global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
17 rows where estimated_generation_note_2015 = "NO-ESTIMATION", other_fuel1 = "Petcoke" and primary_fuel = "Coal"
This data as json, CSV (advanced)
owner 15
- Big Rivers Electric Corp 2
- E-CL 2
- AES GENER 1
- AES GENER S.A. 1
- City of Owensboro - (KY) 1
- DTE Electric Company 1
- EIF Northampton GP LLC 1
- Entergy Louisiana LLC 1
- JEA 1
- Louisville Gas & Electric Co 1
- Major Oak Power LLC 1
- NRG Texas Power LLC 1
- Somerset Operating Co LLC 1
- Southern Illinois Power Coop 1
- Tampa Electric Co 1
country_long 2
primary_fuel 1
- Coal · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4875 | 4875 | CHL | Chile | GUACOLDA | CHL0000053 | 760.0 | -28.4673 | -71.2573 | Coal | Petcoke | AES GENER S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015665 | 2016 | 4192.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5053 | 5053 | CHL | Chile | TERMOELECTRICA MEJILLONES (CTM1) | CHL0000015 | 318.9 | -23.0854 | -70.41 | Coal | Petcoke | E-CL | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015642 | 2016 | 1759.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5054 | 5054 | CHL | Chile | TERMOELECTRICA NORGENER (NTO2) | CHL0000016 | 259.3 | -22.097 | -70.2109 | Coal | Petcoke | AES GENER | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1024261 | 2016 | 1430.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
5056 | 5056 | CHL | Chile | TERMOELECTRICA TOCOPILLA (U12) | CHL0000017 | 1001.7 | -22.091 | -70.2126 | Coal | Petcoke | E-CL | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1015364 | 2016 | 5526.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
25528 | 25528 | USA | United States of America | Big Bend | USA0000645 | 1903.5 | 27.7944 | -82.4036 | Coal | Petcoke | Oil | Gas | 1977.675597583399 | Tampa Electric Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34153 | 2019 | 9546.163035 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3889.9230000000007 | U.S. Energy Information Administration | 8792.6 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
26875 | 26875 | USA | United States of America | D B Wilson | USA0006823 | 509.4 | 37.4497 | -87.0806 | Coal | Petcoke | Oil | 1984.0 | Big Rivers Electric Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14483 | 2019 | 3324.805988 | 2995.417995 | 3250.8110050000005 | 3114.893969 | 2649.782999 | 2256.297042 | 2639.483996 | U.S. Energy Information Administration | 2353.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
27424 | 27424 | USA | United States of America | Elmer Smith | USA0001374 | 445.3 | 37.7942 | -87.0608 | Coal | Petcoke | Other | 1970.335055019088 | City of Owensboro - (KY) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29282 | 2019 | 2684.290029 | 2370.7859950000006 | 2300.2249560000005 | 1955.4629760000005 | 1780.260997 | 2209.9149570000004 | 1604.912991 | U.S. Energy Information Administration | 2056.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
29642 | 29642 | USA | United States of America | Limestone | USA0000298 | 1849.8 | 31.4219 | -96.2525 | Coal | Petcoke | Gas | 1986.5172451075791 | NRG Texas Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22399 | 2019 | 12872.030973 | 11977.24606 | 9164.672004 | 9161.346999 | 9199.36604 | 0.0 | 8700.388997 | U.S. Energy Information Administration | 8544.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
29912 | 29912 | USA | United States of America | Major Oak Power | USA0007030 | 349.2 | 31.0919 | -96.695 | Coal | Petcoke | Gas | 1990.5 | Major Oak Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2068.248013 | 2316.751979 | 2434.4130400000004 | 2467.58902 | 2383.547046 | 2457.778991 | 2413.9239580000003 | U.S. Energy Information Administration | 1613.01 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29970 | 29970 | USA | United States of America | Marion | USA0000976 | 422.0 | 37.6197 | -88.9531 | Coal | Petcoke | Oil | Gas | 1983.367298578199 | Southern Illinois Power Coop | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33045 | 2019 | 1719.44396 | 1726.722046 | 1800.858987 | 1655.060966 | 0.0 | 1718.9139750000002 | 1652.0190200000002 | U.S. Energy Information Administration | 1949.29 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
30343 | 30343 | USA | United States of America | Monroe (MI) | USA0001733 | 3293.0999999999995 | 41.8906 | -83.3464 | Coal | Petcoke | Oil | 1972.7370866356928 | DTE Electric Company | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18393 | 2019 | 16182.420814 | 15294.861534 | 16149.154436 | 14024.752309 | 15587.053891 | 16457.510733 | 15321.784179 | U.S. Energy Information Administration | 15211.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
30812 | 30812 | USA | United States of America | Northampton Generating Company LP | USA0050888 | 134.1 | 40.6917 | -75.4792 | Coal | Petcoke | Waste | Other | 1995.0 | EIF Northampton GP LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35711 | 2019 | 0.0 | 0.0 | 0.0 | 274.923997 | 0.0 | 0.0 | 154.377 | U.S. Energy Information Administration | 619.43 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
30832 | 30832 | USA | United States of America | Northside Generating Station | USA0000667 | 1407.1 | 30.4172 | -81.5525 | Coal | Petcoke | Waste | Gas | 1973.2640892616016 | JEA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23467 | 2019 | 2770.8150100000003 | 3709.207914 | 3787.823998 | 4733.0289840000005 | 2870.527027 | 4278.072985 | 3878.238965000001 | U.S. Energy Information Administration | 6499.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
31706 | 31706 | USA | United States of America | R D Green | USA0006639 | 586.0 | 37.6461 | -87.5 | Coal | Petcoke | 1980.5 | Big Rivers Electric Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14484 | 2019 | 3374.932004 | 3462.7439540000005 | 2584.02797 | 2736.30103 | 2410.041982 | 3059.098002 | 2344.525975 | U.S. Energy Information Administration | 2706.83 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
31712 | 31712 | USA | United States of America | R S Nelson | USA0001393 | 1433.6 | 30.2844 | -93.2911 | Coal | Petcoke | Gas | 1973.401227678572 | Entergy Louisiana LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27331 | 2019 | 6069.249925 | 5023.290948 | 4035.700058 | 4148.850008 | 4279.702003 | 4283.308014 | 3211.2479060000005 | U.S. Energy Information Administration | 6622.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
32730 | 32730 | USA | United States of America | Somerset Operating Co LLC | USA0006082 | 655.1 | 43.3589 | -78.6047 | Coal | Petcoke | 1984.0 | Somerset Operating Co LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27592 | 2019 | 2073.695031 | 1786.614034 | 614.8829969999999 | 627.632005 | 347.691997 | 592.959 | 345.276004 | U.S. Energy Information Administration | 3026.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
33485 | 33485 | USA | United States of America | Trimble County | USA0006071 | 2594.1 | 38.5847 | -85.4117 | Coal | Petcoke | Oil | Gas | 2003.106703673721 | Louisville Gas & Electric Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25151 | 2019 | 8026.243994 | 8243.229978 | 9279.413002 | 8555.402961000002 | 8409.078036 | 9025.847943 | 8823.366957 | U.S. Energy Information Administration | 11982.6 | 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");