-
Notifications
You must be signed in to change notification settings - Fork 0
/
data-province.sql
126 lines (124 loc) · 4.78 KB
/
data-province.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
-- ------------------------------------
-- TABLE PROVINCE DATA
-- ------------------------------------
INSERT INTO `province` VALUES
(1,1,'012800000','Ilocos Norte'),
(2,1,'012900000','Ilocos Sur'),
(3,1,'013300000','La Union'),
(4,1,'015500000','Pangasinan'),
(5,2,'020900000','Batanes'),
(6,2,'021500000','Cagayan'),
(7,2,'023100000','Isabela'),
(8,2,'025000000','Nueva Vizcaya'),
(9,2,'025700000','Quirino'),
(10,3,'037700000','Aurora'),
(11,3,'030800000','Bataan'),
(12,3,'031400000','Bulacan'),
(13,3,'034900000','Nueva Ecija'),
(14,3,'035400000','Pampanga'),
(15,3,'035401000','Angeles City'),
(16,3,'036900000','Tarlac'),
(17,3,'037100000','Zambales'),
(18,3,'037107000','Olongapo City'),
(19,4,'041000000','Batangas'),
(20,4,'042100000','Cavite'),
(21,4,'043400000','Laguna'),
(22,4,'045600000','Quezon'),
(23,4,'045624000','Lucena City'),
(24,4,'045800000','Rizal'),
(25,5,'050500000','Albay'),
(26,5,'051600000','Camarines Norte'),
(27,5,'051700000','Camarines Sur'),
(28,5,'052000000','Catanduanes'),
(29,5,'054100000','Masbate'),
(30,5,'056200000','Sorsogon'),
(31,6,'060400000','Aklan'),
(32,6,'060600000','Antique'),
(33,6,'061900000','Capiz'),
(34,6,'064500000','Negros Occidental'),
(35,6,'064501000','Bacolod City (Capital)'),
(36,6,'067900000','Guimaras'),
(37,6,'063000000','Iloilo'),
(38,6,'063022000','Iloilo City (Capital)'),
(39,7,'071200000','Bohol'),
(40,7,'072200000','Cebu'),
(41,7,'072217000','Cebu City (Capital)'),
(42,7,'072226000','Lapu-lapu City (Opon)'),
(43,7,'072230000','Mandaue City'),
(44,7,'074600000','Negros Oriental'),
(45,7,'076100000','Siquijor'),
(46,8,'087800000','Biliran'),
(47,8,'082600000','Eastern Samar'),
(48,8,'083700000','Leyte'),
(49,8,'083747000','Tacloban City'),
(50,8,'084800000','Northern Samar'),
(51,8,'086400000','Southern Leyte'),
(52,8,'086000000','Samar (Western Samar)'),
(53,9,'097200000','Zamboanga del Norte'),
(54,9,'097300000','Zamboanga del Sur'),
(55,9,'097332000','Zamboanga City'),
(56,9,'098300000','Zamboanga Sibugay'),
(57,9,'099701000','City of Isabela'),
(58,10,'101300000','Bukidnon'),
(59,10,'101800000','Camiguin'),
(60,10,'103500000','Lanao del Norte'),
(61,10,'103504000','Iligan City'),
(62,10,'104200000','Misamis Occidental'),
(63,10,'104300000','Misamis Oriental'),
(64,10,'104305000','Cagayan de Oro City (Capital)'),
(65,11,'112300000','Davao del Norte'),
(66,11,'112400000','Davao del Sur'),
(67,11,'112402000','Davao City'),
(68,11,'112500000','Davao Oriental'),
(69,11,'118200000','Compostela Valley'),
(70,11,'118600000','Davao Occidental'),
(71,12,'124700000','North Cotabato'),
(72,12,'128000000','Sarangani'),
(73,12,'126300000','South Cotabato'),
(74,12,'126303000','General Santos City (Dadiangas)'),
(75,12,'126500000','Sultan Kudarat'),
(76,12,'129804000','Cotabato City'),
(77,13,'133900000','City of Manila'),
(78,13,'137401000','City of Mandaluyong'),
(79,13,'137402000','City of Marikina'),
(80,13,'137403000','City of Pasig'),
(81,13,'137404000','Quezon City'),
(82,13,'137405000','City of San Juan'),
(83,13,'137501000','Caloocan City'),
(84,13,'137502000','City of Malabon'),
(85,13,'137503000','City of Navotas'),
(86,13,'137504000','City of Valenzuela'),
(87,13,'137601000','City of Las Piñas'),
(88,13,'137602000','City of Makati'),
(89,13,'137603000','City of Muntinlupa'),
(90,13,'137604000','City of Parañaque'),
(91,13,'137605000','Pasay City'),
(92,13,'137606000','Pateros'),
(93,13,'137607000','Taguig City'),
(94,14,'140100000','Abra'),
(95,14,'148100000','Apayao'),
(96,14,'141100000','Benguet'),
(97,14,'141102000','Baguio City'),
(98,14,'142700000','Ifugao'),
(99,14,'143200000','Kalinga'),
(100,14,'144400000','Mountain Province'),
(101,15,'150700000','Basilan'),
(102,15,'153600000','Lanao del Sur'),
(103,15,'153800000','Maguindanao'),
(104,15,'156600000','Sulu'),
(105,15,'157000000','Tawi-tawi'),
(106,16,'160200000','Agusan del Norte'),
(107,16,'160202000','Butuan City (Capital)'),
(108,16,'160300000','Agusan del Sur'),
(109,16,'166700000','Surigao del Norte'),
(110,16,'166800000','Surigao del Sur'),
(111,16,'168500000','Dinagat Islands'),
(112,17,'174000000','Marinduque'),
(113,17,'175100000','Occidental Mindoro'),
(114,17,'175200000','Oriental Mindoro'),
(115,17,'175300000','Palawan'),
(116,17,'175316000','Puerto Princesa City (Capital)'),
(117,17,'175900000','Romblon');
-- ------------------------------------
-- END TABLE PROVINCE DATA
-- ------------------------------------