global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
24 rows where capacity_mw = "5.0", country_long = "China" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5605 | 5605 | CHN | China | Dengxinqiao | WRI1071445 | 5.0 | 32.3211 | 108.6056 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3909 | UNFCCC CDM Registry | 9.19 | 13.14 | 13.14 | 15.54 | 13.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5652 | 5652 | CHN | China | Diebu Lazikou Ii Hydro | WRI1071227 | 5.0 | 34.0764 | 103.8944 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3157 | UNFCCC CDM Registry | 12.27 | 15.59 | 15.64 | 17.94 | 15.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5653 | 5653 | CHN | China | Diebu Lazikou Iii | WRI1072519 | 5.0 | 34.0392 | 103.9092 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=7452 | UNFCCC CDM Registry | 12.27 | 15.59 | 15.64 | 17.94 | 15.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5795 | 5795 | CHN | China | Fujian Jianyang Huilong | WRI1071538 | 5.0 | 27.4758 | 118.4433 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4237 | UNFCCC CDM Registry | 8.83 | 12.78 | 12.78 | 15.17 | 12.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5897 | 5897 | CHN | China | Gansu Longchanghe Iv Hydro | WRI1071301 | 5.0 | 38.8808 | 99.7347 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3386 | UNFCCC CDM Registry | 14.91 | 18.43 | 18.12 | 21.81 | 18.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6264 | 6264 | CHN | China | Hangudi | WRI1071075 | 5.0 | 25.6333 | 99.005 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1982 | UNFCCC CDM Registry | 1058746 | 8.83 | 12.78 | 12.78 | 15.17 | 12.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6801 | 6801 | CHN | China | Hunan Xiaohe Small | WRI1071610 | 5.0 | 29.0753 | 109.5256 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4557 | UNFCCC CDM Registry | 14.57 | 19.14 | 19.46 | 20.34 | 17.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7378 | 7378 | CHN | China | Lintan Qingshishan Expansion | WRI1071953 | 5.0 | 34.5806 | 103.6381 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5762 | UNFCCC CDM Registry | 17.54 | 20.89 | 19.32 | 20.35 | 19.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7584 | 7584 | CHN | China | Nanpian River | WRI1071178 | 5.0 | 24.5519 | 97.7189 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3014 | UNFCCC CDM Registry | 8.83 | 12.78 | 12.78 | 15.17 | 12.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7845 | 7845 | CHN | China | Qinyu Small | WRI1071596 | 5.0 | 33.787 | 104.535 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4502 | UNFCCC CDM Registry | 12.81 | 15.15 | 16.99 | 17.51 | 15.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7862 | 7862 | CHN | China | Renewable Energy For Grid | WRI1070944 | 5.0 | 36.0406 | 103.4504 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=594 | UNFCCC CDM Registry | 16.57 | 19.35 | 18.77 | 20.03 | 18.77 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8058 | 8058 | CHN | China | Shanxi Dingxiang Lingzidi | WRI1071311 | 5.0 | 38.4376 | 113.2555 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3411 | UNFCCC CDM Registry | 13.37 | 16.98 | 16.84 | 17.21 | 15.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8171 | 8171 | CHN | China | Shimian Danihe | WRI1071121 | 5.0 | 29.492 | 102.25 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2616 | UNFCCC CDM Registry | 19.04 | 19.75 | 21.1 | 22.63 | 21.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8230 | 8230 | CHN | China | Sichuan Ganluo Longgangzi Small | WRI1072405 | 5.0 | 28.8808 | 102.563 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=7114 | UNFCCC CDM Registry | 9.19 | 13.14 | 13.14 | 15.54 | 13.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8289 | 8289 | CHN | China | Sichuan Province Dayan River 4th Level | WRI1071806 | 5.0 | 28.78 | 102.531 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5247 | UNFCCC CDM Registry | 8.81 | 12.75 | 12.75 | 15.15 | 12.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8353 | 8353 | CHN | China | Sunan Longchanghe I Small Hydro | WRI1071912 | 5.0 | 38.8514 | 99.6769 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5650 | UNFCCC CDM Registry | 14.91 | 18.43 | 18.12 | 21.81 | 18.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8490 | 8490 | CHN | China | Tiantai County Chayuan Cascade | WRI1071739 | 5.0 | 29.0069 | 120.7272 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4983 | UNFCCC CDM Registry | 8.83 | 12.78 | 12.78 | 15.17 | 12.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8848 | 8848 | CHN | China | Xiying River Shuangyaowan I | WRI1071502 | 5.0 | 37.909 | 102.205 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4129 | UNFCCC CDM Registry | 1072511 | 13.75 | 17.32 | 17.69 | 20.63 | 17.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8956 | 8956 | CHN | China | Yiliang County Xionggou Small | WRI1072351 | 5.0 | 27.4367 | 104.0222 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6946 | UNFCCC CDM Registry | 13.98 | 16.87 | 17.84 | 18.98 | 17.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8964 | 8964 | CHN | China | Yingjiang County Nanlang River 2nd Level | WRI1071233 | 5.0 | 24.7878 | 97.9606 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3174 | UNFCCC CDM Registry | 8.83 | 12.78 | 12.78 | 15.17 | 12.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9084 | 9084 | CHN | China | Yunnan Honghe County Yongxing Ii Hydro | WRI1072185 | 5.0 | 23.3333 | 102.4333 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6433 | UNFCCC CDM Registry | 14.48 | 17.17 | 16.04 | 16.58 | 16.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9118 | 9118 | CHN | China | Yunnan Pingbian Baifu | WRI1071844 | 5.0 | 23.2353 | 103.9103 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5385 | UNFCCC CDM Registry | 9.19 | 13.14 | 13.14 | 15.54 | 13.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9137 | 9137 | CHN | China | Yunnan Yingjiang Mengyong River 1st Level | WRI1071156 | 5.0 | 24.7994 | 97.8886 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2893 | UNFCCC CDM Registry | 8.83 | 12.78 | 12.78 | 15.17 | 12.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9150 | 9150 | CHN | China | Yunxi Cascade Chunan | WRI1071966 | 5.0 | 29.7903 | 119.3593 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5802 | UNFCCC CDM Registry | 9.19 | 13.14 | 13.14 | 15.54 | 13.14 | 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");