global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
119 rows where country_long = "United Kingdom" and primary_fuel = "Hydro" sorted by estimated_generation_gwh_2013
This data as json, CSV (advanced)
owner 13
- Scottish and Southern: Hydro Schemes - Tummel 3
- ENGIE 2
- Scottish and Southern Energy (SSE) 2
- Scottish and Southern: Hydro Schemes - Sloy/Awe 2
- First Hydro Company 1
- Magnox Ltd 1
- Powergen 1
- Scottish Power 1
- Scottish Power: Hydro schemes - Cruachan 1
- Scottish Power: Hydro schemes - Galloway 1
- Scottish and Southern: Hydro Schemes - Affric/Beauly 1
- Scottish and Southern: Hydro Schemes - Breadalbane 1
- Scottish and Southern: Hydro Schemes - Great Glen 1
primary_fuel 1
- Hydro · 19 ✖
country_long 1
- United Kingdom · 19 ✖
other_fuel1 0 ✖
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_gwh_2018 | generation_gwh_2019 | generation_data_source | estimated_generation_gwh_2013 ▼ | estimated_generation_gwh_2014 | estimated_generation_gwh_2015 | estimated_generation_gwh_2016 | estimated_generation_gwh_2017 | estimated_generation_note_2013 | estimated_generation_note_2014 | estimated_generation_note_2015 | estimated_generation_note_2016 | estimated_generation_note_2017 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24477 | 24477 | GBR | United Kingdom | Tummel | GBR1000409 | 34.0 | 56.7075 | -4.021 | Hydro | Scottish and Southern: Hydro Schemes - Tummel | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028355 | 103.51 | 75.4 | 155.51 | 95.59 | 94.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
24428 | 24428 | GBR | United Kingdom | Tongland | GBR1000461 | 33.0 | 55.0736 | -4.1408 | Hydro | Scottish Power: Hydro schemes - Galloway | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028382 | 103.54 | 76.97 | 142.34 | 86.57 | 85.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
23597 | 23597 | GBR | United Kingdom | Maentwrog | GBR1000310 | 35.3 | 52.946 | -3.9879 | Hydro | Magnox Ltd | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1024530 | 111.93 | 76.36 | 128.82 | 94.96 | 94.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22662 | 22662 | GBR | United Kingdom | Deanie | GBR1000381 | 38.0 | 57.5167 | -4.9333 | Hydro | Scottish and Southern: Hydro Schemes - Affric/Beauly | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028298 | 123.9 | 97.54 | 138.94 | 105.64 | 105.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
23007 | 23007 | GBR | United Kingdom | Great Glen Scheme | GBR2001012 | 36.0 | 57.2016 | -4.7213 | Hydro | Scottish and Southern Energy (SSE) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 125.72 | 99.41 | 154.99 | 106.54 | 106.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
22959 | 22959 | GBR | United Kingdom | Glenmoriston | GBR1000394 | 37.0 | 57.1971 | -4.8694 | Hydro | Scottish and Southern: Hydro Schemes - Great Glen | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028310 | 129.21 | 102.17 | 159.3 | 109.5 | 109.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22495 | 22495 | GBR | United Kingdom | Clachan | GBR1000401 | 40.0 | 56.3 | -5.5833 | Hydro | Scottish and Southern: Hydro Schemes - Sloy/Awe | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028293 | 132.58 | 93.0 | 170.9 | 112.42 | 107.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
24008 | 24008 | GBR | United Kingdom | Rannoch | GBR1000408 | 45.0 | 56.6333 | -4.3667 | Hydro | Scottish and Southern: Hydro Schemes - Tummel | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028342|1056878 | 137.33 | 100.13 | 206.16 | 126.85 | 125.61 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
23529 | 23529 | GBR | United Kingdom | Lochay | GBR1000384 | 46.0 | 54.9667 | -3.4667 | Hydro | Scottish and Southern: Hydro Schemes - Breadalbane | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028327 | 159.24 | 112.89 | 181.24 | 137.15 | 136.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
24036 | 24036 | GBR | United Kingdom | Rheidol | GBR0003552 | 55.975 | 52.4076 | -3.8772 | Hydro | Powergen | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1025732 | 167.03 | 114.28 | 205.75 | 131.58 | 136.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22517 | 22517 | GBR | United Kingdom | Clunie | GBR1000405 | 61.2 | 57.55 | -2.6167 | Hydro | Scottish and Southern: Hydro Schemes - Tummel | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028294 | 221.29 | 119.75 | 281.41 | 202.13 | 204.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22955 | 22955 | GBR | United Kingdom | Glendoe | GBR0000388 | 100.0 | 57.1437 | -4.6592 | Hydro | Scottish and Southern Energy (SSE) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1059333 | 303.9 | 237.62 | 435.46 | 278.62 | 277.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
24228 | 24228 | GBR | United Kingdom | Sloy | GBR1000404 | 152.5 | 56.2512 | -4.7117 | Hydro | Scottish and Southern: Hydro Schemes - Sloy/Awe | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1028346 | 436.89 | 288.23 | 562.34 | 347.17 | 351.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22892 | 22892 | GBR | United Kingdom | Foyers | GBR2000657 | 300.0 | 57.2618 | -4.4835 | Hydro | GEO | 641.53 | 533.18 | 1099.11 | 538.5 | 659.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||||
22624 | 22624 | GBR | United Kingdom | Cruachan | GBR1000455 | 440.0 | 56.394 | -5.115 | Hydro | Scottish Power: Hydro schemes - Cruachan | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1028366 | 888.52 | 562.47 | 1367.17 | 748.54 | 759.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22625 | 22625 | GBR | United Kingdom | Cruachan | GBR2001140 | 440.0 | 56.4112 | -5.1135 | Hydro | Scottish Power | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 888.52 | 562.47 | 1367.17 | 748.54 | 759.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
22852 | 22852 | GBR | United Kingdom | Ffestiniog | GBR1000152 | 360.0 | 52.9807 | -3.9686 | Hydro | ENGIE | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1017050 | 997.27 | 641.22 | 1120.05 | 795.4 | 793.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22695 | 22695 | GBR | United Kingdom | Dinorwig | GBR2001139 | 1728.0 | 53.1186 | -4.1139 | Hydro | First Hydro Company | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 6614.87 | 3455.69 | 6248.95 | 4686.33 | 4771.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
22694 | 22694 | GBR | United Kingdom | Dinorwig | GBR1000151 | 1800.0 | 53.1181 | -4.1032 | Hydro | ENGIE | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1017049 | 6890.49 | 3599.68 | 6509.32 | 4881.59 | 4969.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 |
Advanced export
JSON shape: default, array, newline-delimited
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_gwh_2018" REAL, "generation_gwh_2019" REAL, "generation_data_source" TEXT, "estimated_generation_gwh_2013" REAL, "estimated_generation_gwh_2014" REAL, "estimated_generation_gwh_2015" REAL, "estimated_generation_gwh_2016" REAL, "estimated_generation_gwh_2017" REAL, "estimated_generation_note_2013" TEXT, "estimated_generation_note_2014" TEXT, "estimated_generation_note_2015" TEXT, "estimated_generation_note_2016" TEXT, "estimated_generation_note_2017" TEXT ); CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long"); CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");