global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
21 rows where capacity_mw = "1000.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2017
country_long 13
- China 5
- India 3
- Japan 2
- Taiwan 2
- Colombia 1
- Italy 1
- Pakistan 1
- Russia 1
- South Africa 1
- South Korea 1
- Switzerland 1
- Thailand 1
- United States of America 1
owner 9
primary_fuel 1
- Hydro · 21 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7934 | 7934 | CHN | China | Sanbanxi Dam | WRI1070894 | 1000.0 | 26.6078 | 109.0475 | Hydro | 2006.0 | CPI Wuling Electric Power Co Ltd | Industry About | https://industryabout.com/country-territories-3/1142-china/hydro-energy/15573-sanbanxi-dam | Industry About | 1017900 | 2693.11 | 3401.1 | 3397.72 | 3888.74 | 3420.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
8391 | 8391 | CHN | China | Tai'in | WRI1000555 | 1000.0 | 36.23 | 117.05 | Hydro | 2007.0 | HydroChina Corporation | http://jyll.ifund.jrj.com.cn/forumjyll/topic43765.html | 1028546 | 2135.36 | 3031.6 | 3031.6 | 3692.67 | 3031.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8715 | 8715 | CHN | China | Xiangshuijian | WRI1000563 | 1000.0 | 31.11 | 118.29 | Hydro | 2012.0 | Polaris Power Network News | http://news.bjx.com.cn/html/20121118/402339.shtml | 1010209 | 2204.21 | 3100.46 | 3100.46 | 3761.71 | 3100.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8975 | 8975 | CHN | China | Yixing | WRI1000539 | 1000.0 | 31.32 | 119.77 | Hydro | 2008.0 | Water Power Magazine | http://www.waterpowermagazine.com/features/featuremixing-up-yixing/ | 1043462 | 3169.48 | 2833.73 | 3316.19 | 3816.28 | 3090.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
9184 | 9184 | CHN | China | Zhanghewan | WRI1000534 | 1000.0 | 37.77 | 114.06 | Hydro | 2009.0 | Asian Development Bank | http://www.adb.org/sites/default/files/projdocs/2002/hebei_zhanghewan.pdf | 1024369 | 1481.38 | 2408.17 | 2460.23 | 3716.65 | 1962.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
9315 | 9315 | COL | Colombia | Chivor | WRI1018566 | 1000.0 | 4.9008 | -73.2969 | Hydro | AES Chivor | ProColombia | http://www.cc.lu/fileadmin/user_upload/cc.lu/Manifestations/20150701_Mexico_Colombia_Mission/01___Electric_Power_Generation_in_Colombia_-_2015.pdf | GEODB | 1012225 | 3903.61 | 4598.14 | 3762.09 | 3618.34 | 3030.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
14605 | 14605 | IND | India | INDIRA SAGAR | IND0000151 | 1000.0 | 22.2791 | 76.4728 | Hydro | 2004.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1023360 | 2019 | 2529.1905 | 1964.33895 | 3304.18605 | 877.3512 | 1302.24605 | Central Electricity Authority | 5134.22 | 3359.46 | 3573.28 | 3072.3 | 3407.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14669 | 14669 | IND | India | KARCHAM WANGTOO | IND0000182 | 1000.0 | 31.5156 | 78.1073 | Hydro | 2011.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1048188 | 2019 | 4219.22785 | 4702.6884 | 4350.42855 | 4547.08035 | 3948.84655 | Central Electricity Authority | 4119.71 | 3626.49 | 3916.45 | 3432.23 | 4184.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15466 | 15466 | IND | India | TEHRI ST -1 | IND0000451 | 1000.0 | 30.3787 | 78.4795 | Hydro | 2006.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1031157 | 2019 | 3008.4322500000003 | 3085.495 | 3130.5884 | 3065.5353000000005 | 3156.2196000000004 | Central Electricity Authority | 4539.17 | 3471.32 | 4273.56 | 3668.43 | 3708.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
16358 | 16358 | ITA | Italy | RONCOVALGRANDE | WRI1002936 | 1000.0 | 46.0702 | 8.7339 | Hydro | TERNA | http://www.terna.it/en-gb/sistemaelettrico/transparencyreport/generation/installedgenerationcapacity.aspx | GEODB | 1016134 | 508.595 | 865.161 | 844.912 | JRC-PPDB-OPEN | 2669.59 | 3245.29 | 3061.82 | 3841.77 | 1946.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
16780 | 16780 | JPN | Japan | Okukiyotsu | WRI1000725 | 1000.0 | 36.8459 | 138.7662 | Hydro | EPDC | Japanese Electric Power Information Center | https://www.jepic.or.jp/en/ | WRI | 1014508 | 2900.91 | 2422.79 | 3356.29 | 2836.7 | 2422.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
16849 | 16849 | JPN | Japan | Shimogo | WRI1000724 | 1000.0 | 37.3448 | 139.9087 | Hydro | EPDC | Japanese Electric Power Information Center | https://www.jepic.or.jp/en/ | GEODB | 1014524 | 2900.91 | 2422.79 | 3356.29 | 2836.7 | 2422.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18217 | 18217 | PAK | Pakistan | Mangla | WRI1001659 | 1000.0 | 33.1373 | 73.6416 | Hydro | Water and Power Development Authority (WAPDA) | Islamabad Chamber of Commerce and Industry | http://icci.com.pk/data/downloads/63/1293619048_1.pdf | GEODB | 1033211 | 4575.09 | 4575.09 | 4763.18 | 4798.38 | 4633.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19265 | 19265 | RUS | Russia | Chirkey HPP | WRI1061672 | 1000.0 | 42.9772 | 46.8708 | Hydro | PJSC "RusHydro" | EnergyBase (RUS) | https://energybase.ru/power-plant/Chirkei_HPP | EnergyBase (RUS) | 3472.51 | 2653.05 | 3157.13 | 4126.11 | 2642.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
19922 | 19922 | ZAF | South Africa | Drakensberg | WRI1000120 | 1000.0 | -28.5651 | 29.0842 | Hydro | 1981.0 | Eskom | Eskom | http://www.eskom.co.za/OurCompany/PhotoGallery/Pages/Eskom_Power_Stations.aspx | WRI | 1016650 | 2667.78 | 2570.24 | 1630.79 | 2622.54 | 1626.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20119 | 20119 | KOR | South Korea | Yangyang | WRI1029856 | 1000.0 | 38.0163 | 128.5467 | Hydro | Korea Electric Power Company | KEPCO | https://home.kepco.co.kr/kepco/EN/C/htmlView/ENCBHP003.do?menuCd=EN030204 | GEODB | 1021191 | 2828.95 | 2136.9 | 1994.31 | 2142.75 | 2136.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21294 | 21294 | CHE | Switzerland | Limmern | WRI1004315 | 1000.0 | 46.8489 | 9.0118 | Hydro | 2016.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | GEODB | 1021340 | 2453.38 | 3178.76 | 3031.52 | 2958.86 | 3976.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21399 | 21399 | TWN | Taiwan | Daguan Erchang | WRI1000441 | 1000.0 | 23.8542 | 120.8701 | Hydro | 1985.0 | Bureau of Ministry Energy and Economic Affairs | http://web3.moeaboe.gov.tw/ECW/english/content/ContentLink.aspx?menu_id=1577 | WRI | 3056.04 | 4194.21 | 4191.91 | 3112.93 | 3188.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21417 | 21417 | TWN | Taiwan | Ming-Hu | WRI1000382 | 1000.0 | 23.8544 | 120.8705 | Hydro | Bureau of Ministry Energy and Economic Affairs | https://web3.moeaboe.gov.tw/ECW/english/content/SubMenu.aspx?menu_id=1537 | WRI | 3056.04 | 4194.21 | 4191.91 | 3112.93 | 3188.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
21532 | 21532 | THA | Thailand | Lam Ta Khong | WRI1000170 | 1000.0 | 14.8073 | 101.5453 | Hydro | 2002.0 | Electric Generating Authority of Thailand | EGAT | http://www.egat.co.th/en/index.php?option=com_content&view=article&id=92&Itemid=127 | GEODB | 1014257 | 4024.18 | 4024.18 | 1863.7 | 1877.46 | 1872.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
25630 | 25630 | USA | United States of America | Blenheim Gilboa | USA0002691 | 1000.0 | 42.4423 | -74.4479 | Hydro | 1973.0 | New York Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27567 | 2019 | -121.264 | -176.02 | -177.465 | -186.162 | -163.034 | -200.581 | -120.509 | U.S. Energy Information Administration | 2252.62 | 2217.39 | 1854.44 | 2140.82 | 1941.04 | 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");