global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
13 rows where country_long = "United States of America", estimated_generation_note_2013 = "HYDRO-V1", owner = "Great River Hydro LLC" and source = "U.S. Energy Information Administration"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, commissioning_year, generation_gwh_2013, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_gwh_2017
primary_fuel 1
- Hydro 13
owner 1
- Great River Hydro LLC · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25469 | 25469 | USA | United States of America | Bellows Falls | USA0003745 | 40.8 | 43.1375 | -72.4464 | Hydro | 1928.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27424 | 2019 | 248.673 | 236.573 | 215.228 | 183.361 | 238.173 | 246.119 | 255.044 | U.S. Energy Information Administration | 150.45 | 150.45 | 104.58 | 150.86 | 128.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26622 | 26622 | USA | United States of America | Comerford | USA0002349 | 167.79999999999998 | 44.3251 | -72.001 | Hydro | 1930.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27428 | 2019 | 323.101 | 353.812 | 343.511 | 290.397 | 379.605 | 352.5 | 417.404 | U.S. Energy Information Administration | 506.31 | 557.38 | 343.18 | 505.51 | 465.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27013 | 27013 | USA | United States of America | Deerfield 2 | USA0006047 | 4.800000000000001 | 42.5731 | -72.7073 | Hydro | 1913.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27432 | 2019 | 0.0 | 8.266 | 22.096 | 22.468 | 32.186 | 35.585 | 32.088 | U.S. Energy Information Administration | 15.24 | 16.98 | 15.16 | 15.76 | 13.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27014 | 27014 | USA | United States of America | Deerfield 3 | USA0006083 | 4.800000000000001 | 42.5995 | -72.7335 | Hydro | 1912.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27431 | 2019 | 24.839 | 24.727 | 19.339 | 19.922 | 30.378 | 33.332 | 27.192 | U.S. Energy Information Administration | 15.24 | 16.98 | 15.16 | 15.76 | 13.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27015 | 27015 | USA | United States of America | Deerfield 4 | USA0006119 | 4.800000000000001 | 42.6198 | -72.7376 | Hydro | 1912.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27430 | 2019 | 0.0 | 6.43 | 16.851 | 15.458 | 24.984 | 27.922 | 22.886 | U.S. Energy Information Administration | 15.24 | 16.98 | 15.16 | 15.76 | 13.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27016 | 27016 | USA | United States of America | Deerfield 5 | USA0001620 | 17.5 | 42.6912 | -72.9561 | Hydro | 1974.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27429 | 2019 | 53.284 | 53.059000000000005 | 40.255 | 37.478 | 60.976 | 63.577 | 52.161 | U.S. Energy Information Administration | 58.04 | 58.32 | 44.98 | 50.13 | 50.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28466 | 28466 | USA | United States of America | Harriman | USA0003746 | 33.599999999999994 | 42.7936 | -72.9144 | Hydro | 1924.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27435 | 2019 | 97.944 | 99.382 | 64.71300000000001 | 65.211 | 110.915 | 128.821 | 103.662 | U.S. Energy Information Administration | 96.09 | 96.09 | 74.13 | 87.01 | 78.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30097 | 30097 | USA | United States of America | Mcindoes | USA0006483 | 10.4 | 44.2603 | -72.0592 | Hydro | 1931.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 47.147 | 41.056 | 43.073 | 44.241 | 35.421 | 45.725 | 48.652 | U.S. Energy Information Administration | 47.4 | 49.08 | 37.47 | 48.63 | 43.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
32138 | 32138 | USA | United States of America | S C Moore | USA0002351 | 190.8 | 44.3356 | -71.8742 | Hydro | 1957.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27445 | 2019 | 267.08 | 280.85 | 268.199 | 233.359 | 317.125 | 266.391 | 336.232 | U.S. Energy Information Administration | 578.24 | 636.31 | 390.21 | 577.33 | 531.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32421 | 32421 | USA | United States of America | Searsburg | USA0006529 | 4.0 | 42.8708 | -72.9273 | Hydro | 1922.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21412 | 2019 | 16.644000000000002 | 16.896 | 12.657 | 13.925 | 19.721 | 23.189 | 19.391 | U.S. Energy Information Administration | 8.97 | 8.97 | 8.78 | 9.0 | 7.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32526 | 32526 | USA | United States of America | Sherman | USA0006012 | 7.2 | 42.7297 | -72.9303 | Hydro | 1927.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27447 | 2019 | 24.085 | 29.238 | 22.397 | 21.901 | 32.692 | 35.228 | 30.308 | U.S. Energy Information Administration | 24.01 | 24.13 | 19.22 | 20.76 | 20.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33789 | 33789 | USA | United States of America | Vernon Dam | USA0002352 | 35.9 | 42.7717 | -72.5146 | Hydro | 1964.2033426183843 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27450 | 2019 | 166.322 | 161.162 | 143.288 | 140.137 | 152.349 | 162.364 | 162.336 | U.S. Energy Information Administration | 141.6 | 131.32 | 90.13 | 141.85 | 118.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34305 | 34305 | USA | United States of America | Wilder | USA0002353 | 35.6 | 43.6679 | -72.3036 | Hydro | 1953.325842696629 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27451 | 2019 | 162.5 | 149.245 | 138.953 | 143.302 | 165.472 | 149.637 | 164.637 | U.S. Energy Information Administration | 139.66 | 135.36 | 103.93 | 138.56 | 116.1 | 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");