subdivisions
Data source: ISO
48 rows where country_code = "DZ"
This data as json, CSV (advanced)
Link | country_code | code_31662 | name | local_variant | language_code | romanization_system | parent_subdivision |
---|---|---|---|---|---|---|---|
DZ,DZ-01 | DZ | DZ-01 | Adrar | ar | conventional names | ||
DZ,DZ-02 | DZ | DZ-02 | Chlef | ar | conventional names | ||
DZ,DZ-03 | DZ | DZ-03 | Laghouat | ar | conventional names | ||
DZ,DZ-04 | DZ | DZ-04 | Oum el Bouaghi | ar | conventional names | ||
DZ,DZ-05 | DZ | DZ-05 | Batna | ar | conventional names | ||
DZ,DZ-06 | DZ | DZ-06 | Béjaïa | ar | conventional names | ||
DZ,DZ-07 | DZ | DZ-07 | Biskra | ar | conventional names | ||
DZ,DZ-08 | DZ | DZ-08 | Béchar | ar | conventional names | ||
DZ,DZ-09 | DZ | DZ-09 | Blida | ar | conventional names | ||
DZ,DZ-10 | DZ | DZ-10 | Bouira | ar | conventional names | ||
DZ,DZ-11 | DZ | DZ-11 | Tamanrasset | ar | conventional names | ||
DZ,DZ-12 | DZ | DZ-12 | Tébessa | ar | conventional names | ||
DZ,DZ-13 | DZ | DZ-13 | Tlemcen | ar | conventional names | ||
DZ,DZ-14 | DZ | DZ-14 | Tiaret | ar | conventional names | ||
DZ,DZ-15 | DZ | DZ-15 | Tizi Ouzou | ar | conventional names | ||
DZ,DZ-16 | DZ | DZ-16 | Alger | ar | conventional names | ||
DZ,DZ-17 | DZ | DZ-17 | Djelfa | ar | conventional names | ||
DZ,DZ-18 | DZ | DZ-18 | Jijel | ar | conventional names | ||
DZ,DZ-19 | DZ | DZ-19 | Sétif | ar | conventional names | ||
DZ,DZ-20 | DZ | DZ-20 | Saïda | ar | conventional names | ||
DZ,DZ-21 | DZ | DZ-21 | Skikda | ar | conventional names | ||
DZ,DZ-22 | DZ | DZ-22 | Sidi Bel Abbès | ar | conventional names | ||
DZ,DZ-23 | DZ | DZ-23 | Annaba | ar | conventional names | ||
DZ,DZ-24 | DZ | DZ-24 | Guelma | ar | conventional names | ||
DZ,DZ-25 | DZ | DZ-25 | Constantine | ar | conventional names | ||
DZ,DZ-26 | DZ | DZ-26 | Médéa | ar | conventional names | ||
DZ,DZ-27 | DZ | DZ-27 | Mostaganem | ar | conventional names | ||
DZ,DZ-28 | DZ | DZ-28 | M'sila | ar | conventional names | ||
DZ,DZ-29 | DZ | DZ-29 | Mascara | ar | conventional names | ||
DZ,DZ-30 | DZ | DZ-30 | Ouargla | ar | conventional names | ||
DZ,DZ-31 | DZ | DZ-31 | Oran | ar | conventional names | ||
DZ,DZ-32 | DZ | DZ-32 | El Bayadh | ar | conventional names | ||
DZ,DZ-33 | DZ | DZ-33 | Illizi | ar | conventional names | ||
DZ,DZ-34 | DZ | DZ-34 | Bordj Bou Arréridj | ar | conventional names | ||
DZ,DZ-35 | DZ | DZ-35 | Boumerdès | ar | conventional names | ||
DZ,DZ-36 | DZ | DZ-36 | El Tarf | ar | conventional names | ||
DZ,DZ-37 | DZ | DZ-37 | Tindouf | ar | conventional names | ||
DZ,DZ-38 | DZ | DZ-38 | Tissemsilt | ar | conventional names | ||
DZ,DZ-39 | DZ | DZ-39 | El Oued | ar | conventional names | ||
DZ,DZ-40 | DZ | DZ-40 | Khenchela | ar | conventional names | ||
DZ,DZ-41 | DZ | DZ-41 | Souk Ahras | ar | conventional names | ||
DZ,DZ-42 | DZ | DZ-42 | Tipaza | ar | conventional names | ||
DZ,DZ-43 | DZ | DZ-43 | Mila | ar | conventional names | ||
DZ,DZ-44 | DZ | DZ-44 | Aïn Defla | ar | conventional names | ||
DZ,DZ-45 | DZ | DZ-45 | Naama | ar | conventional names | ||
DZ,DZ-46 | DZ | DZ-46 | Aïn Témouchent | ar | conventional names | ||
DZ,DZ-47 | DZ | DZ-47 | Ghardaïa | ar | conventional names | ||
DZ,DZ-48 | DZ | DZ-48 | Relizane | ar | conventional names |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );