global-power-plants

Table actions

6 rows where owner = "Aegis Renewables LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

owner 1

  • Aegis Renewables LLC · 6 ✖

country_long 1

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
26181 26181 USA United States of America Cold Springs Windfarm USA0057431 23.0 43.0281 -115.4005 Wind       2013.0 Aegis Renewables LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69090 2017 48.986 53.793 44.365 53.61600000000001 46.57899999999999 U.S. Energy Information Administration  
26619 26619 USA United States of America Desert Meadow Windfarm USA0057430 23.0 43.0566 -115.452 Wind       2013.0 Aegis Renewables LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69091 2017 55.718 62.68 51.328 61.81399999999999 53.086000000000006 U.S. Energy Information Administration  
27816 27816 USA United States of America Hammett Hill Windfarm USA0057428 23.0 43.0061 -115.4633 Wind       2013.0 Aegis Renewables LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69092 2017 54.349 60.61 50.49100000000001 60.593999999999994 53.162 U.S. Energy Information Administration  
29152 29152 USA United States of America Mainline Windfarm USA0057429 23.0 43.0483 -115.4129 Wind       2013.0 Aegis Renewables LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69093 2017 52.669 59.18400000000001 48.256 58.88 50.836999999999996 U.S. Energy Information Administration  
31138 31138 USA United States of America Ryegrass Windfarm USA0057427 23.0 43.0371 -115.4397 Wind       2013.0 Aegis Renewables LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 49.467 56.391999999999996 46.727 57.037 48.92 U.S. Energy Information Administration  
32400 32400 USA United States of America Two Ponds Windfarm USA0057444 23.0 43.0338 -115.4826 Wind       2013.0 Aegis Renewables LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69095 2017 56.631 62.355 51.30900000000001 62.172 54.107 U.S. Energy Information Administration  

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