subdivisions

Data source: ISO

98 rows where country_code = "PH"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: language_code, parent_subdivision

Link country_code code_31662 name local_variant language_code romanization_system parent_subdivision
PH,PH-00* PH PH-00* Pambansang Punong Rehiyon   tl    
PH,PH-01* PH PH-01* Rehiyon ng Iloko   tl    
PH,PH-02* PH PH-02* Rehiyon ng Lambak ng Kagayan   tl    
PH,PH-03* PH PH-03* Rehiyon ng Gitnang Luson   tl    
PH,PH-05* PH PH-05* Rehiyon ng Bikol   tl    
PH,PH-06* PH PH-06* Western Visayas (Region VI)   en    
PH,PH-07* PH PH-07* Rehiyon ng Gitnang Bisaya   tl    
PH,PH-08* PH PH-08* Rehiyon ng Silangang Bisaya   tl    
PH,PH-09* PH PH-09* Zamboanga Peninsula (Region IX)   en    
PH,PH-10* PH PH-10* Rehiyon ng Hilagang Mindanaw   tl    
PH,PH-11* PH PH-11* Rehiyon ng Dabaw   tl    
PH,PH-12* PH PH-12* Soccsksargen (Region XII)   en    
PH,PH-13* PH PH-13* Rehiyon ng Karaga   tl    
PH,PH-14* PH PH-14* Nagsasariling Rehiyon ng Muslim sa Mindanaw   tl    
PH,PH-15* PH PH-15* Rehiyon ng Administratibo ng Kordilyera   tl    
PH,PH-40* PH PH-40* Rehiyon ng Calabarzon   tl    
PH,PH-41* PH PH-41* Rehiyon ng Mimaropa   tl    
PH,PH-ABR* PH PH-ABR* Abra   tl   PH-15
PH,PH-AGN* PH PH-AGN* Hilagang Agusan   tl   PH-13
PH,PH-AGS* PH PH-AGS* Timog Agusan   tl   PH-13
PH,PH-AKL* PH PH-AKL* Aklan   tl   PH-06
PH,PH-ALB* PH PH-ALB* Albay   tl   PH-05
PH,PH-ANT* PH PH-ANT* Antique   en   PH-06
PH,PH-APA* PH PH-APA* Apayaw   tl   PH-15
PH,PH-AUR* PH PH-AUR* Aurora   tl   PH-03
PH,PH-BAN* PH PH-BAN* Bataan   tl   PH-03
PH,PH-BAS* PH PH-BAS* Basilan   tl   PH-09
PH,PH-BEN* PH PH-BEN* Benguet   en   PH-15
PH,PH-BIL* PH PH-BIL* Biliran   tl   PH-08
PH,PH-BOH* PH PH-BOH* Bohol   tl   PH-07
PH,PH-BTG* PH PH-BTG* Batangas   tl   PH-40
PH,PH-BTN* PH PH-BTN* Batanes   tl   PH-02
PH,PH-BUK* PH PH-BUK* Bukidnon   tl   PH-10
PH,PH-BUL* PH PH-BUL* Bulakan   tl   PH-03
PH,PH-CAG* PH PH-CAG* Kagayan   tl   PH-02
PH,PH-CAM* PH PH-CAM* Kamigin   tl   PH-10
PH,PH-CAN* PH PH-CAN* Hilagang Kamarines   tl   PH-05
PH,PH-CAP* PH PH-CAP* Kapis   tl   PH-06
PH,PH-CAS* PH PH-CAS* Timog Kamarines   tl   PH-05
PH,PH-CAT* PH PH-CAT* Katanduwanes   tl   PH-05
PH,PH-CAV* PH PH-CAV* Kabite   tl   PH-40
PH,PH-CEB* PH PH-CEB* Sebu   tl   PH-07
PH,PH-COM PH PH-COM Davao de Oro   en   PH-11
PH,PH-DAO* PH PH-DAO* Silangang Dabaw   tl   PH-11
PH,PH-DAS* PH PH-DAS* Timog Dabaw   tl   PH-11
PH,PH-DAV* PH PH-DAV* Hilagang Dabaw   tl   PH-11
PH,PH-DIN* PH PH-DIN* Pulo ng Dinagat   tl   PH-13
PH,PH-DVO* PH PH-DVO* Kanlurang Dabaw   tl   PH-11
PH,PH-EAS* PH PH-EAS* Silangang Samar   tl   PH-08
PH,PH-GUI* PH PH-GUI* Guimaras   en   PH-06
PH,PH-IFU* PH PH-IFU* Ipugaw   tl   PH-15
PH,PH-ILI* PH PH-ILI* Iloilo   tl   PH-06
PH,PH-ILN* PH PH-ILN* Ilocos Norte   en   PH-01
PH,PH-ILS* PH PH-ILS* Timog Iloko   tl   PH-01
PH,PH-ISA* PH PH-ISA* Isabela   tl   PH-02
PH,PH-KAL* PH PH-KAL* Kalinga   tl   PH-15
PH,PH-LAG* PH PH-LAG* Laguna   tl   PH-40
PH,PH-LAN* PH PH-LAN* Lanao del Norte   en   PH-12
PH,PH-LAS* PH PH-LAS* Timog Lanaw   tl   PH-14
PH,PH-LEY* PH PH-LEY* Leyte   tl   PH-08
PH,PH-LUN* PH PH-LUN* La Unyon   tl   PH-01
PH,PH-MAD* PH PH-MAD* Marinduque   en   PH-41
PH,PH-MAG* PH PH-MAG* Maguindanao   en   PH-14
PH,PH-MAS* PH PH-MAS* Masbate   tl   PH-05
PH,PH-MDC* PH PH-MDC* Mindoro Occidental   en   PH-41
PH,PH-MDR* PH PH-MDR* Silangang Mindoro   tl   PH-41
PH,PH-MOU* PH PH-MOU* Mountain Province   en   PH-15
PH,PH-MSC* PH PH-MSC* Misamis Occidental   en   PH-10
PH,PH-MSR* PH PH-MSR* Silangang Misamis   tl   PH-10
PH,PH-NCO* PH PH-NCO* Kotabato   tl   PH-12
PH,PH-NEC* PH PH-NEC* Negros Occidental   en   PH-06
PH,PH-NER* PH PH-NER* Silangang Negros   tl   PH-07
PH,PH-NSA* PH PH-NSA* Northern Samar   en   PH-08
PH,PH-NUE* PH PH-NUE* Nuweva Esiha   tl   PH-03
PH,PH-NUV* PH PH-NUV* Nuweva Biskaya   tl   PH-02
PH,PH-PAM* PH PH-PAM* Pampanga   tl   PH-03
PH,PH-PAN* PH PH-PAN* Pangasinan   tl   PH-01
PH,PH-PLW* PH PH-PLW* Palawan   tl   PH-41
PH,PH-QUE* PH PH-QUE* Quezon   en   PH-40
PH,PH-QUI* PH PH-QUI* Quirino   en   PH-02
PH,PH-RIZ* PH PH-RIZ* Rizal   en   PH-40
PH,PH-ROM* PH PH-ROM* Romblon   tl   PH-41
PH,PH-SAR* PH PH-SAR* Sarangani   tl   PH-11
PH,PH-SCO* PH PH-SCO* Timog Kotabato   tl   PH-11
PH,PH-SIG* PH PH-SIG* Siquijor   en   PH-07
PH,PH-SLE* PH PH-SLE* Southern Leyte   en   PH-08
PH,PH-SLU* PH PH-SLU* Sulu   tl   PH-14
PH,PH-SOR* PH PH-SOR* Sorsogon   tl   PH-05
PH,PH-SUK* PH PH-SUK* Sultan Kudarat   tl   PH-12
PH,PH-SUN* PH PH-SUN* Surigao del Norte   en   PH-13
PH,PH-SUR* PH PH-SUR* Timog Surigaw   tl   PH-13
PH,PH-TAR* PH PH-TAR* Tarlak   tl   PH-03
PH,PH-TAW* PH PH-TAW* Tawi-Tawi   tl   PH-14
PH,PH-WSA* PH PH-WSA* Samar   tl   PH-08
PH,PH-ZAN* PH PH-ZAN* Zamboanga del Norte   en   PH-09
PH,PH-ZAS* PH PH-ZAS* Zamboanga del Sur   en   PH-09
PH,PH-ZMB* PH PH-ZMB* Zambales   en   PH-03
PH,PH-ZSI* PH PH-ZSI* Zamboanga Sibugay   en   PH-09

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