global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
8 rows where capacity_mw = "300.0", country_long = "China" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5141 | 5141 | CHN | China | Bailianhe | WRI1000517 | 300.0 | 30.59 | 115.45 | Hydro | 1960.0 | Vaptech | http://www.vaptech.bg/uploads/references/References_Hydro-rev20130115.pdf | 1061738 | 557.2 | 842.82 | 811.97 | 1067.79 | 882.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
5238 | 5238 | CHN | China | Bikou | WRI1000516 | 300.0 | 32.76 | 105.22 | Hydro | 1977.0 | Northwest Hydro Consulting Engineers | https://web.archive.org/web/20120331102435/http://www.nwh.cn/english/Projects_Highlights_pic.asp?action=pic_5 | 1045907 | 936.56 | 1125.46 | 1121.1 | 1223.23 | 1211.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6918 | 6918 | CHN | China | Jiangkou (Chongqing) Dam | WRI1070878 | 300.0 | 29.2365 | 107.8929 | Hydro | 1980.0 | Jiangkou Development Co | Industry About | https://industryabout.com/country-territories-3/1142-china/hydro-energy/15410-jiangkou-chongqing-dam | Industry About | 1078035 | 832.82 | 1000.48 | 990.56 | 1146.27 | 990.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
6974 | 6974 | CHN | China | Jiangya Dam | WRI1070880 | 300.0 | 29.5416 | 110.739 | Hydro | 1999.0 | Industry About | https://industryabout.com/country-territories-3/1142-china/hydro-energy/15412-jiangya-dam | Industry About | 1021991 | 710.59 | 933.31 | 942.93 | 1158.58 | 922.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
7037 | 7037 | CHN | China | Jiemian | WRI1000592 | 300.0 | 25.94 | 118.04 | Hydro | South East Network | http://www.fjsen.com/zt/2009-04/22/content_692541.htm | 1066334 | 608.13 | 856.15 | 850.99 | 1031.87 | 796.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7157 | 7157 | CHN | China | Jinshuitan | WRI1000550 | 300.0 | 28.21 | 119.54 | Hydro | 1988.0 | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/DamInformation/damsinchina/webinfo/2010/07/1279253973938211.htm | 1013921 | 685.62 | 898.21 | 887.82 | 1041.53 | 887.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7179 | 7179 | CHN | China | Jiudianxia | WRI1000599 | 300.0 | 34.92 | 103.83 | Hydro | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/DamInformation/damsinchina/webinfo/2010/07/1279253973981691.htm | 1087965 | 785.75 | 982.31 | 929.84 | 1070.71 | 928.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8103 | 8103 | CHN | China | Shaxikou | WRI1000586 | 300.0 | 26.59 | 118.08 | Hydro | 1990.0 | Baike | http://baike.baidu.com/view/1107324.htm | 1017276 | 838.74 | 1029.2 | 1042.16 | 947.3 | 1032.72 | 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");