global-power-plants

Table actions

36 rows where commissioning_year = "1992.0" and primary_fuel = "Hydro"

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: owner

primary_fuel 1

  • Hydro · 36 ✖
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_data_source estimated_generation_gwh
879 879 AUT Austria Oberaudorf Ebbs WRI1005217 60.0 47.6413 12.1989 Hydro       1992.0 Verbund Verbund http://www.verbund.com/pp/de/region/oesterreich WRI                 296.4782134235734
889 889 AUT Austria Retznei WRI1005231 1.0 46.7333 15.5667 Hydro       1992.0 Verbund Verbund http://www.verbund.com/pp/de/region/oesterreich CARMA 1052547               4.941303557059557
1180 1180 BRA Brazil Agro Trafo BRA0000031 14.683 -11.675 -46.6722 Hydro       1992.0   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)   2017             55.92859337623807
1215 1215 BRA Brazil Alto Fêmeas I BRA0027414 10.649 -12.45 -45.2 Hydro       1992.0   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) 1033932 2017             40.56279989535921
2085 2085 BRA Brazil Governador Ney Aminthas de Barros Braga (Segredo) BRA0002715 1260.0 -25.7833 -52.1333 Hydro       1992.0   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) 1012677 2017             4799.42979323435
2373 2373 BRA Brazil Machado Mineiro BRA0001361 1.72 -15.5225 -41.5111 Hydro       1992.0   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) 1011486 2017             6.5516025748913345
3215 3215 BRA Brazil Taquaruçu (Escola Politécnica) BRA0002821 525.0 -22.5419 -52.0 Hydro       1992.0   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)   2017             1999.7624138476456
5677 5677 CHN China Dongjiang WRI1000553 500.0 25.87 113.31 Hydro       1992.0   Chinese National Committee on Large Dams http://www.chincold.org.cn/dams/DamInformation/damsinchina/webinfo/2010/07/1279253973938211.htm   1011840               2054.5015627798957
7449 7449 CHN China Longyangxia WRI1000484 1280.0 36.12 100.92 Hydro       1992.0   Chinese National Committee on Large Dams http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253974093926-1279253974095162.pdf   1026429               5259.524000716532
7465 7465 CHN China Lubuge WRI1000510 450.0 24.82 104.54 Hydro       1992.0   World Bank http://www.worldbank.org/projects/P003425/lubuge-hydroelectric-project?lang=en   1087546               1849.0514065019056
8924 8924 CHN China Yantan WRI1000529 1210.0 24.05 107.51 Hydro       1992.0   China Water https://web.archive.org/web/20140419013705/http://www.chinawater.net.cn/icold2000/st-c4-01.html   1029585               4971.893781927347
13372 13372 DEU Germany Oberaudorf-Ebbs WRI1005986 30.0 47.6413 12.199 Hydro       1992.0 Innwerk AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025000               76.45356116224795
13678 13678 DEU Germany Vohburg WRI1006124 23.3 48.7781 11.6012 Hydro       1992.0 Donau-Wasserkraft AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1027437               59.378932502679255
14497 14497 IND India GHAT PRABHA IND0000128 32.0 16.1424 74.6447 Hydro       1992.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1020549 2018 81.7492 65.7098 31.7803 48.49630000000001 48.12815 Central Electricity Authority  
14683 14683 IND India KHARA IND0000195 72.0 30.3508 77.6017 Hydro       1992.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1032590 2018 416.5269 362.1004 319.4547 267.58535 257.8443 Central Electricity Authority  
15057 15057 IND India N_SAGAR LBC IND0000284 60.0 16.5697 79.3389 Hydro       1992.0   Central Electricity Authority http://www.cea.nic.in/ WRI   2018 97.73885 41.85965 0.0 0.0 12.735999999999999 Central Electricity Authority  
15244 15244 IND India RMC MANGROL IND0000378 6.0 25.1732 75.832 Hydro       1992.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1053462 2018             3.6084612783576606
15455 15455 IND India TANAKPUR IND0000442 94.2 29.0057 80.0946 Hydro       1992.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1023414 2018 382.2591 444.47645 450.0982 428.13855 457.4413 Central Electricity Authority  
17625 17625 MMR Myanmar Baluchaung BHP (1) WRI1061350 28.0 19.57 97.316 Hydro       1992.0 Myanmar Electric Power Enterprise (MEPE) Open Development Myanmar https://opendevelopmentmyanmar.net/dataset/?id=myanmar-power-stations&search_query=P3R5cGU9ZGF0YXNldCZ0YXhvbm9teT1hbGwmc29ydGluZz1zY29yZSZxdWVyeT1wb3dlcg== WRI 1083646       200.0     Open Development Myanmar 90.71334214002644
17762 17762 NZL New Zealand Clyde WRI1000328 432.0 -45.1793 169.307 Hydro       1992.0 Contact Energy Contact Energy https://contact.co.nz/corporate/about/our-company/powerstations GEODB 1015215               2395.886964448496
18734 18734 PRT Portugal Cercosa WRI1022695 4.2 40.6703 -8.2469 Hydro       1992.0   Energias Endogenas de Portugal http://e2p.inegi.up.pt/index.asp Energias Endogenas de Portugal 1017608               24.970711297071148
18812 18812 PRT Portugal Inverno da Calheta WRI1022724 7.3 32.7215 -17.1789 Hydro       1992.0   Energias Endogenas de Portugal http://e2p.inegi.up.pt/index.asp Energias Endogenas de Portugal 1060201               43.401474397290315
19031 19031 PRT Portugal Talhadas WRI1022801 5.2 40.647 -8.3177 Hydro       1992.0   Energias Endogenas de Portugal http://e2p.inegi.up.pt/index.asp Energias Endogenas de Portugal 1017614               30.916118748754755
19048 19048 PRT Portugal Terragido WRI1022805 8.5 41.2872 -7.7495 Hydro       1992.0   Energias Endogenas de Portugal http://e2p.inegi.up.pt/index.asp Energias Endogenas de Portugal 1016496               50.535963339310655
20409 20409 ESP Spain LA SERENA WRI1006595 22.0 38.732 -5.5439 Hydro       1992.0 ENDESA GENERACION S.A. Red Eléctrica de España http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 CARMA 1027884               60.36986970417778
20868 20868 ESP Spain SANTA MARINA GR 3 WRI1023649 34.68 42.5103 -5.873 Hydro       1992.0 ENDESA GENERACION S.A. Red Eléctrica de España http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 WRI 1015727               95.16486733367664
21069 21069 SWE Sweden Fors WRI1002048 3.0 58.753 17.0079 Hydro       1992.0 100% Statkraft Statkraft http://www.statkraft.com/energy-sources/Power-plants/Sweden/fors/ CARMA 1068710               14.943265563951993
21269 21269 CHE Switzerland Ilanz 2 WRI1004243 49.5 46.7741 9.2046 Hydro       1992.0   Swiss Federal Office of Energy http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en CARMA 1021337               203.27266803202386
21423 21423 TWN Taiwan Shuili WRI1000412 13.0 23.8117 120.8539 Hydro       1992.0   Bureau of Ministry Energy and Economic Affairs http://web3.moeaboe.gov.tw/ECW/english/content/ContentLink.aspx?menu_id=1548 CARMA 1030832               25.27957129786956
25344 25344 USA United States of America Blind Canyon Hydro USA0054514 1.3 42.6998 -114.8226 Hydro       1992.0 Blind Canyon Aqua Ranch Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 14642 2017 2.798 3.366 3.972 3.347 4.312 U.S. Energy Information Administration  
25570 25570 USA United States of America Buffalo Bill USA0007317 18.0 44.5082 -109.1707 Hydro       1992.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35622 2017 58.247 97.067 58.193999999999996 53.641000000000005 119.56 U.S. Energy Information Administration  
27231 27231 USA United States of America Forks of Butte Hydro Project USA0050350 14.5 39.8693 -121.6319 Hydro       1992.0 HYPOWER INC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 21639 2017 25.613000000000003 21.596999999999998 16.322 51.348 61.153999999999996 U.S. Energy Information Administration  
27887 27887 USA United States of America Hastings City Hydroelectric USA0054285 4.4 44.7602 -92.8677 Hydro       1992.0 Hastings Lock & Dam U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 18.717 18.178 27.684 18.422 17.897000000000006 U.S. Energy Information Administration  
28860 28860 USA United States of America Lee Creek Water Treatment Facility USA0054283 1.3 35.4845 -94.3929 Hydro       1992.0 Fort Smith City of U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 20443 2017 -4.3069999999999995 0.003 0.0 0.0 0.0 U.S. Energy Information Administration  
28890 28890 USA United States of America Lewisville USA0000794 2.8 33.0685 -96.9638 Hydro       1992.0 City of Garland - (TX) U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18286 2017 0.0 0.0 0.746 3.403 8.186 U.S. Energy Information Administration  
29666 29666 USA United States of America Mt Ida Hydroelectric USA0050031 3.0 42.7213 -73.6806 Hydro       1992.0 Ampersand Mount Ida Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017   9.0 7.407 7.242999999999999 8.743 U.S. Energy Information Administration  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");