global-power-plants

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

12 rows where country_long = "United Kingdom" and owner = "INRG Solar"

View and edit SQL

Suggested facets: capacity_mw, estimated_generation_gwh

primary_fuel

owner

  • INRG Solar · 12

country_long

  • United Kingdom · 12

other_fuel1

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
18846 GBR United Kingdom Combermere Abbey GBR0001478 14.0 52.9994 -2.5962 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               6.999051257000098
19253 GBR United Kingdom Grange Farm GBR0001931 6.0 50.7131 -1.26 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101501|1109211             2.9995933958571857
19369 GBR United Kingdom Hendre Fawr Farm GBR0002286 11.6 51.7409 -3.5913 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               5.799213898657224
19507 GBR United Kingdom Kellygreen Farm GBR0001428 4.0 50.5629 -4.7479 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               1.999728930571457
19588 GBR United Kingdom Land East Of Wadbrook Farm GBR0005131 5.0 50.8117 -2.959 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               2.499661163214321
19601 GBR United Kingdom Land Parcel North of Goddards GBR0005140 5.0 50.977 -0.1684 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               2.499661163214321
19650 GBR United Kingdom Land between Orton Park Farm GBR0005330 6.4 54.8753 -2.9876 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               3.199566288914331
19778 GBR United Kingdom Lower Basset Down Farm GBR0001850 10.5 51.5245 -1.7914 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               5.249288442750076
19823 GBR United Kingdom Manor Farm (Dorset) GBR0001904 5.0 51.0541 -2.3179 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               2.499661163214321
19970 GBR United Kingdom New Stone House GBR0002045 12.5 51.868 -1.1824 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               6.249152908035803
20638 GBR United Kingdom Turweston Solar Farm GBR0002081 16.7 52.0328 -1.1053 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               8.348868285135833
20719 GBR United Kingdom West Hall Solar Farm GBR0002359 7.0 51.3949 -3.4049 Solar         INRG Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101416             3.4995256285000496

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