global-power-plants

Table actions

16 rows where owner = "Kansai"

✎ View and edit SQL

This data as json, CSV (advanced)

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

primary_fuel 4

owner 1

  • Kansai · 16 ✖

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
16480 16480 JPN Japan Aioi WRI1000657 1125.0 34.7742 134.4568 Oil         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020382               2968.920698455582
16483 16483 JPN Japan Ako WRI1000656 1200.0 34.7413 134.3786 Oil         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020384               3166.8487450192883
16525 16525 JPN Japan Gobo WRI1000650 1800.0 33.86 135.1531 Oil         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020392               4750.273117528933
16553 16553 JPN Japan Himeji Daiichi WRI1000654 1442.0 34.7734 134.694 Gas         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020397|1020398               11371.783688059551
16554 16554 JPN Japan Himeji Daini WRI1000653 1650.0 34.7734 134.694 Gas         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020399               13012.096453050117
16609 16609 JPN Japan Kainan WRI1000648 2100.0 34.152 135.1876 Oil         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020408               5541.985303783755
16649 16649 JPN Japan Kisenyama WRI1000713 466.0 34.8806 135.8463 Hydro         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020419               1476.5469587084078
16697 16697 JPN Japan Mihama WRI1000682 826.0 35.7024 135.9634 Nuclear         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB                 0.0
16739 16739 JPN Japan Nanko WRI1000651 1800.0 34.6177 135.4048 Gas         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020436               14195.014312418303
16770 16770 JPN Japan Ohi WRI1000684 4710.0 35.5424 135.6544 Nuclear         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020441               0.0
16778 16778 JPN Japan Okawachi WRI1000711 1280.0 35.1306 134.7108 Hydro         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020442               4055.751302890047
16784 16784 JPN Japan Okutataragi WRI1000710 1932.0 35.2406 134.8617 Hydro         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020443               6121.649622799666
16786 16786 JPN Japan Okuyoshino WRI1000712 1206.0 34.1178 135.8211 Hydro         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020444               3821.2781806917155
16825 16825 JPN Japan Sakaiko WRI1000649 2000.0 34.5704 135.4417 Gas         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ WRI 1077566               15772.23812490923
16895 16895 JPN Japan Takahama WRI1000683 3392.0 35.5223 135.5036 Nuclear         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB 1020472               0.0
16911 16911 JPN Japan Tanagawa Daini WRI1000655 1200.0 34.3216 135.1281 Oil         Kansai Japanese Electric Power Information Center https://www.jepic.or.jp/en/ GEODB                 3166.8487450192883

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