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 = "600.0", country_long = "China" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: source, url, estimated_generation_gwh_2014, estimated_generation_gwh_2015
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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");