global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
18 rows where estimated_generation_gwh_2017 = "3.86"
This data as json, CSV (advanced)
Suggested facets: year_of_capacity_data, estimated_generation_note_2016
owner 14
- Bankstown Sports Club 1
- Centrale Hydroélectrique La Sarre 1/Hydro-Abitibi Inc 1
- City of Elroy - (WI) 1
- City of Osawatomie - (KS) 1
- City of Shelbina - (MO) 1
- CoServ Electric 1
- EQUIPOS DE GENERACION S.A. 1
- Mt.Sinai-St.Lukes Rsvlt. Hospital Center 1
- Redwood Falls Public Util Comm 1
- SRE Utility Solar 1 LLC 1
- Syncarpha Alethea I LLC 1
- Westward Seafoods Inc 1
- Yakama Power 1
- Yakima-Tieton Irrigation Dist 1
country_long 5
- United States of America 11
- France 4
- Australia 1
- Canada 1
- Chile 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
349 | 349 | AUS | Australia | Bankstown Sports Club | AUS0000399 | 2.0 | -33.9197 | 151.0332 | Oil | Bankstown Sports Club | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
4112 | 4112 | CAN | Canada | La Sarre-1 | CAN0008019 | 1.1 | 48.8473 | -79.1497 | Hydro | Centrale Hydroélectrique La Sarre 1/Hydro-Abitibi Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22582 | 2017 | 3.84 | 3.86 | 3.92 | 3.97 | 3.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4882 | 4882 | CHL | Chile | INACAL | CHL0000008 | 6.6 | -23.7819 | -70.3202 | Oil | EQUIPOS DE GENERACION S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 2016 | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
10535 | 10535 | FRA | France | Bourgbarré | WRI1025128 | 2.74268 | 47.9887 | -1.6222 | Solar | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 3.9 | 3.86 | 3.88 | 3.87 | 3.86 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
10980 | 10980 | FRA | France | Gambsheim | WRI1025694 | 1.1 | 48.6926 | 7.8845 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 3.74 | 4.38 | 3.87 | 3.75 | 3.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
11153 | 11153 | FRA | France | La Garde | WRI1025273 | 2.05746 | 43.1267 | 6.0191 | Solar | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 3.76 | 3.76 | 3.81 | 3.79 | 3.86 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
11669 | 11669 | FRA | France | Ornon | WRI1025542 | 1.3 | 45.0405 | 5.9651 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 3.08 | 3.25 | 3.88 | 3.26 | 3.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
24914 | 24914 | USA | United States of America | Alethea I | USA0058519 | 2.8 | 40.0006 | -74.735 | Solar | 2011.0 | Syncarpha Alethea I LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.74 | 3.5700000000000003 | 3.518 | 3.675 | 3.5620000000000003 | 3.136 | 3.86 | U.S. Energy Information Administration | 4.35 | 4.31 | 4.45 | 4.01 | 3.86 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | ||||
26532 | 26532 | USA | United States of America | CoServ Community Solar Station | USA0060427 | 2.0 | 33.2706 | -96.9792 | Solar | 2015.0 | CoServ Electric | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 69547 | 2019 | 1.686 | 3.754 | 3.727 | 3.4410000000000003 | 3.708 | U.S. Energy Information Administration | 3.75 | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | SOLAR-V1 | ||||||||
27193 | 27193 | USA | United States of America | Drop 3 (WA) | USA0006508 | 1.6 | 46.4231 | -120.56 | Hydro | 1932.0 | Yakama Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35611 | 2019 | 0.0 | U.S. Energy Information Administration | 4.4 | 4.43 | 4.61 | 4.44 | 3.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
27427 | 27427 | USA | United States of America | Elroy | USA0004113 | 6.6 | 43.7395 | -90.2675 | Oil | Gas | 1995.3030303030305 | City of Elroy - (WI) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 19285 | 2019 | 0.034 | 0.02 | 0.013 | 0.034 | 0.023 | 0.033 | 0.06 | U.S. Energy Information Administration | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
28920 | 28920 | USA | United States of America | Innovative Solar 23 | USA0059670 | 1.9 | 35.2598 | -81.419 | Solar | 2016.0 | SRE Utility Solar 1 LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.007 | 3.939 | 3.904 | 3.741 | 3.748 | U.S. Energy Information Administration | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | ||||||||||
30490 | 30490 | USA | United States of America | Mt.Sinai-St.Lukes Roosevelt Hosp. Center | USA0062453 | 6.6 | 40.9288 | -73.898 | Oil | 2007.1818181818185 | Mt.Sinai-St.Lukes Rsvlt. Hospital Center | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.062 | U.S. Energy Information Administration | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
31026 | 31026 | USA | United States of America | Orchard Avenue 1 | USA0050421 | 1.6 | 46.5964 | -120.6775 | Hydro | 1987.0 | Yakima-Tieton Irrigation Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.968 | 3.358 | 3.465 | 3.339 | 2.79 | 3.086 | 2.52 | U.S. Energy Information Administration | 4.4 | 4.43 | 4.61 | 4.44 | 3.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31062 | 31062 | USA | United States of America | Osawatomie City of | USA0001314 | 6.6 | 38.5017 | -94.9601 | Oil | Gas | 1959.9545454545455 | City of Osawatomie - (KS) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29185 | 2019 | 0.028 | 0.002 | 0.005 | 0.028 | 0.009 | 0.0196 | 0.011 | U.S. Energy Information Administration | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
32500 | 32500 | USA | United States of America | Shelbina Power #2 | USA0007406 | 6.6000000000000005 | 39.6948 | -92.0467 | Oil | 1993.909090909091 | City of Shelbina - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32521 | 2019 | 0.02646 | 0.061 | 0.034 | 0.028 | 0.058 | 0.038 | 0.015 | U.S. Energy Information Administration | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32768 | 32768 | USA | United States of America | South Generation | USA0007982 | 6.6000000000000005 | 44.5331 | -95.1122 | Oil | 2003.0 | Redwood Falls Public Util Comm | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 59402 | 2019 | 0.13132 | 0.25578 | 0.2303 | 0.272 | 0.104 | 0.161 | 0.144 | U.S. Energy Information Administration | 3.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34215 | 34215 | USA | United States of America | Westward Seafoods | USA0054305 | 6.6000000000000005 | 53.8585 | -166.5529 | Oil | 1991.0 | Westward Seafoods Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 18.865 | 18.767 | 19.096 | 18.455 | 15.633 | 11.797 | 17.373 | U.S. Energy Information Administration | 3.86 | 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");