global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
19 rows where commissioning_year = "1955.0" and country_long = "United States of America"
This data as json, CSV (advanced)
Suggested facets: estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016
owner 14
- USACE Northwestern Division 4
- U S Bureau of Reclamation 3
- Anchorage Municipal Light and Power 1
- Duke Energy Carolinas LLC 1
- Erie Boulevard Hydropower LP 1
- FirstLight Power Resources Services LLC 1
- PUD No 1 of Pend Oreille County 1
- PacifiCorp 1
- Pacific Gas & Electric Co. 1
- Roseburg Forest Products Co 1
- Tennessee Valley Authority 1
- USCE -Vickburg District 1
- United States Steel- Clairton 1
- White Pine Electric Power LLC 1
country_long 1
- United States of America · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24905 | 24905 | USA | United States of America | Albeni Falls | USA0000851 | 42.0 | 48.1802 | -116.9986 | Hydro | 1955.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35529 | 2019 | 230.48 | 160.597 | 180.77 | 208.4 | 154.187 | 167.334 | 182.794 | U.S. Energy Information Administration | 187.54 | 187.81 | 172.71 | 188.32 | 165.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
24911 | 24911 | USA | United States of America | Alcova | USA0006409 | 41.4 | 42.5484 | -106.7175 | Hydro | 1955.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35616 | 2019 | 91.922 | 73.132 | 78.306 | 108.678 | 133.364 | 109.144 | 92.587 | U.S. Energy Information Administration | 129.46 | 146.42 | 113.92 | 138.13 | 121.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25533 | 25533 | USA | United States of America | Big Cliff | USA0003074 | 18.0 | 44.7514 | -122.2832 | Hydro | 1955.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35532 | 2019 | 64.016 | 71.97200000000001 | 54.991 | 68.8 | 92.904 | 87.09100000000001 | 70.106 | U.S. Energy Information Administration | 61.56 | 76.24 | 59.05 | 72.77 | 64.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25628 | 25628 | USA | United States of America | Blakely Mountain | USA0000197 | 75.0 | 34.571 | -93.1944 | Hydro | 1955.0 | USCE -Vickburg District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35535 | 2019 | 165.452 | 168.451 | 209.455 | 223.819 | 111.823 | 182.961 | 231.668 | U.S. Energy Information Administration | 244.74 | 263.68 | 223.39 | 255.77 | 216.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25756 | 25756 | USA | United States of America | Box Canyon | USA0003891 | 90.0 | 48.7809 | -117.4183 | Hydro | 1955.0 | PUD No 1 of Pend Oreille County | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29884 | 2019 | 415.118 | 434.992 | 507.236 | 487.406 | 352.67 | 441.606 | 460.813 | U.S. Energy Information Administration | 408.54 | 407.59 | 383.99 | 408.71 | 359.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26361 | 26361 | USA | United States of America | Chatuge | USA0002778 | 13.2 | 35.0191 | -83.7914 | Hydro | 1955.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34335 | 2019 | 44.909 | 24.839 | 27.77 | 27.983 | 17.415 | 36.086 | 30.591 | U.S. Energy Information Administration | 34.33 | 34.33 | 31.7 | 34.42 | 29.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26480 | 26480 | USA | United States of America | Clairton Works | USA0050729 | 31.0 | 40.3097 | -79.8819 | Gas | 1955.0 | United States Steel- Clairton | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26279 | 2019 | 162.547002 | 174.088003 | 150.40799600000005 | 164.797005 | 129.243996 | 129.24400100000005 | 141.80599999999998 | U.S. Energy Information Administration | 109.32 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27089 | 27089 | USA | United States of America | Dexter | USA0003078 | 15.0 | 43.9242 | -122.8055 | Hydro | 1955.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35548 | 2019 | 74.96900000000001 | 42.474 | 28.21 | 73.3 | 90.769 | 63.279 | 28.114 | U.S. Energy Information Administration | 59.48 | 70.58 | 55.02 | 63.79 | 60.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27117 | 27117 | USA | United States of America | Dillard Complex | USA0050396 | 51.5 | 43.0895 | -123.4156 | Waste | Gas | 1955.0 | Roseburg Forest Products Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 64536 | 2019 | 159.773005 | 167.283004 | 144.10299700000002 | 138.972 | 133.89599800000002 | 144.04499900000002 | 133.637998 | U.S. Energy Information Administration | 9.33 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
27364 | 27364 | USA | United States of America | Eklutna Hydro Project | USA0000077 | 44.4 | 61.4752 | -149.1501 | Hydro | 1955.0 | Anchorage Municipal Light and Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12656 | 2019 | 89.936 | 83.11 | 92.243 | 76.916 | 119.24 | 168.115 | 190.971 | U.S. Energy Information Administration | 162.38 | 162.38 | 112.46 | 162.82 | 137.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27670 | 27670 | USA | United States of America | Five Falls | USA0002562 | 24.0 | 44.5275 | -74.8492 | Hydro | 1955.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27808 | 2019 | 106.764 | 97.749 | 88.237 | 83.926 | 122.148 | 98.665 | 123.329 | U.S. Energy Information Administration | 88.7 | 94.74 | 74.44 | 92.86 | 80.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27714 | 27714 | USA | United States of America | Folsom | USA0000441 | 198.6 | 38.7067 | -121.1584 | Hydro | 1955.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35629 | 2019 | 341.902 | 185.147 | 203.501 | 593.96 | 861.616 | 583.368 | 774.2810000000001 | U.S. Energy Information Administration | 542.09 | 579.46 | 491.66 | 687.89 | 577.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29593 | 29593 | USA | United States of America | Lemolo 1 | USA0003029 | 32.0 | 43.3558 | -122.2494 | Hydro | 1955.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 123.888 | 140.861 | 123.55 | 134.067 | 174.923 | 124.864 | 114.477 | U.S. Energy Information Administration | 106.21 | 106.98 | 83.87 | 112.11 | 89.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29742 | 29742 | USA | United States of America | Lookout Point | USA0003083 | 120.0 | 43.9153 | -122.7531 | Hydro | 1955.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35575 | 2019 | 241.557 | 346.579 | 218.878 | 335.90000000000003 | 387.104 | 240.13 | 272.428 | U.S. Energy Information Administration | 368.25 | 400.1 | 307.82 | 375.16 | 327.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30726 | 30726 | USA | United States of America | Nimbus | USA0000444 | 13.4 | 38.6373 | -121.2202 | Hydro | 1955.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35659 | 2019 | 45.661 | 26.149 | 27.657 | 53.959 | 64.65 | 59.462 | 40.279 | U.S. Energy Information Administration | 52.7 | 47.75 | 45.35 | 61.89 | 59.35 | 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 | |||
32517 | 32517 | USA | United States of America | Shepaug | USA0000552 | 37.2 | 41.4484 | -73.2953 | Hydro | 1955.0 | FirstLight Power Resources Services LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17285 | 2019 | 126.939 | 145.192 | 96.232 | 72.728 | 103.513 | 187.815 | 143.101 | U.S. Energy Information Administration | 107.26 | 105.63 | 77.98 | 102.55 | 86.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33308 | 33308 | USA | United States of America | Tennessee Creek | USA0002749 | 10.8 | 35.2139 | -83.0028 | Hydro | 1955.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27080 | 2019 | 24.613 | 28.301 | 22.29 | 25.841 | 28.96 | 48.111 | 15.394 | U.S. Energy Information Administration | 28.29 | 28.29 | 26.14 | 28.37 | 24.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34261 | 34261 | USA | United States of America | White Pine Electric Power | USA0010148 | 20.0 | 46.7644 | -89.5669 | Gas | 1955.0 | White Pine Electric Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 24.727 | 22.609 | 0.0 | 0.0 | U.S. Energy Information Administration | 70.52 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");