global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

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 estimated_generation_gwh
10902 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
11000 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
11024 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
11025 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
11058 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
11316 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.086   661.9235760381595
11337 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
11346 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           952.645   392.9861111111112
11392 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
11397 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
11399 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
11413 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.82   269.9298540965208
11477 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
11482 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
11601 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
11602 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
11650 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
11651 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
11702 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
11703 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
11704 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
11792 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               200.46261223344558
11816 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
11818 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,
  "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 104.964ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute