global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
8 rows where capacity_mw = "105.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: source, url, year_of_capacity_data
country_long 6
- India 3
- Canada 1
- Indonesia 1
- Norway 1
- Philippines 1
- United States of America 1
primary_fuel 1
- Hydro · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4451 | 4451 | CAN | Canada | Ruskin | CAN0002227 | 105.0 | 49.195 | -122.4083 | Hydro | BC Hydro | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 14179 | 2017 | 362.01 | 348.42 | 347.52 | 349.38 | 331.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
14861 | 14861 | IND | India | LOKTAK | IND0000234 | 105.0 | 24.587 | 93.6696 | Hydro | 1983.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1023411 | 2019 | 370.5778 | 533.9567999999999 | 737.3646500000001 | 833.5513000000001 | 599.59695 | Central Electricity Authority | 414.67 | 356.34 | 446.0 | 318.64 | 303.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14862 | 14862 | IND | India | LOWER JHELUM | IND0000235 | 105.0 | 34.2189 | 74.5281 | Hydro | 1978.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1020019 | 2019 | 597.86565 | 662.87895 | 480.73425 | 478.58505 | 586.3833500000001 | Central Electricity Authority | 508.78 | 492.13 | 510.73 | 459.84 | 488.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15557 | 15557 | IND | India | UPPER SINDH I& II | IND0000484 | 105.0 | 34.198 | 75.1245 | Hydro | 1996.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1020022 | 2019 | 301.8034 | 257.05825000000004 | 361.09545 | 325.60380000000004 | 304.44015 | Central Electricity Authority | 531.08 | 434.98 | 529.51 | 397.4 | 404.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15806 | 15806 | IDN | Indonesia | Sutami / Karangkates - Brantas | WRI1001021 | 105.0 | -8.1606 | 112.4443 | Hydro | PLN - Java Bali Generation Unit / PT. PJB | Indonesia Power Generation | https://repit.wordpress.com/ | WRI | 1026154 | 371.79 | 266.78 | 301.33 | 387.04 | 371.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18016 | 18016 | NOR | Norway | Innset | WRI1003246 | 105.0 | 68.6576 | 18.82 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show?name=&defaultValue=true&viewType=TABLE&areaType=BZN&atch=false&dateTime.dateTime=01.01.2016+00:00|UTC|YEAR&area.values=CTY|10YNO-0--------C!BZN|10YNO-1--------2&productionType.values=B01&productionType.values=B02&productionType.values=B03&productionType.values=B04&productionType.values=B05&productionType.values=B06&productionType.values=B07&productionType.values=B08&productionType.values=B09&productionType.values=B10&productionType.values=B11&productionType.values=B12&productionType.values=B13&productionType.values=B14&productionType.values=B20&productionType.values=B15&productionType.values=B16&productionType.values=B17&productionType.values=B18&productionType.values=B19&DataTables_Table_0_length=209 | WRI | 1030276 | 416.23 | 399.01 | 415.59 | 400.1 | 399.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
18319 | 18319 | PHL | Philippines | AMBUKLAO | WRI1001902 | 105.0 | 16.4588 | 120.7452 | Hydro | Philippines Department of Energy | https://www.doe.gov.ph/list-existing-power-plants | GEODB | 1023471 | 291.12 | 341.11 | 256.88 | 310.87 | 335.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
30125 | 30125 | USA | United States of America | Meldahl Hydroelectric Project | USA0056872 | 105.0 | 38.7914 | -84.173 | Hydro | 2016.0 | City of Hamilton - (OH) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 53802 | 2019 | 379.397 | 494.711 | 428.511 | 486.427 | U.S. Energy Information Administration | 425.56 | 480.27 | 526.43 | 481.58 | 385.45 | 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");