North Korea Cities with Latitude & Longitude – Download in Excel, CSV, SQL, JSON, XML

North_Korea
North Korea
Excel, CSV, SQL, XML, JSON

Last update : 23 March 2026.

Country
North Korea
Capital
Pyongyang
Number of cities
32202
Download
Click here

Here you’ll find a curated sample of 100 key cities from North Korea, each with essential data points such as latitude, longitude, administrative region, and other relevant attributes. This preview is extracted from our full dataset, which includes a total of 32202 geographic locations across North Korea.

Whether you’re working on mapping, analytics, or app development, the data is available for both personal and commercial use. All entries can be downloaded in five formats: Excel (.xlsx), CSV, SQL, JSON, and XML.

Capital Highlight: The official capital city of North Korea is Pyongyang.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
1871327 Sangch’ol-li Sangch’ol-li,Sangch’on-ni,Sangcholli,Sangch’ol-li,Sangch’on-ni,sangchonli,상촌리 KP Hwanghae-namdo 38.61472 125.44722 0 Asia/Pyongyang populated place
6272705 Iwŏl-li Iwol-li,Iwŏl-li,iwonli,이원리 KP Kangwŏn-do 38.98972 127.52111 0 Asia/Pyongyang populated place
1868120 Tŏk-hyŏn Deokhyeon,Tok-hyon,Tokkoge,Tŏk-hyŏn,deoghyeon,덕현 KP Hwanghae-namdo 37.8 125.43333 0 Asia/Pyongyang populated place
1892134 Sanmaegi Sanmaegi,sanmaegi,산매기 KP South Pyongan 39.73583 126.53667 0 Asia/Pyongyang populated place
1866011 Yŏnham-ni Yonham-ni,Yŏnham-ni,yeonhabli,연합리 KP 39.36667 126.08333 0 Asia/Pyongyang populated place
1926616 Moraesŏm Moraeseom,Moraesom,Moraesŏm,molaeseom,모래섬 KP Hwanghae-bukto 38.43667 125.75083 0 Asia/Pyongyang populated place
1947537 Sŏnam-ni Seonamni,Sonam-ni,Sŏnam-ni,seon-amli,선암리 KP Hwanghae-namdo 38.06361 126.18861 0 Asia/Pyongyang populated place
6305736 Sangt’an Sangt’an,Sangt’an-dong,Sangtan,Sangt’an,Sangt’an-dong,sangtan,sangtandong,상탄,상탄동 KP Hambuk 42.93778 129.86056 0 Asia/Pyongyang populated place
1868258 Tŏgam-dong Togam-dong,Tŏgam-dong,deog-amdong,덕암동 KP P’yŏngan-bukto 39.91472 124.41083 0 Asia/Pyongyang populated place
1892305 Ŏmt’aegok Omt’aegok,eomtaegog,Ŏmt’aegok,엄태곡 KP P’yŏngan-bukto 39.94972 125.05611 0 Asia/Pyongyang populated place
1947680 Saenggŭm-ni Saenggeumni,Saenggum-ni,Saenggŭm-ni,saeng-geumli,생금리 KP Hwanghae-namdo 38.14447 126.23306 0 Asia/Pyongyang populated place
1892312 Kŏmbong Kombong,Kŏmbong,geombong,검봉 KP P’yŏngan-bukto 39.88778 125.01361 0 Asia/Pyongyang populated place
1892028 Hagye Hagye,hagye,하계 KP South Pyongan 39.52469 126.53769 0 Asia/Pyongyang populated place
1931425 Yŏam-dong Yeoamdong,Yoam-dong,Yŏam-dong,yeoamdong,여암동 KP Kangwŏn-do 39.0232 127.79142 0 Asia/Pyongyang populated place
2043290 Hwangch’ŏl-li Hwangch’ol-li,Hwangcheolli,Hwangch’ŏl-li,Koyong-ni,Koyŏng-ni,hwangcheonli,황천리 KP Yanggang-do 41.33472 127.79527 0 Asia/Pyongyang populated place
2043880 Hwap’yŏng-ni Hwap’yong-dong,Hwap’yong-ni,Hwap’yŏng-dong,Hwap’yŏng-ni,hwapyeongli,화평리 KP P’yŏngan-bukto 40.06778 124.38556 0 Asia/Pyongyang populated place
1890046 Kkoppat-kol KP Pyongyang Sangwŏn-gun 38.94528 126.00639 0 Asia/Pyongyang populated place
1868428 Tanghyŏn KP Hwanghae-namdo 38.18639 125.62889 0 Asia/Pyongyang populated place
1874699 Maehyŏn Maehyeon,Maehyon,Maehyŏn,maehyeon,매현 KP Hwanghae-namdo 38.18139 125.39417 0 Asia/Pyongyang populated place
1926682 Tongsan-dong Dongsandong,Tongsan,Tongsan-dong,dongsan,dongsandong,동산,동산동 KP Hwanghae-namdo 38.38515 125.65438 0 Asia/Pyongyang populated place
1866857 Wŏlsŏng-dong Wolseongdong,Wolsong-dong,Wosong-dong,Wŏlsŏng-dong,Wŏsŏng-dong,wolseongdong,월성동 KP Hwanghae-namdo 38.28986 125.65634 0 Asia/Pyongyang populated place
1879241 Changgyo-dong Changgyo-dong,jang-gyodong,장교동 KP Hwanghae-namdo 38.10139 125.54361 0 Asia/Pyongyang populated place
2041921 Ponghwa-ri Iisin-Dong,Ilsin-dong,Nisshin-do,Nisshin-dō,Ponghwa-ri,bonghwali,봉화리 KP Hamgyŏng-namdo 40.51972 129.11139 0 Asia/Pyongyang populated place
6269937 Sojae-dong Sojae-dong,Sojaedong,sojaedong,소재동 KP South Pyongan 39.21944 125.50583 0 Asia/Pyongyang populated place
1870434 Sinmak Shimbaku,Shimmaku,Shinbaku,Sinmak,sinmag,신막 KP Hwanghae-bukto 38.41667 126.23333 18669 Asia/Pyongyang populated place
6274333 P’ungdong-ni P’ungdong-ni,P’ungdong-ni,pungdongli,풍동리 KP Hamgyŏng-namdo 39.49583 127.51222 0 Asia/Pyongyang populated place
1872619 P’imok-ch’on P’imok-ch’on,Pimokchon,P’imok-ch’on,pimogchon,피목촌 KP Hwanghae-namdo 38.52889 125.11722 0 Asia/Pyongyang populated place
1947672 Pŏl-mal Beolmal,Pol-mal,Pŏl-mal,beolmal,벌말 KP Hwanghae-namdo 38.13083 126.25167 0 Asia/Pyongyang populated place
1874319 Much’ang-ni KP South Pyongan 39.79722 126.26306 0 Asia/Pyongyang populated place
1874619 Majŏl-li Baten-ri,Majol-li,Majon-ni,Majŏl-li,Majŏn-ni,Maten-ri,majeonli,마전리 KP Kangwŏn-do 39.11167 127.13417 0 Asia/Pyongyang populated place
12119802 Chang-dong Chang-dong,Jangdong,jangdong,장동 KP Yanggang-do 41.33231 128.1836 0 Asia/Pyongyang populated place
1947437 Haesong-dong Haesong-dong,Haesongdong,haesongdong,해송동 KP Hwanghae-namdo 38.13806 125.99056 0 Asia/Pyongyang populated place
2040400 Ssangnyong-ni Ssangnyong-dong,Ssangnyong-ni,ssanglyongli,쌍룡리 KP Hambuk 40.93667 129.34444 0 Asia/Pyongyang populated place
2041978 P’ohangch’on Hokoson,Hokōson,P’ohangch’on,P’ohangch’on,pohangchon,포항촌 KP Hamgyŏng-namdo 40.47667 129.01194 0 Asia/Pyongyang populated place
6273407 Ch’angdong-ni Ch’angdong-ni,Ch’angdong-ni,changdongli,창동리 KP Hamgyŏng-namdo 39.88833 127.62306 0 Asia/Pyongyang populated place
1926278 Saem-gol Saem-gol,Saemgol,saemgol,샘골 KP Hwanghae-bukto 38.4053 125.97333 0 Asia/Pyongyang populated place
6305712 Sangsinjŏn Sangsinjeon,Sangsinjon,Sangsinjŏn,sangsinjeon,상신전 KP Hambuk 42.64312 129.75124 0 Asia/Pyongyang populated place
1872524 Poksang Poksang,bogsang,복상 KP P’yŏngan-bukto 39.97917 125.36 0 Asia/Pyongyang populated place
2042440 Nongp’o Nongp’o,Nongp’o-ri,Nongpo,Nongp’o,Nongp’o-ri,Tongp’o-ri,Tongp’o-ri,nongpo,nongpoli,농포,농포리 KP Hambuk 42.75293 130.20706 0 Asia/Pyongyang populated place
1873266 Oji-dong Oji-dong,Ojidong,ojidong,오지동 KP Hwanghae-namdo 37.86167 125.95667 0 Asia/Pyongyang populated place
2040245 Taebau Daebau,Taeam,Taebau,Taebawi,daebau,대바우 KP Yanggang-do 41.73056 128.79972 0 Asia/Pyongyang populated place
1879725 Aengdang-dong Aengdang-dong,Aengdangdong,aengdangdong,앵당동 KP Hwanghae-namdo 38.30113 125.28068 0 Asia/Pyongyang populated place
2050280 Ma-dong Ma-dong,madong,마동 KP Hamgyŏng-namdo Hŏch’ŏn-gun 40.76528 128.78361 0 Asia/Pyongyang populated place
1879609 Anmi-ri Anmi-ri,anmili,안미리 KP Kangwŏn-do 38.74167 127.83583 0 Asia/Pyongyang populated place
2041376 Sang-ch’on Joson,Jōson,Sang-ch’on,Sang-ch’on,sangchon,상촌 KP Hamgyŏng-namdo 40.38759 128.59409 0 Asia/Pyongyang populated place
1874965 Kwang-ni Kwang-ni,gwangli,광리 KP P’yŏngan-bukto 39.98639 124.67611 0 Asia/Pyongyang populated place
2040515 Songp’a-ri Songp’a-ri,Songp’a-ri,songpali,송파리 KP Chagang-do 40.69417 125.69083 0 Asia/Pyongyang populated place
1888530 Haenghyŏl-li Haenghyeolli,Haenghyol-li,Haenghyon-ni,Haenghyŏl-li,Haenghyŏn-ni,haenghyeonli,행현리 KP Kangwŏn-do 39.00948 127.41337 0 Asia/Pyongyang populated place
12086233 Chang-dong Chang-dong,Jangdong,jangdong,장동 KP Hambuk 42.265 129.76694 0 Asia/Pyongyang populated place
1878202 Ch’ŏnsŏng-dong Ch’onsong,Ch’onsong-dong,Ch’onsong-ni,Cheonseong-dong,Ch’ŏnsŏng,Ch’ŏnsŏng-dong,Ch’ŏnsŏng-ni,cheonseongdong,천성동 KP South Pyongan 39.47256 126.09712 0 Asia/Pyongyang populated place
2043237 Kulbanggae Kulbang-dong,Kulbanggae,Kulbangp’o,Kulbangp’o,gulbang-gae,굴방개 KP Hamgyŏng-namdo 40.58556 128.63889 0 Asia/Pyongyang populated place
2043785 Ihwa-dong Ihwa-dong,ihwadong,이화동 KP P’yŏngan-bukto 40.10472 125.42944 0 Asia/Pyongyang populated place
1874732 Maebau Maebau,Maebawi,Ungam,maebau,Ŭngam,매바우 KP P’yŏngan-bukto 39.73291 125.00207 0 Asia/Pyongyang populated place
1966508 Hŭksŏk Heukseok,Huksok,Hŭksŏk,heugseog,흑석 KP Hwanghae-bukto 38.24918 126.54658 0 Asia/Pyongyang populated place
2042612 Namch’ŏl-li Namch’ol-li,Namch’on-ni,Namch’ŏl-li,Namch’ŏn-ni,namcheonli,남천리 KP 40.01667 127.95 0 Asia/Pyongyang populated place
12279271 Nŭri-gol Neurigol,Nuri-gol,Nŭri-gol,neuligol,느리골 KP Hwanghae-namdo 38.49416 125.12297 0 Asia/Pyongyang populated place
1926944 Hasŏng-dong Haseongdong,Hasong-dong,Hasŏng-dong,haseongdong,하성동 KP Hwanghae-namdo 38.44206 125.57684 0 Asia/Pyongyang populated place
6282659 Chin’gubae Chin’gubae,Chin’gubae,jingubae,진구배 KP Chagang-do 40.93833 126.04278 0 Asia/Pyongyang populated place
1873095 Ŏryong-ni KP South Pyongan Mundŏk-gun 39.48167 125.60972 0 Asia/Pyongyang populated place
1877979 Chungbu Chungbu,Jungbu,jungbu,중부 KP South Pyongan 39.44417 126.21999 0 Asia/Pyongyang populated place
6274264 Sŏngjae-ri Seongjaeri,Songjae-ri,Sŏngjae-ri,seongjaeli,성재리 KP South Pyongan 39.74737 126.66051 0 Asia/Pyongyang populated place
1867664 Tongyang Tongyang,dong-yang,동양 KP P’yŏngan-bukto 39.77389 124.71806 0 Asia/Pyongyang populated place
1870595 Sindŏng-ni Sindong-ni,Sindŏng-ni,sindeogli,신덕리 KP South Pyongan 38.77111 125.2825 0 Asia/Pyongyang populated place
1869957 Sŏkchŏng-ni KP South Pyongan 38.80278 125.47556 0 Asia/Pyongyang populated place
1874051 Nae-ch’on Nae-ch’on,Nae-ch’on,Naechon,naechon,내촌 KP Kangwŏn-do 38.41735 126.92119 0 Asia/Pyongyang populated place
1878366 Ch’ŏngnyongan Ch’ongnyongan,Ch’ongnyongnae,Cheongnyongan,Ch’ŏngnyongan,Ch’ŏngnyongnae,cheonglyong-an,청룡안 KP Hwanghae-bukto 38.86639 125.7375 0 Asia/Pyongyang populated place
6269810 Hongnyŏ-dong Hongnyeodong,Hongnyo-dong,Hongnyŏ-dong,hongnyeodong,홍녀동 KP South Pyongan 39.43885 125.85285 0 Asia/Pyongyang populated place
2040036 Tansŏng-ni Tanjo-ri,Tanjō-ri,Tansong-ni,Tansŏng-ni,danseongli,단성리 KP P’yŏngan-bukto 40.39667 124.90278 0 Asia/Pyongyang populated place
2049314 Hyŏlp’yŏng-dong Hyolp’yong-dong,Hyŏlp’yŏng-dong,hyeolpyeongdong,혈평동 KP Chagang-do 41.1725 126.38111 0 Asia/Pyongyang populated place
2045028 Changsŭng-dong Changsung-dong,Changsŭng-dong,jangseungdong,장승동 KP Chagang-do 40.58667 125.93694 0 Asia/Pyongyang populated place
2052078 Chŏlp’a-gol Cholp’a-gol,Chŏlp’a-gol,jeolpagol,절파골 KP Hamgyŏng-namdo 40.56972 128.66083 0 Asia/Pyongyang populated place
1879086 Ch’angsang Ch’angsang,Ch’angsang,changsang,창상 KP P’yŏngan-bukto 39.86278 125.28389 0 Asia/Pyongyang populated place
6272782 Ch’ŏlchŏm Ch’olchom,Ch’ŏlchŏm,cheoljeom,철점 KP Kangwŏn-do 38.91194 127.79611 0 Asia/Pyongyang populated place
2039043 Yongnim-ŭp Heinanchin,P’yongnamjin,Pyonnamtin,P’yŏngnamjin,Yongnim,Yongnim-up,Yongnim-ŭp,lyonglim,lyonglim-eub,룡림,룡림읍 KP Chagang-do 40.5399 126.64215 0 Asia/Pyongyang populated place
2055057 Such’im-ni Such’im-ni,Such’im-ni,suchimli,수침리 KP Chagang-do 40.78889 125.79861 0 Asia/Pyongyang populated place
1966501 Sop’i-dong Sop’i-dong,Sopidong,Sop’i-dong,sopidong,소피동 KP Hwanghae-bukto 38.24028 126.51 0 Asia/Pyongyang populated place
1902085 Kugŏbi-ri KP Pyongyang Sangwŏn-gun 38.86083 126.03889 0 Asia/Pyongyang populated place
1948998 Singi-ch’on Singi-ch’on,Singi-ch’on,Singichon,singichon,신기촌 KP Hwanghae-bukto Changp’ung-gun 38.12294 126.65466 0 Asia/Pyongyang populated place
1866264 Yongi-ri Yong-ri,Yongi-ri KP South Pyongan 39.27806 125.70972 4 Asia/Pyongyang populated place
1875572 Kuam-dong Guamdong,Kuam-dong,guamdong,구암동 KP Hwanghae-namdo 38.3 125.65 0 Asia/Pyongyang populated place
6366563 Kan-dong Kan-dong,gandong,간동 KP Hwanghae-bukto 38.73444 126.44528 0 Asia/Pyongyang populated place
1873666 Namyang-ni KP South Pyongan 38.84917 125.47222 0 Asia/Pyongyang populated place
2041624 P’yoŭn-dong P’youn-dong,P’youn-gol,P’yoŭn-dong,P’yoŭn-gol,pyeong-eundong,평은동 KP 40.03333 127.01667 0 Asia/Pyongyang populated place
1949933 Naesŏngsan KP Pyongyang Sangwŏn-gun 38.82778 126.01806 0 Asia/Pyongyang populated place
6282382 Naebyŏl-tong Naebyol-tong,Naebyŏl-tong,naebyeoldong,내별동 KP Chagang-do 40.53861 125.74 0 Asia/Pyongyang populated place
1948470 Oehwahyŏn KP Kangwŏn-do P’yŏnggang-gun 38.42361 127.29583 0 Asia/Pyongyang populated place
1876319 Kaksan-dong Gaksandong,Kaksan,Kaksan-dong,gagsan,gagsandong,각산,각산동 KP Hwanghae-namdo 37.91791 125.46544 0 Asia/Pyongyang populated place
1868453 Tang-dong Dangdong,Tang-dong,Tang-gol,dang-gol,dangdong,당골,당동 KP Hwanghae-namdo 38.3102 125.10147 0 Asia/Pyongyang populated place
2040646 Song-dong Song-dong,songdong,송동 KP Hamgyŏng-namdo 40.66333 128.42139 0 Asia/Pyongyang populated place
6366939 Samhyŏn-dong Samhyon-dong,Samhyŏn-dong,samhyeondong,삼현동 KP Hwanghae-bukto 38.75694 126.68861 0 Asia/Pyongyang populated place
1865926 Yu-dong Yu-dong,yudong,유동 KP South Pyongan 38.78861 125.39333 0 Asia/Pyongyang populated place
1871711 Saesŏm Saeseom,Saesom,Saesŏm,Sindo,saeseom,새섬 KP Pyongyang 38.92449 125.59438 0 Asia/Pyongyang populated place
1868735 T’aehwa-ri T’aehwa-ri,Taehwari,T’aehwa-ri,taehwali,태화리 KP Hamgyŏng-namdo 39.66194 127.03389 0 Asia/Pyongyang populated place
2049068 Hŏmogi Homogi,Hŏmogi,heomogi,허모기 KP P’yŏngan-bukto 40.51806 125.10528 0 Asia/Pyongyang populated place
2042868 Mawidŏgi Mawidogi,Mawidok,Mawidŏgi,Mawidŏk,mawidag-i,마위닥이 KP Hamgyŏng-namdo 40.39943 128.39817 0 Asia/Pyongyang populated place
6281458 Yangji-ri Yangji-ri,yangjili,양지리 KP P’yŏngan-bukto 40.56139 125.54861 0 Asia/Pyongyang populated place
1869259 Sosaengp’al-li Sosaengp’al-li,Sosaengpalli,Sosaengp’al-li,sosaengpalli,소생팔리 KP Hwanghae-namdo 38.60917 125.23389 0 Asia/Pyongyang populated place
1948294 Haun KP Hwanghae-bukto 38.49611 126.04278 0 Asia/Pyongyang populated place
2046959 Sinp’ung-dong Sinp’ung-dong,Sinpungdong,Sinp’ung-dong,sinpungdong,신풍동 KP Yanggang-do 41.27167 128.48778 0 Asia/Pyongyang populated place
6302561 Taedŏng-ni Taedong-ni,Taedŏng-ni,daedeogli,대덕리 KP Hamgyŏng-namdo 40.06389 127.65639 0 Asia/Pyongyang populated place

North Korea: Unveiling the Geographic Fabric of an Enigmatic Nation

A Geography of Mountains, Rivers, and Strategic Urban Centers

North Korea’s landscape is a mosaic of rugged mountains, winding rivers, and densely populated urban hubs. Despite its secretive nature, the country’s geography tells a compelling story of adaptation and planning within a complex political framework. For the geographer, North Korea poses a unique challenge: understanding the spatial distribution of its cities within tightly controlled administrative divisions, all set against a backdrop of formidable natural barriers.

To truly comprehend North Korea’s geography, one must rely on structured and precise data—linking each city to its official region and department, complemented by accurate latitude and longitude coordinates.

Administrative Divisions: Provinces and Districts

North Korea is divided into provinces, special cities, and districts, each serving distinct administrative roles. This hierarchy is crucial for governance, economic planning, and resource allocation. Every city and town falls within this framework, creating an intricate spatial order shaped by both geography and policy.

The dataset I have curated organizes every settlement according to its correct province and district, reflecting North Korea’s official territorial organization with accuracy and detail.

Latitude and Longitude: Precision in a Controlled Landscape

Accurate geolocation is essential for mapping and analysis, especially in a country where terrain varies from the mountainous north to the coastal plains. This dataset includes verified latitude and longitude coordinates for all cities and towns, enabling integration into Geographic Information Systems (GIS), strategic planning models, and environmental assessments.

Such precise spatial information transforms abstract locations into actionable data for researchers and planners alike.

Excel: Making Complex Data Accessible

While available in CSV, SQL, JSON, and XML formats, the recent addition of Excel (.xlsx) offers unparalleled accessibility. Excel’s familiar and flexible interface allows users across disciplines to filter, sort, and analyze data without specialized software skills.

The Excel file is designed with clarity and consistency, making it a practical tool for anyone needing immediate access to reliable geographic information.

What the Dataset Includes

* Comprehensive list of North Korean cities and towns

* Classification by province and district

* Verified latitude and longitude coordinates

* Available in Excel (.xlsx), CSV, SQL, JSON, and XML formats

Why North Korea’s Geography Demands Reliable Data

North Korea’s unique geopolitical position and challenging terrain require dependable geographic data to support any form of external analysis, humanitarian planning, or academic research. Detailed and structured spatial information is key to understanding the nation’s settlement patterns and administrative boundaries.

This dataset provides a crucial resource, bridging gaps in knowledge with precision and structure.

Mapping North Korea’s Geographic Complexity

Beyond political mystique lies a geography rich in spatial dynamics—mountainous regions interspersed with urban centers like Pyongyang and Hamhung. Each city holds strategic and cultural significance within this complex network.

Through this dataset, especially with its accessible Excel format, North Korea’s geography emerges not only as a subject of curiosity but as an organized and analyzable landscape, ready for deeper understanding and exploration.

Download North_Korea cities in Excel SQL CSV JSON XML

Access detailed latitude and longitude data for cities in North Korea, now available in Excel (.xlsx) — plus CSV, SQL, XML, and JSON formats

List of countries :

download-cities-data.org