global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

24 rows where country_long = "Germany" and primary_fuel = "Oil"

View and edit SQL

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

primary_fuel

  • Oil · 24

country_long

  • Germany · 24
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
12516 DEU Germany Audorf WRI1005578 87.0 54.2907 9.7228 Oil       1973.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025773               172.67571548821547
12639 DEU Germany Brunsbüttel WRI1005622 254.0 53.8925 9.2011 Oil       1973.0 Vattenfall Europe Generation AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 504.1336980920314
12678 DEU Germany DKW Leinau WRI1005634 11.4 47.9125 10.6117 Oil         Vereinigte Wertach-Elektrizitätswerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1116486               22.626473063973066
12679 DEU Germany DKW Nord WRI1005635 11.4 48.0627 10.4866 Oil       1988.0 Vereinigte Wertach-Elektrizitätswerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1032943               22.626473063973066
12724 DEU Germany EEV WRI1005647 38.0 53.4852 9.9696 Oil       1993.0 Shell Deutschland Oil GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 75.42157687991022
13055 DEU Germany IKS PCK Schwedt WRI1005835 333.5 53.0982 14.2345 Oil         PCK Raffinerie GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024660       1653.142 1526.7079999999999 1575.7579999999998 JRC-PPDB-OPEN 661.9235760381595
13077 DEU Germany Itzehoe WRI1005850 88.0 53.9664 9.4495 Oil       1972.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 174.66049382716048
13092 DEU Germany KW Mittelsbüren WRI1005912 198.0 53.1289 8.6852 Oil         swb Erzeugung GmbH & Co. KG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data         960.0139999999999 1068.632 856.677 JRC-PPDB-OPEN 392.9861111111112
13149 DEU Germany Kraftwerk WRI1005873 66.3 50.8305 6.9594 Oil       1962.0 Basell Polyolefine GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 131.59080387205387
13154 DEU Germany Kraftwerk Fulda WRI1005880 24.8 50.5664 9.6861 Oil       2011.0 RhönEnergie Fulda GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 49.22250280583614
13156 DEU Germany Kraftwerk Hausham WRI1005882 92.8 47.7524 11.8398 Oil       1982.0 Peissenberger Kraftwerksgesellschaft mbH Kraftwerk Hausham Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025366               184.18742985409654
13170 DEU Germany Kraftwerk Walheim WRI1005897 136.0 49.0175 9.1574 Oil       1981.0 EnBW Energie Baden-Württemberg AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1023745       24.941999999999997 17.855 30.68 JRC-PPDB-OPEN 269.9298540965208
13278 DEU Germany MiRO WRI1005947 70.0 49.0608 8.3244 Oil       1995.0 Mineraloelraffinerie Oberrhein GmbH & Co. KG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1098409               138.9344837261504
13285 DEU Germany Moabit (Oil) WRI1005951 51.0 52.5374 13.3461 Oil       1971.0 Vattenfall Europe Wärme Aktiengesellschaft Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010990               101.2236952861953
13449 DEU Germany Raffineriekraftwerk WRI1006012 92.5 51.2998 12.0193 Oil       1997.0 TOTAL Raffinerie Mitteldeutschland GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 183.59199635241302
13450 DEU Germany Raffineriekraftwerk Köln Godorf WRI1006013 80.0 50.8548 6.9808 Oil       2004.0 Steag GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 158.78226711560046
13506 DEU Germany SKW Diesel WRI1006049 10.5 47.6835 10.3191 Oil       1978.0 Allgäuer Ãœberlandwerk GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1116241               20.840172558922557
13507 DEU Germany SKW Natural Gasturbine WRI1006050 24.0 47.6835 10.3191 Oil       1988.0 Allgäuer Ãœberlandwerk GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 47.63468013468013
13579 DEU Germany Spitzenlastanlage Barmen WRI1006051 60.0 51.2689 7.2003 Oil       2008.0 WSW Energie & Wasser AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 119.08670033670036
13580 DEU Germany Spitzenlastkraftwerk Großkayna WRI1006052 120.0 51.2919 11.9465 Oil       1994.0 envia THERM GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data                 238.1734006734007
13581 DEU Germany Spitzenlastkraftwerk Sermuth WRI1006053 17.0 51.1614 12.7815 Oil       1995.0 envia THERM GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1115897               33.7412317620651
13701 DEU Germany Wedel WRI1006131 101.0 53.5663 9.7285 Oil       1972.0 Vattenfall Europe Generation AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data         1175.047 1137.825 913.382 JRC-PPDB-OPEN 200.46261223344558
13731 DEU Germany Wilhelmshaven (Oil) WRI1006144 56.0 53.5658 8.1462 Oil       1973.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025806               111.14758698092031
13733 DEU Germany Wilmersdorf WRI1006145 828.0 52.4816 13.3076 Oil       1977.0 Vattenfall Europe Wärme AG Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010997               1643.3964646464651

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 · Query took 76.645ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette