global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
16 rows where capacity_mw = "200.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: country, source, estimated_generation_gwh_2015, estimated_generation_gwh_2017
country_long 10
- China 4
- Canada 2
- Japan 2
- United States of America 2
- Austria 1
- India 1
- Mali 1
- Norway 1
- South Korea 1
- Vietnam 1
owner 8
primary_fuel 1
- Hydro · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
842 | 842 | AUT | Austria | Gerlos | WRI1005174 | 200.0 | 47.2342 | 11.8997 | Hydro | 1949.0 | Verbund | Verbund | http://www.verbund.com/pp/de/region/oesterreich | GEODB | 1031032 | 299.898 | 334.153 | 245.409 | JRC-PPDB-OPEN | 592.22 | 796.01 | 499.08 | 521.53 | 504.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||
4506 | 4506 | CAN | Canada | Shawinigan-2 | CAN0002234 | 200.0 | 46.5359 | -72.7673 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22681 | 2017 | 860.44 | 860.44 | 869.05 | 865.2 | 860.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4747 | 4747 | CAN | Canada | Wreck Cove | CAN0002259 | 200.0 | 46.5314 | -60.4402 | Hydro | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28524 | 2017 | 557.0 | 557.0 | 557.0 | 558.53 | 557.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
5472 | 5472 | CHN | China | Dahuashui | WRI1000521 | 200.0 | 26.82 | 107.26 | Hydro | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253974006006-1279253974014698.pdf | 480.08 | 654.68 | 655.48 | 814.09 | 695.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||||
6416 | 6416 | CHN | China | Hongkou Dam | WRI1070889 | 200.0 | 26.8944 | 119.3279 | Hydro | 2008.0 | Fujian Hongkou Hydropower Co Ltd | Industry About | https://industryabout.com/country-territories-3/1142-china/hydro-energy/15403-hongkou-dam | Industry About | 485.7 | 642.3 | 637.71 | 756.27 | 642.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
6428 | 6428 | CHN | China | Hongshi | WRI1061006 | 200.0 | 42.95 | 127.13 | Hydro | Sinohydro | https://web.archive.org/web/20101029184306/http://1j.sinohydro.com/project_success_Details.aspx?Pid=97 | 1024398 | 607.54 | 682.66 | 691.45 | 837.53 | 736.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7832 | 7832 | CHN | China | Qingshui River Dahuashui | WRI1072311 | 200.0 | 26.8618 | 107.2737 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6840 | UNFCCC CDM Registry | 1049099 | 480.08 | 654.68 | 655.48 | 814.09 | 695.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
14702 | 14702 | IND | India | KOPILI | IND0000207 | 200.0 | 25.5177 | 92.6679 | Hydro | 1993.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1024378 | 2019 | 626.3127000000001 | 777.891 | 1082.82865 | 1166.9658499999998 | 1112.2309 | Central Electricity Authority | 744.52 | 619.44 | 744.52 | 553.13 | 580.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
16752 | 16752 | JPN | Japan | Niikappu | WRI1000691 | 200.0 | 42.6066 | 142.5569 | Hydro | Hokkaido | Japanese Electric Power Information Center | https://www.jepic.or.jp/en/ | GEODB | 1018580 | 429.42 | 339.34 | 682.07 | 430.01 | 330.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
16897 | 16897 | JPN | Japan | Takami | WRI1000692 | 200.0 | 42.4481 | 142.6236 | Hydro | Hokkaido | Japanese Electric Power Information Center | https://www.jepic.or.jp/en/ | GEODB | 1018601 | 483.18 | 384.33 | 664.73 | 470.07 | 384.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17249 | 17249 | MLI | Mali | Manantali Hydroelectric Power Plant Mali | GEODB0042546 | 200.0 | 13.1956 | -10.4289 | Hydro | GEODB | http://globalenergyobservatory.org | GEODB | 1028444 | 2017 | 1007.42 | 702.69 | 939.21 | 889.38 | 1007.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17922 | 17922 | NOR | Norway | Duge | WRI1003088 | 200.0 | 58.6659 | 6.5031 | 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=473 | WRI | 1028892 | 760.92 | 778.97 | 753.37 | 888.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
20108 | 20108 | KOR | South Korea | Soyang gang | WRI1029855 | 200.0 | 37.9445 | 127.8115 | Hydro | Korea Electric Power Company | KEPCO | https://home.kepco.co.kr/kepco/EN/C/htmlView/ENCBHP003.do?menuCd=EN030204 | WRI | 1021180 | 534.01 | 243.76 | 149.38 | 277.24 | 350.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
30448 | 30448 | USA | United States of America | Mount Elbert | USA0006208 | 200.0 | 39.0942 | -106.3523 | Hydro | 1982.5 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35656 | 2019 | -134.35 | -52.967 | -101.211 | -80.734 | -87.778 | -95.756 | -47.913 | U.S. Energy Information Administration | 506.95 | 506.95 | 453.93 | 508.34 | 421.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33225 | 33225 | USA | United States of America | Table Rock | USA0002166 | 200.0 | 36.597 | -93.3086 | Hydro | 1960.0 | USCE-Little Rock District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35596 | 2019 | 365.406 | 368.917 | 682.777 | 471.456 | 449.235 | 385.536 | 820.362 | U.S. Energy Information Administration | 598.41 | 591.56 | 561.45 | 615.39 | 531.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34809 | 34809 | VNM | Vietnam | Nam Chien 1 | WRI1030947 | 200.0 | 21.5935 | 104.1444 | Hydro | 2013.0 | Nam Chien Hydro Power JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/nam-chien-1-hydropower | Open Development Vietnam | 1071790 | 791.0 | Open Development Vietnam | 869.13 | 868.4 | 642.22 | 854.41 | 478.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");