
INSERT INTO `ref_provinces` (`id`, `psgcCode`, `provDesc`, `regCode`, `provCode`, `region_id`) VALUES
(1, '012800000', 'ILOCOS NORTE', 1, 128,null) ,
(2, '012900000', 'ILOCOS SUR', 1, 129,null) ,
(3, '013300000', 'LA UNION', 1, 133,null) ,
(4, '015500000', 'PANGASINAN', 1, 155,null) ,
(5, '020900000', 'BATANES', 2, 209,null) ,
(6, '021500000', 'CAGAYAN', 2, 215,null) ,
(7, '023100000', 'ISABELA', 2, 231,null) ,
(8, '025000000', 'NUEVA VIZCAYA', 2, 250,null) ,
(9, '025700000', 'QUIRINO', 2, 257,null) ,
(10, '030800000', 'BATAAN', 3, 308,null) ,
(11, '031400000', 'BULACAN', 3, 314,null) ,
(12, '034900000', 'NUEVA ECIJA', 3, 349,null) ,
(13, '035400000', 'PAMPANGA', 3, 354,null) ,
(14, '036900000', 'TARLAC', 3, 369,null) ,
(15, '037100000', 'ZAMBALES', 3, 371,null) ,
(16, '037700000', 'AURORA', 3, 377,null) ,
(17, '041000000', 'BATANGAS', 4, 410,null) ,
(18, '042100000', 'CAVITE', 4, 421,null) ,
(19, '043400000', 'LAGUNA', 4, 434,null) ,
(20, '045600000', 'QUEZON', 4, 456,null) ,
(21, '045800000', 'RIZAL', 4, 458,null) ,
(22, '174000000', 'MARINDUQUE', 17, 1740,null) ,
(23, '175100000', 'OCCIDENTAL MINDORO', 17, 1751,null) ,
(24, '175200000', 'ORIENTAL MINDORO', 17, 1752,null) ,
(25, '175300000', 'PALAWAN', 17, 1753,null) ,
(26, '175900000', 'ROMBLON', 17, 1759,null) ,
(27, '050500000', 'ALBAY', 5, 505,null) ,
(28, '051600000', 'CAMARINES NORTE', 5, 516,null) ,
(29, '051700000', 'CAMARINES SUR', 5, 517,null) ,
(30, '052000000', 'CATANDUANES', 5, 520,null) ,
(31, '054100000', 'MASBATE', 5, 541,null) ,
(32, '056200000', 'SORSOGON', 5, 562,null) ,
(33, '060400000', 'AKLAN', 6, 604,null) ,
(34, '060600000', 'ANTIQUE', 6, 606,null) ,
(35, '061900000', 'CAPIZ', 6, 619,null) ,
(36, '063000000', 'ILOILO', 6, 630,null) ,
(37, '064500000', 'NEGROS OCCIDENTAL', 6, 645,null) ,
(38, '067900000', 'GUIMARAS', 6, 679,null) ,
(39, '071200000', 'BOHOL', 7, 712,null) ,
(40, '072200000', 'CEBU', 7, 722,null) ,
(41, '074600000', 'NEGROS ORIENTAL', 7, 746,null) ,
(42, '076100000', 'SIQUIJOR', 7, 761,null) ,
(43, '082600000', 'EASTERN SAMAR', 8, 826,null) ,
(44, '083700000', 'LEYTE', 8, 837,null) ,
(45, '084800000', 'NORTHERN SAMAR', 8, 848,null) ,
(46, '086000000', 'SAMAR (WESTERN SAMAR)', 8, 860,null) ,
(47, '086400000', 'SOUTHERN LEYTE', 8, 864,null) ,
(48, '087800000', 'BILIRAN', 8, 878,null) ,
(49, '097200000', 'ZAMBOANGA DEL NORTE', 9, 972,null) ,
(50, '097300000', 'ZAMBOANGA DEL SUR', 9, 973,null) ,
(51, '098300000', 'ZAMBOANGA SIBUGAY', 9, 983,null) ,
(52, '099700000', 'CITY OF ISABELA', 9, 997,null) ,
(53, '101300000', 'BUKIDNON', 10, 1013,null) ,
(54, '101800000', 'CAMIGUIN', 10, 1018,null) ,
(55, '103500000', 'LANAO DEL NORTE', 10, 1035,null) ,
(56, '104200000', 'MISAMIS OCCIDENTAL', 10, 1042,null) ,
(57, '104300000', 'MISAMIS ORIENTAL', 10, 1043,null) ,
(58, '112300000', 'DAVAO DEL NORTE', 11, 1123,null) ,
(59, '112400000', 'DAVAO DEL SUR', 11, 1124,null) ,
(60, '112500000', 'DAVAO ORIENTAL', 11, 1125,null) ,
(61, '118200000', 'COMPOSTELA VALLEY', 11, 1182,null) ,
(62, '118600000', 'DAVAO OCCIDENTAL', 11, 1186,null) ,
(63, '124700000', 'COTABATO (NORTH COTABATO)', 12, 1247,null) ,
(64, '126300000', 'SOUTH COTABATO', 12, 1263,null) ,
(65, '126500000', 'SULTAN KUDARAT', 12, 1265,null) ,
(66, '128000000', 'SARANGANI', 12, 1280,null) ,
(67, '129800000', 'COTABATO CITY', 12, 1298,null) ,
(68, '133900000', 'NCR, CITY OF MANILA, FIRST DISTRICT', 13, 1339,null) ,
(69, '133900000', 'CITY OF MANILA', 13, 1339,null) ,
(70, '137400000', 'NCR, SECOND DISTRICT', 13, 1374,null) ,
(71, '137500000', 'NCR, THIRD DISTRICT', 13, 1375,null) ,
(72, '137600000', 'NCR, FOURTH DISTRICT', 13, 1376,null) ,
(73, '140100000', 'ABRA', 14, 1401,null) ,
(74, '141100000', 'BENGUET', 14, 1411,null) ,
(75, '142700000', 'IFUGAO', 14, 1427,null) ,
(76, '143200000', 'KALINGA', 14, 1432,null) ,
(77, '144400000', 'MOUNTAIN PROVINCE', 14, 1444,null) ,
(78, '148100000', 'APAYAO', 14, 1481,null) ,
(79, '150700000', 'BASILAN', 15, 1507,null) ,
(80, '153600000', 'LANAO DEL SUR', 15, 1536,null) ,
(81, '153800000', 'MAGUINDANAO', 15, 1538,null) ,
(82, '156600000', 'SULU', 15, 1566,null) ,
(83, '157000000', 'TAWI-TAWI', 15, 1570,null) ,
(84, '160200000', 'AGUSAN DEL NORTE', 16, 1602,null) ,
(85, '160300000', 'AGUSAN DEL SUR', 16, 1603,null) ,
(86, '166700000', 'SURIGAO DEL NORTE', 16, 1667,null) ,
(87, '166800000', 'SURIGAO DEL SUR', 16, 1668,null) ,
(88, '168500000', 'DINAGAT ISLANDS', 16, 1685, null);