global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
6 rows where country_long = "Pakistan", estimated_generation_note_2015 = "HYDRO-V1", geolocation_source = "GEODB", owner = "Water and Power Development Authority (WAPDA)" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
primary_fuel 1
- Hydro · 6 ✖
owner 1
- Water and Power Development Authority (WAPDA) · 6 ✖
country_long 1
- Pakistan · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 642.1 | 673.81 | 711.68 | 713.83 | 713.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
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 | 5282.96 | 5204.66 | 5605.47 | 5040.66 | 5282.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
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 | 5090.7 | 5090.7 | 3528.29 | 3537.96 | 5090.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
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 | 4575.09 | 4575.09 | 4763.18 | 4798.38 | 4633.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
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 | 12794.61 | 12794.61 | 13568.19 | 13605.36 | 12794.61 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
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 | 995.98 | 1005.88 | 824.03 | 890.92 | 1072.63 | 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");