global-power-plants

Table actions

3 rows where owner = "Hoang Anh Gia Lai JSC."

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

owner 1

  • Hoang Anh Gia Lai JSC. · 3 ✖

country_long 1

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
33449 33449 VNM Vietnam Dak Srong 2 WRI1030823 24.0 13.6786 108.5649 Hydro       2010.0 Hoang Anh Gia Lai JSC. Open Development Vietnam https://data.opendevelopmentmekong.net/vi/library_record/dak-srong-2-hydropower Open Development Vietnam 1078799         85.8   Open Development Vietnam 83.88348958125
33450 33450 VNM Vietnam Dak Srong 3A WRI1030821 10.0 13.3473 108.5323 Hydro       2014.0 Hoang Anh Gia Lai JSC. Open Development Vietnam https://data.opendevelopmentmekong.net/vi/library_record/dak-srong-3a-hydropower Open Development Vietnam 1080446|1100704         37.0   Open Development Vietnam 34.9514539921875
33451 33451 VNM Vietnam Dak Srong 3B WRI1030820 20.0 13.3381 108.5587 Hydro       2012.0 Hoang Anh Gia Lai JSC. Open Development Vietnam https://data.opendevelopmentmekong.net/vi/library_record/dak-srong-3b-hydropower Open Development Vietnam 1093344|1080446|1100704         75.0   Open Development Vietnam 69.902907984375

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