global-power-plants

Table actions

55 rows where country_long = "United Kingdom" and primary_fuel = "Gas"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, url, geolocation_source, wepp_id

primary_fuel 1

  • Gas · 55 ✖

country_long 1

  • United Kingdom · 55 ✖
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
21977 21977 GBR United Kingdom Aberthaw GT GBR1000375 51.0 51.3875 -3.4068 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA                 171.61781370022362
22081 22081 GBR United Kingdom Baglan Bay CCGT GBR1000312 520.0 51.6145 -3.8352 Gas         MPF Operations Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 1749.8286887081626
22082 22082 GBR United Kingdom Baglan Bay OCGT GBR1000314 32.3 51.5924 -3.7802 Gas         MPF Operations Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA                 108.69128201014162
22097 22097 GBR United Kingdom Ballylumford B GBR1000003 540.0 54.845 -5.787 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1011302       210.957 176.78900000000002   JRC-PPDB-OPEN 1817.1297921200146
22098 22098 GBR United Kingdom Ballylumford B OCGT GBR1000004 116.0 54.845 -5.787 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1011302         808.166   JRC-PPDB-OPEN 390.34639978874395
22099 22099 GBR United Kingdom Ballylumford C GBR1000001 616.0 54.8428 -5.7853 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1011302               2072.873985085054
22119 22119 GBR United Kingdom Barry GBR2000125 235.0 51.4089 -3.2301 Gas               GEO                 790.7879650892658
22206 22206 GBR United Kingdom Blackburn GBR1000464 59.0 53.75 -2.4833 Gas         Scottish Power: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1048233               198.5382550649646
22396 22396 GBR United Kingdom Carrington GBR2000124 900.0 53.4366 -2.4077 Gas               WRI                 3028.549653533358
22409 22409 GBR United Kingdom Castleford GBR1000113 56.0 53.7259 -1.3626 Gas         E.On UK Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1038549               188.44308955318672
22456 22456 GBR United Kingdom Chippenham GBR1000440 10.0 51.46 -2.1247 Gas         Scottish and Southern: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1053649               33.650551705926205
22512 22512 GBR United Kingdom Connahs Quay GBR1000492 1380.0 53.2317 -3.0815 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1025709               4643.7761354178165
22516 22516 GBR United Kingdom Coolkeeragh GBR1000075 408.0 55.0437 -7.2487 Gas         Coolkeeragh ESB Ltd Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1013277         4.505   JRC-PPDB-OPEN 1372.9425096017892
22517 22517 GBR United Kingdom Coolkeeragh OCGT GBR1000076 53.0 55.0437 -7.2487 Gas         Coolkeeragh ESB Ltd Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB         1263.904 1199.935   JRC-PPDB-OPEN 178.34792404140887
22522 22522 GBR United Kingdom Corby GBR1000077 401.0 52.5104 -0.6814 Gas         Corby Power Ltd Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1013306               1349.3871234076407
22530 22530 GBR United Kingdom Coryton GBR1000211 800.0 51.5119 0.5079 Gas         Intergen Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1013356|1022996               2692.044136474096
22536 22536 GBR United Kingdom Cottam Development Centre GBR1000493 395.0 53.3051 -0.7858 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1064726               1329.196792384085
22546 22546 GBR United Kingdom Cowes GBR1000376 140.0 50.7469 -1.2862 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023587               471.10772388296687
22611 22611 GBR United Kingdom Damhead Creek GBR1000465 805.0 51.4249 0.6014 Gas         Scottish Power: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1038550               2708.8694123270598
22630 22630 GBR United Kingdom Deeside GBR2000262 515.0 53.2332 -3.0547 Gas               GEO                 1733.0034128551993
22645 22645 GBR United Kingdom Didcot B GBR1000369 1470.0 51.6246 -1.2683 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023591               4946.631100771151
22646 22646 GBR United Kingdom Didcot GT GBR1000377 100.0 51.6246 -1.2683 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 336.505517059262
22665 22665 GBR United Kingdom Drax GT GBR1000112 75.0 53.7364 -0.9981 Gas         Drax Power Ltd Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA                 252.37913779444648
22745 22745 GBR United Kingdom Enfield GBR1000494 408.0 51.6625 -0.0225 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1019434               1372.9425096017892
22876 22876 GBR United Kingdom Glanford Brigg GBR2000126 150.0 53.5411 -0.5055 Gas               GEO                 504.75827558889296
22924 22924 GBR United Kingdom Grain GT GBR1000497 56.0 51.4444 0.7114 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1025719               188.44308955318672
22951 22951 GBR United Kingdom Great Yarmouth GBR1000370 420.0 52.5839 1.7338 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1010122               1413.3231716489004
23188 23188 GBR United Kingdom Keadby GT GBR1000443 25.0 53.5944 -0.7504 Gas         Scottish and Southern: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 84.1263792648155
23211 23211 GBR United Kingdom Killingholme GBR1000500 600.0 53.6535 -0.2556 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 2019.0331023555718
23216 23216 GBR United Kingdom Kilroot OCGT GBR1000005 142.0 54.7251 -5.7643 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023937               477.83783422415206
23352 23352 GBR United Kingdom Langage GBR1000073 905.0 50.3882 -4.0118 Gas         Centrica Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1050394               3045.3749293863207
23396 23396 GBR United Kingdom Little Barford GBR1000371 720.0 52.2046 -0.2693 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023602               2422.839722826687
23397 23397 GBR United Kingdom Little Barford GT GBR1000378 17.0 52.2046 -0.2693 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 57.20593790007455
23525 23525 GBR United Kingdom Marchwood GBR1000311 842.0 50.8998 -1.4384 Gas         Marchwood Power Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1052944               2833.3764536389863
23554 23554 GBR United Kingdom Medway GBR1000437 700.0 51.4396 0.6894 Gas         Scottish and Southern: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1022461               2355.538619414834
23795 23795 GBR United Kingdom Pembroke GBR1000372 2180.0 51.685 -4.99 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023612               7335.820271891912
23813 23813 GBR United Kingdom Peterborough GBR2000128 240.0 52.5769 -0.204 Gas               GEO                 807.6132409422288
23815 23815 GBR United Kingdom Peterhead GBR2000723 1180.0 57.4772 -1.7889 Gas               WRI                 3970.765101299292
23890 23890 GBR United Kingdom Ratcliffe GT GBR1000498 34.0 52.8653 -1.255 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA                 114.41187580014908
23938 23938 GBR United Kingdom Rocksavage GBR1000212 810.0 53.3147 -2.7232 Gas         Intergen Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1019722               2725.6946881800227
23979 23979 GBR United Kingdom Rye House GBR1000466 715.0 51.7626 0.0094 Gas         Scottish Power: Thermal Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1025737               2406.0144469737234
23997 23997 GBR United Kingdom Saltend GBR2000263 1200.0 53.735 -0.2432 Gas Cogeneration             WRI                 4038.0662047111437
24000 24000 GBR United Kingdom Sandbach GBR1000114 56.0 53.1623 -2.4037 Gas         E.On UK Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1038548               188.44308955318672
24023 24023 GBR United Kingdom Seabank 1 GBR2000806 812.0 51.5392 -2.67 Gas               GEO                 2732.424798521208
24024 24024 GBR United Kingdom Seabank 2 GBR1000480 410.0 51.5392 -2.67 Gas         Seabank Power Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1028387               1379.6726199429745
24036 24036 GBR United Kingdom Severn Power GBR1000313 850.0 51.5475 -2.975 Gas         MPF Operations Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1063557               2860.2968950037266
24062 24062 GBR United Kingdom Shoreham GBR2000769 420.0 50.8292 -0.2311 Gas               GEO                 1413.3231716489004
24112 24112 GBR United Kingdom South Humber Bank GBR1000074 1310.0 53.6008 -0.1446 Gas         Centrica Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1018950               4408.222273476333
24131 24131 GBR United Kingdom Spalding GBR0006165 880.0 52.773 -0.1441 Gas         SPEP UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2961.2485501215056
24168 24168 GBR United Kingdom Staythorpe C GBR1000373 1772.0 53.073 -0.8585 Gas         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1064569               5962.8777622901225
24207 24207 GBR United Kingdom Sutton Bridge GBR2000518 819.0 52.7579 0.1923 Gas               GEO                 2755.980184715356
24233 24233 GBR United Kingdom Taylor's Lane GT GBR1000499 144.0 51.5459 -0.2575 Gas         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 484.5679445653373
24269 24269 GBR United Kingdom Thornhill GBR1000115 50.0 53.6908 -1.6291 Gas         E.On UK Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes CARMA 1033670               168.252758529631
24423 24423 GBR United Kingdom West Burton CCGT GBR1000141 1332.0 53.3631 -0.7976 Gas         EDF Energy Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 4482.25348722937
24424 24424 GBR United Kingdom West Burton GT GBR1000146 40.0 53.3631 -0.7976 Gas         EDF Energy Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB                 134.60220682370482

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");