global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
16 rows where commissioning_year = "1978.0" and primary_fuel = "Oil"
This data as json, CSV (advanced)
Suggested facets: country, url, geolocation_source
owner 8
country_long 5
- United States of America 10
- Brazil 2
- Saudi Arabia 2
- Germany 1
- Iran 1
primary_fuel 1
- Oil · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1178 | 1178 | BRA | Brazil | Aeroporto Internacional de Viracopos - Campinas | BRA0029369 | 3.865 | -23.0029 | -47.1249 | Oil | 1978.0 | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 2017 | 7.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
2360 | 2360 | BRA | Brazil | MRN UG I (Antiga Porto Trombetas) | BRA0002130 | 15.3 | -1.762 | -55.8565 | Oil | 1978.0 | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 1022645 | 2017 | 30.23 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
13507 | 13507 | DEU | Germany | SKW Diesel | WRI1006049 | 10.5 | 47.6835 | 10.3191 | Oil | 1978.0 | Allgäuer Ãœberlandwerk GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1116241 | 15.67 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
15836 | 15836 | IRN | Iran | Chahbahar (Kenarak) | WRI1008126 | 64.0 | 25.2919 | 60.643 | Oil | 1978.0 | TAVANIR | http://www2.tavanir.org.ir/info/stat87/sanatlhtml/Links/j14%20-1/main.htm | CARMA | 1031063 | 176.41 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
19759 | 19759 | SAU | Saudi Arabia | JEDDAH NO.2 | WRI1030660 | 157.9 | 21.45 | 39.186 | Oil | 1978.0 | Saudi Electricity Company (SEC) | ECRA | http://www.ecra.gov.sa/en-us/DataAndStatistics/NationalRecord/StationCapacities/Pages/Home.aspx | WRI | 1028200 | 425.01 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
19794 | 19794 | SAU | Saudi Arabia | Riyadh 4 | WRI1030686 | 336.6 | 24.65 | 46.671 | Oil | 1978.0 | Saudi Electricity Company (SEC) | ECRA | http://www.ecra.gov.sa/en-us/DataAndStatistics/NationalRecord/StationCapacities/Pages/Home.aspx | WRI | 1073623 | 906.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
27878 | 27878 | USA | United States of America | Front Street | USA0007396 | 8.100000000000001 | 42.1483 | -72.5911 | Oil | 1978.0 | City of Chicopee - (MA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 16231 | 2019 | 0.731 | 1.883 | 0.927 | 0.188 | 0.439 | 0.844 | 0.089 | U.S. Energy Information Administration | 4.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29475 | 29475 | USA | United States of America | Lake Preston | USA0003352 | 24.1 | 44.3649 | -97.3811 | Oil | 1978.0 | Otter Tail Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29246 | 2019 | 0.21 | 0.541 | 0.145 | 0.41 | 0.38 | 0.496 | 0.251 | U.S. Energy Information Administration | 14.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29946 | 29946 | USA | United States of America | Maple Lake | USA0002042 | 25.0 | 45.2291 | -94.0097 | Oil | 1978.0 | Great River Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35364 | 2019 | 0.22 | 0.452 | 0.131 | 0.288 | 0.26 | 0.38 | 0.494 | U.S. Energy Information Administration | 14.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30182 | 30182 | USA | United States of America | Mexico | USA0006650 | 60.7 | 39.1481 | -91.8306 | Oil | 1978.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35261 | 2019 | -0.244 | 1.48 | -0.128 | -0.01 | -0.214 | 0.312 | 0.22 | U.S. Energy Information Administration | 35.57 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30316 | 30316 | USA | United States of America | Moberly | USA0006651 | 60.6 | 39.4244 | -92.4837 | Oil | 1978.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35267 | 2019 | 0.022 | 0.547 | -0.198 | -0.195 | -0.299 | 0.279 | 2.125 | U.S. Energy Information Administration | 35.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30406 | 30406 | USA | United States of America | Moreau | USA0006652 | 60.8 | 38.5557 | -92.1023 | Oil | 1978.0 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35263 | 2019 | -0.176 | -0.043 | -0.443 | -0.14 | -0.162 | 0.279 | 1.711 | U.S. Energy Information Administration | 35.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32021 | 32021 | USA | United States of America | Rock Lake CT | USA0006741 | 25.0 | 45.8054 | -92.9718 | Oil | 1978.0 | Great River Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35368 | 2019 | 0.217 | 0.269 | 0.149 | 0.274 | 0.308 | 0.245 | 0.743 | U.S. Energy Information Administration | 14.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32845 | 32845 | USA | United States of America | Spirit Mound | USA0006092 | 135.0 | 42.8977 | -96.9905 | Oil | 1978.0 | Basin Electric Power Coop | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 14081 | 2019 | 1.047 | 1.567 | 0.244 | 0.784 | 0.346 | 0.8190000000000001 | 5.4 | U.S. Energy Information Administration | 79.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32888 | 32888 | USA | United States of America | St Bonifacius | USA0006824 | 61.2 | 44.905 | -93.8208 | Oil | 1978.0 | Great River Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17631 | 2019 | 0.538 | 0.685 | 0.379 | 0.639 | 0.536 | 0.608 | 0.489 | U.S. Energy Information Administration | 35.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34047 | 34047 | USA | United States of America | Watertown Power Plant | USA0007247 | 67.5 | 44.9017 | -97.1083 | Oil | 1978.0 | Missouri Basin Muni Power Agny | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.072 | 0.143 | 0.091 | 0.141 | 0.104 | 1.991 | U.S. Energy Information Administration | 39.56 | 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");