global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
11 rows where commissioning_year = "1959.0", primary_fuel = "Hydro" and source = "U.S. Energy Information Administration"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25559 | 25559 | USA | United States of America | Big Thompson | USA0000515 | 4.5 | 40.421 | -105.2238 | Hydro | 1959.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35618 | 2019 | 7.223 | 2.006 | 4.123 | 5.722 | 7.627 | 1.251 | 8.231 | U.S. Energy Information Administration | 11.34 | 12.38 | 11.74 | 12.29 | 10.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25732 | 25732 | USA | United States of America | Boulder | USA0003699 | 4.199999999999999 | 37.9858 | -111.4383 | Hydro | 1959.0 | Garkane Energy Coop Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20725 | 2019 | 20.637 | 20.343 | 22.936 | 25.577 | 24.525 | 19.52 | 25.228 | U.S. Energy Information Administration | 9.73 | 9.73 | 9.83 | 9.76 | 8.34 | 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 | |||
27223 | 27223 | USA | United States of America | Dunn Paper | USA0054878 | 1.0 | 44.3364 | -75.5027 | Hydro | 1959.0 | Dunn Paper | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.633 | 7.569 | 6.627 | 5.474 | 4.6610000000000005 | 5.485 | 6.165 | U.S. Energy Information Administration | 3.85 | 4.3 | 3.9 | 3.92 | 3.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
28117 | 28117 | USA | United States of America | Glendo | USA0004177 | 38.0 | 42.4673 | -104.9555 | Hydro | 1959.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35637 | 2019 | 53.979 | 80.112 | 69.95 | 99.274 | 107.756 | 77.077 | 84.916 | U.S. Energy Information Administration | 122.6 | 131.53 | 108.66 | 127.91 | 111.72 | 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 | |||
30975 | 30975 | USA | United States of America | Oliver Dam | USA0000720 | 60.0 | 32.5163 | -84.9969 | Hydro | 1959.0 | Georgia Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20996 | 2019 | 209.184 | 197.805 | 200.502 | 152.217 | 151.763 | 236.037 | 248.671 | U.S. Energy Information Administration | 210.01 | 213.75 | 158.6 | 227.6 | 183.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31645 | 31645 | USA | United States of America | Prospect | USA0002599 | 19.0 | 43.2919 | -75.1477 | Hydro | 1959.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27848 | 2019 | 75.489 | 77.875 | 57.868 | 69.327 | 88.06700000000001 | 79.002 | 95.043 | U.S. Energy Information Administration | 71.07 | 75.07 | 53.79 | 67.35 | 65.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33167 | 33167 | USA | United States of America | Swift 1 | USA0003850 | 240.0 | 46.0608 | -122.2017 | Hydro | 1959.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29547 | 2019 | 574.062 | 812.195 | 583.525 | 761.592 | 866.791 | 545.383 | 369.084 | U.S. Energy Information Administration | 634.57 | 720.77 | 570.2 | 705.98 | 588.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33168 | 33168 | USA | United States of America | Swift 2 | USA0006265 | 72.0 | 46.0594 | -122.2594 | Hydro | 1959.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29545 | 2019 | 251.81 | 253.67 | 205.04 | 257.07 | 214.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
33682 | 33682 | USA | United States of America | Upper Baker | USA0003861 | 104.8 | 48.649 | -121.6907 | Hydro | 1959.0 | Puget Sound Energy Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30972 | 2019 | 356.55400000000003 | 340.085 | 278.75 | 369.105 | 355.744 | 333.791 | 262.946 | U.S. Energy Information Administration | 317.76 | 317.76 | 289.98 | 318.63 | 274.19 | 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");