global-power-plants

Table actions

14 rows where country_long = "Pakistan" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, commissioning_year, source, url, geolocation_source, estimated_generation_gwh

primary_fuel 1

  • Oil · 14 ✖

country_long 1

  • Pakistan · 14 ✖
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
18185 18185 PAK Pakistan AES Lalpir Ltd. Mahmood Kot Muzaffargarh WRI1001628 362.0 30.1725 70.993 Oil       1997.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB                 3116.4224191221924
18188 18188 PAK Pakistan Bin Qasim WRI1001624 1260.0 24.7844 67.3604 Oil         Karachi Electric Supply Company (KESC) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1020510               10847.216154955695
18204 18204 PAK Pakistan Gul Ahmed Energy Ltd. (GAEL) WRI1001632 136.0 24.8496 67.1471 Oil       1997.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB                 1170.8106325983929
18206 18206 PAK Pakistan Hub Power Project WRI1001627 1292.0 24.9057 66.6946 Oil       1977.0 Hub Power Company Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB                 11122.701009684732
18207 18207 PAK Pakistan Hub Power Project- Narowal WRI1001647 220.0 24.9057 66.6946 Oil       2011.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB 1069520               1893.9583762621055
18208 18208 PAK Pakistan Japan Power Company Lahore WRI1001634 120.0 31.3255 74.2617 Oil       2000.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB                 1033.0682052338761
18211 18211 PAK Pakistan Kohinoor Energy Limited WRI1001635 131.0 31.2629 74.1871 Oil       1997.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB 1021027               1127.7661240469813
18222 18222 PAK Pakistan Nishat Chunian Limited WRI1001650 200.0 31.1389 73.9125 Oil       2010.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm CARMA 1074917               1721.7803420564599
18223 18223 PAK Pakistan Nishat Power Limited WRI1001649 200.0 31.1389 73.9125 Oil       2010.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm CARMA 1072721               1721.7803420564599
18224 18224 PAK Pakistan Pak Gen (Pvt) Limited WRI1001629 365.0 30.1721 70.9929 Oil       1998.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB 1009786               3142.249124253039
18227 18227 PAK Pakistan Piranghaib Multan WRI1001669 192.0 30.215 71.5492 Oil         Government RPP Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf CARMA                 1652.9091283742014
18234 18234 PAK Pakistan Saba Power Company Sheikhupura WRI1001638 114.0 31.7322 73.8752 Oil       1999.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB 1012930               981.4147949721823
18237 18237 PAK Pakistan Southern Electric Power Company WRI1001639 135.0 31.2911 74.2489 Oil       1999.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB                 1162.2017308881104
18238 18238 PAK Pakistan Tapal Energy Limited Karachi WRI1001640 126.0 24.9997 66.9072 Oil       1977.0 IPP Private Power and Infrastructure Board http://ppib.gov.pk/N_commissioned_ipps.htm GEODB 1031010               1084.7216154955697

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");