global-power-plants

Table actions

18 rows where country_long = "India" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, commissioning_year, source, url, wepp_id, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017, estimated_generation_gwh

primary_fuel 1

  • Oil · 18 ✖

country_long 1

  • India · 18 ✖
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_data_source estimated_generation_gwh
14120 14120 IND India B. BRIDGE D.G IND0000018 200.0 13.0977 80.2695 Oil       1998.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1017702 2018 804.2860000000001 573.274 0.0 0.0 0.0 Central Electricity Authority  
14183 14183 IND India BRAMHAPURAM DG IND0000067 60.0 9.9975 76.3744 Oil       1997.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1020759 2018 27.9729 8.1158 12.8899 5.1171 0.42576879557282254 Central Electricity Authority  
14187 14187 IND India BUTIBORI PLANT WRI1019946 81.5 20.9225 78.9535 Oil         Indo Synthetics ltd Indo Synthetics ltd http://www.indoramaindia.com/ WRI 1019458               4418.0610797454665
14412 14412 IND India DIGHE WORKS WRI1019951 22.0 19.1896 73.004 Oil         Mukand Mukand ltd Mukand Mukand ltd http://www.mukand.com/ WRI 1051810               1192.6054448392674
14416 14416 IND India DOLVI ISPAT WRI1019953 67.6 18.69 73.039 Oil         Jsw Steel ltd Jsw Steel ltd http://www.jsw.in/ WRI 1046220               3664.5512759606568
14673 14673 IND India KASARGODE DG IND0000186 21.84 12.4837 74.9929 Oil       1998.0   Central Electricity Authority http://www.cea.nic.in/ WRI   2018             1183.9319506949814
14693 14693 IND India KOJIKODE DG IND0000202 96.0 11.2054 75.8067 Oil       1999.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1039489 2018 186.77924 194.11479 133.4064 36.34044 0.74653 Central Electricity Authority  
14859 14859 IND India LODHIVALI WRI1019964 40.0 18.9002 73.2032 Oil         Tata Co ltd Tata Co ltd http://www.tatapower.com/ WRI 1086815               2168.3735360713954
14892 14892 IND India MAHUL REFINERY WRI1019967 22.0 19.0162 72.8963 Oil         Bharat Corp ltd Bharat Corp ltd https://bharatpetroleum.com/ WRI 1058538               1192.6054448392674
14928 14928 IND India MUMBAI JINDAL WRI1020014 25.2 18.5309 72.9465 Oil         Jsw Steel ltd Jsw Steel ltd http://www.jsw.in/ WRI 1020136               1366.0753277249787
15019 15019 IND India NAGOTHANE COMPLEX WRI1019973 78.9 18.8829 73.1862 Oil         Reliance Reliance petrochemicals Reliance Petrochemicals http://www.ril.com/OurBusinesses/Petrochemicals.aspx WRI 1019446               4277.1167999008285
15114 15114 IND India PAMPORE GT IND0000319 175.0 34.004 74.9175 Oil       1992.0   Central Electricity Authority http://www.cea.nic.in/ WRI   2018 0.0 0.0 0.0 0.0 0.0 Central Electricity Authority  
15302 15302 IND India SAMALPATTI DG IND0000389 105.7 12.2995 78.4038 Oil       2001.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1045793 2018 299.15290324 223.65043618299998 37.56064325 0.0   Central Electricity Authority  
15303 15303 IND India SAMAYANALLUR DG IND0000390 106.0 9.9751 78.0445 Oil       2001.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1041557 2018 346.69 243.63400000000001 39.954 11.308044   Central Electricity Authority  
15470 15470 IND India THANE PLANT WRI1019990 22.5 19.0875 73.0258 Oil         Nocil Nocil rubber Nocil Nocil rubber http://www.nocil.com/ WRI 1023666               1219.7101140401594
15479 15479 IND India TROMBAY IND0000462 500.0 19.0004 72.8983 Oil Gas     1990.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1031024 2018 453.68 770.18 15.0 0.0 0.0 Central Electricity Authority  
15483 15483 IND India TROMBAY_Oil IND0000465 150.0 19.0004 72.8983 Oil Gas     1965.0   Central Electricity Authority http://www.cea.nic.in/ WRI 1031024 2018 0.0 0.0 0.0 0.0   Central Electricity Authority  
15630 15630 IND India YELHANKA (DG) IND0000512 106.6 13.1156 77.5838 Oil       1993.0   Central Electricity Authority http://www.cea.nic.in/ WRI   2018 20.9 0.0 0.0 0.0   Central Electricity Authority  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");