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 = "3.1" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: source, geolocation_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2015, estimated_generation_note_2017
owner 8
country_long 6
- United States of America 7
- Portugal 3
- France 2
- Canada 1
- Switzerland 1
- Vietnam 1
primary_fuel 1
- Hydro · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4623 | 4623 | CAN | Canada | Tennant Lake | CAN0008461 | 3.1 | 49.5674 | -125.6215 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 36782 | 2000 | 5.86 | 5.86 | 5.86 | 5.88 | 5.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10993 | 10993 | FRA | France | Germ | WRI1025095 | 3.1 | 42.7767 | 0.4407 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 10.49 | 10.84 | 11.77 | 11.01 | 11.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
11691 | 11691 | FRA | France | Passy | WRI1025096 | 3.1 | 45.954 | 6.7398 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 9.81 | 9.17 | 11.42 | 9.76 | 11.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
18665 | 18665 | PRT | Portugal | Aregos | WRI1022668 | 3.1 | 41.0939 | -8.0278 | Hydro | 1958.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012697 | 10.97 | 11.64 | 8.47 | 12.1 | 7.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18694 | 18694 | PRT | Portugal | Bragado | WRI1022677 | 3.1 | 41.5814 | -7.6801 | Hydro | 1998.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1053104 | 9.95 | 10.06 | 7.21 | 11.72 | 7.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18949 | 18949 | PRT | Portugal | Ribadouro | WRI1022780 | 3.1 | 41.0991 | -8.0826 | Hydro | 1993.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1018409 | 10.97 | 11.64 | 8.47 | 12.1 | 7.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21324 | 21324 | CHE | Switzerland | Ponte Brolla | WRI1004436 | 3.1 | 46.1879 | 8.7491 | Hydro | 1904.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1029168 | 10.16 | 10.68 | 10.08 | 10.56 | 11.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
25695 | 25695 | USA | United States of America | Boatlock | USA0001603 | 3.1 | 42.2086 | -72.6014 | Hydro | 1923.3225806451608 | City of Holyoke Gas and Electric Dept. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22285 | 2019 | 14.061 | 12.059 | 14.939 | 11.197 | 15.283 | 16.455000000000002 | 15.383 | U.S. Energy Information Administration | 11.65 | 13.62 | 9.76 | 12.04 | 11.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26779 | 26779 | USA | United States of America | Coyote Creek | USA0000483 | 3.1 | 33.9249 | -117.9552 | Hydro | 1984.0 | Metropolitan Water District of S CA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26169 | 2019 | 14.394 | 7.784 | 7.034 | 5.8580000000000005 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 6.44 | 6.44 | 6.45 | 6.46 | 6.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27728 | 27728 | USA | United States of America | Foothills Hydro Plant | USA0010070 | 3.1 | 39.4588 | -105.0657 | Hydro | 1985.0 | Denver City & County-Foothills | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18298 | 2019 | 0.0 | 4.902 | 5.383 | 6.1450000000000005 | 6.151 | 5.982 | 1.265 | U.S. Energy Information Administration | 8.78 | 9.92 | 9.54 | 9.07 | 8.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28956 | 28956 | USA | United States of America | International Paper Jay Hydro | USA0050047 | 3.1 | 44.5037 | -70.221 | Hydro | 1912.0 | Eagle Creek RE LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 12.713 | 15.18 | 15.201 | 13.782 | 13.422 | 16.51 | 15.794 | U.S. Energy Information Administration | 12.51 | 13.46 | 11.06 | 12.2 | 11.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30289 | 30289 | USA | United States of America | Mink Creek Hydro | USA0010325 | 3.1 | 42.2608 | -111.6656 | Hydro | 1987.0 | Mink Creek Hydro Entity | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 48771 | 2019 | 5.953 | 7.758 | 8.576 | 9.29 | 13.728 | 9.285 | 10.281 | U.S. Energy Information Administration | 6.44 | 6.44 | 6.35 | 6.46 | 5.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31674 | 31674 | USA | United States of America | Puueo | USA0000771 | 3.1 | 19.7264 | -155.0908 | Hydro | 1985.5806451612907 | Hawaii Electric Light Co Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21884 | 2019 | 13.835 | 16.746 | 15.764 | 13.464 | 5.535 | 15.313 | 11.467 | U.S. Energy Information Administration | 11.2 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32339 | 32339 | USA | United States of America | Santa Ana 3 | USA0000363 | 3.1 | 34.1072 | -117.0991 | Hydro | 1999.0 | Southern California Edison Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33164 | 2019 | 3.737 | 1.777 | 2.975 | 2.699 | 9.042 | 2.9170000000000003 | 4.121 | U.S. Energy Information Administration | 6.44 | 6.44 | 6.35 | 6.46 | 5.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34883 | 34883 | VNM | Vietnam | Suoi Vang (AnKroet) | WRI1030800 | 3.1 | 11.9921 | 108.3708 | Hydro | 1945.0 | Vietnam Electricity (EVN) | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/suoi-vang-hydropower | Open Development Vietnam | 9.68 | 8.92 | 7.8 | 9.29 | 5.42 | 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");