global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

10 rows where primary_fuel = "Wave and Tidal" sorted by owner

View and edit SQL

country_long

primary_fuel

  • Wave and Tidal · 10
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
11815 FRA France RANCE WRI1002761 240.0 48.618 -2.022 Wave and Tidal           RTE Transmission Operator http://clients.rte-france.com/lang/an/visiteurs/vie/prod/parc_reference.jsp GEODB 1015026                
23162 GBR United Kingdom Inner Sound Phase 1A (MeyGen) GBR0002436 6.0 58.7418 -3.116 Wave and Tidal         Atlantis Resources UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                  
22770 GBR United Kingdom Fall of Warness Tidal Demonstrator (EMEC) GBR0002402 2.0 59.1399 -2.8057 Wave and Tidal         Bluewater Energy Services/ Scotrenewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                  
23007 GBR United Kingdom Hammerfest (EMEC) GBR0002420 1.0 58.9628 -3.4937 Wave and Tidal         Hamerfest Strom/SPR UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1091796                
20105 KOR South Korea Sihwa Lake Tidal Power Plant WRI1029923 254.0 37.3142 126.6136 Wave and Tidal         Korea Water Resources Corporation Korea Water Resources Corporation http://english.kwater.or.kr/eng/busi/project03Page.do?s_mid=1192 WRI 1056654                
24022 GBR United Kingdom SeaGen Tidal Farm GBR0002403 1.2 54.3518 -5.539 Wave and Tidal         Marine Current Turbines (MCT) UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1064859                
3619 CAN Canada Annapolis Tidal CAN0007618 20.0 44.753 -65.5119 Wave and Tidal         Nova Scotia Power Inc Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28521 2017              
22754 GBR United Kingdom European Marine Energy Centre (EMEC) GBR0002452 1.0 58.7329 -3.3248 Wave and Tidal         Scottish Power/CRE Energy/Wello UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                  
24249 GBR United Kingdom The Fall of Warness Tidal Scheme (EMEC) GBR0002411 4.0 59.1399 -2.8057 Wave and Tidal         Tocardo/OpenHydro UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                  
23036 GBR United Kingdom Hayle Wave Hub (Test Site) GBR0002457 23.0 50.205 -5.4423 Wave and Tidal         Wave Hub UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                  

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 · Query took 3583.911ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette