global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
5 rows where country_long = "United States of America", other_fuel3 = "Gas", primary_fuel = "Waste" and url = "http://www.eia.gov/electricity/data/browser/"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26769 | 26769 | USA | United States of America | Covington Facility | USA0050900 | 160.9 | 37.7997 | -79.9947 | Waste | Coal | Oil | Gas | 1996.9092604101927 | WestRock Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 654.0343009999999 | 893.091209 | 1010.363143 | 961.4690050000002 | 928.862008 | 1006.484008 | 904.765987 | U.S. Energy Information Administration | 29.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
27703 | 27703 | USA | United States of America | Florence Mill | USA0050806 | 103.8 | 34.1497 | -79.5606 | Waste | Coal | Oil | Gas | 1982.2774566473988 | WestRock-Florence | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33749 | 2019 | 511.2858110000001 | 493.171663 | 441.1551 | 467.393378 | 458.430888 | 440.132381 | 360.375623 | U.S. Energy Information Administration | 18.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
28959 | 28959 | USA | United States of America | International Paper Pine Hill Mill | USA0054752 | 77.4 | 31.9698 | -87.4806 | Waste | Coal | Oil | Gas | 1974.7648578811363 | International Paper Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25337 | 2019 | 498.698203 | 461.168001 | 376.573 | 476.045003 | 490.279994 | 475.378001 | 475.439003 | U.S. Energy Information Administration | 14.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
30734 | 30734 | USA | United States of America | Nippon Dynawave Packaging Longview WA | USA0050187 | 62.4 | 46.1236 | -122.9728 | Waste | Coal | Oil | Gas | 1963.8205128205127 | Nippon Dynawave Packaging Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 321.76493700000003 | 322.607004 | 292.75682400000005 | 284.06338800000003 | 251.064045 | 294.26080200000007 | 276.10884 | U.S. Energy Information Administration | 11.3 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
34165 | 34165 | USA | United States of America | WestRock Panama City Mill | USA0050807 | 34.0 | 30.142 | -85.6211 | Waste | Coal | Oil | Gas | 1950.8823529411768 | WestRock Corp-Panama City | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33752 | 2019 | 232.988257 | 236.607092 | 253.096996 | 252.692085 | 249.96188300000003 | 197.50869000000003 | 195.430539 | U.S. Energy Information Administration | 6.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");