global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where estimated_generation_note_2017 = "HYDRO-V1", generation_data_source = "U.S. Energy Information Administration" and owner = "Alabama Power Co"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25329 | 25329 | USA | United States of America | Bankhead Dam | USA0000002 | 53.9 | 33.4587 | -87.3568 | Hydro | 1963.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12576 | 2019 | 211.342 | 47.391 | 25.92 | -0.325 | -0.291 | -0.392 | -0.284 | U.S. Energy Information Administration | 205.92 | 201.88 | 169.21 | 204.86 | 162.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28359 | 28359 | USA | United States of America | H Neely Henry Dam | USA0000011 | 72.9 | 33.7845 | -86.0524 | Hydro | 1966.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12587 | 2019 | 297.81 | 198.568 | 198.745 | 154.855 | 176.239 | 252.836 | 251.681 | U.S. Energy Information Administration | 265.01 | 266.61 | 206.19 | 263.84 | 220.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28469 | 28469 | USA | United States of America | Harris Dam | USA0006188 | 135.0 | 33.2583 | -85.616 | Hydro | 1983.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12584 | 2019 | 201.884 | 147.978 | 157.611 | 114.934 | 136.982 | 167.486 | 157.954 | U.S. Energy Information Administration | 411.33 | 410.15 | 341.98 | 407.0 | 324.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28686 | 28686 | USA | United States of America | Holt Dam | USA0000012 | 46.9 | 33.2553 | -87.4495 | Hydro | 1968.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12588 | 2019 | 193.247 | 72.223 | 30.242 | 129.325 | 154.683 | 168.817 | 169.711 | U.S. Energy Information Administration | 179.18 | 180.66 | 144.56 | 178.95 | 141.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29141 | 29141 | USA | United States of America | Jordan Dam | USA0000013 | 100.0 | 32.6189 | -86.2548 | Hydro | 1929.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12589 | 2019 | 477.075 | 294.067 | 336.479 | 269.244 | 211.906 | 435.727 | 399.857 | U.S. Energy Information Administration | 383.69 | 383.69 | 281.98 | 384.74 | 323.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29570 | 29570 | USA | United States of America | Lay Dam | USA0000015 | 177.0 | 32.9633 | -86.5187 | Hydro | 1967.5 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12592 | 2019 | 774.445 | 561.938 | 557.768 | 404.623 | 499.669 | 685.072 | 667.283 | U.S. Energy Information Administration | 603.52 | 603.52 | 440.76 | 598.78 | 507.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29614 | 29614 | USA | United States of America | Lewis Smith Dam | USA0000018 | 181.0 | 33.9406 | -87.1077 | Hydro | 1961.5 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12590 | 2019 | 321.245 | 243.605 | 241.085 | 233.853 | 202.916 | 237.885 | 410.236 | U.S. Energy Information Administration | 527.46 | 528.47 | 425.36 | 477.59 | 443.55 | 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 | |||
30017 | 30017 | USA | United States of America | Martin Dam | USA0000016 | 210.6 | 32.6804 | -85.9114 | Hydro | 1934.122507122507 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12593 | 2019 | 412.885 | 348.048 | 289.985 | 304.289 | 318.416 | 348.53000000000003 | 411.795 | U.S. Energy Information Administration | 646.35 | 618.0 | 547.51 | 641.78 | 493.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30313 | 30313 | USA | United States of America | Mitchell Dam | USA0000017 | 170.0 | 32.806 | -86.4449 | Hydro | 1980.764705882353 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12594 | 2019 | 673.1850000000001 | 466.344 | 465.039 | 372.569 | 428.126 | 543.3050000000001 | 539.163 | U.S. Energy Information Administration | 579.65 | 579.65 | 421.87 | 581.24 | 489.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33380 | 33380 | USA | United States of America | Thurlow Dam | USA0000019 | 91.0 | 32.5354 | -85.8876 | Hydro | 1931.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12596 | 2019 | 277.802 | 228.345 | 193.624 | 200.64 | 217.582 | 209.097 | 239.763 | U.S. Energy Information Administration | 324.43 | 326.27 | 274.29 | 332.69 | 269.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33949 | 33949 | USA | United States of America | Walter Bouldin Dam | USA0000004 | 225.0 | 32.5839 | -86.2831 | Hydro | 1967.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12597 | 2019 | 812.071 | 590.121 | 560.467 | 468.96 | 628.655 | 687.921 | 723.69 | U.S. Energy Information Administration | 501.21 | 321.02 | 410.28 | 433.49 | 209.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34087 | 34087 | USA | United States of America | Weiss Dam | USA0000020 | 87.6 | 34.1721 | -85.7538 | Hydro | 1961.3333333333333 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12598 | 2019 | 317.61 | 209.892 | 212.172 | 164.092 | 177.879 | 280.944 | 272.027 | U.S. Energy Information Administration | 320.38 | 325.37 | 227.78 | 320.83 | 261.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34501 | 34501 | USA | United States of America | Yates Dam | USA0000021 | 50.5 | 32.5743 | -85.8901 | Hydro | 1928.0 | Alabama Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12600 | 2019 | 158.284 | 138.401 | 117.278 | 116.654 | 125.786 | 142.992 | 155.736 | U.S. Energy Information Administration | 180.04 | 181.06 | 147.31 | 184.62 | 149.36 | 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");