global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
7 rows where country_long = "India", other_fuel1 = "Oil", primary_fuel = "Gas" and year_of_capacity_data = 2019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14144 | 14144 | IND | India | BASIN BRIDGE GT | IND0000040 | 120.0 | 13.1021 | 80.2682 | Gas | Oil | 1996.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1030926 | 2019 | 2.85387 | 8.29591247299784 | 10.46898 | 5.85771 | 0.056 | Central Electricity Authority | 377.57 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
14184 | 14184 | IND | India | BSES Kerala CCGT | IND0000068 | 165.0 | 10.074 | 76.3188 | Gas | Oil | 1999.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1038651 | 2019 | 145.56 | 3.4172 | 0.0 | 60.718 | 0.0 | Central Electricity Authority | 519.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
14395 | 14395 | IND | India | DADRI GT | IND0000089 | 829.78 | 28.5932 | 77.6101 | Gas | Oil | 1992.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1023638 | 2019 | 2462.0 | 2924.0 | 2178.0 | 1575.0 | 1605.0 | Central Electricity Authority | 2610.85 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
14598 | 14598 | IND | India | I.P.GT | IND0000146 | 270.0 | 28.6194 | 77.2504 | Gas | Oil | 1989.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 2019 | 904.388 | 445.882 | 673.162 | 562.509 | 577.005 | Central Electricity Authority | 849.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
14852 | 14852 | IND | India | LAKWA GT | IND0000228 | 211.955 | 27.0221 | 94.8833 | Gas | Oil | 2002.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1010448 | 2019 | 855.342825 | 870.2 | 823.297501 | 614.442988 | 840.5586379 | Central Electricity Authority | 666.9 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
15134 | 15134 | IND | India | PIPAVAV CCCP | IND0000338 | 702.86 | 20.8986 | 71.4693 | Gas | Oil | 2013.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1046463 | 2019 | 2.20585 | 454.954 | 216.621274 | 160.5282 | 475.9 | Central Electricity Authority | 2211.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
15228 | 15228 | IND | India | RAMGARH GT | IND0000364 | 270.5 | 27.336 | 70.538 | Gas | Oil | 2008.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1026506 | 2019 | 1153.89723 | 1459.399526 | 1367.92423 | 1391.01485 | 955.56505 | Central Electricity Authority | 851.11 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");