home / global-power-plants

Menu
  • GraphQL API

global-power-plants

Table actions
  • GraphQL API for global-power-plants

8 rows where country_long = "Russia" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, estimated_generation_gwh

owner 6

  • PJSC "TGC-1" 2
  • Salekhardenergo JSC 2
  • Ivanovo branch of PJSC "T Plus" 1
  • JSC "SAKHALINENERGO" 1
  • OAO Kaliningrad Generation Company 1
  • PJSC "RusHydro" 1

primary_fuel 1

  • Oil · 8 ✖

country_long 1

  • Russia · 8 ✖
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
19271 19271 RUS Russia DAL about Valaam WRI1061717 2.0 61.395 30.9483 Oil         PJSC "TGC-1" EnergyBase (RUS) https://energybase.ru/power-plant/DES_island_Valaam EnergyBase (RUS)                 216.06944584637122
19277 19277 RUS Russia Diesel power station №1 of JSC "Salekhardenergo" WRI1062125 33.4 66.5567 66.5757 Oil         Salekhardenergo JSC EnergyBase (RUS) https://energybase.ru/power-plant/diesel-pp-1-slenergo EnergyBase (RUS)                 3608.3597456344
19278 19278 RUS Russia Diesel power station №2 of JSC "Salekhardenergo" WRI1062126 12.5 66.5527 66.5811 Oil         Salekhardenergo JSC EnergyBase (RUS) https://energybase.ru/power-plant/diesel-pp-2-slenergo EnergyBase (RUS)                 1350.4340365398205
19368 19368 RUS Russia Ivanovo TPP-1 WRI1061748 12.0 57.0325 40.9411 Oil       1928.0 Ivanovo branch of PJSC "T Plus" EnergyBase (RUS) https://energybase.ru/power-plant/Ivanovo_CHP-1 EnergyBase (RUS)                 1296.4166750782276
19460 19460 RUS Russia Murmansk TEZ WRI1061648 12.0 68.9581 33.0592 Oil       1934.0 PJSC "TGC-1" EnergyBase (RUS) https://energybase.ru/power-plant/Murmanskaya_CHP EnergyBase (RUS)                 1296.4166750782276
19490 19490 RUS Russia Novikovskaya Diesel Power Plant WRI1061801 4.8 46.368 143.353 Oil         JSC "SAKHALINENERGO" EnergyBase (RUS) https://energybase.ru/power-plant/DES_Novikovskaya EnergyBase (RUS)                 518.566670031291
19522 19522 RUS Russia Ozernovskaya Diesel Power Plant WRI1061704 1.57 51.4914 156.5064 Oil         PJSC "RusHydro" EnergyBase (RUS) https://energybase.ru/power-plant/DES_Ozernovo EnergyBase (RUS)                 169.61451498940144
19606 19606 RUS Russia Svetlovskaya GRES-2 WRI1061839 20.8 54.6644 20.1241 Oil         OAO Kaliningrad Generation Company EnergyBase (RUS) https://energybase.ru/power-plant/Svetlovskaya_TPP-2 EnergyBase (RUS)                 2247.1222368022613

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");
Powered by Datasette · How this site works · Code of conduct