global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where capacity_mw = "9.0" and primary_fuel = "Oil"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
635 | 635 | AUS | Australia | Norseman Mine | AUS0000320 | 9.0 | -32.1963 | 121.7943 | Oil | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1055547 | 27.85527777777778 | 16.33888888888889 | 14.14611111111111 | 15.068055555555556 | 8.275833333333333 | 4.322777777777778 | Australia Clean Energy Regulator | 17.38 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
4804 | 4804 | CHL | Chile | CHILOE | CHL0000082 | 9.0 | -43.0914 | -73.6155 | Oil | ELEKTRAGEN | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1091253 | 2016 | 5.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4816 | 4816 | CHL | Chile | CONSTITUCION | CHL0000096 | 9.0 | -35.3604 | -72.4069 | Oil | ELEKTRAGEN | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1016288 | 2016 | 5.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4950 | 4950 | CHL | Chile | MONTE PATRIA | CHL0000077 | 9.0 | -30.6968 | -70.9491 | Oil | ELEKTRAGEN | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1091255 | 2016 | 5.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
4983 | 4983 | CHL | Chile | PUNITAQUI | CHL0000079 | 9.0 | -30.858 | -71.2406 | Oil | ELEKTRAGEN | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 1091256 | 2016 | 5.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
18396 | 18396 | PHL | Philippines | PETERSVILLE DPP | WRI1001913 | 9.0 | 15.15 | 120.5833 | Oil | Philippines Department of Energy | https://www.doe.gov.ph/list-existing-power-plants | CARMA | 1010181 | 6.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23523 | 23523 | GBR | United Kingdom | Loch Carnan South Uist | GBR1000415 | 9.0 | 57.25 | -7.35 | Oil | Scottish and Southern: Island Generation | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028322 | 4.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
25482 | 25482 | USA | United States of America | Benson City of | USA0001964 | 9.0 | 45.3144 | -95.6028 | Oil | 2002.0 | City of Benson - (MN) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.172 | 0.071 | 0.088 | 0.077 | 0.044 | 0.089 | 0.106 | U.S. Energy Information Administration | 5.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
26867 | 26867 | USA | United States of America | Cuyahoga Falls 1 | USA0062658 | 9.0 | 41.1418 | -81.4745 | Oil | 2018.0 | City of Cuyahoga Falls - (OH) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.3 | 0.244 | U.S. Energy Information Administration | 5.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
28826 | 28826 | USA | United States of America | IMEA Flora | USA0056116 | 9.0 | 38.6658 | -88.4625 | Oil | 2001.0 | Illinois Municipal Elec Agency | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 49063 | 2019 | 0.066 | 0.045 | 0.099 | 0.061 | 0.181 | 0.05 | 0.064 | U.S. Energy Information Administration | 5.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29104 | 29104 | USA | United States of America | John Deere Dubuque Works | USA0054414 | 9.0 | 42.5734 | -90.6926 | Oil | 1994.0 | John Deere Dubuque Works | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23238 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.049 | U.S. Energy Information Administration | 5.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30145 | 30145 | USA | United States of America | Meridian | USA0007719 | 9.0 | 32.5508 | -88.6067 | Oil | 1998.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 41318 | 2019 | 0.096 | 0.072 | 0.0 | 0.043 | 0.011 | 0.039 | 0.008 | U.S. Energy Information Administration | 5.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31293 | 31293 | USA | United States of America | Pawhuska | USA0002995 | 9.0 | 36.6694 | -96.3474 | Oil | 1959.0222222222224 | City of Pawhuska - (OK) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29767 | 2019 | 0.037 | 0.018 | 0.122 | 0.01 | 0.037 | 0.039 | 0.157 | U.S. Energy Information Administration | 5.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32870 | 32870 | USA | United States of America | Springfield (MN) | USA0002012 | 9.0 | 44.2395 | -94.9763 | Oil | 1997.4 | Springfield Public Utils Comm - (MN) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33396 | 2019 | 0.013 | 0.098 | 0.01 | 0.023 | 0.01 | 0.0 | 0.0 | U.S. Energy Information Administration | 5.27 | 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");