Japan Geocode Database v.2.0.0
302,102 Database Records
Explore 301,405 distinct geographic names across 302,102 source rows for Japan. Includes feature identifiers, coordinates, designations and current source codes.
The package includes 33 current NGA fields in CSV, JSON and SQLite, plus schemas, samples and field statistics. Names and coordinates should be verified for operational use.
Table Schema Database Field Statistics
Release structure
Japan Geocode Database
Review the published tables, record coverage, and field names included with release 2.0.0.
- Database
- #626
- Version
- 2.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Table | Records | Fields |
|---|---|---|
| geographic_names | 302102 | rk, ufi, uni, full_name, nt, lat_dd, long_dd, efctv_dt, term_dt_f, term_dt_n, desig_cd, fc, cc_ft, adm1, ft_link, name_rank, lang_cd, transl_cd, script_cd, name_link, cc_nm, generic, full_nm_nd, sort_gen, sort_name, lat_dms, long_dms, mgrs, mod_dt_ft, mod_dt_nm, dialect_cd, display, gis_notes |
Release at a glance
What is inside this database
301,405 distinct names in 302,102 source rows.
Feature Class
- P137,563
- S63,526
- T43,355
- H34,717
- A18,524
- L2,805
- R1,366
- V238
- U8
Table and column statistics
Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.
- Distinct
- 6
- Missing
- 0 (0.0%)
- Distinct
- 93,713
- Missing
- 0 (0.0%)
- Distinct
- 301,405
- Missing
- 0 (0.0%)
- Distinct
- 235,731
- Missing
- 0 (0.0%)
- Distinct
- 7
- Missing
- 0 (0.0%)
- Distinct
- 80,769
- Missing
- 0 (0.0%)
- Distinct
- 80,661
- Missing
- 0 (0.0%)
- Distinct
- 0
- Missing
- 302,102 (100.0%)
- Distinct
- 74
- Missing
- 298,066 (98.7%)
- Distinct
- 17
- Missing
- 302,067 (100.0%)
- Distinct
- 243
- Missing
- 0 (0.0%)
- Distinct
- 9
- Missing
- 0 (0.0%)
- Distinct
- 2
- Missing
- 0 (0.0%)
- Distinct
- 49
- Missing
- 0 (0.0%)
- Distinct
- 3
- Missing
- 302,084 (100.0%)
- Distinct
- 8
- Missing
- 60,358 (20.0%)
- Distinct
- 4
- Missing
- 8,360 (2.8%)
- Distinct
- 9
- Missing
- 201,324 (66.6%)
- Distinct
- 9
- Missing
- 149,397 (49.5%)
- Distinct
- 150,986
- Missing
- 73,874 (24.5%)
- Distinct
- 1
- Missing
- 302,101 (100.0%)
- Distinct
- 1,768
- Missing
- 178,177 (59.0%)
- Distinct
- 234,887
- Missing
- 0 (0.0%)
- Distinct
- 1,648
- Missing
- 178,177 (59.0%)
- Distinct
- 223,057
- Missing
- 0 (0.0%)
- Distinct
- 34,733
- Missing
- 0 (0.0%)
- Distinct
- 36,370
- Missing
- 0 (0.0%)
- Distinct
- 92,516
- Missing
- 0 (0.0%)
- Distinct
- 2,851
- Missing
- 0 (0.0%)
- Distinct
- 4,862
- Missing
- 0 (0.0%)
- Distinct
- 0
- Missing
- 302,102 (100.0%)
- Distinct
- 9
- Missing
- 0 (0.0%)
- Distinct
- 1
- Missing
- 302,098 (100.0%)
Inspect the data
Representative sample data
Switch tables to review representative fields and rows from every table advertised for this release.
geographic namesDownload this sample CSV
| rk | ufi | uni | full_name | nt | lat_dd | long_dd | efctv_dt | term_dt_f | term_dt_n | desig_cd | fc | cc_ft | adm1 | ft_link | name_rank | lang_cd | transl_cd | script_cd | name_link | cc_nm | generic | full_nm_nd | sort_gen | sort_name | lat_dms | long_dms | mgrs | mod_dt_ft | mod_dt_nm | dialect_cd | display | gis_notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 14786292 | 19340877 | Meguro Nihon Daigaku Chūgakkō | N | 35.635075 | 139.711633 | SCH | S | JPN | JP-13 | 1 | jpn | jpn_Hrkt2Latn_BGN_1930 | 19340878 | Gakkō | Meguro Nihon Daigaku Chugakko | GAKKO | MEGURONIHONDAIGAKUCHUGAKKO | 35:38:06 | 139:42:42 | 54SUE8334744238 | 2019-06-18T00:00:00.000Z | 2019-06-18T00:00:00.000Z | 1,2 | ||||||||
| 4 | -3844396 | -5083261 | Temnyy | D | 45.087366 | 147.860374 | STM | H | JPN | JP-01 | 1 | rus | rus_Cyrl2Latn_BGN_1947 | 18705955 | Temnyy | TEMNYY | 45:05:15 | 147:51:37 | 55TEK6770793016 | 2013-07-24T00:00:00.000Z | 2017-10-27T00:00:00.000Z | 1,2,3,4 | ||||||||||
| 5 | -239622 | -361970 | Ōfu | V | 35 | 136.966667 | PPL | P | JPN | JP-23 | jpn | Ofu | OFU | 35:00:00 | 136:58:00 | 53SPU7947474810 | 2001-08-28T00:00:00.000Z | 1993-09-01T00:00:00.000Z | 1,2,3,4,5 | |||||||||||||
| 5 | -226983 | -336235 | Edō | N | 34.266667 | 131.35 | PPL | P | JPN | JP-35 | 1 | Edo | EDO | 34:16:00 | 131:21:00 | 52SGC1635994223 | 2001-09-05T00:00:00.000Z | 1993-09-01T00:00:00.000Z | 1,2,3,4,5 | |||||||||||||
| 5 | -226354 | -334924 | Bō | N | 31.266667 | 130.233333 | PPL | P | JPN | JP-46 | 1 | Bo | BO | 31:16:00 | 130:14:00 | 52RFV1741759812 | 2001-08-29T00:00:00.000Z | 1993-09-01T00:00:00.000Z | 1,2,3,4,5 | |||||||||||||
| 5 | -237337 | -357222 | Mui | N | 43.333333 | 140.4 | PPL | P | JPN | JP-01 | 1 | Mui | MUI | 43:20:00 | 140:24:00 | 54TVN5136098007 | 2001-09-25T00:00:00.000Z | 1993-09-01T00:00:00.000Z | 1,2,3,4,5 | |||||||||||||
| 5 | -229666 | -341613 | Hon | N | 34.85 | 133.1 | AREA | L | JPN | JP-000 | 1 | jpn | Hon | HON | 34:51:00 | 133:06:00 | 53SLU2629558055 | 1994-02-05T00:00:00.000Z | 2014-04-03T00:00:00.000Z | 1,2,3,4,5 | ||||||||||||
| 5 | -240028 | -362526 | Ōi | N | 35.45 | 137.4 | RSTN | S | JPN | JP-21 | 1 | jpn | Oi | OI | 35:27:00 | 137:24:00 | 53SQV1781925595 | 2014-04-17T00:00:00.000Z | 2014-04-17T00:00:00.000Z | 1,2,3,4,5 | ||||||||||||
| 5 | 246161 | 309729 | I-ze | N | 34.090556 | 130.872222 | SHOL | H | JPN | JP-35 | 1 | -ze | I-ze | ZE | IZE | 34:05:26 | 130:52:20 | 52SFC7272373779 | 1997-03-25T00:00:00.000Z | 1997-03-20T00:00:00.000Z | 1,2,3 | |||||||||||
| 5 | 9253175 | 9330419 | Nii | N | 35.693333 | 135.302778 | PPL | P | JPN | JP-26 | 1 | jpn | Nii | NII | 35:41:36 | 135:18:10 | 53SNV2739449978 | 2014-04-02T00:00:00.000Z | 2007-01-25T00:00:00.000Z | 1,2 | ||||||||||||
| 4 | -3844352 | -5083217 | Zolotoy | D | 45.070833 | 147.532778 | STM | H | JPN | JP-01 | 1 | rus | rus_Cyrl2Latn_BGN_1947 | Zolotoy | ZOLOTOY | 45:04:15 | 147:31:58 | 55TEK4193990957 | 2013-07-24T00:00:00.000Z | 2017-02-01T00:00:00.000Z | 1,2 | |||||||||||
| 4 | -3844412 | 6676142 | Гора Карелка | DS | 45.027275 | 147.975968 | MT | T | JPN | JP-01 | rus | Cyrl | -5083277 | Гора | Гора Карелка | ГОРА | ГОРАКАРЕЛКА | 45:01:38 | 147:58:33 | 55TEK7688586444 | 2013-07-24T00:00:00.000Z | 2017-10-26T00:00:00.000Z | 1,2,3,4 | |||||||||
| 4 | -3844303 | 6804718 | Нежный | DS | 45.278889 | 147.868056 | STM | H | JPN | JP-01 | rus | Cyrl | -5083168 | Нежный | НЕЖНЫЙ | 45:16:44 | 147:52:05 | 55TEL6808314299 | 2013-07-24T00:00:00.000Z | 2017-02-01T00:00:00.000Z | 1,2 | |||||||||||
| 5 | -3845091 | 18972841 | テイネイガワ | NS | 44.884011 | 147.613269 | STM | H | JPN | JP-01 | 4 | jpn | Kana | 18972838 | ガワ | テイネイガワ | ガワ | テイネイガワ | 44:53:02 | 147:36:48 | 55TEK4843270249 | 2018-06-08T00:00:00.000Z | 2018-06-08T00:00:00.000Z | 1,2,3,4 | ||||||||
| 5 | -3845088 | 18972939 | うえんべつがわ | NS | 44.928942 | 147.627926 | STM | H | JPN | JP-01 | 3 | jpn | Hira | 18972937 | がわ | うえんべつがわ | がわ | うえんべつがわ | 44:55:44 | 147:37:41 | 55TEK4955175249 | 2018-06-08T00:00:00.000Z | 2018-06-08T00:00:00.000Z | 1,2 | ||||||||
| 4 | -3844313 | -5083178 | Banka Tri Zuba | D | 45.227778 | 147.8625 | BNK | H | JPN | JP-01 | 1 | rus | rus_Cyrl2Latn_BGN_1947 | 6620778 | Banka | Banka Tri Zuba | BANKA | BANKATRIZUBA | 45:13:40 | 147:51:45 | 55TEL6770808616 | 2013-07-24T00:00:00.000Z | 2017-10-26T00:00:00.000Z | 1,2 | ||||||||
| 5 | -3845095 | 18972830 | ぐやがわ | NS | 44.816308 | 147.529758 | STM | H | JPN | JP-01 | 3 | jpn | Hira | 18972828 | がわ | ぐやがわ | がわ | ぐやがわ | 44:48:59 | 147:31:47 | 55TEK4188662681 | 2018-06-08T00:00:00.000Z | 2018-06-08T00:00:00.000Z | 1,2,3,4 | ||||||||
| 5 | -3844312 | 18984080 | 紗那沼 | NS | 45.232822 | 147.903269 | LK | H | JPN | JP-01 | 2 | jpn | Hani | 18984079 | 沼 | 紗那沼 | 沼 | 紗那沼 | 45:13:58 | 147:54:12 | 55TEL7090209211 | 2018-06-20T00:00:00.000Z | 2018-06-20T00:00:00.000Z | 1,2,3,4 | ||||||||
| 5 | -3845120 | 18983826 | きたちりっぷさん | NS | 45.376983 | 147.913236 | VLC | T | JPN | JP-01 | 3 | jpn | Hira | 18983824 | さん | きたちりっぷさん | さん | きたちりっぷさん | 45:22:37 | 147:54:48 | 55TEL7150325235 | 2018-06-20T00:00:00.000Z | 2018-06-20T00:00:00.000Z | 1,2,3,4 | ||||||||
| 4 | -3845094 | -5083977 | Razvilok | D | 44.865 | 147.591667 | STM | H | JPN | JP-01 | 1 | rus | rus_Cyrl2Latn_BGN_1947 | 6856117 | Razvilok | RAZVILOK | 44:51:54 | 147:35:30 | 55TEK4674268124 | 2013-07-24T00:00:00.000Z | 2017-02-01T00:00:00.000Z | 1,2 |
Records Information
302,102 geographic name rows; 301,405 distinct UNI name identifiers; 93,713 distinct UFI feature identifiers. Shared-country name rows are included only when the exact JPN token occurs in cc_ft.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
Need a closer fit?
Data shaped around your project.
Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.RECENT DATA UPDATES
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needsLicense rights
Single Product Publication
Read the complete Oddity Software Single Product Publication License
Use the entire listed package for internal work, customer-facing websites and apps, and client projects. The license is for this product, not one named project. Raw dataset handoff or standalone resale needs a separate grant.
Downloads of an eligible purchased version are unlimited while it remains the current public version. A newer release does not automatically become part of the earlier order.
A clear path from download to project
Get more from your data
Understand the files, check the sample coverage, and choose the license that fits your use.