global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
19 rows where commissioning_year = "1927.0", primary_fuel = "Hydro" and source = "U.S. Energy Information Administration"
This data as json, CSV (advanced)
owner 15
- Guadalupe Blanco River Authority 3
- Central Rivers Power NH LLC 2
- Erie Boulevard Hydropower LP 2
- Cube Hydro Carolinas Yadkin 1
- Georgia Power Co 1
- Great River Hydro LLC 1
- Green Mountain Power Corp 1
- Los Angeles Department of Water & Power 1
- NorthWestern Energy 1
- Northern States Power Co - Minnesota 1
- PE Hydro Generation LLC 1
- PacifiCorp 1
- Pacific Gas & Electric Co. 1
- U S Bureau of Reclamation 1
- Wisconsin Electric Power Co 1
primary_fuel 1
- Hydro · 19 ✖
country_long 1
Link | rowid ▼ | country | country_long | name | gppd_idnr | capacity_mw | latitude | longitude | primary_fuel | other_fuel1 | other_fuel2 | other_fuel3 | commissioning_year | owner | source | url | geolocation_source | wepp_id | year_of_capacity_data | generation_gwh_2013 | generation_gwh_2014 | generation_gwh_2015 | generation_gwh_2016 | generation_gwh_2017 | generation_gwh_2018 | generation_gwh_2019 | generation_data_source | estimated_generation_gwh_2013 | estimated_generation_gwh_2014 | estimated_generation_gwh_2015 | estimated_generation_gwh_2016 | estimated_generation_gwh_2017 | estimated_generation_note_2013 | estimated_generation_note_2014 | estimated_generation_note_2015 | estimated_generation_note_2016 | estimated_generation_note_2017 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24823 | 24823 | USA | United States of America | Abbott TP 3 | USA0003581 | 2.8 | 29.594 | -98.0407 | Hydro | 1927.0 | Guadalupe Blanco River Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21548 | 2019 | 3.99 | 2.767 | 10.238 | 13.634 | 11.599 | 9.227 | 12.367 | U.S. Energy Information Administration | 9.0 | 8.68 | 6.77 | 8.9 | 7.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
24938 | 24938 | USA | United States of America | Allens Falls | USA0002540 | 4.0 | 44.6603 | -74.8603 | Hydro | 1927.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27780 | 2019 | 9.119 | 24.76 | 21.838 | 20.175 | 17.329 | 13.679 | 27.274 | U.S. Energy Information Administration | 8.97 | 8.97 | 8.78 | 9.0 | 7.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25309 | 25309 | USA | United States of America | Balch 1 | USA0000217 | 31.0 | 36.9091 | -119.0877 | Hydro | 1927.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29355 | 2019 | 53.98 | 44.325 | 19.306 | 132.644 | 177.233 | 82.44 | 163.231 | U.S. Energy Information Administration | 76.22 | 75.82 | 62.61 | 86.87 | 81.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25604 | 25604 | USA | United States of America | Black Eagle | USA0002181 | 24.0 | 47.5213 | -111.2614 | Hydro | 1927.0 | NorthWestern Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26726 | 2019 | 109.985 | 120.985 | 127.279 | 118.288 | 126.346 | 138.717 | 142.208 | U.S. Energy Information Administration | 102.45 | 95.45 | 70.17 | 127.56 | 88.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25931 | 25931 | USA | United States of America | Burton Dam | USA0000704 | 6.0 | 34.7939 | -83.5406 | Hydro | 1927.0 | Georgia Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 31.28 | 17.313 | 19.305 | 16.586000000000002 | 17.711000000000002 | 30.793 | 31.133 | U.S. Energy Information Administration | 20.49 | 20.26 | 17.58 | 20.46 | 17.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26136 | 26136 | USA | United States of America | Canaan | USA0003750 | 1.1 | 44.9993 | -71.5302 | Hydro | 1927.0 | Central Rivers Power NH LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30817 | 2019 | 6.0 | 7.081 | 7.179 | 5.365 | 7.465 | 3.722 | 6.106 | U.S. Energy Information Administration | 4.29 | 4.71 | 3.84 | 4.6 | 4.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26863 | 26863 | USA | United States of America | Cutler Hydro | USA0003646 | 30.0 | 41.8347 | -112.0521 | Hydro | 1927.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29499 | 2019 | 31.877 | 40.61 | 35.726 | 64.221 | 147.609 | 69.76 | 90.186 | U.S. Energy Information Administration | 95.38 | 93.14 | 69.88 | 102.39 | 89.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27221 | 27221 | USA | United States of America | Dunlap TP 1 | USA0003582 | 3.6 | 29.6402 | -98.0459 | Hydro | 1927.0 | Guadalupe Blanco River Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21549 | 2019 | 5.674 | 3.145 | 15.303 | 17.322 | 16.179000000000002 | 12.304 | 5.974 | U.S. Energy Information Administration | 10.12 | 9.65 | 7.89 | 10.11 | 8.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28390 | 28390 | USA | United States of America | Haiwee | USA0000398 | 5.6 | 36.1097 | -117.9567 | Hydro | 1927.0 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25092 | 2019 | 3.343 | 3.536 | -0.083 | 6.7700000000000005 | 16.496 | 0.512 | -0.104 | U.S. Energy Information Administration | 11.67 | 11.67 | 8.94 | 12.91 | 11.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28615 | 28615 | USA | United States of America | High Rock Hydro | USA0054896 | 33.0 | 35.6008 | -80.2339 | Hydro | 1927.0 | Cube Hydro Carolinas Yadkin | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37456 | 2019 | 177.705 | 125.216 | 110.38 | 123.068 | 101.115 | 152.635 | 133.737 | U.S. Energy Information Administration | 118.78 | 117.17 | 78.65 | 118.32 | 92.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28700 | 28700 | USA | United States of America | Hooksett | USA0002359 | 1.6 | 43.1017 | -71.4657 | Hydro | 1927.0 | Central Rivers Power NH LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30822 | 2019 | 9.36 | 7.884 | 7.157 | 4.638 | 7.773000000000001 | 7.058 | 7.556 | U.S. Energy Information Administration | 6.54 | 6.5 | 5.59 | 6.52 | 5.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29808 | 29808 | USA | United States of America | Luray Hydro Station | USA0003789 | 1.6 | 38.6767 | -78.4989 | Hydro | 1927.0 | PE Hydro Generation LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30485 | 2019 | 5.611 | 1.183 | 5.9830000000000005 | 6.019 | 3.894 | 5.629 | 5.926 | U.S. Energy Information Administration | 5.04 | 5.42 | 5.73 | 6.4 | 5.61 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30011 | 30011 | USA | United States of America | Marshfield 6 | USA0003739 | 5.0 | 44.3606 | -72.3356 | Hydro | 1927.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21410 | 2019 | 10.789 | 5.4270000000000005 | 4.876 | 7.37 | 11.248 | 8.879 | 11.334 | U.S. Energy Information Administration | 16.34 | 17.38 | 12.9 | 13.94 | 13.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30750 | 30750 | USA | United States of America | Nolte | USA0003585 | 2.4 | 29.5376 | -97.9321 | Hydro | 1927.0 | Guadalupe Blanco River Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21552 | 2019 | 3.048 | 2.047 | 7.3 | 9.804 | 8.476 | 6.386 | 9.344 | U.S. Energy Information Administration | 7.71 | 7.44 | 5.8 | 7.63 | 6.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31415 | 31415 | USA | United States of America | Pilot Butte | USA0000674 | 1.6 | 43.219 | -108.7877 | Hydro | 1927.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35664 | 2019 | 4.63 | 4.85 | 4.39 | 4.71 | 4.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
32526 | 32526 | USA | United States of America | Sherman | USA0006012 | 7.2 | 42.7297 | -72.9303 | Hydro | 1927.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27447 | 2019 | 24.085 | 29.238 | 22.397 | 21.901 | 32.692 | 35.228 | 30.308 | U.S. Energy Information Administration | 24.01 | 24.13 | 19.22 | 20.76 | 20.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33471 | 33471 | USA | United States of America | Trego | USA0004012 | 1.2 | 45.9479 | -91.8884 | Hydro | 1927.0 | Northern States Power Co - Minnesota | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28294 | 2019 | 7.105 | 8.843 | 8.484 | 9.868 | 9.939 | 9.353 | 9.802 | U.S. Energy Information Administration | 4.56 | 4.86 | 4.33 | 4.67 | 4.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33695 | 33695 | USA | United States of America | Upper Newton Falls | USA0058679 | 1.5 | 44.2144 | -74.9914 | Hydro | 1927.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 52110 | 2019 | 7.693 | 5.4510000000000005 | 4.447 | 5.3500000000000005 | 9.7 | 7.339 | 8.096 | U.S. Energy Information Administration | 5.92 | 5.62 | 5.8 | 5.62 | 4.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34263 | 34263 | USA | United States of America | White Rapids | USA0001786 | 9.0 | 45.4821 | -87.8022 | Hydro | 1927.0 | Wisconsin Electric Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37213 | 2019 | 31.325 | 36.848 | 37.77 | 40.46 | 48.395 | 39.099 | 38.412 | U.S. Energy Information Administration | 34.91 | 38.7 | 35.27 | 38.88 | 43.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "global-power-plants" ( "country" TEXT, "country_long" TEXT, "name" TEXT, "gppd_idnr" TEXT, "capacity_mw" REAL, "latitude" REAL, "longitude" REAL, "primary_fuel" TEXT, "other_fuel1" TEXT, "other_fuel2" TEXT, "other_fuel3" TEXT, "commissioning_year" REAL, "owner" TEXT, "source" TEXT, "url" TEXT, "geolocation_source" TEXT, "wepp_id" TEXT, "year_of_capacity_data" INTEGER, "generation_gwh_2013" REAL, "generation_gwh_2014" REAL, "generation_gwh_2015" REAL, "generation_gwh_2016" REAL, "generation_gwh_2017" REAL, "generation_gwh_2018" REAL, "generation_gwh_2019" REAL, "generation_data_source" TEXT, "estimated_generation_gwh_2013" REAL, "estimated_generation_gwh_2014" REAL, "estimated_generation_gwh_2015" REAL, "estimated_generation_gwh_2016" REAL, "estimated_generation_gwh_2017" REAL, "estimated_generation_note_2013" TEXT, "estimated_generation_note_2014" TEXT, "estimated_generation_note_2015" TEXT, "estimated_generation_note_2016" TEXT, "estimated_generation_note_2017" TEXT ); CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long"); CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");