global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
24 rows where capacity_mw = "2.6" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: country, estimated_generation_gwh_2017
owner 15
- Enel Green Power NA Inc. 2
- Algonquin Power 1
- Birch Power Co 1
- Ca Du Hydro Power Constructing JSC. 1
- City of Holyoke Gas and Electric Dept. 1
- Consumers Energy Co 1
- Farmer's Irrigation District 1
- Korea Water Resources Corporation 1
- New York State Elec & Gas Corp 1
- Northern Colorado Water Conservancy District 1
- Rochester Public Utilities 1
- Southern California Edison Co 1
- Truckee Meadows Water Authority 1
- Union Falls Hydro Power LP 1
- Wisconsin Public Service Corp 1
country_long 8
- United States of America 13
- Canada 4
- Mexico 2
- Brazil 1
- Portugal 1
- South Korea 1
- Switzerland 1
- Vietnam 1
primary_fuel 1
- Hydro · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1686 | 1686 | BRA | Brazil | Chibarro | BRA0000768 | 2.6 | -21.8881 | -48.1472 | Hydro | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 1012679 | 2017 | 5.21 | 9.45 | 9.55 | 9.58 | 8.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3863 | 3863 | CAN | Canada | Dickie Brook | CAN0007808 | 2.6 | 45.3492 | -61.5032 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28484 | 2000 | 8.22 | 8.15 | 8.46 | 8.17 | 8.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3914 | 3914 | CAN | Canada | Fenelon Falls | CAN0007853 | 2.6 | 44.5356 | -78.7373 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 55361 | 2000 | 11.86 | 11.49 | 10.72 | 11.49 | 11.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4437 | 4437 | CAN | Canada | Rivière-du-Loup | CAN0008296 | 2.6 | 47.8305 | -69.53 | Hydro | Algonquin Power | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 8.17 | 8.09 | 8.05 | 8.64 | 9.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4642 | 4642 | CAN | Canada | Topsail | CAN0008479 | 2.6 | 47.5395 | -52.9191 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 27729 | 2014 | 9.08 | 9.3 | 9.36 | 9.32 | 8.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17380 | 17380 | MEX | Mexico | Hidroelectricas Virita | MEX0006631 | 2.6 | 18.8327 | -97.1004 | Hydro | INERE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 2016 | 8.25 | 6.8 | 7.0 | 7.02 | 7.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17518 | 17518 | MEX | Mexico | San Pedro Porúas | MEX0006560 | 2.6 | 19.4026 | -101.3199 | Hydro | CFE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 1013144 | 2016 | 8.48 | 6.82 | 7.24 | 7.26 | 7.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18891 | 18891 | PRT | Portugal | Palhal | WRI1022751 | 2.6 | 40.7428 | -8.4608 | Hydro | 1991.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1016494 | 10.26 | 10.26 | 6.73 | 11.64 | 6.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20009 | 20009 | KOR | South Korea | Baekje | WRI1029865 | 2.6 | 36.3174 | 126.9401 | Hydro | Korea Water Resources Corporation | CDM | https://cdm.unfccc.int/Projects/DB/Korean%20Standards%20Association1346907381.12/view | WRI | 8.97 | 7.24 | 7.68 | 7.34 | 7.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21289 | 21289 | CHE | Switzerland | Le Chalet | WRI1004302 | 2.6 | 46.2364 | 7.0269 | Hydro | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1043268 | 9.81 | 12.56 | 10.55 | 10.1 | 10.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
24926 | 24926 | USA | United States of America | Allegan Dam | USA0001694 | 2.6 | 42.5638 | -85.954 | Hydro | 1939.615384615385 | Consumers Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17507 | 2019 | 14.281 | 13.444 | 13.521 | 14.91 | 14.073 | 14.093 | 13.951 | U.S. Energy Information Administration | 10.18 | 9.4 | 8.34 | 10.22 | 9.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25574 | 25574 | USA | United States of America | Birch Creek Power | USA0010140 | 2.6 | 44.0274 | -112.7194 | Hydro | 1986.0 | Birch Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23578 | 2019 | 12.243 | 13.21 | 12.275 | 11.317 | 9.31 | 12.803 | 13.011 | U.S. Energy Information Administration | 7.07 | 7.11 | 7.41 | 7.13 | 6.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26065 | 26065 | USA | United States of America | Cabot Holyoke | USA0009864 | 2.6 | 42.2 | -72.61 | Hydro | 1917.1538461538464 | City of Holyoke Gas and Electric Dept. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22278 | 2019 | 10.311 | 8.863 | 9.186 | 4.915 | 4.1450000000000005 | 2.51 | 5.228 | U.S. Energy Information Administration | 10.23 | 11.89 | 8.64 | 10.56 | 10.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26208 | 26208 | USA | United States of America | Carter Hydro | USA0058622 | 2.6 | 40.3242 | -105.2089 | Hydro | 2012.0 | Northern Colorado Water Conservancy District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 7.007000000000001 | 6.276 | 6.481 | 8.275 | 8.811 | 7.806 | 8.601 | U.S. Energy Information Administration | 8.15 | 8.02 | 8.09 | 7.55 | 7.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
26667 | 26667 | USA | United States of America | Copper Dam Plant | USA0010323 | 2.6 | 45.6652 | -121.5238 | Hydro | 2015.0 | Farmer's Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 14.246 | 14.355 | 12.373 | 15.439 | 16.85 | 16.197 | 13.331 | U.S. Energy Information Administration | 9.96 | 10.29 | 9.38 | 10.57 | 9.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27370 | 27370 | USA | United States of America | El Dorado Hydro Elk Creek | USA0050891 | 2.6 | 45.2178 | -116.3158 | Hydro | 1986.0 | Enel Green Power NA Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32750 | 2019 | 3.973 | 4.2 | 4.317 | 2.1590000000000003 | 4.603 | 3.343 | 4.518 | U.S. Energy Information Administration | 9.9 | 9.18 | 9.57 | 9.4 | 9.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29794 | 29794 | USA | United States of America | Lower Tule River | USA0000365 | 2.6 | 36.1357 | -118.7889 | Hydro | 1909.0 | Southern California Edison Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 6.067 | 6.6930000000000005 | 5.9190000000000005 | 10.54 | 5.623 | -0.102 | -0.117 | U.S. Energy Information Administration | 7.64 | 7.66 | 7.65 | 7.99 | 8.03 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30382 | 30382 | USA | United States of America | Montgomery Creek Hydro | USA0055009 | 2.6 | 40.8468 | -121.9564 | Hydro | 1987.0 | Enel Green Power NA Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32759 | 2019 | 4.945 | 4.312 | 1.804 | 11.134 | 10.406 | 6.352 | 9.971 | U.S. Energy Information Administration | 9.12 | 9.49 | 7.61 | 10.93 | 8.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31786 | 31786 | USA | United States of America | Rainbow Falls Auscble | USA0006526 | 2.6 | 44.5236 | -73.4617 | Hydro | 1926.5 | New York State Elec & Gas Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27601 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.113 | U.S. Energy Information Administration | 8.88 | 10.02 | 9.34 | 9.86 | 8.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32010 | 32010 | USA | United States of America | Rochester Hydro | USA0002007 | 2.6 | 44.213 | -92.4802 | Hydro | 1984.0 | Rochester Public Utilities | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 11.86 | 11.687 | 12.706 | 16.097 | 11.836 | 17.566 | 10.618 | U.S. Energy Information Administration | 9.14 | 10.04 | 8.87 | 10.29 | 8.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33427 | 33427 | USA | United States of America | Tomahawk | USA0004075 | 2.6 | 45.4411 | -89.7306 | Hydro | 1938.0 | Wisconsin Public Service Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37260 | 2019 | 11.563 | 14.255 | 12.355 | 15.505 | 15.465 | 15.478 | 10.425 | U.S. Energy Information Administration | 10.54 | 12.75 | 10.44 | 14.16 | 12.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33641 | 33641 | USA | United States of America | Union Falls | USA0050176 | 2.6 | 44.5107 | -73.9131 | Hydro | 1987.0 | Union Falls Hydro Power LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27870 | 2019 | 13.84119 | 13.295700000000002 | 11.827 | 8.993 | 8.53 | 8.053 | 9.756 | U.S. Energy Information Administration | 9.78 | 11.03 | 8.84 | 8.9 | 9.43 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34005 | 34005 | USA | United States of America | Washoe | USA0006532 | 2.6 | 39.3022 | -119.5604 | Hydro | 1904.0 | Truckee Meadows Water Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32677 | 2019 | 12.658 | 7.536 | 2.612 | 8.279 | 9.437 | 12.15 | 13.446 | U.S. Energy Information Administration | 9.09 | 9.29 | 8.92 | 9.58 | 8.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34696 | 34696 | VNM | Vietnam | Ca Du | WRI1030946 | 2.6 | 15.2714 | 108.5186 | Hydro | 2005.0 | Ca Du Hydro Power Constructing JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ca-du-hydropower | Open Development Vietnam | 10.0 | Open Development Vietnam | 9.13 | 8.25 | 7.77 | 8.84 | 5.88 | 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");