subdivisions

Data source: ISO

27 rows where country_code = "SC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: language_code

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
SC,SC-01* SC SC-01* Anse aux Pins   fr    
SC,SC-02* SC SC-02* Anse Boileau   fr    
SC,SC-03* SC SC-03* Anse Étoile   fr    
SC,SC-04* SC SC-04* O Kap   -    
SC,SC-05* SC SC-05* Anse Royale   fr    
SC,SC-06* SC SC-06* Be Lazar   -    
SC,SC-07* SC SC-07* Be Sent Ann   -    
SC,SC-08* SC SC-08* Bovalon   -    
SC,SC-09* SC SC-09* Beler   -    
SC,SC-10* SC SC-10* Belonm   -    
SC,SC-11* SC SC-11* Kaskad   -    
SC,SC-12* SC SC-12* Glasi   -    
SC,SC-13* SC SC-13* Grand'Anse Mahé   fr    
SC,SC-14* SC SC-14* Grand'Anse Praslin   fr    
SC,SC-15* SC SC-15* Ladig   -    
SC,SC-16* SC SC-16* Larivyer Anglez   -    
SC,SC-17* SC SC-17* Mont Buxton   fr    
SC,SC-18* SC SC-18* Mont Fleuri   fr    
SC,SC-19* SC SC-19* Plezans   -    
SC,SC-20* SC SC-20* Pwent Lari   -    
SC,SC-21* SC SC-21* Port Glaud   fr    
SC,SC-22* SC SC-22* Sen Lwi   -    
SC,SC-23* SC SC-23* Takamaka   fr    
SC,SC-24* SC SC-24* Les Mamelles   fr    
SC,SC-25* SC SC-25* Ros Kaiman   -    
SC,SC-26* SC SC-26* Île Persévérance I   fr    
SC,SC-27* SC SC-27* Île Persévérance II   fr    

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