Japan cities list with latitude and longitude in CSV format

Japan
Japan
CSV, SQL, XML, JSON

Last update : 18 July 2024.

Country
Japan
Capitale
Tokyo
Number of cities
31356
Download

This is the best list of 31356 cities in the Japan 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 Japan file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
10862153ShōwaShowa,Shōwa,zhao he,昭和JPKanagawaKawasaki-shi35.53216139.737430Asia/Tokyopopulated place
9291145TsuruharaTsuruhara,he yuan,鶴原JPŌsakaIzumisano Shi34.42531135.340910Asia/Tokyopopulated place
8647795KumanomachiKumanomachi,xiong ye ding,熊野町JPIshikawaWajima Shi37.33828136.902660Asia/Tokyopopulated place
8526558NatsuedaNatsueda,natsueda,xia jing tian,なつえだ,ナツエダ,夏井田JPAomoriAomori Shi40.87058140.684450Asia/Tokyopopulated place
8464069KawameKawame,chuan mu,kawame,かわめ,カワメ,川目JPAomoriShimokita-gun41.40377140.858660Asia/Tokyopopulated place
11210479UchidamachiUchidamachi,nei tian ding,uchidamachi,うちだまち,ウチダマチ,内田町JPKumamotoKumamoto Shi32.74587130.64920Asia/Tokyopopulated place
1857857Chinzeimachi-madarashimaChinzeimachi-madarashima,Madarashima,zhen xi ding ma du dao,鎮西町馬渡島JPSagaKaratsu Shi33.56872129.764180Asia/Tokyopopulated place
11863879HarakichōHarakicho,Harakichō,harakichou,yuan mu ting,はらきちょう,ハラキチョウ,原木町JPHokkaido41.7298141.037910Asia/Tokyopopulated place
9637349HasamaHasama,po,迫JPShigaGamō-gun34.98496136.222150Asia/Tokyopopulated place
10430681TakamoridaiTakamoridai,gao sen tai,高森台JPKanagawaIsehara Shi35.42301139.329670Asia/Tokyopopulated place
9114321Toyonomachi-ishiToyonomachi-ishi,li ye ding shi,豊野町石JPNaganoNagano Shi36.70469138.261230Asia/Tokyopopulated place
11402990TsukinouraTsukinoura,tsukinoura,yue pu,つきのうら,ツキノウラ,月浦JPKumamotoMinamata Shi32.19016130.381490Asia/Tokyopopulated place
9633122KubotaKubota,wa tian,窪田JPNaraIkoma-gun34.59598135.759640Asia/Tokyopopulated place
9637204Kōnanchō-sugitaniKonancho-sugitani,Kōnanchō-sugitani,jia nan ding shan gu,甲南町杉谷JPShigaKōka-shi34.9189136.145830Asia/Tokyopopulated place
1850734TamariichiJPHiroshimaTakehara-shi34.4132.850Asia/Tokyopopulated place
11209925TsukideTsukide,tsukide,yue chu,つきで,ツキデ,月出JPKumamotoKumamoto Shi32.80436130.766920Asia/Tokyopopulated place
1853669ŌtaguchiOtaguchi,Otakuchi,da tian kou,Ōtaguchi,Ōtakuchi,大田口JPKochiNagaoka Gun33.78593133.716770Asia/Tokyopopulated place
1849226UradoUrado,pu hu,浦戸JPKochiKōchi Shi33.49644133.56850Asia/Tokyopopulated place
8599855Toyotamachō-yarikawaToyotamacho-yarikawa,Toyotamachō-yarikawa,li yu ding qian chuan,豊玉町鑓川JPNagasakiTsushima Shi34.39721129.358850Asia/Tokyopopulated place
9288269KawaideraKawaidera,he he si,河合寺JPŌsakaKawachi-nagano Shi34.44526135.579790Asia/Tokyopopulated place
1851469SukiJPKyotoKyōtango-shi35.58333135.10Asia/Tokyopopulated place
11863886BenzaichōBenzaicho,Benzaichō,benzaichou,bian cai ting,べんざいちょう,ベンザイチョウ,弁才町JPHokkaido41.71933140.992290Asia/Tokyopopulated place
9892659NishimutaNishimuta,xi mou tian,西牟田JPFukuokaChikugo Shi33.23552130.483780Asia/Tokyopopulated place
1852180Shimo-tatsudaShimo-tatsuda,Shimo-tatsutaJPKumamotoKumamoto Shi32.81667130.733330Asia/Tokyopopulated place
10796883SuginazawaSuginazawa,shan ming ze,杉名沢JPShizuokaGotenba Shi35.29464138.916410Asia/Tokyopopulated place
9098691TakaokaTakaoka,gao qiu,高丘JPHokkaidoTomakomai Shi42.67271141.599110Asia/Tokyopopulated place
2128423RebunRBJ,Rebun,Rebunge,RebunkaJPHokkaido42.57389140.600560Asia/Tokyopopulated place
6415066SoneJPMieOwase Shi33.98167136.196940Asia/Tokyopopulated place
6417270EnouraJPHiroshimaOnomichi-shi34.36333133.193330Asia/Tokyopopulated place
8601102MinatoMinato,cou,湊JPYamaguchiNagato Shi34.37711131.183450Asia/Tokyopopulated place
8552760ShimokawaraShimokawara,shimokawara,xia chuan yuan,しもかわら,シモカワラ,下川原JPAomoriSannohe Gun40.40099141.194690Asia/Tokyopopulated place
8572656MinaminagaiMinaminagai,minaminagai,nan yong jing,みなみながい,ミナミナガイ,南永井JPSaitamaTokorozawa-shi35.81536139.521070Asia/Tokyopopulated place
8412121HiraokamachiHiraokamachi,hiraokamachi,ping gang ding,ひらおかまち,ヒラオカマチ,平岡町JPAomoriHirosaki Shi40.60946140.453280Asia/Tokyopopulated place
9889342Chinzeimachi-nakanoChinzeimachi-nakano,zhen xi ding zhong ye,鎮西町中野JPSagaKaratsu Shi33.53152129.906060Asia/Tokyopopulated place
2111285ŌyanagiOyanagi,da liu,Ōyanagi,大柳JPAkitaOgachi-gun39.09254140.719540Asia/Tokyopopulated place
8411591SasamorichōSasamoricho,Sasamorichō,sasamorichou,ti sen ding,ささもりちょう,ササモリチョウ,笹森町JPAomoriHirosaki Shi40.60987140.473470Asia/Tokyopopulated place
8512100KawaaiKawaai,chuan he,kawaai,かわあい,カワアイ,川合JPAomoriKuroishi Shi40.63378140.601680Asia/Tokyopopulated place
1863774FutaeboriFutaebori,NijuboriJPKagoshimaSoo Shi31.63333130.90Asia/Tokyopopulated place
1861497IrifuneIrifune,Irifunecho,Irifunechō,ru chuan,入船JPTokyoChūō Ku35.67181139.776230Asia/Tokyopopulated place
8527773NumaNuma,numa,zhao,ぬま,ヌマ,沼JPIwateKunohe-gun40.32606141.387310Asia/Tokyopopulated place
8519984MinamikomagomeyamaMinamikomagomeyama,minamikomagomeyama,nan ju ru shan,みなみこまごめやま,ミナミコマゴメヤマ,南駒込山JPAomoriAomori Shi40.67584140.940320Asia/Tokyopopulated place
1860566KamiichiKami-ichi,Kamiichi,shang shi,上市JPNaraYoshino-gun34.39696135.85660Asia/Tokyopopulated place
8624936ŌtadaOtada,da zhong,Ōtada,大忠JPOkayamaNiimi Shi35.08214133.406850Asia/Tokyopopulated place
1850941Kōdachō-takatabaraKodacho-takatabara,Kōdachō-takatabara,Takadawara,Takatabara,jia tian ding gao tian yuan,甲田町高田原JPHiroshimaAki-takata Shi34.68333132.766670Asia/Tokyopopulated place
1907147NihongiNihongi,er ben mu,二本木JPSaitama35.79139139.358890Asia/Tokyopopulated place
8624882SannōSanno,Sannō,shan wang,山王JPHiroshimaShōbara-shi35.02636132.983910Asia/Tokyopopulated place
1855171Nishi-shikiyaJPWakayamaHigashimuro-gun33.85135.80Asia/Tokyopopulated place
11863870KawakamichōKawakamicho,Kawakamichō,chuan shang ting,kawakamichou,かわかみちょう,カワカミチョウ,川上町JPHokkaido41.76393141.07190Asia/Tokyopopulated place
11209949NumayazuNumayazu,numayadzu,zhao shan jin,ぬまやづ,ヌマヤヅ,沼山津JPKumamotoKumamoto Shi32.77596130.780050Asia/Tokyopopulated place
11081236Nagata-minamidaiNagata-minamidai,nagataminamidai,yong tianminami tai,ながたみなみだい,ナガタミナミダイ,永田みなみ台JPKanagawaYokohama Shi35.43156139.587670Asia/Tokyopopulated place
2128924NishikichōNishikicho,Nishikichō,jin ting,nishikichou,にしきちょう,ニシキチョウ,錦町JPHokkaidoKushiro Shi42.98313144.383050Asia/Tokyopopulated place
10261827HonmachiHonmachi,ben ding,本町JPFukuokaIizuka Shi33.6514130.668760Asia/Tokyopopulated place
11109626MasumaMasuma,masuma,zeng jian,ますま,マスマ,増間JPChibaMinamibōsō Shi35.06869139.921020Asia/Tokyopopulated place
11865063TakisawachōTakisawacho,Takisawachō,long ze ting,takisawachou,たきさわちょう,タキサワチョウ,滝沢町JPHokkaido41.79595140.79840Asia/Tokyopopulated place
11558490SuehirochōSuehirocho,Suehirochō,mo guang ting,suehirochou,すえひろちょう,スエヒロチョウ,末広町JPHokkaidoTokachi-gun42.81289143.653620Asia/Tokyopopulated place
11274768ŌkuraOkura,da cang,ookura,Ōkura,おおくら,オオクラ,大倉JPKumamotoTamana Shi32.92205130.573820Asia/Tokyopopulated place
1850169TokumaTokuma,de jian,徳間JPNaganoNagano Shi36.68245138.23010Asia/Tokyopopulated place
2114108HachigōdaHachigoda,Hachigōda,ba he tian,八合田JPMiyagiKurokawa-gun38.4505140.839410Asia/Tokyopopulated place
8661699Kitagōchō-higashinoKitagocho-higashino,Kitagōchō-higashino,bei xiang ding dong ye,北郷町東野JPFukuiKatsuyama Shi36.0844136.42890Asia/Tokyopopulated place
10432584ShimohiramaShimohirama,xia ping jian,下平間JPKanagawaIsehara Shi35.38281139.322420Asia/Tokyopopulated place
1859235KitsukaJPShimaneHamada Shi34.76667132.066670Asia/Tokyopopulated place
9291768MatsugamineMatsugamine,songke feng,松ヶ峯JPWakayamaKaisō-gun34.1403135.405950Asia/Tokyopopulated place
9888167YukueYukue,sheng jia,生家JPFukuokaFukutsu Shi33.812130.483740Asia/Tokyopopulated place
2130034HokkōHokko,Hokkō,HotsukoJPHokkaidoSunagawa-shi43.51667141.916670Asia/Tokyopopulated place
11081652OimatsuchōOimatsucho,Oimatsuchō,lao song ding,oimatsuchou,おいまつちょう,オイマツチョウ,老松町JPKanagawaYokohama Shi35.44902139.623240Asia/Tokyopopulated place
1853717Hiro-ōshingaiHiro-oshingai,Hiro-ōshingai,O-shingai,O-shinkai,Shinkai,guang da xin kai,Ō-shingai,Ō-shinkai,広大新開JPHiroshimaKure-shi34.2292132.623270Asia/Tokyopopulated place
9291632HikogaseHikogase,yanke lai,彦ヶ瀬JPWakayamaArida-gun34.12012135.293150Asia/Tokyopopulated place
9634727Kamochō-kan’onjiKamocho-kan’onji,Kamochō-kan’onji,jia mao ding guan yin si,加茂町観音寺JPKyotoKizugawa-shi34.74328135.855230Asia/Tokyopopulated place
2129737KamiobihirochōKami-obihiro,Kamiobihirocho,Kamiobihirochō,shang dai guang ding,上帯広町JPHokkaidoObihiro Shi42.8143.066670Asia/Tokyopopulated place
9637318Kōkachō-kosajiKokacho-kosaji,Kōkachō-kosaji,jia he ding xiao zuo zhi,甲賀町小佐治JPShigaKōka-shi34.9328136.223110Asia/Tokyopopulated place
8549441Dai Ni ŌbokutairaDai Ni Obokutaira,Dai Ni Ōbokutaira,dainioobokutaira,di er da mu ping,だいにおおぼくたいら,ダイニオオボクタイラ,第二大木平JPAomoriHirakawa Shi40.52117140.759070Asia/Tokyopopulated place
9865044ShimaderachōShimaderacho,Shimaderachō,dao si ding,島寺町JPFukuiFukui-shi36.02491136.144430Asia/Tokyopopulated place
9289468HabikigaokaHabikigaoka,yu yega qiu,羽曳が丘JPŌsakaHabikino-shi34.54014135.596360Asia/Tokyopopulated place
8312867ŌhiraOhira,da ping,oohira,Ōhira,おおひら,オオヒラ,大平JPMiyagiKami-gun38.67044140.739610Asia/Tokyopopulated place
1857551Matsue-higashiMatsue,Matsue-higashi,song jiang dong,松江東JPWakayamaWakayama Shi34.24444135.139030Asia/Tokyopopulated place
10979194TanakaTanaka,tian zhong,田中JPSaitamaKitakatsushika Gun35.92325139.808710Asia/Tokyopopulated place
1851293TadamaJPShizuokaShizuoka-shi35.1138.333330Asia/Tokyopopulated place
1861056JitōgataJidogata,Jidōgata,Jitogata,Jitōgata,Zitogata,Zitôgata,de tou fang,地頭方JPShizuokaMakinohara Shi34.63097138.185690Asia/Tokyopopulated place
9642348MinamifuruyamaMinamifuruyama,nan gu shan,南古山JPMieNabari-shi34.68314136.120160Asia/Tokyopopulated place
11175234Ogawamachi-shiranuiOgawamachi-shiranui,ogawamachishiranui,xiao chuan ding bu zhi huo,おがわまちしらぬい,オガワマチシラヌイ,小川町不知火JPKumamotoUki Shi32.61236130.651670Asia/Tokyopopulated place
2112206SugitamachiKita-sugita,Sugita,Sugitamachi,shan tian ding,杉田町JPFukushimaNihonmatsu Shi37.56741140.413950Asia/Tokyopopulated place
9888215TōnoharuTonoharu,Tōnoharu,tang yuan,唐原JPFukuokaFukuoka-shi33.67902130.439590Asia/Tokyopopulated place
2127822TeshikagaTeshikaga,Teshikaga-cho,Teshikaga-chō,di zi qu,di zi qu ding,teshikaga,てしかが,テシカガ,弟子屈,弟子屈町JPHokkaidoKawakami-gun43.48044144.496377631Asia/Tokyopopulated place
8663319KuwanoinKuwanoin,sang yuan,桑院JPToyamaHimi Shi36.81908136.890450Asia/Tokyopopulated place
10420034ShimojimaShimojima,xia dao,下島JPKanagawaHiratsuka Shi35.36876139.34320Asia/Tokyopopulated place
8315572DaiboDaibo,da bao,daibo,だいぼ,ダイボ,大保JPAkitaAkita Shi39.80404140.128250Asia/Tokyopopulated place
1850689TandoTando,TantoJPKagoshimaAira Shi31.73333130.666670Asia/Tokyopopulated place
1865552Ashiomachi-akakuraAkakura,Ashiomachi-akakura,zu wei ding chi cang,足尾町赤倉JPTochigiNikko-shi36.6661139.446580Asia/Tokyopopulated place
8721958Hikarino’okaHikarino’oka,Hikarino’oka,guangno qiu,hikarinooka,ひかりのおか,ヒカリノオカ,光の丘JPKanagawaYokosuka Shi35.22306139.675820Asia/Tokyopopulated place
11534331Higashinijō-minamiHigashinijo-minami,Higashinijō-minami,dong er tiao nan,higashinijouminami,ひがしにじょうみなみ,ヒガシニジョウミナミ,東二条南JPHokkaidoShiranuka-gun42.95352144.076870Asia/Tokyopopulated place
1861549Kasmiagatachō-inugauraInga,Inugaura,Kasmiagatacho-inugaura,Kasmiagatachō-inugaura,shang xian ding quanke pu,上県町犬ヶ浦JPNagasakiTsushima Shi34.53892129.337010Asia/Tokyopopulated place
9291250MaiMai,wu,舞JPŌsakaHannan Shi34.34203135.230880Asia/Tokyopopulated place
1857450MatsuzakiMatsuzaki,song qi,松崎JPTottoriTōhaku-gun35.46667133.90Asia/Tokyopopulated place
11137437KamiizumiKamiizumi,kamiizumi,shang quan,かみいずみ,カミイズミ,上泉JPChibaSodegaura-shi35.41219140.045770Asia/Tokyopopulated place
11102976TosaJPKochiTosa-gun33.73519133.482510Asia/Tokyopopulated place
1851781ShishichōShishi,Shishicho,Shishichō,Sisi,shi zi ding,獅子町JPNagasakiHirado Shi33.31174129.440930Asia/Tokyopopulated place
2129927InakuraishikōzanInakuraishi,Inakuraishikozan,InakuraishikōzanJPHokkaidoFurubira-gun43.16667140.616670Asia/Tokyopopulated place
9982847Saikaichō-kawachigōSaikaicho-kawachigo,Saikaichō-kawachigō,xi hai ding chuan nei xiang,西海町川内郷JPNagasakiSaikai-shi33.04949129.725110Asia/Tokyopopulated place
8711168ShinhamachōShinhamacho,Shinhamachō,xin bang ding,新浜町JPMiyagiShiogama Shi38.33039141.044240Asia/Tokyopopulated place
9115342KawagishiKawagishi,chuan an,川岸JPNaganoOkaya Shi36.04568138.02470Asia/Tokyopopulated place

FaQ about Japan


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.