global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
15 rows where capacity_mw = "18.8"
This data as json, CSV (advanced)
owner 9
country_long 6
- Germany 6
- United States of America 4
- United Kingdom 2
- Brazil 1
- China 1
- Japan 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3204 | 3204 | BRA | Brazil | Tacaicó | BRA0030789 | 18.8 | -9.0187 | -38.056 | Wind | 2015.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) | 1098333 | 2017 | 76.63 | 70.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | WIND-V1 | WIND-V1 | |||||||||||||||
6348 | 6348 | CHN | China | Heiniu | WKS0071677 | 18.8 | 41.095 | 120.3 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 28.55 | 30.74 | 30.32 | 30.67 | 32.21 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
12591 | 12591 | DEU | Germany | Biomass Generator #9 | WRI1006088 | 18.8 | 49.0115 | 9.6718 | Biomass | 2000.0 | EnBW Klenk Holzenergie GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
12922 | 12922 | DEU | Germany | HKW Göttingen | WRI1005788 | 18.8 | 51.5534 | 9.9337 | Gas | 1998.0 | Georg-August-Universität Göttingen Stiftung Öffentlichen Rechts | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 72.85 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
13255 | 13255 | DEU | Germany | Mahlwinkel Solar Power Plant | WRI1025898 | 18.8 | 52.387 | 11.8192 | Solar | Solarparc GmbH | http://www.solarparc.de | Industry About | 27.51 | 28.42 | 28.71 | 28.8 | 28.94 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
13442 | 13442 | DEU | Germany | P�tnitz Solar Power Plant | WRI1025892 | 18.8 | 54.2666 | 12.457 | Solar | Solarparc GmbH | http://www.solarparc.de | Industry About | 27.67 | 28.42 | 28.82 | 28.91 | 28.67 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
13638 | 13638 | DEU | Germany | Trier | WRI1006075 | 18.8 | 49.728 | 6.6245 | Hydro | 1961.0 | RWE Innogy GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1023106 | 96.92 | 81.36 | 88.93 | 80.51 | 72.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
13719 | 13719 | DEU | Germany | Werneuchen - Enerparc Solar Power Plant | WRI1030069 | 18.8 | 52.634 | 13.7603 | Solar | Enerparc AG | http://www.enerparc.de | Industry About | 27.73 | 28.39 | 28.41 | 28.79 | 28.84 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
16489 | 16489 | JPN | Japan | Asakawa | WKS0067748 | 18.8 | 37.06 | 140.41 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 30.16 | 30.65 | 30.18 | 29.53 | 30.15 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
22271 | 22271 | GBR | United Kingdom | Boxted Airfield | GBR0002143 | 18.8 | 51.9431 | 0.9296 | Solar | NextEnergy Solar Fund | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1106173 | 28.8 | 28.64 | 28.23 | 28.31 | 28.84 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24221 | 24221 | GBR | United Kingdom | Slieve Divena Phase 2 Wind Farm | GBR0004054 | 18.8 | 54.5086 | -7.1064 | Wind | Scottish and Southern Energy (SSE) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 47.39 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
25072 | 25072 | USA | United States of America | Animas | USA0002465 | 18.8 | 36.7251 | -108.192 | Gas | Hydro | 1993.287234042553 | City of Farmington - (NM) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20000 | 2019 | 145.515 | 137.532 | 49.414 | 24.01 | 11.923000000000002 | 34.004000000000005 | 1.421 | U.S. Energy Information Administration | 66.29 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
27581 | 27581 | USA | United States of America | Fairhaven Power | USA0010052 | 18.8 | 40.7995 | -124.2028 | Waste | Gas | 1986.0 | DG Fairhaven Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 19915 | 2019 | 115.52200100000002 | 123.768005 | 119.445998 | 68.637 | 1.013 | 39.619 | 64.55 | U.S. Energy Information Administration | 3.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
31962 | 31962 | USA | United States of America | River Mill | USA0003049 | 18.8 | 45.3 | -122.35 | Hydro | 1925.781914893617 | Portland General Electric Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30450 | 2019 | 95.907 | 104.995 | 74.12 | 105.219 | 110.181 | 88.007 | 70.301 | U.S. Energy Information Administration | 77.41 | 85.8 | 68.96 | 80.33 | 68.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33814 | 33814 | USA | United States of America | Victory Garden (Tehachapi) | USA0050532 | 18.8 | 35.0686 | -118.3833 | Wind | 1983.4361702127655 | Wind Stream Operations LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36025 | 2019 | 25.055 | 25.41 | 20.576 | 20.41 | 22.929 | 22.219 | 20.612 | U.S. Energy Information Administration | 22.85 | 28.5 | 29.47 | 29.46 | 27.04 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-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");