global-power-plants
5 rows where owner = "JSC "Sibeco""
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19198 | 19198 | RUS | Russia | Barabinskaya TPP | WRI1061814 | 114.0 | 55.4478 | 78.3656 | Coal | JSC "Sibeco" | EnergyBase (RUS) | https://energybase.ru/power-plant/Barabinskaya_CHP | EnergyBase (RUS) | 397.1537842128967 | ||||||||||||
| 19500 | 19500 | RUS | Russia | Novosibirsk CHP-2 | WRI1061813 | 340.0 | 54.9993 | 82.8743 | Coal | JSC "Sibeco" | EnergyBase (RUS) | https://energybase.ru/power-plant/Novosibirsk_CHP-2 | EnergyBase (RUS) | 1184.493742389341 | ||||||||||||
| 19501 | 19501 | RUS | Russia | Novosibirsk CHP-3 | WRI1061824 | 511.5 | 55.0081 | 82.854 | Coal | JSC "Sibeco" | EnergyBase (RUS) | https://energybase.ru/power-plant/Novosibirsk_CHP-3 | EnergyBase (RUS) | 1781.9663212710232 | ||||||||||||
| 19502 | 19502 | RUS | Russia | Novosibirsk CHP-4 | WRI1061823 | 384.0 | 55.1 | 82.9894 | Coal | JSC "Sibeco" | EnergyBase (RUS) | https://energybase.ru/power-plant/Novosibirsk_CHP-4 | EnergyBase (RUS) | 1337.7811678750204 | ||||||||||||
| 19503 | 19503 | RUS | Russia | Novosibirsk TPP-5 | WRI1061822 | 1200.0 | 55.0056 | 83.0606 | Coal | JSC "Sibeco" | EnergyBase (RUS) | https://energybase.ru/power-plant/Novosibirsk_CHP-5 | EnergyBase (RUS) | 4180.566149609439 |
Advanced export
JSON shape: default, array, newline-delimited
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");