global-power-plants

Table actions

41 rows where country_long = "Indonesia" and primary_fuel = "Hydro"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geolocation_source, wepp_id

primary_fuel 1

  • Hydro · 41 ✖

country_long 1

  • Indonesia · 41 ✖
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
15645 15645 IDN Indonesia Asahan I WRI1000737 180.0 2.5113 99.259 Hydro         PT Bajradaya Sentranusa (China Huadian Corporation 70% + PJB 26.5%+Nusa Konstruksi Engineering 3.5%) Indonesia Power Generation https://repit.wordpress.com/ WRI 1076093               598.0008737623891
15646 15646 IDN Indonesia Bakaru WRI1000738 126.0 -3.1141 119.6042 Hydro         PLN-South&South East Sulawesi Regional Unit Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026035               418.60061163367243
15647 15647 IDN Indonesia Balambano WRI1000739 130.0 -2.5213 121.357 Hydro         PT. Inco Indonesia Power Generation https://repit.wordpress.com/ CARMA 1025948               431.8895199395033
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
15651 15651 IDN Indonesia Besai - Way Kanan WRI1000744 92.8 -4.9822 104.8051 Hydro         PLN-South Sumatera Generation Unit Indonesia Power Generation https://repit.wordpress.com/ WRI 1026048               308.30267269527616
15652 15652 IDN Indonesia Bili bili WRI1000745 20.1 -5.2779 119.5817 Hydro         PLN Indonesia Power Generation https://repit.wordpress.com/ WRI 1092163               66.77676423680012
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
15658 15658 IDN Indonesia CirataI & II WRI1000748 1008.0 -6.7004 107.3671 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ WRI 1026056               3348.8048930693794
15662 15662 IDN Indonesia Giringan - Pamekasan WRI1000755 3.2 -7.7201 111.6715 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026067               10.631126644664695
15663 15663 IDN Indonesia Golang - Pamekasan WRI1000756 2.7 -8.1408 111.1317 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026068               8.97001310643584
15666 15666 IDN Indonesia Jatiluhur WRI1000762 186.0 -6.523 107.389 Hydro         Perum Jasa Tirta II Indonesia Power Generation https://repit.wordpress.com/ GEODB                 617.9342362211355
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
15677 15677 IDN Indonesia Koto Panjang Kampar WRI1000775 114.0 0.2905 100.8814 Hydro         PLN Indonesia Power Generation https://repit.wordpress.com/ WRI                 378.7338867161798
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
15683 15683 IDN Indonesia Larona WRI1000780 165.0 -2.8194 121.5783 Hydro         PT. Inco Indonesia Power Generation https://repit.wordpress.com/ CARMA 1025949               548.1674676155234
15684 15684 IDN Indonesia Lau Renun WRI1000781 82.0 3.0824 98.065 Hydro         PLN - Pandan Sector Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026134               272.42262026953284
15685 15685 IDN Indonesia Lodoyo - Brantas WRI1000783 4.5 -8.1613 112.2173 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026092               14.95002184405973
15686 15686 IDN Indonesia Maninjau III WRI1000785 123.0 -0.2923 100.152 Hydro         PLN-South Sumatera Generation Unit Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026095               408.6339304042993
15688 15688 IDN Indonesia Mendalan - Brantas WRI1000788 23.0 -7.854 112.3316 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026099               76.41122275852751
15691 15691 IDN Indonesia Musi WRI1000792 215.475 -3.766 102.435 Hydro         PLN-South Sumatera Generation Unit Indonesia Power Generation https://repit.wordpress.com/ GEODB 1026105               715.8568792997268
15692 15692 IDN Indonesia Ngebel - Pamekasan WRI1000793 2.2 -7.7891 111.6167 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026106               7.3088995682069795
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
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
15795 15795 IDN Indonesia Riam Kanan/pangeran Muhamad Nur WRI1001004 30.0 -3.5156 115.0074 Hydro         PLN Indonesia Power Generation https://repit.wordpress.com/ WRI                 99.66681229373155
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
15798 15798 IDN Indonesia Sengguruh - Brantas WRI1001010 29.0 -8.1764 112.551 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026143               96.3445852172738
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
15800 15800 IDN Indonesia Sigura gura (asahan II) WRI1001014 286.0 2.5196 99.2793 Hydro         PT. Indonesia Asahan aluminium Indonesia Power Generation https://repit.wordpress.com/ WRI                 950.1569438669072
15802 15802 IDN Indonesia Singkarak WRI1001017 175.0 -0.6909 100.6034 Hydro         PLN-South Sumatera Generation Unit Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026146               581.3897383801008
15803 15803 IDN Indonesia Sipansihaporas WRI1001018 50.0 1.7427 98.7792 Hydro         PLN - North Sumatera Generation Unit Indonesia Power Generation https://repit.wordpress.com/ CARMA 1055420               166.11135382288592
15806 15806 IDN Indonesia Sutami / Karangkates - Brantas WRI1001021 105.0 -8.1606 112.4443 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ WRI 1026154               348.83384302806036
15808 15808 IDN Indonesia Tangga (asahan II) WRI1001024 317.0 2.5479 99.3028 Hydro         PT. Indonesia Asahan aluminium Indonesia Power Generation https://repit.wordpress.com/ WRI 1025945               1053.1459832370965
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
15814 15814 IDN Indonesia Tulungagung - Brantas WRI1001038 36.0 -8.0657 111.9025 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026172               119.60017475247784
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
15818 15818 IDN Indonesia Wlingi - Brantas WRI1001045 54.0 -8.0776 112.3311 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1026178               179.40026212871678
15819 15819 IDN Indonesia Wonorejo - Pamekasan WRI1001046 6.3 -8.1136 112.2869 Hydro         PLN - Java Bali Generation Unit / PT. PJB Indonesia Power Generation https://repit.wordpress.com/ CARMA 1055424               20.93003058168362

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