global-power-plants

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

12 rows where owner = "Pattern Operators LP" and primary_fuel = "Wind"

View and edit SQL

Suggested facets: capacity_mw, commissioning_year, wepp_id

primary_fuel

  • Wind · 12

owner

  • Pattern Operators LP · 12

country_long

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
21789 USA United States of America Broadview Energy JN LLC USA0060145 181.7 34.7342 -103.108 Wind       2017.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         427.901 32.234952905499064
21790 USA United States of America Broadview Energy KW LLC USA0060152 142.6 34.727 -103.1668 Wind       2017.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         316.48 25.29831747013851
23569 USA United States of America Fowler Ridge IV Wind Farm LLC USA0059547 150.0 40.6206 -87.3781 Wind       2016.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55877 2017       433.92 458.91 26.611133383736163
24180 USA United States of America Hatchet Ridge Wind Project USA0056654 101.2 40.8981 -121.8036 Wind       2011.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59026 2017 280.223 295.512 266.264 287.24 292.43  
25265 USA United States of America Logans Gap Wind LLC USA0059442 200.1 31.8225 -98.6906 Wind       2015.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     256.689 709.4300000000002 655.742 35.499251933904034
25308 USA United States of America Lost Creek Wind Energy Facility USA0057189 150.0 39.9814 -94.5181 Wind       2010.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59661 2017 446.019 448.888 410.171 418.07 416.218  
26361 USA United States of America Ocotillo Express LLC USA0057514 265.4 32.7528 -116.0447 Wind       2013.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63043 2017 334.452 566.5980000000001 537.525 530.9780000000002 541.953  
26654 USA United States of America Pattern Gulf Wind USA0056661 283.2 27.0011 -97.5994 Wind       2009.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 57924 2017 811.6560000000002 717.4739999999999 641.447 681.2310000000001 768.732  
26655 USA United States of America Pattern Panhandle Wind 2 LLC USA0058720 181.7 35.4428 -101.3728 Wind       2014.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 67283 2017   116.806 787.638 838.533 788.585  
26656 USA United States of America Pattern Panhandle Wind LLC USA0058242 218.0 35.4275 -101.2531 Wind       2014.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 67283 2017   353.175 751.318 822.2639999999999 768.069  
26916 USA United States of America Post Rock Wind Power Project LLC USA0057678 201.0 38.8417 -98.2994 Wind       2012.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 62821 2017 855.914 844.7189999999999 780.778 761.5600000000002 780.674  
28088 USA United States of America Spring Valley Wind Project USA0057192 150.0 39.1042 -114.4922 Wind       2012.0 Pattern Operators LP U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55780 2017 250.549 300.134 309.724 343.865 361.364  

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