global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
7 rows where capacity_mw = "19.5" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
country_long 6
- Brazil 2
- China 1
- Switzerland 1
- United Kingdom 1
- United States of America 1
- Vietnam 1
owner 3
primary_fuel 1
- Hydro · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1799 | 1799 | BRA | Brazil | Cotiporã | BRA0027877 | 19.5 | -28.9666 | -51.75 | Hydro | 2008.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) | 1061083 | 2017 | 74.79 | 88.21 | 96.78 | 87.76 | 81.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
2331 | 2331 | BRA | Brazil | Linha Emília | BRA0027876 | 19.5 | -28.9333 | -51.7667 | Hydro | 2009.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) | 1061400 | 2017 | 74.79 | 88.21 | 96.78 | 87.76 | 81.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
6087 | 6087 | CHN | China | Guanyinge Dam | WRI1070849 | 19.5 | 41.3149 | 124.1499 | Hydro | 1995.0 | Industry About | https://industryabout.com/country-territories-3/1142-china/hydro-energy/15393-guanyinge-dam | Industry About | 64.67 | 71.83 | 67.85 | 81.83 | 75.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
21222 | 21222 | CHE | Switzerland | Beznau | WRI1004069 | 19.5 | 47.5525 | 8.2286 | Hydro | 1902.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1024253 | 88.46 | 90.35 | 96.82 | 96.18 | 99.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
23312 | 23312 | GBR | United Kingdom | Kinlochleven Hydro Power Station | GBR0000391 | 19.5 | 56.7146 | -4.9634 | Hydro | Hydro Plan (on behalf of Alcan) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 56.79 | 37.31 | 66.94 | 47.57 | 47.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
28536 | 28536 | USA | United States of America | Headgate Rock | USA0007179 | 19.5 | 34.1683 | -114.2774 | Hydro | 1993.0 | Colorado River Indian Irr Proj | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 45554 | 2019 | 78.877 | 79.916 | 73.405 | 75.735 | 72.811 | 67.925 | 72.438 | U.S. Energy Information Administration | 79.16 | 89.34 | 71.53 | 80.57 | 70.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34910 | 34910 | VNM | Vietnam | Yan-Tann-Sien | WRI1030805 | 19.5 | 12.1526 | 108.3787 | Hydro | 2010.0 | Cao Nguyen - Song Da Hydro Power JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/yan-tann-sien-hydropower | Open Development Vietnam | 1076784 | 79.0 | Open Development Vietnam | 86.46 | 79.99 | 70.05 | 87.15 | 55.06 | 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");