global-power-plants

Table actions

11 rows where owner = "Turlock Irrigation District"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year

primary_fuel 3

owner 1

  • Turlock Irrigation District · 11 ✖

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
24763 24763 USA United States of America Almond Power Plant USA0007315 223.5 37.5744 -120.985 Gas       2008.456375838926 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35099 2017 161.12 217.636 196.88299999999998 111.90100000000001 182.09799999999998 U.S. Energy Information Administration  
26697 26697 USA United States of America Don Pedro USA0000439 170.8 37.696 -120.4202 Hydro       1974.614754098361 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35101 2017 250.13 155.81799999999998 145.186 224.07 563.347 U.S. Energy Information Administration  
27294 27294 USA United States of America Frankenheimer Power Plant USA0050219 5.3 37.8304 -120.807 Hydro       1983.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33066 2017 14.814 12.714 11.53 9.502 10.16 U.S. Energy Information Administration  
27979 27979 USA United States of America Hickman USA0000162 1.0 37.6215 -120.7462 Hydro       1979.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35102 2017 3.785 2.8569999999999998 2.481 3.36 3.852 U.S. Energy Information Administration  
28714 28714 USA United States of America La Grange USA0000440 4.5 37.6697 -120.4436 Hydro       1925.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35103 2017 9.501 7.657 7.917999999999999 9.54 5.5440000000000005 U.S. Energy Information Administration  
32364 32364 USA United States of America Tuolumne Wind Project USA0056702 136.3 45.8797 -120.8072 Wind       2009.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55492 2017 367.223 387.12699999999995 333.606 386.31699999999995 339.731 U.S. Energy Information Administration  
32369 32369 USA United States of America Turlock Lake USA0000161 3.3000000000000003 37.6115 -120.5947 Hydro       1980.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35105 2017 7.486000000000001 -0.059 -0.059 0.018000000000000002 5.12 U.S. Energy Information Administration  
32489 32489 USA United States of America Upper Dawson USA0000489 4.4 37.6508 -120.4706 Hydro       1983.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35104 2017 10.147 6.86 6.093 7.654 10.767999999999999 U.S. Energy Information Administration  
32708 32708 USA United States of America Walnut USA0004256 49.8 37.4903 -120.9044 Gas Oil     1986.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 57754 2017 0.0 0.0 0.0 -0.16200000000000006 0.307 U.S. Energy Information Administration  
32710 32710 USA United States of America Walnut Energy Center USA0056078 300.6 37.4878 -120.8956 Gas       2006.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35106 2017 1409.497 1468.6750000000004 1576.1270000000002 1205.595 1124.2330000000004 U.S. Energy Information Administration  
33168 33168 USA United States of America Woodward Power Plant USA0050218 2.8 37.8607 -120.8792 Hydro       1982.0 Turlock Irrigation District U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33067 2017 4.9430000000000005 3.241 1.454 2.359 3.065 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");