Skip to product information
Japan Postal Codes, Streets & Address Database - CSV, Excel, SQL, XML
$29.00 USD
|
Japan · All 47 prefectures
A structured, ready-to-use database of 120,046 postal codes and 1,885 cities across all 47 prefectures of Japan - instantly downloadable in CSV, Excel, SQL and XML. |
Country data
|
120,046
Postal codes
|
1,885
Cities
|
47
Prefectures
|
Did you know?
The most common street name in Japan is Main street, appearing 124,084 times across the dataset.
Sample data preview
Switch tabs to preview each file.
| Country Code | Country | Region | Region2 | Region3 | Region4 |
|---|---|---|---|---|---|
| JP | Japan | Fukushima Prefecture | In the song | ||
| JP | Japan | Niigata Prefecture | Box Rock | ||
| JP | Japan | Hokkaido | North 34th east |
| CC | Country | Region | City | Postal |
|---|---|---|---|---|
| JP | Japan | Aomori Prefecture | Tsugaru City | 038 - 3304 |
| JP | Japan | Fukushima Prefecture | Aizuwakamatsu City | 965 - 0056 |
| JP | Japan | Gifu Prefecture | Gifu City | 502 - 0858 |
| CC | Country | Region | City | Postal | Street | Lat | Lng | Elevation (m) | Geocoding Level | Accuracy Radius (m) |
|---|---|---|---|---|---|---|---|---|---|---|
| JP | Japan | Tokyo | Sumida Ward | 130 - 0002 | Main street | 35.7080666 | 139.8117118 | 6 | POSTAL_CODE | 5000 |
| JP | Japan | Tokyo | Shinjuku ward | 163 - 0927 | Main street | 35.8922487 | 139.6842152 | 4 | CITY | 1000 |
| JP | Japan | Fukushima Prefecture | Date City | 052 - 0026 | Main street | 42.4691076 | 140.8609931 | 5 | POSTAL_CODE | 5000 |
| Country Code | Country | Region | City | Postal Code | Street | Number | Latitude | Longitude | Elevation (m) |
|---|---|---|---|---|---|---|---|---|---|
| JP | Japan | Toyama Prefecture | Takaoka City | 933 - 0804 | Main street | 36.7292930 | 137.0254150 | 13 | |
| JP | Japan | Ehime Prefecture | Imabari | 794 - 0061 | Main street | 34.0658182 | 132.9976758 | 6 | |
| JP | Japan | Akita | Yuzawa City | 012 - 0033 | Main street | 39.1659128 | 140.4831151 | 82 |
Formats & delivery
Available in SQL, Excel, CSV, GIS, SQLite, MySQL, PostgreSQL, SQL Server, KML, GeoJSON, Shapefile, Oracle, Access. Delivered by email within minutes of purchase. One complimentary refresh within 30 days.
Updated on October 19, 2026 · View sample data