global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
26 rows where commissioning_year = "1927.0"
This data as json, CSV (advanced)
Suggested facets: country, source, geolocation_source, estimated_generation_gwh_2015, estimated_generation_gwh_2017
owner 18
- Guadalupe Blanco River Authority 3
- Central Rivers Power NH LLC 2
- Erie Boulevard Hydropower LP 2
- Cube Hydro Carolinas Yadkin 1
- EDF 1
- EnBW Energie Baden-Württemberg AG 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
- Rhein-Main-Donau AG 1
- U S Bureau of Reclamation 1
- Wisconsin Electric Power Co 1
country_long 6
- United States of America 19
- Germany 2
- Switzerland 2
- France 1
- Guatemala 1
- India 1
primary_fuel 1
- Hydro 26
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12311 | 12311 | FRA | France | Val Beynette | WRI1026694 | 30.0 | 45.416 | 2.372 | Hydro | 1927.0 | EDF | EDF | https://www.edf.fr/en/the-edf-group/industrial-provider/renewable-energies/hydropower | GEODB | 1015114 | 72.28 | 86.6 | 98.16 | 91.86 | 94.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
12695 | 12695 | DEU | Germany | Dettingen | WRI1005629 | 11.0 | 48.5275 | 9.3488 | Hydro | 1927.0 | EnBW Energie Baden-Württemberg AG | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1016426 | 39.71 | 24.38 | 28.02 | 24.45 | 24.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
13109 | 13109 | DEU | Germany | Kachlet | WRI1005853 | 53.7 | 48.5797 | 13.4083 | Hydro | 1927.0 | Rhein-Main-Donau AG | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1027423 | 235.45 | 224.79 | 219.45 | 165.38 | 180.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
13948 | 13948 | GTM | Guatemala | Santa Maria | WRI1061409 | 6.0 | 14.72 | -91.523 | Hydro | 1927.0 | Guatemala Energy Data Visualization Center at Universidad Rafael Landivar | http://incyt.org/indicadores/#1495159742418-0490dafa-25d5 | Guatemala Energy Data Visualization Center at Universidad Rafael Landivar | 1051782 | 0.0 | Guatemala Energy Data Visualization Center at Universidad Rafael Landivar | 20.86 | 20.86 | 18.82 | 20.21 | 23.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
15343 | 15343 | IND | India | SIVASAMUNDRUM | IND0000418 | 42.0 | 12.3082 | 77.165 | Hydro | 1927.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1020542 | 2019 | 220.82035 | 215.3777 | 144.4143 | 175.92595 | 282.76905 | Central Electricity Authority | 173.96 | 165.37 | 172.14 | 112.6 | 147.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
21285 | 21285 | CHE | Switzerland | La Peuffeyre | WRI1004290 | 24.0 | 46.2521 | 7.0114 | Hydro | 1927.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1012914 | 78.67 | 108.84 | 86.03 | 81.37 | 86.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21365 | 21365 | CHE | Switzerland | Vernayaz (CFF) | WRI1004615 | 92.0 | 46.1367 | 7.0391 | Hydro | 1927.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1028278 | 283.69 | 384.27 | 302.99 | 285.05 | 303.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
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");