Data source: ISO

48 rows where country_code = "DZ"

View and edit SQL

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
DZ DZ-01 Adrar   ar conventional names  
DZ DZ-02 Chlef   ar conventional names  
DZ DZ-03 Laghouat   ar conventional names  
DZ DZ-04 Oum el Bouaghi   ar conventional names  
DZ DZ-05 Batna   ar conventional names  
DZ DZ-06 Béjaïa   ar conventional names  
DZ DZ-07 Biskra   ar conventional names  
DZ DZ-08 Béchar   ar conventional names  
DZ DZ-09 Blida   ar conventional names  
DZ DZ-10 Bouira   ar conventional names  
DZ DZ-11 Tamanrasset   ar conventional names  
DZ DZ-12 Tébessa   ar conventional names  
DZ DZ-13 Tlemcen   ar conventional names  
DZ DZ-14 Tiaret   ar conventional names  
DZ DZ-15 Tizi Ouzou   ar conventional names  
DZ DZ-16 Alger   ar conventional names  
DZ DZ-17 Djelfa   ar conventional names  
DZ DZ-18 Jijel   ar conventional names  
DZ DZ-19 Sétif   ar conventional names  
DZ DZ-20 Saïda   ar conventional names  
DZ DZ-21 Skikda   ar conventional names  
DZ DZ-22 Sidi Bel Abbès   ar conventional names  
DZ DZ-23 Annaba   ar conventional names  
DZ DZ-24 Guelma   ar conventional names  
DZ DZ-25 Constantine   ar conventional names  
DZ DZ-26 Médéa   ar conventional names  
DZ DZ-27 Mostaganem   ar conventional names  
DZ DZ-28 M'sila   ar conventional names  
DZ DZ-29 Mascara   ar conventional names  
DZ DZ-30 Ouargla   ar conventional names  
DZ DZ-31 Oran   ar conventional names  
DZ DZ-32 El Bayadh   ar conventional names  
DZ DZ-33 Illizi   ar conventional names  
DZ DZ-34 Bordj Bou Arréridj   ar conventional names  
DZ DZ-35 Boumerdès   ar conventional names  
DZ DZ-36 El Tarf   ar conventional names  
DZ DZ-37 Tindouf   ar conventional names  
DZ DZ-38 Tissemsilt   ar conventional names  
DZ DZ-39 El Oued   ar conventional names  
DZ DZ-40 Khenchela   ar conventional names  
DZ DZ-41 Souk Ahras   ar conventional names  
DZ DZ-42 Tipaza   ar conventional names  
DZ DZ-43 Mila   ar conventional names  
DZ DZ-44 Aïn Defla   ar conventional names  
DZ DZ-45 Naama   ar conventional names  
DZ DZ-46 Aïn Témouchent   ar conventional names  
DZ DZ-47 Ghardaïa   ar conventional names  
DZ DZ-48 Relizane   ar conventional names  

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