-
Notifications
You must be signed in to change notification settings - Fork 33
/
db_rajaongkir.sql
7558 lines (7553 loc) · 212 KB
/
db_rajaongkir.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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
DROP TABLE IF EXISTS `tb_ro_cities`;
CREATE TABLE `tb_ro_cities` (
`city_id` int(11) NOT NULL,
`province_id` int(11) DEFAULT NULL,
`city_name` varchar(255) DEFAULT NULL,
`postal_code` char(5) DEFAULT NULL,
PRIMARY KEY (`city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_ro_cities` (`city_id`, `province_id`, `city_name`, `postal_code`) VALUES
(1, 21, 'Kabupaten Aceh Barat', '23681'),
(2, 21, 'Kabupaten Aceh Barat Daya', '23764'),
(3, 21, 'Kabupaten Aceh Besar', '23951'),
(4, 21, 'Kabupaten Aceh Jaya', '23654'),
(5, 21, 'Kabupaten Aceh Selatan', '23719'),
(6, 21, 'Kabupaten Aceh Singkil', '24785'),
(7, 21, 'Kabupaten Aceh Tamiang', '24476'),
(8, 21, 'Kabupaten Aceh Tengah', '24511'),
(9, 21, 'Kabupaten Aceh Tenggara', '24611'),
(10, 21, 'Kabupaten Aceh Timur', '24454'),
(11, 21, 'Kabupaten Aceh Utara', '24382'),
(12, 32, 'Kabupaten Agam', '26411'),
(13, 23, 'Kabupaten Alor', '85811'),
(14, 19, 'Kota Ambon', '97222'),
(15, 34, 'Kabupaten Asahan', '21214'),
(16, 24, 'Kabupaten Asmat', '99777'),
(17, 1, 'Kabupaten Badung', '80351'),
(18, 13, 'Kabupaten Balangan', '71611'),
(19, 15, 'Kota Balikpapan', '76111'),
(20, 21, 'Kota Banda Aceh', '23238'),
(21, 18, 'Kota Bandar Lampung', '35139'),
(22, 9, 'Kabupaten Bandung', '40311'),
(23, 9, 'Kota Bandung', '40111'),
(24, 9, 'Kabupaten Bandung Barat', '40721'),
(25, 29, 'Kabupaten Banggai', '94711'),
(26, 29, 'Kabupaten Banggai Kepulauan', '94881'),
(27, 2, 'Kabupaten Bangka', '33212'),
(28, 2, 'Kabupaten Bangka Barat', '33315'),
(29, 2, 'Kabupaten Bangka Selatan', '33719'),
(30, 2, 'Kabupaten Bangka Tengah', '33613'),
(31, 11, 'Kabupaten Bangkalan', '69118'),
(32, 1, 'Kabupaten Bangli', '80619'),
(33, 13, 'Kabupaten Banjar', '70619'),
(34, 9, 'Kota Banjar', '46311'),
(35, 13, 'Kota Banjarbaru', '70712'),
(36, 13, 'Kota Banjarmasin', '70117'),
(37, 10, 'Kabupaten Banjarnegara', '53419'),
(38, 28, 'Kabupaten Bantaeng', '92411'),
(39, 5, 'Kabupaten Bantul', '55715'),
(40, 33, 'Kabupaten Banyuasin', '30911'),
(41, 10, 'Kabupaten Banyumas', '53114'),
(42, 11, 'Kabupaten Banyuwangi', '68416'),
(43, 13, 'Kabupaten Barito Kuala', '70511'),
(44, 14, 'Kabupaten Barito Selatan', '73711'),
(45, 14, 'Kabupaten Barito Timur', '73671'),
(46, 14, 'Kabupaten Barito Utara', '73881'),
(47, 28, 'Kabupaten Barru', '90719'),
(48, 17, 'Kota Batam', '29413'),
(49, 10, 'Kabupaten Batang', '51211'),
(50, 8, 'Kabupaten Batang Hari', '36613'),
(51, 11, 'Kota Batu', '65311'),
(52, 34, 'Kabupaten Batu Bara', '21655'),
(53, 30, 'Kota Bau-Bau', '93719'),
(54, 9, 'Kabupaten Bekasi', '17837'),
(55, 9, 'Kota Bekasi', '17121'),
(56, 2, 'Kabupaten Belitung', '33419'),
(57, 2, 'Kabupaten Belitung Timur', '33519'),
(58, 23, 'Kabupaten Belu', '85711'),
(59, 21, 'Kabupaten Bener Meriah', '24581'),
(60, 26, 'Kabupaten Bengkalis', '28719'),
(61, 12, 'Kabupaten Bengkayang', '79213'),
(62, 4, 'Kota Bengkulu', '38229'),
(63, 4, 'Kabupaten Bengkulu Selatan', '38519'),
(64, 4, 'Kabupaten Bengkulu Tengah', '38319'),
(65, 4, 'Kabupaten Bengkulu Utara', '38619'),
(66, 15, 'Kabupaten Berau', '77311'),
(67, 24, 'Kabupaten Biak Numfor', '98119'),
(68, 22, 'Kabupaten Bima', '84171'),
(69, 22, 'Kota Bima', '84139'),
(70, 34, 'Kota Binjai', '20712'),
(71, 17, 'Kabupaten Bintan', '29135'),
(72, 21, 'Kabupaten Bireuen', '24219'),
(73, 31, 'Kota Bitung', '95512'),
(74, 11, 'Kabupaten Blitar', '66171'),
(75, 11, 'Kota Blitar', '66124'),
(76, 10, 'Kabupaten Blora', '58219'),
(77, 7, 'Kabupaten Boalemo', '96319'),
(78, 9, 'Kabupaten Bogor', '16911'),
(79, 9, 'Kota Bogor', '16119'),
(80, 11, 'Kabupaten Bojonegoro', '62119'),
(81, 31, 'Kabupaten Bolaang Mongondow (Bolmong)', '95755'),
(82, 31, 'Kabupaten Bolaang Mongondow Selatan', '95774'),
(83, 31, 'Kabupaten Bolaang Mongondow Timur', '95783'),
(84, 31, 'Kabupaten Bolaang Mongondow Utara', '95765'),
(85, 30, 'Kabupaten Bombana', '93771'),
(86, 11, 'Kabupaten Bondowoso', '68219'),
(87, 28, 'Kabupaten Bone', '92713'),
(88, 7, 'Kabupaten Bone Bolango', '96511'),
(89, 15, 'Kota Bontang', '75313'),
(90, 24, 'Kabupaten Boven Digoel', '99662'),
(91, 10, 'Kabupaten Boyolali', '57312'),
(92, 10, 'Kabupaten Brebes', '52212'),
(93, 32, 'Kota Bukittinggi', '26115'),
(94, 1, 'Kabupaten Buleleng', '81111'),
(95, 28, 'Kabupaten Bulukumba', '92511'),
(96, 16, 'Kabupaten Bulungan (Bulongan)', '77211'),
(97, 8, 'Kabupaten Bungo', '37216'),
(98, 29, 'Kabupaten Buol', '94564'),
(99, 19, 'Kabupaten Buru', '97371'),
(100, 19, 'Kabupaten Buru Selatan', '97351'),
(101, 30, 'Kabupaten Buton', '93754'),
(102, 30, 'Kabupaten Buton Utara', '93745'),
(103, 9, 'Kabupaten Ciamis', '46211'),
(104, 9, 'Kabupaten Cianjur', '43217'),
(105, 10, 'Kabupaten Cilacap', '53211'),
(106, 3, 'Kota Cilegon', '42417'),
(107, 9, 'Kota Cimahi', '40512'),
(108, 9, 'Kabupaten Cirebon', '45611'),
(109, 9, 'Kota Cirebon', '45116'),
(110, 34, 'Kabupaten Dairi', '22211'),
(111, 24, 'Kabupaten Deiyai (Deliyai)', '98784'),
(112, 34, 'Kabupaten Deli Serdang', '20511'),
(113, 10, 'Kabupaten Demak', '59519'),
(114, 1, 'Kota Denpasar', '80227'),
(115, 9, 'Kota Depok', '16416'),
(116, 32, 'Kabupaten Dharmasraya', '27612'),
(117, 24, 'Kabupaten Dogiyai', '98866'),
(118, 22, 'Kabupaten Dompu', '84217'),
(119, 29, 'Kabupaten Donggala', '94341'),
(120, 26, 'Kota Dumai', '28811'),
(121, 33, 'Kabupaten Empat Lawang', '31811'),
(122, 23, 'Kabupaten Ende', '86351'),
(123, 28, 'Kabupaten Enrekang', '91719'),
(124, 25, 'Kabupaten Fakfak', '98651'),
(125, 23, 'Kabupaten Flores Timur', '86213'),
(126, 9, 'Kabupaten Garut', '44126'),
(127, 21, 'Kabupaten Gayo Lues', '24653'),
(128, 1, 'Kabupaten Gianyar', '80519'),
(129, 7, 'Kabupaten Gorontalo', '96218'),
(130, 7, 'Kota Gorontalo', '96115'),
(131, 7, 'Kabupaten Gorontalo Utara', '96611'),
(132, 28, 'Kabupaten Gowa', '92111'),
(133, 11, 'Kabupaten Gresik', '61115'),
(134, 10, 'Kabupaten Grobogan', '58111'),
(135, 5, 'Kabupaten Gunung Kidul', '55812'),
(136, 14, 'Kabupaten Gunung Mas', '74511'),
(137, 34, 'Kota Gunungsitoli', '22813'),
(138, 20, 'Kabupaten Halmahera Barat', '97757'),
(139, 20, 'Kabupaten Halmahera Selatan', '97911'),
(140, 20, 'Kabupaten Halmahera Tengah', '97853'),
(141, 20, 'Kabupaten Halmahera Timur', '97862'),
(142, 20, 'Kabupaten Halmahera Utara', '97762'),
(143, 13, 'Kabupaten Hulu Sungai Selatan', '71212'),
(144, 13, 'Kabupaten Hulu Sungai Tengah', '71313'),
(145, 13, 'Kabupaten Hulu Sungai Utara', '71419'),
(146, 34, 'Kabupaten Humbang Hasundutan', '22457'),
(147, 26, 'Kabupaten Indragiri Hilir', '29212'),
(148, 26, 'Kabupaten Indragiri Hulu', '29319'),
(149, 9, 'Kabupaten Indramayu', '45214'),
(150, 24, 'Kabupaten Intan Jaya', '98771'),
(151, 6, 'Kota Jakarta Barat', '11220'),
(152, 6, 'Kota Jakarta Pusat', '10540'),
(153, 6, 'Kota Jakarta Selatan', '12230'),
(154, 6, 'Kota Jakarta Timur', '13330'),
(155, 6, 'Kota Jakarta Utara', '14140'),
(156, 8, 'Kota Jambi', '36111'),
(157, 24, 'Kabupaten Jayapura', '99352'),
(158, 24, 'Kota Jayapura', '99114'),
(159, 24, 'Kabupaten Jayawijaya', '99511'),
(160, 11, 'Kabupaten Jember', '68113'),
(161, 1, 'Kabupaten Jembrana', '82251'),
(162, 28, 'Kabupaten Jeneponto', '92319'),
(163, 10, 'Kabupaten Jepara', '59419'),
(164, 11, 'Kabupaten Jombang', '61415'),
(165, 25, 'Kabupaten Kaimana', '98671'),
(166, 26, 'Kabupaten Kampar', '28411'),
(167, 14, 'Kabupaten Kapuas', '73583'),
(168, 12, 'Kabupaten Kapuas Hulu', '78719'),
(169, 10, 'Kabupaten Karanganyar', '57718'),
(170, 1, 'Kabupaten Karangasem', '80819'),
(171, 9, 'Kabupaten Karawang', '41311'),
(172, 17, 'Kabupaten Karimun', '29611'),
(173, 34, 'Kabupaten Karo', '22119'),
(174, 14, 'Kabupaten Katingan', '74411'),
(175, 4, 'Kabupaten Kaur', '38911'),
(176, 12, 'Kabupaten Kayong Utara', '78852'),
(177, 10, 'Kabupaten Kebumen', '54319'),
(178, 11, 'Kabupaten Kediri', '64184'),
(179, 11, 'Kota Kediri', '64125'),
(180, 24, 'Kabupaten Keerom', '99461'),
(181, 10, 'Kabupaten Kendal', '51314'),
(182, 30, 'Kota Kendari', '93126'),
(183, 4, 'Kabupaten Kepahiang', '39319'),
(184, 17, 'Kabupaten Kepulauan Anambas', '29991'),
(185, 19, 'Kabupaten Kepulauan Aru', '97681'),
(186, 32, 'Kabupaten Kepulauan Mentawai', '25771'),
(187, 26, 'Kabupaten Kepulauan Meranti', '28791'),
(188, 31, 'Kabupaten Kepulauan Sangihe', '95819'),
(189, 6, 'Kabupaten Kepulauan Seribu', '14550'),
(190, 31, 'Kabupaten Kepulauan Siau Tagulandang Biaro (Sitaro)', '95862'),
(191, 20, 'Kabupaten Kepulauan Sula', '97995'),
(192, 31, 'Kabupaten Kepulauan Talaud', '95885'),
(193, 24, 'Kabupaten Kepulauan Yapen (Yapen Waropen)', '98211'),
(194, 8, 'Kabupaten Kerinci', '37167'),
(195, 12, 'Kabupaten Ketapang', '78874'),
(196, 10, 'Kabupaten Klaten', '57411'),
(197, 1, 'Kabupaten Klungkung', '80719'),
(198, 30, 'Kabupaten Kolaka', '93511'),
(199, 30, 'Kabupaten Kolaka Utara', '93911'),
(200, 30, 'Kabupaten Konawe', '93411'),
(201, 30, 'Kabupaten Konawe Selatan', '93811'),
(202, 30, 'Kabupaten Konawe Utara', '93311'),
(203, 13, 'Kabupaten Kotabaru', '72119'),
(204, 31, 'Kota Kotamobagu', '95711'),
(205, 14, 'Kabupaten Kotawaringin Barat', '74119'),
(206, 14, 'Kabupaten Kotawaringin Timur', '74364'),
(207, 26, 'Kabupaten Kuantan Singingi', '29519'),
(208, 12, 'Kabupaten Kubu Raya', '78311'),
(209, 10, 'Kabupaten Kudus', '59311'),
(210, 5, 'Kabupaten Kulon Progo', '55611'),
(211, 9, 'Kabupaten Kuningan', '45511'),
(212, 23, 'Kabupaten Kupang', '85362'),
(213, 23, 'Kota Kupang', '85119'),
(214, 15, 'Kabupaten Kutai Barat', '75711'),
(215, 15, 'Kabupaten Kutai Kartanegara', '75511'),
(216, 15, 'Kabupaten Kutai Timur', '75611'),
(217, 34, 'Kabupaten Labuhan Batu', '21412'),
(218, 34, 'Kabupaten Labuhan Batu Selatan', '21511'),
(219, 34, 'Kabupaten Labuhan Batu Utara', '21711'),
(220, 33, 'Kabupaten Lahat', '31419'),
(221, 14, 'Kabupaten Lamandau', '74611'),
(222, 11, 'Kabupaten Lamongan', '64125'),
(223, 18, 'Kabupaten Lampung Barat', '34814'),
(224, 18, 'Kabupaten Lampung Selatan', '35511'),
(225, 18, 'Kabupaten Lampung Tengah', '34212'),
(226, 18, 'Kabupaten Lampung Timur', '34319'),
(227, 18, 'Kabupaten Lampung Utara', '34516'),
(228, 12, 'Kabupaten Landak', '78319'),
(229, 34, 'Kabupaten Langkat', '20811'),
(230, 21, 'Kota Langsa', '24412'),
(231, 24, 'Kabupaten Lanny Jaya', '99531'),
(232, 3, 'Kabupaten Lebak', '42319'),
(233, 4, 'Kabupaten Lebong', '39264'),
(234, 23, 'Kabupaten Lembata', '86611'),
(235, 21, 'Kota Lhokseumawe', '24352'),
(236, 32, 'Kabupaten Lima Puluh Koto/Kota', '26671'),
(237, 17, 'Kabupaten Lingga', '29811'),
(238, 22, 'Kabupaten Lombok Barat', '83311'),
(239, 22, 'Kabupaten Lombok Tengah', '83511'),
(240, 22, 'Kabupaten Lombok Timur', '83612'),
(241, 22, 'Kabupaten Lombok Utara', '83711'),
(242, 33, 'Kota Lubuk Linggau', '31614'),
(243, 11, 'Kabupaten Lumajang', '67319'),
(244, 28, 'Kabupaten Luwu', '91994'),
(245, 28, 'Kabupaten Luwu Timur', '92981'),
(246, 28, 'Kabupaten Luwu Utara', '92911'),
(247, 11, 'Kabupaten Madiun', '63153'),
(248, 11, 'Kota Madiun', '63122'),
(249, 10, 'Kabupaten Magelang', '56519'),
(250, 10, 'Kota Magelang', '56133'),
(251, 11, 'Kabupaten Magetan', '63314'),
(252, 9, 'Kabupaten Majalengka', '45412'),
(253, 27, 'Kabupaten Majene', '91411'),
(254, 28, 'Kota Makassar', '90111'),
(255, 11, 'Kabupaten Malang', '65163'),
(256, 11, 'Kota Malang', '65112'),
(257, 16, 'Kabupaten Malinau', '77511'),
(258, 19, 'Kabupaten Maluku Barat Daya', '97451'),
(259, 19, 'Kabupaten Maluku Tengah', '97513'),
(260, 19, 'Kabupaten Maluku Tenggara', '97651'),
(261, 19, 'Kabupaten Maluku Tenggara Barat', '97465'),
(262, 27, 'Kabupaten Mamasa', '91362'),
(263, 24, 'Kabupaten Mamberamo Raya', '99381'),
(264, 24, 'Kabupaten Mamberamo Tengah', '99553'),
(265, 27, 'Kabupaten Mamuju', '91519'),
(266, 27, 'Kabupaten Mamuju Utara', '91571'),
(267, 31, 'Kota Manado', '95247'),
(268, 34, 'Kabupaten Mandailing Natal', '22916'),
(269, 23, 'Kabupaten Manggarai', '86551'),
(270, 23, 'Kabupaten Manggarai Barat', '86711'),
(271, 23, 'Kabupaten Manggarai Timur', '86811'),
(272, 25, 'Kabupaten Manokwari', '98311'),
(273, 25, 'Kabupaten Manokwari Selatan', '98355'),
(274, 24, 'Kabupaten Mappi', '99853'),
(275, 28, 'Kabupaten Maros', '90511'),
(276, 22, 'Kota Mataram', '83131'),
(277, 25, 'Kabupaten Maybrat', '98051'),
(278, 34, 'Kota Medan', '20228'),
(279, 12, 'Kabupaten Melawi', '78619'),
(280, 8, 'Kabupaten Merangin', '37319'),
(281, 24, 'Kabupaten Merauke', '99613'),
(282, 18, 'Kabupaten Mesuji', '34911'),
(283, 18, 'Kota Metro', '34111'),
(284, 24, 'Kabupaten Mimika', '99962'),
(285, 31, 'Kabupaten Minahasa', '95614'),
(286, 31, 'Kabupaten Minahasa Selatan', '95914'),
(287, 31, 'Kabupaten Minahasa Tenggara', '95995'),
(288, 31, 'Kabupaten Minahasa Utara', '95316'),
(289, 11, 'Kabupaten Mojokerto', '61382'),
(290, 11, 'Kota Mojokerto', '61316'),
(291, 29, 'Kabupaten Morowali', '94911'),
(292, 33, 'Kabupaten Muara Enim', '31315'),
(293, 8, 'Kabupaten Muaro Jambi', '36311'),
(294, 4, 'Kabupaten Muko Muko', '38715'),
(295, 30, 'Kabupaten Muna', '93611'),
(296, 14, 'Kabupaten Murung Raya', '73911'),
(297, 33, 'Kabupaten Musi Banyuasin', '30719'),
(298, 33, 'Kabupaten Musi Rawas', '31661'),
(299, 24, 'Kabupaten Nabire', '98816'),
(300, 21, 'Kabupaten Nagan Raya', '23674'),
(301, 23, 'Kabupaten Nagekeo', '86911'),
(302, 17, 'Kabupaten Natuna', '29711'),
(303, 24, 'Kabupaten Nduga', '99541'),
(304, 23, 'Kabupaten Ngada', '86413'),
(305, 11, 'Kabupaten Nganjuk', '64414'),
(306, 11, 'Kabupaten Ngawi', '63219'),
(307, 34, 'Kabupaten Nias', '22876'),
(308, 34, 'Kabupaten Nias Barat', '22895'),
(309, 34, 'Kabupaten Nias Selatan', '22865'),
(310, 34, 'Kabupaten Nias Utara', '22856'),
(311, 16, 'Kabupaten Nunukan', '77421'),
(312, 33, 'Kabupaten Ogan Ilir', '30811'),
(313, 33, 'Kabupaten Ogan Komering Ilir', '30618'),
(314, 33, 'Kabupaten Ogan Komering Ulu', '32112'),
(315, 33, 'Kabupaten Ogan Komering Ulu Selatan', '32211'),
(316, 33, 'Kabupaten Ogan Komering Ulu Timur', '32312'),
(317, 11, 'Kabupaten Pacitan', '63512'),
(318, 32, 'Kota Padang', '25112'),
(319, 34, 'Kabupaten Padang Lawas', '22763'),
(320, 34, 'Kabupaten Padang Lawas Utara', '22753'),
(321, 32, 'Kota Padang Panjang', '27122'),
(322, 32, 'Kabupaten Padang Pariaman', '25583'),
(323, 34, 'Kota Padang Sidempuan', '22727'),
(324, 33, 'Kota Pagar Alam', '31512'),
(325, 34, 'Kabupaten Pakpak Bharat', '22272'),
(326, 14, 'Kota Palangka Raya', '73112'),
(327, 33, 'Kota Palembang', '31512'),
(328, 28, 'Kota Palopo', '91911'),
(329, 29, 'Kota Palu', '94111'),
(330, 11, 'Kabupaten Pamekasan', '69319'),
(331, 3, 'Kabupaten Pandeglang', '42212'),
(332, 9, 'Kabupaten Pangandaran', '46511'),
(333, 28, 'Kabupaten Pangkajene Kepulauan', '90611'),
(334, 2, 'Kota Pangkal Pinang', '33115'),
(335, 24, 'Kabupaten Paniai', '98765'),
(336, 28, 'Kota Parepare', '91123'),
(337, 32, 'Kota Pariaman', '25511'),
(338, 29, 'Kabupaten Parigi Moutong', '94411'),
(339, 32, 'Kabupaten Pasaman', '26318'),
(340, 32, 'Kabupaten Pasaman Barat', '26511'),
(341, 15, 'Kabupaten Paser', '76211'),
(342, 11, 'Kabupaten Pasuruan', '67153'),
(343, 11, 'Kota Pasuruan', '67118'),
(344, 10, 'Kabupaten Pati', '59114'),
(345, 32, 'Kota Payakumbuh', '26213'),
(346, 25, 'Kabupaten Pegunungan Arfak', '98354'),
(347, 24, 'Kabupaten Pegunungan Bintang', '99573'),
(348, 10, 'Kabupaten Pekalongan', '51161'),
(349, 10, 'Kota Pekalongan', '51122'),
(350, 26, 'Kota Pekanbaru', '28112'),
(351, 26, 'Kabupaten Pelalawan', '28311'),
(352, 10, 'Kabupaten Pemalang', '52319'),
(353, 34, 'Kota Pematang Siantar', '21126'),
(354, 15, 'Kabupaten Penajam Paser Utara', '76311'),
(355, 18, 'Kabupaten Pesawaran', '35312'),
(356, 18, 'Kabupaten Pesisir Barat', '35974'),
(357, 32, 'Kabupaten Pesisir Selatan', '25611'),
(358, 21, 'Kabupaten Pidie', '24116'),
(359, 21, 'Kabupaten Pidie Jaya', '24186'),
(360, 28, 'Kabupaten Pinrang', '91251'),
(361, 7, 'Kabupaten Pohuwato', '96419'),
(362, 27, 'Kabupaten Polewali Mandar', '91311'),
(363, 11, 'Kabupaten Ponorogo', '63411'),
(364, 12, 'Kabupaten Pontianak', '78971'),
(365, 12, 'Kota Pontianak', '78112'),
(366, 29, 'Kabupaten Poso', '94615'),
(367, 33, 'Kota Prabumulih', '31121'),
(368, 18, 'Kabupaten Pringsewu', '35719'),
(369, 11, 'Kabupaten Probolinggo', '67282'),
(370, 11, 'Kota Probolinggo', '67215'),
(371, 14, 'Kabupaten Pulang Pisau', '74811'),
(372, 20, 'Kabupaten Pulau Morotai', '97771'),
(373, 24, 'Kabupaten Puncak', '98981'),
(374, 24, 'Kabupaten Puncak Jaya', '98979'),
(375, 10, 'Kabupaten Purbalingga', '53312'),
(376, 9, 'Kabupaten Purwakarta', '41119'),
(377, 10, 'Kabupaten Purworejo', '54111'),
(378, 25, 'Kabupaten Raja Ampat', '98489'),
(379, 4, 'Kabupaten Rejang Lebong', '39112'),
(380, 10, 'Kabupaten Rembang', '59219'),
(381, 26, 'Kabupaten Rokan Hilir', '28992'),
(382, 26, 'Kabupaten Rokan Hulu', '28511'),
(383, 23, 'Kabupaten Rote Ndao', '85982'),
(384, 21, 'Kota Sabang', '23512'),
(385, 23, 'Kabupaten Sabu Raijua', '85391'),
(386, 10, 'Kota Salatiga', '50711'),
(387, 15, 'Kota Samarinda', '75133'),
(388, 12, 'Kabupaten Sambas', '79453'),
(389, 34, 'Kabupaten Samosir', '22392'),
(390, 11, 'Kabupaten Sampang', '69219'),
(391, 12, 'Kabupaten Sanggau', '78557'),
(392, 24, 'Kabupaten Sarmi', '99373'),
(393, 8, 'Kabupaten Sarolangun', '37419'),
(394, 32, 'Kota Sawah Lunto', '27416'),
(395, 12, 'Kabupaten Sekadau', '79583'),
(396, 28, 'Kabupaten Selayar (Kepulauan Selayar)', '92812'),
(397, 4, 'Kabupaten Seluma', '38811'),
(398, 10, 'Kabupaten Semarang', '50511'),
(399, 10, 'Kota Semarang', '50135'),
(400, 19, 'Kabupaten Seram Bagian Barat', '97561'),
(401, 19, 'Kabupaten Seram Bagian Timur', '97581'),
(402, 3, 'Kabupaten Serang', '42182'),
(403, 3, 'Kota Serang', '42111'),
(404, 34, 'Kabupaten Serdang Bedagai', '20915'),
(405, 14, 'Kabupaten Seruyan', '74211'),
(406, 26, 'Kabupaten Siak', '28623'),
(407, 34, 'Kota Sibolga', '22522'),
(408, 28, 'Kabupaten Sidenreng Rappang/Rapang', '91613'),
(409, 11, 'Kabupaten Sidoarjo', '61219'),
(410, 29, 'Kabupaten Sigi', '94364'),
(411, 32, 'Kabupaten Sijunjung (Sawah Lunto Sijunjung)', '27511'),
(412, 23, 'Kabupaten Sikka', '86121'),
(413, 34, 'Kabupaten Simalungun', '21162'),
(414, 21, 'Kabupaten Simeulue', '23891'),
(415, 12, 'Kota Singkawang', '79117'),
(416, 28, 'Kabupaten Sinjai', '92615'),
(417, 12, 'Kabupaten Sintang', '78619'),
(418, 11, 'Kabupaten Situbondo', '68316'),
(419, 5, 'Kabupaten Sleman', '55513'),
(420, 32, 'Kabupaten Solok', '27365'),
(421, 32, 'Kota Solok', '27315'),
(422, 32, 'Kabupaten Solok Selatan', '27779'),
(423, 28, 'Kabupaten Soppeng', '90812'),
(424, 25, 'Kabupaten Sorong', '98431'),
(425, 25, 'Kota Sorong', '98411'),
(426, 25, 'Kabupaten Sorong Selatan', '98454'),
(427, 10, 'Kabupaten Sragen', '57211'),
(428, 9, 'Kabupaten Subang', '41215'),
(429, 21, 'Kota Subulussalam', '24882'),
(430, 9, 'Kabupaten Sukabumi', '43311'),
(431, 9, 'Kota Sukabumi', '43114'),
(432, 14, 'Kabupaten Sukamara', '74712'),
(433, 10, 'Kabupaten Sukoharjo', '57514'),
(434, 23, 'Kabupaten Sumba Barat', '87219'),
(435, 23, 'Kabupaten Sumba Barat Daya', '87453'),
(436, 23, 'Kabupaten Sumba Tengah', '87358'),
(437, 23, 'Kabupaten Sumba Timur', '87112'),
(438, 22, 'Kabupaten Sumbawa', '84315'),
(439, 22, 'Kabupaten Sumbawa Barat', '84419'),
(440, 9, 'Kabupaten Sumedang', '45326'),
(441, 11, 'Kabupaten Sumenep', '69413'),
(442, 8, 'Kota Sungaipenuh', '37113'),
(443, 24, 'Kabupaten Supiori', '98164'),
(444, 11, 'Kota Surabaya', '60119'),
(445, 10, 'Kota Surakarta (Solo)', '57113'),
(446, 13, 'Kabupaten Tabalong', '71513'),
(447, 1, 'Kabupaten Tabanan', '82119'),
(448, 28, 'Kabupaten Takalar', '92212'),
(449, 25, 'Kabupaten Tambrauw', '98475'),
(450, 16, 'Kabupaten Tana Tidung', '77611'),
(451, 28, 'Kabupaten Tana Toraja', '91819'),
(452, 13, 'Kabupaten Tanah Bumbu', '72211'),
(453, 32, 'Kabupaten Tanah Datar', '27211'),
(454, 13, 'Kabupaten Tanah Laut', '70811'),
(455, 3, 'Kabupaten Tangerang', '15914'),
(456, 3, 'Kota Tangerang', '15111'),
(457, 3, 'Kota Tangerang Selatan', '15332'),
(458, 18, 'Kabupaten Tanggamus', '35619'),
(459, 34, 'Kota Tanjung Balai', '21321'),
(460, 8, 'Kabupaten Tanjung Jabung Barat', '36513'),
(461, 8, 'Kabupaten Tanjung Jabung Timur', '36719'),
(462, 17, 'Kota Tanjung Pinang', '29111'),
(463, 34, 'Kabupaten Tapanuli Selatan', '22742'),
(464, 34, 'Kabupaten Tapanuli Tengah', '22611'),
(465, 34, 'Kabupaten Tapanuli Utara', '22414'),
(466, 13, 'Kabupaten Tapin', '71119'),
(467, 16, 'Kota Tarakan', '77114'),
(468, 9, 'Kabupaten Tasikmalaya', '46411'),
(469, 9, 'Kota Tasikmalaya', '46116'),
(470, 34, 'Kota Tebing Tinggi', '20632'),
(471, 8, 'Kabupaten Tebo', '37519'),
(472, 10, 'Kabupaten Tegal', '52419'),
(473, 10, 'Kota Tegal', '52114'),
(474, 25, 'Kabupaten Teluk Bintuni', '98551'),
(475, 25, 'Kabupaten Teluk Wondama', '98591'),
(476, 10, 'Kabupaten Temanggung', '56212'),
(477, 20, 'Kota Ternate', '97714'),
(478, 20, 'Kota Tidore Kepulauan', '97815'),
(479, 23, 'Kabupaten Timor Tengah Selatan', '85562'),
(480, 23, 'Kabupaten Timor Tengah Utara', '85612'),
(481, 34, 'Kabupaten Toba Samosir', '22316'),
(482, 29, 'Kabupaten Tojo Una-Una', '94683'),
(483, 29, 'Kabupaten Toli-Toli', '94542'),
(484, 24, 'Kabupaten Tolikara', '99411'),
(485, 31, 'Kota Tomohon', '95416'),
(486, 28, 'Kabupaten Toraja Utara', '91831'),
(487, 11, 'Kabupaten Trenggalek', '66312'),
(488, 19, 'Kota Tual', '97612'),
(489, 11, 'Kabupaten Tuban', '62319'),
(490, 18, 'Kabupaten Tulang Bawang', '34613'),
(491, 18, 'Kabupaten Tulang Bawang Barat', '34419'),
(492, 11, 'Kabupaten Tulungagung', '66212'),
(493, 28, 'Kabupaten Wajo', '90911'),
(494, 30, 'Kabupaten Wakatobi', '93791'),
(495, 24, 'Kabupaten Waropen', '98269'),
(496, 18, 'Kabupaten Way Kanan', '34711'),
(497, 10, 'Kabupaten Wonogiri', '57619'),
(498, 10, 'Kabupaten Wonosobo', '56311'),
(499, 24, 'Kabupaten Yahukimo', '99041'),
(500, 24, 'Kabupaten Yalimo', '99481'),
(501, 5, 'Kota Yogyakarta', '55222');
DROP TABLE IF EXISTS `tb_ro_provinces`;
CREATE TABLE `tb_ro_provinces` (
`province_id` int(11) NOT NULL,
`province_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`province_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_ro_provinces` (`province_id`, `province_name`) VALUES
(1, 'Bali'),
(2, 'Bangka Belitung'),
(3, 'Banten'),
(4, 'Bengkulu'),
(5, 'DI Yogyakarta'),
(6, 'DKI Jakarta'),
(7, 'Gorontalo'),
(8, 'Jambi'),
(9, 'Jawa Barat'),
(10, 'Jawa Tengah'),
(11, 'Jawa Timur'),
(12, 'Kalimantan Barat'),
(13, 'Kalimantan Selatan'),
(14, 'Kalimantan Tengah'),
(15, 'Kalimantan Timur'),
(16, 'Kalimantan Utara'),
(17, 'Kepulauan Riau'),
(18, 'Lampung'),
(19, 'Maluku'),
(20, 'Maluku Utara'),
(21, 'Nanggroe Aceh Darussalam (NAD)'),
(22, 'Nusa Tenggara Barat (NTB)'),
(23, 'Nusa Tenggara Timur (NTT)'),
(24, 'Papua'),
(25, 'Papua Barat'),
(26, 'Riau'),
(27, 'Sulawesi Barat'),
(28, 'Sulawesi Selatan'),
(29, 'Sulawesi Tengah'),
(30, 'Sulawesi Tenggara'),
(31, 'Sulawesi Utara'),
(32, 'Sumatera Barat'),
(33, 'Sumatera Selatan'),
(34, 'Sumatera Utara');
DROP TABLE IF EXISTS `tb_ro_subdistricts`;
CREATE TABLE `tb_ro_subdistricts` (
`subdistrict_id` int(11) NOT NULL,
`city_id` int(11) DEFAULT NULL,
`subdistrict_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`subdistrict_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_ro_subdistricts` (`subdistrict_id`, `city_id`, `subdistrict_name`) VALUES
(1, 1, 'Arongan Lambalek'),
(2, 1, 'Bubon'),
(3, 1, 'Johan Pahlawan'),
(4, 1, 'Kaway XVI'),
(5, 1, 'Meureubo'),
(6, 1, 'Pante Ceureumen (Pantai Ceuremen)'),
(7, 1, 'Panton Reu'),
(8, 1, 'Samatiga'),
(9, 1, 'Sungai Mas'),
(10, 1, 'Woyla'),
(11, 1, 'Woyla Barat'),
(12, 1, 'Woyla Timur'),
(13, 2, 'Babah Rot'),
(14, 2, 'Blang Pidie'),
(15, 2, 'Jeumpa'),
(16, 2, 'Kuala Batee'),
(17, 2, 'Lembah Sabil'),
(18, 2, 'Manggeng'),
(19, 2, 'Setia'),
(20, 2, 'Susoh'),
(21, 2, 'Tangan-Tangan'),
(22, 3, 'Baitussalam'),
(23, 3, 'Blank Bintang'),
(24, 3, 'Darul Imarah'),
(25, 3, 'Darul Kamal'),
(26, 3, 'Darussalam'),
(27, 3, 'Indrapuri'),
(28, 3, 'Ingin Jaya'),
(29, 3, 'Kota Cot Glie (Kuta Cot Glie)'),
(30, 3, 'Kota Jantho'),
(31, 3, 'Kota Malaka (Kuta Malaka)'),
(32, 3, 'Krueng Barona Jaya'),
(33, 3, 'Kuta Baro'),
(34, 3, 'Lembah Seulawah'),
(35, 3, 'Leupung'),
(36, 3, 'Lhoknga (Lho\'nga)'),
(37, 3, 'Lhoong'),
(38, 3, 'Mantasiek (Montasik)'),
(39, 3, 'Mesjid Raya'),
(40, 3, 'Peukan Bada'),
(41, 3, 'Pulo Aceh'),
(42, 3, 'Seulimeum'),
(43, 3, 'Simpang Tiga'),
(44, 3, 'Suka Makmur'),
(45, 4, 'Darul Hikmah'),
(46, 4, 'Indra Jaya'),
(47, 4, 'Jaya'),
(48, 4, 'Keude Panga'),
(49, 4, 'Krueng Sabee'),
(50, 4, 'Pasie Raya'),
(51, 4, 'Sampoiniet'),
(52, 4, 'Setia Bakti'),
(53, 4, 'Teunom'),
(54, 5, 'Bakongan'),
(55, 5, 'Bakongan Timur'),
(56, 5, 'Kluet Selatan'),
(57, 5, 'Kluet Tengah'),
(58, 5, 'Kluet Timur'),
(59, 5, 'Kluet Utara'),
(60, 5, 'Kota Bahagia'),
(61, 5, 'Labuhan Haji'),
(62, 5, 'Labuhan Haji Barat'),
(63, 5, 'Labuhan Haji Timur'),
(64, 5, 'Meukek'),
(65, 5, 'Pasie Raja'),
(66, 5, 'Sama Dua'),
(67, 5, 'Sawang'),
(68, 5, 'Tapak Tuan'),
(69, 5, 'Trumon'),
(70, 5, 'Trumon Tengah'),
(71, 5, 'Trumon Timur'),
(72, 6, 'Danau Paris'),
(73, 6, 'Gunung Meriah (Mariah)'),
(74, 6, 'Kota Baharu'),
(75, 6, 'Kuala Baru'),
(76, 6, 'Pulau Banyak'),
(77, 6, 'Pulau Banyak Barat'),
(78, 6, 'Simpang Kanan'),
(79, 6, 'Singkil'),
(80, 6, 'Singkil Utara'),
(81, 6, 'Singkohor'),
(82, 6, 'Suro Makmur'),
(83, 7, 'Banda Mulia'),
(84, 7, 'Bandar Pusaka'),
(85, 7, 'Bendahara'),
(86, 7, 'Karang Baru'),
(87, 7, 'Kejuruan Muda'),
(88, 7, 'Kota Kuala Simpang'),
(89, 7, 'Manyak Payed'),
(90, 7, 'Rantau'),
(91, 7, 'Sekerak'),
(92, 7, 'Seruway'),
(93, 7, 'Tamiang Hulu'),
(94, 7, 'Tenggulun'),
(95, 8, 'Atu Lintang'),
(96, 8, 'Bebesen'),
(97, 8, 'Bies'),
(98, 8, 'Bintang'),
(99, 8, 'Celala'),
(100, 8, 'Jagong Jeget'),
(101, 8, 'Kebayakan'),
(102, 8, 'Ketol'),
(103, 8, 'Kute Panang'),
(104, 8, 'Linge'),
(105, 8, 'Lut Tawar'),
(106, 8, 'Pegasing'),
(107, 8, 'Rusip Antara'),
(108, 8, 'Silih Nara'),
(109, 9, 'Babul Makmur'),
(110, 9, 'Babul Rahmah'),
(111, 9, 'Babussalam'),
(112, 9, 'Badar'),
(113, 9, 'Bambel'),
(114, 9, 'Bukit Tusam'),
(115, 9, 'Darul Hasanah'),
(116, 9, 'Deleng Pokhisen'),
(117, 9, 'Ketambe'),
(118, 9, 'Lawe Alas'),
(119, 9, 'Lawe Bulan'),
(120, 9, 'Lawe Sigala-Gala'),
(121, 9, 'Lawe Sumur'),
(122, 9, 'Leuser'),
(123, 9, 'Semadam'),
(124, 9, 'Tanah Alas'),
(125, 10, 'Banda Alam'),
(126, 10, 'Birem Bayeun'),
(127, 10, 'Darul Aman'),
(128, 10, 'Darul Falah'),
(129, 10, 'Darul Iksan (Ihsan)'),
(130, 10, 'Idi Rayeuk'),
(131, 10, 'Idi Timur'),
(132, 10, 'Idi Tunong'),
(133, 10, 'Indra Makmur'),
(134, 10, 'Julok'),
(135, 10, 'Madat'),
(136, 10, 'Nurussalam'),
(137, 10, 'Pante Bidari (Beudari)'),
(138, 10, 'Peudawa'),
(139, 10, 'Peunaron'),
(140, 10, 'Peureulak'),
(141, 10, 'Peureulak Barat'),
(142, 10, 'Peureulak Timur'),
(143, 10, 'Rantau Selamat'),
(144, 10, 'Ranto Peureulak'),
(145, 10, 'Serba Jadi'),
(146, 10, 'Simpang Jernih'),
(147, 10, 'Simpang Ulim'),
(148, 10, 'Sungai Raya'),
(149, 11, 'Baktiya'),
(150, 11, 'Baktiya Barat'),
(151, 11, 'Banda Baro'),
(152, 11, 'Cot Girek'),
(153, 11, 'Dewantara'),
(154, 11, 'Geuredong Pase'),
(155, 11, 'Kuta Makmur'),
(156, 11, 'Langkahan'),
(157, 11, 'Lapang'),
(158, 11, 'Lhoksukon'),
(159, 11, 'Matangkuli'),
(160, 11, 'Meurah Mulia'),
(161, 11, 'Muara Batu'),
(162, 11, 'Nibong'),
(163, 11, 'Nisam'),
(164, 11, 'Nisam Antara'),
(165, 11, 'Paya Bakong'),
(166, 11, 'Pirak Timur'),
(167, 11, 'Samudera'),
(168, 11, 'Sawang'),
(169, 11, 'Seunuddon (Seunudon)'),
(170, 11, 'Simpang Kramat (Keramat)'),
(171, 11, 'Syamtalira Aron'),
(172, 11, 'Syamtalira Bayu'),
(173, 11, 'Tanah Jambo Aye'),
(174, 11, 'Tanah Luas'),
(175, 11, 'Tanah Pasir'),
(176, 12, 'Ampek Nagari (IV Nagari )'),
(177, 12, 'Banuhampu'),
(178, 12, 'Baso'),
(179, 12, 'Candung'),
(180, 12, 'IV Angkat Candung (Ampek Angkek)'),
(181, 12, 'IV Koto (Ampek Koto)'),
(182, 12, 'Kamang Magek'),
(183, 12, 'Lubuk Basung'),
(184, 12, 'Malakak'),
(185, 12, 'Matur'),
(186, 12, 'Palembayan'),
(187, 12, 'Palupuh'),
(188, 12, 'Sungai Pua (Puar)'),
(189, 12, 'Tanjung Mutiara'),
(190, 12, 'Tanjung Raya'),
(191, 12, 'Tilatang Kamang'),
(192, 13, 'Alor Barat Daya'),
(193, 13, 'Alor Barat Laut'),
(194, 13, 'Alor Selatan'),
(195, 13, 'Alor Tengah Utara'),
(196, 13, 'Alor Timur'),
(197, 13, 'Alor Timur Laut'),
(198, 13, 'Kabola'),
(199, 13, 'Lembur'),
(200, 13, 'Mataru'),
(201, 13, 'Pantar'),
(202, 13, 'Pantar Barat'),
(203, 13, 'Pantar Barat Laut'),
(204, 13, 'Pantar Tengah'),
(205, 13, 'Pantar Timur'),
(206, 13, 'Pulau Pura'),
(207, 13, 'Pureman'),
(208, 13, 'Teluk Mutiara'),
(209, 14, 'Baguala'),
(210, 14, 'Leitimur Selatan'),
(211, 14, 'Nusaniwe (Nusanive)'),
(212, 14, 'Sirimau'),
(213, 14, 'Teluk Ambon'),
(214, 15, 'Aek Kuasan'),
(215, 15, 'Aek Ledong'),
(216, 15, 'Aek Songsongan'),
(217, 15, 'Air Batu'),
(218, 15, 'Air Joman'),
(219, 15, 'Bandar Pasir Mandoge'),
(220, 15, 'Bandar Pulau'),
(221, 15, 'Buntu Pane'),
(222, 15, 'Kisaran Barat Kota'),
(223, 15, 'Kisaran Timur Kota'),
(224, 15, 'Meranti'),
(225, 15, 'Pulau Rakyat'),
(226, 15, 'Pulo Bandring'),
(227, 15, 'Rahuning'),
(228, 15, 'Rawang Panca Arga'),
(229, 15, 'Sei Dadap'),
(230, 15, 'Sei Kepayang'),
(231, 15, 'Sei Kepayang Barat'),
(232, 15, 'Sei Kepayang Timur'),
(233, 15, 'Setia Janji'),
(234, 15, 'Silau Laut'),
(235, 15, 'Simpang Empat'),
(236, 15, 'Tanjung Balai'),
(237, 15, 'Teluk Dalam'),
(238, 15, 'Tinggi Raja'),
(239, 16, 'Agats'),
(240, 16, 'Akat'),
(241, 16, 'Atsy / Atsj'),
(242, 16, 'Ayip'),
(243, 16, 'Betcbamu'),
(244, 16, 'Der Koumur'),
(245, 16, 'Fayit'),
(246, 16, 'Jetsy'),
(247, 16, 'Joerat'),
(248, 16, 'Kolf Braza'),
(249, 16, 'Kopay'),
(250, 16, 'Pantai Kasuari'),
(251, 16, 'Pulau Tiga'),
(252, 16, 'Safan'),
(253, 16, 'Sawa Erma'),
(254, 16, 'Sirets'),
(255, 16, 'Suator'),
(256, 16, 'Suru-suru'),
(257, 16, 'Unir Sirau'),
(258, 17, 'Abiansemal'),
(259, 17, 'Kuta'),
(260, 17, 'Kuta Selatan'),
(261, 17, 'Kuta Utara'),
(262, 17, 'Mengwi'),
(263, 17, 'Petang'),
(264, 18, 'Awayan'),
(265, 18, 'Batu Mandi'),
(266, 18, 'Halong'),
(267, 18, 'Juai'),
(268, 18, 'Lampihong'),
(269, 18, 'Paringin'),
(270, 18, 'Paringin Selatan'),
(271, 18, 'Tebing Tinggi'),
(272, 19, 'Balikpapan Barat'),
(273, 19, 'Balikpapan Kota'),
(274, 19, 'Balikpapan Selatan'),
(275, 19, 'Balikpapan Tengah'),
(276, 19, 'Balikpapan Timur'),
(277, 19, 'Balikpapan Utara'),
(278, 20, 'Baiturrahman'),
(279, 20, 'Banda Raya'),
(280, 20, 'Jaya Baru'),
(281, 20, 'Kuta Alam'),
(282, 20, 'Kuta Raja'),
(283, 20, 'Lueng Bata'),
(284, 20, 'Meuraxa'),
(285, 20, 'Syiah Kuala'),
(286, 20, 'Ulee Kareng'),
(287, 21, 'Bumi Waras'),
(288, 21, 'Enggal'),
(289, 21, 'Kedamaian'),
(290, 21, 'Kedaton'),
(291, 21, 'Kemiling'),
(292, 21, 'Labuhan Ratu'),
(293, 21, 'Langkapura'),
(294, 21, 'Panjang'),
(295, 21, 'Rajabasa'),
(296, 21, 'Sukabumi'),
(297, 21, 'Sukarame'),
(298, 21, 'Tanjung Karang Barat'),
(299, 21, 'Tanjung Karang Pusat'),
(300, 21, 'Tanjung Karang Timur'),
(301, 21, 'Tanjung Senang'),
(302, 21, 'Telukbetung Barat'),
(303, 21, 'Telukbetung Selatan'),
(304, 21, 'Telukbetung Timur'),
(305, 21, 'Telukbetung Utara'),
(306, 21, 'Way Halim'),
(307, 22, 'Arjasari'),
(308, 22, 'Baleendah'),
(309, 22, 'Banjaran'),
(310, 22, 'Bojongsoang'),
(311, 22, 'Cangkuang'),
(312, 22, 'Cicalengka'),
(313, 22, 'Cikancung'),
(314, 22, 'Cilengkrang'),
(315, 22, 'Cileunyi'),
(316, 22, 'Cimaung'),
(317, 22, 'Cimeunyan'),
(318, 22, 'Ciparay'),
(319, 22, 'Ciwidey'),
(320, 22, 'Dayeuhkolot'),
(321, 22, 'Ibun'),
(322, 22, 'Katapang'),
(323, 22, 'Kertasari'),
(324, 22, 'Kutawaringin'),
(325, 22, 'Majalaya'),
(326, 22, 'Margaasih'),
(327, 22, 'Margahayu'),
(328, 22, 'Nagreg'),
(329, 22, 'Pacet'),
(330, 22, 'Pameungpeuk'),
(331, 22, 'Pangalengan'),
(332, 22, 'Paseh'),
(333, 22, 'Pasirjambu'),
(334, 22, 'Ranca Bali'),
(335, 22, 'Rancaekek'),
(336, 22, 'Solokan Jeruk'),
(337, 22, 'Soreang'),
(338, 23, 'Andir'),
(339, 23, 'Antapani (Cicadas)'),
(340, 23, 'Arcamanik'),
(341, 23, 'Astana Anyar'),
(342, 23, 'Babakan Ciparay'),
(343, 23, 'Bandung Kidul'),
(344, 23, 'Bandung Kulon'),
(345, 23, 'Bandung Wetan'),
(346, 23, 'Batununggal'),
(347, 23, 'Bojongloa Kaler'),
(348, 23, 'Bojongloa Kidul'),
(349, 23, 'Buahbatu (Margacinta)'),
(350, 23, 'Cibeunying Kaler'),
(351, 23, 'Cibeunying Kidul'),
(352, 23, 'Cibiru'),
(353, 23, 'Cicendo'),
(354, 23, 'Cidadap'),
(355, 23, 'Cinambo'),
(356, 23, 'Coblong'),
(357, 23, 'Gedebage'),
(358, 23, 'Kiaracondong'),
(359, 23, 'Lengkong'),
(360, 23, 'Mandalajati'),
(361, 23, 'Panyileukan'),
(362, 23, 'Rancasari'),
(363, 23, 'Regol'),
(364, 23, 'Sukajadi'),
(365, 23, 'Sukasari'),
(366, 23, 'Sumur Bandung'),
(367, 23, 'Ujung Berung'),
(368, 24, 'Batujajar'),
(369, 24, 'Cihampelas'),
(370, 24, 'Cikalong Wetan'),
(371, 24, 'Cililin'),
(372, 24, 'Cipatat'),
(373, 24, 'Cipeundeuy'),
(374, 24, 'Cipongkor'),
(375, 24, 'Cisarua'),
(376, 24, 'Gununghalu'),
(377, 24, 'Lembang'),
(378, 24, 'Ngamprah'),
(379, 24, 'Padalarang'),
(380, 24, 'Parongpong'),
(381, 24, 'Rongga'),
(382, 24, 'Saguling'),
(383, 24, 'Sindangkerta'),
(384, 25, 'Balantak'),
(385, 25, 'Balantak Selatan'),
(386, 25, 'Balantak Utara'),
(387, 25, 'Batui'),
(388, 25, 'Batui Selatan'),
(389, 25, 'Bualemo (Boalemo)'),
(390, 25, 'Bunta'),
(391, 25, 'Kintom'),
(392, 25, 'Lamala'),
(393, 25, 'Lobu'),
(394, 25, 'Luwuk'),
(395, 25, 'Luwuk Selatan'),
(396, 25, 'Luwuk Timur'),
(397, 25, 'Luwuk Utara'),
(398, 25, 'Mantoh'),
(399, 25, 'Masama'),
(400, 25, 'Moilong'),
(401, 25, 'Nambo'),
(402, 25, 'Nuhon'),
(403, 25, 'Pagimana'),
(404, 25, 'Simpang Raya'),
(405, 25, 'Toili'),
(406, 25, 'Toili Barat'),
(407, 26, 'Banggai'),
(408, 26, 'Banggai Selatan'),
(409, 26, 'Banggai Tengah'),
(410, 26, 'Banggai Utara'),
(411, 26, 'Bangkurung'),
(412, 26, 'Bokan Kepulauan'),
(413, 26, 'Buko'),
(414, 26, 'Buko Selatan'),
(415, 26, 'Bulagi'),
(416, 26, 'Bulagi Selatan'),
(417, 26, 'Bulagi Utara'),
(418, 26, 'Labobo (Lobangkurung)'),
(419, 26, 'Liang'),
(420, 26, 'Peling Tengah'),
(421, 26, 'Tinangkung'),
(422, 26, 'Tinangkung Selatan'),
(423, 26, 'Tinangkung Utara'),
(424, 26, 'Totikum (Totikung)'),
(425, 26, 'Totikum Selatan'),
(426, 27, 'Bakam'),
(427, 27, 'Belinyu'),
(428, 27, 'Mendo Barat'),
(429, 27, 'Merawang'),
(430, 27, 'Pemali'),
(431, 27, 'Puding Besar'),
(432, 27, 'Riau Silip'),
(433, 27, 'Sungai Liat'),
(434, 28, 'Jebus'),
(435, 28, 'Kelapa'),
(436, 28, 'Mentok (Muntok)'),