global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
24 rows where primary_fuel = "Hydro" and source = "Baike"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5166 | 5166 | CHN | China | Banduo | WRI1000604 | 360.0 | 35.31 | 100.27 | Hydro | Baike | http://baike.baidu.com/view/1113141.htm | 1070845 | 1017.82 | 1208.07 | 1250.6 | 1372.89 | 1185.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5373 | 5373 | CHN | China | Changzhou | WRI1000575 | 630.0 | 23.42 | 111.21 | Hydro | 1993.0 | Baike | http://baike.baidu.com/view/2476357.htm | 1058020 | 1343.48 | 1806.49 | 1789.91 | 2211.98 | 1474.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
5464 | 5464 | CHN | China | Dafutan | WRI1000612 | 195.0 | 27.98 | 110.27 | Hydro | Baike | http://baike.baidu.com/view/1162078.htm | 1065268 | 651.07 | 777.16 | 946.7 | 1005.79 | 789.21 | 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 | ||||||||||||||
5590 | 5590 | CHN | China | Daxia | WRI1000596 | 324.5 | 36.15 | 104.01 | Hydro | Baike | http://baike.baidu.com/view/439122.htm | 1017410 | 894.36 | 1401.47 | 1104.18 | 1047.98 | 1104.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5784 | 5784 | CHN | China | Fuchunjiang | WRI1000605 | 297.2 | 29.71 | 119.65 | Hydro | Baike | http://baike.baidu.com/view/1244447.htm | 1013918 | 830.91 | 1032.44 | 859.05 | 1098.19 | 1032.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6412 | 6412 | CHN | China | Honghua | WRI1000583 | 228.0 | 24.23 | 109.53 | Hydro | 2006.0 | Baike | http://baike.baidu.com/subview/4606506/4606506.htm | 1056764 | 1120.78 | 1046.18 | 1235.4 | 1301.5 | 1243.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6980 | 6980 | CHN | China | Jiangzi | WRI1000590 | 360.0 | 27.52 | 115.13 | Hydro | Baike | http://baike.baidu.com/view/632240.htm | 1141.87 | 1308.2 | 1267.43 | 1772.87 | 1157.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||||
7072 | 7072 | CHN | China | Jilintai | WRI1000542 | 460.0 | 43.86 | 82.847 | Hydro | Baike | http://baike.baidu.com/view/4269744.htm | 1033539 | 1172.46 | 1732.06 | 1491.69 | 1615.27 | 1402.85 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7406 | 7406 | CHN | China | Liujiaxia | WRI1000486 | 1225.0 | 35.93 | 103.34 | Hydro | 1968.0 | Baike | http://baike.baidu.com/view/159096.htm | 1024476 | 2959.24 | 3990.23 | 3732.03 | 4337.05 | 3732.03 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7468 | 7468 | CHN | China | Ludila | WRI1000471 | 2160.0 | 26.2 | 100.82 | Hydro | 2014.0 | Baike | http://baike.baidu.com/view/1237237.htm | 1077180 | 5078.33 | 8859.22 | 6475.01 | 7205.95 | 7105.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7719 | 7719 | CHN | China | Pingban | WRI1000580 | 405.0 | 24.82 | 105.49 | Hydro | 2005.0 | Baike | http://www.baike.com/wiki/%E5%B9%B3%E7%8F%AD%E6%B0%B4%E7%94%B5%E7%AB%99&prd=so_1_doc | 1053871 | 1346.74 | 1395.77 | 1395.77 | 1511.42 | 1402.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7834 | 7834 | CHN | China | Qingtongxia | WRI1000556 | 272.0 | 37.88 | 105.99 | Hydro | 1978.0 | Baike | http://baike.baidu.com/view/439111.htm | 1024480 | 749.66 | 1146.37 | 925.54 | 878.43 | 925.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7946 | 7946 | CHN | China | Sanmexia | WRI1000547 | 400.0 | 34.83 | 111.34 | Hydro | 1960.0 | Baike | http://baike.baidu.com/view/656801.htm | 1011857 | 1477.29 | 1735.93 | 1685.85 | 1292.26 | 1735.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7980 | 7980 | CHN | China | Shahe | WRI1000591 | 100.0 | 31.29 | 119.43 | Hydro | Baike | http://baike.baidu.com/view/4316433.htm | 1045283 | 246.1 | 335.73 | 335.73 | 383.8 | 335.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8094 | 8094 | CHN | China | Shapotou | WRI1000557 | 153.2 | 37.45 | 105.02 | Hydro | Baike | http://www.baike.com/wiki/%E6%B2%99%E5%9D%A1%E5%A4%B4%E6%B0%B4%E5%88%A9%E6%9E%A2%E7%BA%BD | 1065100 | 474.93 | 682.27 | 573.99 | 548.83 | 573.99 | 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 | ||||||||||||||
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 | ||||||||||||||
8484 | 8484 | CHN | China | Tianqiao | WRI1000610 | 128.0 | 39.06 | 111.13 | Hydro | Baike | http://baike.baidu.com/view/439118.htm | 1059943 | 396.81 | 570.04 | 479.57 | 458.55 | 479.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8523 | 8523 | CHN | China | Tongwan | WRI1000613 | 180.0 | 27.58 | 110.29 | Hydro | Baike | http://baike.baidu.com/view/4630553.htm | 1062398 | 598.61 | 638.88 | 871.49 | 926.04 | 726.12 | 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 | |||||||||||||||
8596 | 8596 | CHN | China | Wanmipo | WRI1000611 | 240.0 | 28.76 | 109.51 | Hydro | Baike | http://baike.baidu.com/view/1972763.htm | 1059187 | 654.14 | 814.9 | 821.91 | 937.98 | 823.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8749 | 8749 | CHN | China | Xihe | WRI1061007 | 180.0 | 32.83 | 108.28 | Hydro | Baike | http://www.baike.com/wiki/%E5%96%9C%E6%B2%B3%E6%B0%B4%E7%94%B5%E7%AB%99 | 1057472 | 671.7 | 790.41 | 744.37 | 756.19 | 788.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8752 | 8752 | CHN | China | Xijin | WRI1000582 | 234.4 | 24.87 | 104.58 | Hydro | 1979.0 | Baike | http://baike.baidu.com/view/1050095.htm | 1074456 | 550.58 | 728.4 | 728.4 | 828.4 | 767.66 | 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");