global-power-plants

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

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

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 generation_data_source estimated_generation_gwh
12502 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
12517 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
12690 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
12699 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
12707 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
12750 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
12775 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
12893 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
13011 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
13116 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
13192 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
13273 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
13300 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
13353 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
13377 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
13420 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
13421 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
13429 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
13433 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
13497 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
13522 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
13533 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
13659 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
13668 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
13685 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
13689 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       779.058 766.957 738.915 JRC-PPDB-OPEN 1223.2569785959677
13690 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,
  "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 47.789ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette