subdivisions

Data source: ISO

87 rows where country_code = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: local_variant, parent_subdivision

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
MA,MA-01 MA MA-01 Tanger-Tétouan-Al Hoceïma   ar conventional names  
MA,MA-02 MA MA-02 L'Oriental   ar conventional names  
MA,MA-03 MA MA-03 Fès-Meknès   ar conventional names  
MA,MA-04 MA MA-04 Rabat-Salé-Kénitra   ar conventional names  
MA,MA-05 MA MA-05 Béni Mellal-Khénifra   ar conventional names  
MA,MA-06 MA MA-06 Casablanca-Settat   ar conventional names  
MA,MA-07 MA MA-07 Marrakech-Safi   ar conventional names  
MA,MA-08 MA MA-08 Drâa-Tafilalet   ar conventional names  
MA,MA-09 MA MA-09 Souss-Massa   ar conventional names  
MA,MA-10 MA MA-10 Guelmim-Oued Noun (EH-partial)   ar conventional names  
MA,MA-11 MA MA-11 Laâyoune-Sakia El Hamra (EH-partial)   ar conventional names  
MA,MA-12 MA MA-12 Dakhla-Oued Ed-Dahab (EH)   ar conventional names  
MA,MA-AGD* MA MA-AGD* Agadir-Ida-Ou-Tanane   ar conventional names MA-09
MA,MA-AOU* MA MA-AOU* Aousserd (EH)   ar conventional names MA-12
MA,MA-ASZ* MA MA-ASZ* Assa-Zag (EH-partial)   ar conventional names MA-10
MA,MA-AZI* MA MA-AZI* Azilal   ar conventional names MA-05
MA,MA-BEM* MA MA-BEM* Béni Mellal   ar conventional names MA-05
MA,MA-BER* MA MA-BER* Berkane   ar conventional names MA-02
MA,MA-BES* MA MA-BES* Benslimane   ar conventional names MA-06
MA,MA-BOD* MA MA-BOD* Boujdour (EH)   ar conventional names MA-11
MA,MA-BOM* MA MA-BOM* Boulemane   ar conventional names MA-03
MA,MA-BRR* MA MA-BRR* Berrechid   ar conventional names MA-06
MA,MA-CAS* MA MA-CAS* Casablanca Dar el Beïda ar conventional names MA-06
MA,MA-CHE* MA MA-CHE* Chefchaouen   ar conventional names MA-01
MA,MA-CHI* MA MA-CHI* Chichaoua   ar conventional names MA-07
MA,MA-CHT* MA MA-CHT* Chtouka-Ait Baha   ar conventional names MA-06
MA,MA-DRI* MA MA-DRI* Driouch   ar conventional names MA-02
MA,MA-ERR* MA MA-ERR* Errachidia   ar conventional names MA-08
MA,MA-ESI* MA MA-ESI* Essaouira   ar conventional names MA-07
MA,MA-ESM* MA MA-ESM* Es-Semara (EH-partial)   ar conventional names MA-11
MA,MA-FAH* MA MA-FAH* Fahs-Anjra   ar conventional names MA-01
MA,MA-FES* MA MA-FES* Fès   ar conventional names MA-03
MA,MA-FIG* MA MA-FIG* Figuig   ar conventional names MA-02
MA,MA-FQH* MA MA-FQH* Fquih Ben Salah   ar conventional names MA-05
MA,MA-GUE* MA MA-GUE* Guelmim   ar conventional names MA-10
MA,MA-GUF* MA MA-GUF* Guercif   ar conventional names MA-02
MA,MA-HAJ* MA MA-HAJ* El Hajeb   ar conventional names MA-03
MA,MA-HAO* MA MA-HAO* Al Haouz   ar conventional names MA-07
MA,MA-HOC* MA MA-HOC* Al Hoceïma   ar conventional names MA-01
MA,MA-IFR* MA MA-IFR* Ifrane   ar conventional names MA-03
MA,MA-INE* MA MA-INE* Inezgane-Ait Melloul   ar conventional names MA-09
MA,MA-JDI* MA MA-JDI* El Jadida   ar conventional names MA-06
MA,MA-JRA* MA MA-JRA* Jerada   ar conventional names MA-02
MA,MA-KEN* MA MA-KEN* Kénitra   ar conventional names MA-04
MA,MA-KES* MA MA-KES* El Kelâa des Sraghna   ar conventional names MA-07
MA,MA-KHE* MA MA-KHE* Khémisset   ar conventional names MA-04
MA,MA-KHN* MA MA-KHN* Khénifra   ar conventional names MA-05
MA,MA-KHO* MA MA-KHO* Khouribga   ar conventional names MA-05
MA,MA-LAA* MA MA-LAA* Laâyoune (EH)   ar conventional names MA-11
MA,MA-LAR* MA MA-LAR* Larache   ar conventional names MA-01
MA,MA-MAR* MA MA-MAR* Marrakech   ar conventional names MA-07
MA,MA-MDF* MA MA-MDF* M’diq-Fnideq   ar conventional names MA-01
MA,MA-MED* MA MA-MED* Médiouna   ar conventional names MA-06
MA,MA-MEK* MA MA-MEK* Meknès   ar conventional names MA-03
MA,MA-MID* MA MA-MID* Midelt   ar conventional names MA-08
MA,MA-MOH* MA MA-MOH* Mohammadia   ar conventional names MA-06
MA,MA-MOU* MA MA-MOU* Moulay Yacoub   ar conventional names MA-03
MA,MA-NAD* MA MA-NAD* Nador   ar conventional names MA-02
MA,MA-NOU* MA MA-NOU* Nouaceur   ar conventional names MA-04
MA,MA-OUA* MA MA-OUA* Ouarzazate   ar conventional names MA-08
MA,MA-OUD* MA MA-OUD* Oued Ed-Dahab (EH)   ar conventional names MA-12
MA,MA-OUJ* MA MA-OUJ* Oujda-Angad   ar conventional names MA-02
MA,MA-OUZ* MA MA-OUZ* Ouezzane   ar conventional names MA-01
MA,MA-RAB* MA MA-RAB* Rabat   ar conventional names MA-04
MA,MA-REH* MA MA-REH* Rehamna   ar conventional names MA-07
MA,MA-SAF* MA MA-SAF* Safi   ar conventional names MA-07
MA,MA-SAL* MA MA-SAL* Salé   ar conventional names MA-04
MA,MA-SEF* MA MA-SEF* Sefrou   ar conventional names MA-03
MA,MA-SET* MA MA-SET* Settat   ar conventional names MA-06
MA,MA-SIB* MA MA-SIB* Sidi Bennour   ar conventional names MA-06
MA,MA-SIF* MA MA-SIF* Sidi Ifni   ar conventional names MA-10
MA,MA-SIK* MA MA-SIK* Sidi Kacem   ar conventional names MA-04
MA,MA-SIL* MA MA-SIL* Sidi Slimane   ar conventional names MA-04
MA,MA-SKH* MA MA-SKH* Skhirate-Témara   ar conventional names MA-04
MA,MA-TAF* MA MA-TAF* Tarfaya (EH-partial)   ar conventional names MA-11
MA,MA-TAI* MA MA-TAI* Taourirt   ar conventional names MA-02
MA,MA-TAO* MA MA-TAO* Taounate   ar conventional names MA-03
MA,MA-TAR* MA MA-TAR* Taroudannt   ar conventional names MA-09
MA,MA-TAT* MA MA-TAT* Tata   ar conventional names MA-09
MA,MA-TAZ* MA MA-TAZ* Taza   ar conventional names MA-03
MA,MA-TET* MA MA-TET* Tétouan   ar conventional names MA-01
MA,MA-TIN* MA MA-TIN* Tinghir   ar conventional names MA-08
MA,MA-TIZ* MA MA-TIZ* Tiznit   ar conventional names MA-09
MA,MA-TNG* MA MA-TNG* Tanger-Assilah   ar conventional names MA-01
MA,MA-TNT* MA MA-TNT* Tan-Tan (EH-partial)   ar conventional names MA-10
MA,MA-YUS* MA MA-YUS* Youssoufia   ar conventional names MA-07
MA,MA-ZAG* MA MA-ZAG* Zagora   ar conventional names MA-08

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