/* 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', '新蔡县'); INSERT INTO city VALUES ('1871', '420000', '-', '湖北省'); INSERT INTO city VALUES ('1872', '420100', '420000', '武汉市'); INSERT INTO city VALUES ('1873', '420101', '420100', '市辖区'); INSERT INTO city VALUES ('1874', '420102', '420100', '江岸区'); INSERT INTO city VALUES ('1875', '420103', '420100', '江汉区'); INSERT INTO city VALUES ('1876', '420104', '420100', '硚口区'); INSERT INTO city VALUES ('1877', '420105', '420100', '汉阳区'); INSERT INTO city VALUES ('1878', '420106', '420100', '武昌区'); INSERT INTO city VALUES ('1879', '420107', '420100', '青山区'); INSERT INTO city VALUES ('188', '130822', '130800', '兴隆县'); INSERT INTO city VALUES ('1880', '420111', '420100', '洪山区'); INSERT INTO city VALUES ('1881', '420112', '420100', '东西湖区'); INSERT INTO city VALUES ('1882', '420113', '420100', '汉南区'); INSERT INTO city VALUES ('1883', '420114', '420100', '蔡甸区'); INSERT INTO city VALUES ('1884', '420115', '420100', '江夏区'); INSERT INTO city VALUES ('1885', '420116', '420100', '黄陂区'); INSERT INTO city VALUES ('1886', '420117', '420100', '新洲区'); INSERT INTO city VALUES ('1887', '420200', '420000', '黄石市'); INSERT INTO city VALUES ('1888', '420201', '420200', '市辖区'); INSERT INTO city VALUES ('1889', '420202', '420200', '黄石港区'); INSERT INTO city VALUES ('189', '130823', '130800', '平泉县'); INSERT INTO city VALUES ('1890', '420203', '420200', '西塞山区'); INSERT INTO city VALUES ('1891', '420204', '420200', '下陆区'); INSERT INTO city VALUES ('1892', '420205', '420200', '铁山区'); INSERT INTO city VALUES ('1893', '420222', '420200', '阳新县'); INSERT INTO city VALUES ('1894', '420281', '420200', '大冶市'); INSERT INTO city VALUES ('1895', '420300', '420000', '十堰市'); INSERT INTO city VALUES ('1896', '420301', '420300', '市辖区'); INSERT INTO city VALUES ('1897', '420302', '420300', '茅箭区'); INSERT INTO city VALUES ('1898', '420303', '420300', '张湾区'); INSERT INTO city VALUES ('1899', '420321', '420300', '郧县'); INSERT INTO city VALUES ('19', '110200', '110000', '县'); INSERT INTO city VALUES ('190', '130824', '130800', '滦平县'); INSERT INTO city VALUES ('1900', '420322', '420300', '郧西县'); INSERT INTO city VALUES ('1901', '420323', '420300', '竹山县'); INSERT INTO city VALUES ('1902', '420324', '420300', '竹溪县'); INSERT INTO city VALUES ('1903', '420325', '420300', '房县'); INSERT INTO city VALUES ('1904', '420381', '420300', '丹江口市'); INSERT INTO city VALUES ('1905', '420500', '420000', '宜昌市'); INSERT INTO city VALUES ('1906', '420501', '420500', '市辖区'); INSERT INTO city VALUES ('1907', '420502', '420500', '西陵区'); INSERT INTO city VALUES ('1908', '420503', '420500', '伍家岗区'); INSERT INTO city VALUES ('1909', '420504', '420500', '点军区'); INSERT INTO city VALUES ('191', '130825', '130800', '隆化县'); INSERT INTO city VALUES ('1910', '420505', '420500', '猇亭区'); INSERT INTO city VALUES ('1911', '420506', '420500', '夷陵区'); INSERT INTO city VALUES ('1912', '420525', '420500', '远安县'); INSERT INTO city VALUES ('1913', '420526', '420500', '兴山县'); INSERT INTO city VALUES ('1914', '420527', '420500', '秭归县'); INSERT INTO city VALUES ('1915', '420528', '420500', '长阳土家族自治县'); INSERT INTO city VALUES ('1916', '420529', '420500', '五峰土家族自治县'); INSERT INTO city VALUES ('1917', '420581', '420500', '宜都市'); INSERT INTO city VALUES ('1918', '420582', '420500', '当阳市'); INSERT INTO city VALUES ('1919', '420583', '420500', '枝江市'); INSERT INTO city VALUES ('192', '130826', '130800', '丰宁满族自治县'); INSERT INTO city VALUES ('1920', '420600', '420000', '襄樊市'); INSERT INTO city VALUES ('1921', '420601', '420600', '市辖区'); INSERT INTO city VALUES ('1922', '420602', '420600', '襄城区'); INSERT INTO city VALUES ('1923', '420606', '420600', '樊城区'); INSERT INTO city VALUES ('1924', '420607', '420600', '襄阳区'); INSERT INTO city VALUES ('1925', '420624', '420600', '南漳县'); INSERT INTO city VALUES ('1926', '420625', '420600', '谷城县'); INSERT INTO city VALUES ('1927', '420626', '420600', '保康县'); INSERT INTO city VALUES ('1928', '420682', '420600', '老河口市'); INSERT INTO city VALUES ('1929', '420683', '420600', '枣阳市'); INSERT INTO city VALUES ('193', '130827', '130800', '宽城满族自治县'); INSERT INTO city VALUES ('1930', '420684', '420600', '宜城市'); INSERT INTO city VALUES ('1931', '420700', '420000', '鄂州市'); INSERT INTO city VALUES ('1932', '420701', '420700', '市辖区'); INSERT INTO city VALUES ('1933', '420702', '420700', '梁子湖区'); INSERT INTO city VALUES ('1934', '420703', '420700', '华容区'); INSERT INTO city VALUES ('1935', '420704', '420700', '鄂城区'); INSERT INTO city VALUES ('1936', '420800', '420000', '荆门市'); INSERT INTO city VALUES ('1937', '420801', '420800', '市辖区'); INSERT INTO city VALUES ('1938', '420802', '420800', '东宝区'); INSERT INTO city VALUES ('1939', '420804', '420800', '掇刀区'); INSERT INTO city VALUES ('194', '130828', '130800', '围场满族蒙古族自治县'); INSERT INTO city VALUES ('1940', '420821', '420800', '京山县'); INSERT INTO city VALUES ('1941', '420822', '420800', '沙洋县'); INSERT INTO city VALUES ('1942', '420881', '420800', '钟祥市'); INSERT INTO city VALUES ('1943', '420900', '420000', '孝感市'); INSERT INTO city VALUES ('1944', '420901', '420900', '市辖区'); INSERT INTO city VALUES ('1945', '420902', '420900', '孝南区'); INSERT INTO city VALUES ('1946', '420921', '420900', '孝昌县'); INSERT INTO city VALUES ('1947', '420922', '420900', '大悟县'); INSERT INTO city VALUES ('1948', '420923', '420900', '云梦县'); INSERT INTO city VALUES ('1949', '420981', '420900', '应城市'); INSERT INTO city VALUES ('195', '130900', '130000', '沧州市'); INSERT INTO city VALUES ('1950', '420982', '420900', '安陆市'); INSERT INTO city VALUES ('1951', '420984', '420900', '汉川市'); INSERT INTO city VALUES ('1952', '421000', '420000', '荆州市'); INSERT INTO city VALUES ('1953', '421001', '421000', '市辖区'); INSERT INTO city VALUES ('1954', '421002', '421000', '沙市区'); INSERT INTO city VALUES ('1955', '421003', '421000', '荆州区'); INSERT INTO city VALUES ('1956', '421022', '421000', '公安县'); INSERT INTO city VALUES ('1957', '421023', '421000', '监利县'); INSERT INTO city VALUES ('1958', '421024', '421000', '江陵县'); INSERT INTO city VALUES ('1959', '421081', '421000', '石首市'); INSERT INTO city VALUES ('196', '130901', '130900', '市辖区'); INSERT INTO city VALUES ('1960', '421083', '421000', '洪湖市'); INSERT INTO city VALUES ('1961', '421087', '421000', '松滋市'); INSERT INTO city VALUES ('1962', '421100', '420000', '黄冈市'); INSERT INTO city VALUES ('1963', '421101', '421100', '市辖区'); INSERT INTO city VALUES ('1964', '421102', '421100', '黄州区'); INSERT INTO city VALUES ('1965', '421121', '421100', '团风县'); INSERT INTO city VALUES ('1966', '421122', '421100', '红安县'); INSERT INTO city VALUES ('1967', '421123', '421100', '罗田县'); INSERT INTO city VALUES ('1968', '421124', '421100', '英山县'); INSERT INTO city VALUES ('1969', '421125', '421100', '浠水县'); INSERT INTO city VALUES ('197', '130902', '130900', '新华区'); INSERT INTO city VALUES ('1970', '421126', '421100', '蕲春县'); INSERT INTO city VALUES ('1971', '421127', '421100', '黄梅县'); INSERT INTO city VALUES ('1972', '421181', '421100', '麻城市'); INSERT INTO city VALUES ('1973', '421182', '421100', '武穴市'); INSERT INTO city VALUES ('1974', '421200', '420000', '咸宁市'); INSERT INTO city VALUES ('1975', '421201', '421200', '市辖区'); INSERT INTO city VALUES ('1976', '421202', '421200', '咸安区'); INSERT INTO city VALUES ('1977', '421221', '421200', '嘉鱼县'); INSERT INTO city VALUES ('1978', '421222', '421200', '通城县'); INSERT INTO city VALUES ('1979', '421223', '421200', '崇阳县'); INSERT INTO city VALUES ('198', '130903', '130900', '运河区'); INSERT INTO city VALUES ('1980', '421224', '421200', '通山县'); INSERT INTO city VALUES ('1981', '421281', '421200', '赤壁市'); INSERT INTO city VALUES ('1982', '421300', '420000', '随州市'); INSERT INTO city VALUES ('1983', '421301', '421300', '市辖区'); INSERT INTO city VALUES ('1984', '421302', '421300', '曾都区'); INSERT INTO city VALUES ('1985', '421381', '421300', '广水市'); INSERT INTO city VALUES ('1986', '422800', '420000', '恩施土家族苗族自治州'); INSERT INTO city VALUES ('1987', '422801', '422800', '恩施市'); INSERT INTO city VALUES ('1988', '422802', '422800', '利川市'); INSERT INTO city VALUES ('1989', '422822', '422800', '建始县'); INSERT INTO city VALUES ('199', '130921', '130900', '沧县'); INSERT INTO city VALUES ('1990', '422823', '422800', '巴东县'); INSERT INTO city VALUES ('1991', '422825', '422800', '宣恩县'); INSERT INTO city VALUES ('1992', '422826', '422800', '咸丰县'); INSERT INTO city VALUES ('1993', '422827', '422800', '来凤县'); INSERT INTO city VALUES ('1994', '422828', '422800', '鹤峰县'); INSERT INTO city VALUES ('1995', '429000', '420000', '省直辖县级行政单位(**)'); INSERT INTO city VALUES ('1996', '429004', '429000', '仙桃市'); INSERT INTO city VALUES ('1997', '429005', '429000', '潜江市'); INSERT INTO city VALUES ('1998', '429006', '429000', '天门市'); INSERT INTO city VALUES ('1999', '429021', '429000', '神农架林区'); INSERT INTO city VALUES ('2', '110100', '110000', '市辖区'); INSERT INTO city VALUES ('20', '110228', '110200', '密云县'); INSERT INTO city VALUES ('200', '130922', '130900', '青县'); INSERT INTO city VALUES ('2000', '430000', '-', '湖南省'); INSERT INTO city VALUES ('2001', '430100', '430000', '长沙市'); INSERT INTO city VALUES ('2002', '430101', '430100', '市辖区'); INSERT INTO city VALUES ('2003', '430102', '430100', '芙蓉区'); INSERT INTO city VALUES ('2004', '430103', '430100', '天心区'); INSERT INTO city VALUES ('2005', '430104', '430100', '岳麓区'); INSERT INTO city VALUES ('2006', '430105', '430100', '开福区'); INSERT INTO city VALUES ('2007', '430111', '430100', '雨花区'); INSERT INTO city VALUES ('2008', '430121', '430100', '长沙县'); INSERT INTO city VALUES ('2009', '430122', '430100', '望城县'); INSERT INTO city VALUES ('201', '130923', '130900', '东光县'); INSERT INTO city VALUES ('2010', '430124', '430100', '宁乡县'); INSERT INTO city VALUES ('2011', '430181', '430100', '浏阳市'); INSERT INTO city VALUES ('2012', '430200', '430000', '株洲市'); INSERT INTO city VALUES ('2013', '430201', '430200', '市辖区'); INSERT INTO city VALUES ('2014', '430202', '430200', '荷塘区'); INSERT INTO city VALUES ('2015', '430203', '430200', '芦淞区'); INSERT INTO city VALUES ('2016', '430204', '430200', '石峰区'); INSERT INTO city VALUES ('2017', '430211', '430200', '天元区'); INSERT INTO city VALUES ('2018', '430221', '430200', '株洲县'); INSERT INTO city VALUES ('2019', '430223', '430200', '攸县'); INSERT INTO city VALUES ('202', '130924', '130900', '海兴县'); INSERT INTO city VALUES ('2020', '430224', '430200', '茶陵县'); INSERT INTO city VALUES ('2021', '430225', '430200', '炎陵县'); INSERT INTO city VALUES ('2022', '430281', '430200', '醴陵市'); INSERT INTO city VALUES ('2023', '430300', '430000', '湘潭市'); INSERT INTO city VALUES ('2024', '430301', '430300', '市辖区'); INSERT INTO city VALUES ('2025', '430302', '430300', '雨湖区'); INSERT INTO city VALUES ('2026', '430304', '430300', '岳塘区'); INSERT INTO city VALUES ('2027', '430321', '430300', '湘潭县'); INSERT INTO city VALUES ('2028', '430381', '430300', '湘乡市'); INSERT INTO city VALUES ('2029', '430382', '430300', '韶山市'); INSERT INTO city VALUES ('203', '130925', '130900', '盐山县'); INSERT INTO city VALUES ('2030', '430400', '430000', '衡阳市'); INSERT INTO city VALUES ('2031', '430401', '430400', '市辖区'); INSERT INTO city VALUES ('2032', '430405', '430400', '珠晖区'); INSERT INTO city VALUES ('2033', '430406', '430400', '雁峰区'); INSERT INTO city VALUES ('2034', '430407', '430400', '石鼓区'); INSERT INTO city VALUES ('2035', '430408', '430400', '蒸湘区'); INSERT INTO city VALUES ('2036', '430412', '430400', '南岳区'); INSERT INTO city VALUES ('2037', '430421', '430400', '衡阳县'); INSERT INTO city VALUES ('2038', '430422', '430400', '衡南县'); INSERT INTO city VALUES ('2039', '430423', '430400', '衡山县'); INSERT INTO city VALUES ('204', '130926', '130900', '肃宁县'); INSERT INTO city VALUES ('2040', '430424', '430400', '衡东县'); INSERT INTO city VALUES ('2041', '430426', '430400', '祁东县'); INSERT INTO city VALUES ('2042', '430481', '430400', '耒阳市'); INSERT INTO city VALUES ('2043', '430482', '430400', '常宁市'); INSERT INTO city VALUES ('2044', '430500', '430000', '邵阳市'); INSERT INTO city VALUES ('2045', '430501', '430500', '市辖区'); INSERT INTO city VALUES ('2046', '430502', '430500', '双清区'); INSERT INTO city VALUES ('2047', '430503', '430500', '大祥区'); INSERT INTO city VALUES ('2048', '430511', '430500', '北塔区'); INSERT INTO city VALUES ('2049', '430521', '430500', '邵东县'); INSERT INTO city VALUES ('205', '130927', '130900', '南皮县'); INSERT INTO city VALUES ('2050', '430522', '430500', '新邵县'); INSERT INTO city VALUES ('2051', '430523', '430500', '邵阳县'); INSERT INTO city VALUES ('2052', '430524', '430500', '隆回县'); INSERT INTO city VALUES ('2053', '430525', '430500', '洞口县'); INSERT INTO city VALUES ('2054', '430527', '430500', '绥宁县'); INSERT INTO city VALUES ('2055', '430528', '430500', '新宁县'); INSERT INTO city VALUES ('2056', '430529', '430500', '城步苗族自治县'); INSERT INTO city VALUES ('2057', '430581', '430500', '武冈市'); INSERT INTO city VALUES ('2058', '430600', '430000', '岳阳市'); INSERT INTO city VALUES ('2059', '430601', '430600', '市辖区'); INSERT INTO city VALUES ('206', '130928', '130900', '吴桥县'); INSERT INTO city VALUES ('2060', '430602', '430600', '岳阳楼区'); INSERT INTO city VALUES ('2061', '430603', '430600', '云溪区'); INSERT INTO city VALUES ('2062', '430611', '430600', '君山区'); INSERT INTO city VALUES ('2063', '430621', '430600', '岳阳县'); INSERT INTO city VALUES ('2064', '430623', '430600', '华容县'); INSERT INTO city VALUES ('2065', '430624', '430600', '湘阴县'); INSERT INTO city VALUES ('2066', '430626', '430600', '平江县'); INSERT INTO city VALUES ('2067', '430681', '430600', '汨罗市'); INSERT INTO city VALUES ('2068', '430682', '430600', '临湘市'); INSERT INTO city VALUES ('2069', '430700', '430000', '常德市'); INSERT INTO city VALUES ('207', '130929', '130900', '献县'); INSERT INTO city VALUES ('2070', '430701', '430700', '市辖区'); INSERT INTO city VALUES ('2071', '430702', '430700', '武陵区'); INSERT INTO city VALUES ('2072', '430703', '430700', '鼎城区'); INSERT INTO city VALUES ('2073', '430721', '430700', '安乡县'); INSERT INTO city VALUES ('2074', '430722', '430700', '汉寿县'); INSERT INTO city VALUES ('2075', '430723', '430700', '澧县'); INSERT INTO city VALUES ('2076', '430724', '430700', '临澧县'); INSERT INTO city VALUES ('2077', '430725', '430700', '桃源县'); INSERT INTO city VALUES ('2078', '430726', '430700', '石门县'); INSERT INTO city VALUES ('2079', '430781', '430700', '津市市'); INSERT INTO city VALUES ('208', '130930', '130900', '孟村回族自治县'); INSERT INTO city VALUES ('2080', '430800', '430000', '张家界市'); INSERT INTO city VALUES ('2081', '430801', '430800', '市辖区'); INSERT INTO city VALUES ('2082', '430802', '430800', '永定区'); INSERT INTO city VALUES ('2083', '430811', '430800', '武陵源区'); INSERT INTO city VALUES ('2084', '430821', '430800', '慈利县'); INSERT INTO city VALUES ('2085', '430822', '430800', '桑植县'); INSERT INTO city VALUES ('2086', '430900', '430000', '益阳市'); INSERT INTO city VALUES ('2087', '430901', '430900', '市辖区'); INSERT INTO city VALUES ('2088', '430902', '430900', '资阳区'); INSERT INTO city VALUES ('2089', '430903', '430900', '赫山区'); INSERT INTO city VALUES ('209', '130981', '130900', '泊头市'); INSERT INTO city VALUES ('2090', '430921', '430900', '南县'); INSERT INTO city VALUES ('2091', '430922', '430900', '桃江县'); INSERT INTO city VALUES ('2092', '430923', '430900', '安化县'); INSERT INTO city VALUES ('2093', '430981', '430900', '沅江市'); INSERT INTO city VALUES ('2094', '431000', '430000', '郴州市'); INSERT INTO city VALUES ('2095', '431001', '431000', '市辖区'); INSERT INTO city VALUES ('2096', '431002', '431000', '北湖区'); INSERT INTO city VALUES ('2097', '431003', '431000', '苏仙区'); INSERT INTO city VALUES ('2098', '431021', '431000', '桂阳县'); INSERT INTO city VALUES ('2099', '431022', '431000', '宜章县'); INSERT INTO city VALUES ('21', '110229', '110200', '延庆县'); INSERT INTO city VALUES ('210', '130982', '130900', '任丘市'); INSERT INTO city VALUES ('2100', '431023', '431000', '永兴县'); INSERT INTO city VALUES ('2101', '431024', '431000', '嘉禾县'); INSERT INTO city VALUES ('2102', '431025', '431000', '临武县'); INSERT INTO city VALUES ('2103', '431026', '431000', '汝城县'); INSERT INTO city VALUES ('2104', '431027', '431000', '桂东县'); INSERT INTO city VALUES ('2105', '431028', '431000', '安仁县'); INSERT INTO city VALUES ('2106', '431081', '431000', '资兴市'); INSERT INTO city VALUES ('2107', '431100', '430000', '永州市'); INSERT INTO city VALUES ('2108', '431101', '431100', '市辖区'); INSERT INTO city VALUES ('2109', '431102', '431100', '零陵区'); INSERT INTO city VALUES ('211', '130983', '130900', '黄骅市'); INSERT INTO city VALUES ('2110', '431103', '431100', '冷水滩区'); INSERT INTO city VALUES ('2111', '431121', '431100', '祁阳县'); INSERT INTO city VALUES ('2112', '431122', '431100', '东安县'); INSERT INTO city VALUES ('2113', '431123', '431100', '双牌县'); INSERT INTO city VALUES ('2114', '431124', '431100', '道县'); INSERT INTO city VALUES ('2115', '431125', '431100', '江永县'); INSERT INTO city VALUES ('2116', '431126', '431100', '宁远县'); INSERT INTO city VALUES ('2117', '431127', '431100', '蓝山县'); INSERT INTO city VALUES ('2118', '431128', '431100', '新田县'); INSERT INTO city VALUES ('2119', '431129', '431100', '江华瑶族自治县'); INSERT INTO city VALUES ('212', '130984', '130900', '河间市'); INSERT INTO city VALUES ('2120', '431200', '430000', '怀化市'); INSERT INTO city VALUES ('2121', '431201', '431200', '市辖区'); INSERT INTO city VALUES ('2122', '431202', '431200', '鹤城区'); INSERT INTO city VALUES ('2123', '431221', '431200', '中方县'); INSERT INTO city VALUES ('2124', '431222', '431200', '沅陵县'); INSERT INTO city VALUES ('2125', '431223', '431200', '辰溪县'); INSERT INTO city VALUES ('2126', '431224', '431200', '溆浦县'); INSERT INTO city VALUES ('2127', '431225', '431200', '会同县'); INSERT INTO city VALUES ('2128', '431226', '431200', '麻阳苗族自治县'); INSERT INTO city VALUES ('2129', '431227', '431200', '新晃侗族自治县'); INSERT INTO city VALUES ('213', '131000', '130000', '廊坊市'); INSERT INTO city VALUES ('2130', '431228', '431200', '芷江侗族自治县'); INSERT INTO city VALUES ('2131', '431229', '431200', '靖州苗族侗族自治县'); INSERT INTO city VALUES ('2132', '431230', '431200', '通道侗族自治县'); INSERT INTO city VALUES ('2133', '431281', '431200', '洪江市'); INSERT INTO city VALUES ('2134', '431300', '430000', '娄底市'); INSERT INTO city VALUES ('2135', '431301', '431300', '市辖区'); INSERT INTO city VALUES ('2136', '431302', '431300', '娄星区'); INSERT INTO city VALUES ('2137', '431321', '431300', '双峰县'); INSERT INTO city VALUES ('2138', '431322', '431300', '新化县'); INSERT INTO city VALUES ('2139', '431381', '431300', '冷水江市'); INSERT INTO city VALUES ('214', '131001', '131000', '市辖区'); INSERT INTO city VALUES ('2140', '431382', '431300', '涟源市'); INSERT INTO city VALUES ('2141', '433100', '430000', '湘西土家族苗族自治州'); INSERT INTO city VALUES ('2142', '433101', '433100', '吉首市'); INSERT INTO city VALUES ('2143', '433122', '433100', '泸溪县'); INSERT INTO city VALUES ('2144', '433123', '433100', '凤凰县'); INSERT INTO city VALUES ('2145', '433124', '433100', '花垣县'); INSERT INTO city VALUES ('2146', '433125', '433100', '保靖县'); INSERT INTO city VALUES ('2147', '433126', '433100', '古丈县'); INSERT INTO city VALUES ('2148', '433127', '433100', '永顺县'); INSERT INTO city VALUES ('2149', '433130', '433100', '龙山县'); INSERT INTO city VALUES ('215', '131002', '131000', '安次区'); INSERT INTO city VALUES ('2150', '440000', '-', '广东省'); INSERT INTO city VALUES ('2151', '440100', '440000', '广州市'); INSERT INTO city VALUES ('2152', '440101', '440100', '市辖区'); INSERT INTO city VALUES ('2153', '440103', '440100', '荔湾区'); INSERT INTO city VALUES ('2154', '440104', '440100', '越秀区'); INSERT INTO city VALUES ('2155', '440105', '440100', '海珠区'); INSERT INTO city VALUES ('2156', '440106', '440100', '天河区'); INSERT INTO city VALUES ('2157', '440111', '440100', '白云区'); INSERT INTO city VALUES ('2158', '440112', '440100', '黄埔区'); INSERT INTO city VALUES ('2159', '440113', '440100', '番禺区'); INSERT INTO city VALUES ('216', '131003', '131000', '广阳区'); INSERT INTO city VALUES ('2160', '440114', '440100', '花都区'); INSERT INTO city VALUES ('2161', '440115', '440100', '南沙区'); INSERT INTO city VALUES ('2162', '440116', '440100', '萝岗区'); INSERT INTO city VALUES ('2163', '440183', '440100', '增城市'); INSERT INTO city VALUES ('2164', '440184', '440100', '从化市'); INSERT INTO city VALUES ('2165', '440200', '440000', '韶关市'); INSERT INTO city VALUES ('2166', '440201', '440200', '市辖区'); INSERT INTO city VALUES ('2167', '440203', '440200', '武江区'); INSERT INTO city VALUES ('2168', '440204', '440200', '浈江区'); INSERT INTO city VALUES ('2169', '440205', '440200', '曲江区'); INSERT INTO city VALUES ('217', '131022', '131000', '固安县'); INSERT INTO city VALUES ('2170', '440222', '440200', '始兴县'); INSERT INTO city VALUES ('2171', '440224', '440200', '仁化县'); INSERT INTO city VALUES ('2172', '440229', '440200', '翁源县'); INSERT INTO city VALUES ('2173', '440232', '440200', '乳源瑶族自治县'); INSERT INTO city VALUES ('2174', '440233', '440200', '新丰县'); INSERT INTO city VALUES ('2175', '440281', '440200', '乐昌市'); INSERT INTO city VALUES ('2176', '440282', '440200', '南雄市'); INSERT INTO city VALUES ('2177', '440300', '440000', '深圳市'); INSERT INTO city VALUES ('2178', '440301', '440300', '市辖区'); INSERT INTO city VALUES ('2179', '440303', '440300', '罗湖区'); INSERT INTO city VALUES ('218', '131023', '131000', '永清县'); INSERT INTO city VALUES ('2180', '440304', '440300', '福田区'); INSERT INTO city VALUES ('2181', '440305', '440300', '南山区'); INSERT INTO city VALUES ('2182', '440306', '440300', '宝安区'); INSERT INTO city VALUES ('2183', '440307', '440300', '龙岗区'); INSERT INTO city VALUES ('2184', '440308', '440300', '盐田区'); INSERT INTO city VALUES ('2185', '440400', '440000', '珠海市'); INSERT INTO city VALUES ('2186', '440401', '440400', '市辖区'); INSERT INTO city VALUES ('2187', '440402', '440400', '香洲区'); INSERT INTO city VALUES ('2188', '440403', '440400', '斗门区'); INSERT INTO city VALUES ('2189', '440404', '440400', '金湾区'); INSERT INTO city VALUES ('219', '131024', '131000', '香河县'); INSERT INTO city VALUES ('2190', '440500', '440000', '汕头市'); INSERT INTO city VALUES ('2191', '440501', '440500', '市辖区'); INSERT INTO city VALUES ('2192', '440507', '440500', '龙湖区'); INSERT INTO city VALUES ('2193', '440511', '440500', '金平区'); INSERT INTO city VALUES ('2194', '440512', '440500', '濠江区'); INSERT INTO city VALUES ('2195', '440513', '440500', '潮阳区'); INSERT INTO city VALUES ('2196', '440514', '440500', '潮南区'); INSERT INTO city VALUES ('2197', '440515', '440500', '澄海区'); INSERT INTO city VALUES ('2198', '440523', '440500', '南澳县'); INSERT INTO city VALUES ('2199', '440600', '440000', '佛山市'); INSERT INTO city VALUES ('22', '120000', '-', '天津市'); INSERT INTO city VALUES ('220', '131025', '131000', '大城县'); INSERT INTO city VALUES ('2200', '440601', '440600', '市辖区'); INSERT INTO city VALUES ('2201', '440604', '440600', '禅城区'); INSERT INTO city VALUES ('2202', '440605', '440600', '南海区'); INSERT INTO city VALUES ('2203', '440606', '440600', '顺德区'); INSERT INTO city VALUES ('2204', '440607', '440600', '三水区'); INSERT INTO city VALUES ('2205', '440608', '440600', '高明区'); INSERT INTO city VALUES ('2206', '440700', '440000', '江门市'); INSERT INTO city VALUES ('2207', '440701', '440700', '市辖区'); INSERT INTO city VALUES ('2208', '440703', '440700', '蓬江区'); INSERT INTO city VALUES ('2209', '440704', '440700', '江海区'); INSERT INTO city VALUES ('221', '131026', '131000', '文安县'); INSERT INTO city VALUES ('2210', '440705', '440700', '新会区'); INSERT INTO city VALUES ('2211', '440781', '440700', '台山市'); INSERT INTO city VALUES ('2212', '440783', '440700', '开平市'); INSERT INTO city VALUES ('2213', '440784', '440700', '鹤山市'); INSERT INTO city VALUES ('2214', '440785', '440700', '恩平市'); INSERT INTO city VALUES ('2215', '440800', '440000', '湛江市'); INSERT INTO city VALUES ('2216', '440801', '440800', '市辖区'); INSERT INTO city VALUES ('2217', '440802', '440800', '赤坎区'); INSERT INTO city VALUES ('2218', '440803', '440800', '霞山区'); INSERT INTO city VALUES ('2219', '440804', '440800', '坡头区'); INSERT INTO city VALUES ('222', '131028', '131000', '大厂回族自治县'); INSERT INTO city VALUES ('2220', '440811', '440800', '麻章区'); INSERT INTO city VALUES ('2221', '440823', '440800', '遂溪县'); INSERT INTO city VALUES ('2222', '440825', '440800', '徐闻县'); INSERT INTO city VALUES ('2223', '440881', '440800', '廉江市'); INSERT INTO city VALUES ('2224', '440882', '440800', '雷州市'); INSERT INTO city VALUES ('2225', '440883', '440800', '吴川市'); INSERT INTO city VALUES ('2226', '440900', '440000', '茂名市'); INSERT INTO city VALUES ('2227', '440901', '440900', '市辖区'); INSERT INTO city VALUES ('2228', '440902', '440900', '茂南区'); INSERT INTO city VALUES ('2229', '440903', '440900', '茂港区'); INSERT INTO city VALUES ('223', '131081', '131000', '霸州市'); INSERT INTO city VALUES ('2230', '440923', '440900', '电白县'); INSERT INTO city VALUES ('2231', '440981', '440900', '高州市'); INSERT INTO city VALUES ('2232', '440982', '440900', '化州市'); INSERT INTO city VALUES ('2233', '440983', '440900', '信宜市'); INSERT INTO city VALUES ('2234', '441200', '440000', '肇庆市'); INSERT INTO city VALUES ('2235', '441201', '441200', '市辖区'); INSERT INTO city VALUES ('2236', '441202', '441200', '端州区'); INSERT INTO city VALUES ('2237', '441203', '441200', '鼎湖区'); INSERT INTO city VALUES ('2238', '441223', '441200', '广宁县'); INSERT INTO city VALUES ('2239', '441224', '441200', '怀集县'); INSERT INTO city VALUES ('224', '131082', '131000', '三河市'); INSERT INTO city VALUES ('2240', '441225', '441200', '封开县'); INSERT INTO city VALUES ('2241', '441226', '441200', '德庆县'); INSERT INTO city VALUES ('2242', '441283', '441200', '高要市'); INSERT INTO city VALUES ('2243', '441284', '441200', '四会市'); INSERT INTO city VALUES ('2244', '441300', '440000', '惠州市'); INSERT INTO city VALUES ('2245', '441301', '441300', '市辖区'); INSERT INTO city VALUES ('2246', '441302', '441300', '惠城区'); INSERT INTO city VALUES ('2247', '441303', '441300', '惠阳区'); INSERT INTO city VALUES ('2248', '441322', '441300', '博罗县'); INSERT INTO city VALUES ('2249', '441323', '441300', '惠东县'); INSERT INTO city VALUES ('225', '131100', '130000', '衡水市'); INSERT INTO city VALUES ('2250', '441324', '441300', '龙门县'); INSERT INTO city VALUES ('2251', '441400', '440000', '梅州市'); INSERT INTO city VALUES ('2252', '441401', '441400', '市辖区'); INSERT INTO city VALUES ('2253', '441402', '441400', '梅江区'); INSERT INTO city VALUES ('2254', '441421', '441400', '梅县'); INSERT INTO city VALUES ('2255', '441422', '441400', '大埔县'); INSERT INTO city VALUES ('2256', '441423', '441400', '丰顺县'); INSERT INTO city VALUES ('2257', '441424', '441400', '五华县'); INSERT INTO city VALUES ('2258', '441426', '441400', '平远县'); INSERT INTO city VALUES ('2259', '441427', '441400', '蕉岭县'); INSERT INTO city VALUES ('226', '131101', '131100', '市辖区'); INSERT INTO city VALUES ('2260', '441481', '441400', '兴宁市'); INSERT INTO city VALUES ('2261', '441500', '440000', '汕尾市'); INSERT INTO city VALUES ('2262', '441501', '441500', '市辖区'); INSERT INTO city VALUES ('2263', '441502', '441500', '城区'); INSERT INTO city VALUES ('2264', '441521', '441500', '海丰县'); INSERT INTO city VALUES ('2265', '441523', '441500', '陆河县'); INSERT INTO city VALUES ('2266', '441581', '441500', '陆丰市'); INSERT INTO city VALUES ('2267', '441600', '440000', '河源市'); INSERT INTO city VALUES ('2268', '441601', '441600', '市辖区'); INSERT INTO city VALUES ('2269', '441602', '441600', '源城区'); INSERT INTO city VALUES ('227', '131102', '131100', '桃城区'); INSERT INTO city VALUES ('2270', '441621', '441600', '紫金县'); INSERT INTO city VALUES ('2271', '441622', '441600', '龙川县'); INSERT INTO city VALUES ('2272', '441623', '441600', '连平县'); INSERT INTO city VALUES ('2273', '441624', '441600', '和平县'); INSERT INTO city VALUES ('2274', '441625', '441600', '东源县'); INSERT INTO city VALUES ('2275', '441700', '440000', '阳江市'); INSERT INTO city VALUES ('2276', '441701', '441700', '市辖区'); INSERT INTO city VALUES ('2277', '441702', '441700', '江城区'); INSERT INTO city VALUES ('2278', '441721', '441700', '阳西县'); INSERT INTO city VALUES ('2279', '441723', '441700', '阳东县'); INSERT INTO city VALUES ('228', '131121', '131100', '枣强县'); INSERT INTO city VALUES ('2280', '441781', '441700', '阳春市'); INSERT INTO city VALUES ('2281', '441800', '440000', '清远市'); INSERT INTO city VALUES ('2282', '441801', '441800', '市辖区'); INSERT INTO city VALUES ('2283', '441802', '441800', '清城区'); INSERT INTO city VALUES ('2284', '441821', '441800', '佛冈县'); INSERT INTO city VALUES ('2285', '441823', '441800', '阳山县'); INSERT INTO city VALUES ('2286', '441825', '441800', '连山壮族瑶族自治县'); INSERT INTO city VALUES ('2287', '441826', '441800', '连南瑶族自治县'); INSERT INTO city VALUES ('2288', '441827', '441800', '清新县'); INSERT INTO city VALUES ('2289', '441881', '441800', '英德市'); INSERT INTO city VALUES ('229', '131122', '131100', '武邑县'); INSERT INTO city VALUES ('2290', '441882', '441800', '连州市'); INSERT INTO city VALUES ('2291', '441900', '440000', '东莞市'); INSERT INTO city VALUES ('2292', '442000', '440000', '中山市'); INSERT INTO city VALUES ('2293', '445100', '440000', '潮州市'); INSERT INTO city VALUES ('2294', '445101', '445100', '市辖区'); INSERT INTO city VALUES ('2295', '445102', '445100', '湘桥区'); INSERT INTO city VALUES ('2296', '445121', '445100', '潮安县'); INSERT INTO city VALUES ('2297', '445122', '445100', '饶平县'); INSERT INTO city VALUES ('2298', '445200', '440000', '揭阳市'); INSERT INTO city VALUES ('2299', '445201', '445200', '市辖区'); INSERT INTO city VALUES ('23', '120100', '120000', '市辖区'); INSERT INTO city VALUES ('230', '131123', '131100', '武强县'); INSERT INTO city VALUES ('2300', '445202', '445200', '榕城区'); INSERT INTO city VALUES ('2301', '445221', '445200', '揭东县'); INSERT INTO city VALUES ('2302', '445222', '445200', '揭西县'); INSERT INTO city VALUES ('2303', '445224', '445200', '惠来县'); INSERT INTO city VALUES ('2304', '445281', '445200', '普宁市'); INSERT INTO city VALUES ('2305', '445300', '440000', '云浮市'); INSERT INTO city VALUES ('2306', '445301', '445300', '市辖区'); INSERT INTO city VALUES ('2307', '445302', '445300', '云城区'); INSERT INTO city VALUES ('2308', '445321', '445300', '新兴县'); INSERT INTO city VALUES ('2309', '445322', '445300', '郁南县'); INSERT INTO city VALUES ('231', '131124', '131100', '饶阳县'); INSERT INTO city VALUES ('2310', '445323', '445300', '云安县'); INSERT INTO city VALUES ('2311', '445381', '445300', '罗定市'); INSERT INTO city VALUES ('2312', '450000', '-', '广西壮族自治区'); INSERT INTO city VALUES ('2313', '450100', '450000', '南宁市'); INSERT INTO city VALUES ('2314', '450101', '450100', '市辖区'); INSERT INTO city VALUES ('2315', '450102', '450100', '兴宁区'); INSERT INTO city VALUES ('2316', '450103', '450100', '青秀区'); INSERT INTO city VALUES ('2317', '450105', '450100', '江南区'); INSERT INTO city VALUES ('2318', '450107', '450100', '西乡塘区'); INSERT INTO city VALUES ('2319', '450108', '450100', '良庆区'); INSERT INTO city VALUES ('232', '131125', '131100', '安平县'); INSERT INTO city VALUES ('2320', '450109', '450100', '邕宁区'); INSERT INTO city VALUES ('2321', '450122', '450100', '武鸣县'); INSERT INTO city VALUES ('2322', '450123', '450100', '隆安县'); INSERT INTO city VALUES ('2323', '450124', '450100', '马山县'); INSERT INTO city VALUES ('2324', '450125', '450100', '上林县'); INSERT INTO city VALUES ('2325', '450126', '450100', '宾阳县'); INSERT INTO city VALUES ('2326', '450127', '450100', '横县'); INSERT INTO city VALUES ('2327', '450200', '450000', '柳州市'); INSERT INTO city VALUES ('2328', '450201', '450200', '市辖区'); INSERT INTO city VALUES ('2329', '450202', '450200', '城中区'); INSERT INTO city VALUES ('233', '131126', '131100', '故城县'); INSERT INTO city VALUES ('2330', '450203', '450200', '鱼峰区'); INSERT INTO city VALUES ('2331', '450204', '450200', '柳南区'); INSERT INTO city VALUES ('2332', '450205', '450200', '柳北区'); INSERT INTO city VALUES ('2333', '450221', '450200', '柳江县'); INSERT INTO city VALUES ('2334', '450222', '450200', '柳城县'); INSERT INTO city VALUES ('2335', '450223', '450200', '鹿寨县'); INSERT INTO city VALUES ('2336', '450224', '450200', '融安县'); INSERT INTO city VALUES ('2337', '450225', '450200', '融水苗族自治县'); INSERT INTO city VALUES ('2338', '450226', '450200', '三江侗族自治县'); INSERT INTO city VALUES ('2339', '450300', '450000', '桂林市'); INSERT INTO city VALUES ('234', '131127', '131100', '景县'); INSERT INTO city VALUES ('2340', '450301', '450300', '市辖区'); INSERT INTO city VALUES ('2341', '450302', '450300', '秀峰区'); INSERT INTO city VALUES ('2342', '450303', '450300', '叠彩区'); INSERT INTO city VALUES ('2343', '450304', '450300', '象山区'); INSERT INTO city VALUES ('2344', '450305', '450300', '七星区'); INSERT INTO city VALUES ('2345', '450311', '450300', '雁山区'); INSERT INTO city VALUES ('2346', '450321', '450300', '阳朔县'); INSERT INTO city VALUES ('2347', '450322', '450300', '临桂县'); INSERT INTO city VALUES ('2348', '450323', '450300', '灵川县'); INSERT INTO city VALUES ('2349', '450324', '450300', '全州县'); INSERT INTO city VALUES ('235', '131128', '131100', '阜城县'); INSERT INTO city VALUES ('2350', '450325', '450300', '兴安县'); INSERT INTO city VALUES ('2351', '450326', '450300', '永福县'); INSERT INTO city VALUES ('2352', '450327', '450300', '灌阳县'); INSERT INTO city VALUES ('2353', '450328', '450300', '龙胜各族自治县'); INSERT INTO city VALUES ('2354', '450329', '450300', '资源县'); INSERT INTO city VALUES ('2355', '450330', '450300', '平乐县'); INSERT INTO city VALUES ('2356', '450331', '450300', '荔蒲县'); INSERT INTO city VALUES ('2357', '450332', '450300', '恭城瑶族自治县'); INSERT INTO city VALUES ('2358', '450400', '450000', '梧州市'); INSERT INTO city VALUES ('2359', '450401', '450400', '市辖区'); INSERT INTO city VALUES ('236', '131181', '131100', '冀州市'); INSERT INTO city VALUES ('2360', '450403', '450400', '万秀区'); INSERT INTO city VALUES ('2361', '450404', '450400', '蝶山区'); INSERT INTO city VALUES ('2362', '450405', '450400', '长洲区'); INSERT INTO city VALUES ('2363', '450421', '450400', '苍梧县'); INSERT INTO city VALUES ('2364', '450422', '450400', '藤县'); INSERT INTO city VALUES ('2365', '450423', '450400', '蒙山县'); INSERT INTO city VALUES ('2366', '450481', '450400', '岑溪市'); INSERT INTO city VALUES ('2367', '450500', '450000', '北海市'); INSERT INTO city VALUES ('2368', '450501', '450500', '市辖区'); INSERT INTO city VALUES ('2369', '450502', '450500', '海城区'); INSERT INTO city VALUES ('237', '131182', '131100', '深州市'); INSERT INTO city VALUES ('2370', '450503', '450500', '银海区'); INSERT INTO city VALUES ('2371', '450512', '450500', '铁山港区'); INSERT INTO city VALUES ('2372', '450521', '450500', '合浦县'); INSERT INTO city VALUES ('2373', '450600', '450000', '防城港市'); INSERT INTO city VALUES ('2374', '450601', '450600', '市辖区'); INSERT INTO city VALUES ('2375', '450602', '450600', '港口区'); INSERT INTO city VALUES ('2376', '450603', '450600', '防城区'); INSERT INTO city VALUES ('2377', '450621', '450600', '上思县'); INSERT INTO city VALUES ('2378', '450681', '450600', '东兴市'); INSERT INTO city VALUES ('2379', '450700', '450000', '钦州市'); INSERT INTO city VALUES ('238', '140000', '-', '山西省'); INSERT INTO city VALUES ('2380', '450701', '450700', '市辖区'); INSERT INTO city VALUES ('2381', '450702', '450700', '钦南区'); INSERT INTO city VALUES ('2382', '450703', '450700', '钦北区'); INSERT INTO city VALUES ('2383', '450721', '450700', '灵山县'); INSERT INTO city VALUES ('2384', '450722', '450700', '浦北县'); INSERT INTO city VALUES ('2385', '450800', '450000', '贵港市'); INSERT INTO city VALUES ('2386', '450801', '450800', '市辖区'); INSERT INTO city VALUES ('2387', '450802', '450800', '港北区'); INSERT INTO city VALUES ('2388', '450803', '450800', '港南区'); INSERT INTO city VALUES ('2389', '450804', '450800', '覃塘区'); INSERT INTO city VALUES ('239', '140100', '140000', '太原市'); INSERT INTO city VALUES ('2390', '450821', '450800', '平南县'); INSERT INTO city VALUES ('2391', '450881', '450800', '桂平市'); INSERT INTO city VALUES ('2392', '450900', '450000', '玉林市'); INSERT INTO city VALUES ('2393', '450901', '450900', '市辖区'); INSERT INTO city VALUES ('2394', '450902', '450900', '玉州区'); INSERT INTO city VALUES ('2395', '450921', '450900', '容县'); INSERT INTO city VALUES ('2396', '450922', '450900', '陆川县'); INSERT INTO city VALUES ('2397', '450923', '450900', '博白县'); INSERT INTO city VALUES ('2398', '450924', '450900', '兴业县'); INSERT INTO city VALUES ('2399', '450981', '450900', '北流市'); INSERT INTO city VALUES ('24', '120101', '120100', '和平区'); INSERT INTO city VALUES ('240', '140101', '140100', '市辖区'); INSERT INTO city VALUES ('2400', '451000', '450000', '百色市'); INSERT INTO city VALUES ('2401', '451001', '451000', '市辖区'); INSERT INTO city VALUES ('2402', '451002', '451000', '右江区'); INSERT INTO city VALUES ('2403', '451021', '451000', '田阳县'); INSERT INTO city VALUES ('2404', '451022', '451000', '田东县'); INSERT INTO city VALUES ('2405', '451023', '451000', '平果县'); INSERT INTO city VALUES ('2406', '451024', '451000', '德保县'); INSERT INTO city VALUES ('2407', '451025', '451000', '靖西县'); INSERT INTO city VALUES ('2408', '451026', '451000', '那坡县'); INSERT INTO city VALUES ('2409', '451027', '451000', '凌云县'); INSERT INTO city VALUES ('241', '140105', '140100', '小店区'); INSERT INTO city VALUES ('2410', '451028', '451000', '乐业县'); INSERT INTO city VALUES ('2411', '451029', '451000', '田林县'); INSERT INTO city VALUES ('2412', '451030', '451000', '西林县'); INSERT INTO city VALUES ('2413', '451031', '451000', '隆林各族自治县'); INSERT INTO city VALUES ('2414', '451100', '450000', '贺州市'); INSERT INTO city VALUES ('2415', '451101', '451100', '市辖区'); INSERT INTO city VALUES ('2416', '451102', '451100', '八步区'); INSERT INTO city VALUES ('2417', '451121', '451100', '昭平县'); INSERT INTO city VALUES ('2418', '451122', '451100', '钟山县'); INSERT INTO city VALUES ('2419', '451123', '451100', '富川瑶族自治县'); INSERT INTO city VALUES ('242', '140106', '140100', '迎泽区'); INSERT INTO city VALUES ('2420', '451200', '450000', '河池市'); INSERT INTO city VALUES ('2421', '451201', '451200', '市辖区'); INSERT INTO city VALUES ('2422', '451202', '451200', '金城江区'); INSERT INTO city VALUES ('2423', '451221', '451200', '南丹县'); INSERT INTO city VALUES ('2424', '451222', '451200', '天峨县'); INSERT INTO city VALUES ('2425', '451223', '451200', '凤山县'); INSERT INTO city VALUES ('2426', '451224', '451200', '东兰县'); INSERT INTO city VALUES ('2427', '451225', '451200', '罗城仫佬族自治县'); INSERT INTO city VALUES ('2428', '451226', '451200', '环江毛南族自治县'); INSERT INTO city VALUES ('2429', '451227', '451200', '巴马瑶族自治县'); INSERT INTO city VALUES ('243', '140107', '140100', '杏花岭区'); INSERT INTO city VALUES ('2430', '451228', '451200', '都安瑶族自治县'); INSERT INTO city VALUES ('2431', '451229', '451200', '大化瑶族自治县'); INSERT INTO city VALUES ('2432', '451281', '451200', '宜州市'); INSERT INTO city VALUES ('2433', '451300', '450000', '来宾市'); INSERT INTO city VALUES ('2434', '451301', '451300', '市辖区'); INSERT INTO city VALUES ('2435', '451302', '451300', '兴宾区'); INSERT INTO city VALUES ('2436', '451321', '451300', '忻城县'); INSERT INTO city VALUES ('2437', '451322', '451300', '象州县'); INSERT INTO city VALUES ('2438', '451323', '451300', '武宣县'); INSERT INTO city VALUES ('2439', '451324', '451300', '金秀瑶族自治县'); INSERT INTO city VALUES ('244', '140108', '140100', '尖草坪区'); INSERT INTO city VALUES ('2440', '451381', '451300', '合山市'); INSERT INTO city VALUES ('2441', '451400', '450000', '崇左市'); INSERT INTO city VALUES ('2442', '451401', '451400', '市辖区'); INSERT INTO city VALUES ('2443', '451402', '451400', '江洲区'); INSERT INTO city VALUES ('2444', '451421', '451400', '扶绥县'); INSERT INTO city VALUES ('2445', '451422', '451400', '宁明县'); INSERT INTO city VALUES ('2446', '451423', '451400', '龙州县'); INSERT INTO city VALUES ('2447', '451424', '451400', '大新县'); INSERT INTO city VALUES ('2448', '451425', '451400', '天等县'); INSERT INTO city VALUES ('2449', '451481', '451400', '凭祥市'); INSERT INTO city VALUES ('245', '140109', '140100', '万柏林区'); INSERT INTO city VALUES ('2450', '460000', '-', '海南省'); INSERT INTO city VALUES ('2451', '460100', '460000', '海口市'); INSERT INTO city VALUES ('2452', '460101', '460100', '市辖区'); INSERT INTO city VALUES ('2453', '460105', '460100', '秀英区'); INSERT INTO city VALUES ('2454', '460106', '460100', '龙华区'); INSERT INTO city VALUES ('2455', '460107', '460100', '琼山区'); INSERT INTO city VALUES ('2456', '460108', '460100', '美兰区'); INSERT INTO city VALUES ('2457', '460200', '460000', '三亚市'); INSERT INTO city VALUES ('2458', '460201', '460200', '市辖区'); INSERT INTO city VALUES ('2459', '469000', '460000', '省直辖县级行政单位'); INSERT INTO city VALUES ('246', '140110', '140100', '晋源区'); INSERT INTO city VALUES ('2460', '469001', '469000', '五指山市'); INSERT INTO city VALUES ('2461', '469002', '469000', '琼海市'); INSERT INTO city VALUES ('2462', '469003', '469000', '儋州市'); INSERT INTO city VALUES ('2463', '469005', '469000', '文昌市'); INSERT INTO city VALUES ('2464', '469006', '469000', '万宁市'); INSERT INTO city VALUES ('2465', '469007', '469000', '东方市'); INSERT INTO city VALUES ('2466', '469021', '469000', '定安县(**)'); INSERT INTO city VALUES ('2467', '469022', '469000', '屯昌县(**)'); INSERT INTO city VALUES ('2468', '469023', '469000', '澄迈县(**)'); INSERT INTO city VALUES ('2469', '469024', '469000', '临高县(**)'); INSERT INTO city VALUES ('247', '140121', '140100', '清徐县'); INSERT INTO city VALUES ('2470', '469025', '469000', '白沙黎族自治县(**)'); INSERT INTO city VALUES ('2471', '469026', '469000', '昌江黎族自治县(**)'); INSERT INTO city VALUES ('2472', '469027', '469000', '乐东黎族自治县(**)'); INSERT INTO city VALUES ('2473', '469028', '469000', '陵水黎族自治县(**)'); INSERT INTO city VALUES ('2474', '469029', '469000', '保亭黎族苗族自治县(**)'); INSERT INTO city VALUES ('2475', '469030', '469000', '琼中黎族苗族自治县(**)'); INSERT INTO city VALUES ('2476', '469031', '469000', '西沙群岛(**)'); INSERT INTO city VALUES ('2477', '469032', '469000', '南沙群岛(**)'); INSERT INTO city VALUES ('2478', '469033', '469000', '中沙群岛的岛礁及其海域(**)'); INSERT INTO city VALUES ('2479', '500000', '-', '重庆市'); INSERT INTO city VALUES ('248', '140122', '140100', '阳曲县'); INSERT INTO city VALUES ('2480', '500100', '500000', '市辖区'); INSERT INTO city VALUES ('2481', '500101', '500100', '万州区'); INSERT INTO city VALUES ('2482', '500102', '500100', '涪陵区'); INSERT INTO city VALUES ('2483', '500103', '500100', '渝中区'); INSERT INTO city VALUES ('2484', '500104', '500100', '大渡口区'); INSERT INTO city VALUES ('2485', '500105', '500100', '江北区'); INSERT INTO city VALUES ('2486', '500106', '500100', '沙坪坝区'); INSERT INTO city VALUES ('2487', '500107', '500100', '九龙坡区'); INSERT INTO city VALUES ('2488', '500108', '500100', '南岸区'); INSERT INTO city VALUES ('2489', '500109', '500100', '北碚区'); INSERT INTO city VALUES ('249', '140123', '140100', '娄烦县'); INSERT INTO city VALUES ('2490', '500110', '500100', '万盛区'); INSERT INTO city VALUES ('2491', '500111', '500100', '双桥区'); INSERT INTO city VALUES ('2492', '500112', '500100', '渝北区'); INSERT INTO city VALUES ('2493', '500113', '500100', '巴南区'); INSERT INTO city VALUES ('2494', '500114', '500100', '黔江区'); INSERT INTO city VALUES ('2495', '500115', '500100', '长寿区'); INSERT INTO city VALUES ('2496', '500116', '500100', '江津区'); INSERT INTO city VALUES ('2497', '500117', '500100', '合川区'); INSERT INTO city VALUES ('2498', '500118', '500100', '永川区'); INSERT INTO city VALUES ('2499', '500119', '500100', '南川区'); INSERT INTO city VALUES ('25', '120102', '120100', '河东区'); INSERT INTO city VALUES ('250', '140181', '140100', '古交市'); INSERT INTO city VALUES ('2500', '500200', '500000', '县'); INSERT INTO city VALUES ('2501', '500222', '500200', '綦江县'); INSERT INTO city VALUES ('2502', '500223', '500200', '潼南县'); INSERT INTO city VALUES ('2503', '500224', '500200', '铜梁县'); INSERT INTO city VALUES ('2504', '500225', '500200', '大足县'); INSERT INTO city VALUES ('2505', '500226', '500200', '荣昌县'); INSERT INTO city VALUES ('2506', '500227', '500200', '璧山县'); INSERT INTO city VALUES ('2507', '500228', '500200', '梁平县'); INSERT INTO city VALUES ('2508', '500229', '500200', '城口县'); INSERT INTO city VALUES ('2509', '500230', '500200', '丰都县'); INSERT INTO city VALUES ('251', '140200', '140000', '大同市'); INSERT INTO city VALUES ('2510', '500231', '500200', '垫江县'); INSERT INTO city VALUES ('2511', '500232', '500200', '武隆县'); INSERT INTO city VALUES ('2512', '500233', '500200', '忠县'); INSERT INTO city VALUES ('2513', '500234', '500200', '开县'); INSERT INTO city VALUES ('2514', '500235', '500200', '云阳县'); INSERT INTO city VALUES ('2515', '500236', '500200', '奉节县'); INSERT INTO city VALUES ('2516', '500237', '500200', '巫山县'); INSERT INTO city VALUES ('2517', '500238', '500200', '巫溪县'); INSERT INTO city VALUES ('2518', '500240', '500200', '石柱土家族自治县'); INSERT INTO city VALUES ('2519', '500241', '500200', '秀山土家族苗族自治县'); INSERT INTO city VALUES ('252', '140201', '140200', '市辖区'); INSERT INTO city VALUES ('2520', '500242', '500200', '酉阳土家族苗族自治县'); INSERT INTO city VALUES ('2521', '500243', '500200', '彭水苗族土家族自治县'); INSERT INTO city VALUES ('2522', '510000', '-', '四川省'); INSERT INTO city VALUES ('2523', '510100', '510000', '成都市'); INSERT INTO city VALUES ('2524', '510101', '510100', '市辖区'); INSERT INTO city VALUES ('2525', '510104', '510100', '锦江区'); INSERT INTO city VALUES ('2526', '510105', '510100', '青羊区'); INSERT INTO city VALUES ('2527', '510106', '510100', '金牛区'); INSERT INTO city VALUES ('2528', '510107', '510100', '武侯区'); INSERT INTO city VALUES ('2529', '510108', '510100', '成华区'); INSERT INTO city VALUES ('253', '140202', '140200', '城区'); INSERT INTO city VALUES ('2530', '510112', '510100', '龙泉驿区'); INSERT INTO city VALUES ('2531', '510113', '510100', '青白江区'); INSERT INTO city VALUES ('2532', '510114', '510100', '新都区'); INSERT INTO city VALUES ('2533', '510115', '510100', '温江区'); INSERT INTO city VALUES ('2534', '510121', '510100', '金堂县'); INSERT INTO city VALUES ('2535', '510122', '510100', '双流县'); INSERT INTO city VALUES ('2536', '510124', '510100', '郫县'); INSERT INTO city VALUES ('2537', '510129', '510100', '大邑县'); INSERT INTO city VALUES ('2538', '510131', '510100', '蒲江县'); INSERT INTO city VALUES ('2539', '510132', '510100', '新津县'); INSERT INTO city VALUES ('254', '140203', '140200', '矿区'); INSERT INTO city VALUES ('2540', '510181', '510100', '都江堰市'); INSERT INTO city VALUES ('2541', '510182', '510100', '彭州市'); INSERT INTO city VALUES ('2542', '510183', '510100', '邛崃市'); INSERT INTO city VALUES ('2543', '510184', '510100', '崇州市'); INSERT INTO city VALUES ('2544', '510300', '510000', '自贡市'); INSERT INTO city VALUES ('2545', '510301', '510300', '市辖区'); INSERT INTO city VALUES ('2546', '510302', '510300', '自流井区'); INSERT INTO city VALUES ('2547', '510303', '510300', '贡井区'); INSERT INTO city VALUES ('2548', '510304', '510300', '大安区'); INSERT INTO city VALUES ('2549', '510311', '510300', '沿滩区'); INSERT INTO city VALUES ('255', '140211', '140200', '南郊区'); INSERT INTO city VALUES ('2550', '510321', '510300', '荣县'); INSERT INTO city VALUES ('2551', '510322', '510300', '富顺县'); INSERT INTO city VALUES ('2552', '510400', '510000', '攀枝花市'); INSERT INTO city VALUES ('2553', '510401', '510400', '市辖区'); INSERT INTO city VALUES ('2554', '510402', '510400', '东区'); INSERT INTO city VALUES ('2555', '510403', '510400', '西区'); INSERT INTO city VALUES ('2556', '510411', '510400', '仁和区'); INSERT INTO city VALUES ('2557', '510421', '510400', '米易县'); INSERT INTO city VALUES ('2558', '510422', '510400', '盐边县'); INSERT INTO city VALUES ('2559', '510500', '510000', '泸州市'); INSERT INTO city VALUES ('256', '140212', '140200', '新荣区'); INSERT INTO city VALUES ('2560', '510501', '510500', '市辖区'); INSERT INTO city VALUES ('2561', '510502', '510500', '江阳区'); INSERT INTO city VALUES ('2562', '510503', '510500', '纳溪区'); INSERT INTO city VALUES ('2563', '510504', '510500', '龙马潭区'); INSERT INTO city VALUES ('2564', '510521', '510500', '泸县'); INSERT INTO city VALUES ('2565', '510522', '510500', '合江县'); INSERT INTO city VALUES ('2566', '510524', '510500', '叙永县'); INSERT INTO city VALUES ('2567', '510525', '510500', '古蔺县'); INSERT INTO city VALUES ('2568', '510600', '510000', '德阳市'); INSERT INTO city VALUES ('2569', '510601', '510600', '市辖区'); INSERT INTO city VALUES ('257', '140221', '140200', '阳高县'); INSERT INTO city VALUES ('2570', '510603', '510600', '旌阳区'); INSERT INTO city VALUES ('2571', '510623', '510600', '中江县'); INSERT INTO city VALUES ('2572', '510626', '510600', '罗江县'); INSERT INTO city VALUES ('2573', '510681', '510600', '广汉市'); INSERT INTO city VALUES ('2574', '510682', '510600', '什邡市'); INSERT INTO city VALUES ('2575', '510683', '510600', '绵竹市'); INSERT INTO city VALUES ('2576', '510700', '510000', '绵阳市'); INSERT INTO city VALUES ('2577', '510701', '510700', '市辖区'); INSERT INTO city VALUES ('2578', '510703', '510700', '涪城区'); INSERT INTO city VALUES ('2579', '510704', '510700', '游仙区'); INSERT INTO city VALUES ('258', '140222', '140200', '天镇县'); INSERT INTO city VALUES ('2580', '510722', '510700', '三台县'); INSERT INTO city VALUES ('2581', '510723', '510700', '盐亭县'); INSERT INTO city VALUES ('2582', '510724', '510700', '安县'); INSERT INTO city VALUES ('2583', '510725', '510700', '梓潼县'); INSERT INTO city VALUES ('2584', '510726', '510700', '北川羌族自治县'); INSERT INTO city VALUES ('2585', '510727', '510700', '平武县'); INSERT INTO city VALUES ('2586', '510781', '510700', '江油市'); INSERT INTO city VALUES ('2587', '510800', '510000', '广元市'); INSERT INTO city VALUES ('2588', '510801', '510800', '市辖区'); INSERT INTO city VALUES ('2589', '510802', '510800', '市中区'); INSERT INTO city VALUES ('259', '140223', '140200', '广灵县'); INSERT INTO city VALUES ('2590', '510811', '510800', '元坝区'); INSERT INTO city VALUES ('2591', '510812', '510800', '朝天区'); INSERT INTO city VALUES ('2592', '510821', '510800', '旺苍县'); INSERT INTO city VALUES ('2593', '510822', '510800', '青川县'); INSERT INTO city VALUES ('2594', '510823', '510800', '剑阁县'); INSERT INTO city VALUES ('2595', '510824', '510800', '苍溪县'); INSERT INTO city VALUES ('2596', '510900', '510000', '遂宁市'); INSERT INTO city VALUES ('2597', '510901', '510900', '市辖区'); INSERT INTO city VALUES ('2598', '510903', '510900', '船山区'); INSERT INTO city VALUES ('2599', '510904', '510900', '安居区'); INSERT INTO city VALUES ('26', '120103', '120100', '河西区'); INSERT INTO city VALUES ('260', '140224', '140200', '灵丘县'); INSERT INTO city VALUES ('2600', '510921', '510900', '蓬溪县'); INSERT INTO city VALUES ('2601', '510922', '510900', '射洪县'); INSERT INTO city VALUES ('2602', '510923', '510900', '大英县'); INSERT INTO city VALUES ('2603', '511000', '510000', '内江市'); INSERT INTO city VALUES ('2604', '511001', '511000', '市辖区'); INSERT INTO city VALUES ('2605', '511002', '511000', '市中区'); INSERT INTO city VALUES ('2606', '511011', '511000', '东兴区'); INSERT INTO city VALUES ('2607', '511024', '511000', '威远县'); INSERT INTO city VALUES ('2608', '511025', '511000', '资中县'); INSERT INTO city VALUES ('2609', '511028', '511000', '隆昌县'); INSERT INTO city VALUES ('261', '140225', '140200', '浑源县'); INSERT INTO city VALUES ('2610', '511100', '510000', '乐山市'); INSERT INTO city VALUES ('2611', '511101', '511100', '市辖区'); INSERT INTO city VALUES ('2612', '511102', '511100', '市中区'); INSERT INTO city VALUES ('2613', '511111', '511100', '沙湾区'); INSERT INTO city VALUES ('2614', '511112', '511100', '五通桥区'); INSERT INTO city VALUES ('2615', '511113', '511100', '金口河区'); INSERT INTO city VALUES ('2616', '511123', '511100', '犍为县'); INSERT INTO city VALUES ('2617', '511124', '511100', '井研县'); INSERT INTO city VALUES ('2618', '511126', '511100', '夹江县'); INSERT INTO city VALUES ('2619', '511129', '511100', '沐川县'); INSERT INTO city VALUES ('262', '140226', '140200', '左云县'); INSERT INTO city VALUES ('2620', '511132', '511100', '峨边彝族自治县'); INSERT INTO city VALUES ('2621', '511133', '511100', '马边彝族自治县'); INSERT INTO city VALUES ('2622', '511181', '511100', '峨眉山市'); INSERT INTO city VALUES ('2623', '511300', '510000', '南充市'); INSERT INTO city VALUES ('2624', '511301', '511300', '市辖区'); INSERT INTO city VALUES ('2625', '511302', '511300', '顺庆区'); INSERT INTO city VALUES ('2626', '511303', '511300', '高坪区'); INSERT INTO city VALUES ('2627', '511304', '511300', '嘉陵区'); INSERT INTO city VALUES ('2628', '511321', '511300', '南部县'); INSERT INTO city VALUES ('2629', '511322', '511300', '营山县'); INSERT INTO city VALUES ('263', '140227', '140200', '大同县'); INSERT INTO city VALUES ('2630', '511323', '511300', '蓬安县'); INSERT INTO city VALUES ('2631', '511324', '511300', '仪陇县'); INSERT INTO city VALUES ('2632', '511325', '511300', '西充县'); INSERT INTO city VALUES ('2633', '511381', '511300', '阆中市'); INSERT INTO city VALUES ('2634', '511400', '510000', '眉山市'); INSERT INTO city VALUES ('2635', '511401', '511400', '市辖区'); INSERT INTO city VALUES ('2636', '511402', '511400', '东坡区'); INSERT INTO city VALUES ('2637', '511421', '511400', '仁寿县'); INSERT INTO city VALUES ('2638', '511422', '511400', '彭山县'); INSERT INTO city VALUES ('2639', '511423', '511400', '洪雅县'); INSERT INTO city VALUES ('264', '140300', '140000', '阳泉市'); INSERT INTO city VALUES ('2640', '511424', '511400', '丹棱县'); INSERT INTO city VALUES ('2641', '511425', '511400', '青神县'); INSERT INTO city VALUES ('2642', '511500', '510000', '宜宾市'); INSERT INTO city VALUES ('2643', '511501', '511500', '市辖区'); INSERT INTO city VALUES ('2644', '511502', '511500', '翠屏区'); INSERT INTO city VALUES ('2645', '511521', '511500', '宜宾县'); INSERT INTO city VALUES ('2646', '511522', '511500', '南溪县'); INSERT INTO city VALUES ('2647', '511523', '511500', '江安县'); INSERT INTO city VALUES ('2648', '511524', '511500', '长宁县'); INSERT INTO city VALUES ('2649', '511525', '511500', '高县'); INSERT INTO city VALUES ('265', '140301', '140300', '市辖区'); INSERT INTO city VALUES ('2650', '511526', '511500', '珙县'); INSERT INTO city VALUES ('2651', '511527', '511500', '筠连县'); INSERT INTO city VALUES ('2652', '511528', '511500', '兴文县'); INSERT INTO city VALUES ('2653', '511529', '511500', '屏山县'); INSERT INTO city VALUES ('2654', '511600', '510000', '广安市'); INSERT INTO city VALUES ('2655', '511601', '511600', '市辖区'); INSERT INTO city VALUES ('2656', '511602', '511600', '广安区'); INSERT INTO city VALUES ('2657', '511621', '511600', '岳池县'); INSERT INTO city VALUES ('2658', '511622', '511600', '武胜县'); INSERT INTO city VALUES ('2659', '511623', '511600', '邻水县'); INSERT INTO city VALUES ('266', '140302', '140300', '城区'); INSERT INTO city VALUES ('2660', '511681', '511600', '华蓥市'); INSERT INTO city VALUES ('2661', '511700', '510000', '达州市'); INSERT INTO city VALUES ('2662', '511701', '511700', '市辖区'); INSERT INTO city VALUES ('2663', '511702', '511700', '通川区'); INSERT INTO city VALUES ('2664', '511721', '511700', '达县'); INSERT INTO city VALUES ('2665', '511722', '511700', '宣汉县'); INSERT INTO city VALUES ('2666', '511723', '511700', '开江县'); INSERT INTO city VALUES ('2667', '511724', '511700', '大竹县'); INSERT INTO city VALUES ('2668', '511725', '511700', '渠县'); INSERT INTO city VALUES ('2669', '511781', '511700', '万源市'); INSERT INTO city VALUES ('267', '140303', '140300', '矿区'); INSERT INTO city VALUES ('2670', '511800', '510000', '雅安市'); INSERT INTO city VALUES ('2671', '511801', '511800', '市辖区'); INSERT INTO city VALUES ('2672', '511802', '511800', '雨城区'); INSERT INTO city VALUES ('2673', '511821', '511800', '名山县'); INSERT INTO city VALUES ('2674', '511822', '511800', '荥经县'); INSERT INTO city VALUES ('2675', '511823', '511800', '汉源县'); INSERT INTO city VALUES ('2676', '511824', '511800', '石棉县'); INSERT INTO city VALUES ('2677', '511825', '511800', '天全县'); INSERT INTO city VALUES ('2678', '511826', '511800', '芦山县'); INSERT INTO city VALUES ('2679', '511827', '511800', '宝兴县'); INSERT INTO city VALUES ('268', '140311', '140300', '郊区'); INSERT INTO city VALUES ('2680', '511900', '510000', '巴中市'); INSERT INTO city VALUES ('2681', '511901', '511900', '市辖区'); INSERT INTO city VALUES ('2682', '511902', '511900', '巴州区'); INSERT INTO city VALUES ('2683', '511921', '511900', '通江县'); INSERT INTO city VALUES ('2684', '511922', '511900', '南江县'); INSERT INTO city VALUES ('2685', '511923', '511900', '平昌县'); INSERT INTO city VALUES ('2686', '512000', '510000', '资阳市'); INSERT INTO city VALUES ('2687', '512001', '512000', '市辖区'); INSERT INTO city VALUES ('2688', '512002', '512000', '雁江区'); INSERT INTO city VALUES ('2689', '512021', '512000', '安岳县'); INSERT INTO city VALUES ('269', '140321', '140300', '平定县'); INSERT INTO city VALUES ('2690', '512022', '512000', '乐至县'); INSERT INTO city VALUES ('2691', '512081', '512000', '简阳市'); INSERT INTO city VALUES ('2692', '513200', '510000', '阿坝藏族羌族自治州'); INSERT INTO city VALUES ('2693', '513221', '513200', '汶川县'); INSERT INTO city VALUES ('2694', '513222', '513200', '理县'); INSERT INTO city VALUES ('2695', '513223', '513200', '茂县'); INSERT INTO city VALUES ('2696', '513224', '513200', '松潘县'); INSERT INTO city VALUES ('2697', '513225', '513200', '九寨沟县'); INSERT INTO city VALUES ('2698', '513226', '513200', '金川县'); INSERT INTO city VALUES ('2699', '513227', '513200', '小金县'); INSERT INTO city VALUES ('27', '120104', '120100', '南开区'); INSERT INTO city VALUES ('270', '140322', '140300', '盂县'); INSERT INTO city VALUES ('2700', '513228', '513200', '黑水县'); INSERT INTO city VALUES ('2701', '513229', '513200', '马尔康县'); INSERT INTO city VALUES ('2702', '513230', '513200', '壤塘县'); INSERT INTO city VALUES ('2703', '513231', '513200', '阿坝县'); INSERT INTO city VALUES ('2704', '513232', '513200', '若尔盖县'); INSERT INTO city VALUES ('2705', '513233', '513200', '红原县'); INSERT INTO city VALUES ('2706', '513300', '510000', '甘孜藏族自治州'); INSERT INTO city VALUES ('2707', '513321', '513300', '康定县'); INSERT INTO city VALUES ('2708', '513322', '513300', '泸定县'); INSERT INTO city VALUES ('2709', '513323', '513300', '丹巴县'); INSERT INTO city VALUES ('271', '140400', '140000', '长治市'); INSERT INTO city VALUES ('2710', '513324', '513300', '九龙县'); INSERT INTO city VALUES ('2711', '513325', '513300', '雅江县'); INSERT INTO city VALUES ('2712', '513326', '513300', '道孚县'); INSERT INTO city VALUES ('2713', '513327', '513300', '炉霍县'); INSERT INTO city VALUES ('2714', '513328', '513300', '甘孜县'); INSERT INTO city VALUES ('2715', '513329', '513300', '新龙县'); INSERT INTO city VALUES ('2716', '513330', '513300', '德格县'); INSERT INTO city VALUES ('2717', '513331', '513300', '白玉县'); INSERT INTO city VALUES ('2718', '513332', '513300', '石渠县'); INSERT INTO city VALUES ('2719', '513333', '513300', '色达县'); INSERT INTO city VALUES ('272', '140401', '140400', '市辖区'); INSERT INTO city VALUES ('2720', '513334', '513300', '理塘县'); INSERT INTO city VALUES ('2721', '513335', '513300', '巴塘县'); INSERT INTO city VALUES ('2722', '513336', '513300', '乡城县'); INSERT INTO city VALUES ('2723', '513337', '513300', '稻城县'); INSERT INTO city VALUES ('2724', '513338', '513300', '得荣县'); INSERT INTO city VALUES ('2725', '513400', '510000', '凉山彝族自治州'); INSERT INTO city VALUES ('2726', '513401', '513400', '西昌市'); INSERT INTO city VALUES ('2727', '513422', '513400', '木里藏族自治县'); INSERT INTO city VALUES ('2728', '513423', '513400', '盐源县'); INSERT INTO city VALUES ('2729', '513424', '513400', '德昌县'); INSERT INTO city VALUES ('273', '140402', '140400', '城区'); INSERT INTO city VALUES ('2730', '513425', '513400', '会理县'); INSERT INTO city VALUES ('2731', '513426', '513400', '会东县'); INSERT INTO city VALUES ('2732', '513427', '513400', '宁南县'); INSERT INTO city VALUES ('2733', '513428', '513400', '普格县'); INSERT INTO city VALUES ('2734', '513429', '513400', '布拖县'); INSERT INTO city VALUES ('2735', '513430', '513400', '金阳县'); INSERT INTO city VALUES ('2736', '513431', '513400', '昭觉县'); INSERT INTO city VALUES ('2737', '513432', '513400', '喜德县'); INSERT INTO city VALUES ('2738', '513433', '513400', '冕宁县'); INSERT INTO city VALUES ('2739', '513434', '513400', '越西县'); INSERT INTO city VALUES ('274', '140411', '140400', '郊区'); INSERT INTO city VALUES ('2740', '513435', '513400', '甘洛县'); INSERT INTO city VALUES ('2741', '513436', '513400', '美姑县'); INSERT INTO city VALUES ('2742', '513437', '513400', '雷波县'); INSERT INTO city VALUES ('2743', '520000', '-', '贵州省'); INSERT INTO city VALUES ('2744', '520100', '520000', '贵阳市'); INSERT INTO city VALUES ('2745', '520101', '520100', '市辖区'); INSERT INTO city VALUES ('2746', '520102', '520100', '南明区'); INSERT INTO city VALUES ('2747', '520103', '520100', '云岩区'); INSERT INTO city VALUES ('2748', '520111', '520100', '花溪区'); INSERT INTO city VALUES ('2749', '520112', '520100', '乌当区'); INSERT INTO city VALUES ('275', '140421', '140400', '长治县'); INSERT INTO city VALUES ('2750', '520113', '520100', '白云区'); INSERT INTO city VALUES ('2751', '520114', '520100', '小河区'); INSERT INTO city VALUES ('2752', '520121', '520100', '开阳县'); INSERT INTO city VALUES ('2753', '520122', '520100', '息烽县'); INSERT INTO city VALUES ('2754', '520123', '520100', '修文县'); INSERT INTO city VALUES ('2755', '520181', '520100', '清镇市'); INSERT INTO city VALUES ('2756', '520200', '520000', '六盘水市'); INSERT INTO city VALUES ('2757', '520201', '520200', '钟山区'); INSERT INTO city VALUES ('2758', '520203', '520200', '六枝特区'); INSERT INTO city VALUES ('2759', '520221', '520200', '水城县'); INSERT INTO city VALUES ('276', '140423', '140400', '襄垣县'); INSERT INTO city VALUES ('2760', '520222', '520200', '盘县'); INSERT INTO city VALUES ('2761', '520300', '520000', '遵义市'); INSERT INTO city VALUES ('2762', '520301', '520300', '市辖区'); INSERT INTO city VALUES ('2763', '520302', '520300', '红花岗区'); INSERT INTO city VALUES ('2764', '520303', '520300', '汇川区'); INSERT INTO city VALUES ('2765', '520321', '520300', '遵义县'); INSERT INTO city VALUES ('2766', '520322', '520300', '桐梓县'); INSERT INTO city VALUES ('2767', '520323', '520300', '绥阳县'); INSERT INTO city VALUES ('2768', '520324', '520300', '正安县'); INSERT INTO city VALUES ('2769', '520325', '520300', '道真仡佬族苗族自治县'); INSERT INTO city VALUES ('277', '140424', '140400', '屯留县'); INSERT INTO city VALUES ('2770', '520326', '520300', '务川仡佬族苗族自治县'); INSERT INTO city VALUES ('2771', '520327', '520300', '凤冈县'); INSERT INTO city VALUES ('2772', '520328', '520300', '湄潭县'); INSERT INTO city VALUES ('2773', '520329', '520300', '余庆县'); INSERT INTO city VALUES ('2774', '520330', '520300', '习水县'); INSERT INTO city VALUES ('2775', '520381', '520300', '赤水市'); INSERT INTO city VALUES ('2776', '520382', '520300', '仁怀市'); INSERT INTO city VALUES ('2777', '520400', '520000', '安顺市'); INSERT INTO city VALUES ('2778', '520401', '520400', '市辖区'); INSERT INTO city VALUES ('2779', '520402', '520400', '西秀区'); INSERT INTO city VALUES ('278', '140425', '140400', '平顺县'); INSERT INTO city VALUES ('2780', '520421', '520400', '平坝县'); INSERT INTO city VALUES ('2781', '520422', '520400', '普定县'); INSERT INTO city VALUES ('2782', '520423', '520400', '镇宁布依族苗族自治县'); INSERT INTO city VALUES ('2783', '520424', '520400', '关岭布依族苗族自治县'); INSERT INTO city VALUES ('2784', '520425', '520400', '紫云苗族布依族自治县'); INSERT INTO city VALUES ('2785', '522200', '520000', '铜仁地区'); INSERT INTO city VALUES ('2786', '522201', '522200', '铜仁市'); INSERT INTO city VALUES ('2787', '522222', '522200', '江口县'); INSERT INTO city VALUES ('2788', '522223', '522200', '玉屏侗族自治县'); INSERT INTO city VALUES ('2789', '522224', '522200', '石阡县'); INSERT INTO city VALUES ('279', '140426', '140400', '黎城县'); INSERT INTO city VALUES ('2790', '522225', '522200', '思南县'); INSERT INTO city VALUES ('2791', '522226', '522200', '印江土家族苗族自治县'); INSERT INTO city VALUES ('2792', '522227', '522200', '德江县'); INSERT INTO city VALUES ('2793', '522228', '522200', '沿河土家族自治县'); INSERT INTO city VALUES ('2794', '522229', '522200', '松桃苗族自治县'); INSERT INTO city VALUES ('2795', '522230', '522200', '万山特区'); INSERT INTO city VALUES ('2796', '522300', '520000', '黔西南布依族苗族自治州'); INSERT INTO city VALUES ('2797', '522301', '522300', '兴义市'); INSERT INTO city VALUES ('2798', '522322', '522300', '兴仁县'); INSERT INTO city VALUES ('2799', '522323', '522300', '普安县'); INSERT INTO city VALUES ('28', '120105', '120100', '河北区'); INSERT INTO city VALUES ('280', '140427', '140400', '壶关县'); INSERT INTO city VALUES ('2800', '522324', '522300', '晴隆县'); INSERT INTO city VALUES ('2801', '522325', '522300', '贞丰县'); INSERT INTO city VALUES ('2802', '522326', '522300', '望谟县'); INSERT INTO city VALUES ('2803', '522327', '522300', '册亨县'); INSERT INTO city VALUES ('2804', '522328', '522300', '安龙县'); INSERT INTO city VALUES ('2805', '522400', '520000', '毕节地区'); INSERT INTO city VALUES ('2806', '522401', '522400', '毕节市'); INSERT INTO city VALUES ('2807', '522422', '522400', '大方县'); INSERT INTO city VALUES ('2808', '522423', '522400', '黔西县'); INSERT INTO city VALUES ('2809', '522424', '522400', '金沙县'); INSERT INTO city VALUES ('281', '140428', '140400', '长子县'); INSERT INTO city VALUES ('2810', '522425', '522400', '织金县'); INSERT INTO city VALUES ('2811', '522426', '522400', '纳雍县'); INSERT INTO city VALUES ('2812', '522427', '522400', '威宁彝族回族苗族自治县'); INSERT INTO city VALUES ('2813', '522428', '522400', '赫章县'); INSERT INTO city VALUES ('2814', '522600', '520000', '黔东南苗族侗族自治州'); INSERT INTO city VALUES ('2815', '522601', '522600', '凯里市'); INSERT INTO city VALUES ('2816', '522622', '522600', '黄平县'); INSERT INTO city VALUES ('2817', '522623', '522600', '施秉县'); INSERT INTO city VALUES ('2818', '522624', '522600', '三穗县'); INSERT INTO city VALUES ('2819', '522625', '522600', '镇远县'); INSERT INTO city VALUES ('282', '140429', '140400', '武乡县'); INSERT INTO city VALUES ('2820', '522626', '522600', '岑巩县'); INSERT INTO city VALUES ('2821', '522627', '522600', '天柱县'); INSERT INTO city VALUES ('2822', '522628', '522600', '锦屏县'); INSERT INTO city VALUES ('2823', '522629', '522600', '剑河县'); INSERT INTO city VALUES ('2824', '522630', '522600', '台江县'); INSERT INTO city VALUES ('2825', '522631', '522600', '黎平县'); INSERT INTO city VALUES ('2826', '522632', '522600', '榕江县'); INSERT INTO city VALUES ('2827', '522633', '522600', '从江县'); INSERT INTO city VALUES ('2828', '522634', '522600', '雷山县'); INSERT INTO city VALUES ('2829', '522635', '522600', '麻江县'); INSERT INTO city VALUES ('283', '140430', '140400', '沁县'); INSERT INTO city VALUES ('2830', '522636', '522600', '丹寨县'); INSERT INTO city VALUES ('2831', '522700', '520000', '黔南布依族苗族自治州'); INSERT INTO city VALUES ('2832', '522701', '522700', '都匀市'); INSERT INTO city VALUES ('2833', '522702', '522700', '福泉市'); INSERT INTO city VALUES ('2834', '522722', '522700', '荔波县'); INSERT INTO city VALUES ('2835', '522723', '522700', '贵定县'); INSERT INTO city VALUES ('2836', '522725', '522700', '瓮安县'); INSERT INTO city VALUES ('2837', '522726', '522700', '独山县'); INSERT INTO city VALUES ('2838', '522727', '522700', '平塘县'); INSERT INTO city VALUES ('2839', '522728', '522700', '罗甸县'); INSERT INTO city VALUES ('284', '140431', '140400', '沁源县'); INSERT INTO city VALUES ('2840', '522729', '522700', '长顺县'); INSERT INTO city VALUES ('2841', '522730', '522700', '龙里县'); INSERT INTO city VALUES ('2842', '522731', '522700', '惠水县'); INSERT INTO city VALUES ('2843', '522732', '522700', '三都水族自治县'); INSERT INTO city VALUES ('2844', '530000', '-', '云南省'); INSERT INTO city VALUES ('2845', '530100', '530000', '昆明市'); INSERT INTO city VALUES ('2846', '530101', '530100', '市辖区'); INSERT INTO city VALUES ('2847', '530102', '530100', '五华区'); INSERT INTO city VALUES ('2848', '530103', '530100', '盘龙区'); INSERT INTO city VALUES ('2849', '530111', '530100', '官渡区'); INSERT INTO city VALUES ('285', '140481', '140400', '潞城市'); INSERT INTO city VALUES ('2850', '530112', '530100', '西山区'); INSERT INTO city VALUES ('2851', '530113', '530100', '东川区'); INSERT INTO city VALUES ('2852', '530121', '530100', '呈贡县'); INSERT INTO city VALUES ('2853', '530122', '530100', '晋宁县'); INSERT INTO city VALUES ('2854', '530124', '530100', '富民县'); INSERT INTO city VALUES ('2855', '530125', '530100', '宜良县'); INSERT INTO city VALUES ('2856', '530126', '530100', '石林彝族自治县'); INSERT INTO city VALUES ('2857', '530127', '530100', '嵩明县'); INSERT INTO city VALUES ('2858', '530128', '530100', '禄劝彝族苗族自治县'); INSERT INTO city VALUES ('2859', '530129', '530100', '寻甸回族彝族自治县'); INSERT INTO city VALUES ('286', '140500', '140000', '晋城市'); INSERT INTO city VALUES ('2860', '530181', '530100', '安宁市'); INSERT INTO city VALUES ('2861', '530300', '530000', '曲靖市'); INSERT INTO city VALUES ('2862', '530301', '530300', '市辖区'); INSERT INTO city VALUES ('2863', '530302', '530300', '麒麟区'); INSERT INTO city VALUES ('2864', '530321', '530300', '马龙县'); INSERT INTO city VALUES ('2865', '530322', '530300', '陆良县'); INSERT INTO city VALUES ('2866', '530323', '530300', '师宗县'); INSERT INTO city VALUES ('2867', '530324', '530300', '罗平县'); INSERT INTO city VALUES ('2868', '530325', '530300', '富源县'); INSERT INTO city VALUES ('2869', '530326', '530300', '会泽县'); INSERT INTO city VALUES ('287', '140501', '140500', '市辖区'); INSERT INTO city VALUES ('2870', '530328', '530300', '沾益县'); INSERT INTO city VALUES ('2871', '530381', '530300', '宣威市'); INSERT INTO city VALUES ('2872', '530400', '530000', '玉溪市'); INSERT INTO city VALUES ('2873', '530401', '530400', '市辖区'); INSERT INTO city VALUES ('2874', '530402', '530400', '红塔区'); INSERT INTO city VALUES ('2875', '530421', '530400', '江川县'); INSERT INTO city VALUES ('2876', '530422', '530400', '澄江县'); INSERT INTO city VALUES ('2877', '530423', '530400', '通海县'); INSERT INTO city VALUES ('2878', '530424', '530400', '华宁县'); INSERT INTO city VALUES ('2879', '530425', '530400', '易门县'); INSERT INTO city VALUES ('288', '140502', '140500', '城区'); INSERT INTO city VALUES ('2880', '530426', '530400', '峨山彝族自治县'); INSERT INTO city VALUES ('2881', '530427', '530400', '新平彝族傣族自治县'); INSERT INTO city VALUES ('2882', '530428', '530400', '元江哈尼族彝族傣族自治县'); INSERT INTO city VALUES ('2883', '530500', '530000', '保山市'); INSERT INTO city VALUES ('2884', '530501', '530500', '市辖区'); INSERT INTO city VALUES ('2885', '530502', '530500', '隆阳区'); INSERT INTO city VALUES ('2886', '530521', '530500', '施甸县'); INSERT INTO city VALUES ('2887', '530522', '530500', '腾冲县'); INSERT INTO city VALUES ('2888', '530523', '530500', '龙陵县'); INSERT INTO city VALUES ('2889', '530524', '530500', '昌宁县'); INSERT INTO city VALUES ('289', '140521', '140500', '沁水县'); INSERT INTO city VALUES ('2890', '530600', '530000', '昭通市'); INSERT INTO city VALUES ('2891', '530601', '530600', '市辖区'); INSERT INTO city VALUES ('2892', '530602', '530600', '昭阳区'); INSERT INTO city VALUES ('2893', '530621', '530600', '鲁甸县'); INSERT INTO city VALUES ('2894', '530622', '530600', '巧家县'); INSERT INTO city VALUES ('2895', '530623', '530600', '盐津县'); INSERT INTO city VALUES ('2896', '530624', '530600', '大关县'); INSERT INTO city VALUES ('2897', '530625', '530600', '永善县'); INSERT INTO city VALUES ('2898', '530626', '530600', '绥江县'); INSERT INTO city VALUES ('2899', '530627', '530600', '镇雄县'); INSERT INTO city VALUES ('29', '120106', '120100', '红桥区'); INSERT INTO city VALUES ('290', '140522', '140500', '阳城县'); INSERT INTO city VALUES ('2900', '530628', '530600', '彝良县'); INSERT INTO city VALUES ('2901', '530629', '530600', '威信县'); INSERT INTO city VALUES ('2902', '530630', '530600', '水富县'); INSERT INTO city VALUES ('2903', '530700', '530000', '丽江市'); INSERT INTO city VALUES ('2904', '530701', '530700', '市辖区'); INSERT INTO city VALUES ('2905', '530702', '530700', '古城区'); INSERT INTO city VALUES ('2906', '530721', '530700', '玉龙纳西族自治县'); INSERT INTO city VALUES ('2907', '530722', '530700', '永胜县'); INSERT INTO city VALUES ('2908', '530723', '530700', '华坪县'); INSERT INTO city VALUES ('2909', '530724', '530700', '宁蒗彝族自治县'); INSERT INTO city VALUES ('291', '140524', '140500', '陵川县'); INSERT INTO city VALUES ('2910', '530800', '530000', '普洱市(*)'); INSERT INTO city VALUES ('2911', '530801', '530800', '市辖区'); INSERT INTO city VALUES ('2912', '530802', '530800', '思茅区(*)'); INSERT INTO city VALUES ('2913', '530821', '530800', '宁洱哈尼族彝族自治县(*)'); INSERT INTO city VALUES ('2914', '530822', '530800', '墨江哈尼族自治县'); INSERT INTO city VALUES ('2915', '530823', '530800', '景东彝族自治县'); INSERT INTO city VALUES ('2916', '530824', '530800', '景谷傣族彝族自治县'); INSERT INTO city VALUES ('2917', '530825', '530800', '镇沅彝族哈尼族拉祜族自治县'); INSERT INTO city VALUES ('2918', '530826', '530800', '江城哈尼族彝族自治县'); INSERT INTO city VALUES ('2919', '530827', '530800', '孟连傣族拉祜族佤族自治县'); INSERT INTO city VALUES ('292', '140525', '140500', '泽州县'); INSERT INTO city VALUES ('2920', '530828', '530800', '澜沧拉祜族自治县'); INSERT INTO city VALUES ('2921', '530829', '530800', '西盟佤族自治县'); INSERT INTO city VALUES ('2922', '530900', '530000', '临沧市'); INSERT INTO city VALUES ('2923', '530901', '530900', '市辖区'); INSERT INTO city VALUES ('2924', '530902', '530900', '临翔区'); INSERT INTO city VALUES ('2925', '530921', '530900', '凤庆县'); INSERT INTO city VALUES ('2926', '530922', '530900', '云县'); INSERT INTO city VALUES ('2927', '530923', '530900', '永德县'); INSERT INTO city VALUES ('2928', '530924', '530900', '镇康县'); INSERT INTO city VALUES ('2929', '530925', '530900', '双江拉祜族佤族布朗族傣族自治'); INSERT INTO city VALUES ('293', '140581', '140500', '高平市'); INSERT INTO city VALUES ('2930', '530926', '530900', '耿马傣族佤族自治县'); INSERT INTO city VALUES ('2931', '530927', '530900', '沧源佤族自治县'); INSERT INTO city VALUES ('2932', '532300', '530000', '楚雄彝族自治州'); INSERT INTO city VALUES ('2933', '532301', '532300', '楚雄市'); INSERT INTO city VALUES ('2934', '532322', '532300', '双柏县'); INSERT INTO city VALUES ('2935', '532323', '532300', '牟定县'); INSERT INTO city VALUES ('2936', '532324', '532300', '南华县'); INSERT INTO city VALUES ('2937', '532325', '532300', '姚安县'); INSERT INTO city VALUES ('2938', '532326', '532300', '大姚县'); INSERT INTO city VALUES ('2939', '532327', '532300', '永仁县'); INSERT INTO city VALUES ('294', '140600', '140000', '朔州市'); INSERT INTO city VALUES ('2940', '532328', '532300', '元谋县'); INSERT INTO city VALUES ('2941', '532329', '532300', '武定县'); INSERT INTO city VALUES ('2942', '532331', '532300', '禄丰县'); INSERT INTO city VALUES ('2943', '532500', '530000', '红河哈尼族彝族自治州'); INSERT INTO city VALUES ('2944', '532501', '532500', '个旧市'); INSERT INTO city VALUES ('2945', '532502', '532500', '开远市'); INSERT INTO city VALUES ('2946', '532522', '532500', '蒙自县'); INSERT INTO city VALUES ('2947', '532523', '532500', '屏边苗族自治县'); INSERT INTO city VALUES ('2948', '532524', '532500', '建水县'); INSERT INTO city VALUES ('2949', '532525', '532500', '石屏县'); INSERT INTO city VALUES ('295', '140601', '140600', '市辖区'); INSERT INTO city VALUES ('2950', '532526', '532500', '弥勒县'); INSERT INTO city VALUES ('2951', '532527', '532500', '泸西县'); INSERT INTO city VALUES ('2952', '532528', '532500', '元阳县'); INSERT INTO city VALUES ('2953', '532529', '532500', '红河县'); INSERT INTO city VALUES ('2954', '532530', '532500', '金平苗族瑶族傣族自治县'); INSERT INTO city VALUES ('2955', '532531', '532500', '绿春县'); INSERT INTO city VALUES ('2956', '532532', '532500', '河口瑶族自治县'); INSERT INTO city VALUES ('2957', '532600', '530000', '文山壮族苗族自治州'); INSERT INTO city VALUES ('2958', '532621', '532600', '文山县'); INSERT INTO city VALUES ('2959', '532622', '532600', '砚山县'); INSERT INTO city VALUES ('296', '140602', '140600', '朔城区'); INSERT INTO city VALUES ('2960', '532623', '532600', '西畴县'); INSERT INTO city VALUES ('2961', '532624', '532600', '麻栗坡县'); INSERT INTO city VALUES ('2962', '532625', '532600', '马关县'); INSERT INTO city VALUES ('2963', '532626', '532600', '丘北县'); INSERT INTO city VALUES ('2964', '532627', '532600', '广南县'); INSERT INTO city VALUES ('2965', '532628', '532600', '富宁县'); INSERT INTO city VALUES ('2966', '532800', '530000', '西双版纳傣族自治州'); INSERT INTO city VALUES ('2967', '532801', '532800', '景洪市'); INSERT INTO city VALUES ('2968', '532822', '532800', '勐海县'); INSERT INTO city VALUES ('2969', '532823', '532800', '勐腊县'); INSERT INTO city VALUES ('297', '140603', '140600', '平鲁区'); INSERT INTO city VALUES ('2970', '532900', '530000', '大理白族自治州'); INSERT INTO city VALUES ('2971', '532901', '532900', '大理市'); INSERT INTO city VALUES ('2972', '532922', '532900', '漾濞彝族自治县'); INSERT INTO city VALUES ('2973', '532923', '532900', '祥云县'); INSERT INTO city VALUES ('2974', '532924', '532900', '宾川县'); INSERT INTO city VALUES ('2975', '532925', '532900', '弥渡县'); INSERT INTO city VALUES ('2976', '532926', '532900', '南涧彝族自治县'); INSERT INTO city VALUES ('2977', '532927', '532900', '巍山彝族回族自治县'); INSERT INTO city VALUES ('2978', '532928', '532900', '永平县'); INSERT INTO city VALUES ('2979', '532929', '532900', '云龙县'); INSERT INTO city VALUES ('298', '140621', '140600', '山阴县'); INSERT INTO city VALUES ('2980', '532930', '532900', '洱源县'); INSERT INTO city VALUES ('2981', '532931', '532900', '剑川县'); INSERT INTO city VALUES ('2982', '532932', '532900', '鹤庆县'); INSERT INTO city VALUES ('2983', '533100', '530000', '德宏傣族景颇族自治州'); INSERT INTO city VALUES ('2984', '533102', '533100', '瑞丽市'); INSERT INTO city VALUES ('2985', '533103', '533100', '潞西市'); INSERT INTO city VALUES ('2986', '533122', '533100', '梁河县'); INSERT INTO city VALUES ('2987', '533123', '533100', '盈江县'); INSERT INTO city VALUES ('2988', '533124', '533100', '陇川县'); INSERT INTO city VALUES ('2989', '533300', '530000', '怒江傈僳族自治州'); INSERT INTO city VALUES ('299', '140622', '140600', '应县'); INSERT INTO city VALUES ('2990', '533321', '533300', '泸水县'); INSERT INTO city VALUES ('2991', '533323', '533300', '福贡县'); INSERT INTO city VALUES ('2992', '533324', '533300', '贡山独龙族怒族自治县'); INSERT INTO city VALUES ('2993', '533325', '533300', '兰坪白族普米族自治县'); INSERT INTO city VALUES ('2994', '533400', '530000', '迪庆藏族自治州'); INSERT INTO city VALUES ('2995', '533421', '533400', '香格里拉县'); INSERT INTO city VALUES ('2996', '533422', '533400', '德钦县'); INSERT INTO city VALUES ('2997', '533423', '533400', '维西傈僳族自治县'); INSERT INTO city VALUES ('2998', '540000', '-', '西藏自治区'); INSERT INTO city VALUES ('2999', '540100', '540000', '拉萨市'); INSERT INTO city VALUES ('3', '110101', '110100', '东城区'); INSERT INTO city VALUES ('30', '120107', '120100', '塘沽区'); INSERT INTO city VALUES ('300', '140623', '140600', '右玉县'); INSERT INTO city VALUES ('3000', '540101', '540100', '市辖区'); INSERT INTO city VALUES ('3001', '540102', '540100', '城关区'); INSERT INTO city VALUES ('3002', '540121', '540100', '林周县'); INSERT INTO city VALUES ('3003', '540122', '540100', '当雄县'); INSERT INTO city VALUES ('3004', '540123', '540100', '尼木县'); INSERT INTO city VALUES ('3005', '540124', '540100', '曲水县'); INSERT INTO city VALUES ('3006', '540125', '540100', '堆龙德庆县'); INSERT INTO city VALUES ('3007', '540126', '540100', '达孜县'); INSERT INTO city VALUES ('3008', '540127', '540100', '墨竹工卡县'); INSERT INTO city VALUES ('3009', '542100', '540000', '昌都地区'); INSERT INTO city VALUES ('301', '140624', '140600', '怀仁县'); INSERT INTO city VALUES ('3010', '542121', '542100', '昌都县'); INSERT INTO city VALUES ('3011', '542122', '542100', '江达县'); INSERT INTO city VALUES ('3012', '542123', '542100', '贡觉县'); INSERT INTO city VALUES ('3013', '542124', '542100', '类乌齐县'); INSERT INTO city VALUES ('3014', '542125', '542100', '丁青县'); INSERT INTO city VALUES ('3015', '542126', '542100', '察雅县'); INSERT INTO city VALUES ('3016', '542127', '542100', '八宿县'); INSERT INTO city VALUES ('3017', '542128', '542100', '左贡县'); INSERT INTO city VALUES ('3018', '542129', '542100', '芒康县'); INSERT INTO city VALUES ('3019', '542132', '542100', '洛隆县'); INSERT INTO city VALUES ('302', '140700', '140000', '晋中市'); INSERT INTO city VALUES ('3020', '542133', '542100', '边坝县'); INSERT INTO city VALUES ('3021', '542200', '540000', '山南地区'); INSERT INTO city VALUES ('3022', '542221', '542200', '乃东县'); INSERT INTO city VALUES ('3023', '542222', '542200', '扎囊县'); INSERT INTO city VALUES ('3024', '542223', '542200', '贡嘎县'); INSERT INTO city VALUES ('3025', '542224', '542200', '桑日县'); INSERT INTO city VALUES ('3026', '542225', '542200', '琼结县'); INSERT INTO city VALUES ('3027', '542226', '542200', '曲松县'); INSERT INTO city VALUES ('3028', '542227', '542200', '措美县'); INSERT INTO city VALUES ('3029', '542228', '542200', '洛扎县'); INSERT INTO city VALUES ('303', '140701', '140700', '市辖区'); INSERT INTO city VALUES ('3030', '542229', '542200', '加查县'); INSERT INTO city VALUES ('3031', '542231', '542200', '隆子县'); INSERT INTO city VALUES ('3032', '542232', '542200', '错那县'); INSERT INTO city VALUES ('3033', '542233', '542200', '浪卡子县'); INSERT INTO city VALUES ('3034', '542300', '540000', '日喀则地区'); INSERT INTO city VALUES ('3035', '542301', '542300', '日喀则市'); INSERT INTO city VALUES ('3036', '542322', '542300', '南木林县'); INSERT INTO city VALUES ('3037', '542323', '542300', '江孜县'); INSERT INTO city VALUES ('3038', '542324', '542300', '定日县'); INSERT INTO city VALUES ('3039', '542325', '542300', '萨迦县'); INSERT INTO city VALUES ('304', '140702', '140700', '榆次区'); INSERT INTO city VALUES ('3040', '542326', '542300', '拉孜县'); INSERT INTO city VALUES ('3041', '542327', '542300', '昂仁县'); INSERT INTO city VALUES ('3042', '542328', '542300', '谢通门县'); INSERT INTO city VALUES ('3043', '542329', '542300', '白朗县'); INSERT INTO city VALUES ('3044', '542330', '542300', '仁布县'); INSERT INTO city VALUES ('3045', '542331', '542300', '康马县'); INSERT INTO city VALUES ('3046', '542332', '542300', '定结县'); INSERT INTO city VALUES ('3047', '542333', '542300', '仲巴县'); INSERT INTO city VALUES ('3048', '542334', '542300', '亚东县'); INSERT INTO city VALUES ('3049', '542335', '542300', '吉隆县'); INSERT INTO city VALUES ('305', '140721', '140700', '榆社县'); INSERT INTO city VALUES ('3050', '542336', '542300', '聂拉木县'); INSERT INTO city VALUES ('3051', '542337', '542300', '萨嘎县'); INSERT INTO city VALUES ('3052', '542338', '542300', '岗巴县'); INSERT INTO city VALUES ('3053', '542400', '540000', '那曲地区'); INSERT INTO city VALUES ('3054', '542421', '542400', '那曲县'); INSERT INTO city VALUES ('3055', '542422', '542400', '嘉黎县'); INSERT INTO city VALUES ('3056', '542423', '542400', '比如县'); INSERT INTO city VALUES ('3057', '542424', '542400', '聂荣县'); INSERT INTO city VALUES ('3058', '542425', '542400', '安多县'); INSERT INTO city VALUES ('3059', '542426', '542400', '申扎县'); INSERT INTO city VALUES ('306', '140722', '140700', '左权县'); INSERT INTO city VALUES ('3060', '542427', '542400', '索县'); INSERT INTO city VALUES ('3061', '542428', '542400', '班戈县'); INSERT INTO city VALUES ('3062', '542429', '542400', '巴青县'); INSERT INTO city VALUES ('3063', '542430', '542400', '尼玛县'); INSERT INTO city VALUES ('3064', '542500', '540000', '阿里地区'); INSERT INTO city VALUES ('3065', '542521', '542500', '普兰县'); INSERT INTO city VALUES ('3066', '542522', '542500', '札达县'); INSERT INTO city VALUES ('3067', '542523', '542500', '噶尔县'); INSERT INTO city VALUES ('3068', '542524', '542500', '日土县'); INSERT INTO city VALUES ('3069', '542525', '542500', '革吉县'); INSERT INTO city VALUES ('307', '140723', '140700', '和顺县'); INSERT INTO city VALUES ('3070', '542526', '542500', '改则县'); INSERT INTO city VALUES ('3071', '542527', '542500', '措勤县'); INSERT INTO city VALUES ('3072', '542600', '540000', '林芝地区'); INSERT INTO city VALUES ('3073', '542621', '542600', '林芝县'); INSERT INTO city VALUES ('3074', '542622', '542600', '工布江达县'); INSERT INTO city VALUES ('3075', '542623', '542600', '米林县'); INSERT INTO city VALUES ('3076', '542624', '542600', '墨脱县'); INSERT INTO city VALUES ('3077', '542625', '542600', '波密县'); INSERT INTO city VALUES ('3078', '542626', '542600', '察隅县'); INSERT INTO city VALUES ('3079', '542627', '542600', '朗县'); INSERT INTO city VALUES ('308', '140724', '140700', '昔阳县'); INSERT INTO city VALUES ('3080', '610000', '-', '陕西省'); INSERT INTO city VALUES ('3081', '610100', '610000', '西安市'); INSERT INTO city VALUES ('3082', '610101', '610100', '市辖区'); INSERT INTO city VALUES ('3083', '610102', '610100', '新城区'); INSERT INTO city VALUES ('3084', '610103', '610100', '碑林区'); INSERT INTO city VALUES ('3085', '610104', '610100', '莲湖区'); INSERT INTO city VALUES ('3086', '610111', '610100', '灞桥区'); INSERT INTO city VALUES ('3087', '610112', '610100', '未央区'); INSERT INTO city VALUES ('3088', '610113', '610100', '雁塔区'); INSERT INTO city VALUES ('3089', '610114', '610100', '阎良区'); INSERT INTO city VALUES ('309', '140725', '140700', '寿阳县'); INSERT INTO city VALUES ('3090', '610115', '610100', '临潼区'); INSERT INTO city VALUES ('3091', '610116', '610100', '长安区'); INSERT INTO city VALUES ('3092', '610122', '610100', '蓝田县'); INSERT INTO city VALUES ('3093', '610124', '610100', '周至县'); INSERT INTO city VALUES ('3094', '610125', '610100', '户县'); INSERT INTO city VALUES ('3095', '610126', '610100', '高陵县'); INSERT INTO city VALUES ('3096', '610200', '610000', '铜川市'); INSERT INTO city VALUES ('3097', '610201', '610200', '市辖区'); INSERT INTO city VALUES ('3098', '610202', '610200', '王益区'); INSERT INTO city VALUES ('3099', '610203', '610200', '印台区'); INSERT INTO city VALUES ('31', '120108', '120100', '汉沽区'); INSERT INTO city VALUES ('310', '140726', '140700', '太谷县'); INSERT INTO city VALUES ('3100', '610204', '610200', '耀州区'); INSERT INTO city VALUES ('3101', '610222', '610200', '宜君县'); INSERT INTO city VALUES ('3102', '610300', '610000', '宝鸡市'); INSERT INTO city VALUES ('3103', '610301', '610300', '市辖区'); INSERT INTO city VALUES ('3104', '610302', '610300', '渭滨区'); INSERT INTO city VALUES ('3105', '610303', '610300', '金台区'); INSERT INTO city VALUES ('3106', '610304', '610300', '陈仓区'); INSERT INTO city VALUES ('3107', '610322', '610300', '凤翔县'); INSERT INTO city VALUES ('3108', '610323', '610300', '岐山县'); INSERT INTO city VALUES ('3109', '610324', '610300', '扶风县'); INSERT INTO city VALUES ('311', '140727', '140700', '祁县'); INSERT INTO city VALUES ('3110', '610326', '610300', '眉县'); INSERT INTO city VALUES ('3111', '610327', '610300', '陇县'); INSERT INTO city VALUES ('3112', '610328', '610300', '千阳县'); INSERT INTO city VALUES ('3113', '610329', '610300', '麟游县'); INSERT INTO city VALUES ('3114', '610330', '610300', '凤县'); INSERT INTO city VALUES ('3115', '610331', '610300', '太白县'); INSERT INTO city VALUES ('3116', '610400', '610000', '咸阳市'); INSERT INTO city VALUES ('3117', '610401', '610400', '市辖区'); INSERT INTO city VALUES ('3118', '610402', '610400', '秦都区'); INSERT INTO city VALUES ('3119', '610403', '610400', '杨凌区'); INSERT INTO city VALUES ('312', '140728', '140700', '平遥县'); INSERT INTO city VALUES ('3120', '610404', '610400', '渭城区'); INSERT INTO city VALUES ('3121', '610422', '610400', '三原县'); INSERT INTO city VALUES ('3122', '610423', '610400', '泾阳县'); INSERT INTO city VALUES ('3123', '610424', '610400', '乾县'); INSERT INTO city VALUES ('3124', '610425', '610400', '礼泉县'); INSERT INTO city VALUES ('3125', '610426', '610400', '永寿县'); INSERT INTO city VALUES ('3126', '610427', '610400', '彬县'); INSERT INTO city VALUES ('3127', '610428', '610400', '长武县'); INSERT INTO city VALUES ('3128', '610429', '610400', '旬邑县'); INSERT INTO city VALUES ('3129', '610430', '610400', '淳化县'); INSERT INTO city VALUES ('313', '140729', '140700', '灵石县'); INSERT INTO city VALUES ('3130', '610431', '610400', '武功县'); INSERT INTO city VALUES ('3131', '610481', '610400', '兴平市'); INSERT INTO city VALUES ('3132', '610500', '610000', '渭南市'); INSERT INTO city VALUES ('3133', '610501', '610500', '市辖区'); INSERT INTO city VALUES ('3134', '610502', '610500', '临渭区'); INSERT INTO city VALUES ('3135', '610521', '610500', '华县'); INSERT INTO city VALUES ('3136', '610522', '610500', '潼关县'); INSERT INTO city VALUES ('3137', '610523', '610500', '大荔县'); INSERT INTO city VALUES ('3138', '610524', '610500', '合阳县'); INSERT INTO city VALUES ('3139', '610525', '610500', '澄城县'); INSERT INTO city VALUES ('314', '140781', '140700', '介休市'); INSERT INTO city VALUES ('3140', '610526', '610500', '蒲城县'); INSERT INTO city VALUES ('3141', '610527', '610500', '白水县'); INSERT INTO city VALUES ('3142', '610528', '610500', '富平县'); INSERT INTO city VALUES ('3143', '610581', '610500', '韩城市'); INSERT INTO city VALUES ('3144', '610582', '610500', '华阴市'); INSERT INTO city VALUES ('3145', '610600', '610000', '延安市'); INSERT INTO city VALUES ('3146', '610601', '610600', '市辖区'); INSERT INTO city VALUES ('3147', '610602', '610600', '宝塔区'); INSERT INTO city VALUES ('3148', '610621', '610600', '延长县'); INSERT INTO city VALUES ('3149', '610622', '610600', '延川县'); INSERT INTO city VALUES ('315', '140800', '140000', '运城市'); INSERT INTO city VALUES ('3150', '610623', '610600', '子长县'); INSERT INTO city VALUES ('3151', '610624', '610600', '安塞县'); INSERT INTO city VALUES ('3152', '610625', '610600', '志丹县'); INSERT INTO city VALUES ('3153', '610626', '610600', '吴起县'); INSERT INTO city VALUES ('3154', '610627', '610600', '甘泉县'); INSERT INTO city VALUES ('3155', '610628', '610600', '富县'); INSERT INTO city VALUES ('3156', '610629', '610600', '洛川县'); INSERT INTO city VALUES ('3157', '610630', '610600', '宜川县'); INSERT INTO city VALUES ('3158', '610631', '610600', '黄龙县'); INSERT INTO city VALUES ('3159', '610632', '610600', '黄陵县'); INSERT INTO city VALUES ('316', '140801', '140800', '市辖区'); INSERT INTO city VALUES ('3160', '610700', '610000', '汉中市'); INSERT INTO city VALUES ('3161', '610701', '610700', '市辖区'); INSERT INTO city VALUES ('3162', '610702', '610700', '汉台区'); INSERT INTO city VALUES ('3163', '610721', '610700', '南郑县'); INSERT INTO city VALUES ('3164', '610722', '610700', '城固县'); INSERT INTO city VALUES ('3165', '610723', '610700', '洋县'); INSERT INTO city VALUES ('3166', '610724', '610700', '西乡县'); INSERT INTO city VALUES ('3167', '610725', '610700', '勉县'); INSERT INTO city VALUES ('3168', '610726', '610700', '宁强县'); INSERT INTO city VALUES ('3169', '610727', '610700', '略阳县'); INSERT INTO city VALUES ('317', '140802', '140800', '盐湖区'); INSERT INTO city VALUES ('3170', '610728', '610700', '镇巴县'); INSERT INTO city VALUES ('3171', '610729', '610700', '留坝县'); INSERT INTO city VALUES ('3172', '610730', '610700', '佛坪县'); INSERT INTO city VALUES ('3173', '610800', '610000', '榆林市'); INSERT INTO city VALUES ('3174', '610801', '610800', '市辖区'); INSERT INTO city VALUES ('3175', '610802', '610800', '榆阳区'); INSERT INTO city VALUES ('3176', '610821', '610800', '神木县'); INSERT INTO city VALUES ('3177', '610822', '610800', '府谷县'); INSERT INTO city VALUES ('3178', '610823', '610800', '横山县'); INSERT INTO city VALUES ('3179', '610824', '610800', '靖边县'); INSERT INTO city VALUES ('318', '140821', '140800', '临猗县'); INSERT INTO city VALUES ('3180', '610825', '610800', '定边县'); INSERT INTO city VALUES ('3181', '610826', '610800', '绥德县'); INSERT INTO city VALUES ('3182', '610827', '610800', '米脂县'); INSERT INTO city VALUES ('3183', '610828', '610800', '佳县'); INSERT INTO city VALUES ('3184', '610829', '610800', '吴堡县'); INSERT INTO city VALUES ('3185', '610830', '610800', '清涧县'); INSERT INTO city VALUES ('3186', '610831', '610800', '子洲县'); INSERT INTO city VALUES ('3187', '610900', '610000', '安康市'); INSERT INTO city VALUES ('3188', '610901', '610900', '市辖区'); INSERT INTO city VALUES ('3189', '610902', '610900', '汉滨区'); INSERT INTO city VALUES ('319', '140822', '140800', '万荣县'); INSERT INTO city VALUES ('3190', '610921', '610900', '汉阴县'); INSERT INTO city VALUES ('3191', '610922', '610900', '石泉县'); INSERT INTO city VALUES ('3192', '610923', '610900', '宁陕县'); INSERT INTO city VALUES ('3193', '610924', '610900', '紫阳县'); INSERT INTO city VALUES ('3194', '610925', '610900', '岚皋县'); INSERT INTO city VALUES ('3195', '610926', '610900', '平利县'); INSERT INTO city VALUES ('3196', '610927', '610900', '镇坪县'); INSERT INTO city VALUES ('3197', '610928', '610900', '旬阳县'); INSERT INTO city VALUES ('3198', '610929', '610900', '白河县'); INSERT INTO city VALUES ('3199', '611000', '610000', '商洛市'); INSERT INTO city VALUES ('32', '120109', '120100', '大港区'); INSERT INTO city VALUES ('320', '140823', '140800', '闻喜县'); INSERT INTO city VALUES ('3200', '611001', '611000', '市辖区'); INSERT INTO city VALUES ('3201', '611002', '611000', '商州区'); INSERT INTO city VALUES ('3202', '611021', '611000', '洛南县'); INSERT INTO city VALUES ('3203', '611022', '611000', '丹凤县'); INSERT INTO city VALUES ('3204', '611023', '611000', '商南县'); INSERT INTO city VALUES ('3205', '611024', '611000', '山阳县'); INSERT INTO city VALUES ('3206', '611025', '611000', '镇安县'); INSERT INTO city VALUES ('3207', '611026', '611000', '柞水县'); INSERT INTO city VALUES ('3208', '620000', '-', '甘肃省'); INSERT INTO city VALUES ('3209', '620100', '620000', '兰州市'); INSERT INTO city VALUES ('321', '140824', '140800', '稷山县'); INSERT INTO city VALUES ('3210', '620101', '620100', '市辖区'); INSERT INTO city VALUES ('3211', '620102', '620100', '城关区'); INSERT INTO city VALUES ('3212', '620103', '620100', '七里河区'); INSERT INTO city VALUES ('3213', '620104', '620100', '西固区'); INSERT INTO city VALUES ('3214', '620105', '620100', '安宁区'); INSERT INTO city VALUES ('3215', '620111', '620100', '红古区'); INSERT INTO city VALUES ('3216', '620121', '620100', '永登县'); INSERT INTO city VALUES ('3217', '620122', '620100', '皋兰县'); INSERT INTO city VALUES ('3218', '620123', '620100', '榆中县'); INSERT INTO city VALUES ('3219', '620200', '620000', '嘉峪关市'); INSERT INTO city VALUES ('322', '140825', '140800', '新绛县'); INSERT INTO city VALUES ('3220', '620201', '620200', '市辖区'); INSERT INTO city VALUES ('3221', '620300', '620000', '金昌市'); INSERT INTO city VALUES ('3222', '620301', '620300', '市辖区'); INSERT INTO city VALUES ('3223', '620302', '620300', '金川区'); INSERT INTO city VALUES ('3224', '620321', '620300', '永昌县'); INSERT INTO city VALUES ('3225', '620400', '620000', '白银市'); INSERT INTO city VALUES ('3226', '620401', '620400', '市辖区'); INSERT INTO city VALUES ('3227', '620402', '620400', '白银区'); INSERT INTO city VALUES ('3228', '620403', '620400', '平川区'); INSERT INTO city VALUES ('3229', '620421', '620400', '靖远县'); INSERT INTO city VALUES ('323', '140826', '140800', '绛县'); INSERT INTO city VALUES ('3230', '620422', '620400', '会宁县'); INSERT INTO city VALUES ('3231', '620423', '620400', '景泰县'); INSERT INTO city VALUES ('3232', '620500', '620000', '天水市'); INSERT INTO city VALUES ('3233', '620501', '620500', '市辖区'); INSERT INTO city VALUES ('3234', '620502', '620500', '秦州区(**)'); INSERT INTO city VALUES ('3235', '620503', '620500', '麦积区(**)'); INSERT INTO city VALUES ('3236', '620521', '620500', '清水县'); INSERT INTO city VALUES ('3237', '620522', '620500', '秦安县'); INSERT INTO city VALUES ('3238', '620523', '620500', '甘谷县'); INSERT INTO city VALUES ('3239', '620524', '620500', '武山县'); INSERT INTO city VALUES ('324', '140827', '140800', '垣曲县'); INSERT INTO city VALUES ('3240', '620525', '620500', '张家川回族自治县'); INSERT INTO city VALUES ('3241', '620600', '620000', '武威市'); INSERT INTO city VALUES ('3242', '620601', '620600', '市辖区'); INSERT INTO city VALUES ('3243', '620602', '620600', '凉州区'); INSERT INTO city VALUES ('3244', '620621', '620600', '民勤县'); INSERT INTO city VALUES ('3245', '620622', '620600', '古浪县'); INSERT INTO city VALUES ('3246', '620623', '620600', '天祝藏族自治县'); INSERT INTO city VALUES ('3247', '620700', '620000', '张掖市'); INSERT INTO city VALUES ('3248', '620701', '620700', '市辖区'); INSERT INTO city VALUES ('3249', '620702', '620700', '甘州区'); INSERT INTO city VALUES ('325', '140828', '140800', '夏县'); INSERT INTO city VALUES ('3250', '620721', '620700', '肃南裕固族自治县'); INSERT INTO city VALUES ('3251', '620722', '620700', '民乐县'); INSERT INTO city VALUES ('3252', '620723', '620700', '临泽县'); INSERT INTO city VALUES ('3253', '620724', '620700', '高台县'); INSERT INTO city VALUES ('3254', '620725', '620700', '山丹县'); INSERT INTO city VALUES ('3255', '620800', '620000', '平凉市'); INSERT INTO city VALUES ('3256', '620801', '620800', '市辖区'); INSERT INTO city VALUES ('3257', '620802', '620800', '崆峒区'); INSERT INTO city VALUES ('3258', '620821', '620800', '泾川县'); INSERT INTO city VALUES ('3259', '620822', '620800', '灵台县'); INSERT INTO city VALUES ('326', '140829', '140800', '平陆县'); INSERT INTO city VALUES ('3260', '620823', '620800', '崇信县'); INSERT INTO city VALUES ('3261', '620824', '620800', '华亭县'); INSERT INTO city VALUES ('3262', '620825', '620800', '庄浪县'); INSERT INTO city VALUES ('3263', '620826', '620800', '静宁县'); INSERT INTO city VALUES ('3264', '620900', '620000', '酒泉市'); INSERT INTO city VALUES ('3265', '620901', '620900', '市辖区'); INSERT INTO city VALUES ('3266', '620902', '620900', '肃州区'); INSERT INTO city VALUES ('3267', '620921', '620900', '金塔县'); INSERT INTO city VALUES ('3268', '620922', '620900', '瓜州县'); INSERT INTO city VALUES ('3269', '620923', '620900', '肃北蒙古族自治县'); INSERT INTO city VALUES ('327', '140830', '140800', '芮城县'); INSERT INTO city VALUES ('3270', '620924', '620900', '阿克塞哈萨克族自治县'); INSERT INTO city VALUES ('3271', '620981', '620900', '玉门市'); INSERT INTO city VALUES ('3272', '620982', '620900', '敦煌市'); INSERT INTO city VALUES ('3273', '621000', '620000', '庆阳市'); INSERT INTO city VALUES ('3274', '621001', '621000', '市辖区'); INSERT INTO city VALUES ('3275', '621002', '621000', '西峰区'); INSERT INTO city VALUES ('3276', '621021', '621000', '庆城县'); INSERT INTO city VALUES ('3277', '621022', '621000', '环县'); INSERT INTO city VALUES ('3278', '621023', '621000', '华池县'); INSERT INTO city VALUES ('3279', '621024', '621000', '合水县'); INSERT INTO city VALUES ('328', '140881', '140800', '永济市'); INSERT INTO city VALUES ('3280', '621025', '621000', '正宁县'); INSERT INTO city VALUES ('3281', '621026', '621000', '宁县'); INSERT INTO city VALUES ('3282', '621027', '621000', '镇原县'); INSERT INTO city VALUES ('3283', '621100', '620000', '定西市'); INSERT INTO city VALUES ('3284', '621101', '621100', '市辖区'); INSERT INTO city VALUES ('3285', '621102', '621100', '安定区'); INSERT INTO city VALUES ('3286', '621121', '621100', '通渭县'); INSERT INTO city VALUES ('3287', '621122', '621100', '陇西县'); INSERT INTO city VALUES ('3288', '621123', '621100', '渭源县'); INSERT INTO city VALUES ('3289', '621124', '621100', '临洮县'); INSERT INTO city VALUES ('329', '140882', '140800', '河津市'); INSERT INTO city VALUES ('3290', '621125', '621100', '漳县'); INSERT INTO city VALUES ('3291', '621126', '621100', '岷县'); INSERT INTO city VALUES ('3292', '621200', '620000', '陇南市'); INSERT INTO city VALUES ('3293', '621201', '621200', '市辖区'); INSERT INTO city VALUES ('3294', '621202', '621200', '武都区'); INSERT INTO city VALUES ('3295', '621221', '621200', '成县'); INSERT INTO city VALUES ('3296', '621222', '621200', '文县'); INSERT INTO city VALUES ('3297', '621223', '621200', '宕昌县'); INSERT INTO city VALUES ('3298', '621224', '621200', '康县'); INSERT INTO city VALUES ('3299', '621225', '621200', '西和县'); INSERT INTO city VALUES ('33', '120110', '120100', '东丽区'); INSERT INTO city VALUES ('330', '140900', '140000', '忻州市'); INSERT INTO city VALUES ('3300', '621226', '621200', '礼县'); INSERT INTO city VALUES ('3301', '621227', '621200', '徽县'); INSERT INTO city VALUES ('3302', '621228', '621200', '两当县'); INSERT INTO city VALUES ('3303', '622900', '620000', '临夏回族自治州'); INSERT INTO city VALUES ('3304', '622901', '622900', '临夏市'); INSERT INTO city VALUES ('3305', '622921', '622900', '临夏县'); INSERT INTO city VALUES ('3306', '622922', '622900', '康乐县'); INSERT INTO city VALUES ('3307', '622923', '622900', '永靖县'); INSERT INTO city VALUES ('3308', '622924', '622900', '广河县'); INSERT INTO city VALUES ('3309', '622925', '622900', '和政县'); INSERT INTO city VALUES ('331', '140901', '140900', '市辖区'); INSERT INTO city VALUES ('3310', '622926', '622900', '东乡族自治县'); INSERT INTO city VALUES ('3311', '622927', '622900', '积石山保安族东乡族撒拉族自治'); INSERT INTO city VALUES ('3312', '623000', '620000', '甘南藏族自治州'); INSERT INTO city VALUES ('3313', '623001', '623000', '合作市'); INSERT INTO city VALUES ('3314', '623021', '623000', '临潭县'); INSERT INTO city VALUES ('3315', '623022', '623000', '卓尼县'); INSERT INTO city VALUES ('3316', '623023', '623000', '舟曲县'); INSERT INTO city VALUES ('3317', '623024', '623000', '迭部县'); INSERT INTO city VALUES ('3318', '623025', '623000', '玛曲县'); INSERT INTO city VALUES ('3319', '623026', '623000', '碌曲县'); INSERT INTO city VALUES ('332', '140902', '140900', '忻府区'); INSERT INTO city VALUES ('3320', '623027', '623000', '夏河县'); INSERT INTO city VALUES ('3321', '630000', '-', '青海省'); INSERT INTO city VALUES ('3322', '630100', '630000', '西宁市'); INSERT INTO city VALUES ('3323', '630101', '630100', '市辖区'); INSERT INTO city VALUES ('3324', '630102', '630100', '城东区'); INSERT INTO city VALUES ('3325', '630103', '630100', '城中区'); INSERT INTO city VALUES ('3326', '630104', '630100', '城西区'); INSERT INTO city VALUES ('3327', '630105', '630100', '城北区'); INSERT INTO city VALUES ('3328', '630121', '630100', '大通回族土族自治县'); INSERT INTO city VALUES ('3329', '630122', '630100', '湟中县'); INSERT INTO city VALUES ('333', '140921', '140900', '定襄县'); INSERT INTO city VALUES ('3330', '630123', '630100', '湟源县'); INSERT INTO city VALUES ('3331', '632100', '630000', '海东地区'); INSERT INTO city VALUES ('3332', '632121', '632100', '平安县'); INSERT INTO city VALUES ('3333', '632122', '632100', '民和回族土族自治县'); INSERT INTO city VALUES ('3334', '632123', '632100', '乐都县'); INSERT INTO city VALUES ('3335', '632126', '632100', '互助土族自治县'); INSERT INTO city VALUES ('3336', '632127', '632100', '化隆回族自治县'); INSERT INTO city VALUES ('3337', '632128', '632100', '循化撒拉族自治县'); INSERT INTO city VALUES ('3338', '632200', '630000', '海北藏族自治州'); INSERT INTO city VALUES ('3339', '632221', '632200', '门源回族自治县'); INSERT INTO city VALUES ('334', '140922', '140900', '五台县'); INSERT INTO city VALUES ('3340', '632222', '632200', '祁连县'); INSERT INTO city VALUES ('3341', '632223', '632200', '海晏县'); INSERT INTO city VALUES ('3342', '632224', '632200', '刚察县'); INSERT INTO city VALUES ('3343', '632300', '630000', '黄南藏族自治州'); INSERT INTO city VALUES ('3344', '632321', '632300', '同仁县'); INSERT INTO city VALUES ('3345', '632322', '632300', '尖扎县'); INSERT INTO city VALUES ('3346', '632323', '632300', '泽库县'); INSERT INTO city VALUES ('3347', '632324', '632300', '河南蒙古族自治县'); INSERT INTO city VALUES ('3348', '632500', '630000', '海南藏族自治州'); INSERT INTO city VALUES ('3349', '632521', '632500', '共和县'); INSERT INTO city VALUES ('335', '140923', '140900', '代县'); INSERT INTO city VALUES ('3350', '632522', '632500', '同德县'); INSERT INTO city VALUES ('3351', '632523', '632500', '贵德县'); INSERT INTO city VALUES ('3352', '632524', '632500', '兴海县'); INSERT INTO city VALUES ('3353', '632525', '632500', '贵南县'); INSERT INTO city VALUES ('3354', '632600', '630000', '果洛藏族自治州'); INSERT INTO city VALUES ('3355', '632621', '632600', '玛沁县'); INSERT INTO city VALUES ('3356', '632622', '632600', '班玛县'); INSERT INTO city VALUES ('3357', '632623', '632600', '甘德县'); INSERT INTO city VALUES ('3358', '632624', '632600', '达日县'); INSERT INTO city VALUES ('3359', '632625', '632600', '久治县'); INSERT INTO city VALUES ('336', '140924', '140900', '繁峙县'); INSERT INTO city VALUES ('3360', '632626', '632600', '玛多县'); INSERT INTO city VALUES ('3361', '632700', '630000', '玉树藏族自治州'); INSERT INTO city VALUES ('3362', '632721', '632700', '玉树县'); INSERT INTO city VALUES ('3363', '632722', '632700', '杂多县'); INSERT INTO city VALUES ('3364', '632723', '632700', '称多县'); INSERT INTO city VALUES ('3365', '632724', '632700', '治多县'); INSERT INTO city VALUES ('3366', '632725', '632700', '囊谦县'); INSERT INTO city VALUES ('3367', '632726', '632700', '曲麻莱县'); INSERT INTO city VALUES ('3368', '632800', '630000', '海西蒙古族藏族自治州'); INSERT INTO city VALUES ('3369', '632801', '632800', '格尔木市'); INSERT INTO city VALUES ('337', '140925', '140900', '宁武县'); INSERT INTO city VALUES ('3370', '632802', '632800', '德令哈市'); INSERT INTO city VALUES ('3371', '632821', '632800', '乌兰县'); INSERT INTO city VALUES ('3372', '632822', '632800', '都兰县'); INSERT INTO city VALUES ('3373', '632823', '632800', '天峻县'); INSERT INTO city VALUES ('3374', '640000', '-', '宁夏回族自治区'); INSERT INTO city VALUES ('3375', '640100', '640000', '银川市'); INSERT INTO city VALUES ('3376', '640101', '640100', '市辖区'); INSERT INTO city VALUES ('3377', '640104', '640100', '兴庆区'); INSERT INTO city VALUES ('3378', '640105', '640100', '西夏区'); INSERT INTO city VALUES ('3379', '640106', '640100', '金凤区'); INSERT INTO city VALUES ('338', '140926', '140900', '静乐县'); INSERT INTO city VALUES ('3380', '640121', '640100', '永宁县'); INSERT INTO city VALUES ('3381', '640122', '640100', '贺兰县'); INSERT INTO city VALUES ('3382', '640181', '640100', '灵武市'); INSERT INTO city VALUES ('3383', '640200', '640000', '石嘴山市'); INSERT INTO city VALUES ('3384', '640201', '640200', '市辖区'); INSERT INTO city VALUES ('3385', '640202', '640200', '大武口区'); INSERT INTO city VALUES ('3386', '640205', '640200', '惠农区'); INSERT INTO city VALUES ('3387', '640221', '640200', '平罗县'); INSERT INTO city VALUES ('3388', '640300', '640000', '吴忠市'); INSERT INTO city VALUES ('3389', '640301', '640300', '市辖区'); INSERT INTO city VALUES ('339', '140927', '140900', '神池县'); INSERT INTO city VALUES ('3390', '640302', '640300', '利通区'); INSERT INTO city VALUES ('3391', '640323', '640300', '盐池县'); INSERT INTO city VALUES ('3392', '640324', '640300', '同心县'); INSERT INTO city VALUES ('3393', '640381', '640300', '青铜峡市'); INSERT INTO city VALUES ('3394', '640400', '640000', '固原市'); INSERT INTO city VALUES ('3395', '640401', '640400', '市辖区'); INSERT INTO city VALUES ('3396', '640402', '640400', '原州区'); INSERT INTO city VALUES ('3397', '640422', '640400', '西吉县'); INSERT INTO city VALUES ('3398', '640423', '640400', '隆德县'); INSERT INTO city VALUES ('3399', '640424', '640400', '泾源县'); INSERT INTO city VALUES ('34', '120111', '120100', '西青区'); INSERT INTO city VALUES ('340', '140928', '140900', '五寨县'); INSERT INTO city VALUES ('3400', '640425', '640400', '彭阳县'); INSERT INTO city VALUES ('3401', '640500', '640000', '中卫市'); INSERT INTO city VALUES ('3402', '640501', '640500', '市辖区'); INSERT INTO city VALUES ('3403', '640502', '640500', '沙坡头区'); INSERT INTO city VALUES ('3404', '640521', '640500', '中宁县'); INSERT INTO city VALUES ('3405', '640522', '640500', '海原县'); INSERT INTO city VALUES ('3406', '650000', '-', '新疆维吾尔自治区'); INSERT INTO city VALUES ('3407', '650100', '650000', '乌鲁木齐市'); INSERT INTO city VALUES ('3408', '650101', '650100', '市辖区'); INSERT INTO city VALUES ('3409', '650102', '650100', '天山区'); INSERT INTO city VALUES ('341', '140929', '140900', '岢岚县'); INSERT INTO city VALUES ('3410', '650103', '650100', '沙依巴克区'); INSERT INTO city VALUES ('3411', '650104', '650100', '新市区'); INSERT INTO city VALUES ('3412', '650105', '650100', '水磨沟区'); INSERT INTO city VALUES ('3413', '650106', '650100', '头屯河区'); INSERT INTO city VALUES ('3414', '650107', '650100', '达坂城区'); INSERT INTO city VALUES ('3415', '650109', '650100', '米东区(*)'); INSERT INTO city VALUES ('3416', '650121', '650100', '乌鲁木齐县'); INSERT INTO city VALUES ('3417', '650200', '650000', '克拉玛依市'); INSERT INTO city VALUES ('3418', '650201', '650200', '市辖区'); INSERT INTO city VALUES ('3419', '650202', '650200', '独山子区'); INSERT INTO city VALUES ('342', '140930', '140900', '河曲县'); INSERT INTO city VALUES ('3420', '650203', '650200', '克拉玛依区'); INSERT INTO city VALUES ('3421', '650204', '650200', '白碱滩区'); INSERT INTO city VALUES ('3422', '650205', '650200', '乌尔禾区'); INSERT INTO city VALUES ('3423', '652100', '650000', '吐鲁番地区'); INSERT INTO city VALUES ('3424', '652101', '652100', '吐鲁番市'); INSERT INTO city VALUES ('3425', '652122', '652100', '鄯善县'); INSERT INTO city VALUES ('3426', '652123', '652100', '托克逊县'); INSERT INTO city VALUES ('3427', '652200', '650000', '哈密地区'); INSERT INTO city VALUES ('3428', '652201', '652200', '哈密市'); INSERT INTO city VALUES ('3429', '652222', '652200', '巴里坤哈萨克自治县'); INSERT INTO city VALUES ('343', '140931', '140900', '保德县'); INSERT INTO city VALUES ('3430', '652223', '652200', '伊吾县'); INSERT INTO city VALUES ('3431', '652300', '650000', '昌吉回族自治州'); INSERT INTO city VALUES ('3432', '652301', '652300', '昌吉市'); INSERT INTO city VALUES ('344', '140932', '140900', '偏关县'); INSERT INTO city VALUES ('345', '140981', '140900', '原平市'); INSERT INTO city VALUES ('346', '141000', '140000', '临汾市'); INSERT INTO city VALUES ('347', '141001', '141000', '市辖区'); INSERT INTO city VALUES ('348', '141002', '141000', '尧都区'); INSERT INTO city VALUES ('349', '141021', '141000', '曲沃县'); INSERT INTO city VALUES ('35', '120112', '120100', '津南区'); INSERT INTO city VALUES ('350', '141022', '141000', '翼城县'); INSERT INTO city VALUES ('351', '141023', '141000', '襄汾县'); INSERT INTO city VALUES ('352', '141024', '141000', '洪洞县'); INSERT INTO city VALUES ('353', '141025', '141000', '古县'); INSERT INTO city VALUES ('354', '141026', '141000', '安泽县'); INSERT INTO city VALUES ('355', '141027', '141000', '浮山县'); INSERT INTO city VALUES ('356', '141028', '141000', '吉县'); INSERT INTO city VALUES ('357', '141029', '141000', '乡宁县'); INSERT INTO city VALUES ('358', '141030', '141000', '大宁县'); INSERT INTO city VALUES ('359', '141031', '141000', '隰县'); INSERT INTO city VALUES ('36', '120113', '120100', '北辰区'); INSERT INTO city VALUES ('360', '141032', '141000', '永和县'); INSERT INTO city VALUES ('361', '141033', '141000', '蒲县'); INSERT INTO city VALUES ('362', '141034', '141000', '汾西县'); INSERT INTO city VALUES ('363', '141081', '141000', '侯马市'); INSERT INTO city VALUES ('364', '141082', '141000', '霍州市'); INSERT INTO city VALUES ('365', '141100', '140000', '吕梁市'); INSERT INTO city VALUES ('366', '141101', '141100', '市辖区'); INSERT INTO city VALUES ('367', '141102', '141100', '离石区'); INSERT INTO city VALUES ('368', '141121', '141100', '文水县'); INSERT INTO city VALUES ('369', '141122', '141100', '交城县'); INSERT INTO city VALUES ('37', '120114', '120100', '武清区'); INSERT INTO city VALUES ('370', '141123', '141100', '兴县'); INSERT INTO city VALUES ('371', '141124', '141100', '临县'); INSERT INTO city VALUES ('372', '141125', '141100', '柳林县'); INSERT INTO city VALUES ('373', '141126', '141100', '石楼县'); INSERT INTO city VALUES ('374', '141127', '141100', '岚县'); INSERT INTO city VALUES ('375', '141128', '141100', '方山县'); INSERT INTO city VALUES ('376', '141129', '141100', '中阳县'); INSERT INTO city VALUES ('377', '141130', '141100', '交口县'); INSERT INTO city VALUES ('378', '141181', '141100', '孝义市'); INSERT INTO city VALUES ('379', '141182', '141100', '汾阳市'); INSERT INTO city VALUES ('38', '120115', '120100', '宝坻区'); INSERT INTO city VALUES ('380', '150000', '-', '内蒙古自治区'); INSERT INTO city VALUES ('381', '150100', '150000', '呼和浩特市'); INSERT INTO city VALUES ('382', '150101', '150100', '市辖区'); INSERT INTO city VALUES ('383', '150102', '150100', '新城区'); INSERT INTO city VALUES ('384', '150103', '150100', '回民区'); INSERT INTO city VALUES ('385', '150104', '150100', '玉泉区'); INSERT INTO city VALUES ('386', '150105', '150100', '赛罕区'); INSERT INTO city VALUES ('387', '150121', '150100', '土默特左旗'); INSERT INTO city VALUES ('388', '150122', '150100', '托克托县'); INSERT INTO city VALUES ('389', '150123', '150100', '和林格尔县'); INSERT INTO city VALUES ('39', '120200', '120000', '县'); INSERT INTO city VALUES ('390', '150124', '150100', '清水河县'); INSERT INTO city VALUES ('391', '150125', '150100', '武川县'); INSERT INTO city VALUES ('392', '150200', '150000', '包头市'); INSERT INTO city VALUES ('393', '150201', '150200', '市辖区'); INSERT INTO city VALUES ('394', '150202', '150200', '东河区'); INSERT INTO city VALUES ('395', '150203', '150200', '昆都仑区'); INSERT INTO city VALUES ('396', '150204', '150200', '青山区'); INSERT INTO city VALUES ('397', '150205', '150200', '石拐区'); INSERT INTO city VALUES ('398', '150206', '150200', '白云矿区'); INSERT INTO city VALUES ('399', '150207', '150200', '九原区'); INSERT INTO city VALUES ('4', '110102', '110100', '西城区'); INSERT INTO city VALUES ('40', '120221', '120200', '宁河县'); INSERT INTO city VALUES ('400', '150221', '150200', '土默特右旗'); INSERT INTO city VALUES ('401', '150222', '150200', '固阳县'); INSERT INTO city VALUES ('402', '150223', '150200', '达尔罕茂明安联合旗'); INSERT INTO city VALUES ('403', '150300', '150000', '乌海市'); INSERT INTO city VALUES ('404', '150301', '150300', '市辖区'); INSERT INTO city VALUES ('405', '150302', '150300', '海勃湾区'); INSERT INTO city VALUES ('406', '150303', '150300', '海南区'); INSERT INTO city VALUES ('407', '150304', '150300', '乌达区'); INSERT INTO city VALUES ('408', '150400', '150000', '赤峰市'); INSERT INTO city VALUES ('409', '150401', '150400', '市辖区'); INSERT INTO city VALUES ('41', '120223', '120200', '静海县'); INSERT INTO city VALUES ('410', '150402', '150400', '红山区'); INSERT INTO city VALUES ('411', '150403', '150400', '元宝山区'); INSERT INTO city VALUES ('412', '150404', '150400', '松山区'); INSERT INTO city VALUES ('413', '150421', '150400', '阿鲁科尔沁旗'); INSERT INTO city VALUES ('414', '150422', '150400', '巴林左旗'); INSERT INTO city VALUES ('415', '150423', '150400', '巴林右旗'); INSERT INTO city VALUES ('416', '150424', '150400', '林西县'); INSERT INTO city VALUES ('417', '150425', '150400', '克什克腾旗'); INSERT INTO city VALUES ('418', '150426', '150400', '翁牛特旗'); INSERT INTO city VALUES ('419', '150428', '150400', '喀喇沁旗'); INSERT INTO city VALUES ('42', '120225', '120200', '蓟县'); INSERT INTO city VALUES ('420', '150429', '150400', '宁城县'); INSERT INTO city VALUES ('421', '150430', '150400', '敖汉旗'); INSERT INTO city VALUES ('422', '150500', '150000', '通辽市'); INSERT INTO city VALUES ('423', '150501', '150500', '市辖区'); INSERT INTO city VALUES ('424', '150502', '150500', '科尔沁区'); INSERT INTO city VALUES ('425', '150521', '150500', '科尔沁左翼中旗'); INSERT INTO city VALUES ('426', '150522', '150500', '科尔沁左翼后旗'); INSERT INTO city VALUES ('427', '150523', '150500', '开鲁县'); INSERT INTO city VALUES ('428', '150524', '150500', '库伦旗'); INSERT INTO city VALUES ('429', '150525', '150500', '奈曼旗'); INSERT INTO city VALUES ('43', '130000', '-', '河北省'); INSERT INTO city VALUES ('430', '150526', '150500', '扎鲁特旗'); INSERT INTO city VALUES ('431', '150581', '150500', '霍林郭勒市'); INSERT INTO city VALUES ('432', '150600', '150000', '鄂尔多斯市'); INSERT INTO city VALUES ('433', '150601', '150600', '市辖区(**)'); INSERT INTO city VALUES ('434', '150602', '150600', '东胜区'); INSERT INTO city VALUES ('435', '150621', '150600', '达拉特旗'); INSERT INTO city VALUES ('436', '150622', '150600', '准格尔旗'); INSERT INTO city VALUES ('437', '150623', '150600', '鄂托克前旗'); INSERT INTO city VALUES ('438', '150624', '150600', '鄂托克旗'); INSERT INTO city VALUES ('439', '150625', '150600', '杭锦旗'); INSERT INTO city VALUES ('44', '130100', '130000', '石家庄市'); INSERT INTO city VALUES ('440', '150626', '150600', '乌审旗'); INSERT INTO city VALUES ('441', '150627', '150600', '伊金霍洛旗'); INSERT INTO city VALUES ('442', '150700', '150000', '呼伦贝尔市'); INSERT INTO city VALUES ('443', '150701', '150700', '市辖区'); INSERT INTO city VALUES ('444', '150702', '150700', '海拉尔区'); INSERT INTO city VALUES ('445', '150721', '150700', '阿荣旗'); INSERT INTO city VALUES ('446', '150722', '150700', '莫力达瓦达斡尔族自治旗'); INSERT INTO city VALUES ('447', '150723', '150700', '鄂伦春自治旗'); INSERT INTO city VALUES ('448', '150724', '150700', '鄂温克族自治旗'); INSERT INTO city VALUES ('449', '150725', '150700', '陈巴尔虎旗'); INSERT INTO city VALUES ('45', '130101', '130100', '市辖区'); INSERT INTO city VALUES ('450', '150726', '150700', '新巴尔虎左旗'); INSERT INTO city VALUES ('451', '150727', '150700', '新巴尔虎右旗'); INSERT INTO city VALUES ('452', '150781', '150700', '满洲里市'); INSERT INTO city VALUES ('453', '150782', '150700', '牙克石市'); INSERT INTO city VALUES ('454', '150783', '150700', '扎兰屯市'); INSERT INTO city VALUES ('455', '150784', '150700', '额尔古纳市'); INSERT INTO city VALUES ('456', '150785', '150700', '根河市'); INSERT INTO city VALUES ('457', '150800', '150000', '巴彦淖尔市'); INSERT INTO city VALUES ('458', '150801', '150800', '市辖区'); INSERT INTO city VALUES ('459', '150802', '150800', '临河区'); INSERT INTO city VALUES ('46', '130102', '130100', '长安区'); INSERT INTO city VALUES ('460', '150821', '150800', '五原县'); INSERT INTO city VALUES ('461', '150822', '150800', '磴口县'); INSERT INTO city VALUES ('462', '150823', '150800', '乌拉特前旗'); INSERT INTO city VALUES ('463', '150824', '150800', '乌拉特中旗'); INSERT INTO city VALUES ('464', '150825', '150800', '乌拉特后旗'); INSERT INTO city VALUES ('465', '150826', '150800', '杭锦后旗'); INSERT INTO city VALUES ('466', '150900', '150000', '乌兰察布市'); INSERT INTO city VALUES ('467', '150901', '150900', '市辖区'); INSERT INTO city VALUES ('468', '150902', '150900', '集宁区'); INSERT INTO city VALUES ('469', '150921', '150900', '卓资县'); INSERT INTO city VALUES ('47', '130103', '130100', '桥东区'); INSERT INTO city VALUES ('470', '150922', '150900', '化德县'); INSERT INTO city VALUES ('471', '150923', '150900', '商都县'); INSERT INTO city VALUES ('472', '150924', '150900', '兴和县'); INSERT INTO city VALUES ('473', '150925', '150900', '凉城县'); INSERT INTO city VALUES ('474', '150926', '150900', '察哈尔右翼前旗'); INSERT INTO city VALUES ('475', '150927', '150900', '察哈尔右翼中旗'); INSERT INTO city VALUES ('476', '150928', '150900', '察哈尔右翼后旗'); INSERT INTO city VALUES ('477', '150929', '150900', '四子王旗'); INSERT INTO city VALUES ('478', '150981', '150900', '丰镇市'); INSERT INTO city VALUES ('479', '152200', '150000', '兴安盟'); INSERT INTO city VALUES ('48', '130104', '130100', '桥西区'); INSERT INTO city VALUES ('480', '152201', '152200', '乌兰浩特市'); INSERT INTO city VALUES ('481', '152202', '152200', '阿尔山市'); INSERT INTO city VALUES ('482', '152221', '152200', '科尔沁右翼前旗'); INSERT INTO city VALUES ('483', '152222', '152200', '科尔沁右翼中旗'); INSERT INTO city VALUES ('484', '152223', '152200', '扎赉特旗'); INSERT INTO city VALUES ('485', '152224', '152200', '突泉县'); INSERT INTO city VALUES ('486', '152500', '150000', '锡林郭勒盟'); INSERT INTO city VALUES ('487', '152501', '152500', '二连浩特市'); INSERT INTO city VALUES ('488', '152502', '152500', '锡林浩特市'); INSERT INTO city VALUES ('489', '152522', '152500', '阿巴嘎旗'); INSERT INTO city VALUES ('49', '130105', '130100', '新华区'); INSERT INTO city VALUES ('490', '152523', '152500', '苏尼特左旗'); INSERT INTO city VALUES ('491', '152524', '152500', '苏尼特右旗'); INSERT INTO city VALUES ('492', '152525', '152500', '东乌珠穆沁旗'); INSERT INTO city VALUES ('493', '152526', '152500', '西乌珠穆沁旗'); INSERT INTO city VALUES ('494', '152527', '152500', '太仆寺旗'); INSERT INTO city VALUES ('495', '152528', '152500', '镶黄旗'); INSERT INTO city VALUES ('496', '152529', '152500', '正镶白旗'); INSERT INTO city VALUES ('497', '152530', '152500', '正蓝旗'); INSERT INTO city VALUES ('498', '152531', '152500', '多伦县'); INSERT INTO city VALUES ('499', '152900', '150000', '阿拉善盟'); INSERT INTO city VALUES ('5', '110103', '110100', '崇文区'); INSERT INTO city VALUES ('50', '130107', '130100', '井陉矿区'); INSERT INTO city VALUES ('500', '152921', '152900', '阿拉善左旗'); INSERT INTO city VALUES ('501', '152922', '152900', '阿拉善右旗'); INSERT INTO city VALUES ('502', '152923', '152900', '额济纳旗'); INSERT INTO city VALUES ('503', '210000', '-', '辽宁省'); INSERT INTO city VALUES ('504', '210100', '210000', '沈阳市'); INSERT INTO city VALUES ('505', '210101', '210100', '市辖区'); INSERT INTO city VALUES ('506', '210102', '210100', '和平区'); INSERT INTO city VALUES ('507', '210103', '210100', '沈河区'); INSERT INTO city VALUES ('508', '210104', '210100', '大东区'); INSERT INTO city VALUES ('509', '210105', '210100', '皇姑区'); INSERT INTO city VALUES ('51', '130108', '130100', '裕华区'); INSERT INTO city VALUES ('510', '210106', '210100', '铁西区'); INSERT INTO city VALUES ('511', '210111', '210100', '苏家屯区'); INSERT INTO city VALUES ('512', '210112', '210100', '东陵区'); INSERT INTO city VALUES ('513', '210113', '210100', '沈北新区'); INSERT INTO city VALUES ('514', '210114', '210100', '于洪区'); INSERT INTO city VALUES ('515', '210122', '210100', '辽中县'); INSERT INTO city VALUES ('516', '210123', '210100', '康平县'); INSERT INTO city VALUES ('517', '210124', '210100', '法库县'); INSERT INTO city VALUES ('518', '210181', '210100', '新民市'); INSERT INTO city VALUES ('519', '210200', '210000', '大连市'); INSERT INTO city VALUES ('52', '130121', '130100', '井陉县'); INSERT INTO city VALUES ('520', '210201', '210200', '市辖区'); INSERT INTO city VALUES ('521', '210202', '210200', '中山区'); INSERT INTO city VALUES ('522', '210203', '210200', '西岗区'); INSERT INTO city VALUES ('523', '210204', '210200', '沙河口区'); INSERT INTO city VALUES ('524', '210211', '210200', '甘井子区'); INSERT INTO city VALUES ('525', '210212', '210200', '旅顺口区'); INSERT INTO city VALUES ('526', '210213', '210200', '金州区'); INSERT INTO city VALUES ('527', '210224', '210200', '长海县'); INSERT INTO city VALUES ('528', '210281', '210200', '瓦房店市'); INSERT INTO city VALUES ('529', '210282', '210200', '普兰店市'); INSERT INTO city VALUES ('53', '130123', '130100', '正定县'); INSERT INTO city VALUES ('530', '210283', '210200', '庄河市'); INSERT INTO city VALUES ('531', '210300', '210000', '鞍山市'); INSERT INTO city VALUES ('532', '210301', '210300', '市辖区'); INSERT INTO city VALUES ('533', '210302', '210300', '铁东区'); INSERT INTO city VALUES ('534', '210303', '210300', '铁西区'); INSERT INTO city VALUES ('535', '210304', '210300', '立山区'); INSERT INTO city VALUES ('536', '210311', '210300', '千山区'); INSERT INTO city VALUES ('537', '210321', '210300', '台安县'); INSERT INTO city VALUES ('538', '210323', '210300', '岫岩满族自治县'); INSERT INTO city VALUES ('539', '210381', '210300', '海城市'); INSERT INTO city VALUES ('54', '130124', '130100', '栾城县'); INSERT INTO city VALUES ('540', '210400', '210000', '抚顺市'); INSERT INTO city VALUES ('541', '210401', '210400', '市辖区'); INSERT INTO city VALUES ('542', '210402', '210400', '新抚区'); INSERT INTO city VALUES ('543', '210403', '210400', '东洲区'); INSERT INTO city VALUES ('544', '210404', '210400', '望花区'); INSERT INTO city VALUES ('545', '210411', '210400', '顺城区'); INSERT INTO city VALUES ('546', '210421', '210400', '抚顺县'); INSERT INTO city VALUES ('547', '210422', '210400', '新宾满族自治县'); INSERT INTO city VALUES ('548', '210423', '210400', '清原满族自治县'); INSERT INTO city VALUES ('549', '210500', '210000', '本溪市'); INSERT INTO city VALUES ('55', '130125', '130100', '行唐县'); INSERT INTO city VALUES ('550', '210501', '210500', '市辖区'); INSERT INTO city VALUES ('551', '210502', '210500', '平山区'); INSERT INTO city VALUES ('552', '210503', '210500', '溪湖区'); INSERT INTO city VALUES ('553', '210504', '210500', '明山区'); INSERT INTO city VALUES ('554', '210505', '210500', '南芬区'); INSERT INTO city VALUES ('555', '210521', '210500', '本溪满族自治县'); INSERT INTO city VALUES ('556', '210522', '210500', '桓仁满族自治县'); INSERT INTO city VALUES ('557', '210600', '210000', '丹东市'); INSERT INTO city VALUES ('558', '210601', '210600', '市辖区'); INSERT INTO city VALUES ('559', '210602', '210600', '元宝区'); INSERT INTO city VALUES ('56', '130126', '130100', '灵寿县'); INSERT INTO city VALUES ('560', '210603', '210600', '振兴区'); INSERT INTO city VALUES ('561', '210604', '210600', '振安区'); INSERT INTO city VALUES ('562', '210624', '210600', '宽甸满族自治县'); INSERT INTO city VALUES ('563', '210681', '210600', '东港市'); INSERT INTO city VALUES ('564', '210682', '210600', '凤城市'); INSERT INTO city VALUES ('565', '210700', '210000', '锦州市'); INSERT INTO city VALUES ('566', '210701', '210700', '市辖区'); INSERT INTO city VALUES ('567', '210702', '210700', '古塔区'); INSERT INTO city VALUES ('568', '210703', '210700', '凌河区'); INSERT INTO city VALUES ('569', '210711', '210700', '太和区'); INSERT INTO city VALUES ('57', '130127', '130100', '高邑县'); INSERT INTO city VALUES ('570', '210726', '210700', '黑山县'); INSERT INTO city VALUES ('571', '210727', '210700', '义县'); INSERT INTO city VALUES ('572', '210781', '210700', '凌海市'); INSERT INTO city VALUES ('573', '210782', '210700', '北镇市'); INSERT INTO city VALUES ('574', '210800', '210000', '营口市'); INSERT INTO city VALUES ('575', '210801', '210800', '市辖区'); INSERT INTO city VALUES ('576', '210802', '210800', '站前区'); INSERT INTO city VALUES ('577', '210803', '210800', '西市区'); INSERT INTO city VALUES ('578', '210804', '210800', '鲅鱼圈区'); INSERT INTO city VALUES ('579', '210811', '210800', '老边区'); INSERT INTO city VALUES ('58', '130128', '130100', '深泽县'); INSERT INTO city VALUES ('580', '210881', '210800', '盖州市'); INSERT INTO city VALUES ('581', '210882', '210800', '大石桥市'); INSERT INTO city VALUES ('582', '210900', '210000', '阜新市'); INSERT INTO city VALUES ('583', '210901', '210900', '市辖区'); INSERT INTO city VALUES ('584', '210902', '210900', '海州区'); INSERT INTO city VALUES ('585', '210903', '210900', '新邱区'); INSERT INTO city VALUES ('586', '210904', '210900', '太平区'); INSERT INTO city VALUES ('587', '210905', '210900', '清河门区'); INSERT INTO city VALUES ('588', '210911', '210900', '细河区'); INSERT INTO city VALUES ('589', '210921', '210900', '阜新蒙古族自治县'); INSERT INTO city VALUES ('59', '130129', '130100', '赞皇县'); INSERT INTO city VALUES ('590', '210922', '210900', '彰武县'); INSERT INTO city VALUES ('591', '211000', '210000', '辽阳市'); INSERT INTO city VALUES ('592', '211001', '211000', '市辖区'); INSERT INTO city VALUES ('593', '211002', '211000', '白塔区'); INSERT INTO city VALUES ('594', '211003', '211000', '文圣区'); INSERT INTO city VALUES ('595', '211004', '211000', '宏伟区'); INSERT INTO city VALUES ('596', '211005', '211000', '弓长岭区'); INSERT INTO city VALUES ('597', '211011', '211000', '太子河区'); INSERT INTO city VALUES ('598', '211021', '211000', '辽阳县'); INSERT INTO city VALUES ('599', '211081', '211000', '灯塔市'); INSERT INTO city VALUES ('6', '110104', '110100', '宣武区'); INSERT INTO city VALUES ('60', '130130', '130100', '无极县'); INSERT INTO city VALUES ('600', '211100', '210000', '盘锦市'); INSERT INTO city VALUES ('601', '211101', '211100', '市辖区'); INSERT INTO city VALUES ('602', '211102', '211100', '双台子区'); INSERT INTO city VALUES ('603', '211103', '211100', '兴隆台区'); INSERT INTO city VALUES ('604', '211121', '211100', '大洼县'); INSERT INTO city VALUES ('605', '211122', '211100', '盘山县'); INSERT INTO city VALUES ('606', '211200', '210000', '铁岭市'); INSERT INTO city VALUES ('607', '211201', '211200', '市辖区'); INSERT INTO city VALUES ('608', '211202', '211200', '银州区'); INSERT INTO city VALUES ('609', '211204', '211200', '清河区'); INSERT INTO city VALUES ('61', '130131', '130100', '平山县'); INSERT INTO city VALUES ('610', '211221', '211200', '铁岭县'); INSERT INTO city VALUES ('611', '211223', '211200', '西丰县'); INSERT INTO city VALUES ('612', '211224', '211200', '昌图县'); INSERT INTO city VALUES ('613', '211281', '211200', '调兵山市'); INSERT INTO city VALUES ('614', '211282', '211200', '开原市'); INSERT INTO city VALUES ('615', '211300', '210000', '朝阳市'); INSERT INTO city VALUES ('616', '211301', '211300', '市辖区'); INSERT INTO city VALUES ('617', '211302', '211300', '双塔区'); INSERT INTO city VALUES ('618', '211303', '211300', '龙城区'); INSERT INTO city VALUES ('619', '211321', '211300', '朝阳县'); INSERT INTO city VALUES ('62', '130132', '130100', '元氏县'); INSERT INTO city VALUES ('620', '211322', '211300', '建平县'); INSERT INTO city VALUES ('621', '211324', '211300', '喀喇沁左翼蒙古族自治县'); INSERT INTO city VALUES ('622', '211381', '211300', '北票市'); INSERT INTO city VALUES ('623', '211382', '211300', '凌源市'); INSERT INTO city VALUES ('624', '211400', '210000', '葫芦岛市'); INSERT INTO city VALUES ('625', '211401', '211400', '市辖区'); INSERT INTO city VALUES ('626', '211402', '211400', '连山区'); INSERT INTO city VALUES ('627', '211403', '211400', '龙港区'); INSERT INTO city VALUES ('628', '211404', '211400', '南票区'); INSERT INTO city VALUES ('629', '211421', '211400', '绥中县'); INSERT INTO city VALUES ('63', '130133', '130100', '赵县'); INSERT INTO city VALUES ('630', '211422', '211400', '建昌县'); INSERT INTO city VALUES ('631', '211481', '211400', '兴城市'); INSERT INTO city VALUES ('632', '220000', '-', '吉林省'); INSERT INTO city VALUES ('633', '220100', '220000', '长春市'); INSERT INTO city VALUES ('634', '220101', '220100', '市辖区'); INSERT INTO city VALUES ('635', '220102', '220100', '南关区'); INSERT INTO city VALUES ('636', '220103', '220100', '宽城区'); INSERT INTO city VALUES ('637', '220104', '220100', '朝阳区'); INSERT INTO city VALUES ('638', '220105', '220100', '二道区'); INSERT INTO city VALUES ('639', '220106', '220100', '绿园区'); INSERT INTO city VALUES ('64', '130181', '130100', '辛集市'); INSERT INTO city VALUES ('640', '220112', '220100', '双阳区'); INSERT INTO city VALUES ('641', '220122', '220100', '农安县'); INSERT INTO city VALUES ('642', '220181', '220100', '九台市'); INSERT INTO city VALUES ('643', '220182', '220100', '榆树市'); INSERT INTO city VALUES ('644', '220183', '220100', '德惠市'); INSERT INTO city VALUES ('645', '220200', '220000', '吉林市'); INSERT INTO city VALUES ('646', '220201', '220200', '市辖区'); INSERT INTO city VALUES ('647', '220202', '220200', '昌邑区'); INSERT INTO city VALUES ('648', '220203', '220200', '龙潭区'); INSERT INTO city VALUES ('649', '220204', '220200', '船营区'); INSERT INTO city VALUES ('65', '130182', '130100', '藁城市'); INSERT INTO city VALUES ('650', '220211', '220200', '丰满区'); INSERT INTO city VALUES ('651', '220221', '220200', '永吉县'); INSERT INTO city VALUES ('652', '220281', '220200', '蛟河市'); INSERT INTO city VALUES ('653', '220282', '220200', '桦甸市'); INSERT INTO city VALUES ('654', '220283', '220200', '舒兰市'); INSERT INTO city VALUES ('655', '220284', '220200', '磐石市'); INSERT INTO city VALUES ('656', '220300', '220000', '四平市'); INSERT INTO city VALUES ('657', '220301', '220300', '市辖区'); INSERT INTO city VALUES ('658', '220302', '220300', '铁西区'); INSERT INTO city VALUES ('659', '220303', '220300', '铁东区'); INSERT INTO city VALUES ('66', '130183', '130100', '晋州市'); INSERT INTO city VALUES ('660', '220322', '220300', '梨树县'); INSERT INTO city VALUES ('661', '220323', '220300', '伊通满族自治县'); INSERT INTO city VALUES ('662', '220381', '220300', '公主岭市'); INSERT INTO city VALUES ('663', '220382', '220300', '双辽市'); INSERT INTO city VALUES ('664', '220400', '220000', '辽源市'); INSERT INTO city VALUES ('665', '220401', '220400', '市辖区'); INSERT INTO city VALUES ('666', '220402', '220400', '龙山区'); INSERT INTO city VALUES ('667', '220403', '220400', '西安区'); INSERT INTO city VALUES ('668', '220421', '220400', '东丰县'); INSERT INTO city VALUES ('669', '220422', '220400', '东辽县'); INSERT INTO city VALUES ('67', '130184', '130100', '新乐市'); INSERT INTO city VALUES ('670', '220500', '220000', '通化市'); INSERT INTO city VALUES ('671', '220501', '220500', '市辖区'); INSERT INTO city VALUES ('672', '220502', '220500', '东昌区'); INSERT INTO city VALUES ('673', '220503', '220500', '二道江区'); INSERT INTO city VALUES ('674', '220521', '220500', '通化县'); INSERT INTO city VALUES ('675', '220523', '220500', '辉南县'); INSERT INTO city VALUES ('676', '220524', '220500', '柳河县'); INSERT INTO city VALUES ('677', '220581', '220500', '梅河口市'); INSERT INTO city VALUES ('678', '220582', '220500', '集安市'); INSERT INTO city VALUES ('679', '220600', '220000', '白山市'); INSERT INTO city VALUES ('68', '130185', '130100', '鹿泉市'); INSERT INTO city VALUES ('680', '220601', '220600', '市辖区'); INSERT INTO city VALUES ('681', '220602', '220600', '八道江区'); INSERT INTO city VALUES ('682', '220605', '220600', '江源区(**)'); INSERT INTO city VALUES ('683', '220621', '220600', '抚松县'); INSERT INTO city VALUES ('684', '220622', '220600', '靖宇县'); INSERT INTO city VALUES ('685', '220623', '220600', '长白朝鲜族自治县'); INSERT INTO city VALUES ('686', '220681', '220600', '临江市'); INSERT INTO city VALUES ('687', '220700', '220000', '松原市'); INSERT INTO city VALUES ('688', '220701', '220700', '市辖区'); INSERT INTO city VALUES ('689', '220702', '220700', '宁江区'); INSERT INTO city VALUES ('69', '130200', '130000', '唐山市'); INSERT INTO city VALUES ('690', '220721', '220700', '前郭尔罗斯蒙古族自治县'); INSERT INTO city VALUES ('691', '220722', '220700', '长岭县'); INSERT INTO city VALUES ('692', '220723', '220700', '乾安县'); INSERT INTO city VALUES ('693', '220724', '220700', '扶余县'); INSERT INTO city VALUES ('694', '220800', '220000', '白城市'); INSERT INTO city VALUES ('695', '220801', '220800', '市辖区'); INSERT INTO city VALUES ('696', '220802', '220800', '洮北区'); INSERT INTO city VALUES ('697', '220821', '220800', '镇赉县'); INSERT INTO city VALUES ('698', '220822', '220800', '通榆县'); INSERT INTO city VALUES ('699', '220881', '220800', '洮南市'); INSERT INTO city VALUES ('7', '110105', '110100', '朝阳区'); INSERT INTO city VALUES ('70', '130201', '130200', '市辖区'); INSERT INTO city VALUES ('700', '220882', '220800', '大安市'); INSERT INTO city VALUES ('701', '222400', '220000', '延边朝鲜族自治州'); INSERT INTO city VALUES ('702', '222401', '222400', '延吉市'); INSERT INTO city VALUES ('703', '222402', '222400', '图们市'); INSERT INTO city VALUES ('704', '222403', '222400', '敦化市'); INSERT INTO city VALUES ('705', '222404', '222400', '珲春市'); INSERT INTO city VALUES ('706', '222405', '222400', '龙井市'); INSERT INTO city VALUES ('707', '222406', '222400', '和龙市'); INSERT INTO city VALUES ('708', '222424', '222400', '汪清县'); INSERT INTO city VALUES ('709', '222426', '222400', '安图县'); INSERT INTO city VALUES ('71', '130202', '130200', '路南区'); INSERT INTO city VALUES ('710', '230000', '-', '黑龙江省'); INSERT INTO city VALUES ('711', '230100', '230000', '哈尔滨市'); INSERT INTO city VALUES ('712', '230101', '230100', '市辖区'); INSERT INTO city VALUES ('713', '230102', '230100', '道里区'); INSERT INTO city VALUES ('714', '230103', '230100', '南岗区'); INSERT INTO city VALUES ('715', '230104', '230100', '道外区'); INSERT INTO city VALUES ('716', '230108', '230100', '平房区'); INSERT INTO city VALUES ('717', '230109', '230100', '松北区'); INSERT INTO city VALUES ('718', '230110', '230100', '香坊区'); INSERT INTO city VALUES ('719', '230111', '230100', '呼兰区'); INSERT INTO city VALUES ('72', '130203', '130200', '路北区'); INSERT INTO city VALUES ('720', '230112', '230100', '阿城区'); INSERT INTO city VALUES ('721', '230123', '230100', '依兰县'); INSERT INTO city VALUES ('722', '230124', '230100', '方正县'); INSERT INTO city VALUES ('723', '230125', '230100', '宾县'); INSERT INTO city VALUES ('724', '230126', '230100', '巴彦县'); INSERT INTO city VALUES ('725', '230127', '230100', '木兰县'); INSERT INTO city VALUES ('726', '230128', '230100', '通河县'); INSERT INTO city VALUES ('727', '230129', '230100', '延寿县'); INSERT INTO city VALUES ('728', '230182', '230100', '双城市'); INSERT INTO city VALUES ('729', '230183', '230100', '尚志市'); INSERT INTO city VALUES ('73', '130204', '130200', '古冶区'); INSERT INTO city VALUES ('730', '230184', '230100', '五常市'); INSERT INTO city VALUES ('731', '230200', '230000', '齐齐哈尔市'); INSERT INTO city VALUES ('732', '230201', '230200', '市辖区'); INSERT INTO city VALUES ('733', '230202', '230200', '龙沙区'); INSERT INTO city VALUES ('734', '230203', '230200', '建华区'); INSERT INTO city VALUES ('735', '230204', '230200', '铁锋区'); INSERT INTO city VALUES ('736', '230205', '230200', '昂昂溪区'); INSERT INTO city VALUES ('737', '230206', '230200', '富拉尔基区'); INSERT INTO city VALUES ('738', '230207', '230200', '碾子山区'); INSERT INTO city VALUES ('739', '230208', '230200', '梅里斯达斡尔族区'); INSERT INTO city VALUES ('74', '130205', '130200', '开平区'); INSERT INTO city VALUES ('740', '230221', '230200', '龙江县'); INSERT INTO city VALUES ('741', '230223', '230200', '依安县'); INSERT INTO city VALUES ('742', '230224', '230200', '泰来县'); INSERT INTO city VALUES ('743', '230225', '230200', '甘南县'); INSERT INTO city VALUES ('744', '230227', '230200', '富裕县'); INSERT INTO city VALUES ('745', '230229', '230200', '克山县'); INSERT INTO city VALUES ('746', '230230', '230200', '克东县'); INSERT INTO city VALUES ('747', '230231', '230200', '拜泉县'); INSERT INTO city VALUES ('748', '230281', '230200', '讷河市'); INSERT INTO city VALUES ('749', '230300', '230000', '鸡西市'); INSERT INTO city VALUES ('75', '130207', '130200', '丰南区'); INSERT INTO city VALUES ('750', '230301', '230300', '市辖区'); INSERT INTO city VALUES ('751', '230302', '230300', '鸡冠区'); INSERT INTO city VALUES ('752', '230303', '230300', '恒山区'); INSERT INTO city VALUES ('753', '230304', '230300', '滴道区'); INSERT INTO city VALUES ('754', '230305', '230300', '梨树区'); INSERT INTO city VALUES ('755', '230306', '230300', '城子河区'); INSERT INTO city VALUES ('756', '230307', '230300', '麻山区'); INSERT INTO city VALUES ('757', '230321', '230300', '鸡东县'); INSERT INTO city VALUES ('758', '230381', '230300', '虎林市'); INSERT INTO city VALUES ('759', '230382', '230300', '密山市'); INSERT INTO city VALUES ('76', '130208', '130200', '丰润区'); INSERT INTO city VALUES ('760', '230400', '230000', '鹤岗市'); INSERT INTO city VALUES ('761', '230401', '230400', '市辖区'); INSERT INTO city VALUES ('762', '230402', '230400', '向阳区'); INSERT INTO city VALUES ('763', '230403', '230400', '工农区'); INSERT INTO city VALUES ('764', '230404', '230400', '南山区'); INSERT INTO city VALUES ('765', '230405', '230400', '兴安区'); INSERT INTO city VALUES ('766', '230406', '230400', '东山区'); INSERT INTO city VALUES ('767', '230407', '230400', '兴山区'); INSERT INTO city VALUES ('768', '230421', '230400', '萝北县'); INSERT INTO city VALUES ('769', '230422', '230400', '绥滨县'); INSERT INTO city VALUES ('77', '130223', '130200', '滦县'); INSERT INTO city VALUES ('770', '230500', '230000', '双鸭山市'); INSERT INTO city VALUES ('771', '230501', '230500', '市辖区'); INSERT INTO city VALUES ('772', '230502', '230500', '尖山区'); INSERT INTO city VALUES ('773', '230503', '230500', '岭东区'); INSERT INTO city VALUES ('774', '230505', '230500', '四方台区'); INSERT INTO city VALUES ('775', '230506', '230500', '宝山区'); INSERT INTO city VALUES ('776', '230521', '230500', '集贤县'); INSERT INTO city VALUES ('777', '230522', '230500', '友谊县'); INSERT INTO city VALUES ('778', '230523', '230500', '宝清县'); INSERT INTO city VALUES ('779', '230524', '230500', '饶河县'); INSERT INTO city VALUES ('78', '130224', '130200', '滦南县'); INSERT INTO city VALUES ('780', '230600', '230000', '大庆市'); INSERT INTO city VALUES ('781', '230601', '230600', '市辖区'); INSERT INTO city VALUES ('782', '230602', '230600', '萨尔图区'); INSERT INTO city VALUES ('783', '230603', '230600', '龙凤区'); INSERT INTO city VALUES ('784', '230604', '230600', '让胡路区'); INSERT INTO city VALUES ('785', '230605', '230600', '红岗区'); INSERT INTO city VALUES ('786', '230606', '230600', '大同区'); INSERT INTO city VALUES ('787', '230621', '230600', '肇州县'); INSERT INTO city VALUES ('788', '230622', '230600', '肇源县'); INSERT INTO city VALUES ('789', '230623', '230600', '林甸县'); INSERT INTO city VALUES ('79', '130225', '130200', '乐亭县'); INSERT INTO city VALUES ('790', '230624', '230600', '杜尔伯特蒙古族自治县'); INSERT INTO city VALUES ('791', '230700', '230000', '伊春市'); INSERT INTO city VALUES ('792', '230701', '230700', '市辖区'); INSERT INTO city VALUES ('793', '230702', '230700', '伊春区'); INSERT INTO city VALUES ('794', '230703', '230700', '南岔区'); INSERT INTO city VALUES ('795', '230704', '230700', '友好区'); INSERT INTO city VALUES ('796', '230705', '230700', '西林区'); INSERT INTO city VALUES ('797', '230706', '230700', '翠峦区'); INSERT INTO city VALUES ('798', '230707', '230700', '新青区'); INSERT INTO city VALUES ('799', '230708', '230700', '美溪区'); INSERT INTO city VALUES ('8', '110106', '110100', '丰台区'); INSERT INTO city VALUES ('80', '130227', '130200', '迁西县'); INSERT INTO city VALUES ('800', '230709', '230700', '金山屯区'); INSERT INTO city VALUES ('801', '230710', '230700', '五营区'); INSERT INTO city VALUES ('802', '230711', '230700', '乌马河区'); INSERT INTO city VALUES ('803', '230712', '230700', '汤旺河区'); INSERT INTO city VALUES ('804', '230713', '230700', '带岭区'); INSERT INTO city VALUES ('805', '230714', '230700', '乌伊岭区'); INSERT INTO city VALUES ('806', '230715', '230700', '红星区'); INSERT INTO city VALUES ('807', '230716', '230700', '上甘岭区'); INSERT INTO city VALUES ('808', '230722', '230700', '嘉荫县'); INSERT INTO city VALUES ('809', '230781', '230700', '铁力市'); INSERT INTO city VALUES ('81', '130229', '130200', '玉田县'); INSERT INTO city VALUES ('810', '230800', '230000', '佳木斯市'); INSERT INTO city VALUES ('811', '230801', '230800', '市辖区'); INSERT INTO city VALUES ('812', '230803', '230800', '向阳区'); INSERT INTO city VALUES ('813', '230804', '230800', '前进区'); INSERT INTO city VALUES ('814', '230805', '230800', '东风区'); INSERT INTO city VALUES ('815', '230811', '230800', '郊区'); INSERT INTO city VALUES ('816', '230822', '230800', '桦南县'); INSERT INTO city VALUES ('817', '230826', '230800', '桦川县'); INSERT INTO city VALUES ('818', '230828', '230800', '汤原县'); INSERT INTO city VALUES ('819', '230833', '230800', '抚远县'); INSERT INTO city VALUES ('82', '130230', '130200', '唐海县'); INSERT INTO city VALUES ('820', '230881', '230800', '同江市'); INSERT INTO city VALUES ('821', '230882', '230800', '富锦市'); INSERT INTO city VALUES ('822', '230900', '230000', '七台河市'); INSERT INTO city VALUES ('823', '230901', '230900', '市辖区'); INSERT INTO city VALUES ('824', '230902', '230900', '新兴区'); INSERT INTO city VALUES ('825', '230903', '230900', '桃山区'); INSERT INTO city VALUES ('826', '230904', '230900', '茄子河区'); INSERT INTO city VALUES ('827', '230921', '230900', '勃利县'); INSERT INTO city VALUES ('828', '231000', '230000', '牡丹江市'); INSERT INTO city VALUES ('829', '231001', '231000', '市辖区'); INSERT INTO city VALUES ('83', '130281', '130200', '遵化市'); INSERT INTO city VALUES ('830', '231002', '231000', '东安区'); INSERT INTO city VALUES ('831', '231003', '231000', '阳明区'); INSERT INTO city VALUES ('832', '231004', '231000', '爱民区'); INSERT INTO city VALUES ('833', '231005', '231000', '西安区'); INSERT INTO city VALUES ('834', '231024', '231000', '东宁县'); INSERT INTO city VALUES ('835', '231025', '231000', '林口县'); INSERT INTO city VALUES ('836', '231081', '231000', '绥芬河市'); INSERT INTO city VALUES ('837', '231083', '231000', '海林市'); INSERT INTO city VALUES ('838', '231084', '231000', '宁安市'); INSERT INTO city VALUES ('839', '231085', '231000', '穆棱市'); INSERT INTO city VALUES ('84', '130283', '130200', '迁安市'); INSERT INTO city VALUES ('840', '231100', '230000', '黑河市'); INSERT INTO city VALUES ('841', '231101', '231100', '市辖区'); INSERT INTO city VALUES ('842', '231102', '231100', '爱辉区'); INSERT INTO city VALUES ('843', '231121', '231100', '嫩江县'); INSERT INTO city VALUES ('844', '231123', '231100', '逊克县'); INSERT INTO city VALUES ('845', '231124', '231100', '孙吴县'); INSERT INTO city VALUES ('846', '231181', '231100', '北安市'); INSERT INTO city VALUES ('847', '231182', '231100', '五大连池市'); INSERT INTO city VALUES ('848', '231200', '230000', '绥化市'); INSERT INTO city VALUES ('849', '231201', '231200', '市辖区'); INSERT INTO city VALUES ('85', '130300', '130000', '秦皇岛市'); INSERT INTO city VALUES ('850', '231202', '231200', '北林区'); INSERT INTO city VALUES ('851', '231221', '231200', '望奎县'); INSERT INTO city VALUES ('852', '231222', '231200', '兰西县'); INSERT INTO city VALUES ('853', '231223', '231200', '青冈县'); INSERT INTO city VALUES ('854', '231224', '231200', '庆安县'); INSERT INTO city VALUES ('855', '231225', '231200', '明水县'); INSERT INTO city VALUES ('856', '231226', '231200', '绥棱县'); INSERT INTO city VALUES ('857', '231281', '231200', '安达市'); INSERT INTO city VALUES ('858', '231282', '231200', '肇东市'); INSERT INTO city VALUES ('859', '231283', '231200', '海伦市'); INSERT INTO city VALUES ('86', '130301', '130300', '市辖区'); INSERT INTO city VALUES ('860', '232700', '230000', '大兴安岭地区'); INSERT INTO city VALUES ('861', '232701', '232700', '加格达奇区'); INSERT INTO city VALUES ('862', '232702', '232700', '松岭区'); INSERT INTO city VALUES ('863', '232703', '232700', '新林区'); INSERT INTO city VALUES ('864', '232704', '232700', '呼中区'); INSERT INTO city VALUES ('865', '232721', '232700', '呼玛县'); INSERT INTO city VALUES ('866', '232722', '232700', '塔河县'); INSERT INTO city VALUES ('867', '232723', '232700', '漠河县'); INSERT INTO city VALUES ('868', '310000', '-', '上海市'); INSERT INTO city VALUES ('869', '310100', '310000', '市辖区'); INSERT INTO city VALUES ('87', '130302', '130300', '海港区'); INSERT INTO city VALUES ('870', '310101', '310100', '黄浦区'); INSERT INTO city VALUES ('871', '310103', '310100', '卢湾区'); INSERT INTO city VALUES ('872', '310104', '310100', '徐汇区'); INSERT INTO city VALUES ('873', '310105', '310100', '长宁区'); INSERT INTO city VALUES ('874', '310106', '310100', '静安区'); INSERT INTO city VALUES ('875', '310107', '310100', '普陀区'); INSERT INTO city VALUES ('876', '310108', '310100', '闸北区'); INSERT INTO city VALUES ('877', '310109', '310100', '虹口区'); INSERT INTO city VALUES ('878', '310110', '310100', '杨浦区'); INSERT INTO city VALUES ('879', '310112', '310100', '闵行区'); INSERT INTO city VALUES ('88', '130303', '130300', '山海关区'); INSERT INTO city VALUES ('880', '310113', '310100', '宝山区'); INSERT INTO city VALUES ('881', '310114', '310100', '嘉定区'); INSERT INTO city VALUES ('882', '310115', '310100', '浦东新区'); INSERT INTO city VALUES ('883', '310116', '310100', '金山区'); INSERT INTO city VALUES ('884', '310117', '310100', '松江区'); INSERT INTO city VALUES ('885', '310118', '310100', '青浦区'); INSERT INTO city VALUES ('886', '310119', '310100', '南汇区'); INSERT INTO city VALUES ('887', '310120', '310100', '奉贤区'); INSERT INTO city VALUES ('888', '310200', '310000', '县'); INSERT INTO city VALUES ('889', '310230', '310200', '崇明县'); INSERT INTO city VALUES ('89', '130304', '130300', '北戴河区'); INSERT INTO city VALUES ('890', '320000', '-', '江苏省'); INSERT INTO city VALUES ('891', '320100', '320000', '南京市'); INSERT INTO city VALUES ('892', '320101', '320100', '市辖区'); INSERT INTO city VALUES ('893', '320102', '320100', '玄武区'); INSERT INTO city VALUES ('894', '320103', '320100', '白下区'); INSERT INTO city VALUES ('895', '320104', '320100', '秦淮区'); INSERT INTO city VALUES ('896', '320105', '320100', '建邺区'); INSERT INTO city VALUES ('897', '320106', '320100', '鼓楼区'); INSERT INTO city VALUES ('898', '320107', '320100', '下关区'); INSERT INTO city VALUES ('899', '320111', '320100', '浦口区'); INSERT INTO city VALUES ('9', '110107', '110100', '石景山区'); INSERT INTO city VALUES ('90', '130321', '130300', '青龙满族自治县'); INSERT INTO city VALUES ('900', '320113', '320100', '栖霞区'); INSERT INTO city VALUES ('901', '320114', '320100', '雨花台区'); INSERT INTO city VALUES ('902', '320115', '320100', '江宁区'); INSERT INTO city VALUES ('903', '320116', '320100', '六合区'); INSERT INTO city VALUES ('904', '320124', '320100', '溧水县'); INSERT INTO city VALUES ('905', '320125', '320100', '高淳县'); INSERT INTO city VALUES ('906', '320200', '320000', '无锡市'); INSERT INTO city VALUES ('907', '320201', '320200', '市辖区'); INSERT INTO city VALUES ('908', '320202', '320200', '崇安区'); INSERT INTO city VALUES ('909', '320203', '320200', '南长区'); INSERT INTO city VALUES ('91', '130322', '130300', '昌黎县'); INSERT INTO city VALUES ('910', '320204', '320200', '北塘区'); INSERT INTO city VALUES ('911', '320205', '320200', '锡山区'); INSERT INTO city VALUES ('912', '320206', '320200', '惠山区'); INSERT INTO city VALUES ('913', '320211', '320200', '滨湖区'); INSERT INTO city VALUES ('914', '320281', '320200', '江阴市'); INSERT INTO city VALUES ('915', '320282', '320200', '宜兴市'); INSERT INTO city VALUES ('916', '320300', '320000', '徐州市'); INSERT INTO city VALUES ('917', '320301', '320300', '市辖区'); INSERT INTO city VALUES ('918', '320302', '320300', '鼓楼区'); INSERT INTO city VALUES ('919', '320303', '320300', '云龙区'); INSERT INTO city VALUES ('92', '130323', '130300', '抚宁县'); INSERT INTO city VALUES ('920', '320304', '320300', '九里区'); INSERT INTO city VALUES ('921', '320305', '320300', '贾汪区'); INSERT INTO city VALUES ('922', '320311', '320300', '泉山区'); INSERT INTO city VALUES ('923', '320321', '320300', '丰县'); INSERT INTO city VALUES ('924', '320322', '320300', '沛县'); INSERT INTO city VALUES ('925', '320323', '320300', '铜山县'); INSERT INTO city VALUES ('926', '320324', '320300', '睢宁县'); INSERT INTO city VALUES ('927', '320381', '320300', '新沂市'); INSERT INTO city VALUES ('928', '320382', '320300', '邳州市'); INSERT INTO city VALUES ('929', '320400', '320000', '常州市'); INSERT INTO city VALUES ('93', '130324', '130300', '卢龙县'); INSERT INTO city VALUES ('930', '320401', '320400', '市辖区'); INSERT INTO city VALUES ('931', '320402', '320400', '天宁区'); INSERT INTO city VALUES ('932', '320404', '320400', '钟楼区'); INSERT INTO city VALUES ('933', '320405', '320400', '戚墅堰区'); INSERT INTO city VALUES ('934', '320411', '320400', '新北区'); INSERT INTO city VALUES ('935', '320412', '320400', '武进区'); INSERT INTO city VALUES ('936', '320481', '320400', '溧阳市'); INSERT INTO city VALUES ('937', '320482', '320400', '金坛市'); INSERT INTO city VALUES ('938', '320500', '320000', '苏州市'); INSERT INTO city VALUES ('939', '320501', '320500', '市辖区'); INSERT INTO city VALUES ('94', '130400', '130000', '邯郸市'); INSERT INTO city VALUES ('940', '320502', '320500', '沧浪区'); INSERT INTO city VALUES ('941', '320503', '320500', '平江区'); INSERT INTO city VALUES ('942', '320504', '320500', '金阊区'); INSERT INTO city VALUES ('943', '320505', '320500', '虎丘区'); INSERT INTO city VALUES ('944', '320506', '320500', '吴中区'); INSERT INTO city VALUES ('945', '320507', '320500', '相城区'); INSERT INTO city VALUES ('946', '320581', '320500', '常熟市'); INSERT INTO city VALUES ('947', '320582', '320500', '张家港市'); INSERT INTO city VALUES ('948', '320583', '320500', '昆山市'); INSERT INTO city VALUES ('949', '320584', '320500', '吴江市'); INSERT INTO city VALUES ('95', '130401', '130400', '市辖区'); INSERT INTO city VALUES ('950', '320585', '320500', '太仓市'); INSERT INTO city VALUES ('951', '320600', '320000', '南通市'); INSERT INTO city VALUES ('952', '320601', '320600', '市辖区'); INSERT INTO city VALUES ('953', '320602', '320600', '崇川区'); INSERT INTO city VALUES ('954', '320611', '320600', '港闸区'); INSERT INTO city VALUES ('955', '320621', '320600', '海安县'); INSERT INTO city VALUES ('956', '320623', '320600', '如东县'); INSERT INTO city VALUES ('957', '320681', '320600', '启东市'); INSERT INTO city VALUES ('958', '320682', '320600', '如皋市'); INSERT INTO city VALUES ('959', '320683', '320600', '通州市'); INSERT INTO city VALUES ('96', '130402', '130400', '邯山区'); INSERT INTO city VALUES ('960', '320684', '320600', '海门市'); INSERT INTO city VALUES ('961', '320700', '320000', '连云港市'); INSERT INTO city VALUES ('962', '320701', '320700', '市辖区'); INSERT INTO city VALUES ('963', '320703', '320700', '连云区'); INSERT INTO city VALUES ('964', '320705', '320700', '新浦区'); INSERT INTO city VALUES ('965', '320706', '320700', '海州区'); INSERT INTO city VALUES ('966', '320721', '320700', '赣榆县'); INSERT INTO city VALUES ('967', '320722', '320700', '东海县'); INSERT INTO city VALUES ('968', '320723', '320700', '灌云县'); INSERT INTO city VALUES ('969', '320724', '320700', '灌南县'); INSERT INTO city VALUES ('97', '130403', '130400', '丛台区'); INSERT INTO city VALUES ('970', '320800', '320000', '淮安市'); INSERT INTO city VALUES ('971', '320801', '320800', '市辖区'); INSERT INTO city VALUES ('972', '320802', '320800', '清河区'); INSERT INTO city VALUES ('973', '320803', '320800', '楚州区'); INSERT INTO city VALUES ('974', '320804', '320800', '淮阴区'); INSERT INTO city VALUES ('975', '320811', '320800', '清浦区'); INSERT INTO city VALUES ('976', '320826', '320800', '涟水县'); INSERT INTO city VALUES ('977', '320829', '320800', '洪泽县'); INSERT INTO city VALUES ('978', '320830', '320800', '盱眙县'); INSERT INTO city VALUES ('979', '320831', '320800', '金湖县'); INSERT INTO city VALUES ('98', '130404', '130400', '复兴区'); INSERT INTO city VALUES ('980', '320900', '320000', '盐城市'); INSERT INTO city VALUES ('981', '320901', '320900', '市辖区'); INSERT INTO city VALUES ('982', '320902', '320900', '亭湖区'); INSERT INTO city VALUES ('983', '320903', '320900', '盐都区'); INSERT INTO city VALUES ('984', '320921', '320900', '响水县'); INSERT INTO city VALUES ('985', '320922', '320900', '滨海县'); INSERT INTO city VALUES ('986', '320923', '320900', '阜宁县'); INSERT INTO city VALUES ('987', '320924', '320900', '射阳县'); INSERT INTO city VALUES ('988', '320925', '320900', '建湖县'); INSERT INTO city VALUES ('989', '320981', '320900', '东台市'); INSERT INTO city VALUES ('99', '130406', '130400', '峰峰矿区'); INSERT INTO city VALUES ('990', '320982', '320900', '大丰市'); INSERT INTO city VALUES ('991', '321000', '320000', '扬州市'); INSERT INTO city VALUES ('992', '321001', '321000', '市辖区'); INSERT INTO city VALUES ('993', '321002', '321000', '广陵区'); INSERT INTO city VALUES ('994', '321003', '321000', '邗江区'); INSERT INTO city VALUES ('995', '321011', '321000', '维扬区'); INSERT INTO city VALUES ('996', '321023', '321000', '宝应县'); INSERT INTO city VALUES ('997', '321081', '321000', '仪征市'); INSERT INTO city VALUES ('998', '321084', '321000', '高邮市'); INSERT INTO city VALUES ('999', '321088', '321000', '江都市');