North Korea cities list with latitude and longitude in CSV format

North_Korea
North Korea
CSV, SQL, XML, JSON

Last update : 26 May 2024.

Country
North Korea
Capitale
Pyongyang
Number of cities
32202
Download

This is the best list of 32202 cities in the North Korea available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the North Korea file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
1874000Naedŏng-niKPSouth Pyongan38.7625125.485830Asia/Pyongyangpopulated place
2040633Songdŏng-niSongdong-ni,Songdŏng-ni,songdeogli,송덕리KPChagang-do41.34972126.839720Asia/Pyongyangpopulated place
1889973Hap’al-liHap’al-li,Hapalli,Hap’al-li,hapalli,하팔리KPSouth PyonganSukch’ŏn-gun39.46359125.654080Asia/Pyongyangpopulated place
12084869Tuhak-kokDuhakgok,Tuhak-kok,duhaggog,두학곡KPRason42.46106130.419130Asia/Pyongyangpopulated place
1868200Tohwa-riTohwa-ri,dohwali,도화리KP39.7125.783330Asia/Pyongyangpopulated place
1931098PŏlmalBeolmal,Polmal,Pŏlmal,beolmal,벌말KPKangwŏn-do38.4025127.032220Asia/Pyongyangpopulated place
1930858Hwasan-dongHwasan-dong,Hwasandong,hwasandong,화산동KPHwanghae-namdo37.965126.073330Asia/Pyongyangpopulated place
2045276Chaegung-ch’onChaegung-ch’on,Chaegung-ch’on,Jaegungchon,Zaigu-son,Zaigū-son,Zaikyuson,Zaikyūson,jaegungchon,재궁촌KPHambuk40.61028129.146670Asia/Pyongyangpopulated place
1891916Sosungni Changhŭng-dongSosungni Changhung-dong,Sosungni Changhŭng-dong,sosuglijangheungdong,소숙리장흥동KPHamgyŏng-namdo39.77306126.85750Asia/Pyongyangpopulated place
2039321Yanggwich’ŏnsang-dongYanggich’onsang-dong,Yanggich’ŏnsang-dong,Yanggwich’onsang-dong,Yanggwich’ŏnsang-dong,yang-gwicheonsangdong,양귀천상동KPChagang-do40.69611125.656390Asia/Pyongyangpopulated place
2050038Kang-ch’onKang-ch’on,Kang-ch’on,gangchon,강촌KPHamgyŏng-namdo40.30622128.2130Asia/Pyongyangpopulated place
1873237Okkye-dongKPHwanghae-namdo38.05194125.714170Asia/Pyongyangpopulated place
2040716Soksa-riSoksa-ri,sogsali,속사리KPHamgyŏng-namdo40.68111127.271670Asia/Pyongyangpopulated place
1873333OejŏlOejeol,Oejol,Oejŏl,Oesa,oejeol,외절KPHwanghae-namdo38.39854125.150130Asia/Pyongyangpopulated place
1929187SaenmalSaenmal,saesmal,샛말KPSouth Pyongan39.3125.889170Asia/Pyongyangpopulated place
2043023Kwihyang-dongGwihyangdong,Kwihyang-dong,gwihyangdong,귀향동KPHambuk41.78056129.575560Asia/Pyongyangpopulated place
2044071Honam-niHonam-ni,honamli,호남리KPHamgyŏng-namdo40.05306128.290560Asia/Pyongyangpopulated place
1879213Changhŭng-niChanghung-dong,Changhung-ni,Changhŭng-dong,Changhŭng-ni,Jangheungni,jangheungli,장흥리KPKangwŏn-do39.12028127.438060Asia/Pyongyangpopulated place
1948573Mai-dongMai-dong,maidong,마이동KPP’yŏngan-buktoKujang-gun39.88861126.330280Asia/Pyongyangpopulated place
1932084P’osang-niP’osang-ni,P’osang-ni,posangli,포상리KPHamgyŏng-namdo39.61278127.440Asia/Pyongyangpopulated place
2049716Taech’ŏnp’oDaecheonpo,Taech’onp’o,Taech’ŏnp’o,daecheonpo,대천포KPHambuk41.38528129.10Asia/Pyongyangpopulated place
2043090Kwandong-niKPYanggang-do41.26361128.020560Asia/Pyongyangpopulated place
1871860P’yŏngwŏnEiju,Eijū,Eisyo,Eizyu,Eizyū,Heigen,P’yongwon,P’yongwon-up,P’yŏngwŏn,P’yŏngwŏn-ŭp,Yeiju,Yongyu,Yonju,YŏngyuKPSouth PyonganP’yŏngwŏn39.30583125.596670Asia/Pyongyangpopulated place
1870354Sinsa-dongSinsa-dong,Sinsadong,sinsadong,신사동KPHwanghae-bukto38.77715125.700830Asia/Pyongyangpopulated place
1947336Hawŏl-tongHawol-tong,Hawoldong,Hawŏl-tong,hawoldong,하월동KPHwanghae-namdo38.24848125.807580Asia/Pyongyangpopulated place
6281032SŏnggolmaŭlArongsong-dong,Arongsŏng-dong,Song-dong,Songgolmaul,Sŏng-dong,Sŏnggolmaŭl,alongseongdong,seong-golma-eul,seongdong,성골마을,성동,아롱성동KPChagang-do40.2928126.37160Asia/Pyongyangpopulated place
1925818Wŏnsal-liWonsal-li,Wonsalli,Wŏnsal-li,wonsanli,원산리KPHwanghae-bukto38.56239125.691160Asia/Pyongyangpopulated place
1929302Chwagoe-dongChwagoe-dong,Jwagoedong,jwagoedong,좌괴동KPPyongyang39.06889125.911110Asia/Pyongyangpopulated place
1874098Myŏngdŏng-niKPKangwŏn-do38.66889126.914440Asia/Pyongyangpopulated place
6269742Non’golNon’gol,Non-gol,nongol,논골KPSouth Pyongan39.47506125.961310Asia/Pyongyangpopulated place
1950878Yongdam-niYongdam-ni,Yongdamni,yongdamli,용담리KPSouth PyonganSukch’ŏn-gun39.42727125.665890Asia/Pyongyangpopulated place
1867498Tut’ang-dongDutangdong,Tut’am-dong,Tut’ang-dong,Tut’am-dong,Tut’ang-dong,dutangdong,두탕동KPPyongyang38.90333125.688060Asia/Pyongyangpopulated place
1948375Yugong-niYugong-ni,Yugongni,yugogli,유곡리KPKangwŏn-do38.46238127.7560Asia/Pyongyangpopulated place
1867751Tongp’o-dongDong Poli,Dongpodong,Toho,Toho-ri,Tongp’o-dong,Tongp’o-ri,Tongpo-ni,Tongp’o-dong,Tongp’o-ri,Tōho,Tōho-ri,dongpodong,동포동KPPyongyang39.08583125.745830Asia/Pyongyangpopulated place
1870294Sinul-liSinul-li,Sinulli,sin-ulli,신울리KPHwanghae-namdo37.85139126.072780Asia/Pyongyangpopulated place
1879427Chajin-dongChajin-dong,Jajindong,jajindong,자진동KPHwanghae-namdo38.04257125.892020Asia/Pyongyangpopulated place
1869487Songjŏl-liSongjol-li,Songjon,Songjon-ni,Songjŏl-li,Songjŏn,Songjŏn-ni,songjeonli,송전리KPSouth Pyongan39.35889126.4750Asia/Pyongyangpopulated place
2039887Tolgogae-golSongnyong-dong,Sŏngnyŏng-dong,Tolgogae-gol,dolgogaegol,돌고개골KPHamgyŏng-namdo40.42639128.839720Asia/Pyongyangpopulated place
1875438Kumal-liGumalli,Kumal-li,gumanli,구만리KPHwanghae-bukto38.42783126.548690Asia/Pyongyangpopulated place
1872573Poch’ŏl-liBocheolli,Poch’ol-li,Poch’on-ni,Poch’ŏl-li,Poch’ŏn-ni,bocheonli,보천리KPHwanghae-namdo37.91889126.007220Asia/Pyongyangpopulated place
2044690Ch’ŏnha-riCh’onha-ri,Ch’ŏnha-ri,cheonhali,천하리KPHamgyŏng-namdo40.09611128.12580Asia/Pyongyangpopulated place
1869698Sŏngbung-niSeongbungni,Songbung-ni,Sŏngbung-ni,seongbugli,성북리KPKangwŏn-do39.18012127.370340Asia/Pyongyangpopulated place
2039439Wŏlsung-niWolsung-ni,Wŏlsung-ni,wolsungli,월숭리KPChagang-do40.35139125.731390Asia/Pyongyangpopulated place
1878670ChogaesŏmChogaesom,Chogaesŏm,Hap-toKPSouth Pyongan38.89722125.571110Asia/Pyongyangpopulated place
1868416TangjŏnTangjon,Tangjŏn,dangjeon,당전KPP’yŏngan-bukto39.57139125.293610Asia/Pyongyangpopulated place
1889704Chungyang-niChungyang-ni,Jungyangni,jung-yangli,중양리KPSouth Pyongan39.39786126.34290Asia/Pyongyangpopulated place
1866368YonggangRyuko,Ryukou,Ryūkou,Ryūkō,YonggangKPSouth Pyongan38.86417125.344170Asia/Pyongyangpopulated place
1889220SsangsilSsangsil,ssangsil,쌍실KPSouth Pyongan39.3525126.606110Asia/Pyongyangpopulated place
2042563Namp’a-dongNamp’a-dong,Namp’a-dong,nampadong,남파동KPChagang-do40.98528126.5650Asia/Pyongyangpopulated place
1876340Kajang-dongKajang-dong,Kajang-gol,gajangdong,가장동KPP’yŏngan-bukto39.62278125.148060Asia/Pyongyangpopulated place
12087526NambunggyeNambunggye,nambung-gye,남붕계KPHambuk42.00984129.961870Asia/Pyongyangpopulated place
2039301Yangjŏl-liYangjol-li,Yangjon-ni,Yangjŏl-li,Yangjŏn-niKPChagang-do40.78722125.914720Asia/Pyongyangpopulated place
1889941Chŏng-ch’onChong-ch’on,Chŏng-ch’on,Jeongchon,jeongchon,정촌KPSouth Pyongan39.36999126.137740Asia/Pyongyangpopulated place
1872531PokkodaeBokgodae,Pokkodae,boggodae,복고대KPHwanghae-buktoT’osan-gun38.205126.683890Asia/Pyongyangpopulated place
6282567Kotŭn-maŭlChik-tong,Chikch’am,Chikch’am,Kotun-maul,Kotŭn-maŭl,god-eunma-eul,jigcham,jigdong,곧은마을,직동,직참KPChagang-do40.86118126.495170Asia/Pyongyangpopulated place
1873486Nu-ch’onNu-ch’on,Nu-ch’on,Nuchon,nuchon,누촌KPHwanghae-namdo38.60583125.336670Asia/Pyongyangpopulated place
1931629Sojung-dongKPHwanghae-bukto38.66222126.004440Asia/Pyongyangpopulated place
1868982Sunhwa-riSunhwa-ri,sunhwali,순화리KPSouth Pyongan39.06362125.53290Asia/Pyongyangpopulated place
12490473NaengjŏnggolKPHwanghae-namdo38.3384125.122290Asia/Pyongyangpopulated place
1868784Taegiam-niDaegiamni,Taegiam-ni,Taejiam-ni,daegiamli,대기암리KPPyongyang38.85583125.66250Asia/Pyongyangpopulated place
2038893Yŏsu-riYeosuri,Yosu-ri,Yŏsu-ri,yeosuli,여수리KPYanggang-do41.55583128.453330Asia/Pyongyangpopulated place
12084859Sŏha-riSeohari,Soha-ri,Sŏha-ri,seohali,서하리KPRason42.36074130.562690Asia/Pyongyangpopulated place
1947454Munhwa-dongKPHwanghae-namdo38.00583125.963330Asia/Pyongyangpopulated place
1870567Sin’gi-dongKPSouth Pyongan38.78639125.425830Asia/Pyongyangpopulated place
6281821YŏndaebongYondaebong,Yŏndaebong,yeondaebong,연대봉KPP’yŏngan-bukto40.12124.471110Asia/Pyongyangpopulated place
1868987Sŭngyang-niSungyang-ni,Sŭngyang-ni,seung-yangli,승양리KPKangwŏn-doMunch’ŏn-si39.27333127.330280Asia/Pyongyangpopulated place
11792024Ch’oe-ch’onCh’oe-ch’on,Choechon,Ch’oe-ch’on,choechon,최촌KPPyongyang38.83226125.554290Asia/Pyongyangpopulated place
2055756SohongdanSohongdan,sohongdan,소홍단KPYanggang-doTaehongdan-gun42.00028128.843890Asia/Pyongyangpopulated place
6366900Towŏn-dongDowondong,Towon-dong,Towŏn-dong,dowondong,도원동KPHwanghae-bukto38.89614126.62030Asia/Pyongyangpopulated place
1878379Chŏng-niChong-ni,Chŏng-ni,jeongli,정리KPSouth Pyongan38.80083125.184720Asia/Pyongyangpopulated place
1871249Sangganch’onSangganch’on,Sangganchon,Sangganch’on,Sanghanch’on,Sanghanch’on,sang-ganchon,상간촌KPHwanghae-namdo38.38354125.399640Asia/Pyongyangpopulated place
1879504Chaein-maŭlChaein-ch’on,Chaein-ch’on,Chaein-maul,Chaein-maŭl,jaeinma-eul,재인마을KP38.86667125.383330Asia/Pyongyangpopulated place
1888358Harŭng-dongHareungdong,Harung-dong,Harŭng-dong,haleungdong,하릉동KPSouth Pyongan39.14472126.49250Asia/Pyongyangpopulated place
6281130Kurak-kolKurak-kol,gulaggol,구락골KPChagang-do40.2275126.448610Asia/Pyongyangpopulated place
1874555MangilgogaeMangil-gol,Mangil-kol,Mangilgogae,Mangilgok,mang-ilgol,망일골KPP’yŏngan-bukto39.94833124.71250Asia/Pyongyangpopulated place
6366920Pokp’o-dongBokpodong,Pokp’o-dong,Pokp’o-dong,bogpodong,복포동KPHwanghae-bukto38.79418126.644590Asia/Pyongyangpopulated place
1889679Hwahyŏl-liHwahyeolli,Hwahyol-li,Hwahyon-ni,Hwahyŏl-li,Hwahyŏn-ni,hwahyeonli,화현리KPSouth PyonganP’yŏngwŏn-gun39.28198125.546470Asia/Pyongyangpopulated place
1892263Ch’ŏnja-bongCh’onja-bong,Ch’ŏnja-bong,cheonjabong,천자봉KPP’yŏngan-bukto39.83611125.222782400Asia/Pyongyangpopulated place
1869049Sujin-golSujin-dong,Sujin-gol,Sujin-kol,sujingol,수진골KPP’yŏngan-bukto39.82028124.981390Asia/Pyongyangpopulated place
1872897Paeksŏng-niBaekseongni,Hakuseki-ri,Paeksong-ni,Paeksŏng-ni,baegseogli,백석리KPHwanghae-namdo37.8525126.183890Asia/Pyongyangpopulated place
1873354Oe-dongOe-dong,Oedong,Wi-dong,oedong,외동KPHwanghae-namdo38.00166125.322120Asia/Pyongyangpopulated place
6282608Paengnim-dongPaekha-ri,Paengnim-dong,baeghali,baeglimdong,백림동,백하리KPChagang-do40.70466126.106630Asia/Pyongyangpopulated place
2043552Kan’guGan-gu,Kan’gu,Kan’gu,gangu,간구KPHambuk41.28333129.650Asia/Pyongyangpopulated place
12108875Sam Ho3 Ho,3ho,3호,Sam Ho,samho,삼호KPYanggang-do41.6641128.754270Asia/Pyongyangpopulated place
6270304Chungch’amChungch’am,Chungch’am,jungcham,중참KPP’yŏngan-bukto39.85278125.995280Asia/Pyongyangpopulated place
1891436Nŏlta-riNeoldari,Nolta-ri,Nŏlta-ri,neoldali,널다리KPHwanghae-bukto38.38617126.701310Asia/Pyongyangpopulated place
2045844Tongjung-niDongjungni,Tongjung-ni,dongjungli,동중리KPYanggang-do41.30556128.228610Asia/Pyongyangpopulated place
2049594Sanggu-dongSanggu-dong,Sanggudong,sang-gudong,상구동KPHambukMusan-gun41.97611129.293060Asia/Pyongyangpopulated place
12543413Yŏlgu-dongYeolgudong,Yolgu-dong,Yŏlgu-dong,yeolgudong,열구동KPSouth Pyongan39.41852125.425880Asia/Pyongyangpopulated place
1948679PulgŭnbinKPSouth PyonganTŏkch’ŏn-gun39.85111126.320Asia/Pyongyangpopulated place
1931320KuamGuam,Kuam,guam,구암KPHwanghae-bukto38.30881126.65460Asia/Pyongyangpopulated place
12498889Sinhŭng-dongSinheungdong,Sinhung-dong,Sinhŭng-dong,sinheungdong,신흥동KPKangwŏn-do38.26498126.926290Asia/Pyongyangpopulated place
6366675P’yŏngwŏl-liP’yongwol-li,P’yŏngwŏl-li,pyeong-wonli,평원리KPHwanghae-bukto38.735126.687780Asia/Pyongyangpopulated place
2044287Hago-dongHago-dong,Hago-ri,Hagodong,hagodong,하고동KPHambuk41.5125129.517220Asia/Pyongyangpopulated place
1932073Ch’ŏnhwang-niCh’onhwang-ni,Ch’ŏnhwang-ni,cheonhwangli,천황리KPHamgyŏng-namdo39.50583127.434440Asia/Pyongyangpopulated place
1949805Yongch’ŏl-liKPHwanghae-buktoYŏnsan-gun38.86667126.172220Asia/Pyongyangpopulated place
1877170Hoejŏl-liHoejol-li,Hoejŏl-li,hoejeonli,회전리KPSouth Pyongan39.33472126.348610Asia/Pyongyangpopulated place
1892050Songnim-dongSongnim-dong,songlimdong,송림동KPSouth Pyongan39.61611126.517780Asia/Pyongyangpopulated place
6363468Tojang-golTojang-gol,dojang-gol,도장골KPKangwŏn-do38.60944127.747220Asia/Pyongyangpopulated place
1950315Ong-dongKPSouth PyonganSŏngch’ŏn-gun39.19889126.100830Asia/Pyongyangpopulated place

FaQ about North Korea


Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.