global-power-plants

Table actions

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

81 rows where owner = "Pacific Gas & Electric Co."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017

primary_fuel 5

owner 1

  • Pacific Gas & Electric Co. · 81 ✖

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_gwh_2018 generation_gwh_2019 generation_data_source estimated_generation_gwh_2013 estimated_generation_gwh_2014 estimated_generation_gwh_2015 estimated_generation_gwh_2016 estimated_generation_gwh_2017 estimated_generation_note_2013 estimated_generation_note_2014 estimated_generation_note_2015 estimated_generation_note_2016 estimated_generation_note_2017
24754 24754 USA United States of America A G Wishon USA0000293 12.8 37.151 -119.5047 Hydro       1910.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29353 2019 21.245 6.571 2.59 34.315 34.926 25.652 52.855 U.S. Energy Information Administration 43.91 34.02 31.66 42.51 46.38 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
24974 24974 USA United States of America Alta Powerhouse USA0000214 1.0 39.216 -120.8036 Hydro       1902.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 3.387 3.545 2.928 3.123 3.485 3.438 3.401 U.S. Energy Information Administration 2.21 2.22 2.35 2.23 1.87 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
25309 25309 USA United States of America Balch 1 USA0000217 31.0 36.9091 -119.0877 Hydro       1927.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29355 2019 53.98 44.325 19.306 132.644 177.233 82.44 163.231 U.S. Energy Information Administration 76.22 75.82 62.61 86.87 81.31 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
25310 25310 USA United States of America Balch 2 USA0000218 97.2 36.9089 -119.0876 Hydro       1958.5 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29357 2019 194.302 158.988 51.608 331.916 549.62 403.455 581.244 U.S. Energy Information Administration 239.05 237.78 205.81 272.43 256.47 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
25455 25455 USA United States of America Belden USA0000219 117.9 40.0074 -121.2494 Hydro       1969.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29358 2019 249.737 161.634 142.826 181.578 285.963 233.801 429.689 U.S. Energy Information Administration 359.77 349.83 290.69 405.82 329.79 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
25885 25885 USA United States of America Bucks Creek USA0000220 66.0 39.9106 -121.3277 Hydro       1928.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29360 2019 137.772 70.387 79.157 260.39300000000003 265.473 131.028 160.302 U.S. Energy Information Administration 232.28 219.6 192.7 253.52 207.17 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
25943 25943 USA United States of America Butt Valley USA0000221 40.0 40.1757 -121.1907 Hydro       1959.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29359 2019 133.302 88.042 73.34700000000001 76.608 138.093 58.44 129.768 U.S. Energy Information Administration 117.31 117.31 105.75 117.63 100.68 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26049 26049 USA United States of America CSU East Bay USA0057042 1.4 37.6589 -122.0594 Gas       2011.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 61555 2019 7.775 9.993 10.172 3.666 4.199 4.801 4.678 U.S. Energy Information Administration         4.93 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
26154 26154 USA United States of America Cantua Solar Station USA0057522 20.0 36.4251 -120.3435 Solar       2012.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 48.175 43.209 42.547 43.802 39.822 42.223 40.365 U.S. Energy Information Administration 43.08 44.6 47.24 42.23 41.0 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
26179 26179 USA United States of America Caribou 1 USA0000222 73.8 40.0855 -121.1482 Hydro       1922.0162601626016 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29361 2019 143.02100000000002 71.782 82.182 85.487 325.222 114.369 133.017 U.S. Energy Information Administration 245.49 237.23 211.42 261.15 218.97 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26180 26180 USA United States of America Caribou 2 USA0000223 117.9 40.086 -121.1494 Hydro       1958.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29362 2019 368.398 289.603 220.738 307.41 466.865 358.407 678.61 U.S. Energy Information Administration 339.87 348.92 288.68 372.26 303.91 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26292 26292 USA United States of America Centerville PH USA0000224 6.4 39.7889 -121.6574 Hydro       1900.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29364 2019                 15.48 16.64 14.67 21.95 19.18 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26410 26410 USA United States of America Chili Bar USA0000225 7.0 38.7718 -120.8132 Hydro       1965.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29363 2019 15.949 1.702 0.866 32.35 43.403 27.25 35.121 U.S. Energy Information Administration 24.24 24.72 19.1 30.19 28.1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26567 26567 USA United States of America Coleman PH USA0000227 12.1 40.4046 -122.1219 Hydro       1979.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29370 2019 39.844 35.544000000000004 26.894 47.515 59.049 45.303 41.183 U.S. Energy Information Administration 35.03 42.22 32.67 45.16 44.2 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26609 26609 USA United States of America Colusa Generating Station USA0056532 712.4 39.3661 -122.27 Gas       2011.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55555 2019 2535.528 2480.83 3571.838 2909.398 2490.625 2986.3010000000004 3028.361 U.S. Energy Information Administration         2512.27 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
26772 26772 USA United States of America Cow Creek USA0000229 1.4 40.5708 -122.0209 Hydro       1907.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29367 2019 4.6690000000000005 4.082 4.043 6.813 7.641 3.785 4.479 U.S. Energy Information Administration 2.92 2.94 2.92 2.95 2.45 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26802 26802 USA United States of America Cresta USA0000231 73.8 39.8259 -121.4097 Hydro       1949.5 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29365 2019 198.325 148.108 124.142 250.939 368.101 190.017 371.172 U.S. Energy Information Administration 259.73 245.55 215.47 283.48 231.66 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
26983 26983 USA United States of America De Sabla USA0000232 18.4 39.8693 -121.6318 Hydro       1963.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29375 2019 73.71900000000001 43.65 42.822 49.393 27.716 59.657 54.574 U.S. Energy Information Administration 47.95 47.5 40.66 62.78 54.79 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
27005 27005 USA United States of America Deer Creek PH USA0000233 5.5 39.2981 -120.8443 Hydro       1908.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29372 2019 19.803 17.756 18.342 15.919 13.931 21.01 16.199 U.S. Energy Information Administration 11.93 11.93 11.84 11.97 10.11 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
27092 27092 USA United States of America Diablo Canyon USA0006099 2323.0 35.2115 -120.8555 Nuclear       1985.501076194576 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29376 2019 18012.439 16985.978000000003 18505.385 18907.578 17901.079 18213.519 16165.384000000002 U.S. Energy Information Administration         18429.02 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
27197 27197 USA United States of America Drum 1 USA0000235 49.2 39.2569 -120.7674 Hydro       1919.219512195122 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29377 2019 57.424 19.894 20.904 157.038 133.286 85.904 73.34 U.S. Energy Information Administration 140.73 140.73 123.56 141.11 120.28 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
27198 27198 USA United States of America Drum 2 USA0000236 53.1 39.2574 -120.767 Hydro       1966.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29378 2019 240.928 170.814 175.386 246.25 311.214 231.243 278.49 U.S. Energy Information Administration 151.89 151.89 133.35 152.3 129.81 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
27230 27230 USA United States of America Dutch Flat USA0000237 22.0 39.217 -120.8356 Hydro       1943.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29373 2019 106.726 60.196 62.567 93.409 81.453 69.559 67.004 U.S. Energy Information Administration 63.72 63.72 56.04 63.9 54.58 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
27379 27379 USA United States of America Electra USA0000239 102.5 38.331 -120.6699 Hydro       1948.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29380 2019 312.122 220.266 164.18800000000002 434.128 446.074 316.535 316.582 U.S. Energy Information Administration 345.73 276.86 211.22 302.7 326.27 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
27674 27674 USA United States of America Five Points Solar Station USA0057498 15.0 36.4003 -120.1033 Solar       2011.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 70675 2019 28.338 28.299 25.471 29.839 27.708 28.699 26.209 U.S. Energy Information Administration 35.33 33.62 34.09 26.4 29.88 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
28000 28000 USA United States of America Gates Solar Station USA0057892 20.0 36.1764 -120.1142 Solar       2013.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 102155 2019 26.44 47.646 43.228 43.717 42.378 43.311 33.235 U.S. Energy Information Administration   44.6 47.75 44.34 48.44 NO-ESTIMATION SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
28003 28003 USA United States of America Gateway Generating Station USA0056476 619.7 38.0175 -121.7587 Gas       2009.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55850 2019 3182.079 3242.2610000000004 3310.8230000000003 2435.9500000000003 2779.798 2929.751 2872.858 U.S. Energy Information Administration         2185.36 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28082 28082 USA United States of America Giffen USA0057521 10.0 36.5303 -120.3161 Solar       2012.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 24.0 21.518 21.772 20.678 18.175 18.948 17.464 U.S. Energy Information Administration 22.07 20.41 21.4 19.55 16.69 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
28339 28339 USA United States of America Guernsey Solar Station USA0057891 20.0 36.1639 -119.6506 Solar       2013.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 11.488 46.332 46.157 45.922 44.076 43.717 43.083 U.S. Energy Information Administration   44.6 47.36 44.38 48.05 NO-ESTIMATION SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
28380 28380 USA United States of America Haas USA0000240 135.0 36.9274 -119.0203 Hydro       1959.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29386 2019 181.774 138.226 35.18 344.669 757.886 361.336 650.136 U.S. Energy Information Administration 284.67 282.91 238.51 332.63 319.9 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
28399 28399 USA United States of America Halsey USA0000241 13.6 38.957 -121.0419 Hydro       1917.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29385 2019 44.306 24.258 14.612 29.404 31.493 38.014 41.231 U.S. Energy Information Administration 35.32 35.32 31.62 35.42 30.82 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
28404 28404 USA United States of America Hamilton Branch USA0000242 5.300000000000001 40.2687 -121.0895 Hydro       1921.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29387 2019 9.621 4.101 4.033 10.118 8.307 4.508 0.0 U.S. Energy Information Administration 17.29 16.77 16.6 19.46 18.77 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
28495 28495 USA United States of America Hat Creek 1 USA0000243 10.0 40.9293 -121.5445 Hydro       1921.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29383 2019 19.585 20.956 22.156 25.538 34.504 31.285 34.424 U.S. Energy Information Administration 34.05 31.86 30.63 35.44 31.2 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
28496 28496 USA United States of America Hat Creek 2 USA0000244 10.0 40.9607 -121.5487 Hydro       1921.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29384 2019 36.412 32.216 30.899 32.645 41.712 41.999 43.089 U.S. Energy Information Administration 34.05 31.86 30.63 35.44 31.2 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
28560 28560 USA United States of America Helms Pumped Storage USA0006100 1053.0 37.0293 -118.9683 Hydro       1984.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29382 2019 -308.524 -209.45 -250.413 -498.562 -290.22 -412.78 -298.392 U.S. Energy Information Administration 2094.43 2080.72 1796.15 2367.71 2247.09 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
28752 28752 USA United States of America Humboldt Bay USA0000246 166.99999999999997 40.7415 -124.2103 Gas Oil Biomass   2010.1000000000004 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29392 2019 358.038997 346.41700000000003 402.544004 366.744005 431.581999 383.862005 405.185998 U.S. Energy Information Administration         588.92 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28771 28771 USA United States of America Huron Solar Station USA0057523 20.0 36.1814 -120.0306 Solar       2012.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 67266 2019 45.047 44.014 42.785 42.504 40.413 41.313 39.941 U.S. Energy Information Administration 47.58 44.99 47.63 42.36 39.93 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
28940 28940 USA United States of America Inskip USA0000248 7.6 40.401 -121.9655 Hydro       1979.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29393 2019 35.431 27.483 15.099 18.808 10.74 0.0 0.0 U.S. Energy Information Administration 24.18 20.95 22.39 26.77 24.78 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29052 29052 USA United States of America James B Black USA0000249 168.6 40.9923 -121.9752 Hydro       1966.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29390 2019 534.995 434.19 398.101 587.264 770.26 543.811 679.587 U.S. Energy Information Administration 488.82 497.05 346.65 532.99 464.7 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29278 29278 USA United States of America Kerckhoff USA0000250 22.6 37.0925 -119.5528 Hydro       1920.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29398 2019 15.989 0.0 5.495 44.863 73.232 0.0   U.S. Energy Information Administration 76.27 61.17 52.75 75.34 73.84 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29279 29279 USA United States of America Kerckhoff 2 USA0000682 139.5 37.0718 -119.558 Hydro       1983.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29398 2019 209.452 140.573 78.03 302.683 794.645 326.621 668.481 U.S. Energy Information Administration 421.88 345.47 305.53 427.38 368.85 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29280 29280 USA United States of America Kern Canyon USA0007911 9.5 35.4407 -118.7965 Hydro       1921.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29396 2019 22.129 15.513 6.539 33.87 0.299 0.0 0.0 U.S. Energy Information Administration 25.71 28.57 23.98 23.58 24.96 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29305 29305 USA United States of America Kilarc USA0000253 1.5 40.6778 -121.8733 Hydro       1904.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29397 2019 14.137 9.982 9.15 15.462 8.934000000000001 8.351 2.253 U.S. Energy Information Administration 6.8 7.34 6.91 8.33 8.4 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29338 29338 USA United States of America Kings River PH USA0000254 48.6 36.8882 -119.1588 Hydro       1962.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29399 2019 51.058 41.283 18.02 125.119 226.372 134.174 122.29 U.S. Energy Information Administration 129.31 137.37 83.8 159.11 147.1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
29637 29637 USA United States of America Lime Saddle USA0000255 2.0 39.6988 -121.571 Hydro       1906.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29400 2019 5.496 4.223 4.301 3.295 5.1530000000000005 3.03 0.0 U.S. Energy Information Administration 5.23 5.26 5.23 5.27 4.55 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
30598 30598 USA United States of America Narrows PH USA0000262 10.2 39.2364 -121.2717 Hydro       1943.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29409 2019 58.746 25.183 36.316 41.923 61.468 22.883 47.007 U.S. Energy Information Administration 38.35 42.47 34.29 51.96 41.46 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
30694 30694 USA United States of America Newcastle USA0000632 12.7 38.8352 -121.093 Hydro       1987.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29408 2019 13.801 7.369 10.112 16.068 14.305 10.963 21.393 U.S. Energy Information Administration 41.19 44.94 36.89 57.69 47.49 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
30896 30896 USA United States of America Oak Flat USA0000626 1.4 40.0753 -121.1614 Hydro       1985.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29411 2019 5.465 5.795 5.489 5.873 4.134 2.363 4.311 U.S. Energy Information Administration 5.4 4.22 5.16 4.55 3.76 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31394 31394 USA United States of America Phoenix USA0000264 1.6 38.0321 -120.3265 Hydro       1940.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29413 2019 9.559 5.091 4.8420000000000005 7.876 6.462 5.6690000000000005 6.434 U.S. Energy Information Administration 4.35 4.38 4.45 4.39 3.81 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31465 31465 USA United States of America Pit 1 USA0000265 69.2 40.9908 -121.4982 Hydro       1922.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29418 2019 204.369 177.903 147.084 191.861 295.265 227.077 277.402 U.S. Energy Information Administration 217.83 220.86 174.22 246.29 213.59 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31466 31466 USA United States of America Pit 3 USA0000266 80.1 40.9974 -121.7481 Hydro       1925.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29415 2019 258.625 214.655 237.705 299.634 241.413 257.821 362.321 U.S. Energy Information Administration 269.42 259.54 200.6 284.24 249.62 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31467 31467 USA United States of America Pit 4 USA0000267 103.4 40.9864 -121.8494 Hydro       1955.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29419 2019 348.817 305.937 229.977 392.158 374.569 397.187 452.03 U.S. Energy Information Administration 356.73 343.97 267.9 375.89 331.17 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31468 31468 USA United States of America Pit 5 USA0000268 141.60000000000002 40.9862 -121.9776 Hydro       1944.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29420 2019 478.997 517.33 442.276 587.622 227.227 612.859 853.787 U.S. Energy Information Administration 410.54 417.45 291.14 447.64 390.28 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31469 31469 USA United States of America Pit 6 USA0000269 79.2 40.9226 -121.9929 Hydro       1965.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29416 2019 273.255 278.46500000000003 199.848 313.589 325.115 268.511 334.992 U.S. Energy Information Administration 264.08 256.19 192.48 280.09 246.81 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31470 31470 USA United States of America Pit 7 USA0000270 109.8 40.8475 -121.9908 Hydro       1965.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29417 2019 379.472 303.928 272.312 423.27 464.098 361.008 461.161 U.S. Energy Information Administration 375.61 395.3 283.06 422.7 351.67 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31519 31519 USA United States of America Poe USA0000272 142.8 39.7229 -121.4698 Hydro       1958.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29424 2019 443.849 312.983 225.66 431.224 612.066 446.263 601.439 U.S. Energy Information Administration 435.1 434.22 362.26 498.29 396.82 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
31579 31579 USA United States of America Potter Valley USA0000274 9.4 39.3618 -123.1279 Hydro       1925.808510638297 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29421 2019 19.522 11.286 8.254 8.34 19.494 13.113 18.872 U.S. Energy Information Administration 28.24 31.57 20.88 31.68 28.06 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32011 32011 USA United States of America Rock Creek USA0000275 126.0 39.9052 -121.3452 Hydro       1950.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 312.976 236.934 192.982 346.829 543.463 331.932 645.136 U.S. Energy Information Administration 383.91 383.13 319.64 439.67 350.14 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32186 32186 USA United States of America SF State University USA0057043 1.6 37.7239 -122.4775 Gas       2011.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 10.17 9.365 3.89 1.508 1.574 11.119 9.08 U.S. Energy Information Administration         5.64 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
32271 32271 USA United States of America Salt Springs USA0000279 42.0 38.4979 -120.2181 Hydro       1946.5571428571427 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29426 2019 122.519 106.54 67.07000000000001 174.893 226.241 125.733 191.54 U.S. Energy Information Administration 120.13 120.13 105.47 120.46 102.67 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32306 32306 USA United States of America San Joaquin 2 USA0000276 2.8 37.2032 -119.4975 Hydro       1917.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29427 2019 2.556 0.913 0.0 3.389 6.723 0.355 0.0 U.S. Energy Information Administration 7.53 7.57 7.69 7.59 6.58 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32307 32307 USA United States of America San Joaquin 3 USA0000277 4.0 37.2537 -119.5194 Hydro       1923.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29429 2019 3.394 1.185 0.0 0.48 1.156 0.0 0.0 U.S. Energy Information Administration 9.3 9.3 9.4 9.32 7.97 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32747 32747 USA United States of America South USA0000280 6.7 40.3954 -121.8792 Hydro       1980.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 38.305 30.054 19.895 20.39 14.139 25.089 24.953 U.S. Energy Information Administration 21.31 18.47 19.73 23.6 21.85 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32825 32825 USA United States of America Spaulding 1 USA0000281 7.0 39.3246 -120.6448 Hydro       1928.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29431 2019 23.859 25.046 21.925 16.756 48.076 4.496 6.648000000000001 U.S. Energy Information Administration 23.65 22.52 21.89 29.61 25.16 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32826 32826 USA United States of America Spaulding 2 USA0000282 3.7 39.3246 -120.6454 Hydro       1928.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29430 2019 4.736 1.861 6.45 0.948 5.053 8.907 8.166 U.S. Energy Information Administration 12.8 12.38 12.53 15.43 13.1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32827 32827 USA United States of America Spaulding 3 USA0000283 6.6 39.3377 -120.6355 Hydro       1929.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29433 2019 24.335 3.4490000000000003 16.871 17.352 26.122 0.031 27.527 U.S. Energy Information Administration 22.3 21.23 20.64 27.92 23.72 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32855 32855 USA United States of America Spring Gap USA0000284 6.0 38.1865 -120.1117 Hydro       1921.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29432 2019 30.591 15.316 25.131 34.819 29.694 29.98 34.671 U.S. Energy Information Administration 20.3 17.69 16.06 19.22 19.64 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
32941 32941 USA United States of America Stanislaus USA0000285 81.9 38.139 -120.3703 Hydro       1963.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29435 2019 218.729 146.457 155.69400000000002 402.166 426.899 333.26 376.753 U.S. Energy Information Administration 217.05 235.88 199.57 306.49 249.05 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
33045 33045 USA United States of America Stroud Solar Station USA0057497 20.0 36.5314 -120.1069 Solar       2011.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63178 2019 44.933 42.715 40.966 38.539 34.751 37.339 33.509 U.S. Energy Information Administration 46.89 44.49 45.12 35.62 40.26 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
33390 33390 USA United States of America Tiger Creek USA0000287 52.2 38.4493 -120.4926 Hydro       1931.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29436 2019 258.587 191.952 137.625 269.377 192.636 227.447 252.45 U.S. Energy Information Administration 149.87 115.45 99.69 119.52 110.07 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
33413 33413 USA United States of America Toadtown USA0000714 1.8 39.8935 -121.5934 Hydro       1986.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29438 2019 3.903 1.542 1.875 3.216 3.294 3.5340000000000003 4.332 U.S. Energy Information Administration 5.08 5.41 5.13 6.98 5.92 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
33512 33512 USA United States of America Tule River USA0000289 8.4 36.1631 -118.7071 Hydro       1914.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 5.508 1.656 -2.389 14.898 0.0 0.001 0.0 U.S. Energy Information Administration 22.0 22.0 21.01 22.06 19.22 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
33720 33720 USA United States of America Vaca Dixon Battery Storage System USA0059256 2.0 38.3933 -121.9278 Storage       2013.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019       -1.413 -1.386 -1.167 -0.736 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
33721 33721 USA United States of America Vaca Dixon Solar Station USA0057041 2.0 38.4106 -121.9264 Solar       2010.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60024 2019 4.707 4.056 4.425 4.0280000000000005 3.434 4.069 3.074 U.S. Energy Information Administration 4.21 3.49 3.41 3.15 3.41 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
33854 33854 USA United States of America Volta 1 USA0000290 8.5 40.4591 -121.8671 Hydro       1980.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29442 2019 38.828 25.463 23.485 43.593 54.338 49.31 48.307 U.S. Energy Information Administration 17.44 23.4 19.71 26.88 24.58 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
33855 33855 USA United States of America Volta 2 USA0000180 1.0 40.4519 -121.8621 Hydro       1981.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29440 2019 4.728 3.363 2.759 4.7860000000000005 5.791 5.328 4.535 U.S. Energy Information Administration 2.38 3.26 3.15 3.7 3.32 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
34130 34130 USA United States of America West Gates Solar Station USA0058206 10.0 36.1422 -120.1325 Solar       2013.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 13.404 23.405 22.148 22.441 21.555 21.699 18.063 U.S. Energy Information Administration   20.41 21.65 20.27 20.54 NO-ESTIMATION SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
34146 34146 USA United States of America West Point PH USA0000291 13.6 38.4209 -120.5496 Hydro       1948.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29441 2019 72.156 52.18 37.963 78.889 87.97800000000001 69.038 78.013 U.S. Energy Information Administration 34.72 33.73 31.03 34.99 35.94 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
34211 34211 USA United States of America Westside Solar Station USA0057499 15.0 36.3787 -120.1249 Solar       2011.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 64647 2019 32.642 32.102000000000004 28.713 30.612 25.383 28.708 27.663 U.S. Energy Information Administration 35.33 33.62 34.09 26.4 29.98 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1 SOLAR-V1
34404 34404 USA United States of America Wise USA0000292 16.4 38.8899 -121.0985 Hydro       1928.9512195121952 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29445 2019 68.223 40.807 36.213 67.77 59.131 65.607 71.436 U.S. Energy Information Administration 41.47 41.47 37.22 41.58 36.04 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1 HYDRO-V1
34511 34511 USA United States of America Yerba Buena USA0059257 4.0 37.3058 -121.755 Storage       2013.0 Pacific Gas & Electric Co. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019       -2.611 -3.357 -4.399 -3.032 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION

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_gwh_2018" REAL,
  "generation_gwh_2019" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh_2013" REAL,
  "estimated_generation_gwh_2014" REAL,
  "estimated_generation_gwh_2015" REAL,
  "estimated_generation_gwh_2016" REAL,
  "estimated_generation_gwh_2017" REAL,
  "estimated_generation_note_2013" TEXT,
  "estimated_generation_note_2014" TEXT,
  "estimated_generation_note_2015" TEXT,
  "estimated_generation_note_2016" TEXT,
  "estimated_generation_note_2017" TEXT
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");