subdivisions

Data source: ISO

47 rows where country_code = "JP"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
JP,JP-01 JP JP-01 Hokkaidô   ja ISO 3602:1989  
JP,JP-02 JP JP-02 Aomori   ja ISO 3602:1989  
JP,JP-03 JP JP-03 Iwate   ja ISO 3602:1989  
JP,JP-04 JP JP-04 Miyagi   ja ISO 3602:1989  
JP,JP-05 JP JP-05 Akita   ja ISO 3602:1989  
JP,JP-06 JP JP-06 Yamagata   ja ISO 3602:1989  
JP,JP-07 JP JP-07 Hukusima   ja ISO 3602:1989  
JP,JP-08 JP JP-08 Ibaraki   ja ISO 3602:1989  
JP,JP-09 JP JP-09 Totigi   ja ISO 3602:1989  
JP,JP-10 JP JP-10 Gunma   ja ISO 3602:1989  
JP,JP-11 JP JP-11 Saitama   ja ISO 3602:1989  
JP,JP-12 JP JP-12 Tiba   ja ISO 3602:1989  
JP,JP-13 JP JP-13 Tôkyô   ja ISO 3602:1989  
JP,JP-14 JP JP-14 Kanagawa   ja ISO 3602:1989  
JP,JP-15 JP JP-15 Niigata   ja ISO 3602:1989  
JP,JP-16 JP JP-16 Toyama   ja ISO 3602:1989  
JP,JP-17 JP JP-17 Isikawa   ja ISO 3602:1989  
JP,JP-18 JP JP-18 Hukui   ja ISO 3602:1989  
JP,JP-19 JP JP-19 Yamanasi   ja ISO 3602:1989  
JP,JP-20 JP JP-20 Nagano   ja ISO 3602:1989  
JP,JP-21 JP JP-21 Gihu   ja ISO 3602:1989  
JP,JP-22 JP JP-22 Sizuoka   ja ISO 3602:1989  
JP,JP-23 JP JP-23 Aiti   ja ISO 3602:1989  
JP,JP-24 JP JP-24 Mie   ja ISO 3602:1989  
JP,JP-25 JP JP-25 Siga   ja ISO 3602:1989  
JP,JP-26 JP JP-26 Kyôto   ja ISO 3602:1989  
JP,JP-27 JP JP-27 Ôsaka   ja ISO 3602:1989  
JP,JP-28 JP JP-28 Hyôgo   ja ISO 3602:1989  
JP,JP-29 JP JP-29 Nara   ja ISO 3602:1989  
JP,JP-30 JP JP-30 Wakayama   ja ISO 3602:1989  
JP,JP-31 JP JP-31 Tottori   ja ISO 3602:1989  
JP,JP-32 JP JP-32 Simane   ja ISO 3602:1989  
JP,JP-33 JP JP-33 Okayama   ja ISO 3602:1989  
JP,JP-34 JP JP-34 Hirosima   ja ISO 3602:1989  
JP,JP-35 JP JP-35 Yamaguti   ja ISO 3602:1989  
JP,JP-36 JP JP-36 Tokusima   ja ISO 3602:1989  
JP,JP-37 JP JP-37 Kagawa   ja ISO 3602:1989  
JP,JP-38 JP JP-38 Ehime   ja ISO 3602:1989  
JP,JP-39 JP JP-39 Kôti   ja ISO 3602:1989  
JP,JP-40 JP JP-40 Hukuoka   ja ISO 3602:1989  
JP,JP-41 JP JP-41 Saga   ja ISO 3602:1989  
JP,JP-42 JP JP-42 Nagasaki   ja ISO 3602:1989  
JP,JP-43 JP JP-43 Kumamoto   ja ISO 3602:1989  
JP,JP-44 JP JP-44 Ôita   ja ISO 3602:1989  
JP,JP-45 JP JP-45 Miyazaki   ja ISO 3602:1989  
JP,JP-46 JP JP-46 Kagosima   ja ISO 3602:1989  
JP,JP-47 JP JP-47 Okinawa   ja ISO 3602:1989  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE subdivisions (
    country_code text NOT NULL
    , code_31662 text NOT NULL
    , name text
    , local_variant text
    , language_code text
    , romanization_system text
    , parent_subdivision text
    , PRIMARY KEY (country_code , code_31662)
    , FOREIGN KEY (country_code) REFERENCES countries (alpha_2_code) ON DELETE CASCADE
    , FOREIGN KEY (language_code) REFERENCES languages (alpha_2_code) ON DELETE CASCADE
);