subdivisions

Data source: ISO

21 rows where country_code = "SE"

✎ View and edit SQL

This data as json, CSV (advanced)

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
SE,SE-AB SE SE-AB Stockholms län [SE-01]   sv    
SE,SE-AC SE SE-AC Västerbottens län [SE-24]   sv    
SE,SE-BD SE SE-BD Norrbottens län [SE-25]   sv    
SE,SE-C SE SE-C Uppsala län [SE-03]   sv    
SE,SE-D SE SE-D Södermanlands län [SE-04]   sv    
SE,SE-E SE SE-E Östergötlands län [SE-05]   sv    
SE,SE-F SE SE-F Jönköpings län [SE-06]   sv    
SE,SE-G SE SE-G Kronobergs län [SE-07]   sv    
SE,SE-H SE SE-H Kalmar län [SE-08]   sv    
SE,SE-I SE SE-I Gotlands län [SE-09]   sv    
SE,SE-K SE SE-K Blekinge län [SE-10]   sv    
SE,SE-M SE SE-M Skåne län [SE-12]   sv    
SE,SE-N SE SE-N Hallands län [SE-13]   sv    
SE,SE-O SE SE-O Västra Götalands län [SE-14]   sv    
SE,SE-S SE SE-S Värmlands län [SE-17]   sv    
SE,SE-T SE SE-T Örebro län [SE-18]   sv    
SE,SE-U SE SE-U Västmanlands län [SE-19]   sv    
SE,SE-W SE SE-W Dalarnas län [SE-20]   sv    
SE,SE-X SE SE-X Gävleborgs län [SE-21]   sv    
SE,SE-Y SE SE-Y Västernorrlands län [SE-22]   sv    
SE,SE-Z SE SE-Z Jämtlands län [SE-23]   sv    

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