global-power-plants

Table actions

16 rows where country_long = "Indonesia" and owner = "PLN - PT. Indonesia Power"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, geolocation_source, wepp_id, estimated_generation_gwh

primary_fuel 2

owner 1

  • PLN - PT. Indonesia Power · 16 ✖

country_long 1

  • Indonesia · 16 ✖
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
15650 15650 IDN Indonesia Bengkok+Dago/saguling WRI1000743 3.85 -6.6247 107.5564 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA                 12.790574244362213
15655 15655 IDN Indonesia Cikalong/saguling WRI1000747 19.2 -6.9039 107.6186 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026135               63.786759867988174
15675 15675 IDN Indonesia Ketenger / mrica WRI1000772 8.04 -7.5097 109.2778 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1050220               26.710705694720048
15676 15676 IDN Indonesia Klambu/Mrica WRI1000773 1.117 -7.0069 110.7964 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA                 3.7109276444032697
15678 15678 IDN Indonesia Kracak/saguling WRI1000776 18.9 -6.9039 107.6186 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026135               62.790091745050866
15681 15681 IDN Indonesia Lamajan/saguling WRI1000779 19.56 -6.9039 107.6186 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026135               64.98276161551296
15694 15694 IDN Indonesia PB. Sudirman/Mrica WRI1000800 180.9 -7.3927 109.6054 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ GEODB 1026120               600.9908781312013
15765 15765 IDN Indonesia PLTU Perak WRI1000970 100.0 -7.2492 112.7508 Coal         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA                 410.2273889476017
15775 15775 IDN Indonesia PLTU Tambak Lorok WRI1000984 300.0 -6.9507 110.4304 Coal         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ GEODB 1026156               1230.6821668428051
15786 15786 IDN Indonesia Pejengkolan/Mrica WRI1000801 1.4 -7.5694 109.8006 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026121               4.651117907040804
15793 15793 IDN Indonesia Plengan/Saguling WRI1000806 6.87 -6.9039 107.6186 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA                 22.82370001526452
15796 15796 IDN Indonesia Saguling WRI1001005 700.72 -6.9126 107.3663 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ GEODB 1026135               2327.950957015452
15797 15797 IDN Indonesia Sempor/Mrica WRI1001009 1.0 -7.4733 109.3331 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1050218               3.3222270764577178
15799 15799 IDN Indonesia Sidorejo/Mrica WRI1001013 1.4 -7.4764 110.2622 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1050222               4.651117907040804
15813 15813 IDN Indonesia Timo / Mrica WRI1001035 12.0 -6.9485 110.4069 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026168               39.86672491749261
15815 15815 IDN Indonesia Ubrug/saguling WRI1001039 18.36 -6.9039 107.6186 Hydro         PLN - PT. Indonesia Power Indonesia Power Generation https://repit.wordpress.com/ CARMA                 60.9960891237637

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