global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
15 rows where country_long = "North Korea", primary_fuel = "Hydro" and source = "The People's Korea"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, url, geolocation_source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17836 | 17836 | PRK | North Korea | Anju Youth | WRI1019857 | 10.0 | 39.6178 | 125.6647 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | CARMA | 1013788 | 43.98 | 35.49 | 35.43 | 37.43 | 32.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17845 | 17845 | PRK | North Korea | Huichon | WRI1019846 | 300.0 | 39.662 | 125.8124 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1090838 | 629.81 | 486.63 | 601.47 | 559.4 | 457.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17846 | 17846 | PRK | North Korea | Kangge Youth | WRI1019847 | 225.0 | 40.9923 | 126.5531 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1013808 | 708.05 | 668.52 | 731.85 | 623.21 | 603.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17847 | 17847 | PRK | North Korea | Naejungri | WRI1019855 | 12.0 | 40.7238 | 128.2671 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1013819 | 40.37 | 36.15 | 41.35 | 38.25 | 38.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17848 | 17848 | PRK | North Korea | Pochon | WRI1019865 | 400.0 | 38.8921 | 127.4562 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 892.12 | 647.55 | 1019.89 | 636.31 | 643.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17852 | 17852 | PRK | North Korea | River Changja | WRI1019850 | 81.0 | 38.2021 | 125.7837 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 213.72 | 283.79 | 202.74 | 171.15 | 125.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17853 | 17853 | PRK | North Korea | River Changjin | WRI1019844 | 346.7 | 40.5662 | 127.2338 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 980.76 | 860.58 | 1023.22 | 789.25 | 793.02 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17855 | 17855 | PRK | North Korea | River Pujon | WRI1019848 | 202.3 | 40.6604 | 127.5171 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 522.22 | 407.0 | 547.22 | 434.15 | 434.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17856 | 17856 | PRK | North Korea | River Taedong | WRI1019853 | 20.0 | 39.7371 | 125.5004 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 84.88 | 73.64 | 72.67 | 66.93 | 64.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17859 | 17859 | PRK | North Korea | Supung | WRI1019840 | 700.0 | 40.4615 | 124.9627 | Hydro | 1956.0 | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1021218 | 1990.32 | 2684.33 | 2785.74 | 2364.02 | 2587.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17860 | 17860 | PRK | North Korea | T'aep'yongman | WRI1019849 | 190.0 | 40.3527 | 124.7352 | Hydro | 1986.0 | The People's Korea | http://www.sinohydro.com/664-2024-18397.aspx | WRI | 618.33 | 801.63 | 681.33 | 658.38 | 711.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
17861 | 17861 | PRK | North Korea | The 5th Puryong | WRI1019851 | 36.0 | 42.0628 | 129.6913 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 98.81 | 106.08 | 106.27 | 101.76 | 86.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17864 | 17864 | PRK | North Korea | The March 17th Power Plant | WRI1019841 | 482.0 | 41.349 | 129.3901 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1186.22 | 1011.91 | 1485.98 | 1021.01 | 784.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
17865 | 17865 | PRK | North Korea | Unbong | WRI1019842 | 400.0 | 38.5979 | 125.4621 | Hydro | 1960.0 | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1021219 | 953.68 | 953.68 | 1108.08 | 883.78 | 881.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17866 | 17866 | PRK | North Korea | Yunfeng | WRI1019843 | 400.0 | 41.3814 | 126.5149 | Hydro | The People's Korea | https://web.archive.org/web/20090824204833/http://www1.korea-np.co.jp/pk/112th_issue/99091601.htm | WRI | 1334.17 | 1213.47 | 1169.34 | 1036.87 | 1008.22 | 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");