global-power-plants

Table actions

33 rows where owner = "Los Angeles Department of Water & Power"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, other_fuel1, commissioning_year, wepp_id, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016, generation_gwh_2017

primary_fuel 5

owner 1

  • Los Angeles Department of Water & Power · 33 ✖

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
24578 24578 USA United States of America 2555 E Olympic Bl USA0057871 1.0 34.0269 -118.2242 Solar       2012.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 1.894 1.341 1.235 1.78 1.35 U.S. Energy Information Administration  
24662 24662 USA United States of America Adelanto Solar Project USA0057305 10.0 34.5508 -117.4353 Solar       2012.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 21.154 19.937 18.18 16.245 17.226 U.S. Energy Information Administration  
24882 24882 USA United States of America Apex Generating Station USA0055514 600.6 36.416 -114.9609 Gas       2003.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48296 2017 430.26599999999996 1653.509 2647.857 3423.755 3137.1020000000003 U.S. Energy Information Administration  
25270 25270 USA United States of America Big Pine Creek USA0000391 3.2 37.1428 -118.3241 Hydro       1925.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25082 2017 3.241 9.526 9.552999999999999 1.484 12.959000000000001 U.S. Energy Information Administration  
25872 25872 USA United States of America Castaic USA0000392 1682.0 34.5872 -118.6566 Hydro       1975.8668252080856 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25083 2017 0.0 0.0 0.0 0.0 356.72 U.S. Energy Information Administration  
26196 26196 USA United States of America Colon PV USA0059798 1.3 33.7927 -118.2524 Solar       2016.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     0.085 2.188 1.761 U.S. Energy Information Administration 0.5778691274752631
26260 26260 USA United States of America Control Gorge USA0000393 37.5 37.4379 -118.557 Hydro       1952.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25085 2017 3.238 2.8310000000000004 9.179 37.04 111.77 U.S. Energy Information Administration  
26327 26327 USA United States of America Cottonwood USA0000394 1.6 36.4434 -118.0439 Hydro       1908.5 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25084 2017 0.532 1.5630000000000002 1.097 1.6130000000000002 4.159 U.S. Energy Information Administration  
27215 27215 USA United States of America Foothill USA0000396 9.9 34.3182 -118.4944 Hydro       1971.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25088 2017 25.424 19.917 3.1860000000000004 31.469 42.693999999999996 U.S. Energy Information Administration  
27229 27229 USA United States of America Forever 21 Retail Inc. USA0059651 1.7 34.0714 -118.1961 Solar       2015.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     2.378 2.2119999999999997 2.222 U.S. Energy Information Administration 0.7556750128522671
27296 27296 USA United States of America Franklin (CA) USA0000397 2.0 34.1039 -118.4134 Hydro       1921.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25089 2017 2.695 -0.004 -0.008 0.0 0.0 U.S. Energy Information Administration  
27798 27798 USA United States of America Haiwee USA0000398 5.6 36.1097 -117.9567 Hydro       1927.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25092 2017 3.343 3.536 -0.083 6.7700000000000005 16.496 U.S. Energy Information Administration  
27837 27837 USA United States of America Harbor USA0000399 548.1 33.7706 -118.2656 Gas Oil Biomass   1998.8633461047248 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 129.46 0.0 0.0 0.0 79.223 U.S. Energy Information Administration  
27916 27916 USA United States of America Haynes USA0000400 1739.1 33.7647 -118.0991 Gas Oil Biomass   1996.744925536197 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25094 2017 3642.018 0.0 0.0 0.0 2853.921 U.S. Energy Information Administration  
28302 28302 USA United States of America Intermountain Power Project USA0006481 1640.0 39.5097 -112.5802 Coal       1986.5 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23182 2017 12387.224297 12369.825964999998 10860.909184 8403.849998 8413.931945999999 U.S. Energy Information Administration  
28932 28932 USA United States of America Linden Wind Energy Project USA0057635 50.0 45.7442 -120.7836 Wind       2010.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60969 2017 149.226 147.475 132.595 142.458 119.098 U.S. Energy Information Administration  
29122 29122 USA United States of America Maclay Solar Project USA0057308 2.2 34.3197 -118.4308 Solar       2017.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         3.675 U.S. Energy Information Administration 0.9779323695735224
29424 29424 USA United States of America Middle Gorge USA0000401 37.5 37.51 -118.5692 Hydro       1952.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25095 2017 37.345 22.081999999999997 0.278 21.16 143.04 U.S. Energy Information Administration  
29927 29927 USA United States of America Nordhoff Place USA0059652 1.2 34.2367 -118.5658 Solar       2014.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017   0.332 1.837 1.765 1.6769999999999998 U.S. Energy Information Administration  
29954 29954 USA United States of America North Hollywood USA0057854 9.0 34.1944 -118.3903 Hydro       1993.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 2.92 0.0 0.0 0.0 0.0 U.S. Energy Information Administration  
30064 30064 USA United States of America Occidental College Solar Project USA0057311 1.0 34.1283 -118.2069 Solar       2013.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 66802 2017 1.5659999999999998 1.811 1.796 1.858 1.848 U.S. Energy Information Administration  
30232 30232 USA United States of America Owens Valley Solar Project 11 USA0060953 1.0 36.2751 -118.0122 Solar       2017.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017       0.115 2.93 U.S. Energy Information Administration 0.4445147134425101
30291 30291 USA United States of America Pacific Cruise Ship Terminals Berth 93 USA0057309 1.1 33.7331 -118.2772 Solar       2010.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 1.605 1.589   0.0 0.306 U.S. Energy Information Administration  
30506 30506 USA United States of America Pine Tree Solar Project USA0057306 8.5 35.2296 -118.1957 Solar       2013.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50746 2017 13.573 16.675 10.329 11.443 14.732999999999999 U.S. Energy Information Administration  
30507 30507 USA United States of America Pine Tree Wind Power Project USA0056433 135.0 35.248 -118.1754 Wind       2009.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50746 2017 273.943 283.265 122.352 141.609 256.08799999999997 U.S. Energy Information Administration  
30566 30566 USA United States of America Pleasant Valley Hydro USA0000402 3.2 37.4142 -118.5239 Hydro       1958.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25096 2017 3.815 2.018 0.318 3.424 13.573 U.S. Energy Information Administration  
30614 30614 USA United States of America Port of LA Solar FiT Project USA0061319 1.1 33.728 -118.28 Solar       2015.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33019 2017       0.0 1.8659999999999999 U.S. Energy Information Administration 0.4889661847867612
31282 31282 USA United States of America San Fernando USA0000403 5.6 34.3128 -118.4928 Hydro       1922.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25097 2017 0.648 -0.027999999999999997 1.24 0.682 21.678 U.S. Energy Information Administration  
31283 31283 USA United States of America San Francisquito 1 USA0006479 69.3 34.5902 -118.4547 Hydro       1967.2886002886005 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25101 2017 47.25899999999999 39.849 16.000999999999998 68.807 278.94100000000003 U.S. Energy Information Administration  
31284 31284 USA United States of America San Francisquito 2 USA0006480 42.0 34.5343 -118.5251 Hydro       1924.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 1.654 2.4819999999999998 2.609 1.12 94.41 U.S. Energy Information Administration  
31359 31359 USA United States of America Scattergood USA0000404 875.9999999999999 33.9182 -118.4276 Gas Biomass     1994.1342465753428 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25100 2017 1199.06296 1133.91201 1278.1200199999998 1419.960001 2002.670002 U.S. Energy Information Administration  
32491 32491 USA United States of America Upper Gorge USA0000407 37.5 37.546 -118.59 Hydro       1953.0 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25102 2017 43.526 27.323 0.238 31.15 134.56 U.S. Energy Information Administration  
32536 32536 USA United States of America Valley (CA) USA0000408 690.5 34.245 -118.3913 Gas Oil Biomass   2002.8247646632874 Los Angeles Department of Water & Power U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 926.921 0.0 0.0 0.0 1477.2720000000004 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");