global-power-plants

Table actions

8 rows where owner = "California Dept. of Water Resources"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

owner 1

  • California Dept. of Water Resources · 8 ✖

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
24698 24698 USA United States of America Alamo USA0000905 19.6 34.8158 -118.6867 Hydro       1986.0 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15328 2017 22.048 19.265 23.88 67.0 104.37200000000001 U.S. Energy Information Administration  
26634 26634 USA United States of America Devil Canyon USA0000436 276.2 34.2056 -117.3344 Hydro       1984.9891383055758 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15330 2017 572.178 216.054 267.055 876.7769999999999 1496.8929999999998 U.S. Energy Information Administration  
26876 26876 USA United States of America Edward C Hyatt USA0000437 644.1 39.543 -121.4922 Hydro       1968.3033690420739 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15331 2017 1489.571 652.5880000000001 572.227 1703.427 2375.487 U.S. Energy Information Administration  
29540 29540 USA United States of America Mojave Siphon USA0007072 32.7 34.3074 -117.3235 Hydro       1996.0 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15333 2017 42.0 10.933 15.999 62.37600000000001 99.243 U.S. Energy Information Administration  
32213 32213 USA United States of America Thermalito USA0000438 115.1 39.5149 -121.6301 Hydro       1968.0 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15335 2017 0.0 0.0       U.S. Energy Information Administration  
32214 32214 USA United States of America Thermalito Diverson Dam USA0007129 3.4 39.5287 -121.5464 Hydro       1987.0 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15336 2017 16.184 19.459 19.947 20.320999999999998 12.982 U.S. Energy Information Administration  
32640 32640 USA United States of America W E Warne USA0006196 74.2 34.6853 -118.7881 Hydro       1982.5 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15337 2017 385.412 180.578 270.28000000000003 287.46 293.222 U.S. Energy Information Administration  
32646 32646 USA United States of America W R Gianelli USA0000448 424.0 37.0692 -121.0772 Hydro       1967.25 California Dept. of Water Resources U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15332 2017 5.507000000000001 -142.409 -26.449 -317.173 43.67 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");