global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
23 rows where capacity_mw = "600.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: url, year_of_capacity_data, generation_data_source, estimated_generation_gwh_2014
country_long 12
- China 9
- South Korea 3
- India 2
- Albania 1
- Japan 1
- Malaysia 1
- Mexico 1
- Myanmar 1
- Nigeria 1
- Russia 1
- Tajikistan 1
- United States of America 1
owner 8
primary_fuel 1
- Hydro · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | ALB | Albania | Koman | WRI1002171 | 600.0 | 42.1033 | 19.8224 | Hydro | 1985.0 | Energy Charter Secretariat | http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf | GEODB | 1021233 | 2072.13 | 1618.73 | 1805.63 | 2434.84 | 1982.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
5471 | 5471 | CHN | China | Dahua | WRI1000579 | 600.0 | 23.85 | 108.13 | Hydro | 1986.0 | Baike | http://baike.baidu.com/view/1114944.htm | 1029568 | 1471.34 | 1704.95 | 2604.86 | 1933.58 | 2037.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6413 | 6413 | CHN | China | Hongjiadu | WRI1000503 | 600.0 | 26.87 | 105.86 | Hydro | 2005.0 | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253974061075-1279253974063421.pdf | 1033517 | 1416.45 | 2034.27 | 1977.0 | 2334.45 | 1881.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7291 | 7291 | CHN | China | Letan | WRI1000577 | 600.0 | 23.97 | 108.61 | Hydro | HydroChina Corporation | http://www.hydrochina.com.cn:8080/news/news_zy.jsp?new_id=297911 | 1068450 | 1450.16 | 1704.95 | 2587.19 | 1907.73 | 2524.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7539 | 7539 | CHN | China | Mianhutan | WRI1000585 | 600.0 | 24.662 | 116.5955 | Hydro | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253974119114-1279253974121875.pdf | Industry About | 1017273 | 1501.14 | 1791.22 | 1787.76 | 2139.19 | 1873.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8356 | 8356 | CHN | China | Suofengying | WRI1000505 | 600.0 | 26.97 | 106.37 | Hydro | 2006.0 | Wilson Center | https://www.wilsoncenter.org/publication/interactive-mapping-chinas-dam-rush | 1056478 | 1563.63 | 2104.25 | 2261.02 | 2654.31 | 2104.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8417 | 8417 | CHN | China | Tangkeng | WRI1000606 | 600.0 | 28.1178 | 120.0339 | Hydro | Baike | http://baike.baidu.com/view/677790.htm | Industry About | 1057469 | 1442.66 | 1842.51 | 1842.21 | 2110.71 | 1852.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8510 | 8510 | CHN | China | Tongjiezi | WRI1000502 | 600.0 | 29.26 | 103.63 | Hydro | 1994.0 | Wilson Center | https://www.wilsoncenter.org/publication/interactive-mapping-chinas-dam-rush | 1028828 | 1402.13 | 2044.48 | 2018.03 | 2344.69 | 2043.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8532 | 8532 | CHN | China | Tongzilin | WRI1061009 | 600.0 | 26.71 | 101.85 | Hydro | Baike | http://baike.baidu.com/view/4016426.htm | 1084266 | 1656.51 | 2214.62 | 2044.48 | 2247.52 | 2044.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8969 | 8969 | CHN | China | Yinpan | WRI1000504 | 600.0 | 29.24 | 107.89 | Hydro | Wilson Center | https://www.wilsoncenter.org/publication/interactive-mapping-chinas-dam-rush | 1062201 | 1661.51 | 1996.83 | 1977.0 | 2288.4 | 1977.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
15234 | 15234 | IND | India | RANJIT SAGAR | IND0000369 | 600.0 | 32.4404 | 75.7305 | Hydro | 2000.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1026394 | 2019 | 1853.486 | 1947.48365 | 1299.5495999999998 | 1794.4029 | 1447.2474 | Central Electricity Authority | 2265.42 | 1948.42 | 2127.41 | 1714.85 | 1898.68 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15554 | 15554 | IND | India | UPPAR INDRAVATI | IND0000481 | 600.0 | 19.4269 | 82.8594 | Hydro | 1999.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1024908 | 2019 | 2682.94785 | 1751.6378 | 1514.0318000000002 | 1736.84215 | 2131.1308000000004 | Central Electricity Authority | 1856.65 | 1495.55 | 1856.65 | 1308.05 | 1404.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
16917 | 16917 | JPN | Japan | Tenzan | WRI1000720 | 600.0 | 33.328 | 130.1066 | Hydro | Kyushu | Japanese Electric Power Information Center | https://www.jepic.or.jp/en/ | GEODB | 1021696 | 1057.37 | 713.91 | 1707.61 | 922.5 | 713.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17222 | 17222 | MYS | Malaysia | Pergau | WRI1000238 | 600.0 | 5.625 | 101.7031 | Hydro | Penisular Malaysia Electricity Supply Company | http://www.st.gov.my/index.php/component/k2/item/606-peninsular-malaysia-electricity-supply-industry-outlook-2014.html | GEODB | 1031191 | 1402.86 | 1402.86 | 1402.86 | 1541.07 | 1206.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17320 | 17320 | MEX | Mexico | Carlos Ramírez Ulloa (El Caracol) | MEX0001860 | 600.0 | 17.9505 | -99.9943 | Hydro | CFE | CFE-CENACE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsAllGE100MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 1013132 | 2016 | 2003.97 | 1780.86 | 1600.33 | 1655.85 | 1629.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17647 | 17647 | MMR | Myanmar | Shweli (1) | WRI1061367 | 600.0 | 23.7 | 97.507 | Hydro | 2008.0 | Open Development Myanmar | https://opendevelopmentmyanmar.net/dataset/?id=myanmar-power-stations&search_query=P3R5cGU9ZGF0YXNldCZ0YXhvbm9teT1hbGwmc29ydGluZz1zY29yZSZxdWVyeT1wb3dlcg== | WRI | 1058259 | 4022.0 | Open Development Myanmar | 2457.83 | 1850.11 | 2153.12 | 2474.77 | 2270.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
17835 | 17835 | NGA | Nigeria | Shiroro | WRI1000035 | 600.0 | 9.9724 | 6.8353 | Hydro | Government of Nigeria | Sarafinchin | http://www.sarafinchin.com/index.php/projects/africa/kainji-and-jebba-dams-niger-river-nigeria/ | GEODB | 1023945 | 1721.79 | 2093.69 | 2151.78 | 2442.32 | 2631.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19428 | 19428 | RUS | Russia | Kureyskaya HPP | WRI1061884 | 600.0 | 66.9441 | 88.3384 | Hydro | 1975.0 | JSC Norilsk-Taimyr Energy Company (JSC NTEK) | EnergyBase (RUS) | https://energybase.ru/power-plant/Kureyskaya-HPP | EnergyBase (RUS) | 2456.54 | 2880.82 | 3210.96 | 1677.66 | 2816.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20024 | 20024 | KOR | South Korea | Cheongsong | WRI1029849 | 600.0 | 36.4052 | 129.016 | Hydro | 2000.0 | Korea Western Power | KWP | http://www.westernpower.co.kr/english/power/generation.asp | GEODB | 1021141 | 1006.47 | 510.16 | 66.37 | 163.64 | 195.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20076 | 20076 | KOR | South Korea | Muju | WRI1029848 | 600.0 | 35.9632 | 127.705 | Hydro | Korea Electric Power Company | KEPCO | https://home.kepco.co.kr/kepco/EN/C/htmlView/ENCBHP003.do?menuCd=EN030204 | GEODB | 1021163 | 1402.86 | 987.62 | 902.07 | 990.33 | 987.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20089 | 20089 | KOR | South Korea | Samnangjin | WRI1029846 | 600.0 | 35.4127 | 128.876 | Hydro | Korea Electric Power Company | KEPCO | https://home.kepco.co.kr/kepco/EN/C/htmlView/ENCBHP003.do?menuCd=EN030204 | GEODB | 1021175 | 1588.16 | 1367.09 | 731.74 | 1376.58 | 787.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21432 | 21432 | TJK | Tajikistan | Baipaza | WRI1000351 | 600.0 | 38.2674 | 69.1237 | Hydro | Barki Tojik | Energy Charter Secretariat | http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Tajikistan_2013_en.pdf | GEODB | 1019494 | 1795.17 | 2159.98 | 2125.31 | 2131.13 | 2125.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
25411 | 25411 | USA | United States of America | Bear Swamp | USA0008005 | 600.0 | 42.6839 | -72.9599 | Hydro | 1974.0 | Bear Swamp Power Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | -145.559 | -148.482 | -160.048 | -151.394 | -103.236 | -171.036 | -163.741 | U.S. Energy Information Administration | 1296.59 | 1296.59 | 1026.7 | 1158.18 | 979.65 | 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");