global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
13 rows where commissioning_year = "1964.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
owner 12
- U S Bureau of Reclamation 2
- Alabama Power Co 1
- Appalachian Power Co 1
- Duke Energy Carolinas LLC 1
- Energy Northwest 1
- Grand River Dam Authority 1
- Portland General Electric Co 1
- Tennessee Valley Authority 1
- USACE Northwestern Division 1
- USCE-Little Rock District 1
- USCE-Tulsa District 1
- Union Electric Co - (MO) 1
primary_fuel 1
- Hydro · 13 ✖
country_long 1
- United States of America · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26736 | 26736 | USA | United States of America | Cougar | USA0003076 | 26.0 | 44.1307 | -122.2439 | Hydro | 1964.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35546 | 2019 | 126.669 | 156.925 | 62.141 | 35.4 | 96.175 | 80.523 | 89.009 | U.S. Energy Information Administration | 74.76 | 74.76 | 65.69 | 74.97 | 63.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26773 | 26773 | USA | United States of America | Cowans Ford | USA0002722 | 350.0 | 35.4346 | -80.9588 | Hydro | 1964.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18711 | 2019 | 258.09000000000003 | 148.025 | 156.06 | 140.58 | 120.382 | 311.20300000000003 | 263.714 | U.S. Energy Information Administration | 875.41 | 793.0 | 696.07 | 834.11 | 644.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27508 | 27508 | USA | United States of America | Eufaula Dam | USA0006419 | 90.0 | 35.3069 | -95.3572 | Hydro | 1964.0 | USCE-Tulsa District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35554 | 2019 | 177.18200000000002 | 126.521 | 341.782 | 259.558 | 194.298 | 269.474 | 462.962 | U.S. Energy Information Administration | 314.51 | 315.72 | 373.01 | 323.36 | 324.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28314 | 28314 | USA | United States of America | Greers Ferry Lake | USA0000188 | 96.0 | 35.5207 | -91.9953 | Hydro | 1964.0 | USCE-Little Rock District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35561 | 2019 | 124.885 | 149.328 | 270.873 | 198.122 | 164.651 | 200.955 | 296.621 | U.S. Energy Information Administration | 309.82 | 326.49 | 279.49 | 333.88 | 269.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29588 | 29588 | USA | United States of America | Leesville | USA0003777 | 40.0 | 37.0933 | -79.4025 | Hydro | 1964.0 | Appalachian Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13358 | 2019 | 67.97200000000001 | 58.672 | 69.804 | 79.431 | 57.756 | 83.759 | 72.286 | U.S. Energy Information Administration | 130.52 | 131.81 | 97.62 | 133.23 | 108.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29716 | 29716 | USA | United States of America | Logan Martin Dam | USA0000014 | 128.10000000000002 | 33.4259 | -86.3375 | Hydro | 1964.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12591 | 2019 | 495.981 | 346.035 | 358.557 | 266.305 | 310.886 | 445.383 | 446.04 | U.S. Energy Information Administration | 438.22 | 423.55 | 318.99 | 435.55 | 365.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29975 | 29975 | USA | United States of America | Markham | USA0002980 | 128.4 | 36.2317 | -95.1822 | Hydro | 1964.0 | Grand River Dam Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 253.738 | 111.265 | 347.677 | 251.699 | 248.572 | 176.311 | 549.249 | U.S. Energy Information Administration | 446.28 | 390.16 | 465.58 | 464.11 | 478.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30129 | 30129 | USA | United States of America | Melton Hill | USA0003408 | 72.0 | 35.8853 | -84.3003 | Hydro | 1964.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34356 | 2019 | 211.371 | 149.741 | 151.872 | 112.664 | 66.92 | 152.381 | 193.878 | U.S. Energy Information Administration | 316.21 | 263.59 | 246.59 | 338.41 | 220.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31185 | 31185 | USA | United States of America | Packwood | USA0003929 | 27.5 | 46.5958 | -121.5694 | Hydro | 1964.0 | Energy Northwest | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36340 | 2019 | 97.835 | 128.333 | 87.72200000000001 | 96.505 | 103.512 | 87.522 | 58.329 | U.S. Energy Information Administration | 89.29 | 93.82 | 71.87 | 87.25 | 76.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32097 | 32097 | USA | United States of America | Round Butte | USA0003050 | 372.5 | 44.6058 | -121.2773 | Hydro | 1964.0 | Portland General Electric Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30451 | 2019 | 949.058 | 992.595 | 919.904 | 931.167 | 1035.602 | 835.0980000000001 | 870.8190000000001 | U.S. Energy Information Administration | 974.33 | 1171.26 | 901.8 | 1093.41 | 971.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32853 | 32853 | USA | United States of America | Spring Creek | USA0000450 | 180.0 | 40.6281 | -122.4675 | Hydro | 1964.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35669 | 2019 | 352.401 | 283.446 | 200.467 | 193.724 | 417.597 | 129.101 | 374.42 | U.S. Energy Information Administration | 571.05 | 613.88 | 403.46 | 614.08 | 475.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33270 | 33270 | USA | United States of America | Taum Sauk | USA0002108 | 408.0 | 37.5208 | -90.8347 | Hydro | 1964.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35272 | 2019 | -102.571 | -135.904 | -71.811 | -152.879 | -147.606 | -121.335 | -19.611 | U.S. Energy Information Administration | 1005.36 | 1005.36 | 951.02 | 1008.11 | 831.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33489 | 33489 | USA | United States of America | Trinity | USA0000451 | 140.0 | 40.7973 | -122.7626 | Hydro | 1964.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35672 | 2019 | 449.91 | 279.059 | 195.161 | 277.80400000000003 | 411.169 | 275.421 | 270.275 | U.S. Energy Information Administration | 353.66 | 427.74 | 354.58 | 417.09 | 352.25 | 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");