global-power-plants

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

20 rows where country_long = "Poland", owner = "PGE" and primary_fuel = "Hydro"

View and edit SQL

Suggested facets: capacity_mw, commissioning_year, source, url, estimated_generation_gwh

primary_fuel

  • Hydro · 20

owner

  • PGE · 20

country_long

  • Poland · 20
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
15247 POL Poland Dobrzeń WRI1061533 2.0 50.7558 17.8332 Hydro       2008.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Dobrzen University of Dąbrowa Górnicza               2.6313763233878733
15249 POL Poland Dychów WRI1061534 88.0 51.9886 15.0541 Hydro       1936.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Dychow University of Dąbrowa Górnicza               115.78055822906641
15250 POL Poland Dębe WRI1061532 21.0 52.4882 20.9237 Hydro       1963.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Debe University of Dąbrowa Górnicza               27.629451395572662
15377 POL Poland Gorzupia II WRI1061535 2.0 51.736 15.2584 Hydro       1998.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Gorzupia-II University of Dąbrowa Górnicza               2.6313763233878733
15378 POL Poland Grajówka WRI1061536 3.0 51.6725 15.2919 Hydro       1922.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Grajowka University of Dąbrowa Górnicza               3.9470644850818086
15379 POL Poland Gubin WRI1061537 1.0 51.9518 14.7215 Hydro       1905.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Gubin University of Dąbrowa Górnicza               1.3156881616939369
15380 POL Poland Januszkowice WRI1061538 2.0 50.3905 18.1133 Hydro       2003.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Januszkowice University of Dąbrowa Górnicza               2.6313763233878733
15387 POL Poland Krapkowice WRI1061539 2.0 50.4712 17.9809 Hydro       2007.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Krapkowice University of Dąbrowa Górnicza               2.6313763233878733
15388 POL Poland Krępna WRI1061540 2.0 50.4483 17.9577 Hydro       2004.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Krepna University of Dąbrowa Górnicza               2.6313763233878733
15391 POL Poland Myczkowice WRI1061541 8.0 49.432 22.4014 Hydro       1961.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Myczkowce University of Dąbrowa Górnicza               10.525505293551493
15397 POL Poland Oława WRI1061542 4.0 50.9374 17.3401 Hydro         PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Olawa University of Dąbrowa Górnicza               5.262752646775747
15401 POL Poland Porąbka WRI1061543 13.0 49.8069 19.2023 Hydro       1953.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Porabka University of Dąbrowa Górnicza               17.103946102021172
15409 POL Poland Raduszec Stary WRI1061544 3.0 52.0293 15.0719 Hydro       1935.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Raduszec-Stary University of Dąbrowa Górnicza               3.9470644850818086
15410 POL Poland Rakowice WRI1061545 2.0 51.1294 15.5766 Hydro       2005.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Rakowice University of Dąbrowa Górnicza               2.6313763233878733
15413 POL Poland Smardzewice WRI1061546 4.0 51.4739 20.0061 Hydro       1973.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Smardzewice University of Dąbrowa Górnicza               5.262752646775747
15414 POL Poland Solina WRI1019065 198.0 49.3959 22.4541 Hydro       1968.0 PGE ENTSOE https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show University of Dąbrowa Górnicza 1033798             260.5062560153994
15420 POL Poland Tresna WRI1061547 21.0 49.7479 19.2063 Hydro       1966.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Tresna University of Dąbrowa Górnicza               27.629451395572662
15424 POL Poland Zielisko WRI1061548 2.0 51.6218 14.764 Hydro       1933.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Zielisko University of Dąbrowa Górnicza               2.6313763233878733
15428 POL Poland Żagań II WRI1061549 2.0 51.6154 15.3168 Hydro       1963.0 PGE PGE Energia Odnawialna https://pgeeo.pl/Nasze-obiekty/Elektrownie-wodne/Zagan-II University of Dąbrowa Górnicza               2.6313763233878733
15429 POL Poland Żarnowiec WRI1019043 716.0 54.7224 18.0825 Hydro       1983.0 PGE ENTSOE https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show University of Dąbrowa Górnicza 1015458       341.332     942.0327237728584

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