global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
18 rows where commissioning_year = "1922.0" and primary_fuel = "Hydro" sorted by generation_gwh_2014 descending
This data as json, CSV (advanced)
Suggested facets: country, source
owner 17
- 100% Statkraft 1
- ALLETE Inc. 1
- Albany Engineering Corporation 1
- Avista Corp 1
- Bayerische Elektrizitätswerke GmbH 1
- CHI Energy Inc 1
- Consumers Energy Co 1
- Great River Hydro LLC 1
- Green Mountain Power Corp 1
- Los Angeles Department of Water & Power 1
- PGE 1
- Pacific Gas & Electric Co. 1
- Rochester Gas & Electric Corp 1
- U S Bureau of Reclamation 1
- Wacker Chemie AG 1
- Wisconsin Electric Power Co 1
- Wisconsin Public Service Corp 1
country_long 5
- United States of America 13
- Germany 2
- Poland 1
- Portugal 1
- Sweden 1
primary_fuel 1
- Hydro · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31465 | 31465 | USA | United States of America | Pit 1 | USA0000265 | 69.2 | 40.9908 | -121.4982 | Hydro | 1922.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29418 | 2019 | 204.369 | 177.903 | 147.084 | 191.861 | 295.265 | 227.077 | 277.402 | U.S. Energy Information Administration | 217.83 | 220.86 | 174.22 | 246.29 | 213.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33688 | 33688 | USA | United States of America | Upper Falls | USA0009096 | 10.0 | 47.6544 | -117.4189 | Hydro | 1922.0 | Avista Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36365 | 2019 | 68.384 | 67.033 | 38.374 | 62.708 | 68.396 | 61.161 | 66.538 | U.S. Energy Information Administration | 47.06 | 47.84 | 45.76 | 48.12 | 46.21 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34060 | 34060 | USA | United States of America | Wausau | USA0004077 | 5.4 | 44.9575 | -89.6367 | Hydro | 1922.0 | Wisconsin Public Service Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37263 | 2019 | 28.133 | 31.598 | 31.25 | 40.38 | 39.739 | 23.066 | 15.87 | U.S. Energy Information Administration | 21.86 | 29.02 | 20.02 | 28.18 | 24.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32057 | 32057 | USA | United States of America | Rogers | USA0001716 | 6.8 | 43.613 | -85.4795 | Hydro | 1922.0 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17537 | 2019 | 26.781 | 25.367 | 20.82 | 17.68 | 17.667 | 22.815 | 17.245 | U.S. Energy Information Administration | 27.06 | 27.56 | 20.5 | 26.55 | 25.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32551 | 32551 | USA | United States of America | Shoshone (WY) | USA0004183 | 3.0 | 44.5029 | -109.1812 | Hydro | 1922.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35667 | 2019 | 19.133 | 19.748 | 18.051 | 17.579 | 19.202 | 19.356 | 20.025 | U.S. Energy Information Administration | 9.98 | 9.86 | 9.26 | 9.8 | 8.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32421 | 32421 | USA | United States of America | Searsburg | USA0006529 | 4.0 | 42.8708 | -72.9273 | Hydro | 1922.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21412 | 2019 | 16.644000000000002 | 16.896 | 12.657 | 13.925 | 19.721 | 23.189 | 19.391 | 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 | |||
31426 | 31426 | USA | United States of America | Pine | USA0004045 | 3.2 | 45.8275 | -88.2483 | Hydro | 1922.0 | Wisconsin Electric Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37203 | 2019 | 11.224 | 15.299 | 13.98 | 16.578 | 22.781 | 8.061 | 1.659 | U.S. Energy Information Administration | 9.97 | 11.45 | 12.31 | 12.03 | 11.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28388 | 28388 | USA | United States of America | Hailesboro 4 Plant | USA0010544 | 1.4 | 44.3117 | -75.445 | Hydro | 1922.0 | CHI Energy Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.296 | 11.669 | 10.024 | 9.951 | 13.203 | 10.248 | 11.754 | U.S. Energy Information Administration | 5.31 | 5.94 | 5.18 | 5.41 | 5.27 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29370 | 29370 | USA | United States of America | Knife Falls | USA0001895 | 2.4000000000000004 | 46.7266 | -92.4486 | Hydro | 1922.0 | ALLETE Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26508 | 2019 | 9.108 | 8.397 | 10.552 | 14.834 | 12.143 | 12.008 | 12.284 | U.S. Energy Information Administration | 9.01 | 10.01 | 7.84 | 10.73 | 8.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26215 | 26215 | USA | United States of America | Carver Falls | USA0006456 | 1.9 | 43.6262 | -73.3073 | Hydro | 1922.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15960 | 2019 | 7.621 | 5.304 | 0.243 | 5.428 | 5.533 | 6.257000000000001 | 7.861 | U.S. Energy Information Administration | 5.46 | 6.21 | 5.42 | 5.36 | 4.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32296 | 32296 | USA | United States of America | San Fernando | USA0000403 | 5.6 | 34.3128 | -118.4928 | Hydro | 1922.0 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25097 | 2019 | 0.648 | -0.028 | 1.24 | 0.682 | 21.678 | 18.086 | 11.281 | U.S. Energy Information Administration | 11.75 | 11.7 | 11.31 | 11.78 | 11.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
12505 | 12505 | DEU | Germany | Alzwerke GmbH | WRI1005576 | 45.0 | 48.1769 | 12.8405 | Hydro | 1922.0 | Wacker Chemie AG | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 204.48 | 156.54 | 173.7 | 156.97 | 156.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
13270 | 13270 | DEU | Germany | Meitingen | WRI1005938 | 11.3 | 48.547 | 10.8651 | Hydro | 1922.0 | Bayerische Elektrizitätswerke GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1021853 | 53.12 | 41.5 | 47.69 | 44.57 | 40.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
18574 | 18574 | POL | Poland | Grajówka | WRI1061536 | 3.0 | 51.6725 | 15.2919 | Hydro | 1922.0 | PGE | PGE Energia Odnawialna | https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Grajowka | University of Dąbrowa Górnicza | 10.98 | 11.98 | 8.54 | 11.67 | 10.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18823 | 18823 | PRT | Portugal | Lindoso | WRI1022576 | 44.1 | 41.8595 | -8.2704 | Hydro | 1922.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012724 | 130.71 | 126.26 | 76.19 | 140.99 | 74.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21173 | 21173 | SWE | Sweden | Skogaby | WRI1002087 | 12.5 | 56.5333 | 13.1833 | Hydro | 1922.0 | 100% Statkraft | Statkraft | http://www.statkraft.com/energy-sources/Power-plants/Sweden/Skogaby/ | CARMA | 1030690 | 57.12 | 63.57 | 54.79 | 57.09 | 62.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
28274 | 28274 | USA | United States of America | Green Island Hydroelectric Station | USA0061207 | 6.0 | 42.7481 | -73.6902 | Hydro | 1922.0 | Albany Engineering Corporation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27816 | 2019 | 35.376 | 41.138 | 39.779 | 40.147 | U.S. Energy Information Administration | 27.91 | 28.63 | 20.7 | 26.39 | 25.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
34403 | 34403 | USA | United States of America | Wiscoy 170 | USA0002646 | 1.0 | 42.5042 | -78.0828 | Hydro | 1922.0 | Rochester Gas & Electric Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31597 | 2019 | 0.0 | U.S. Energy Information Administration | 3.56 | 4.0 | 3.47 | 3.43 | 3.08 | 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");