global-power-plants
3 rows where country_long = "Russia", owner = "JSC "DVEUK"" and primary_fuel = "Gas"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19455 | 19455 | RUS | Russia | Mini-cogeneration plant "Oceanarium" (Russkiy Island) | WRI1061978 | 13.2 | 43.0048 | 131.9163 | Gas | Oil | 2014.0 | JSC "DVEUK" | EnergyBase (RUS) | https://energybase.ru/power-plant/mini-chp-oceanarium-russkiy-island | EnergyBase (RUS) | 69.51856229565644 | ||||||||||
| 19456 | 19456 | RUS | Russia | Mini-cogeneration plant "Severnaya" (Russky Island) | WRI1061976 | 3.6 | 43.0538 | 131.8868 | Gas | Oil | 2014.0 | JSC "DVEUK" | EnergyBase (RUS) | https://energybase.ru/power-plant/mini-chp-north-russkiy-island | EnergyBase (RUS) | 18.959607898815392 | ||||||||||
| 19457 | 19457 | RUS | Russia | Mini-cogeneration plant "Tsentralnaya" (Russky Island) | WRI1061977 | 33.0 | 43.0367 | 131.8834 | Gas | Oil | 2014.0 | JSC "DVEUK" | EnergyBase (RUS) | https://energybase.ru/power-plant/mini-chp-central-russkiy-island | EnergyBase (RUS) | 173.79640573914108 |
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");