global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
16 rows where commissioning_year = "1959.0" and country_long = "United States of America"
This data as json, CSV (advanced)
Suggested facets: generation_gwh_2013, generation_gwh_2015, generation_gwh_2017, generation_gwh_2018, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017
owner 13
- PacifiCorp 2
- Pacific Gas & Electric Co. 2
- U S Bureau of Reclamation 2
- AES Huntington Beach LLC 1
- Dunn Paper 1
- Erie Boulevard Hydropower LP 1
- Garkane Energy Coop Inc 1
- Georgia Power Co 1
- L'Anse Warden Electric Company LLC 1
- Madison Gas & Electric Co 1
- Merlin One LLC 1
- Midwest Generations EME LLC 1
- Puget Sound Energy Inc 1
country_long 1
- United States of America · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24782 | 24782 | USA | United States of America | AES Huntington Beach LLC | USA0000335 | 218.0 | 33.6439 | -117.9792 | Gas | 1959.0 | AES Huntington Beach LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33131 | 2019 | 851.663 | 912.234 | 722.4970000000001 | 486.191 | 408.97 | 319.522 | 221.671 | U.S. Energy Information Administration | 768.77 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
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 | |||
25643 | 25643 | USA | United States of America | Blount Street | USA0003992 | 100.0 | 43.0789 | -89.3744 | Gas | 1959.0 | Madison Gas & Electric Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25372 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 43.29 | U.S. Energy Information Administration | 352.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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 | ||||
27706 | 27706 | USA | United States of America | Flos Inn Diesel | USA0001514 | 6.0 | 46.71 | -67.9556 | Oil | 1959.0 | Merlin One LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | U.S. Energy Information Administration | 3.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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 | |||
29107 | 29107 | USA | United States of America | John H Warden | USA0001772 | 22.0 | 46.7553 | -88.4558 | Waste | Other | 1959.0 | L'Anse Warden Electric Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 122.767997 | U.S. Energy Information Administration | 3.98 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29133 | 29133 | USA | United States of America | Joliet 9 | USA0000874 | 360.4 | 41.4931 | -88.1153 | Gas | 1959.0 | Midwest Generations EME LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17168 | 2019 | 1302.586001 | 1126.329022 | 1265.6969640000002 | 206.764501 | 43.712 | -57.596 | -64.543 | U.S. Energy Information Administration | 1270.94 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");