global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
23 rows where capacity_mw = "2.5" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: url, geolocation_source
owner 17
- Algonquin Power 1
- Beaver City Corporation 1
- Emporia Hydro Power LP 1
- Erie Boulevard Hydropower LP 1
- H. RIO HONDO SA 1
- Hydro-Electric Corp Tasmania/SA Water 1
- Idaho Power Co 1
- Korpelan Voima kuntayhtymä 1
- Neshkoro Power Assc LLC 1
- Quinebaug Associates LLC 1
- RWE npower 1
- Rwanda Energy Group Limited (REG) Government of Rwanda 1
- STS Hydropower LLC 1
- Scottish and Southern Energy (SSE) 1
- Valley Falls Associates 1
- Yakama Power 1
- Yolo County Flood Control WCD 1
country_long 10
- United States of America 10
- Brazil 2
- Mexico 2
- Portugal 2
- United Kingdom 2
- Argentina 1
- Australia 1
- Canada 1
- Finland 1
- Rwanda 1
primary_fuel 1
- Hydro · 23 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260 | 260 | ARG | Argentina | LOS QUIROGA | ARG0000331 | 2.5 | -27.6509 | -64.3618 | Hydro | 1963.0 | H. RIO HONDO SA | Ministerio de Energía y Minería | http://energia3.mecon.gov.ar/contenidos/archivos/Reorganizacion/informacion_del_mercado/publicaciones/mercado_electrico/estadisticosectorelectrico/2015/A1.POT_GEN_COMB_POR_CENTRAL_2015.xlsx | Ministerio de Energía y Minería | 1009877 | 2015 | 8.92 | 9.11 | 10.24 | 9.55 | 9.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
739 | 739 | AUS | Australia | Terminal Storage | AUS0000058 | 2.5 | -34.8393 | 138.7112 | Hydro | Hydro-Electric Corp Tasmania/SA Water | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1058811 | 6.72 | 6.73 | 6.39 | 7.0 | 8.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
2353 | 2353 | BRA | Brazil | MAX-01 (Nova Lacerda) | BRA0029696 | 2.5 | -14.4178 | -59.5236 | Hydro | 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) | 2017 | 8.68 | 11.91 | 11.77 | 11.98 | 10.77 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3176 | 3176 | BRA | Brazil | São Maurício | BRA0029137 | 2.5 | -28.1356 | -49.1219 | Hydro | 2010.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) | 1078395 | 2017 | 6.53 | 9.55 | 8.35 | 9.23 | 8.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4420 | 4420 | CAN | Canada | Rawdon | CAN0008279 | 2.5 | 46.0458 | -73.7294 | Hydro | Algonquin Power | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 32861 | 2017 | 9.99 | 9.56 | 8.34 | 9.0 | 9.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
10117 | 10117 | FIN | Finland | Hamari | WRI1002323 | 2.5 | 65.7 | 25.1667 | Hydro | Korpelan Voima kuntayhtymä | Finnish Energy Authority | http://www.energiavirasto.fi/en/voimalaitosrekisteri | CARMA | 1020313 | 12.58 | 12.64 | 10.66 | 10.37 | 12.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17332 | 17332 | MEX | Mexico | Compañía Electrica Carolina | MEX0006630 | 2.5 | 20.2048 | -100.8865 | Hydro | INERE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 2016 | 10.22 | 9.97 | 9.66 | 9.69 | 9.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17530 | 17530 | MEX | Mexico | Tamazulapan | MEX0006559 | 2.5 | 17.6868 | -97.6178 | Hydro | CFE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 1013154 | 2016 | 9.13 | 8.03 | 8.44 | 7.14 | 9.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18808 | 18808 | PRT | Portugal | Idanha-a-Nova | WRI1022723 | 2.5 | 39.9447 | -7.2011 | Hydro | 1970.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012723 | 8.39 | 8.39 | 6.16 | 8.63 | 4.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18882 | 18882 | PRT | Portugal | Odivelas | WRI1022747 | 2.5 | 38.1852 | -8.1153 | Hydro | 2010.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088860 | 6.96 | 6.96 | 6.13 | 8.15 | 6.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
19726 | 19726 | RWA | Rwanda | Mukungwa II | WRI1061149 | 2.5 | -1.582 | 29.655 | Hydro | 2010.0 | Rwanda Energy Group Limited (REG) Government of Rwanda | REG | http://reg.rw/index.php/media-centre/download/2-uncategorised/232-power-plant-status-on-february-01-2015 | KTH | 1073969 | 8.49 | 7.95 | 6.83 | 8.92 | 8.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
22633 | 22633 | GBR | United Kingdom | Cuaich | GBR0000471 | 2.5 | 56.9562 | -4.211 | Hydro | 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 | 1028295 | 8.16 | 6.44 | 8.9 | 6.98 | 6.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
23247 | 23247 | GBR | United Kingdom | Inverlael | GBR0000426 | 2.5 | 57.8235 | -5.0553 | Hydro | RWE npower | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1063093 | 12.41 | 9.82 | 14.51 | 11.11 | 11.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
25948 | 25948 | USA | United States of America | Byllesby | USA0050328 | 2.5 | 44.5119 | -92.9394 | Hydro | 1988.0 | Neshkoro Power Assc LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37673 | 2019 | 9.02 | 10.035 | 11.517 | 15.568 | 14.975 | 13.799 | 14.513 | U.S. Energy Information Administration | 8.21 | 8.94 | 8.7 | 8.93 | 8.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26500 | 26500 | USA | United States of America | Clear Lake | USA0000814 | 2.5 | 42.667 | -114.7801 | Hydro | 1938.0 | Idaho Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22756 | 2019 | 12.313 | 16.963 | 15.695 | 16.538 | 16.514 | 17.281 | 17.272000000000002 | U.S. Energy Information Administration | 9.78 | 10.52 | 8.44 | 10.58 | 8.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26501 | 26501 | USA | United States of America | Clear Lake Hydro Project | USA0050128 | 2.5 | 38.9236 | -122.5667 | Hydro | 1985.0 | Yolo County Flood Control WCD | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37543 | 2019 | 8.12 | 8.38 | 8.41 | 9.89 | 8.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
27191 | 27191 | USA | United States of America | Drop 2 (WA) | USA0006507 | 2.5 | 46.4492 | -120.5342 | Hydro | 1942.0 | Yakama Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35612 | 2019 | 4.309 | 4.245 | 0.0 | 1.235 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 6.8 | 6.84 | 7.13 | 6.85 | 5.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27356 | 27356 | USA | United States of America | Eel Weir | USA0002556 | 2.5 | 44.6384 | -75.4905 | Hydro | 1928.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27810 | 2019 | 9.755 | 9.506 | 7.67 | 7.648000000000001 | 10.619 | 6.98 | 8.767 | U.S. Energy Information Administration | 10.56 | 10.79 | 9.86 | 10.37 | 10.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27442 | 27442 | USA | United States of America | Emporia | USA0050175 | 2.5 | 36.696 | -77.56 | Hydro | 1986.0 | Emporia Hydro Power LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34069 | 2019 | 6.8052600000000005 | 7.65171 | 7.356 | 7.636 | 5.069 | 5.479 | 7.054 | U.S. Energy Information Administration | 7.49 | 6.43 | 7.34 | 9.56 | 6.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31700 | 31700 | USA | United States of America | Quinebaug Lower Project | USA0055860 | 2.5 | 41.7987 | -71.8868 | Hydro | 1990.0 | Quinebaug Associates LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 6.537 | 6.739 | 4.8500000000000005 | 5.0 | 7.415 | 9.49 | 8.615 | U.S. Energy Information Administration | 8.85 | 8.13 | 8.71 | 8.15 | 8.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33068 | 33068 | USA | United States of America | Sugarloaf Hydro Plant | USA0050435 | 2.5 | 39.2527 | -106.3748 | Hydro | 1985.0 | STS Hydropower LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 65672 | 2019 | 1.5 | 5.09 | 5.297 | 5.612 | 2.6 | 4.955 | 2.561 | U.S. Energy Information Administration | 6.52 | 6.55 | 6.52 | 6.57 | 5.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33684 | 33684 | USA | United States of America | Upper Beaver | USA0003643 | 2.5 | 38.2683 | -112.4806 | Hydro | 1907.0 | Beaver City Corporation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29485 | 2019 | 10.582 | 10.097 | 10.191 | 11.165 | 10.768 | 7.387 | 10.742 | U.S. Energy Information Administration | 6.52 | 6.55 | 6.52 | 6.57 | 5.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33748 | 33748 | USA | United States of America | Valley Falls Hydroelectric Facility | USA0050034 | 2.5 | 42.9044 | -73.5625 | Hydro | 1985.0 | Valley Falls Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26034 | 2019 | 9.898 | 8.177 | 6.847 | 7.43 | 9.047 | 7.073 | 5.353 | U.S. Energy Information Administration | 9.43 | 9.4 | 7.99 | 9.51 | 8.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-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");