-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcity.sql
More file actions
3463 lines (3458 loc) · 227 KB
/
city.sql
File metadata and controls
3463 lines (3458 loc) · 227 KB
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 MySQL Data Transfer
Source Server : 本地的
Source Server Version : 50024
Source Host : localhost:3306
Source Database : xl
Target Server Type : MYSQL
Target Server Version : 50024
File Encoding : 65001
Date: 2014-05-25 22:59:22
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `city`
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` varchar(255) NOT NULL,
`code` varchar(255) default NULL,
`parentCode` varchar(255) default NULL,
`name` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO city VALUES ('1', '110000', '-', '北京市');
INSERT INTO city VALUES ('10', '110108', '110100', '海淀区');
INSERT INTO city VALUES ('100', '130421', '130400', '邯郸县');
INSERT INTO city VALUES ('1000', '321100', '320000', '镇江市');
INSERT INTO city VALUES ('1001', '321101', '321100', '市辖区');
INSERT INTO city VALUES ('1002', '321102', '321100', '京口区');
INSERT INTO city VALUES ('1003', '321111', '321100', '润州区');
INSERT INTO city VALUES ('1004', '321112', '321100', '丹徒区');
INSERT INTO city VALUES ('1005', '321181', '321100', '丹阳市');
INSERT INTO city VALUES ('1006', '321182', '321100', '扬中市');
INSERT INTO city VALUES ('1007', '321183', '321100', '句容市');
INSERT INTO city VALUES ('1008', '321200', '320000', '泰州市');
INSERT INTO city VALUES ('1009', '321201', '321200', '市辖区');
INSERT INTO city VALUES ('101', '130423', '130400', '临漳县');
INSERT INTO city VALUES ('1010', '321202', '321200', '海陵区');
INSERT INTO city VALUES ('1011', '321203', '321200', '高港区');
INSERT INTO city VALUES ('1012', '321281', '321200', '兴化市');
INSERT INTO city VALUES ('1013', '321282', '321200', '靖江市');
INSERT INTO city VALUES ('1014', '321283', '321200', '泰兴市');
INSERT INTO city VALUES ('1015', '321284', '321200', '姜堰市');
INSERT INTO city VALUES ('1016', '321300', '320000', '宿迁市');
INSERT INTO city VALUES ('1017', '321301', '321300', '市辖区');
INSERT INTO city VALUES ('1018', '321302', '321300', '宿城区');
INSERT INTO city VALUES ('1019', '321311', '321300', '宿豫区');
INSERT INTO city VALUES ('102', '130424', '130400', '成安县');
INSERT INTO city VALUES ('1020', '321322', '321300', '沭阳县');
INSERT INTO city VALUES ('1021', '321323', '321300', '泗阳县');
INSERT INTO city VALUES ('1022', '321324', '321300', '泗洪县');
INSERT INTO city VALUES ('1023', '330000', '-', '浙江省');
INSERT INTO city VALUES ('1024', '330100', '330000', '杭州市');
INSERT INTO city VALUES ('1025', '330101', '330100', '市辖区');
INSERT INTO city VALUES ('1026', '330102', '330100', '上城区');
INSERT INTO city VALUES ('1027', '330103', '330100', '下城区');
INSERT INTO city VALUES ('1028', '330104', '330100', '江干区');
INSERT INTO city VALUES ('1029', '330105', '330100', '拱墅区');
INSERT INTO city VALUES ('103', '130425', '130400', '大名县');
INSERT INTO city VALUES ('1030', '330106', '330100', '西湖区');
INSERT INTO city VALUES ('1031', '330108', '330100', '滨江区');
INSERT INTO city VALUES ('1032', '330109', '330100', '萧山区');
INSERT INTO city VALUES ('1033', '330110', '330100', '余杭区');
INSERT INTO city VALUES ('1034', '330122', '330100', '桐庐县');
INSERT INTO city VALUES ('1035', '330127', '330100', '淳安县');
INSERT INTO city VALUES ('1036', '330182', '330100', '建德市');
INSERT INTO city VALUES ('1037', '330183', '330100', '富阳市');
INSERT INTO city VALUES ('1038', '330185', '330100', '临安市');
INSERT INTO city VALUES ('1039', '330200', '330000', '宁波市');
INSERT INTO city VALUES ('104', '130426', '130400', '涉县');
INSERT INTO city VALUES ('1040', '330201', '330200', '市辖区');
INSERT INTO city VALUES ('1041', '330203', '330200', '海曙区');
INSERT INTO city VALUES ('1042', '330204', '330200', '江东区');
INSERT INTO city VALUES ('1043', '330205', '330200', '江北区');
INSERT INTO city VALUES ('1044', '330206', '330200', '北仑区');
INSERT INTO city VALUES ('1045', '330211', '330200', '镇海区');
INSERT INTO city VALUES ('1046', '330212', '330200', '鄞州区');
INSERT INTO city VALUES ('1047', '330225', '330200', '象山县');
INSERT INTO city VALUES ('1048', '330226', '330200', '宁海县');
INSERT INTO city VALUES ('1049', '330281', '330200', '余姚市');
INSERT INTO city VALUES ('105', '130427', '130400', '磁县');
INSERT INTO city VALUES ('1050', '330282', '330200', '慈溪市');
INSERT INTO city VALUES ('1051', '330283', '330200', '奉化市');
INSERT INTO city VALUES ('1052', '330300', '330000', '温州市');
INSERT INTO city VALUES ('1053', '330301', '330300', '市辖区');
INSERT INTO city VALUES ('1054', '330302', '330300', '鹿城区');
INSERT INTO city VALUES ('1055', '330303', '330300', '龙湾区');
INSERT INTO city VALUES ('1056', '330304', '330300', '瓯海区');
INSERT INTO city VALUES ('1057', '330322', '330300', '洞头县');
INSERT INTO city VALUES ('1058', '330324', '330300', '永嘉县');
INSERT INTO city VALUES ('1059', '330326', '330300', '平阳县');
INSERT INTO city VALUES ('106', '130428', '130400', '肥乡县');
INSERT INTO city VALUES ('1060', '330327', '330300', '苍南县');
INSERT INTO city VALUES ('1061', '330328', '330300', '文成县');
INSERT INTO city VALUES ('1062', '330329', '330300', '泰顺县');
INSERT INTO city VALUES ('1063', '330381', '330300', '瑞安市');
INSERT INTO city VALUES ('1064', '330382', '330300', '乐清市');
INSERT INTO city VALUES ('1065', '330400', '330000', '嘉兴市');
INSERT INTO city VALUES ('1066', '330401', '330400', '市辖区');
INSERT INTO city VALUES ('1067', '330402', '330400', '南湖区(**)');
INSERT INTO city VALUES ('1068', '330411', '330400', '秀洲区');
INSERT INTO city VALUES ('1069', '330421', '330400', '嘉善县');
INSERT INTO city VALUES ('107', '130429', '130400', '永年县');
INSERT INTO city VALUES ('1070', '330424', '330400', '海盐县');
INSERT INTO city VALUES ('1071', '330481', '330400', '海宁市');
INSERT INTO city VALUES ('1072', '330482', '330400', '平湖市');
INSERT INTO city VALUES ('1073', '330483', '330400', '桐乡市');
INSERT INTO city VALUES ('1074', '330500', '330000', '湖州市');
INSERT INTO city VALUES ('1075', '330501', '330500', '市辖区');
INSERT INTO city VALUES ('1076', '330502', '330500', '吴兴区');
INSERT INTO city VALUES ('1077', '330503', '330500', '南浔区');
INSERT INTO city VALUES ('1078', '330521', '330500', '德清县');
INSERT INTO city VALUES ('1079', '330522', '330500', '长兴县');
INSERT INTO city VALUES ('108', '130430', '130400', '邱县');
INSERT INTO city VALUES ('1080', '330523', '330500', '安吉县');
INSERT INTO city VALUES ('1081', '330600', '330000', '绍兴市');
INSERT INTO city VALUES ('1082', '330601', '330600', '市辖区');
INSERT INTO city VALUES ('1083', '330602', '330600', '越城区');
INSERT INTO city VALUES ('1084', '330621', '330600', '绍兴县');
INSERT INTO city VALUES ('1085', '330624', '330600', '新昌县');
INSERT INTO city VALUES ('1086', '330681', '330600', '诸暨市');
INSERT INTO city VALUES ('1087', '330682', '330600', '上虞市');
INSERT INTO city VALUES ('1088', '330683', '330600', '嵊州市');
INSERT INTO city VALUES ('1089', '330700', '330000', '金华市');
INSERT INTO city VALUES ('109', '130431', '130400', '鸡泽县');
INSERT INTO city VALUES ('1090', '330701', '330700', '市辖区');
INSERT INTO city VALUES ('1091', '330702', '330700', '婺城区');
INSERT INTO city VALUES ('1092', '330703', '330700', '金东区');
INSERT INTO city VALUES ('1093', '330723', '330700', '武义县');
INSERT INTO city VALUES ('1094', '330726', '330700', '浦江县');
INSERT INTO city VALUES ('1095', '330727', '330700', '磐安县');
INSERT INTO city VALUES ('1096', '330781', '330700', '兰溪市');
INSERT INTO city VALUES ('1097', '330782', '330700', '义乌市');
INSERT INTO city VALUES ('1098', '330783', '330700', '东阳市');
INSERT INTO city VALUES ('1099', '330784', '330700', '永康市');
INSERT INTO city VALUES ('11', '110109', '110100', '门头沟区');
INSERT INTO city VALUES ('110', '130432', '130400', '广平县');
INSERT INTO city VALUES ('1100', '330800', '330000', '衢州市');
INSERT INTO city VALUES ('1101', '330801', '330800', '市辖区');
INSERT INTO city VALUES ('1102', '330802', '330800', '柯城区');
INSERT INTO city VALUES ('1103', '330803', '330800', '衢江区');
INSERT INTO city VALUES ('1104', '330822', '330800', '常山县');
INSERT INTO city VALUES ('1105', '330824', '330800', '开化县');
INSERT INTO city VALUES ('1106', '330825', '330800', '龙游县');
INSERT INTO city VALUES ('1107', '330881', '330800', '江山市');
INSERT INTO city VALUES ('1108', '330900', '330000', '舟山市');
INSERT INTO city VALUES ('1109', '330901', '330900', '市辖区');
INSERT INTO city VALUES ('111', '130433', '130400', '馆陶县');
INSERT INTO city VALUES ('1110', '330902', '330900', '定海区');
INSERT INTO city VALUES ('1111', '330903', '330900', '普陀区');
INSERT INTO city VALUES ('1112', '330921', '330900', '岱山县');
INSERT INTO city VALUES ('1113', '330922', '330900', '嵊泗县');
INSERT INTO city VALUES ('1114', '331000', '330000', '台州市');
INSERT INTO city VALUES ('1115', '331001', '331000', '市辖区');
INSERT INTO city VALUES ('1116', '331002', '331000', '椒江区');
INSERT INTO city VALUES ('1117', '331003', '331000', '黄岩区');
INSERT INTO city VALUES ('1118', '331004', '331000', '路桥区');
INSERT INTO city VALUES ('1119', '331021', '331000', '玉环县');
INSERT INTO city VALUES ('112', '130434', '130400', '魏县');
INSERT INTO city VALUES ('1120', '331022', '331000', '三门县');
INSERT INTO city VALUES ('1121', '331023', '331000', '天台县');
INSERT INTO city VALUES ('1122', '331024', '331000', '仙居县');
INSERT INTO city VALUES ('1123', '331081', '331000', '温岭市');
INSERT INTO city VALUES ('1124', '331082', '331000', '临海市');
INSERT INTO city VALUES ('1125', '331100', '330000', '丽水市');
INSERT INTO city VALUES ('1126', '331101', '331100', '市辖区');
INSERT INTO city VALUES ('1127', '331102', '331100', '莲都区');
INSERT INTO city VALUES ('1128', '331121', '331100', '青田县');
INSERT INTO city VALUES ('1129', '331122', '331100', '缙云县');
INSERT INTO city VALUES ('113', '130435', '130400', '曲周县');
INSERT INTO city VALUES ('1130', '331123', '331100', '遂昌县');
INSERT INTO city VALUES ('1131', '331124', '331100', '松阳县');
INSERT INTO city VALUES ('1132', '331125', '331100', '云和县');
INSERT INTO city VALUES ('1133', '331126', '331100', '庆元县');
INSERT INTO city VALUES ('1134', '331127', '331100', '景宁畲族自治县');
INSERT INTO city VALUES ('1135', '331181', '331100', '龙泉市');
INSERT INTO city VALUES ('1136', '340000', '-', '安徽省');
INSERT INTO city VALUES ('1137', '340100', '340000', '合肥市');
INSERT INTO city VALUES ('1138', '340101', '340100', '市辖区');
INSERT INTO city VALUES ('1139', '340102', '340100', '瑶海区');
INSERT INTO city VALUES ('114', '130481', '130400', '武安市');
INSERT INTO city VALUES ('1140', '340103', '340100', '庐阳区');
INSERT INTO city VALUES ('1141', '340104', '340100', '蜀山区');
INSERT INTO city VALUES ('1142', '340111', '340100', '包河区');
INSERT INTO city VALUES ('1143', '340121', '340100', '长丰县');
INSERT INTO city VALUES ('1144', '340122', '340100', '肥东县');
INSERT INTO city VALUES ('1145', '340123', '340100', '肥西县');
INSERT INTO city VALUES ('1146', '340200', '340000', '芜湖市');
INSERT INTO city VALUES ('1147', '340201', '340200', '市辖区');
INSERT INTO city VALUES ('1148', '340202', '340200', '镜湖区');
INSERT INTO city VALUES ('1149', '340203', '340200', '弋江区');
INSERT INTO city VALUES ('115', '130500', '130000', '邢台市');
INSERT INTO city VALUES ('1150', '340207', '340200', '鸠江区');
INSERT INTO city VALUES ('1151', '340208', '340200', '三山区');
INSERT INTO city VALUES ('1152', '340221', '340200', '芜湖县');
INSERT INTO city VALUES ('1153', '340222', '340200', '繁昌县');
INSERT INTO city VALUES ('1154', '340223', '340200', '南陵县');
INSERT INTO city VALUES ('1155', '340300', '340000', '蚌埠市');
INSERT INTO city VALUES ('1156', '340301', '340300', '市辖区');
INSERT INTO city VALUES ('1157', '340302', '340300', '龙子湖区');
INSERT INTO city VALUES ('1158', '340303', '340300', '蚌山区');
INSERT INTO city VALUES ('1159', '340304', '340300', '禹会区');
INSERT INTO city VALUES ('116', '130501', '130500', '市辖区');
INSERT INTO city VALUES ('1160', '340311', '340300', '淮上区');
INSERT INTO city VALUES ('1161', '340321', '340300', '怀远县');
INSERT INTO city VALUES ('1162', '340322', '340300', '五河县');
INSERT INTO city VALUES ('1163', '340323', '340300', '固镇县');
INSERT INTO city VALUES ('1164', '340400', '340000', '淮南市');
INSERT INTO city VALUES ('1165', '340401', '340400', '市辖区');
INSERT INTO city VALUES ('1166', '340402', '340400', '大通区');
INSERT INTO city VALUES ('1167', '340403', '340400', '田家庵区');
INSERT INTO city VALUES ('1168', '340404', '340400', '谢家集区');
INSERT INTO city VALUES ('1169', '340405', '340400', '八公山区');
INSERT INTO city VALUES ('117', '130502', '130500', '桥东区');
INSERT INTO city VALUES ('1170', '340406', '340400', '潘集区');
INSERT INTO city VALUES ('1171', '340421', '340400', '凤台县');
INSERT INTO city VALUES ('1172', '340500', '340000', '马鞍山市');
INSERT INTO city VALUES ('1173', '340501', '340500', '市辖区');
INSERT INTO city VALUES ('1174', '340502', '340500', '金家庄区');
INSERT INTO city VALUES ('1175', '340503', '340500', '花山区');
INSERT INTO city VALUES ('1176', '340504', '340500', '雨山区');
INSERT INTO city VALUES ('1177', '340521', '340500', '当涂县');
INSERT INTO city VALUES ('1178', '340600', '340000', '淮北市');
INSERT INTO city VALUES ('1179', '340601', '340600', '市辖区');
INSERT INTO city VALUES ('118', '130503', '130500', '桥西区');
INSERT INTO city VALUES ('1180', '340602', '340600', '杜集区');
INSERT INTO city VALUES ('1181', '340603', '340600', '相山区');
INSERT INTO city VALUES ('1182', '340604', '340600', '烈山区');
INSERT INTO city VALUES ('1183', '340621', '340600', '濉溪县');
INSERT INTO city VALUES ('1184', '340700', '340000', '铜陵市');
INSERT INTO city VALUES ('1185', '340701', '340700', '市辖区');
INSERT INTO city VALUES ('1186', '340702', '340700', '铜官山区');
INSERT INTO city VALUES ('1187', '340703', '340700', '狮子山区');
INSERT INTO city VALUES ('1188', '340711', '340700', '郊区');
INSERT INTO city VALUES ('1189', '340721', '340700', '铜陵县');
INSERT INTO city VALUES ('119', '130521', '130500', '邢台县');
INSERT INTO city VALUES ('1190', '340800', '340000', '安庆市');
INSERT INTO city VALUES ('1191', '340801', '340800', '市辖区');
INSERT INTO city VALUES ('1192', '340802', '340800', '迎江区');
INSERT INTO city VALUES ('1193', '340803', '340800', '大观区');
INSERT INTO city VALUES ('1194', '340811', '340800', '宜秀区');
INSERT INTO city VALUES ('1195', '340822', '340800', '怀宁县');
INSERT INTO city VALUES ('1196', '340823', '340800', '枞阳县');
INSERT INTO city VALUES ('1197', '340824', '340800', '潜山县');
INSERT INTO city VALUES ('1198', '340825', '340800', '太湖县');
INSERT INTO city VALUES ('1199', '340826', '340800', '宿松县');
INSERT INTO city VALUES ('12', '110111', '110100', '房山区');
INSERT INTO city VALUES ('120', '130522', '130500', '临城县');
INSERT INTO city VALUES ('1200', '340827', '340800', '望江县');
INSERT INTO city VALUES ('1201', '340828', '340800', '岳西县');
INSERT INTO city VALUES ('1202', '340881', '340800', '桐城市');
INSERT INTO city VALUES ('1203', '341000', '340000', '黄山市');
INSERT INTO city VALUES ('1204', '341001', '341000', '市辖区');
INSERT INTO city VALUES ('1205', '341002', '341000', '屯溪区');
INSERT INTO city VALUES ('1206', '341003', '341000', '黄山区');
INSERT INTO city VALUES ('1207', '341004', '341000', '徽州区');
INSERT INTO city VALUES ('1208', '341021', '341000', '歙县');
INSERT INTO city VALUES ('1209', '341022', '341000', '休宁县');
INSERT INTO city VALUES ('121', '130523', '130500', '内丘县');
INSERT INTO city VALUES ('1210', '341023', '341000', '黟县');
INSERT INTO city VALUES ('1211', '341024', '341000', '祁门县');
INSERT INTO city VALUES ('1212', '341100', '340000', '滁州市');
INSERT INTO city VALUES ('1213', '341101', '341100', '市辖区');
INSERT INTO city VALUES ('1214', '341102', '341100', '琅琊区');
INSERT INTO city VALUES ('1215', '341103', '341100', '南谯区');
INSERT INTO city VALUES ('1216', '341122', '341100', '来安县');
INSERT INTO city VALUES ('1217', '341124', '341100', '全椒县');
INSERT INTO city VALUES ('1218', '341125', '341100', '定远县');
INSERT INTO city VALUES ('1219', '341126', '341100', '凤阳县');
INSERT INTO city VALUES ('122', '130524', '130500', '柏乡县');
INSERT INTO city VALUES ('1220', '341181', '341100', '天长市');
INSERT INTO city VALUES ('1221', '341182', '341100', '明光市');
INSERT INTO city VALUES ('1222', '341200', '340000', '阜阳市');
INSERT INTO city VALUES ('1223', '341201', '341200', '市辖区');
INSERT INTO city VALUES ('1224', '341202', '341200', '颍州区');
INSERT INTO city VALUES ('1225', '341203', '341200', '颍东区');
INSERT INTO city VALUES ('1226', '341204', '341200', '颍泉区');
INSERT INTO city VALUES ('1227', '341221', '341200', '临泉县');
INSERT INTO city VALUES ('1228', '341222', '341200', '太和县');
INSERT INTO city VALUES ('1229', '341225', '341200', '阜南县');
INSERT INTO city VALUES ('123', '130525', '130500', '隆尧县');
INSERT INTO city VALUES ('1230', '341226', '341200', '颍上县');
INSERT INTO city VALUES ('1231', '341282', '341200', '界首市');
INSERT INTO city VALUES ('1232', '341300', '340000', '宿州市');
INSERT INTO city VALUES ('1233', '341301', '341300', '市辖区');
INSERT INTO city VALUES ('1234', '341302', '341300', '埇桥区');
INSERT INTO city VALUES ('1235', '341321', '341300', '砀山县');
INSERT INTO city VALUES ('1236', '341322', '341300', '萧县');
INSERT INTO city VALUES ('1237', '341323', '341300', '灵璧县');
INSERT INTO city VALUES ('1238', '341324', '341300', '泗县');
INSERT INTO city VALUES ('1239', '341400', '340000', '巢湖市');
INSERT INTO city VALUES ('124', '130526', '130500', '任县');
INSERT INTO city VALUES ('1240', '341401', '341400', '市辖区');
INSERT INTO city VALUES ('1241', '341402', '341400', '居巢区');
INSERT INTO city VALUES ('1242', '341421', '341400', '庐江县');
INSERT INTO city VALUES ('1243', '341422', '341400', '无为县');
INSERT INTO city VALUES ('1244', '341423', '341400', '含山县');
INSERT INTO city VALUES ('1245', '341424', '341400', '和县');
INSERT INTO city VALUES ('1246', '341500', '340000', '六安市');
INSERT INTO city VALUES ('1247', '341501', '341500', '市辖区');
INSERT INTO city VALUES ('1248', '341502', '341500', '金安区');
INSERT INTO city VALUES ('1249', '341503', '341500', '裕安区');
INSERT INTO city VALUES ('125', '130527', '130500', '南和县');
INSERT INTO city VALUES ('1250', '341521', '341500', '寿县');
INSERT INTO city VALUES ('1251', '341522', '341500', '霍邱县');
INSERT INTO city VALUES ('1252', '341523', '341500', '舒城县');
INSERT INTO city VALUES ('1253', '341524', '341500', '金寨县');
INSERT INTO city VALUES ('1254', '341525', '341500', '霍山县');
INSERT INTO city VALUES ('1255', '341600', '340000', '亳州市');
INSERT INTO city VALUES ('1256', '341601', '341600', '市辖区');
INSERT INTO city VALUES ('1257', '341602', '341600', '谯城区');
INSERT INTO city VALUES ('1258', '341621', '341600', '涡阳县');
INSERT INTO city VALUES ('1259', '341622', '341600', '蒙城县');
INSERT INTO city VALUES ('126', '130528', '130500', '宁晋县');
INSERT INTO city VALUES ('1260', '341623', '341600', '利辛县');
INSERT INTO city VALUES ('1261', '341700', '340000', '池州市');
INSERT INTO city VALUES ('1262', '341701', '341700', '市辖区');
INSERT INTO city VALUES ('1263', '341702', '341700', '贵池区');
INSERT INTO city VALUES ('1264', '341721', '341700', '东至县');
INSERT INTO city VALUES ('1265', '341722', '341700', '石台县');
INSERT INTO city VALUES ('1266', '341723', '341700', '青阳县');
INSERT INTO city VALUES ('1267', '341800', '340000', '宣城市');
INSERT INTO city VALUES ('1268', '341801', '341800', '市辖区');
INSERT INTO city VALUES ('1269', '341802', '341800', '宣州区');
INSERT INTO city VALUES ('127', '130529', '130500', '巨鹿县');
INSERT INTO city VALUES ('1270', '341821', '341800', '郎溪县');
INSERT INTO city VALUES ('1271', '341822', '341800', '广德县');
INSERT INTO city VALUES ('1272', '341823', '341800', '泾县');
INSERT INTO city VALUES ('1273', '341824', '341800', '绩溪县');
INSERT INTO city VALUES ('1274', '341825', '341800', '旌德县');
INSERT INTO city VALUES ('1275', '341881', '341800', '宁国市');
INSERT INTO city VALUES ('1276', '350000', '-', '福建省');
INSERT INTO city VALUES ('1277', '350100', '350000', '福州市');
INSERT INTO city VALUES ('1278', '350101', '350100', '市辖区');
INSERT INTO city VALUES ('1279', '350102', '350100', '鼓楼区');
INSERT INTO city VALUES ('128', '130530', '130500', '新河县');
INSERT INTO city VALUES ('1280', '350103', '350100', '台江区');
INSERT INTO city VALUES ('1281', '350104', '350100', '仓山区');
INSERT INTO city VALUES ('1282', '350105', '350100', '马尾区');
INSERT INTO city VALUES ('1283', '350111', '350100', '晋安区');
INSERT INTO city VALUES ('1284', '350121', '350100', '闽侯县');
INSERT INTO city VALUES ('1285', '350122', '350100', '连江县');
INSERT INTO city VALUES ('1286', '350123', '350100', '罗源县');
INSERT INTO city VALUES ('1287', '350124', '350100', '闽清县');
INSERT INTO city VALUES ('1288', '350125', '350100', '永泰县');
INSERT INTO city VALUES ('1289', '350128', '350100', '平潭县');
INSERT INTO city VALUES ('129', '130531', '130500', '广宗县');
INSERT INTO city VALUES ('1290', '350181', '350100', '福清市');
INSERT INTO city VALUES ('1291', '350182', '350100', '长乐市');
INSERT INTO city VALUES ('1292', '350200', '350000', '厦门市');
INSERT INTO city VALUES ('1293', '350201', '350200', '市辖区');
INSERT INTO city VALUES ('1294', '350203', '350200', '思明区');
INSERT INTO city VALUES ('1295', '350205', '350200', '海沧区');
INSERT INTO city VALUES ('1296', '350206', '350200', '湖里区');
INSERT INTO city VALUES ('1297', '350211', '350200', '集美区');
INSERT INTO city VALUES ('1298', '350212', '350200', '同安区');
INSERT INTO city VALUES ('1299', '350213', '350200', '翔安区');
INSERT INTO city VALUES ('13', '110112', '110100', '通州区');
INSERT INTO city VALUES ('130', '130532', '130500', '平乡县');
INSERT INTO city VALUES ('1300', '350300', '350000', '莆田市');
INSERT INTO city VALUES ('1301', '350301', '350300', '市辖区');
INSERT INTO city VALUES ('1302', '350302', '350300', '城厢区');
INSERT INTO city VALUES ('1303', '350303', '350300', '涵江区');
INSERT INTO city VALUES ('1304', '350304', '350300', '荔城区');
INSERT INTO city VALUES ('1305', '350305', '350300', '秀屿区');
INSERT INTO city VALUES ('1306', '350322', '350300', '仙游县');
INSERT INTO city VALUES ('1307', '350400', '350000', '三明市');
INSERT INTO city VALUES ('1308', '350401', '350400', '市辖区');
INSERT INTO city VALUES ('1309', '350402', '350400', '梅列区');
INSERT INTO city VALUES ('131', '130533', '130500', '威县');
INSERT INTO city VALUES ('1310', '350403', '350400', '三元区');
INSERT INTO city VALUES ('1311', '350421', '350400', '明溪县');
INSERT INTO city VALUES ('1312', '350423', '350400', '清流县');
INSERT INTO city VALUES ('1313', '350424', '350400', '宁化县');
INSERT INTO city VALUES ('1314', '350425', '350400', '大田县');
INSERT INTO city VALUES ('1315', '350426', '350400', '尤溪县');
INSERT INTO city VALUES ('1316', '350427', '350400', '沙县');
INSERT INTO city VALUES ('1317', '350428', '350400', '将乐县');
INSERT INTO city VALUES ('1318', '350429', '350400', '泰宁县');
INSERT INTO city VALUES ('1319', '350430', '350400', '建宁县');
INSERT INTO city VALUES ('132', '130534', '130500', '清河县');
INSERT INTO city VALUES ('1320', '350481', '350400', '永安市');
INSERT INTO city VALUES ('1321', '350500', '350000', '泉州市');
INSERT INTO city VALUES ('1322', '350501', '350500', '市辖区');
INSERT INTO city VALUES ('1323', '350502', '350500', '鲤城区');
INSERT INTO city VALUES ('1324', '350503', '350500', '丰泽区');
INSERT INTO city VALUES ('1325', '350504', '350500', '洛江区');
INSERT INTO city VALUES ('1326', '350505', '350500', '泉港区');
INSERT INTO city VALUES ('1327', '350521', '350500', '惠安县');
INSERT INTO city VALUES ('1328', '350524', '350500', '安溪县');
INSERT INTO city VALUES ('1329', '350525', '350500', '永春县');
INSERT INTO city VALUES ('133', '130535', '130500', '临西县');
INSERT INTO city VALUES ('1330', '350526', '350500', '德化县');
INSERT INTO city VALUES ('1331', '350527', '350500', '金门县');
INSERT INTO city VALUES ('1332', '350581', '350500', '石狮市');
INSERT INTO city VALUES ('1333', '350582', '350500', '晋江市');
INSERT INTO city VALUES ('1334', '350583', '350500', '南安市');
INSERT INTO city VALUES ('1335', '350600', '350000', '漳州市');
INSERT INTO city VALUES ('1336', '350601', '350600', '市辖区');
INSERT INTO city VALUES ('1337', '350602', '350600', '芗城区');
INSERT INTO city VALUES ('1338', '350603', '350600', '龙文区');
INSERT INTO city VALUES ('1339', '350622', '350600', '云霄县');
INSERT INTO city VALUES ('134', '130581', '130500', '南宫市');
INSERT INTO city VALUES ('1340', '350623', '350600', '漳浦县');
INSERT INTO city VALUES ('1341', '350624', '350600', '诏安县');
INSERT INTO city VALUES ('1342', '350625', '350600', '长泰县');
INSERT INTO city VALUES ('1343', '350626', '350600', '东山县');
INSERT INTO city VALUES ('1344', '350627', '350600', '南靖县');
INSERT INTO city VALUES ('1345', '350628', '350600', '平和县');
INSERT INTO city VALUES ('1346', '350629', '350600', '华安县');
INSERT INTO city VALUES ('1347', '350681', '350600', '龙海市');
INSERT INTO city VALUES ('1348', '350700', '350000', '南平市');
INSERT INTO city VALUES ('1349', '350701', '350700', '市辖区');
INSERT INTO city VALUES ('135', '130582', '130500', '沙河市');
INSERT INTO city VALUES ('1350', '350702', '350700', '延平区');
INSERT INTO city VALUES ('1351', '350721', '350700', '顺昌县');
INSERT INTO city VALUES ('1352', '350722', '350700', '浦城县');
INSERT INTO city VALUES ('1353', '350723', '350700', '光泽县');
INSERT INTO city VALUES ('1354', '350724', '350700', '松溪县');
INSERT INTO city VALUES ('1355', '350725', '350700', '政和县');
INSERT INTO city VALUES ('1356', '350781', '350700', '邵武市');
INSERT INTO city VALUES ('1357', '350782', '350700', '武夷山市');
INSERT INTO city VALUES ('1358', '350783', '350700', '建瓯市');
INSERT INTO city VALUES ('1359', '350784', '350700', '建阳市');
INSERT INTO city VALUES ('136', '130600', '130000', '保定市');
INSERT INTO city VALUES ('1360', '350800', '350000', '龙岩市');
INSERT INTO city VALUES ('1361', '350801', '350800', '市辖区');
INSERT INTO city VALUES ('1362', '350802', '350800', '新罗区');
INSERT INTO city VALUES ('1363', '350821', '350800', '长汀县');
INSERT INTO city VALUES ('1364', '350822', '350800', '永定县');
INSERT INTO city VALUES ('1365', '350823', '350800', '上杭县');
INSERT INTO city VALUES ('1366', '350824', '350800', '武平县');
INSERT INTO city VALUES ('1367', '350825', '350800', '连城县');
INSERT INTO city VALUES ('1368', '350881', '350800', '漳平市');
INSERT INTO city VALUES ('1369', '350900', '350000', '宁德市');
INSERT INTO city VALUES ('137', '130601', '130600', '市辖区');
INSERT INTO city VALUES ('1370', '350901', '350900', '市辖区');
INSERT INTO city VALUES ('1371', '350902', '350900', '蕉城区');
INSERT INTO city VALUES ('1372', '350921', '350900', '霞浦县');
INSERT INTO city VALUES ('1373', '350922', '350900', '古田县');
INSERT INTO city VALUES ('1374', '350923', '350900', '屏南县');
INSERT INTO city VALUES ('1375', '350924', '350900', '寿宁县');
INSERT INTO city VALUES ('1376', '350925', '350900', '周宁县');
INSERT INTO city VALUES ('1377', '350926', '350900', '柘荣县');
INSERT INTO city VALUES ('1378', '350981', '350900', '福安市');
INSERT INTO city VALUES ('1379', '350982', '350900', '福鼎市');
INSERT INTO city VALUES ('138', '130602', '130600', '新市区');
INSERT INTO city VALUES ('1380', '360000', '-', '江西省');
INSERT INTO city VALUES ('1381', '360100', '360000', '南昌市');
INSERT INTO city VALUES ('1382', '360101', '360100', '市辖区');
INSERT INTO city VALUES ('1383', '360102', '360100', '东湖区');
INSERT INTO city VALUES ('1384', '360103', '360100', '西湖区');
INSERT INTO city VALUES ('1385', '360104', '360100', '青云谱区');
INSERT INTO city VALUES ('1386', '360105', '360100', '湾里区');
INSERT INTO city VALUES ('1387', '360111', '360100', '青山湖区');
INSERT INTO city VALUES ('1388', '360121', '360100', '南昌县');
INSERT INTO city VALUES ('1389', '360122', '360100', '新建县');
INSERT INTO city VALUES ('139', '130603', '130600', '北市区');
INSERT INTO city VALUES ('1390', '360123', '360100', '安义县');
INSERT INTO city VALUES ('1391', '360124', '360100', '进贤县');
INSERT INTO city VALUES ('1392', '360200', '360000', '景德镇市');
INSERT INTO city VALUES ('1393', '360201', '360200', '市辖区');
INSERT INTO city VALUES ('1394', '360202', '360200', '昌江区');
INSERT INTO city VALUES ('1395', '360203', '360200', '珠山区');
INSERT INTO city VALUES ('1396', '360222', '360200', '浮梁县');
INSERT INTO city VALUES ('1397', '360281', '360200', '乐平市');
INSERT INTO city VALUES ('1398', '360300', '360000', '萍乡市');
INSERT INTO city VALUES ('1399', '360301', '360300', '市辖区');
INSERT INTO city VALUES ('14', '110113', '110100', '顺义区');
INSERT INTO city VALUES ('140', '130604', '130600', '南市区');
INSERT INTO city VALUES ('1400', '360302', '360300', '安源区');
INSERT INTO city VALUES ('1401', '360313', '360300', '湘东区');
INSERT INTO city VALUES ('1402', '360321', '360300', '莲花县');
INSERT INTO city VALUES ('1403', '360322', '360300', '上栗县');
INSERT INTO city VALUES ('1404', '360323', '360300', '芦溪县');
INSERT INTO city VALUES ('1405', '360400', '360000', '九江市');
INSERT INTO city VALUES ('1406', '360401', '360400', '市辖区');
INSERT INTO city VALUES ('1407', '360402', '360400', '庐山区');
INSERT INTO city VALUES ('1408', '360403', '360400', '浔阳区');
INSERT INTO city VALUES ('1409', '360421', '360400', '九江县');
INSERT INTO city VALUES ('141', '130621', '130600', '满城县');
INSERT INTO city VALUES ('1410', '360423', '360400', '武宁县');
INSERT INTO city VALUES ('1411', '360424', '360400', '修水县');
INSERT INTO city VALUES ('1412', '360425', '360400', '永修县');
INSERT INTO city VALUES ('1413', '360426', '360400', '德安县');
INSERT INTO city VALUES ('1414', '360427', '360400', '星子县');
INSERT INTO city VALUES ('1415', '360428', '360400', '都昌县');
INSERT INTO city VALUES ('1416', '360429', '360400', '湖口县');
INSERT INTO city VALUES ('1417', '360430', '360400', '彭泽县');
INSERT INTO city VALUES ('1418', '360481', '360400', '瑞昌市');
INSERT INTO city VALUES ('1419', '360500', '360000', '新余市');
INSERT INTO city VALUES ('142', '130622', '130600', '清苑县');
INSERT INTO city VALUES ('1420', '360501', '360500', '市辖区');
INSERT INTO city VALUES ('1421', '360502', '360500', '渝水区');
INSERT INTO city VALUES ('1422', '360521', '360500', '分宜县');
INSERT INTO city VALUES ('1423', '360600', '360000', '鹰潭市');
INSERT INTO city VALUES ('1424', '360601', '360600', '市辖区');
INSERT INTO city VALUES ('1425', '360602', '360600', '月湖区');
INSERT INTO city VALUES ('1426', '360622', '360600', '余江县');
INSERT INTO city VALUES ('1427', '360681', '360600', '贵溪市');
INSERT INTO city VALUES ('1428', '360700', '360000', '赣州市');
INSERT INTO city VALUES ('1429', '360701', '360700', '市辖区');
INSERT INTO city VALUES ('143', '130623', '130600', '涞水县');
INSERT INTO city VALUES ('1430', '360702', '360700', '章贡区');
INSERT INTO city VALUES ('1431', '360721', '360700', '赣县');
INSERT INTO city VALUES ('1432', '360722', '360700', '信丰县');
INSERT INTO city VALUES ('1433', '360723', '360700', '大余县');
INSERT INTO city VALUES ('1434', '360724', '360700', '上犹县');
INSERT INTO city VALUES ('1435', '360725', '360700', '崇义县');
INSERT INTO city VALUES ('1436', '360726', '360700', '安远县');
INSERT INTO city VALUES ('1437', '360727', '360700', '龙南县');
INSERT INTO city VALUES ('1438', '360728', '360700', '定南县');
INSERT INTO city VALUES ('1439', '360729', '360700', '全南县');
INSERT INTO city VALUES ('144', '130624', '130600', '阜平县');
INSERT INTO city VALUES ('1440', '360730', '360700', '宁都县');
INSERT INTO city VALUES ('1441', '360731', '360700', '于都县');
INSERT INTO city VALUES ('1442', '360732', '360700', '兴国县');
INSERT INTO city VALUES ('1443', '360733', '360700', '会昌县');
INSERT INTO city VALUES ('1444', '360734', '360700', '寻乌县');
INSERT INTO city VALUES ('1445', '360735', '360700', '石城县');
INSERT INTO city VALUES ('1446', '360781', '360700', '瑞金市');
INSERT INTO city VALUES ('1447', '360782', '360700', '南康市');
INSERT INTO city VALUES ('1448', '360800', '360000', '吉安市');
INSERT INTO city VALUES ('1449', '360801', '360800', '市辖区');
INSERT INTO city VALUES ('145', '130625', '130600', '徐水县');
INSERT INTO city VALUES ('1450', '360802', '360800', '吉州区');
INSERT INTO city VALUES ('1451', '360803', '360800', '青原区');
INSERT INTO city VALUES ('1452', '360821', '360800', '吉安县');
INSERT INTO city VALUES ('1453', '360822', '360800', '吉水县');
INSERT INTO city VALUES ('1454', '360823', '360800', '峡江县');
INSERT INTO city VALUES ('1455', '360824', '360800', '新干县');
INSERT INTO city VALUES ('1456', '360825', '360800', '永丰县');
INSERT INTO city VALUES ('1457', '360826', '360800', '泰和县');
INSERT INTO city VALUES ('1458', '360827', '360800', '遂川县');
INSERT INTO city VALUES ('1459', '360828', '360800', '万安县');
INSERT INTO city VALUES ('146', '130626', '130600', '定兴县');
INSERT INTO city VALUES ('1460', '360829', '360800', '安福县');
INSERT INTO city VALUES ('1461', '360830', '360800', '永新县');
INSERT INTO city VALUES ('1462', '360881', '360800', '井冈山市');
INSERT INTO city VALUES ('1463', '360900', '360000', '宜春市');
INSERT INTO city VALUES ('1464', '360901', '360900', '市辖区');
INSERT INTO city VALUES ('1465', '360902', '360900', '袁州区');
INSERT INTO city VALUES ('1466', '360921', '360900', '奉新县');
INSERT INTO city VALUES ('1467', '360922', '360900', '万载县');
INSERT INTO city VALUES ('1468', '360923', '360900', '上高县');
INSERT INTO city VALUES ('1469', '360924', '360900', '宜丰县');
INSERT INTO city VALUES ('147', '130627', '130600', '唐县');
INSERT INTO city VALUES ('1470', '360925', '360900', '靖安县');
INSERT INTO city VALUES ('1471', '360926', '360900', '铜鼓县');
INSERT INTO city VALUES ('1472', '360981', '360900', '丰城市');
INSERT INTO city VALUES ('1473', '360982', '360900', '樟树市');
INSERT INTO city VALUES ('1474', '360983', '360900', '高安市');
INSERT INTO city VALUES ('1475', '361000', '360000', '抚州市');
INSERT INTO city VALUES ('1476', '361001', '361000', '市辖区');
INSERT INTO city VALUES ('1477', '361002', '361000', '临川区');
INSERT INTO city VALUES ('1478', '361021', '361000', '南城县');
INSERT INTO city VALUES ('1479', '361022', '361000', '黎川县');
INSERT INTO city VALUES ('148', '130628', '130600', '高阳县');
INSERT INTO city VALUES ('1480', '361023', '361000', '南丰县');
INSERT INTO city VALUES ('1481', '361024', '361000', '崇仁县');
INSERT INTO city VALUES ('1482', '361025', '361000', '乐安县');
INSERT INTO city VALUES ('1483', '361026', '361000', '宜黄县');
INSERT INTO city VALUES ('1484', '361027', '361000', '金溪县');
INSERT INTO city VALUES ('1485', '361028', '361000', '资溪县');
INSERT INTO city VALUES ('1486', '361029', '361000', '东乡县');
INSERT INTO city VALUES ('1487', '361030', '361000', '广昌县');
INSERT INTO city VALUES ('1488', '361100', '360000', '上饶市');
INSERT INTO city VALUES ('1489', '361101', '361100', '市辖区');
INSERT INTO city VALUES ('149', '130629', '130600', '容城县');
INSERT INTO city VALUES ('1490', '361102', '361100', '信州区');
INSERT INTO city VALUES ('1491', '361121', '361100', '上饶县');
INSERT INTO city VALUES ('1492', '361122', '361100', '广丰县');
INSERT INTO city VALUES ('1493', '361123', '361100', '玉山县');
INSERT INTO city VALUES ('1494', '361124', '361100', '铅山县');
INSERT INTO city VALUES ('1495', '361125', '361100', '横峰县');
INSERT INTO city VALUES ('1496', '361126', '361100', '弋阳县');
INSERT INTO city VALUES ('1497', '361127', '361100', '余干县');
INSERT INTO city VALUES ('1498', '361128', '361100', '鄱阳县');
INSERT INTO city VALUES ('1499', '361129', '361100', '万年县');
INSERT INTO city VALUES ('15', '110114', '110100', '昌平区');
INSERT INTO city VALUES ('150', '130630', '130600', '涞源县');
INSERT INTO city VALUES ('1500', '361130', '361100', '婺源县');
INSERT INTO city VALUES ('1501', '361181', '361100', '德兴市');
INSERT INTO city VALUES ('1502', '370000', '-', '山东省');
INSERT INTO city VALUES ('1503', '370100', '370000', '济南市');
INSERT INTO city VALUES ('1504', '370101', '370100', '市辖区');
INSERT INTO city VALUES ('1505', '370102', '370100', '历下区');
INSERT INTO city VALUES ('1506', '370103', '370100', '市中区');
INSERT INTO city VALUES ('1507', '370104', '370100', '槐荫区');
INSERT INTO city VALUES ('1508', '370105', '370100', '天桥区');
INSERT INTO city VALUES ('1509', '370112', '370100', '历城区');
INSERT INTO city VALUES ('151', '130631', '130600', '望都县');
INSERT INTO city VALUES ('1510', '370113', '370100', '长清区');
INSERT INTO city VALUES ('1511', '370124', '370100', '平阴县');
INSERT INTO city VALUES ('1512', '370125', '370100', '济阳县');
INSERT INTO city VALUES ('1513', '370126', '370100', '商河县');
INSERT INTO city VALUES ('1514', '370181', '370100', '章丘市');
INSERT INTO city VALUES ('1515', '370200', '370000', '青岛市');
INSERT INTO city VALUES ('1516', '370201', '370200', '市辖区');
INSERT INTO city VALUES ('1517', '370202', '370200', '市南区');
INSERT INTO city VALUES ('1518', '370203', '370200', '市北区');
INSERT INTO city VALUES ('1519', '370205', '370200', '四方区');
INSERT INTO city VALUES ('152', '130632', '130600', '安新县');
INSERT INTO city VALUES ('1520', '370211', '370200', '黄岛区');
INSERT INTO city VALUES ('1521', '370212', '370200', '崂山区');
INSERT INTO city VALUES ('1522', '370213', '370200', '李沧区');
INSERT INTO city VALUES ('1523', '370214', '370200', '城阳区');
INSERT INTO city VALUES ('1524', '370281', '370200', '胶州市');
INSERT INTO city VALUES ('1525', '370282', '370200', '即墨市');
INSERT INTO city VALUES ('1526', '370283', '370200', '平度市');
INSERT INTO city VALUES ('1527', '370284', '370200', '胶南市');
INSERT INTO city VALUES ('1528', '370285', '370200', '莱西市');
INSERT INTO city VALUES ('1529', '370300', '370000', '淄博市');
INSERT INTO city VALUES ('153', '130633', '130600', '易县');
INSERT INTO city VALUES ('1530', '370301', '370300', '市辖区');
INSERT INTO city VALUES ('1531', '370302', '370300', '淄川区');
INSERT INTO city VALUES ('1532', '370303', '370300', '张店区');
INSERT INTO city VALUES ('1533', '370304', '370300', '博山区');
INSERT INTO city VALUES ('1534', '370305', '370300', '临淄区');
INSERT INTO city VALUES ('1535', '370306', '370300', '周村区');
INSERT INTO city VALUES ('1536', '370321', '370300', '桓台县');
INSERT INTO city VALUES ('1537', '370322', '370300', '高青县');
INSERT INTO city VALUES ('1538', '370323', '370300', '沂源县');
INSERT INTO city VALUES ('1539', '370400', '370000', '枣庄市');
INSERT INTO city VALUES ('154', '130634', '130600', '曲阳县');
INSERT INTO city VALUES ('1540', '370401', '370400', '市辖区');
INSERT INTO city VALUES ('1541', '370402', '370400', '市中区');
INSERT INTO city VALUES ('1542', '370403', '370400', '薛城区');
INSERT INTO city VALUES ('1543', '370404', '370400', '峄城区');
INSERT INTO city VALUES ('1544', '370405', '370400', '台儿庄区');
INSERT INTO city VALUES ('1545', '370406', '370400', '山亭区');
INSERT INTO city VALUES ('1546', '370481', '370400', '滕州市');
INSERT INTO city VALUES ('1547', '370500', '370000', '东营市');
INSERT INTO city VALUES ('1548', '370501', '370500', '市辖区');
INSERT INTO city VALUES ('1549', '370502', '370500', '东营区');
INSERT INTO city VALUES ('155', '130635', '130600', '蠡县');
INSERT INTO city VALUES ('1550', '370503', '370500', '河口区');
INSERT INTO city VALUES ('1551', '370521', '370500', '垦利县');
INSERT INTO city VALUES ('1552', '370522', '370500', '利津县');
INSERT INTO city VALUES ('1553', '370523', '370500', '广饶县');
INSERT INTO city VALUES ('1554', '370600', '370000', '烟台市');
INSERT INTO city VALUES ('1555', '370601', '370600', '市辖区');
INSERT INTO city VALUES ('1556', '370602', '370600', '芝罘区');
INSERT INTO city VALUES ('1557', '370611', '370600', '福山区');
INSERT INTO city VALUES ('1558', '370612', '370600', '牟平区');
INSERT INTO city VALUES ('1559', '370613', '370600', '莱山区');
INSERT INTO city VALUES ('156', '130636', '130600', '顺平县');
INSERT INTO city VALUES ('1560', '370634', '370600', '长岛县');
INSERT INTO city VALUES ('1561', '370681', '370600', '龙口市');
INSERT INTO city VALUES ('1562', '370682', '370600', '莱阳市');
INSERT INTO city VALUES ('1563', '370683', '370600', '莱州市');
INSERT INTO city VALUES ('1564', '370684', '370600', '蓬莱市');
INSERT INTO city VALUES ('1565', '370685', '370600', '招远市');
INSERT INTO city VALUES ('1566', '370686', '370600', '栖霞市');
INSERT INTO city VALUES ('1567', '370687', '370600', '海阳市');
INSERT INTO city VALUES ('1568', '370700', '370000', '潍坊市');
INSERT INTO city VALUES ('1569', '370701', '370700', '市辖区');
INSERT INTO city VALUES ('157', '130637', '130600', '博野县');
INSERT INTO city VALUES ('1570', '370702', '370700', '潍城区');
INSERT INTO city VALUES ('1571', '370703', '370700', '寒亭区');
INSERT INTO city VALUES ('1572', '370704', '370700', '坊子区');
INSERT INTO city VALUES ('1573', '370705', '370700', '奎文区');
INSERT INTO city VALUES ('1574', '370724', '370700', '临朐县');
INSERT INTO city VALUES ('1575', '370725', '370700', '昌乐县');
INSERT INTO city VALUES ('1576', '370781', '370700', '青州市');
INSERT INTO city VALUES ('1577', '370782', '370700', '诸城市');
INSERT INTO city VALUES ('1578', '370783', '370700', '寿光市');
INSERT INTO city VALUES ('1579', '370784', '370700', '安丘市');
INSERT INTO city VALUES ('158', '130638', '130600', '雄县');
INSERT INTO city VALUES ('1580', '370785', '370700', '高密市');
INSERT INTO city VALUES ('1581', '370786', '370700', '昌邑市');
INSERT INTO city VALUES ('1582', '370800', '370000', '济宁市');
INSERT INTO city VALUES ('1583', '370801', '370800', '市辖区');
INSERT INTO city VALUES ('1584', '370802', '370800', '市中区');
INSERT INTO city VALUES ('1585', '370811', '370800', '任城区');
INSERT INTO city VALUES ('1586', '370826', '370800', '微山县');
INSERT INTO city VALUES ('1587', '370827', '370800', '鱼台县');
INSERT INTO city VALUES ('1588', '370828', '370800', '金乡县');
INSERT INTO city VALUES ('1589', '370829', '370800', '嘉祥县');
INSERT INTO city VALUES ('159', '130681', '130600', '涿州市');
INSERT INTO city VALUES ('1590', '370830', '370800', '汶上县');
INSERT INTO city VALUES ('1591', '370831', '370800', '泗水县');
INSERT INTO city VALUES ('1592', '370832', '370800', '梁山县');
INSERT INTO city VALUES ('1593', '370881', '370800', '曲阜市');
INSERT INTO city VALUES ('1594', '370882', '370800', '兖州市');
INSERT INTO city VALUES ('1595', '370883', '370800', '邹城市');
INSERT INTO city VALUES ('1596', '370900', '370000', '泰安市');
INSERT INTO city VALUES ('1597', '370901', '370900', '市辖区');
INSERT INTO city VALUES ('1598', '370902', '370900', '泰山区');
INSERT INTO city VALUES ('1599', '370911', '370900', '岱岳区(**)');
INSERT INTO city VALUES ('16', '110115', '110100', '大兴区');
INSERT INTO city VALUES ('160', '130682', '130600', '定州市');
INSERT INTO city VALUES ('1600', '370921', '370900', '宁阳县');
INSERT INTO city VALUES ('1601', '370923', '370900', '东平县');
INSERT INTO city VALUES ('1602', '370982', '370900', '新泰市');
INSERT INTO city VALUES ('1603', '370983', '370900', '肥城市');
INSERT INTO city VALUES ('1604', '371000', '370000', '威海市');
INSERT INTO city VALUES ('1605', '371001', '371000', '市辖区');
INSERT INTO city VALUES ('1606', '371002', '371000', '环翠区');
INSERT INTO city VALUES ('1607', '371081', '371000', '文登市');
INSERT INTO city VALUES ('1608', '371082', '371000', '荣成市');
INSERT INTO city VALUES ('1609', '371083', '371000', '乳山市');
INSERT INTO city VALUES ('161', '130683', '130600', '安国市');
INSERT INTO city VALUES ('1610', '371100', '370000', '日照市');
INSERT INTO city VALUES ('1611', '371101', '371100', '市辖区');
INSERT INTO city VALUES ('1612', '371102', '371100', '东港区');
INSERT INTO city VALUES ('1613', '371103', '371100', '岚山区');
INSERT INTO city VALUES ('1614', '371121', '371100', '五莲县');
INSERT INTO city VALUES ('1615', '371122', '371100', '莒县');
INSERT INTO city VALUES ('1616', '371200', '370000', '莱芜市');
INSERT INTO city VALUES ('1617', '371201', '371200', '市辖区');
INSERT INTO city VALUES ('1618', '371202', '371200', '莱城区');
INSERT INTO city VALUES ('1619', '371203', '371200', '钢城区');
INSERT INTO city VALUES ('162', '130684', '130600', '高碑店市');
INSERT INTO city VALUES ('1620', '371300', '370000', '临沂市');
INSERT INTO city VALUES ('1621', '371301', '371300', '市辖区');
INSERT INTO city VALUES ('1622', '371302', '371300', '兰山区');
INSERT INTO city VALUES ('1623', '371311', '371300', '罗庄区');
INSERT INTO city VALUES ('1624', '371312', '371300', '河东区');
INSERT INTO city VALUES ('1625', '371321', '371300', '沂南县');
INSERT INTO city VALUES ('1626', '371322', '371300', '郯城县');
INSERT INTO city VALUES ('1627', '371323', '371300', '沂水县');
INSERT INTO city VALUES ('1628', '371324', '371300', '苍山县');
INSERT INTO city VALUES ('1629', '371325', '371300', '费县');
INSERT INTO city VALUES ('163', '130700', '130000', '张家口市');
INSERT INTO city VALUES ('1630', '371326', '371300', '平邑县');
INSERT INTO city VALUES ('1631', '371327', '371300', '莒南县');
INSERT INTO city VALUES ('1632', '371328', '371300', '蒙阴县');
INSERT INTO city VALUES ('1633', '371329', '371300', '临沭县');
INSERT INTO city VALUES ('1634', '371400', '370000', '德州市');
INSERT INTO city VALUES ('1635', '371401', '371400', '市辖区');
INSERT INTO city VALUES ('1636', '371402', '371400', '德城区');
INSERT INTO city VALUES ('1637', '371421', '371400', '陵县');
INSERT INTO city VALUES ('1638', '371422', '371400', '宁津县');
INSERT INTO city VALUES ('1639', '371423', '371400', '庆云县');
INSERT INTO city VALUES ('164', '130701', '130700', '市辖区');
INSERT INTO city VALUES ('1640', '371424', '371400', '临邑县');
INSERT INTO city VALUES ('1641', '371425', '371400', '齐河县');
INSERT INTO city VALUES ('1642', '371426', '371400', '平原县');
INSERT INTO city VALUES ('1643', '371427', '371400', '夏津县');
INSERT INTO city VALUES ('1644', '371428', '371400', '武城县');
INSERT INTO city VALUES ('1645', '371481', '371400', '乐陵市');
INSERT INTO city VALUES ('1646', '371482', '371400', '禹城市');
INSERT INTO city VALUES ('1647', '371500', '370000', '聊城市');
INSERT INTO city VALUES ('1648', '371501', '371500', '市辖区');
INSERT INTO city VALUES ('1649', '371502', '371500', '东昌府区');
INSERT INTO city VALUES ('165', '130702', '130700', '桥东区');
INSERT INTO city VALUES ('1650', '371521', '371500', '阳谷县');
INSERT INTO city VALUES ('1651', '371522', '371500', '莘县');
INSERT INTO city VALUES ('1652', '371523', '371500', '茌平县');
INSERT INTO city VALUES ('1653', '371524', '371500', '东阿县');
INSERT INTO city VALUES ('1654', '371525', '371500', '冠县');
INSERT INTO city VALUES ('1655', '371526', '371500', '高唐县');
INSERT INTO city VALUES ('1656', '371581', '371500', '临清市');
INSERT INTO city VALUES ('1657', '371600', '370000', '滨州市');
INSERT INTO city VALUES ('1658', '371601', '371600', '市辖区');
INSERT INTO city VALUES ('1659', '371602', '371600', '滨城区');
INSERT INTO city VALUES ('166', '130703', '130700', '桥西区');
INSERT INTO city VALUES ('1660', '371621', '371600', '惠民县');
INSERT INTO city VALUES ('1661', '371622', '371600', '阳信县');
INSERT INTO city VALUES ('1662', '371623', '371600', '无棣县');
INSERT INTO city VALUES ('1663', '371624', '371600', '沾化县');
INSERT INTO city VALUES ('1664', '371625', '371600', '博兴县');
INSERT INTO city VALUES ('1665', '371626', '371600', '邹平县');
INSERT INTO city VALUES ('1666', '371700', '370000', '菏泽市');
INSERT INTO city VALUES ('1667', '371701', '371700', '市辖区');
INSERT INTO city VALUES ('1668', '371702', '371700', '牡丹区');
INSERT INTO city VALUES ('1669', '371721', '371700', '曹县');
INSERT INTO city VALUES ('167', '130705', '130700', '宣化区');
INSERT INTO city VALUES ('1670', '371722', '371700', '单县');
INSERT INTO city VALUES ('1671', '371723', '371700', '成武县');
INSERT INTO city VALUES ('1672', '371724', '371700', '巨野县');
INSERT INTO city VALUES ('1673', '371725', '371700', '郓城县');
INSERT INTO city VALUES ('1674', '371726', '371700', '鄄城县');
INSERT INTO city VALUES ('1675', '371727', '371700', '定陶县');
INSERT INTO city VALUES ('1676', '371728', '371700', '东明县');
INSERT INTO city VALUES ('1677', '410000', '-', '河南省');
INSERT INTO city VALUES ('1678', '410100', '410000', '郑州市');
INSERT INTO city VALUES ('1679', '410101', '410100', '市辖区');
INSERT INTO city VALUES ('168', '130706', '130700', '下花园区');
INSERT INTO city VALUES ('1680', '410102', '410100', '中原区');
INSERT INTO city VALUES ('1681', '410103', '410100', '二七区');
INSERT INTO city VALUES ('1682', '410104', '410100', '管城回族区');
INSERT INTO city VALUES ('1683', '410105', '410100', '金水区');
INSERT INTO city VALUES ('1684', '410106', '410100', '上街区');
INSERT INTO city VALUES ('1685', '410108', '410100', '惠济区');
INSERT INTO city VALUES ('1686', '410122', '410100', '中牟县');
INSERT INTO city VALUES ('1687', '410181', '410100', '巩义市');
INSERT INTO city VALUES ('1688', '410182', '410100', '荥阳市');
INSERT INTO city VALUES ('1689', '410183', '410100', '新密市');
INSERT INTO city VALUES ('169', '130721', '130700', '宣化县');
INSERT INTO city VALUES ('1690', '410184', '410100', '新郑市');
INSERT INTO city VALUES ('1691', '410185', '410100', '登封市');
INSERT INTO city VALUES ('1692', '410200', '410000', '开封市');
INSERT INTO city VALUES ('1693', '410201', '410200', '市辖区');
INSERT INTO city VALUES ('1694', '410202', '410200', '龙亭区');
INSERT INTO city VALUES ('1695', '410203', '410200', '顺河回族区');
INSERT INTO city VALUES ('1696', '410204', '410200', '鼓楼区');
INSERT INTO city VALUES ('1697', '410205', '410200', '禹王台区');
INSERT INTO city VALUES ('1698', '410211', '410200', '金明区');
INSERT INTO city VALUES ('1699', '410221', '410200', '杞县');
INSERT INTO city VALUES ('17', '110116', '110100', '怀柔区');
INSERT INTO city VALUES ('170', '130722', '130700', '张北县');
INSERT INTO city VALUES ('1700', '410222', '410200', '通许县');
INSERT INTO city VALUES ('1701', '410223', '410200', '尉氏县');
INSERT INTO city VALUES ('1702', '410224', '410200', '开封县');
INSERT INTO city VALUES ('1703', '410225', '410200', '兰考县');
INSERT INTO city VALUES ('1704', '410300', '410000', '洛阳市');
INSERT INTO city VALUES ('1705', '410301', '410300', '市辖区');
INSERT INTO city VALUES ('1706', '410302', '410300', '老城区');
INSERT INTO city VALUES ('1707', '410303', '410300', '西工区');
INSERT INTO city VALUES ('1708', '410304', '410300', '瀍河回族区(**)');
INSERT INTO city VALUES ('1709', '410305', '410300', '涧西区');
INSERT INTO city VALUES ('171', '130723', '130700', '康保县');
INSERT INTO city VALUES ('1710', '410306', '410300', '吉利区');
INSERT INTO city VALUES ('1711', '410311', '410300', '洛龙区(**)');
INSERT INTO city VALUES ('1712', '410322', '410300', '孟津县');
INSERT INTO city VALUES ('1713', '410323', '410300', '新安县');
INSERT INTO city VALUES ('1714', '410324', '410300', '栾川县');
INSERT INTO city VALUES ('1715', '410325', '410300', '嵩县');
INSERT INTO city VALUES ('1716', '410326', '410300', '汝阳县');
INSERT INTO city VALUES ('1717', '410327', '410300', '宜阳县');
INSERT INTO city VALUES ('1718', '410328', '410300', '洛宁县');
INSERT INTO city VALUES ('1719', '410329', '410300', '伊川县');
INSERT INTO city VALUES ('172', '130724', '130700', '沽源县');
INSERT INTO city VALUES ('1720', '410381', '410300', '偃师市');
INSERT INTO city VALUES ('1721', '410400', '410000', '平顶山市');
INSERT INTO city VALUES ('1722', '410401', '410400', '市辖区');
INSERT INTO city VALUES ('1723', '410402', '410400', '新华区');
INSERT INTO city VALUES ('1724', '410403', '410400', '卫东区');
INSERT INTO city VALUES ('1725', '410404', '410400', '石龙区');
INSERT INTO city VALUES ('1726', '410411', '410400', '湛河区');
INSERT INTO city VALUES ('1727', '410421', '410400', '宝丰县');
INSERT INTO city VALUES ('1728', '410422', '410400', '叶县');
INSERT INTO city VALUES ('1729', '410423', '410400', '鲁山县');
INSERT INTO city VALUES ('173', '130725', '130700', '尚义县');
INSERT INTO city VALUES ('1730', '410425', '410400', '郏县');
INSERT INTO city VALUES ('1731', '410481', '410400', '舞钢市');
INSERT INTO city VALUES ('1732', '410482', '410400', '汝州市');
INSERT INTO city VALUES ('1733', '410500', '410000', '安阳市');
INSERT INTO city VALUES ('1734', '410501', '410500', '市辖区');
INSERT INTO city VALUES ('1735', '410502', '410500', '文峰区');
INSERT INTO city VALUES ('1736', '410503', '410500', '北关区');
INSERT INTO city VALUES ('1737', '410505', '410500', '殷都区');
INSERT INTO city VALUES ('1738', '410506', '410500', '龙安区');
INSERT INTO city VALUES ('1739', '410522', '410500', '安阳县');
INSERT INTO city VALUES ('174', '130726', '130700', '蔚县');
INSERT INTO city VALUES ('1740', '410523', '410500', '汤阴县');
INSERT INTO city VALUES ('1741', '410526', '410500', '滑县');
INSERT INTO city VALUES ('1742', '410527', '410500', '内黄县');
INSERT INTO city VALUES ('1743', '410581', '410500', '林州市');
INSERT INTO city VALUES ('1744', '410600', '410000', '鹤壁市');
INSERT INTO city VALUES ('1745', '410601', '410600', '市辖区');
INSERT INTO city VALUES ('1746', '410602', '410600', '鹤山区');
INSERT INTO city VALUES ('1747', '410603', '410600', '山城区');
INSERT INTO city VALUES ('1748', '410611', '410600', '淇滨区');
INSERT INTO city VALUES ('1749', '410621', '410600', '浚县');
INSERT INTO city VALUES ('175', '130727', '130700', '阳原县');
INSERT INTO city VALUES ('1750', '410622', '410600', '淇县');
INSERT INTO city VALUES ('1751', '410700', '410000', '新乡市');
INSERT INTO city VALUES ('1752', '410701', '410700', '市辖区');
INSERT INTO city VALUES ('1753', '410702', '410700', '红旗区');
INSERT INTO city VALUES ('1754', '410703', '410700', '卫滨区');
INSERT INTO city VALUES ('1755', '410704', '410700', '凤泉区');
INSERT INTO city VALUES ('1756', '410711', '410700', '牧野区');
INSERT INTO city VALUES ('1757', '410721', '410700', '新乡县');
INSERT INTO city VALUES ('1758', '410724', '410700', '获嘉县');
INSERT INTO city VALUES ('1759', '410725', '410700', '原阳县');
INSERT INTO city VALUES ('176', '130728', '130700', '怀安县');
INSERT INTO city VALUES ('1760', '410726', '410700', '延津县');
INSERT INTO city VALUES ('1761', '410727', '410700', '封丘县');
INSERT INTO city VALUES ('1762', '410728', '410700', '长垣县');
INSERT INTO city VALUES ('1763', '410781', '410700', '卫辉市');
INSERT INTO city VALUES ('1764', '410782', '410700', '辉县市');
INSERT INTO city VALUES ('1765', '410800', '410000', '焦作市');
INSERT INTO city VALUES ('1766', '410801', '410800', '市辖区');
INSERT INTO city VALUES ('1767', '410802', '410800', '解放区');
INSERT INTO city VALUES ('1768', '410803', '410800', '中站区');
INSERT INTO city VALUES ('1769', '410804', '410800', '马村区');
INSERT INTO city VALUES ('177', '130729', '130700', '万全县');
INSERT INTO city VALUES ('1770', '410811', '410800', '山阳区');
INSERT INTO city VALUES ('1771', '410821', '410800', '修武县');
INSERT INTO city VALUES ('1772', '410822', '410800', '博爱县');
INSERT INTO city VALUES ('1773', '410823', '410800', '武陟县');
INSERT INTO city VALUES ('1774', '410825', '410800', '温县');
INSERT INTO city VALUES ('1775', '410881', '410800', '济源市');
INSERT INTO city VALUES ('1776', '410882', '410800', '沁阳市');
INSERT INTO city VALUES ('1777', '410883', '410800', '孟州市');
INSERT INTO city VALUES ('1778', '410900', '410000', '濮阳市');
INSERT INTO city VALUES ('1779', '410901', '410900', '市辖区');
INSERT INTO city VALUES ('178', '130730', '130700', '怀来县');
INSERT INTO city VALUES ('1780', '410902', '410900', '华龙区');
INSERT INTO city VALUES ('1781', '410922', '410900', '清丰县');
INSERT INTO city VALUES ('1782', '410923', '410900', '南乐县');
INSERT INTO city VALUES ('1783', '410926', '410900', '范县');
INSERT INTO city VALUES ('1784', '410927', '410900', '台前县');
INSERT INTO city VALUES ('1785', '410928', '410900', '濮阳县');
INSERT INTO city VALUES ('1786', '411000', '410000', '许昌市');
INSERT INTO city VALUES ('1787', '411001', '411000', '市辖区');
INSERT INTO city VALUES ('1788', '411002', '411000', '魏都区');
INSERT INTO city VALUES ('1789', '411023', '411000', '许昌县');
INSERT INTO city VALUES ('179', '130731', '130700', '涿鹿县');
INSERT INTO city VALUES ('1790', '411024', '411000', '鄢陵县');
INSERT INTO city VALUES ('1791', '411025', '411000', '襄城县');
INSERT INTO city VALUES ('1792', '411081', '411000', '禹州市');
INSERT INTO city VALUES ('1793', '411082', '411000', '长葛市');
INSERT INTO city VALUES ('1794', '411100', '410000', '漯河市');
INSERT INTO city VALUES ('1795', '411101', '411100', '市辖区');
INSERT INTO city VALUES ('1796', '411102', '411100', '源汇区');
INSERT INTO city VALUES ('1797', '411103', '411100', '郾城区');
INSERT INTO city VALUES ('1798', '411104', '411100', '召陵区');
INSERT INTO city VALUES ('1799', '411121', '411100', '舞阳县');
INSERT INTO city VALUES ('18', '110117', '110100', '平谷区');
INSERT INTO city VALUES ('180', '130732', '130700', '赤城县');
INSERT INTO city VALUES ('1800', '411122', '411100', '临颍县');
INSERT INTO city VALUES ('1801', '411200', '410000', '三门峡市');
INSERT INTO city VALUES ('1802', '411201', '411200', '市辖区');
INSERT INTO city VALUES ('1803', '411202', '411200', '湖滨区');
INSERT INTO city VALUES ('1804', '411221', '411200', '渑池县');
INSERT INTO city VALUES ('1805', '411222', '411200', '陕县');
INSERT INTO city VALUES ('1806', '411224', '411200', '卢氏县');
INSERT INTO city VALUES ('1807', '411281', '411200', '义马市');
INSERT INTO city VALUES ('1808', '411282', '411200', '灵宝市');
INSERT INTO city VALUES ('1809', '411300', '410000', '南阳市');
INSERT INTO city VALUES ('181', '130733', '130700', '崇礼县');
INSERT INTO city VALUES ('1810', '411301', '411300', '市辖区');
INSERT INTO city VALUES ('1811', '411302', '411300', '宛城区');
INSERT INTO city VALUES ('1812', '411303', '411300', '卧龙区');
INSERT INTO city VALUES ('1813', '411321', '411300', '南召县');
INSERT INTO city VALUES ('1814', '411322', '411300', '方城县');
INSERT INTO city VALUES ('1815', '411323', '411300', '西峡县');
INSERT INTO city VALUES ('1816', '411324', '411300', '镇平县');
INSERT INTO city VALUES ('1817', '411325', '411300', '内乡县');
INSERT INTO city VALUES ('1818', '411326', '411300', '淅川县');
INSERT INTO city VALUES ('1819', '411327', '411300', '社旗县');
INSERT INTO city VALUES ('182', '130800', '130000', '承德市');
INSERT INTO city VALUES ('1820', '411328', '411300', '唐河县');
INSERT INTO city VALUES ('1821', '411329', '411300', '新野县');
INSERT INTO city VALUES ('1822', '411330', '411300', '桐柏县');
INSERT INTO city VALUES ('1823', '411381', '411300', '邓州市');
INSERT INTO city VALUES ('1824', '411400', '410000', '商丘市');
INSERT INTO city VALUES ('1825', '411401', '411400', '市辖区');
INSERT INTO city VALUES ('1826', '411402', '411400', '梁园区');
INSERT INTO city VALUES ('1827', '411403', '411400', '睢阳区');
INSERT INTO city VALUES ('1828', '411421', '411400', '民权县');
INSERT INTO city VALUES ('1829', '411422', '411400', '睢县');
INSERT INTO city VALUES ('183', '130801', '130800', '市辖区');
INSERT INTO city VALUES ('1830', '411423', '411400', '宁陵县');
INSERT INTO city VALUES ('1831', '411424', '411400', '柘城县');
INSERT INTO city VALUES ('1832', '411425', '411400', '虞城县');
INSERT INTO city VALUES ('1833', '411426', '411400', '夏邑县');
INSERT INTO city VALUES ('1834', '411481', '411400', '永城市');
INSERT INTO city VALUES ('1835', '411500', '410000', '信阳市');
INSERT INTO city VALUES ('1836', '411501', '411500', '市辖区');
INSERT INTO city VALUES ('1837', '411502', '411500', '浉河区');
INSERT INTO city VALUES ('1838', '411503', '411500', '平桥区');
INSERT INTO city VALUES ('1839', '411521', '411500', '罗山县');
INSERT INTO city VALUES ('184', '130802', '130800', '双桥区');
INSERT INTO city VALUES ('1840', '411522', '411500', '光山县');
INSERT INTO city VALUES ('1841', '411523', '411500', '新县');
INSERT INTO city VALUES ('1842', '411524', '411500', '商城县');
INSERT INTO city VALUES ('1843', '411525', '411500', '固始县');
INSERT INTO city VALUES ('1844', '411526', '411500', '潢川县');
INSERT INTO city VALUES ('1845', '411527', '411500', '淮滨县');
INSERT INTO city VALUES ('1846', '411528', '411500', '息县');
INSERT INTO city VALUES ('1847', '411600', '410000', '周口市');
INSERT INTO city VALUES ('1848', '411601', '411600', '市辖区');
INSERT INTO city VALUES ('1849', '411602', '411600', '川汇区');
INSERT INTO city VALUES ('185', '130803', '130800', '双滦区');
INSERT INTO city VALUES ('1850', '411621', '411600', '扶沟县');
INSERT INTO city VALUES ('1851', '411622', '411600', '西华县');
INSERT INTO city VALUES ('1852', '411623', '411600', '商水县');
INSERT INTO city VALUES ('1853', '411624', '411600', '沈丘县');
INSERT INTO city VALUES ('1854', '411625', '411600', '郸城县');
INSERT INTO city VALUES ('1855', '411626', '411600', '淮阳县');
INSERT INTO city VALUES ('1856', '411627', '411600', '太康县');
INSERT INTO city VALUES ('1857', '411628', '411600', '鹿邑县');
INSERT INTO city VALUES ('1858', '411681', '411600', '项城市');
INSERT INTO city VALUES ('1859', '411700', '410000', '驻马店市');
INSERT INTO city VALUES ('186', '130804', '130800', '鹰手营子矿区');
INSERT INTO city VALUES ('1860', '411701', '411700', '市辖区');
INSERT INTO city VALUES ('1861', '411702', '411700', '驿城区');
INSERT INTO city VALUES ('1862', '411721', '411700', '西平县');
INSERT INTO city VALUES ('1863', '411722', '411700', '上蔡县');
INSERT INTO city VALUES ('1864', '411723', '411700', '平舆县');
INSERT INTO city VALUES ('1865', '411724', '411700', '正阳县');
INSERT INTO city VALUES ('1866', '411725', '411700', '确山县');
INSERT INTO city VALUES ('1867', '411726', '411700', '泌阳县');
INSERT INTO city VALUES ('1868', '411727', '411700', '汝南县');
INSERT INTO city VALUES ('1869', '411728', '411700', '遂平县');
INSERT INTO city VALUES ('187', '130821', '130800', '承德县');
INSERT INTO city VALUES ('1870', '411729', '411700', '新蔡县');