省市区三级联动

参考文章：http://www.cnblogs.com/taoweiji/p/3710262.html  天津市的数据有问题

 

修复后的数据如下：

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50027
Source Host           : localhost:3306
Source Database       : frame

Target Server Type    : MYSQL
Target Server Version : 50027
File Encoding         : 65001

Date: 2015-05-02 12:24:29
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `area`
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `code` varchar(255) collate utf8_bin NOT NULL,
  `name` varchar(255) collate utf8_bin default NULL,
  `id` varchar(255) collate utf8_bin default NULL,
  `citycode` varchar(255) collate utf8_bin default NULL,
  PRIMARY KEY  (`code`),
  KEY `FK_Reference_7` (`citycode`),
  CONSTRAINT `FK_Reference_7` FOREIGN KEY (`citycode`) REFERENCES `city` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('110101', '东城区', '1', '110100');
INSERT INTO `area` VALUES ('110102', '西城区', '2', '110100');
INSERT INTO `area` VALUES ('110103', '崇文区', '3', '110100');
INSERT INTO `area` VALUES ('110104', '宣武区', '4', '110100');
INSERT INTO `area` VALUES ('110105', '朝阳区', '5', '110100');
INSERT INTO `area` VALUES ('110106', '丰台区', '6', '110100');
INSERT INTO `area` VALUES ('110107', '石景山区', '7', '110100');
INSERT INTO `area` VALUES ('110108', '海淀区', '8', '110100');
INSERT INTO `area` VALUES ('110109', '门头沟区', '9', '110100');
INSERT INTO `area` VALUES ('110111', '房山区', '10', '110100');
INSERT INTO `area` VALUES ('110112', '通州区', '11', '110100');
INSERT INTO `area` VALUES ('110113', '顺义区', '12', '110100');
INSERT INTO `area` VALUES ('110114', '昌平区', '13', '110100');
INSERT INTO `area` VALUES ('110115', '大兴区', '14', '110100');
INSERT INTO `area` VALUES ('110116', '怀柔区', '15', '110100');
INSERT INTO `area` VALUES ('110117', '平谷区', '16', '110100');
INSERT INTO `area` VALUES ('110228', '密云县', '17', '110100');
INSERT INTO `area` VALUES ('110229', '延庆县', '18', '110100');
INSERT INTO `area` VALUES ('120101', '和平区', '19', '120100');
INSERT INTO `area` VALUES ('120102', '河东区', '20', '120100');
INSERT INTO `area` VALUES ('120103', '河西区', '21', '120100');
INSERT INTO `area` VALUES ('120104', '南开区', '22', '120100');
INSERT INTO `area` VALUES ('120105', '河北区', '23', '120100');
INSERT INTO `area` VALUES ('120106', '红桥区', '24', '120100');
INSERT INTO `area` VALUES ('120107', '塘沽区', '25', '120100');
INSERT INTO `area` VALUES ('120108', '汉沽区', '26', '120100');
INSERT INTO `area` VALUES ('120109', '大港区', '27', '120100');
INSERT INTO `area` VALUES ('120110', '东丽区', '28', '120100');
INSERT INTO `area` VALUES ('120111', '西青区', '29', '120100');
INSERT INTO `area` VALUES ('120112', '津南区', '30', '120100');
INSERT INTO `area` VALUES ('120113', '北辰区', '31', '120100');
INSERT INTO `area` VALUES ('120114', '武清区', '32', '120100');
INSERT INTO `area` VALUES ('120115', '宝坻区', '33', '120100');
INSERT INTO `area` VALUES ('120221', '宁河县', '34', '120100');
INSERT INTO `area` VALUES ('120223', '静海县', '35', '120100');
INSERT INTO `area` VALUES ('120225', '蓟　县', '36', '120100');
INSERT INTO `area` VALUES ('130101', '市辖区', '37', '130100');
INSERT INTO `area` VALUES ('130102', '长安区', '38', '130100');
INSERT INTO `area` VALUES ('130103', '桥东区', '39', '130100');
INSERT INTO `area` VALUES ('130104', '桥西区', '40', '130100');
INSERT INTO `area` VALUES ('130105', '新华区', '41', '130100');
INSERT INTO `area` VALUES ('130107', '井陉矿区', '42', '130100');
INSERT INTO `area` VALUES ('130108', '裕华区', '43', '130100');
INSERT INTO `area` VALUES ('130121', '井陉县', '44', '130100');
INSERT INTO `area` VALUES ('130123', '正定县', '45', '130100');
INSERT INTO `area` VALUES ('130124', '栾城县', '46', '130100');
INSERT INTO `area` VALUES ('130125', '行唐县', '47', '130100');
INSERT INTO `area` VALUES ('130126', '灵寿县', '48', '130100');
INSERT INTO `area` VALUES ('130127', '高邑县', '49', '130100');
INSERT INTO `area` VALUES ('130128', '深泽县', '50', '130100');
INSERT INTO `area` VALUES ('130129', '赞皇县', '51', '130100');
INSERT INTO `area` VALUES ('130130', '无极县', '52', '130100');
INSERT INTO `area` VALUES ('130131', '平山县', '53', '130100');
INSERT INTO `area` VALUES ('130132', '元氏县', '54', '130100');
INSERT INTO `area` VALUES ('130133', '赵　县', '55', '130100');
INSERT INTO `area` VALUES ('130181', '辛集市', '56', '130100');
INSERT INTO `area` VALUES ('130182', '藁城市', '57', '130100');
INSERT INTO `area` VALUES ('130183', '晋州市', '58', '130100');
INSERT INTO `area` VALUES ('130184', '新乐市', '59', '130100');
INSERT INTO `area` VALUES ('130185', '鹿泉市', '60', '130100');
INSERT INTO `area` VALUES ('130201', '市辖区', '61', '130200');
INSERT INTO `area` VALUES ('130202', '路南区', '62', '130200');
INSERT INTO `area` VALUES ('130203', '路北区', '63', '130200');
INSERT INTO `area` VALUES ('130204', '古冶区', '64', '130200');
INSERT INTO `area` VALUES ('130205', '开平区', '65', '130200');
INSERT INTO `area` VALUES ('130207', '丰南区', '66', '130200');
INSERT INTO `area` VALUES ('130208', '丰润区', '67', '130200');
INSERT INTO `area` VALUES ('130223', '滦　县', '68', '130200');
INSERT INTO `area` VALUES ('130224', '滦南县', '69', '130200');
INSERT INTO `area` VALUES ('130225', '乐亭县', '70', '130200');
INSERT INTO `area` VALUES ('130227', '迁西县', '71', '130200');
INSERT INTO `area` VALUES ('130229', '玉田县', '72', '130200');
INSERT INTO `area` VALUES ('130230', '唐海县', '73', '130200');
INSERT INTO `area` VALUES ('130281', '遵化市', '74', '130200');
INSERT INTO `area` VALUES ('130283', '迁安市', '75', '130200');
INSERT INTO `area` VALUES ('130301', '市辖区', '76', '130300');
INSERT INTO `area` VALUES ('130302', '海港区', '77', '130300');
INSERT INTO `area` VALUES ('130303', '山海关区', '78', '130300');
INSERT INTO `area` VALUES ('130304', '北戴河区', '79', '130300');
INSERT INTO `area` VALUES ('130321', '青龙满族自治县', '80', '130300');
INSERT INTO `area` VALUES ('130322', '昌黎县', '81', '130300');
INSERT INTO `area` VALUES ('130323', '抚宁县', '82', '130300');
INSERT INTO `area` VALUES ('130324', '卢龙县', '83', '130300');
INSERT INTO `area` VALUES ('130401', '市辖区', '84', '130400');
INSERT INTO `area` VALUES ('130402', '邯山区', '85', '130400');
INSERT INTO `area` VALUES ('130403', '丛台区', '86', '130400');
INSERT INTO `area` VALUES ('130404', '复兴区', '87', '130400');
INSERT INTO `area` VALUES ('130406', '峰峰矿区', '88', '130400');
INSERT INTO `area` VALUES ('130421', '邯郸县', '89', '130400');
INSERT INTO `area` VALUES ('130423', '临漳县', '90', '130400');
INSERT INTO `area` VALUES ('130424', '成安县', '91', '130400');
INSERT INTO `area` VALUES ('130425', '大名县', '92', '130400');
INSERT INTO `area` VALUES ('130426', '涉　县', '93', '130400');
INSERT INTO `area` VALUES ('130427', '磁　县', '94', '130400');
INSERT INTO `area` VALUES ('130428', '肥乡县', '95', '130400');
INSERT INTO `area` VALUES ('130429', '永年县', '96', '130400');
INSERT INTO `area` VALUES ('130430', '邱　县', '97', '130400');
INSERT INTO `area` VALUES ('130431', '鸡泽县', '98', '130400');
INSERT INTO `area` VALUES ('130432', '广平县', '99', '130400');
INSERT INTO `area` VALUES ('130433', '馆陶县', '100', '130400');
INSERT INTO `area` VALUES ('130434', '魏　县', '101', '130400');
INSERT INTO `area` VALUES ('130435', '曲周县', '102', '130400');
INSERT INTO `area` VALUES ('130481', '武安市', '103', '130400');
INSERT INTO `area` VALUES ('130501', '市辖区', '104', '130500');
INSERT INTO `area` VALUES ('130502', '桥东区', '105', '130500');
INSERT INTO `area` VALUES ('130503', '桥西区', '106', '130500');
INSERT INTO `area` VALUES ('130521', '邢台县', '107', '130500');
INSERT INTO `area` VALUES ('130522', '临城县', '108', '130500');
INSERT INTO `area` VALUES ('130523', '内丘县', '109', '130500');
INSERT INTO `area` VALUES ('130524', '柏乡县', '110', '130500');
INSERT INTO `area` VALUES ('130525', '隆尧县', '111', '130500');
INSERT INTO `area` VALUES ('130526', '任　县', '112', '130500');
INSERT INTO `area` VALUES ('130527', '南和县', '113', '130500');
INSERT INTO `area` VALUES ('130528', '宁晋县', '114', '130500');
INSERT INTO `area` VALUES ('130529', '巨鹿县', '115', '130500');
INSERT INTO `area` VALUES ('130530', '新河县', '116', '130500');
INSERT INTO `area` VALUES ('130531', '广宗县', '117', '130500');
INSERT INTO `area` VALUES ('130532', '平乡县', '118', '130500');
INSERT INTO `area` VALUES ('130533', '威　县', '119', '130500');
INSERT INTO `area` VALUES ('130534', '清河县', '120', '130500');
INSERT INTO `area` VALUES ('130535', '临西县', '121', '130500');
INSERT INTO `area` VALUES ('130581', '南宫市', '122', '130500');
INSERT INTO `area` VALUES ('130582', '沙河市', '123', '130500');
INSERT INTO `area` VALUES ('130601', '市辖区', '124', '130600');
INSERT INTO `area` VALUES ('130602', '新市区', '125', '130600');
INSERT INTO `area` VALUES ('130603', '北市区', '126', '130600');
INSERT INTO `area` VALUES ('130604', '南市区', '127', '130600');
INSERT INTO `area` VALUES ('130621', '满城县', '128', '130600');
INSERT INTO `area` VALUES ('130622', '清苑县', '129', '130600');
INSERT INTO `area` VALUES ('130623', '涞水县', '130', '130600');
INSERT INTO `area` VALUES ('130624', '阜平县', '131', '130600');
INSERT INTO `area` VALUES ('130625', '徐水县', '132', '130600');
INSERT INTO `area` VALUES ('130626', '定兴县', '133', '130600');
INSERT INTO `area` VALUES ('130627', '唐　县', '134', '130600');
INSERT INTO `area` VALUES ('130628', '高阳县', '135', '130600');
INSERT INTO `area` VALUES ('130629', '容城县', '136', '130600');
INSERT INTO `area` VALUES ('130630', '涞源县', '137', '130600');
INSERT INTO `area` VALUES ('130631', '望都县', '138', '130600');
INSERT INTO `area` VALUES ('130632', '安新县', '139', '130600');
INSERT INTO `area` VALUES ('130633', '易　县', '140', '130600');
INSERT INTO `area` VALUES ('130634', '曲阳县', '141', '130600');
INSERT INTO `area` VALUES ('130635', '蠡　县', '142', '130600');
INSERT INTO `area` VALUES ('130636', '顺平县', '143', '130600');
INSERT INTO `area` VALUES ('130637', '博野县', '144', '130600');
INSERT INTO `area` VALUES ('130638', '雄　县', '145', '130600');
INSERT INTO `area` VALUES ('130681', '涿州市', '146', '130600');
INSERT INTO `area` VALUES ('130682', '定州市', '147', '130600');
INSERT INTO `area` VALUES ('130683', '安国市', '148', '130600');
INSERT INTO `area` VALUES ('130684', '高碑店市', '149', '130600');
INSERT INTO `area` VALUES ('130701', '市辖区', '150', '130700');
INSERT INTO `area` VALUES ('130702', '桥东区', '151', '130700');
INSERT INTO `area` VALUES ('130703', '桥西区', '152', '130700');
INSERT INTO `area` VALUES ('130705', '宣化区', '153', '130700');
INSERT INTO `area` VALUES ('130706', '下花园区', '154', '130700');
INSERT INTO `area` VALUES ('130721', '宣化县', '155', '130700');
INSERT INTO `area` VALUES ('130722', '张北县', '156', '130700');
INSERT INTO `area` VALUES ('130723', '康保县', '157', '130700');
INSERT INTO `area` VALUES ('130724', '沽源县', '158', '130700');
INSERT INTO `area` VALUES ('130725', '尚义县', '159', '130700');
INSERT INTO `area` VALUES ('130726', '蔚　县', '160', '130700');
INSERT INTO `area` VALUES ('130727', '阳原县', '161', '130700');
INSERT INTO `area` VALUES ('130728', '怀安县', '162', '130700');
INSERT INTO `area` VALUES ('130729', '万全县', '163', '130700');
INSERT INTO `area` VALUES ('130730', '怀来县', '164', '130700');
INSERT INTO `area` VALUES ('130731', '涿鹿县', '165', '130700');
INSERT INTO `area` VALUES ('130732', '赤城县', '166', '130700');
INSERT INTO `area` VALUES ('130733', '崇礼县', '167', '130700');
INSERT INTO `area` VALUES ('130801', '市辖区', '168', '130800');
INSERT INTO `area` VALUES ('130802', '双桥区', '169', '130800');
INSERT INTO `area` VALUES ('130803', '双滦区', '170', '130800');
INSERT INTO `area` VALUES ('130804', '鹰手营子矿区', '171', '130800');
INSERT INTO `area` VALUES ('130821', '承德县', '172', '130800');
INSERT INTO `area` VALUES ('130822', '兴隆县', '173', '130800');
INSERT INTO `area` VALUES ('130823', '平泉县', '174', '130800');
INSERT INTO `area` VALUES ('130824', '滦平县', '175', '130800');
INSERT INTO `area` VALUES ('130825', '隆化县', '176', '130800');
INSERT INTO `area` VALUES ('130826', '丰宁满族自治县', '177', '130800');
INSERT INTO `area` VALUES ('130827', '宽城满族自治县', '178', '130800');
INSERT INTO `area` VALUES ('130828', '围场满族蒙古族自治县', '179', '130800');
INSERT INTO `area` VALUES ('130901', '市辖区', '180', '130900');
INSERT INTO `area` VALUES ('130902', '新华区', '181', '130900');
INSERT INTO `area` VALUES ('130903', '运河区', '182', '130900');
INSERT INTO `area` VALUES ('130921', '沧　县', '183', '130900');
INSERT INTO `area` VALUES ('130922', '青　县', '184', '130900');
INSERT INTO `area` VALUES ('130923', '东光县', '185', '130900');
INSERT INTO `area` VALUES ('130924', '海兴县', '186', '130900');
INSERT INTO `area` VALUES ('130925', '盐山县', '187', '130900');
INSERT INTO `area` VALUES ('130926', '肃宁县', '188', '130900');
INSERT INTO `area` VALUES ('130927', '南皮县', '189', '130900');
INSERT INTO `area` VALUES ('130928', '吴桥县', '190', '130900');
INSERT INTO `area` VALUES ('130929', '献　县', '191', '130900');
INSERT INTO `area` VALUES ('130930', '孟村回族自治县', '192', '130900');
INSERT INTO `area` VALUES ('130981', '泊头市', '193', '130900');
INSERT INTO `area` VALUES ('130982', '任丘市', '194', '130900');
INSERT INTO `area` VALUES ('130983', '黄骅市', '195', '130900');
INSERT INTO `area` VALUES ('130984', '河间市', '196', '130900');
INSERT INTO `area` VALUES ('131001', '市辖区', '197', '131000');
INSERT INTO `area` VALUES ('131002', '安次区', '198', '131000');
INSERT INTO `area` VALUES ('131003', '广阳区', '199', '131000');
INSERT INTO `area` VALUES ('131022', '固安县', '200', '131000');
INSERT INTO `area` VALUES ('131023', '永清县', '201', '131000');
INSERT INTO `area` VALUES ('131024', '香河县', '202', '131000');
INSERT INTO `area` VALUES ('131025', '大城县', '203', '131000');
INSERT INTO `area` VALUES ('131026', '文安县', '204', '131000');
INSERT INTO `area` VALUES ('131028', '大厂回族自治县', '205', '131000');
INSERT INTO `area` VALUES ('131081', '霸州市', '206', '131000');
INSERT INTO `area` VALUES ('131082', '三河市', '207', '131000');
INSERT INTO `area` VALUES ('131101', '市辖区', '208', '131100');
INSERT INTO `area` VALUES ('131102', '桃城区', '209', '131100');
INSERT INTO `area` VALUES ('131121', '枣强县', '210', '131100');
INSERT INTO `area` VALUES ('131122', '武邑县', '211', '131100');
INSERT INTO `area` VALUES ('131123', '武强县', '212', '131100');
INSERT INTO `area` VALUES ('131124', '饶阳县', '213', '131100');
INSERT INTO `area` VALUES ('131125', '安平县', '214', '131100');
INSERT INTO `area` VALUES ('131126', '故城县', '215', '131100');
INSERT INTO `area` VALUES ('131127', '景　县', '216', '131100');
INSERT INTO `area` VALUES ('131128', '阜城县', '217', '131100');
INSERT INTO `area` VALUES ('131181', '冀州市', '218', '131100');
INSERT INTO `area` VALUES ('131182', '深州市', '219', '131100');
INSERT INTO `area` VALUES ('140101', '市辖区', '220', '140100');
INSERT INTO `area` VALUES ('140105', '小店区', '221', '140100');
INSERT INTO `area` VALUES ('140106', '迎泽区', '222', '140100');
INSERT INTO `area` VALUES ('140107', '杏花岭区', '223', '140100');
INSERT INTO `area` VALUES ('140108', '尖草坪区', '224', '140100');
INSERT INTO `area` VALUES ('140109', '万柏林区', '225', '140100');
INSERT INTO `area` VALUES ('140110', '晋源区', '226', '140100');
INSERT INTO `area` VALUES ('140121', '清徐县', '227', '140100');
INSERT INTO `area` VALUES ('140122', '阳曲县', '228', '140100');
INSERT INTO `area` VALUES ('140123', '娄烦县', '229', '140100');
INSERT INTO `area` VALUES ('140181', '古交市', '230', '140100');
INSERT INTO `area` VALUES ('140201', '市辖区', '231', '140200');
INSERT INTO `area` VALUES ('140202', '城　区', '232', '140200');
INSERT INTO `area` VALUES ('140203', '矿　区', '233', '140200');
INSERT INTO `area` VALUES ('140211', '南郊区', '234', '140200');
INSERT INTO `area` VALUES ('140212', '新荣区', '235', '140200');
INSERT INTO `area` VALUES ('140221', '阳高县', '236', '140200');
INSERT INTO `area` VALUES ('140222', '天镇县', '237', '140200');
INSERT INTO `area` VALUES ('140223', '广灵县', '238', '140200');
INSERT INTO `area` VALUES ('140224', '灵丘县', '239', '140200');
INSERT INTO `area` VALUES ('140225', '浑源县', '240', '140200');
INSERT INTO `area` VALUES ('140226', '左云县', '241', '140200');
INSERT INTO `area` VALUES ('140227', '大同县', '242', '140200');
INSERT INTO `area` VALUES ('140301', '市辖区', '243', '140300');
INSERT INTO `area` VALUES ('140302', '城　区', '244', '140300');
INSERT INTO `area` VALUES ('140303', '矿　区', '245', '140300');
INSERT INTO `area` VALUES ('140311', '郊　区', '246', '140300');
INSERT INTO `area` VALUES ('140321', '平定县', '247', '140300');
INSERT INTO `area` VALUES ('140322', '盂　县', '248', '140300');
INSERT INTO `area` VALUES ('140401', '市辖区', '249', '140400');
INSERT INTO `area` VALUES ('140402', '城　区', '250', '140400');
INSERT INTO `area` VALUES ('140411', '郊　区', '251', '140400');
INSERT INTO `area` VALUES ('140421', '长治县', '252', '140400');
INSERT INTO `area` VALUES ('140423', '襄垣县', '253', '140400');
INSERT INTO `area` VALUES ('140424', '屯留县', '254', '140400');
INSERT INTO `area` VALUES ('140425', '平顺县', '255', '140400');
INSERT INTO `area` VALUES ('140426', '黎城县', '256', '140400');
INSERT INTO `area` VALUES ('140427', '壶关县', '257', '140400');
INSERT INTO `area` VALUES ('140428', '长子县', '258', '140400');
INSERT INTO `area` VALUES ('140429', '武乡县', '259', '140400');
INSERT INTO `area` VALUES ('140430', '沁　县', '260', '140400');
INSERT INTO `area` VALUES ('140431', '沁源县', '261', '140400');
INSERT INTO `area` VALUES ('140481', '潞城市', '262', '140400');
INSERT INTO `area` VALUES ('140501', '市辖区', '263', '140500');
INSERT INTO `area` VALUES ('140502', '城　区', '264', '140500');
INSERT INTO `area` VALUES ('140521', '沁水县', '265', '140500');
INSERT INTO `area` VALUES ('140522', '阳城县', '266', '140500');
INSERT INTO `area` VALUES ('140524', '陵川县', '267', '140500');
INSERT INTO `area` VALUES ('140525', '泽州县', '268', '140500');
INSERT INTO `area` VALUES ('140581', '高平市', '269', '140500');
INSERT INTO `area` VALUES ('140601', '市辖区', '270', '140600');
INSERT INTO `area` VALUES ('140602', '朔城区', '271', '140600');
INSERT INTO `area` VALUES ('140603', '平鲁区', '272', '140600');
INSERT INTO `area` VALUES ('140621', '山阴县', '273', '140600');
INSERT INTO `area` VALUES ('140622', '应　县', '274', '140600');
INSERT INTO `area` VALUES ('140623', '右玉县', '275', '140600');
INSERT INTO `area` VALUES ('140624', '怀仁县', '276', '140600');
INSERT INTO `area` VALUES ('140701', '市辖区', '277', '140700');
INSERT INTO `area` VALUES ('140702', '榆次区', '278', '140700');
INSERT INTO `area` VALUES ('140721', '榆社县', '279', '140700');
INSERT INTO `area` VALUES ('140722', '左权县', '280', '140700');
INSERT INTO `area` VALUES ('140723', '和顺县', '281', '140700');
INSERT INTO `area` VALUES ('140724', '昔阳县', '282', '140700');
INSERT INTO `area` VALUES ('140725', '寿阳县', '283', '140700');
INSERT INTO `area` VALUES ('140726', '太谷县', '284', '140700');
INSERT INTO `area` VALUES ('140727', '祁　县', '285', '140700');
INSERT INTO `area` VALUES ('140728', '平遥县', '286', '140700');
INSERT INTO `area` VALUES ('140729', '灵石县', '287', '140700');
INSERT INTO `area` VALUES ('140781', '介休市', '288', '140700');
INSERT INTO `area` VALUES ('140801', '市辖区', '289', '140800');
INSERT INTO `area` VALUES ('140802', '盐湖区', '290', '140800');
INSERT INTO `area` VALUES ('140821', '临猗县', '291', '140800');
INSERT INTO `area` VALUES ('140822', '万荣县', '292', '140800');
INSERT INTO `area` VALUES ('140823', '闻喜县', '293', '140800');
INSERT INTO `area` VALUES ('140824', '稷山县', '294', '140800');
INSERT INTO `area` VALUES ('140825', '新绛县', '295', '140800');
INSERT INTO `area` VALUES ('140826', '绛　县', '296', '140800');
INSERT INTO `area` VALUES ('140827', '垣曲县', '297', '140800');
INSERT INTO `area` VALUES ('140828', '夏　县', '298', '140800');
INSERT INTO `area` VALUES ('140829', '平陆县', '299', '140800');
INSERT INTO `area` VALUES ('140830', '芮城县', '300', '140800');
INSERT INTO `area` VALUES ('140881', '永济市', '301', '140800');
INSERT INTO `area` VALUES ('140882', '河津市', '302', '140800');
INSERT INTO `area` VALUES ('140901', '市辖区', '303', '140900');
INSERT INTO `area` VALUES ('140902', '忻府区', '304', '140900');
INSERT INTO `area` VALUES ('140921', '定襄县', '305', '140900');
INSERT INTO `area` VALUES ('140922', '五台县', '306', '140900');
INSERT INTO `area` VALUES ('140923', '代　县', '307', '140900');
INSERT INTO `area` VALUES ('140924', '繁峙县', '308', '140900');
INSERT INTO `area` VALUES ('140925', '宁武县', '309', '140900');
INSERT INTO `area` VALUES ('140926', '静乐县', '310', '140900');
INSERT INTO `area` VALUES ('140927', '神池县', '311', '140900');
INSERT INTO `area` VALUES ('140928', '五寨县', '312', '140900');
INSERT INTO `area` VALUES ('140929', '岢岚县', '313', '140900');
INSERT INTO `area` VALUES ('140930', '河曲县', '314', '140900');
INSERT INTO `area` VALUES ('140931', '保德县', '315', '140900');
INSERT INTO `area` VALUES ('140932', '偏关县', '316', '140900');
INSERT INTO `area` VALUES ('140981', '原平市', '317', '140900');
INSERT INTO `area` VALUES ('141001', '市辖区', '318', '141000');
INSERT INTO `area` VALUES ('141002', '尧都区', '319', '141000');
INSERT INTO `area` VALUES ('141021', '曲沃县', '320', '141000');
INSERT INTO `area` VALUES ('141022', '翼城县', '321', '141000');
INSERT INTO `area` VALUES ('141023', '襄汾县', '322', '141000');
INSERT INTO `area` VALUES ('141024', '洪洞县', '323', '141000');
INSERT INTO `area` VALUES ('141025', '古　县', '324', '141000');
INSERT INTO `area` VALUES ('141026', '安泽县', '325', '141000');
INSERT INTO `area` VALUES ('141027', '浮山县', '326', '141000');
INSERT INTO `area` VALUES ('141028', '吉　县', '327', '141000');
INSERT INTO `area` VALUES ('141029', '乡宁县', '328', '141000');
INSERT INTO `area` VALUES ('141030', '大宁县', '329', '141000');
INSERT INTO `area` VALUES ('141031', '隰　县', '330', '141000');
INSERT INTO `area` VALUES ('141032', '永和县', '331', '141000');
INSERT INTO `area` VALUES ('141033', '蒲　县', '332', '141000');
INSERT INTO `area` VALUES ('141034', '汾西县', '333', '141000');
INSERT INTO `area` VALUES ('141081', '侯马市', '334', '141000');
INSERT INTO `area` VALUES ('141082', '霍州市', '335', '141000');
INSERT INTO `area` VALUES ('141101', '市辖区', '336', '141100');
INSERT INTO `area` VALUES ('141102', '离石区', '337', '141100');
INSERT INTO `area` VALUES ('141121', '文水县', '338', '141100');
INSERT INTO `area` VALUES ('141122', '交城县', '339', '141100');
INSERT INTO `area` VALUES ('141123', '兴　县', '340', '141100');
INSERT INTO `area` VALUES ('141124', '临　县', '341', '141100');
INSERT INTO `area` VALUES ('141125', '柳林县', '342', '141100');
INSERT INTO `area` VALUES ('141126', '石楼县', '343', '141100');
INSERT INTO `area` VALUES ('141127', '岚　县', '344', '141100');
INSERT INTO `area` VALUES ('141128', '方山县', '345', '141100');
INSERT INTO `area` VALUES ('141129', '中阳县', '346', '141100');
INSERT INTO `area` VALUES ('141130', '交口县', '347', '141100');
INSERT INTO `area` VALUES ('141181', '孝义市', '348', '141100');
INSERT INTO `area` VALUES ('141182', '汾阳市', '349', '141100');
INSERT INTO `area` VALUES ('150101', '市辖区', '350', '150100');
INSERT INTO `area` VALUES ('150102', '新城区', '351', '150100');
INSERT INTO `area` VALUES ('150103', '回民区', '352', '150100');
INSERT INTO `area` VALUES ('150104', '玉泉区', '353', '150100');
INSERT INTO `area` VALUES ('150105', '赛罕区', '354', '150100');
INSERT INTO `area` VALUES ('150121', '土默特左旗', '355', '150100');
INSERT INTO `area` VALUES ('150122', '托克托县', '356', '150100');
INSERT INTO `area` VALUES ('150123', '和林格尔县', '357', '150100');
INSERT INTO `area` VALUES ('150124', '清水河县', '358', '150100');
INSERT INTO `area` VALUES ('150125', '武川县', '359', '150100');
INSERT INTO `area` VALUES ('150201', '市辖区', '360', '150200');
INSERT INTO `area` VALUES ('150202', '东河区', '361', '150200');
INSERT INTO `area` VALUES ('150203', '昆都仑区', '362', '150200');
INSERT INTO `area` VALUES ('150204', '青山区', '363', '150200');
INSERT INTO `area` VALUES ('150205', '石拐区', '364', '150200');
INSERT INTO `area` VALUES ('150206', '白云矿区', '365', '150200');
INSERT INTO `area` VALUES ('150207', '九原区', '366', '150200');
INSERT INTO `area` VALUES ('150221', '土默特右旗', '367', '150200');
INSERT INTO `area` VALUES ('150222', '固阳县', '368', '150200');
INSERT INTO `area` VALUES ('150223', '达尔罕茂明安联合旗', '369', '150200');
INSERT INTO `area` VALUES ('150301', '市辖区', '370', '150300');
INSERT INTO `area` VALUES ('150302', '海勃湾区', '371', '150300');
INSERT INTO `area` VALUES ('150303', '海南区', '372', '150300');
INSERT INTO `area` VALUES ('150304', '乌达区', '373', '150300');
INSERT INTO `area` VALUES ('150401', '市辖区', '374', '150400');
INSERT INTO `area` VALUES ('150402', '红山区', '375', '150400');
INSERT INTO `area` VALUES ('150403', '元宝山区', '376', '150400');
INSERT INTO `area` VALUES ('150404', '松山区', '377', '150400');
INSERT INTO `area` VALUES ('150421', '阿鲁科尔沁旗', '378', '150400');
INSERT INTO `area` VALUES ('150422', '巴林左旗', '379', '150400');
INSERT INTO `area` VALUES ('150423', '巴林右旗', '380', '150400');
INSERT INTO `area` VALUES ('150424', '林西县', '381', '150400');
INSERT INTO `area` VALUES ('150425', '克什克腾旗', '382', '150400');
INSERT INTO `area` VALUES ('150426', '翁牛特旗', '383', '150400');
INSERT INTO `area` VALUES ('150428', '喀喇沁旗', '384', '150400');
INSERT INTO `area` VALUES ('150429', '宁城县', '385', '150400');
INSERT INTO `area` VALUES ('150430', '敖汉旗', '386', '150400');
INSERT INTO `area` VALUES ('150501', '市辖区', '387', '150500');
INSERT INTO `area` VALUES ('150502', '科尔沁区', '388', '150500');
INSERT INTO `area` VALUES ('150521', '科尔沁左翼中旗', '389', '150500');
INSERT INTO `area` VALUES ('150522', '科尔沁左翼后旗', '390', '150500');
INSERT INTO `area` VALUES ('150523', '开鲁县', '391', '150500');
INSERT INTO `area` VALUES ('150524', '库伦旗', '392', '150500');
INSERT INTO `area` VALUES ('150525', '奈曼旗', '393', '150500');
INSERT INTO `area` VALUES ('150526', '扎鲁特旗', '394', '150500');
INSERT INTO `area` VALUES ('150581', '霍林郭勒市', '395', '150500');
INSERT INTO `area` VALUES ('150602', '东胜区', '396', '150600');
INSERT INTO `area` VALUES ('150621', '达拉特旗', '397', '150600');
INSERT INTO `area` VALUES ('150622', '准格尔旗', '398', '150600');
INSERT INTO `area` VALUES ('150623', '鄂托克前旗', '399', '150600');
INSERT INTO `area` VALUES ('150624', '鄂托克旗', '400', '150600');
INSERT INTO `area` VALUES ('150625', '杭锦旗', '401', '150600');
INSERT INTO `area` VALUES ('150626', '乌审旗', '402', '150600');
INSERT INTO `area` VALUES ('150627', '伊金霍洛旗', '403', '150600');
INSERT INTO `area` VALUES ('150701', '市辖区', '404', '150700');
INSERT INTO `area` VALUES ('150702', '海拉尔区', '405', '150700');
INSERT INTO `area` VALUES ('150721', '阿荣旗', '406', '150700');
INSERT INTO `area` VALUES ('150722', '莫力达瓦达斡尔族自治旗', '407', '150700');
INSERT INTO `area` VALUES ('150723', '鄂伦春自治旗', '408', '150700');
INSERT INTO `area` VALUES ('150724', '鄂温克族自治旗', '409', '150700');
INSERT INTO `area` VALUES ('150725', '陈巴尔虎旗', '410', '150700');
INSERT INTO `area` VALUES ('150726', '新巴尔虎左旗', '411', '150700');
INSERT INTO `area` VALUES ('150727', '新巴尔虎右旗', '412', '150700');
INSERT INTO `area` VALUES ('150781', '满洲里市', '413', '150700');
INSERT INTO `area` VALUES ('150782', '牙克石市', '414', '150700');
INSERT INTO `area` VALUES ('150783', '扎兰屯市', '415', '150700');
INSERT INTO `area` VALUES ('150784', '额尔古纳市', '416', '150700');
INSERT INTO `area` VALUES ('150785', '根河市', '417', '150700');
INSERT INTO `area` VALUES ('150801', '市辖区', '418', '150800');
INSERT INTO `area` VALUES ('150802', '临河区', '419', '150800');
INSERT INTO `area` VALUES ('150821', '五原县', '420', '150800');
INSERT INTO `area` VALUES ('150822', '磴口县', '421', '150800');
INSERT INTO `area` VALUES ('150823', '乌拉特前旗', '422', '150800');
INSERT INTO `area` VALUES ('150824', '乌拉特中旗', '423', '150800');
INSERT INTO `area` VALUES ('150825', '乌拉特后旗', '424', '150800');
INSERT INTO `area` VALUES ('150826', '杭锦后旗', '425', '150800');
INSERT INTO `area` VALUES ('150901', '市辖区', '426', '150900');
INSERT INTO `area` VALUES ('150902', '集宁区', '427', '150900');
INSERT INTO `area` VALUES ('150921', '卓资县', '428', '150900');
INSERT INTO `area` VALUES ('150922', '化德县', '429', '150900');
INSERT INTO `area` VALUES ('150923', '商都县', '430', '150900');
INSERT INTO `area` VALUES ('150924', '兴和县', '431', '150900');
INSERT INTO `area` VALUES ('150925', '凉城县', '432', '150900');
INSERT INTO `area` VALUES ('150926', '察哈尔右翼前旗', '433', '150900');
INSERT INTO `area` VALUES ('150927', '察哈尔右翼中旗', '434', '150900');
INSERT INTO `area` VALUES ('150928', '察哈尔右翼后旗', '435', '150900');
INSERT INTO `area` VALUES ('150929', '四子王旗', '436', '150900');
INSERT INTO `area` VALUES ('150981', '丰镇市', '437', '150900');
INSERT INTO `area` VALUES ('152201', '乌兰浩特市', '438', '152200');
INSERT INTO `area` VALUES ('152202', '阿尔山市', '439', '152200');
INSERT INTO `area` VALUES ('152221', '科尔沁右翼前旗', '440', '152200');
INSERT INTO `area` VALUES ('152222', '科尔沁右翼中旗', '441', '152200');
INSERT INTO `area` VALUES ('152223', '扎赉特旗', '442', '152200');
INSERT INTO `area` VALUES ('152224', '突泉县', '443', '152200');
INSERT INTO `area` VALUES ('152501', '二连浩特市', '444', '152500');
INSERT INTO `area` VALUES ('152502', '锡林浩特市', '445', '152500');
INSERT INTO `area` VALUES ('152522', '阿巴嘎旗', '446', '152500');
INSERT INTO `area` VALUES ('152523', '苏尼特左旗', '447', '152500');
INSERT INTO `area` VALUES ('152524', '苏尼特右旗', '448', '152500');
INSERT INTO `area` VALUES ('152525', '东乌珠穆沁旗', '449', '152500');
INSERT INTO `area` VALUES ('152526', '西乌珠穆沁旗', '450', '152500');
INSERT INTO `area` VALUES ('152527', '太仆寺旗', '451', '152500');
INSERT INTO `area` VALUES ('152528', '镶黄旗', '452', '152500');
INSERT INTO `area` VALUES ('152529', '正镶白旗', '453', '152500');
INSERT INTO `area` VALUES ('152530', '正蓝旗', '454', '152500');
INSERT INTO `area` VALUES ('152531', '多伦县', '455', '152500');
INSERT INTO `area` VALUES ('152921', '阿拉善左旗', '456', '152900');
INSERT INTO `area` VALUES ('152922', '阿拉善右旗', '457', '152900');
INSERT INTO `area` VALUES ('152923', '额济纳旗', '458', '152900');
INSERT INTO `area` VALUES ('210101', '市辖区', '459', '210100');
INSERT INTO `area` VALUES ('210102', '和平区', '460', '210100');
INSERT INTO `area` VALUES ('210103', '沈河区', '461', '210100');
INSERT INTO `area` VALUES ('210104', '大东区', '462', '210100');
INSERT INTO `area` VALUES ('210105', '皇姑区', '463', '210100');
INSERT INTO `area` VALUES ('210106', '铁西区', '464', '210100');
INSERT INTO `area` VALUES ('210111', '苏家屯区', '465', '210100');
INSERT INTO `area` VALUES ('210112', '东陵区', '466', '210100');
INSERT INTO `area` VALUES ('210113', '新城子区', '467', '210100');
INSERT INTO `area` VALUES ('210114', '于洪区', '468', '210100');
INSERT INTO `area` VALUES ('210122', '辽中县', '469', '210100');
INSERT INTO `area` VALUES ('210123', '康平县', '470', '210100');
INSERT INTO `area` VALUES ('210124', '法库县', '471', '210100');
INSERT INTO `area` VALUES ('210181', '新民市', '472', '210100');
INSERT INTO `area` VALUES ('210201', '市辖区', '473', '210200');
INSERT INTO `area` VALUES ('210202', '中山区', '474', '210200');
INSERT INTO `area` VALUES ('210203', '西岗区', '475', '210200');
INSERT INTO `area` VALUES ('210204', '沙河口区', '476', '210200');
INSERT INTO `area` VALUES ('210211', '甘井子区', '477', '210200');
INSERT INTO `area` VALUES ('210212', '旅顺口区', '478', '210200');
INSERT INTO `area` VALUES ('210213', '金州区', '479', '210200');
INSERT INTO `area` VALUES ('210224', '长海县', '480', '210200');
INSERT INTO `area` VALUES ('210281', '瓦房店市', '481', '210200');
INSERT INTO `area` VALUES ('210282', '普兰店市', '482', '210200');
INSERT INTO `area` VALUES ('210283', '庄河市', '483', '210200');
INSERT INTO `area` VALUES ('210301', '市辖区', '484', '210300');
INSERT INTO `area` VALUES ('210302', '铁东区', '485', '210300');
INSERT INTO `area` VALUES ('210303', '铁西区', '486', '210300');
INSERT INTO `area` VALUES ('210304', '立山区', '487', '210300');
INSERT INTO `area` VALUES ('210311', '千山区', '488', '210300');
INSERT INTO `area` VALUES ('210321', '台安县', '489', '210300');
INSERT INTO `area` VALUES ('210323', '岫岩满族自治县', '490', '210300');
INSERT INTO `area` VALUES ('210381', '海城市', '491', '210300');
INSERT INTO `area` VALUES ('210401', '市辖区', '492', '210400');
INSERT INTO `area` VALUES ('210402', '新抚区', '493', '210400');
INSERT INTO `area` VALUES ('210403', '东洲区', '494', '210400');
INSERT INTO `area` VALUES ('210404', '望花区', '495', '210400');
INSERT INTO `area` VALUES ('210411', '顺城区', '496', '210400');
INSERT INTO `area` VALUES ('210421', '抚顺县', '497', '210400');
INSERT INTO `area` VALUES ('210422', '新宾满族自治县', '498', '210400');
INSERT INTO `area` VALUES ('210423', '清原满族自治县', '499', '210400');
INSERT INTO `area` VALUES ('210501', '市辖区', '500', '210500');
INSERT INTO `area` VALUES ('210502', '平山区', '501', '210500');
INSERT INTO `area` VALUES ('210503', '溪湖区', '502', '210500');
INSERT INTO `area` VALUES ('210504', '明山区', '503', '210500');
INSERT INTO `area` VALUES ('210505', '南芬区', '504', '210500');
INSERT INTO `area` VALUES ('210521', '本溪满族自治县', '505', '210500');
INSERT INTO `area` VALUES ('210522', '桓仁满族自治县', '506', '210500');
INSERT INTO `area` VALUES ('210601', '市辖区', '507', '210600');
INSERT INTO `area` VALUES ('210602', '元宝区', '508', '210600');
INSERT INTO `area` VALUES ('210603', '振兴区', '509', '210600');
INSERT INTO `area` VALUES ('210604', '振安区', '510', '210600');
INSERT INTO `area` VALUES ('210624', '宽甸满族自治县', '511', '210600');
INSERT INTO `area` VALUES ('210681', '东港市', '512', '210600');
INSERT INTO `area` VALUES ('210682', '凤城市', '513', '210600');
INSERT INTO `area` VALUES ('210701', '市辖区', '514', '210700');
INSERT INTO `area` VALUES ('210702', '古塔区', '515', '210700');
INSERT INTO `area` VALUES ('210703', '凌河区', '516', '210700');
INSERT INTO `area` VALUES ('210711', '太和区', '517', '210700');
INSERT INTO `area` VALUES ('210726', '黑山县', '518', '210700');
INSERT INTO `area` VALUES ('210727', '义　县', '519', '210700');
INSERT INTO `area` VALUES ('210781', '凌海市', '520', '210700');
INSERT INTO `area` VALUES ('210782', '北宁市', '521', '210700');
INSERT INTO `area` VALUES ('210801', '市辖区', '522', '210800');
INSERT INTO `area` VALUES ('210802', '站前区', '523', '210800');
INSERT INTO `area` VALUES ('210803', '西市区', '524', '210800');
INSERT INTO `area` VALUES ('210804', '鲅鱼圈区', '525', '210800');
INSERT INTO `area` VALUES ('210811', '老边区', '526', '210800');
INSERT INTO `area` VALUES ('210881', '盖州市', '527', '210800');
INSERT INTO `area` VALUES ('210882', '大石桥市', '528', '210800');
INSERT INTO `area` VALUES ('210901', '市辖区', '529', '210900');
INSERT INTO `area` VALUES ('210902', '海州区', '530', '210900');
INSERT INTO `area` VALUES ('210903', '新邱区', '531', '210900');
INSERT INTO `area` VALUES ('210904', '太平区', '532', '210900');
INSERT INTO `area` VALUES ('210905', '清河门区', '533', '210900');
INSERT INTO `area` VALUES ('210911', '细河区', '534', '210900');
INSERT INTO `area` VALUES ('210921', '阜新蒙古族自治县', '535', '210900');
INSERT INTO `area` VALUES ('210922', '彰武县', '536', '210900');
INSERT INTO `area` VALUES ('211001', '市辖区', '537', '211000');
INSERT INTO `area` VALUES ('211002', '白塔区', '538', '211000');
INSERT INTO `area` VALUES ('211003', '文圣区', '539', '211000');
INSERT INTO `area` VALUES ('211004', '宏伟区', '540', '211000');
INSERT INTO `area` VALUES ('211005', '弓长岭区', '541', '211000');
INSERT INTO `area` VALUES ('211011', '太子河区', '542', '211000');
INSERT INTO `area` VALUES ('211021', '辽阳县', '543', '211000');
INSERT INTO `area` VALUES ('211081', '灯塔市', '544', '211000');
INSERT INTO `area` VALUES ('211101', '市辖区', '545', '211100');
INSERT INTO `area` VALUES ('211102', '双台子区', '546', '211100');
INSERT INTO `area` VALUES ('211103', '兴隆台区', '547', '211100');
INSERT INTO `area` VALUES ('211121', '大洼县', '548', '211100');
INSERT INTO `area` VALUES ('211122', '盘山县', '549', '211100');
INSERT INTO `area` VALUES ('211201', '市辖区', '550', '211200');
INSERT INTO `area` VALUES ('211202', '银州区', '551', '211200');
INSERT INTO `area` VALUES ('211204', '清河区', '552', '211200');
INSERT INTO `area` VALUES ('211221', '铁岭县', '553', '211200');
INSERT INTO `area` VALUES ('211223', '西丰县', '554', '211200');
INSERT INTO `area` VALUES ('211224', '昌图县', '555', '211200');
INSERT INTO `area` VALUES ('211281', '调兵山市', '556', '211200');
INSERT INTO `area` VALUES ('211282', '开原市', '557', '211200');
INSERT INTO `area` VALUES ('211301', '市辖区', '558', '211300');
INSERT INTO `area` VALUES ('211302', '双塔区', '559', '211300');
INSERT INTO `area` VALUES ('211303', '龙城区', '560', '211300');
INSERT INTO `area` VALUES ('211321', '朝阳县', '561', '211300');
INSERT INTO `area` VALUES ('211322', '建平县', '562', '211300');
INSERT INTO `area` VALUES ('211324', '喀喇沁左翼蒙古族自治县', '563', '211300');
INSERT INTO `area` VALUES ('211381', '北票市', '564', '211300');
INSERT INTO `area` VALUES ('211382', '凌源市', '565', '211300');
INSERT INTO `area` VALUES ('211401', '市辖区', '566', '211400');
INSERT INTO `area` VALUES ('211402', '连山区', '567', '211400');
INSERT INTO `area` VALUES ('211403', '龙港区', '568', '211400');
INSERT INTO `area` VALUES ('211404', '南票区', '569', '211400');
INSERT INTO `area` VALUES ('211421', '绥中县', '570', '211400');
INSERT INTO `area` VALUES ('211422', '建昌县', '571', '211400');
INSERT INTO `area` VALUES ('211481', '兴城市', '572', '211400');
INSERT INTO `area` VALUES ('220101', '市辖区', '573', '220100');
INSERT INTO `area` VALUES ('220102', '南关区', '574', '220100');
INSERT INTO `area` VALUES ('220103', '宽城区', '575', '220100');
INSERT INTO `area` VALUES ('220104', '朝阳区', '576', '220100');
INSERT INTO `area` VALUES ('220105', '二道区', '577', '220100');
INSERT INTO `area` VALUES ('220106', '绿园区', '578', '220100');
INSERT INTO `area` VALUES ('220112', '双阳区', '579', '220100');
INSERT INTO `area` VALUES ('220122', '农安县', '580', '220100');
INSERT INTO `area` VALUES ('220181', '九台市', '581', '220100');
INSERT INTO `area` VALUES ('220182', '榆树市', '582', '220100');
INSERT INTO `area` VALUES ('220183', '德惠市', '583', '220100');
INSERT INTO `area` VALUES ('220201', '市辖区', '584', '220200');
INSERT INTO `area` VALUES ('220202', '昌邑区', '585', '220200');
INSERT INTO `area` VALUES ('220203', '龙潭区', '586', '220200');
INSERT INTO `area` VALUES ('220204', '船营区', '587', '220200');
INSERT INTO `area` VALUES ('220211', '丰满区', '588', '220200');
INSERT INTO `area` VALUES ('220221', '永吉县', '589', '220200');
INSERT INTO `area` VALUES ('220281', '蛟河市', '590', '220200');
INSERT INTO `area` VALUES ('220282', '桦甸市', '591', '220200');
INSERT INTO `area` VALUES ('220283', '舒兰市', '592', '220200');
INSERT INTO `area` VALUES ('220284', '磐石市', '593', '220200');
INSERT INTO `area` VALUES ('220301', '市辖区', '594', '220300');
INSERT INTO `area` VALUES ('220302', '铁西区', '595', '220300');
INSERT INTO `area` VALUES ('220303', '铁东区', '596', '220300');
INSERT INTO `area` VALUES ('220322', '梨树县', '597', '220300');
INSERT INTO `area` VALUES ('220323', '伊通满族自治县', '598', '220300');
INSERT INTO `area` VALUES ('220381', '公主岭市', '599', '220300');
INSERT INTO `area` VALUES ('220382', '双辽市', '600', '220300');
INSERT INTO `area` VALUES ('220401', '市辖区', '601', '220400');
INSERT INTO `area` VALUES ('220402', '龙山区', '602', '220400');
INSERT INTO `area` VALUES ('220403', '西安区', '603', '220400');
INSERT INTO `area` VALUES ('220421', '东丰县', '604', '220400');
INSERT INTO `area` VALUES ('220422', '东辽县', '605', '220400');
INSERT INTO `area` VALUES ('220501', '市辖区', '606', '220500');
INSERT INTO `area` VALUES ('220502', '东昌区', '607', '220500');
INSERT INTO `area` VALUES ('220503', '二道江区', '608', '220500');
INSERT INTO `area` VALUES ('220521', '通化县', '609', '220500');
INSERT INTO `area` VALUES ('220523', '辉南县', '610', '220500');
INSERT INTO `area` VALUES ('220524', '柳河县', '611', '220500');
INSERT INTO `area` VALUES ('220581', '梅河口市', '612', '220500');
INSERT INTO `area` VALUES ('220582', '集安市', '613', '220500');
INSERT INTO `area` VALUES ('220601', '市辖区', '614', '220600');
INSERT INTO `area` VALUES ('220602', '八道江区', '615', '220600');
INSERT INTO `area` VALUES ('220621', '抚松县', '616', '220600');
INSERT INTO `area` VALUES ('220622', '靖宇县', '617', '220600');
INSERT INTO `area` VALUES ('220623', '长白朝鲜族自治县', '618', '220600');
INSERT INTO `area` VALUES ('220625', '江源县', '619', '220600');
INSERT INTO `area` VALUES ('220681', '临江市', '620', '220600');
INSERT INTO `area` VALUES ('220701', '市辖区', '621', '220700');
INSERT INTO `area` VALUES ('220702', '宁江区', '622', '220700');
INSERT INTO `area` VALUES ('220721', '前郭尔罗斯蒙古族自治县', '623', '220700');
INSERT INTO `area` VALUES ('220722', '长岭县', '624', '220700');
INSERT INTO `area` VALUES ('220723', '乾安县', '625', '220700');
INSERT INTO `area` VALUES ('220724', '扶余县', '626', '220700');
INSERT INTO `area` VALUES ('220801', '市辖区', '627', '220800');
INSERT INTO `area` VALUES ('220802', '洮北区', '628', '220800');
INSERT INTO `area` VALUES ('220821', '镇赉县', '629', '220800');
INSERT INTO `area` VALUES ('220822', '通榆县', '630', '220800');
INSERT INTO `area` VALUES ('220881', '洮南市', '631', '220800');
INSERT INTO `area` VALUES ('220882', '大安市', '632', '220800');
INSERT INTO `area` VALUES ('222401', '延吉市', '633', '222400');
INSERT INTO `area` VALUES ('222402', '图们市', '634', '222400');
INSERT INTO `area` VALUES ('222403', '敦化市', '635', '222400');
INSERT INTO `area` VALUES ('222404', '珲春市', '636', '222400');
INSERT INTO `area` VALUES ('222405', '龙井市', '637', '222400');
INSERT INTO `area` VALUES ('222406', '和龙市', '638', '222400');
INSERT INTO `area` VALUES ('222424', '汪清县', '639', '222400');
INSERT INTO `area` VALUES ('222426', '安图县', '640', '222400');
INSERT INTO `area` VALUES ('230101', '市辖区', '641', '230100');
INSERT INTO `area` VALUES ('230102', '道里区', '642', '230100');
INSERT INTO `area` VALUES ('230103', '南岗区', '643', '230100');
INSERT INTO `area` VALUES ('230104', '道外区', '644', '230100');
INSERT INTO `area` VALUES ('230106', '香坊区', '645', '230100');
INSERT INTO `area` VALUES ('230107', '动力区', '646', '230100');
INSERT INTO `area` VALUES ('230108', '平房区', '647', '230100');
INSERT INTO `area` VALUES ('230109', '松北区', '648', '230100');
INSERT INTO `area` VALUES ('230111', '呼兰区', '649', '230100');
INSERT INTO `area` VALUES ('230123', '依兰县', '650', '230100');
INSERT INTO `area` VALUES ('230124', '方正县', '651', '230100');
INSERT INTO `area` VALUES ('230125', '宾　县', '652', '230100');
INSERT INTO `area` VALUES ('230126', '巴彦县', '653', '230100');
INSERT INTO `area` VALUES ('230127', '木兰县', '654', '230100');
INSERT INTO `area` VALUES ('230128', '通河县', '655', '230100');
INSERT INTO `area` VALUES ('230129', '延寿县', '656', '230100');
INSERT INTO `area` VALUES ('230181', '阿城市', '657', '230100');
INSERT INTO `area` VALUES ('230182', '双城市', '658', '230100');
INSERT INTO `area` VALUES ('230183', '尚志市', '659', '230100');
INSERT INTO `area` VALUES ('230184', '五常市', '660', '230100');
INSERT INTO `area` VALUES ('230201', '市辖区', '661', '230200');
INSERT INTO `area` VALUES ('230202', '龙沙区', '662', '230200');
INSERT INTO `area` VALUES ('230203', '建华区', '663', '230200');
INSERT INTO `area` VALUES ('230204', '铁锋区', '664', '230200');
INSERT INTO `area` VALUES ('230205', '昂昂溪区', '665', '230200');
INSERT INTO `area` VALUES ('230206', '富拉尔基区', '666', '230200');
INSERT INTO `area` VALUES ('230207', '碾子山区', '667', '230200');
INSERT INTO `area` VALUES ('230208', '梅里斯达斡尔族区', '668', '230200');
INSERT INTO `area` VALUES ('230221', '龙江县', '669', '230200');
INSERT INTO `area` VALUES ('230223', '依安县', '670', '230200');
INSERT INTO `area` VALUES ('230224', '泰来县', '671', '230200');
INSERT INTO `area` VALUES ('230225', '甘南县', '672', '230200');
INSERT INTO `area` VALUES ('230227', '富裕县', '673', '230200');
INSERT INTO `area` VALUES ('230229', '克山县', '674', '230200');
INSERT INTO `area` VALUES ('230230', '克东县', '675', '230200');
INSERT INTO `area` VALUES ('230231', '拜泉县', '676', '230200');
INSERT INTO `area` VALUES ('230281', '讷河市', '677', '230200');
INSERT INTO `area` VALUES ('230301', '市辖区', '678', '230300');
INSERT INTO `area` VALUES ('230302', '鸡冠区', '679', '230300');
INSERT INTO `area` VALUES ('230303', '恒山区', '680', '230300');
INSERT INTO `area` VALUES ('230304', '滴道区', '681', '230300');
INSERT INTO `area` VALUES ('230305', '梨树区', '682', '230300');
INSERT INTO `area` VALUES ('230306', '城子河区', '683', '230300');
INSERT INTO `area` VALUES ('230307', '麻山区', '684', '230300');
INSERT INTO `area` VALUES ('230321', '鸡东县', '685', '230300');
INSERT INTO `area` VALUES ('230381', '虎林市', '686', '230300');
INSERT INTO `area` VALUES ('230382', '密山市', '687', '230300');
INSERT INTO `area` VALUES ('230401', '市辖区', '688', '230400');
INSERT INTO `area` VALUES ('230402', '向阳区', '689', '230400');
INSERT INTO `area` VALUES ('230403', '工农区', '690', '230400');
INSERT INTO `area` VALUES ('230404', '南山区', '691', '230400');
INSERT INTO `area` VALUES ('230405', '兴安区', '692', '230400');
INSERT INTO `area` VALUES ('230406', '东山区', '693', '230400');
INSERT INTO `area` VALUES ('230407', '兴山区', '694', '230400');
INSERT INTO `area` VALUES ('230421', '萝北县', '695', '230400');
INSERT INTO `area` VALUES ('230422', '绥滨县', '696', '230400');
INSERT INTO `area` VALUES ('230501', '市辖区', '697', '230500');
INSERT INTO `area` VALUES ('230502', '尖山区', '698', '230500');
INSERT INTO `area` VALUES ('230503', '岭东区', '699', '230500');
INSERT INTO `area` VALUES ('230505', '四方台区', '700', '230500');
INSERT INTO `area` VALUES ('230506', '宝山区', '701', '230500');
INSERT INTO `area` VALUES ('230521', '集贤县', '702', '230500');
INSERT INTO `area` VALUES ('230522', '友谊县', '703', '230500');
INSERT INTO `area` VALUES ('230523', '宝清县', '704', '230500');
INSERT INTO `area` VALUES ('230524', '饶河县', '705', '230500');
INSERT INTO `area` VALUES ('230601', '市辖区', '706', '230600');
INSERT INTO `area` VALUES ('230602', '萨尔图区', '707', '230600');
INSERT INTO `area` VALUES ('230603', '龙凤区', '708', '230600');
INSERT INTO `area` VALUES ('230604', '让胡路区', '709', '230600');
INSERT INTO `area` VALUES ('230605', '红岗区', '710', '230600');
INSERT INTO `area` VALUES ('230606', '大同区', '711', '230600');
INSERT INTO `area` VALUES ('230621', '肇州县', '712', '230600');
INSERT INTO `area` VALUES ('230622', '肇源县', '713', '230600');
INSERT INTO `area` VALUES ('230623', '林甸县', '714', '230600');
INSERT INTO `area` VALUES ('230624', '杜尔伯特蒙古族自治县', '715', '230600');
INSERT INTO `area` VALUES ('230701', '市辖区', '716', '230700');
INSERT INTO `area` VALUES ('230702', '伊春区', '717', '230700');
INSERT INTO `area` VALUES ('230703', '南岔区', '718', '230700');
INSERT INTO `area` VALUES ('230704', '友好区', '719', '230700');
INSERT INTO `area` VALUES ('230705', '西林区', '720', '230700');
INSERT INTO `area` VALUES ('230706', '翠峦区', '721', '230700');
INSERT INTO `area` VALUES ('230707', '新青区', '722', '230700');
INSERT INTO `area` VALUES ('230708', '美溪区', '723', '230700');
INSERT INTO `area` VALUES ('230709', '金山屯区', '724', '230700');
INSERT INTO `area` VALUES ('230710', '五营区', '725', '230700');
INSERT INTO `area` VALUES ('230711', '乌马河区', '726', '230700');
INSERT INTO `area` VALUES ('230712', '汤旺河区', '727', '230700');
INSERT INTO `area` VALUES ('230713', '带岭区', '728', '230700');
INSERT INTO `area` VALUES ('230714', '乌伊岭区', '729', '230700');
INSERT INTO `area` VALUES ('230715', '红星区', '730', '230700');
INSERT INTO `area` VALUES ('230716', '上甘岭区', '731', '230700');
INSERT INTO `area` VALUES ('230722', '嘉荫县', '732', '230700');
INSERT INTO `area` VALUES ('230781', '铁力市', '733', '230700');
INSERT INTO `area` VALUES ('230801', '市辖区', '734', '230800');
INSERT INTO `area` VALUES ('230802', '永红区', '735', '230800');
INSERT INTO `area` VALUES ('230803', '向阳区', '736', '230800');
INSERT INTO `area` VALUES ('230804', '前进区', '737', '230800');
INSERT INTO `area` VALUES ('230805', '东风区', '738', '230800');
INSERT INTO `area` VALUES ('230811', '郊　区', '739', '230800');
INSERT INTO `area` VALUES ('230822', '桦南县', '740', '230800');
INSERT INTO `area` VALUES ('230826', '桦川县', '741', '230800');
INSERT INTO `area` VALUES ('230828', '汤原县', '742', '230800');
INSERT INTO `area` VALUES ('230833', '抚远县', '743', '230800');
INSERT INTO `area` VALUES ('230881', '同江市', '744', '230800');
INSERT INTO `area` VALUES ('230882', '富锦市', '745', '230800');
INSERT INTO `area` VALUES ('230901', '市辖区', '746', '230900');
INSERT INTO `area` VALUES ('230902', '新兴区', '747', '230900');
INSERT INTO `area` VALUES ('230903', '桃山区', '748', '230900');
INSERT INTO `area` VALUES ('230904', '茄子河区', '749', '230900');
INSERT INTO `area` VALUES ('230921', '勃利县', '750', '230900');
INSERT INTO `area` VALUES ('231001', '市辖区', '751', '231000');
INSERT INTO `area` VALUES ('231002', '东安区', '752', '231000');
INSERT INTO `area` VALUES ('231003', '阳明区', '753', '231000');
INSERT INTO `area` VALUES ('231004', '爱民区', '754', '231000');
INSERT INTO `area` VALUES ('231005', '西安区', '755', '231000');
INSERT INTO `area` VALUES ('231024', '东宁县', '756', '231000');
INSERT INTO `area` VALUES ('231025', '林口县', '757', '231000');
INSERT INTO `area` VALUES ('231081', '绥芬河市', '758', '231000');
INSERT INTO `area` VALUES ('231083', '海林市', '759', '231000');
INSERT INTO `area` VALUES ('231084', '宁安市', '760', '231000');
INSERT INTO `area` VALUES ('231085', '穆棱市', '761', '231000');
INSERT INTO `area` VALUES ('231101', '市辖区', '762', '231100');
INSERT INTO `area` VALUES ('231102', '爱辉区', '763', '231100');
INSERT INTO `area` VALUES ('231121', '嫩江县', '764', '231100');
INSERT INTO `area` VALUES ('231123', '逊克县', '765', '231100');
INSERT INTO `area` VALUES ('231124', '孙吴县', '766', '231100');
INSERT INTO `area` VALUES ('231181', '北安市', '767', '231100');
INSERT INTO `area` VALUES ('231182', '五大连池市', '768', '231100');
INSERT INTO `area` VALUES ('231201', '市辖区', '769', '231200');
INSERT INTO `area` VALUES ('231202', '北林区', '770', '231200');
INSERT INTO `area` VALUES ('231221', '望奎县', '771', '231200');
INSERT INTO `area` VALUES ('231222', '兰西县', '772', '231200');
INSERT INTO `area` VALUES ('231223', '青冈县', '773', '231200');
INSERT INTO `area` VALUES ('231224', '庆安县', '774', '231200');
INSERT INTO `area` VALUES ('231225', '明水县', '775', '231200');
INSERT INTO `area` VALUES ('231226', '绥棱县', '776', '231200');
INSERT INTO `area` VALUES ('231281', '安达市', '777', '231200');
INSERT INTO `area` VALUES ('231282', '肇东市', '778', '231200');
INSERT INTO `area` VALUES ('231283', '海伦市', '779', '231200');
INSERT INTO `area` VALUES ('232721', '呼玛县', '780', '232700');
INSERT INTO `area` VALUES ('232722', '塔河县', '781', '232700');
INSERT INTO `area` VALUES ('232723', '漠河县', '782', '232700');
INSERT INTO `area` VALUES ('310101', '黄浦区', '783', '310100');
INSERT INTO `area` VALUES ('310103', '卢湾区', '784', '310100');
INSERT INTO `area` VALUES ('310104', '徐汇区', '785', '310100');
INSERT INTO `area` VALUES ('310105', '长宁区', '786', '310100');
INSERT INTO `area` VALUES ('310106', '静安区', '787', '310100');
INSERT INTO `area` VALUES ('310107', '普陀区', '788', '310100');
INSERT INTO `area` VALUES ('310108', '闸北区', '789', '310100');
INSERT INTO `area` VALUES ('310109', '虹口区', '790', '310100');
INSERT INTO `area` VALUES ('310110', '杨浦区', '791', '310100');
INSERT INTO `area` VALUES ('310112', '闵行区', '792', '310100');
INSERT INTO `area` VALUES ('310113', '宝山区', '793', '310100');
INSERT INTO `area` VALUES ('310114', '嘉定区', '794', '310100');
INSERT INTO `area` VALUES ('310115', '浦东新区', '795', '310100');
INSERT INTO `area` VALUES ('310116', '金山区', '796', '310100');
INSERT INTO `area` VALUES ('310117', '松江区', '797', '310100');
INSERT INTO `area` VALUES ('310118', '青浦区', '798', '310100');
INSERT INTO `area` VALUES ('310119', '南汇区', '799', '310100');
INSERT INTO `area` VALUES ('310120', '奉贤区', '800', '310100');
INSERT INTO `area` VALUES ('310230', '崇明县', '801', '310200');
INSERT INTO `area` VALUES ('320101', '市辖区', '802', '320100');
INSERT INTO `area` VALUES ('320102', '玄武区', '803', '320100');
INSERT INTO `area` VALUES ('320103', '白下区', '804', '320100');
INSERT INTO `area` VALUES ('320104', '秦淮区', '805', '320100');
INSERT INTO `area` VALUES ('320105', '建邺区', '806', '320100');
INSERT INTO `area` VALUES ('320106', '鼓楼区', '807', '320100');
INSERT INTO `area` VALUES ('320107', '下关区', '808', '320100');
INSERT INTO `area` VALUES ('320111', '浦口区', '809', '320100');
INSERT INTO `area` VALUES ('320113', '栖霞区', '810', '320100');
INSERT INTO `area` VALUES ('320114', '雨花台区', '811', '320100');
INSERT INTO `area` VALUES ('320115', '江宁区', '812', '320100');
INSERT INTO `area` VALUES ('320116', '六合区', '813', '320100');
INSERT INTO `area` VALUES ('320124', '溧水县', '814', '320100');
INSERT INTO `area` VALUES ('320125', '高淳县', '815', '320100');
INSERT INTO `area` VALUES ('320201', '市辖区', '816', '320200');
INSERT INTO `area` VALUES ('320202', '崇安区', '817', '320200');
INSERT INTO `area` VALUES ('320203', '南长区', '818', '320200');
INSERT INTO `area` VALUES ('320204', '北塘区', '819', '320200');
INSERT INTO `area` VALUES ('320205', '锡山区', '820', '320200');
INSERT INTO `area` VALUES ('320206', '惠山区', '821', '320200');
INSERT INTO `area` VALUES ('320211', '滨湖区', '822', '320200');
INSERT INTO `area` VALUES ('320281', '江阴市', '823', '320200');
INSERT INTO `area` VALUES ('320282', '宜兴市', '824', '320200');
INSERT INTO `area` VALUES ('320301', '市辖区', '825', '320300');
INSERT INTO `area` VALUES ('320302', '鼓楼区', '826', '320300');
INSERT INTO `area` VALUES ('320303', '云龙区', '827', '320300');
INSERT INTO `area` VALUES ('320304', '九里区', '828', '320300');
INSERT INTO `area` VALUES ('320305', '贾汪区', '829', '320300');
INSERT INTO `area` VALUES ('320311', '泉山区', '830', '320300');
INSERT INTO `area` VALUES ('320321', '丰　县', '831', '320300');
INSERT INTO `area` VALUES ('320322', '沛　县', '832', '320300');
INSERT INTO `area` VALUES ('320323', '铜山县', '833', '320300');
INSERT INTO `area` VALUES ('320324', '睢宁县', '834', '320300');
INSERT INTO `area` VALUES ('320381', '新沂市', '835', '320300');
INSERT INTO `area` VALUES ('320382', '邳州市', '836', '320300');
INSERT INTO `area` VALUES ('320401', '市辖区', '837', '320400');
INSERT INTO `area` VALUES ('320402', '天宁区', '838', '320400');
INSERT INTO `area` VALUES ('320404', '钟楼区', '839', '320400');
INSERT INTO `area` VALUES ('320405', '戚墅堰区', '840', '320400');
INSERT INTO `area` VALUES ('320411', '新北区', '841', '320400');
INSERT INTO `area` VALUES ('320412', '武进区', '842', '320400');
INSERT INTO `area` VALUES ('320481', '溧阳市', '843', '320400');
INSERT INTO `area` VALUES ('320482', '金坛市', '844', '320400');
INSERT INTO `area` VALUES ('320501', '市辖区', '845', '320500');
INSERT INTO `area` VALUES ('320502', '沧浪区', '846', '320500');
INSERT INTO `area` VALUES ('320503', '平江区', '847', '320500');
INSERT INTO `area` VALUES ('320504', '金阊区', '848', '320500');
INSERT INTO `area` VALUES ('320505', '虎丘区', '849', '320500');
INSERT INTO `area` VALUES ('320506', '吴中区', '850', '320500');
INSERT INTO `area` VALUES ('320507', '相城区', '851', '320500');
INSERT INTO `area` VALUES ('320581', '常熟市', '852', '320500');
INSERT INTO `area` VALUES ('320582', '张家港市', '853', '320500');
INSERT INTO `area` VALUES ('320583', '昆山市', '854', '320500');
INSERT INTO `area` VALUES ('320584', '吴江市', '855', '320500');
INSERT INTO `area` VALUES ('320585', '太仓市', '856', '320500');
INSERT INTO `area` VALUES ('320601', '市辖区', '857', '320600');
INSERT INTO `area` VALUES ('320602', '崇川区', '858', '320600');
INSERT INTO `area` VALUES ('320611', '港闸区', '859', '320600');
INSERT INTO `area` VALUES ('320621', '海安县', '860', '320600');
INSERT INTO `area` VALUES ('320623', '如东县', '861', '320600');
INSERT INTO `area` VALUES ('320681', '启东市', '862', '320600');
INSERT INTO `area` VALUES ('320682', '如皋市', '863', '320600');
INSERT INTO `area` VALUES ('320683', '通州市', '864', '320600');
INSERT INTO `area` VALUES ('320684', '海门市', '865', '320600');
INSERT INTO `area` VALUES ('320701', '市辖区', '866', '320700');
INSERT INTO `area` VALUES ('320703', '连云区', '867', '320700');
INSERT INTO `area` VALUES ('320705', '新浦区', '868', '320700');
INSERT INTO `area` VALUES ('320706', '海州区', '869', '320700');
INSERT INTO `area` VALUES ('320721', '赣榆县', '870', '320700');
INSERT INTO `area` VALUES ('320722', '东海县', '871', '320700');
INSERT INTO `area` VALUES ('320723', '灌云县', '872', '320700');
INSERT INTO `area` VALUES ('320724', '灌南县', '873', '320700');
INSERT INTO `area` VALUES ('320801', '市辖区', '874', '320800');
INSERT INTO `area` VALUES ('320802', '清河区', '875', '320800');
INSERT INTO `area` VALUES ('320803', '楚州区', '876', '320800');
INSERT INTO `area` VALUES ('320804', '淮阴区', '877', '320800');
INSERT INTO `area` VALUES ('320811', '清浦区', '878', '320800');
INSERT INTO `area` VALUES ('320826', '涟水县', '879', '320800');
INSERT INTO `area` VALUES ('320829', '洪泽县', '880', '320800');
INSERT INTO `area` VALUES ('320830', '盱眙县', '881', '320800');
INSERT INTO `area` VALUES ('320831', '金湖县', '882', '320800');
INSERT INTO `area` VALUES ('320901', '市辖区', '883', '320900');
INSERT INTO `area` VALUES ('320902', '亭湖区', '884', '320900');
INSERT INTO `area` VALUES ('320903', '盐都区', '885', '320900');
INSERT INTO `area` VALUES ('320921', '响水县', '886', '320900');
INSERT INTO `area` VALUES ('320922', '滨海县', '887', '320900');
INSERT INTO `area` VALUES ('320923', '阜宁县', '888', '320900');
INSERT INTO `area` VALUES ('320924', '射阳县', '889', '320900');
INSERT INTO `area` VALUES ('320925', '建湖县', '890', '320900');
INSERT INTO `area` VALUES ('320981', '东台市', '891', '320900');
INSERT INTO `area` VALUES ('320982', '大丰市', '892', '320900');
INSERT INTO `area` VALUES ('321001', '市辖区', '893', '321000');
INSERT INTO `area` VALUES ('321002', '广陵区', '894', '321000');
INSERT INTO `area` VALUES ('321003', '邗江区', '895', '321000');
INSERT INTO `area` VALUES ('321011', '郊　区', '896', '321000');
INSERT INTO `area` VALUES ('321023', '宝应县', '897', '321000');
INSERT INTO `area` VALUES ('321081', '仪征市', '898', '321000');
INSERT INTO `area` VALUES ('321084', '高邮市', '899', '321000');
INSERT INTO `area` VALUES ('321088', '江都市', '900', '321000');
INSERT INTO `area` VALUES ('321101', '市辖区', '901', '321100');
INSERT INTO `area` VALUES ('321102', '京口区', '902', '321100');
INSERT INTO `area` VALUES ('321111', '润州区', '903', '321100');
INSERT INTO `area` VALUES ('321112', '丹徒区', '904', '321100');
INSERT INTO `area` VALUES ('321181', '丹阳市', '905', '321100');
INSERT INTO `area` VALUES ('321182', '扬中市', '906', '321100');
INSERT INTO `area` VALUES ('321183', '句容市', '907', '321100');
INSERT INTO `area` VALUES ('321201', '市辖区', '908', '321200');
INSERT INTO `area` VALUES ('321202', '海陵区', '909', '321200');
INSERT INTO `area` VALUES ('321203', '高港区', '910', '321200');
INSERT INTO `area` VALUES ('321281', '兴化市', '911', '321200');
INSERT INTO `area` VALUES ('321282', '靖江市', '912', '321200');
INSERT INTO `area` VALUES ('321283', '泰兴市', '913', '321200');
INSERT INTO `area` VALUES ('321284', '姜堰市', '914', '321200');
INSERT INTO `area` VALUES ('321301', '市辖区', '915', '321300');
INSERT INTO `area` VALUES ('321302', '宿城区', '916', '321300');
INSERT INTO `area` VALUES ('321311', '宿豫区', '917', '321300');
INSERT INTO `area` VALUES ('321322', '沭阳县', '918', '321300');
INSERT INTO `area` VALUES ('321323', '泗阳县', '919', '321300');
INSERT INTO `area` VALUES ('321324', '泗洪县', '920', '321300');
INSERT INTO `area` VALUES ('330101', '市辖区', '921', '330100');
INSERT INTO `area` VALUES ('330102', '上城区', '922', '330100');
INSERT INTO `area` VALUES ('330103', '下城区', '923', '330100');
INSERT INTO `area` VALUES ('330104', '江干区', '924', '330100');
INSERT INTO `area` VALUES ('330105', '拱墅区', '925', '330100');
INSERT INTO `area` VALUES ('330106', '西湖区', '926', '330100');
INSERT INTO `area` VALUES ('330108', '滨江区', '927', '330100');
INSERT INTO `area` VALUES ('330109', '萧山区', '928', '330100');
INSERT INTO `area` VALUES ('330110', '余杭区', '929', '330100');
INSERT INTO `area` VALUES ('330122', '桐庐县', '930', '330100');
INSERT INTO `area` VALUES ('330127', '淳安县', '931', '330100');
INSERT INTO `area` VALUES ('330182', '建德市', '932', '330100');
INSERT INTO `area` VALUES ('330183', '富阳市', '933', '330100');
INSERT INTO `area` VALUES ('330185', '临安市', '934', '330100');
INSERT INTO `area` VALUES ('330201', '市辖区', '935', '330200');
INSERT INTO `area` VALUES ('330203', '海曙区', '936', '330200');
INSERT INTO `area` VALUES ('330204', '江东区', '937', '330200');
INSERT INTO `area` VALUES ('330205', '江北区', '938', '330200');
INSERT INTO `area` VALUES ('330206', '北仑区', '939', '330200');
INSERT INTO `area` VALUES ('330211', '镇海区', '940', '330200');
INSERT INTO `area` VALUES ('330212', '鄞州区', '941', '330200');
INSERT INTO `area` VALUES ('330225', '象山县', '942', '330200');
INSERT INTO `area` VALUES ('330226', '宁海县', '943', '330200');
INSERT INTO `area` VALUES ('330281', '余姚市', '944', '330200');
INSERT INTO `area` VALUES ('330282', '慈溪市', '945', '330200');
INSERT INTO `area` VALUES ('330283', '奉化市', '946', '330200');
INSERT INTO `area` VALUES ('330301', '市辖区', '947', '330300');
INSERT INTO `area` VALUES ('330302', '鹿城区', '948', '330300');
INSERT INTO `area` VALUES ('330303', '龙湾区', '949', '330300');
INSERT INTO `area` VALUES ('330304', '瓯海区', '950', '330300');
INSERT INTO `area` VALUES ('330322', '洞头县', '951', '330300');
INSERT INTO `area` VALUES ('330324', '永嘉县', '952', '330300');
INSERT INTO `area` VALUES ('330326', '平阳县', '953', '330300');
INSERT INTO `area` VALUES ('330327', '苍南县', '954', '330300');
INSERT INTO `area` VALUES ('330328', '文成县', '955', '330300');
INSERT INTO `area` VALUES ('330329', '泰顺县', '956', '330300');
INSERT INTO `area` VALUES ('330381', '瑞安市', '957', '330300');
INSERT INTO `area` VALUES ('330382', '乐清市', '958', '330300');
INSERT INTO `area` VALUES ('330401', '市辖区', '959', '330400');
INSERT INTO `area` VALUES ('330402', '秀城区', '960', '330400');
INSERT INTO `area` VALUES ('330411', '秀洲区', '961', '330400');
INSERT INTO `area` VALUES ('330421', '嘉善县', '962', '330400');
INSERT INTO `area` VALUES ('330424', '海盐县', '963', '330400');
INSERT INTO `area` VALUES ('330481', '海宁市', '964', '330400');
INSERT INTO `area` VALUES ('330482', '平湖市', '965', '330400');
INSERT INTO `area` VALUES ('330483', '桐乡市', '966', '330400');
INSERT INTO `area` VALUES ('330501', '市辖区', '967', '330500');
INSERT INTO `area` VALUES ('330502', '吴兴区', '968', '330500');
INSERT INTO `area` VALUES ('330503', '南浔区', '969', '330500');
INSERT INTO `area` VALUES ('330521', '德清县', '970', '330500');
INSERT INTO `area` VALUES ('330522', '长兴县', '971', '330500');
INSERT INTO `area` VALUES ('330523', '安吉县', '972', '330500');
INSERT INTO `area` VALUES ('330601', '市辖区', '973', '330600');
INSERT INTO `area` VALUES ('330602', '越城区', '974', '330600');
INSERT INTO `area` VALUES ('330621', '绍兴县', '975', '330600');
INSERT INTO `area` VALUES ('330624', '新昌县', '976', '330600');
INSERT INTO `area` VALUES ('330681', '诸暨市', '977', '330600');
INSERT INTO `area` VALUES ('330682', '上虞市', '978', '330600');
INSERT INTO `area` VALUES ('330683', '嵊州市', '979', '330600');
INSERT INTO `area` VALUES ('330701', '市辖区', '980', '330700');
INSERT INTO `area` VALUES ('330702', '婺城区', '981', '330700');
INSERT INTO `area` VALUES ('330703', '金东区', '982', '330700');
INSERT INTO `area` VALUES ('330723', '武义县', '983', '330700');
INSERT INTO `area` VALUES ('330726', '浦江县', '984', '330700');
INSERT INTO `area` VALUES ('330727', '磐安县', '985', '330700');
INSERT INTO `area` VALUES ('330781', '兰溪市', '986', '330700');
INSERT INTO `area` VALUES ('330782', '义乌市', '987', '330700');
INSERT INTO `area` VALUES ('330783', '东阳市', '988', '330700');
INSERT INTO `area` VALUES ('330784', '永康市', '989', '330700');
INSERT INTO `area` VALUES ('330801', '市辖区', '990', '330800');
INSERT INTO `area` VALUES ('330802', '柯城区', '991', '330800');
INSERT INTO `area` VALUES ('330803', '衢江区', '992', '330800');
INSERT INTO `area` VALUES ('330822', '常山县', '993', '330800');
INSERT INTO `area` VALUES ('330824', '开化县', '994', '330800');
INSERT INTO `area` VALUES ('330825', '龙游县', '995', '330800');
INSERT INTO `area` VALUES ('330881', '江山市', '996', '330800');
INSERT INTO `area` VALUES ('330901', '市辖区', '997', '330900');
INSERT INTO `area` VALUES ('330902', '定海区', '998', '330900');
INSERT INTO `area` VALUES ('330903', '普陀区', '999', '330900');
INSERT INTO `area` VALUES ('330921', '岱山县', '1000', '330900');
INSERT INTO `area` VALUES ('330922', '嵊泗县', '1001', '330900');
INSERT INTO `area` VALUES ('331001', '市辖区', '1002', '331000');
INSERT INTO `area` VALUES ('331002', '椒江区', '1003', '331000');
INSERT INTO `area` VALUES ('331003', '黄岩区', '1004', '331000');
INSERT INTO `area` VALUES ('331004', '路桥区', '1005', '331000');
INSERT INTO `area` VALUES ('331021', '玉环县', '1006', '331000');
INSERT INTO `area` VALUES ('331022', '三门县', '1007', '331000');
INSERT INTO `area` VALUES ('331023', '天台县', '1008', '331000');
INSERT INTO `area` VALUES ('331024', '仙居县', '1009', '331000');
INSERT INTO `area` VALUES ('331081', '温岭市', '1010', '331000');
INSERT INTO `area` VALUES ('331082', '临海市', '1011', '331000');
INSERT INTO `area` VALUES ('331101', '市辖区', '1012', '331100');
INSERT INTO `area` VALUES ('331102', '莲都区', '1013', '331100');
INSERT INTO `area` VALUES ('331121', '青田县', '1014', '331100');
INSERT INTO `area` VALUES ('331122', '缙云县', '1015', '331100');
INSERT INTO `area` VALUES ('331123', '遂昌县', '1016', '331100');
INSERT INTO `area` VALUES ('331124', '松阳县', '1017', '331100');
INSERT INTO `area` VALUES ('331125', '云和县', '1018', '331100');
INSERT INTO `area` VALUES ('331126', '庆元县', '1019', '331100');
INSERT INTO `area` VALUES ('331127', '景宁畲族自治县', '1020', '331100');
INSERT INTO `area` VALUES ('331181', '龙泉市', '1021', '331100');
INSERT INTO `area` VALUES ('340101', '市辖区', '1022', '340100');
INSERT INTO `area` VALUES ('340102', '瑶海区', '1023', '340100');
INSERT INTO `area` VALUES ('340103', '庐阳区', '1024', '340100');
INSERT INTO `area` VALUES ('340104', '蜀山区', '1025', '340100');
INSERT INTO `area` VALUES ('340111', '包河区', '1026', '340100');
INSERT INTO `area` VALUES ('340121', '长丰县', '1027', '340100');
INSERT INTO `area` VALUES ('340122', '肥东县', '1028', '340100');
INSERT INTO `area` VALUES ('340123', '肥西县', '1029', '340100');
INSERT INTO `area` VALUES ('340201', '市辖区', '1030', '340200');
INSERT INTO `area` VALUES ('340202', '镜湖区', '1031', '340200');
INSERT INTO `area` VALUES ('340203', '马塘区', '1032', '340200');
INSERT INTO `area` VALUES ('340204', '新芜区', '1033', '340200');
INSERT INTO `area` VALUES ('340207', '鸠江区', '1034', '340200');
INSERT INTO `area` VALUES ('340221', '芜湖县', '1035', '340200');
INSERT INTO `area` VALUES ('340222', '繁昌县', '1036', '340200');
INSERT INTO `area` VALUES ('340223', '南陵县', '1037', '340200');
INSERT INTO `area` VALUES ('340301', '市辖区', '1038', '340300');
INSERT INTO `area` VALUES ('340302', '龙子湖区', '1039', '340300');
INSERT INTO `area` VALUES ('340303', '蚌山区', '1040', '340300');
INSERT INTO `area` VALUES ('340304', '禹会区', '1041', '340300');
INSERT INTO `area` VALUES ('340311', '淮上区', '1042', '340300');
INSERT INTO `area` VALUES ('340321', '怀远县', '1043', '340300');
INSERT INTO `area` VALUES ('340322', '五河县', '1044', '340300');
INSERT INTO `area` VALUES ('340323', '固镇县', '1045', '340300');
INSERT INTO `area` VALUES ('340401', '市辖区', '1046', '340400');
INSERT INTO `area` VALUES ('340402', '大通区', '1047', '340400');
INSERT INTO `area` VALUES ('340403', '田家庵区', '1048', '340400');
INSERT INTO `area` VALUES ('340404', '谢家集区', '1049', '340400');
INSERT INTO `area` VALUES ('340405', '八公山区', '1050', '340400');
INSERT INTO `area` VALUES ('340406', '潘集区', '1051', '340400');
INSERT INTO `area` VALUES ('340421', '凤台县', '1052', '340400');
INSERT INTO `area` VALUES ('340501', '市辖区', '1053', '340500');
INSERT INTO `area` VALUES ('340502', '金家庄区', '1054', '340500');
INSERT INTO `area` VALUES ('340503', '花山区', '1055', '340500');
INSERT INTO `area` VALUES ('340504', '雨山区', '1056', '340500');
INSERT INTO `area` VALUES ('340521', '当涂县', '1057', '340500');
INSERT INTO `area` VALUES ('340601', '市辖区', '1058', '340600');
INSERT INTO `area` VALUES ('340602', '杜集区', '1059', '340600');
INSERT INTO `area` VALUES ('340603', '相山区', '1060', '340600');
INSERT INTO `area` VALUES ('340604', '烈山区', '1061', '340600');
INSERT INTO `area` VALUES ('340621', '濉溪县', '1062', '340600');
INSERT INTO `area` VALUES ('340701', '市辖区', '1063', '340700');
INSERT INTO `area` VALUES ('340702', '铜官山区', '1064', '340700');
INSERT INTO `area` VALUES ('340703', '狮子山区', '1065', '340700');
INSERT INTO `area` VALUES ('340711', '郊　区', '1066', '340700');
INSERT INTO `area` VALUES ('340721', '铜陵县', '1067', '340700');
INSERT INTO `area` VALUES ('340801', '市辖区', '1068', '340800');
INSERT INTO `area` VALUES ('340802', '迎江区', '1069', '340800');
INSERT INTO `area` VALUES ('340803', '大观区', '1070', '340800');
INSERT INTO `area` VALUES ('340811', '郊　区', '1071', '340800');
INSERT INTO `area` VALUES ('340822', '怀宁县', '1072', '340800');
INSERT INTO `area` VALUES ('340823', '枞阳县', '1073', '340800');
INSERT INTO `area` VALUES ('340824', '潜山县', '1074', '340800');
INSERT INTO `area` VALUES ('340825', '太湖县', '1075', '340800');
INSERT INTO `area` VALUES ('340826', '宿松县', '1076', '340800');
INSERT INTO `area` VALUES ('340827', '望江县', '1077', '340800');
INSERT INTO `area` VALUES ('340828', '岳西县', '1078', '340800');
INSERT INTO `area` VALUES ('340881', '桐城市', '1079', '340800');
INSERT INTO `area` VALUES ('341001', '市辖区', '1080', '341000');
INSERT INTO `area` VALUES ('341002', '屯溪区', '1081', '341000');
INSERT INTO `area` VALUES ('341003', '黄山区', '1082', '341000');
INSERT INTO `area` VALUES ('341004', '徽州区', '1083', '341000');
INSERT INTO `area` VALUES ('341021', '歙　县', '1084', '341000');
INSERT INTO `area` VALUES ('341022', '休宁县', '1085', '341000');
INSERT INTO `area` VALUES ('341023', '黟　县', '1086', '341000');
INSERT INTO `area` VALUES ('341024', '祁门县', '1087', '341000');
INSERT INTO `area` VALUES ('341101', '市辖区', '1088', '341100');
INSERT INTO `area` VALUES ('341102', '琅琊区', '1089', '341100');
INSERT INTO `area` VALUES ('341103', '南谯区', '1090', '341100');
INSERT INTO `area` VALUES ('341122', '来安县', '1091', '341100');
INSERT INTO `area` VALUES ('341124', '全椒县', '1092', '341100');
INSERT INTO `area` VALUES ('341125', '定远县', '1093', '341100');
INSERT INTO `area` VALUES ('341126', '凤阳县', '1094', '341100');
INSERT INTO `area` VALUES ('341181', '天长市', '1095', '341100');
INSERT INTO `area` VALUES ('341182', '明光市', '1096', '341100');
INSERT INTO `area` VALUES ('341201', '市辖区', '1097', '341200');
INSERT INTO `area` VALUES ('341202', '颍州区', '1098', '341200');
INSERT INTO `area` VALUES ('341203', '颍东区', '1099', '341200');
INSERT INTO `area` VALUES ('341204', '颍泉区', '1100', '341200');
INSERT INTO `area` VALUES ('341221', '临泉县', '1101', '341200');
INSERT INTO `area` VALUES ('341222', '太和县', '1102', '341200');
INSERT INTO `area` VALUES ('341225', '阜南县', '1103', '341200');
INSERT INTO `area` VALUES ('341226', '颍上县', '1104', '341200');
INSERT INTO `area` VALUES ('341282', '界首市', '1105', '341200');
INSERT INTO `area` VALUES ('341301', '市辖区', '1106', '341300');
INSERT INTO `area` VALUES ('341302', '墉桥区', '1107', '341300');
INSERT INTO `area` VALUES ('341321', '砀山县', '1108', '341300');
INSERT INTO `area` VALUES ('341322', '萧　县', '1109', '341300');
INSERT INTO `area` VALUES ('341323', '灵璧县', '1110', '341300');
INSERT INTO `area` VALUES ('341324', '泗　县', '1111', '341300');
INSERT INTO `area` VALUES ('341401', '市辖区', '1112', '341400');
INSERT INTO `area` VALUES ('341402', '居巢区', '1113', '341400');
INSERT INTO `area` VALUES ('341421', '庐江县', '1114', '341400');
INSERT INTO `area` VALUES ('341422', '无为县', '1115', '341400');
INSERT INTO `area` VALUES ('341423', '含山县', '1116', '341400');
INSERT INTO `area` VALUES ('341424', '和　县', '1117', '341400');
INSERT INTO `area` VALUES ('341501', '市辖区', '1118', '341500');
INSERT INTO `area` VALUES ('341502', '金安区', '1119', '341500');
INSERT INTO `area` VALUES ('341503', '裕安区', '1120', '341500');
INSERT INTO `area` VALUES ('341521', '寿　县', '1121', '341500');
INSERT INTO `area` VALUES ('341522', '霍邱县', '1122', '341500');
INSERT INTO `area` VALUES ('341523', '舒城县', '1123', '341500');
INSERT INTO `area` VALUES ('341524', '金寨县', '1124', '341500');
INSERT INTO `area` VALUES ('341525', '霍山县', '1125', '341500');
INSERT INTO `area` VALUES ('341601', '市辖区', '1126', '341600');
INSERT INTO `area` VALUES ('341602', '谯城区', '1127', '341600');
INSERT INTO `area` VALUES ('341621', '涡阳县', '1128', '341600');
INSERT INTO `area` VALUES ('341622', '蒙城县', '1129', '341600');
INSERT INTO `area` VALUES ('341623', '利辛县', '1130', '341600');
INSERT INTO `area` VALUES ('341701', '市辖区', '1131', '341700');
INSERT INTO `area` VALUES ('341702', '贵池区', '1132', '341700');
INSERT INTO `area` VALUES ('341721', '东至县', '1133', '341700');
INSERT INTO `area` VALUES ('341722', '石台县', '1134', '341700');
INSERT INTO `area` VALUES ('341723', '青阳县', '1135', '341700');
INSERT INTO `area` VALUES ('341801', '市辖区', '1136', '341800');
INSERT INTO `area` VALUES ('341802', '宣州区', '1137', '341800');
INSERT INTO `area` VALUES ('341821', '郎溪县', '1138', '341800');
INSERT INTO `area` VALUES ('341822', '广德县', '1139', '341800');
INSERT INTO `area` VALUES ('341823', '泾　县', '1140', '341800');
INSERT INTO `area` VALUES ('341824', '绩溪县', '1141', '341800');
INSERT INTO `area` VALUES ('341825', '旌德县', '1142', '341800');
INSERT INTO `area` VALUES ('341881', '宁国市', '1143', '341800');
INSERT INTO `area` VALUES ('350101', '市辖区', '1144', '350100');
INSERT INTO `area` VALUES ('350102', '鼓楼区', '1145', '350100');
INSERT INTO `area` VALUES ('350103', '台江区', '1146', '350100');
INSERT INTO `area` VALUES ('350104', '仓山区', '1147', '350100');
INSERT INTO `area` VALUES ('350105', '马尾区', '1148', '350100');
INSERT INTO `area` VALUES ('350111', '晋安区', '1149', '350100');
INSERT INTO `area` VALUES ('350121', '闽侯县', '1150', '350100');
INSERT INTO `area` VALUES ('350122', '连江县', '1151', '350100');
INSERT INTO `area` VALUES ('350123', '罗源县', '1152', '350100');
INSERT INTO `area` VALUES ('350124', '闽清县', '1153', '350100');
INSERT INTO `area` VALUES ('350125', '永泰县', '1154', '350100');
INSERT INTO `area` VALUES ('350128', '平潭县', '1155', '350100');
INSERT INTO `area` VALUES ('350181', '福清市', '1156', '350100');
INSERT INTO `area` VALUES ('350182', '长乐市', '1157', '350100');
INSERT INTO `area` VALUES ('350201', '市辖区', '1158', '350200');
INSERT INTO `area` VALUES ('350203', '思明区', '1159', '350200');
INSERT INTO `area` VALUES ('350205', '海沧区', '1160', '350200');
INSERT INTO `area` VALUES ('350206', '湖里区', '1161', '350200');
INSERT INTO `area` VALUES ('350211', '集美区', '1162', '350200');
INSERT INTO `area` VALUES ('350212', '同安区', '1163', '350200');
INSERT INTO `area` VALUES ('350213', '翔安区', '1164', '350200');
INSERT INTO `area` VALUES ('350301', '市辖区', '1165', '350300');
INSERT INTO `area` VALUES ('350302', '城厢区', '1166', '350300');
INSERT INTO `area` VALUES ('350303', '涵江区', '1167', '350300');
INSERT INTO `area` VALUES ('350304', '荔城区', '1168', '350300');
INSERT INTO `area` VALUES ('350305', '秀屿区', '1169', '350300');
INSERT INTO `area` VALUES ('350322', '仙游县', '1170', '350300');
INSERT INTO `area` VALUES ('350401', '市辖区', '1171', '350400');
INSERT INTO `area` VALUES ('350402', '梅列区', '1172', '350400');
INSERT INTO `area` VALUES ('350403', '三元区', '1173', '350400');
INSERT INTO `area` VALUES ('350421', '明溪县', '1174', '350400');
INSERT INTO `area` VALUES ('350423', '清流县', '1175', '350400');
INSERT INTO `area` VALUES ('350424', '宁化县', '1176', '350400');
INSERT INTO `area` VALUES ('350425', '大田县', '1177', '350400');
INSERT INTO `area` VALUES ('350426', '尤溪县', '1178', '350400');
INSERT INTO `area` VALUES ('350427', '沙　县', '1179', '350400');
INSERT INTO `area` VALUES ('350428', '将乐县', '1180', '350400');
INSERT INTO `area` VALUES ('350429', '泰宁县', '1181', '350400');
INSERT INTO `area` VALUES ('350430', '建宁县', '1182', '350400');
INSERT INTO `area` VALUES ('350481', '永安市', '1183', '350400');
INSERT INTO `area` VALUES ('350501', '市辖区', '1184', '350500');
INSERT INTO `area` VALUES ('350502', '鲤城区', '1185', '350500');
INSERT INTO `area` VALUES ('350503', '丰泽区', '1186', '350500');
INSERT INTO `area` VALUES ('350504', '洛江区', '1187', '350500');
INSERT INTO `area` VALUES ('350505', '泉港区', '1188', '350500');
INSERT INTO `area` VALUES ('350521', '惠安县', '1189', '350500');
INSERT INTO `area` VALUES ('350524', '安溪县', '1190', '350500');
INSERT INTO `area` VALUES ('350525', '永春县', '1191', '350500');
INSERT INTO `area` VALUES ('350526', '德化县', '1192', '350500');
INSERT INTO `area` VALUES ('350527', '金门县', '1193', '350500');
INSERT INTO `area` VALUES ('350581', '石狮市', '1194', '350500');
INSERT INTO `area` VALUES ('350582', '晋江市', '1195', '350500');
INSERT INTO `area` VALUES ('350583', '南安市', '1196', '350500');
INSERT INTO `area` VALUES ('350601', '市辖区', '1197', '350600');
INSERT INTO `area` VALUES ('350602', '芗城区', '1198', '350600');
INSERT INTO `area` VALUES ('350603', '龙文区', '1199', '350600');
INSERT INTO `area` VALUES ('350622', '云霄县', '1200', '350600');
INSERT INTO `area` VALUES ('350623', '漳浦县', '1201', '350600');
INSERT INTO `area` VALUES ('350624', '诏安县', '1202', '350600');
INSERT INTO `area` VALUES ('350625', '长泰县', '1203', '350600');
INSERT INTO `area` VALUES ('350626', '东山县', '1204', '350600');
INSERT INTO `area` VALUES ('350627', '南靖县', '1205', '350600');
INSERT INTO `area` VALUES ('350628', '平和县', '1206', '350600');
INSERT INTO `area` VALUES ('350629', '华安县', '1207', '350600');
INSERT INTO `area` VALUES ('350681', '龙海市', '1208', '350600');
INSERT INTO `area` VALUES ('350701', '市辖区', '1209', '350700');
INSERT INTO `area` VALUES ('350702', '延平区', '1210', '350700');
INSERT INTO `area` VALUES ('350721', '顺昌县', '1211', '350700');
INSERT INTO `area` VALUES ('350722', '浦城县', '1212', '350700');
INSERT INTO `area` VALUES ('350723', '光泽县', '1213', '350700');
INSERT INTO `area` VALUES ('350724', '松溪县', '1214', '350700');
INSERT INTO `area` VALUES ('350725', '政和县', '1215', '350700');
INSERT INTO `area` VALUES ('350781', '邵武市', '1216', '350700');
INSERT INTO `area` VALUES ('350782', '武夷山市', '1217', '350700');
INSERT INTO `area` VALUES ('350783', '建瓯市', '1218', '350700');
INSERT INTO `area` VALUES ('350784', '建阳市', '1219', '350700');
INSERT INTO `area` VALUES ('350801', '市辖区', '1220', '350800');
INSERT INTO `area` VALUES ('350802', '新罗区', '1221', '350800');
INSERT INTO `area` VALUES ('350821', '长汀县', '1222', '350800');
INSERT INTO `area` VALUES ('350822', '永定县', '1223', '350800');
INSERT INTO `area` VALUES ('350823', '上杭县', '1224', '350800');
INSERT INTO `area` VALUES ('350824', '武平县', '1225', '350800');
INSERT INTO `area` VALUES ('350825', '连城县', '1226', '350800');
INSERT INTO `area` VALUES ('350881', '漳平市', '1227', '350800');
INSERT INTO `area` VALUES ('350901', '市辖区', '1228', '350900');
INSERT INTO `area` VALUES ('350902', '蕉城区', '1229', '350900');
INSERT INTO `area` VALUES ('350921', '霞浦县', '1230', '350900');
INSERT INTO `area` VALUES ('350922', '古田县', '1231', '350900');
INSERT INTO `area` VALUES ('350923', '屏南县', '1232', '350900');
INSERT INTO `area` VALUES ('350924', '寿宁县', '1233', '350900');
INSERT INTO `area` VALUES ('350925', '周宁县', '1234', '350900');
INSERT INTO `area` VALUES ('350926', '柘荣县', '1235', '350900');
INSERT INTO `area` VALUES ('350981', '福安市', '1236', '350900');
INSERT INTO `area` VALUES ('350982', '福鼎市', '1237', '350900');
INSERT INTO `area` VALUES ('360101', '市辖区', '1238', '360100');
INSERT INTO `area` VALUES ('360102', '东湖区', '1239', '360100');
INSERT INTO `area` VALUES ('360103', '西湖区', '1240', '360100');
INSERT INTO `area` VALUES ('360104', '青云谱区', '1241', '360100');
INSERT INTO `area` VALUES ('360105', '湾里区', '1242', '360100');
INSERT INTO `area` VALUES ('360111', '青山湖区', '1243', '360100');
INSERT INTO `area` VALUES ('360121', '南昌县', '1244', '360100');
INSERT INTO `area` VALUES ('360122', '新建县', '1245', '360100');
INSERT INTO `area` VALUES ('360123', '安义县', '1246', '360100');
INSERT INTO `area` VALUES ('360124', '进贤县', '1247', '360100');
INSERT INTO `area` VALUES ('360201', '市辖区', '1248', '360200');
INSERT INTO `area` VALUES ('360202', '昌江区', '1249', '360200');
INSERT INTO `area` VALUES ('360203', '珠山区', '1250', '360200');
INSERT INTO `area` VALUES ('360222', '浮梁县', '1251', '360200');
INSERT INTO `area` VALUES ('360281', '乐平市', '1252', '360200');
INSERT INTO `area` VALUES ('360301', '市辖区', '1253', '360300');
INSERT INTO `area` VALUES ('360302', '安源区', '1254', '360300');
INSERT INTO `area` VALUES ('360313', '湘东区', '1255', '360300');
INSERT INTO `area` VALUES ('360321', '莲花县', '1256', '360300');
INSERT INTO `area` VALUES ('360322', '上栗县', '1257', '360300');
INSERT INTO `area` VALUES ('360323', '芦溪县', '1258', '360300');
INSERT INTO `area` VALUES ('360401', '市辖区', '1259', '360400');
INSERT INTO `area` VALUES ('360402', '庐山区', '1260', '360400');
INSERT INTO `area` VALUES ('360403', '浔阳区', '1261', '360400');
INSERT INTO `area` VALUES ('360421', '九江县', '1262', '360400');
INSERT INTO `area` VALUES ('360423', '武宁县', '1263', '360400');
INSERT INTO `area` VALUES ('360424', '修水县', '1264', '360400');
INSERT INTO `area` VALUES ('360425', '永修县', '1265', '360400');
INSERT INTO `area` VALUES ('360426', '德安县', '1266', '360400');
INSERT INTO `area` VALUES ('360427', '星子县', '1267', '360400');
INSERT INTO `area` VALUES ('360428', '都昌县', '1268', '360400');
INSERT INTO `area` VALUES ('360429', '湖口县', '1269', '360400');
INSERT INTO `area` VALUES ('360430', '彭泽县', '1270', '360400');
INSERT INTO `area` VALUES ('360481', '瑞昌市', '1271', '360400');
INSERT INTO `area` VALUES ('360501', '市辖区', '1272', '360500');
INSERT INTO `area` VALUES ('360502', '渝水区', '1273', '360500');
INSERT INTO `area` VALUES ('360521', '分宜县', '1274', '360500');
INSERT INTO `area` VALUES ('360601', '市辖区', '1275', '360600');
INSERT INTO `area` VALUES ('360602', '月湖区', '1276', '360600');
INSERT INTO `area` VALUES ('360622', '余江县', '1277', '360600');
INSERT INTO `area` VALUES ('360681', '贵溪市', '1278', '360600');
INSERT INTO `area` VALUES ('360701', '市辖区', '1279', '360700');
INSERT INTO `area` VALUES ('360702', '章贡区', '1280', '360700');
INSERT INTO `area` VALUES ('360721', '赣　县', '1281', '360700');
INSERT INTO `area` VALUES ('360722', '信丰县', '1282', '360700');
INSERT INTO `area` VALUES ('360723', '大余县', '1283', '360700');
INSERT INTO `area` VALUES ('360724', '上犹县', '1284', '360700');
INSERT INTO `area` VALUES ('360725', '崇义县', '1285', '360700');
INSERT INTO `area` VALUES ('360726', '安远县', '1286', '360700');
INSERT INTO `area` VALUES ('360727', '龙南县', '1287', '360700');
INSERT INTO `area` VALUES ('360728', '定南县', '1288', '360700');
INSERT INTO `area` VALUES ('360729', '全南县', '1289', '360700');
INSERT INTO `area` VALUES ('360730', '宁都县', '1290', '360700');
INSERT INTO `area` VALUES ('360731', '于都县', '1291', '360700');
INSERT INTO `area` VALUES ('360732', '兴国县', '1292', '360700');
INSERT INTO `area` VALUES ('360733', '会昌县', '1293', '360700');
INSERT INTO `area` VALUES ('360734', '寻乌县', '1294', '360700');
INSERT INTO `area` VALUES ('360735', '石城县', '1295', '360700');
INSERT INTO `area` VALUES ('360781', '瑞金市', '1296', '360700');
INSERT INTO `area` VALUES ('360782', '南康市', '1297', '360700');
INSERT INTO `area` VALUES ('360801', '市辖区', '1298', '360800');
INSERT INTO `area` VALUES ('360802', '吉州区', '1299', '360800');
INSERT INTO `area` VALUES ('360803', '青原区', '1300', '360800');
INSERT INTO `area` VALUES ('360821', '吉安县', '1301', '360800');
INSERT INTO `area` VALUES ('360822', '吉水县', '1302', '360800');
INSERT INTO `area` VALUES ('360823', '峡江县', '1303', '360800');
INSERT INTO `area` VALUES ('360824', '新干县', '1304', '360800');
INSERT INTO `area` VALUES ('360825', '永丰县', '1305', '360800');
INSERT INTO `area` VALUES ('360826', '泰和县', '1306', '360800');
INSERT INTO `area` VALUES ('360827', '遂川县', '1307', '360800');
INSERT INTO `area` VALUES ('360828', '万安县', '1308', '360800');
INSERT INTO `area` VALUES ('360829', '安福县', '1309', '360800');
INSERT INTO `area` VALUES ('360830', '永新县', '1310', '360800');
INSERT INTO `area` VALUES ('360881', '井冈山市', '1311', '360800');
INSERT INTO `area` VALUES ('360901', '市辖区', '1312', '360900');
INSERT INTO `area` VALUES ('360902', '袁州区', '1313', '360900');
INSERT INTO `area` VALUES ('360921', '奉新县', '1314', '360900');
INSERT INTO `area` VALUES ('360922', '万载县', '1315', '360900');
INSERT INTO `area` VALUES ('360923', '上高县', '1316', '360900');
INSERT INTO `area` VALUES ('360924', '宜丰县', '1317', '360900');
INSERT INTO `area` VALUES ('360925', '靖安县', '1318', '360900');
INSERT INTO `area` VALUES ('360926', '铜鼓县', '1319', '360900');
INSERT INTO `area` VALUES ('360981', '丰城市', '1320', '360900');
INSERT INTO `area` VALUES ('360982', '樟树市', '1321', '360900');
INSERT INTO `area` VALUES ('360983', '高安市', '1322', '360900');
INSERT INTO `area` VALUES ('361001', '市辖区', '1323', '361000');
INSERT INTO `area` VALUES ('361002', '临川区', '1324', '361000');
INSERT INTO `area` VALUES ('361021', '南城县', '1325', '361000');
INSERT INTO `area` VALUES ('361022', '黎川县', '1326', '361000');
INSERT INTO `area` VALUES ('361023', '南丰县', '1327', '361000');
INSERT INTO `area` VALUES ('361024', '崇仁县', '1328', '361000');
INSERT INTO `area` VALUES ('361025', '乐安县', '1329', '361000');
INSERT INTO `area` VALUES ('361026', '宜黄县', '1330', '361000');
INSERT INTO `area` VALUES ('361027', '金溪县', '1331', '361000');
INSERT INTO `area` VALUES ('361028', '资溪县', '1332', '361000');
INSERT INTO `area` VALUES ('361029', '东乡县', '1333', '361000');
INSERT INTO `area` VALUES ('361030', '广昌县', '1334', '361000');
INSERT INTO `area` VALUES ('361101', '市辖区', '1335', '361100');
INSERT INTO `area` VALUES ('361102', '信州区', '1336', '361100');
INSERT INTO `area` VALUES ('361121', '上饶县', '1337', '361100');
INSERT INTO `area` VALUES ('361122', '广丰县', '1338', '361100');
INSERT INTO `area` VALUES ('361123', '玉山县', '1339', '361100');
INSERT INTO `area` VALUES ('361124', '铅山县', '1340', '361100');
INSERT INTO `area` VALUES ('361125', '横峰县', '1341', '361100');
INSERT INTO `area` VALUES ('361126', '弋阳县', '1342', '361100');
INSERT INTO `area` VALUES ('361127', '余干县', '1343', '361100');
INSERT INTO `area` VALUES ('361128', '鄱阳县', '1344', '361100');
INSERT INTO `area` VALUES ('361129', '万年县', '1345', '361100');
INSERT INTO `area` VALUES ('361130', '婺源县', '1346', '361100');
INSERT INTO `area` VALUES ('361181', '德兴市', '1347', '361100');
INSERT INTO `area` VALUES ('370101', '市辖区', '1348', '370100');
INSERT INTO `area` VALUES ('370102', '历下区', '1349', '370100');
INSERT INTO `area` VALUES ('370103', '市中区', '1350', '370100');
INSERT INTO `area` VALUES ('370104', '槐荫区', '1351', '370100');
INSERT INTO `area` VALUES ('370105', '天桥区', '1352', '370100');
INSERT INTO `area` VALUES ('370112', '历城区', '1353', '370100');
INSERT INTO `area` VALUES ('370113', '长清区', '1354', '370100');
INSERT INTO `area` VALUES ('370124', '平阴县', '1355', '370100');
INSERT INTO `area` VALUES ('370125', '济阳县', '1356', '370100');
INSERT INTO `area` VALUES ('370126', '商河县', '1357', '370100');
INSERT INTO `area` VALUES ('370181', '章丘市', '1358', '370100');
INSERT INTO `area` VALUES ('370201', '市辖区', '1359', '370200');
INSERT INTO `area` VALUES ('370202', '市南区', '1360', '370200');
INSERT INTO `area` VALUES ('370203', '市北区', '1361', '370200');
INSERT INTO `area` VALUES ('370205', '四方区', '1362', '370200');
INSERT INTO `area` VALUES ('370211', '黄岛区', '1363', '370200');
INSERT INTO `area` VALUES ('370212', '崂山区', '1364', '370200');
INSERT INTO `area` VALUES ('370213', '李沧区', '1365', '370200');
INSERT INTO `area` VALUES ('370214', '城阳区', '1366', '370200');
INSERT INTO `area` VALUES ('370281', '胶州市', '1367', '370200');
INSERT INTO `area` VALUES ('370282', '即墨市', '1368', '370200');
INSERT INTO `area` VALUES ('370283', '平度市', '1369', '370200');
INSERT INTO `area` VALUES ('370284', '胶南市', '1370', '370200');
INSERT INTO `area` VALUES ('370285', '莱西市', '1371', '370200');
INSERT INTO `area` VALUES ('370301', '市辖区', '1372', '370300');
INSERT INTO `area` VALUES ('370302', '淄川区', '1373', '370300');
INSERT INTO `area` VALUES ('370303', '张店区', '1374', '370300');
INSERT INTO `area` VALUES ('370304', '博山区', '1375', '370300');
INSERT INTO `area` VALUES ('370305', '临淄区', '1376', '370300');
INSERT INTO `area` VALUES ('370306', '周村区', '1377', '370300');
INSERT INTO `area` VALUES ('370321', '桓台县', '1378', '370300');
INSERT INTO `area` VALUES ('370322', '高青县', '1379', '370300');
INSERT INTO `area` VALUES ('370323', '沂源县', '1380', '370300');
INSERT INTO `area` VALUES ('370401', '市辖区', '1381', '370400');
INSERT INTO `area` VALUES ('370402', '市中区', '1382', '370400');
INSERT INTO `area` VALUES ('370403', '薛城区', '1383', '370400');
INSERT INTO `area` VALUES ('370404', '峄城区', '1384', '370400');
INSERT INTO `area` VALUES ('370405', '台儿庄区', '1385', '370400');
INSERT INTO `area` VALUES ('370406', '山亭区', '1386', '370400');
INSERT INTO `area` VALUES ('370481', '滕州市', '1387', '370400');
INSERT INTO `area` VALUES ('370501', '市辖区', '1388', '370500');
INSERT INTO `area` VALUES ('370502', '东营区', '1389', '370500');
INSERT INTO `area` VALUES ('370503', '河口区', '1390', '370500');
INSERT INTO `area` VALUES ('370521', '垦利县', '1391', '370500');
INSERT INTO `area` VALUES ('370522', '利津县', '1392', '370500');
INSERT INTO `area` VALUES ('370523', '广饶县', '1393', '370500');
INSERT INTO `area` VALUES ('370601', '市辖区', '1394', '370600');
INSERT INTO `area` VALUES ('370602', '芝罘区', '1395', '370600');
INSERT INTO `area` VALUES ('370611', '福山区', '1396', '370600');
INSERT INTO `area` VALUES ('370612', '牟平区', '1397', '370600');
INSERT INTO `area` VALUES ('370613', '莱山区', '1398', '370600');
INSERT INTO `area` VALUES ('370634', '长岛县', '1399', '370600');
INSERT INTO `area` VALUES ('370681', '龙口市', '1400', '370600');
INSERT INTO `area` VALUES ('370682', '莱阳市', '1401', '370600');
INSERT INTO `area` VALUES ('370683', '莱州市', '1402', '370600');
INSERT INTO `area` VALUES ('370684', '蓬莱市', '1403', '370600');
INSERT INTO `area` VALUES ('370685', '招远市', '1404', '370600');
INSERT INTO `area` VALUES ('370686', '栖霞市', '1405', '370600');
INSERT INTO `area` VALUES ('370687', '海阳市', '1406', '370600');
INSERT INTO `area` VALUES ('370701', '市辖区', '1407', '370700');
INSERT INTO `area` VALUES ('370702', '潍城区', '1408', '370700');
INSERT INTO `area` VALUES ('370703', '寒亭区', '1409', '370700');
INSERT INTO `area` VALUES ('370704', '坊子区', '1410', '370700');
INSERT INTO `area` VALUES ('370705', '奎文区', '1411', '370700');
INSERT INTO `area` VALUES ('370724', '临朐县', '1412', '370700');
INSERT INTO `area` VALUES ('370725', '昌乐县', '1413', '370700');
INSERT INTO `area` VALUES ('370781', '青州市', '1414', '370700');
INSERT INTO `area` VALUES ('370782', '诸城市', '1415', '370700');
INSERT INTO `area` VALUES ('370783', '寿光市', '1416', '370700');
INSERT INTO `area` VALUES ('370784', '安丘市', '1417', '370700');
INSERT INTO `area` VALUES ('370785', '高密市', '1418', '370700');
INSERT INTO `area` VALUES ('370786', '昌邑市', '1419', '370700');
INSERT INTO `area` VALUES ('370801', '市辖区', '1420', '370800');
INSERT INTO `area` VALUES ('370802', '市中区', '1421', '370800');
INSERT INTO `area` VALUES ('370811', '任城区', '1422', '370800');
INSERT INTO `area` VALUES ('370826', '微山县', '1423', '370800');
INSERT INTO `area` VALUES ('370827', '鱼台县', '1424', '370800');
INSERT INTO `area` VALUES ('370828', '金乡县', '1425', '370800');
INSERT INTO `area` VALUES ('370829', '嘉祥县', '1426', '370800');
INSERT INTO `area` VALUES ('370830', '汶上县', '1427', '370800');
INSERT INTO `area` VALUES ('370831', '泗水县', '1428', '370800');
INSERT INTO `area` VALUES ('370832', '梁山县', '1429', '370800');
INSERT INTO `area` VALUES ('370881', '曲阜市', '1430', '370800');
INSERT INTO `area` VALUES ('370882', '兖州市', '1431', '370800');
INSERT INTO `area` VALUES ('370883', '邹城市', '1432', '370800');
INSERT INTO `area` VALUES ('370901', '市辖区', '1433', '370900');
INSERT INTO `area` VALUES ('370902', '泰山区', '1434', '370900');
INSERT INTO `area` VALUES ('370903', '岱岳区', '1435', '370900');
INSERT INTO `area` VALUES ('370921', '宁阳县', '1436', '370900');
INSERT INTO `area` VALUES ('370923', '东平县', '1437', '370900');
INSERT INTO `area` VALUES ('370982', '新泰市', '1438', '370900');
INSERT INTO `area` VALUES ('370983', '肥城市', '1439', '370900');
INSERT INTO `area` VALUES ('371001', '市辖区', '1440', '371000');
INSERT INTO `area` VALUES ('371002', '环翠区', '1441', '371000');
INSERT INTO `area` VALUES ('371081', '文登市', '1442', '371000');
INSERT INTO `area` VALUES ('371082', '荣成市', '1443', '371000');
INSERT INTO `area` VALUES ('371083', '乳山市', '1444', '371000');
INSERT INTO `area` VALUES ('371101', '市辖区', '1445', '371100');
INSERT INTO `area` VALUES ('371102', '东港区', '1446', '371100');
INSERT INTO `area` VALUES ('371103', '岚山区', '1447', '371100');
INSERT INTO `area` VALUES ('371121', '五莲县', '1448', '371100');
INSERT INTO `area` VALUES ('371122', '莒　县', '1449', '371100');
INSERT INTO `area` VALUES ('371201', '市辖区', '1450', '371200');
INSERT INTO `area` VALUES ('371202', '莱城区', '1451', '371200');
INSERT INTO `area` VALUES ('371203', '钢城区', '1452', '371200');
INSERT INTO `area` VALUES ('371301', '市辖区', '1453', '371300');
INSERT INTO `area` VALUES ('371302', '兰山区', '1454', '371300');
INSERT INTO `area` VALUES ('371311', '罗庄区', '1455', '371300');
INSERT INTO `area` VALUES ('371312', '河东区', '1456', '371300');
INSERT INTO `area` VALUES ('371321', '沂南县', '1457', '371300');
INSERT INTO `area` VALUES ('371322', '郯城县', '1458', '371300');
INSERT INTO `area` VALUES ('371323', '沂水县', '1459', '371300');
INSERT INTO `area` VALUES ('371324', '苍山县', '1460', '371300');
INSERT INTO `area` VALUES ('371325', '费　县', '1461', '371300');
INSERT INTO `area` VALUES ('371326', '平邑县', '1462', '371300');
INSERT INTO `area` VALUES ('371327', '莒南县', '1463', '371300');
INSERT INTO `area` VALUES ('371328', '蒙阴县', '1464', '371300');
INSERT INTO `area` VALUES ('371329', '临沭县', '1465', '371300');
INSERT INTO `area` VALUES ('371401', '市辖区', '1466', '371400');
INSERT INTO `area` VALUES ('371402', '德城区', '1467', '371400');
INSERT INTO `area` VALUES ('371421', '陵　县', '1468', '371400');
INSERT INTO `area` VALUES ('371422', '宁津县', '1469', '371400');
INSERT INTO `area` VALUES ('371423', '庆云县', '1470', '371400');
INSERT INTO `area` VALUES ('371424', '临邑县', '1471', '371400');
INSERT INTO `area` VALUES ('371425', '齐河县', '1472', '371400');
INSERT INTO `area` VALUES ('371426', '平原县', '1473', '371400');
INSERT INTO `area` VALUES ('371427', '夏津县', '1474', '371400');
INSERT INTO `area` VALUES ('371428', '武城县', '1475', '371400');
INSERT INTO `area` VALUES ('371481', '乐陵市', '1476', '371400');
INSERT INTO `area` VALUES ('371482', '禹城市', '1477', '371400');
INSERT INTO `area` VALUES ('371501', '市辖区', '1478', '371500');
INSERT INTO `area` VALUES ('371502', '东昌府区', '1479', '371500');
INSERT INTO `area` VALUES ('371521', '阳谷县', '1480', '371500');
INSERT INTO `area` VALUES ('371522', '莘　县', '1481', '371500');
INSERT INTO `area` VALUES ('371523', '茌平县', '1482', '371500');
INSERT INTO `area` VALUES ('371524', '东阿县', '1483', '371500');
INSERT INTO `area` VALUES ('371525', '冠　县', '1484', '371500');
INSERT INTO `area` VALUES ('371526', '高唐县', '1485', '371500');
INSERT INTO `area` VALUES ('371581', '临清市', '1486', '371500');
INSERT INTO `area` VALUES ('371601', '市辖区', '1487', '371600');
INSERT INTO `area` VALUES ('371602', '滨城区', '1488', '371600');
INSERT INTO `area` VALUES ('371621', '惠民县', '1489', '371600');
INSERT INTO `area` VALUES ('371622', '阳信县', '1490', '371600');
INSERT INTO `area` VALUES ('371623', '无棣县', '1491', '371600');
INSERT INTO `area` VALUES ('371624', '沾化县', '1492', '371600');
INSERT INTO `area` VALUES ('371625', '博兴县', '1493', '371600');
INSERT INTO `area` VALUES ('371626', '邹平县', '1494', '371600');
INSERT INTO `area` VALUES ('371701', '市辖区', '1495', '371700');
INSERT INTO `area` VALUES ('371702', '牡丹区', '1496', '371700');
INSERT INTO `area` VALUES ('371721', '曹　县', '1497', '371700');
INSERT INTO `area` VALUES ('371722', '单　县', '1498', '371700');
INSERT INTO `area` VALUES ('371723', '成武县', '1499', '371700');
INSERT INTO `area` VALUES ('371724', '巨野县', '1500', '371700');
INSERT INTO `area` VALUES ('371725', '郓城县', '1501', '371700');
INSERT INTO `area` VALUES ('371726', '鄄城县', '1502', '371700');
INSERT INTO `area` VALUES ('371727', '定陶县', '1503', '371700');
INSERT INTO `area` VALUES ('371728', '东明县', '1504', '371700');
INSERT INTO `area` VALUES ('410101', '市辖区', '1505', '410100');
INSERT INTO `area` VALUES ('410102', '中原区', '1506', '410100');
INSERT INTO `area` VALUES ('410103', '二七区', '1507', '410100');
INSERT INTO `area` VALUES ('410104', '管城回族区', '1508', '410100');
INSERT INTO `area` VALUES ('410105', '金水区', '1509', '410100');
INSERT INTO `area` VALUES ('410106', '上街区', '1510', '410100');
INSERT INTO `area` VALUES ('410108', '邙山区', '1511', '410100');
INSERT INTO `area` VALUES ('410122', '中牟县', '1512', '410100');
INSERT INTO `area` VALUES ('410181', '巩义市', '1513', '410100');
INSERT INTO `area` VALUES ('410182', '荥阳市', '1514', '410100');
INSERT INTO `area` VALUES ('410183', '新密市', '1515', '410100');
INSERT INTO `area` VALUES ('410184', '新郑市', '1516', '410100');
INSERT INTO `area` VALUES ('410185', '登封市', '1517', '410100');
INSERT INTO `area` VALUES ('410201', '市辖区', '1518', '410200');
INSERT INTO `area` VALUES ('410202', '龙亭区', '1519', '410200');
INSERT INTO `area` VALUES ('410203', '顺河回族区', '1520', '410200');
INSERT INTO `area` VALUES ('410204', '鼓楼区', '1521', '410200');
INSERT INTO `area` VALUES ('410205', '南关区', '1522', '410200');
INSERT INTO `area` VALUES ('410211', '郊　区', '1523', '410200');
INSERT INTO `area` VALUES ('410221', '杞　县', '1524', '410200');
INSERT INTO `area` VALUES ('410222', '通许县', '1525', '410200');
INSERT INTO `area` VALUES ('410223', '尉氏县', '1526', '410200');
INSERT INTO `area` VALUES ('410224', '开封县', '1527', '410200');
INSERT INTO `area` VALUES ('410225', '兰考县', '1528', '410200');
INSERT INTO `area` VALUES ('410301', '市辖区', '1529', '410300');
INSERT INTO `area` VALUES ('410302', '老城区', '1530', '410300');
INSERT INTO `area` VALUES ('410303', '西工区', '1531', '410300');
INSERT INTO `area` VALUES ('410304', '廛河回族区', '1532', '410300');
INSERT INTO `area` VALUES ('410305', '涧西区', '1533', '410300');
INSERT INTO `area` VALUES ('410306', '吉利区', '1534', '410300');
INSERT INTO `area` VALUES ('410307', '洛龙区', '1535', '410300');
INSERT INTO `area` VALUES ('410322', '孟津县', '1536', '410300');
INSERT INTO `area` VALUES ('410323', '新安县', '1537', '410300');
INSERT INTO `area` VALUES ('410324', '栾川县', '1538', '410300');
INSERT INTO `area` VALUES ('410325', '嵩　县', '1539', '410300');
INSERT INTO `area` VALUES ('410326', '汝阳县', '1540', '410300');
INSERT INTO `area` VALUES ('410327', '宜阳县', '1541', '410300');
INSERT INTO `area` VALUES ('410328', '洛宁县', '1542', '410300');
INSERT INTO `area` VALUES ('410329', '伊川县', '1543', '410300');
INSERT INTO `area` VALUES ('410381', '偃师市', '1544', '410300');
INSERT INTO `area` VALUES ('410401', '市辖区', '1545', '410400');
INSERT INTO `area` VALUES ('410402', '新华区', '1546', '410400');
INSERT INTO `area` VALUES ('410403', '卫东区', '1547', '410400');
INSERT INTO `area` VALUES ('410404', '石龙区', '1548', '410400');
INSERT INTO `area` VALUES ('410411', '湛河区', '1549', '410400');
INSERT INTO `area` VALUES ('410421', '宝丰县', '1550', '410400');
INSERT INTO `area` VALUES ('410422', '叶　县', '1551', '410400');
INSERT INTO `area` VALUES ('410423', '鲁山县', '1552', '410400');
INSERT INTO `area` VALUES ('410425', '郏　县', '1553', '410400');
INSERT INTO `area` VALUES ('410481', '舞钢市', '1554', '410400');
INSERT INTO `area` VALUES ('410482', '汝州市', '1555', '410400');
INSERT INTO `area` VALUES ('410501', '市辖区', '1556', '410500');
INSERT INTO `area` VALUES ('410502', '文峰区', '1557', '410500');
INSERT INTO `area` VALUES ('410503', '北关区', '1558', '410500');
INSERT INTO `area` VALUES ('410505', '殷都区', '1559', '410500');
INSERT INTO `area` VALUES ('410506', '龙安区', '1560', '410500');
INSERT INTO `area` VALUES ('410522', '安阳县', '1561', '410500');
INSERT INTO `area` VALUES ('410523', '汤阴县', '1562', '410500');
INSERT INTO `area` VALUES ('410526', '滑　县', '1563', '410500');
INSERT INTO `area` VALUES ('410527', '内黄县', '1564', '410500');
INSERT INTO `area` VALUES ('410581', '林州市', '1565', '410500');
INSERT INTO `area` VALUES ('410601', '市辖区', '1566', '410600');
INSERT INTO `area` VALUES ('410602', '鹤山区', '1567', '410600');
INSERT INTO `area` VALUES ('410603', '山城区', '1568', '410600');
INSERT INTO `area` VALUES ('410611', '淇滨区', '1569', '410600');
INSERT INTO `area` VALUES ('410621', '浚　县', '1570', '410600');
INSERT INTO `area` VALUES ('410622', '淇　县', '1571', '410600');
INSERT INTO `area` VALUES ('410701', '市辖区', '1572', '410700');
INSERT INTO `area` VALUES ('410702', '红旗区', '1573', '410700');
INSERT INTO `area` VALUES ('410703', '卫滨区', '1574', '410700');
INSERT INTO `area` VALUES ('410704', '凤泉区', '1575', '410700');
INSERT INTO `area` VALUES ('410711', '牧野区', '1576', '410700');
INSERT INTO `area` VALUES ('410721', '新乡县', '1577', '410700');
INSERT INTO `area` VALUES ('410724', '获嘉县', '1578', '410700');
INSERT INTO `area` VALUES ('410725', '原阳县', '1579', '410700');
INSERT INTO `area` VALUES ('410726', '延津县', '1580', '410700');
INSERT INTO `area` VALUES ('410727', '封丘县', '1581', '410700');
INSERT INTO `area` VALUES ('410728', '长垣县', '1582', '410700');
INSERT INTO `area` VALUES ('410781', '卫辉市', '1583', '410700');
INSERT INTO `area` VALUES ('410782', '辉县市', '1584', '410700');
INSERT INTO `area` VALUES ('410801', '市辖区', '1585', '410800');
INSERT INTO `area` VALUES ('410802', '解放区', '1586', '410800');
INSERT INTO `area` VALUES ('410803', '中站区', '1587', '410800');
INSERT INTO `area` VALUES ('410804', '马村区', '1588', '410800');
INSERT INTO `area` VALUES ('410811', '山阳区', '1589', '410800');
INSERT INTO `area` VALUES ('410821', '修武县', '1590', '410800');
INSERT INTO `area` VALUES ('410822', '博爱县', '1591', '410800');
INSERT INTO `area` VALUES ('410823', '武陟县', '1592', '410800');
INSERT INTO `area` VALUES ('410825', '温　县', '1593', '410800');
INSERT INTO `area` VALUES ('410881', '济源市', '1594', '410800');
INSERT INTO `area` VALUES ('410882', '沁阳市', '1595', '410800');
INSERT INTO `area` VALUES ('410883', '孟州市', '1596', '410800');
INSERT INTO `area` VALUES ('410901', '市辖区', '1597', '410900');
INSERT INTO `area` VALUES ('410902', '华龙区', '1598', '410900');
INSERT INTO `area` VALUES ('410922', '清丰县', '1599', '410900');
INSERT INTO `area` VALUES ('410923', '南乐县', '1600', '410900');
INSERT INTO `area` VALUES ('410926', '范　县', '1601', '410900');
INSERT INTO `area` VALUES ('410927', '台前县', '1602', '410900');
INSERT INTO `area` VALUES ('410928', '濮阳县', '1603', '410900');
INSERT INTO `area` VALUES ('411001', '市辖区', '1604', '411000');
INSERT INTO `area` VALUES ('411002', '魏都区', '1605', '411000');
INSERT INTO `area` VALUES ('411023', '许昌县', '1606', '411000');
INSERT INTO `area` VALUES ('411024', '鄢陵县', '1607', '411000');
INSERT INTO `area` VALUES ('411025', '襄城县', '1608', '411000');
INSERT INTO `area` VALUES ('411081', '禹州市', '1609', '411000');
INSERT INTO `area` VALUES ('411082', '长葛市', '1610', '411000');
INSERT INTO `area` VALUES ('411101', '市辖区', '1611', '411100');
INSERT INTO `area` VALUES ('411102', '源汇区', '1612', '411100');
INSERT INTO `area` VALUES ('411103', '郾城区', '1613', '411100');
INSERT INTO `area` VALUES ('411104', '召陵区', '1614', '411100');
INSERT INTO `area` VALUES ('411121', '舞阳县', '1615', '411100');
INSERT INTO `area` VALUES ('411122', '临颍县', '1616', '411100');
INSERT INTO `area` VALUES ('411201', '市辖区', '1617', '411200');
INSERT INTO `area` VALUES ('411202', '湖滨区', '1618', '411200');
INSERT INTO `area` VALUES ('411221', '渑池县', '1619', '411200');
INSERT INTO `area` VALUES ('411222', '陕　县', '1620', '411200');
INSERT INTO `area` VALUES ('411224', '卢氏县', '1621', '411200');
INSERT INTO `area` VALUES ('411281', '义马市', '1622', '411200');
INSERT INTO `area` VALUES ('411282', '灵宝市', '1623', '411200');
INSERT INTO `area` VALUES ('411301', '市辖区', '1624', '411300');
INSERT INTO `area` VALUES ('411302', '宛城区', '1625', '411300');
INSERT INTO `area` VALUES ('411303', '卧龙区', '1626', '411300');
INSERT INTO `area` VALUES ('411321', '南召县', '1627', '411300');
INSERT INTO `area` VALUES ('411322', '方城县', '1628', '411300');
INSERT INTO `area` VALUES ('411323', '西峡县', '1629', '411300');
INSERT INTO `area` VALUES ('411324', '镇平县', '1630', '411300');
INSERT INTO `area` VALUES ('411325', '内乡县', '1631', '411300');
INSERT INTO `area` VALUES ('411326', '淅川县', '1632', '411300');
INSERT INTO `area` VALUES ('411327', '社旗县', '1633', '411300');
INSERT INTO `area` VALUES ('411328', '唐河县', '1634', '411300');
INSERT INTO `area` VALUES ('411329', '新野县', '1635', '411300');
INSERT INTO `area` VALUES ('411330', '桐柏县', '1636', '411300');
INSERT INTO `area` VALUES ('411381', '邓州市', '1637', '411300');
INSERT INTO `area` VALUES ('411401', '市辖区', '1638', '411400');
INSERT INTO `area` VALUES ('411402', '梁园区', '1639', '411400');
INSERT INTO `area` VALUES ('411403', '睢阳区', '1640', '411400');
INSERT INTO `area` VALUES ('411421', '民权县', '1641', '411400');
INSERT INTO `area` VALUES ('411422', '睢　县', '1642', '411400');
INSERT INTO `area` VALUES ('411423', '宁陵县', '1643', '411400');
INSERT INTO `area` VALUES ('411424', '柘城县', '1644', '411400');
INSERT INTO `area` VALUES ('411425', '虞城县', '1645', '411400');
INSERT INTO `area` VALUES ('411426', '夏邑县', '1646', '411400');
INSERT INTO `area` VALUES ('411481', '永城市', '1647', '411400');
INSERT INTO `area` VALUES ('411501', '市辖区', '1648', '411500');
INSERT INTO `area` VALUES ('411502', '师河区', '1649', '411500');
INSERT INTO `area` VALUES ('411503', '平桥区', '1650', '411500');
INSERT INTO `area` VALUES ('411521', '罗山县', '1651', '411500');
INSERT INTO `area` VALUES ('411522', '光山县', '1652', '411500');
INSERT INTO `area` VALUES ('411523', '新　县', '1653', '411500');
INSERT INTO `area` VALUES ('411524', '商城县', '1654', '411500');
INSERT INTO `area` VALUES ('411525', '固始县', '1655', '411500');
INSERT INTO `area` VALUES ('411526', '潢川县', '1656', '411500');
INSERT INTO `area` VALUES ('411527', '淮滨县', '1657', '411500');
INSERT INTO `area` VALUES ('411528', '息　县', '1658', '411500');
INSERT INTO `area` VALUES ('411601', '市辖区', '1659', '411600');
INSERT INTO `area` VALUES ('411602', '川汇区', '1660', '411600');
INSERT INTO `area` VALUES ('411621', '扶沟县', '1661', '411600');
INSERT INTO `area` VALUES ('411622', '西华县', '1662', '411600');
INSERT INTO `area` VALUES ('411623', '商水县', '1663', '411600');
INSERT INTO `area` VALUES ('411624', '沈丘县', '1664', '411600');
INSERT INTO `area` VALUES ('411625', '郸城县', '1665', '411600');
INSERT INTO `area` VALUES ('411626', '淮阳县', '1666', '411600');
INSERT INTO `area` VALUES ('411627', '太康县', '1667', '411600');
INSERT INTO `area` VALUES ('411628', '鹿邑县', '1668', '411600');
INSERT INTO `area` VALUES ('411681', '项城市', '1669', '411600');
INSERT INTO `area` VALUES ('411701', '市辖区', '1670', '411700');
INSERT INTO `area` VALUES ('411702', '驿城区', '1671', '411700');
INSERT INTO `area` VALUES ('411721', '西平县', '1672', '411700');
INSERT INTO `area` VALUES ('411722', '上蔡县', '1673', '411700');
INSERT INTO `area` VALUES ('411723', '平舆县', '1674', '411700');
INSERT INTO `area` VALUES ('411724', '正阳县', '1675', '411700');
INSERT INTO `area` VALUES ('411725', '确山县', '1676', '411700');
INSERT INTO `area` VALUES ('411726', '泌阳县', '1677', '411700');
INSERT INTO `area` VALUES ('411727', '汝南县', '1678', '411700');
INSERT INTO `area` VALUES ('411728', '遂平县', '1679', '411700');
INSERT INTO `area` VALUES ('411729', '新蔡县', '1680', '411700');
INSERT INTO `area` VALUES ('420101', '市辖区', '1681', '420100');
INSERT INTO `area` VALUES ('420102', '江岸区', '1682', '420100');
INSERT INTO `area` VALUES ('420103', '江汉区', '1683', '420100');
INSERT INTO `area` VALUES ('420104', '乔口区', '1684', '420100');
INSERT INTO `area` VALUES ('420105', '汉阳区', '1685', '420100');
INSERT INTO `area` VALUES ('420106', '武昌区', '1686', '420100');
INSERT INTO `area` VALUES ('420107', '青山区', '1687', '420100');
INSERT INTO `area` VALUES ('420111', '洪山区', '1688', '420100');
INSERT INTO `area` VALUES ('420112', '东西湖区', '1689', '420100');
INSERT INTO `area` VALUES ('420113', '汉南区', '1690', '420100');
INSERT INTO `area` VALUES ('420114', '蔡甸区', '1691', '420100');
INSERT INTO `area` VALUES ('420115', '江夏区', '1692', '420100');
INSERT INTO `area` VALUES ('420116', '黄陂区', '1693', '420100');
INSERT INTO `area` VALUES ('420117', '新洲区', '1694', '420100');
INSERT INTO `area` VALUES ('420201', '市辖区', '1695', '420200');
INSERT INTO `area` VALUES ('420202', '黄石港区', '1696', '420200');
INSERT INTO `area` VALUES ('420203', '西塞山区', '1697', '420200');
INSERT INTO `area` VALUES ('420204', '下陆区', '1698', '420200');
INSERT INTO `area` VALUES ('420205', '铁山区', '1699', '420200');
INSERT INTO `area` VALUES ('420222', '阳新县', '1700', '420200');
INSERT INTO `area` VALUES ('420281', '大冶市', '1701', '420200');
INSERT INTO `area` VALUES ('420301', '市辖区', '1702', '420300');
INSERT INTO `area` VALUES ('420302', '茅箭区', '1703', '420300');
INSERT INTO `area` VALUES ('420303', '张湾区', '1704', '420300');
INSERT INTO `area` VALUES ('420321', '郧　县', '1705', '420300');
INSERT INTO `area` VALUES ('420322', '郧西县', '1706', '420300');
INSERT INTO `area` VALUES ('420323', '竹山县', '1707', '420300');
INSERT INTO `area` VALUES ('420324', '竹溪县', '1708', '420300');
INSERT INTO `area` VALUES ('420325', '房　县', '1709', '420300');
INSERT INTO `area` VALUES ('420381', '丹江口市', '1710', '420300');
INSERT INTO `area` VALUES ('420501', '市辖区', '1711', '420500');
INSERT INTO `area` VALUES ('420502', '西陵区', '1712', '420500');
INSERT INTO `area` VALUES ('420503', '伍家岗区', '1713', '420500');
INSERT INTO `area` VALUES ('420504', '点军区', '1714', '420500');
INSERT INTO `area` VALUES ('420505', '猇亭区', '1715', '420500');
INSERT INTO `area` VALUES ('420506', '夷陵区', '1716', '420500');
INSERT INTO `area` VALUES ('420525', '远安县', '1717', '420500');
INSERT INTO `area` VALUES ('420526', '兴山县', '1718', '420500');
INSERT INTO `area` VALUES ('420527', '秭归县', '1719', '420500');
INSERT INTO `area` VALUES ('420528', '长阳土家族自治县', '1720', '420500');
INSERT INTO `area` VALUES ('420529', '五峰土家族自治县', '1721', '420500');
INSERT INTO `area` VALUES ('420581', '宜都市', '1722', '420500');
INSERT INTO `area` VALUES ('420582', '当阳市', '1723', '420500');
INSERT INTO `area` VALUES ('420583', '枝江市', '1724', '420500');
INSERT INTO `area` VALUES ('420601', '市辖区', '1725', '420600');
INSERT INTO `area` VALUES ('420602', '襄城区', '1726', '420600');
INSERT INTO `area` VALUES ('420606', '樊城区', '1727', '420600');
INSERT INTO `area` VALUES ('420607', '襄阳区', '1728', '420600');
INSERT INTO `area` VALUES ('420624', '南漳县', '1729', '420600');
INSERT INTO `area` VALUES ('420625', '谷城县', '1730', '420600');
INSERT INTO `area` VALUES ('420626', '保康县', '1731', '420600');
INSERT INTO `area` VALUES ('420682', '老河口市', '1732', '420600');
INSERT INTO `area` VALUES ('420683', '枣阳市', '1733', '420600');
INSERT INTO `area` VALUES ('420684', '宜城市', '1734', '420600');
INSERT INTO `area` VALUES ('420701', '市辖区', '1735', '420700');
INSERT INTO `area` VALUES ('420702', '梁子湖区', '1736', '420700');
INSERT INTO `area` VALUES ('420703', '华容区', '1737', '420700');
INSERT INTO `area` VALUES ('420704', '鄂城区', '1738', '420700');
INSERT INTO `area` VALUES ('420801', '市辖区', '1739', '420800');
INSERT INTO `area` VALUES ('420802', '东宝区', '1740', '420800');
INSERT INTO `area` VALUES ('420804', '掇刀区', '1741', '420800');
INSERT INTO `area` VALUES ('420821', '京山县', '1742', '420800');
INSERT INTO `area` VALUES ('420822', '沙洋县', '1743', '420800');
INSERT INTO `area` VALUES ('420881', '钟祥市', '1744', '420800');
INSERT INTO `area` VALUES ('420901', '市辖区', '1745', '420900');
INSERT INTO `area` VALUES ('420902', '孝南区', '1746', '420900');
INSERT INTO `area` VALUES ('420921', '孝昌县', '1747', '420900');
INSERT INTO `area` VALUES ('420922', '大悟县', '1748', '420900');
INSERT INTO `area` VALUES ('420923', '云梦县', '1749', '420900');
INSERT INTO `area` VALUES ('420981', '应城市', '1750', '420900');
INSERT INTO `area` VALUES ('420982', '安陆市', '1751', '420900');
INSERT INTO `area` VALUES ('420984', '汉川市', '1752', '420900');
INSERT INTO `area` VALUES ('421001', '市辖区', '1753', '421000');
INSERT INTO `area` VALUES ('421002', '沙市区', '1754', '421000');
INSERT INTO `area` VALUES ('421003', '荆州区', '1755', '421000');
INSERT INTO `area` VALUES ('421022', '公安县', '1756', '421000');
INSERT INTO `area` VALUES ('421023', '监利县', '1757', '421000');
INSERT INTO `area` VALUES ('421024', '江陵县', '1758', '421000');
INSERT INTO `area` VALUES ('421081', '石首市', '1759', '421000');
INSERT INTO `area` VALUES ('421083', '洪湖市', '1760', '421000');
INSERT INTO `area` VALUES ('421087', '松滋市', '1761', '421000');
INSERT INTO `area` VALUES ('421101', '市辖区', '1762', '421100');
INSERT INTO `area` VALUES ('421102', '黄州区', '1763', '421100');
INSERT INTO `area` VALUES ('421121', '团风县', '1764', '421100');
INSERT INTO `area` VALUES ('421122', '红安县', '1765', '421100');
INSERT INTO `area` VALUES ('421123', '罗田县', '1766', '421100');
INSERT INTO `area` VALUES ('421124', '英山县', '1767', '421100');
INSERT INTO `area` VALUES ('421125', '浠水县', '1768', '421100');
INSERT INTO `area` VALUES ('421126', '蕲春县', '1769', '421100');
INSERT INTO `area` VALUES ('421127', '黄梅县', '1770', '421100');
INSERT INTO `area` VALUES ('421181', '麻城市', '1771', '421100');
INSERT INTO `area` VALUES ('421182', '武穴市', '1772', '421100');
INSERT INTO `area` VALUES ('421201', '市辖区', '1773', '421200');
INSERT INTO `area` VALUES ('421202', '咸安区', '1774', '421200');
INSERT INTO `area` VALUES ('421221', '嘉鱼县', '1775', '421200');
INSERT INTO `area` VALUES ('421222', '通城县', '1776', '421200');
INSERT INTO `area` VALUES ('421223', '崇阳县', '1777', '421200');
INSERT INTO `area` VALUES ('421224', '通山县', '1778', '421200');
INSERT INTO `area` VALUES ('421281', '赤壁市', '1779', '421200');
INSERT INTO `area` VALUES ('421301', '市辖区', '1780', '421300');
INSERT INTO `area` VALUES ('421302', '曾都区', '1781', '421300');
INSERT INTO `area` VALUES ('421381', '广水市', '1782', '421300');
INSERT INTO `area` VALUES ('422801', '恩施市', '1783', '422800');
INSERT INTO `area` VALUES ('422802', '利川市', '1784', '422800');
INSERT INTO `area` VALUES ('422822', '建始县', '1785', '422800');
INSERT INTO `area` VALUES ('422823', '巴东县', '1786', '422800');
INSERT INTO `area` VALUES ('422825', '宣恩县', '1787', '422800');
INSERT INTO `area` VALUES ('422826', '咸丰县', '1788', '422800');
INSERT INTO `area` VALUES ('422827', '来凤县', '1789', '422800');
INSERT INTO `area` VALUES ('422828', '鹤峰县', '1790', '422800');
INSERT INTO `area` VALUES ('429004', '仙桃市', '1791', '429000');
INSERT INTO `area` VALUES ('429005', '潜江市', '1792', '429000');
INSERT INTO `area` VALUES ('429006', '天门市', '1793', '429000');
INSERT INTO `area` VALUES ('429021', '神农架林区', '1794', '429000');
INSERT INTO `area` VALUES ('430101', '市辖区', '1795', '430100');
INSERT INTO `area` VALUES ('430102', '芙蓉区', '1796', '430100');
INSERT INTO `area` VALUES ('430103', '天心区', '1797', '430100');
INSERT INTO `area` VALUES ('430104', '岳麓区', '1798', '430100');
INSERT INTO `area` VALUES ('430105', '开福区', '1799', '430100');
INSERT INTO `area` VALUES ('430111', '雨花区', '1800', '430100');
INSERT INTO `area` VALUES ('430121', '长沙县', '1801', '430100');
INSERT INTO `area` VALUES ('430122', '望城县', '1802', '430100');
INSERT INTO `area` VALUES ('430124', '宁乡县', '1803', '430100');
INSERT INTO `area` VALUES ('430181', '浏阳市', '1804', '430100');
INSERT INTO `area` VALUES ('430201', '市辖区', '1805', '430200');
INSERT INTO `area` VALUES ('430202', '荷塘区', '1806', '430200');
INSERT INTO `area` VALUES ('430203', '芦淞区', '1807', '430200');
INSERT INTO `area` VALUES ('430204', '石峰区', '1808', '430200');
INSERT INTO `area` VALUES ('430211', '天元区', '1809', '430200');
INSERT INTO `area` VALUES ('430221', '株洲县', '1810', '430200');
INSERT INTO `area` VALUES ('430223', '攸　县', '1811', '430200');
INSERT INTO `area` VALUES ('430224', '茶陵县', '1812', '430200');
INSERT INTO `area` VALUES ('430225', '炎陵县', '1813', '430200');
INSERT INTO `area` VALUES ('430281', '醴陵市', '1814', '430200');
INSERT INTO `area` VALUES ('430301', '市辖区', '1815', '430300');
INSERT INTO `area` VALUES ('430302', '雨湖区', '1816', '430300');
INSERT INTO `area` VALUES ('430304', '岳塘区', '1817', '430300');
INSERT INTO `area` VALUES ('430321', '湘潭县', '1818', '430300');
INSERT INTO `area` VALUES ('430381', '湘乡市', '1819', '430300');
INSERT INTO `area` VALUES ('430382', '韶山市', '1820', '430300');
INSERT INTO `area` VALUES ('430401', '市辖区', '1821', '430400');
INSERT INTO `area` VALUES ('430405', '珠晖区', '1822', '430400');
INSERT INTO `area` VALUES ('430406', '雁峰区', '1823', '430400');
INSERT INTO `area` VALUES ('430407', '石鼓区', '1824', '430400');
INSERT INTO `area` VALUES ('430408', '蒸湘区', '1825', '430400');
INSERT INTO `area` VALUES ('430412', '南岳区', '1826', '430400');
INSERT INTO `area` VALUES ('430421', '衡阳县', '1827', '430400');
INSERT INTO `area` VALUES ('430422', '衡南县', '1828', '430400');
INSERT INTO `area` VALUES ('430423', '衡山县', '1829', '430400');
INSERT INTO `area` VALUES ('430424', '衡东县', '1830', '430400');
INSERT INTO `area` VALUES ('430426', '祁东县', '1831', '430400');
INSERT INTO `area` VALUES ('430481', '耒阳市', '1832', '430400');
INSERT INTO `area` VALUES ('430482', '常宁市', '1833', '430400');
INSERT INTO `area` VALUES ('430501', '市辖区', '1834', '430500');
INSERT INTO `area` VALUES ('430502', '双清区', '1835', '430500');
INSERT INTO `area` VALUES ('430503', '大祥区', '1836', '430500');
INSERT INTO `area` VALUES ('430511', '北塔区', '1837', '430500');
INSERT INTO `area` VALUES ('430521', '邵东县', '1838', '430500');
INSERT INTO `area` VALUES ('430522', '新邵县', '1839', '430500');
INSERT INTO `area` VALUES ('430523', '邵阳县', '1840', '430500');
INSERT INTO `area` VALUES ('430524', '隆回县', '1841', '430500');
INSERT INTO `area` VALUES ('430525', '洞口县', '1842', '430500');
INSERT INTO `area` VALUES ('430527', '绥宁县', '1843', '430500');
INSERT INTO `area` VALUES ('430528', '新宁县', '1844', '430500');
INSERT INTO `area` VALUES ('430529', '城步苗族自治县', '1845', '430500');
INSERT INTO `area` VALUES ('430581', '武冈市', '1846', '430500');
INSERT INTO `area` VALUES ('430601', '市辖区', '1847', '430600');
INSERT INTO `area` VALUES ('430602', '岳阳楼区', '1848', '430600');
INSERT INTO `area` VALUES ('430603', '云溪区', '1849', '430600');
INSERT INTO `area` VALUES ('430611', '君山区', '1850', '430600');
INSERT INTO `area` VALUES ('430621', '岳阳县', '1851', '430600');
INSERT INTO `area` VALUES ('430623', '华容县', '1852', '430600');
INSERT INTO `area` VALUES ('430624', '湘阴县', '1853', '430600');
INSERT INTO `area` VALUES ('430626', '平江县', '1854', '430600');
INSERT INTO `area` VALUES ('430681', '汨罗市', '1855', '430600');
INSERT INTO `area` VALUES ('430682', '临湘市', '1856', '430600');
INSERT INTO `area` VALUES ('430701', '市辖区', '1857', '430700');
INSERT INTO `area` VALUES ('430702', '武陵区', '1858', '430700');
INSERT INTO `area` VALUES ('430703', '鼎城区', '1859', '430700');
INSERT INTO `area` VALUES ('430721', '安乡县', '1860', '430700');
INSERT INTO `area` VALUES ('430722', '汉寿县', '1861', '430700');
INSERT INTO `area` VALUES ('430723', '澧　县', '1862', '430700');
INSERT INTO `area` VALUES ('430724', '临澧县', '1863', '430700');
INSERT INTO `area` VALUES ('430725', '桃源县', '1864', '430700');
INSERT INTO `area` VALUES ('430726', '石门县', '1865', '430700');
INSERT INTO `area` VALUES ('430781', '津市市', '1866', '430700');
INSERT INTO `area` VALUES ('430801', '市辖区', '1867', '430800');
INSERT INTO `area` VALUES ('430802', '永定区', '1868', '430800');
INSERT INTO `area` VALUES ('430811', '武陵源区', '1869', '430800');
INSERT INTO `area` VALUES ('430821', '慈利县', '1870', '430800');
INSERT INTO `area` VALUES ('430822', '桑植县', '1871', '430800');
INSERT INTO `area` VALUES ('430901', '市辖区', '1872', '430900');
INSERT INTO `area` VALUES ('430902', '资阳区', '1873', '430900');
INSERT INTO `area` VALUES ('430903', '赫山区', '1874', '430900');
INSERT INTO `area` VALUES ('430921', '南　县', '1875', '430900');
INSERT INTO `area` VALUES ('430922', '桃江县', '1876', '430900');
INSERT INTO `area` VALUES ('430923', '安化县', '1877', '430900');
INSERT INTO `area` VALUES ('430981', '沅江市', '1878', '430900');
INSERT INTO `area` VALUES ('431001', '市辖区', '1879', '431000');
INSERT INTO `area` VALUES ('431002', '北湖区', '1880', '431000');
INSERT INTO `area` VALUES ('431003', '苏仙区', '1881', '431000');
INSERT INTO `area` VALUES ('431021', '桂阳县', '1882', '431000');
INSERT INTO `area` VALUES ('431022', '宜章县', '1883', '431000');
INSERT INTO `area` VALUES ('431023', '永兴县', '1884', '431000');
INSERT INTO `area` VALUES ('431024', '嘉禾县', '1885', '431000');
INSERT INTO `area` VALUES ('431025', '临武县', '1886', '431000');
INSERT INTO `area` VALUES ('431026', '汝城县', '1887', '431000');
INSERT INTO `area` VALUES ('431027', '桂东县', '1888', '431000');
INSERT INTO `area` VALUES ('431028', '安仁县', '1889', '431000');
INSERT INTO `area` VALUES ('431081', '资兴市', '1890', '431000');
INSERT INTO `area` VALUES ('431101', '市辖区', '1891', '431100');
INSERT INTO `area` VALUES ('431102', '芝山区', '1892', '431100');
INSERT INTO `area` VALUES ('431103', '冷水滩区', '1893', '431100');
INSERT INTO `area` VALUES ('431121', '祁阳县', '1894', '431100');
INSERT INTO `area` VALUES ('431122', '东安县', '1895', '431100');
INSERT INTO `area` VALUES ('431123', '双牌县', '1896', '431100');
INSERT INTO `area` VALUES ('431124', '道　县', '1897', '431100');
INSERT INTO `area` VALUES ('431125', '江永县', '1898', '431100');
INSERT INTO `area` VALUES ('431126', '宁远县', '1899', '431100');
INSERT INTO `area` VALUES ('431127', '蓝山县', '1900', '431100');
INSERT INTO `area` VALUES ('431128', '新田县', '1901', '431100');
INSERT INTO `area` VALUES ('431129', '江华瑶族自治县', '1902', '431100');
INSERT INTO `area` VALUES ('431201', '市辖区', '1903', '431200');
INSERT INTO `area` VALUES ('431202', '鹤城区', '1904', '431200');
INSERT INTO `area` VALUES ('431221', '中方县', '1905', '431200');
INSERT INTO `area` VALUES ('431222', '沅陵县', '1906', '431200');
INSERT INTO `area` VALUES ('431223', '辰溪县', '1907', '431200');
INSERT INTO `area` VALUES ('431224', '溆浦县', '1908', '431200');
INSERT INTO `area` VALUES ('431225', '会同县', '1909', '431200');
INSERT INTO `area` VALUES ('431226', '麻阳苗族自治县', '1910', '431200');
INSERT INTO `area` VALUES ('431227', '新晃侗族自治县', '1911', '431200');
INSERT INTO `area` VALUES ('431228', '芷江侗族自治县', '1912', '431200');
INSERT INTO `area` VALUES ('431229', '靖州苗族侗族自治县', '1913', '431200');
INSERT INTO `area` VALUES ('431230', '通道侗族自治县', '1914', '431200');
INSERT INTO `area` VALUES ('431281', '洪江市', '1915', '431200');
INSERT INTO `area` VALUES ('431301', '市辖区', '1916', '431300');
INSERT INTO `area` VALUES ('431302', '娄星区', '1917', '431300');
INSERT INTO `area` VALUES ('431321', '双峰县', '1918', '431300');
INSERT INTO `area` VALUES ('431322', '新化县', '1919', '431300');
INSERT INTO `area` VALUES ('431381', '冷水江市', '1920', '431300');
INSERT INTO `area` VALUES ('431382', '涟源市', '1921', '431300');
INSERT INTO `area` VALUES ('433101', '吉首市', '1922', '433100');
INSERT INTO `area` VALUES ('433122', '泸溪县', '1923', '433100');
INSERT INTO `area` VALUES ('433123', '凤凰县', '1924', '433100');
INSERT INTO `area` VALUES ('433124', '花垣县', '1925', '433100');
INSERT INTO `area` VALUES ('433125', '保靖县', '1926', '433100');
INSERT INTO `area` VALUES ('433126', '古丈县', '1927', '433100');
INSERT INTO `area` VALUES ('433127', '永顺县', '1928', '433100');
INSERT INTO `area` VALUES ('433130', '龙山县', '1929', '433100');
INSERT INTO `area` VALUES ('440101', '市辖区', '1930', '440100');
INSERT INTO `area` VALUES ('440102', '东山区', '1931', '440100');
INSERT INTO `area` VALUES ('440103', '荔湾区', '1932', '440100');
INSERT INTO `area` VALUES ('440104', '越秀区', '1933', '440100');
INSERT INTO `area` VALUES ('440105', '海珠区', '1934', '440100');
INSERT INTO `area` VALUES ('440106', '天河区', '1935', '440100');
INSERT INTO `area` VALUES ('440107', '芳村区', '1936', '440100');
INSERT INTO `area` VALUES ('440111', '白云区', '1937', '440100');
INSERT INTO `area` VALUES ('440112', '黄埔区', '1938', '440100');
INSERT INTO `area` VALUES ('440113', '番禺区', '1939', '440100');
INSERT INTO `area` VALUES ('440114', '花都区', '1940', '440100');
INSERT INTO `area` VALUES ('440183', '增城市', '1941', '440100');
INSERT INTO `area` VALUES ('440184', '从化市', '1942', '440100');
INSERT INTO `area` VALUES ('440201', '市辖区', '1943', '440200');
INSERT INTO `area` VALUES ('440203', '武江区', '1944', '440200');
INSERT INTO `area` VALUES ('440204', '浈江区', '1945', '440200');
INSERT INTO `area` VALUES ('440205', '曲江区', '1946', '440200');
INSERT INTO `area` VALUES ('440222', '始兴县', '1947', '440200');
INSERT INTO `area` VALUES ('440224', '仁化县', '1948', '440200');
INSERT INTO `area` VALUES ('440229', '翁源县', '1949', '440200');
INSERT INTO `area` VALUES ('440232', '乳源瑶族自治县', '1950', '440200');
INSERT INTO `area` VALUES ('440233', '新丰县', '1951', '440200');
INSERT INTO `area` VALUES ('440281', '乐昌市', '1952', '440200');
INSERT INTO `area` VALUES ('440282', '南雄市', '1953', '440200');
INSERT INTO `area` VALUES ('440301', '市辖区', '1954', '440300');
INSERT INTO `area` VALUES ('440303', '罗湖区', '1955', '440300');
INSERT INTO `area` VALUES ('440304', '福田区', '1956', '440300');
INSERT INTO `area` VALUES ('440305', '南山区', '1957', '440300');
INSERT INTO `area` VALUES ('440306', '宝安区', '1958', '440300');
INSERT INTO `area` VALUES ('440307', '龙岗区', '1959', '440300');
INSERT INTO `area` VALUES ('440308', '盐田区', '1960', '440300');
INSERT INTO `area` VALUES ('440401', '市辖区', '1961', '440400');
INSERT INTO `area` VALUES ('440402', '香洲区', '1962', '440400');
INSERT INTO `area` VALUES ('440403', '斗门区', '1963', '440400');
INSERT INTO `area` VALUES ('440404', '金湾区', '1964', '440400');
INSERT INTO `area` VALUES ('440501', '市辖区', '1965', '440500');
INSERT INTO `area` VALUES ('440507', '龙湖区', '1966', '440500');
INSERT INTO `area` VALUES ('440511', '金平区', '1967', '440500');
INSERT INTO `area` VALUES ('440512', '濠江区', '1968', '440500');
INSERT INTO `area` VALUES ('440513', '潮阳区', '1969', '440500');
INSERT INTO `area` VALUES ('440514', '潮南区', '1970', '440500');
INSERT INTO `area` VALUES ('440515', '澄海区', '1971', '440500');
INSERT INTO `area` VALUES ('440523', '南澳县', '1972', '440500');
INSERT INTO `area` VALUES ('440601', '市辖区', '1973', '440600');
INSERT INTO `area` VALUES ('440604', '禅城区', '1974', '440600');
INSERT INTO `area` VALUES ('440605', '南海区', '1975', '440600');
INSERT INTO `area` VALUES ('440606', '顺德区', '1976', '440600');
INSERT INTO `area` VALUES ('440607', '三水区', '1977', '440600');
INSERT INTO `area` VALUES ('440608', '高明区', '1978', '440600');
INSERT INTO `area` VALUES ('440701', '市辖区', '1979', '440700');
INSERT INTO `area` VALUES ('440703', '蓬江区', '1980', '440700');
INSERT INTO `area` VALUES ('440704', '江海区', '1981', '440700');
INSERT INTO `area` VALUES ('440705', '新会区', '1982', '440700');
INSERT INTO `area` VALUES ('440781', '台山市', '1983', '440700');
INSERT INTO `area` VALUES ('440783', '开平市', '1984', '440700');
INSERT INTO `area` VALUES ('440784', '鹤山市', '1985', '440700');
INSERT INTO `area` VALUES ('440785', '恩平市', '1986', '440700');
INSERT INTO `area` VALUES ('440801', '市辖区', '1987', '440800');
INSERT INTO `area` VALUES ('440802', '赤坎区', '1988', '440800');
INSERT INTO `area` VALUES ('440803', '霞山区', '1989', '440800');
INSERT INTO `area` VALUES ('440804', '坡头区', '1990', '440800');
INSERT INTO `area` VALUES ('440811', '麻章区', '1991', '440800');
INSERT INTO `area` VALUES ('440823', '遂溪县', '1992', '440800');
INSERT INTO `area` VALUES ('440825', '徐闻县', '1993', '440800');
INSERT INTO `area` VALUES ('440881', '廉江市', '1994', '440800');
INSERT INTO `area` VALUES ('440882', '雷州市', '1995', '440800');
INSERT INTO `area` VALUES ('440883', '吴川市', '1996', '440800');
INSERT INTO `area` VALUES ('440901', '市辖区', '1997', '440900');
INSERT INTO `area` VALUES ('440902', '茂南区', '1998', '440900');
INSERT INTO `area` VALUES ('440903', '茂港区', '1999', '440900');
INSERT INTO `area` VALUES ('440923', '电白县', '2000', '440900');
INSERT INTO `area` VALUES ('440981', '高州市', '2001', '440900');
INSERT INTO `area` VALUES ('440982', '化州市', '2002', '440900');
INSERT INTO `area` VALUES ('440983', '信宜市', '2003', '440900');
INSERT INTO `area` VALUES ('441201', '市辖区', '2004', '441200');
INSERT INTO `area` VALUES ('441202', '端州区', '2005', '441200');
INSERT INTO `area` VALUES ('441203', '鼎湖区', '2006', '441200');
INSERT INTO `area` VALUES ('441223', '广宁县', '2007', '441200');
INSERT INTO `area` VALUES ('441224', '怀集县', '2008', '441200');
INSERT INTO `area` VALUES ('441225', '封开县', '2009', '441200');
INSERT INTO `area` VALUES ('441226', '德庆县', '2010', '441200');
INSERT INTO `area` VALUES ('441283', '高要市', '2011', '441200');
INSERT INTO `area` VALUES ('441284', '四会市', '2012', '441200');
INSERT INTO `area` VALUES ('441301', '市辖区', '2013', '441300');
INSERT INTO `area` VALUES ('441302', '惠城区', '2014', '441300');
INSERT INTO `area` VALUES ('441303', '惠阳区', '2015', '441300');
INSERT INTO `area` VALUES ('441322', '博罗县', '2016', '441300');
INSERT INTO `area` VALUES ('441323', '惠东县', '2017', '441300');
INSERT INTO `area` VALUES ('441324', '龙门县', '2018', '441300');
INSERT INTO `area` VALUES ('441401', '市辖区', '2019', '441400');
INSERT INTO `area` VALUES ('441402', '梅江区', '2020', '441400');
INSERT INTO `area` VALUES ('441421', '梅　县', '2021', '441400');
INSERT INTO `area` VALUES ('441422', '大埔县', '2022', '441400');
INSERT INTO `area` VALUES ('441423', '丰顺县', '2023', '441400');
INSERT INTO `area` VALUES ('441424', '五华县', '2024', '441400');
INSERT INTO `area` VALUES ('441426', '平远县', '2025', '441400');
INSERT INTO `area` VALUES ('441427', '蕉岭县', '2026', '441400');
INSERT INTO `area` VALUES ('441481', '兴宁市', '2027', '441400');
INSERT INTO `area` VALUES ('441501', '市辖区', '2028', '441500');
INSERT INTO `area` VALUES ('441502', '城　区', '2029', '441500');
INSERT INTO `area` VALUES ('441521', '海丰县', '2030', '441500');
INSERT INTO `area` VALUES ('441523', '陆河县', '2031', '441500');
INSERT INTO `area` VALUES ('441581', '陆丰市', '2032', '441500');
INSERT INTO `area` VALUES ('441601', '市辖区', '2033', '441600');
INSERT INTO `area` VALUES ('441602', '源城区', '2034', '441600');
INSERT INTO `area` VALUES ('441621', '紫金县', '2035', '441600');
INSERT INTO `area` VALUES ('441622', '龙川县', '2036', '441600');
INSERT INTO `area` VALUES ('441623', '连平县', '2037', '441600');
INSERT INTO `area` VALUES ('441624', '和平县', '2038', '441600');
INSERT INTO `area` VALUES ('441625', '东源县', '2039', '441600');
INSERT INTO `area` VALUES ('441701', '市辖区', '2040', '441700');
INSERT INTO `area` VALUES ('441702', '江城区', '2041', '441700');
INSERT INTO `area` VALUES ('441721', '阳西县', '2042', '441700');
INSERT INTO `area` VALUES ('441723', '阳东县', '2043', '441700');
INSERT INTO `area` VALUES ('441781', '阳春市', '2044', '441700');
INSERT INTO `area` VALUES ('441801', '市辖区', '2045', '441800');
INSERT INTO `area` VALUES ('441802', '清城区', '2046', '441800');
INSERT INTO `area` VALUES ('441821', '佛冈县', '2047', '441800');
INSERT INTO `area` VALUES ('441823', '阳山县', '2048', '441800');
INSERT INTO `area` VALUES ('441825', '连山壮族瑶族自治县', '2049', '441800');
INSERT INTO `area` VALUES ('441826', '连南瑶族自治县', '2050', '441800');
INSERT INTO `area` VALUES ('441827', '清新县', '2051', '441800');
INSERT INTO `area` VALUES ('441881', '英德市', '2052', '441800');
INSERT INTO `area` VALUES ('441882', '连州市', '2053', '441800');
INSERT INTO `area` VALUES ('445101', '市辖区', '2054', '445100');
INSERT INTO `area` VALUES ('445102', '湘桥区', '2055', '445100');
INSERT INTO `area` VALUES ('445121', '潮安县', '2056', '445100');
INSERT INTO `area` VALUES ('445122', '饶平县', '2057', '445100');
INSERT INTO `area` VALUES ('445201', '市辖区', '2058', '445200');
INSERT INTO `area` VALUES ('445202', '榕城区', '2059', '445200');
INSERT INTO `area` VALUES ('445221', '揭东县', '2060', '445200');
INSERT INTO `area` VALUES ('445222', '揭西县', '2061', '445200');
INSERT INTO `area` VALUES ('445224', '惠来县', '2062', '445200');
INSERT INTO `area` VALUES ('445281', '普宁市', '2063', '445200');
INSERT INTO `area` VALUES ('445301', '市辖区', '2064', '445300');
INSERT INTO `area` VALUES ('445302', '云城区', '2065', '445300');
INSERT INTO `area` VALUES ('445321', '新兴县', '2066', '445300');
INSERT INTO `area` VALUES ('445322', '郁南县', '2067', '445300');
INSERT INTO `area` VALUES ('445323', '云安县', '2068', '445300');
INSERT INTO `area` VALUES ('445381', '罗定市', '2069', '445300');
INSERT INTO `area` VALUES ('450101', '市辖区', '2070', '450100');
INSERT INTO `area` VALUES ('450102', '兴宁区', '2071', '450100');
INSERT INTO `area` VALUES ('450103', '青秀区', '2072', '450100');
INSERT INTO `area` VALUES ('450105', '江南区', '2073', '450100');
INSERT INTO `area` VALUES ('450107', '西乡塘区', '2074', '450100');
INSERT INTO `area` VALUES ('450108', '良庆区', '2075', '450100');
INSERT INTO `area` VALUES ('450109', '邕宁区', '2076', '450100');
INSERT INTO `area` VALUES ('450122', '武鸣县', '2077', '450100');
INSERT INTO `area` VALUES ('450123', '隆安县', '2078', '450100');
INSERT INTO `area` VALUES ('450124', '马山县', '2079', '450100');
INSERT INTO `area` VALUES ('450125', '上林县', '2080', '450100');
INSERT INTO `area` VALUES ('450126', '宾阳县', '2081', '450100');
INSERT INTO `area` VALUES ('450127', '横　县', '2082', '450100');
INSERT INTO `area` VALUES ('450201', '市辖区', '2083', '450200');
INSERT INTO `area` VALUES ('450202', '城中区', '2084', '450200');
INSERT INTO `area` VALUES ('450203', '鱼峰区', '2085', '450200');
INSERT INTO `area` VALUES ('450204', '柳南区', '2086', '450200');
INSERT INTO `area` VALUES ('450205', '柳北区', '2087', '450200');
INSERT INTO `area` VALUES ('450221', '柳江县', '2088', '450200');
INSERT INTO `area` VALUES ('450222', '柳城县', '2089', '450200');
INSERT INTO `area` VALUES ('450223', '鹿寨县', '2090', '450200');
INSERT INTO `area` VALUES ('450224', '融安县', '2091', '450200');
INSERT INTO `area` VALUES ('450225', '融水苗族自治县', '2092', '450200');
INSERT INTO `area` VALUES ('450226', '三江侗族自治县', '2093', '450200');
INSERT INTO `area` VALUES ('450301', '市辖区', '2094', '450300');
INSERT INTO `area` VALUES ('450302', '秀峰区', '2095', '450300');
INSERT INTO `area` VALUES ('450303', '叠彩区', '2096', '450300');
INSERT INTO `area` VALUES ('450304', '象山区', '2097', '450300');
INSERT INTO `area` VALUES ('450305', '七星区', '2098', '450300');
INSERT INTO `area` VALUES ('450311', '雁山区', '2099', '450300');
INSERT INTO `area` VALUES ('450321', '阳朔县', '2100', '450300');
INSERT INTO `area` VALUES ('450322', '临桂县', '2101', '450300');
INSERT INTO `area` VALUES ('450323', '灵川县', '2102', '450300');
INSERT INTO `area` VALUES ('450324', '全州县', '2103', '450300');
INSERT INTO `area` VALUES ('450325', '兴安县', '2104', '450300');
INSERT INTO `area` VALUES ('450326', '永福县', '2105', '450300');
INSERT INTO `area` VALUES ('450327', '灌阳县', '2106', '450300');
INSERT INTO `area` VALUES ('450328', '龙胜各族自治县', '2107', '450300');
INSERT INTO `area` VALUES ('450329', '资源县', '2108', '450300');
INSERT INTO `area` VALUES ('450330', '平乐县', '2109', '450300');
INSERT INTO `area` VALUES ('450331', '荔蒲县', '2110', '450300');
INSERT INTO `area` VALUES ('450332', '恭城瑶族自治县', '2111', '450300');
INSERT INTO `area` VALUES ('450401', '市辖区', '2112', '450400');
INSERT INTO `area` VALUES ('450403', '万秀区', '2113', '450400');
INSERT INTO `area` VALUES ('450404', '蝶山区', '2114', '450400');
INSERT INTO `area` VALUES ('450405', '长洲区', '2115', '450400');
INSERT INTO `area` VALUES ('450421', '苍梧县', '2116', '450400');
INSERT INTO `area` VALUES ('450422', '藤　县', '2117', '450400');
INSERT INTO `area` VALUES ('450423', '蒙山县', '2118', '450400');
INSERT INTO `area` VALUES ('450481', '岑溪市', '2119', '450400');
INSERT INTO `area` VALUES ('450501', '市辖区', '2120', '450500');
INSERT INTO `area` VALUES ('450502', '海城区', '2121', '450500');
INSERT INTO `area` VALUES ('450503', '银海区', '2122', '450500');
INSERT INTO `area` VALUES ('450512', '铁山港区', '2123', '450500');
INSERT INTO `area` VALUES ('450521', '合浦县', '2124', '450500');
INSERT INTO `area` VALUES ('450601', '市辖区', '2125', '450600');
INSERT INTO `area` VALUES ('450602', '港口区', '2126', '450600');
INSERT INTO `area` VALUES ('450603', '防城区', '2127', '450600');
INSERT INTO `area` VALUES ('450621', '上思县', '2128', '450600');
INSERT INTO `area` VALUES ('450681', '东兴市', '2129', '450600');
INSERT INTO `area` VALUES ('450701', '市辖区', '2130', '450700');
INSERT INTO `area` VALUES ('450702', '钦南区', '2131', '450700');
INSERT INTO `area` VALUES ('450703', '钦北区', '2132', '450700');
INSERT INTO `area` VALUES ('450721', '灵山县', '2133', '450700');
INSERT INTO `area` VALUES ('450722', '浦北县', '2134', '450700');
INSERT INTO `area` VALUES ('450801', '市辖区', '2135', '450800');
INSERT INTO `area` VALUES ('450802', '港北区', '2136', '450800');
INSERT INTO `area` VALUES ('450803', '港南区', '2137', '450800');
INSERT INTO `area` VALUES ('450804', '覃塘区', '2138', '450800');
INSERT INTO `area` VALUES ('450821', '平南县', '2139', '450800');
INSERT INTO `area` VALUES ('450881', '桂平市', '2140', '450800');
INSERT INTO `area` VALUES ('450901', '市辖区', '2141', '450900');
INSERT INTO `area` VALUES ('450902', '玉州区', '2142', '450900');
INSERT INTO `area` VALUES ('450921', '容　县', '2143', '450900');
INSERT INTO `area` VALUES ('450922', '陆川县', '2144', '450900');
INSERT INTO `area` VALUES ('450923', '博白县', '2145', '450900');
INSERT INTO `area` VALUES ('450924', '兴业县', '2146', '450900');
INSERT INTO `area` VALUES ('450981', '北流市', '2147', '450900');
INSERT INTO `area` VALUES ('451001', '市辖区', '2148', '451000');
INSERT INTO `area` VALUES ('451002', '右江区', '2149', '451000');
INSERT INTO `area` VALUES ('451021', '田阳县', '2150', '451000');
INSERT INTO `area` VALUES ('451022', '田东县', '2151', '451000');
INSERT INTO `area` VALUES ('451023', '平果县', '2152', '451000');
INSERT INTO `area` VALUES ('451024', '德保县', '2153', '451000');
INSERT INTO `area` VALUES ('451025', '靖西县', '2154', '451000');
INSERT INTO `area` VALUES ('451026', '那坡县', '2155', '451000');
INSERT INTO `area` VALUES ('451027', '凌云县', '2156', '451000');
INSERT INTO `area` VALUES ('451028', '乐业县', '2157', '451000');
INSERT INTO `area` VALUES ('451029', '田林县', '2158', '451000');
INSERT INTO `area` VALUES ('451030', '西林县', '2159', '451000');
INSERT INTO `area` VALUES ('451031', '隆林各族自治县', '2160', '451000');
INSERT INTO `area` VALUES ('451101', '市辖区', '2161', '451100');
INSERT INTO `area` VALUES ('451102', '八步区', '2162', '451100');
INSERT INTO `area` VALUES ('451121', '昭平县', '2163', '451100');
INSERT INTO `area` VALUES ('451122', '钟山县', '2164', '451100');
INSERT INTO `area` VALUES ('451123', '富川瑶族自治县', '2165', '451100');
INSERT INTO `area` VALUES ('451201', '市辖区', '2166', '451200');
INSERT INTO `area` VALUES ('451202', '金城江区', '2167', '451200');
INSERT INTO `area` VALUES ('451221', '南丹县', '2168', '451200');
INSERT INTO `area` VALUES ('451222', '天峨县', '2169', '451200');
INSERT INTO `area` VALUES ('451223', '凤山县', '2170', '451200');
INSERT INTO `area` VALUES ('451224', '东兰县', '2171', '451200');
INSERT INTO `area` VALUES ('451225', '罗城仫佬族自治县', '2172', '451200');
INSERT INTO `area` VALUES ('451226', '环江毛南族自治县', '2173', '451200');
INSERT INTO `area` VALUES ('451227', '巴马瑶族自治县', '2174', '451200');
INSERT INTO `area` VALUES ('451228', '都安瑶族自治县', '2175', '451200');
INSERT INTO `area` VALUES ('451229', '大化瑶族自治县', '2176', '451200');
INSERT INTO `area` VALUES ('451281', '宜州市', '2177', '451200');
INSERT INTO `area` VALUES ('451301', '市辖区', '2178', '451300');
INSERT INTO `area` VALUES ('451302', '兴宾区', '2179', '451300');
INSERT INTO `area` VALUES ('451321', '忻城县', '2180', '451300');
INSERT INTO `area` VALUES ('451322', '象州县', '2181', '451300');
INSERT INTO `area` VALUES ('451323', '武宣县', '2182', '451300');
INSERT INTO `area` VALUES ('451324', '金秀瑶族自治县', '2183', '451300');
INSERT INTO `area` VALUES ('451381', '合山市', '2184', '451300');
INSERT INTO `area` VALUES ('451401', '市辖区', '2185', '451400');
INSERT INTO `area` VALUES ('451402', '江洲区', '2186', '451400');
INSERT INTO `area` VALUES ('451421', '扶绥县', '2187', '451400');
INSERT INTO `area` VALUES ('451422', '宁明县', '2188', '451400');
INSERT INTO `area` VALUES ('451423', '龙州县', '2189', '451400');
INSERT INTO `area` VALUES ('451424', '大新县', '2190', '451400');
INSERT INTO `area` VALUES ('451425', '天等县', '2191', '451400');
INSERT INTO `area` VALUES ('451481', '凭祥市', '2192', '451400');
INSERT INTO `area` VALUES ('460101', '市辖区', '2193', '460100');
INSERT INTO `area` VALUES ('460105', '秀英区', '2194', '460100');
INSERT INTO `area` VALUES ('460106', '龙华区', '2195', '460100');
INSERT INTO `area` VALUES ('460107', '琼山区', '2196', '460100');
INSERT INTO `area` VALUES ('460108', '美兰区', '2197', '460100');
INSERT INTO `area` VALUES ('460201', '市辖区', '2198', '460200');
INSERT INTO `area` VALUES ('469001', '五指山市', '2199', '469000');
INSERT INTO `area` VALUES ('469002', '琼海市', '2200', '469000');
INSERT INTO `area` VALUES ('469003', '儋州市', '2201', '469000');
INSERT INTO `area` VALUES ('469005', '文昌市', '2202', '469000');
INSERT INTO `area` VALUES ('469006', '万宁市', '2203', '469000');
INSERT INTO `area` VALUES ('469007', '东方市', '2204', '469000');
INSERT INTO `area` VALUES ('469025', '定安县', '2205', '469000');
INSERT INTO `area` VALUES ('469026', '屯昌县', '2206', '469000');
INSERT INTO `area` VALUES ('469027', '澄迈县', '2207', '469000');
INSERT INTO `area` VALUES ('469028', '临高县', '2208', '469000');
INSERT INTO `area` VALUES ('469030', '白沙黎族自治县', '2209', '469000');
INSERT INTO `area` VALUES ('469031', '昌江黎族自治县', '2210', '469000');
INSERT INTO `area` VALUES ('469033', '乐东黎族自治县', '2211', '469000');
INSERT INTO `area` VALUES ('469034', '陵水黎族自治县', '2212', '469000');
INSERT INTO `area` VALUES ('469035', '保亭黎族苗族自治县', '2213', '469000');
INSERT INTO `area` VALUES ('469036', '琼中黎族苗族自治县', '2214', '469000');
INSERT INTO `area` VALUES ('469037', '西沙群岛', '2215', '469000');
INSERT INTO `area` VALUES ('469038', '南沙群岛', '2216', '469000');
INSERT INTO `area` VALUES ('469039', '中沙群岛的岛礁及其海域', '2217', '469000');
INSERT INTO `area` VALUES ('500101', '万州区', '2218', '500100');
INSERT INTO `area` VALUES ('500102', '涪陵区', '2219', '500100');
INSERT INTO `area` VALUES ('500103', '渝中区', '2220', '500100');
INSERT INTO `area` VALUES ('500104', '大渡口区', '2221', '500100');
INSERT INTO `area` VALUES ('500105', '江北区', '2222', '500100');
INSERT INTO `area` VALUES ('500106', '沙坪坝区', '2223', '500100');
INSERT INTO `area` VALUES ('500107', '九龙坡区', '2224', '500100');
INSERT INTO `area` VALUES ('500108', '南岸区', '2225', '500100');
INSERT INTO `area` VALUES ('500109', '北碚区', '2226', '500100');
INSERT INTO `area` VALUES ('500110', '万盛区', '2227', '500100');
INSERT INTO `area` VALUES ('500111', '双桥区', '2228', '500100');
INSERT INTO `area` VALUES ('500112', '渝北区', '2229', '500100');
INSERT INTO `area` VALUES ('500113', '巴南区', '2230', '500100');
INSERT INTO `area` VALUES ('500114', '黔江区', '2231', '500100');
INSERT INTO `area` VALUES ('500115', '长寿区', '2232', '500100');
INSERT INTO `area` VALUES ('500222', '綦江县', '2233', '500200');
INSERT INTO `area` VALUES ('500223', '潼南县', '2234', '500200');
INSERT INTO `area` VALUES ('500224', '铜梁县', '2235', '500200');
INSERT INTO `area` VALUES ('500225', '大足县', '2236', '500200');
INSERT INTO `area` VALUES ('500226', '荣昌县', '2237', '500200');
INSERT INTO `area` VALUES ('500227', '璧山县', '2238', '500200');
INSERT INTO `area` VALUES ('500228', '梁平县', '2239', '500200');
INSERT INTO `area` VALUES ('500229', '城口县', '2240', '500200');
INSERT INTO `area` VALUES ('500230', '丰都县', '2241', '500200');
INSERT INTO `area` VALUES ('500231', '垫江县', '2242', '500200');
INSERT INTO `area` VALUES ('500232', '武隆县', '2243', '500200');
INSERT INTO `area` VALUES ('500233', '忠　县', '2244', '500200');
INSERT INTO `area` VALUES ('500234', '开　县', '2245', '500200');
INSERT INTO `area` VALUES ('500235', '云阳县', '2246', '500200');
INSERT INTO `area` VALUES ('500236', '奉节县', '2247', '500200');
INSERT INTO `area` VALUES ('500237', '巫山县', '2248', '500200');
INSERT INTO `area` VALUES ('500238', '巫溪县', '2249', '500200');
INSERT INTO `area` VALUES ('500240', '石柱土家族自治县', '2250', '500200');
INSERT INTO `area` VALUES ('500241', '秀山土家族苗族自治县', '2251', '500200');
INSERT INTO `area` VALUES ('500242', '酉阳土家族苗族自治县', '2252', '500200');
INSERT INTO `area` VALUES ('500243', '彭水苗族土家族自治县', '2253', '500200');
INSERT INTO `area` VALUES ('500381', '江津市', '2254', '500300');
INSERT INTO `area` VALUES ('500382', '合川市', '2255', '500300');
INSERT INTO `area` VALUES ('500383', '永川市', '2256', '500300');
INSERT INTO `area` VALUES ('500384', '南川市', '2257', '500300');
INSERT INTO `area` VALUES ('510101', '市辖区', '2258', '510100');
INSERT INTO `area` VALUES ('510104', '锦江区', '2259', '510100');
INSERT INTO `area` VALUES ('510105', '青羊区', '2260', '510100');
INSERT INTO `area` VALUES ('510106', '金牛区', '2261', '510100');
INSERT INTO `area` VALUES ('510107', '武侯区', '2262', '510100');
INSERT INTO `area` VALUES ('510108', '成华区', '2263', '510100');
INSERT INTO `area` VALUES ('510112', '龙泉驿区', '2264', '510100');
INSERT INTO `area` VALUES ('510113', '青白江区', '2265', '510100');
INSERT INTO `area` VALUES ('510114', '新都区', '2266', '510100');
INSERT INTO `area` VALUES ('510115', '温江区', '2267', '510100');
INSERT INTO `area` VALUES ('510121', '金堂县', '2268', '510100');
INSERT INTO `area` VALUES ('510122', '双流县', '2269', '510100');
INSERT INTO `area` VALUES ('510124', '郫　县', '2270', '510100');
INSERT INTO `area` VALUES ('510129', '大邑县', '2271', '510100');
INSERT INTO `area` VALUES ('510131', '蒲江县', '2272', '510100');
INSERT INTO `area` VALUES ('510132', '新津县', '2273', '510100');
INSERT INTO `area` VALUES ('510181', '都江堰市', '2274', '510100');
INSERT INTO `area` VALUES ('510182', '彭州市', '2275', '510100');
INSERT INTO `area` VALUES ('510183', '邛崃市', '2276', '510100');
INSERT INTO `area` VALUES ('510184', '崇州市', '2277', '510100');
INSERT INTO `area` VALUES ('510301', '市辖区', '2278', '510300');
INSERT INTO `area` VALUES ('510302', '自流井区', '2279', '510300');
INSERT INTO `area` VALUES ('510303', '贡井区', '2280', '510300');
INSERT INTO `area` VALUES ('510304', '大安区', '2281', '510300');
INSERT INTO `area` VALUES ('510311', '沿滩区', '2282', '510300');
INSERT INTO `area` VALUES ('510321', '荣　县', '2283', '510300');
INSERT INTO `area` VALUES ('510322', '富顺县', '2284', '510300');
INSERT INTO `area` VALUES ('510401', '市辖区', '2285', '510400');
INSERT INTO `area` VALUES ('510402', '东　区', '2286', '510400');
INSERT INTO `area` VALUES ('510403', '西　区', '2287', '510400');
INSERT INTO `area` VALUES ('510411', '仁和区', '2288', '510400');
INSERT INTO `area` VALUES ('510421', '米易县', '2289', '510400');
INSERT INTO `area` VALUES ('510422', '盐边县', '2290', '510400');
INSERT INTO `area` VALUES ('510501', '市辖区', '2291', '510500');
INSERT INTO `area` VALUES ('510502', '江阳区', '2292', '510500');
INSERT INTO `area` VALUES ('510503', '纳溪区', '2293', '510500');
INSERT INTO `area` VALUES ('510504', '龙马潭区', '2294', '510500');
INSERT INTO `area` VALUES ('510521', '泸　县', '2295', '510500');
INSERT INTO `area` VALUES ('510522', '合江县', '2296', '510500');
INSERT INTO `area` VALUES ('510524', '叙永县', '2297', '510500');
INSERT INTO `area` VALUES ('510525', '古蔺县', '2298', '510500');
INSERT INTO `area` VALUES ('510601', '市辖区', '2299', '510600');
INSERT INTO `area` VALUES ('510603', '旌阳区', '2300', '510600');
INSERT INTO `area` VALUES ('510623', '中江县', '2301', '510600');
INSERT INTO `area` VALUES ('510626', '罗江县', '2302', '510600');
INSERT INTO `area` VALUES ('510681', '广汉市', '2303', '510600');
INSERT INTO `area` VALUES ('510682', '什邡市', '2304', '510600');
INSERT INTO `area` VALUES ('510683', '绵竹市', '2305', '510600');
INSERT INTO `area` VALUES ('510701', '市辖区', '2306', '510700');
INSERT INTO `area` VALUES ('510703', '涪城区', '2307', '510700');
INSERT INTO `area` VALUES ('510704', '游仙区', '2308', '510700');
INSERT INTO `area` VALUES ('510722', '三台县', '2309', '510700');
INSERT INTO `area` VALUES ('510723', '盐亭县', '2310', '510700');
INSERT INTO `area` VALUES ('510724', '安　县', '2311', '510700');
INSERT INTO `area` VALUES ('510725', '梓潼县', '2312', '510700');
INSERT INTO `area` VALUES ('510726', '北川羌族自治县', '2313', '510700');
INSERT INTO `area` VALUES ('510727', '平武县', '2314', '510700');
INSERT INTO `area` VALUES ('510781', '江油市', '2315', '510700');
INSERT INTO `area` VALUES ('510801', '市辖区', '2316', '510800');
INSERT INTO `area` VALUES ('510802', '市中区', '2317', '510800');
INSERT INTO `area` VALUES ('510811', '元坝区', '2318', '510800');
INSERT INTO `area` VALUES ('510812', '朝天区', '2319', '510800');
INSERT INTO `area` VALUES ('510821', '旺苍县', '2320', '510800');
INSERT INTO `area` VALUES ('510822', '青川县', '2321', '510800');
INSERT INTO `area` VALUES ('510823', '剑阁县', '2322', '510800');
INSERT INTO `area` VALUES ('510824', '苍溪县', '2323', '510800');
INSERT INTO `area` VALUES ('510901', '市辖区', '2324', '510900');
INSERT INTO `area` VALUES ('510903', '船山区', '2325', '510900');
INSERT INTO `area` VALUES ('510904', '安居区', '2326', '510900');
INSERT INTO `area` VALUES ('510921', '蓬溪县', '2327', '510900');
INSERT INTO `area` VALUES ('510922', '射洪县', '2328', '510900');
INSERT INTO `area` VALUES ('510923', '大英县', '2329', '510900');
INSERT INTO `area` VALUES ('511001', '市辖区', '2330', '511000');
INSERT INTO `area` VALUES ('511002', '市中区', '2331', '511000');
INSERT INTO `area` VALUES ('511011', '东兴区', '2332', '511000');
INSERT INTO `area` VALUES ('511024', '威远县', '2333', '511000');
INSERT INTO `area` VALUES ('511025', '资中县', '2334', '511000');
INSERT INTO `area` VALUES ('511028', '隆昌县', '2335', '511000');
INSERT INTO `area` VALUES ('511101', '市辖区', '2336', '511100');
INSERT INTO `area` VALUES ('511102', '市中区', '2337', '511100');
INSERT INTO `area` VALUES ('511111', '沙湾区', '2338', '511100');
INSERT INTO `area` VALUES ('511112', '五通桥区', '2339', '511100');
INSERT INTO `area` VALUES ('511113', '金口河区', '2340', '511100');
INSERT INTO `area` VALUES ('511123', '犍为县', '2341', '511100');
INSERT INTO `area` VALUES ('511124', '井研县', '2342', '511100');
INSERT INTO `area` VALUES ('511126', '夹江县', '2343', '511100');
INSERT INTO `area` VALUES ('511129', '沐川县', '2344', '511100');
INSERT INTO `area` VALUES ('511132', '峨边彝族自治县', '2345', '511100');
INSERT INTO `area` VALUES ('511133', '马边彝族自治县', '2346', '511100');
INSERT INTO `area` VALUES ('511181', '峨眉山市', '2347', '511100');
INSERT INTO `area` VALUES ('511301', '市辖区', '2348', '511300');
INSERT INTO `area` VALUES ('511302', '顺庆区', '2349', '511300');
INSERT INTO `area` VALUES ('511303', '高坪区', '2350', '511300');
INSERT INTO `area` VALUES ('511304', '嘉陵区', '2351', '511300');
INSERT INTO `area` VALUES ('511321', '南部县', '2352', '511300');
INSERT INTO `area` VALUES ('511322', '营山县', '2353', '511300');
INSERT INTO `area` VALUES ('511323', '蓬安县', '2354', '511300');
INSERT INTO `area` VALUES ('511324', '仪陇县', '2355', '511300');
INSERT INTO `area` VALUES ('511325', '西充县', '2356', '511300');
INSERT INTO `area` VALUES ('511381', '阆中市', '2357', '511300');
INSERT INTO `area` VALUES ('511401', '市辖区', '2358', '511400');
INSERT INTO `area` VALUES ('511402', '东坡区', '2359', '511400');
INSERT INTO `area` VALUES ('511421', '仁寿县', '2360', '511400');
INSERT INTO `area` VALUES ('511422', '彭山县', '2361', '511400');
INSERT INTO `area` VALUES ('511423', '洪雅县', '2362', '511400');
INSERT INTO `area` VALUES ('511424', '丹棱县', '2363', '511400');
INSERT INTO `area` VALUES ('511425', '青神县', '2364', '511400');
INSERT INTO `area` VALUES ('511501', '市辖区', '2365', '511500');
INSERT INTO `area` VALUES ('511502', '翠屏区', '2366', '511500');
INSERT INTO `area` VALUES ('511521', '宜宾县', '2367', '511500');
INSERT INTO `area` VALUES ('511522', '南溪县', '2368', '511500');
INSERT INTO `area` VALUES ('511523', '江安县', '2369', '511500');
INSERT INTO `area` VALUES ('511524', '长宁县', '2370', '511500');
INSERT INTO `area` VALUES ('511525', '高　县', '2371', '511500');
INSERT INTO `area` VALUES ('511526', '珙　县', '2372', '511500');
INSERT INTO `area` VALUES ('511527', '筠连县', '2373', '511500');
INSERT INTO `area` VALUES ('511528', '兴文县', '2374', '511500');
INSERT INTO `area` VALUES ('511529', '屏山县', '2375', '511500');
INSERT INTO `area` VALUES ('511601', '市辖区', '2376', '511600');
INSERT INTO `area` VALUES ('511602', '广安区', '2377', '511600');
INSERT INTO `area` VALUES ('511621', '岳池县', '2378', '511600');
INSERT INTO `area` VALUES ('511622', '武胜县', '2379', '511600');
INSERT INTO `area` VALUES ('511623', '邻水县', '2380', '511600');
INSERT INTO `area` VALUES ('511681', '华莹市', '2381', '511600');
INSERT INTO `area` VALUES ('511701', '市辖区', '2382', '511700');
INSERT INTO `area` VALUES ('511702', '通川区', '2383', '511700');
INSERT INTO `area` VALUES ('511721', '达　县', '2384', '511700');
INSERT INTO `area` VALUES ('511722', '宣汉县', '2385', '511700');
INSERT INTO `area` VALUES ('511723', '开江县', '2386', '511700');
INSERT INTO `area` VALUES ('511724', '大竹县', '2387', '511700');
INSERT INTO `area` VALUES ('511725', '渠　县', '2388', '511700');
INSERT INTO `area` VALUES ('511781', '万源市', '2389', '511700');
INSERT INTO `area` VALUES ('511801', '市辖区', '2390', '511800');
INSERT INTO `area` VALUES ('511802', '雨城区', '2391', '511800');
INSERT INTO `area` VALUES ('511821', '名山县', '2392', '511800');
INSERT INTO `area` VALUES ('511822', '荥经县', '2393', '511800');
INSERT INTO `area` VALUES ('511823', '汉源县', '2394', '511800');
INSERT INTO `area` VALUES ('511824', '石棉县', '2395', '511800');
INSERT INTO `area` VALUES ('511825', '天全县', '2396', '511800');
INSERT INTO `area` VALUES ('511826', '芦山县', '2397', '511800');
INSERT INTO `area` VALUES ('511827', '宝兴县', '2398', '511800');
INSERT INTO `area` VALUES ('511901', '市辖区', '2399', '511900');
INSERT INTO `area` VALUES ('511902', '巴州区', '2400', '511900');
INSERT INTO `area` VALUES ('511921', '通江县', '2401', '511900');
INSERT INTO `area` VALUES ('511922', '南江县', '2402', '511900');
INSERT INTO `area` VALUES ('511923', '平昌县', '2403', '511900');
INSERT INTO `area` VALUES ('512001', '市辖区', '2404', '512000');
INSERT INTO `area` VALUES ('512002', '雁江区', '2405', '512000');
INSERT INTO `area` VALUES ('512021', '安岳县', '2406', '512000');
INSERT INTO `area` VALUES ('512022', '乐至县', '2407', '512000');
INSERT INTO `area` VALUES ('512081', '简阳市', '2408', '512000');
INSERT INTO `area` VALUES ('513221', '汶川县', '2409', '513200');
INSERT INTO `area` VALUES ('513222', '理　县', '2410', '513200');
INSERT INTO `area` VALUES ('513223', '茂　县', '2411', '513200');
INSERT INTO `area` VALUES ('513224', '松潘县', '2412', '513200');
INSERT INTO `area` VALUES ('513225', '九寨沟县', '2413', '513200');
INSERT INTO `area` VALUES ('513226', '金川县', '2414', '513200');
INSERT INTO `area` VALUES ('513227', '小金县', '2415', '513200');
INSERT INTO `area` VALUES ('513228', '黑水县', '2416', '513200');
INSERT INTO `area` VALUES ('513229', '马尔康县', '2417', '513200');
INSERT INTO `area` VALUES ('513230', '壤塘县', '2418', '513200');
INSERT INTO `area` VALUES ('513231', '阿坝县', '2419', '513200');
INSERT INTO `area` VALUES ('513232', '若尔盖县', '2420', '513200');
INSERT INTO `area` VALUES ('513233', '红原县', '2421', '513200');
INSERT INTO `area` VALUES ('513321', '康定县', '2422', '513300');
INSERT INTO `area` VALUES ('513322', '泸定县', '2423', '513300');
INSERT INTO `area` VALUES ('513323', '丹巴县', '2424', '513300');
INSERT INTO `area` VALUES ('513324', '九龙县', '2425', '513300');
INSERT INTO `area` VALUES ('513325', '雅江县', '2426', '513300');
INSERT INTO `area` VALUES ('513326', '道孚县', '2427', '513300');
INSERT INTO `area` VALUES ('513327', '炉霍县', '2428', '513300');
INSERT INTO `area` VALUES ('513328', '甘孜县', '2429', '513300');
INSERT INTO `area` VALUES ('513329', '新龙县', '2430', '513300');
INSERT INTO `area` VALUES ('513330', '德格县', '2431', '513300');
INSERT INTO `area` VALUES ('513331', '白玉县', '2432', '513300');
INSERT INTO `area` VALUES ('513332', '石渠县', '2433', '513300');
INSERT INTO `area` VALUES ('513333', '色达县', '2434', '513300');
INSERT INTO `area` VALUES ('513334', '理塘县', '2435', '513300');
INSERT INTO `area` VALUES ('513335', '巴塘县', '2436', '513300');
INSERT INTO `area` VALUES ('513336', '乡城县', '2437', '513300');
INSERT INTO `area` VALUES ('513337', '稻城县', '2438', '513300');
INSERT INTO `area` VALUES ('513338', '得荣县', '2439', '513300');
INSERT INTO `area` VALUES ('513401', '西昌市', '2440', '513400');
INSERT INTO `area` VALUES ('513422', '木里藏族自治县', '2441', '513400');
INSERT INTO `area` VALUES ('513423', '盐源县', '2442', '513400');
INSERT INTO `area` VALUES ('513424', '德昌县', '2443', '513400');
INSERT INTO `area` VALUES ('513425', '会理县', '2444', '513400');
INSERT INTO `area` VALUES ('513426', '会东县', '2445', '513400');
INSERT INTO `area` VALUES ('513427', '宁南县', '2446', '513400');
INSERT INTO `area` VALUES ('513428', '普格县', '2447', '513400');
INSERT INTO `area` VALUES ('513429', '布拖县', '2448', '513400');
INSERT INTO `area` VALUES ('513430', '金阳县', '2449', '513400');
INSERT INTO `area` VALUES ('513431', '昭觉县', '2450', '513400');
INSERT INTO `area` VALUES ('513432', '喜德县', '2451', '513400');
INSERT INTO `area` VALUES ('513433', '冕宁县', '2452', '513400');
INSERT INTO `area` VALUES ('513434', '越西县', '2453', '513400');
INSERT INTO `area` VALUES ('513435', '甘洛县', '2454', '513400');
INSERT INTO `area` VALUES ('513436', '美姑县', '2455', '513400');
INSERT INTO `area` VALUES ('513437', '雷波县', '2456', '513400');
INSERT INTO `area` VALUES ('520101', '市辖区', '2457', '520100');
INSERT INTO `area` VALUES ('520102', '南明区', '2458', '520100');
INSERT INTO `area` VALUES ('520103', '云岩区', '2459', '520100');
INSERT INTO `area` VALUES ('520111', '花溪区', '2460', '520100');
INSERT INTO `area` VALUES ('520112', '乌当区', '2461', '520100');
INSERT INTO `area` VALUES ('520113', '白云区', '2462', '520100');
INSERT INTO `area` VALUES ('520114', '小河区', '2463', '520100');
INSERT INTO `area` VALUES ('520121', '开阳县', '2464', '520100');
INSERT INTO `area` VALUES ('520122', '息烽县', '2465', '520100');
INSERT INTO `area` VALUES ('520123', '修文县', '2466', '520100');
INSERT INTO `area` VALUES ('520181', '清镇市', '2467', '520100');
INSERT INTO `area` VALUES ('520201', '钟山区', '2468', '520200');
INSERT INTO `area` VALUES ('520203', '六枝特区', '2469', '520200');
INSERT INTO `area` VALUES ('520221', '水城县', '2470', '520200');
INSERT INTO `area` VALUES ('520222', '盘　县', '2471', '520200');
INSERT INTO `area` VALUES ('520301', '市辖区', '2472', '520300');
INSERT INTO `area` VALUES ('520302', '红花岗区', '2473', '520300');
INSERT INTO `area` VALUES ('520303', '汇川区', '2474', '520300');
INSERT INTO `area` VALUES ('520321', '遵义县', '2475', '520300');
INSERT INTO `area` VALUES ('520322', '桐梓县', '2476', '520300');
INSERT INTO `area` VALUES ('520323', '绥阳县', '2477', '520300');
INSERT INTO `area` VALUES ('520324', '正安县', '2478', '520300');
INSERT INTO `area` VALUES ('520325', '道真仡佬族苗族自治县', '2479', '520300');
INSERT INTO `area` VALUES ('520326', '务川仡佬族苗族自治县', '2480', '520300');
INSERT INTO `area` VALUES ('520327', '凤冈县', '2481', '520300');
INSERT INTO `area` VALUES ('520328', '湄潭县', '2482', '520300');
INSERT INTO `area` VALUES ('520329', '余庆县', '2483', '520300');
INSERT INTO `area` VALUES ('520330', '习水县', '2484', '520300');
INSERT INTO `area` VALUES ('520381', '赤水市', '2485', '520300');
INSERT INTO `area` VALUES ('520382', '仁怀市', '2486', '520300');
INSERT INTO `area` VALUES ('520401', '市辖区', '2487', '520400');
INSERT INTO `area` VALUES ('520402', '西秀区', '2488', '520400');
INSERT INTO `area` VALUES ('520421', '平坝县', '2489', '520400');
INSERT INTO `area` VALUES ('520422', '普定县', '2490', '520400');
INSERT INTO `area` VALUES ('520423', '镇宁布依族苗族自治县', '2491', '520400');
INSERT INTO `area` VALUES ('520424', '关岭布依族苗族自治县', '2492', '520400');
INSERT INTO `area` VALUES ('520425', '紫云苗族布依族自治县', '2493', '520400');
INSERT INTO `area` VALUES ('522201', '铜仁市', '2494', '522200');
INSERT INTO `area` VALUES ('522222', '江口县', '2495', '522200');
INSERT INTO `area` VALUES ('522223', '玉屏侗族自治县', '2496', '522200');
INSERT INTO `area` VALUES ('522224', '石阡县', '2497', '522200');
INSERT INTO `area` VALUES ('522225', '思南县', '2498', '522200');
INSERT INTO `area` VALUES ('522226', '印江土家族苗族自治县', '2499', '522200');
INSERT INTO `area` VALUES ('522227', '德江县', '2500', '522200');
INSERT INTO `area` VALUES ('522228', '沿河土家族自治县', '2501', '522200');
INSERT INTO `area` VALUES ('522229', '松桃苗族自治县', '2502', '522200');
INSERT INTO `area` VALUES ('522230', '万山特区', '2503', '522200');
INSERT INTO `area` VALUES ('522301', '兴义市', '2504', '522300');
INSERT INTO `area` VALUES ('522322', '兴仁县', '2505', '522300');
INSERT INTO `area` VALUES ('522323', '普安县', '2506', '522300');
INSERT INTO `area` VALUES ('522324', '晴隆县', '2507', '522300');
INSERT INTO `area` VALUES ('522325', '贞丰县', '2508', '522300');
INSERT INTO `area` VALUES ('522326', '望谟县', '2509', '522300');
INSERT INTO `area` VALUES ('522327', '册亨县', '2510', '522300');
INSERT INTO `area` VALUES ('522328', '安龙县', '2511', '522300');
INSERT INTO `area` VALUES ('522401', '毕节市', '2512', '522400');
INSERT INTO `area` VALUES ('522422', '大方县', '2513', '522400');
INSERT INTO `area` VALUES ('522423', '黔西县', '2514', '522400');
INSERT INTO `area` VALUES ('522424', '金沙县', '2515', '522400');
INSERT INTO `area` VALUES ('522425', '织金县', '2516', '522400');
INSERT INTO `area` VALUES ('522426', '纳雍县', '2517', '522400');
INSERT INTO `area` VALUES ('522427', '威宁彝族回族苗族自治县', '2518', '522400');
INSERT INTO `area` VALUES ('522428', '赫章县', '2519', '522400');
INSERT INTO `area` VALUES ('522601', '凯里市', '2520', '522600');
INSERT INTO `area` VALUES ('522622', '黄平县', '2521', '522600');
INSERT INTO `area` VALUES ('522623', '施秉县', '2522', '522600');
INSERT INTO `area` VALUES ('522624', '三穗县', '2523', '522600');
INSERT INTO `area` VALUES ('522625', '镇远县', '2524', '522600');
INSERT INTO `area` VALUES ('522626', '岑巩县', '2525', '522600');
INSERT INTO `area` VALUES ('522627', '天柱县', '2526', '522600');
INSERT INTO `area` VALUES ('522628', '锦屏县', '2527', '522600');
INSERT INTO `area` VALUES ('522629', '剑河县', '2528', '522600');
INSERT INTO `area` VALUES ('522630', '台江县', '2529', '522600');
INSERT INTO `area` VALUES ('522631', '黎平县', '2530', '522600');
INSERT INTO `area` VALUES ('522632', '榕江县', '2531', '522600');
INSERT INTO `area` VALUES ('522633', '从江县', '2532', '522600');
INSERT INTO `area` VALUES ('522634', '雷山县', '2533', '522600');
INSERT INTO `area` VALUES ('522635', '麻江县', '2534', '522600');
INSERT INTO `area` VALUES ('522636', '丹寨县', '2535', '522600');
INSERT INTO `area` VALUES ('522701', '都匀市', '2536', '522700');
INSERT INTO `area` VALUES ('522702', '福泉市', '2537', '522700');
INSERT INTO `area` VALUES ('522722', '荔波县', '2538', '522700');
INSERT INTO `area` VALUES ('522723', '贵定县', '2539', '522700');
INSERT INTO `area` VALUES ('522725', '瓮安县', '2540', '522700');
INSERT INTO `area` VALUES ('522726', '独山县', '2541', '522700');
INSERT INTO `area` VALUES ('522727', '平塘县', '2542', '522700');
INSERT INTO `area` VALUES ('522728', '罗甸县', '2543', '522700');
INSERT INTO `area` VALUES ('522729', '长顺县', '2544', '522700');
INSERT INTO `area` VALUES ('522730', '龙里县', '2545', '522700');
INSERT INTO `area` VALUES ('522731', '惠水县', '2546', '522700');
INSERT INTO `area` VALUES ('522732', '三都水族自治县', '2547', '522700');
INSERT INTO `area` VALUES ('530101', '市辖区', '2548', '530100');
INSERT INTO `area` VALUES ('530102', '五华区', '2549', '530100');
INSERT INTO `area` VALUES ('530103', '盘龙区', '2550', '530100');
INSERT INTO `area` VALUES ('530111', '官渡区', '2551', '530100');
INSERT INTO `area` VALUES ('530112', '西山区', '2552', '530100');
INSERT INTO `area` VALUES ('530113', '东川区', '2553', '530100');
INSERT INTO `area` VALUES ('530121', '呈贡县', '2554', '530100');
INSERT INTO `area` VALUES ('530122', '晋宁县', '2555', '530100');
INSERT INTO `area` VALUES ('530124', '富民县', '2556', '530100');
INSERT INTO `area` VALUES ('530125', '宜良县', '2557', '530100');
INSERT INTO `area` VALUES ('530126', '石林彝族自治县', '2558', '530100');
INSERT INTO `area` VALUES ('530127', '嵩明县', '2559', '530100');
INSERT INTO `area` VALUES ('530128', '禄劝彝族苗族自治县', '2560', '530100');
INSERT INTO `area` VALUES ('530129', '寻甸回族彝族自治县', '2561', '530100');
INSERT INTO `area` VALUES ('530181', '安宁市', '2562', '530100');
INSERT INTO `area` VALUES ('530301', '市辖区', '2563', '530300');
INSERT INTO `area` VALUES ('530302', '麒麟区', '2564', '530300');
INSERT INTO `area` VALUES ('530321', '马龙县', '2565', '530300');
INSERT INTO `area` VALUES ('530322', '陆良县', '2566', '530300');
INSERT INTO `area` VALUES ('530323', '师宗县', '2567', '530300');
INSERT INTO `area` VALUES ('530324', '罗平县', '2568', '530300');
INSERT INTO `area` VALUES ('530325', '富源县', '2569', '530300');
INSERT INTO `area` VALUES ('530326', '会泽县', '2570', '530300');
INSERT INTO `area` VALUES ('530328', '沾益县', '2571', '530300');
INSERT INTO `area` VALUES ('530381', '宣威市', '2572', '530300');
INSERT INTO `area` VALUES ('530401', '市辖区', '2573', '530400');
INSERT INTO `area` VALUES ('530402', '红塔区', '2574', '530400');
INSERT INTO `area` VALUES ('530421', '江川县', '2575', '530400');
INSERT INTO `area` VALUES ('530422', '澄江县', '2576', '530400');
INSERT INTO `area` VALUES ('530423', '通海县', '2577', '530400');
INSERT INTO `area` VALUES ('530424', '华宁县', '2578', '530400');
INSERT INTO `area` VALUES ('530425', '易门县', '2579', '530400');
INSERT INTO `area` VALUES ('530426', '峨山彝族自治县', '2580', '530400');
INSERT INTO `area` VALUES ('530427', '新平彝族傣族自治县', '2581', '530400');
INSERT INTO `area` VALUES ('530428', '元江哈尼族彝族傣族自治县', '2582', '530400');
INSERT INTO `area` VALUES ('530501', '市辖区', '2583', '530500');
INSERT INTO `area` VALUES ('530502', '隆阳区', '2584', '530500');
INSERT INTO `area` VALUES ('530521', '施甸县', '2585', '530500');
INSERT INTO `area` VALUES ('530522', '腾冲县', '2586', '530500');
INSERT INTO `area` VALUES ('530523', '龙陵县', '2587', '530500');
INSERT INTO `area` VALUES ('530524', '昌宁县', '2588', '530500');
INSERT INTO `area` VALUES ('530601', '市辖区', '2589', '530600');
INSERT INTO `area` VALUES ('530602', '昭阳区', '2590', '530600');
INSERT INTO `area` VALUES ('530621', '鲁甸县', '2591', '530600');
INSERT INTO `area` VALUES ('530622', '巧家县', '2592', '530600');
INSERT INTO `area` VALUES ('530623', '盐津县', '2593', '530600');
INSERT INTO `area` VALUES ('530624', '大关县', '2594', '530600');
INSERT INTO `area` VALUES ('530625', '永善县', '2595', '530600');
INSERT INTO `area` VALUES ('530626', '绥江县', '2596', '530600');
INSERT INTO `area` VALUES ('530627', '镇雄县', '2597', '530600');
INSERT INTO `area` VALUES ('530628', '彝良县', '2598', '530600');
INSERT INTO `area` VALUES ('530629', '威信县', '2599', '530600');
INSERT INTO `area` VALUES ('530630', '水富县', '2600', '530600');
INSERT INTO `area` VALUES ('530701', '市辖区', '2601', '530700');
INSERT INTO `area` VALUES ('530702', '古城区', '2602', '530700');
INSERT INTO `area` VALUES ('530721', '玉龙纳西族自治县', '2603', '530700');
INSERT INTO `area` VALUES ('530722', '永胜县', '2604', '530700');
INSERT INTO `area` VALUES ('530723', '华坪县', '2605', '530700');
INSERT INTO `area` VALUES ('530724', '宁蒗彝族自治县', '2606', '530700');
INSERT INTO `area` VALUES ('530801', '市辖区', '2607', '530800');
INSERT INTO `area` VALUES ('530802', '翠云区', '2608', '530800');
INSERT INTO `area` VALUES ('530821', '普洱哈尼族彝族自治县', '2609', '530800');
INSERT INTO `area` VALUES ('530822', '墨江哈尼族自治县', '2610', '530800');
INSERT INTO `area` VALUES ('530823', '景东彝族自治县', '2611', '530800');
INSERT INTO `area` VALUES ('530824', '景谷傣族彝族自治县', '2612', '530800');
INSERT INTO `area` VALUES ('530825', '镇沅彝族哈尼族拉祜族自治县', '2613', '530800');
INSERT INTO `area` VALUES ('530826', '江城哈尼族彝族自治县', '2614', '530800');
INSERT INTO `area` VALUES ('530827', '孟连傣族拉祜族佤族自治县', '2615', '530800');
INSERT INTO `area` VALUES ('530828', '澜沧拉祜族自治县', '2616', '530800');
INSERT INTO `area` VALUES ('530829', '西盟佤族自治县', '2617', '530800');
INSERT INTO `area` VALUES ('530901', '市辖区', '2618', '530900');
INSERT INTO `area` VALUES ('530902', '临翔区', '2619', '530900');
INSERT INTO `area` VALUES ('530921', '凤庆县', '2620', '530900');
INSERT INTO `area` VALUES ('530922', '云　县', '2621', '530900');
INSERT INTO `area` VALUES ('530923', '永德县', '2622', '530900');
INSERT INTO `area` VALUES ('530924', '镇康县', '2623', '530900');
INSERT INTO `area` VALUES ('530925', '双江拉祜族佤族布朗族傣族自治县', '2624', '530900');
INSERT INTO `area` VALUES ('530926', '耿马傣族佤族自治县', '2625', '530900');
INSERT INTO `area` VALUES ('530927', '沧源佤族自治县', '2626', '530900');
INSERT INTO `area` VALUES ('532301', '楚雄市', '2627', '532300');
INSERT INTO `area` VALUES ('532322', '双柏县', '2628', '532300');
INSERT INTO `area` VALUES ('532323', '牟定县', '2629', '532300');
INSERT INTO `area` VALUES ('532324', '南华县', '2630', '532300');
INSERT INTO `area` VALUES ('532325', '姚安县', '2631', '532300');
INSERT INTO `area` VALUES ('532326', '大姚县', '2632', '532300');
INSERT INTO `area` VALUES ('532327', '永仁县', '2633', '532300');
INSERT INTO `area` VALUES ('532328', '元谋县', '2634', '532300');
INSERT INTO `area` VALUES ('532329', '武定县', '2635', '532300');
INSERT INTO `area` VALUES ('532331', '禄丰县', '2636', '532300');
INSERT INTO `area` VALUES ('532501', '个旧市', '2637', '532500');
INSERT INTO `area` VALUES ('532502', '开远市', '2638', '532500');
INSERT INTO `area` VALUES ('532522', '蒙自县', '2639', '532500');
INSERT INTO `area` VALUES ('532523', '屏边苗族自治县', '2640', '532500');
INSERT INTO `area` VALUES ('532524', '建水县', '2641', '532500');
INSERT INTO `area` VALUES ('532525', '石屏县', '2642', '532500');
INSERT INTO `area` VALUES ('532526', '弥勒县', '2643', '532500');
INSERT INTO `area` VALUES ('532527', '泸西县', '2644', '532500');
INSERT INTO `area` VALUES ('532528', '元阳县', '2645', '532500');
INSERT INTO `area` VALUES ('532529', '红河县', '2646', '532500');
INSERT INTO `area` VALUES ('532530', '金平苗族瑶族傣族自治县', '2647', '532500');
INSERT INTO `area` VALUES ('532531', '绿春县', '2648', '532500');
INSERT INTO `area` VALUES ('532532', '河口瑶族自治县', '2649', '532500');
INSERT INTO `area` VALUES ('532621', '文山县', '2650', '532600');
INSERT INTO `area` VALUES ('532622', '砚山县', '2651', '532600');
INSERT INTO `area` VALUES ('532623', '西畴县', '2652', '532600');
INSERT INTO `area` VALUES ('532624', '麻栗坡县', '2653', '532600');
INSERT INTO `area` VALUES ('532625', '马关县', '2654', '532600');
INSERT INTO `area` VALUES ('532626', '丘北县', '2655', '532600');
INSERT INTO `area` VALUES ('532627', '广南县', '2656', '532600');
INSERT INTO `area` VALUES ('532628', '富宁县', '2657', '532600');
INSERT INTO `area` VALUES ('532801', '景洪市', '2658', '532800');
INSERT INTO `area` VALUES ('532822', '勐海县', '2659', '532800');
INSERT INTO `area` VALUES ('532823', '勐腊县', '2660', '532800');
INSERT INTO `area` VALUES ('532901', '大理市', '2661', '532900');
INSERT INTO `area` VALUES ('532922', '漾濞彝族自治县', '2662', '532900');
INSERT INTO `area` VALUES ('532923', '祥云县', '2663', '532900');
INSERT INTO `area` VALUES ('532924', '宾川县', '2664', '532900');
INSERT INTO `area` VALUES ('532925', '弥渡县', '2665', '532900');
INSERT INTO `area` VALUES ('532926', '南涧彝族自治县', '2666', '532900');
INSERT INTO `area` VALUES ('532927', '巍山彝族回族自治县', '2667', '532900');
INSERT INTO `area` VALUES ('532928', '永平县', '2668', '532900');
INSERT INTO `area` VALUES ('532929', '云龙县', '2669', '532900');
INSERT INTO `area` VALUES ('532930', '洱源县', '2670', '532900');
INSERT INTO `area` VALUES ('532931', '剑川县', '2671', '532900');
INSERT INTO `area` VALUES ('532932', '鹤庆县', '2672', '532900');
INSERT INTO `area` VALUES ('533102', '瑞丽市', '2673', '533100');
INSERT INTO `area` VALUES ('533103', '潞西市', '2674', '533100');
INSERT INTO `area` VALUES ('533122', '梁河县', '2675', '533100');
INSERT INTO `area` VALUES ('533123', '盈江县', '2676', '533100');
INSERT INTO `area` VALUES ('533124', '陇川县', '2677', '533100');
INSERT INTO `area` VALUES ('533321', '泸水县', '2678', '533300');
INSERT INTO `area` VALUES ('533323', '福贡县', '2679', '533300');
INSERT INTO `area` VALUES ('533324', '贡山独龙族怒族自治县', '2680', '533300');
INSERT INTO `area` VALUES ('533325', '兰坪白族普米族自治县', '2681', '533300');
INSERT INTO `area` VALUES ('533421', '香格里拉县', '2682', '533400');
INSERT INTO `area` VALUES ('533422', '德钦县', '2683', '533400');
INSERT INTO `area` VALUES ('533423', '维西傈僳族自治县', '2684', '533400');
INSERT INTO `area` VALUES ('540101', '市辖区', '2685', '540100');
INSERT INTO `area` VALUES ('540102', '城关区', '2686', '540100');
INSERT INTO `area` VALUES ('540121', '林周县', '2687', '540100');
INSERT INTO `area` VALUES ('540122', '当雄县', '2688', '540100');
INSERT INTO `area` VALUES ('540123', '尼木县', '2689', '540100');
INSERT INTO `area` VALUES ('540124', '曲水县', '2690', '540100');
INSERT INTO `area` VALUES ('540125', '堆龙德庆县', '2691', '540100');
INSERT INTO `area` VALUES ('540126', '达孜县', '2692', '540100');
INSERT INTO `area` VALUES ('540127', '墨竹工卡县', '2693', '540100');
INSERT INTO `area` VALUES ('542121', '昌都县', '2694', '542100');
INSERT INTO `area` VALUES ('542122', '江达县', '2695', '542100');
INSERT INTO `area` VALUES ('542123', '贡觉县', '2696', '542100');
INSERT INTO `area` VALUES ('542124', '类乌齐县', '2697', '542100');
INSERT INTO `area` VALUES ('542125', '丁青县', '2698', '542100');
INSERT INTO `area` VALUES ('542126', '察雅县', '2699', '542100');
INSERT INTO `area` VALUES ('542127', '八宿县', '2700', '542100');
INSERT INTO `area` VALUES ('542128', '左贡县', '2701', '542100');
INSERT INTO `area` VALUES ('542129', '芒康县', '2702', '542100');
INSERT INTO `area` VALUES ('542132', '洛隆县', '2703', '542100');
INSERT INTO `area` VALUES ('542133', '边坝县', '2704', '542100');
INSERT INTO `area` VALUES ('542221', '乃东县', '2705', '542200');
INSERT INTO `area` VALUES ('542222', '扎囊县', '2706', '542200');
INSERT INTO `area` VALUES ('542223', '贡嘎县', '2707', '542200');
INSERT INTO `area` VALUES ('542224', '桑日县', '2708', '542200');
INSERT INTO `area` VALUES ('542225', '琼结县', '2709', '542200');
INSERT INTO `area` VALUES ('542226', '曲松县', '2710', '542200');
INSERT INTO `area` VALUES ('542227', '措美县', '2711', '542200');
INSERT INTO `area` VALUES ('542228', '洛扎县', '2712', '542200');
INSERT INTO `area` VALUES ('542229', '加查县', '2713', '542200');
INSERT INTO `area` VALUES ('542231', '隆子县', '2714', '542200');
INSERT INTO `area` VALUES ('542232', '错那县', '2715', '542200');
INSERT INTO `area` VALUES ('542233', '浪卡子县', '2716', '542200');
INSERT INTO `area` VALUES ('542301', '日喀则市', '2717', '542300');
INSERT INTO `area` VALUES ('542322', '南木林县', '2718', '542300');
INSERT INTO `area` VALUES ('542323', '江孜县', '2719', '542300');
INSERT INTO `area` VALUES ('542324', '定日县', '2720', '542300');
INSERT INTO `area` VALUES ('542325', '萨迦县', '2721', '542300');
INSERT INTO `area` VALUES ('542326', '拉孜县', '2722', '542300');
INSERT INTO `area` VALUES ('542327', '昂仁县', '2723', '542300');
INSERT INTO `area` VALUES ('542328', '谢通门县', '2724', '542300');
INSERT INTO `area` VALUES ('542329', '白朗县', '2725', '542300');
INSERT INTO `area` VALUES ('542330', '仁布县', '2726', '542300');
INSERT INTO `area` VALUES ('542331', '康马县', '2727', '542300');
INSERT INTO `area` VALUES ('542332', '定结县', '2728', '542300');
INSERT INTO `area` VALUES ('542333', '仲巴县', '2729', '542300');
INSERT INTO `area` VALUES ('542334', '亚东县', '2730', '542300');
INSERT INTO `area` VALUES ('542335', '吉隆县', '2731', '542300');
INSERT INTO `area` VALUES ('542336', '聂拉木县', '2732', '542300');
INSERT INTO `area` VALUES ('542337', '萨嘎县', '2733', '542300');
INSERT INTO `area` VALUES ('542338', '岗巴县', '2734', '542300');
INSERT INTO `area` VALUES ('542421', '那曲县', '2735', '542400');
INSERT INTO `area` VALUES ('542422', '嘉黎县', '2736', '542400');
INSERT INTO `area` VALUES ('542423', '比如县', '2737', '542400');
INSERT INTO `area` VALUES ('542424', '聂荣县', '2738', '542400');
INSERT INTO `area` VALUES ('542425', '安多县', '2739', '542400');
INSERT INTO `area` VALUES ('542426', '申扎县', '2740', '542400');
INSERT INTO `area` VALUES ('542427', '索　县', '2741', '542400');
INSERT INTO `area` VALUES ('542428', '班戈县', '2742', '542400');
INSERT INTO `area` VALUES ('542429', '巴青县', '2743', '542400');
INSERT INTO `area` VALUES ('542430', '尼玛县', '2744', '542400');
INSERT INTO `area` VALUES ('542521', '普兰县', '2745', '542500');
INSERT INTO `area` VALUES ('542522', '札达县', '2746', '542500');
INSERT INTO `area` VALUES ('542523', '噶尔县', '2747', '542500');
INSERT INTO `area` VALUES ('542524', '日土县', '2748', '542500');
INSERT INTO `area` VALUES ('542525', '革吉县', '2749', '542500');
INSERT INTO `area` VALUES ('542526', '改则县', '2750', '542500');
INSERT INTO `area` VALUES ('542527', '措勤县', '2751', '542500');
INSERT INTO `area` VALUES ('542621', '林芝县', '2752', '542600');
INSERT INTO `area` VALUES ('542622', '工布江达县', '2753', '542600');
INSERT INTO `area` VALUES ('542623', '米林县', '2754', '542600');
INSERT INTO `area` VALUES ('542624', '墨脱县', '2755', '542600');
INSERT INTO `area` VALUES ('542625', '波密县', '2756', '542600');
INSERT INTO `area` VALUES ('542626', '察隅县', '2757', '542600');
INSERT INTO `area` VALUES ('542627', '朗　县', '2758', '542600');
INSERT INTO `area` VALUES ('610101', '市辖区', '2759', '610100');
INSERT INTO `area` VALUES ('610102', '新城区', '2760', '610100');
INSERT INTO `area` VALUES ('610103', '碑林区', '2761', '610100');
INSERT INTO `area` VALUES ('610104', '莲湖区', '2762', '610100');
INSERT INTO `area` VALUES ('610111', '灞桥区', '2763', '610100');
INSERT INTO `area` VALUES ('610112', '未央区', '2764', '610100');
INSERT INTO `area` VALUES ('610113', '雁塔区', '2765', '610100');
INSERT INTO `area` VALUES ('610114', '阎良区', '2766', '610100');
INSERT INTO `area` VALUES ('610115', '临潼区', '2767', '610100');
INSERT INTO `area` VALUES ('610116', '长安区', '2768', '610100');
INSERT INTO `area` VALUES ('610122', '蓝田县', '2769', '610100');
INSERT INTO `area` VALUES ('610124', '周至县', '2770', '610100');
INSERT INTO `area` VALUES ('610125', '户　县', '2771', '610100');
INSERT INTO `area` VALUES ('610126', '高陵县', '2772', '610100');
INSERT INTO `area` VALUES ('610201', '市辖区', '2773', '610200');
INSERT INTO `area` VALUES ('610202', '王益区', '2774', '610200');
INSERT INTO `area` VALUES ('610203', '印台区', '2775', '610200');
INSERT INTO `area` VALUES ('610204', '耀州区', '2776', '610200');
INSERT INTO `area` VALUES ('610222', '宜君县', '2777', '610200');
INSERT INTO `area` VALUES ('610301', '市辖区', '2778', '610300');
INSERT INTO `area` VALUES ('610302', '渭滨区', '2779', '610300');
INSERT INTO `area` VALUES ('610303', '金台区', '2780', '610300');
INSERT INTO `area` VALUES ('610304', '陈仓区', '2781', '610300');
INSERT INTO `area` VALUES ('610322', '凤翔县', '2782', '610300');
INSERT INTO `area` VALUES ('610323', '岐山县', '2783', '610300');
INSERT INTO `area` VALUES ('610324', '扶风县', '2784', '610300');
INSERT INTO `area` VALUES ('610326', '眉　县', '2785', '610300');
INSERT INTO `area` VALUES ('610327', '陇　县', '2786', '610300');
INSERT INTO `area` VALUES ('610328', '千阳县', '2787', '610300');
INSERT INTO `area` VALUES ('610329', '麟游县', '2788', '610300');
INSERT INTO `area` VALUES ('610330', '凤　县', '2789', '610300');
INSERT INTO `area` VALUES ('610331', '太白县', '2790', '610300');
INSERT INTO `area` VALUES ('610401', '市辖区', '2791', '610400');
INSERT INTO `area` VALUES ('610402', '秦都区', '2792', '610400');
INSERT INTO `area` VALUES ('610403', '杨凌区', '2793', '610400');
INSERT INTO `area` VALUES ('610404', '渭城区', '2794', '610400');
INSERT INTO `area` VALUES ('610422', '三原县', '2795', '610400');
INSERT INTO `area` VALUES ('610423', '泾阳县', '2796', '610400');
INSERT INTO `area` VALUES ('610424', '乾　县', '2797', '610400');
INSERT INTO `area` VALUES ('610425', '礼泉县', '2798', '610400');
INSERT INTO `area` VALUES ('610426', '永寿县', '2799', '610400');
INSERT INTO `area` VALUES ('610427', '彬　县', '2800', '610400');
INSERT INTO `area` VALUES ('610428', '长武县', '2801', '610400');
INSERT INTO `area` VALUES ('610429', '旬邑县', '2802', '610400');
INSERT INTO `area` VALUES ('610430', '淳化县', '2803', '610400');
INSERT INTO `area` VALUES ('610431', '武功县', '2804', '610400');
INSERT INTO `area` VALUES ('610481', '兴平市', '2805', '610400');
INSERT INTO `area` VALUES ('610501', '市辖区', '2806', '610500');
INSERT INTO `area` VALUES ('610502', '临渭区', '2807', '610500');
INSERT INTO `area` VALUES ('610521', '华　县', '2808', '610500');
INSERT INTO `area` VALUES ('610522', '潼关县', '2809', '610500');
INSERT INTO `area` VALUES ('610523', '大荔县', '2810', '610500');
INSERT INTO `area` VALUES ('610524', '合阳县', '2811', '610500');
INSERT INTO `area` VALUES ('610525', '澄城县', '2812', '610500');
INSERT INTO `area` VALUES ('610526', '蒲城县', '2813', '610500');
INSERT INTO `area` VALUES ('610527', '白水县', '2814', '610500');
INSERT INTO `area` VALUES ('610528', '富平县', '2815', '610500');
INSERT INTO `area` VALUES ('610581', '韩城市', '2816', '610500');
INSERT INTO `area` VALUES ('610582', '华阴市', '2817', '610500');
INSERT INTO `area` VALUES ('610601', '市辖区', '2818', '610600');
INSERT INTO `area` VALUES ('610602', '宝塔区', '2819', '610600');
INSERT INTO `area` VALUES ('610621', '延长县', '2820', '610600');
INSERT INTO `area` VALUES ('610622', '延川县', '2821', '610600');
INSERT INTO `area` VALUES ('610623', '子长县', '2822', '610600');
INSERT INTO `area` VALUES ('610624', '安塞县', '2823', '610600');
INSERT INTO `area` VALUES ('610625', '志丹县', '2824', '610600');
INSERT INTO `area` VALUES ('610626', '吴旗县', '2825', '610600');
INSERT INTO `area` VALUES ('610627', '甘泉县', '2826', '610600');
INSERT INTO `area` VALUES ('610628', '富　县', '2827', '610600');
INSERT INTO `area` VALUES ('610629', '洛川县', '2828', '610600');
INSERT INTO `area` VALUES ('610630', '宜川县', '2829', '610600');
INSERT INTO `area` VALUES ('610631', '黄龙县', '2830', '610600');
INSERT INTO `area` VALUES ('610632', '黄陵县', '2831', '610600');
INSERT INTO `area` VALUES ('610701', '市辖区', '2832', '610700');
INSERT INTO `area` VALUES ('610702', '汉台区', '2833', '610700');
INSERT INTO `area` VALUES ('610721', '南郑县', '2834', '610700');
INSERT INTO `area` VALUES ('610722', '城固县', '2835', '610700');
INSERT INTO `area` VALUES ('610723', '洋　县', '2836', '610700');
INSERT INTO `area` VALUES ('610724', '西乡县', '2837', '610700');
INSERT INTO `area` VALUES ('610725', '勉　县', '2838', '610700');
INSERT INTO `area` VALUES ('610726', '宁强县', '2839', '610700');
INSERT INTO `area` VALUES ('610727', '略阳县', '2840', '610700');
INSERT INTO `area` VALUES ('610728', '镇巴县', '2841', '610700');
INSERT INTO `area` VALUES ('610729', '留坝县', '2842', '610700');
INSERT INTO `area` VALUES ('610730', '佛坪县', '2843', '610700');
INSERT INTO `area` VALUES ('610801', '市辖区', '2844', '610800');
INSERT INTO `area` VALUES ('610802', '榆阳区', '2845', '610800');
INSERT INTO `area` VALUES ('610821', '神木县', '2846', '610800');
INSERT INTO `area` VALUES ('610822', '府谷县', '2847', '610800');
INSERT INTO `area` VALUES ('610823', '横山县', '2848', '610800');
INSERT INTO `area` VALUES ('610824', '靖边县', '2849', '610800');
INSERT INTO `area` VALUES ('610825', '定边县', '2850', '610800');
INSERT INTO `area` VALUES ('610826', '绥德县', '2851', '610800');
INSERT INTO `area` VALUES ('610827', '米脂县', '2852', '610800');
INSERT INTO `area` VALUES ('610828', '佳　县', '2853', '610800');
INSERT INTO `area` VALUES ('610829', '吴堡县', '2854', '610800');
INSERT INTO `area` VALUES ('610830', '清涧县', '2855', '610800');
INSERT INTO `area` VALUES ('610831', '子洲县', '2856', '610800');
INSERT INTO `area` VALUES ('610901', '市辖区', '2857', '610900');
INSERT INTO `area` VALUES ('610902', '汉滨区', '2858', '610900');
INSERT INTO `area` VALUES ('610921', '汉阴县', '2859', '610900');
INSERT INTO `area` VALUES ('610922', '石泉县', '2860', '610900');
INSERT INTO `area` VALUES ('610923', '宁陕县', '2861', '610900');
INSERT INTO `area` VALUES ('610924', '紫阳县', '2862', '610900');
INSERT INTO `area` VALUES ('610925', '岚皋县', '2863', '610900');
INSERT INTO `area` VALUES ('610926', '平利县', '2864', '610900');
INSERT INTO `area` VALUES ('610927', '镇坪县', '2865', '610900');
INSERT INTO `area` VALUES ('610928', '旬阳县', '2866', '610900');
INSERT INTO `area` VALUES ('610929', '白河县', '2867', '610900');
INSERT INTO `area` VALUES ('611001', '市辖区', '2868', '611000');
INSERT INTO `area` VALUES ('611002', '商州区', '2869', '611000');
INSERT INTO `area` VALUES ('611021', '洛南县', '2870', '611000');
INSERT INTO `area` VALUES ('611022', '丹凤县', '2871', '611000');
INSERT INTO `area` VALUES ('611023', '商南县', '2872', '611000');
INSERT INTO `area` VALUES ('611024', '山阳县', '2873', '611000');
INSERT INTO `area` VALUES ('611025', '镇安县', '2874', '611000');
INSERT INTO `area` VALUES ('611026', '柞水县', '2875', '611000');
INSERT INTO `area` VALUES ('620101', '市辖区', '2876', '620100');
INSERT INTO `area` VALUES ('620102', '城关区', '2877', '620100');
INSERT INTO `area` VALUES ('620103', '七里河区', '2878', '620100');
INSERT INTO `area` VALUES ('620104', '西固区', '2879', '620100');
INSERT INTO `area` VALUES ('620105', '安宁区', '2880', '620100');
INSERT INTO `area` VALUES ('620111', '红古区', '2881', '620100');
INSERT INTO `area` VALUES ('620121', '永登县', '2882', '620100');
INSERT INTO `area` VALUES ('620122', '皋兰县', '2883', '620100');
INSERT INTO `area` VALUES ('620123', '榆中县', '2884', '620100');
INSERT INTO `area` VALUES ('620201', '市辖区', '2885', '620200');
INSERT INTO `area` VALUES ('620301', '市辖区', '2886', '620300');
INSERT INTO `area` VALUES ('620302', '金川区', '2887', '620300');
INSERT INTO `area` VALUES ('620321', '永昌县', '2888', '620300');
INSERT INTO `area` VALUES ('620401', '市辖区', '2889', '620400');
INSERT INTO `area` VALUES ('620402', '白银区', '2890', '620400');
INSERT INTO `area` VALUES ('620403', '平川区', '2891', '620400');
INSERT INTO `area` VALUES ('620421', '靖远县', '2892', '620400');
INSERT INTO `area` VALUES ('620422', '会宁县', '2893', '620400');
INSERT INTO `area` VALUES ('620423', '景泰县', '2894', '620400');
INSERT INTO `area` VALUES ('620501', '市辖区', '2895', '620500');
INSERT INTO `area` VALUES ('620502', '秦城区', '2896', '620500');
INSERT INTO `area` VALUES ('620503', '北道区', '2897', '620500');
INSERT INTO `area` VALUES ('620521', '清水县', '2898', '620500');
INSERT INTO `area` VALUES ('620522', '秦安县', '2899', '620500');
INSERT INTO `area` VALUES ('620523', '甘谷县', '2900', '620500');
INSERT INTO `area` VALUES ('620524', '武山县', '2901', '620500');
INSERT INTO `area` VALUES ('620525', '张家川回族自治县', '2902', '620500');
INSERT INTO `area` VALUES ('620601', '市辖区', '2903', '620600');
INSERT INTO `area` VALUES ('620602', '凉州区', '2904', '620600');
INSERT INTO `area` VALUES ('620621', '民勤县', '2905', '620600');
INSERT INTO `area` VALUES ('620622', '古浪县', '2906', '620600');
INSERT INTO `area` VALUES ('620623', '天祝藏族自治县', '2907', '620600');
INSERT INTO `area` VALUES ('620701', '市辖区', '2908', '620700');
INSERT INTO `area` VALUES ('620702', '甘州区', '2909', '620700');
INSERT INTO `area` VALUES ('620721', '肃南裕固族自治县', '2910', '620700');
INSERT INTO `area` VALUES ('620722', '民乐县', '2911', '620700');
INSERT INTO `area` VALUES ('620723', '临泽县', '2912', '620700');
INSERT INTO `area` VALUES ('620724', '高台县', '2913', '620700');
INSERT INTO `area` VALUES ('620725', '山丹县', '2914', '620700');
INSERT INTO `area` VALUES ('620801', '市辖区', '2915', '620800');
INSERT INTO `area` VALUES ('620802', '崆峒区', '2916', '620800');
INSERT INTO `area` VALUES ('620821', '泾川县', '2917', '620800');
INSERT INTO `area` VALUES ('620822', '灵台县', '2918', '620800');
INSERT INTO `area` VALUES ('620823', '崇信县', '2919', '620800');
INSERT INTO `area` VALUES ('620824', '华亭县', '2920', '620800');
INSERT INTO `area` VALUES ('620825', '庄浪县', '2921', '620800');
INSERT INTO `area` VALUES ('620826', '静宁县', '2922', '620800');
INSERT INTO `area` VALUES ('620901', '市辖区', '2923', '620900');
INSERT INTO `area` VALUES ('620902', '肃州区', '2924', '620900');
INSERT INTO `area` VALUES ('620921', '金塔县', '2925', '620900');
INSERT INTO `area` VALUES ('620922', '安西县', '2926', '620900');
INSERT INTO `area` VALUES ('620923', '肃北蒙古族自治县', '2927', '620900');
INSERT INTO `area` VALUES ('620924', '阿克塞哈萨克族自治县', '2928', '620900');
INSERT INTO `area` VALUES ('620981', '玉门市', '2929', '620900');
INSERT INTO `area` VALUES ('620982', '敦煌市', '2930', '620900');
INSERT INTO `area` VALUES ('621001', '市辖区', '2931', '621000');
INSERT INTO `area` VALUES ('621002', '西峰区', '2932', '621000');
INSERT INTO `area` VALUES ('621021', '庆城县', '2933', '621000');
INSERT INTO `area` VALUES ('621022', '环　县', '2934', '621000');
INSERT INTO `area` VALUES ('621023', '华池县', '2935', '621000');
INSERT INTO `area` VALUES ('621024', '合水县', '2936', '621000');
INSERT INTO `area` VALUES ('621025', '正宁县', '2937', '621000');
INSERT INTO `area` VALUES ('621026', '宁　县', '2938', '621000');
INSERT INTO `area` VALUES ('621027', '镇原县', '2939', '621000');
INSERT INTO `area` VALUES ('621101', '市辖区', '2940', '621100');
INSERT INTO `area` VALUES ('621102', '安定区', '2941', '621100');
INSERT INTO `area` VALUES ('621121', '通渭县', '2942', '621100');
INSERT INTO `area` VALUES ('621122', '陇西县', '2943', '621100');
INSERT INTO `area` VALUES ('621123', '渭源县', '2944', '621100');
INSERT INTO `area` VALUES ('621124', '临洮县', '2945', '621100');
INSERT INTO `area` VALUES ('621125', '漳　县', '2946', '621100');
INSERT INTO `area` VALUES ('621126', '岷　县', '2947', '621100');
INSERT INTO `area` VALUES ('621201', '市辖区', '2948', '621200');
INSERT INTO `area` VALUES ('621202', '武都区', '2949', '621200');
INSERT INTO `area` VALUES ('621221', '成　县', '2950', '621200');
INSERT INTO `area` VALUES ('621222', '文　县', '2951', '621200');
INSERT INTO `area` VALUES ('621223', '宕昌县', '2952', '621200');
INSERT INTO `area` VALUES ('621224', '康　县', '2953', '621200');
INSERT INTO `area` VALUES ('621225', '西和县', '2954', '621200');
INSERT INTO `area` VALUES ('621226', '礼　县', '2955', '621200');
INSERT INTO `area` VALUES ('621227', '徽　县', '2956', '621200');
INSERT INTO `area` VALUES ('621228', '两当县', '2957', '621200');
INSERT INTO `area` VALUES ('622901', '临夏市', '2958', '622900');
INSERT INTO `area` VALUES ('622921', '临夏县', '2959', '622900');
INSERT INTO `area` VALUES ('622922', '康乐县', '2960', '622900');
INSERT INTO `area` VALUES ('622923', '永靖县', '2961', '622900');
INSERT INTO `area` VALUES ('622924', '广河县', '2962', '622900');
INSERT INTO `area` VALUES ('622925', '和政县', '2963', '622900');
INSERT INTO `area` VALUES ('622926', '东乡族自治县', '2964', '622900');
INSERT INTO `area` VALUES ('622927', '积石山保安族东乡族撒拉族自治县', '2965', '622900');
INSERT INTO `area` VALUES ('623001', '合作市', '2966', '623000');
INSERT INTO `area` VALUES ('623021', '临潭县', '2967', '623000');
INSERT INTO `area` VALUES ('623022', '卓尼县', '2968', '623000');
INSERT INTO `area` VALUES ('623023', '舟曲县', '2969', '623000');
INSERT INTO `area` VALUES ('623024', '迭部县', '2970', '623000');
INSERT INTO `area` VALUES ('623025', '玛曲县', '2971', '623000');
INSERT INTO `area` VALUES ('623026', '碌曲县', '2972', '623000');
INSERT INTO `area` VALUES ('623027', '夏河县', '2973', '623000');
INSERT INTO `area` VALUES ('630101', '市辖区', '2974', '630100');
INSERT INTO `area` VALUES ('630102', '城东区', '2975', '630100');
INSERT INTO `area` VALUES ('630103', '城中区', '2976', '630100');
INSERT INTO `area` VALUES ('630104', '城西区', '2977', '630100');
INSERT INTO `area` VALUES ('630105', '城北区', '2978', '630100');
INSERT INTO `area` VALUES ('630121', '大通回族土族自治县', '2979', '630100');
INSERT INTO `area` VALUES ('630122', '湟中县', '2980', '630100');
INSERT INTO `area` VALUES ('630123', '湟源县', '2981', '630100');
INSERT INTO `area` VALUES ('632121', '平安县', '2982', '632100');
INSERT INTO `area` VALUES ('632122', '民和回族土族自治县', '2983', '632100');
INSERT INTO `area` VALUES ('632123', '乐都县', '2984', '632100');
INSERT INTO `area` VALUES ('632126', '互助土族自治县', '2985', '632100');
INSERT INTO `area` VALUES ('632127', '化隆回族自治县', '2986', '632100');
INSERT INTO `area` VALUES ('632128', '循化撒拉族自治县', '2987', '632100');
INSERT INTO `area` VALUES ('632221', '门源回族自治县', '2988', '632200');
INSERT INTO `area` VALUES ('632222', '祁连县', '2989', '632200');
INSERT INTO `area` VALUES ('632223', '海晏县', '2990', '632200');
INSERT INTO `area` VALUES ('632224', '刚察县', '2991', '632200');
INSERT INTO `area` VALUES ('632321', '同仁县', '2992', '632300');
INSERT INTO `area` VALUES ('632322', '尖扎县', '2993', '632300');
INSERT INTO `area` VALUES ('632323', '泽库县', '2994', '632300');
INSERT INTO `area` VALUES ('632324', '河南蒙古族自治县', '2995', '632300');
INSERT INTO `area` VALUES ('632521', '共和县', '2996', '632500');
INSERT INTO `area` VALUES ('632522', '同德县', '2997', '632500');
INSERT INTO `area` VALUES ('632523', '贵德县', '2998', '632500');
INSERT INTO `area` VALUES ('632524', '兴海县', '2999', '632500');
INSERT INTO `area` VALUES ('632525', '贵南县', '3000', '632500');
INSERT INTO `area` VALUES ('632621', '玛沁县', '3001', '632600');
INSERT INTO `area` VALUES ('632622', '班玛县', '3002', '632600');
INSERT INTO `area` VALUES ('632623', '甘德县', '3003', '632600');
INSERT INTO `area` VALUES ('632624', '达日县', '3004', '632600');
INSERT INTO `area` VALUES ('632625', '久治县', '3005', '632600');
INSERT INTO `area` VALUES ('632626', '玛多县', '3006', '632600');
INSERT INTO `area` VALUES ('632721', '玉树县', '3007', '632700');
INSERT INTO `area` VALUES ('632722', '杂多县', '3008', '632700');
INSERT INTO `area` VALUES ('632723', '称多县', '3009', '632700');
INSERT INTO `area` VALUES ('632724', '治多县', '3010', '632700');
INSERT INTO `area` VALUES ('632725', '囊谦县', '3011', '632700');
INSERT INTO `area` VALUES ('632726', '曲麻莱县', '3012', '632700');
INSERT INTO `area` VALUES ('632801', '格尔木市', '3013', '632800');
INSERT INTO `area` VALUES ('632802', '德令哈市', '3014', '632800');
INSERT INTO `area` VALUES ('632821', '乌兰县', '3015', '632800');
INSERT INTO `area` VALUES ('632822', '都兰县', '3016', '632800');
INSERT INTO `area` VALUES ('632823', '天峻县', '3017', '632800');
INSERT INTO `area` VALUES ('640101', '市辖区', '3018', '640100');
INSERT INTO `area` VALUES ('640104', '兴庆区', '3019', '640100');
INSERT INTO `area` VALUES ('640105', '西夏区', '3020', '640100');
INSERT INTO `area` VALUES ('640106', '金凤区', '3021', '640100');
INSERT INTO `area` VALUES ('640121', '永宁县', '3022', '640100');
INSERT INTO `area` VALUES ('640122', '贺兰县', '3023', '640100');
INSERT INTO `area` VALUES ('640181', '灵武市', '3024', '640100');
INSERT INTO `area` VALUES ('640201', '市辖区', '3025', '640200');
INSERT INTO `area` VALUES ('640202', '大武口区', '3026', '640200');
INSERT INTO `area` VALUES ('640205', '惠农区', '3027', '640200');
INSERT INTO `area` VALUES ('640221', '平罗县', '3028', '640200');
INSERT INTO `area` VALUES ('640301', '市辖区', '3029', '640300');
INSERT INTO `area` VALUES ('640302', '利通区', '3030', '640300');
INSERT INTO `area` VALUES ('640323', '盐池县', '3031', '640300');
INSERT INTO `area` VALUES ('640324', '同心县', '3032', '640300');
INSERT INTO `area` VALUES ('640381', '青铜峡市', '3033', '640300');
INSERT INTO `area` VALUES ('640401', '市辖区', '3034', '640400');
INSERT INTO `area` VALUES ('640402', '原州区', '3035', '640400');
INSERT INTO `area` VALUES ('640422', '西吉县', '3036', '640400');
INSERT INTO `area` VALUES ('640423', '隆德县', '3037', '640400');
INSERT INTO `area` VALUES ('640424', '泾源县', '3038', '640400');
INSERT INTO `area` VALUES ('640425', '彭阳县', '3039', '640400');
INSERT INTO `area` VALUES ('640501', '市辖区', '3040', '640500');
INSERT INTO `area` VALUES ('640502', '沙坡头区', '3041', '640500');
INSERT INTO `area` VALUES ('640521', '中宁县', '3042', '640500');
INSERT INTO `area` VALUES ('640522', '海原县', '3043', '640500');
INSERT INTO `area` VALUES ('650101', '市辖区', '3044', '650100');
INSERT INTO `area` VALUES ('650102', '天山区', '3045', '650100');
INSERT INTO `area` VALUES ('650103', '沙依巴克区', '3046', '650100');
INSERT INTO `area` VALUES ('650104', '新市区', '3047', '650100');
INSERT INTO `area` VALUES ('650105', '水磨沟区', '3048', '650100');
INSERT INTO `area` VALUES ('650106', '头屯河区', '3049', '650100');
INSERT INTO `area` VALUES ('650107', '达坂城区', '3050', '650100');
INSERT INTO `area` VALUES ('650108', '东山区', '3051', '650100');
INSERT INTO `area` VALUES ('650121', '乌鲁木齐县', '3052', '650100');
INSERT INTO `area` VALUES ('650201', '市辖区', '3053', '650200');
INSERT INTO `area` VALUES ('650202', '独山子区', '3054', '650200');
INSERT INTO `area` VALUES ('650203', '克拉玛依区', '3055', '650200');
INSERT INTO `area` VALUES ('650204', '白碱滩区', '3056', '650200');
INSERT INTO `area` VALUES ('650205', '乌尔禾区', '3057', '650200');
INSERT INTO `area` VALUES ('652101', '吐鲁番市', '3058', '652100');
INSERT INTO `area` VALUES ('652122', '鄯善县', '3059', '652100');
INSERT INTO `area` VALUES ('652123', '托克逊县', '3060', '652100');
INSERT INTO `area` VALUES ('652201', '哈密市', '3061', '652200');
INSERT INTO `area` VALUES ('652222', '巴里坤哈萨克自治县', '3062', '652200');
INSERT INTO `area` VALUES ('652223', '伊吾县', '3063', '652200');
INSERT INTO `area` VALUES ('652301', '昌吉市', '3064', '652300');
INSERT INTO `area` VALUES ('652302', '阜康市', '3065', '652300');
INSERT INTO `area` VALUES ('652303', '米泉市', '3066', '652300');
INSERT INTO `area` VALUES ('652323', '呼图壁县', '3067', '652300');
INSERT INTO `area` VALUES ('652324', '玛纳斯县', '3068', '652300');
INSERT INTO `area` VALUES ('652325', '奇台县', '3069', '652300');
INSERT INTO `area` VALUES ('652327', '吉木萨尔县', '3070', '652300');
INSERT INTO `area` VALUES ('652328', '木垒哈萨克自治县', '3071', '652300');
INSERT INTO `area` VALUES ('652701', '博乐市', '3072', '652700');
INSERT INTO `area` VALUES ('652722', '精河县', '3073', '652700');
INSERT INTO `area` VALUES ('652723', '温泉县', '3074', '652700');
INSERT INTO `area` VALUES ('652801', '库尔勒市', '3075', '652800');
INSERT INTO `area` VALUES ('652822', '轮台县', '3076', '652800');
INSERT INTO `area` VALUES ('652823', '尉犁县', '3077', '652800');
INSERT INTO `area` VALUES ('652824', '若羌县', '3078', '652800');
INSERT INTO `area` VALUES ('652825', '且末县', '3079', '652800');
INSERT INTO `area` VALUES ('652826', '焉耆回族自治县', '3080', '652800');
INSERT INTO `area` VALUES ('652827', '和静县', '3081', '652800');
INSERT INTO `area` VALUES ('652828', '和硕县', '3082', '652800');
INSERT INTO `area` VALUES ('652829', '博湖县', '3083', '652800');
INSERT INTO `area` VALUES ('652901', '阿克苏市', '3084', '652900');
INSERT INTO `area` VALUES ('652922', '温宿县', '3085', '652900');
INSERT INTO `area` VALUES ('652923', '库车县', '3086', '652900');
INSERT INTO `area` VALUES ('652924', '沙雅县', '3087', '652900');
INSERT INTO `area` VALUES ('652925', '新和县', '3088', '652900');
INSERT INTO `area` VALUES ('652926', '拜城县', '3089', '652900');
INSERT INTO `area` VALUES ('652927', '乌什县', '3090', '652900');
INSERT INTO `area` VALUES ('652928', '阿瓦提县', '3091', '652900');
INSERT INTO `area` VALUES ('652929', '柯坪县', '3092', '652900');
INSERT INTO `area` VALUES ('653001', '阿图什市', '3093', '653000');
INSERT INTO `area` VALUES ('653022', '阿克陶县', '3094', '653000');
INSERT INTO `area` VALUES ('653023', '阿合奇县', '3095', '653000');
INSERT INTO `area` VALUES ('653024', '乌恰县', '3096', '653000');
INSERT INTO `area` VALUES ('653101', '喀什市', '3097', '653100');
INSERT INTO `area` VALUES ('653121', '疏附县', '3098', '653100');
INSERT INTO `area` VALUES ('653122', '疏勒县', '3099', '653100');
INSERT INTO `area` VALUES ('653123', '英吉沙县', '3100', '653100');
INSERT INTO `area` VALUES ('653124', '泽普县', '3101', '653100');
INSERT INTO `area` VALUES ('653125', '莎车县', '3102', '653100');
INSERT INTO `area` VALUES ('653126', '叶城县', '3103', '653100');
INSERT INTO `area` VALUES ('653127', '麦盖提县', '3104', '653100');
INSERT INTO `area` VALUES ('653128', '岳普湖县', '3105', '653100');
INSERT INTO `area` VALUES ('653129', '伽师县', '3106', '653100');
INSERT INTO `area` VALUES ('653130', '巴楚县', '3107', '653100');
INSERT INTO `area` VALUES ('653131', '塔什库尔干塔吉克自治县', '3108', '653100');
INSERT INTO `area` VALUES ('653201', '和田市', '3109', '653200');
INSERT INTO `area` VALUES ('653221', '和田县', '3110', '653200');
INSERT INTO `area` VALUES ('653222', '墨玉县', '3111', '653200');
INSERT INTO `area` VALUES ('653223', '皮山县', '3112', '653200');
INSERT INTO `area` VALUES ('653224', '洛浦县', '3113', '653200');
INSERT INTO `area` VALUES ('653225', '策勒县', '3114', '653200');
INSERT INTO `area` VALUES ('653226', '于田县', '3115', '653200');
INSERT INTO `area` VALUES ('653227', '民丰县', '3116', '653200');
INSERT INTO `area` VALUES ('654002', '伊宁市', '3117', '654000');
INSERT INTO `area` VALUES ('654003', '奎屯市', '3118', '654000');
INSERT INTO `area` VALUES ('654021', '伊宁县', '3119', '654000');
INSERT INTO `area` VALUES ('654022', '察布查尔锡伯自治县', '3120', '654000');
INSERT INTO `area` VALUES ('654023', '霍城县', '3121', '654000');
INSERT INTO `area` VALUES ('654024', '巩留县', '3122', '654000');
INSERT INTO `area` VALUES ('654025', '新源县', '3123', '654000');
INSERT INTO `area` VALUES ('654026', '昭苏县', '3124', '654000');
INSERT INTO `area` VALUES ('654027', '特克斯县', '3125', '654000');
INSERT INTO `area` VALUES ('654028', '尼勒克县', '3126', '654000');
INSERT INTO `area` VALUES ('654201', '塔城市', '3127', '654200');
INSERT INTO `area` VALUES ('654202', '乌苏市', '3128', '654200');
INSERT INTO `area` VALUES ('654221', '额敏县', '3129', '654200');
INSERT INTO `area` VALUES ('654223', '沙湾县', '3130', '654200');
INSERT INTO `area` VALUES ('654224', '托里县', '3131', '654200');
INSERT INTO `area` VALUES ('654225', '裕民县', '3132', '654200');
INSERT INTO `area` VALUES ('654226', '和布克赛尔蒙古自治县', '3133', '654200');
INSERT INTO `area` VALUES ('654301', '阿勒泰市', '3134', '654300');
INSERT INTO `area` VALUES ('654321', '布尔津县', '3135', '654300');
INSERT INTO `area` VALUES ('654322', '富蕴县', '3136', '654300');
INSERT INTO `area` VALUES ('654323', '福海县', '3137', '654300');
INSERT INTO `area` VALUES ('654324', '哈巴河县', '3138', '654300');
INSERT INTO `area` VALUES ('654325', '青河县', '3139', '654300');
INSERT INTO `area` VALUES ('654326', '吉木乃县', '3140', '654300');
INSERT INTO `area` VALUES ('659001', '石河子市', '3141', '659000');
INSERT INTO `area` VALUES ('659002', '阿拉尔市', '3142', '659000');
INSERT INTO `area` VALUES ('659003', '图木舒克市', '3143', '659000');
INSERT INTO `area` VALUES ('659004', '五家渠市', '3144', '659000');

-- ----------------------------
-- Table structure for `city`
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `code` varchar(255) collate utf8_bin NOT NULL,
  `name` varchar(255) collate utf8_bin default NULL,
  `id` varchar(255) collate utf8_bin default NULL,
  `provincecode` varchar(255) collate utf8_bin default NULL,
  PRIMARY KEY  (`code`),
  KEY `FK_Reference_6` (`provincecode`),
  CONSTRAINT `FK_Reference_6` FOREIGN KEY (`provincecode`) REFERENCES `province` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('110100', '北京市', '1', '110000');
INSERT INTO `city` VALUES ('120100', '天津市', '342', '110000');
INSERT INTO `city` VALUES ('130100', '石家庄市', '2', '130000');
INSERT INTO `city` VALUES ('130200', '唐山市', '3', '130000');
INSERT INTO `city` VALUES ('130300', '秦皇岛市', '4', '130000');
INSERT INTO `city` VALUES ('130400', '邯郸市', '5', '130000');
INSERT INTO `city` VALUES ('130500', '邢台市', '6', '130000');
INSERT INTO `city` VALUES ('130600', '保定市', '7', '130000');
INSERT INTO `city` VALUES ('130700', '张家口市', '8', '130000');
INSERT INTO `city` VALUES ('130800', '承德市', '9', '130000');
INSERT INTO `city` VALUES ('130900', '沧州市', '10', '130000');
INSERT INTO `city` VALUES ('131000', '廊坊市', '11', '130000');
INSERT INTO `city` VALUES ('131100', '衡水市', '12', '130000');
INSERT INTO `city` VALUES ('140100', '太原市', '13', '140000');
INSERT INTO `city` VALUES ('140200', '大同市', '14', '140000');
INSERT INTO `city` VALUES ('140300', '阳泉市', '15', '140000');
INSERT INTO `city` VALUES ('140400', '长治市', '16', '140000');
INSERT INTO `city` VALUES ('140500', '晋城市', '17', '140000');
INSERT INTO `city` VALUES ('140600', '朔州市', '18', '140000');
INSERT INTO `city` VALUES ('140700', '晋中市', '19', '140000');
INSERT INTO `city` VALUES ('140800', '运城市', '20', '140000');
INSERT INTO `city` VALUES ('140900', '忻州市', '21', '140000');
INSERT INTO `city` VALUES ('141000', '临汾市', '22', '140000');
INSERT INTO `city` VALUES ('141100', '吕梁市', '23', '140000');
INSERT INTO `city` VALUES ('150100', '呼和浩特市', '24', '150000');
INSERT INTO `city` VALUES ('150200', '包头市', '25', '150000');
INSERT INTO `city` VALUES ('150300', '乌海市', '26', '150000');
INSERT INTO `city` VALUES ('150400', '赤峰市', '27', '150000');
INSERT INTO `city` VALUES ('150500', '通辽市', '28', '150000');
INSERT INTO `city` VALUES ('150600', '鄂尔多斯市', '29', '150000');
INSERT INTO `city` VALUES ('150700', '呼伦贝尔市', '30', '150000');
INSERT INTO `city` VALUES ('150800', '巴彦淖尔市', '31', '150000');
INSERT INTO `city` VALUES ('150900', '乌兰察布市', '32', '150000');
INSERT INTO `city` VALUES ('152200', '兴安盟', '33', '150000');
INSERT INTO `city` VALUES ('152500', '锡林郭勒盟', '34', '150000');
INSERT INTO `city` VALUES ('152900', '阿拉善盟', '35', '150000');
INSERT INTO `city` VALUES ('210100', '沈阳市', '36', '210000');
INSERT INTO `city` VALUES ('210200', '大连市', '37', '210000');
INSERT INTO `city` VALUES ('210300', '鞍山市', '38', '210000');
INSERT INTO `city` VALUES ('210400', '抚顺市', '39', '210000');
INSERT INTO `city` VALUES ('210500', '本溪市', '40', '210000');
INSERT INTO `city` VALUES ('210600', '丹东市', '41', '210000');
INSERT INTO `city` VALUES ('210700', '锦州市', '42', '210000');
INSERT INTO `city` VALUES ('210800', '营口市', '43', '210000');
INSERT INTO `city` VALUES ('210900', '阜新市', '44', '210000');
INSERT INTO `city` VALUES ('211000', '辽阳市', '45', '210000');
INSERT INTO `city` VALUES ('211100', '盘锦市', '46', '210000');
INSERT INTO `city` VALUES ('211200', '铁岭市', '47', '210000');
INSERT INTO `city` VALUES ('211300', '朝阳市', '48', '210000');
INSERT INTO `city` VALUES ('211400', '葫芦岛市', '49', '210000');
INSERT INTO `city` VALUES ('220100', '长春市', '50', '220000');
INSERT INTO `city` VALUES ('220200', '吉林市', '51', '220000');
INSERT INTO `city` VALUES ('220300', '四平市', '52', '220000');
INSERT INTO `city` VALUES ('220400', '辽源市', '53', '220000');
INSERT INTO `city` VALUES ('220500', '通化市', '54', '220000');
INSERT INTO `city` VALUES ('220600', '白山市', '55', '220000');
INSERT INTO `city` VALUES ('220700', '松原市', '56', '220000');
INSERT INTO `city` VALUES ('220800', '白城市', '57', '220000');
INSERT INTO `city` VALUES ('222400', '延边朝鲜族自治州', '58', '220000');
INSERT INTO `city` VALUES ('230100', '哈尔滨市', '59', '230000');
INSERT INTO `city` VALUES ('230200', '齐齐哈尔市', '60', '230000');
INSERT INTO `city` VALUES ('230300', '鸡西市', '61', '230000');
INSERT INTO `city` VALUES ('230400', '鹤岗市', '62', '230000');
INSERT INTO `city` VALUES ('230500', '双鸭山市', '63', '230000');
INSERT INTO `city` VALUES ('230600', '大庆市', '64', '230000');
INSERT INTO `city` VALUES ('230700', '伊春市', '65', '230000');
INSERT INTO `city` VALUES ('230800', '佳木斯市', '66', '230000');
INSERT INTO `city` VALUES ('230900', '七台河市', '67', '230000');
INSERT INTO `city` VALUES ('231000', '牡丹江市', '68', '230000');
INSERT INTO `city` VALUES ('231100', '黑河市', '69', '230000');
INSERT INTO `city` VALUES ('231200', '绥化市', '70', '230000');
INSERT INTO `city` VALUES ('232700', '大兴安岭地区', '71', '230000');
INSERT INTO `city` VALUES ('310100', '市辖区', '72', '310000');
INSERT INTO `city` VALUES ('310200', '县', '73', '310000');
INSERT INTO `city` VALUES ('320100', '南京市', '74', '320000');
INSERT INTO `city` VALUES ('320200', '无锡市', '75', '320000');
INSERT INTO `city` VALUES ('320300', '徐州市', '76', '320000');
INSERT INTO `city` VALUES ('320400', '常州市', '77', '320000');
INSERT INTO `city` VALUES ('320500', '苏州市', '78', '320000');
INSERT INTO `city` VALUES ('320600', '南通市', '79', '320000');
INSERT INTO `city` VALUES ('320700', '连云港市', '80', '320000');
INSERT INTO `city` VALUES ('320800', '淮安市', '81', '320000');
INSERT INTO `city` VALUES ('320900', '盐城市', '82', '320000');
INSERT INTO `city` VALUES ('321000', '扬州市', '83', '320000');
INSERT INTO `city` VALUES ('321100', '镇江市', '84', '320000');
INSERT INTO `city` VALUES ('321200', '泰州市', '85', '320000');
INSERT INTO `city` VALUES ('321300', '宿迁市', '86', '320000');
INSERT INTO `city` VALUES ('330100', '杭州市', '87', '330000');
INSERT INTO `city` VALUES ('330200', '宁波市', '88', '330000');
INSERT INTO `city` VALUES ('330300', '温州市', '89', '330000');
INSERT INTO `city` VALUES ('330400', '嘉兴市', '90', '330000');
INSERT INTO `city` VALUES ('330500', '湖州市', '91', '330000');
INSERT INTO `city` VALUES ('330600', '绍兴市', '92', '330000');
INSERT INTO `city` VALUES ('330700', '金华市', '93', '330000');
INSERT INTO `city` VALUES ('330800', '衢州市', '94', '330000');
INSERT INTO `city` VALUES ('330900', '舟山市', '95', '330000');
INSERT INTO `city` VALUES ('331000', '台州市', '96', '330000');
INSERT INTO `city` VALUES ('331100', '丽水市', '97', '330000');
INSERT INTO `city` VALUES ('340100', '合肥市', '98', '340000');
INSERT INTO `city` VALUES ('340200', '芜湖市', '99', '340000');
INSERT INTO `city` VALUES ('340300', '蚌埠市', '100', '340000');
INSERT INTO `city` VALUES ('340400', '淮南市', '101', '340000');
INSERT INTO `city` VALUES ('340500', '马鞍山市', '102', '340000');
INSERT INTO `city` VALUES ('340600', '淮北市', '103', '340000');
INSERT INTO `city` VALUES ('340700', '铜陵市', '104', '340000');
INSERT INTO `city` VALUES ('340800', '安庆市', '105', '340000');
INSERT INTO `city` VALUES ('341000', '黄山市', '106', '340000');
INSERT INTO `city` VALUES ('341100', '滁州市', '107', '340000');
INSERT INTO `city` VALUES ('341200', '阜阳市', '108', '340000');
INSERT INTO `city` VALUES ('341300', '宿州市', '109', '340000');
INSERT INTO `city` VALUES ('341400', '巢湖市', '110', '340000');
INSERT INTO `city` VALUES ('341500', '六安市', '111', '340000');
INSERT INTO `city` VALUES ('341600', '亳州市', '112', '340000');
INSERT INTO `city` VALUES ('341700', '池州市', '113', '340000');
INSERT INTO `city` VALUES ('341800', '宣城市', '114', '340000');
INSERT INTO `city` VALUES ('350100', '福州市', '115', '350000');
INSERT INTO `city` VALUES ('350200', '厦门市', '116', '350000');
INSERT INTO `city` VALUES ('350300', '莆田市', '117', '350000');
INSERT INTO `city` VALUES ('350400', '三明市', '118', '350000');
INSERT INTO `city` VALUES ('350500', '泉州市', '119', '350000');
INSERT INTO `city` VALUES ('350600', '漳州市', '120', '350000');
INSERT INTO `city` VALUES ('350700', '南平市', '121', '350000');
INSERT INTO `city` VALUES ('350800', '龙岩市', '122', '350000');
INSERT INTO `city` VALUES ('350900', '宁德市', '123', '350000');
INSERT INTO `city` VALUES ('360100', '南昌市', '124', '360000');
INSERT INTO `city` VALUES ('360200', '景德镇市', '125', '360000');
INSERT INTO `city` VALUES ('360300', '萍乡市', '126', '360000');
INSERT INTO `city` VALUES ('360400', '九江市', '127', '360000');
INSERT INTO `city` VALUES ('360500', '新余市', '128', '360000');
INSERT INTO `city` VALUES ('360600', '鹰潭市', '129', '360000');
INSERT INTO `city` VALUES ('360700', '赣州市', '130', '360000');
INSERT INTO `city` VALUES ('360800', '吉安市', '131', '360000');
INSERT INTO `city` VALUES ('360900', '宜春市', '132', '360000');
INSERT INTO `city` VALUES ('361000', '抚州市', '133', '360000');
INSERT INTO `city` VALUES ('361100', '上饶市', '134', '360000');
INSERT INTO `city` VALUES ('370100', '济南市', '135', '370000');
INSERT INTO `city` VALUES ('370200', '青岛市', '136', '370000');
INSERT INTO `city` VALUES ('370300', '淄博市', '137', '370000');
INSERT INTO `city` VALUES ('370400', '枣庄市', '138', '370000');
INSERT INTO `city` VALUES ('370500', '东营市', '139', '370000');
INSERT INTO `city` VALUES ('370600', '烟台市', '140', '370000');
INSERT INTO `city` VALUES ('370700', '潍坊市', '141', '370000');
INSERT INTO `city` VALUES ('370800', '济宁市', '142', '370000');
INSERT INTO `city` VALUES ('370900', '泰安市', '143', '370000');
INSERT INTO `city` VALUES ('371000', '威海市', '144', '370000');
INSERT INTO `city` VALUES ('371100', '日照市', '145', '370000');
INSERT INTO `city` VALUES ('371200', '莱芜市', '146', '370000');
INSERT INTO `city` VALUES ('371300', '临沂市', '147', '370000');
INSERT INTO `city` VALUES ('371400', '德州市', '148', '370000');
INSERT INTO `city` VALUES ('371500', '聊城市', '149', '370000');
INSERT INTO `city` VALUES ('371600', '滨州市', '150', '370000');
INSERT INTO `city` VALUES ('371700', '荷泽市', '151', '370000');
INSERT INTO `city` VALUES ('410100', '郑州市', '152', '410000');
INSERT INTO `city` VALUES ('410200', '开封市', '153', '410000');
INSERT INTO `city` VALUES ('410300', '洛阳市', '154', '410000');
INSERT INTO `city` VALUES ('410400', '平顶山市', '155', '410000');
INSERT INTO `city` VALUES ('410500', '安阳市', '156', '410000');
INSERT INTO `city` VALUES ('410600', '鹤壁市', '157', '410000');
INSERT INTO `city` VALUES ('410700', '新乡市', '158', '410000');
INSERT INTO `city` VALUES ('410800', '焦作市', '159', '410000');
INSERT INTO `city` VALUES ('410900', '濮阳市', '160', '410000');
INSERT INTO `city` VALUES ('411000', '许昌市', '161', '410000');
INSERT INTO `city` VALUES ('411100', '漯河市', '162', '410000');
INSERT INTO `city` VALUES ('411200', '三门峡市', '163', '410000');
INSERT INTO `city` VALUES ('411300', '南阳市', '164', '410000');
INSERT INTO `city` VALUES ('411400', '商丘市', '165', '410000');
INSERT INTO `city` VALUES ('411500', '信阳市', '166', '410000');
INSERT INTO `city` VALUES ('411600', '周口市', '167', '410000');
INSERT INTO `city` VALUES ('411700', '驻马店市', '168', '410000');
INSERT INTO `city` VALUES ('420100', '武汉市', '169', '420000');
INSERT INTO `city` VALUES ('420200', '黄石市', '170', '420000');
INSERT INTO `city` VALUES ('420300', '十堰市', '171', '420000');
INSERT INTO `city` VALUES ('420500', '宜昌市', '172', '420000');
INSERT INTO `city` VALUES ('420600', '襄樊市', '173', '420000');
INSERT INTO `city` VALUES ('420700', '鄂州市', '174', '420000');
INSERT INTO `city` VALUES ('420800', '荆门市', '175', '420000');
INSERT INTO `city` VALUES ('420900', '孝感市', '176', '420000');
INSERT INTO `city` VALUES ('421000', '荆州市', '177', '420000');
INSERT INTO `city` VALUES ('421100', '黄冈市', '178', '420000');
INSERT INTO `city` VALUES ('421200', '咸宁市', '179', '420000');
INSERT INTO `city` VALUES ('421300', '随州市', '180', '420000');
INSERT INTO `city` VALUES ('422800', '恩施土家族苗族自治州', '181', '420000');
INSERT INTO `city` VALUES ('429000', '省直辖行政单位', '182', '420000');
INSERT INTO `city` VALUES ('430100', '长沙市', '183', '430000');
INSERT INTO `city` VALUES ('430200', '株洲市', '184', '430000');
INSERT INTO `city` VALUES ('430300', '湘潭市', '185', '430000');
INSERT INTO `city` VALUES ('430400', '衡阳市', '186', '430000');
INSERT INTO `city` VALUES ('430500', '邵阳市', '187', '430000');
INSERT INTO `city` VALUES ('430600', '岳阳市', '188', '430000');
INSERT INTO `city` VALUES ('430700', '常德市', '189', '430000');
INSERT INTO `city` VALUES ('430800', '张家界市', '190', '430000');
INSERT INTO `city` VALUES ('430900', '益阳市', '191', '430000');
INSERT INTO `city` VALUES ('431000', '郴州市', '192', '430000');
INSERT INTO `city` VALUES ('431100', '永州市', '193', '430000');
INSERT INTO `city` VALUES ('431200', '怀化市', '194', '430000');
INSERT INTO `city` VALUES ('431300', '娄底市', '195', '430000');
INSERT INTO `city` VALUES ('433100', '湘西土家族苗族自治州', '196', '430000');
INSERT INTO `city` VALUES ('440100', '广州市', '197', '440000');
INSERT INTO `city` VALUES ('440200', '韶关市', '198', '440000');
INSERT INTO `city` VALUES ('440300', '深圳市', '199', '440000');
INSERT INTO `city` VALUES ('440400', '珠海市', '200', '440000');
INSERT INTO `city` VALUES ('440500', '汕头市', '201', '440000');
INSERT INTO `city` VALUES ('440600', '佛山市', '202', '440000');
INSERT INTO `city` VALUES ('440700', '江门市', '203', '440000');
INSERT INTO `city` VALUES ('440800', '湛江市', '204', '440000');
INSERT INTO `city` VALUES ('440900', '茂名市', '205', '440000');
INSERT INTO `city` VALUES ('441200', '肇庆市', '206', '440000');
INSERT INTO `city` VALUES ('441300', '惠州市', '207', '440000');
INSERT INTO `city` VALUES ('441400', '梅州市', '208', '440000');
INSERT INTO `city` VALUES ('441500', '汕尾市', '209', '440000');
INSERT INTO `city` VALUES ('441600', '河源市', '210', '440000');
INSERT INTO `city` VALUES ('441700', '阳江市', '211', '440000');
INSERT INTO `city` VALUES ('441800', '清远市', '212', '440000');
INSERT INTO `city` VALUES ('441900', '东莞市', '213', '440000');
INSERT INTO `city` VALUES ('442000', '中山市', '214', '440000');
INSERT INTO `city` VALUES ('445100', '潮州市', '215', '440000');
INSERT INTO `city` VALUES ('445200', '揭阳市', '216', '440000');
INSERT INTO `city` VALUES ('445300', '云浮市', '217', '440000');
INSERT INTO `city` VALUES ('450100', '南宁市', '218', '450000');
INSERT INTO `city` VALUES ('450200', '柳州市', '219', '450000');
INSERT INTO `city` VALUES ('450300', '桂林市', '220', '450000');
INSERT INTO `city` VALUES ('450400', '梧州市', '221', '450000');
INSERT INTO `city` VALUES ('450500', '北海市', '222', '450000');
INSERT INTO `city` VALUES ('450600', '防城港市', '223', '450000');
INSERT INTO `city` VALUES ('450700', '钦州市', '224', '450000');
INSERT INTO `city` VALUES ('450800', '贵港市', '225', '450000');
INSERT INTO `city` VALUES ('450900', '玉林市', '226', '450000');
INSERT INTO `city` VALUES ('451000', '百色市', '227', '450000');
INSERT INTO `city` VALUES ('451100', '贺州市', '228', '450000');
INSERT INTO `city` VALUES ('451200', '河池市', '229', '450000');
INSERT INTO `city` VALUES ('451300', '来宾市', '230', '450000');
INSERT INTO `city` VALUES ('451400', '崇左市', '231', '450000');
INSERT INTO `city` VALUES ('460100', '海口市', '232', '460000');
INSERT INTO `city` VALUES ('460200', '三亚市', '233', '460000');
INSERT INTO `city` VALUES ('469000', '省直辖县级行政单位', '234', '460000');
INSERT INTO `city` VALUES ('500100', '市辖区', '235', '500000');
INSERT INTO `city` VALUES ('500200', '县', '236', '500000');
INSERT INTO `city` VALUES ('500300', '市', '237', '500000');
INSERT INTO `city` VALUES ('510100', '成都市', '238', '510000');
INSERT INTO `city` VALUES ('510300', '自贡市', '239', '510000');
INSERT INTO `city` VALUES ('510400', '攀枝花市', '240', '510000');
INSERT INTO `city` VALUES ('510500', '泸州市', '241', '510000');
INSERT INTO `city` VALUES ('510600', '德阳市', '242', '510000');
INSERT INTO `city` VALUES ('510700', '绵阳市', '243', '510000');
INSERT INTO `city` VALUES ('510800', '广元市', '244', '510000');
INSERT INTO `city` VALUES ('510900', '遂宁市', '245', '510000');
INSERT INTO `city` VALUES ('511000', '内江市', '246', '510000');
INSERT INTO `city` VALUES ('511100', '乐山市', '247', '510000');
INSERT INTO `city` VALUES ('511300', '南充市', '248', '510000');
INSERT INTO `city` VALUES ('511400', '眉山市', '249', '510000');
INSERT INTO `city` VALUES ('511500', '宜宾市', '250', '510000');
INSERT INTO `city` VALUES ('511600', '广安市', '251', '510000');
INSERT INTO `city` VALUES ('511700', '达州市', '252', '510000');
INSERT INTO `city` VALUES ('511800', '雅安市', '253', '510000');
INSERT INTO `city` VALUES ('511900', '巴中市', '254', '510000');
INSERT INTO `city` VALUES ('512000', '资阳市', '255', '510000');
INSERT INTO `city` VALUES ('513200', '阿坝藏族羌族自治州', '256', '510000');
INSERT INTO `city` VALUES ('513300', '甘孜藏族自治州', '257', '510000');
INSERT INTO `city` VALUES ('513400', '凉山彝族自治州', '258', '510000');
INSERT INTO `city` VALUES ('520100', '贵阳市', '259', '520000');
INSERT INTO `city` VALUES ('520200', '六盘水市', '260', '520000');
INSERT INTO `city` VALUES ('520300', '遵义市', '261', '520000');
INSERT INTO `city` VALUES ('520400', '安顺市', '262', '520000');
INSERT INTO `city` VALUES ('522200', '铜仁地区', '263', '520000');
INSERT INTO `city` VALUES ('522300', '黔西南布依族苗族自治州', '264', '520000');
INSERT INTO `city` VALUES ('522400', '毕节地区', '265', '520000');
INSERT INTO `city` VALUES ('522600', '黔东南苗族侗族自治州', '266', '520000');
INSERT INTO `city` VALUES ('522700', '黔南布依族苗族自治州', '267', '520000');
INSERT INTO `city` VALUES ('530100', '昆明市', '268', '530000');
INSERT INTO `city` VALUES ('530300', '曲靖市', '269', '530000');
INSERT INTO `city` VALUES ('530400', '玉溪市', '270', '530000');
INSERT INTO `city` VALUES ('530500', '保山市', '271', '530000');
INSERT INTO `city` VALUES ('530600', '昭通市', '272', '530000');
INSERT INTO `city` VALUES ('530700', '丽江市', '273', '530000');
INSERT INTO `city` VALUES ('530800', '思茅市', '274', '530000');
INSERT INTO `city` VALUES ('530900', '临沧市', '275', '530000');
INSERT INTO `city` VALUES ('532300', '楚雄彝族自治州', '276', '530000');
INSERT INTO `city` VALUES ('532500', '红河哈尼族彝族自治州', '277', '530000');
INSERT INTO `city` VALUES ('532600', '文山壮族苗族自治州', '278', '530000');
INSERT INTO `city` VALUES ('532800', '西双版纳傣族自治州', '279', '530000');
INSERT INTO `city` VALUES ('532900', '大理白族自治州', '280', '530000');
INSERT INTO `city` VALUES ('533100', '德宏傣族景颇族自治州', '281', '530000');
INSERT INTO `city` VALUES ('533300', '怒江傈僳族自治州', '282', '530000');
INSERT INTO `city` VALUES ('533400', '迪庆藏族自治州', '283', '530000');
INSERT INTO `city` VALUES ('540100', '拉萨市', '284', '540000');
INSERT INTO `city` VALUES ('542100', '昌都地区', '285', '540000');
INSERT INTO `city` VALUES ('542200', '山南地区', '286', '540000');
INSERT INTO `city` VALUES ('542300', '日喀则地区', '287', '540000');
INSERT INTO `city` VALUES ('542400', '那曲地区', '288', '540000');
INSERT INTO `city` VALUES ('542500', '阿里地区', '289', '540000');
INSERT INTO `city` VALUES ('542600', '林芝地区', '290', '540000');
INSERT INTO `city` VALUES ('610100', '西安市', '291', '610000');
INSERT INTO `city` VALUES ('610200', '铜川市', '292', '610000');
INSERT INTO `city` VALUES ('610300', '宝鸡市', '293', '610000');
INSERT INTO `city` VALUES ('610400', '咸阳市', '294', '610000');
INSERT INTO `city` VALUES ('610500', '渭南市', '295', '610000');
INSERT INTO `city` VALUES ('610600', '延安市', '296', '610000');
INSERT INTO `city` VALUES ('610700', '汉中市', '297', '610000');
INSERT INTO `city` VALUES ('610800', '榆林市', '298', '610000');
INSERT INTO `city` VALUES ('610900', '安康市', '299', '610000');
INSERT INTO `city` VALUES ('611000', '商洛市', '300', '610000');
INSERT INTO `city` VALUES ('620100', '兰州市', '301', '620000');
INSERT INTO `city` VALUES ('620200', '嘉峪关市', '302', '620000');
INSERT INTO `city` VALUES ('620300', '金昌市', '303', '620000');
INSERT INTO `city` VALUES ('620400', '白银市', '304', '620000');
INSERT INTO `city` VALUES ('620500', '天水市', '305', '620000');
INSERT INTO `city` VALUES ('620600', '武威市', '306', '620000');
INSERT INTO `city` VALUES ('620700', '张掖市', '307', '620000');
INSERT INTO `city` VALUES ('620800', '平凉市', '308', '620000');
INSERT INTO `city` VALUES ('620900', '酒泉市', '309', '620000');
INSERT INTO `city` VALUES ('621000', '庆阳市', '310', '620000');
INSERT INTO `city` VALUES ('621100', '定西市', '311', '620000');
INSERT INTO `city` VALUES ('621200', '陇南市', '312', '620000');
INSERT INTO `city` VALUES ('622900', '临夏回族自治州', '313', '620000');
INSERT INTO `city` VALUES ('623000', '甘南藏族自治州', '314', '620000');
INSERT INTO `city` VALUES ('630100', '西宁市', '315', '630000');
INSERT INTO `city` VALUES ('632100', '海东地区', '316', '630000');
INSERT INTO `city` VALUES ('632200', '海北藏族自治州', '317', '630000');
INSERT INTO `city` VALUES ('632300', '黄南藏族自治州', '318', '630000');
INSERT INTO `city` VALUES ('632500', '海南藏族自治州', '319', '630000');
INSERT INTO `city` VALUES ('632600', '果洛藏族自治州', '320', '630000');
INSERT INTO `city` VALUES ('632700', '玉树藏族自治州', '321', '630000');
INSERT INTO `city` VALUES ('632800', '海西蒙古族藏族自治州', '322', '630000');
INSERT INTO `city` VALUES ('640100', '银川市', '323', '640000');
INSERT INTO `city` VALUES ('640200', '石嘴山市', '324', '640000');
INSERT INTO `city` VALUES ('640300', '吴忠市', '325', '640000');
INSERT INTO `city` VALUES ('640400', '固原市', '326', '640000');
INSERT INTO `city` VALUES ('640500', '中卫市', '327', '640000');
INSERT INTO `city` VALUES ('650100', '乌鲁木齐市', '328', '650000');
INSERT INTO `city` VALUES ('650200', '克拉玛依市', '329', '650000');
INSERT INTO `city` VALUES ('652100', '吐鲁番地区', '330', '650000');
INSERT INTO `city` VALUES ('652200', '哈密地区', '331', '650000');
INSERT INTO `city` VALUES ('652300', '昌吉回族自治州', '332', '650000');
INSERT INTO `city` VALUES ('652700', '博尔塔拉蒙古自治州', '333', '650000');
INSERT INTO `city` VALUES ('652800', '巴音郭楞蒙古自治州', '334', '650000');
INSERT INTO `city` VALUES ('652900', '阿克苏地区', '335', '650000');
INSERT INTO `city` VALUES ('653000', '克孜勒苏柯尔克孜自治州', '336', '650000');
INSERT INTO `city` VALUES ('653100', '喀什地区', '337', '650000');
INSERT INTO `city` VALUES ('653200', '和田地区', '338', '650000');
INSERT INTO `city` VALUES ('654000', '伊犁哈萨克自治州', '339', '650000');
INSERT INTO `city` VALUES ('654200', '塔城地区', '340', '650000');
INSERT INTO `city` VALUES ('654300', '阿勒泰地区', '341', '650000');
INSERT INTO `city` VALUES ('659000', '省直辖行政单位', '342', '650000');

-- ----------------------------
-- Table structure for `province`
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `code` varchar(255) collate utf8_bin NOT NULL,
  `name` varchar(255) collate utf8_bin default NULL,
  `id` varchar(255) collate utf8_bin default NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('110000', '北京市', '1');
INSERT INTO `province` VALUES ('120000', '天津市', '2');
INSERT INTO `province` VALUES ('130000', '河北省', '3');
INSERT INTO `province` VALUES ('140000', '山西省', '4');
INSERT INTO `province` VALUES ('150000', '内蒙古', '5');
INSERT INTO `province` VALUES ('210000', '辽宁省', '6');
INSERT INTO `province` VALUES ('220000', '吉林省', '7');
INSERT INTO `province` VALUES ('230000', '黑龙江', '8');
INSERT INTO `province` VALUES ('310000', '上海市', '9');
INSERT INTO `province` VALUES ('320000', '江苏省', '10');
INSERT INTO `province` VALUES ('330000', '浙江省', '11');
INSERT INTO `province` VALUES ('340000', '安徽省', '12');
INSERT INTO `province` VALUES ('350000', '福建省', '13');
INSERT INTO `province` VALUES ('360000', '江西省', '14');
INSERT INTO `province` VALUES ('370000', '山东省', '15');
INSERT INTO `province` VALUES ('410000', '河南省', '16');
INSERT INTO `province` VALUES ('420000', '湖北省', '17');
INSERT INTO `province` VALUES ('430000', '湖南省', '18');
INSERT INTO `province` VALUES ('440000', '广东省', '19');
INSERT INTO `province` VALUES ('450000', '广  西', '20');
INSERT INTO `province` VALUES ('460000', '海南省', '21');
INSERT INTO `province` VALUES ('500000', '重庆市', '22');
INSERT INTO `province` VALUES ('510000', '四川省', '23');
INSERT INTO `province` VALUES ('520000', '贵州省', '24');
INSERT INTO `province` VALUES ('530000', '云南省', '25');
INSERT INTO `province` VALUES ('540000', '西  藏', '26');
INSERT INTO `province` VALUES ('610000', '陕西省', '27');
INSERT INTO `province` VALUES ('620000', '甘肃省', '28');
INSERT INTO `province` VALUES ('630000', '青海省', '29');
INSERT INTO `province` VALUES ('640000', '宁  夏', '30');
INSERT INTO `province` VALUES ('650000', '新  疆', '31');
INSERT INTO `province` VALUES ('710000', '台湾省', '32');
INSERT INTO `province` VALUES ('810000', '香  港', '33');
INSERT INTO `province` VALUES ('820000', '澳  门', '34');