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 = "40.0", geolocation_source = "UNFCCC CDM Registry" and primary_fuel = "Hydro"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5176 | 5176 | CHN | China | Baoshan Supahe Chaoyang | WRI1071122 | 40.0 | 24.4244 | 98.7592 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2624 | UNFCCC CDM Registry | 1071545 | 106.62 | 139.9 | 141.8 | 150.63 | 134.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6112 | 6112 | CHN | China | Guizhou Tongzihe Yangjiayuan | WRI1071847 | 40.0 | 28.1619 | 106.3747 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5404 | UNFCCC CDM Registry | 114.46 | 147.89 | 137.07 | 161.01 | 138.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6727 | 6727 | CHN | China | Hubei Enshi Qinglonghu | WRI1071393 | 40.0 | 30.1917 | 109.8611 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3698 | UNFCCC CDM Registry | 1089190 | 107.13 | 137.98 | 133.67 | 150.49 | 138.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7720 | 7720 | CHN | China | Pingbian Guanyintuo Hydro | WRI1071068 | 40.0 | 28.5747 | 103.7031 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1897 | UNFCCC CDM Registry | 100.54 | 136.39 | 136.39 | 155.62 | 136.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7966 | 7966 | CHN | China | Shaanxi Juting | WRI1071905 | 40.0 | 33.0817 | 106.0136 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5630 | UNFCCC CDM Registry | 132.4 | 138.34 | 159.58 | 154.45 | 123.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8265 | 8265 | CHN | China | Sichuan Leshan Ebian Ejingxiang Hydro | WRI1071288 | 40.0 | 29.0567 | 103.1558 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3345 | UNFCCC CDM Registry | 1105558 | 106.77 | 134.53 | 134.38 | 150.63 | 134.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8281 | 8281 | CHN | China | Sichuan Muchuan County Huogu | WRI1071279 | 40.0 | 28.9232 | 103.6743 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3309 | UNFCCC CDM Registry | 121.22 | 148.56 | 148.15 | 162.81 | 147.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9147 | 9147 | CHN | China | Yunnan Yun County Nan River | WRI1071722 | 40.0 | 24.3297 | 100.0433 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4927 | UNFCCC CDM Registry | 108.02 | 136.3 | 122.97 | 156.97 | 139.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9245 | 9245 | CHN | China | Zhenkang Fengweihe | WRI1071274 | 40.0 | 23.8467 | 98.9833 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3293 | UNFCCC CDM Registry | 1090556 | 120.95 | 140.65 | 147.89 | 161.65 | 145.61 | 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");