Philippines - Formatting standards & code snippets
Here is a complete list of standards and formats used in Philippines. It includes a full list of ISO codes, number, date, currency, telephone and address formats. You will also get code examples on how to perform the most common formatting operations in Java, C#, JavaScript and PHP. Multiple resource files are made available, mainly the complete list of states, in different formats such as CSV, XML, JSON, HTML and SQL.
What are the ISO-3166-1 codes for Philippines?
- Alpha-2: PH
- Alpha-3: PHL
- Numeric: 608
- Java Locale Code: en_PH, fil_PH
- .Net CultureInfo Code: en-PH, fil-PH
- PHP Locale Code: en_PH, fil_PH
What is the official language in Philippines?
- Filipino and English
What is the date format in Philippines?
The date format in Philippines is middle-endian for Filipino and little-endian for English
- Format - English: dd/MM/yyyy
Ex: 03/12/2014 for December 3rd 2014 - Format - Filipino: M/d/yyyy
Ex: 12/3/2014 for December 3rd 2014
Formatting a date in Java:
// English
Locale locale = new Locale("en", "PH");
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy", locale);
sdf.format(new Date());
// Filipino
Locale locale = new Locale("fil", "PH");
SimpleDateFormat sdf = new SimpleDateFormat("M/d/yyyy", locale);
sdf.format(new Date());
Formatting a date in C#:
// English
CultureInfo ci = CultureInfo.GetCultureInfo("en-PH");
DateTime.Now.ToString("dd/MM/yyyy", ci);
// Filipino
CultureInfo ci = CultureInfo.GetCultureInfo("fil-PH");
DateTime.Now.ToString("M/d/yyyy", ci);
Formatting a date in JavaScript:
let date = new Date();
date.toLocaleDateString('en-PH'); // or fil-PH
Formatting a date in PHP:
// English
date("d/m/Y");
// Filipino
date("n/j/Y");
What is the time format in Philippines?
The time format in Philippines is mostly 12-hour notation, but 24-hour format is also commonly adopted.
- Format: h:mm[:ss] a.m.|p.m.
Ex: 9:00 a.m. for 09:00AM, and 9:00 p.m. for 09:00PM
Formatting time in Java:
Locale locale = new Locale("en", "PH");
SimpleDateFormat sdf = new SimpleDateFormat("h:mm:ss a", locale);
sdf.format(new Date());
Formatting time in C#:
CultureInfo ci = CultureInfo.GetCultureInfo("en-PH");
DateTime.Now.ToString("h:mm:ss tt", ci);
Formatting time in JavaScript:
let time = new Date();
date.toLocaleTimeString('en-PH', {hour12: true});
Formatting time in PHP:
date("g:i:s a");
What is the numeric format in Philippines?
- Format: 999,999,999.99
- Group Size: 3
- Grouping Character: , (comma)
- Decimal Character: . (dot)
Formatting numbers in Java:
Locale locale = new Locale("en", "PH");
NumberFormat numberFormat = NumberFormat.getNumberInstance(locale);
numberFormat.format(999999999.99d);
Formatting numbers in C#:
double d = 999999999.99d;
d.ToString("n", CultureInfo.GetCultureInfo("en-PH")));
Formatting numbers in JavaScript:
let number = 999999999.99;
number.toLocaleString('en-PH');
Formatting numbers in PHP:
$fmt = new NumberFormatter($locale = 'en_PH', NumberFormatter::DECIMAL); // or en_PK
$fmt->format(999999999.99);
What is the currency format in Philippines?
- Format: ₱999,999,999.99
- Group Size: 3
- Grouping Character: , (comma)
- Decimal Character: . (dot)
- Currency Symbol: ₱
- Currency Symbol Position: Before number
- Currency Name: Philippines Piso (PHP)
Formatting currency in Java:
Locale locale = new Locale("en", "PH");
NumberFormat numberFormat = NumberFormat.getCurrencyInstance(locale);
numberFormat.format(999999999.99d);
Formatting currency in C#:
double d = 999999999.99d;
d.ToString("c", CultureInfo.GetCultureInfo("en-PH")));
Formatting currency in JavaScript:
let number = 999999999.99;
number.toLocaleString('en-PH', {currency: 'PHP', style: 'currency'});
Formatting currency in PHP:
$fmt = new NumberFormatter($locale = 'en_PH', NumberFormatter::CURRENCY); // or en_PK
$fmt->format(999999999.99);
Download list of provinces for Philippines in CSV, JSON, HTML, SQL and XML
List of provinces: HTML - Select Control
--------------------------
ISO_3166-2 code + name
------------------------
<select>
<option value="PH-ABR">Abra</option>
<option value="PH-AGN">Agusan del Norte</option>
<option value="PH-AGS">Agusan del Sur</option>
<option value="PH-AKL">Aklan</option>
<option value="PH-ALB">Albay</option>
<option value="PH-ANT">Antique</option>
<option value="PH-APA">Apayao</option>
<option value="PH-AUR">Aurora</option>
<option value="PH-BAS">Basilan</option>
<option value="PH-BAN">Bataan</option>
<option value="PH-BTN">Batanes</option>
<option value="PH-BTG">Batangas</option>
<option value="PH-BEN">Benguet</option>
<option value="PH-BIL">Biliran</option>
<option value="PH-BOH">Bohol</option>
<option value="PH-BUK">Bukidnon</option>
<option value="PH-BUL">Bulacan</option>
<option value="PH-CAG">Cagayan</option>
<option value="PH-CAN">Camarines Norte</option>
<option value="PH-CAS">Camarines Sur</option>
<option value="PH-CAM">Camiguin</option>
<option value="PH-CAP">Capiz</option>
<option value="PH-CAT">Catanduanes</option>
<option value="PH-CAV">Cavite</option>
<option value="PH-CEB">Cebu</option>
<option value="PH-COM">Compostela Valley</option>
<option value="PH-NCO">Cotabato</option>
<option value="PH-DAV">Davao del Norte</option>
<option value="PH-DAS">Davao del Sur</option>
<option value="PH-DVO">Davao Occidental</option>
<option value="PH-DAO">Davao Oriental</option>
<option value="PH-DIN">Dinagat Islands</option>
<option value="PH-EAS">Eastern Samar</option>
<option value="PH-GUI">Guimaras</option>
<option value="PH-IFU">Ifugao</option>
<option value="PH-ILN">Ilocos Norte</option>
<option value="PH-ILS">Ilocos Sur</option>
<option value="PH-ILI">Iloilo</option>
<option value="PH-ISA">Isabela</option>
<option value="PH-KAL">Kalinga</option>
<option value="PH-LUN">La Union</option>
<option value="PH-LAG">Laguna</option>
<option value="PH-LAN">Lanao del Norte</option>
<option value="PH-LAS">Lanao del Sur</option>
<option value="PH-LEY">Leyte</option>
<option value="PH-MAG">Maguindanao</option>
<option value="PH-MAD">Marinduque</option>
<option value="PH-MAS">Masbate</option>
<option value="PH-MDC">Mindoro Occidental</option>
<option value="PH-MDR">Mindoro Oriental</option>
<option value="PH-MSC">Misamis Occidental</option>
<option value="PH-MSR">Misamis Oriental</option>
<option value="PH-MOU">Mountain Province</option>
<option value="PH-NEC">Negros Occidental</option>
<option value="PH-NER">Negros Oriental</option>
<option value="PH-NSA">Northern Samar</option>
<option value="PH-NUE">Nueva Ecija</option>
<option value="PH-NUV">Nueva Vizcaya</option>
<option value="PH-PLW">Palawan</option>
<option value="PH-PAM">Pampanga</option>
<option value="PH-PAN">Pangasinan</option>
<option value="PH-QUE">Quezon</option>
<option value="PH-QUI">Quirino</option>
<option value="PH-RIZ">Rizal</option>
<option value="PH-ROM">Romblon</option>
<option value="PH-WSA">Samar (Western Samar)</option>
<option value="PH-SAR">Sarangani</option>
<option value="PH-SIG">Siquijor</option>
<option value="PH-SOR">Sorsogon</option>
<option value="PH-SCO">South Cotabato</option>
<option value="PH-SLE">Southern Leyte</option>
<option value="PH-SUK">Sultan Kudarat</option>
<option value="PH-SLU">Sulu</option>
<option value="PH-SUN">Surigao del Norte</option>
<option value="PH-SUR">Surigao del Sur</option>
<option value="PH-TAR">Tarlac</option>
<option value="PH-TAW">Tawi-Tawi</option>
<option value="PH-ZMB">Zambales</option>
<option value="PH-ZAN">Zamboanga del Norte</option>
<option value="PH-ZAS">Zamboanga del Sur</option>
<option value="PH-ZSI">Zamboanga Sibugay</option>
</select>
List of provinces: CSV
code,name
PH-ABR,"Abra"
PH-AGN,"Agusan del Norte"
PH-AGS,"Agusan del Sur"
PH-AKL,"Aklan"
PH-ALB,"Albay"
PH-ANT,"Antique"
PH-APA,"Apayao"
PH-AUR,"Aurora"
PH-BAS,"Basilan"
PH-BAN,"Bataan"
PH-BTN,"Batanes"
PH-BTG,"Batangas"
PH-BEN,"Benguet"
PH-BIL,"Biliran"
PH-BOH,"Bohol"
PH-BUK,"Bukidnon"
PH-BUL,"Bulacan"
PH-CAG,"Cagayan"
PH-CAN,"Camarines Norte"
PH-CAS,"Camarines Sur"
PH-CAM,"Camiguin"
PH-CAP,"Capiz"
PH-CAT,"Catanduanes"
PH-CAV,"Cavite"
PH-CEB,"Cebu"
PH-COM,"Compostela Valley"
PH-NCO,"Cotabato"
PH-DAV,"Davao del Norte"
PH-DAS,"Davao del Sur"
PH-DVO,"Davao Occidental"
PH-DAO,"Davao Oriental"
PH-DIN,"Dinagat Islands"
PH-EAS,"Eastern Samar"
PH-GUI,"Guimaras"
PH-IFU,"Ifugao"
PH-ILN,"Ilocos Norte"
PH-ILS,"Ilocos Sur"
PH-ILI,"Iloilo"
PH-ISA,"Isabela"
PH-KAL,"Kalinga"
PH-LUN,"La Union"
PH-LAG,"Laguna"
PH-LAN,"Lanao del Norte"
PH-LAS,"Lanao del Sur"
PH-LEY,"Leyte"
PH-MAG,"Maguindanao"
PH-MAD,"Marinduque"
PH-MAS,"Masbate"
PH-MDC,"Mindoro Occidental"
PH-MDR,"Mindoro Oriental"
PH-MSC,"Misamis Occidental"
PH-MSR,"Misamis Oriental"
PH-MOU,"Mountain Province"
PH-NEC,"Negros Occidental"
PH-NER,"Negros Oriental"
PH-NSA,"Northern Samar"
PH-NUE,"Nueva Ecija"
PH-NUV,"Nueva Vizcaya"
PH-PLW,"Palawan"
PH-PAM,"Pampanga"
PH-PAN,"Pangasinan"
PH-QUE,"Quezon"
PH-QUI,"Quirino"
PH-RIZ,"Rizal"
PH-ROM,"Romblon"
PH-WSA,"Samar (Western Samar)"
PH-SAR,"Sarangani"
PH-SIG,"Siquijor"
PH-SOR,"Sorsogon"
PH-SCO,"South Cotabato"
PH-SLE,"Southern Leyte"
PH-SUK,"Sultan Kudarat"
PH-SLU,"Sulu"
PH-SUN,"Surigao del Norte"
PH-SUR,"Surigao del Sur"
PH-TAR,"Tarlac"
PH-TAW,"Tawi-Tawi"
PH-ZMB,"Zambales"
PH-ZAN,"Zamboanga del Norte"
PH-ZAS,"Zamboanga del Sur"
PH-ZSI,"Zamboanga Sibugay"
List of provinces: JSON
------------------------
ISO-3166-2 code + Name
------------------------
[
{code: "PH-ABR", name: "Abra"},
{code: "PH-AGN", name: "Agusan del Norte"},
{code: "PH-AGS", name: "Agusan del Sur"},
{code: "PH-AKL", name: "Aklan"},
{code: "PH-ALB", name: "Albay"},
{code: "PH-ANT", name: "Antique"},
{code: "PH-APA", name: "Apayao"},
{code: "PH-AUR", name: "Aurora"},
{code: "PH-BAS", name: "Basilan"},
{code: "PH-BAN", name: "Bataan"},
{code: "PH-BTN", name: "Batanes"},
{code: "PH-BTG", name: "Batangas"},
{code: "PH-BEN", name: "Benguet"},
{code: "PH-BIL", name: "Biliran"},
{code: "PH-BOH", name: "Bohol"},
{code: "PH-BUK", name: "Bukidnon"},
{code: "PH-BUL", name: "Bulacan"},
{code: "PH-CAG", name: "Cagayan"},
{code: "PH-CAN", name: "Camarines Norte"},
{code: "PH-CAS", name: "Camarines Sur"},
{code: "PH-CAM", name: "Camiguin"},
{code: "PH-CAP", name: "Capiz"},
{code: "PH-CAT", name: "Catanduanes"},
{code: "PH-CAV", name: "Cavite"},
{code: "PH-CEB", name: "Cebu"},
{code: "PH-COM", name: "Compostela Valley"},
{code: "PH-NCO", name: "Cotabato"},
{code: "PH-DAV", name: "Davao del Norte"},
{code: "PH-DAS", name: "Davao del Sur"},
{code: "PH-DVO", name: "Davao Occidental"},
{code: "PH-DAO", name: "Davao Oriental"},
{code: "PH-DIN", name: "Dinagat Islands"},
{code: "PH-EAS", name: "Eastern Samar"},
{code: "PH-GUI", name: "Guimaras"},
{code: "PH-IFU", name: "Ifugao"},
{code: "PH-ILN", name: "Ilocos Norte"},
{code: "PH-ILS", name: "Ilocos Sur"},
{code: "PH-ILI", name: "Iloilo"},
{code: "PH-ISA", name: "Isabela"},
{code: "PH-KAL", name: "Kalinga"},
{code: "PH-LUN", name: "La Union"},
{code: "PH-LAG", name: "Laguna"},
{code: "PH-LAN", name: "Lanao del Norte"},
{code: "PH-LAS", name: "Lanao del Sur"},
{code: "PH-LEY", name: "Leyte"},
{code: "PH-MAG", name: "Maguindanao"},
{code: "PH-MAD", name: "Marinduque"},
{code: "PH-MAS", name: "Masbate"},
{code: "PH-MDC", name: "Mindoro Occidental"},
{code: "PH-MDR", name: "Mindoro Oriental"},
{code: "PH-MSC", name: "Misamis Occidental"},
{code: "PH-MSR", name: "Misamis Oriental"},
{code: "PH-MOU", name: "Mountain Province"},
{code: "PH-NEC", name: "Negros Occidental"},
{code: "PH-NER", name: "Negros Oriental"},
{code: "PH-NSA", name: "Northern Samar"},
{code: "PH-NUE", name: "Nueva Ecija"},
{code: "PH-NUV", name: "Nueva Vizcaya"},
{code: "PH-PLW", name: "Palawan"},
{code: "PH-PAM", name: "Pampanga"},
{code: "PH-PAN", name: "Pangasinan"},
{code: "PH-QUE", name: "Quezon"},
{code: "PH-QUI", name: "Quirino"},
{code: "PH-RIZ", name: "Rizal"},
{code: "PH-ROM", name: "Romblon"},
{code: "PH-WSA", name: "Samar (Western Samar)"},
{code: "PH-SAR", name: "Sarangani"},
{code: "PH-SIG", name: "Siquijor"},
{code: "PH-SOR", name: "Sorsogon"},
{code: "PH-SCO", name: "South Cotabato"},
{code: "PH-SLE", name: "Southern Leyte"},
{code: "PH-SUK", name: "Sultan Kudarat"},
{code: "PH-SLU", name: "Sulu"},
{code: "PH-SUN", name: "Surigao del Norte"},
{code: "PH-SUR", name: "Surigao del Sur"},
{code: "PH-TAR", name: "Tarlac"},
{code: "PH-TAW", name: "Tawi-Tawi"},
{code: "PH-ZMB", name: "Zambales"},
{code: "PH-ZAN", name: "Zamboanga del Norte"},
{code: "PH-ZAS", name: "Zamboanga del Sur"},
{code: "PH-ZSI", name: "Zamboanga Sibugay"}
]
List of provinces: SQL
-- -----------------------------------------------------
-- Table `province`
-- -----------------------------------------------------
DROP TABLE IF EXISTS province;
CREATE TABLE IF NOT EXISTS province (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
code VARCHAR(6) NOT NULL,
name VARCHAR(50) NOT NULL,
PRIMARY KEY (id),
UNIQUE INDEX id_UNIQUE (id ASC),
UNIQUE INDEX code_UNIQUE (code ASC)
) ENGINE = InnoDB;
INSERT INTO province (id, code, name) VALUES (null, 'PH-ABR', 'Abra');
INSERT INTO province (id, code, name) VALUES (null, 'PH-AGN', 'Agusan del Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-AGS', 'Agusan del Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-AKL', 'Aklan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ALB', 'Albay');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ANT', 'Antique');
INSERT INTO province (id, code, name) VALUES (null, 'PH-APA', 'Apayao');
INSERT INTO province (id, code, name) VALUES (null, 'PH-AUR', 'Aurora');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BAS', 'Basilan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BAN', 'Bataan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BTN', 'Batanes');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BTG', 'Batangas');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BEN', 'Benguet');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BIL', 'Biliran');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BOH', 'Bohol');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BUK', 'Bukidnon');
INSERT INTO province (id, code, name) VALUES (null, 'PH-BUL', 'Bulacan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAG', 'Cagayan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAN', 'Camarines Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAS', 'Camarines Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAM', 'Camiguin');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAP', 'Capiz');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAT', 'Catanduanes');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CAV', 'Cavite');
INSERT INTO province (id, code, name) VALUES (null, 'PH-CEB', 'Cebu');
INSERT INTO province (id, code, name) VALUES (null, 'PH-COM', 'Compostela Valley');
INSERT INTO province (id, code, name) VALUES (null, 'PH-NCO', 'Cotabato');
INSERT INTO province (id, code, name) VALUES (null, 'PH-DAV', 'Davao del Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-DAS', 'Davao del Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-DVO', 'Davao Occidental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-DAO', 'Davao Oriental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-DIN', 'Dinagat Islands');
INSERT INTO province (id, code, name) VALUES (null, 'PH-EAS', 'Eastern Samar');
INSERT INTO province (id, code, name) VALUES (null, 'PH-GUI', 'Guimaras');
INSERT INTO province (id, code, name) VALUES (null, 'PH-IFU', 'Ifugao');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ILN', 'Ilocos Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ILS', 'Ilocos Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ILI', 'Iloilo');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ISA', 'Isabela');
INSERT INTO province (id, code, name) VALUES (null, 'PH-KAL', 'Kalinga');
INSERT INTO province (id, code, name) VALUES (null, 'PH-LUN', 'La Union');
INSERT INTO province (id, code, name) VALUES (null, 'PH-LAG', 'Laguna');
INSERT INTO province (id, code, name) VALUES (null, 'PH-LAN', 'Lanao del Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-LAS', 'Lanao del Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-LEY', 'Leyte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MAG', 'Maguindanao');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MAD', 'Marinduque');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MAS', 'Masbate');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MDC', 'Mindoro Occidental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MDR', 'Mindoro Oriental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MSC', 'Misamis Occidental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MSR', 'Misamis Oriental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-MOU', 'Mountain Province');
INSERT INTO province (id, code, name) VALUES (null, 'PH-NEC', 'Negros Occidental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-NER', 'Negros Oriental');
INSERT INTO province (id, code, name) VALUES (null, 'PH-NSA', 'Northern Samar');
INSERT INTO province (id, code, name) VALUES (null, 'PH-NUE', 'Nueva Ecija');
INSERT INTO province (id, code, name) VALUES (null, 'PH-NUV', 'Nueva Vizcaya');
INSERT INTO province (id, code, name) VALUES (null, 'PH-PLW', 'Palawan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-PAM', 'Pampanga');
INSERT INTO province (id, code, name) VALUES (null, 'PH-PAN', 'Pangasinan');
INSERT INTO province (id, code, name) VALUES (null, 'PH-QUE', 'Quezon');
INSERT INTO province (id, code, name) VALUES (null, 'PH-QUI', 'Quirino');
INSERT INTO province (id, code, name) VALUES (null, 'PH-RIZ', 'Rizal');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ROM', 'Romblon');
INSERT INTO province (id, code, name) VALUES (null, 'PH-WSA', 'Samar (Western Samar)');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SAR', 'Sarangani');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SIG', 'Siquijor');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SOR', 'Sorsogon');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SCO', 'South Cotabato');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SLE', 'Southern Leyte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SUK', 'Sultan Kudarat');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SLU', 'Sulu');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SUN', 'Surigao del Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-SUR', 'Surigao del Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-TAR', 'Tarlac');
INSERT INTO province (id, code, name) VALUES (null, 'PH-TAW', 'Tawi-Tawi');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ZMB', 'Zambales');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ZAN', 'Zamboanga del Norte');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ZAS', 'Zamboanga del Sur');
INSERT INTO province (id, code, name) VALUES (null, 'PH-ZSI', 'Zamboanga Sibugay');
List of provinces: XML
<!-- ISO 3166-2 code + name -->
<?xml version="1.0" encoding="UTF-8"?>
<provinces>
<province>
<code>PH-ABR</code>
<name>Abra</name>
</province>
<province>
<code>PH-AGN</code>
<name>Agusan del Norte</name>
</province>
<province>
<code>PH-AGS</code>
<name>Agusan del Sur</name>
</province>
<province>
<code>PH-AKL</code>
<name>Aklan</name>
</province>
<province>
<code>PH-ALB</code>
<name>Albay</name>
</province>
<province>
<code>PH-ANT</code>
<name>Antique</name>
</province>
<province>
<code>PH-APA</code>
<name>Apayao</name>
</province>
<province>
<code>PH-AUR</code>
<name>Aurora</name>
</province>
<province>
<code>PH-BAS</code>
<name>Basilan</name>
</province>
<province>
<code>PH-BAN</code>
<name>Bataan</name>
</province>
<province>
<code>PH-BTN</code>
<name>Batanes</name>
</province>
<province>
<code>PH-BTG</code>
<name>Batangas</name>
</province>
<province>
<code>PH-BEN</code>
<name>Benguet</name>
</province>
<province>
<code>PH-BIL</code>
<name>Biliran</name>
</province>
<province>
<code>PH-BOH</code>
<name>Bohol</name>
</province>
<province>
<code>PH-BUK</code>
<name>Bukidnon</name>
</province>
<province>
<code>PH-BUL</code>
<name>Bulacan</name>
</province>
<province>
<code>PH-CAG</code>
<name>Cagayan</name>
</province>
<province>
<code>PH-CAN</code>
<name>Camarines Norte</name>
</province>
<province>
<code>PH-CAS</code>
<name>Camarines Sur</name>
</province>
<province>
<code>PH-CAM</code>
<name>Camiguin</name>
</province>
<province>
<code>PH-CAP</code>
<name>Capiz</name>
</province>
<province>
<code>PH-CAT</code>
<name>Catanduanes</name>
</province>
<province>
<code>PH-CAV</code>
<name>Cavite</name>
</province>
<province>
<code>PH-CEB</code>
<name>Cebu</name>
</province>
<province>
<code>PH-COM</code>
<name>Compostela Valley</name>
</province>
<province>
<code>PH-NCO</code>
<name>Cotabato</name>
</province>
<province>
<code>PH-DAV</code>
<name>Davao del Norte</name>
</province>
<province>
<code>PH-DAS</code>
<name>Davao del Sur</name>
</province>
<province>
<code>PH-DVO</code>
<name>Davao Occidental</name>
</province>
<province>
<code>PH-DAO</code>
<name>Davao Oriental</name>
</province>
<province>
<code>PH-DIN</code>
<name>Dinagat Islands</name>
</province>
<province>
<code>PH-EAS</code>
<name>Eastern Samar</name>
</province>
<province>
<code>PH-GUI</code>
<name>Guimaras</name>
</province>
<province>
<code>PH-IFU</code>
<name>Ifugao</name>
</province>
<province>
<code>PH-ILN</code>
<name>Ilocos Norte</name>
</province>
<province>
<code>PH-ILS</code>
<name>Ilocos Sur</name>
</province>
<province>
<code>PH-ILI</code>
<name>Iloilo</name>
</province>
<province>
<code>PH-ISA</code>
<name>Isabela</name>
</province>
<province>
<code>PH-KAL</code>
<name>Kalinga</name>
</province>
<province>
<code>PH-LUN</code>
<name>La Union</name>
</province>
<province>
<code>PH-LAG</code>
<name>Laguna</name>
</province>
<province>
<code>PH-LAN</code>
<name>Lanao del Norte</name>
</province>
<province>
<code>PH-LAS</code>
<name>Lanao del Sur</name>
</province>
<province>
<code>PH-LEY</code>
<name>Leyte</name>
</province>
<province>
<code>PH-MAG</code>
<name>Maguindanao</name>
</province>
<province>
<code>PH-MAD</code>
<name>Marinduque</name>
</province>
<province>
<code>PH-MAS</code>
<name>Masbate</name>
</province>
<province>
<code>PH-MDC</code>
<name>Mindoro Occidental</name>
</province>
<province>
<code>PH-MDR</code>
<name>Mindoro Oriental</name>
</province>
<province>
<code>PH-MSC</code>
<name>Misamis Occidental</name>
</province>
<province>
<code>PH-MSR</code>
<name>Misamis Oriental</name>
</province>
<province>
<code>PH-MOU</code>
<name>Mountain Province</name>
</province>
<province>
<code>PH-NEC</code>
<name>Negros Occidental</name>
</province>
<province>
<code>PH-NER</code>
<name>Negros Oriental</name>
</province>
<province>
<code>PH-NSA</code>
<name>Northern Samar</name>
</province>
<province>
<code>PH-NUE</code>
<name>Nueva Ecija</name>
</province>
<province>
<code>PH-NUV</code>
<name>Nueva Vizcaya</name>
</province>
<province>
<code>PH-PLW</code>
<name>Palawan</name>
</province>
<province>
<code>PH-PAM</code>
<name>Pampanga</name>
</province>
<province>
<code>PH-PAN</code>
<name>Pangasinan</name>
</province>
<province>
<code>PH-QUE</code>
<name>Quezon</name>
</province>
<province>
<code>PH-QUI</code>
<name>Quirino</name>
</province>
<province>
<code>PH-RIZ</code>
<name>Rizal</name>
</province>
<province>
<code>PH-ROM</code>
<name>Romblon</name>
</province>
<province>
<code>PH-WSA</code>
<name>Samar (Western Samar)</name>
</province>
<province>
<code>PH-SAR</code>
<name>Sarangani</name>
</province>
<province>
<code>PH-SIG</code>
<name>Siquijor</name>
</province>
<province>
<code>PH-SOR</code>
<name>Sorsogon</name>
</province>
<province>
<code>PH-SCO</code>
<name>South Cotabato</name>
</province>
<province>
<code>PH-SLE</code>
<name>Southern Leyte</name>
</province>
<province>
<code>PH-SUK</code>
<name>Sultan Kudarat</name>
</province>
<province>
<code>PH-SLU</code>
<name>Sulu</name>
</province>
<province>
<code>PH-SUN</code>
<name>Surigao del Norte</name>
</province>
<province>
<code>PH-SUR</code>
<name>Surigao del Sur</name>
</province>
<province>
<code>PH-TAR</code>
<name>Tarlac</name>
</province>
<province>
<code>PH-TAW</code>
<name>Tawi-Tawi</name>
</province>
<province>
<code>PH-ZMB</code>
<name>Zambales</name>
</province>
<province>
<code>PH-ZAN</code>
<name>Zamboanga del Norte</name>
</province>
<province>
<code>PH-ZAS</code>
<name>Zamboanga del Sur</name>
</province>
<province>
<code>PH-ZSI</code>
<name>Zamboanga Sibugay</name>
</province>
</provinces>