global-power-plants

Table actions

10 rows where country_long = "Pakistan" and owner = "Water and Power Development Authority (WAPDA)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geolocation_source

primary_fuel 1

owner 1

  • Water and Power Development Authority (WAPDA) · 10 ✖

country_long 1

  • Pakistan · 10 ✖
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
18189 18189 PAK Pakistan Chashma WRI1001661 184.0 32.4348 71.3706 Hydro       2001.0 Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1033192               723.7849203965153
18191 18191 PAK Pakistan Chichoki WRI1001665 13.0 31.7131 73.9783 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf CARMA 1033194               51.13697807149294
18193 18193 PAK Pakistan Dargai WRI1001663 20.0 34.8617 72.0359 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf CARMA 1033196               78.67227395614299
18202 18202 PAK Pakistan Ghazi Barotha WRI1001658 1450.0 33.7793 72.259 Hydro       2003.0 Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1033199               5703.739861820368
18214 18214 PAK Pakistan Kot Addu Power Company ltd. WRI1001656 1368.0 30.4451 70.9811 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1033207               5381.1835386001785
18217 18217 PAK Pakistan Mangla WRI1001659 1000.0 33.1373 73.6416 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1033211               3933.6136978071495
18232 18232 PAK Pakistan Rasul WRI1001662 22.0 32.5834 73.4843 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf CARMA 1033220               86.53950135175728
18236 18236 PAK Pakistan Shadiwal WRI1001666 14.0 31.4498 74.2783 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf CARMA 1033223               55.0705917693001
18239 18239 PAK Pakistan Tarbela WRI1001657 3478.0 34.0889 72.6861 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1033226               13681.108440973265
18245 18245 PAK Pakistan Warsak WRI1001660 243.0 34.1642 71.3582 Hydro         Water and Power Development Authority (WAPDA) Islamabad Chamber of Commerce and Industry http://icci.com.pk/data/downloads/63/1293619048_1.pdf GEODB 1033228               955.8681285671373

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