global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
21 rows where country_long = "United States of America", estimated_generation_note_2014 = "HYDRO-V1", owner = "USACE Northwestern Division" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, commissioning_year, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017
primary_fuel 1
- Hydro · 21 ✖
owner 1
- USACE Northwestern Division · 21 ✖
country_long 1
- United States of America · 21 ✖
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 | |||
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 | |||
25712 | 25712 | USA | United States of America | Bonneville | USA0003075 | 1161.9999999999998 | 45.6441 | -121.941 | Hydro | 1960.8279690189331 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35537 | 2019 | 4671.527 | 4876.917 | 4127.097 | 4625.436 | 4834.674 | 4859.814 | 4207.101 | U.S. Energy Information Administration | 5094.37 | 5082.05 | 5323.72 | 5095.97 | 4427.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26407 | 26407 | USA | United States of America | Chief Joseph | USA0003921 | 2456.2 | 47.9951 | -119.6404 | Hydro | 1965.7936650109928 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35542 | 2019 | 12187.702 | 11643.559 | 11462.296 | 11638.206 | 11422.433 | 12352.466 | 9854.017 | U.S. Energy Information Administration | 10255.53 | 10229.49 | 12027.74 | 10257.52 | 9419.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
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 | |||
27082 | 27082 | USA | United States of America | Detroit | USA0003077 | 100.0 | 44.7224 | -122.2511 | Hydro | 1953.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35552 | 2019 | 276.902 | 372.019 | 222.452 | 282.2 | 359.779 | 379.298 | 247.809 | U.S. Energy Information Administration | 294.9 | 355.96 | 289.34 | 357.95 | 303.68 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-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 | |||
27237 | 27237 | USA | United States of America | Dworshak | USA0000840 | 465.0 | 46.5143 | -116.2977 | Hydro | 1974.443010752688 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35553 | 2019 | 1833.797 | 1744.669 | 1614.911 | 1693.686 | 1436.978 | 1598.478 | 1702.262 | U.S. Energy Information Administration | 1046.26 | 1191.22 | 963.72 | 1194.48 | 1091.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27777 | 27777 | USA | United States of America | Foster | USA0006552 | 20.0 | 44.4146 | -122.6712 | Hydro | 1968.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35558 | 2019 | 94.904 | 101.649 | 52.574 | 76.10000000000001 | 85.913 | 82.985 | 61.271 | U.S. Energy Information Administration | 80.13 | 94.84 | 67.57 | 79.62 | 79.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28284 | 28284 | USA | United States of America | Green Peter | USA0003080 | 80.0 | 44.4494 | -122.5494 | Hydro | 1967.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35563 | 2019 | 235.619 | 299.515 | 150.826 | 215.9 | 276.245 | 250.419 | 158.218 | U.S. Energy Information Administration | 212.9 | 287.04 | 213.59 | 271.04 | 244.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28639 | 28639 | USA | United States of America | Hills Creek | USA0003081 | 30.0 | 43.7107 | -122.4238 | Hydro | 1962.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35566 | 2019 | 129.042 | 108.905 | 76.69800000000001 | 96.5 | 157.222 | 122.105 | 116.765 | U.S. Energy Information Administration | 88.98 | 103.58 | 76.83 | 105.89 | 85.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28854 | 28854 | USA | United States of America | Ice Harbor | USA0003925 | 603.0 | 46.2498 | -118.8798 | Hydro | 1969.7313432835824 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35565 | 2019 | 1385.372 | 1725.926 | 1439.3 | 1667.942 | 2036.324 | 1710.952 | 1722.25 | U.S. Energy Information Administration | 1680.7 | 1648.96 | 1260.38 | 1653.48 | 2147.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29103 | 29103 | USA | United States of America | John Day | USA0003082 | 2160.0 | 45.7164 | -120.6941 | Hydro | 1969.5 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35570 | 2019 | 8893.007 | 9472.764 | 8679.505000000001 | 9171.812 | 10506.957 | 9192.949 | 7643.804 | U.S. Energy Information Administration | 9469.74 | 9446.84 | 9641.33 | 9472.72 | 8230.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29620 | 29620 | USA | United States of America | Libby | USA0006172 | 525.0 | 48.4098 | -115.3143 | Hydro | 1977.2 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35576 | 2019 | 2306.062 | 2513.693 | 1757.669 | 2185.485 | 2281.28 | 2056.393 | 1511.427 | U.S. Energy Information Administration | 1892.18 | 1708.09 | 1521.75 | 1891.78 | 1411.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29678 | 29678 | USA | United States of America | Little Goose | USA0003926 | 810.0 | 46.5838 | -118.0273 | Hydro | 1974.1666666666667 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35577 | 2019 | 1691.949 | 2224.6240000000003 | 1709.321 | 2039.508 | 2813.434 | 2452.129 | 2101.742 | U.S. Energy Information Administration | 2257.66 | 2215.02 | 1620.78 | 2221.09 | 2884.52 | 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 | |||
29762 | 29762 | USA | United States of America | Lost Creek | USA0006174 | 49.0 | 42.6717 | -122.6772 | Hydro | 1977.5 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35578 | 2019 | 232.649 | 257.301 | 214.887 | 239.2 | 85.81400000000001 | 220.524 | 265.582 | U.S. Energy Information Administration | 139.49 | 161.11 | 93.77 | 162.26 | 142.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29783 | 29783 | USA | United States of America | Lower Granite | USA0006175 | 810.0 | 46.6595 | -117.4294 | Hydro | 1976.5 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35573 | 2019 | 1680.189 | 2284.833 | 1698.509 | 2104.1040000000003 | 2666.506 | 2466.663 | 2192.833 | U.S. Energy Information Administration | 2257.66 | 2215.02 | 1620.78 | 2221.09 | 2884.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29787 | 29787 | USA | United States of America | Lower Monumental | USA0003927 | 810.0 | 46.5635 | -118.5397 | Hydro | 1974.1666666666667 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35574 | 2019 | 1697.014 | 2290.236 | 1640.095 | 1987.131 | 2767.576 | 2383.418 | 2240.943 | U.S. Energy Information Administration | 2257.66 | 2215.02 | 1693.05 | 2221.09 | 2884.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30090 | 30090 | USA | United States of America | McNary | USA0003084 | 990.5 | 45.9402 | -119.2988 | Hydro | 1955.1625441696112 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35579 | 2019 | 5270.314 | 5364.541 | 5150.3 | 5627.633 | 5709.423 | 5682.145 | 4474.352 | U.S. Energy Information Administration | 4704.4 | 4693.9 | 4783.08 | 4706.76 | 4136.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33339 | 33339 | USA | United States of America | The Dalles | USA0003895 | 1819.7 | 45.614 | -121.1346 | Hydro | 1964.1317799637304 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35547 | 2019 | 6523.862 | 6946.311 | 6388.086 | 6744.404 | 7061.6050000000005 | 7161.168000000001 | 5929.261 | U.S. Energy Information Administration | 7977.82 | 7958.52 | 8122.37 | 7980.32 | 6933.79 | 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");