global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
63 rows where owner = "Pacific Gas & Electric Co." and primary_fuel = "Hydro" sorted by estimated_generation_gwh_2016
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||||||||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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");