​Japan's Prefectures, Cities, Towns, Districts SQL Data - Download

​You are building a website or app that ​will use Japan's Prefectures, Cities, Towns (Zipcodes), Districts (Block numbers)​, Addresses data?

You need structured data, zip codes list in Japanese but also Hiragana, Katakana, and Translated in Romaji.

​

​Those data are not easy to found on the internet.

I'm living in Japan and worked as an IT engineer​ for many japanese companies. 

I can tell you that those "base data" are quite useful and time-saving when you are developing an application that requires Japanese addresses.

For example,​ you might need them if you implement:

• ​An address search functionality via the zip or postal code
• List the cities of a prefecture in Japan
• ​Get the address in romaji for a foreign application
• Register some clients addresses and locate them on Google map

...

​If you want to save your time and don't ​want to create ​all the data by yourself​:

Here some Prefectures, Cities, Towns (Zipcodes), Districts (Block numbers)​ SQL ready to use!

What you will get:

SQL files for MySQL :

• Create tables scripts: Prefectures, Cities, Towns, Districts (Blocks)
  
• All Prefectures data (Inserts of 47 records)
• All Cities data (Inserts of 1,936 records)
  
• All Towns data (Inserts of 143,878 records)
  
• All Districts data (Inserts of 148,119 records)
  
  

​Sample data:

​​To give you an idea of what ​data you will have access, here some sample data extracted from the tables (you can easily export them in​ CSV, TSV​, PHP array...).​​​

Prefectures.sql:

Cities.sql:

Towns.sql:

Blocks.sql:

​​License: You can use the data for personal or commercial purposes. But don't resell or redistribute it.