subdivisions

Data source: ISO

24 rows where country_code = "ME"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
ME,ME-01* ME ME-01* Andrijevica   -    
ME,ME-02* ME ME-02* Bar   -    
ME,ME-03* ME ME-03* Berane   -    
ME,ME-04* ME ME-04* Bijelo Polje   -    
ME,ME-05* ME ME-05* Budva   -    
ME,ME-06* ME ME-06* Cetinje   -    
ME,ME-07* ME ME-07* Danilovgrad   -    
ME,ME-08* ME ME-08* Herceg-Novi   -    
ME,ME-09* ME ME-09* Kolašin   -    
ME,ME-10* ME ME-10* Kotor   -    
ME,ME-11* ME ME-11* Mojkovac   -    
ME,ME-12* ME ME-12* Nikšić   -    
ME,ME-13* ME ME-13* Plav   -    
ME,ME-14* ME ME-14* Pljevlja   -    
ME,ME-15* ME ME-15* Plužine   -    
ME,ME-16* ME ME-16* Podgorica   -    
ME,ME-17* ME ME-17* Rožaje   -    
ME,ME-18* ME ME-18* Šavnik   -    
ME,ME-19* ME ME-19* Tivat   -    
ME,ME-20* ME ME-20* Ulcinj   -    
ME,ME-21* ME ME-21* Žabljak   -    
ME,ME-22* ME ME-22* Gusinje   -    
ME,ME-23* ME ME-23* Petnjica   -    
ME,ME-24* ME ME-24* Tuzi   -    

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
);