-
Notifications
You must be signed in to change notification settings - Fork 227
/
world_area.sql
7200 lines (7183 loc) · 752 KB
/
world_area.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
/*
Navicat Premium Data Transfer
Source Server : 139
Source Server Type : MySQL
Source Server Version : 50718
Source Schema : world_area
Target Server Type : MySQL
Target Server Version : 50718
File Encoding : 65001
Date: 28/02/2019 16:59:26
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country_id` int(11) NULL DEFAULT NULL,
`code` int(11) NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`cname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`lower_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES (1, 226, 1, 'New England', '新英格兰地区', 'new england');
INSERT INTO `area` VALUES (2, 226, 2, 'Mid-Atlantic', '中大西洋地区', 'mid-atlantic');
INSERT INTO `area` VALUES (3, 226, 3, 'Southeast region', '东南地区', 'southeast region');
INSERT INTO `area` VALUES (4, 226, 4, 'Great Lakes', '五大湖区', 'great lakes');
INSERT INTO `area` VALUES (5, 226, 5, 'Southern land', '南方地区', 'southern land');
INSERT INTO `area` VALUES (6, 226, 6, 'Midwest', '中西部地区', 'midwest');
INSERT INTO `area` VALUES (7, 226, 7, 'Rocky Mountain', '落基山区', 'rocky mountain');
INSERT INTO `area` VALUES (8, 226, 8, 'Pacific Coast', '太平洋海岸区', 'pacific coast');
INSERT INTO `area` VALUES (9, 226, 9, 'Southwest Region', '西南地区', 'southwest region');
-- ----------------------------
-- Table structure for cities
-- ----------------------------
DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`state_id` smallint(6) NOT NULL COMMENT '所属州省代码',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`cname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`lower_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`code_full` char(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '地区代码',
PRIMARY KEY (`id`) USING BTREE,
INDEX `cities_state_id_index`(`state_id`) USING BTREE,
INDEX `cities_code_index`(`code_full`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3796 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of cities
-- ----------------------------
INSERT INTO `cities` VALUES (1, 1, 'HEA', 'Herat', '赫拉特', 'herat', 'AFG000HEA');
INSERT INTO `cities` VALUES (2, 1, 'KBL', 'Kabul', '喀布尔', 'kabul', 'AFG000KBL');
INSERT INTO `cities` VALUES (3, 1, 'KDH', 'Kandahar', '坎大哈', 'kandahar', 'AFG000KDH');
INSERT INTO `cities` VALUES (4, 1, 'MZR', 'Mazar-i Sharif', '马扎里沙里夫', 'mazar-i sharif', 'AFG000MZR');
INSERT INTO `cities` VALUES (5, 2, 'BGO', 'Bengo', '本戈', 'bengo', 'AGO000BGO');
INSERT INTO `cities` VALUES (6, 2, 'BGU', 'Benguela', '本格拉', 'benguela', 'AGO000BGU');
INSERT INTO `cities` VALUES (7, 2, 'BIE', 'Bie', '比耶', 'bie', 'AGO000BIE');
INSERT INTO `cities` VALUES (8, 2, 'CAB', 'Cabinda', '卡宾达', 'cabinda', 'AGO000CAB');
INSERT INTO `cities` VALUES (9, 2, 'CCU', 'Cuando Cubango', '宽多库邦戈', 'cuando cubango', 'AGO000CCU');
INSERT INTO `cities` VALUES (10, 2, 'CNN', 'Cunene', '库内内', 'cunene', 'AGO000CNN');
INSERT INTO `cities` VALUES (11, 2, 'CNO', 'Cuanza Norte', '北宽扎', 'cuanza norte', 'AGO000CNO');
INSERT INTO `cities` VALUES (12, 2, 'CUS', 'Cuanza Sul', '南宽扎', 'cuanza sul', 'AGO000CUS');
INSERT INTO `cities` VALUES (13, 2, 'HUA', 'Huambo', '万博', 'huambo', 'AGO000HUA');
INSERT INTO `cities` VALUES (14, 2, 'HUI', 'Huila', '威拉', 'huila', 'AGO000HUI');
INSERT INTO `cities` VALUES (15, 2, 'LNO', 'Lunda Norte', '北隆达', 'lunda norte', 'AGO000LNO');
INSERT INTO `cities` VALUES (16, 2, 'LSU', 'Lunda Sul', '南隆达', 'lunda sul', 'AGO000LSU');
INSERT INTO `cities` VALUES (17, 2, 'LUA', 'Luanda', '罗安达', 'luanda', 'AGO000LUA');
INSERT INTO `cities` VALUES (18, 2, 'MAL', 'Malanje', '马兰热', 'malanje', 'AGO000MAL');
INSERT INTO `cities` VALUES (19, 2, 'MOX', 'Moxico', '莫希科', 'moxico', 'AGO000MOX');
INSERT INTO `cities` VALUES (20, 2, 'NAM', 'Namibe', '纳米贝', 'namibe', 'AGO000NAM');
INSERT INTO `cities` VALUES (21, 2, 'UIG', 'Uige', '威热', 'uige', 'AGO000UIG');
INSERT INTO `cities` VALUES (22, 2, 'ZAI', 'Zaire', '扎伊尔', 'zaire', 'AGO000ZAI');
INSERT INTO `cities` VALUES (23, 3, 'BR', 'Berat', '培拉特', 'berat', 'ALB0000BR');
INSERT INTO `cities` VALUES (24, 3, 'DI', 'Diber', '迪勃拉', 'diber', 'ALB0000DI');
INSERT INTO `cities` VALUES (25, 3, 'DR', 'Durres', '都拉斯', 'durres', 'ALB0000DR');
INSERT INTO `cities` VALUES (26, 3, 'EL', 'Elbasan', '爱尔巴桑', 'elbasan', 'ALB0000EL');
INSERT INTO `cities` VALUES (27, 3, 'FR', 'Fier', '费里', 'fier', 'ALB0000FR');
INSERT INTO `cities` VALUES (28, 3, 'GJ', 'Gjirokaster', '吉诺卡斯特', 'gjirokaster', 'ALB0000GJ');
INSERT INTO `cities` VALUES (29, 3, 'KO', 'Korce', '科尔察', 'korce', 'ALB0000KO');
INSERT INTO `cities` VALUES (30, 3, 'KU', 'Kukes', '库克斯', 'kukes', 'ALB0000KU');
INSERT INTO `cities` VALUES (31, 3, 'LE', 'Lezhe', '莱什', 'lezhe', 'ALB0000LE');
INSERT INTO `cities` VALUES (32, 3, 'SH', 'Shkoder', '斯库台', 'shkoder', 'ALB0000SH');
INSERT INTO `cities` VALUES (33, 3, 'TR', 'Tirane', '地拉那', 'tirane', 'ALB0000TR');
INSERT INTO `cities` VALUES (34, 3, 'VL', 'Vlore', '发罗拉', 'vlore', 'ALB0000VL');
INSERT INTO `cities` VALUES (35, 4, '2', 'Canillo', '卡尼略', 'canillo', 'AND000002');
INSERT INTO `cities` VALUES (36, 4, '3', 'Encamp', '恩坎普', 'encamp', 'AND000003');
INSERT INTO `cities` VALUES (37, 4, '4', 'La Massana', '马萨纳', 'la massana', 'AND000004');
INSERT INTO `cities` VALUES (38, 4, '5', 'Ordino', '奥尔迪诺', 'ordino', 'AND000005');
INSERT INTO `cities` VALUES (39, 4, '6', 'Sant Julia de Laria', '圣胡利娅-德洛里亚', 'sant julia de laria', 'AND000006');
INSERT INTO `cities` VALUES (40, 4, '7', 'Andorra la Vella', '安道尔城', 'andorra la vella', 'AND000007');
INSERT INTO `cities` VALUES (41, 4, '8', 'Escaldes-Engordany', '莱塞斯卡尔德-恩戈尔达', 'escaldes-engordany', 'AND000008');
INSERT INTO `cities` VALUES (42, 5, 'AL', 'Al l\'Ayn', '艾因', 'al l\'ayn', 'ARE0000AL');
INSERT INTO `cities` VALUES (43, 5, 'AZ', 'Abu Dhabi', '阿布扎比', 'abu dhabi', 'ARE0000AZ');
INSERT INTO `cities` VALUES (44, 5, 'DU', 'Dubai', '迪拜', 'dubai', 'ARE0000DU');
INSERT INTO `cities` VALUES (45, 5, 'SH', 'Ash Shariqah', '沙迦', 'ash shariqah', 'ARE0000SH');
INSERT INTO `cities` VALUES (46, 6, 'AFA', 'San Rafael', '圣拉斐尔', 'san rafael', 'ARG000AFA');
INSERT INTO `cities` VALUES (47, 6, 'BHI', 'Bahia Blanca', '布兰卡港', 'bahia blanca', 'ARG000BHI');
INSERT INTO `cities` VALUES (48, 6, 'BUE', 'Buenos Aires', '布宜诺斯艾利斯', 'buenos aires', 'ARG000BUE');
INSERT INTO `cities` VALUES (49, 6, 'CNQ', 'Corrientes', '科连特斯', 'corrientes', 'ARG000CNQ');
INSERT INTO `cities` VALUES (50, 6, 'COC', 'Concordia', '肯考迪娅', 'concordia', 'ARG000COC');
INSERT INTO `cities` VALUES (51, 6, 'COR', 'Cordoba', '科尔多瓦', 'cordoba', 'ARG000COR');
INSERT INTO `cities` VALUES (52, 6, 'CRD', 'Comodoro Rivadavia', '里瓦达维亚海军准将城', 'comodoro rivadavia', 'ARG000CRD');
INSERT INTO `cities` VALUES (53, 6, 'CTC', 'Catamarca', '卡塔马卡', 'catamarca', 'ARG000CTC');
INSERT INTO `cities` VALUES (54, 6, 'FMA', 'Formosa', '福莫萨', 'formosa', 'ARG000FMA');
INSERT INTO `cities` VALUES (55, 6, 'IRJ', 'La Rioja', '拉里奥哈', 'la rioja', 'ARG000IRJ');
INSERT INTO `cities` VALUES (56, 6, 'JUJ', 'Jujuy', '胡胡伊', 'jujuy', 'ARG000JUJ');
INSERT INTO `cities` VALUES (57, 6, 'LPG', 'La Plata', '拉普拉塔', 'la plata', 'ARG000LPG');
INSERT INTO `cities` VALUES (58, 6, 'LUQ', 'San Luis', '圣路易斯', 'san luis', 'ARG000LUQ');
INSERT INTO `cities` VALUES (59, 6, 'MDQ', 'Mar del Plata', '马德普拉塔', 'mar del plata', 'ARG000MDQ');
INSERT INTO `cities` VALUES (60, 6, 'MDZ', 'Mendoza', '门多萨', 'mendoza', 'ARG000MDZ');
INSERT INTO `cities` VALUES (61, 6, 'NQN', 'Neuquen', '内乌肯', 'neuquen', 'ARG000NQN');
INSERT INTO `cities` VALUES (62, 6, 'PRA', 'Parana', '巴拉那', 'parana', 'ARG000PRA');
INSERT INTO `cities` VALUES (63, 6, 'PSS', 'Posadas', '波萨达斯', 'posadas', 'ARG000PSS');
INSERT INTO `cities` VALUES (64, 6, 'RCU', 'Rio Cuarto', '里奥夸尔托', 'rio cuarto', 'ARG000RCU');
INSERT INTO `cities` VALUES (65, 6, 'REL', 'Trelew', '特雷利乌', 'trelew', 'ARG000REL');
INSERT INTO `cities` VALUES (66, 6, 'RES', 'Resistencia', '雷西斯滕匹亚', 'resistencia', 'ARG000RES');
INSERT INTO `cities` VALUES (67, 6, 'RGL', 'Rio Gallegos', '里奥加耶戈斯', 'rio gallegos', 'ARG000RGL');
INSERT INTO `cities` VALUES (68, 6, 'ROS', 'Rosario', '罗萨里奥', 'rosario', 'ARG000ROS');
INSERT INTO `cities` VALUES (69, 6, 'RSA', 'Santa Rosa', '圣罗莎', 'santa rosa', 'ARG000RSA');
INSERT INTO `cities` VALUES (70, 6, 'RWO', 'Rawson', '罗森', 'rawson', 'ARG000RWO');
INSERT INTO `cities` VALUES (71, 6, 'SDE', 'Santiago del Estero', '圣地亚哥-德尔埃斯特罗', 'santiago del estero', 'ARG000SDE');
INSERT INTO `cities` VALUES (72, 6, 'SFN', 'Santa Fe', '圣菲', 'santa fe', 'ARG000SFN');
INSERT INTO `cities` VALUES (73, 6, 'SLA', 'Salta', '萨尔塔', 'salta', 'ARG000SLA');
INSERT INTO `cities` VALUES (74, 6, 'SMC', 'San Miguel de Tucuman', '圣米格尔-德图库曼', 'san miguel de tucuman', 'ARG000SMC');
INSERT INTO `cities` VALUES (75, 6, 'SNS', 'San Nicolas', '圣尼古拉斯', 'san nicolas', 'ARG000SNS');
INSERT INTO `cities` VALUES (76, 6, 'UAQ', 'San Juan', '圣胡安', 'san juan', 'ARG000UAQ');
INSERT INTO `cities` VALUES (77, 6, 'USH', 'Ushuaia', '乌斯怀亚', 'ushuaia', 'ARG000USH');
INSERT INTO `cities` VALUES (78, 6, 'VDM', 'Viedma', '别德马', 'viedma', 'ARG000VDM');
INSERT INTO `cities` VALUES (79, 6, 'VLK', 'Villa Krause', '克劳斯城', 'villa krause', 'ARG000VLK');
INSERT INTO `cities` VALUES (80, 7, 'AGT', 'Aragacotn', '阿拉加措特恩', 'aragacotn', 'ARM000AGT');
INSERT INTO `cities` VALUES (81, 7, 'ARA', 'Ararat', '阿拉拉特', 'ararat', 'ARM000ARA');
INSERT INTO `cities` VALUES (82, 7, 'ARM', 'Armavir', '阿尔马维尔', 'armavir', 'ARM000ARM');
INSERT INTO `cities` VALUES (83, 7, 'EVN', 'Yerevan', '埃里温市', 'yerevan', 'ARM000EVN');
INSERT INTO `cities` VALUES (84, 7, 'GEG', 'Gelarkunik', '格加尔库尼克', 'gelarkunik', 'ARM000GEG');
INSERT INTO `cities` VALUES (85, 7, 'KOT', 'Kotayk', '科泰克', 'kotayk', 'ARM000KOT');
INSERT INTO `cities` VALUES (86, 7, 'LOR', 'Lorri', '洛里', 'lorri', 'ARM000LOR');
INSERT INTO `cities` VALUES (87, 7, 'SHI', 'Shirak', '希拉克', 'shirak', 'ARM000SHI');
INSERT INTO `cities` VALUES (88, 7, 'SYU', 'Syunik', '休尼克', 'syunik', 'ARM000SYU');
INSERT INTO `cities` VALUES (89, 7, 'TAV', 'Tavus', '塔武什', 'tavus', 'ARM000TAV');
INSERT INTO `cities` VALUES (90, 7, 'VAY', 'VayocJor', '瓦约茨·佐尔', 'vayocjor', 'ARM000VAY');
INSERT INTO `cities` VALUES (91, 8, 'AAN', 'Aana', '阿纳', 'aana', 'ASM000AAN');
INSERT INTO `cities` VALUES (92, 8, 'AIT', 'Aigaile Tai', '艾加伊勒泰', 'aigaile tai', 'ASM000AIT');
INSERT INTO `cities` VALUES (93, 8, 'ATU', 'Atua', '阿图阿', 'atua', 'ASM000ATU');
INSERT INTO `cities` VALUES (94, 8, 'FAA', 'Faasaleleaga', '法塞莱莱阿加', 'faasaleleaga', 'ASM000FAA');
INSERT INTO `cities` VALUES (95, 8, 'GFG', 'Gagaifomauga', '加盖福毛加', 'gagaifomauga', 'ASM000GFG');
INSERT INTO `cities` VALUES (96, 8, 'GMG', 'Gagaemauga', '加加埃毛加', 'gagaemauga', 'ASM000GMG');
INSERT INTO `cities` VALUES (97, 8, 'PAL', 'Palauli', '帕劳利', 'palauli', 'ASM000PAL');
INSERT INTO `cities` VALUES (98, 8, 'SAT', 'Satupaitea', '萨图帕伊泰阿', 'satupaitea', 'ASM000SAT');
INSERT INTO `cities` VALUES (99, 8, 'SAV', 'Savaii', '萨瓦伊岛', 'savaii', 'ASM000SAV');
INSERT INTO `cities` VALUES (100, 8, 'TUA', 'Tuamasaga', '图阿马萨加', 'tuamasaga', 'ASM000TUA');
INSERT INTO `cities` VALUES (101, 8, 'UPO', 'Upolu', '乌波卢岛', 'upolu', 'ASM000UPO');
INSERT INTO `cities` VALUES (102, 8, 'VAF', 'Vaao Fonoti', '瓦奥福诺蒂', 'vaao fonoti', 'ASM000VAF');
INSERT INTO `cities` VALUES (103, 8, 'VAI', 'Vaisigano', '韦西加诺', 'vaisigano', 'ASM000VAI');
INSERT INTO `cities` VALUES (104, 9, 'DRW', 'Darwin', '达尔文', 'darwin', 'AUS0NTDRW');
INSERT INTO `cities` VALUES (105, 9, 'PAL', 'Palmerston North', '北帕默斯顿', 'palmerston north', 'AUS0NTPAL');
INSERT INTO `cities` VALUES (106, 10, 'ADL', 'Adelaide', '阿德莱德', 'adelaide', 'AUS0SAADL');
INSERT INTO `cities` VALUES (107, 10, 'MGB', 'Mount Gambier', '甘比亚山', 'mount gambier', 'AUS0SAMGB');
INSERT INTO `cities` VALUES (108, 10, 'MYB', 'Murray Bridge', '默里布里奇', 'murray bridge', 'AUS0SAMYB');
INSERT INTO `cities` VALUES (109, 10, 'PLO', 'Port Lincoln', '林肯港', 'port lincoln', 'AUS0SAPLO');
INSERT INTO `cities` VALUES (110, 10, 'PPI', 'Port Pirie', '皮里港', 'port pirie', 'AUS0SAPPI');
INSERT INTO `cities` VALUES (111, 10, 'PUG', 'Port Augusta', '奥古斯塔港', 'port augusta', 'AUS0SAPUG');
INSERT INTO `cities` VALUES (112, 10, 'VHA', 'Victor Harbor', '维克托港', 'victor harbor', 'AUS0SAVHA');
INSERT INTO `cities` VALUES (113, 10, 'WAY', 'Whyalla', '怀阿拉', 'whyalla', 'AUS0SAWAY');
INSERT INTO `cities` VALUES (114, 11, 'ALH', 'Albany', '奥尔巴尼', 'albany', 'AUS0WAALH');
INSERT INTO `cities` VALUES (115, 11, 'BUY', 'Bunbury', '班伯里', 'bunbury', 'AUS0WABUY');
INSERT INTO `cities` VALUES (116, 11, 'FRE', 'Fremantle', '弗里曼特尔港', 'fremantle', 'AUS0WAFRE');
INSERT INTO `cities` VALUES (117, 11, 'GET', 'Geraldton', '杰拉尔顿', 'geraldton', 'AUS0WAGET');
INSERT INTO `cities` VALUES (118, 11, 'KGI', 'Kalgoorlie', '卡尔古利', 'kalgoorlie', 'AUS0WAKGI');
INSERT INTO `cities` VALUES (119, 11, 'MDU', 'Mandurah', '曼哲拉', 'mandurah', 'AUS0WAMDU');
INSERT INTO `cities` VALUES (120, 11, 'PER', 'Perth', '珀斯', 'perth', 'AUS0WAPER');
INSERT INTO `cities` VALUES (121, 12, 'CBR', 'Canberra', '堪培拉', 'canberra', 'AUSACTCBR');
INSERT INTO `cities` VALUES (122, 13, 'HBS', 'Sydney', '悉尼', 'sydney', 'AUSNSWHBS');
INSERT INTO `cities` VALUES (123, 13, 'NTL', 'Newcastle', '纽卡斯尔', 'newcastle', 'AUSNSWNTL');
INSERT INTO `cities` VALUES (124, 13, 'WOL', 'Wollongong', '伍伦贡', 'wollongong', 'AUSNSWWOL');
INSERT INTO `cities` VALUES (125, 14, 'BNE', 'Brisbane', '布里斯班', 'brisbane', 'AUSQLDBNE');
INSERT INTO `cities` VALUES (126, 14, 'CNS', 'Cairns', '凯恩斯', 'cairns', 'AUSQLDCNS');
INSERT INTO `cities` VALUES (127, 14, 'CUD', 'Caloundra', '日光海岸', 'caloundra', 'AUSQLDCUD');
INSERT INTO `cities` VALUES (128, 14, 'OOL', 'Gold Coast', '黄金海岸', 'gold coast', 'AUSQLDOOL');
INSERT INTO `cities` VALUES (129, 14, 'TSV', 'Townsville', '汤斯维尔', 'townsville', 'AUSQLDTSV');
INSERT INTO `cities` VALUES (130, 14, 'TWB', 'Toowoomba', '图文巴', 'toowoomba', 'AUSQLDTWB');
INSERT INTO `cities` VALUES (131, 15, 'BWT', 'Burnie', '伯尼港', 'burnie', 'AUSTASBWT');
INSERT INTO `cities` VALUES (132, 15, 'DPO', 'Devonport', '德文波特', 'devonport', 'AUSTASDPO');
INSERT INTO `cities` VALUES (133, 15, 'HBA', 'Hobart', '霍巴特', 'hobart', 'AUSTASHBA');
INSERT INTO `cities` VALUES (134, 15, 'LST', 'Launceston', '朗塞斯顿', 'launceston', 'AUSTASLST');
INSERT INTO `cities` VALUES (135, 16, 'GEX', 'Geelong', '吉朗', 'geelong', 'AUSVICGEX');
INSERT INTO `cities` VALUES (136, 16, 'MEL', 'Melbourne', '墨尔本', 'melbourne', 'AUSVICMEL');
INSERT INTO `cities` VALUES (137, 17, 'BUR', 'Burgenland', '布尔根兰', 'burgenland', 'AUT000BUR');
INSERT INTO `cities` VALUES (138, 17, 'CAT', 'Carinthia', '克恩顿', 'carinthia', 'AUT000CAT');
INSERT INTO `cities` VALUES (139, 17, 'LAU', 'Lower Austria', '下奥地利', 'lower austria', 'AUT000LAU');
INSERT INTO `cities` VALUES (140, 17, 'STY', 'Styria', '施蒂利亚', 'styria', 'AUT000STY');
INSERT INTO `cities` VALUES (141, 17, 'SZG', 'Salzburg', '萨尔茨堡', 'salzburg', 'AUT000SZG');
INSERT INTO `cities` VALUES (142, 17, 'TYR', 'Tyrol', '蒂罗尔', 'tyrol', 'AUT000TYR');
INSERT INTO `cities` VALUES (143, 17, 'UAU', 'Upper Austria', '上奥地利', 'upper austria', 'AUT000UAU');
INSERT INTO `cities` VALUES (144, 17, 'VDD', 'Vienna', '维也纳', 'vienna', 'AUT000VDD');
INSERT INTO `cities` VALUES (145, 17, 'VOR', 'Vorarlberg', '福拉尔贝格', 'vorarlberg', 'AUT000VOR');
INSERT INTO `cities` VALUES (146, 18, 'GA', 'Ganca', '占贾', 'ganca', 'AZE0000GA');
INSERT INTO `cities` VALUES (147, 18, 'NX', 'Naxcivan', '纳希切万', 'naxcivan', 'AZE0000NX');
INSERT INTO `cities` VALUES (148, 18, 'SA', 'Saki', '舍基', 'saki', 'AZE0000SA');
INSERT INTO `cities` VALUES (149, 18, 'ABS', 'Abseron', '阿布歇隆', 'abseron', 'AZE000ABS');
INSERT INTO `cities` VALUES (150, 18, 'KAL', 'Kalbacar', '卡尔巴卡尔', 'kalbacar', 'AZE000KAL');
INSERT INTO `cities` VALUES (151, 18, 'LAN', 'Lankaran', '连科兰', 'lankaran', 'AZE000LAN');
INSERT INTO `cities` VALUES (152, 18, 'MQA', 'Mil-Qarabax', '密尔-卡拉巴赫', 'mil-qarabax', 'AZE000MQA');
INSERT INTO `cities` VALUES (153, 18, 'MSA', 'Mugan-Salyan', '穆甘-萨连', 'mugan-salyan', 'AZE000MSA');
INSERT INTO `cities` VALUES (154, 18, 'NQA', 'Nagorni-Qarabax', '纳戈尔诺-卡拉巴赫', 'nagorni-qarabax', 'AZE000NQA');
INSERT INTO `cities` VALUES (155, 18, 'PRI', 'Priaraks', '普利亚拉克斯', 'priaraks', 'AZE000PRI');
INSERT INTO `cities` VALUES (156, 18, 'QAZ', 'Qazax', '卡扎赫', 'qazax', 'AZE000QAZ');
INSERT INTO `cities` VALUES (157, 18, 'SIR', 'Sirvan', '锡尔万', 'sirvan', 'AZE000SIR');
INSERT INTO `cities` VALUES (158, 18, 'SMC', 'Sumqayit', '苏姆盖特', 'sumqayit', 'AZE000SMC');
INSERT INTO `cities` VALUES (159, 18, 'XAC', 'Xacmaz', '哈奇马斯', 'xacmaz', 'AZE000XAC');
INSERT INTO `cities` VALUES (160, 19, 'BB', 'Bubanza', '布班扎', 'bubanza', 'BDI0000BB');
INSERT INTO `cities` VALUES (161, 19, 'BM', 'Bujumbura Mairie', '布琼布拉城市', 'bujumbura mairie', 'BDI0000BM');
INSERT INTO `cities` VALUES (162, 19, 'BR', 'Bururi', '布鲁里', 'bururi', 'BDI0000BR');
INSERT INTO `cities` VALUES (163, 19, 'BU', 'Bujumbura Rural', '布琼布拉乡村', 'bujumbura rural', 'BDI0000BU');
INSERT INTO `cities` VALUES (164, 19, 'CA', 'Cankuzo', '坎库佐', 'cankuzo', 'BDI0000CA');
INSERT INTO `cities` VALUES (165, 19, 'CI', 'Cibitoke', '锡比托凯', 'cibitoke', 'BDI0000CI');
INSERT INTO `cities` VALUES (166, 19, 'GI', 'Gitega', '基特加', 'gitega', 'BDI0000GI');
INSERT INTO `cities` VALUES (167, 19, 'KI', 'Kirundo', '基龙多', 'kirundo', 'BDI0000KI');
INSERT INTO `cities` VALUES (168, 19, 'KR', 'Karuzi', '卡鲁济', 'karuzi', 'BDI0000KR');
INSERT INTO `cities` VALUES (169, 19, 'KY', 'Kayanza', '卡扬扎', 'kayanza', 'BDI0000KY');
INSERT INTO `cities` VALUES (170, 19, 'MA', 'Makamba', '马坎巴', 'makamba', 'BDI0000MA');
INSERT INTO `cities` VALUES (171, 19, 'MU', 'Muramvya', '穆拉姆维亚', 'muramvya', 'BDI0000MU');
INSERT INTO `cities` VALUES (172, 19, 'MW', 'Mwaro', '穆瓦洛', 'mwaro', 'BDI0000MW');
INSERT INTO `cities` VALUES (173, 19, 'MY', 'Muyinga', '穆因加', 'muyinga', 'BDI0000MY');
INSERT INTO `cities` VALUES (174, 19, 'NG', 'Ngozi', '恩戈齐', 'ngozi', 'BDI0000NG');
INSERT INTO `cities` VALUES (175, 19, 'RT', 'Rutana', '鲁塔纳', 'rutana', 'BDI0000RT');
INSERT INTO `cities` VALUES (176, 19, 'RY', 'Ruyigi', '鲁伊吉', 'ruyigi', 'BDI0000RY');
INSERT INTO `cities` VALUES (177, 20, 'BRU', 'Brussels', '布鲁塞尔', 'brussels', 'BEL000BRU');
INSERT INTO `cities` VALUES (178, 20, 'VAN', 'Antwerpen', '安特卫普', 'antwerpen', 'BEL000VAN');
INSERT INTO `cities` VALUES (179, 20, 'VBR', 'Vlaams-Brabant', '佛兰芒-布拉班特', 'vlaams-brabant', 'BEL000VBR');
INSERT INTO `cities` VALUES (180, 20, 'VLI', 'Limburg', '林堡', 'limburg', 'BEL000VLI');
INSERT INTO `cities` VALUES (181, 20, 'VOV', 'Oost-Vlaanderen', '东佛兰德', 'oost-vlaanderen', 'BEL000VOV');
INSERT INTO `cities` VALUES (182, 20, 'VWV', 'West-Vlaanderen', '西佛兰德', 'west-vlaanderen', 'BEL000VWV');
INSERT INTO `cities` VALUES (183, 20, 'WBR', 'Brabant-Wallone', '布拉班特-瓦隆', 'brabant-wallone', 'BEL000WBR');
INSERT INTO `cities` VALUES (184, 20, 'WHT', 'Hainaut', '埃诺', 'hainaut', 'BEL000WHT');
INSERT INTO `cities` VALUES (185, 20, 'WLG', 'Liege', '列日', 'liege', 'BEL000WLG');
INSERT INTO `cities` VALUES (186, 20, 'WLX', 'Luxembourg', '卢森堡', 'luxembourg', 'BEL000WLX');
INSERT INTO `cities` VALUES (187, 20, 'WNA', 'Namur', '那慕尔', 'namur', 'BEL000WNA');
INSERT INTO `cities` VALUES (188, 21, 'AK', 'Atakora', '阿塔科拉', 'atakora', 'BEN0000AK');
INSERT INTO `cities` VALUES (189, 21, 'AL', 'Alibori', '阿黎博里', 'alibori', 'BEN0000AL');
INSERT INTO `cities` VALUES (190, 21, 'AQ', 'Atlantique', '大西洋', 'atlantique', 'BEN0000AQ');
INSERT INTO `cities` VALUES (191, 21, 'BO', 'Borgou', '博尔古', 'borgou', 'BEN0000BO');
INSERT INTO `cities` VALUES (192, 21, 'CO', 'Collines', '丘陵', 'collines', 'BEN0000CO');
INSERT INTO `cities` VALUES (193, 21, 'DO', 'Donga', '峡谷', 'donga', 'BEN0000DO');
INSERT INTO `cities` VALUES (194, 21, 'KO', 'Kouffo', '库福', 'kouffo', 'BEN0000KO');
INSERT INTO `cities` VALUES (195, 21, 'LI', 'Littoral', '滨海', 'littoral', 'BEN0000LI');
INSERT INTO `cities` VALUES (196, 21, 'MO', 'Mono', '莫诺', 'mono', 'BEN0000MO');
INSERT INTO `cities` VALUES (197, 21, 'OU', 'Oueme', '韦梅', 'oueme', 'BEN0000OU');
INSERT INTO `cities` VALUES (198, 21, 'PL', 'Plateau', '高原', 'plateau', 'BEN0000PL');
INSERT INTO `cities` VALUES (199, 21, 'ZO', 'Zou', '祖', 'zou', 'BEN0000ZO');
INSERT INTO `cities` VALUES (200, 21, 'BOH', 'Bohicon', '波希康市', 'bohicon', 'BEN000BOH');
INSERT INTO `cities` VALUES (201, 22, 'BAL', 'Bale', '巴雷', 'bale', 'BFA000BAL');
INSERT INTO `cities` VALUES (202, 22, 'BAM', 'Bam', '巴姆', 'bam', 'BFA000BAM');
INSERT INTO `cities` VALUES (203, 22, 'BAN', 'Banwa', '巴瓦', 'banwa', 'BFA000BAN');
INSERT INTO `cities` VALUES (204, 22, 'BAZ', 'Bazega', '巴泽加', 'bazega', 'BFA000BAZ');
INSERT INTO `cities` VALUES (205, 22, 'BLG', 'Boulgou', '布尔古', 'boulgou', 'BFA000BLG');
INSERT INTO `cities` VALUES (206, 22, 'BOK', 'Boulkiemde', '布尔基恩德', 'boulkiemde', 'BFA000BOK');
INSERT INTO `cities` VALUES (207, 22, 'BOR', 'Bougouriba', '布古里巴', 'bougouriba', 'BFA000BOR');
INSERT INTO `cities` VALUES (208, 22, 'COM', 'Comoe', '科莫埃', 'comoe', 'BFA000COM');
INSERT INTO `cities` VALUES (209, 22, 'GAN', 'Ganzourgou', '冈祖尔古', 'ganzourgou', 'BFA000GAN');
INSERT INTO `cities` VALUES (210, 22, 'GNA', 'Gnagna', '尼亚尼亚', 'gnagna', 'BFA000GNA');
INSERT INTO `cities` VALUES (211, 22, 'GOU', 'Gourma', '古尔马', 'gourma', 'BFA000GOU');
INSERT INTO `cities` VALUES (212, 22, 'HOU', 'Houet', '乌埃', 'houet', 'BFA000HOU');
INSERT INTO `cities` VALUES (213, 22, 'IOA', 'Ioba', '伊奥巴', 'ioba', 'BFA000IOA');
INSERT INTO `cities` VALUES (214, 22, 'KAD', 'Kadiogo', '卡焦戈', 'kadiogo', 'BFA000KAD');
INSERT INTO `cities` VALUES (215, 22, 'KEN', 'Kenedougou', '凯内杜古', 'kenedougou', 'BFA000KEN');
INSERT INTO `cities` VALUES (216, 22, 'KOL', 'Koulpelogo', '库尔佩罗戈', 'koulpelogo', 'BFA000KOL');
INSERT INTO `cities` VALUES (217, 22, 'KOO', 'Komondjari', '科蒙加里', 'komondjari', 'BFA000KOO');
INSERT INTO `cities` VALUES (218, 22, 'KOP', 'Kompienga', '孔皮恩加', 'kompienga', 'BFA000KOP');
INSERT INTO `cities` VALUES (219, 22, 'KOS', 'Kossi', '孔西', 'kossi', 'BFA000KOS');
INSERT INTO `cities` VALUES (220, 22, 'KOT', 'Kouritenga', '库里滕加', 'kouritenga', 'BFA000KOT');
INSERT INTO `cities` VALUES (221, 22, 'KOW', 'Kourweogo', '库尔维奥戈', 'kourweogo', 'BFA000KOW');
INSERT INTO `cities` VALUES (222, 22, 'LER', 'Leraba', '雷拉巴', 'leraba', 'BFA000LER');
INSERT INTO `cities` VALUES (223, 22, 'LOR', 'Loroum', '罗卢姆', 'loroum', 'BFA000LOR');
INSERT INTO `cities` VALUES (224, 22, 'MOU', 'Mouhoun', '穆翁', 'mouhoun', 'BFA000MOU');
INSERT INTO `cities` VALUES (225, 22, 'NAH', 'Nahouri', '纳乌里', 'nahouri', 'BFA000NAH');
INSERT INTO `cities` VALUES (226, 22, 'NAM', 'Namentenga', '纳门滕加', 'namentenga', 'BFA000NAM');
INSERT INTO `cities` VALUES (227, 22, 'NAY', 'Nayala', '纳亚拉', 'nayala', 'BFA000NAY');
INSERT INTO `cities` VALUES (228, 22, 'NOU', 'Noumbiel', '努姆比埃尔', 'noumbiel', 'BFA000NOU');
INSERT INTO `cities` VALUES (229, 22, 'OUB', 'Oubritenga', '乌布里滕加', 'oubritenga', 'BFA000OUB');
INSERT INTO `cities` VALUES (230, 22, 'OUD', 'Oudalan', '乌达兰', 'oudalan', 'BFA000OUD');
INSERT INTO `cities` VALUES (231, 22, 'PAS', 'Passore', '帕索雷', 'passore', 'BFA000PAS');
INSERT INTO `cities` VALUES (232, 22, 'PON', 'Poni', '波尼', 'poni', 'BFA000PON');
INSERT INTO `cities` VALUES (233, 22, 'SAG', 'Sanguie', '桑吉', 'sanguie', 'BFA000SAG');
INSERT INTO `cities` VALUES (234, 22, 'SAM', 'Sanmatenga', '桑马滕加', 'sanmatenga', 'BFA000SAM');
INSERT INTO `cities` VALUES (235, 22, 'SEN', 'Seno', '塞诺', 'seno', 'BFA000SEN');
INSERT INTO `cities` VALUES (236, 22, 'SIS', 'Sissili', '锡西里', 'sissili', 'BFA000SIS');
INSERT INTO `cities` VALUES (237, 22, 'SOM', 'Soum', '苏姆', 'soum', 'BFA000SOM');
INSERT INTO `cities` VALUES (238, 22, 'SOR', 'Sourou', '苏鲁', 'sourou', 'BFA000SOR');
INSERT INTO `cities` VALUES (239, 22, 'TAP', 'Tapoa', '塔波阿', 'tapoa', 'BFA000TAP');
INSERT INTO `cities` VALUES (240, 22, 'TUY', 'Tuy', '图伊', 'tuy', 'BFA000TUY');
INSERT INTO `cities` VALUES (241, 22, 'YAG', 'Yagha', '亚加', 'yagha', 'BFA000YAG');
INSERT INTO `cities` VALUES (242, 22, 'YAT', 'Yatenga', '亚滕加', 'yatenga', 'BFA000YAT');
INSERT INTO `cities` VALUES (243, 22, 'ZIR', 'Ziro', '济罗', 'ziro', 'BFA000ZIR');
INSERT INTO `cities` VALUES (244, 22, 'ZOD', 'Zondoma', '宗多马', 'zondoma', 'BFA000ZOD');
INSERT INTO `cities` VALUES (245, 22, 'ZOW', 'Zoundweogo', '宗德韦奥戈', 'zoundweogo', 'BFA000ZOW');
INSERT INTO `cities` VALUES (246, 23, 'CGP', 'Chittagong', '吉大港', 'chittagong', 'BGD000CGP');
INSERT INTO `cities` VALUES (247, 23, 'DAC', 'Dhaka', '达卡', 'dhaka', 'BGD000DAC');
INSERT INTO `cities` VALUES (248, 23, 'KHL', 'Khulna', '库尔纳', 'khulna', 'BGD000KHL');
INSERT INTO `cities` VALUES (249, 24, 'BOJ', 'Burgas', '布尔加斯', 'burgas', 'BGR000BOJ');
INSERT INTO `cities` VALUES (250, 24, 'GSO', 'Grad Sofiya', '索非亚市', 'grad sofiya', 'BGR000GSO');
INSERT INTO `cities` VALUES (251, 24, 'KHO', 'Khaskovo', '卡斯科伏', 'khaskovo', 'BGR000KHO');
INSERT INTO `cities` VALUES (252, 24, 'LVP', 'Lovech', '洛维奇', 'lovech', 'BGR000LVP');
INSERT INTO `cities` VALUES (253, 24, 'OZA', 'Montana', '蒙塔纳', 'montana', 'BGR000OZA');
INSERT INTO `cities` VALUES (254, 24, 'PDV', 'Plovdiv', '普罗夫迪夫', 'plovdiv', 'BGR000PDV');
INSERT INTO `cities` VALUES (255, 24, 'ROU', 'Ruse', '鲁塞', 'ruse', 'BGR000ROU');
INSERT INTO `cities` VALUES (256, 24, 'SOF', 'Sofiya', '索非亚', 'sofiya', 'BGR000SOF');
INSERT INTO `cities` VALUES (257, 24, 'VAR', 'Varna', '瓦尔纳', 'varna', 'BGR000VAR');
INSERT INTO `cities` VALUES (258, 25, '1', 'Al-Hadd', '哈德', 'al-hadd', 'BHR000001');
INSERT INTO `cities` VALUES (259, 25, '2', 'Al-Muharraq', '穆哈拉格', 'al-muharraq', 'BHR000002');
INSERT INTO `cities` VALUES (260, 25, '3', 'Al-Manamah', '麦纳麦', 'al-manamah', 'BHR000003');
INSERT INTO `cities` VALUES (261, 25, '5', 'Northern', '北部', 'northern', 'BHR000005');
INSERT INTO `cities` VALUES (262, 25, '7', 'Al-Wusta', '中部', 'al-wusta', 'BHR000007');
INSERT INTO `cities` VALUES (263, 25, '8', 'Isa', '伊萨城', 'isa', 'BHR000008');
INSERT INTO `cities` VALUES (264, 25, '9', 'Ar-Rifa', '里法', 'ar-rifa', 'BHR000009');
INSERT INTO `cities` VALUES (265, 25, '10', 'Western', '西部', 'western', 'BHR000010');
INSERT INTO `cities` VALUES (266, 25, '12', 'Hammad', '哈马德', 'hammad', 'BHR000012');
INSERT INTO `cities` VALUES (267, 26, 'FBP', 'Bosansko-Podrinjski', '波斯尼亚-波德里涅', 'bosansko-podrinjski', 'BIH000FBP');
INSERT INTO `cities` VALUES (268, 26, 'FHB', 'Hercegovacko-Bosanski', '西波斯尼亚', 'hercegovacko-bosanski', 'BIH000FHB');
INSERT INTO `cities` VALUES (269, 26, 'FHN', 'Hercegovacko-Neretvanski', '黑塞哥维那-涅雷特瓦', 'hercegovacko-neretvanski', 'BIH000FHN');
INSERT INTO `cities` VALUES (270, 26, 'FPO', 'Posavski', '波萨维纳', 'posavski', 'BIH000FPO');
INSERT INTO `cities` VALUES (271, 26, 'FSA', 'Sarajevo', '萨拉热窝', 'sarajevo', 'BIH000FSA');
INSERT INTO `cities` VALUES (272, 26, 'FSB', 'Srednjo-Bosanski', '中波斯尼亚', 'srednjo-bosanski', 'BIH000FSB');
INSERT INTO `cities` VALUES (273, 26, 'FTO', 'Tomislavgrad', '多米斯拉夫格勒', 'tomislavgrad', 'BIH000FTO');
INSERT INTO `cities` VALUES (274, 26, 'FTU', 'Tuzlanski-Podrinjski', '图兹拉-波德里涅', 'tuzlanski-podrinjski', 'BIH000FTU');
INSERT INTO `cities` VALUES (275, 26, 'FUS', 'Unsko-Sanski', '乌纳-萨纳', 'unsko-sanski', 'BIH000FUS');
INSERT INTO `cities` VALUES (276, 26, 'FZE', 'Zenicko-Dobojski', '泽尼察-多博伊', 'zenicko-dobojski', 'BIH000FZE');
INSERT INTO `cities` VALUES (277, 26, 'FZH', 'Zapadno-Hercegovaki', '西黑塞哥维那', 'zapadno-hercegovaki', 'BIH000FZH');
INSERT INTO `cities` VALUES (278, 27, 'BR', 'Bresckaja', '布列斯特', 'bresckaja', 'BLR0000BR');
INSERT INTO `cities` VALUES (279, 27, 'HO', 'Homelskaja', '戈梅利', 'homelskaja', 'BLR0000HO');
INSERT INTO `cities` VALUES (280, 27, 'HR', 'Hrodzenskaja', '格罗德诺', 'hrodzenskaja', 'BLR0000HR');
INSERT INTO `cities` VALUES (281, 27, 'MA', 'Mahileuskaja', '莫吉廖夫', 'mahileuskaja', 'BLR0000MA');
INSERT INTO `cities` VALUES (282, 27, 'MI', 'Minsk', '明斯克市', 'minsk', 'BLR0000MI');
INSERT INTO `cities` VALUES (283, 27, 'VI', 'Vicebskaja', '维捷布斯克', 'vicebskaja', 'BLR0000VI');
INSERT INTO `cities` VALUES (284, 28, 'BZ', 'Belize', '伯利兹', 'belize', 'BLZ0000BZ');
INSERT INTO `cities` VALUES (285, 28, 'CR', 'Corozal', '科罗萨尔', 'corozal', 'BLZ0000CR');
INSERT INTO `cities` VALUES (286, 28, 'CY', 'Cayo', '卡约', 'cayo', 'BLZ0000CY');
INSERT INTO `cities` VALUES (287, 28, 'OW', 'Orange Walk', '橘园', 'orange walk', 'BLZ0000OW');
INSERT INTO `cities` VALUES (288, 28, 'SC', 'Stann Creek', '斯坦港', 'stann creek', 'BLZ0000SC');
INSERT INTO `cities` VALUES (289, 28, 'TO', 'Toledo', '托莱多', 'toledo', 'BLZ0000TO');
INSERT INTO `cities` VALUES (290, 29, 'ALT', 'El Alto', '奥尔托', 'el alto', 'BOL000ALT');
INSERT INTO `cities` VALUES (291, 29, 'BEN', 'El Beni', '贝尼', 'el beni', 'BOL000BEN');
INSERT INTO `cities` VALUES (292, 29, 'CBB', 'Cochabamba', '科恰班巴', 'cochabamba', 'BOL000CBB');
INSERT INTO `cities` VALUES (293, 29, 'CHU', 'Chuquisaca', '丘基萨卡', 'chuquisaca', 'BOL000CHU');
INSERT INTO `cities` VALUES (294, 29, 'LPB', 'La Paz', '拉巴斯', 'la paz', 'BOL000LPB');
INSERT INTO `cities` VALUES (295, 29, 'ORU', 'Oruro', '奥鲁罗', 'oruro', 'BOL000ORU');
INSERT INTO `cities` VALUES (296, 29, 'PAN', 'Pando', '潘多', 'pando', 'BOL000PAN');
INSERT INTO `cities` VALUES (297, 29, 'POI', 'Potosi', '波多西', 'potosi', 'BOL000POI');
INSERT INTO `cities` VALUES (298, 29, 'QUI', 'Quillacollo', '基拉科洛', 'quillacollo', 'BOL000QUI');
INSERT INTO `cities` VALUES (299, 29, 'SAC', 'Sacaba', '萨卡巴', 'sacaba', 'BOL000SAC');
INSERT INTO `cities` VALUES (300, 29, 'SRZ', 'Santa Cruz', '圣克鲁斯', 'santa cruz', 'BOL000SRZ');
INSERT INTO `cities` VALUES (301, 29, 'TJA', 'Tarija', '塔里哈', 'tarija', 'BOL000TJA');
INSERT INTO `cities` VALUES (302, 30, 'AC', 'Acre', '阿克里', 'acre', 'BRA0000AC');
INSERT INTO `cities` VALUES (303, 30, 'AL', 'Alagoas', '阿拉戈斯', 'alagoas', 'BRA0000AL');
INSERT INTO `cities` VALUES (304, 30, 'AM', 'Amazonas', '亚马孙', 'amazonas', 'BRA0000AM');
INSERT INTO `cities` VALUES (305, 30, 'AP', 'Amapa', '阿马帕', 'amapa', 'BRA0000AP');
INSERT INTO `cities` VALUES (306, 30, 'BA', 'Bahia', '巴伊亚', 'bahia', 'BRA0000BA');
INSERT INTO `cities` VALUES (307, 30, 'CE', 'Ceara', '塞阿拉', 'ceara', 'BRA0000CE');
INSERT INTO `cities` VALUES (308, 30, 'ES', 'Espirito Santo', '圣埃斯皮里图', 'espirito santo', 'BRA0000ES');
INSERT INTO `cities` VALUES (309, 30, 'GO', 'Goias', '戈亚斯', 'goias', 'BRA0000GO');
INSERT INTO `cities` VALUES (310, 30, 'MA', 'Maranhao', '马拉尼昂', 'maranhao', 'BRA0000MA');
INSERT INTO `cities` VALUES (311, 30, 'MG', 'Minas Gerais', '米纳斯吉拉斯', 'minas gerais', 'BRA0000MG');
INSERT INTO `cities` VALUES (312, 30, 'MS', 'Mato Grosso do Sul', '南马托格罗索', 'mato grosso do sul', 'BRA0000MS');
INSERT INTO `cities` VALUES (313, 30, 'MT', 'Mato Grosso', '马托格罗索', 'mato grosso', 'BRA0000MT');
INSERT INTO `cities` VALUES (314, 30, 'PA', 'Para', '帕拉', 'para', 'BRA0000PA');
INSERT INTO `cities` VALUES (315, 30, 'PB', 'Paraiba', '帕拉伊巴', 'paraiba', 'BRA0000PB');
INSERT INTO `cities` VALUES (316, 30, 'PE', 'Pernambuco', '伯南布哥', 'pernambuco', 'BRA0000PE');
INSERT INTO `cities` VALUES (317, 30, 'PI', 'Piaui', '皮奥伊', 'piaui', 'BRA0000PI');
INSERT INTO `cities` VALUES (318, 30, 'PR', 'Parana', '巴拉那', 'parana', 'BRA0000PR');
INSERT INTO `cities` VALUES (319, 30, 'RJ', 'Rio de Janeiro', '里约热内卢', 'rio de janeiro', 'BRA0000RJ');
INSERT INTO `cities` VALUES (320, 30, 'RN', 'Rio Grande do Norte', '北里奥格兰德', 'rio grande do norte', 'BRA0000RN');
INSERT INTO `cities` VALUES (321, 30, 'RO', 'Rondonia', '朗多尼亚', 'rondonia', 'BRA0000RO');
INSERT INTO `cities` VALUES (322, 30, 'RR', 'Roraima', '罗赖马', 'roraima', 'BRA0000RR');
INSERT INTO `cities` VALUES (323, 30, 'RS', 'Rio Grande do Sul', '南里奥格兰德', 'rio grande do sul', 'BRA0000RS');
INSERT INTO `cities` VALUES (324, 30, 'SC', 'Santa Catarina', '圣卡塔琳娜', 'santa catarina', 'BRA0000SC');
INSERT INTO `cities` VALUES (325, 30, 'SE', 'Sergipe', '塞尔希培', 'sergipe', 'BRA0000SE');
INSERT INTO `cities` VALUES (326, 30, 'SP', 'Sao Paulo', '圣保罗', 'sao paulo', 'BRA0000SP');
INSERT INTO `cities` VALUES (327, 30, 'TO', 'Tocantins', '托坎廷斯', 'tocantins', 'BRA0000TO');
INSERT INTO `cities` VALUES (328, 30, 'BSB', 'Brasilia', '巴西利亚', 'brasilia', 'BRA000BSB');
INSERT INTO `cities` VALUES (329, 31, 'AC', 'Ouham', '瓦姆', 'ouham', 'CAF0000AC');
INSERT INTO `cities` VALUES (330, 31, 'BB', 'Bamingui-Bangoran', '巴明吉-班戈兰', 'bamingui-bangoran', 'CAF0000BB');
INSERT INTO `cities` VALUES (331, 31, 'BI', 'Bimbo', '宾博', 'bimbo', 'CAF0000BI');
INSERT INTO `cities` VALUES (332, 31, 'BK', 'Basse-Kotto', '下科托', 'basse-kotto', 'CAF0000BK');
INSERT INTO `cities` VALUES (333, 31, 'HK', 'Haute-Kotto', '上科托', 'haute-kotto', 'CAF0000HK');
INSERT INTO `cities` VALUES (334, 31, 'HM', 'Haut-Mbomou', '上姆博穆', 'haut-mbomou', 'CAF0000HM');
INSERT INTO `cities` VALUES (335, 31, 'HS', 'Mambere-Kadei', '曼贝雷-卡代', 'mambere-kadei', 'CAF0000HS');
INSERT INTO `cities` VALUES (336, 31, 'KB', 'Nana-Gribizi', '纳纳-格里比齐', 'nana-gribizi', 'CAF0000KB');
INSERT INTO `cities` VALUES (337, 31, 'KG', 'Kemo', '凯莫', 'kemo', 'CAF0000KG');
INSERT INTO `cities` VALUES (338, 31, 'LB', 'Lobaye', '洛巴伊', 'lobaye', 'CAF0000LB');
INSERT INTO `cities` VALUES (339, 31, 'MB', 'Mbomou', '姆博穆', 'mbomou', 'CAF0000MB');
INSERT INTO `cities` VALUES (340, 31, 'MP', 'Ombella-Mpoko', '翁贝拉-姆波科', 'ombella-mpoko', 'CAF0000MP');
INSERT INTO `cities` VALUES (341, 31, 'NM', 'Nana-Mambere', '纳纳-曼贝雷', 'nana-mambere', 'CAF0000NM');
INSERT INTO `cities` VALUES (342, 31, 'OP', 'Ouham-Pende', '瓦姆-彭代', 'ouham-pende', 'CAF0000OP');
INSERT INTO `cities` VALUES (343, 31, 'SE', 'Sangha-Mbaere', '桑加-姆巴埃雷', 'sangha-mbaere', 'CAF0000SE');
INSERT INTO `cities` VALUES (344, 31, 'UK', 'Ouaka', '瓦卡', 'ouaka', 'CAF0000UK');
INSERT INTO `cities` VALUES (345, 31, 'VK', 'Vakaga', '瓦卡加', 'vakaga', 'CAF0000VK');
INSERT INTO `cities` VALUES (346, 31, 'BGF', 'Bangui', '班吉直辖市', 'bangui', 'CAF000BGF');
INSERT INTO `cities` VALUES (347, 32, 'ABB', 'Abbotsford', '阿伯茨福', 'abbotsford', 'CAN000ABB');
INSERT INTO `cities` VALUES (348, 32, 'BAR', 'Barrie', '巴里', 'barrie', 'CAN000BAR');
INSERT INTO `cities` VALUES (349, 32, 'BRP', 'Brampton', '基奇纳', 'brampton', 'CAN000BRP');
INSERT INTO `cities` VALUES (350, 32, 'CAL', 'Calgary', '卡里加里', 'calgary', 'CAN000CAL');
INSERT INTO `cities` VALUES (351, 32, 'CBR', 'Cape Breton', '布列塔尼角', 'cape breton', 'CAN000CBR');
INSERT INTO `cities` VALUES (352, 32, 'CHA', 'Charlottetown', '夏洛特敦', 'charlottetown', 'CAN000CHA');
INSERT INTO `cities` VALUES (353, 32, 'EDM', 'Edmonton', '埃德蒙顿', 'edmonton', 'CAN000EDM');
INSERT INTO `cities` VALUES (354, 32, 'FRE', 'Fredericton', '弗雷德里顿', 'fredericton', 'CAN000FRE');
INSERT INTO `cities` VALUES (355, 32, 'GLP', 'Guelph', '圭尔夫', 'guelph', 'CAN000GLP');
INSERT INTO `cities` VALUES (356, 32, 'HAL', 'Halifax', '哈利法克斯', 'halifax', 'CAN000HAL');
INSERT INTO `cities` VALUES (357, 32, 'HAM', 'Hamilton', '哈密尔顿', 'hamilton', 'CAN000HAM');
INSERT INTO `cities` VALUES (358, 32, 'IQL', 'Iqaluit', '伊魁特', 'iqaluit', 'CAN000IQL');
INSERT INTO `cities` VALUES (359, 32, 'KGN', 'Kingston', '金斯敦', 'kingston', 'CAN000KGN');
INSERT INTO `cities` VALUES (360, 32, 'KWL', 'Kelowna', '基劳纳', 'kelowna', 'CAN000KWL');
INSERT INTO `cities` VALUES (361, 32, 'LOD', 'London', '伦敦', 'london', 'CAN000LOD');
INSERT INTO `cities` VALUES (362, 32, 'MTR', 'Montreal', '蒙特利尔', 'montreal', 'CAN000MTR');
INSERT INTO `cities` VALUES (363, 32, 'OSH', 'Oshawa', '奥沙瓦', 'oshawa', 'CAN000OSH');
INSERT INTO `cities` VALUES (364, 32, 'OTT', 'Ottawa', '渥太华', 'ottawa', 'CAN000OTT');
INSERT INTO `cities` VALUES (365, 32, 'QUE', 'Quebec', '魁北克', 'quebec', 'CAN000QUE');
INSERT INTO `cities` VALUES (366, 32, 'REG', 'Regina', '里贾纳', 'regina', 'CAN000REG');
INSERT INTO `cities` VALUES (367, 32, 'SAK', 'Saskatoon', '萨斯卡通', 'saskatoon', 'CAN000SAK');
INSERT INTO `cities` VALUES (368, 32, 'SBE', 'Sherbrooke', '舍布鲁克', 'sherbrooke', 'CAN000SBE');
INSERT INTO `cities` VALUES (369, 32, 'SCA', 'Santa Catarina', '圣卡塔琳娜', 'santa catarina', 'CAN000SCA');
INSERT INTO `cities` VALUES (370, 32, 'SJB', 'Saint-John\'s', '圣约翰斯', 'saint-john\'s', 'CAN000SJB');
INSERT INTO `cities` VALUES (371, 32, 'SUD', 'Sudbury', '萨德伯里', 'sudbury', 'CAN000SUD');
INSERT INTO `cities` VALUES (372, 32, 'THU', 'Thunder Bay', '桑德贝', 'thunder bay', 'CAN000THU');
INSERT INTO `cities` VALUES (373, 32, 'TOR', 'Toronto', '多伦多', 'toronto', 'CAN000TOR');
INSERT INTO `cities` VALUES (374, 32, 'TRR', 'Trois-Rivieres', '三河城', 'trois-rivieres', 'CAN000TRR');
INSERT INTO `cities` VALUES (375, 32, 'VAN', 'Vancouver', '温哥华', 'vancouver', 'CAN000VAN');
INSERT INTO `cities` VALUES (376, 32, 'VIC', 'Victoria', '维多利亚', 'victoria', 'CAN000VIC');
INSERT INTO `cities` VALUES (377, 32, 'WDR', 'Windsor', '温莎', 'windsor', 'CAN000WDR');
INSERT INTO `cities` VALUES (378, 32, 'WNP', 'Winnipeg', '温尼伯', 'winnipeg', 'CAN000WNP');
INSERT INTO `cities` VALUES (379, 32, 'YXY', 'Whitehorse', '怀特霍斯', 'whitehorse', 'CAN000YXY');
INSERT INTO `cities` VALUES (380, 32, 'YZF', 'Yellowknife', '耶洛奈夫', 'yellowknife', 'CAN000YZF');
INSERT INTO `cities` VALUES (381, 33, 'AG', 'Aargau', '阿尔高', 'aargau', 'CHE0000AG');
INSERT INTO `cities` VALUES (382, 33, 'AI', 'Appenzell Innerrhodn', '内阿彭策尔', 'appenzell innerrhodn', 'CHE0000AI');
INSERT INTO `cities` VALUES (383, 33, 'AR', 'Appenzell Ausserrhon', '外阿彭策尔', 'appenzell ausserrhon', 'CHE0000AR');
INSERT INTO `cities` VALUES (384, 33, 'BE', 'Bern', '伯尔尼', 'bern', 'CHE0000BE');
INSERT INTO `cities` VALUES (385, 33, 'BL', 'Basel Landschaft', '巴塞尔乡村', 'basel landschaft', 'CHE0000BL');
INSERT INTO `cities` VALUES (386, 33, 'BS', 'Basel-Sstadt', '巴塞尔城市', 'basel-sstadt', 'CHE0000BS');
INSERT INTO `cities` VALUES (387, 33, 'FR', 'Freiburg', '弗里堡', 'freiburg', 'CHE0000FR');
INSERT INTO `cities` VALUES (388, 33, 'GE', 'Geneve', '日内瓦', 'geneve', 'CHE0000GE');
INSERT INTO `cities` VALUES (389, 33, 'GL', 'Glarus', '格拉鲁斯', 'glarus', 'CHE0000GL');
INSERT INTO `cities` VALUES (390, 33, 'GR', 'Graubünden', '格劳宾登', 'graubünden', 'CHE0000GR');
INSERT INTO `cities` VALUES (391, 33, 'JU', 'Jura', '汝拉', 'jura', 'CHE0000JU');
INSERT INTO `cities` VALUES (392, 33, 'LA', 'Lausanne', '洛桑', 'lausanne', 'CHE0000LA');
INSERT INTO `cities` VALUES (393, 33, 'LU', 'Luzern', '卢塞恩', 'luzern', 'CHE0000LU');
INSERT INTO `cities` VALUES (394, 33, 'NE', 'Neuchatel', '纳沙泰尔', 'neuchatel', 'CHE0000NE');
INSERT INTO `cities` VALUES (395, 33, 'NW', 'Nidwalden', '下瓦尔登', 'nidwalden', 'CHE0000NW');
INSERT INTO `cities` VALUES (396, 33, 'OW', 'Obwalden', '上瓦尔登', 'obwalden', 'CHE0000OW');
INSERT INTO `cities` VALUES (397, 33, 'SG', 'St.Gallen', '圣加仑', 'st.gallen', 'CHE0000SG');
INSERT INTO `cities` VALUES (398, 33, 'SH', 'Schaffhausen', '沙夫豪森', 'schaffhausen', 'CHE0000SH');
INSERT INTO `cities` VALUES (399, 33, 'SO', 'Solothurn', '索洛图恩', 'solothurn', 'CHE0000SO');
INSERT INTO `cities` VALUES (400, 33, 'SZ', 'Schwyz', '施维茨', 'schwyz', 'CHE0000SZ');
INSERT INTO `cities` VALUES (401, 33, 'TG', 'Thurgau', '图尔高', 'thurgau', 'CHE0000TG');
INSERT INTO `cities` VALUES (402, 33, 'TI', 'Ticino', '提契诺', 'ticino', 'CHE0000TI');
INSERT INTO `cities` VALUES (403, 33, 'UR', 'Uri', '乌里', 'uri', 'CHE0000UR');
INSERT INTO `cities` VALUES (404, 33, 'VD', 'Vaud', '沃', 'vaud', 'CHE0000VD');
INSERT INTO `cities` VALUES (405, 33, 'VS', 'Wallis', '瓦莱', 'wallis', 'CHE0000VS');
INSERT INTO `cities` VALUES (406, 33, 'ZG', 'Zug', '楚格', 'zug', 'CHE0000ZG');
INSERT INTO `cities` VALUES (407, 33, 'ZH', 'Zurich', '苏黎世', 'zurich', 'CHE0000ZH');
INSERT INTO `cities` VALUES (408, 34, 'AI', 'Region de Alsen del General Carlos Ibanez del', '伊瓦涅斯将军的艾森大区', 'region de alsen del general carlos ibanez del', 'CHL0000AI');
INSERT INTO `cities` VALUES (409, 34, 'AN', 'Region de Antofagasta', '安托法加斯塔大区', 'region de antofagasta', 'CHL0000AN');
INSERT INTO `cities` VALUES (410, 34, 'AR', 'Region de la Araucania', '阿劳卡尼亚大区', 'region de la araucania', 'CHL0000AR');
INSERT INTO `cities` VALUES (411, 34, 'AT', 'Region de Atacama', '阿塔卡马大区', 'region de atacama', 'CHL0000AT');
INSERT INTO `cities` VALUES (412, 34, 'BI', 'Region del Biobio', '比奥比奥大区', 'region del biobio', 'CHL0000BI');
INSERT INTO `cities` VALUES (413, 34, 'CO', 'Region de Coquimbo', '科金博大区', 'region de coquimbo', 'CHL0000CO');
INSERT INTO `cities` VALUES (414, 34, 'LI', 'Libertador', '复活节岛', 'libertador', 'CHL0000LI');
INSERT INTO `cities` VALUES (415, 34, 'LL', 'Region de los Lagos', '湖大区', 'region de los lagos', 'CHL0000LL');
INSERT INTO `cities` VALUES (416, 34, 'MA', 'Magallanes y Antartica Chilena', '麦哲伦-智利南极大区', 'magallanes y antartica chilena', 'CHL0000MA');
INSERT INTO `cities` VALUES (417, 34, 'ML', 'Region del Maule', '马乌莱大区', 'region del maule', 'CHL0000ML');
INSERT INTO `cities` VALUES (418, 34, 'RM', 'Santiago de Cuba', '圣地亚哥', 'santiago de cuba', 'CHL0000RM');
INSERT INTO `cities` VALUES (419, 34, 'TA', 'Region de Tarapaca', '塔拉帕卡大区', 'region de tarapaca', 'CHL0000TA');
INSERT INTO `cities` VALUES (420, 34, 'VS', 'Region de Valparaiso', '瓦尔帕莱索大区', 'region de valparaiso', 'CHL0000VS');
INSERT INTO `cities` VALUES (421, 35, '1', 'Dongcheng', '东城', 'dongcheng', 'CHN011001');
INSERT INTO `cities` VALUES (422, 35, '2', 'Xicheng', '西城', 'xicheng', 'CHN011002');
INSERT INTO `cities` VALUES (423, 35, '5', 'Chaoyang', '朝阳', 'chaoyang', 'CHN011005');
INSERT INTO `cities` VALUES (424, 35, '6', 'Fengtai', '丰台', 'fengtai', 'CHN011006');
INSERT INTO `cities` VALUES (425, 35, '7', 'Shijingshan', '石景山', 'shijingshan', 'CHN011007');
INSERT INTO `cities` VALUES (426, 35, '8', 'Haidian', '海淀', 'haidian', 'CHN011008');
INSERT INTO `cities` VALUES (427, 35, '9', 'Mentougou', '门头沟', 'mentougou', 'CHN011009');
INSERT INTO `cities` VALUES (428, 35, '11', 'Fangshan', '房山', 'fangshan', 'CHN011011');
INSERT INTO `cities` VALUES (429, 35, '12', 'Tongzhou', '通州', 'tongzhou', 'CHN011012');
INSERT INTO `cities` VALUES (430, 35, '13', 'Shunyi', '顺义', 'shunyi', 'CHN011013');
INSERT INTO `cities` VALUES (431, 35, '21', 'Changping', '昌平', 'changping', 'CHN011021');
INSERT INTO `cities` VALUES (432, 35, '24', 'Daxing', '大兴', 'daxing', 'CHN011024');
INSERT INTO `cities` VALUES (433, 35, '26', 'Pinggu', '平谷', 'pinggu', 'CHN011026');
INSERT INTO `cities` VALUES (434, 35, '27', 'Huairou', '怀柔', 'huairou', 'CHN011027');
INSERT INTO `cities` VALUES (435, 35, '28', 'Miyun', '密云', 'miyun', 'CHN011028');
INSERT INTO `cities` VALUES (436, 35, '29', 'Yanqing', '延庆', 'yanqing', 'CHN011029');
INSERT INTO `cities` VALUES (437, 36, '1', 'Heping', '和平', 'heping', 'CHN012001');
INSERT INTO `cities` VALUES (438, 36, '2', 'Hedong', '河东', 'hedong', 'CHN012002');
INSERT INTO `cities` VALUES (439, 36, '3', 'Hexi', '河西', 'hexi', 'CHN012003');
INSERT INTO `cities` VALUES (440, 36, '4', 'Nankai', '南开', 'nankai', 'CHN012004');
INSERT INTO `cities` VALUES (441, 36, '5', 'Hebei', '河北', 'hebei', 'CHN012005');
INSERT INTO `cities` VALUES (442, 36, '6', 'Hongqiao', '红桥', 'hongqiao', 'CHN012006');
INSERT INTO `cities` VALUES (443, 36, '10', 'Dongli', '东丽', 'dongli', 'CHN012010');
INSERT INTO `cities` VALUES (444, 36, '11', 'Xiqing', '西青', 'xiqing', 'CHN012011');
INSERT INTO `cities` VALUES (445, 36, '12', 'Jinnan', '津南', 'jinnan', 'CHN012012');
INSERT INTO `cities` VALUES (446, 36, '13', 'Beichen', '北辰', 'beichen', 'CHN012013');
INSERT INTO `cities` VALUES (447, 36, '21', 'Ninghe', '宁河', 'ninghe', 'CHN012021');
INSERT INTO `cities` VALUES (448, 36, '22', 'Wuqing', '武清', 'wuqing', 'CHN012022');
INSERT INTO `cities` VALUES (449, 36, '23', 'Jinghai', '静海', 'jinghai', 'CHN012023');
INSERT INTO `cities` VALUES (450, 36, '24', 'Baodi', '宝坻', 'baodi', 'CHN012024');
INSERT INTO `cities` VALUES (451, 36, '25', 'Jixian', '蓟县', 'jixian', 'CHN012025');
INSERT INTO `cities` VALUES (452, 36, '26', 'Binghaixinqu', '滨海新区', 'binghaixinqu', 'CHN012026');
INSERT INTO `cities` VALUES (453, 37, '1', 'Shijiazhuang', '石家庄', 'shijiazhuang', 'CHN013001');
INSERT INTO `cities` VALUES (454, 37, '2', 'Tangshan', '唐山', 'tangshan', 'CHN013002');
INSERT INTO `cities` VALUES (455, 37, '3', 'Qinhuangdao', '秦皇岛', 'qinhuangdao', 'CHN013003');
INSERT INTO `cities` VALUES (456, 37, '4', 'Handan', '邯郸', 'handan', 'CHN013004');
INSERT INTO `cities` VALUES (457, 37, '5', 'Xingtai', '邢台', 'xingtai', 'CHN013005');
INSERT INTO `cities` VALUES (458, 37, '6', 'Baoding', '保定', 'baoding', 'CHN013006');
INSERT INTO `cities` VALUES (459, 37, '7', 'Zhangjiakou', '张家口', 'zhangjiakou', 'CHN013007');
INSERT INTO `cities` VALUES (460, 37, '8', 'Chengde', '承德', 'chengde', 'CHN013008');
INSERT INTO `cities` VALUES (461, 37, '9', 'Cangzhou', '沧州', 'cangzhou', 'CHN013009');
INSERT INTO `cities` VALUES (462, 37, '10', 'Langfang', '廊坊', 'langfang', 'CHN013010');
INSERT INTO `cities` VALUES (463, 37, '11', 'Hengshui', '衡水', 'hengshui', 'CHN013011');
INSERT INTO `cities` VALUES (464, 38, '1', 'Taiyuan', '太原', 'taiyuan', 'CHN014001');
INSERT INTO `cities` VALUES (465, 38, '2', 'Datong', '大同', 'datong', 'CHN014002');
INSERT INTO `cities` VALUES (466, 38, '3', 'Yangquan', '阳泉', 'yangquan', 'CHN014003');
INSERT INTO `cities` VALUES (467, 38, '4', 'Changzhi', '长治', 'changzhi', 'CHN014004');
INSERT INTO `cities` VALUES (468, 38, '5', 'Jincheng', '晋城', 'jincheng', 'CHN014005');
INSERT INTO `cities` VALUES (469, 38, '6', 'Shuozhou', '朔州', 'shuozhou', 'CHN014006');
INSERT INTO `cities` VALUES (470, 38, '7', 'Jinzhong', '晋中', 'jinzhong', 'CHN014007');
INSERT INTO `cities` VALUES (471, 38, '8', 'Yuncheng', '运城', 'yuncheng', 'CHN014008');
INSERT INTO `cities` VALUES (472, 38, '9', 'Xinzhou', '忻州', 'xinzhou', 'CHN014009');
INSERT INTO `cities` VALUES (473, 38, '10', 'Linfen', '临汾', 'linfen', 'CHN014010');
INSERT INTO `cities` VALUES (474, 38, '11', 'luliang', '吕梁', 'luliang', 'CHN014011');
INSERT INTO `cities` VALUES (475, 39, '1', 'Hohhot', '呼和浩特', 'hohhot', 'CHN015001');
INSERT INTO `cities` VALUES (476, 39, '2', 'Baotou', '包头', 'baotou', 'CHN015002');
INSERT INTO `cities` VALUES (477, 39, '3', 'Wuhai', '乌海', 'wuhai', 'CHN015003');
INSERT INTO `cities` VALUES (478, 39, '4', 'Chifeng', '赤峰', 'chifeng', 'CHN015004');
INSERT INTO `cities` VALUES (479, 39, '5', 'Tongliao', '通辽', 'tongliao', 'CHN015005');
INSERT INTO `cities` VALUES (480, 39, '6', 'Ordos', '鄂尔多斯', 'ordos', 'CHN015006');
INSERT INTO `cities` VALUES (481, 39, '7', 'Hulun Buir', '呼伦贝尔', 'hulun buir', 'CHN015007');
INSERT INTO `cities` VALUES (482, 39, '8', 'Bayannur', '巴彦淖尔', 'bayannur', 'CHN015008');
INSERT INTO `cities` VALUES (483, 39, '9', 'Ulan Qab', '乌兰察布', 'ulan qab', 'CHN015009');
INSERT INTO `cities` VALUES (484, 39, '22', 'Xing\'an', '兴安', 'xing\'an', 'CHN015022');
INSERT INTO `cities` VALUES (485, 39, '25', 'Xilin Gol', '锡林郭勒', 'xilin gol', 'CHN015025');
INSERT INTO `cities` VALUES (486, 39, '29', 'Alxa', '阿拉善', 'alxa', 'CHN015029');
INSERT INTO `cities` VALUES (487, 40, '1', 'Shenyang', '沈阳', 'shenyang', 'CHN021001');
INSERT INTO `cities` VALUES (488, 40, '2', 'Dalian', '大连', 'dalian', 'CHN021002');
INSERT INTO `cities` VALUES (489, 40, '3', 'Anshan', '鞍山', 'anshan', 'CHN021003');
INSERT INTO `cities` VALUES (490, 40, '4', 'Fushun', '抚顺', 'fushun', 'CHN021004');
INSERT INTO `cities` VALUES (491, 40, '5', 'Benxi', '本溪', 'benxi', 'CHN021005');
INSERT INTO `cities` VALUES (492, 40, '6', 'Dandong', '丹东', 'dandong', 'CHN021006');
INSERT INTO `cities` VALUES (493, 40, '7', 'Jinzhou', '锦州', 'jinzhou', 'CHN021007');
INSERT INTO `cities` VALUES (494, 40, '8', 'Yingkou', '营口', 'yingkou', 'CHN021008');
INSERT INTO `cities` VALUES (495, 40, '9', 'Fuxin', '阜新', 'fuxin', 'CHN021009');
INSERT INTO `cities` VALUES (496, 40, '10', 'Liaoyang', '辽阳', 'liaoyang', 'CHN021010');
INSERT INTO `cities` VALUES (497, 40, '11', 'Panjin', '盘锦', 'panjin', 'CHN021011');
INSERT INTO `cities` VALUES (498, 40, '12', 'Tieling', '铁岭', 'tieling', 'CHN021012');
INSERT INTO `cities` VALUES (499, 40, '13', 'Chaoyang', '朝阳', 'chaoyang', 'CHN021013');
INSERT INTO `cities` VALUES (500, 40, '14', 'Huludao', '葫芦岛', 'huludao', 'CHN021014');
INSERT INTO `cities` VALUES (501, 41, '1', 'Changchun', '长春', 'changchun', 'CHN022001');
INSERT INTO `cities` VALUES (502, 41, '2', 'Jilin', '吉林', 'jilin', 'CHN022002');
INSERT INTO `cities` VALUES (503, 41, '3', 'Siping', '四平', 'siping', 'CHN022003');
INSERT INTO `cities` VALUES (504, 41, '4', 'Liaoyuan', '辽源', 'liaoyuan', 'CHN022004');
INSERT INTO `cities` VALUES (505, 41, '5', 'Tonghua', '通化', 'tonghua', 'CHN022005');
INSERT INTO `cities` VALUES (506, 41, '6', 'Baishan', '白山', 'baishan', 'CHN022006');
INSERT INTO `cities` VALUES (507, 41, '7', 'Songyuan', '松原', 'songyuan', 'CHN022007');
INSERT INTO `cities` VALUES (508, 41, '8', 'Baicheng', '白城', 'baicheng', 'CHN022008');
INSERT INTO `cities` VALUES (509, 41, '24', 'Yanbian Korean Autonomous Prefecture', '延边', 'yanbian korean autonomous prefecture', 'CHN022024');
INSERT INTO `cities` VALUES (510, 42, '1', 'Harbin', '哈尔滨', 'harbin', 'CHN023001');
INSERT INTO `cities` VALUES (511, 42, '2', 'Qiqihar', '齐齐哈尔', 'qiqihar', 'CHN023002');
INSERT INTO `cities` VALUES (512, 42, '3', 'Jixi', '鸡西', 'jixi', 'CHN023003');
INSERT INTO `cities` VALUES (513, 42, '4', 'Hegang', '鹤岗', 'hegang', 'CHN023004');
INSERT INTO `cities` VALUES (514, 42, '5', 'Shuangyashan', '双鸭山', 'shuangyashan', 'CHN023005');
INSERT INTO `cities` VALUES (515, 42, '6', 'Daqing', '大庆', 'daqing', 'CHN023006');
INSERT INTO `cities` VALUES (516, 42, '7', 'Yichun', '伊春', 'yichun', 'CHN023007');
INSERT INTO `cities` VALUES (517, 42, '8', 'Jiamusi', '佳木斯', 'jiamusi', 'CHN023008');
INSERT INTO `cities` VALUES (518, 42, '9', 'Qitaihe', '七台河', 'qitaihe', 'CHN023009');
INSERT INTO `cities` VALUES (519, 42, '10', 'Mudanjiang', '牡丹江', 'mudanjiang', 'CHN023010');
INSERT INTO `cities` VALUES (520, 42, '11', 'Heihe', '黑河', 'heihe', 'CHN023011');
INSERT INTO `cities` VALUES (521, 42, '12', 'Suihua', '绥化', 'suihua', 'CHN023012');
INSERT INTO `cities` VALUES (522, 42, '27', 'Da Hinggan Ling', '大兴安岭', 'da hinggan ling', 'CHN023027');
INSERT INTO `cities` VALUES (523, 43, '1', 'Huangpu', '黄浦', 'huangpu', 'CHN031001');
INSERT INTO `cities` VALUES (524, 43, '3', 'Luwan', '卢湾', 'luwan', 'CHN031003');
INSERT INTO `cities` VALUES (525, 43, '4', 'Xuhui', '徐汇', 'xuhui', 'CHN031004');
INSERT INTO `cities` VALUES (526, 43, '5', 'Changning', '长宁', 'changning', 'CHN031005');
INSERT INTO `cities` VALUES (527, 43, '6', 'Jing\'an', '静安', 'jing\'an', 'CHN031006');
INSERT INTO `cities` VALUES (528, 43, '7', 'Putuo', '普陀', 'putuo', 'CHN031007');
INSERT INTO `cities` VALUES (529, 43, '8', 'Zhabei', '闸北', 'zhabei', 'CHN031008');
INSERT INTO `cities` VALUES (530, 43, '9', 'Hongkou', '虹口', 'hongkou', 'CHN031009');
INSERT INTO `cities` VALUES (531, 43, '11', 'Yangpu', '杨浦', 'yangpu', 'CHN031011');
INSERT INTO `cities` VALUES (532, 43, '12', 'Minhang', '闵行', 'minhang', 'CHN031012');
INSERT INTO `cities` VALUES (533, 43, '13', 'Baoshan', '宝山', 'baoshan', 'CHN031013');
INSERT INTO `cities` VALUES (534, 43, '14', 'Jiading', '嘉定', 'jiading', 'CHN031014');
INSERT INTO `cities` VALUES (535, 43, '15', 'Pudong New Area', '浦东新区', 'pudong new area', 'CHN031015');
INSERT INTO `cities` VALUES (536, 43, '16', 'Jinshan', '金山', 'jinshan', 'CHN031016');
INSERT INTO `cities` VALUES (537, 43, '17', 'Songjiang', '松江', 'songjiang', 'CHN031017');
INSERT INTO `cities` VALUES (538, 43, '26', 'Fengxian', '奉贤', 'fengxian', 'CHN031026');
INSERT INTO `cities` VALUES (539, 43, '29', 'Qingpu', '青浦', 'qingpu', 'CHN031029');
INSERT INTO `cities` VALUES (540, 43, '30', 'Chongming', '崇明', 'chongming', 'CHN031030');
INSERT INTO `cities` VALUES (541, 44, '1', 'Nanjing', '南京', 'nanjing', 'CHN032001');
INSERT INTO `cities` VALUES (542, 44, '2', 'Wuxi', '无锡', 'wuxi', 'CHN032002');
INSERT INTO `cities` VALUES (543, 44, '3', 'Xuzhou', '徐州', 'xuzhou', 'CHN032003');
INSERT INTO `cities` VALUES (544, 44, '4', 'Changzhou', '常州', 'changzhou', 'CHN032004');
INSERT INTO `cities` VALUES (545, 44, '5', 'Suzhou', '苏州', 'suzhou', 'CHN032005');
INSERT INTO `cities` VALUES (546, 44, '6', 'Nantong', '南通', 'nantong', 'CHN032006');
INSERT INTO `cities` VALUES (547, 44, '7', 'Lianyungang', '连云港', 'lianyungang', 'CHN032007');
INSERT INTO `cities` VALUES (548, 44, '8', 'Huai\'an', '淮安', 'huai\'an', 'CHN032008');
INSERT INTO `cities` VALUES (549, 44, '9', 'Yancheng', '盐城', 'yancheng', 'CHN032009');
INSERT INTO `cities` VALUES (550, 44, '10', 'Yangzhou', '扬州', 'yangzhou', 'CHN032010');
INSERT INTO `cities` VALUES (551, 44, '11', 'Zhenjiang', '镇江', 'zhenjiang', 'CHN032011');
INSERT INTO `cities` VALUES (552, 44, '12', 'Taizhou', '泰州', 'taizhou', 'CHN032012');
INSERT INTO `cities` VALUES (553, 44, '13', 'Suqian', '宿迁', 'suqian', 'CHN032013');
INSERT INTO `cities` VALUES (554, 45, '1', 'Hangzhou', '杭州', 'hangzhou', 'CHN033001');
INSERT INTO `cities` VALUES (555, 45, '2', 'Ningbo', '宁波', 'ningbo', 'CHN033002');
INSERT INTO `cities` VALUES (556, 45, '3', 'Wenzhou', '温州', 'wenzhou', 'CHN033003');
INSERT INTO `cities` VALUES (557, 45, '4', 'Jiaxing', '嘉兴', 'jiaxing', 'CHN033004');
INSERT INTO `cities` VALUES (558, 45, '5', 'Huzhou', '湖州', 'huzhou', 'CHN033005');
INSERT INTO `cities` VALUES (559, 45, '6', 'Shaoxing', '绍兴', 'shaoxing', 'CHN033006');
INSERT INTO `cities` VALUES (560, 45, '7', 'Jinhua', '金华', 'jinhua', 'CHN033007');
INSERT INTO `cities` VALUES (561, 45, '8', 'Quzhou', '衢州', 'quzhou', 'CHN033008');
INSERT INTO `cities` VALUES (562, 45, '9', 'Zhoushan', '舟山', 'zhoushan', 'CHN033009');
INSERT INTO `cities` VALUES (563, 45, '10', 'Taizhou', '台州', 'taizhou', 'CHN033010');
INSERT INTO `cities` VALUES (564, 45, '11', 'Lishui', '丽水', 'lishui', 'CHN033011');
INSERT INTO `cities` VALUES (565, 46, '1', 'Hefei', '合肥', 'hefei', 'CHN034001');
INSERT INTO `cities` VALUES (566, 46, '2', 'Wuhu', '芜湖', 'wuhu', 'CHN034002');
INSERT INTO `cities` VALUES (567, 46, '3', 'Bengbu', '蚌埠', 'bengbu', 'CHN034003');
INSERT INTO `cities` VALUES (568, 46, '4', 'Huainan', '淮南', 'huainan', 'CHN034004');
INSERT INTO `cities` VALUES (569, 46, '5', 'Ma\'anshan', '马鞍山', 'ma\'anshan', 'CHN034005');
INSERT INTO `cities` VALUES (570, 46, '6', 'Huaibei', '淮北', 'huaibei', 'CHN034006');
INSERT INTO `cities` VALUES (571, 46, '7', 'Tongling', '铜陵', 'tongling', 'CHN034007');
INSERT INTO `cities` VALUES (572, 46, '8', 'Anqing', '安庆', 'anqing', 'CHN034008');
INSERT INTO `cities` VALUES (573, 46, '10', 'Huangshan', '黄山', 'huangshan', 'CHN034010');
INSERT INTO `cities` VALUES (574, 46, '11', 'Chuzhou', '滁州', 'chuzhou', 'CHN034011');
INSERT INTO `cities` VALUES (575, 46, '12', 'Fuyang', '阜阳', 'fuyang', 'CHN034012');
INSERT INTO `cities` VALUES (576, 46, '13', 'Suzhou', '宿州', 'suzhou', 'CHN034013');
INSERT INTO `cities` VALUES (577, 46, '15', 'Lu\'an', '六安', 'lu\'an', 'CHN034015');
INSERT INTO `cities` VALUES (578, 46, '16', 'Bozhou', '亳州', 'bozhou', 'CHN034016');
INSERT INTO `cities` VALUES (579, 46, '17', 'Chizhou', '池州', 'chizhou', 'CHN034017');
INSERT INTO `cities` VALUES (580, 46, '18', 'Xuancheng', '宣城', 'xuancheng', 'CHN034018');
INSERT INTO `cities` VALUES (581, 47, '1', 'Fuzhou', '福州', 'fuzhou', 'CHN035001');
INSERT INTO `cities` VALUES (582, 47, '2', 'Xiamen', '厦门', 'xiamen', 'CHN035002');
INSERT INTO `cities` VALUES (583, 47, '3', 'Putian', '莆田', 'putian', 'CHN035003');
INSERT INTO `cities` VALUES (584, 47, '4', 'Sanming', '三明', 'sanming', 'CHN035004');
INSERT INTO `cities` VALUES (585, 47, '5', 'Quanzhou', '泉州', 'quanzhou', 'CHN035005');
INSERT INTO `cities` VALUES (586, 47, '6', 'Zhangzhou', '漳州', 'zhangzhou', 'CHN035006');
INSERT INTO `cities` VALUES (587, 47, '7', 'Nanping', '南平', 'nanping', 'CHN035007');
INSERT INTO `cities` VALUES (588, 47, '8', 'Longyan', '龙岩', 'longyan', 'CHN035008');
INSERT INTO `cities` VALUES (589, 47, '9', 'Ningde', '宁德', 'ningde', 'CHN035009');
INSERT INTO `cities` VALUES (590, 48, '1', 'Nanchang', '南昌', 'nanchang', 'CHN036001');
INSERT INTO `cities` VALUES (591, 48, '2', 'Jingdezhen', '景德镇', 'jingdezhen', 'CHN036002');
INSERT INTO `cities` VALUES (592, 48, '3', 'Pingxiang', '萍乡', 'pingxiang', 'CHN036003');
INSERT INTO `cities` VALUES (593, 48, '4', 'Jiujiang', '九江', 'jiujiang', 'CHN036004');
INSERT INTO `cities` VALUES (594, 48, '5', 'Xinyu', '新余', 'xinyu', 'CHN036005');
INSERT INTO `cities` VALUES (595, 48, '6', 'Yingtan', '鹰潭', 'yingtan', 'CHN036006');
INSERT INTO `cities` VALUES (596, 48, '7', 'Ganzhou', '赣州', 'ganzhou', 'CHN036007');
INSERT INTO `cities` VALUES (597, 48, '8', 'Ji\'an', '吉安', 'ji\'an', 'CHN036008');
INSERT INTO `cities` VALUES (598, 48, '9', 'Yichun', '宜春', 'yichun', 'CHN036009');
INSERT INTO `cities` VALUES (599, 48, '10', 'Fuzhou', '抚州', 'fuzhou', 'CHN036010');
INSERT INTO `cities` VALUES (600, 48, '11', 'Shangrao', '上饶', 'shangrao', 'CHN036011');
INSERT INTO `cities` VALUES (601, 49, '1', 'Jinan', '济南', 'jinan', 'CHN037001');
INSERT INTO `cities` VALUES (602, 49, '2', 'Qingdao', '青岛', 'qingdao', 'CHN037002');
INSERT INTO `cities` VALUES (603, 49, '3', 'Zibo', '淄博', 'zibo', 'CHN037003');
INSERT INTO `cities` VALUES (604, 49, '4', 'Zaozhuang', '枣庄', 'zaozhuang', 'CHN037004');
INSERT INTO `cities` VALUES (605, 49, '5', 'Dongying', '东营', 'dongying', 'CHN037005');
INSERT INTO `cities` VALUES (606, 49, '6', 'Yantai', '烟台', 'yantai', 'CHN037006');
INSERT INTO `cities` VALUES (607, 49, '7', 'Weifang', '潍坊', 'weifang', 'CHN037007');
INSERT INTO `cities` VALUES (608, 49, '8', 'Jining', '济宁', 'jining', 'CHN037008');
INSERT INTO `cities` VALUES (609, 49, '9', 'Tai\'an', '泰安', 'tai\'an', 'CHN037009');
INSERT INTO `cities` VALUES (610, 49, '10', 'Weihai', '威海', 'weihai', 'CHN037010');
INSERT INTO `cities` VALUES (611, 49, '11', 'Rizhao', '日照', 'rizhao', 'CHN037011');
INSERT INTO `cities` VALUES (612, 49, '12', 'Laiwu', '莱芜', 'laiwu', 'CHN037012');
INSERT INTO `cities` VALUES (613, 49, '13', 'Linyi', '临沂', 'linyi', 'CHN037013');
INSERT INTO `cities` VALUES (614, 49, '14', 'Dezhou', '德州', 'dezhou', 'CHN037014');
INSERT INTO `cities` VALUES (615, 49, '15', 'Liaocheng', '聊城', 'liaocheng', 'CHN037015');
INSERT INTO `cities` VALUES (616, 49, '16', 'Binzhou', '滨州', 'binzhou', 'CHN037016');
INSERT INTO `cities` VALUES (617, 49, '17', 'Heze', '菏泽', 'heze', 'CHN037017');
INSERT INTO `cities` VALUES (618, 50, '1', 'Zhengzhou', '郑州', 'zhengzhou', 'CHN041001');
INSERT INTO `cities` VALUES (619, 50, '2', 'Kaifeng', '开封', 'kaifeng', 'CHN041002');
INSERT INTO `cities` VALUES (620, 50, '3', 'Luoyang', '洛阳', 'luoyang', 'CHN041003');
INSERT INTO `cities` VALUES (621, 50, '4', 'Pingdingshan', '平顶山', 'pingdingshan', 'CHN041004');
INSERT INTO `cities` VALUES (622, 50, '5', 'Anyang', '安阳', 'anyang', 'CHN041005');
INSERT INTO `cities` VALUES (623, 50, '6', 'Hebi', '鹤壁', 'hebi', 'CHN041006');
INSERT INTO `cities` VALUES (624, 50, '7', 'Xinxiang', '新乡', 'xinxiang', 'CHN041007');
INSERT INTO `cities` VALUES (625, 50, '8', 'Jiaozuo', '焦作', 'jiaozuo', 'CHN041008');
INSERT INTO `cities` VALUES (626, 50, '9', 'Puyang', '濮阳', 'puyang', 'CHN041009');
INSERT INTO `cities` VALUES (627, 50, '10', 'Xuchang', '许昌', 'xuchang', 'CHN041010');
INSERT INTO `cities` VALUES (628, 50, '11', 'Luohe', '漯河', 'luohe', 'CHN041011');
INSERT INTO `cities` VALUES (629, 50, '12', 'Sanmenxia', '三门峡', 'sanmenxia', 'CHN041012');
INSERT INTO `cities` VALUES (630, 50, '13', 'Nanyang', '南阳', 'nanyang', 'CHN041013');
INSERT INTO `cities` VALUES (631, 50, '14', 'Shangqiu', '商丘', 'shangqiu', 'CHN041014');
INSERT INTO `cities` VALUES (632, 50, '15', 'Xinyang', '信阳', 'xinyang', 'CHN041015');
INSERT INTO `cities` VALUES (633, 50, '16', 'Zhoukou', '周口', 'zhoukou', 'CHN041016');
INSERT INTO `cities` VALUES (634, 50, '17', 'Zhumadian', '驻马店', 'zhumadian', 'CHN041017');
INSERT INTO `cities` VALUES (635, 50, '18', 'Jiyuan', '济源', 'jiyuan', 'CHN041018');
INSERT INTO `cities` VALUES (636, 51, '1', 'Wuhan', '武汉', 'wuhan', 'CHN042001');
INSERT INTO `cities` VALUES (637, 51, '2', 'Huangshi', '黄石', 'huangshi', 'CHN042002');
INSERT INTO `cities` VALUES (638, 51, '3', 'Shiyan', '十堰', 'shiyan', 'CHN042003');
INSERT INTO `cities` VALUES (639, 51, '5', 'Yichang', '宜昌', 'yichang', 'CHN042005');
INSERT INTO `cities` VALUES (640, 51, '6', 'Xiangyang', '襄阳', 'xiangyang', 'CHN042006');
INSERT INTO `cities` VALUES (641, 51, '7', 'Ezhou', '鄂州', 'ezhou', 'CHN042007');
INSERT INTO `cities` VALUES (642, 51, '8', 'Jingmen', '荆门', 'jingmen', 'CHN042008');
INSERT INTO `cities` VALUES (643, 51, '9', 'Xiaogan', '孝感', 'xiaogan', 'CHN042009');
INSERT INTO `cities` VALUES (644, 51, '10', 'Jingzhou', '荆州', 'jingzhou', 'CHN042010');
INSERT INTO `cities` VALUES (645, 51, '11', 'Huanggang', '黄冈', 'huanggang', 'CHN042011');
INSERT INTO `cities` VALUES (646, 51, '12', 'Xianning', '咸宁', 'xianning', 'CHN042012');
INSERT INTO `cities` VALUES (647, 51, '13', 'Suizhou', '随州', 'suizhou', 'CHN042013');
INSERT INTO `cities` VALUES (648, 51, '28', 'Enshi Tujia-Miao Autonomous Prefecture', '恩施', 'enshi tujia-miao autonomous prefecture', 'CHN042028');
INSERT INTO `cities` VALUES (649, 51, '94', 'Xiantao', '仙桃', 'xiantao', 'CHN042094');
INSERT INTO `cities` VALUES (650, 51, '95', 'Qianjiang', '潜江', 'qianjiang', 'CHN042095');
INSERT INTO `cities` VALUES (651, 51, '96', 'Tianmen', '天门', 'tianmen', 'CHN042096');
INSERT INTO `cities` VALUES (652, 51, 'A21', 'Shennongjia', '神农架', 'shennongjia', 'CHN042A21');
INSERT INTO `cities` VALUES (653, 52, '1', 'Changsha', '长沙', 'changsha', 'CHN043001');
INSERT INTO `cities` VALUES (654, 52, '2', 'Zhuzhou', '株洲', 'zhuzhou', 'CHN043002');
INSERT INTO `cities` VALUES (655, 52, '3', 'Xiangtan', '湘潭', 'xiangtan', 'CHN043003');
INSERT INTO `cities` VALUES (656, 52, '4', 'Hengyang', '衡阳', 'hengyang', 'CHN043004');
INSERT INTO `cities` VALUES (657, 52, '5', 'Shaoyang', '邵阳', 'shaoyang', 'CHN043005');
INSERT INTO `cities` VALUES (658, 52, '6', 'Yueyang', '岳阳', 'yueyang', 'CHN043006');
INSERT INTO `cities` VALUES (659, 52, '7', 'Changde', '常德', 'changde', 'CHN043007');
INSERT INTO `cities` VALUES (660, 52, '8', 'Zhangjiajie', '张家界', 'zhangjiajie', 'CHN043008');
INSERT INTO `cities` VALUES (661, 52, '9', 'Yiyang', '益阳', 'yiyang', 'CHN043009');
INSERT INTO `cities` VALUES (662, 52, '10', 'Chenzhou', '郴州', 'chenzhou', 'CHN043010');
INSERT INTO `cities` VALUES (663, 52, '11', 'Yongzhou', '永州', 'yongzhou', 'CHN043011');
INSERT INTO `cities` VALUES (664, 52, '12', 'Huaihua', '怀化', 'huaihua', 'CHN043012');
INSERT INTO `cities` VALUES (665, 52, '13', 'Loudi', '娄底', 'loudi', 'CHN043013');
INSERT INTO `cities` VALUES (666, 52, '31', 'Xiangxi Tujia-Miao Autonomous Prefecture', '湘西', 'xiangxi tujia-miao autonomous prefecture', 'CHN043031');
INSERT INTO `cities` VALUES (667, 53, '1', 'Guangzhou', '广州', 'guangzhou', 'CHN044001');
INSERT INTO `cities` VALUES (668, 53, '2', 'Shaoguan', '韶关', 'shaoguan', 'CHN044002');
INSERT INTO `cities` VALUES (669, 53, '3', 'Shenzhen', '深圳', 'shenzhen', 'CHN044003');
INSERT INTO `cities` VALUES (670, 53, '4', 'Zhuhai', '珠海', 'zhuhai', 'CHN044004');
INSERT INTO `cities` VALUES (671, 53, '5', 'Shantou', '汕头', 'shantou', 'CHN044005');
INSERT INTO `cities` VALUES (672, 53, '6', 'Foshan', '佛山', 'foshan', 'CHN044006');
INSERT INTO `cities` VALUES (673, 53, '7', 'Jiangmen', '江门', 'jiangmen', 'CHN044007');
INSERT INTO `cities` VALUES (674, 53, '8', 'Zhanjiang', '湛江', 'zhanjiang', 'CHN044008');
INSERT INTO `cities` VALUES (675, 53, '9', 'Maoming', '茂名', 'maoming', 'CHN044009');
INSERT INTO `cities` VALUES (676, 53, '12', 'Zhaoqing', '肇庆', 'zhaoqing', 'CHN044012');
INSERT INTO `cities` VALUES (677, 53, '13', 'Huizhou', '惠州', 'huizhou', 'CHN044013');
INSERT INTO `cities` VALUES (678, 53, '14', 'Meizhou', '梅州', 'meizhou', 'CHN044014');
INSERT INTO `cities` VALUES (679, 53, '15', 'Shanwei', '汕尾', 'shanwei', 'CHN044015');
INSERT INTO `cities` VALUES (680, 53, '16', 'Heyuan', '河源', 'heyuan', 'CHN044016');
INSERT INTO `cities` VALUES (681, 53, '17', 'Yangjiang', '阳江', 'yangjiang', 'CHN044017');
INSERT INTO `cities` VALUES (682, 53, '18', 'Qingyuan', '清远', 'qingyuan', 'CHN044018');
INSERT INTO `cities` VALUES (683, 53, '19', 'Dongguan', '东莞', 'dongguan', 'CHN044019');
INSERT INTO `cities` VALUES (684, 53, '20', 'Zhongshan', '中山', 'zhongshan', 'CHN044020');
INSERT INTO `cities` VALUES (685, 53, '51', 'Chaozhou', '潮州', 'chaozhou', 'CHN044051');
INSERT INTO `cities` VALUES (686, 53, '52', 'Jieyang', '揭阳', 'jieyang', 'CHN044052');
INSERT INTO `cities` VALUES (687, 53, '53', 'Yunfu', '云浮', 'yunfu', 'CHN044053');
INSERT INTO `cities` VALUES (688, 54, '1', 'Nanning', '南宁', 'nanning', 'CHN045001');
INSERT INTO `cities` VALUES (689, 54, '2', 'Liuzhou', '柳州', 'liuzhou', 'CHN045002');
INSERT INTO `cities` VALUES (690, 54, '3', 'Guilin', '桂林', 'guilin', 'CHN045003');
INSERT INTO `cities` VALUES (691, 54, '4', 'Wuzhou', '梧州', 'wuzhou', 'CHN045004');
INSERT INTO `cities` VALUES (692, 54, '5', 'Beihai', '北海', 'beihai', 'CHN045005');
INSERT INTO `cities` VALUES (693, 54, '6', 'Fangchenggang', '防城港', 'fangchenggang', 'CHN045006');
INSERT INTO `cities` VALUES (694, 54, '7', 'Qinzhou', '钦州', 'qinzhou', 'CHN045007');
INSERT INTO `cities` VALUES (695, 54, '8', 'Guigang', '贵港', 'guigang', 'CHN045008');
INSERT INTO `cities` VALUES (696, 54, '9', 'Yulin', '玉林', 'yulin', 'CHN045009');
INSERT INTO `cities` VALUES (697, 54, '10', 'Baise', '百色', 'baise', 'CHN045010');
INSERT INTO `cities` VALUES (698, 54, '11', 'Hezhou', '贺州', 'hezhou', 'CHN045011');
INSERT INTO `cities` VALUES (699, 54, '12', 'Hechi', '河池', 'hechi', 'CHN045012');
INSERT INTO `cities` VALUES (700, 54, '13', 'Laibin', '来宾', 'laibin', 'CHN045013');
INSERT INTO `cities` VALUES (701, 54, '14', 'Chongzuo', '崇左', 'chongzuo', 'CHN045014');
INSERT INTO `cities` VALUES (702, 55, '1', 'Haikou', '海口', 'haikou', 'CHN046001');
INSERT INTO `cities` VALUES (703, 55, '2', 'Sanya', '三亚', 'sanya', 'CHN046002');
INSERT INTO `cities` VALUES (704, 55, '3', 'Shansha', '三沙', 'shansha', 'CHN046003');
INSERT INTO `cities` VALUES (705, 55, '91', 'Wuzhishan', '五指山', 'wuzhishan', 'CHN046091');
INSERT INTO `cities` VALUES (706, 55, '92', 'Qionghai', '琼海', 'qionghai', 'CHN046092');
INSERT INTO `cities` VALUES (707, 55, '93', 'Danzhou', '儋州', 'danzhou', 'CHN046093');
INSERT INTO `cities` VALUES (708, 55, '95', 'Wenchang', '文昌', 'wenchang', 'CHN046095');
INSERT INTO `cities` VALUES (709, 55, '96', 'Wanning', '万宁', 'wanning', 'CHN046096');
INSERT INTO `cities` VALUES (710, 55, '97', 'Dornod', '东方', 'dornod', 'CHN046097');
INSERT INTO `cities` VALUES (711, 55, 'A25', 'Ding\'an', '定安', 'ding\'an', 'CHN046A25');
INSERT INTO `cities` VALUES (712, 55, 'A26', 'Tunchang', '屯昌', 'tunchang', 'CHN046A26');
INSERT INTO `cities` VALUES (713, 55, 'A27', 'Cengmai', '澄迈', 'cengmai', 'CHN046A27');
INSERT INTO `cities` VALUES (714, 55, 'A28', 'Lingao', '临高', 'lingao', 'CHN046A28');
INSERT INTO `cities` VALUES (715, 55, 'A3', 'Baisha Li Autonomous County', '白沙', 'baisha li autonomous county', 'CHN046A30');
INSERT INTO `cities` VALUES (716, 55, 'A31', 'Jiang Li Autonomous County', '昌江', 'jiang li autonomous county', 'CHN046A31');
INSERT INTO `cities` VALUES (717, 55, 'A33', 'Ledong Li Autonomous County', '乐东', 'ledong li autonomous county', 'CHN046A33');
INSERT INTO `cities` VALUES (718, 55, 'A34', 'Lingshui Li Autonomous County', '陵水', 'lingshui li autonomous county', 'CHN046A34');
INSERT INTO `cities` VALUES (719, 55, 'A35', 'Baoting Li-Miao Autonomous County', '保亭', 'baoting li-miao autonomous county', 'CHN046A35');
INSERT INTO `cities` VALUES (720, 55, 'A36', 'Qiongzhong Li-Miao Autonomous County', '琼中', 'qiongzhong li-miao autonomous county', 'CHN046A36');
INSERT INTO `cities` VALUES (721, 56, '1', 'Wanzhou', '万州', 'wanzhou', 'CHN050001');
INSERT INTO `cities` VALUES (722, 56, '2', 'Fuling', '涪陵', 'fuling', 'CHN050002');
INSERT INTO `cities` VALUES (723, 56, '3', 'Yuzhong', '渝中', 'yuzhong', 'CHN050003');
INSERT INTO `cities` VALUES (724, 56, '4', 'Dadukou', '大渡口', 'dadukou', 'CHN050004');
INSERT INTO `cities` VALUES (725, 56, '5', 'Jiangbei', '江北', 'jiangbei', 'CHN050005');
INSERT INTO `cities` VALUES (726, 56, '6', 'Shapingba', '沙坪坝', 'shapingba', 'CHN050006');
INSERT INTO `cities` VALUES (727, 56, '7', 'Jiulongpo', '九龙坡', 'jiulongpo', 'CHN050007');
INSERT INTO `cities` VALUES (728, 56, '8', 'Nan\'an', '南岸', 'nan\'an', 'CHN050008');
INSERT INTO `cities` VALUES (729, 56, '9', 'Beibei', '北碚', 'beibei', 'CHN050009');
INSERT INTO `cities` VALUES (730, 56, '10', 'Wansheng', '万盛', 'wansheng', 'CHN050010');
INSERT INTO `cities` VALUES (731, 56, '11', 'Shuangqiao', '双桥', 'shuangqiao', 'CHN050011');
INSERT INTO `cities` VALUES (732, 56, '12', 'Yubei', '渝北', 'yubei', 'CHN050012');
INSERT INTO `cities` VALUES (733, 56, '13', 'Ba\'nan', '巴南', 'ba\'nan', 'CHN050013');
INSERT INTO `cities` VALUES (734, 56, '21', 'Changshou', '长寿', 'changshou', 'CHN050021');
INSERT INTO `cities` VALUES (735, 56, '22', 'Qijiang', '綦江', 'qijiang', 'CHN050022');
INSERT INTO `cities` VALUES (736, 56, '23', 'Tongnan', '潼南', 'tongnan', 'CHN050023');
INSERT INTO `cities` VALUES (737, 56, '24', 'Tongliang', '铜梁', 'tongliang', 'CHN050024');
INSERT INTO `cities` VALUES (738, 56, '25', 'Dazu', '大足', 'dazu', 'CHN050025');
INSERT INTO `cities` VALUES (739, 56, '26', 'Rongchang', '荣昌', 'rongchang', 'CHN050026');
INSERT INTO `cities` VALUES (740, 56, '27', 'Bishan', '璧山', 'bishan', 'CHN050027');
INSERT INTO `cities` VALUES (741, 56, '28', 'Liangping', '梁平', 'liangping', 'CHN050028');
INSERT INTO `cities` VALUES (742, 56, '29', 'Chengkou', '城口', 'chengkou', 'CHN050029');
INSERT INTO `cities` VALUES (743, 56, '30', 'Fengdu', '丰都', 'fengdu', 'CHN050030');
INSERT INTO `cities` VALUES (744, 56, '31', 'Dianjiang', '垫江', 'dianjiang', 'CHN050031');
INSERT INTO `cities` VALUES (745, 56, '32', 'Wulong', '武隆', 'wulong', 'CHN050032');
INSERT INTO `cities` VALUES (746, 56, '33', 'Zhongxian', '忠县', 'zhongxian', 'CHN050033');
INSERT INTO `cities` VALUES (747, 56, '34', 'Kaixian', '开县', 'kaixian', 'CHN050034');
INSERT INTO `cities` VALUES (748, 56, '35', 'Yunyang', '云阳', 'yunyang', 'CHN050035');
INSERT INTO `cities` VALUES (749, 56, '36', 'Fengjie', '奉节', 'fengjie', 'CHN050036');
INSERT INTO `cities` VALUES (750, 56, '37', 'Wushan', '巫山', 'wushan', 'CHN050037');
INSERT INTO `cities` VALUES (751, 56, '38', 'Wuxi', '巫溪', 'wuxi', 'CHN050038');
INSERT INTO `cities` VALUES (752, 56, '39', 'Qianjiang', '黔江', 'qianjiang', 'CHN050039');
INSERT INTO `cities` VALUES (753, 56, '40', 'Shizhu Tujia Autonomous Country', '石柱', 'shizhu tujia autonomous country', 'CHN050040');
INSERT INTO `cities` VALUES (754, 56, '41', 'Xiushan Tujia-Miao Autonomous Country', '秀山', 'xiushan tujia-miao autonomous country', 'CHN050041');
INSERT INTO `cities` VALUES (755, 56, '42', 'Youyang Tujia-Miao Autonomous Country', '酉阳', 'youyang tujia-miao autonomous country', 'CHN050042');
INSERT INTO `cities` VALUES (756, 56, '43', 'Pengshui Miao-Tujia Autonomous Country', '彭水', 'pengshui miao-tujia autonomous country', 'CHN050043');
INSERT INTO `cities` VALUES (757, 56, '81', 'Jiangjin', '江津', 'jiangjin', 'CHN050081');
INSERT INTO `cities` VALUES (758, 56, '82', 'Hechuan', '合川', 'hechuan', 'CHN050082');
INSERT INTO `cities` VALUES (759, 56, '83', 'Yongchuan', '永川', 'yongchuan', 'CHN050083');
INSERT INTO `cities` VALUES (760, 56, '84', 'Liangjiangxinqu', '南川', 'liangjiangxinqu', 'CHN050084');
INSERT INTO `cities` VALUES (761, 56, '85', 'Kaixian', '两江新区', 'kaixian', 'CHN050085');
INSERT INTO `cities` VALUES (762, 57, '1', 'Chengdu', '成都', 'chengdu', 'CHN051001');
INSERT INTO `cities` VALUES (763, 57, '3', 'Zigong', '自贡', 'zigong', 'CHN051003');
INSERT INTO `cities` VALUES (764, 57, '4', 'Panzhihua', '攀枝花', 'panzhihua', 'CHN051004');
INSERT INTO `cities` VALUES (765, 57, '5', 'Luzhou', '泸州', 'luzhou', 'CHN051005');
INSERT INTO `cities` VALUES (766, 57, '6', 'Deyang', '德阳', 'deyang', 'CHN051006');
INSERT INTO `cities` VALUES (767, 57, '7', 'Mianyang', '绵阳', 'mianyang', 'CHN051007');
INSERT INTO `cities` VALUES (768, 57, '8', 'Guangyuan', '广元', 'guangyuan', 'CHN051008');
INSERT INTO `cities` VALUES (769, 57, '9', 'Suining', '遂宁', 'suining', 'CHN051009');
INSERT INTO `cities` VALUES (770, 57, '10', 'Neijiang', '内江', 'neijiang', 'CHN051010');
INSERT INTO `cities` VALUES (771, 57, '11', 'Leshan', '乐山', 'leshan', 'CHN051011');
INSERT INTO `cities` VALUES (772, 57, '13', 'Nanchong', '南充', 'nanchong', 'CHN051013');
INSERT INTO `cities` VALUES (773, 57, '14', 'Meishan', '眉山', 'meishan', 'CHN051014');
INSERT INTO `cities` VALUES (774, 57, '15', 'Yibin', '宜宾', 'yibin', 'CHN051015');
INSERT INTO `cities` VALUES (775, 57, '16', 'Guang\'an', '广安', 'guang\'an', 'CHN051016');
INSERT INTO `cities` VALUES (776, 57, '17', 'Dazhou', '达州', 'dazhou', 'CHN051017');
INSERT INTO `cities` VALUES (777, 57, '18', 'Ya\'an', '雅安', 'ya\'an', 'CHN051018');
INSERT INTO `cities` VALUES (778, 57, '19', 'Bazhong', '巴中', 'bazhong', 'CHN051019');
INSERT INTO `cities` VALUES (779, 57, '20', 'Ziyang', '资阳', 'ziyang', 'CHN051020');
INSERT INTO `cities` VALUES (780, 57, '32', 'Aba Tibetan-Qiang Autonomous Prefecture', '阿坝', 'aba tibetan-qiang autonomous prefecture', 'CHN051032');
INSERT INTO `cities` VALUES (781, 57, '33', 'Garze Tibetan Autonomous Prefecture', '甘孜', 'garze tibetan autonomous prefecture', 'CHN051033');
INSERT INTO `cities` VALUES (782, 57, '34', 'Liangshan Yi Autonomous Prefecture', '凉山', 'liangshan yi autonomous prefecture', 'CHN051034');
INSERT INTO `cities` VALUES (783, 58, '1', 'Guiyang', '贵阳', 'guiyang', 'CHN052001');
INSERT INTO `cities` VALUES (784, 58, '2', 'Liupanshui', '六盘水', 'liupanshui', 'CHN052002');
INSERT INTO `cities` VALUES (785, 58, '3', 'Zunyi', '遵义', 'zunyi', 'CHN052003');
INSERT INTO `cities` VALUES (786, 58, '4', 'Anshun', '安顺', 'anshun', 'CHN052004');
INSERT INTO `cities` VALUES (787, 58, '22', 'Tongren', '铜仁', 'tongren', 'CHN052022');
INSERT INTO `cities` VALUES (788, 58, '23', 'Qianxinan Buyi-Miao Autonomous Prefecture', '黔西南', 'qianxinan buyi-miao autonomous prefecture', 'CHN052023');
INSERT INTO `cities` VALUES (789, 58, '24', 'Bijie', '毕节', 'bijie', 'CHN052024');
INSERT INTO `cities` VALUES (790, 58, '26', 'Qiandongnan Miao-Dong Autonomous Prefecture', '黔东南', 'qiandongnan miao-dong autonomous prefecture', 'CHN052026');
INSERT INTO `cities` VALUES (791, 58, '27', 'Qiannan Buyi Autonomous Prefecture', '黔南', 'qiannan buyi autonomous prefecture', 'CHN052027');
INSERT INTO `cities` VALUES (792, 59, '1', 'Kunming', '昆明', 'kunming', 'CHN053001');
INSERT INTO `cities` VALUES (793, 59, '3', 'Qujing', '曲靖', 'qujing', 'CHN053003');
INSERT INTO `cities` VALUES (794, 59, '4', 'Yuxi', '玉溪', 'yuxi', 'CHN053004');
INSERT INTO `cities` VALUES (795, 59, '5', 'Baoshan', '保山', 'baoshan', 'CHN053005');
INSERT INTO `cities` VALUES (796, 59, '6', 'Zhaotong', '昭通', 'zhaotong', 'CHN053006');
INSERT INTO `cities` VALUES (797, 59, '7', 'Lijiang', '丽江', 'lijiang', 'CHN053007');
INSERT INTO `cities` VALUES (798, 59, '8', 'Pu\'er', '普洱', 'pu\'er', 'CHN053008');
INSERT INTO `cities` VALUES (799, 59, '9', 'Lincang', '临沧', 'lincang', 'CHN053009');
INSERT INTO `cities` VALUES (800, 59, '23', 'Chuxiong Yi Autonomous Prefecture', '楚雄', 'chuxiong yi autonomous prefecture', 'CHN053023');
INSERT INTO `cities` VALUES (801, 59, '25', 'Honghe Hani-Yi Autonomous Prefecture', '红河', 'honghe hani-yi autonomous prefecture', 'CHN053025');
INSERT INTO `cities` VALUES (802, 59, '26', 'Wenshan Zhuang-Miao Autonomous Prefecture', '文山', 'wenshan zhuang-miao autonomous prefecture', 'CHN053026');
INSERT INTO `cities` VALUES (803, 59, '28', 'Xishuangbanna Dai Autonomous Prefecture', '西双版纳', 'xishuangbanna dai autonomous prefecture', 'CHN053028');
INSERT INTO `cities` VALUES (804, 59, '29', 'Dali Bai Autonomous Prefecture', '大理', 'dali bai autonomous prefecture', 'CHN053029');
INSERT INTO `cities` VALUES (805, 59, '31', 'Dehong Dai-Jingpo Autonomous Prefecture', '德宏', 'dehong dai-jingpo autonomous prefecture', 'CHN053031');
INSERT INTO `cities` VALUES (806, 59, '33', 'Nujiang Lisu Autonomous Prefecture', '怒江', 'nujiang lisu autonomous prefecture', 'CHN053033');
INSERT INTO `cities` VALUES (807, 59, '34', 'Diqing Tibetan Autonomous Prefecture', '迪庆', 'diqing tibetan autonomous prefecture', 'CHN053034');
INSERT INTO `cities` VALUES (808, 60, '1', 'Lhasa', '拉萨', 'lhasa', 'CHN054001');
INSERT INTO `cities` VALUES (809, 60, '21', 'Qamdo', '昌都', 'qamdo', 'CHN054021');
INSERT INTO `cities` VALUES (810, 60, '22', 'Shannan', '山南', 'shannan', 'CHN054022');
INSERT INTO `cities` VALUES (811, 60, '23', 'Xigaze', '日喀则', 'xigaze', 'CHN054023');
INSERT INTO `cities` VALUES (812, 60, '24', 'Nagqu', '那曲', 'nagqu', 'CHN054024');
INSERT INTO `cities` VALUES (813, 60, '25', 'Ngari', '阿里', 'ngari', 'CHN054025');
INSERT INTO `cities` VALUES (814, 60, '26', 'Nyingchi', '林芝', 'nyingchi', 'CHN054026');
INSERT INTO `cities` VALUES (815, 61, '1', 'Xi\'an', '西安', 'xi\'an', 'CHN061001');
INSERT INTO `cities` VALUES (816, 61, '2', 'Tongchuan', '铜川', 'tongchuan', 'CHN061002');
INSERT INTO `cities` VALUES (817, 61, '3', 'Baoji', '宝鸡', 'baoji', 'CHN061003');
INSERT INTO `cities` VALUES (818, 61, '4', 'Xianyang', '咸阳', 'xianyang', 'CHN061004');
INSERT INTO `cities` VALUES (819, 61, '5', 'Weinan', '渭南', 'weinan', 'CHN061005');
INSERT INTO `cities` VALUES (820, 61, '6', 'Yan\'an', '延安', 'yan\'an', 'CHN061006');
INSERT INTO `cities` VALUES (821, 61, '7', 'Hanzhong', '汉中', 'hanzhong', 'CHN061007');
INSERT INTO `cities` VALUES (822, 61, '8', 'Yulin', '榆林', 'yulin', 'CHN061008');
INSERT INTO `cities` VALUES (823, 61, '9', 'Ankang', '安康', 'ankang', 'CHN061009');
INSERT INTO `cities` VALUES (824, 61, '10', 'Shangluo', '商洛', 'shangluo', 'CHN061010');
INSERT INTO `cities` VALUES (825, 62, '1', 'Lanzhou', '兰州市', 'lanzhou', 'CHN062001');
INSERT INTO `cities` VALUES (826, 62, '2', 'Jinchang', '嘉峪关', 'jinchang', 'CHN062002');
INSERT INTO `cities` VALUES (827, 62, '3', 'Baiyin', '金昌', 'baiyin', 'CHN062003');
INSERT INTO `cities` VALUES (828, 62, '4', 'Tianshui', '白银', 'tianshui', 'CHN062004');
INSERT INTO `cities` VALUES (829, 62, '5', 'Jiayuguan', '天水', 'jiayuguan', 'CHN062005');
INSERT INTO `cities` VALUES (830, 62, '6', 'Wuwei', '武威', 'wuwei', 'CHN062006');
INSERT INTO `cities` VALUES (831, 62, '7', 'Zhangye', '张掖', 'zhangye', 'CHN062007');
INSERT INTO `cities` VALUES (832, 62, '8', 'Pingliang', '平凉', 'pingliang', 'CHN062008');
INSERT INTO `cities` VALUES (833, 62, '9', 'Jiuquan', '酒泉', 'jiuquan', 'CHN062009');
INSERT INTO `cities` VALUES (834, 62, '10', 'Qingyang', '庆阳', 'qingyang', 'CHN062010');
INSERT INTO `cities` VALUES (835, 62, '11', 'Dingxi', '定西', 'dingxi', 'CHN062011');
INSERT INTO `cities` VALUES (836, 62, '12', 'Longnan', '陇南', 'longnan', 'CHN062012');
INSERT INTO `cities` VALUES (837, 62, '29', 'Linxia Hui Autonomous Prefecture', '临夏', 'linxia hui autonomous prefecture', 'CHN062029');
INSERT INTO `cities` VALUES (838, 62, '30', 'Gannan Tibetan Autonomous Prefecture', '甘南', 'gannan tibetan autonomous prefecture', 'CHN062030');
INSERT INTO `cities` VALUES (839, 63, '1', 'Xining', '西宁', 'xining', 'CHN063001');
INSERT INTO `cities` VALUES (840, 63, '21', 'Haidong', '海东', 'haidong', 'CHN063021');
INSERT INTO `cities` VALUES (841, 63, '22', 'Haibei Tibetan Autonomous Prefecture', '海北', 'haibei tibetan autonomous prefecture', 'CHN063022');
INSERT INTO `cities` VALUES (842, 63, '23', 'Huangnan Tibetan Autonomous Prefecture', '黄南', 'huangnan tibetan autonomous prefecture', 'CHN063023');
INSERT INTO `cities` VALUES (843, 63, '25', 'Hainan Tibetan Autonomous Prefecture', '海南', 'hainan tibetan autonomous prefecture', 'CHN063025');
INSERT INTO `cities` VALUES (844, 63, '26', 'Guoluo Tibetan Autonomous Prefecture', '果洛', 'guoluo tibetan autonomous prefecture', 'CHN063026');
INSERT INTO `cities` VALUES (845, 63, '27', 'Yushu Tibetan Autonomous Prefecture', '玉树', 'yushu tibetan autonomous prefecture', 'CHN063027');
INSERT INTO `cities` VALUES (846, 63, '28', 'Haixi Mongol-Tibetan Autonomous Prefecture', '海西', 'haixi mongol-tibetan autonomous prefecture', 'CHN063028');
INSERT INTO `cities` VALUES (847, 64, '1', 'Yinchuan', '银川', 'yinchuan', 'CHN064001');
INSERT INTO `cities` VALUES (848, 64, '2', 'Shizuishan', '石嘴山', 'shizuishan', 'CHN064002');
INSERT INTO `cities` VALUES (849, 64, '3', 'Wuzhong', '吴忠', 'wuzhong', 'CHN064003');
INSERT INTO `cities` VALUES (850, 64, '4', 'Guyuan', '固原', 'guyuan', 'CHN064004');
INSERT INTO `cities` VALUES (851, 64, '5', 'Zhongwei', '中卫', 'zhongwei', 'CHN064005');
INSERT INTO `cities` VALUES (852, 65, '1', 'Urumqi', '乌鲁木齐', 'urumqi', 'CHN065001');
INSERT INTO `cities` VALUES (853, 65, '2', 'Karamay', '克拉玛依', 'karamay', 'CHN065002');
INSERT INTO `cities` VALUES (854, 65, '21', 'Turpan', '吐鲁番', 'turpan', 'CHN065021');
INSERT INTO `cities` VALUES (855, 65, '22', 'Hami', '哈密', 'hami', 'CHN065022');
INSERT INTO `cities` VALUES (856, 65, '23', 'Changji Hui Autonomous Prefecture', '昌吉', 'changji hui autonomous prefecture', 'CHN065023');
INSERT INTO `cities` VALUES (857, 65, '27', 'Bortala Mongol Autonomous Prefecture', '博尔塔拉', 'bortala mongol autonomous prefecture', 'CHN065027');
INSERT INTO `cities` VALUES (858, 65, '28', 'Bayingolin Mongol Autonomous Prefecture', '巴音郭楞', 'bayingolin mongol autonomous prefecture', 'CHN065028');
INSERT INTO `cities` VALUES (859, 65, '29', 'Aksu', '阿克苏', 'aksu', 'CHN065029');
INSERT INTO `cities` VALUES (860, 65, '30', 'Kizilsu Kirgiz Autonomous Prefecture', '克孜勒苏', 'kizilsu kirgiz autonomous prefecture', 'CHN065030');
INSERT INTO `cities` VALUES (861, 65, '31', 'Kashi', '喀什', 'kashi', 'CHN065031');
INSERT INTO `cities` VALUES (862, 65, '32', 'Hotan', '和田', 'hotan', 'CHN065032');
INSERT INTO `cities` VALUES (863, 65, '40', 'Ili Kazakh Autonomous Prefecture', '伊犁', 'ili kazakh autonomous prefecture', 'CHN065040');
INSERT INTO `cities` VALUES (864, 65, '42', 'Tacheng', '塔城', 'tacheng', 'CHN065042');
INSERT INTO `cities` VALUES (865, 65, '43', 'Altay', '阿勒泰', 'altay', 'CHN065043');
INSERT INTO `cities` VALUES (866, 65, '91', 'Shihezi', '石河子', 'shihezi', 'CHN065091');
INSERT INTO `cities` VALUES (867, 65, '92', 'Alar', '阿拉尔', 'alar', 'CHN065092');
INSERT INTO `cities` VALUES (868, 65, '93', 'Tumsuk', '图木舒克', 'tumsuk', 'CHN065093');
INSERT INTO `cities` VALUES (869, 65, '94', 'Wujiaqu', '五家渠', 'wujiaqu', 'CHN065094');
INSERT INTO `cities` VALUES (870, 65, '95', 'Beitun', '北屯', 'beitun', 'CHN065095');
INSERT INTO `cities` VALUES (871, 66, '1', 'Taipei City', '台北市', 'taipei city', 'CHN071001');
INSERT INTO `cities` VALUES (872, 66, '2', 'Kaohsiung City', '高雄市', 'kaohsiung city', 'CHN071002');
INSERT INTO `cities` VALUES (873, 66, '3', 'Keelung City', '基隆市', 'keelung city', 'CHN071003');
INSERT INTO `cities` VALUES (874, 66, '4', 'Taichung City', '台中市', 'taichung city', 'CHN071004');
INSERT INTO `cities` VALUES (875, 66, '5', 'Tainan City', '台南市', 'tainan city', 'CHN071005');
INSERT INTO `cities` VALUES (876, 66, '6', 'Hsinchu City', '新竹市', 'hsinchu city', 'CHN071006');
INSERT INTO `cities` VALUES (877, 66, '7', 'Chiayi City', '嘉义市', 'chiayi city', 'CHN071007');
INSERT INTO `cities` VALUES (878, 66, '8', 'Taipei County', '台北县', 'taipei county', 'CHN071008');
INSERT INTO `cities` VALUES (879, 66, '9', 'Ilan County', '宜兰县', 'ilan county', 'CHN071009');
INSERT INTO `cities` VALUES (880, 66, '10', 'Taoyuan County', '桃园县', 'taoyuan county', 'CHN071010');
INSERT INTO `cities` VALUES (881, 66, '11', 'Hsinchu County', '新竹县', 'hsinchu county', 'CHN071011');
INSERT INTO `cities` VALUES (882, 66, '12', 'Miaoli County', '苗栗县', 'miaoli county', 'CHN071012');
INSERT INTO `cities` VALUES (883, 66, '13', 'Taichung County', '台中县', 'taichung county', 'CHN071013');
INSERT INTO `cities` VALUES (884, 66, '14', 'Changhwa County', '彰化县', 'changhwa county', 'CHN071014');
INSERT INTO `cities` VALUES (885, 66, '15', 'Nantou County', '南投县', 'nantou county', 'CHN071015');
INSERT INTO `cities` VALUES (886, 66, '16', 'Yunnlin County', '云林县', 'yunnlin county', 'CHN071016');
INSERT INTO `cities` VALUES (887, 66, '17', 'Chiayi County', '嘉义县', 'chiayi county', 'CHN071017');
INSERT INTO `cities` VALUES (888, 66, '18', 'Tainan County', '台南县', 'tainan county', 'CHN071018');
INSERT INTO `cities` VALUES (889, 66, '19', 'Kaohsiung County', '高雄县', 'kaohsiung county', 'CHN071019');
INSERT INTO `cities` VALUES (890, 66, '20', 'Pingtung County', '屏东县', 'pingtung county', 'CHN071020');
INSERT INTO `cities` VALUES (891, 66, '21', 'Penghu County', '澎湖县', 'penghu county', 'CHN071021');
INSERT INTO `cities` VALUES (892, 66, '22', 'Taitung County', '台东县', 'taitung county', 'CHN071022');
INSERT INTO `cities` VALUES (893, 66, '23', 'Hualian County', '花莲县', 'hualian county', 'CHN071023');
INSERT INTO `cities` VALUES (894, 67, 'HCW', NULL, '中西区', NULL, 'CHN081HCW');
INSERT INTO `cities` VALUES (895, 67, 'HEA', NULL, '东区', NULL, 'CHN081HEA');
INSERT INTO `cities` VALUES (896, 67, 'HSO', NULL, '南区', NULL, 'CHN081HSO');
INSERT INTO `cities` VALUES (897, 67, 'HWC', NULL, '湾仔区', NULL, 'CHN081HWC');
INSERT INTO `cities` VALUES (898, 67, 'KKC', NULL, '九龙城区', NULL, 'CHN081KKC');
INSERT INTO `cities` VALUES (899, 67, 'KKT', NULL, '观塘区', NULL, 'CHN081KKT');
INSERT INTO `cities` VALUES (900, 67, 'KSS', NULL, '深水埗区', NULL, 'CHN081KSS');
INSERT INTO `cities` VALUES (901, 67, 'KWT', NULL, '黄大仙区', NULL, 'CHN081KWT');
INSERT INTO `cities` VALUES (902, 67, 'KYT', NULL, '油尖旺区', NULL, 'CHN081KYT');
INSERT INTO `cities` VALUES (903, 67, 'NIS', NULL, '离岛区', NULL, 'CHN081NIS');
INSERT INTO `cities` VALUES (904, 67, 'NKT', NULL, '葵青区', NULL, 'CHN081NKT');
INSERT INTO `cities` VALUES (905, 67, 'NNO', NULL, '北区', NULL, 'CHN081NNO');
INSERT INTO `cities` VALUES (906, 67, 'NSK', NULL, '西贡区', NULL, 'CHN081NSK');
INSERT INTO `cities` VALUES (907, 67, 'NST', NULL, '沙田区', NULL, 'CHN081NST');
INSERT INTO `cities` VALUES (908, 67, 'NTM', NULL, '屯门区', NULL, 'CHN081NTM');
INSERT INTO `cities` VALUES (909, 67, 'NTP', NULL, '大埔区', NULL, 'CHN081NTP');
INSERT INTO `cities` VALUES (910, 67, 'NTW', NULL, '荃湾区', NULL, 'CHN081NTW');
INSERT INTO `cities` VALUES (911, 67, 'NYL', NULL, '元朗区', NULL, 'CHN081NYL');
INSERT INTO `cities` VALUES (912, 68, 'ANT', NULL, '圣安多尼堂区', NULL, 'CHN082ANT');
INSERT INTO `cities` VALUES (913, 68, 'CAT', NULL, '大堂区', NULL, 'CHN082CAT');
INSERT INTO `cities` VALUES (914, 68, 'CLN', NULL, '路环', NULL, 'CHN082CLN');
INSERT INTO `cities` VALUES (915, 68, 'LAW', NULL, '望德堂区', NULL, 'CHN082LAW');
INSERT INTO `cities` VALUES (916, 68, 'LAZ', NULL, '风顺堂区', NULL, 'CHN082LAZ');
INSERT INTO `cities` VALUES (917, 68, 'OLF', NULL, '花地玛堂区', NULL, 'CHN082OLF');
INSERT INTO `cities` VALUES (918, 68, 'TPA', NULL, '氹仔', NULL, 'CHN082TPA');
INSERT INTO `cities` VALUES (919, 69, 'AG', 'Agnebi', '阿涅比', 'agnebi', 'CIV0000AG');
INSERT INTO `cities` VALUES (920, 69, 'BF', 'Bafing', '巴芬', 'bafing', 'CIV0000BF');
INSERT INTO `cities` VALUES (921, 69, 'BS', 'Bas-Sassandra', '下萨桑德拉', 'bas-sassandra', 'CIV0000BS');
INSERT INTO `cities` VALUES (922, 69, 'DE', 'Denguele', '登盖莱', 'denguele', 'CIV0000DE');
INSERT INTO `cities` VALUES (923, 69, 'DH', 'Montagnes', '山地', 'montagnes', 'CIV0000DH');
INSERT INTO `cities` VALUES (924, 69, 'FR', 'Fromager', '弗罗马格尔', 'fromager', 'CIV0000FR');
INSERT INTO `cities` VALUES (925, 69, 'HT', 'Haut-Sassandra', '萨桑德拉', 'haut-sassandra', 'CIV0000HT');
INSERT INTO `cities` VALUES (926, 69, 'LC', 'Lacs', '湖泊', 'lacs', 'CIV0000LC');
INSERT INTO `cities` VALUES (927, 69, 'LG', 'Lagunes', '泻湖', 'lagunes', 'CIV0000LG');
INSERT INTO `cities` VALUES (928, 69, 'MC', 'Moyen-Comoe', '中科莫埃', 'moyen-comoe', 'CIV0000MC');
INSERT INTO `cities` VALUES (929, 69, 'MR', 'Marahoue', '马拉韦', 'marahoue', 'CIV0000MR');
INSERT INTO `cities` VALUES (930, 69, 'MV', 'Moyen-Cavally', '中卡瓦利', 'moyen-cavally', 'CIV0000MV');
INSERT INTO `cities` VALUES (931, 69, 'NC', 'Nzi-Comoe', '恩济-科莫埃', 'nzi-comoe', 'CIV0000NC');
INSERT INTO `cities` VALUES (932, 69, 'SB', 'Sud-Bandama', '南邦达马', 'sud-bandama', 'CIV0000SB');
INSERT INTO `cities` VALUES (933, 69, 'SC', 'Sud-Comoe', '南科莫埃', 'sud-comoe', 'CIV0000SC');
INSERT INTO `cities` VALUES (934, 69, 'SV', 'Savanes', '萨瓦纳', 'savanes', 'CIV0000SV');
INSERT INTO `cities` VALUES (935, 69, 'VB', 'Vallee du Bandama', '邦达马河谷', 'vallee du bandama', 'CIV0000VB');