global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
6 rows where commissioning_year = "1971.0", primary_fuel = "Hydro" and source = "U.S. Energy Information Administration"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27726 | 27726 | USA | United States of America | Foothill | USA0000396 | 10.1 | 34.3182 | -118.4944 | Hydro | 1971.0 | Los Angeles Department of Water & Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25088 | 2019 | 25.424 | 19.917 | 3.186 | 31.469 | 42.694 | -8.344 | -0.086 | U.S. Energy Information Administration | 25.22 | 25.47 | 22.65 | 25.62 | 21.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29277 | 29277 | USA | United States of America | Keowee | USA0006517 | 157.6 | 34.7981 | -82.8872 | Hydro | 1971.0 | Duke Energy Carolinas LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18725 | 2019 | 72.872 | 58.482 | 61.534 | 53.797 | 31.968 | 98.14 | 84.363 | U.S. Energy Information Administration | 406.87 | 360.99 | 330.88 | 407.86 | 255.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29745 | 29745 | USA | United States of America | Loon Lake | USA0000432 | 74.1 | 38.9827 | -120.3245 | Hydro | 1971.0 | Sacramento Municipal Util Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 31872 | 2019 | 53.258 | 55.822 | 31.161 | 92.67 | 200.464 | 54.595 | 110.999 | U.S. Energy Information Administration | 214.11 | 214.11 | 195.45 | 214.7 | 183.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30431 | 30431 | USA | United States of America | Morrow Point | USA0000514 | 173.2 | 38.4518 | -107.5393 | Hydro | 1971.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35657 | 2019 | 183.431 | 295.791 | 341.545 | 326.77500000000003 | 338.514 | 321.447 | 296.887 | U.S. Energy Information Administration | 580.77 | 545.5 | 460.72 | 522.03 | 456.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30936 | 30936 | USA | United States of America | Oconto Falls Lower | USA0050439 | 2.0 | 44.8719 | -88.1439 | Hydro | 1971.0 | N E W Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32276 | 2019 | 6.734 | 8.591 | 8.725 | 8.939 | 11.771 | 8.232 | 11.421 | U.S. Energy Information Administration | 6.78 | 7.07 | 7.6 | 7.07 | 7.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32003 | 32003 | USA | United States of America | Robert S Kerr | USA0002985 | 110.0 | 35.3445 | -94.7755 | Hydro | 1971.0 | USCE-Tulsa District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35588 | 2019 | 465.039 | 313.097 | 491.999 | 506.024 | 458.2 | 429.195 | 543.0 | U.S. Energy Information Administration | 450.59 | 466.96 | 408.34 | 467.58 | 376.84 | 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");