global-power-plants

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

62 rows where owner = "Southern California Edison Co"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, estimated_generation_gwh

primary_fuel

owner

  • Southern California Edison Co · 62 ✖

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
21380 21380 USA United States of America Barre Peaker USA0056474 49.8 33.8073 -117.9832 Gas       2007.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 51623 2017 16.282 29.409000000000002 33.129 28.75 33.132  
21545 21545 USA United States of America Big Creek 1 USA0000317 88.4 37.2042 -119.2396 Hydro       1919.6787330316745 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33113 2017 210.49900000000002 151.124 52.32899999999999 282.18 499.68800000000005  
21546 21546 USA United States of America Big Creek 2 USA0000318 66.6 37.2 -119.3069 Hydro       1918.7297297297296 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33112 2017 200.826 140.967 51.79 332.639 438.835  
21547 21547 USA United States of America Big Creek 2A USA0000322 110.0 37.2001 -119.3068 Hydro       1928.5 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33110 2017 217.742 207.24900000000002 111.803 359.244 206.074  
21548 21548 USA United States of America Big Creek 3 USA0000319 174.5 37.1485 -119.3866 Hydro       1940.080229226361 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33115 2017 465.038 302.9290000000001 176.81099999999998 763.3720000000002 1071.415  
21549 21549 USA United States of America Big Creek 4 USA0000320 100.0 37.139 -119.4898 Hydro       1951.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33117 2017 221.66 133.078 76.577 378.638 631.388  
21550 21550 USA United States of America Big Creek 8 USA0000321 75.0 37.2096 -119.3289 Hydro       1925.8 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33116 2017 121.044 105.736 42.165 212.77200000000002 369.509  
21587 21587 USA United States of America Bishop Creek 2 USA0000323 7.3 37.2736 -118.5733 Hydro       1908.945205479452 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33119 2017 21.013 15.118 12.554 24.861 44.288  
21588 21588 USA United States of America Bishop Creek 3 USA0000324 8.399999999999999 37.302 -118.532 Hydro       1913.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33120 2017 18.174 15.001 12.683 22.88 44.059  
21589 21589 USA United States of America Bishop Creek 4 USA0000325 8.2 37.323 -118.5017 Hydro       1906.756097560976 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33111 2017 24.134 25.145 23.840999999999998 23.688000000000002 30.865  
21590 21590 USA United States of America Bishop Creek 5 USA0000326 4.5 37.3344 -118.4797 Hydro       1929.666666666667 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33118 2017 8.652000000000001 6.091 4.971 10.842 19.938  
21591 21591 USA United States of America Bishop Creek 6 USA0000327 1.6 37.3499 -118.4628 Hydro       1913.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33114 2017 8.291 6.752999999999999 5.926 8.024000000000001 12.427  
21700 21700 USA United States of America Borel USA0000328 12.0 35.5881 -118.5248 Hydro       1918.5 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33121 2017 7.122000000000001 -0.209 -0.221 -0.218 -0.308  
22032 22032 USA United States of America California State University San Bernardi USA0057544 1.4 34.1858 -117.3242 Gas       2013.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 14552 2017 4.571000000000001 8.911 5.914 6.71 7.859  
22209 22209 USA United States of America Center Peaker USA0056475 59.8 33.9296 -118.1046 Gas Storage     2008.672240802676 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 19.979 19.464000000000002 28.755 27.378 22.699  
23492 23492 USA United States of America Fontana USA0000332 3.0 34.1552 -117.3971 Hydro       1918.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33129 2017 2.845 1.916 1.6269999999999998 1.294 3.4930000000000003  
23953 23953 USA United States of America Grapeland Peaker USA0056472 59.8 34.0903 -117.5343 Gas Storage     2008.672240802676 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 21.206999999999997 14.044 21.636 33.435 22.9  
24649 24649 USA United States of America J S Eastwood USA0000104 199.8 37.1479 -119.2567 Hydro       1988.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33138 2017 72.14 78.29 80.39699999999999 238.699 425.14  
24831 24831 USA United States of America Kaweah 1 USA0000337 2.3 36.4651 -118.862 Hydro       1929.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33137 2017 7.1850000000000005 3.5589999999999997 6.5200000000000005 6.976 7.537000000000001  
24832 24832 USA United States of America Kaweah 2 USA0000336 1.8 36.4613 -118.8799 Hydro       1929.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33136 2017 6.681 4.4350000000000005 6.422999999999999 5.74 7.154  
24833 24833 USA United States of America Kaweah 3 USA0000338 4.8 36.4861 -118.8356 Hydro       1913.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33134 2017 11.085 6.761 12.262 18.979 19.807  
24881 24881 USA United States of America Kern River 1 USA0000340 26.4 35.4603 -118.7796 Hydro       1907.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33139 2017 61.306 101.689 79.277 152.368 169.463  
24882 24882 USA United States of America Kern River 3 USA0000339 40.1 35.7762 -118.4362 Hydro       1921.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33135 2017 72.381 0.368 35.152 117.487 216.90400000000002  
25338 25338 USA United States of America Lower Tule River USA0000365 2.6 36.1357 -118.7889 Hydro       1909.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 6.067 6.6930000000000005 5.9190000000000005 10.54 5.622999999999999  
25350 25350 USA United States of America Lundy USA0000342 3.0 38.0427 -119.172 Hydro       1912.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33141 2017 4.838 4.324 4.285 7.722 16.799  
25448 25448 USA United States of America Mammoth Pool USA0000344 190.0 37.2203 -119.338 Hydro       1960.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33147 2017 355.68300000000005 217.263 137.64700000000002 632.582 970.25  
25584 25584 USA United States of America McGrath Peaker USA0056471 49.8 34.2056 -119.2469 Gas       2012.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 65214 2017 23.874000000000002 26.691999999999997 41.581 31.296999999999997 45.188  
25742 25742 USA United States of America Mill Creek 3 USA0007147 3.0 34.088 -117.0395 Hydro       1903.666666666667 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33148 2017 5.8100000000000005 4.905 4.966 5.23 14.508  
25791 25791 USA United States of America Mira Loma Energy Storage Facility USA0060661 20.0 34.0061 -117.5609 Storage       2017.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017       0.0 13.433  
25792 25792 USA United States of America Mira Loma Peaker USA0056473 49.8 34.0053 -117.5604 Gas       2007.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 15.165 16.53 25.551 32.593 24.404  
25948 25948 USA United States of America Mountainview Generating Station USA0000358 1036.8 34.0818 -117.2418 Gas       2006.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33162 2017 5518.3420000000015 6172.6631 5750.4093 4890.772000000001 4040.5069  
26685 26685 USA United States of America Pebbly Beach USA0006704 12.69999999999999 33.3331 -118.3103 Oil Gas Storage   1987.0472440944914 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33154 2017 0.0 28.224 29.1 0.0 28.739  
26879 26879 USA United States of America Poole USA0000353 11.3 37.9442 -119.2161 Hydro       1924.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33156 2017 8.15 21.226 17.637 30.359 39.173  
26905 26905 USA United States of America Portal USA0000354 10.8 37.257 -119.1589 Hydro       1957.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33157 2017 15.953 22.88 9.696 11.019 33.309  
27407 27407 USA United States of America Rush Creek USA0000357 13.1 37.767 -119.1233 Hydro       1917.099236641221 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33158 2017 40.023 22.177 18.047 45.95399999999999 51.64  
27605 27605 USA United States of America Santa Ana 1 USA0000361 3.2 34.1452 -117.0585 Hydro       1899.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33165 2017 2.135 0.513 1.132 0.8759999999999999 5.593  
27606 27606 USA United States of America Santa Ana 3 USA0000363 3.1 34.1072 -117.0991 Hydro       1999.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33164 2017 3.737 1.777 2.975 2.699 9.042  
27915 27915 USA United States of America Solar Photovoltaic Project #02 USA0056996 1.0 33.9852 -117.7008 Solar       2010.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.951 0.7909999999999999 0.7030000000000001 0.899 0.58  
27916 27916 USA United States of America Solar Photovoltaic Project #03 USA0057217 1.0 34.0943 -117.4001 Solar       2011.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 -0.11599999999999999 0.38 1.255 1.16 1.147  
27917 27917 USA United States of America Solar Photovoltaic Project #05 USA0057219 2.5 34.0863 -117.2306 Solar       2012.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.5700000000000003 3.99 4.371 3.967 4.231  
27918 27918 USA United States of America Solar Photovoltaic Project #06 USA0057220 2.0 34.0414 -117.5731 Solar       2011.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.478 3.7119999999999997 4.077 3.912 3.7319999999999998  
27919 27919 USA United States of America Solar Photovoltaic Project #07 USA0057221 2.5 34.0861 -117.2275 Solar       2012.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.636 4.566 4.471 3.995 4.143  
27920 27920 USA United States of America Solar Photovoltaic Project #08 USA0057222 2.0 34.0419 -117.565 Solar       2011.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.4939999999999998 3.9960000000000004 3.964 3.58 3.5189999999999997  
27921 27921 USA United States of America Solar Photovoltaic Project #09 USA0057223 1.0 34.0428 -117.5717 Solar       2011.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 1.837 1.396 1.76 1.605 1.7469999999999999  
27922 27922 USA United States of America Solar Photovoltaic Project #10 USA0057224 1.5 34.075 -117.5169 Solar       2013.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.02 2.761 2.699 2.394 1.624  
27923 27923 USA United States of America Solar Photovoltaic Project #11 USA0057225 3.5 34.0758 -117.2414 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     6.461 6.247000000000001 6.202999999999999 1.560746837892019
27924 27924 USA United States of America Solar Photovoltaic Project #13 USA0057227 3.5 34.0835 -117.2356 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     6.651 6.178 5.897 1.560746837892019
27925 27925 USA United States of America Solar Photovoltaic Project #15 USA0057229 3.5 34.0792 -117.5167 Solar       2013.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 1.6969999999999998 4.574 5.03 4.263999999999999 3.722  
27926 27926 USA United States of America Solar Photovoltaic Project #16 USA0057230 1.5 34.0856 -117.2336 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     2.528 2.383 1.696 0.6688915019537224
27927 27927 USA United States of America Solar Photovoltaic Project #17 USA0057231 3.5 34.0728 -117.5033 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     5.9239999999999995 5.257000000000001 3.937 1.560746837892019
27928 27928 USA United States of America Solar Photovoltaic Project #18 USA0057232 1.5 34.0833 -117.5164 Solar       2012.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 2.839 2.2880000000000003 2.345 2.16 1.858  
27929 27929 USA United States of America Solar Photovoltaic Project #22 USA0057237 2.0 34.08 -117.2114 Solar       2011.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.62 3.0589999999999997 3.4090000000000003 2.8000000000000003 2.7539999999999996  
27930 27930 USA United States of America Solar Photovoltaic Project #23 USA0057236 2.5 34.0808 -117.5203 Solar       2013.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 5.4270000000000005 4.849 4.846 4.516 3.8369999999999997  
27931 27931 USA United States of America Solar Photovoltaic Project #26 USA0057245 6.0 34.1312 -117.4253 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     10.79 10.270999999999999 10.192 2.675566007814889
27932 27932 USA United States of America Solar Photovoltaic Project #27 USA0057246 2.0 34.1311 -117.4217 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     3.221 3.188 2.948 0.8918553359382966
27933 27933 USA United States of America Solar Photovoltaic Project #28 USA0057247 3.5 34.0942 -117.2742 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     6.4430000000000005 5.542999999999999 4.881 1.560746837892019
27934 27934 USA United States of America Solar Photovoltaic Project #32 USA0057534 1.5 34.0317 -117.5719 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     2.468 2.443 2.351 0.6688915019537224
27935 27935 USA United States of America Solar Photovoltaic Project #33 USA0057535 1.0 34.0325 -117.5692 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     1.699 1.507 1.64 0.4459276679691483
27936 27936 USA United States of America Solar Photovoltaic Project #42 USA0057441 5.0 36.0281 -119.0747 Solar       2012.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 9.366 8.862 9.285 8.781 8.134  
27937 27937 USA United States of America Solar Photovoltaic Project #44 USA0057540 8.0 33.8392 -117.2208 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     13.8 12.289000000000001 8.952 3.5674213437531863
27938 27938 USA United States of America Solar Photovoltaic Project #48 USA0057900 5.0 34.0811 -117.2281 Solar       2015.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     8.992 6.954 8.467 2.229638339845741
28443 28443 USA United States of America Tehachapi Energy Storage Project USA0059661 8.0 35.1233 -118.38 Storage       2016.0 Southern California Edison Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017       0.0 1.7  

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