home / global-power-plants

Menu
  • GraphQL API

global-power-plants

Table actions
  • GraphQL API for global-power-plants

8 rows where owner = "EDF Energies Nouvelles"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country, capacity_mw, source, url, geolocation_source, wepp_id, year_of_capacity_data, estimated_generation_gwh

primary_fuel 2

  • Solar 4
  • Wind 4

country_long 2

  • Canada 6
  • United Kingdom 2

owner 1

  • EDF Energies Nouvelles · 8 ✖
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
3626 3626 CAN Canada Arnprior Solar CAN0007625 23.4 45.4083 -76.275 Solar         EDF Energies Nouvelles Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 60014 2017             22.495565531588746
3901 3901 CAN Canada Elmsley East / West CAN0007843 24.0 44.8406 -76.0866 Solar         EDF Energies Nouvelles Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 62105 2017             23.072374904193577
4433 4433 CAN Canada Rivière du Moulin 1 CAN0002220 150.0 47.9745 -71.0996 Wind         EDF Energies Nouvelles Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 58349 2016             278.618404786629
4434 4434 CAN Canada Rivière du Moulin 2 CAN0002221 200.0 47.997 -71.056 Wind         EDF Energies Nouvelles Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 58349 2016             371.49120638217204
4578 4578 CAN Canada St. Isidore A CAN0008419 12.0 45.4289 -74.9374 Solar         EDF Energies Nouvelles Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2017             11.536187452096788
4579 4579 CAN Canada St. Isidore B CAN0008420 12.0 45.3637 -74.9092 Solar         EDF Energies Nouvelles Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 62106 2017             11.536187452096788
22321 22321 GBR United Kingdom Burnfoot Hill GBR0002902 30.1 56.2091 -3.7728 Wind         EDF Energies Nouvelles UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1084302               54.61799021922063
22496 22496 GBR United Kingdom Cold Northcott GBR0003511 6.6 50.6455 -4.5467 Wind         EDF Energies Nouvelles UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1023660               11.976037722486913

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 · How this site works · Code of conduct