/*
 Navicat Premium Data Transfer

 Source Server         : mysql1
 Source Server Type    : MySQL
 Source Server Version : 50713
 Source Host           : localhost:3309
 Source Schema         : area

 Target Server Type    : MySQL
 Target Server Version : 50713
 File Encoding         : 65001

 Date: 11/02/2022 17:43:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chn_code
-- ----------------------------
DROP TABLE IF EXISTS `chn_code`;
CREATE TABLE `chn_code`  (
  `idcode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chn_code
-- ----------------------------
INSERT INTO `chn_code` VALUES ('110000', '北京市');
INSERT INTO `chn_code` VALUES ('110101', '   东城区');
INSERT INTO `chn_code` VALUES ('110102', '   西城区');
INSERT INTO `chn_code` VALUES ('110105', '   朝阳区');
INSERT INTO `chn_code` VALUES ('110106', '   丰台区');
INSERT INTO `chn_code` VALUES ('110107', '   石景山区');
INSERT INTO `chn_code` VALUES ('110108', '   海淀区');
INSERT INTO `chn_code` VALUES ('110109', '   门头沟区');
INSERT INTO `chn_code` VALUES ('110111', '   房山区');
INSERT INTO `chn_code` VALUES ('110112', '   通州区');
INSERT INTO `chn_code` VALUES ('110113', '   顺义区');
INSERT INTO `chn_code` VALUES ('110114', '   昌平区');
INSERT INTO `chn_code` VALUES ('110115', '   大兴区');
INSERT INTO `chn_code` VALUES ('110116', '   怀柔区');
INSERT INTO `chn_code` VALUES ('110117', '   平谷区');
INSERT INTO `chn_code` VALUES ('110118', '   密云区');
INSERT INTO `chn_code` VALUES ('110119', '   延庆区');
INSERT INTO `chn_code` VALUES ('120000', '天津市');
INSERT INTO `chn_code` VALUES ('120101', '   和平区');
INSERT INTO `chn_code` VALUES ('120102', '   河东区');
INSERT INTO `chn_code` VALUES ('120103', '   河西区');
INSERT INTO `chn_code` VALUES ('120104', '   南开区');
INSERT INTO `chn_code` VALUES ('120105', '   河北区');
INSERT INTO `chn_code` VALUES ('120106', '   红桥区');
INSERT INTO `chn_code` VALUES ('120110', '   东丽区');
INSERT INTO `chn_code` VALUES ('120111', '   西青区');
INSERT INTO `chn_code` VALUES ('120112', '   津南区');
INSERT INTO `chn_code` VALUES ('120113', '   北辰区');
INSERT INTO `chn_code` VALUES ('120114', '   武清区');
INSERT INTO `chn_code` VALUES ('120115', '   宝坻区');
INSERT INTO `chn_code` VALUES ('120116', '   滨海新区');
INSERT INTO `chn_code` VALUES ('120117', '   宁河区');
INSERT INTO `chn_code` VALUES ('120118', '   静海区');
INSERT INTO `chn_code` VALUES ('120119', '   蓟州区');
INSERT INTO `chn_code` VALUES ('130000', '河北省');
INSERT INTO `chn_code` VALUES ('130100', ' 石家庄市');
INSERT INTO `chn_code` VALUES ('130102', '   长安区');
INSERT INTO `chn_code` VALUES ('130104', '   桥西区');
INSERT INTO `chn_code` VALUES ('130105', '   新华区');
INSERT INTO `chn_code` VALUES ('130107', '   井陉矿区');
INSERT INTO `chn_code` VALUES ('130108', '   裕华区');
INSERT INTO `chn_code` VALUES ('130109', '   藁城区');
INSERT INTO `chn_code` VALUES ('130110', '   鹿泉区');
INSERT INTO `chn_code` VALUES ('130111', '   栾城区');
INSERT INTO `chn_code` VALUES ('130121', '   井陉县');
INSERT INTO `chn_code` VALUES ('130123', '   正定县');
INSERT INTO `chn_code` VALUES ('130125', '   行唐县');
INSERT INTO `chn_code` VALUES ('130126', '   灵寿县');
INSERT INTO `chn_code` VALUES ('130127', '   高邑县');
INSERT INTO `chn_code` VALUES ('130128', '   深泽县');
INSERT INTO `chn_code` VALUES ('130129', '   赞皇县');
INSERT INTO `chn_code` VALUES ('130130', '   无极县');
INSERT INTO `chn_code` VALUES ('130131', '   平山县');
INSERT INTO `chn_code` VALUES ('130132', '   元氏县');
INSERT INTO `chn_code` VALUES ('130133', '   赵县');
INSERT INTO `chn_code` VALUES ('130181', '   辛集市');
INSERT INTO `chn_code` VALUES ('130183', '   晋州市');
INSERT INTO `chn_code` VALUES ('130184', '   新乐市');
INSERT INTO `chn_code` VALUES ('130200', ' 唐山市');
INSERT INTO `chn_code` VALUES ('130202', '   路南区');
INSERT INTO `chn_code` VALUES ('130203', '   路北区');
INSERT INTO `chn_code` VALUES ('130204', '   古冶区');
INSERT INTO `chn_code` VALUES ('130205', '   开平区');
INSERT INTO `chn_code` VALUES ('130207', '   丰南区');
INSERT INTO `chn_code` VALUES ('130208', '   丰润区');
INSERT INTO `chn_code` VALUES ('130209', '   曹妃甸区');
INSERT INTO `chn_code` VALUES ('130224', '   滦南县');
INSERT INTO `chn_code` VALUES ('130225', '   乐亭县');
INSERT INTO `chn_code` VALUES ('130227', '   迁西县');
INSERT INTO `chn_code` VALUES ('130229', '   玉田县');
INSERT INTO `chn_code` VALUES ('130281', '   遵化市');
INSERT INTO `chn_code` VALUES ('130283', '   迁安市');
INSERT INTO `chn_code` VALUES ('130284', '   滦州市');
INSERT INTO `chn_code` VALUES ('130300', ' 秦皇岛市');
INSERT INTO `chn_code` VALUES ('130302', '   海港区');
INSERT INTO `chn_code` VALUES ('130303', '   山海关区');
INSERT INTO `chn_code` VALUES ('130304', '   北戴河区');
INSERT INTO `chn_code` VALUES ('130306', '   抚宁区');
INSERT INTO `chn_code` VALUES ('130321', '   青龙满族自治县');
INSERT INTO `chn_code` VALUES ('130322', '   昌黎县');
INSERT INTO `chn_code` VALUES ('130324', '   卢龙县');
INSERT INTO `chn_code` VALUES ('130400', ' 邯郸市');
INSERT INTO `chn_code` VALUES ('130402', '   邯山区');
INSERT INTO `chn_code` VALUES ('130403', '   丛台区');
INSERT INTO `chn_code` VALUES ('130404', '   复兴区');
INSERT INTO `chn_code` VALUES ('130406', '   峰峰矿区');
INSERT INTO `chn_code` VALUES ('130407', '   肥乡区');
INSERT INTO `chn_code` VALUES ('130408', '   永年区');
INSERT INTO `chn_code` VALUES ('130423', '   临漳县');
INSERT INTO `chn_code` VALUES ('130424', '   成安县');
INSERT INTO `chn_code` VALUES ('130425', '   大名县');
INSERT INTO `chn_code` VALUES ('130426', '   涉县');
INSERT INTO `chn_code` VALUES ('130427', '   磁县');
INSERT INTO `chn_code` VALUES ('130430', '   邱县');
INSERT INTO `chn_code` VALUES ('130431', '   鸡泽县');
INSERT INTO `chn_code` VALUES ('130432', '   广平县');
INSERT INTO `chn_code` VALUES ('130433', '   馆陶县');
INSERT INTO `chn_code` VALUES ('130434', '   魏县');
INSERT INTO `chn_code` VALUES ('130435', '   曲周县');
INSERT INTO `chn_code` VALUES ('130481', '   武安市');
INSERT INTO `chn_code` VALUES ('130500', ' 邢台市');
INSERT INTO `chn_code` VALUES ('130502', '   襄都区');
INSERT INTO `chn_code` VALUES ('130503', '   信都区');
INSERT INTO `chn_code` VALUES ('130505', '   任泽区');
INSERT INTO `chn_code` VALUES ('130506', '   南和区');
INSERT INTO `chn_code` VALUES ('130522', '   临城县');
INSERT INTO `chn_code` VALUES ('130523', '   内丘县');
INSERT INTO `chn_code` VALUES ('130524', '   柏乡县');
INSERT INTO `chn_code` VALUES ('130525', '   隆尧县');
INSERT INTO `chn_code` VALUES ('130528', '   宁晋县');
INSERT INTO `chn_code` VALUES ('130529', '   巨鹿县');
INSERT INTO `chn_code` VALUES ('130530', '   新河县');
INSERT INTO `chn_code` VALUES ('130531', '   广宗县');
INSERT INTO `chn_code` VALUES ('130532', '   平乡县');
INSERT INTO `chn_code` VALUES ('130533', '   威县');
INSERT INTO `chn_code` VALUES ('130534', '   清河县');
INSERT INTO `chn_code` VALUES ('130535', '   临西县');
INSERT INTO `chn_code` VALUES ('130581', '   南宫市');
INSERT INTO `chn_code` VALUES ('130582', '   沙河市');
INSERT INTO `chn_code` VALUES ('130600', ' 保定市');
INSERT INTO `chn_code` VALUES ('130602', '   竞秀区');
INSERT INTO `chn_code` VALUES ('130606', '   莲池区');
INSERT INTO `chn_code` VALUES ('130607', '   满城区');
INSERT INTO `chn_code` VALUES ('130608', '   清苑区');
INSERT INTO `chn_code` VALUES ('130609', '   徐水区');
INSERT INTO `chn_code` VALUES ('130623', '   涞水县');
INSERT INTO `chn_code` VALUES ('130624', '   阜平县');
INSERT INTO `chn_code` VALUES ('130626', '   定兴县');
INSERT INTO `chn_code` VALUES ('130627', '   唐县');
INSERT INTO `chn_code` VALUES ('130628', '   高阳县');
INSERT INTO `chn_code` VALUES ('130629', '   容城县');
INSERT INTO `chn_code` VALUES ('130630', '   涞源县');
INSERT INTO `chn_code` VALUES ('130631', '   望都县');
INSERT INTO `chn_code` VALUES ('130632', '   安新县');
INSERT INTO `chn_code` VALUES ('130633', '   易县');
INSERT INTO `chn_code` VALUES ('130634', '   曲阳县');
INSERT INTO `chn_code` VALUES ('130635', '   蠡县');
INSERT INTO `chn_code` VALUES ('130636', '   顺平县');
INSERT INTO `chn_code` VALUES ('130637', '   博野县');
INSERT INTO `chn_code` VALUES ('130638', '   雄县');
INSERT INTO `chn_code` VALUES ('130681', '   涿州市');
INSERT INTO `chn_code` VALUES ('130682', '   定州市');
INSERT INTO `chn_code` VALUES ('130683', '   安国市');
INSERT INTO `chn_code` VALUES ('130684', '   高碑店市');
INSERT INTO `chn_code` VALUES ('130700', ' 张家口市');
INSERT INTO `chn_code` VALUES ('130702', '   桥东区');
INSERT INTO `chn_code` VALUES ('130703', '   桥西区');
INSERT INTO `chn_code` VALUES ('130705', '   宣化区');
INSERT INTO `chn_code` VALUES ('130706', '   下花园区');
INSERT INTO `chn_code` VALUES ('130708', '   万全区');
INSERT INTO `chn_code` VALUES ('130709', '   崇礼区');
INSERT INTO `chn_code` VALUES ('130722', '   张北县');
INSERT INTO `chn_code` VALUES ('130723', '   康保县');
INSERT INTO `chn_code` VALUES ('130724', '   沽源县');
INSERT INTO `chn_code` VALUES ('130725', '   尚义县');
INSERT INTO `chn_code` VALUES ('130726', '   蔚县');
INSERT INTO `chn_code` VALUES ('130727', '   阳原县');
INSERT INTO `chn_code` VALUES ('130728', '   怀安县');
INSERT INTO `chn_code` VALUES ('130730', '   怀来县');
INSERT INTO `chn_code` VALUES ('130731', '   涿鹿县');
INSERT INTO `chn_code` VALUES ('130732', '   赤城县');
INSERT INTO `chn_code` VALUES ('130800', ' 承德市');
INSERT INTO `chn_code` VALUES ('130802', '   双桥区');
INSERT INTO `chn_code` VALUES ('130803', '   双滦区');
INSERT INTO `chn_code` VALUES ('130804', '   鹰手营子矿区');
INSERT INTO `chn_code` VALUES ('130821', '   承德县');
INSERT INTO `chn_code` VALUES ('130822', '   兴隆县');
INSERT INTO `chn_code` VALUES ('130824', '   滦平县');
INSERT INTO `chn_code` VALUES ('130825', '   隆化县');
INSERT INTO `chn_code` VALUES ('130826', '   丰宁满族自治县');
INSERT INTO `chn_code` VALUES ('130827', '   宽城满族自治县');
INSERT INTO `chn_code` VALUES ('130828', '   围场满族蒙古族自治县');
INSERT INTO `chn_code` VALUES ('130881', '   平泉市');
INSERT INTO `chn_code` VALUES ('130900', ' 沧州市');
INSERT INTO `chn_code` VALUES ('130902', '   新华区');
INSERT INTO `chn_code` VALUES ('130903', '   运河区');
INSERT INTO `chn_code` VALUES ('130921', '   沧县');
INSERT INTO `chn_code` VALUES ('130922', '   青县');
INSERT INTO `chn_code` VALUES ('130923', '   东光县');
INSERT INTO `chn_code` VALUES ('130924', '   海兴县');
INSERT INTO `chn_code` VALUES ('130925', '   盐山县');
INSERT INTO `chn_code` VALUES ('130926', '   肃宁县');
INSERT INTO `chn_code` VALUES ('130927', '   南皮县');
INSERT INTO `chn_code` VALUES ('130928', '   吴桥县');
INSERT INTO `chn_code` VALUES ('130929', '   献县');
INSERT INTO `chn_code` VALUES ('130930', '   孟村回族自治县');
INSERT INTO `chn_code` VALUES ('130981', '   泊头市');
INSERT INTO `chn_code` VALUES ('130982', '   任丘市');
INSERT INTO `chn_code` VALUES ('130983', '   黄骅市');
INSERT INTO `chn_code` VALUES ('130984', '   河间市');
INSERT INTO `chn_code` VALUES ('131000', ' 廊坊市');
INSERT INTO `chn_code` VALUES ('131002', '   安次区');
INSERT INTO `chn_code` VALUES ('131003', '   广阳区');
INSERT INTO `chn_code` VALUES ('131022', '   固安县');
INSERT INTO `chn_code` VALUES ('131023', '   永清县');
INSERT INTO `chn_code` VALUES ('131024', '   香河县');
INSERT INTO `chn_code` VALUES ('131025', '   大城县');
INSERT INTO `chn_code` VALUES ('131026', '   文安县');
INSERT INTO `chn_code` VALUES ('131028', '   大厂回族自治县');
INSERT INTO `chn_code` VALUES ('131081', '   霸州市');
INSERT INTO `chn_code` VALUES ('131082', '   三河市');
INSERT INTO `chn_code` VALUES ('131100', ' 衡水市');
INSERT INTO `chn_code` VALUES ('131102', '   桃城区');
INSERT INTO `chn_code` VALUES ('131103', '   冀州区');
INSERT INTO `chn_code` VALUES ('131121', '   枣强县');
INSERT INTO `chn_code` VALUES ('131122', '   武邑县');
INSERT INTO `chn_code` VALUES ('131123', '   武强县');
INSERT INTO `chn_code` VALUES ('131124', '   饶阳县');
INSERT INTO `chn_code` VALUES ('131125', '   安平县');
INSERT INTO `chn_code` VALUES ('131126', '   故城县');
INSERT INTO `chn_code` VALUES ('131127', '   景县');
INSERT INTO `chn_code` VALUES ('131128', '   阜城县');
INSERT INTO `chn_code` VALUES ('131182', '   深州市');
INSERT INTO `chn_code` VALUES ('140000', '山西省');
INSERT INTO `chn_code` VALUES ('140100', ' 太原市');
INSERT INTO `chn_code` VALUES ('140105', '   小店区');
INSERT INTO `chn_code` VALUES ('140106', '   迎泽区');
INSERT INTO `chn_code` VALUES ('140107', '   杏花岭区');
INSERT INTO `chn_code` VALUES ('140108', '   尖草坪区');
INSERT INTO `chn_code` VALUES ('140109', '   万柏林区');
INSERT INTO `chn_code` VALUES ('140110', '   晋源区');
INSERT INTO `chn_code` VALUES ('140121', '   清徐县');
INSERT INTO `chn_code` VALUES ('140122', '   阳曲县');
INSERT INTO `chn_code` VALUES ('140123', '   娄烦县');
INSERT INTO `chn_code` VALUES ('140181', '   古交市');
INSERT INTO `chn_code` VALUES ('140200', ' 大同市');
INSERT INTO `chn_code` VALUES ('140212', '   新荣区');
INSERT INTO `chn_code` VALUES ('140213', '   平城区');
INSERT INTO `chn_code` VALUES ('140214', '   云冈区');
INSERT INTO `chn_code` VALUES ('140215', '   云州区');
INSERT INTO `chn_code` VALUES ('140221', '   阳高县');
INSERT INTO `chn_code` VALUES ('140222', '   天镇县');
INSERT INTO `chn_code` VALUES ('140223', '   广灵县');
INSERT INTO `chn_code` VALUES ('140224', '   灵丘县');
INSERT INTO `chn_code` VALUES ('140225', '   浑源县');
INSERT INTO `chn_code` VALUES ('140226', '   左云县');
INSERT INTO `chn_code` VALUES ('140300', ' 阳泉市');
INSERT INTO `chn_code` VALUES ('140302', '   城区');
INSERT INTO `chn_code` VALUES ('140303', '   矿区');
INSERT INTO `chn_code` VALUES ('140311', '   郊区');
INSERT INTO `chn_code` VALUES ('140321', '   平定县');
INSERT INTO `chn_code` VALUES ('140322', '   盂县');
INSERT INTO `chn_code` VALUES ('140400', ' 长治市');
INSERT INTO `chn_code` VALUES ('140403', '   潞州区');
INSERT INTO `chn_code` VALUES ('140404', '   上党区');
INSERT INTO `chn_code` VALUES ('140405', '   屯留区');
INSERT INTO `chn_code` VALUES ('140406', '   潞城区');
INSERT INTO `chn_code` VALUES ('140423', '   襄垣县');
INSERT INTO `chn_code` VALUES ('140425', '   平顺县');
INSERT INTO `chn_code` VALUES ('140426', '   黎城县');
INSERT INTO `chn_code` VALUES ('140427', '   壶关县');
INSERT INTO `chn_code` VALUES ('140428', '   长子县');
INSERT INTO `chn_code` VALUES ('140429', '   武乡县');
INSERT INTO `chn_code` VALUES ('140430', '   沁县');
INSERT INTO `chn_code` VALUES ('140431', '   沁源县');
INSERT INTO `chn_code` VALUES ('140500', ' 晋城市');
INSERT INTO `chn_code` VALUES ('140502', '   城区');
INSERT INTO `chn_code` VALUES ('140521', '   沁水县');
INSERT INTO `chn_code` VALUES ('140522', '   阳城县');
INSERT INTO `chn_code` VALUES ('140524', '   陵川县');
INSERT INTO `chn_code` VALUES ('140525', '   泽州县');
INSERT INTO `chn_code` VALUES ('140581', '   高平市');
INSERT INTO `chn_code` VALUES ('140600', ' 朔州市');
INSERT INTO `chn_code` VALUES ('140602', '   朔城区');
INSERT INTO `chn_code` VALUES ('140603', '   平鲁区');
INSERT INTO `chn_code` VALUES ('140621', '   山阴县');
INSERT INTO `chn_code` VALUES ('140622', '   应县');
INSERT INTO `chn_code` VALUES ('140623', '   右玉县');
INSERT INTO `chn_code` VALUES ('140681', '   怀仁市');
INSERT INTO `chn_code` VALUES ('140700', ' 晋中市');
INSERT INTO `chn_code` VALUES ('140702', '   榆次区');
INSERT INTO `chn_code` VALUES ('140703', '   太谷区');
INSERT INTO `chn_code` VALUES ('140721', '   榆社县');
INSERT INTO `chn_code` VALUES ('140722', '   左权县');
INSERT INTO `chn_code` VALUES ('140723', '   和顺县');
INSERT INTO `chn_code` VALUES ('140724', '   昔阳县');
INSERT INTO `chn_code` VALUES ('140725', '   寿阳县');
INSERT INTO `chn_code` VALUES ('140727', '   祁县');
INSERT INTO `chn_code` VALUES ('140728', '   平遥县');
INSERT INTO `chn_code` VALUES ('140729', '   灵石县');
INSERT INTO `chn_code` VALUES ('140781', '   介休市');
INSERT INTO `chn_code` VALUES ('140800', ' 运城市');
INSERT INTO `chn_code` VALUES ('140802', '   盐湖区');
INSERT INTO `chn_code` VALUES ('140821', '   临猗县');
INSERT INTO `chn_code` VALUES ('140822', '   万荣县');
INSERT INTO `chn_code` VALUES ('140823', '   闻喜县');
INSERT INTO `chn_code` VALUES ('140824', '   稷山县');
INSERT INTO `chn_code` VALUES ('140825', '   新绛县');
INSERT INTO `chn_code` VALUES ('140826', '   绛县');
INSERT INTO `chn_code` VALUES ('140827', '   垣曲县');
INSERT INTO `chn_code` VALUES ('140828', '   夏县');
INSERT INTO `chn_code` VALUES ('140829', '   平陆县');
INSERT INTO `chn_code` VALUES ('140830', '   芮城县');
INSERT INTO `chn_code` VALUES ('140881', '   永济市');
INSERT INTO `chn_code` VALUES ('140882', '   河津市');
INSERT INTO `chn_code` VALUES ('140900', ' 忻州市');
INSERT INTO `chn_code` VALUES ('140902', '   忻府区');
INSERT INTO `chn_code` VALUES ('140921', '   定襄县');
INSERT INTO `chn_code` VALUES ('140922', '   五台县');
INSERT INTO `chn_code` VALUES ('140923', '   代县');
INSERT INTO `chn_code` VALUES ('140924', '   繁峙县');
INSERT INTO `chn_code` VALUES ('140925', '   宁武县');
INSERT INTO `chn_code` VALUES ('140926', '   静乐县');
INSERT INTO `chn_code` VALUES ('140927', '   神池县');
INSERT INTO `chn_code` VALUES ('140928', '   五寨县');
INSERT INTO `chn_code` VALUES ('140929', '   岢岚县');
INSERT INTO `chn_code` VALUES ('140930', '   河曲县');
INSERT INTO `chn_code` VALUES ('140931', '   保德县');
INSERT INTO `chn_code` VALUES ('140932', '   偏关县');
INSERT INTO `chn_code` VALUES ('140981', '   原平市');
INSERT INTO `chn_code` VALUES ('141000', ' 临汾市');
INSERT INTO `chn_code` VALUES ('141002', '   尧都区');
INSERT INTO `chn_code` VALUES ('141021', '   曲沃县');
INSERT INTO `chn_code` VALUES ('141022', '   翼城县');
INSERT INTO `chn_code` VALUES ('141023', '   襄汾县');
INSERT INTO `chn_code` VALUES ('141024', '   洪洞县');
INSERT INTO `chn_code` VALUES ('141025', '   古县');
INSERT INTO `chn_code` VALUES ('141026', '   安泽县');
INSERT INTO `chn_code` VALUES ('141027', '   浮山县');
INSERT INTO `chn_code` VALUES ('141028', '   吉县');
INSERT INTO `chn_code` VALUES ('141029', '   乡宁县');
INSERT INTO `chn_code` VALUES ('141030', '   大宁县');
INSERT INTO `chn_code` VALUES ('141031', '   隰县');
INSERT INTO `chn_code` VALUES ('141032', '   永和县');
INSERT INTO `chn_code` VALUES ('141033', '   蒲县');
INSERT INTO `chn_code` VALUES ('141034', '   汾西县');
INSERT INTO `chn_code` VALUES ('141081', '   侯马市');
INSERT INTO `chn_code` VALUES ('141082', '   霍州市');
INSERT INTO `chn_code` VALUES ('141100', ' 吕梁市');
INSERT INTO `chn_code` VALUES ('141102', '   离石区');
INSERT INTO `chn_code` VALUES ('141121', '   文水县');
INSERT INTO `chn_code` VALUES ('141122', '   交城县');
INSERT INTO `chn_code` VALUES ('141123', '   兴县');
INSERT INTO `chn_code` VALUES ('141124', '   临县');
INSERT INTO `chn_code` VALUES ('141125', '   柳林县');
INSERT INTO `chn_code` VALUES ('141126', '   石楼县');
INSERT INTO `chn_code` VALUES ('141127', '   岚县');
INSERT INTO `chn_code` VALUES ('141128', '   方山县');
INSERT INTO `chn_code` VALUES ('141129', '   中阳县');
INSERT INTO `chn_code` VALUES ('141130', '   交口县');
INSERT INTO `chn_code` VALUES ('141181', '   孝义市');
INSERT INTO `chn_code` VALUES ('141182', '   汾阳市');
INSERT INTO `chn_code` VALUES ('150000', '内蒙古自治区');
INSERT INTO `chn_code` VALUES ('150100', ' 呼和浩特市');
INSERT INTO `chn_code` VALUES ('150102', '   新城区');
INSERT INTO `chn_code` VALUES ('150103', '   回民区');
INSERT INTO `chn_code` VALUES ('150104', '   玉泉区');
INSERT INTO `chn_code` VALUES ('150105', '   赛罕区');
INSERT INTO `chn_code` VALUES ('150121', '   土默特左旗');
INSERT INTO `chn_code` VALUES ('150122', '   托克托县');
INSERT INTO `chn_code` VALUES ('150123', '   和林格尔县');
INSERT INTO `chn_code` VALUES ('150124', '   清水河县');
INSERT INTO `chn_code` VALUES ('150125', '   武川县');
INSERT INTO `chn_code` VALUES ('150200', ' 包头市');
INSERT INTO `chn_code` VALUES ('150202', '   东河区');
INSERT INTO `chn_code` VALUES ('150203', '   昆都仑区');
INSERT INTO `chn_code` VALUES ('150204', '   青山区');
INSERT INTO `chn_code` VALUES ('150205', '   石拐区');
INSERT INTO `chn_code` VALUES ('150206', '   白云鄂博矿区');
INSERT INTO `chn_code` VALUES ('150207', '   九原区');
INSERT INTO `chn_code` VALUES ('150221', '   土默特右旗');
INSERT INTO `chn_code` VALUES ('150222', '   固阳县');
INSERT INTO `chn_code` VALUES ('150223', '   达尔罕茂明安联合旗');
INSERT INTO `chn_code` VALUES ('150300', ' 乌海市');
INSERT INTO `chn_code` VALUES ('150302', '   海勃湾区');
INSERT INTO `chn_code` VALUES ('150303', '   海南区');
INSERT INTO `chn_code` VALUES ('150304', '   乌达区');
INSERT INTO `chn_code` VALUES ('150400', ' 赤峰市');
INSERT INTO `chn_code` VALUES ('150402', '   红山区');
INSERT INTO `chn_code` VALUES ('150403', '   元宝山区');
INSERT INTO `chn_code` VALUES ('150404', '   松山区');
INSERT INTO `chn_code` VALUES ('150421', '   阿鲁科尔沁旗');
INSERT INTO `chn_code` VALUES ('150422', '   巴林左旗');
INSERT INTO `chn_code` VALUES ('150423', '   巴林右旗');
INSERT INTO `chn_code` VALUES ('150424', '   林西县');
INSERT INTO `chn_code` VALUES ('150425', '   克什克腾旗');
INSERT INTO `chn_code` VALUES ('150426', '   翁牛特旗');
INSERT INTO `chn_code` VALUES ('150428', '   喀喇沁旗');
INSERT INTO `chn_code` VALUES ('150429', '   宁城县');
INSERT INTO `chn_code` VALUES ('150430', '   敖汉旗');
INSERT INTO `chn_code` VALUES ('150500', ' 通辽市');
INSERT INTO `chn_code` VALUES ('150502', '   科尔沁区');
INSERT INTO `chn_code` VALUES ('150521', '   科尔沁左翼中旗');
INSERT INTO `chn_code` VALUES ('150522', '   科尔沁左翼后旗');
INSERT INTO `chn_code` VALUES ('150523', '   开鲁县');
INSERT INTO `chn_code` VALUES ('150524', '   库伦旗');
INSERT INTO `chn_code` VALUES ('150525', '   奈曼旗');
INSERT INTO `chn_code` VALUES ('150526', '   扎鲁特旗');
INSERT INTO `chn_code` VALUES ('150581', '   霍林郭勒市');
INSERT INTO `chn_code` VALUES ('150600', ' 鄂尔多斯市');
INSERT INTO `chn_code` VALUES ('150602', '   东胜区');
INSERT INTO `chn_code` VALUES ('150603', '   康巴什区');
INSERT INTO `chn_code` VALUES ('150621', '   达拉特旗');
INSERT INTO `chn_code` VALUES ('150622', '   准格尔旗');
INSERT INTO `chn_code` VALUES ('150623', '   鄂托克前旗');
INSERT INTO `chn_code` VALUES ('150624', '   鄂托克旗');
INSERT INTO `chn_code` VALUES ('150625', '   杭锦旗');
INSERT INTO `chn_code` VALUES ('150626', '   乌审旗');
INSERT INTO `chn_code` VALUES ('150627', '   伊金霍洛旗');
INSERT INTO `chn_code` VALUES ('150700', ' 呼伦贝尔市');
INSERT INTO `chn_code` VALUES ('150702', '   海拉尔区');
INSERT INTO `chn_code` VALUES ('150703', '   扎赉诺尔区');
INSERT INTO `chn_code` VALUES ('150721', '   阿荣旗');
INSERT INTO `chn_code` VALUES ('150722', '   莫力达瓦达斡尔族自治旗');
INSERT INTO `chn_code` VALUES ('150723', '   鄂伦春自治旗');
INSERT INTO `chn_code` VALUES ('150724', '   鄂温克族自治旗');
INSERT INTO `chn_code` VALUES ('150725', '   陈巴尔虎旗');
INSERT INTO `chn_code` VALUES ('150726', '   新巴尔虎左旗');
INSERT INTO `chn_code` VALUES ('150727', '   新巴尔虎右旗');
INSERT INTO `chn_code` VALUES ('150781', '   满洲里市');
INSERT INTO `chn_code` VALUES ('150782', '   牙克石市');
INSERT INTO `chn_code` VALUES ('150783', '   扎兰屯市');
INSERT INTO `chn_code` VALUES ('150784', '   额尔古纳市');
INSERT INTO `chn_code` VALUES ('150785', '   根河市');
INSERT INTO `chn_code` VALUES ('150800', ' 巴彦淖尔市');
INSERT INTO `chn_code` VALUES ('150802', '   临河区');
INSERT INTO `chn_code` VALUES ('150821', '   五原县');
INSERT INTO `chn_code` VALUES ('150822', '   磴口县');
INSERT INTO `chn_code` VALUES ('150823', '   乌拉特前旗');
INSERT INTO `chn_code` VALUES ('150824', '   乌拉特中旗');
INSERT INTO `chn_code` VALUES ('150825', '   乌拉特后旗');
INSERT INTO `chn_code` VALUES ('150826', '   杭锦后旗');
INSERT INTO `chn_code` VALUES ('150900', ' 乌兰察布市');
INSERT INTO `chn_code` VALUES ('150902', '   集宁区');
INSERT INTO `chn_code` VALUES ('150921', '   卓资县');
INSERT INTO `chn_code` VALUES ('150922', '   化德县');
INSERT INTO `chn_code` VALUES ('150923', '   商都县');
INSERT INTO `chn_code` VALUES ('150924', '   兴和县');
INSERT INTO `chn_code` VALUES ('150925', '   凉城县');
INSERT INTO `chn_code` VALUES ('150926', '   察哈尔右翼前旗');
INSERT INTO `chn_code` VALUES ('150927', '   察哈尔右翼中旗');
INSERT INTO `chn_code` VALUES ('150928', '   察哈尔右翼后旗');
INSERT INTO `chn_code` VALUES ('150929', '   四子王旗');
INSERT INTO `chn_code` VALUES ('150981', '   丰镇市');
INSERT INTO `chn_code` VALUES ('152200', ' 兴安盟');
INSERT INTO `chn_code` VALUES ('152201', '   乌兰浩特市');
INSERT INTO `chn_code` VALUES ('152202', '   阿尔山市');
INSERT INTO `chn_code` VALUES ('152221', '   科尔沁右翼前旗');
INSERT INTO `chn_code` VALUES ('152222', '   科尔沁右翼中旗');
INSERT INTO `chn_code` VALUES ('152223', '   扎赉特旗');
INSERT INTO `chn_code` VALUES ('152224', '   突泉县');
INSERT INTO `chn_code` VALUES ('152500', ' 锡林郭勒盟');
INSERT INTO `chn_code` VALUES ('152501', '   二连浩特市');
INSERT INTO `chn_code` VALUES ('152502', '   锡林浩特市');
INSERT INTO `chn_code` VALUES ('152522', '   阿巴嘎旗');
INSERT INTO `chn_code` VALUES ('152523', '   苏尼特左旗');
INSERT INTO `chn_code` VALUES ('152524', '   苏尼特右旗');
INSERT INTO `chn_code` VALUES ('152525', '   东乌珠穆沁旗');
INSERT INTO `chn_code` VALUES ('152526', '   西乌珠穆沁旗');
INSERT INTO `chn_code` VALUES ('152527', '   太仆寺旗');
INSERT INTO `chn_code` VALUES ('152528', '   镶黄旗');
INSERT INTO `chn_code` VALUES ('152529', '   正镶白旗');
INSERT INTO `chn_code` VALUES ('152530', '   正蓝旗');
INSERT INTO `chn_code` VALUES ('152531', '   多伦县');
INSERT INTO `chn_code` VALUES ('152900', ' 阿拉善盟');
INSERT INTO `chn_code` VALUES ('152921', '   阿拉善左旗');
INSERT INTO `chn_code` VALUES ('152922', '   阿拉善右旗');
INSERT INTO `chn_code` VALUES ('152923', '   额济纳旗');
INSERT INTO `chn_code` VALUES ('210000', '辽宁省');
INSERT INTO `chn_code` VALUES ('210100', ' 沈阳市');
INSERT INTO `chn_code` VALUES ('210102', '   和平区');
INSERT INTO `chn_code` VALUES ('210103', '   沈河区');
INSERT INTO `chn_code` VALUES ('210104', '   大东区');
INSERT INTO `chn_code` VALUES ('210105', '   皇姑区');
INSERT INTO `chn_code` VALUES ('210106', '   铁西区');
INSERT INTO `chn_code` VALUES ('210111', '   苏家屯区');
INSERT INTO `chn_code` VALUES ('210112', '   浑南区');
INSERT INTO `chn_code` VALUES ('210113', '   沈北新区');
INSERT INTO `chn_code` VALUES ('210114', '   于洪区');
INSERT INTO `chn_code` VALUES ('210115', '   辽中区');
INSERT INTO `chn_code` VALUES ('210123', '   康平县');
INSERT INTO `chn_code` VALUES ('210124', '   法库县');
INSERT INTO `chn_code` VALUES ('210181', '   新民市');
INSERT INTO `chn_code` VALUES ('210200', ' 大连市');
INSERT INTO `chn_code` VALUES ('210202', '   中山区');
INSERT INTO `chn_code` VALUES ('210203', '   西岗区');
INSERT INTO `chn_code` VALUES ('210204', '   沙河口区');
INSERT INTO `chn_code` VALUES ('210211', '   甘井子区');
INSERT INTO `chn_code` VALUES ('210212', '   旅顺口区');
INSERT INTO `chn_code` VALUES ('210213', '   金州区');
INSERT INTO `chn_code` VALUES ('210214', '   普兰店区');
INSERT INTO `chn_code` VALUES ('210224', '   长海县');
INSERT INTO `chn_code` VALUES ('210281', '   瓦房店市');
INSERT INTO `chn_code` VALUES ('210283', '   庄河市');
INSERT INTO `chn_code` VALUES ('210300', ' 鞍山市');
INSERT INTO `chn_code` VALUES ('210302', '   铁东区');
INSERT INTO `chn_code` VALUES ('210303', '   铁西区');
INSERT INTO `chn_code` VALUES ('210304', '   立山区');
INSERT INTO `chn_code` VALUES ('210311', '   千山区');
INSERT INTO `chn_code` VALUES ('210321', '   台安县');
INSERT INTO `chn_code` VALUES ('210323', '   岫岩满族自治县');
INSERT INTO `chn_code` VALUES ('210381', '   海城市');
INSERT INTO `chn_code` VALUES ('210400', ' 抚顺市');
INSERT INTO `chn_code` VALUES ('210402', '   新抚区');
INSERT INTO `chn_code` VALUES ('210403', '   东洲区');
INSERT INTO `chn_code` VALUES ('210404', '   望花区');
INSERT INTO `chn_code` VALUES ('210411', '   顺城区');
INSERT INTO `chn_code` VALUES ('210421', '   抚顺县');
INSERT INTO `chn_code` VALUES ('210422', '   新宾满族自治县');
INSERT INTO `chn_code` VALUES ('210423', '   清原满族自治县');
INSERT INTO `chn_code` VALUES ('210500', ' 本溪市');
INSERT INTO `chn_code` VALUES ('210502', '   平山区');
INSERT INTO `chn_code` VALUES ('210503', '   溪湖区');
INSERT INTO `chn_code` VALUES ('210504', '   明山区');
INSERT INTO `chn_code` VALUES ('210505', '   南芬区');
INSERT INTO `chn_code` VALUES ('210521', '   本溪满族自治县');
INSERT INTO `chn_code` VALUES ('210522', '   桓仁满族自治县');
INSERT INTO `chn_code` VALUES ('210600', ' 丹东市');
INSERT INTO `chn_code` VALUES ('210602', '   元宝区');
INSERT INTO `chn_code` VALUES ('210603', '   振兴区');
INSERT INTO `chn_code` VALUES ('210604', '   振安区');
INSERT INTO `chn_code` VALUES ('210624', '   宽甸满族自治县');
INSERT INTO `chn_code` VALUES ('210681', '   东港市');
INSERT INTO `chn_code` VALUES ('210682', '   凤城市');
INSERT INTO `chn_code` VALUES ('210700', ' 锦州市');
INSERT INTO `chn_code` VALUES ('210702', '   古塔区');
INSERT INTO `chn_code` VALUES ('210703', '   凌河区');
INSERT INTO `chn_code` VALUES ('210711', '   太和区');
INSERT INTO `chn_code` VALUES ('210726', '   黑山县');
INSERT INTO `chn_code` VALUES ('210727', '   义县');
INSERT INTO `chn_code` VALUES ('210781', '   凌海市');
INSERT INTO `chn_code` VALUES ('210782', '   北镇市');
INSERT INTO `chn_code` VALUES ('210800', ' 营口市');
INSERT INTO `chn_code` VALUES ('210802', '   站前区');
INSERT INTO `chn_code` VALUES ('210803', '   西市区');
INSERT INTO `chn_code` VALUES ('210804', '   鲅鱼圈区');
INSERT INTO `chn_code` VALUES ('210811', '   老边区');
INSERT INTO `chn_code` VALUES ('210881', '   盖州市');
INSERT INTO `chn_code` VALUES ('210882', '   大石桥市');
INSERT INTO `chn_code` VALUES ('210900', ' 阜新市');
INSERT INTO `chn_code` VALUES ('210902', '   海州区');
INSERT INTO `chn_code` VALUES ('210903', '   新邱区');
INSERT INTO `chn_code` VALUES ('210904', '   太平区');
INSERT INTO `chn_code` VALUES ('210905', '   清河门区');
INSERT INTO `chn_code` VALUES ('210911', '   细河区');
INSERT INTO `chn_code` VALUES ('210921', '   阜新蒙古族自治县');
INSERT INTO `chn_code` VALUES ('210922', '   彰武县');
INSERT INTO `chn_code` VALUES ('211000', ' 辽阳市');
INSERT INTO `chn_code` VALUES ('211002', '   白塔区');
INSERT INTO `chn_code` VALUES ('211003', '   文圣区');
INSERT INTO `chn_code` VALUES ('211004', '   宏伟区');
INSERT INTO `chn_code` VALUES ('211005', '   弓长岭区');
INSERT INTO `chn_code` VALUES ('211011', '   太子河区');
INSERT INTO `chn_code` VALUES ('211021', '   辽阳县');
INSERT INTO `chn_code` VALUES ('211081', '   灯塔市');
INSERT INTO `chn_code` VALUES ('211100', ' 盘锦市');
INSERT INTO `chn_code` VALUES ('211102', '   双台子区');
INSERT INTO `chn_code` VALUES ('211103', '   兴隆台区');
INSERT INTO `chn_code` VALUES ('211104', '   大洼区');
INSERT INTO `chn_code` VALUES ('211122', '   盘山县');
INSERT INTO `chn_code` VALUES ('211200', ' 铁岭市');
INSERT INTO `chn_code` VALUES ('211202', '   银州区');
INSERT INTO `chn_code` VALUES ('211204', '   清河区');
INSERT INTO `chn_code` VALUES ('211221', '   铁岭县');
INSERT INTO `chn_code` VALUES ('211223', '   西丰县');
INSERT INTO `chn_code` VALUES ('211224', '   昌图县');
INSERT INTO `chn_code` VALUES ('211281', '   调兵山市');
INSERT INTO `chn_code` VALUES ('211282', '   开原市');
INSERT INTO `chn_code` VALUES ('211300', ' 朝阳市');
INSERT INTO `chn_code` VALUES ('211302', '   双塔区');
INSERT INTO `chn_code` VALUES ('211303', '   龙城区');
INSERT INTO `chn_code` VALUES ('211321', '   朝阳县');
INSERT INTO `chn_code` VALUES ('211322', '   建平县');
INSERT INTO `chn_code` VALUES ('211324', '   喀喇沁左翼蒙古族自治县');
INSERT INTO `chn_code` VALUES ('211381', '   北票市');
INSERT INTO `chn_code` VALUES ('211382', '   凌源市');
INSERT INTO `chn_code` VALUES ('211400', ' 葫芦岛市');
INSERT INTO `chn_code` VALUES ('211402', '   连山区');
INSERT INTO `chn_code` VALUES ('211403', '   龙港区');
INSERT INTO `chn_code` VALUES ('211404', '   南票区');
INSERT INTO `chn_code` VALUES ('211421', '   绥中县');
INSERT INTO `chn_code` VALUES ('211422', '   建昌县');
INSERT INTO `chn_code` VALUES ('211481', '   兴城市');
INSERT INTO `chn_code` VALUES ('220000', '吉林省');
INSERT INTO `chn_code` VALUES ('220100', ' 长春市');
INSERT INTO `chn_code` VALUES ('220102', '   南关区');
INSERT INTO `chn_code` VALUES ('220103', '   宽城区');
INSERT INTO `chn_code` VALUES ('220104', '   朝阳区');
INSERT INTO `chn_code` VALUES ('220105', '   二道区');
INSERT INTO `chn_code` VALUES ('220106', '   绿园区');
INSERT INTO `chn_code` VALUES ('220112', '   双阳区');
INSERT INTO `chn_code` VALUES ('220113', '   九台区');
INSERT INTO `chn_code` VALUES ('220122', '   农安县');
INSERT INTO `chn_code` VALUES ('220182', '   榆树市');
INSERT INTO `chn_code` VALUES ('220183', '   德惠市');
INSERT INTO `chn_code` VALUES ('220184', '   公主岭市');
INSERT INTO `chn_code` VALUES ('220200', ' 吉林市');
INSERT INTO `chn_code` VALUES ('220202', '   昌邑区');
INSERT INTO `chn_code` VALUES ('220203', '   龙潭区');
INSERT INTO `chn_code` VALUES ('220204', '   船营区');
INSERT INTO `chn_code` VALUES ('220211', '   丰满区');
INSERT INTO `chn_code` VALUES ('220221', '   永吉县');
INSERT INTO `chn_code` VALUES ('220281', '   蛟河市');
INSERT INTO `chn_code` VALUES ('220282', '   桦甸市');
INSERT INTO `chn_code` VALUES ('220283', '   舒兰市');
INSERT INTO `chn_code` VALUES ('220284', '   磐石市');
INSERT INTO `chn_code` VALUES ('220300', ' 四平市');
INSERT INTO `chn_code` VALUES ('220302', '   铁西区');
INSERT INTO `chn_code` VALUES ('220303', '   铁东区');
INSERT INTO `chn_code` VALUES ('220322', '   梨树县');
INSERT INTO `chn_code` VALUES ('220323', '   伊通满族自治县');
INSERT INTO `chn_code` VALUES ('220382', '   双辽市');
INSERT INTO `chn_code` VALUES ('220400', ' 辽源市');
INSERT INTO `chn_code` VALUES ('220402', '   龙山区');
INSERT INTO `chn_code` VALUES ('220403', '   西安区');
INSERT INTO `chn_code` VALUES ('220421', '   东丰县');
INSERT INTO `chn_code` VALUES ('220422', '   东辽县');
INSERT INTO `chn_code` VALUES ('220500', ' 通化市');
INSERT INTO `chn_code` VALUES ('220502', '   东昌区');
INSERT INTO `chn_code` VALUES ('220503', '   二道江区');
INSERT INTO `chn_code` VALUES ('220521', '   通化县');
INSERT INTO `chn_code` VALUES ('220523', '   辉南县');
INSERT INTO `chn_code` VALUES ('220524', '   柳河县');
INSERT INTO `chn_code` VALUES ('220581', '   梅河口市');
INSERT INTO `chn_code` VALUES ('220582', '   集安市');
INSERT INTO `chn_code` VALUES ('220600', ' 白山市');
INSERT INTO `chn_code` VALUES ('220602', '   浑江区');
INSERT INTO `chn_code` VALUES ('220605', '   江源区');
INSERT INTO `chn_code` VALUES ('220621', '   抚松县');
INSERT INTO `chn_code` VALUES ('220622', '   靖宇县');
INSERT INTO `chn_code` VALUES ('220623', '   长白朝鲜族自治县');
INSERT INTO `chn_code` VALUES ('220681', '   临江市');
INSERT INTO `chn_code` VALUES ('220700', ' 松原市');
INSERT INTO `chn_code` VALUES ('220702', '   宁江区');
INSERT INTO `chn_code` VALUES ('220721', '   前郭尔罗斯蒙古族自治县');
INSERT INTO `chn_code` VALUES ('220722', '   长岭县');
INSERT INTO `chn_code` VALUES ('220723', '   乾安县');
INSERT INTO `chn_code` VALUES ('220781', '   扶余市');
INSERT INTO `chn_code` VALUES ('220800', ' 白城市');
INSERT INTO `chn_code` VALUES ('220802', '   洮北区');
INSERT INTO `chn_code` VALUES ('220821', '   镇赉县');
INSERT INTO `chn_code` VALUES ('220822', '   通榆县');
INSERT INTO `chn_code` VALUES ('220881', '   洮南市');
INSERT INTO `chn_code` VALUES ('220882', '   大安市');
INSERT INTO `chn_code` VALUES ('222400', ' 延边朝鲜族自治州');
INSERT INTO `chn_code` VALUES ('222401', '   延吉市');
INSERT INTO `chn_code` VALUES ('222402', '   图们市');
INSERT INTO `chn_code` VALUES ('222403', '   敦化市');
INSERT INTO `chn_code` VALUES ('222404', '   珲春市');
INSERT INTO `chn_code` VALUES ('222405', '   龙井市');
INSERT INTO `chn_code` VALUES ('222406', '   和龙市');
INSERT INTO `chn_code` VALUES ('222424', '   汪清县');
INSERT INTO `chn_code` VALUES ('222426', '   安图县');
INSERT INTO `chn_code` VALUES ('230000', '黑龙江省');
INSERT INTO `chn_code` VALUES ('230100', ' 哈尔滨市');
INSERT INTO `chn_code` VALUES ('230102', '   道里区');
INSERT INTO `chn_code` VALUES ('230103', '   南岗区');
INSERT INTO `chn_code` VALUES ('230104', '   道外区');
INSERT INTO `chn_code` VALUES ('230108', '   平房区');
INSERT INTO `chn_code` VALUES ('230109', '   松北区');
INSERT INTO `chn_code` VALUES ('230110', '   香坊区');
INSERT INTO `chn_code` VALUES ('230111', '   呼兰区');
INSERT INTO `chn_code` VALUES ('230112', '   阿城区');
INSERT INTO `chn_code` VALUES ('230113', '   双城区');
INSERT INTO `chn_code` VALUES ('230123', '   依兰县');
INSERT INTO `chn_code` VALUES ('230124', '   方正县');
INSERT INTO `chn_code` VALUES ('230125', '   宾县');
INSERT INTO `chn_code` VALUES ('230126', '   巴彦县');
INSERT INTO `chn_code` VALUES ('230127', '   木兰县');
INSERT INTO `chn_code` VALUES ('230128', '   通河县');
INSERT INTO `chn_code` VALUES ('230129', '   延寿县');
INSERT INTO `chn_code` VALUES ('230183', '   尚志市');
INSERT INTO `chn_code` VALUES ('230184', '   五常市');
INSERT INTO `chn_code` VALUES ('230200', ' 齐齐哈尔市');
INSERT INTO `chn_code` VALUES ('230202', '   龙沙区');
INSERT INTO `chn_code` VALUES ('230203', '   建华区');
INSERT INTO `chn_code` VALUES ('230204', '   铁锋区');
INSERT INTO `chn_code` VALUES ('230205', '   昂昂溪区');
INSERT INTO `chn_code` VALUES ('230206', '   富拉尔基区');
INSERT INTO `chn_code` VALUES ('230207', '   碾子山区');
INSERT INTO `chn_code` VALUES ('230208', '   梅里斯达斡尔族区');
INSERT INTO `chn_code` VALUES ('230221', '   龙江县');
INSERT INTO `chn_code` VALUES ('230223', '   依安县');
INSERT INTO `chn_code` VALUES ('230224', '   泰来县');
INSERT INTO `chn_code` VALUES ('230225', '   甘南县');
INSERT INTO `chn_code` VALUES ('230227', '   富裕县');
INSERT INTO `chn_code` VALUES ('230229', '   克山县');
INSERT INTO `chn_code` VALUES ('230230', '   克东县');
INSERT INTO `chn_code` VALUES ('230231', '   拜泉县');
INSERT INTO `chn_code` VALUES ('230281', '   讷河市');
INSERT INTO `chn_code` VALUES ('230300', ' 鸡西市');
INSERT INTO `chn_code` VALUES ('230302', '   鸡冠区');
INSERT INTO `chn_code` VALUES ('230303', '   恒山区');
INSERT INTO `chn_code` VALUES ('230304', '   滴道区');
INSERT INTO `chn_code` VALUES ('230305', '   梨树区');
INSERT INTO `chn_code` VALUES ('230306', '   城子河区');
INSERT INTO `chn_code` VALUES ('230307', '   麻山区');
INSERT INTO `chn_code` VALUES ('230321', '   鸡东县');
INSERT INTO `chn_code` VALUES ('230381', '   虎林市');
INSERT INTO `chn_code` VALUES ('230382', '   密山市');
INSERT INTO `chn_code` VALUES ('230400', ' 鹤岗市');
INSERT INTO `chn_code` VALUES ('230402', '   向阳区');
INSERT INTO `chn_code` VALUES ('230403', '   工农区');
INSERT INTO `chn_code` VALUES ('230404', '   南山区');
INSERT INTO `chn_code` VALUES ('230405', '   兴安区');
INSERT INTO `chn_code` VALUES ('230406', '   东山区');
INSERT INTO `chn_code` VALUES ('230407', '   兴山区');
INSERT INTO `chn_code` VALUES ('230421', '   萝北县');
INSERT INTO `chn_code` VALUES ('230422', '   绥滨县');
INSERT INTO `chn_code` VALUES ('230500', ' 双鸭山市');
INSERT INTO `chn_code` VALUES ('230502', '   尖山区');
INSERT INTO `chn_code` VALUES ('230503', '   岭东区');
INSERT INTO `chn_code` VALUES ('230505', '   四方台区');
INSERT INTO `chn_code` VALUES ('230506', '   宝山区');
INSERT INTO `chn_code` VALUES ('230521', '   集贤县');
INSERT INTO `chn_code` VALUES ('230522', '   友谊县');
INSERT INTO `chn_code` VALUES ('230523', '   宝清县');
INSERT INTO `chn_code` VALUES ('230524', '   饶河县');
INSERT INTO `chn_code` VALUES ('230600', ' 大庆市');
INSERT INTO `chn_code` VALUES ('230602', '   萨尔图区');
INSERT INTO `chn_code` VALUES ('230603', '   龙凤区');
INSERT INTO `chn_code` VALUES ('230604', '   让胡路区');
INSERT INTO `chn_code` VALUES ('230605', '   红岗区');
INSERT INTO `chn_code` VALUES ('230606', '   大同区');
INSERT INTO `chn_code` VALUES ('230621', '   肇州县');
INSERT INTO `chn_code` VALUES ('230622', '   肇源县');
INSERT INTO `chn_code` VALUES ('230623', '   林甸县');
INSERT INTO `chn_code` VALUES ('230624', '   杜尔伯特蒙古族自治县');
INSERT INTO `chn_code` VALUES ('230700', ' 伊春市');
INSERT INTO `chn_code` VALUES ('230717', '   伊美区');
INSERT INTO `chn_code` VALUES ('230718', '   乌翠区');
INSERT INTO `chn_code` VALUES ('230719', '   友好区');
INSERT INTO `chn_code` VALUES ('230722', '   嘉荫县');
INSERT INTO `chn_code` VALUES ('230723', '   汤旺县');
INSERT INTO `chn_code` VALUES ('230724', '   丰林县');
INSERT INTO `chn_code` VALUES ('230725', '   大箐山县');
INSERT INTO `chn_code` VALUES ('230726', '   南岔县');
INSERT INTO `chn_code` VALUES ('230751', '   金林区');
INSERT INTO `chn_code` VALUES ('230781', '   铁力市');
INSERT INTO `chn_code` VALUES ('230800', ' 佳木斯市');
INSERT INTO `chn_code` VALUES ('230803', '   向阳区');
INSERT INTO `chn_code` VALUES ('230804', '   前进区');
INSERT INTO `chn_code` VALUES ('230805', '   东风区');
INSERT INTO `chn_code` VALUES ('230811', '   郊区');
INSERT INTO `chn_code` VALUES ('230822', '   桦南县');
INSERT INTO `chn_code` VALUES ('230826', '   桦川县');
INSERT INTO `chn_code` VALUES ('230828', '   汤原县');
INSERT INTO `chn_code` VALUES ('230881', '   同江市');
INSERT INTO `chn_code` VALUES ('230882', '   富锦市');
INSERT INTO `chn_code` VALUES ('230883', '   抚远市');
INSERT INTO `chn_code` VALUES ('230900', ' 七台河市');
INSERT INTO `chn_code` VALUES ('230902', '   新兴区');
INSERT INTO `chn_code` VALUES ('230903', '   桃山区');
INSERT INTO `chn_code` VALUES ('230904', '   茄子河区');
INSERT INTO `chn_code` VALUES ('230921', '   勃利县');
INSERT INTO `chn_code` VALUES ('231000', ' 牡丹江市');
INSERT INTO `chn_code` VALUES ('231002', '   东安区');
INSERT INTO `chn_code` VALUES ('231003', '   阳明区');
INSERT INTO `chn_code` VALUES ('231004', '   爱民区');
INSERT INTO `chn_code` VALUES ('231005', '   西安区');
INSERT INTO `chn_code` VALUES ('231025', '   林口县');
INSERT INTO `chn_code` VALUES ('231081', '   绥芬河市');
INSERT INTO `chn_code` VALUES ('231083', '   海林市');
INSERT INTO `chn_code` VALUES ('231084', '   宁安市');
INSERT INTO `chn_code` VALUES ('231085', '   穆棱市');
INSERT INTO `chn_code` VALUES ('231086', '   东宁市');
INSERT INTO `chn_code` VALUES ('231100', ' 黑河市');
INSERT INTO `chn_code` VALUES ('231102', '   爱辉区');
INSERT INTO `chn_code` VALUES ('231123', '   逊克县');
INSERT INTO `chn_code` VALUES ('231124', '   孙吴县');
INSERT INTO `chn_code` VALUES ('231181', '   北安市');
INSERT INTO `chn_code` VALUES ('231182', '   五大连池市');
INSERT INTO `chn_code` VALUES ('231183', '   嫩江市');
INSERT INTO `chn_code` VALUES ('231200', ' 绥化市');
INSERT INTO `chn_code` VALUES ('231202', '   北林区');
INSERT INTO `chn_code` VALUES ('231221', '   望奎县');
INSERT INTO `chn_code` VALUES ('231222', '   兰西县');
INSERT INTO `chn_code` VALUES ('231223', '   青冈县');
INSERT INTO `chn_code` VALUES ('231224', '   庆安县');
INSERT INTO `chn_code` VALUES ('231225', '   明水县');
INSERT INTO `chn_code` VALUES ('231226', '   绥棱县');
INSERT INTO `chn_code` VALUES ('231281', '   安达市');
INSERT INTO `chn_code` VALUES ('231282', '   肇东市');
INSERT INTO `chn_code` VALUES ('231283', '   海伦市');
INSERT INTO `chn_code` VALUES ('232700', ' 大兴安岭地区');
INSERT INTO `chn_code` VALUES ('232701', '   漠河市');
INSERT INTO `chn_code` VALUES ('232721', '   呼玛县');
INSERT INTO `chn_code` VALUES ('232722', '   塔河县');
INSERT INTO `chn_code` VALUES ('310000', '上海市');
INSERT INTO `chn_code` VALUES ('310101', '   黄浦区');
INSERT INTO `chn_code` VALUES ('310104', '   徐汇区');
INSERT INTO `chn_code` VALUES ('310105', '   长宁区');
INSERT INTO `chn_code` VALUES ('310106', '   静安区');
INSERT INTO `chn_code` VALUES ('310107', '   普陀区');
INSERT INTO `chn_code` VALUES ('310109', '   虹口区');
INSERT INTO `chn_code` VALUES ('310110', '   杨浦区');
INSERT INTO `chn_code` VALUES ('310112', '   闵行区');
INSERT INTO `chn_code` VALUES ('310113', '   宝山区');
INSERT INTO `chn_code` VALUES ('310114', '   嘉定区');
INSERT INTO `chn_code` VALUES ('310115', '   浦东新区');
INSERT INTO `chn_code` VALUES ('310116', '   金山区');
INSERT INTO `chn_code` VALUES ('310117', '   松江区');
INSERT INTO `chn_code` VALUES ('310118', '   青浦区');
INSERT INTO `chn_code` VALUES ('310120', '   奉贤区');
INSERT INTO `chn_code` VALUES ('310151', '   崇明区');
INSERT INTO `chn_code` VALUES ('320000', '江苏省');
INSERT INTO `chn_code` VALUES ('320100', ' 南京市');
INSERT INTO `chn_code` VALUES ('320102', '   玄武区');
INSERT INTO `chn_code` VALUES ('320104', '   秦淮区');
INSERT INTO `chn_code` VALUES ('320105', '   建邺区');
INSERT INTO `chn_code` VALUES ('320106', '   鼓楼区');
INSERT INTO `chn_code` VALUES ('320111', '   浦口区');
INSERT INTO `chn_code` VALUES ('320113', '   栖霞区');
INSERT INTO `chn_code` VALUES ('320114', '   雨花台区');
INSERT INTO `chn_code` VALUES ('320115', '   江宁区');
INSERT INTO `chn_code` VALUES ('320116', '   六合区');
INSERT INTO `chn_code` VALUES ('320117', '   溧水区');
INSERT INTO `chn_code` VALUES ('320118', '   高淳区');
INSERT INTO `chn_code` VALUES ('320200', ' 无锡市');
INSERT INTO `chn_code` VALUES ('320205', '   锡山区');
INSERT INTO `chn_code` VALUES ('320206', '   惠山区');
INSERT INTO `chn_code` VALUES ('320211', '   滨湖区');
INSERT INTO `chn_code` VALUES ('320213', '   梁溪区');
INSERT INTO `chn_code` VALUES ('320214', '   新吴区');
INSERT INTO `chn_code` VALUES ('320281', '   江阴市');
INSERT INTO `chn_code` VALUES ('320282', '   宜兴市');
INSERT INTO `chn_code` VALUES ('320300', ' 徐州市');
INSERT INTO `chn_code` VALUES ('320302', '   鼓楼区');
INSERT INTO `chn_code` VALUES ('320303', '   云龙区');
INSERT INTO `chn_code` VALUES ('320305', '   贾汪区');
INSERT INTO `chn_code` VALUES ('320311', '   泉山区');
INSERT INTO `chn_code` VALUES ('320312', '   铜山区');
INSERT INTO `chn_code` VALUES ('320321', '   丰县');
INSERT INTO `chn_code` VALUES ('320322', '   沛县');
INSERT INTO `chn_code` VALUES ('320324', '   睢宁县');
INSERT INTO `chn_code` VALUES ('320381', '   新沂市');
INSERT INTO `chn_code` VALUES ('320382', '   邳州市');
INSERT INTO `chn_code` VALUES ('320400', ' 常州市');
INSERT INTO `chn_code` VALUES ('320402', '   天宁区');
INSERT INTO `chn_code` VALUES ('320404', '   钟楼区');
INSERT INTO `chn_code` VALUES ('320411', '   新北区');
INSERT INTO `chn_code` VALUES ('320412', '   武进区');
INSERT INTO `chn_code` VALUES ('320413', '   金坛区');
INSERT INTO `chn_code` VALUES ('320481', '   溧阳市');
INSERT INTO `chn_code` VALUES ('320500', ' 苏州市');
INSERT INTO `chn_code` VALUES ('320505', '   虎丘区');
INSERT INTO `chn_code` VALUES ('320506', '   吴中区');
INSERT INTO `chn_code` VALUES ('320507', '   相城区');
INSERT INTO `chn_code` VALUES ('320508', '   姑苏区');
INSERT INTO `chn_code` VALUES ('320509', '   吴江区');
INSERT INTO `chn_code` VALUES ('320581', '   常熟市');
INSERT INTO `chn_code` VALUES ('320582', '   张家港市');
INSERT INTO `chn_code` VALUES ('320583', '   昆山市');
INSERT INTO `chn_code` VALUES ('320585', '   太仓市');
INSERT INTO `chn_code` VALUES ('320600', ' 南通市');
INSERT INTO `chn_code` VALUES ('320612', '   通州区');
INSERT INTO `chn_code` VALUES ('320613', '   崇川区');
INSERT INTO `chn_code` VALUES ('320614', '   海门区');
INSERT INTO `chn_code` VALUES ('320623', '   如东县');
INSERT INTO `chn_code` VALUES ('320681', '   启东市');
INSERT INTO `chn_code` VALUES ('320682', '   如皋市');
INSERT INTO `chn_code` VALUES ('320685', '   海安市');
INSERT INTO `chn_code` VALUES ('320700', ' 连云港市');
INSERT INTO `chn_code` VALUES ('320703', '   连云区');
INSERT INTO `chn_code` VALUES ('320706', '   海州区');
INSERT INTO `chn_code` VALUES ('320707', '   赣榆区');
INSERT INTO `chn_code` VALUES ('320722', '   东海县');
INSERT INTO `chn_code` VALUES ('320723', '   灌云县');
INSERT INTO `chn_code` VALUES ('320724', '   灌南县');
INSERT INTO `chn_code` VALUES ('320800', ' 淮安市');
INSERT INTO `chn_code` VALUES ('320803', '   淮安区');
INSERT INTO `chn_code` VALUES ('320804', '   淮阴区');
INSERT INTO `chn_code` VALUES ('320812', '   清江浦区');
INSERT INTO `chn_code` VALUES ('320813', '   洪泽区');
INSERT INTO `chn_code` VALUES ('320826', '   涟水县');
INSERT INTO `chn_code` VALUES ('320830', '   盱眙县');
INSERT INTO `chn_code` VALUES ('320831', '   金湖县');
INSERT INTO `chn_code` VALUES ('320900', ' 盐城市');
INSERT INTO `chn_code` VALUES ('320902', '   亭湖区');
INSERT INTO `chn_code` VALUES ('320903', '   盐都区');
INSERT INTO `chn_code` VALUES ('320904', '   大丰区');
INSERT INTO `chn_code` VALUES ('320921', '   响水县');
INSERT INTO `chn_code` VALUES ('320922', '   滨海县');
INSERT INTO `chn_code` VALUES ('320923', '   阜宁县');
INSERT INTO `chn_code` VALUES ('320924', '   射阳县');
INSERT INTO `chn_code` VALUES ('320925', '   建湖县');
INSERT INTO `chn_code` VALUES ('320981', '   东台市');
INSERT INTO `chn_code` VALUES ('321000', ' 扬州市');
INSERT INTO `chn_code` VALUES ('321002', '   广陵区');
INSERT INTO `chn_code` VALUES ('321003', '   邗江区');
INSERT INTO `chn_code` VALUES ('321012', '   江都区');
INSERT INTO `chn_code` VALUES ('321023', '   宝应县');
INSERT INTO `chn_code` VALUES ('321081', '   仪征市');
INSERT INTO `chn_code` VALUES ('321084', '   高邮市');
INSERT INTO `chn_code` VALUES ('321100', ' 镇江市');
INSERT INTO `chn_code` VALUES ('321102', '   京口区');
INSERT INTO `chn_code` VALUES ('321111', '   润州区');
INSERT INTO `chn_code` VALUES ('321112', '   丹徒区');
INSERT INTO `chn_code` VALUES ('321181', '   丹阳市');
INSERT INTO `chn_code` VALUES ('321182', '   扬中市');
INSERT INTO `chn_code` VALUES ('321183', '   句容市');
INSERT INTO `chn_code` VALUES ('321200', ' 泰州市');
INSERT INTO `chn_code` VALUES ('321202', '   海陵区');
INSERT INTO `chn_code` VALUES ('321203', '   高港区');
INSERT INTO `chn_code` VALUES ('321204', '   姜堰区');
INSERT INTO `chn_code` VALUES ('321281', '   兴化市');
INSERT INTO `chn_code` VALUES ('321282', '   靖江市');
INSERT INTO `chn_code` VALUES ('321283', '   泰兴市');
INSERT INTO `chn_code` VALUES ('321300', ' 宿迁市');
INSERT INTO `chn_code` VALUES ('321302', '   宿城区');
INSERT INTO `chn_code` VALUES ('321311', '   宿豫区');
INSERT INTO `chn_code` VALUES ('321322', '   沭阳县');
INSERT INTO `chn_code` VALUES ('321323', '   泗阳县');
INSERT INTO `chn_code` VALUES ('321324', '   泗洪县');
INSERT INTO `chn_code` VALUES ('330000', '浙江省');
INSERT INTO `chn_code` VALUES ('330100', ' 杭州市');
INSERT INTO `chn_code` VALUES ('330102', '   上城区');
INSERT INTO `chn_code` VALUES ('330103', '   下城区');
INSERT INTO `chn_code` VALUES ('330104', '   江干区');
INSERT INTO `chn_code` VALUES ('330105', '   拱墅区');
INSERT INTO `chn_code` VALUES ('330106', '   西湖区');
INSERT INTO `chn_code` VALUES ('330108', '   滨江区');
INSERT INTO `chn_code` VALUES ('330109', '   萧山区');
INSERT INTO `chn_code` VALUES ('330110', '   余杭区');
INSERT INTO `chn_code` VALUES ('330111', '   富阳区');
INSERT INTO `chn_code` VALUES ('330112', '   临安区');
INSERT INTO `chn_code` VALUES ('330122', '   桐庐县');
INSERT INTO `chn_code` VALUES ('330127', '   淳安县');
INSERT INTO `chn_code` VALUES ('330182', '   建德市');
INSERT INTO `chn_code` VALUES ('330200', ' 宁波市');
INSERT INTO `chn_code` VALUES ('330203', '   海曙区');
INSERT INTO `chn_code` VALUES ('330205', '   江北区');
INSERT INTO `chn_code` VALUES ('330206', '   北仑区');
INSERT INTO `chn_code` VALUES ('330211', '   镇海区');
INSERT INTO `chn_code` VALUES ('330212', '   鄞州区');
INSERT INTO `chn_code` VALUES ('330213', '   奉化区');
INSERT INTO `chn_code` VALUES ('330225', '   象山县');
INSERT INTO `chn_code` VALUES ('330226', '   宁海县');
INSERT INTO `chn_code` VALUES ('330281', '   余姚市');
INSERT INTO `chn_code` VALUES ('330282', '   慈溪市');
INSERT INTO `chn_code` VALUES ('330300', ' 温州市');
INSERT INTO `chn_code` VALUES ('330302', '   鹿城区');
INSERT INTO `chn_code` VALUES ('330303', '   龙湾区');
INSERT INTO `chn_code` VALUES ('330304', '   瓯海区');
INSERT INTO `chn_code` VALUES ('330305', '   洞头区');
INSERT INTO `chn_code` VALUES ('330324', '   永嘉县');
INSERT INTO `chn_code` VALUES ('330326', '   平阳县');
INSERT INTO `chn_code` VALUES ('330327', '   苍南县');
INSERT INTO `chn_code` VALUES ('330328', '   文成县');
INSERT INTO `chn_code` VALUES ('330329', '   泰顺县');
INSERT INTO `chn_code` VALUES ('330381', '   瑞安市');
INSERT INTO `chn_code` VALUES ('330382', '   乐清市');
INSERT INTO `chn_code` VALUES ('330383', '   龙港市');
INSERT INTO `chn_code` VALUES ('330400', ' 嘉兴市');
INSERT INTO `chn_code` VALUES ('330402', '   南湖区');
INSERT INTO `chn_code` VALUES ('330411', '   秀洲区');
INSERT INTO `chn_code` VALUES ('330421', '   嘉善县');
INSERT INTO `chn_code` VALUES ('330424', '   海盐县');
INSERT INTO `chn_code` VALUES ('330481', '   海宁市');
INSERT INTO `chn_code` VALUES ('330482', '   平湖市');
INSERT INTO `chn_code` VALUES ('330483', '   桐乡市');
INSERT INTO `chn_code` VALUES ('330500', ' 湖州市');
INSERT INTO `chn_code` VALUES ('330502', '   吴兴区');
INSERT INTO `chn_code` VALUES ('330503', '   南浔区');
INSERT INTO `chn_code` VALUES ('330521', '   德清县');
INSERT INTO `chn_code` VALUES ('330522', '   长兴县');
INSERT INTO `chn_code` VALUES ('330523', '   安吉县');
INSERT INTO `chn_code` VALUES ('330600', ' 绍兴市');
INSERT INTO `chn_code` VALUES ('330602', '   越城区');
INSERT INTO `chn_code` VALUES ('330603', '   柯桥区');
INSERT INTO `chn_code` VALUES ('330604', '   上虞区');
INSERT INTO `chn_code` VALUES ('330624', '   新昌县');
INSERT INTO `chn_code` VALUES ('330681', '   诸暨市');
INSERT INTO `chn_code` VALUES ('330683', '   嵊州市');
INSERT INTO `chn_code` VALUES ('330700', ' 金华市');
INSERT INTO `chn_code` VALUES ('330702', '   婺城区');
INSERT INTO `chn_code` VALUES ('330703', '   金东区');
INSERT INTO `chn_code` VALUES ('330723', '   武义县');
INSERT INTO `chn_code` VALUES ('330726', '   浦江县');
INSERT INTO `chn_code` VALUES ('330727', '   磐安县');
INSERT INTO `chn_code` VALUES ('330781', '   兰溪市');
INSERT INTO `chn_code` VALUES ('330782', '   义乌市');
INSERT INTO `chn_code` VALUES ('330783', '   东阳市');
INSERT INTO `chn_code` VALUES ('330784', '   永康市');
INSERT INTO `chn_code` VALUES ('330800', ' 衢州市');
INSERT INTO `chn_code` VALUES ('330802', '   柯城区');
INSERT INTO `chn_code` VALUES ('330803', '   衢江区');
INSERT INTO `chn_code` VALUES ('330822', '   常山县');
INSERT INTO `chn_code` VALUES ('330824', '   开化县');
INSERT INTO `chn_code` VALUES ('330825', '   龙游县');
INSERT INTO `chn_code` VALUES ('330881', '   江山市');
INSERT INTO `chn_code` VALUES ('330900', ' 舟山市');
INSERT INTO `chn_code` VALUES ('330902', '   定海区');
INSERT INTO `chn_code` VALUES ('330903', '   普陀区');
INSERT INTO `chn_code` VALUES ('330921', '   岱山县');
INSERT INTO `chn_code` VALUES ('330922', '   嵊泗县');
INSERT INTO `chn_code` VALUES ('331000', ' 台州市');
INSERT INTO `chn_code` VALUES ('331002', '   椒江区');
INSERT INTO `chn_code` VALUES ('331003', '   黄岩区');
INSERT INTO `chn_code` VALUES ('331004', '   路桥区');
INSERT INTO `chn_code` VALUES ('331022', '   三门县');
INSERT INTO `chn_code` VALUES ('331023', '   天台县');
INSERT INTO `chn_code` VALUES ('331024', '   仙居县');
INSERT INTO `chn_code` VALUES ('331081', '   温岭市');
INSERT INTO `chn_code` VALUES ('331082', '   临海市');
INSERT INTO `chn_code` VALUES ('331083', '   玉环市');
INSERT INTO `chn_code` VALUES ('331100', ' 丽水市');
INSERT INTO `chn_code` VALUES ('331102', '   莲都区');
INSERT INTO `chn_code` VALUES ('331121', '   青田县');
INSERT INTO `chn_code` VALUES ('331122', '   缙云县');
INSERT INTO `chn_code` VALUES ('331123', '   遂昌县');
INSERT INTO `chn_code` VALUES ('331124', '   松阳县');
INSERT INTO `chn_code` VALUES ('331125', '   云和县');
INSERT INTO `chn_code` VALUES ('331126', '   庆元县');
INSERT INTO `chn_code` VALUES ('331127', '   景宁畲族自治县');
INSERT INTO `chn_code` VALUES ('331181', '   龙泉市');
INSERT INTO `chn_code` VALUES ('340000', '安徽省');
INSERT INTO `chn_code` VALUES ('340100', ' 合肥市');
INSERT INTO `chn_code` VALUES ('340102', '   瑶海区');
INSERT INTO `chn_code` VALUES ('340103', '   庐阳区');
INSERT INTO `chn_code` VALUES ('340104', '   蜀山区');
INSERT INTO `chn_code` VALUES ('340111', '   包河区');
INSERT INTO `chn_code` VALUES ('340121', '   长丰县');
INSERT INTO `chn_code` VALUES ('340122', '   肥东县');
INSERT INTO `chn_code` VALUES ('340123', '   肥西县');
INSERT INTO `chn_code` VALUES ('340124', '   庐江县');
INSERT INTO `chn_code` VALUES ('340181', '   巢湖市');
INSERT INTO `chn_code` VALUES ('340200', ' 芜湖市');
INSERT INTO `chn_code` VALUES ('340202', '   镜湖区');
INSERT INTO `chn_code` VALUES ('340207', '   鸠江区');
INSERT INTO `chn_code` VALUES ('340209', '   弋江区 ');
INSERT INTO `chn_code` VALUES ('340210', '   湾沚区 ');
INSERT INTO `chn_code` VALUES ('340212', '   繁昌区');
INSERT INTO `chn_code` VALUES ('340223', '   南陵县');
INSERT INTO `chn_code` VALUES ('340281', '   无为市');
INSERT INTO `chn_code` VALUES ('340300', ' 蚌埠市');
INSERT INTO `chn_code` VALUES ('340302', '   龙子湖区');
INSERT INTO `chn_code` VALUES ('340303', '   蚌山区');
INSERT INTO `chn_code` VALUES ('340304', '   禹会区');
INSERT INTO `chn_code` VALUES ('340311', '   淮上区');
INSERT INTO `chn_code` VALUES ('340321', '   怀远县');
INSERT INTO `chn_code` VALUES ('340322', '   五河县');
INSERT INTO `chn_code` VALUES ('340323', '   固镇县');
INSERT INTO `chn_code` VALUES ('340400', ' 淮南市');
INSERT INTO `chn_code` VALUES ('340402', '   大通区');
INSERT INTO `chn_code` VALUES ('340403', '   田家庵区');
INSERT INTO `chn_code` VALUES ('340404', '   谢家集区');
INSERT INTO `chn_code` VALUES ('340405', '   八公山区');
INSERT INTO `chn_code` VALUES ('340406', '   潘集区');
INSERT INTO `chn_code` VALUES ('340421', '   凤台县');
INSERT INTO `chn_code` VALUES ('340422', '   寿县');
INSERT INTO `chn_code` VALUES ('340500', ' 马鞍山市');
INSERT INTO `chn_code` VALUES ('340503', '   花山区');
INSERT INTO `chn_code` VALUES ('340504', '   雨山区');
INSERT INTO `chn_code` VALUES ('340506', '   博望区');
INSERT INTO `chn_code` VALUES ('340521', '   当涂县');
INSERT INTO `chn_code` VALUES ('340522', '   含山县');
INSERT INTO `chn_code` VALUES ('340523', '   和县');
INSERT INTO `chn_code` VALUES ('340600', ' 淮北市');
INSERT INTO `chn_code` VALUES ('340602', '   杜集区');
INSERT INTO `chn_code` VALUES ('340603', '   相山区');
INSERT INTO `chn_code` VALUES ('340604', '   烈山区');
INSERT INTO `chn_code` VALUES ('340621', '   濉溪县');
INSERT INTO `chn_code` VALUES ('340700', ' 铜陵市');
INSERT INTO `chn_code` VALUES ('340705', '   铜官区');
INSERT INTO `chn_code` VALUES ('340706', '   义安区');
INSERT INTO `chn_code` VALUES ('340711', '   郊区');
INSERT INTO `chn_code` VALUES ('340722', '   枞阳县');
INSERT INTO `chn_code` VALUES ('340800', ' 安庆市');
INSERT INTO `chn_code` VALUES ('340802', '   迎江区');
INSERT INTO `chn_code` VALUES ('340803', '   大观区');
INSERT INTO `chn_code` VALUES ('340811', '   宜秀区');
INSERT INTO `chn_code` VALUES ('340822', '   怀宁县');
INSERT INTO `chn_code` VALUES ('340825', '   太湖县');
INSERT INTO `chn_code` VALUES ('340826', '   宿松县');
INSERT INTO `chn_code` VALUES ('340827', '   望江县');
INSERT INTO `chn_code` VALUES ('340828', '   岳西县');
INSERT INTO `chn_code` VALUES ('340881', '   桐城市');
INSERT INTO `chn_code` VALUES ('340882', '   潜山市');
INSERT INTO `chn_code` VALUES ('341000', ' 黄山市');
INSERT INTO `chn_code` VALUES ('341002', '   屯溪区');
INSERT INTO `chn_code` VALUES ('341003', '   黄山区');
INSERT INTO `chn_code` VALUES ('341004', '   徽州区');
INSERT INTO `chn_code` VALUES ('341021', '   歙县');
INSERT INTO `chn_code` VALUES ('341022', '   休宁县');
INSERT INTO `chn_code` VALUES ('341023', '   黟县');
INSERT INTO `chn_code` VALUES ('341024', '   祁门县');
INSERT INTO `chn_code` VALUES ('341100', ' 滁州市');
INSERT INTO `chn_code` VALUES ('341102', '   琅琊区');
INSERT INTO `chn_code` VALUES ('341103', '   南谯区');
INSERT INTO `chn_code` VALUES ('341122', '   来安县');
INSERT INTO `chn_code` VALUES ('341124', '   全椒县');
INSERT INTO `chn_code` VALUES ('341125', '   定远县');
INSERT INTO `chn_code` VALUES ('341126', '   凤阳县');
INSERT INTO `chn_code` VALUES ('341181', '   天长市');
INSERT INTO `chn_code` VALUES ('341182', '   明光市');
INSERT INTO `chn_code` VALUES ('341200', ' 阜阳市');
INSERT INTO `chn_code` VALUES ('341202', '   颍州区');
INSERT INTO `chn_code` VALUES ('341203', '   颍东区');
INSERT INTO `chn_code` VALUES ('341204', '   颍泉区');
INSERT INTO `chn_code` VALUES ('341221', '   临泉县');
INSERT INTO `chn_code` VALUES ('341222', '   太和县');
INSERT INTO `chn_code` VALUES ('341225', '   阜南县');
INSERT INTO `chn_code` VALUES ('341226', '   颍上县');
INSERT INTO `chn_code` VALUES ('341282', '   界首市');
INSERT INTO `chn_code` VALUES ('341300', ' 宿州市');
INSERT INTO `chn_code` VALUES ('341302', '   埇桥区');
INSERT INTO `chn_code` VALUES ('341321', '   砀山县');
INSERT INTO `chn_code` VALUES ('341322', '   萧县');
INSERT INTO `chn_code` VALUES ('341323', '   灵璧县');
INSERT INTO `chn_code` VALUES ('341324', '   泗县');
INSERT INTO `chn_code` VALUES ('341500', ' 六安市');
INSERT INTO `chn_code` VALUES ('341502', '   金安区');
INSERT INTO `chn_code` VALUES ('341503', '   裕安区');
INSERT INTO `chn_code` VALUES ('341504', '   叶集区');
INSERT INTO `chn_code` VALUES ('341522', '   霍邱县');
INSERT INTO `chn_code` VALUES ('341523', '   舒城县');
INSERT INTO `chn_code` VALUES ('341524', '   金寨县');
INSERT INTO `chn_code` VALUES ('341525', '   霍山县');
INSERT INTO `chn_code` VALUES ('341600', ' 亳州市');
INSERT INTO `chn_code` VALUES ('341602', '   谯城区');
INSERT INTO `chn_code` VALUES ('341621', '   涡阳县');
INSERT INTO `chn_code` VALUES ('341622', '   蒙城县');
INSERT INTO `chn_code` VALUES ('341623', '   利辛县');
INSERT INTO `chn_code` VALUES ('341700', ' 池州市');
INSERT INTO `chn_code` VALUES ('341702', '   贵池区');
INSERT INTO `chn_code` VALUES ('341721', '   东至县');
INSERT INTO `chn_code` VALUES ('341722', '   石台县');
INSERT INTO `chn_code` VALUES ('341723', '   青阳县');
INSERT INTO `chn_code` VALUES ('341800', ' 宣城市');
INSERT INTO `chn_code` VALUES ('341802', '   宣州区');
INSERT INTO `chn_code` VALUES ('341821', '   郎溪县');
INSERT INTO `chn_code` VALUES ('341823', '   泾县');
INSERT INTO `chn_code` VALUES ('341824', '   绩溪县');
INSERT INTO `chn_code` VALUES ('341825', '   旌德县');
INSERT INTO `chn_code` VALUES ('341881', '   宁国市');
INSERT INTO `chn_code` VALUES ('341882', '   广德市');
INSERT INTO `chn_code` VALUES ('350000', '福建省');
INSERT INTO `chn_code` VALUES ('350100', ' 福州市');
INSERT INTO `chn_code` VALUES ('350102', '   鼓楼区');
INSERT INTO `chn_code` VALUES ('350103', '   台江区');
INSERT INTO `chn_code` VALUES ('350104', '   仓山区');
INSERT INTO `chn_code` VALUES ('350105', '   马尾区');
INSERT INTO `chn_code` VALUES ('350111', '   晋安区');
INSERT INTO `chn_code` VALUES ('350112', '   长乐区');
INSERT INTO `chn_code` VALUES ('350121', '   闽侯县');
INSERT INTO `chn_code` VALUES ('350122', '   连江县');
INSERT INTO `chn_code` VALUES ('350123', '   罗源县');
INSERT INTO `chn_code` VALUES ('350124', '   闽清县');
INSERT INTO `chn_code` VALUES ('350125', '   永泰县');
INSERT INTO `chn_code` VALUES ('350128', '   平潭县');
INSERT INTO `chn_code` VALUES ('350181', '   福清市');
INSERT INTO `chn_code` VALUES ('350200', ' 厦门市');
INSERT INTO `chn_code` VALUES ('350203', '   思明区');
INSERT INTO `chn_code` VALUES ('350205', '   海沧区');
INSERT INTO `chn_code` VALUES ('350206', '   湖里区');
INSERT INTO `chn_code` VALUES ('350211', '   集美区');
INSERT INTO `chn_code` VALUES ('350212', '   同安区');
INSERT INTO `chn_code` VALUES ('350213', '   翔安区');
INSERT INTO `chn_code` VALUES ('350300', ' 莆田市');
INSERT INTO `chn_code` VALUES ('350302', '   城厢区');
INSERT INTO `chn_code` VALUES ('350303', '   涵江区');
INSERT INTO `chn_code` VALUES ('350304', '   荔城区');
INSERT INTO `chn_code` VALUES ('350305', '   秀屿区');
INSERT INTO `chn_code` VALUES ('350322', '   仙游县');
INSERT INTO `chn_code` VALUES ('350400', ' 三明市');
INSERT INTO `chn_code` VALUES ('350402', '   梅列区');
INSERT INTO `chn_code` VALUES ('350403', '   三元区');
INSERT INTO `chn_code` VALUES ('350421', '   明溪县');
INSERT INTO `chn_code` VALUES ('350423', '   清流县');
INSERT INTO `chn_code` VALUES ('350424', '   宁化县');
INSERT INTO `chn_code` VALUES ('350425', '   大田县');
INSERT INTO `chn_code` VALUES ('350426', '   尤溪县');
INSERT INTO `chn_code` VALUES ('350427', '   沙县');
INSERT INTO `chn_code` VALUES ('350428', '   将乐县');
INSERT INTO `chn_code` VALUES ('350429', '   泰宁县');
INSERT INTO `chn_code` VALUES ('350430', '   建宁县');
INSERT INTO `chn_code` VALUES ('350481', '   永安市');
INSERT INTO `chn_code` VALUES ('350500', ' 泉州市');
INSERT INTO `chn_code` VALUES ('350502', '   鲤城区');
INSERT INTO `chn_code` VALUES ('350503', '   丰泽区');
INSERT INTO `chn_code` VALUES ('350504', '   洛江区');
INSERT INTO `chn_code` VALUES ('350505', '   泉港区');
INSERT INTO `chn_code` VALUES ('350521', '   惠安县');
INSERT INTO `chn_code` VALUES ('350524', '   安溪县');
INSERT INTO `chn_code` VALUES ('350525', '   永春县');
INSERT INTO `chn_code` VALUES ('350526', '   德化县');
INSERT INTO `chn_code` VALUES ('350527', '   金门县');
INSERT INTO `chn_code` VALUES ('350581', '   石狮市');
INSERT INTO `chn_code` VALUES ('350582', '   晋江市');
INSERT INTO `chn_code` VALUES ('350583', '   南安市');
INSERT INTO `chn_code` VALUES ('350600', ' 漳州市');
INSERT INTO `chn_code` VALUES ('350602', '   芗城区');
INSERT INTO `chn_code` VALUES ('350603', '   龙文区');
INSERT INTO `chn_code` VALUES ('350622', '   云霄县');
INSERT INTO `chn_code` VALUES ('350623', '   漳浦县');
INSERT INTO `chn_code` VALUES ('350624', '   诏安县');
INSERT INTO `chn_code` VALUES ('350625', '   长泰县');
INSERT INTO `chn_code` VALUES ('350626', '   东山县');
INSERT INTO `chn_code` VALUES ('350627', '   南靖县');
INSERT INTO `chn_code` VALUES ('350628', '   平和县');
INSERT INTO `chn_code` VALUES ('350629', '   华安县');
INSERT INTO `chn_code` VALUES ('350681', '   龙海市');
INSERT INTO `chn_code` VALUES ('350700', ' 南平市');
INSERT INTO `chn_code` VALUES ('350702', '   延平区');
INSERT INTO `chn_code` VALUES ('350703', '   建阳区');
INSERT INTO `chn_code` VALUES ('350721', '   顺昌县');
INSERT INTO `chn_code` VALUES ('350722', '   浦城县');
INSERT INTO `chn_code` VALUES ('350723', '   光泽县');
INSERT INTO `chn_code` VALUES ('350724', '   松溪县');
INSERT INTO `chn_code` VALUES ('350725', '   政和县');
INSERT INTO `chn_code` VALUES ('350781', '   邵武市');
INSERT INTO `chn_code` VALUES ('350782', '   武夷山市');
INSERT INTO `chn_code` VALUES ('350783', '   建瓯市');
INSERT INTO `chn_code` VALUES ('350800', ' 龙岩市');
INSERT INTO `chn_code` VALUES ('350802', '   新罗区');
INSERT INTO `chn_code` VALUES ('350803', '   永定区');
INSERT INTO `chn_code` VALUES ('350821', '   长汀县');
INSERT INTO `chn_code` VALUES ('350823', '   上杭县');
INSERT INTO `chn_code` VALUES ('350824', '   武平县');
INSERT INTO `chn_code` VALUES ('350825', '   连城县');
INSERT INTO `chn_code` VALUES ('350881', '   漳平市');
INSERT INTO `chn_code` VALUES ('350900', ' 宁德市');
INSERT INTO `chn_code` VALUES ('350902', '   蕉城区');
INSERT INTO `chn_code` VALUES ('350921', '   霞浦县');
INSERT INTO `chn_code` VALUES ('350922', '   古田县');
INSERT INTO `chn_code` VALUES ('350923', '   屏南县');
INSERT INTO `chn_code` VALUES ('350924', '   寿宁县');
INSERT INTO `chn_code` VALUES ('350925', '   周宁县');
INSERT INTO `chn_code` VALUES ('350926', '   柘荣县');
INSERT INTO `chn_code` VALUES ('350981', '   福安市');
INSERT INTO `chn_code` VALUES ('350982', '   福鼎市');
INSERT INTO `chn_code` VALUES ('360000', '江西省');
INSERT INTO `chn_code` VALUES ('360100', ' 南昌市');
INSERT INTO `chn_code` VALUES ('360102', '   东湖区');
INSERT INTO `chn_code` VALUES ('360103', '   西湖区');
INSERT INTO `chn_code` VALUES ('360104', '   青云谱区');
INSERT INTO `chn_code` VALUES ('360111', '   青山湖区');
INSERT INTO `chn_code` VALUES ('360112', '   新建区');
INSERT INTO `chn_code` VALUES ('360113', '   红谷滩区');
INSERT INTO `chn_code` VALUES ('360121', '   南昌县');
INSERT INTO `chn_code` VALUES ('360123', '   安义县');
INSERT INTO `chn_code` VALUES ('360124', '   进贤县');
INSERT INTO `chn_code` VALUES ('360200', ' 景德镇市');
INSERT INTO `chn_code` VALUES ('360202', '   昌江区');
INSERT INTO `chn_code` VALUES ('360203', '   珠山区');
INSERT INTO `chn_code` VALUES ('360222', '   浮梁县');
INSERT INTO `chn_code` VALUES ('360281', '   乐平市');
INSERT INTO `chn_code` VALUES ('360300', ' 萍乡市');
INSERT INTO `chn_code` VALUES ('360302', '   安源区');
INSERT INTO `chn_code` VALUES ('360313', '   湘东区');
INSERT INTO `chn_code` VALUES ('360321', '   莲花县');
INSERT INTO `chn_code` VALUES ('360322', '   上栗县');
INSERT INTO `chn_code` VALUES ('360323', '   芦溪县');
INSERT INTO `chn_code` VALUES ('360400', ' 九江市');
INSERT INTO `chn_code` VALUES ('360402', '   濂溪区');
INSERT INTO `chn_code` VALUES ('360403', '   浔阳区');
INSERT INTO `chn_code` VALUES ('360404', '   柴桑区');
INSERT INTO `chn_code` VALUES ('360423', '   武宁县');
INSERT INTO `chn_code` VALUES ('360424', '   修水县');
INSERT INTO `chn_code` VALUES ('360425', '   永修县');
INSERT INTO `chn_code` VALUES ('360426', '   德安县');
INSERT INTO `chn_code` VALUES ('360428', '   都昌县');
INSERT INTO `chn_code` VALUES ('360429', '   湖口县');
INSERT INTO `chn_code` VALUES ('360430', '   彭泽县');
INSERT INTO `chn_code` VALUES ('360481', '   瑞昌市');
INSERT INTO `chn_code` VALUES ('360482', '   共青城市');
INSERT INTO `chn_code` VALUES ('360483', '   庐山市');
INSERT INTO `chn_code` VALUES ('360500', ' 新余市');
INSERT INTO `chn_code` VALUES ('360502', '   渝水区');
INSERT INTO `chn_code` VALUES ('360521', '   分宜县');
INSERT INTO `chn_code` VALUES ('360600', ' 鹰潭市');
INSERT INTO `chn_code` VALUES ('360602', '   月湖区');
INSERT INTO `chn_code` VALUES ('360603', '   余江区');
INSERT INTO `chn_code` VALUES ('360681', '   贵溪市');
INSERT INTO `chn_code` VALUES ('360700', ' 赣州市');
INSERT INTO `chn_code` VALUES ('360702', '   章贡区');
INSERT INTO `chn_code` VALUES ('360703', '   南康区');
INSERT INTO `chn_code` VALUES ('360704', '   赣县区');
INSERT INTO `chn_code` VALUES ('360722', '   信丰县');
INSERT INTO `chn_code` VALUES ('360723', '   大余县');
INSERT INTO `chn_code` VALUES ('360724', '   上犹县');
INSERT INTO `chn_code` VALUES ('360725', '   崇义县');
INSERT INTO `chn_code` VALUES ('360726', '   安远县');
INSERT INTO `chn_code` VALUES ('360728', '   定南县');
INSERT INTO `chn_code` VALUES ('360729', '   全南县');
INSERT INTO `chn_code` VALUES ('360730', '   宁都县');
INSERT INTO `chn_code` VALUES ('360731', '   于都县');
INSERT INTO `chn_code` VALUES ('360732', '   兴国县');
INSERT INTO `chn_code` VALUES ('360733', '   会昌县');
INSERT INTO `chn_code` VALUES ('360734', '   寻乌县');
INSERT INTO `chn_code` VALUES ('360735', '   石城县');
INSERT INTO `chn_code` VALUES ('360781', '   瑞金市');
INSERT INTO `chn_code` VALUES ('360783', '   龙南市');
INSERT INTO `chn_code` VALUES ('360800', ' 吉安市');
INSERT INTO `chn_code` VALUES ('360802', '   吉州区');
INSERT INTO `chn_code` VALUES ('360803', '   青原区');
INSERT INTO `chn_code` VALUES ('360821', '   吉安县');
INSERT INTO `chn_code` VALUES ('360822', '   吉水县');
INSERT INTO `chn_code` VALUES ('360823', '   峡江县');
INSERT INTO `chn_code` VALUES ('360824', '   新干县');
INSERT INTO `chn_code` VALUES ('360825', '   永丰县');
INSERT INTO `chn_code` VALUES ('360826', '   泰和县');
INSERT INTO `chn_code` VALUES ('360827', '   遂川县');
INSERT INTO `chn_code` VALUES ('360828', '   万安县');
INSERT INTO `chn_code` VALUES ('360829', '   安福县');
INSERT INTO `chn_code` VALUES ('360830', '   永新县');
INSERT INTO `chn_code` VALUES ('360881', '   井冈山市');
INSERT INTO `chn_code` VALUES ('360900', ' 宜春市');
INSERT INTO `chn_code` VALUES ('360902', '   袁州区');
INSERT INTO `chn_code` VALUES ('360921', '   奉新县');
INSERT INTO `chn_code` VALUES ('360922', '   万载县');
INSERT INTO `chn_code` VALUES ('360923', '   上高县');
INSERT INTO `chn_code` VALUES ('360924', '   宜丰县');
INSERT INTO `chn_code` VALUES ('360925', '   靖安县');
INSERT INTO `chn_code` VALUES ('360926', '   铜鼓县');
INSERT INTO `chn_code` VALUES ('360981', '   丰城市');
INSERT INTO `chn_code` VALUES ('360982', '   樟树市');
INSERT INTO `chn_code` VALUES ('360983', '   高安市');
INSERT INTO `chn_code` VALUES ('361000', ' 抚州市');
INSERT INTO `chn_code` VALUES ('361002', '   临川区');
INSERT INTO `chn_code` VALUES ('361003', '   东乡区');
INSERT INTO `chn_code` VALUES ('361021', '   南城县');
INSERT INTO `chn_code` VALUES ('361022', '   黎川县');
INSERT INTO `chn_code` VALUES ('361023', '   南丰县');
INSERT INTO `chn_code` VALUES ('361024', '   崇仁县');
INSERT INTO `chn_code` VALUES ('361025', '   乐安县');
INSERT INTO `chn_code` VALUES ('361026', '   宜黄县');
INSERT INTO `chn_code` VALUES ('361027', '   金溪县');
INSERT INTO `chn_code` VALUES ('361028', '   资溪县');
INSERT INTO `chn_code` VALUES ('361030', '   广昌县');
INSERT INTO `chn_code` VALUES ('361100', ' 上饶市');
INSERT INTO `chn_code` VALUES ('361102', '   信州区');
INSERT INTO `chn_code` VALUES ('361103', '   广丰区');
INSERT INTO `chn_code` VALUES ('361104', '   广信区');
INSERT INTO `chn_code` VALUES ('361123', '   玉山县');
INSERT INTO `chn_code` VALUES ('361124', '   铅山县');
INSERT INTO `chn_code` VALUES ('361125', '   横峰县');
INSERT INTO `chn_code` VALUES ('361126', '   弋阳县');
INSERT INTO `chn_code` VALUES ('361127', '   余干县');
INSERT INTO `chn_code` VALUES ('361128', '   鄱阳县');
INSERT INTO `chn_code` VALUES ('361129', '   万年县');
INSERT INTO `chn_code` VALUES ('361130', '   婺源县');
INSERT INTO `chn_code` VALUES ('361181', '   德兴市');
INSERT INTO `chn_code` VALUES ('370000', '山东省');
INSERT INTO `chn_code` VALUES ('370100', ' 济南市');
INSERT INTO `chn_code` VALUES ('370102', '   历下区');
INSERT INTO `chn_code` VALUES ('370103', '   市中区');
INSERT INTO `chn_code` VALUES ('370104', '   槐荫区');
INSERT INTO `chn_code` VALUES ('370105', '   天桥区');
INSERT INTO `chn_code` VALUES ('370112', '   历城区');
INSERT INTO `chn_code` VALUES ('370113', '   长清区');
INSERT INTO `chn_code` VALUES ('370114', '   章丘区');
INSERT INTO `chn_code` VALUES ('370115', '   济阳区');
INSERT INTO `chn_code` VALUES ('370116', '   莱芜区');
INSERT INTO `chn_code` VALUES ('370117', '   钢城区');
INSERT INTO `chn_code` VALUES ('370124', '   平阴县');
INSERT INTO `chn_code` VALUES ('370126', '   商河县');
INSERT INTO `chn_code` VALUES ('370200', ' 青岛市');
INSERT INTO `chn_code` VALUES ('370202', '   市南区');
INSERT INTO `chn_code` VALUES ('370203', '   市北区');
INSERT INTO `chn_code` VALUES ('370211', '   黄岛区');
INSERT INTO `chn_code` VALUES ('370212', '   崂山区');
INSERT INTO `chn_code` VALUES ('370213', '   李沧区');
INSERT INTO `chn_code` VALUES ('370214', '   城阳区');
INSERT INTO `chn_code` VALUES ('370215', '   即墨区');
INSERT INTO `chn_code` VALUES ('370281', '   胶州市');
INSERT INTO `chn_code` VALUES ('370283', '   平度市');
INSERT INTO `chn_code` VALUES ('370285', '   莱西市');
INSERT INTO `chn_code` VALUES ('370300', ' 淄博市');
INSERT INTO `chn_code` VALUES ('370302', '   淄川区');
INSERT INTO `chn_code` VALUES ('370303', '   张店区');
INSERT INTO `chn_code` VALUES ('370304', '   博山区');
INSERT INTO `chn_code` VALUES ('370305', '   临淄区');
INSERT INTO `chn_code` VALUES ('370306', '   周村区');
INSERT INTO `chn_code` VALUES ('370321', '   桓台县');
INSERT INTO `chn_code` VALUES ('370322', '   高青县');
INSERT INTO `chn_code` VALUES ('370323', '   沂源县');
INSERT INTO `chn_code` VALUES ('370400', ' 枣庄市');
INSERT INTO `chn_code` VALUES ('370402', '   市中区');
INSERT INTO `chn_code` VALUES ('370403', '   薛城区');
INSERT INTO `chn_code` VALUES ('370404', '   峄城区');
INSERT INTO `chn_code` VALUES ('370405', '   台儿庄区');
INSERT INTO `chn_code` VALUES ('370406', '   山亭区');
INSERT INTO `chn_code` VALUES ('370481', '   滕州市');
INSERT INTO `chn_code` VALUES ('370500', ' 东营市');
INSERT INTO `chn_code` VALUES ('370502', '   东营区');
INSERT INTO `chn_code` VALUES ('370503', '   河口区');
INSERT INTO `chn_code` VALUES ('370505', '   垦利区');
INSERT INTO `chn_code` VALUES ('370522', '   利津县');
INSERT INTO `chn_code` VALUES ('370523', '   广饶县');
INSERT INTO `chn_code` VALUES ('370600', ' 烟台市');
INSERT INTO `chn_code` VALUES ('370602', '   芝罘区');
INSERT INTO `chn_code` VALUES ('370611', '   福山区');
INSERT INTO `chn_code` VALUES ('370612', '   牟平区');
INSERT INTO `chn_code` VALUES ('370613', '   莱山区');
INSERT INTO `chn_code` VALUES ('370614', '   蓬莱区');
INSERT INTO `chn_code` VALUES ('370681', '   龙口市');
INSERT INTO `chn_code` VALUES ('370682', '   莱阳市');
INSERT INTO `chn_code` VALUES ('370683', '   莱州市');
INSERT INTO `chn_code` VALUES ('370685', '   招远市');
INSERT INTO `chn_code` VALUES ('370686', '   栖霞市');
INSERT INTO `chn_code` VALUES ('370687', '   海阳市');
INSERT INTO `chn_code` VALUES ('370700', ' 潍坊市');
INSERT INTO `chn_code` VALUES ('370702', '   潍城区');
INSERT INTO `chn_code` VALUES ('370703', '   寒亭区');
INSERT INTO `chn_code` VALUES ('370704', '   坊子区');
INSERT INTO `chn_code` VALUES ('370705', '   奎文区');
INSERT INTO `chn_code` VALUES ('370724', '   临朐县');
INSERT INTO `chn_code` VALUES ('370725', '   昌乐县');
INSERT INTO `chn_code` VALUES ('370781', '   青州市');
INSERT INTO `chn_code` VALUES ('370782', '   诸城市');
INSERT INTO `chn_code` VALUES ('370783', '   寿光市');
INSERT INTO `chn_code` VALUES ('370784', '   安丘市');
INSERT INTO `chn_code` VALUES ('370785', '   高密市');
INSERT INTO `chn_code` VALUES ('370786', '   昌邑市');
INSERT INTO `chn_code` VALUES ('370800', ' 济宁市');
INSERT INTO `chn_code` VALUES ('370811', '   任城区');
INSERT INTO `chn_code` VALUES ('370812', '   兖州区');
INSERT INTO `chn_code` VALUES ('370826', '   微山县');
INSERT INTO `chn_code` VALUES ('370827', '   鱼台县');
INSERT INTO `chn_code` VALUES ('370828', '   金乡县');
INSERT INTO `chn_code` VALUES ('370829', '   嘉祥县');
INSERT INTO `chn_code` VALUES ('370830', '   汶上县');
INSERT INTO `chn_code` VALUES ('370831', '   泗水县');
INSERT INTO `chn_code` VALUES ('370832', '   梁山县');
INSERT INTO `chn_code` VALUES ('370881', '   曲阜市');
INSERT INTO `chn_code` VALUES ('370883', '   邹城市');
INSERT INTO `chn_code` VALUES ('370900', ' 泰安市');
INSERT INTO `chn_code` VALUES ('370902', '   泰山区');
INSERT INTO `chn_code` VALUES ('370911', '   岱岳区');
INSERT INTO `chn_code` VALUES ('370921', '   宁阳县');
INSERT INTO `chn_code` VALUES ('370923', '   东平县');
INSERT INTO `chn_code` VALUES ('370982', '   新泰市');
INSERT INTO `chn_code` VALUES ('370983', '   肥城市');
INSERT INTO `chn_code` VALUES ('371000', ' 威海市');
INSERT INTO `chn_code` VALUES ('371002', '   环翠区');
INSERT INTO `chn_code` VALUES ('371003', '   文登区');
INSERT INTO `chn_code` VALUES ('371082', '   荣成市');
INSERT INTO `chn_code` VALUES ('371083', '   乳山市');
INSERT INTO `chn_code` VALUES ('371100', ' 日照市');
INSERT INTO `chn_code` VALUES ('371102', '   东港区');
INSERT INTO `chn_code` VALUES ('371103', '   岚山区');
INSERT INTO `chn_code` VALUES ('371121', '   五莲县');
INSERT INTO `chn_code` VALUES ('371122', '   莒县');
INSERT INTO `chn_code` VALUES ('371300', ' 临沂市');
INSERT INTO `chn_code` VALUES ('371302', '   兰山区');
INSERT INTO `chn_code` VALUES ('371311', '   罗庄区');
INSERT INTO `chn_code` VALUES ('371312', '   河东区');
INSERT INTO `chn_code` VALUES ('371321', '   沂南县');
INSERT INTO `chn_code` VALUES ('371322', '   郯城县');
INSERT INTO `chn_code` VALUES ('371323', '   沂水县');
INSERT INTO `chn_code` VALUES ('371324', '   兰陵县');
INSERT INTO `chn_code` VALUES ('371325', '   费县');
INSERT INTO `chn_code` VALUES ('371326', '   平邑县');
INSERT INTO `chn_code` VALUES ('371327', '   莒南县');
INSERT INTO `chn_code` VALUES ('371328', '   蒙阴县');
INSERT INTO `chn_code` VALUES ('371329', '   临沭县');
INSERT INTO `chn_code` VALUES ('371400', ' 德州市');
INSERT INTO `chn_code` VALUES ('371402', '   德城区');
INSERT INTO `chn_code` VALUES ('371403', '   陵城区');
INSERT INTO `chn_code` VALUES ('371422', '   宁津县');
INSERT INTO `chn_code` VALUES ('371423', '   庆云县');
INSERT INTO `chn_code` VALUES ('371424', '   临邑县');
INSERT INTO `chn_code` VALUES ('371425', '   齐河县');
INSERT INTO `chn_code` VALUES ('371426', '   平原县');
INSERT INTO `chn_code` VALUES ('371427', '   夏津县');
INSERT INTO `chn_code` VALUES ('371428', '   武城县');
INSERT INTO `chn_code` VALUES ('371481', '   乐陵市');
INSERT INTO `chn_code` VALUES ('371482', '   禹城市');
INSERT INTO `chn_code` VALUES ('371500', ' 聊城市');
INSERT INTO `chn_code` VALUES ('371502', '   东昌府区');
INSERT INTO `chn_code` VALUES ('371503', '   茌平区');
INSERT INTO `chn_code` VALUES ('371521', '   阳谷县');
INSERT INTO `chn_code` VALUES ('371522', '   莘县');
INSERT INTO `chn_code` VALUES ('371524', '   东阿县');
INSERT INTO `chn_code` VALUES ('371525', '   冠县');
INSERT INTO `chn_code` VALUES ('371526', '   高唐县');
INSERT INTO `chn_code` VALUES ('371581', '   临清市');
INSERT INTO `chn_code` VALUES ('371600', ' 滨州市');
INSERT INTO `chn_code` VALUES ('371602', '   滨城区');
INSERT INTO `chn_code` VALUES ('371603', '   沾化区');
INSERT INTO `chn_code` VALUES ('371621', '   惠民县');
INSERT INTO `chn_code` VALUES ('371622', '   阳信县');
INSERT INTO `chn_code` VALUES ('371623', '   无棣县');
INSERT INTO `chn_code` VALUES ('371625', '   博兴县');
INSERT INTO `chn_code` VALUES ('371681', '   邹平市');
INSERT INTO `chn_code` VALUES ('371700', ' 菏泽市');
INSERT INTO `chn_code` VALUES ('371702', '   牡丹区');
INSERT INTO `chn_code` VALUES ('371703', '   定陶区');
INSERT INTO `chn_code` VALUES ('371721', '   曹县');
INSERT INTO `chn_code` VALUES ('371722', '   单县');
INSERT INTO `chn_code` VALUES ('371723', '   成武县');
INSERT INTO `chn_code` VALUES ('371724', '   巨野县');
INSERT INTO `chn_code` VALUES ('371725', '   郓城县');
INSERT INTO `chn_code` VALUES ('371726', '   鄄城县');
INSERT INTO `chn_code` VALUES ('371728', '   东明县');
INSERT INTO `chn_code` VALUES ('410000', '河南省');
INSERT INTO `chn_code` VALUES ('410100', ' 郑州市');
INSERT INTO `chn_code` VALUES ('410102', '   中原区');
INSERT INTO `chn_code` VALUES ('410103', '   二七区');
INSERT INTO `chn_code` VALUES ('410104', '   管城回族区');
INSERT INTO `chn_code` VALUES ('410105', '   金水区');
INSERT INTO `chn_code` VALUES ('410106', '   上街区');
INSERT INTO `chn_code` VALUES ('410108', '   惠济区');
INSERT INTO `chn_code` VALUES ('410122', '   中牟县');
INSERT INTO `chn_code` VALUES ('410181', '   巩义市');
INSERT INTO `chn_code` VALUES ('410182', '   荥阳市');
INSERT INTO `chn_code` VALUES ('410183', '   新密市');
INSERT INTO `chn_code` VALUES ('410184', '   新郑市');
INSERT INTO `chn_code` VALUES ('410185', '   登封市');
INSERT INTO `chn_code` VALUES ('410200', ' 开封市');
INSERT INTO `chn_code` VALUES ('410202', '   龙亭区');
INSERT INTO `chn_code` VALUES ('410203', '   顺河回族区');
INSERT INTO `chn_code` VALUES ('410204', '   鼓楼区');
INSERT INTO `chn_code` VALUES ('410205', '   禹王台区');
INSERT INTO `chn_code` VALUES ('410212', '   祥符区');
INSERT INTO `chn_code` VALUES ('410221', '   杞县');
INSERT INTO `chn_code` VALUES ('410222', '   通许县');
INSERT INTO `chn_code` VALUES ('410223', '   尉氏县');
INSERT INTO `chn_code` VALUES ('410225', '   兰考县');
INSERT INTO `chn_code` VALUES ('410300', ' 洛阳市');
INSERT INTO `chn_code` VALUES ('410302', '   老城区');
INSERT INTO `chn_code` VALUES ('410303', '   西工区');
INSERT INTO `chn_code` VALUES ('410304', '   瀍河回族区');
INSERT INTO `chn_code` VALUES ('410305', '   涧西区');
INSERT INTO `chn_code` VALUES ('410306', '   吉利区');
INSERT INTO `chn_code` VALUES ('410311', '   洛龙区');
INSERT INTO `chn_code` VALUES ('410322', '   孟津县');
INSERT INTO `chn_code` VALUES ('410323', '   新安县');
INSERT INTO `chn_code` VALUES ('410324', '   栾川县');
INSERT INTO `chn_code` VALUES ('410325', '   嵩县');
INSERT INTO `chn_code` VALUES ('410326', '   汝阳县');
INSERT INTO `chn_code` VALUES ('410327', '   宜阳县');
INSERT INTO `chn_code` VALUES ('410328', '   洛宁县');
INSERT INTO `chn_code` VALUES ('410329', '   伊川县');
INSERT INTO `chn_code` VALUES ('410381', '   偃师市');
INSERT INTO `chn_code` VALUES ('410400', ' 平顶山市');
INSERT INTO `chn_code` VALUES ('410402', '   新华区');
INSERT INTO `chn_code` VALUES ('410403', '   卫东区');
INSERT INTO `chn_code` VALUES ('410404', '   石龙区');
INSERT INTO `chn_code` VALUES ('410411', '   湛河区');
INSERT INTO `chn_code` VALUES ('410421', '   宝丰县');
INSERT INTO `chn_code` VALUES ('410422', '   叶县');
INSERT INTO `chn_code` VALUES ('410423', '   鲁山县');
INSERT INTO `chn_code` VALUES ('410425', '   郏县');
INSERT INTO `chn_code` VALUES ('410481', '   舞钢市');
INSERT INTO `chn_code` VALUES ('410482', '   汝州市');
INSERT INTO `chn_code` VALUES ('410500', ' 安阳市');
INSERT INTO `chn_code` VALUES ('410502', '   文峰区');
INSERT INTO `chn_code` VALUES ('410503', '   北关区');
INSERT INTO `chn_code` VALUES ('410505', '   殷都区');
INSERT INTO `chn_code` VALUES ('410506', '   龙安区');
INSERT INTO `chn_code` VALUES ('410522', '   安阳县');
INSERT INTO `chn_code` VALUES ('410523', '   汤阴县');
INSERT INTO `chn_code` VALUES ('410526', '   滑县');
INSERT INTO `chn_code` VALUES ('410527', '   内黄县');
INSERT INTO `chn_code` VALUES ('410581', '   林州市');
INSERT INTO `chn_code` VALUES ('410600', ' 鹤壁市');
INSERT INTO `chn_code` VALUES ('410602', '   鹤山区');
INSERT INTO `chn_code` VALUES ('410603', '   山城区');
INSERT INTO `chn_code` VALUES ('410611', '   淇滨区');
INSERT INTO `chn_code` VALUES ('410621', '   浚县');
INSERT INTO `chn_code` VALUES ('410622', '   淇县');
INSERT INTO `chn_code` VALUES ('410700', ' 新乡市');
INSERT INTO `chn_code` VALUES ('410702', '   红旗区');
INSERT INTO `chn_code` VALUES ('410703', '   卫滨区');
INSERT INTO `chn_code` VALUES ('410704', '   凤泉区');
INSERT INTO `chn_code` VALUES ('410711', '   牧野区');
INSERT INTO `chn_code` VALUES ('410721', '   新乡县');
INSERT INTO `chn_code` VALUES ('410724', '   获嘉县');
INSERT INTO `chn_code` VALUES ('410725', '   原阳县');
INSERT INTO `chn_code` VALUES ('410726', '   延津县');
INSERT INTO `chn_code` VALUES ('410727', '   封丘县');
INSERT INTO `chn_code` VALUES ('410781', '   卫辉市');
INSERT INTO `chn_code` VALUES ('410782', '   辉县市');
INSERT INTO `chn_code` VALUES ('410783', '   长垣市');
INSERT INTO `chn_code` VALUES ('410800', ' 焦作市');
INSERT INTO `chn_code` VALUES ('410802', '   解放区');
INSERT INTO `chn_code` VALUES ('410803', '   中站区');
INSERT INTO `chn_code` VALUES ('410804', '   马村区');
INSERT INTO `chn_code` VALUES ('410811', '   山阳区');
INSERT INTO `chn_code` VALUES ('410821', '   修武县');
INSERT INTO `chn_code` VALUES ('410822', '   博爱县');
INSERT INTO `chn_code` VALUES ('410823', '   武陟县');
INSERT INTO `chn_code` VALUES ('410825', '   温县');
INSERT INTO `chn_code` VALUES ('410882', '   沁阳市');
INSERT INTO `chn_code` VALUES ('410883', '   孟州市');
INSERT INTO `chn_code` VALUES ('410900', ' 濮阳市');
INSERT INTO `chn_code` VALUES ('410902', '   华龙区');
INSERT INTO `chn_code` VALUES ('410922', '   清丰县');
INSERT INTO `chn_code` VALUES ('410923', '   南乐县');
INSERT INTO `chn_code` VALUES ('410926', '   范县');
INSERT INTO `chn_code` VALUES ('410927', '   台前县');
INSERT INTO `chn_code` VALUES ('410928', '   濮阳县');
INSERT INTO `chn_code` VALUES ('411000', ' 许昌市');
INSERT INTO `chn_code` VALUES ('411002', '   魏都区');
INSERT INTO `chn_code` VALUES ('411003', '   建安区');
INSERT INTO `chn_code` VALUES ('411024', '   鄢陵县');
INSERT INTO `chn_code` VALUES ('411025', '   襄城县');
INSERT INTO `chn_code` VALUES ('411081', '   禹州市');
INSERT INTO `chn_code` VALUES ('411082', '   长葛市');
INSERT INTO `chn_code` VALUES ('411100', ' 漯河市');
INSERT INTO `chn_code` VALUES ('411102', '   源汇区');
INSERT INTO `chn_code` VALUES ('411103', '   郾城区');
INSERT INTO `chn_code` VALUES ('411104', '   召陵区');
INSERT INTO `chn_code` VALUES ('411121', '   舞阳县');
INSERT INTO `chn_code` VALUES ('411122', '   临颍县');
INSERT INTO `chn_code` VALUES ('411200', ' 三门峡市');
INSERT INTO `chn_code` VALUES ('411202', '   湖滨区');
INSERT INTO `chn_code` VALUES ('411203', '   陕州区');
INSERT INTO `chn_code` VALUES ('411221', '   渑池县');
INSERT INTO `chn_code` VALUES ('411224', '   卢氏县');
INSERT INTO `chn_code` VALUES ('411281', '   义马市');
INSERT INTO `chn_code` VALUES ('411282', '   灵宝市');
INSERT INTO `chn_code` VALUES ('411300', ' 南阳市');
INSERT INTO `chn_code` VALUES ('411302', '   宛城区');
INSERT INTO `chn_code` VALUES ('411303', '   卧龙区');
INSERT INTO `chn_code` VALUES ('411321', '   南召县');
INSERT INTO `chn_code` VALUES ('411322', '   方城县');
INSERT INTO `chn_code` VALUES ('411323', '   西峡县');
INSERT INTO `chn_code` VALUES ('411324', '   镇平县');
INSERT INTO `chn_code` VALUES ('411325', '   内乡县');
INSERT INTO `chn_code` VALUES ('411326', '   淅川县');
INSERT INTO `chn_code` VALUES ('411327', '   社旗县');
INSERT INTO `chn_code` VALUES ('411328', '   唐河县');
INSERT INTO `chn_code` VALUES ('411329', '   新野县');
INSERT INTO `chn_code` VALUES ('411330', '   桐柏县');
INSERT INTO `chn_code` VALUES ('411381', '   邓州市');
INSERT INTO `chn_code` VALUES ('411400', ' 商丘市');
INSERT INTO `chn_code` VALUES ('411402', '   梁园区');
INSERT INTO `chn_code` VALUES ('411403', '   睢阳区');
INSERT INTO `chn_code` VALUES ('411421', '   民权县');
INSERT INTO `chn_code` VALUES ('411422', '   睢县');
INSERT INTO `chn_code` VALUES ('411423', '   宁陵县');
INSERT INTO `chn_code` VALUES ('411424', '   柘城县');
INSERT INTO `chn_code` VALUES ('411425', '   虞城县');
INSERT INTO `chn_code` VALUES ('411426', '   夏邑县');
INSERT INTO `chn_code` VALUES ('411481', '   永城市');
INSERT INTO `chn_code` VALUES ('411500', ' 信阳市');
INSERT INTO `chn_code` VALUES ('411502', '   浉河区');
INSERT INTO `chn_code` VALUES ('411503', '   平桥区');
INSERT INTO `chn_code` VALUES ('411521', '   罗山县');
INSERT INTO `chn_code` VALUES ('411522', '   光山县');
INSERT INTO `chn_code` VALUES ('411523', '   新县');
INSERT INTO `chn_code` VALUES ('411524', '   商城县');
INSERT INTO `chn_code` VALUES ('411525', '   固始县');
INSERT INTO `chn_code` VALUES ('411526', '   潢川县');
INSERT INTO `chn_code` VALUES ('411527', '   淮滨县');
INSERT INTO `chn_code` VALUES ('411528', '   息县');
INSERT INTO `chn_code` VALUES ('411600', ' 周口市');
INSERT INTO `chn_code` VALUES ('411602', '   川汇区');
INSERT INTO `chn_code` VALUES ('411603', '   淮阳区');
INSERT INTO `chn_code` VALUES ('411621', '   扶沟县');
INSERT INTO `chn_code` VALUES ('411622', '   西华县');
INSERT INTO `chn_code` VALUES ('411623', '   商水县');
INSERT INTO `chn_code` VALUES ('411624', '   沈丘县');
INSERT INTO `chn_code` VALUES ('411625', '   郸城县');
INSERT INTO `chn_code` VALUES ('411627', '   太康县');
INSERT INTO `chn_code` VALUES ('411628', '   鹿邑县');
INSERT INTO `chn_code` VALUES ('411681', '   项城市');
INSERT INTO `chn_code` VALUES ('411700', ' 驻马店市');
INSERT INTO `chn_code` VALUES ('411702', '   驿城区');
INSERT INTO `chn_code` VALUES ('411721', '   西平县');
INSERT INTO `chn_code` VALUES ('411722', '   上蔡县');
INSERT INTO `chn_code` VALUES ('411723', '   平舆县');
INSERT INTO `chn_code` VALUES ('411724', '   正阳县');
INSERT INTO `chn_code` VALUES ('411725', '   确山县');
INSERT INTO `chn_code` VALUES ('411726', '   泌阳县');
INSERT INTO `chn_code` VALUES ('411727', '   汝南县');
INSERT INTO `chn_code` VALUES ('411728', '   遂平县');
INSERT INTO `chn_code` VALUES ('411729', '   新蔡县');
INSERT INTO `chn_code` VALUES ('419001', '   济源市');
INSERT INTO `chn_code` VALUES ('420000', '湖北省');
INSERT INTO `chn_code` VALUES ('420100', ' 武汉市');
INSERT INTO `chn_code` VALUES ('420102', '   江岸区');
INSERT INTO `chn_code` VALUES ('420103', '   江汉区');
INSERT INTO `chn_code` VALUES ('420104', '   硚口区');
INSERT INTO `chn_code` VALUES ('420105', '   汉阳区');
INSERT INTO `chn_code` VALUES ('420106', '   武昌区');
INSERT INTO `chn_code` VALUES ('420107', '   青山区');
INSERT INTO `chn_code` VALUES ('420111', '   洪山区');
INSERT INTO `chn_code` VALUES ('420112', '   东西湖区');
INSERT INTO `chn_code` VALUES ('420113', '   汉南区');
INSERT INTO `chn_code` VALUES ('420114', '   蔡甸区');
INSERT INTO `chn_code` VALUES ('420115', '   江夏区');
INSERT INTO `chn_code` VALUES ('420116', '   黄陂区');
INSERT INTO `chn_code` VALUES ('420117', '   新洲区');
INSERT INTO `chn_code` VALUES ('420200', ' 黄石市');
INSERT INTO `chn_code` VALUES ('420202', '   黄石港区');
INSERT INTO `chn_code` VALUES ('420203', '   西塞山区');
INSERT INTO `chn_code` VALUES ('420204', '   下陆区');
INSERT INTO `chn_code` VALUES ('420205', '   铁山区');
INSERT INTO `chn_code` VALUES ('420222', '   阳新县');
INSERT INTO `chn_code` VALUES ('420281', '   大冶市');
INSERT INTO `chn_code` VALUES ('420300', ' 十堰市');
INSERT INTO `chn_code` VALUES ('420302', '   茅箭区');
INSERT INTO `chn_code` VALUES ('420303', '   张湾区');
INSERT INTO `chn_code` VALUES ('420304', '   郧阳区');
INSERT INTO `chn_code` VALUES ('420322', '   郧西县');
INSERT INTO `chn_code` VALUES ('420323', '   竹山县');
INSERT INTO `chn_code` VALUES ('420324', '   竹溪县');
INSERT INTO `chn_code` VALUES ('420325', '   房县');
INSERT INTO `chn_code` VALUES ('420381', '   丹江口市');
INSERT INTO `chn_code` VALUES ('420500', ' 宜昌市');
INSERT INTO `chn_code` VALUES ('420502', '   西陵区');
INSERT INTO `chn_code` VALUES ('420503', '   伍家岗区');
INSERT INTO `chn_code` VALUES ('420504', '   点军区');
INSERT INTO `chn_code` VALUES ('420505', '   猇亭区');
INSERT INTO `chn_code` VALUES ('420506', '   夷陵区');
INSERT INTO `chn_code` VALUES ('420525', '   远安县');
INSERT INTO `chn_code` VALUES ('420526', '   兴山县');
INSERT INTO `chn_code` VALUES ('420527', '   秭归县');
INSERT INTO `chn_code` VALUES ('420528', '   长阳土家族自治县');
INSERT INTO `chn_code` VALUES ('420529', '   五峰土家族自治县');
INSERT INTO `chn_code` VALUES ('420581', '   宜都市');
INSERT INTO `chn_code` VALUES ('420582', '   当阳市');
INSERT INTO `chn_code` VALUES ('420583', '   枝江市');
INSERT INTO `chn_code` VALUES ('420600', ' 襄阳市');
INSERT INTO `chn_code` VALUES ('420602', '   襄城区');
INSERT INTO `chn_code` VALUES ('420606', '   樊城区');
INSERT INTO `chn_code` VALUES ('420607', '   襄州区');
INSERT INTO `chn_code` VALUES ('420624', '   南漳县');
INSERT INTO `chn_code` VALUES ('420625', '   谷城县');
INSERT INTO `chn_code` VALUES ('420626', '   保康县');
INSERT INTO `chn_code` VALUES ('420682', '   老河口市');
INSERT INTO `chn_code` VALUES ('420683', '   枣阳市');
INSERT INTO `chn_code` VALUES ('420684', '   宜城市');
INSERT INTO `chn_code` VALUES ('420700', ' 鄂州市');
INSERT INTO `chn_code` VALUES ('420702', '   梁子湖区');
INSERT INTO `chn_code` VALUES ('420703', '   华容区');
INSERT INTO `chn_code` VALUES ('420704', '   鄂城区');
INSERT INTO `chn_code` VALUES ('420800', ' 荆门市');
INSERT INTO `chn_code` VALUES ('420802', '   东宝区');
INSERT INTO `chn_code` VALUES ('420804', '   掇刀区');
INSERT INTO `chn_code` VALUES ('420822', '   沙洋县');
INSERT INTO `chn_code` VALUES ('420881', '   钟祥市');
INSERT INTO `chn_code` VALUES ('420882', '   京山市');
INSERT INTO `chn_code` VALUES ('420900', ' 孝感市');
INSERT INTO `chn_code` VALUES ('420902', '   孝南区');
INSERT INTO `chn_code` VALUES ('420921', '   孝昌县');
INSERT INTO `chn_code` VALUES ('420922', '   大悟县');
INSERT INTO `chn_code` VALUES ('420923', '   云梦县');
INSERT INTO `chn_code` VALUES ('420981', '   应城市');
INSERT INTO `chn_code` VALUES ('420982', '   安陆市');
INSERT INTO `chn_code` VALUES ('420984', '   汉川市');
INSERT INTO `chn_code` VALUES ('421000', ' 荆州市');
INSERT INTO `chn_code` VALUES ('421002', '   沙市区');
INSERT INTO `chn_code` VALUES ('421003', '   荆州区');
INSERT INTO `chn_code` VALUES ('421022', '   公安县');
INSERT INTO `chn_code` VALUES ('421024', '   江陵县');
INSERT INTO `chn_code` VALUES ('421081', '   石首市');
INSERT INTO `chn_code` VALUES ('421083', '   洪湖市');
INSERT INTO `chn_code` VALUES ('421087', '   松滋市');
INSERT INTO `chn_code` VALUES ('421088', '   监利市');
INSERT INTO `chn_code` VALUES ('421100', ' 黄冈市');
INSERT INTO `chn_code` VALUES ('421102', '   黄州区');
INSERT INTO `chn_code` VALUES ('421121', '   团风县');
INSERT INTO `chn_code` VALUES ('421122', '   红安县');
INSERT INTO `chn_code` VALUES ('421123', '   罗田县');
INSERT INTO `chn_code` VALUES ('421124', '   英山县');
INSERT INTO `chn_code` VALUES ('421125', '   浠水县');
INSERT INTO `chn_code` VALUES ('421126', '   蕲春县');
INSERT INTO `chn_code` VALUES ('421127', '   黄梅县');
INSERT INTO `chn_code` VALUES ('421181', '   麻城市');
INSERT INTO `chn_code` VALUES ('421182', '   武穴市');
INSERT INTO `chn_code` VALUES ('421200', ' 咸宁市');
INSERT INTO `chn_code` VALUES ('421202', '   咸安区');
INSERT INTO `chn_code` VALUES ('421221', '   嘉鱼县');
INSERT INTO `chn_code` VALUES ('421222', '   通城县');
INSERT INTO `chn_code` VALUES ('421223', '   崇阳县');
INSERT INTO `chn_code` VALUES ('421224', '   通山县');
INSERT INTO `chn_code` VALUES ('421281', '   赤壁市');
INSERT INTO `chn_code` VALUES ('421300', ' 随州市');
INSERT INTO `chn_code` VALUES ('421303', '   曾都区');
INSERT INTO `chn_code` VALUES ('421321', '   随县');
INSERT INTO `chn_code` VALUES ('421381', '   广水市');
INSERT INTO `chn_code` VALUES ('422800', ' 恩施土家族苗族自治州');
INSERT INTO `chn_code` VALUES ('422801', '   恩施市');
INSERT INTO `chn_code` VALUES ('422802', '   利川市');
INSERT INTO `chn_code` VALUES ('422822', '   建始县');
INSERT INTO `chn_code` VALUES ('422823', '   巴东县');
INSERT INTO `chn_code` VALUES ('422825', '   宣恩县');
INSERT INTO `chn_code` VALUES ('422826', '   咸丰县');
INSERT INTO `chn_code` VALUES ('422827', '   来凤县');
INSERT INTO `chn_code` VALUES ('422828', '   鹤峰县');
INSERT INTO `chn_code` VALUES ('429004', '   仙桃市');
INSERT INTO `chn_code` VALUES ('429005', '   潜江市');
INSERT INTO `chn_code` VALUES ('429006', '   天门市');
INSERT INTO `chn_code` VALUES ('429021', '   神农架林区');
INSERT INTO `chn_code` VALUES ('430000', '湖南省');
INSERT INTO `chn_code` VALUES ('430100', ' 长沙市');
INSERT INTO `chn_code` VALUES ('430102', '   芙蓉区');
INSERT INTO `chn_code` VALUES ('430103', '   天心区');
INSERT INTO `chn_code` VALUES ('430104', '   岳麓区');
INSERT INTO `chn_code` VALUES ('430105', '   开福区');
INSERT INTO `chn_code` VALUES ('430111', '   雨花区');
INSERT INTO `chn_code` VALUES ('430112', '   望城区');
INSERT INTO `chn_code` VALUES ('430121', '   长沙县');
INSERT INTO `chn_code` VALUES ('430181', '   浏阳市');
INSERT INTO `chn_code` VALUES ('430182', '   宁乡市');
INSERT INTO `chn_code` VALUES ('430200', ' 株洲市');
INSERT INTO `chn_code` VALUES ('430202', '   荷塘区');
INSERT INTO `chn_code` VALUES ('430203', '   芦淞区');
INSERT INTO `chn_code` VALUES ('430204', '   石峰区');
INSERT INTO `chn_code` VALUES ('430211', '   天元区');
INSERT INTO `chn_code` VALUES ('430212', '   渌口区');
INSERT INTO `chn_code` VALUES ('430223', '   攸县');
INSERT INTO `chn_code` VALUES ('430224', '   茶陵县');
INSERT INTO `chn_code` VALUES ('430225', '   炎陵县');
INSERT INTO `chn_code` VALUES ('430281', '   醴陵市');
INSERT INTO `chn_code` VALUES ('430300', ' 湘潭市');
INSERT INTO `chn_code` VALUES ('430302', '   雨湖区');
INSERT INTO `chn_code` VALUES ('430304', '   岳塘区');
INSERT INTO `chn_code` VALUES ('430321', '   湘潭县');
INSERT INTO `chn_code` VALUES ('430381', '   湘乡市');
INSERT INTO `chn_code` VALUES ('430382', '   韶山市');
INSERT INTO `chn_code` VALUES ('430400', ' 衡阳市');
INSERT INTO `chn_code` VALUES ('430405', '   珠晖区');
INSERT INTO `chn_code` VALUES ('430406', '   雁峰区');
INSERT INTO `chn_code` VALUES ('430407', '   石鼓区');
INSERT INTO `chn_code` VALUES ('430408', '   蒸湘区');
INSERT INTO `chn_code` VALUES ('430412', '   南岳区');
INSERT INTO `chn_code` VALUES ('430421', '   衡阳县');
INSERT INTO `chn_code` VALUES ('430422', '   衡南县');
INSERT INTO `chn_code` VALUES ('430423', '   衡山县');
INSERT INTO `chn_code` VALUES ('430424', '   衡东县');
INSERT INTO `chn_code` VALUES ('430426', '   祁东县');
INSERT INTO `chn_code` VALUES ('430481', '   耒阳市');
INSERT INTO `chn_code` VALUES ('430482', '   常宁市');
INSERT INTO `chn_code` VALUES ('430500', ' 邵阳市');
INSERT INTO `chn_code` VALUES ('430502', '   双清区');
INSERT INTO `chn_code` VALUES ('430503', '   大祥区');
INSERT INTO `chn_code` VALUES ('430511', '   北塔区');
INSERT INTO `chn_code` VALUES ('430522', '   新邵县');
INSERT INTO `chn_code` VALUES ('430523', '   邵阳县');
INSERT INTO `chn_code` VALUES ('430524', '   隆回县');
INSERT INTO `chn_code` VALUES ('430525', '   洞口县');
INSERT INTO `chn_code` VALUES ('430527', '   绥宁县');
INSERT INTO `chn_code` VALUES ('430528', '   新宁县');
INSERT INTO `chn_code` VALUES ('430529', '   城步苗族自治县');
INSERT INTO `chn_code` VALUES ('430581', '   武冈市');
INSERT INTO `chn_code` VALUES ('430582', '   邵东市');
INSERT INTO `chn_code` VALUES ('430600', ' 岳阳市');
INSERT INTO `chn_code` VALUES ('430602', '   岳阳楼区');
INSERT INTO `chn_code` VALUES ('430603', '   云溪区');
INSERT INTO `chn_code` VALUES ('430611', '   君山区');
INSERT INTO `chn_code` VALUES ('430621', '   岳阳县');
INSERT INTO `chn_code` VALUES ('430623', '   华容县');
INSERT INTO `chn_code` VALUES ('430624', '   湘阴县');
INSERT INTO `chn_code` VALUES ('430626', '   平江县');
INSERT INTO `chn_code` VALUES ('430681', '   汨罗市');
INSERT INTO `chn_code` VALUES ('430682', '   临湘市');
INSERT INTO `chn_code` VALUES ('430700', ' 常德市');
INSERT INTO `chn_code` VALUES ('430702', '   武陵区');
INSERT INTO `chn_code` VALUES ('430703', '   鼎城区');
INSERT INTO `chn_code` VALUES ('430721', '   安乡县');
INSERT INTO `chn_code` VALUES ('430722', '   汉寿县');
INSERT INTO `chn_code` VALUES ('430723', '   澧县');
INSERT INTO `chn_code` VALUES ('430724', '   临澧县');
INSERT INTO `chn_code` VALUES ('430725', '   桃源县');
INSERT INTO `chn_code` VALUES ('430726', '   石门县');
INSERT INTO `chn_code` VALUES ('430781', '   津市市');
INSERT INTO `chn_code` VALUES ('430800', ' 张家界市');
INSERT INTO `chn_code` VALUES ('430802', '   永定区');
INSERT INTO `chn_code` VALUES ('430811', '   武陵源区');
INSERT INTO `chn_code` VALUES ('430821', '   慈利县');
INSERT INTO `chn_code` VALUES ('430822', '   桑植县');
INSERT INTO `chn_code` VALUES ('430900', ' 益阳市');
INSERT INTO `chn_code` VALUES ('430902', '   资阳区');
INSERT INTO `chn_code` VALUES ('430903', '   赫山区');
INSERT INTO `chn_code` VALUES ('430921', '   南县');
INSERT INTO `chn_code` VALUES ('430922', '   桃江县');
INSERT INTO `chn_code` VALUES ('430923', '   安化县');
INSERT INTO `chn_code` VALUES ('430981', '   沅江市');
INSERT INTO `chn_code` VALUES ('431000', ' 郴州市');
INSERT INTO `chn_code` VALUES ('431002', '   北湖区');
INSERT INTO `chn_code` VALUES ('431003', '   苏仙区');
INSERT INTO `chn_code` VALUES ('431021', '   桂阳县');
INSERT INTO `chn_code` VALUES ('431022', '   宜章县');
INSERT INTO `chn_code` VALUES ('431023', '   永兴县');
INSERT INTO `chn_code` VALUES ('431024', '   嘉禾县');
INSERT INTO `chn_code` VALUES ('431025', '   临武县');
INSERT INTO `chn_code` VALUES ('431026', '   汝城县');
INSERT INTO `chn_code` VALUES ('431027', '   桂东县');
INSERT INTO `chn_code` VALUES ('431028', '   安仁县');
INSERT INTO `chn_code` VALUES ('431081', '   资兴市');
INSERT INTO `chn_code` VALUES ('431100', ' 永州市');
INSERT INTO `chn_code` VALUES ('431102', '   零陵区');
INSERT INTO `chn_code` VALUES ('431103', '   冷水滩区');
INSERT INTO `chn_code` VALUES ('431121', '   祁阳县');
INSERT INTO `chn_code` VALUES ('431122', '   东安县');
INSERT INTO `chn_code` VALUES ('431123', '   双牌县');
INSERT INTO `chn_code` VALUES ('431124', '   道县');
INSERT INTO `chn_code` VALUES ('431125', '   江永县');
INSERT INTO `chn_code` VALUES ('431126', '   宁远县');
INSERT INTO `chn_code` VALUES ('431127', '   蓝山县');
INSERT INTO `chn_code` VALUES ('431128', '   新田县');
INSERT INTO `chn_code` VALUES ('431129', '   江华瑶族自治县');
INSERT INTO `chn_code` VALUES ('431200', ' 怀化市');
INSERT INTO `chn_code` VALUES ('431202', '   鹤城区');
INSERT INTO `chn_code` VALUES ('431221', '   中方县');
INSERT INTO `chn_code` VALUES ('431222', '   沅陵县');
INSERT INTO `chn_code` VALUES ('431223', '   辰溪县');
INSERT INTO `chn_code` VALUES ('431224', '   溆浦县');
INSERT INTO `chn_code` VALUES ('431225', '   会同县');
INSERT INTO `chn_code` VALUES ('431226', '   麻阳苗族自治县');
INSERT INTO `chn_code` VALUES ('431227', '   新晃侗族自治县');
INSERT INTO `chn_code` VALUES ('431228', '   芷江侗族自治县');
INSERT INTO `chn_code` VALUES ('431229', '   靖州苗族侗族自治县');
INSERT INTO `chn_code` VALUES ('431230', '   通道侗族自治县');
INSERT INTO `chn_code` VALUES ('431281', '   洪江市');
INSERT INTO `chn_code` VALUES ('431300', ' 娄底市');
INSERT INTO `chn_code` VALUES ('431302', '   娄星区');
INSERT INTO `chn_code` VALUES ('431321', '   双峰县');
INSERT INTO `chn_code` VALUES ('431322', '   新化县');
INSERT INTO `chn_code` VALUES ('431381', '   冷水江市');
INSERT INTO `chn_code` VALUES ('431382', '   涟源市');
INSERT INTO `chn_code` VALUES ('433100', ' 湘西土家族苗族自治州');
INSERT INTO `chn_code` VALUES ('433101', '   吉首市');
INSERT INTO `chn_code` VALUES ('433122', '   泸溪县');
INSERT INTO `chn_code` VALUES ('433123', '   凤凰县');
INSERT INTO `chn_code` VALUES ('433124', '   花垣县');
INSERT INTO `chn_code` VALUES ('433125', '   保靖县');
INSERT INTO `chn_code` VALUES ('433126', '   古丈县');
INSERT INTO `chn_code` VALUES ('433127', '   永顺县');
INSERT INTO `chn_code` VALUES ('433130', '   龙山县');
INSERT INTO `chn_code` VALUES ('440000', '广东省');
INSERT INTO `chn_code` VALUES ('440100', ' 广州市');
INSERT INTO `chn_code` VALUES ('440103', '   荔湾区');
INSERT INTO `chn_code` VALUES ('440104', '   越秀区');
INSERT INTO `chn_code` VALUES ('440105', '   海珠区');
INSERT INTO `chn_code` VALUES ('440106', '   天河区');
INSERT INTO `chn_code` VALUES ('440111', '   白云区');
INSERT INTO `chn_code` VALUES ('440112', '   黄埔区');
INSERT INTO `chn_code` VALUES ('440113', '   番禺区');
INSERT INTO `chn_code` VALUES ('440114', '   花都区');
INSERT INTO `chn_code` VALUES ('440115', '   南沙区');
INSERT INTO `chn_code` VALUES ('440117', '   从化区');
INSERT INTO `chn_code` VALUES ('440118', '   增城区');
INSERT INTO `chn_code` VALUES ('440200', ' 韶关市');
INSERT INTO `chn_code` VALUES ('440203', '   武江区');
INSERT INTO `chn_code` VALUES ('440204', '   浈江区');
INSERT INTO `chn_code` VALUES ('440205', '   曲江区');
INSERT INTO `chn_code` VALUES ('440222', '   始兴县');
INSERT INTO `chn_code` VALUES ('440224', '   仁化县');
INSERT INTO `chn_code` VALUES ('440229', '   翁源县');
INSERT INTO `chn_code` VALUES ('440232', '   乳源瑶族自治县');
INSERT INTO `chn_code` VALUES ('440233', '   新丰县');
INSERT INTO `chn_code` VALUES ('440281', '   乐昌市');
INSERT INTO `chn_code` VALUES ('440282', '   南雄市');
INSERT INTO `chn_code` VALUES ('440300', ' 深圳市');
INSERT INTO `chn_code` VALUES ('440303', '   罗湖区');
INSERT INTO `chn_code` VALUES ('440304', '   福田区');
INSERT INTO `chn_code` VALUES ('440305', '   南山区');
INSERT INTO `chn_code` VALUES ('440306', '   宝安区');
INSERT INTO `chn_code` VALUES ('440307', '   龙岗区');
INSERT INTO `chn_code` VALUES ('440308', '   盐田区');
INSERT INTO `chn_code` VALUES ('440309', '   龙华区');
INSERT INTO `chn_code` VALUES ('440310', '   坪山区');
INSERT INTO `chn_code` VALUES ('440311', '   光明区');
INSERT INTO `chn_code` VALUES ('440400', ' 珠海市');
INSERT INTO `chn_code` VALUES ('440402', '   香洲区');
INSERT INTO `chn_code` VALUES ('440403', '   斗门区');
INSERT INTO `chn_code` VALUES ('440404', '   金湾区');
INSERT INTO `chn_code` VALUES ('440500', ' 汕头市');
INSERT INTO `chn_code` VALUES ('440507', '   龙湖区');
INSERT INTO `chn_code` VALUES ('440511', '   金平区');
INSERT INTO `chn_code` VALUES ('440512', '   濠江区');
INSERT INTO `chn_code` VALUES ('440513', '   潮阳区');
INSERT INTO `chn_code` VALUES ('440514', '   潮南区');
INSERT INTO `chn_code` VALUES ('440515', '   澄海区');
INSERT INTO `chn_code` VALUES ('440523', '   南澳县');
INSERT INTO `chn_code` VALUES ('440600', ' 佛山市');
INSERT INTO `chn_code` VALUES ('440604', '   禅城区');
INSERT INTO `chn_code` VALUES ('440605', '   南海区');
INSERT INTO `chn_code` VALUES ('440606', '   顺德区');
INSERT INTO `chn_code` VALUES ('440607', '   三水区');
INSERT INTO `chn_code` VALUES ('440608', '   高明区');
INSERT INTO `chn_code` VALUES ('440700', ' 江门市');
INSERT INTO `chn_code` VALUES ('440703', '   蓬江区');
INSERT INTO `chn_code` VALUES ('440704', '   江海区');
INSERT INTO `chn_code` VALUES ('440705', '   新会区');
INSERT INTO `chn_code` VALUES ('440781', '   台山市');
INSERT INTO `chn_code` VALUES ('440783', '   开平市');
INSERT INTO `chn_code` VALUES ('440784', '   鹤山市');
INSERT INTO `chn_code` VALUES ('440785', '   恩平市');
INSERT INTO `chn_code` VALUES ('440800', ' 湛江市');
INSERT INTO `chn_code` VALUES ('440802', '   赤坎区');
INSERT INTO `chn_code` VALUES ('440803', '   霞山区');
INSERT INTO `chn_code` VALUES ('440804', '   坡头区');
INSERT INTO `chn_code` VALUES ('440811', '   麻章区');
INSERT INTO `chn_code` VALUES ('440823', '   遂溪县');
INSERT INTO `chn_code` VALUES ('440825', '   徐闻县');
INSERT INTO `chn_code` VALUES ('440881', '   廉江市');
INSERT INTO `chn_code` VALUES ('440882', '   雷州市');
INSERT INTO `chn_code` VALUES ('440883', '   吴川市');
INSERT INTO `chn_code` VALUES ('440900', ' 茂名市');
INSERT INTO `chn_code` VALUES ('440902', '   茂南区');
INSERT INTO `chn_code` VALUES ('440904', '   电白区');
INSERT INTO `chn_code` VALUES ('440981', '   高州市');
INSERT INTO `chn_code` VALUES ('440982', '   化州市');
INSERT INTO `chn_code` VALUES ('440983', '   信宜市');
INSERT INTO `chn_code` VALUES ('441200', ' 肇庆市');
INSERT INTO `chn_code` VALUES ('441202', '   端州区');
INSERT INTO `chn_code` VALUES ('441203', '   鼎湖区');
INSERT INTO `chn_code` VALUES ('441204', '   高要区');
INSERT INTO `chn_code` VALUES ('441223', '   广宁县');
INSERT INTO `chn_code` VALUES ('441224', '   怀集县');
INSERT INTO `chn_code` VALUES ('441225', '   封开县');
INSERT INTO `chn_code` VALUES ('441226', '   德庆县');
INSERT INTO `chn_code` VALUES ('441284', '   四会市');
INSERT INTO `chn_code` VALUES ('441300', ' 惠州市');
INSERT INTO `chn_code` VALUES ('441302', '   惠城区');
INSERT INTO `chn_code` VALUES ('441303', '   惠阳区');
INSERT INTO `chn_code` VALUES ('441322', '   博罗县');
INSERT INTO `chn_code` VALUES ('441323', '   惠东县');
INSERT INTO `chn_code` VALUES ('441324', '   龙门县');
INSERT INTO `chn_code` VALUES ('441400', ' 梅州市');
INSERT INTO `chn_code` VALUES ('441402', '   梅江区');
INSERT INTO `chn_code` VALUES ('441403', '   梅县区');
INSERT INTO `chn_code` VALUES ('441422', '   大埔县');
INSERT INTO `chn_code` VALUES ('441423', '   丰顺县');
INSERT INTO `chn_code` VALUES ('441424', '   五华县');
INSERT INTO `chn_code` VALUES ('441426', '   平远县');
INSERT INTO `chn_code` VALUES ('441427', '   蕉岭县');
INSERT INTO `chn_code` VALUES ('441481', '   兴宁市');
INSERT INTO `chn_code` VALUES ('441500', ' 汕尾市');
INSERT INTO `chn_code` VALUES ('441502', '   城区');
INSERT INTO `chn_code` VALUES ('441521', '   海丰县');
INSERT INTO `chn_code` VALUES ('441523', '   陆河县');
INSERT INTO `chn_code` VALUES ('441581', '   陆丰市');
INSERT INTO `chn_code` VALUES ('441600', ' 河源市');
INSERT INTO `chn_code` VALUES ('441602', '   源城区');
INSERT INTO `chn_code` VALUES ('441621', '   紫金县');
INSERT INTO `chn_code` VALUES ('441622', '   龙川县');
INSERT INTO `chn_code` VALUES ('441623', '   连平县');
INSERT INTO `chn_code` VALUES ('441624', '   和平县');
INSERT INTO `chn_code` VALUES ('441625', '   东源县');
INSERT INTO `chn_code` VALUES ('441700', ' 阳江市');
INSERT INTO `chn_code` VALUES ('441702', '   江城区');
INSERT INTO `chn_code` VALUES ('441704', '   阳东区');
INSERT INTO `chn_code` VALUES ('441721', '   阳西县');
INSERT INTO `chn_code` VALUES ('441781', '   阳春市');
INSERT INTO `chn_code` VALUES ('441800', ' 清远市');
INSERT INTO `chn_code` VALUES ('441802', '   清城区');
INSERT INTO `chn_code` VALUES ('441803', '   清新区');
INSERT INTO `chn_code` VALUES ('441821', '   佛冈县');
INSERT INTO `chn_code` VALUES ('441823', '   阳山县');
INSERT INTO `chn_code` VALUES ('441825', '   连山壮族瑶族自治县');
INSERT INTO `chn_code` VALUES ('441826', '   连南瑶族自治县');
INSERT INTO `chn_code` VALUES ('441881', '   英德市');
INSERT INTO `chn_code` VALUES ('441882', '   连州市');
INSERT INTO `chn_code` VALUES ('441900', ' 东莞市');
INSERT INTO `chn_code` VALUES ('442000', ' 中山市');
INSERT INTO `chn_code` VALUES ('445100', ' 潮州市');
INSERT INTO `chn_code` VALUES ('445102', '   湘桥区');
INSERT INTO `chn_code` VALUES ('445103', '   潮安区');
INSERT INTO `chn_code` VALUES ('445122', '   饶平县');
INSERT INTO `chn_code` VALUES ('445200', ' 揭阳市');
INSERT INTO `chn_code` VALUES ('445202', '   榕城区');
INSERT INTO `chn_code` VALUES ('445203', '   揭东区');
INSERT INTO `chn_code` VALUES ('445222', '   揭西县');
INSERT INTO `chn_code` VALUES ('445224', '   惠来县');
INSERT INTO `chn_code` VALUES ('445281', '   普宁市');
INSERT INTO `chn_code` VALUES ('445300', ' 云浮市');
INSERT INTO `chn_code` VALUES ('445302', '   云城区');
INSERT INTO `chn_code` VALUES ('445303', '   云安区');
INSERT INTO `chn_code` VALUES ('445321', '   新兴县');
INSERT INTO `chn_code` VALUES ('445322', '   郁南县');
INSERT INTO `chn_code` VALUES ('445381', '   罗定市');
INSERT INTO `chn_code` VALUES ('450000', '广西壮族自治区');
INSERT INTO `chn_code` VALUES ('450100', ' 南宁市');
INSERT INTO `chn_code` VALUES ('450102', '   兴宁区');
INSERT INTO `chn_code` VALUES ('450103', '   青秀区');
INSERT INTO `chn_code` VALUES ('450105', '   江南区');
INSERT INTO `chn_code` VALUES ('450107', '   西乡塘区');
INSERT INTO `chn_code` VALUES ('450108', '   良庆区');
INSERT INTO `chn_code` VALUES ('450109', '   邕宁区');
INSERT INTO `chn_code` VALUES ('450110', '   武鸣区');
INSERT INTO `chn_code` VALUES ('450123', '   隆安县');
INSERT INTO `chn_code` VALUES ('450124', '   马山县');
INSERT INTO `chn_code` VALUES ('450125', '   上林县');
INSERT INTO `chn_code` VALUES ('450126', '   宾阳县');
INSERT INTO `chn_code` VALUES ('450127', '   横县');
INSERT INTO `chn_code` VALUES ('450200', ' 柳州市');
INSERT INTO `chn_code` VALUES ('450202', '   城中区');
INSERT INTO `chn_code` VALUES ('450203', '   鱼峰区');
INSERT INTO `chn_code` VALUES ('450204', '   柳南区');
INSERT INTO `chn_code` VALUES ('450205', '   柳北区');
INSERT INTO `chn_code` VALUES ('450206', '   柳江区');
INSERT INTO `chn_code` VALUES ('450222', '   柳城县');
INSERT INTO `chn_code` VALUES ('450223', '   鹿寨县');
INSERT INTO `chn_code` VALUES ('450224', '   融安县');
INSERT INTO `chn_code` VALUES ('450225', '   融水苗族自治县');
INSERT INTO `chn_code` VALUES ('450226', '   三江侗族自治县');
INSERT INTO `chn_code` VALUES ('450300', ' 桂林市');
INSERT INTO `chn_code` VALUES ('450302', '   秀峰区');
INSERT INTO `chn_code` VALUES ('450303', '   叠彩区');
INSERT INTO `chn_code` VALUES ('450304', '   象山区');
INSERT INTO `chn_code` VALUES ('450305', '   七星区');
INSERT INTO `chn_code` VALUES ('450311', '   雁山区');
INSERT INTO `chn_code` VALUES ('450312', '   临桂区');
INSERT INTO `chn_code` VALUES ('450321', '   阳朔县');
INSERT INTO `chn_code` VALUES ('450323', '   灵川县');
INSERT INTO `chn_code` VALUES ('450324', '   全州县');
INSERT INTO `chn_code` VALUES ('450325', '   兴安县');
INSERT INTO `chn_code` VALUES ('450326', '   永福县');
INSERT INTO `chn_code` VALUES ('450327', '   灌阳县');
INSERT INTO `chn_code` VALUES ('450328', '   龙胜各族自治县');
INSERT INTO `chn_code` VALUES ('450329', '   资源县');
INSERT INTO `chn_code` VALUES ('450330', '   平乐县');
INSERT INTO `chn_code` VALUES ('450332', '   恭城瑶族自治县');
INSERT INTO `chn_code` VALUES ('450381', '   荔浦市');
INSERT INTO `chn_code` VALUES ('450400', ' 梧州市');
INSERT INTO `chn_code` VALUES ('450403', '   万秀区');
INSERT INTO `chn_code` VALUES ('450405', '   长洲区');
INSERT INTO `chn_code` VALUES ('450406', '   龙圩区');
INSERT INTO `chn_code` VALUES ('450421', '   苍梧县');
INSERT INTO `chn_code` VALUES ('450422', '   藤县');
INSERT INTO `chn_code` VALUES ('450423', '   蒙山县');
INSERT INTO `chn_code` VALUES ('450481', '   岑溪市');
INSERT INTO `chn_code` VALUES ('450500', ' 北海市');
INSERT INTO `chn_code` VALUES ('450502', '   海城区');
INSERT INTO `chn_code` VALUES ('450503', '   银海区');
INSERT INTO `chn_code` VALUES ('450512', '   铁山港区');
INSERT INTO `chn_code` VALUES ('450521', '   合浦县');
INSERT INTO `chn_code` VALUES ('450600', ' 防城港市');
INSERT INTO `chn_code` VALUES ('450602', '   港口区');
INSERT INTO `chn_code` VALUES ('450603', '   防城区');
INSERT INTO `chn_code` VALUES ('450621', '   上思县');
INSERT INTO `chn_code` VALUES ('450681', '   东兴市');
INSERT INTO `chn_code` VALUES ('450700', ' 钦州市');
INSERT INTO `chn_code` VALUES ('450702', '   钦南区');
INSERT INTO `chn_code` VALUES ('450703', '   钦北区');
INSERT INTO `chn_code` VALUES ('450721', '   灵山县');
INSERT INTO `chn_code` VALUES ('450722', '   浦北县');
INSERT INTO `chn_code` VALUES ('450800', ' 贵港市');
INSERT INTO `chn_code` VALUES ('450802', '   港北区');
INSERT INTO `chn_code` VALUES ('450803', '   港南区');
INSERT INTO `chn_code` VALUES ('450804', '   覃塘区');
INSERT INTO `chn_code` VALUES ('450821', '   平南县');
INSERT INTO `chn_code` VALUES ('450881', '   桂平市');
INSERT INTO `chn_code` VALUES ('450900', ' 玉林市');
INSERT INTO `chn_code` VALUES ('450902', '   玉州区');
INSERT INTO `chn_code` VALUES ('450903', '   福绵区');
INSERT INTO `chn_code` VALUES ('450921', '   容县');
INSERT INTO `chn_code` VALUES ('450922', '   陆川县');
INSERT INTO `chn_code` VALUES ('450923', '   博白县');
INSERT INTO `chn_code` VALUES ('450924', '   兴业县');
INSERT INTO `chn_code` VALUES ('450981', '   北流市');
INSERT INTO `chn_code` VALUES ('451000', ' 百色市');
INSERT INTO `chn_code` VALUES ('451002', '   右江区');
INSERT INTO `chn_code` VALUES ('451003', '   田阳区');
INSERT INTO `chn_code` VALUES ('451022', '   田东县');
INSERT INTO `chn_code` VALUES ('451024', '   德保县');
INSERT INTO `chn_code` VALUES ('451026', '   那坡县');
INSERT INTO `chn_code` VALUES ('451027', '   凌云县');
INSERT INTO `chn_code` VALUES ('451028', '   乐业县');
INSERT INTO `chn_code` VALUES ('451029', '   田林县');
INSERT INTO `chn_code` VALUES ('451030', '   西林县');
INSERT INTO `chn_code` VALUES ('451031', '   隆林各族自治县');
INSERT INTO `chn_code` VALUES ('451081', '   靖西市');
INSERT INTO `chn_code` VALUES ('451082', '   平果市');
INSERT INTO `chn_code` VALUES ('451100', ' 贺州市');
INSERT INTO `chn_code` VALUES ('451102', '   八步区');
INSERT INTO `chn_code` VALUES ('451103', '   平桂区');
INSERT INTO `chn_code` VALUES ('451121', '   昭平县');
INSERT INTO `chn_code` VALUES ('451122', '   钟山县');
INSERT INTO `chn_code` VALUES ('451123', '   富川瑶族自治县');
INSERT INTO `chn_code` VALUES ('451200', ' 河池市');
INSERT INTO `chn_code` VALUES ('451202', '   金城江区');
INSERT INTO `chn_code` VALUES ('451203', '   宜州区');
INSERT INTO `chn_code` VALUES ('451221', '   南丹县');
INSERT INTO `chn_code` VALUES ('451222', '   天峨县');
INSERT INTO `chn_code` VALUES ('451223', '   凤山县');
INSERT INTO `chn_code` VALUES ('451224', '   东兰县');
INSERT INTO `chn_code` VALUES ('451225', '   罗城仫佬族自治县');
INSERT INTO `chn_code` VALUES ('451226', '   环江毛南族自治县');
INSERT INTO `chn_code` VALUES ('451227', '   巴马瑶族自治县');
INSERT INTO `chn_code` VALUES ('451228', '   都安瑶族自治县');
INSERT INTO `chn_code` VALUES ('451229', '   大化瑶族自治县');
INSERT INTO `chn_code` VALUES ('451300', ' 来宾市');
INSERT INTO `chn_code` VALUES ('451302', '   兴宾区');
INSERT INTO `chn_code` VALUES ('451321', '   忻城县');
INSERT INTO `chn_code` VALUES ('451322', '   象州县');
INSERT INTO `chn_code` VALUES ('451323', '   武宣县');
INSERT INTO `chn_code` VALUES ('451324', '   金秀瑶族自治县');
INSERT INTO `chn_code` VALUES ('451381', '   合山市');
INSERT INTO `chn_code` VALUES ('451400', ' 崇左市');
INSERT INTO `chn_code` VALUES ('451402', '   江州区');
INSERT INTO `chn_code` VALUES ('451421', '   扶绥县');
INSERT INTO `chn_code` VALUES ('451422', '   宁明县');
INSERT INTO `chn_code` VALUES ('451423', '   龙州县');
INSERT INTO `chn_code` VALUES ('451424', '   大新县');
INSERT INTO `chn_code` VALUES ('451425', '   天等县');
INSERT INTO `chn_code` VALUES ('451481', '   凭祥市');
INSERT INTO `chn_code` VALUES ('460000', '海南省');
INSERT INTO `chn_code` VALUES ('460100', ' 海口市');
INSERT INTO `chn_code` VALUES ('460105', '   秀英区');
INSERT INTO `chn_code` VALUES ('460106', '   龙华区');
INSERT INTO `chn_code` VALUES ('460107', '   琼山区');
INSERT INTO `chn_code` VALUES ('460108', '   美兰区');
INSERT INTO `chn_code` VALUES ('460200', ' 三亚市');
INSERT INTO `chn_code` VALUES ('460202', '   海棠区');
INSERT INTO `chn_code` VALUES ('460203', '   吉阳区');
INSERT INTO `chn_code` VALUES ('460204', '   天涯区');
INSERT INTO `chn_code` VALUES ('460205', '   崖州区');
INSERT INTO `chn_code` VALUES ('460300', ' 三沙市');
INSERT INTO `chn_code` VALUES (NULL, '   西沙区');
INSERT INTO `chn_code` VALUES (NULL, '   南沙区');
INSERT INTO `chn_code` VALUES ('460400', ' 儋州市');
INSERT INTO `chn_code` VALUES ('469001', '   五指山市');
INSERT INTO `chn_code` VALUES ('469002', '   琼海市');
INSERT INTO `chn_code` VALUES ('469005', '   文昌市');
INSERT INTO `chn_code` VALUES ('469006', '   万宁市');
INSERT INTO `chn_code` VALUES ('469007', '   东方市');
INSERT INTO `chn_code` VALUES ('469021', '   定安县');
INSERT INTO `chn_code` VALUES ('469022', '   屯昌县');
INSERT INTO `chn_code` VALUES ('469023', '   澄迈县');
INSERT INTO `chn_code` VALUES ('469024', '   临高县');
INSERT INTO `chn_code` VALUES ('469025', '   白沙黎族自治县');
INSERT INTO `chn_code` VALUES ('469026', '   昌江黎族自治县');
INSERT INTO `chn_code` VALUES ('469027', '   乐东黎族自治县');
INSERT INTO `chn_code` VALUES ('469028', '   陵水黎族自治县');
INSERT INTO `chn_code` VALUES ('469029', '   保亭黎族苗族自治县');
INSERT INTO `chn_code` VALUES ('469030', '   琼中黎族苗族自治县');
INSERT INTO `chn_code` VALUES ('500000', '重庆市');
INSERT INTO `chn_code` VALUES ('500101', '   万州区');
INSERT INTO `chn_code` VALUES ('500102', '   涪陵区');
INSERT INTO `chn_code` VALUES ('500103', '   渝中区');
INSERT INTO `chn_code` VALUES ('500104', '   大渡口区');
INSERT INTO `chn_code` VALUES ('500105', '   江北区');
INSERT INTO `chn_code` VALUES ('500106', '   沙坪坝区');
INSERT INTO `chn_code` VALUES ('500107', '   九龙坡区');
INSERT INTO `chn_code` VALUES ('500108', '   南岸区');
INSERT INTO `chn_code` VALUES ('500109', '   北碚区');
INSERT INTO `chn_code` VALUES ('500110', '   綦江区');
INSERT INTO `chn_code` VALUES ('500111', '   大足区');
INSERT INTO `chn_code` VALUES ('500112', '   渝北区');
INSERT INTO `chn_code` VALUES ('500113', '   巴南区');
INSERT INTO `chn_code` VALUES ('500114', '   黔江区');
INSERT INTO `chn_code` VALUES ('500115', '   长寿区');
INSERT INTO `chn_code` VALUES ('500116', '   江津区');
INSERT INTO `chn_code` VALUES ('500117', '   合川区');
INSERT INTO `chn_code` VALUES ('500118', '   永川区');
INSERT INTO `chn_code` VALUES ('500119', '   南川区');
INSERT INTO `chn_code` VALUES ('500120', '   璧山区');
INSERT INTO `chn_code` VALUES ('500151', '   铜梁区');
INSERT INTO `chn_code` VALUES ('500152', '   潼南区');
INSERT INTO `chn_code` VALUES ('500153', '   荣昌区');
INSERT INTO `chn_code` VALUES ('500154', '   开州区');
INSERT INTO `chn_code` VALUES ('500155', '   梁平区');
INSERT INTO `chn_code` VALUES ('500156', '   武隆区');
INSERT INTO `chn_code` VALUES ('500229', '   城口县');
INSERT INTO `chn_code` VALUES ('500230', '   丰都县');
INSERT INTO `chn_code` VALUES ('500231', '   垫江县');
INSERT INTO `chn_code` VALUES ('500233', '   忠县');
INSERT INTO `chn_code` VALUES ('500235', '   云阳县');
INSERT INTO `chn_code` VALUES ('500236', '   奉节县');
INSERT INTO `chn_code` VALUES ('500237', '   巫山县');
INSERT INTO `chn_code` VALUES ('500238', '   巫溪县');
INSERT INTO `chn_code` VALUES ('500240', '   石柱土家族自治县');
INSERT INTO `chn_code` VALUES ('500241', '   秀山土家族苗族自治县');
INSERT INTO `chn_code` VALUES ('500242', '   酉阳土家族苗族自治县');
INSERT INTO `chn_code` VALUES ('500243', '   彭水苗族土家族自治县');
INSERT INTO `chn_code` VALUES ('510000', '四川省');
INSERT INTO `chn_code` VALUES ('510100', ' 成都市');
INSERT INTO `chn_code` VALUES ('510104', '   锦江区');
INSERT INTO `chn_code` VALUES ('510105', '   青羊区');
INSERT INTO `chn_code` VALUES ('510106', '   金牛区');
INSERT INTO `chn_code` VALUES ('510107', '   武侯区');
INSERT INTO `chn_code` VALUES ('510108', '   成华区');
INSERT INTO `chn_code` VALUES ('510112', '   龙泉驿区');
INSERT INTO `chn_code` VALUES ('510113', '   青白江区');
INSERT INTO `chn_code` VALUES ('510114', '   新都区');
INSERT INTO `chn_code` VALUES ('510115', '   温江区');
INSERT INTO `chn_code` VALUES ('510116', '   双流区');
INSERT INTO `chn_code` VALUES ('510117', '   郫都区');
INSERT INTO `chn_code` VALUES ('510118', '   新津区');
INSERT INTO `chn_code` VALUES ('510121', '   金堂县');
INSERT INTO `chn_code` VALUES ('510129', '   大邑县');
INSERT INTO `chn_code` VALUES ('510131', '   蒲江县');
INSERT INTO `chn_code` VALUES ('510181', '   都江堰市');
INSERT INTO `chn_code` VALUES ('510182', '   彭州市');
INSERT INTO `chn_code` VALUES ('510183', '   邛崃市');
INSERT INTO `chn_code` VALUES ('510184', '   崇州市');
INSERT INTO `chn_code` VALUES ('510185', '   简阳市');
INSERT INTO `chn_code` VALUES ('510300', ' 自贡市');
INSERT INTO `chn_code` VALUES ('510302', '   自流井区');
INSERT INTO `chn_code` VALUES ('510303', '   贡井区');
INSERT INTO `chn_code` VALUES ('510304', '   大安区');
INSERT INTO `chn_code` VALUES ('510311', '   沿滩区');
INSERT INTO `chn_code` VALUES ('510321', '   荣县');
INSERT INTO `chn_code` VALUES ('510322', '   富顺县');
INSERT INTO `chn_code` VALUES ('510400', ' 攀枝花市');
INSERT INTO `chn_code` VALUES ('510402', '   东区');
INSERT INTO `chn_code` VALUES ('510403', '   西区');
INSERT INTO `chn_code` VALUES ('510411', '   仁和区');
INSERT INTO `chn_code` VALUES ('510421', '   米易县');
INSERT INTO `chn_code` VALUES ('510422', '   盐边县');
INSERT INTO `chn_code` VALUES ('510500', ' 泸州市');
INSERT INTO `chn_code` VALUES ('510502', '   江阳区');
INSERT INTO `chn_code` VALUES ('510503', '   纳溪区');
INSERT INTO `chn_code` VALUES ('510504', '   龙马潭区');
INSERT INTO `chn_code` VALUES ('510521', '   泸县');
INSERT INTO `chn_code` VALUES ('510522', '   合江县');
INSERT INTO `chn_code` VALUES ('510524', '   叙永县');
INSERT INTO `chn_code` VALUES ('510525', '   古蔺县');
INSERT INTO `chn_code` VALUES ('510600', ' 德阳市');
INSERT INTO `chn_code` VALUES ('510603', '   旌阳区');
INSERT INTO `chn_code` VALUES ('510604', '   罗江区');
INSERT INTO `chn_code` VALUES ('510623', '   中江县');
INSERT INTO `chn_code` VALUES ('510681', '   广汉市');
INSERT INTO `chn_code` VALUES ('510682', '   什邡市');
INSERT INTO `chn_code` VALUES ('510683', '   绵竹市');
INSERT INTO `chn_code` VALUES ('510700', ' 绵阳市');
INSERT INTO `chn_code` VALUES ('510703', '   涪城区');
INSERT INTO `chn_code` VALUES ('510704', '   游仙区');
INSERT INTO `chn_code` VALUES ('510705', '   安州区');
INSERT INTO `chn_code` VALUES ('510722', '   三台县');
INSERT INTO `chn_code` VALUES ('510723', '   盐亭县');
INSERT INTO `chn_code` VALUES ('510725', '   梓潼县');
INSERT INTO `chn_code` VALUES ('510726', '   北川羌族自治县');
INSERT INTO `chn_code` VALUES ('510727', '   平武县');
INSERT INTO `chn_code` VALUES ('510781', '   江油市');
INSERT INTO `chn_code` VALUES ('510800', ' 广元市');
INSERT INTO `chn_code` VALUES ('510802', '   利州区');
INSERT INTO `chn_code` VALUES ('510811', '   昭化区');
INSERT INTO `chn_code` VALUES ('510812', '   朝天区');
INSERT INTO `chn_code` VALUES ('510821', '   旺苍县');
INSERT INTO `chn_code` VALUES ('510822', '   青川县');
INSERT INTO `chn_code` VALUES ('510823', '   剑阁县');
INSERT INTO `chn_code` VALUES ('510824', '   苍溪县');
INSERT INTO `chn_code` VALUES ('510900', ' 遂宁市');
INSERT INTO `chn_code` VALUES ('510903', '   船山区');
INSERT INTO `chn_code` VALUES ('510904', '   安居区');
INSERT INTO `chn_code` VALUES ('510921', '   蓬溪县');
INSERT INTO `chn_code` VALUES ('510923', '   大英县');
INSERT INTO `chn_code` VALUES ('510981', '   射洪市');
INSERT INTO `chn_code` VALUES ('511000', ' 内江市');
INSERT INTO `chn_code` VALUES ('511002', '   市中区');
INSERT INTO `chn_code` VALUES ('511011', '   东兴区');
INSERT INTO `chn_code` VALUES ('511024', '   威远县');
INSERT INTO `chn_code` VALUES ('511025', '   资中县');
INSERT INTO `chn_code` VALUES ('511083', '   隆昌市');
INSERT INTO `chn_code` VALUES ('511100', ' 乐山市');
INSERT INTO `chn_code` VALUES ('511102', '   市中区');
INSERT INTO `chn_code` VALUES ('511111', '   沙湾区');
INSERT INTO `chn_code` VALUES ('511112', '   五通桥区');
INSERT INTO `chn_code` VALUES ('511113', '   金口河区');
INSERT INTO `chn_code` VALUES ('511123', '   犍为县');
INSERT INTO `chn_code` VALUES ('511124', '   井研县');
INSERT INTO `chn_code` VALUES ('511126', '   夹江县');
INSERT INTO `chn_code` VALUES ('511129', '   沐川县');
INSERT INTO `chn_code` VALUES ('511132', '   峨边彝族自治县');
INSERT INTO `chn_code` VALUES ('511133', '   马边彝族自治县');
INSERT INTO `chn_code` VALUES ('511181', '   峨眉山市');
INSERT INTO `chn_code` VALUES ('511300', ' 南充市');
INSERT INTO `chn_code` VALUES ('511302', '   顺庆区');
INSERT INTO `chn_code` VALUES ('511303', '   高坪区');
INSERT INTO `chn_code` VALUES ('511304', '   嘉陵区');
INSERT INTO `chn_code` VALUES ('511321', '   南部县');
INSERT INTO `chn_code` VALUES ('511322', '   营山县');
INSERT INTO `chn_code` VALUES ('511323', '   蓬安县');
INSERT INTO `chn_code` VALUES ('511324', '   仪陇县');
INSERT INTO `chn_code` VALUES ('511325', '   西充县');
INSERT INTO `chn_code` VALUES ('511381', '   阆中市');
INSERT INTO `chn_code` VALUES ('511400', ' 眉山市');
INSERT INTO `chn_code` VALUES ('511402', '   东坡区');
INSERT INTO `chn_code` VALUES ('511403', '   彭山区');
INSERT INTO `chn_code` VALUES ('511421', '   仁寿县');
INSERT INTO `chn_code` VALUES ('511423', '   洪雅县');
INSERT INTO `chn_code` VALUES ('511424', '   丹棱县');
INSERT INTO `chn_code` VALUES ('511425', '   青神县');
INSERT INTO `chn_code` VALUES ('511500', ' 宜宾市');
INSERT INTO `chn_code` VALUES ('511502', '   翠屏区');
INSERT INTO `chn_code` VALUES ('511503', '   南溪区');
INSERT INTO `chn_code` VALUES ('511504', '   叙州区');
INSERT INTO `chn_code` VALUES ('511523', '   江安县');
INSERT INTO `chn_code` VALUES ('511524', '   长宁县');
INSERT INTO `chn_code` VALUES ('511525', '   高县');
INSERT INTO `chn_code` VALUES ('511526', '   珙县');
INSERT INTO `chn_code` VALUES ('511527', '   筠连县');
INSERT INTO `chn_code` VALUES ('511528', '   兴文县');
INSERT INTO `chn_code` VALUES ('511529', '   屏山县');
INSERT INTO `chn_code` VALUES ('511600', ' 广安市');
INSERT INTO `chn_code` VALUES ('511602', '   广安区');
INSERT INTO `chn_code` VALUES ('511603', '   前锋区');
INSERT INTO `chn_code` VALUES ('511621', '   岳池县');
INSERT INTO `chn_code` VALUES ('511622', '   武胜县');
INSERT INTO `chn_code` VALUES ('511623', '   邻水县');
INSERT INTO `chn_code` VALUES ('511681', '   华蓥市');
INSERT INTO `chn_code` VALUES ('511700', ' 达州市');
INSERT INTO `chn_code` VALUES ('511702', '   通川区');
INSERT INTO `chn_code` VALUES ('511703', '   达川区');
INSERT INTO `chn_code` VALUES ('511722', '   宣汉县');
INSERT INTO `chn_code` VALUES ('511723', '   开江县');
INSERT INTO `chn_code` VALUES ('511724', '   大竹县');
INSERT INTO `chn_code` VALUES ('511725', '   渠县');
INSERT INTO `chn_code` VALUES ('511781', '   万源市');
INSERT INTO `chn_code` VALUES ('511800', ' 雅安市');
INSERT INTO `chn_code` VALUES ('511802', '   雨城区');
INSERT INTO `chn_code` VALUES ('511803', '   名山区');
INSERT INTO `chn_code` VALUES ('511822', '   荥经县');
INSERT INTO `chn_code` VALUES ('511823', '   汉源县');
INSERT INTO `chn_code` VALUES ('511824', '   石棉县');
INSERT INTO `chn_code` VALUES ('511825', '   天全县');
INSERT INTO `chn_code` VALUES ('511826', '   芦山县');
INSERT INTO `chn_code` VALUES ('511827', '   宝兴县');
INSERT INTO `chn_code` VALUES ('511900', ' 巴中市');
INSERT INTO `chn_code` VALUES ('511902', '   巴州区');
INSERT INTO `chn_code` VALUES ('511903', '   恩阳区');
INSERT INTO `chn_code` VALUES ('511921', '   通江县');
INSERT INTO `chn_code` VALUES ('511922', '   南江县');
INSERT INTO `chn_code` VALUES ('511923', '   平昌县');
INSERT INTO `chn_code` VALUES ('512000', ' 资阳市');
INSERT INTO `chn_code` VALUES ('512002', '   雁江区');
INSERT INTO `chn_code` VALUES ('512021', '   安岳县');
INSERT INTO `chn_code` VALUES ('512022', '   乐至县');
INSERT INTO `chn_code` VALUES ('513200', ' 阿坝藏族羌族自治州');
INSERT INTO `chn_code` VALUES ('513201', '   马尔康市');
INSERT INTO `chn_code` VALUES ('513221', '   汶川县');
INSERT INTO `chn_code` VALUES ('513222', '   理县');
INSERT INTO `chn_code` VALUES ('513223', '   茂县');
INSERT INTO `chn_code` VALUES ('513224', '   松潘县');
INSERT INTO `chn_code` VALUES ('513225', '   九寨沟县');
INSERT INTO `chn_code` VALUES ('513226', '   金川县');
INSERT INTO `chn_code` VALUES ('513227', '   小金县');
INSERT INTO `chn_code` VALUES ('513228', '   黑水县');
INSERT INTO `chn_code` VALUES ('513230', '   壤塘县');
INSERT INTO `chn_code` VALUES ('513231', '   阿坝县');
INSERT INTO `chn_code` VALUES ('513232', '   若尔盖县');
INSERT INTO `chn_code` VALUES ('513233', '   红原县');
INSERT INTO `chn_code` VALUES ('513300', ' 甘孜藏族自治州');
INSERT INTO `chn_code` VALUES ('513301', '   康定市');
INSERT INTO `chn_code` VALUES ('513322', '   泸定县');
INSERT INTO `chn_code` VALUES ('513323', '   丹巴县');
INSERT INTO `chn_code` VALUES ('513324', '   九龙县');
INSERT INTO `chn_code` VALUES ('513325', '   雅江县');
INSERT INTO `chn_code` VALUES ('513326', '   道孚县');
INSERT INTO `chn_code` VALUES ('513327', '   炉霍县');
INSERT INTO `chn_code` VALUES ('513328', '   甘孜县');
INSERT INTO `chn_code` VALUES ('513329', '   新龙县');
INSERT INTO `chn_code` VALUES ('513330', '   德格县');
INSERT INTO `chn_code` VALUES ('513331', '   白玉县');
INSERT INTO `chn_code` VALUES ('513332', '   石渠县');
INSERT INTO `chn_code` VALUES ('513333', '   色达县');
INSERT INTO `chn_code` VALUES ('513334', '   理塘县');
INSERT INTO `chn_code` VALUES ('513335', '   巴塘县');
INSERT INTO `chn_code` VALUES ('513336', '   乡城县');
INSERT INTO `chn_code` VALUES ('513337', '   稻城县');
INSERT INTO `chn_code` VALUES ('513338', '   得荣县');
INSERT INTO `chn_code` VALUES ('513400', ' 凉山彝族自治州');
INSERT INTO `chn_code` VALUES ('513401', '   西昌市');
INSERT INTO `chn_code` VALUES ('513422', '   木里藏族自治县');
INSERT INTO `chn_code` VALUES ('513423', '   盐源县');
INSERT INTO `chn_code` VALUES ('513424', '   德昌县');
INSERT INTO `chn_code` VALUES ('513425', '   会理县');
INSERT INTO `chn_code` VALUES ('513426', '   会东县');
INSERT INTO `chn_code` VALUES ('513427', '   宁南县');
INSERT INTO `chn_code` VALUES ('513428', '   普格县');
INSERT INTO `chn_code` VALUES ('513429', '   布拖县');
INSERT INTO `chn_code` VALUES ('513430', '   金阳县');
INSERT INTO `chn_code` VALUES ('513431', '   昭觉县');
INSERT INTO `chn_code` VALUES ('513432', '   喜德县');
INSERT INTO `chn_code` VALUES ('513433', '   冕宁县');
INSERT INTO `chn_code` VALUES ('513434', '   越西县');
INSERT INTO `chn_code` VALUES ('513435', '   甘洛县');
INSERT INTO `chn_code` VALUES ('513436', '   美姑县');
INSERT INTO `chn_code` VALUES ('513437', '   雷波县');
INSERT INTO `chn_code` VALUES ('520000', '贵州省');
INSERT INTO `chn_code` VALUES ('520100', ' 贵阳市');
INSERT INTO `chn_code` VALUES ('520102', '   南明区');
INSERT INTO `chn_code` VALUES ('520103', '   云岩区');
INSERT INTO `chn_code` VALUES ('520111', '   花溪区');
INSERT INTO `chn_code` VALUES ('520112', '   乌当区');
INSERT INTO `chn_code` VALUES ('520113', '   白云区');
INSERT INTO `chn_code` VALUES ('520115', '   观山湖区');
INSERT INTO `chn_code` VALUES ('520121', '   开阳县');
INSERT INTO `chn_code` VALUES ('520122', '   息烽县');
INSERT INTO `chn_code` VALUES ('520123', '   修文县');
INSERT INTO `chn_code` VALUES ('520181', '   清镇市');
INSERT INTO `chn_code` VALUES ('520200', ' 六盘水市');
INSERT INTO `chn_code` VALUES ('520201', '   钟山区');
INSERT INTO `chn_code` VALUES ('520203', '   六枝特区');
INSERT INTO `chn_code` VALUES ('520204', '   水城区');
INSERT INTO `chn_code` VALUES ('520281', '   盘州市');
INSERT INTO `chn_code` VALUES ('520300', ' 遵义市');
INSERT INTO `chn_code` VALUES ('520302', '   红花岗区');
INSERT INTO `chn_code` VALUES ('520303', '   汇川区');
INSERT INTO `chn_code` VALUES ('520304', '   播州区');
INSERT INTO `chn_code` VALUES ('520322', '   桐梓县');
INSERT INTO `chn_code` VALUES ('520323', '   绥阳县');
INSERT INTO `chn_code` VALUES ('520324', '   正安县');
INSERT INTO `chn_code` VALUES ('520325', '   道真仡佬族苗族自治县');
INSERT INTO `chn_code` VALUES ('520326', '   务川仡佬族苗族自治县');
INSERT INTO `chn_code` VALUES ('520327', '   凤冈县');
INSERT INTO `chn_code` VALUES ('520328', '   湄潭县');
INSERT INTO `chn_code` VALUES ('520329', '   余庆县');
INSERT INTO `chn_code` VALUES ('520330', '   习水县');
INSERT INTO `chn_code` VALUES ('520381', '   赤水市');
INSERT INTO `chn_code` VALUES ('520382', '   仁怀市');
INSERT INTO `chn_code` VALUES ('520400', ' 安顺市');
INSERT INTO `chn_code` VALUES ('520402', '   西秀区');
INSERT INTO `chn_code` VALUES ('520403', '   平坝区');
INSERT INTO `chn_code` VALUES ('520422', '   普定县');
INSERT INTO `chn_code` VALUES ('520423', '   镇宁布依族苗族自治县');
INSERT INTO `chn_code` VALUES ('520424', '   关岭布依族苗族自治县');
INSERT INTO `chn_code` VALUES ('520425', '   紫云苗族布依族自治县');
INSERT INTO `chn_code` VALUES ('520500', ' 毕节市');
INSERT INTO `chn_code` VALUES ('520502', '   七星关区');
INSERT INTO `chn_code` VALUES ('520521', '   大方县');
INSERT INTO `chn_code` VALUES ('520522', '   黔西县');
INSERT INTO `chn_code` VALUES ('520523', '   金沙县');
INSERT INTO `chn_code` VALUES ('520524', '   织金县');
INSERT INTO `chn_code` VALUES ('520525', '   纳雍县');
INSERT INTO `chn_code` VALUES ('520526', '   威宁彝族回族苗族自治县');
INSERT INTO `chn_code` VALUES ('520527', '   赫章县');
INSERT INTO `chn_code` VALUES ('520600', ' 铜仁市');
INSERT INTO `chn_code` VALUES ('520602', '   碧江区');
INSERT INTO `chn_code` VALUES ('520603', '   万山区');
INSERT INTO `chn_code` VALUES ('520621', '   江口县');
INSERT INTO `chn_code` VALUES ('520622', '   玉屏侗族自治县');
INSERT INTO `chn_code` VALUES ('520623', '   石阡县');
INSERT INTO `chn_code` VALUES ('520624', '   思南县');
INSERT INTO `chn_code` VALUES ('520625', '   印江土家族苗族自治县');
INSERT INTO `chn_code` VALUES ('520626', '   德江县');
INSERT INTO `chn_code` VALUES ('520627', '   沿河土家族自治县');
INSERT INTO `chn_code` VALUES ('520628', '   松桃苗族自治县');
INSERT INTO `chn_code` VALUES ('522300', ' 黔西南布依族苗族自治州');
INSERT INTO `chn_code` VALUES ('522301', '   兴义市');
INSERT INTO `chn_code` VALUES ('522302', '   兴仁市');
INSERT INTO `chn_code` VALUES ('522323', '   普安县');
INSERT INTO `chn_code` VALUES ('522324', '   晴隆县');
INSERT INTO `chn_code` VALUES ('522325', '   贞丰县');
INSERT INTO `chn_code` VALUES ('522326', '   望谟县');
INSERT INTO `chn_code` VALUES ('522327', '   册亨县');
INSERT INTO `chn_code` VALUES ('522328', '   安龙县');
INSERT INTO `chn_code` VALUES ('522600', ' 黔东南苗族侗族自治州');
INSERT INTO `chn_code` VALUES ('522601', '   凯里市');
INSERT INTO `chn_code` VALUES ('522622', '   黄平县');
INSERT INTO `chn_code` VALUES ('522623', '   施秉县');
INSERT INTO `chn_code` VALUES ('522624', '   三穗县');
INSERT INTO `chn_code` VALUES ('522625', '   镇远县');
INSERT INTO `chn_code` VALUES ('522626', '   岑巩县');
INSERT INTO `chn_code` VALUES ('522627', '   天柱县');
INSERT INTO `chn_code` VALUES ('522628', '   锦屏县');
INSERT INTO `chn_code` VALUES ('522629', '   剑河县');
INSERT INTO `chn_code` VALUES ('522630', '   台江县');
INSERT INTO `chn_code` VALUES ('522631', '   黎平县');
INSERT INTO `chn_code` VALUES ('522632', '   榕江县');
INSERT INTO `chn_code` VALUES ('522633', '   从江县');
INSERT INTO `chn_code` VALUES ('522634', '   雷山县');
INSERT INTO `chn_code` VALUES ('522635', '   麻江县');
INSERT INTO `chn_code` VALUES ('522636', '   丹寨县');
INSERT INTO `chn_code` VALUES ('522700', ' 黔南布依族苗族自治州');
INSERT INTO `chn_code` VALUES ('522701', '   都匀市');
INSERT INTO `chn_code` VALUES ('522702', '   福泉市');
INSERT INTO `chn_code` VALUES ('522722', '   荔波县');
INSERT INTO `chn_code` VALUES ('522723', '   贵定县');
INSERT INTO `chn_code` VALUES ('522725', '   瓮安县');
INSERT INTO `chn_code` VALUES ('522726', '   独山县');
INSERT INTO `chn_code` VALUES ('522727', '   平塘县');
INSERT INTO `chn_code` VALUES ('522728', '   罗甸县');
INSERT INTO `chn_code` VALUES ('522729', '   长顺县');
INSERT INTO `chn_code` VALUES ('522730', '   龙里县');
INSERT INTO `chn_code` VALUES ('522731', '   惠水县');
INSERT INTO `chn_code` VALUES ('522732', '   三都水族自治县');
INSERT INTO `chn_code` VALUES ('530000', '云南省');
INSERT INTO `chn_code` VALUES ('530100', ' 昆明市');
INSERT INTO `chn_code` VALUES ('530102', '   五华区');
INSERT INTO `chn_code` VALUES ('530103', '   盘龙区');
INSERT INTO `chn_code` VALUES ('530111', '   官渡区');
INSERT INTO `chn_code` VALUES ('530112', '   西山区');
INSERT INTO `chn_code` VALUES ('530113', '   东川区');
INSERT INTO `chn_code` VALUES ('530114', '   呈贡区');
INSERT INTO `chn_code` VALUES ('530115', '   晋宁区');
INSERT INTO `chn_code` VALUES ('530124', '   富民县');
INSERT INTO `chn_code` VALUES ('530125', '   宜良县');
INSERT INTO `chn_code` VALUES ('530126', '   石林彝族自治县');
INSERT INTO `chn_code` VALUES ('530127', '   嵩明县');
INSERT INTO `chn_code` VALUES ('530128', '   禄劝彝族苗族自治县');
INSERT INTO `chn_code` VALUES ('530129', '   寻甸回族彝族自治县');
INSERT INTO `chn_code` VALUES ('530181', '   安宁市');
INSERT INTO `chn_code` VALUES ('530300', ' 曲靖市');
INSERT INTO `chn_code` VALUES ('530302', '   麒麟区');
INSERT INTO `chn_code` VALUES ('530303', '   沾益区');
INSERT INTO `chn_code` VALUES ('530304', '   马龙区');
INSERT INTO `chn_code` VALUES ('530322', '   陆良县');
INSERT INTO `chn_code` VALUES ('530323', '   师宗县');
INSERT INTO `chn_code` VALUES ('530324', '   罗平县');
INSERT INTO `chn_code` VALUES ('530325', '   富源县');
INSERT INTO `chn_code` VALUES ('530326', '   会泽县');
INSERT INTO `chn_code` VALUES ('530381', '   宣威市');
INSERT INTO `chn_code` VALUES ('530400', ' 玉溪市');
INSERT INTO `chn_code` VALUES ('530402', '   红塔区');
INSERT INTO `chn_code` VALUES ('530403', '   江川区');
INSERT INTO `chn_code` VALUES ('530423', '   通海县');
INSERT INTO `chn_code` VALUES ('530424', '   华宁县');
INSERT INTO `chn_code` VALUES ('530425', '   易门县');
INSERT INTO `chn_code` VALUES ('530426', '   峨山彝族自治县');
INSERT INTO `chn_code` VALUES ('530427', '   新平彝族傣族自治县');
INSERT INTO `chn_code` VALUES ('530428', '   元江哈尼族彝族傣族自治县');
INSERT INTO `chn_code` VALUES ('530481', '   澄江市');
INSERT INTO `chn_code` VALUES ('530500', ' 保山市');
INSERT INTO `chn_code` VALUES ('530502', '   隆阳区');
INSERT INTO `chn_code` VALUES ('530521', '   施甸县');
INSERT INTO `chn_code` VALUES ('530523', '   龙陵县');
INSERT INTO `chn_code` VALUES ('530524', '   昌宁县');
INSERT INTO `chn_code` VALUES ('530581', '   腾冲市');
INSERT INTO `chn_code` VALUES ('530600', ' 昭通市');
INSERT INTO `chn_code` VALUES ('530602', '   昭阳区');
INSERT INTO `chn_code` VALUES ('530621', '   鲁甸县');
INSERT INTO `chn_code` VALUES ('530622', '   巧家县');
INSERT INTO `chn_code` VALUES ('530623', '   盐津县');
INSERT INTO `chn_code` VALUES ('530624', '   大关县');
INSERT INTO `chn_code` VALUES ('530625', '   永善县');
INSERT INTO `chn_code` VALUES ('530626', '   绥江县');
INSERT INTO `chn_code` VALUES ('530627', '   镇雄县');
INSERT INTO `chn_code` VALUES ('530628', '   彝良县');
INSERT INTO `chn_code` VALUES ('530629', '   威信县');
INSERT INTO `chn_code` VALUES ('530681', '   水富市');
INSERT INTO `chn_code` VALUES ('530700', ' 丽江市');
INSERT INTO `chn_code` VALUES ('530702', '   古城区');
INSERT INTO `chn_code` VALUES ('530721', '   玉龙纳西族自治县');
INSERT INTO `chn_code` VALUES ('530722', '   永胜县');
INSERT INTO `chn_code` VALUES ('530723', '   华坪县');
INSERT INTO `chn_code` VALUES ('530724', '   宁蒗彝族自治县');
INSERT INTO `chn_code` VALUES ('530800', ' 普洱市');
INSERT INTO `chn_code` VALUES ('530802', '   思茅区');
INSERT INTO `chn_code` VALUES ('530821', '   宁洱哈尼族彝族自治县');
INSERT INTO `chn_code` VALUES ('530822', '   墨江哈尼族自治县');
INSERT INTO `chn_code` VALUES ('530823', '   景东彝族自治县');
INSERT INTO `chn_code` VALUES ('530824', '   景谷傣族彝族自治县');
INSERT INTO `chn_code` VALUES ('530825', '   镇沅彝族哈尼族拉祜族自治县');
INSERT INTO `chn_code` VALUES ('530826', '   江城哈尼族彝族自治县');
INSERT INTO `chn_code` VALUES ('530827', '   孟连傣族拉祜族佤族自治县');
INSERT INTO `chn_code` VALUES ('530828', '   澜沧拉祜族自治县');
INSERT INTO `chn_code` VALUES ('530829', '   西盟佤族自治县');
INSERT INTO `chn_code` VALUES ('530900', ' 临沧市');
INSERT INTO `chn_code` VALUES ('530902', '   临翔区');
INSERT INTO `chn_code` VALUES ('530921', '   凤庆县');
INSERT INTO `chn_code` VALUES ('530922', '   云县');
INSERT INTO `chn_code` VALUES ('530923', '   永德县');
INSERT INTO `chn_code` VALUES ('530924', '   镇康县');
INSERT INTO `chn_code` VALUES ('530925', '   双江拉祜族佤族布朗族傣族自治县');
INSERT INTO `chn_code` VALUES ('530926', '   耿马傣族佤族自治县');
INSERT INTO `chn_code` VALUES ('530927', '   沧源佤族自治县');
INSERT INTO `chn_code` VALUES ('532300', ' 楚雄彝族自治州');
INSERT INTO `chn_code` VALUES ('532301', '   楚雄市');
INSERT INTO `chn_code` VALUES ('532322', '   双柏县');
INSERT INTO `chn_code` VALUES ('532323', '   牟定县');
INSERT INTO `chn_code` VALUES ('532324', '   南华县');
INSERT INTO `chn_code` VALUES ('532325', '   姚安县');
INSERT INTO `chn_code` VALUES ('532326', '   大姚县');
INSERT INTO `chn_code` VALUES ('532327', '   永仁县');
INSERT INTO `chn_code` VALUES ('532328', '   元谋县');
INSERT INTO `chn_code` VALUES ('532329', '   武定县');
INSERT INTO `chn_code` VALUES ('532331', '   禄丰县');
INSERT INTO `chn_code` VALUES ('532500', ' 红河哈尼族彝族自治州');
INSERT INTO `chn_code` VALUES ('532501', '   个旧市');
INSERT INTO `chn_code` VALUES ('532502', '   开远市');
INSERT INTO `chn_code` VALUES ('532503', '   蒙自市');
INSERT INTO `chn_code` VALUES ('532504', '   弥勒市');
INSERT INTO `chn_code` VALUES ('532523', '   屏边苗族自治县');
INSERT INTO `chn_code` VALUES ('532524', '   建水县');
INSERT INTO `chn_code` VALUES ('532525', '   石屏县');
INSERT INTO `chn_code` VALUES ('532527', '   泸西县');
INSERT INTO `chn_code` VALUES ('532528', '   元阳县');
INSERT INTO `chn_code` VALUES ('532529', '   红河县');
INSERT INTO `chn_code` VALUES ('532530', '   金平苗族瑶族傣族自治县');
INSERT INTO `chn_code` VALUES ('532531', '   绿春县');
INSERT INTO `chn_code` VALUES ('532532', '   河口瑶族自治县');
INSERT INTO `chn_code` VALUES ('532600', ' 文山壮族苗族自治州');
INSERT INTO `chn_code` VALUES ('532601', '   文山市');
INSERT INTO `chn_code` VALUES ('532622', '   砚山县');
INSERT INTO `chn_code` VALUES ('532623', '   西畴县');
INSERT INTO `chn_code` VALUES ('532624', '   麻栗坡县');
INSERT INTO `chn_code` VALUES ('532625', '   马关县');
INSERT INTO `chn_code` VALUES ('532626', '   丘北县');
INSERT INTO `chn_code` VALUES ('532627', '   广南县');
INSERT INTO `chn_code` VALUES ('532628', '   富宁县');
INSERT INTO `chn_code` VALUES ('532800', ' 西双版纳傣族自治州');
INSERT INTO `chn_code` VALUES ('532801', '   景洪市');
INSERT INTO `chn_code` VALUES ('532822', '   勐海县');
INSERT INTO `chn_code` VALUES ('532823', '   勐腊县');
INSERT INTO `chn_code` VALUES ('532900', ' 大理白族自治州');
INSERT INTO `chn_code` VALUES ('532901', '   大理市');
INSERT INTO `chn_code` VALUES ('532922', '   漾濞彝族自治县');
INSERT INTO `chn_code` VALUES ('532923', '   祥云县');
INSERT INTO `chn_code` VALUES ('532924', '   宾川县');
INSERT INTO `chn_code` VALUES ('532925', '   弥渡县');
INSERT INTO `chn_code` VALUES ('532926', '   南涧彝族自治县');
INSERT INTO `chn_code` VALUES ('532927', '   巍山彝族回族自治县');
INSERT INTO `chn_code` VALUES ('532928', '   永平县');
INSERT INTO `chn_code` VALUES ('532929', '   云龙县');
INSERT INTO `chn_code` VALUES ('532930', '   洱源县');
INSERT INTO `chn_code` VALUES ('532931', '   剑川县');
INSERT INTO `chn_code` VALUES ('532932', '   鹤庆县');
INSERT INTO `chn_code` VALUES ('533100', ' 德宏傣族景颇族自治州');
INSERT INTO `chn_code` VALUES ('533102', '   瑞丽市');
INSERT INTO `chn_code` VALUES ('533103', '   芒市');
INSERT INTO `chn_code` VALUES ('533122', '   梁河县');
INSERT INTO `chn_code` VALUES ('533123', '   盈江县');
INSERT INTO `chn_code` VALUES ('533124', '   陇川县');
INSERT INTO `chn_code` VALUES ('533300', ' 怒江傈僳族自治州');
INSERT INTO `chn_code` VALUES ('533301', '   泸水市');
INSERT INTO `chn_code` VALUES ('533323', '   福贡县');
INSERT INTO `chn_code` VALUES ('533324', '   贡山独龙族怒族自治县');
INSERT INTO `chn_code` VALUES ('533325', '   兰坪白族普米族自治县');
INSERT INTO `chn_code` VALUES ('533400', ' 迪庆藏族自治州');
INSERT INTO `chn_code` VALUES ('533401', '   香格里拉市');
INSERT INTO `chn_code` VALUES ('533422', '   德钦县');
INSERT INTO `chn_code` VALUES ('533423', '   维西傈僳族自治县');
INSERT INTO `chn_code` VALUES ('540000', '西藏自治区');
INSERT INTO `chn_code` VALUES ('540100', ' 拉萨市');
INSERT INTO `chn_code` VALUES ('540102', '   城关区');
INSERT INTO `chn_code` VALUES ('540103', '   堆龙德庆区');
INSERT INTO `chn_code` VALUES ('540104', '   达孜区');
INSERT INTO `chn_code` VALUES ('540121', '   林周县');
INSERT INTO `chn_code` VALUES ('540122', '   当雄县');
INSERT INTO `chn_code` VALUES ('540123', '   尼木县');
INSERT INTO `chn_code` VALUES ('540124', '   曲水县');
INSERT INTO `chn_code` VALUES ('540127', '   墨竹工卡县');
INSERT INTO `chn_code` VALUES ('540200', ' 日喀则市');
INSERT INTO `chn_code` VALUES ('540202', '   桑珠孜区');
INSERT INTO `chn_code` VALUES ('540221', '   南木林县');
INSERT INTO `chn_code` VALUES ('540222', '   江孜县');
INSERT INTO `chn_code` VALUES ('540223', '   定日县');
INSERT INTO `chn_code` VALUES ('540224', '   萨迦县');
INSERT INTO `chn_code` VALUES ('540225', '   拉孜县');
INSERT INTO `chn_code` VALUES ('540226', '   昂仁县');
INSERT INTO `chn_code` VALUES ('540227', '   谢通门县');
INSERT INTO `chn_code` VALUES ('540228', '   白朗县');
INSERT INTO `chn_code` VALUES ('540229', '   仁布县');
INSERT INTO `chn_code` VALUES ('540230', '   康马县');
INSERT INTO `chn_code` VALUES ('540231', '   定结县');
INSERT INTO `chn_code` VALUES ('540232', '   仲巴县');
INSERT INTO `chn_code` VALUES ('540233', '   亚东县');
INSERT INTO `chn_code` VALUES ('540234', '   吉隆县');
INSERT INTO `chn_code` VALUES ('540235', '   聂拉木县');
INSERT INTO `chn_code` VALUES ('540236', '   萨嘎县');
INSERT INTO `chn_code` VALUES ('540237', '   岗巴县');
INSERT INTO `chn_code` VALUES ('540300', ' 昌都市');
INSERT INTO `chn_code` VALUES ('540302', '   卡若区');
INSERT INTO `chn_code` VALUES ('540321', '   江达县');
INSERT INTO `chn_code` VALUES ('540322', '   贡觉县');
INSERT INTO `chn_code` VALUES ('540323', '   类乌齐县');
INSERT INTO `chn_code` VALUES ('540324', '   丁青县');
INSERT INTO `chn_code` VALUES ('540325', '   察雅县');
INSERT INTO `chn_code` VALUES ('540326', '   八宿县');
INSERT INTO `chn_code` VALUES ('540327', '   左贡县');
INSERT INTO `chn_code` VALUES ('540328', '   芒康县');
INSERT INTO `chn_code` VALUES ('540329', '   洛隆县');
INSERT INTO `chn_code` VALUES ('540330', '   边坝县');
INSERT INTO `chn_code` VALUES ('540400', ' 林芝市');
INSERT INTO `chn_code` VALUES ('540402', '   巴宜区');
INSERT INTO `chn_code` VALUES ('540421', '   工布江达县');
INSERT INTO `chn_code` VALUES ('540422', '   米林县');
INSERT INTO `chn_code` VALUES ('540423', '   墨脱县');
INSERT INTO `chn_code` VALUES ('540424', '   波密县');
INSERT INTO `chn_code` VALUES ('540425', '   察隅县');
INSERT INTO `chn_code` VALUES ('540426', '   朗县');
INSERT INTO `chn_code` VALUES ('540500', ' 山南市');
INSERT INTO `chn_code` VALUES ('540502', '   乃东区');
INSERT INTO `chn_code` VALUES ('540521', '   扎囊县');
INSERT INTO `chn_code` VALUES ('540522', '   贡嘎县');
INSERT INTO `chn_code` VALUES ('540523', '   桑日县');
INSERT INTO `chn_code` VALUES ('540524', '   琼结县');
INSERT INTO `chn_code` VALUES ('540525', '   曲松县');
INSERT INTO `chn_code` VALUES ('540526', '   措美县');
INSERT INTO `chn_code` VALUES ('540527', '   洛扎县');
INSERT INTO `chn_code` VALUES ('540528', '   加查县');
INSERT INTO `chn_code` VALUES ('540529', '   隆子县');
INSERT INTO `chn_code` VALUES ('540530', '   错那县');
INSERT INTO `chn_code` VALUES ('540531', '   浪卡子县');
INSERT INTO `chn_code` VALUES ('540600', ' 那曲市');
INSERT INTO `chn_code` VALUES ('540602', '   色尼区');
INSERT INTO `chn_code` VALUES ('540621', '   嘉黎县 ');
INSERT INTO `chn_code` VALUES ('540622', '   比如县 ');
INSERT INTO `chn_code` VALUES ('540623', '   聂荣县 ');
INSERT INTO `chn_code` VALUES ('540624', '   安多县 ');
INSERT INTO `chn_code` VALUES ('540625', '   申扎县 ');
INSERT INTO `chn_code` VALUES ('540626', '   索县   ');
INSERT INTO `chn_code` VALUES ('540627', '   班戈县 ');
INSERT INTO `chn_code` VALUES ('540628', '   巴青县 ');
INSERT INTO `chn_code` VALUES ('540629', '   尼玛县 ');
INSERT INTO `chn_code` VALUES ('540630', '   双湖县 ');
INSERT INTO `chn_code` VALUES ('542500', ' 阿里地区');
INSERT INTO `chn_code` VALUES ('542521', '   普兰县');
INSERT INTO `chn_code` VALUES ('542522', '   札达县');
INSERT INTO `chn_code` VALUES ('542523', '   噶尔县');
INSERT INTO `chn_code` VALUES ('542524', '   日土县');
INSERT INTO `chn_code` VALUES ('542525', '   革吉县');
INSERT INTO `chn_code` VALUES ('542526', '   改则县');
INSERT INTO `chn_code` VALUES ('542527', '   措勤县');
INSERT INTO `chn_code` VALUES ('610000', '陕西省');
INSERT INTO `chn_code` VALUES ('610100', ' 西安市');
INSERT INTO `chn_code` VALUES ('610102', '   新城区');
INSERT INTO `chn_code` VALUES ('610103', '   碑林区');
INSERT INTO `chn_code` VALUES ('610104', '   莲湖区');
INSERT INTO `chn_code` VALUES ('610111', '   灞桥区');
INSERT INTO `chn_code` VALUES ('610112', '   未央区');
INSERT INTO `chn_code` VALUES ('610113', '   雁塔区');
INSERT INTO `chn_code` VALUES ('610114', '   阎良区');
INSERT INTO `chn_code` VALUES ('610115', '   临潼区');
INSERT INTO `chn_code` VALUES ('610116', '   长安区');
INSERT INTO `chn_code` VALUES ('610117', '   高陵区');
INSERT INTO `chn_code` VALUES ('610118', '   鄠邑区');
INSERT INTO `chn_code` VALUES ('610122', '   蓝田县');
INSERT INTO `chn_code` VALUES ('610124', '   周至县');
INSERT INTO `chn_code` VALUES ('610200', ' 铜川市');
INSERT INTO `chn_code` VALUES ('610202', '   王益区');
INSERT INTO `chn_code` VALUES ('610203', '   印台区');
INSERT INTO `chn_code` VALUES ('610204', '   耀州区');
INSERT INTO `chn_code` VALUES ('610222', '   宜君县');
INSERT INTO `chn_code` VALUES ('610300', ' 宝鸡市');
INSERT INTO `chn_code` VALUES ('610302', '   渭滨区');
INSERT INTO `chn_code` VALUES ('610303', '   金台区');
INSERT INTO `chn_code` VALUES ('610304', '   陈仓区');
INSERT INTO `chn_code` VALUES ('610322', '   凤翔县');
INSERT INTO `chn_code` VALUES ('610323', '   岐山县');
INSERT INTO `chn_code` VALUES ('610324', '   扶风县');
INSERT INTO `chn_code` VALUES ('610326', '   眉县');
INSERT INTO `chn_code` VALUES ('610327', '   陇县');
INSERT INTO `chn_code` VALUES ('610328', '   千阳县');
INSERT INTO `chn_code` VALUES ('610329', '   麟游县');
INSERT INTO `chn_code` VALUES ('610330', '   凤县');
INSERT INTO `chn_code` VALUES ('610331', '   太白县');
INSERT INTO `chn_code` VALUES ('610400', ' 咸阳市');
INSERT INTO `chn_code` VALUES ('610402', '   秦都区');
INSERT INTO `chn_code` VALUES ('610403', '   杨陵区');
INSERT INTO `chn_code` VALUES ('610404', '   渭城区');
INSERT INTO `chn_code` VALUES ('610422', '   三原县');
INSERT INTO `chn_code` VALUES ('610423', '   泾阳县');
INSERT INTO `chn_code` VALUES ('610424', '   乾县');
INSERT INTO `chn_code` VALUES ('610425', '   礼泉县');
INSERT INTO `chn_code` VALUES ('610426', '   永寿县');
INSERT INTO `chn_code` VALUES ('610428', '   长武县');
INSERT INTO `chn_code` VALUES ('610429', '   旬邑县');
INSERT INTO `chn_code` VALUES ('610430', '   淳化县');
INSERT INTO `chn_code` VALUES ('610431', '   武功县');
INSERT INTO `chn_code` VALUES ('610481', '   兴平市');
INSERT INTO `chn_code` VALUES ('610482', '   彬州市');
INSERT INTO `chn_code` VALUES ('610500', ' 渭南市');
INSERT INTO `chn_code` VALUES ('610502', '   临渭区');
INSERT INTO `chn_code` VALUES ('610503', '   华州区');
INSERT INTO `chn_code` VALUES ('610522', '   潼关县');
INSERT INTO `chn_code` VALUES ('610523', '   大荔县');
INSERT INTO `chn_code` VALUES ('610524', '   合阳县');
INSERT INTO `chn_code` VALUES ('610525', '   澄城县');
INSERT INTO `chn_code` VALUES ('610526', '   蒲城县');
INSERT INTO `chn_code` VALUES ('610527', '   白水县');
INSERT INTO `chn_code` VALUES ('610528', '   富平县');
INSERT INTO `chn_code` VALUES ('610581', '   韩城市');
INSERT INTO `chn_code` VALUES ('610582', '   华阴市');
INSERT INTO `chn_code` VALUES ('610600', ' 延安市');
INSERT INTO `chn_code` VALUES ('610602', '   宝塔区');
INSERT INTO `chn_code` VALUES ('610603', '   安塞区');
INSERT INTO `chn_code` VALUES ('610621', '   延长县');
INSERT INTO `chn_code` VALUES ('610622', '   延川县');
INSERT INTO `chn_code` VALUES ('610625', '   志丹县');
INSERT INTO `chn_code` VALUES ('610626', '   吴起县');
INSERT INTO `chn_code` VALUES ('610627', '   甘泉县');
INSERT INTO `chn_code` VALUES ('610628', '   富县');
INSERT INTO `chn_code` VALUES ('610629', '   洛川县');
INSERT INTO `chn_code` VALUES ('610630', '   宜川县');
INSERT INTO `chn_code` VALUES ('610631', '   黄龙县');
INSERT INTO `chn_code` VALUES ('610632', '   黄陵县');
INSERT INTO `chn_code` VALUES ('610681', '   子长市');
INSERT INTO `chn_code` VALUES ('610700', ' 汉中市');
INSERT INTO `chn_code` VALUES ('610702', '   汉台区');
INSERT INTO `chn_code` VALUES ('610703', '   南郑区');
INSERT INTO `chn_code` VALUES ('610722', '   城固县');
INSERT INTO `chn_code` VALUES ('610723', '   洋县');
INSERT INTO `chn_code` VALUES ('610724', '   西乡县');
INSERT INTO `chn_code` VALUES ('610725', '   勉县');
INSERT INTO `chn_code` VALUES ('610726', '   宁强县');
INSERT INTO `chn_code` VALUES ('610727', '   略阳县');
INSERT INTO `chn_code` VALUES ('610728', '   镇巴县');
INSERT INTO `chn_code` VALUES ('610729', '   留坝县');
INSERT INTO `chn_code` VALUES ('610730', '   佛坪县');
INSERT INTO `chn_code` VALUES ('610800', ' 榆林市');
INSERT INTO `chn_code` VALUES ('610802', '   榆阳区');
INSERT INTO `chn_code` VALUES ('610803', '   横山区');
INSERT INTO `chn_code` VALUES ('610822', '   府谷县');
INSERT INTO `chn_code` VALUES ('610824', '   靖边县');
INSERT INTO `chn_code` VALUES ('610825', '   定边县');
INSERT INTO `chn_code` VALUES ('610826', '   绥德县');
INSERT INTO `chn_code` VALUES ('610827', '   米脂县');
INSERT INTO `chn_code` VALUES ('610828', '   佳县');
INSERT INTO `chn_code` VALUES ('610829', '   吴堡县');
INSERT INTO `chn_code` VALUES ('610830', '   清涧县');
INSERT INTO `chn_code` VALUES ('610831', '   子洲县');
INSERT INTO `chn_code` VALUES ('610881', '   神木市');
INSERT INTO `chn_code` VALUES ('610900', ' 安康市');
INSERT INTO `chn_code` VALUES ('610902', '   汉滨区');
INSERT INTO `chn_code` VALUES ('610921', '   汉阴县');
INSERT INTO `chn_code` VALUES ('610922', '   石泉县');
INSERT INTO `chn_code` VALUES ('610923', '   宁陕县');
INSERT INTO `chn_code` VALUES ('610924', '   紫阳县');
INSERT INTO `chn_code` VALUES ('610925', '   岚皋县');
INSERT INTO `chn_code` VALUES ('610926', '   平利县');
INSERT INTO `chn_code` VALUES ('610927', '   镇坪县');
INSERT INTO `chn_code` VALUES ('610928', '   旬阳县');
INSERT INTO `chn_code` VALUES ('610929', '   白河县');
INSERT INTO `chn_code` VALUES ('611000', ' 商洛市');
INSERT INTO `chn_code` VALUES ('611002', '   商州区');
INSERT INTO `chn_code` VALUES ('611021', '   洛南县');
INSERT INTO `chn_code` VALUES ('611022', '   丹凤县');
INSERT INTO `chn_code` VALUES ('611023', '   商南县');
INSERT INTO `chn_code` VALUES ('611024', '   山阳县');
INSERT INTO `chn_code` VALUES ('611025', '   镇安县');
INSERT INTO `chn_code` VALUES ('611026', '   柞水县');
INSERT INTO `chn_code` VALUES ('620000', '甘肃省');
INSERT INTO `chn_code` VALUES ('620100', ' 兰州市');
INSERT INTO `chn_code` VALUES ('620102', '   城关区');
INSERT INTO `chn_code` VALUES ('620103', '   七里河区');
INSERT INTO `chn_code` VALUES ('620104', '   西固区');
INSERT INTO `chn_code` VALUES ('620105', '   安宁区');
INSERT INTO `chn_code` VALUES ('620111', '   红古区');
INSERT INTO `chn_code` VALUES ('620121', '   永登县');
INSERT INTO `chn_code` VALUES ('620122', '   皋兰县');
INSERT INTO `chn_code` VALUES ('620123', '   榆中县');
INSERT INTO `chn_code` VALUES ('620200', ' 嘉峪关市');
INSERT INTO `chn_code` VALUES ('620300', ' 金昌市');
INSERT INTO `chn_code` VALUES ('620302', '   金川区');
INSERT INTO `chn_code` VALUES ('620321', '   永昌县');
INSERT INTO `chn_code` VALUES ('620400', ' 白银市');
INSERT INTO `chn_code` VALUES ('620402', '   白银区');
INSERT INTO `chn_code` VALUES ('620403', '   平川区');
INSERT INTO `chn_code` VALUES ('620421', '   靖远县');
INSERT INTO `chn_code` VALUES ('620422', '   会宁县');
INSERT INTO `chn_code` VALUES ('620423', '   景泰县');
INSERT INTO `chn_code` VALUES ('620500', ' 天水市');
INSERT INTO `chn_code` VALUES ('620502', '   秦州区');
INSERT INTO `chn_code` VALUES ('620503', '   麦积区');
INSERT INTO `chn_code` VALUES ('620521', '   清水县');
INSERT INTO `chn_code` VALUES ('620522', '   秦安县');
INSERT INTO `chn_code` VALUES ('620523', '   甘谷县');
INSERT INTO `chn_code` VALUES ('620524', '   武山县');
INSERT INTO `chn_code` VALUES ('620525', '   张家川回族自治县');
INSERT INTO `chn_code` VALUES ('620600', ' 武威市');
INSERT INTO `chn_code` VALUES ('620602', '   凉州区');
INSERT INTO `chn_code` VALUES ('620621', '   民勤县');
INSERT INTO `chn_code` VALUES ('620622', '   古浪县');
INSERT INTO `chn_code` VALUES ('620623', '   天祝藏族自治县');
INSERT INTO `chn_code` VALUES ('620700', ' 张掖市');
INSERT INTO `chn_code` VALUES ('620702', '   甘州区');
INSERT INTO `chn_code` VALUES ('620721', '   肃南裕固族自治县');
INSERT INTO `chn_code` VALUES ('620722', '   民乐县');
INSERT INTO `chn_code` VALUES ('620723', '   临泽县');
INSERT INTO `chn_code` VALUES ('620724', '   高台县');
INSERT INTO `chn_code` VALUES ('620725', '   山丹县');
INSERT INTO `chn_code` VALUES ('620800', ' 平凉市');
INSERT INTO `chn_code` VALUES ('620802', '   崆峒区');
INSERT INTO `chn_code` VALUES ('620821', '   泾川县');
INSERT INTO `chn_code` VALUES ('620822', '   灵台县');
INSERT INTO `chn_code` VALUES ('620823', '   崇信县');
INSERT INTO `chn_code` VALUES ('620825', '   庄浪县');
INSERT INTO `chn_code` VALUES ('620826', '   静宁县');
INSERT INTO `chn_code` VALUES ('620881', '   华亭市');
INSERT INTO `chn_code` VALUES ('620900', ' 酒泉市');
INSERT INTO `chn_code` VALUES ('620902', '   肃州区');
INSERT INTO `chn_code` VALUES ('620921', '   金塔县');
INSERT INTO `chn_code` VALUES ('620922', '   瓜州县');
INSERT INTO `chn_code` VALUES ('620923', '   肃北蒙古族自治县');
INSERT INTO `chn_code` VALUES ('620924', '   阿克塞哈萨克族自治县');
INSERT INTO `chn_code` VALUES ('620981', '   玉门市');
INSERT INTO `chn_code` VALUES ('620982', '   敦煌市');
INSERT INTO `chn_code` VALUES ('621000', ' 庆阳市');
INSERT INTO `chn_code` VALUES ('621002', '   西峰区');
INSERT INTO `chn_code` VALUES ('621021', '   庆城县');
INSERT INTO `chn_code` VALUES ('621022', '   环县');
INSERT INTO `chn_code` VALUES ('621023', '   华池县');
INSERT INTO `chn_code` VALUES ('621024', '   合水县');
INSERT INTO `chn_code` VALUES ('621025', '   正宁县');
INSERT INTO `chn_code` VALUES ('621026', '   宁县');
INSERT INTO `chn_code` VALUES ('621027', '   镇原县');
INSERT INTO `chn_code` VALUES ('621100', ' 定西市');
INSERT INTO `chn_code` VALUES ('621102', '   安定区');
INSERT INTO `chn_code` VALUES ('621121', '   通渭县');
INSERT INTO `chn_code` VALUES ('621122', '   陇西县');
INSERT INTO `chn_code` VALUES ('621123', '   渭源县');
INSERT INTO `chn_code` VALUES ('621124', '   临洮县');
INSERT INTO `chn_code` VALUES ('621125', '   漳县');
INSERT INTO `chn_code` VALUES ('621126', '   岷县');
INSERT INTO `chn_code` VALUES ('621200', ' 陇南市');
INSERT INTO `chn_code` VALUES ('621202', '   武都区');
INSERT INTO `chn_code` VALUES ('621221', '   成县');
INSERT INTO `chn_code` VALUES ('621222', '   文县');
INSERT INTO `chn_code` VALUES ('621223', '   宕昌县');
INSERT INTO `chn_code` VALUES ('621224', '   康县');
INSERT INTO `chn_code` VALUES ('621225', '   西和县');
INSERT INTO `chn_code` VALUES ('621226', '   礼县');
INSERT INTO `chn_code` VALUES ('621227', '   徽县');
INSERT INTO `chn_code` VALUES ('621228', '   两当县');
INSERT INTO `chn_code` VALUES ('622900', ' 临夏回族自治州');
INSERT INTO `chn_code` VALUES ('622901', '   临夏市');
INSERT INTO `chn_code` VALUES ('622921', '   临夏县');
INSERT INTO `chn_code` VALUES ('622922', '   康乐县');
INSERT INTO `chn_code` VALUES ('622923', '   永靖县');
INSERT INTO `chn_code` VALUES ('622924', '   广河县');
INSERT INTO `chn_code` VALUES ('622925', '   和政县');
INSERT INTO `chn_code` VALUES ('622926', '   东乡族自治县');
INSERT INTO `chn_code` VALUES ('622927', '   积石山保安族东乡族撒拉族自治县');
INSERT INTO `chn_code` VALUES ('623000', ' 甘南藏族自治州');
INSERT INTO `chn_code` VALUES ('623001', '   合作市');
INSERT INTO `chn_code` VALUES ('623021', '   临潭县');
INSERT INTO `chn_code` VALUES ('623022', '   卓尼县');
INSERT INTO `chn_code` VALUES ('623023', '   舟曲县');
INSERT INTO `chn_code` VALUES ('623024', '   迭部县');
INSERT INTO `chn_code` VALUES ('623025', '   玛曲县');
INSERT INTO `chn_code` VALUES ('623026', '   碌曲县');
INSERT INTO `chn_code` VALUES ('623027', '   夏河县');
INSERT INTO `chn_code` VALUES ('630000', '青海省');
INSERT INTO `chn_code` VALUES ('630100', ' 西宁市');
INSERT INTO `chn_code` VALUES ('630102', '   城东区');
INSERT INTO `chn_code` VALUES ('630103', '   城中区');
INSERT INTO `chn_code` VALUES ('630104', '   城西区');
INSERT INTO `chn_code` VALUES ('630105', '   城北区');
INSERT INTO `chn_code` VALUES ('630106', '   湟中区');
INSERT INTO `chn_code` VALUES ('630121', '   大通回族土族自治县');
INSERT INTO `chn_code` VALUES ('630123', '   湟源县');
INSERT INTO `chn_code` VALUES ('630200', ' 海东市');
INSERT INTO `chn_code` VALUES ('630202', '   乐都区');
INSERT INTO `chn_code` VALUES ('630203', '   平安区');
INSERT INTO `chn_code` VALUES ('630222', '   民和回族土族自治县');
INSERT INTO `chn_code` VALUES ('630223', '   互助土族自治县');
INSERT INTO `chn_code` VALUES ('630224', '   化隆回族自治县');
INSERT INTO `chn_code` VALUES ('630225', '   循化撒拉族自治县');
INSERT INTO `chn_code` VALUES ('632200', ' 海北藏族自治州');
INSERT INTO `chn_code` VALUES ('632221', '   门源回族自治县');
INSERT INTO `chn_code` VALUES ('632222', '   祁连县');
INSERT INTO `chn_code` VALUES ('632223', '   海晏县');
INSERT INTO `chn_code` VALUES ('632224', '   刚察县');
INSERT INTO `chn_code` VALUES ('632300', ' 黄南藏族自治州');
INSERT INTO `chn_code` VALUES ('632301', '   同仁市');
INSERT INTO `chn_code` VALUES ('632322', '   尖扎县');
INSERT INTO `chn_code` VALUES ('632323', '   泽库县');
INSERT INTO `chn_code` VALUES ('632324', '   河南蒙古族自治县');
INSERT INTO `chn_code` VALUES ('632500', ' 海南藏族自治州');
INSERT INTO `chn_code` VALUES ('632521', '   共和县');
INSERT INTO `chn_code` VALUES ('632522', '   同德县');
INSERT INTO `chn_code` VALUES ('632523', '   贵德县');
INSERT INTO `chn_code` VALUES ('632524', '   兴海县');
INSERT INTO `chn_code` VALUES ('632525', '   贵南县');
INSERT INTO `chn_code` VALUES ('632600', ' 果洛藏族自治州');
INSERT INTO `chn_code` VALUES ('632621', '   玛沁县');
INSERT INTO `chn_code` VALUES ('632622', '   班玛县');
INSERT INTO `chn_code` VALUES ('632623', '   甘德县');
INSERT INTO `chn_code` VALUES ('632624', '   达日县');
INSERT INTO `chn_code` VALUES ('632625', '   久治县');
INSERT INTO `chn_code` VALUES ('632626', '   玛多县');
INSERT INTO `chn_code` VALUES ('632700', ' 玉树藏族自治州');
INSERT INTO `chn_code` VALUES ('632701', '   玉树市');
INSERT INTO `chn_code` VALUES ('632722', '   杂多县');
INSERT INTO `chn_code` VALUES ('632723', '   称多县');
INSERT INTO `chn_code` VALUES ('632724', '   治多县');
INSERT INTO `chn_code` VALUES ('632725', '   囊谦县');
INSERT INTO `chn_code` VALUES ('632726', '   曲麻莱县');
INSERT INTO `chn_code` VALUES ('632800', ' 海西蒙古族藏族自治州');
INSERT INTO `chn_code` VALUES ('632801', '   格尔木市');
INSERT INTO `chn_code` VALUES ('632802', '   德令哈市');
INSERT INTO `chn_code` VALUES ('632803', '   茫崖市');
INSERT INTO `chn_code` VALUES ('632821', '   乌兰县');
INSERT INTO `chn_code` VALUES ('632822', '   都兰县');
INSERT INTO `chn_code` VALUES ('632823', '   天峻县');
INSERT INTO `chn_code` VALUES ('640000', '宁夏回族自治区');
INSERT INTO `chn_code` VALUES ('640100', ' 银川市');
INSERT INTO `chn_code` VALUES ('640104', '   兴庆区');
INSERT INTO `chn_code` VALUES ('640105', '   西夏区');
INSERT INTO `chn_code` VALUES ('640106', '   金凤区');
INSERT INTO `chn_code` VALUES ('640121', '   永宁县');
INSERT INTO `chn_code` VALUES ('640122', '   贺兰县');
INSERT INTO `chn_code` VALUES ('640181', '   灵武市');
INSERT INTO `chn_code` VALUES ('640200', ' 石嘴山市');
INSERT INTO `chn_code` VALUES ('640202', '   大武口区');
INSERT INTO `chn_code` VALUES ('640205', '   惠农区');
INSERT INTO `chn_code` VALUES ('640221', '   平罗县');
INSERT INTO `chn_code` VALUES ('640300', ' 吴忠市');
INSERT INTO `chn_code` VALUES ('640302', '   利通区');
INSERT INTO `chn_code` VALUES ('640303', '   红寺堡区');
INSERT INTO `chn_code` VALUES ('640323', '   盐池县');
INSERT INTO `chn_code` VALUES ('640324', '   同心县');
INSERT INTO `chn_code` VALUES ('640381', '   青铜峡市');
INSERT INTO `chn_code` VALUES ('640400', ' 固原市');
INSERT INTO `chn_code` VALUES ('640402', '   原州区');
INSERT INTO `chn_code` VALUES ('640422', '   西吉县');
INSERT INTO `chn_code` VALUES ('640423', '   隆德县');
INSERT INTO `chn_code` VALUES ('640424', '   泾源县');
INSERT INTO `chn_code` VALUES ('640425', '   彭阳县');
INSERT INTO `chn_code` VALUES ('640500', ' 中卫市');
INSERT INTO `chn_code` VALUES ('640502', '   沙坡头区');
INSERT INTO `chn_code` VALUES ('640521', '   中宁县');
INSERT INTO `chn_code` VALUES ('640522', '   海原县');
INSERT INTO `chn_code` VALUES ('650000', '新疆维吾尔自治区');
INSERT INTO `chn_code` VALUES ('650100', ' 乌鲁木齐市');
INSERT INTO `chn_code` VALUES ('650102', '   天山区');
INSERT INTO `chn_code` VALUES ('650103', '   沙依巴克区');
INSERT INTO `chn_code` VALUES ('650104', '   新市区');
INSERT INTO `chn_code` VALUES ('650105', '   水磨沟区');
INSERT INTO `chn_code` VALUES ('650106', '   头屯河区');
INSERT INTO `chn_code` VALUES ('650107', '   达坂城区');
INSERT INTO `chn_code` VALUES ('650109', '   米东区');
INSERT INTO `chn_code` VALUES ('650121', '   乌鲁木齐县');
INSERT INTO `chn_code` VALUES ('650200', ' 克拉玛依市');
INSERT INTO `chn_code` VALUES ('650202', '   独山子区');
INSERT INTO `chn_code` VALUES ('650203', '   克拉玛依区');
INSERT INTO `chn_code` VALUES ('650204', '   白碱滩区');
INSERT INTO `chn_code` VALUES ('650205', '   乌尔禾区');
INSERT INTO `chn_code` VALUES ('650400', ' 吐鲁番市');
INSERT INTO `chn_code` VALUES ('650402', '   高昌区');
INSERT INTO `chn_code` VALUES ('650421', '   鄯善县');
INSERT INTO `chn_code` VALUES ('650422', '   托克逊县');
INSERT INTO `chn_code` VALUES ('650500', ' 哈密市');
INSERT INTO `chn_code` VALUES ('650502', '   伊州区');
INSERT INTO `chn_code` VALUES ('650521', '   巴里坤哈萨克自治县');
INSERT INTO `chn_code` VALUES ('650522', '   伊吾县');
INSERT INTO `chn_code` VALUES ('652300', ' 昌吉回族自治州');
INSERT INTO `chn_code` VALUES ('652301', '   昌吉市');
INSERT INTO `chn_code` VALUES ('652302', '   阜康市');
INSERT INTO `chn_code` VALUES ('652323', '   呼图壁县');
INSERT INTO `chn_code` VALUES ('652324', '   玛纳斯县');
INSERT INTO `chn_code` VALUES ('652325', '   奇台县');
INSERT INTO `chn_code` VALUES ('652327', '   吉木萨尔县');
INSERT INTO `chn_code` VALUES ('652328', '   木垒哈萨克自治县');
INSERT INTO `chn_code` VALUES ('652700', ' 博尔塔拉蒙古自治州');
INSERT INTO `chn_code` VALUES ('652701', '   博乐市');
INSERT INTO `chn_code` VALUES ('652702', '   阿拉山口市');
INSERT INTO `chn_code` VALUES ('652722', '   精河县');
INSERT INTO `chn_code` VALUES ('652723', '   温泉县');
INSERT INTO `chn_code` VALUES ('652800', ' 巴音郭楞蒙古自治州');
INSERT INTO `chn_code` VALUES ('652801', '   库尔勒市');
INSERT INTO `chn_code` VALUES ('652822', '   轮台县');
INSERT INTO `chn_code` VALUES ('652823', '   尉犁县');
INSERT INTO `chn_code` VALUES ('652824', '   若羌县');
INSERT INTO `chn_code` VALUES ('652825', '   且末县');
INSERT INTO `chn_code` VALUES ('652826', '   焉耆回族自治县');
INSERT INTO `chn_code` VALUES ('652827', '   和静县');
INSERT INTO `chn_code` VALUES ('652828', '   和硕县');
INSERT INTO `chn_code` VALUES ('652829', '   博湖县');
INSERT INTO `chn_code` VALUES ('652900', ' 阿克苏地区');
INSERT INTO `chn_code` VALUES ('652901', '   阿克苏市');
INSERT INTO `chn_code` VALUES ('652902', '   库车市');
INSERT INTO `chn_code` VALUES ('652922', '   温宿县');
INSERT INTO `chn_code` VALUES ('652924', '   沙雅县');
INSERT INTO `chn_code` VALUES ('652925', '   新和县');
INSERT INTO `chn_code` VALUES ('652926', '   拜城县');
INSERT INTO `chn_code` VALUES ('652927', '   乌什县');
INSERT INTO `chn_code` VALUES ('652928', '   阿瓦提县');
INSERT INTO `chn_code` VALUES ('652929', '   柯坪县');
INSERT INTO `chn_code` VALUES ('653000', ' 克孜勒苏柯尔克孜自治州');
INSERT INTO `chn_code` VALUES ('653001', '   阿图什市');
INSERT INTO `chn_code` VALUES ('653022', '   阿克陶县');
INSERT INTO `chn_code` VALUES ('653023', '   阿合奇县');
INSERT INTO `chn_code` VALUES ('653024', '   乌恰县');
INSERT INTO `chn_code` VALUES ('653100', ' 喀什地区');
INSERT INTO `chn_code` VALUES ('653101', '   喀什市');
INSERT INTO `chn_code` VALUES ('653121', '   疏附县');
INSERT INTO `chn_code` VALUES ('653122', '   疏勒县');
INSERT INTO `chn_code` VALUES ('653123', '   英吉沙县');
INSERT INTO `chn_code` VALUES ('653124', '   泽普县');
INSERT INTO `chn_code` VALUES ('653125', '   莎车县');
INSERT INTO `chn_code` VALUES ('653126', '   叶城县');
INSERT INTO `chn_code` VALUES ('653127', '   麦盖提县');
INSERT INTO `chn_code` VALUES ('653128', '   岳普湖县');
INSERT INTO `chn_code` VALUES ('653129', '   伽师县');
INSERT INTO `chn_code` VALUES ('653130', '   巴楚县');
INSERT INTO `chn_code` VALUES ('653131', '   塔什库尔干塔吉克自治县');
INSERT INTO `chn_code` VALUES ('653200', ' 和田地区');
INSERT INTO `chn_code` VALUES ('653201', '   和田市');
INSERT INTO `chn_code` VALUES ('653221', '   和田县');
INSERT INTO `chn_code` VALUES ('653222', '   墨玉县');
INSERT INTO `chn_code` VALUES ('653223', '   皮山县');
INSERT INTO `chn_code` VALUES ('653224', '   洛浦县');
INSERT INTO `chn_code` VALUES ('653225', '   策勒县');
INSERT INTO `chn_code` VALUES ('653226', '   于田县');
INSERT INTO `chn_code` VALUES ('653227', '   民丰县');
INSERT INTO `chn_code` VALUES ('654000', ' 伊犁哈萨克自治州');
INSERT INTO `chn_code` VALUES ('654002', '   伊宁市');
INSERT INTO `chn_code` VALUES ('654003', '   奎屯市');
INSERT INTO `chn_code` VALUES ('654004', '   霍尔果斯市');
INSERT INTO `chn_code` VALUES ('654021', '   伊宁县');
INSERT INTO `chn_code` VALUES ('654022', '   察布查尔锡伯自治县');
INSERT INTO `chn_code` VALUES ('654023', '   霍城县');
INSERT INTO `chn_code` VALUES ('654024', '   巩留县');
INSERT INTO `chn_code` VALUES ('654025', '   新源县');
INSERT INTO `chn_code` VALUES ('654026', '   昭苏县');
INSERT INTO `chn_code` VALUES ('654027', '   特克斯县');
INSERT INTO `chn_code` VALUES ('654028', '   尼勒克县');
INSERT INTO `chn_code` VALUES ('654200', ' 塔城地区');
INSERT INTO `chn_code` VALUES ('654201', '   塔城市');
INSERT INTO `chn_code` VALUES ('654202', '   乌苏市');
INSERT INTO `chn_code` VALUES ('654221', '   额敏县');
INSERT INTO `chn_code` VALUES ('654223', '   沙湾县');
INSERT INTO `chn_code` VALUES ('654224', '   托里县');
INSERT INTO `chn_code` VALUES ('654225', '   裕民县');
INSERT INTO `chn_code` VALUES ('654226', '   和布克赛尔蒙古自治县');
INSERT INTO `chn_code` VALUES ('654300', ' 阿勒泰地区');
INSERT INTO `chn_code` VALUES ('654301', '   阿勒泰市');
INSERT INTO `chn_code` VALUES ('654321', '   布尔津县');
INSERT INTO `chn_code` VALUES ('654322', '   富蕴县');
INSERT INTO `chn_code` VALUES ('654323', '   福海县');
INSERT INTO `chn_code` VALUES ('654324', '   哈巴河县');
INSERT INTO `chn_code` VALUES ('654325', '   青河县');
INSERT INTO `chn_code` VALUES ('654326', '   吉木乃县');
INSERT INTO `chn_code` VALUES ('659001', '   石河子市');
INSERT INTO `chn_code` VALUES ('659002', '   阿拉尔市');
INSERT INTO `chn_code` VALUES ('659003', '   图木舒克市');
INSERT INTO `chn_code` VALUES ('659004', '   五家渠市');
INSERT INTO `chn_code` VALUES ('659005', '   北屯市');
INSERT INTO `chn_code` VALUES ('659006', '   铁门关市');
INSERT INTO `chn_code` VALUES ('659007', '   双河市');
INSERT INTO `chn_code` VALUES ('659008', '   可克达拉市');
INSERT INTO `chn_code` VALUES ('659009', '   昆玉市');
INSERT INTO `chn_code` VALUES ('659010', '   胡杨河市');
INSERT INTO `chn_code` VALUES ('710000', '台湾省');
INSERT INTO `chn_code` VALUES ('810000', '香港特别行政区');
INSERT INTO `chn_code` VALUES ('820000', '澳门特别行政区');

SET FOREIGN_KEY_CHECKS = 1;