global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
9 rows where capacity_mw = "800.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
country_long 7
- China 3
- India 1
- Japan 1
- Kyrgyzstan 1
- New Zealand 1
- South Korea 1
- Syrian Arab Republic 1
owner 3
primary_fuel 1
- Hydro · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5114 | 5114 | CHN | China | Ankang | WRI1000495 | 800.0 | 32.6 | 108.88 | Hydro | 1993.0 | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253973991194-1279253973994771.pdf | 1024462 | 2492.0 | 2905.47 | 3015.5 | 3281.69 | 2929.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
5772 | 5772 | CHN | China | Fengtan | WRI1000587 | 800.0 | 28.72 | 110.27 | Hydro | 1979.0 | HydroChina Zhongnan Engineering Company | http://web.archive.org/web/20110226112818/http://en.msdi.cn/showArticle.aspx?id=132 | 1045909 | 2473.31 | 2956.27 | 3322.06 | 3595.31 | 3091.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8173 | 8173 | CHN | China | Shisanling | WRI1000607 | 800.0 | 40.27 | 116.28 | Hydro | Chinese National Committee on Large Dams | https://web.archive.org/web/20120315034732/http://www.chincold.org.cn/news/li080321-10-Shisanling.pdf | 1024350 | 1188.48 | 1905.47 | 1899.12 | 2376.53 | 1927.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
14695 | 14695 | IND | India | KOLDAM | IND0000204 | 800.0 | 31.382 | 76.8761 | Hydro | 2015.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1018455 | 2019 | 0.25 | 2297.057 | 3209.0342 | 3297.0519 | 2998.86035 | Central Electricity Authority | 3000.67 | 2862.2 | 3000.67 | 2740.08 | 3117.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
16634 | 16634 | JPN | Japan | Kazunogawa | WRI1000698 | 800.0 | 35.7175 | 138.8742 | Hydro | Tokyo | Japanese Electric Power Information Center | https://www.jepic.or.jp/en/ | GEODB | 1031669 | 2463.21 | 2080.71 | 2827.52 | 2412.23 | 2080.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17103 | 17103 | KGZ | Kyrgyzstan | Kurpsay Hydroelectric Power Plant Kyrgyzstan | GEODB0041757 | 800.0 | 41.4986 | 72.3641 | Hydro | GEODB | http://globalenergyobservatory.org | GEODB | 2017 | 1990.24 | 1942.78 | 2602.24 | 2609.37 | 2771.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17773 | 17773 | NZL | New Zealand | Manapouri | WRI1000304 | 800.0 | -45.5214 | 167.2778 | Hydro | Meridian Energy | Meridian Energy | https://www.meridianenergy.co.nz/about-us/our-power-stations | GEODB | 1015223 | 3264.91 | 3084.07 | 2170.38 | 2176.33 | 2170.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20120 | 20120 | KOR | South Korea | Yecheon | WRI1029852 | 800.0 | 36.5678 | 128.8761 | Hydro | Korea Electric Power Company | KEPCO | https://home.kepco.co.kr/kepco/EN/C/htmlView/ENCBHP003.do?menuCd=EN030204 | WRI | 1060971 | 1640.18 | 782.85 | 769.78 | 1185.9 | 952.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21388 | 21388 | SYR | Syrian Arab Republic | Taqba (Al-Thawra) Hydroelectric Power Project Syria | GEODB0041660 | 800.0 | 35.8722 | 38.5667 | Hydro | GEODB | http://globalenergyobservatory.org | GEODB | 1016717 | 2017 | 2222.72 | 1865.79 | 2156.14 | 1811.16 | 1817.41 | 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");