global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
6 rows where commissioning_year = "2002.0", country = "IND" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14133 | 14133 | IND | India | BANSAGAR (II) | IND0000030 | 30.0 | 24.1917 | 81.2875 | Hydro | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1038407 | 2019 | 85.65955000000001 | 106.9426 | 109.18135 | 55.8394 | 36.90455 | Central Electricity Authority | 129.98 | 118.72 | 127.5 | 98.35 | 98.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14686 | 14686 | IND | India | KHOPOLI | IND0000198 | 72.0 | 18.7817 | 73.3558 | Hydro | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1079079 | 2019 | 302.23125 | 259.92385 | 305.7038 | 314.79810000000003 | 340.77755 | Central Electricity Authority | 264.85 | 222.18 | 264.85 | 165.31 | 200.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14898 | 14898 | IND | India | MANERI BHALI | IND0000255 | 394.0 | 30.7294 | 78.4238 | Hydro | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1050068 | 2019 | 1261.7197 | 1707.0120499999998 | 1592.92535 | 1663.0629 | 1724.0763 | Central Electricity Authority | 1388.05 | 1333.05 | 1413.91 | 1189.07 | 1183.99 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15231 | 15231 | IND | India | RANGANADI | IND0000367 | 405.0 | 27.3426 | 93.8168 | Hydro | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1047211 | 2019 | 1103.9326 | 1273.84875 | 1242.76495 | 1409.6563 | 1046.59075 | Central Electricity Authority | 1762.36 | 1599.12 | 1685.72 | 1557.52 | 1617.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15322 | 15322 | IND | India | SEWA-III | IND0000401 | 9.0 | 32.6029 | 75.9006 | Hydro | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1048264 | 2019 | 49.18 | 38.86 | 42.96 | 35.58 | 37.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
15460 | 15460 | IND | India | TAWA | IND0000446 | 13.5 | 22.5616 | 77.9635 | Hydro | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1018478 | 2019 | 69.92 | 47.86 | 55.16 | 51.16 | 42.26 | 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");