global-power-plants

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

27 rows where owner = "E.ON Kraftwerke GmbH" and primary_fuel = "Hydro"

View and edit SQL

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

primary_fuel

  • Hydro · 27

owner

  • E.ON Kraftwerke GmbH · 27

country_long

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
10891 DEU Germany Altheim WRI1005575 17.8 51.5365 14.3829 Hydro       1951.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024984             45.362446289600456
10903 DEU Germany Aufkirchen WRI1005579 27.0 48.3067 11.8588 Hydro       1924.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data               68.80820504602316
11036 DEU Germany Dessau WRI1005628 10.3 47.7393 10.8257 Hydro       1967.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data               26.249055999038468
11041 DEU Germany Dingolfing WRI1005632 15.0 48.634 12.4837 Hydro       1957.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024985             38.226780581123975
11045 DEU Germany Dornau WRI1005637 16.6 47.8002 10.9026 Hydro       1960.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010826             42.30430384311054
11079 DEU Germany Eitting WRI1005654 26.0 48.3586 11.8822 Hydro       1925.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data               66.25975300728156
11102 DEU Germany Ettling WRI1005670 12.6 48.6961 12.7978 Hydro       1988.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024986             32.11049568814414
11182 DEU Germany Gummering WRI1005725 14.8 48.6225 12.398 Hydro       1957.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024988             37.71709017337565
11284 DEU Germany Hemfurth WRI1005764 40.0 51.1671 9.0468 Hydro       1915.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025783             101.93808154966395
11367 DEU Germany Kaufering WRI1005855 16.7 48.084 10.8649 Hydro       1975.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data               42.559149046984686
11423 DEU Germany Landau WRI1005929 12.6 48.6679 12.66 Hydro       1984.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data               32.11049568814414
11473 DEU Germany Merching WRI1005939 12.0 48.2704 10.9773 Hydro       1978.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010835             30.581424464899182
11490 DEU Germany Mühltal WRI1005956 11.2 47.9963 11.4854 Hydro       1924.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1019816             28.542662833905908
11526 DEU Germany Niederaichbach WRI1005978 16.2 48.6039 12.3023 Hydro       1951.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024990             41.28492302761389
11542 DEU Germany Obernach WRI1005987 12.8 47.5547 11.2914 Hydro       1955.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010855             32.620186095892464
11578 DEU Germany Pfrombach WRI1006000 22.3 48.4413 11.9923 Hydro       1929.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010856             56.83048046393765
11579 DEU Germany Pielweichs WRI1006002 12.6 49.7943 10.1813 Hydro       1994.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1024991             32.11049568814414
11586 DEU Germany Prem WRI1006004 19.2 47.6927 10.7976 Hydro       1971.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010837             48.9302791438387
11587 DEU Germany Prittriching WRI1006005 12.1 48.2106 10.9049 Hydro       1984.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010838             30.83626966877334
11642 DEU Germany Roßhaupten WRI1006034 45.5 47.6515 10.7355 Hydro       1954.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010839             115.95456776274273
11662 DEU Germany Scheuring WRI1006040 12.2 48.1802 10.8833 Hydro       1980.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010840             31.091114872647506
11670 DEU Germany Schwabstadl WRI1006043 12.0 48.1484 10.867 Hydro       1981.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010841             30.581424464899182
11759 DEU Germany Unterbergen WRI1006112 12.4 48.2374 10.9272 Hydro       1983.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010843             31.60080528039582
11767 DEU Germany Urspring WRI1006120 10.1 47.716 10.8258 Hydro       1966.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010844             25.739365591290145
11780 DEU Germany Walchensee WRI1006126 124.0 47.6314 11.3371 Hydro       1924.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1010860             316.0080528039582
11783 DEU Germany Waldeck 2 WRI1006127 480.0 51.1671 9.0468 Hydro       1974.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025803         778.2769999999999   1223.2569785959677
11784 DEU Germany Waldeck1/Bringhausen WRI1006128 143.0 51.1671 9.0468 Hydro       1931.0 E.ON Kraftwerke GmbH Open Power System Data http://data.open-power-system-data.org/ Open Power System Data 1025803             364.4286415400486

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 73.924ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute