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 = "1954.0", primary_fuel = "Hydro" and source = "U.S. Energy Information Administration"
This data as json, CSV (advanced)
owner 11
- U S Bureau of Reclamation 3
- Appalachian Power Co 1
- City of Seattle - (WA) 1
- Duke Energy Carolinas LLC 1
- Erie Boulevard Hydropower LP 1
- Imperial Irrigation District 1
- International Bound & Wtr Comm 1
- N E W Hydro LLC 1
- New York Power Authority 1
- Tennessee Valley Authority 1
- Utica Water & Power Authority 1
primary_fuel 1
- Hydro · 13 ✖
country_long 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25405 | 25405 | USA | United States of America | Bear Creek Dam | USA0002741 | 9.0 | 35.2427 | -83.072 | Hydro | 1954.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27072 | 2019 | 37.843 | 21.207 | 27.553 | 18.298 | 1.229 | 37.232 | 21.408 | U.S. Energy Information Administration | 23.58 | 23.58 | 22.51 | 23.64 | 20.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26158 | 26158 | USA | United States of America | Canyon Ferry | USA0006400 | 49.8 | 46.649 | -111.7279 | Hydro | 1954.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35625 | 2019 | 264.915 | 363.024 | 303.399 | 310.096 | 347.272 | 369.392 | 368.878 | U.S. Energy Information Administration | 182.49 | 195.21 | 128.32 | 183.73 | 216.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27190 | 27190 | USA | United States of America | Drop 2 (CA) | USA0000385 | 10.0 | 32.7054 | -115.031 | Hydro | 1954.0 | Imperial Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22906 | 2019 | 46.499 | 45.567 | 47.745 | 45.727 | 42.917 | 43.434 | 40.0 | U.S. Energy Information Administration | 25.47 | 25.47 | 22.88 | 25.54 | 22.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27590 | 27590 | USA | United States of America | Falcon Dam & Power | USA0006410 | 31.5 | 26.5575 | -99.1642 | Hydro | 1954.0 | International Bound & Wtr Comm | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23266 | 2019 | 49.443 | 37.758 | 6.805 | 56.77 | 72.09700000000001 | 66.715 | 62.51 | U.S. Energy Information Administration | 122.55 | 121.4 | 91.06 | 129.58 | 112.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27690 | 27690 | USA | United States of America | Flatiron | USA0000518 | 94.5 | 40.365 | -105.236 | Hydro | 1954.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35634 | 2019 | 179.931 | 222.616 | 143.563 | 208.112 | 156.385 | 199.991 | 201.574 | U.S. Energy Information Administration | 224.38 | 239.41 | 218.6 | 229.25 | 187.27 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27767 | 27767 | USA | United States of America | Fort Patrick Henry | USA0003401 | 59.4 | 36.4982 | -82.5086 | Hydro | 1954.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34346 | 2019 | 176.487 | 89.72200000000001 | 118.375 | 90.514 | 107.901 | 145.155 | 157.595 | U.S. Energy Information Administration | 209.28 | 212.71 | 167.72 | 213.9 | 179.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30132 | 30132 | USA | United States of America | Menominee Mill Marinette | USA0050409 | 1.8 | 45.1069 | -87.6378 | Hydro | 1954.0 | N E W Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32273 | 2019 | 13.898 | 14.743 | 15.345 | 12.698 | 16.181 | 14.314 | 12.023 | U.S. Energy Information Administration | 7.46 | 7.96 | 7.54 | 9.9 | 8.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30510 | 30510 | USA | United States of America | Murphys | USA0000261 | 3.6 | 38.1471 | -120.4464 | Hydro | 1954.0 | Utica Water & Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29404 | 2019 | 12.227 | 11.545 | 6.187 | 13.756 | 18.573 | 14.187 | 14.963 | U.S. Energy Information Administration | 8.3 | 8.3 | 8.46 | 8.32 | 7.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30647 | 30647 | USA | United States of America | Neversink | USA0002483 | 25.0 | 41.8194 | -74.6358 | Hydro | 1954.0 | New York Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15849 | 2019 | 29.716 | 41.329 | 35.544000000000004 | 22.887 | 27.414 | 7.279 | 17.632 | U.S. Energy Information Administration | 55.61 | 65.05 | 44.71 | 55.55 | 46.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30714 | 30714 | USA | United States of America | Niagara | USA0003778 | 3.6 | 37.2544 | -79.8756 | Hydro | 1954.0 | Appalachian Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13362 | 2019 | 10.449 | 8.006 | 0.0 | 0.0 | 0.0 | 7.858 | 10.524 | U.S. Energy Information Administration | 7.67 | 8.96 | 7.46 | 8.98 | 8.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31522 | 31522 | USA | United States of America | Pole Hill | USA0000519 | 38.2 | 40.3651 | -105.3251 | Hydro | 1954.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35663 | 2019 | 150.626 | 191.968 | 120.246 | 190.647 | 146.464 | 173.248 | 213.228 | U.S. Energy Information Administration | 87.59 | 83.3 | 72.05 | 79.44 | 70.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32090 | 32090 | USA | United States of America | Ross | USA0006202 | 450.0 | 48.7326 | -121.0679 | Hydro | 1954.0 | City of Seattle - (WA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32349 | 2019 | 724.327 | 794.413 | 682.792 | 789.494 | 739.553 | 688.166 | 522.6 | U.S. Energy Information Administration | 1226.76 | 1267.27 | 869.81 | 1270.75 | 1026.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32755 | 32755 | USA | United States of America | South Colton | USA0002611 | 21.0 | 44.5133 | -74.8831 | Hydro | 1954.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27861 | 2019 | 92.85 | 82.34 | 74.483 | 69.985 | 104.181 | 83.358 | 104.491 | U.S. Energy Information Administration | 79.17 | 84.65 | 66.89 | 83.01 | 71.85 | 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");