省份

https://blog.csdn.net/weixin_30521649/article/details/101921205

https://www.cnblogs.com/laowenBlog/p/11290486.html

/*
Navicat MySQL Data Transfer

Source Server         : 本机
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : region

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

Date: 2019-07-22 14:51:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for region_city
-- ----------------------------
DROP TABLE IF EXISTS `region_city`;
CREATE TABLE `region_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `parentId` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3442 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of region_city
-- ----------------------------
INSERT INTO `region_city` VALUES ('1', '110000', '北京市', '0');
INSERT INTO `region_city` VALUES ('2', '110101', '东城区', '1');
INSERT INTO `region_city` VALUES ('3', '110102', '西城区', '1');
INSERT INTO `region_city` VALUES ('4', '110105', '朝阳区', '1');
INSERT INTO `region_city` VALUES ('5', '110106', '丰台区', '1');
INSERT INTO `region_city` VALUES ('6', '110107', '石景山区', '1');
INSERT INTO `region_city` VALUES ('7', '110108', '海淀区', '1');
INSERT INTO `region_city` VALUES ('8', '110109', '门头沟区', '1');
INSERT INTO `region_city` VALUES ('9', '110111', '房山区', '1');
INSERT INTO `region_city` VALUES ('10', '110112', '通州区', '1');
INSERT INTO `region_city` VALUES ('11', '110113', '顺义区', '1');
INSERT INTO `region_city` VALUES ('12', '110114', '昌平区', '1');
INSERT INTO `region_city` VALUES ('13', '110115', '大兴区', '1');
INSERT INTO `region_city` VALUES ('14', '110116', '怀柔区', '1');
INSERT INTO `region_city` VALUES ('15', '110117', '平谷区', '1');
INSERT INTO `region_city` VALUES ('16', '110118', '密云区', '1');
INSERT INTO `region_city` VALUES ('17', '110119', '延庆区', '1');
INSERT INTO `region_city` VALUES ('18', '120000', '天津市', '0');
INSERT INTO `region_city` VALUES ('19', '120101', '和平区', '18');
INSERT INTO `region_city` VALUES ('20', '120102', '河东区', '18');
INSERT INTO `region_city` VALUES ('21', '120103', '河西区', '18');
INSERT INTO `region_city` VALUES ('22', '120104', '南开区', '18');
INSERT INTO `region_city` VALUES ('23', '120105', '河北区', '18');
INSERT INTO `region_city` VALUES ('24', '120106', '红桥区', '18');
INSERT INTO `region_city` VALUES ('25', '120110', '东丽区', '18');
INSERT INTO `region_city` VALUES ('26', '120111', '西青区', '18');
INSERT INTO `region_city` VALUES ('27', '120112', '津南区', '18');
INSERT INTO `region_city` VALUES ('28', '120113', '北辰区', '18');
INSERT INTO `region_city` VALUES ('29', '120114', '武清区', '18');
INSERT INTO `region_city` VALUES ('30', '120115', '宝坻区', '18');
INSERT INTO `region_city` VALUES ('31', '120116', '滨海新区', '18');
INSERT INTO `region_city` VALUES ('32', '120117', '宁河区', '18');
INSERT INTO `region_city` VALUES ('33', '120118', '静海区', '18');
INSERT INTO `region_city` VALUES ('34', '120119', '蓟州区', '18');
INSERT INTO `region_city` VALUES ('35', '130000', '河北省', '0');
INSERT INTO `region_city` VALUES ('36', '130100', '石家庄市', '35');
INSERT INTO `region_city` VALUES ('37', '130102', '长安区', '36');
INSERT INTO `region_city` VALUES ('38', '130104', '桥西区', '36');
INSERT INTO `region_city` VALUES ('39', '130105', '新华区', '36');
INSERT INTO `region_city` VALUES ('40', '130107', '井陉矿区', '36');
INSERT INTO `region_city` VALUES ('41', '130108', '裕华区', '36');
INSERT INTO `region_city` VALUES ('42', '130109', '藁城区', '36');
INSERT INTO `region_city` VALUES ('43', '130110', '鹿泉区', '36');
INSERT INTO `region_city` VALUES ('44', '130111', '栾城区', '36');
INSERT INTO `region_city` VALUES ('45', '130121', '井陉县', '36');
INSERT INTO `region_city` VALUES ('46', '130123', '正定县', '36');
INSERT INTO `region_city` VALUES ('47', '130125', '行唐县', '36');
INSERT INTO `region_city` VALUES ('48', '130126', '灵寿县', '36');
INSERT INTO `region_city` VALUES ('49', '130127', '高邑县', '36');
INSERT INTO `region_city` VALUES ('50', '130128', '深泽县', '36');
INSERT INTO `region_city` VALUES ('51', '130129', '赞皇县', '36');
INSERT INTO `region_city` VALUES ('52', '130130', '无极县', '36');
INSERT INTO `region_city` VALUES ('53', '130131', '平山县', '36');
INSERT INTO `region_city` VALUES ('54', '130132', '元氏县', '36');
INSERT INTO `region_city` VALUES ('55', '130133', '赵县', '36');
INSERT INTO `region_city` VALUES ('56', '130181', '辛集市', '36');
INSERT INTO `region_city` VALUES ('57', '130183', '晋州市', '36');
INSERT INTO `region_city` VALUES ('58', '130184', '新乐市', '36');
INSERT INTO `region_city` VALUES ('59', '130200', '唐山市', '35');
INSERT INTO `region_city` VALUES ('60', '130202', '路南区', '59');
INSERT INTO `region_city` VALUES ('61', '130203', '路北区', '59');
INSERT INTO `region_city` VALUES ('62', '130204', '古冶区', '59');
INSERT INTO `region_city` VALUES ('63', '130205', '开平区', '59');
INSERT INTO `region_city` VALUES ('64', '130207', '丰南区', '59');
INSERT INTO `region_city` VALUES ('65', '130208', '丰润区', '59');
INSERT INTO `region_city` VALUES ('66', '130209', '曹妃甸区', '59');
INSERT INTO `region_city` VALUES ('67', '130223', '滦县', '59');
INSERT INTO `region_city` VALUES ('68', '130224', '滦南县', '59');
INSERT INTO `region_city` VALUES ('69', '130225', '乐亭县', '59');
INSERT INTO `region_city` VALUES ('70', '130227', '迁西县', '59');
INSERT INTO `region_city` VALUES ('71', '130229', '玉田县', '59');
INSERT INTO `region_city` VALUES ('72', '130281', '遵化市', '59');
INSERT INTO `region_city` VALUES ('73', '130283', '迁安市', '59');
INSERT INTO `region_city` VALUES ('74', '130300', '秦皇岛市', '35');
INSERT INTO `region_city` VALUES ('75', '130302', '海港区', '74');
INSERT INTO `region_city` VALUES ('76', '130303', '山海关区', '74');
INSERT INTO `region_city` VALUES ('77', '130304', '北戴河区', '74');
INSERT INTO `region_city` VALUES ('78', '130306', '抚宁区', '74');
INSERT INTO `region_city` VALUES ('79', '130321', '青龙满族自治县', '74');
INSERT INTO `region_city` VALUES ('80', '130322', '昌黎县', '74');
INSERT INTO `region_city` VALUES ('81', '130324', '卢龙县', '74');
INSERT INTO `region_city` VALUES ('82', '130400', '邯郸市', '35');
INSERT INTO `region_city` VALUES ('83', '130402', '邯山区', '82');
INSERT INTO `region_city` VALUES ('84', '130403', '丛台区', '82');
INSERT INTO `region_city` VALUES ('85', '130404', '复兴区', '82');
INSERT INTO `region_city` VALUES ('86', '130406', '峰峰矿区', '82');
INSERT INTO `region_city` VALUES ('87', '130407', '肥乡区', '82');
INSERT INTO `region_city` VALUES ('88', '130408', '永年区', '82');
INSERT INTO `region_city` VALUES ('89', '130423', '临漳县', '82');
INSERT INTO `region_city` VALUES ('90', '130424', '成安县', '82');
INSERT INTO `region_city` VALUES ('91', '130425', '大名县', '82');
INSERT INTO `region_city` VALUES ('92', '130426', '涉县', '82');
INSERT INTO `region_city` VALUES ('93', '130427', '磁县', '82');
INSERT INTO `region_city` VALUES ('94', '130430', '邱县', '82');
INSERT INTO `region_city` VALUES ('95', '130431', '鸡泽县', '82');
INSERT INTO `region_city` VALUES ('96', '130432', '广平县', '82');
INSERT INTO `region_city` VALUES ('97', '130433', '馆陶县', '82');
INSERT INTO `region_city` VALUES ('98', '130434', '魏县', '82');
INSERT INTO `region_city` VALUES ('99', '130435', '曲周县', '82');
INSERT INTO `region_city` VALUES ('100', '130481', '武安市', '82');
INSERT INTO `region_city` VALUES ('101', '130500', '邢台市', '35');
INSERT INTO `region_city` VALUES ('102', '130502', '桥东区', '101');
INSERT INTO `region_city` VALUES ('103', '130503', '桥西区', '101');
INSERT INTO `region_city` VALUES ('104', '130521', '邢台县', '101');
INSERT INTO `region_city` VALUES ('105', '130522', '临城县', '101');
INSERT INTO `region_city` VALUES ('106', '130523', '内丘县', '101');
INSERT INTO `region_city` VALUES ('107', '130524', '柏乡县', '101');
INSERT INTO `region_city` VALUES ('108', '130525', '隆尧县', '101');
INSERT INTO `region_city` VALUES ('109', '130526', '任县', '101');
INSERT INTO `region_city` VALUES ('110', '130527', '南和县', '101');
INSERT INTO `region_city` VALUES ('111', '130528', '宁晋县', '101');
INSERT INTO `region_city` VALUES ('112', '130529', '巨鹿县', '101');
INSERT INTO `region_city` VALUES ('113', '130530', '新河县', '101');
INSERT INTO `region_city` VALUES ('114', '130531', '广宗县', '101');
INSERT INTO `region_city` VALUES ('115', '130532', '平乡县', '101');
INSERT INTO `region_city` VALUES ('116', '130533', '威县', '101');
INSERT INTO `region_city` VALUES ('117', '130534', '清河县', '101');
INSERT INTO `region_city` VALUES ('118', '130535', '临西县', '101');
INSERT INTO `region_city` VALUES ('119', '130581', '南宫市', '101');
INSERT INTO `region_city` VALUES ('120', '130582', '沙河市', '101');
INSERT INTO `region_city` VALUES ('121', '130600', '保定市', '35');
INSERT INTO `region_city` VALUES ('122', '130602', '竞秀区', '121');
INSERT INTO `region_city` VALUES ('123', '130606', '莲池区', '121');
INSERT INTO `region_city` VALUES ('124', '130607', '满城区', '121');
INSERT INTO `region_city` VALUES ('125', '130608', '清苑区', '121');
INSERT INTO `region_city` VALUES ('126', '130609', '徐水区', '121');
INSERT INTO `region_city` VALUES ('127', '130623', '涞水县', '121');
INSERT INTO `region_city` VALUES ('128', '130624', '阜平县', '121');
INSERT INTO `region_city` VALUES ('129', '130626', '定兴县', '121');
INSERT INTO `region_city` VALUES ('130', '130627', '唐县', '121');
INSERT INTO `region_city` VALUES ('131', '130628', '高阳县', '121');
INSERT INTO `region_city` VALUES ('132', '130629', '容城县', '121');
INSERT INTO `region_city` VALUES ('133', '130630', '涞源县', '121');
INSERT INTO `region_city` VALUES ('134', '130631', '望都县', '121');
INSERT INTO `region_city` VALUES ('135', '130632', '安新县', '121');
INSERT INTO `region_city` VALUES ('136', '130633', '易县', '121');
INSERT INTO `region_city` VALUES ('137', '130634', '曲阳县', '121');
INSERT INTO `region_city` VALUES ('138', '130635', '蠡县', '121');
INSERT INTO `region_city` VALUES ('139', '130636', '顺平县', '121');
INSERT INTO `region_city` VALUES ('140', '130637', '博野县', '121');
INSERT INTO `region_city` VALUES ('141', '130638', '雄县', '121');
INSERT INTO `region_city` VALUES ('142', '130681', '涿州市', '121');
INSERT INTO `region_city` VALUES ('143', '130682', '定州市', '121');
INSERT INTO `region_city` VALUES ('144', '130683', '安国市', '121');
INSERT INTO `region_city` VALUES ('145', '130684', '高碑店市', '121');
INSERT INTO `region_city` VALUES ('146', '130700', '张家口市', '35');
INSERT INTO `region_city` VALUES ('147', '130702', '桥东区', '146');
INSERT INTO `region_city` VALUES ('148', '130703', '桥西区', '146');
INSERT INTO `region_city` VALUES ('149', '130705', '宣化区', '146');
INSERT INTO `region_city` VALUES ('150', '130706', '下花园区', '146');
INSERT INTO `region_city` VALUES ('151', '130708', '万全区', '146');
INSERT INTO `region_city` VALUES ('152', '130709', '崇礼区', '146');
INSERT INTO `region_city` VALUES ('153', '130722', '张北县', '146');
INSERT INTO `region_city` VALUES ('154', '130723', '康保县', '146');
INSERT INTO `region_city` VALUES ('155', '130724', '沽源县', '146');
INSERT INTO `region_city` VALUES ('156', '130725', '尚义县', '146');
INSERT INTO `region_city` VALUES ('157', '130726', '蔚县', '146');
INSERT INTO `region_city` VALUES ('158', '130727', '阳原县', '146');
INSERT INTO `region_city` VALUES ('159', '130728', '怀安县', '146');
INSERT INTO `region_city` VALUES ('160', '130730', '怀来县', '146');
INSERT INTO `region_city` VALUES ('161', '130731', '涿鹿县', '146');
INSERT INTO `region_city` VALUES ('162', '130732', '赤城县', '146');
INSERT INTO `region_city` VALUES ('163', '130800', '承德市', '35');
INSERT INTO `region_city` VALUES ('164', '130802', '双桥区', '163');
INSERT INTO `region_city` VALUES ('165', '130803', '双滦区', '163');
INSERT INTO `region_city` VALUES ('166', '130804', '鹰手营子矿区', '163');
INSERT INTO `region_city` VALUES ('167', '130821', '承德县', '163');
INSERT INTO `region_city` VALUES ('168', '130822', '兴隆县', '163');
INSERT INTO `region_city` VALUES ('169', '130824', '滦平县', '163');
INSERT INTO `region_city` VALUES ('170', '130825', '隆化县', '163');
INSERT INTO `region_city` VALUES ('171', '130826', '丰宁满族自治县', '163');
INSERT INTO `region_city` VALUES ('172', '130827', '宽城满族自治县', '163');
INSERT INTO `region_city` VALUES ('173', '130828', '围场满族蒙古族自治县', '163');
INSERT INTO `region_city` VALUES ('174', '130881', '平泉市', '163');
INSERT INTO `region_city` VALUES ('175', '130900', '沧州市', '35');
INSERT INTO `region_city` VALUES ('176', '130902', '新华区', '175');
INSERT INTO `region_city` VALUES ('177', '130903', '运河区', '175');
INSERT INTO `region_city` VALUES ('178', '130921', '沧县', '175');
INSERT INTO `region_city` VALUES ('179', '130922', '青县', '175');
INSERT INTO `region_city` VALUES ('180', '130923', '东光县', '175');
INSERT INTO `region_city` VALUES ('181', '130924', '海兴县', '175');
INSERT INTO `region_city` VALUES ('182', '130925', '盐山县', '175');
INSERT INTO `region_city` VALUES ('183', '130926', '肃宁县', '175');
INSERT INTO `region_city` VALUES ('184', '130927', '南皮县', '175');
INSERT INTO `region_city` VALUES ('185', '130928', '吴桥县', '175');
INSERT INTO `region_city` VALUES ('186', '130929', '献县', '175');
INSERT INTO `region_city` VALUES ('187', '130930', '孟村回族自治县', '175');
INSERT INTO `region_city` VALUES ('188', '130981', '泊头市', '175');
INSERT INTO `region_city` VALUES ('189', '130982', '任丘市', '175');
INSERT INTO `region_city` VALUES ('190', '130983', '黄骅市', '175');
INSERT INTO `region_city` VALUES ('191', '130984', '河间市', '175');
INSERT INTO `region_city` VALUES ('192', '131000', '廊坊市', '35');
INSERT INTO `region_city` VALUES ('193', '131002', '安次区', '192');
INSERT INTO `region_city` VALUES ('194', '131003', '广阳区', '192');
INSERT INTO `region_city` VALUES ('195', '131022', '固安县', '192');
INSERT INTO `region_city` VALUES ('196', '131023', '永清县', '192');
INSERT INTO `region_city` VALUES ('197', '131024', '香河县', '192');
INSERT INTO `region_city` VALUES ('198', '131025', '大城县', '192');
INSERT INTO `region_city` VALUES ('199', '131026', '文安县', '192');
INSERT INTO `region_city` VALUES ('200', '131028', '大厂回族自治县', '192');
INSERT INTO `region_city` VALUES ('201', '131081', '霸州市', '192');
INSERT INTO `region_city` VALUES ('202', '131082', '三河市', '192');
INSERT INTO `region_city` VALUES ('203', '131100', '衡水市', '35');
INSERT INTO `region_city` VALUES ('204', '131102', '桃城区', '203');
INSERT INTO `region_city` VALUES ('205', '131103', '冀州区', '203');
INSERT INTO `region_city` VALUES ('206', '131121', '枣强县', '203');
INSERT INTO `region_city` VALUES ('207', '131122', '武邑县', '203');
INSERT INTO `region_city` VALUES ('208', '131123', '武强县', '203');
INSERT INTO `region_city` VALUES ('209', '131124', '饶阳县', '203');
INSERT INTO `region_city` VALUES ('210', '131125', '安平县', '203');
INSERT INTO `region_city` VALUES ('211', '131126', '故城县', '203');
INSERT INTO `region_city` VALUES ('212', '131127', '景县', '203');
INSERT INTO `region_city` VALUES ('213', '131128', '阜城县', '203');
INSERT INTO `region_city` VALUES ('214', '131182', '深州市', '203');
INSERT INTO `region_city` VALUES ('215', '140000', '山西省', '0');
INSERT INTO `region_city` VALUES ('216', '140100', '太原市', '215');
INSERT INTO `region_city` VALUES ('217', '140105', '小店区', '216');
INSERT INTO `region_city` VALUES ('218', '140106', '迎泽区', '216');
INSERT INTO `region_city` VALUES ('219', '140107', '杏花岭区', '216');
INSERT INTO `region_city` VALUES ('220', '140108', '尖草坪区', '216');
INSERT INTO `region_city` VALUES ('221', '140109', '万柏林区', '216');
INSERT INTO `region_city` VALUES ('222', '140110', '晋源区', '216');
INSERT INTO `region_city` VALUES ('223', '140121', '清徐县', '216');
INSERT INTO `region_city` VALUES ('224', '140122', '阳曲县', '216');
INSERT INTO `region_city` VALUES ('225', '140123', '娄烦县', '216');
INSERT INTO `region_city` VALUES ('226', '140181', '古交市', '216');
INSERT INTO `region_city` VALUES ('227', '140200', '大同市', '215');
INSERT INTO `region_city` VALUES ('228', '140202', '城区', '227');
INSERT INTO `region_city` VALUES ('229', '140203', '矿区', '227');
INSERT INTO `region_city` VALUES ('230', '140211', '南郊区', '227');
INSERT INTO `region_city` VALUES ('231', '140212', '新荣区', '227');
INSERT INTO `region_city` VALUES ('232', '140221', '阳高县', '227');
INSERT INTO `region_city` VALUES ('233', '140222', '天镇县', '227');
INSERT INTO `region_city` VALUES ('234', '140223', '广灵县', '227');
INSERT INTO `region_city` VALUES ('235', '140224', '灵丘县', '227');
INSERT INTO `region_city` VALUES ('236', '140225', '浑源县', '227');
INSERT INTO `region_city` VALUES ('237', '140226', '左云县', '227');
INSERT INTO `region_city` VALUES ('238', '140227', '大同县', '227');
INSERT INTO `region_city` VALUES ('239', '140300', '阳泉市', '215');
INSERT INTO `region_city` VALUES ('240', '140302', '城区', '239');
INSERT INTO `region_city` VALUES ('241', '140303', '矿区', '239');
INSERT INTO `region_city` VALUES ('242', '140311', '郊区', '239');
INSERT INTO `region_city` VALUES ('243', '140321', '平定县', '239');
INSERT INTO `region_city` VALUES ('244', '140322', '盂县', '239');
INSERT INTO `region_city` VALUES ('245', '140400', '长治市', '215');
INSERT INTO `region_city` VALUES ('246', '140402', '城区', '245');
INSERT INTO `region_city` VALUES ('247', '140411', '郊区', '245');
INSERT INTO `region_city` VALUES ('248', '140421', '长治县', '245');
INSERT INTO `region_city` VALUES ('249', '140423', '襄垣县', '245');
INSERT INTO `region_city` VALUES ('250', '140424', '屯留县', '245');
INSERT INTO `region_city` VALUES ('251', '140425', '平顺县', '245');
INSERT INTO `region_city` VALUES ('252', '140426', '黎城县', '245');
INSERT INTO `region_city` VALUES ('253', '140427', '壶关县', '245');
INSERT INTO `region_city` VALUES ('254', '140428', '长子县', '245');
INSERT INTO `region_city` VALUES ('255', '140429', '武乡县', '245');
INSERT INTO `region_city` VALUES ('256', '140430', '沁县', '245');
INSERT INTO `region_city` VALUES ('257', '140431', '沁源县', '245');
INSERT INTO `region_city` VALUES ('258', '140481', '潞城市', '245');
INSERT INTO `region_city` VALUES ('259', '140500', '晋城市', '215');
INSERT INTO `region_city` VALUES ('260', '140502', '城区', '259');
INSERT INTO `region_city` VALUES ('261', '140521', '沁水县', '259');
INSERT INTO `region_city` VALUES ('262', '140522', '阳城县', '259');
INSERT INTO `region_city` VALUES ('263', '140524', '陵川县', '259');
INSERT INTO `region_city` VALUES ('264', '140525', '泽州县', '259');
INSERT INTO `region_city` VALUES ('265', '140581', '高平市', '259');
INSERT INTO `region_city` VALUES ('266', '140600', '朔州市', '215');
INSERT INTO `region_city` VALUES ('267', '140602', '朔城区', '266');
INSERT INTO `region_city` VALUES ('268', '140603', '平鲁区', '266');
INSERT INTO `region_city` VALUES ('269', '140621', '山阴县', '266');
INSERT INTO `region_city` VALUES ('270', '140622', '应县', '266');
INSERT INTO `region_city` VALUES ('271', '140623', '右玉县', '266');
INSERT INTO `region_city` VALUES ('272', '140624', '怀仁县', '266');
INSERT INTO `region_city` VALUES ('273', '140700', '晋中市', '215');
INSERT INTO `region_city` VALUES ('274', '140702', '榆次区', '273');
INSERT INTO `region_city` VALUES ('275', '140721', '榆社县', '273');
INSERT INTO `region_city` VALUES ('276', '140722', '左权县', '273');
INSERT INTO `region_city` VALUES ('277', '140723', '和顺县', '273');
INSERT INTO `region_city` VALUES ('278', '140724', '昔阳县', '273');
INSERT INTO `region_city` VALUES ('279', '140725', '寿阳县', '273');
INSERT INTO `region_city` VALUES ('280', '140726', '太谷县', '273');
INSERT INTO `region_city` VALUES ('281', '140727', '祁县', '273');
INSERT INTO `region_city` VALUES ('282', '140728', '平遥县', '273');
INSERT INTO `region_city` VALUES ('283', '140729', '灵石县', '273');
INSERT INTO `region_city` VALUES ('284', '140781', '介休市', '273');
INSERT INTO `region_city` VALUES ('285', '140800', '运城市', '215');
INSERT INTO `region_city` VALUES ('286', '140802', '盐湖区', '285');
INSERT INTO `region_city` VALUES ('287', '140821', '临猗县', '285');
INSERT INTO `region_city` VALUES ('288', '140822', '万荣县', '285');
INSERT INTO `region_city` VALUES ('289', '140823', '闻喜县', '285');
INSERT INTO `region_city` VALUES ('290', '140824', '稷山县', '285');
INSERT INTO `region_city` VALUES ('291', '140825', '新绛县', '285');
INSERT INTO `region_city` VALUES ('292', '140826', '绛县', '285');
INSERT INTO `region_city` VALUES ('293', '140827', '垣曲县', '285');
INSERT INTO `region_city` VALUES ('294', '140828', '夏县', '285');
INSERT INTO `region_city` VALUES ('295', '140829', '平陆县', '285');
INSERT INTO `region_city` VALUES ('296', '140830', '芮城县', '285');
INSERT INTO `region_city` VALUES ('297', '140881', '永济市', '285');
INSERT INTO `region_city` VALUES ('298', '140882', '河津市', '285');
INSERT INTO `region_city` VALUES ('299', '140900', '忻州市', '215');
INSERT INTO `region_city` VALUES ('300', '140902', '忻府区', '299');
INSERT INTO `region_city` VALUES ('301', '140921', '定襄县', '299');
INSERT INTO `region_city` VALUES ('302', '140922', '五台县', '299');
INSERT INTO `region_city` VALUES ('303', '140923', '代县', '299');
INSERT INTO `region_city` VALUES ('304', '140924', '繁峙县', '299');
INSERT INTO `region_city` VALUES ('305', '140925', '宁武县', '299');
INSERT INTO `region_city` VALUES ('306', '140926', '静乐县', '299');
INSERT INTO `region_city` VALUES ('307', '140927', '神池县', '299');
INSERT INTO `region_city` VALUES ('308', '140928', '五寨县', '299');
INSERT INTO `region_city` VALUES ('309', '140929', '岢岚县', '299');
INSERT INTO `region_city` VALUES ('310', '140930', '河曲县', '299');
INSERT INTO `region_city` VALUES ('311', '140931', '保德县', '299');
INSERT INTO `region_city` VALUES ('312', '140932', '偏关县', '299');
INSERT INTO `region_city` VALUES ('313', '140981', '原平市', '299');
INSERT INTO `region_city` VALUES ('314', '141000', '临汾市', '215');
INSERT INTO `region_city` VALUES ('315', '141002', '尧都区', '314');
INSERT INTO `region_city` VALUES ('316', '141021', '曲沃县', '314');
INSERT INTO `region_city` VALUES ('317', '141022', '翼城县', '314');
INSERT INTO `region_city` VALUES ('318', '141023', '襄汾县', '314');
INSERT INTO `region_city` VALUES ('319', '141024', '洪洞县', '314');
INSERT INTO `region_city` VALUES ('320', '141025', '古县', '314');
INSERT INTO `region_city` VALUES ('321', '141026', '安泽县', '314');
INSERT INTO `region_city` VALUES ('322', '141027', '浮山县', '314');
INSERT INTO `region_city` VALUES ('323', '141028', '吉县', '314');
INSERT INTO `region_city` VALUES ('324', '141029', '乡宁县', '314');
INSERT INTO `region_city` VALUES ('325', '141030', '大宁县', '314');
INSERT INTO `region_city` VALUES ('326', '141031', '隰县', '314');
INSERT INTO `region_city` VALUES ('327', '141032', '永和县', '314');
INSERT INTO `region_city` VALUES ('328', '141033', '蒲县', '314');
INSERT INTO `region_city` VALUES ('329', '141034', '汾西县', '314');
INSERT INTO `region_city` VALUES ('330', '141081', '侯马市', '314');
INSERT INTO `region_city` VALUES ('331', '141082', '霍州市', '314');
INSERT INTO `region_city` VALUES ('332', '141100', '吕梁市', '215');
INSERT INTO `region_city` VALUES ('333', '141102', '离石区', '332');
INSERT INTO `region_city` VALUES ('334', '141121', '文水县', '332');
INSERT INTO `region_city` VALUES ('335', '141122', '交城县', '332');
INSERT INTO `region_city` VALUES ('336', '141123', '兴县', '332');
INSERT INTO `region_city` VALUES ('337', '141124', '临县', '332');
INSERT INTO `region_city` VALUES ('338', '141125', '柳林县', '332');
INSERT INTO `region_city` VALUES ('339', '141126', '石楼县', '332');
INSERT INTO `region_city` VALUES ('340', '141127', '岚县', '332');
INSERT INTO `region_city` VALUES ('341', '141128', '方山县', '332');
INSERT INTO `region_city` VALUES ('342', '141129', '中阳县', '332');
INSERT INTO `region_city` VALUES ('343', '141130', '交口县', '332');
INSERT INTO `region_city` VALUES ('344', '141181', '孝义市', '332');
INSERT INTO `region_city` VALUES ('345', '141182', '汾阳市', '332');
INSERT INTO `region_city` VALUES ('346', '150000', '内蒙古自治区', '0');
INSERT INTO `region_city` VALUES ('347', '150100', '呼和浩特市', '346');
INSERT INTO `region_city` VALUES ('348', '150102', '新城区', '347');
INSERT INTO `region_city` VALUES ('349', '150103', '回民区', '347');
INSERT INTO `region_city` VALUES ('350', '150104', '玉泉区', '347');
INSERT INTO `region_city` VALUES ('351', '150105', '赛罕区', '347');
INSERT INTO `region_city` VALUES ('352', '150121', '土默特左旗', '347');
INSERT INTO `region_city` VALUES ('353', '150122', '托克托县', '347');
INSERT INTO `region_city` VALUES ('354', '150123', '和林格尔县', '347');
INSERT INTO `region_city` VALUES ('355', '150124', '清水河县', '347');
INSERT INTO `region_city` VALUES ('356', '150125', '武川县', '347');
INSERT INTO `region_city` VALUES ('357', '150200', '包头市', '346');
INSERT INTO `region_city` VALUES ('358', '150202', '东河区', '357');
INSERT INTO `region_city` VALUES ('359', '150203', '昆都仑区', '357');
INSERT INTO `region_city` VALUES ('360', '150204', '青山区', '357');
INSERT INTO `region_city` VALUES ('361', '150205', '石拐区', '357');
INSERT INTO `region_city` VALUES ('362', '150206', '白云鄂博矿区', '357');
INSERT INTO `region_city` VALUES ('363', '150207', '九原区', '357');
INSERT INTO `region_city` VALUES ('364', '150221', '土默特右旗', '357');
INSERT INTO `region_city` VALUES ('365', '150222', '固阳县', '357');
INSERT INTO `region_city` VALUES ('366', '150223', '达尔罕茂明安联合旗', '357');
INSERT INTO `region_city` VALUES ('367', '150300', '乌海市', '346');
INSERT INTO `region_city` VALUES ('368', '150302', '海勃湾区', '367');
INSERT INTO `region_city` VALUES ('369', '150303', '海南区', '367');
INSERT INTO `region_city` VALUES ('370', '150304', '乌达区', '367');
INSERT INTO `region_city` VALUES ('371', '150400', '赤峰市', '346');
INSERT INTO `region_city` VALUES ('372', '150402', '红山区', '371');
INSERT INTO `region_city` VALUES ('373', '150403', '元宝山区', '371');
INSERT INTO `region_city` VALUES ('374', '150404', '松山区', '371');
INSERT INTO `region_city` VALUES ('375', '150421', '阿鲁科尔沁旗', '371');
INSERT INTO `region_city` VALUES ('376', '150422', '巴林左旗', '371');
INSERT INTO `region_city` VALUES ('377', '150423', '巴林右旗', '371');
INSERT INTO `region_city` VALUES ('378', '150424', '林西县', '371');
INSERT INTO `region_city` VALUES ('379', '150425', '克什克腾旗', '371');
INSERT INTO `region_city` VALUES ('380', '150426', '翁牛特旗', '371');
INSERT INTO `region_city` VALUES ('381', '150428', '喀喇沁旗', '371');
INSERT INTO `region_city` VALUES ('382', '150429', '宁城县', '371');
INSERT INTO `region_city` VALUES ('383', '150430', '敖汉旗', '371');
INSERT INTO `region_city` VALUES ('384', '150500', '通辽市', '346');
INSERT INTO `region_city` VALUES ('385', '150502', '科尔沁区', '384');
INSERT INTO `region_city` VALUES ('386', '150521', '科尔沁左翼中旗', '384');
INSERT INTO `region_city` VALUES ('387', '150522', '科尔沁左翼后旗', '384');
INSERT INTO `region_city` VALUES ('388', '150523', '开鲁县', '384');
INSERT INTO `region_city` VALUES ('389', '150524', '库伦旗', '384');
INSERT INTO `region_city` VALUES ('390', '150525', '奈曼旗', '384');
INSERT INTO `region_city` VALUES ('391', '150526', '扎鲁特旗', '384');
INSERT INTO `region_city` VALUES ('392', '150581', '霍林郭勒市', '384');
INSERT INTO `region_city` VALUES ('393', '150600', '鄂尔多斯市', '346');
INSERT INTO `region_city` VALUES ('394', '150602', '东胜区', '393');
INSERT INTO `region_city` VALUES ('395', '150603', '康巴什区', '393');
INSERT INTO `region_city` VALUES ('396', '150621', '达拉特旗', '393');
INSERT INTO `region_city` VALUES ('397', '150622', '准格尔旗', '393');
INSERT INTO `region_city` VALUES ('398', '150623', '鄂托克前旗', '393');
INSERT INTO `region_city` VALUES ('399', '150624', '鄂托克旗', '393');
INSERT INTO `region_city` VALUES ('400', '150625', '杭锦旗', '393');
INSERT INTO `region_city` VALUES ('401', '150626', '乌审旗', '393');
INSERT INTO `region_city` VALUES ('402', '150627', '伊金霍洛旗', '393');
INSERT INTO `region_city` VALUES ('403', '150700', '呼伦贝尔市', '346');
INSERT INTO `region_city` VALUES ('404', '150702', '海拉尔区', '403');
INSERT INTO `region_city` VALUES ('405', '150703', '扎赉诺尔区', '403');
INSERT INTO `region_city` VALUES ('406', '150721', '阿荣旗', '403');
INSERT INTO `region_city` VALUES ('407', '150722', '莫力达瓦达斡尔族自治旗', '403');
INSERT INTO `region_city` VALUES ('408', '150723', '鄂伦春自治旗', '403');
INSERT INTO `region_city` VALUES ('409', '150724', '鄂温克族自治旗', '403');
INSERT INTO `region_city` VALUES ('410', '150725', '陈巴尔虎旗', '403');
INSERT INTO `region_city` VALUES ('411', '150726', '新巴尔虎左旗', '403');
INSERT INTO `region_city` VALUES ('412', '150727', '新巴尔虎右旗', '403');
INSERT INTO `region_city` VALUES ('413', '150781', '满洲里市', '403');
INSERT INTO `region_city` VALUES ('414', '150782', '牙克石市', '403');
INSERT INTO `region_city` VALUES ('415', '150783', '扎兰屯市', '403');
INSERT INTO `region_city` VALUES ('416', '150784', '额尔古纳市', '403');
INSERT INTO `region_city` VALUES ('417', '150785', '根河市', '403');
INSERT INTO `region_city` VALUES ('418', '150800', '巴彦淖尔市', '346');
INSERT INTO `region_city` VALUES ('419', '150802', '临河区', '418');
INSERT INTO `region_city` VALUES ('420', '150821', '五原县', '418');
INSERT INTO `region_city` VALUES ('421', '150822', '磴口县', '418');
INSERT INTO `region_city` VALUES ('422', '150823', '乌拉特前旗', '418');
INSERT INTO `region_city` VALUES ('423', '150824', '乌拉特中旗', '418');
INSERT INTO `region_city` VALUES ('424', '150825', '乌拉特后旗', '418');
INSERT INTO `region_city` VALUES ('425', '150826', '杭锦后旗', '418');
INSERT INTO `region_city` VALUES ('426', '150900', '乌兰察布市', '346');
INSERT INTO `region_city` VALUES ('427', '150902', '集宁区', '426');
INSERT INTO `region_city` VALUES ('428', '150921', '卓资县', '426');
INSERT INTO `region_city` VALUES ('429', '150922', '化德县', '426');
INSERT INTO `region_city` VALUES ('430', '150923', '商都县', '426');
INSERT INTO `region_city` VALUES ('431', '150924', '兴和县', '426');
INSERT INTO `region_city` VALUES ('432', '150925', '凉城县', '426');
INSERT INTO `region_city` VALUES ('433', '150926', '察哈尔右翼前旗', '426');
INSERT INTO `region_city` VALUES ('434', '150927', '察哈尔右翼中旗', '426');
INSERT INTO `region_city` VALUES ('435', '150928', '察哈尔右翼后旗', '426');
INSERT INTO `region_city` VALUES ('436', '150929', '四子王旗', '426');
INSERT INTO `region_city` VALUES ('437', '150981', '丰镇市', '426');
INSERT INTO `region_city` VALUES ('438', '152200', '兴安盟', '346');
INSERT INTO `region_city` VALUES ('439', '152201', '乌兰浩特市', '438');
INSERT INTO `region_city` VALUES ('440', '152202', '阿尔山市', '438');
INSERT INTO `region_city` VALUES ('441', '152221', '科尔沁右翼前旗', '438');
INSERT INTO `region_city` VALUES ('442', '152222', '科尔沁右翼中旗', '438');
INSERT INTO `region_city` VALUES ('443', '152223', '扎赉特旗', '438');
INSERT INTO `region_city` VALUES ('444', '152224', '突泉县', '438');
INSERT INTO `region_city` VALUES ('445', '152500', '锡林郭勒盟', '346');
INSERT INTO `region_city` VALUES ('446', '152501', '二连浩特市', '445');
INSERT INTO `region_city` VALUES ('447', '152502', '锡林浩特市', '445');
INSERT INTO `region_city` VALUES ('448', '152522', '阿巴嘎旗', '445');
INSERT INTO `region_city` VALUES ('449', '152523', '苏尼特左旗', '445');
INSERT INTO `region_city` VALUES ('450', '152524', '苏尼特右旗', '445');
INSERT INTO `region_city` VALUES ('451', '152525', '东乌珠穆沁旗', '445');
INSERT INTO `region_city` VALUES ('452', '152526', '西乌珠穆沁旗', '445');
INSERT INTO `region_city` VALUES ('453', '152527', '太仆寺旗', '445');
INSERT INTO `region_city` VALUES ('454', '152528', '镶黄旗', '445');
INSERT INTO `region_city` VALUES ('455', '152529', '正镶白旗', '445');
INSERT INTO `region_city` VALUES ('456', '152530', '正蓝旗', '445');
INSERT INTO `region_city` VALUES ('457', '152531', '多伦县', '445');
INSERT INTO `region_city` VALUES ('458', '152900', '阿拉善盟', '346');
INSERT INTO `region_city` VALUES ('459', '152921', '阿拉善左旗', '458');
INSERT INTO `region_city` VALUES ('460', '152922', '阿拉善右旗', '458');
INSERT INTO `region_city` VALUES ('461', '152923', '额济纳旗', '458');
INSERT INTO `region_city` VALUES ('462', '210000', '辽宁省', '0');
INSERT INTO `region_city` VALUES ('463', '210100', '沈阳市', '462');
INSERT INTO `region_city` VALUES ('464', '210102', '和平区', '463');
INSERT INTO `region_city` VALUES ('465', '210103', '沈河区', '463');
INSERT INTO `region_city` VALUES ('466', '210104', '大东区', '463');
INSERT INTO `region_city` VALUES ('467', '210105', '皇姑区', '463');
INSERT INTO `region_city` VALUES ('468', '210106', '铁西区', '463');
INSERT INTO `region_city` VALUES ('469', '210111', '苏家屯区', '463');
INSERT INTO `region_city` VALUES ('470', '210112', '浑南区', '463');
INSERT INTO `region_city` VALUES ('471', '210113', '沈北新区', '463');
INSERT INTO `region_city` VALUES ('472', '210114', '于洪区', '463');
INSERT INTO `region_city` VALUES ('473', '210115', '辽中区', '463');
INSERT INTO `region_city` VALUES ('474', '210123', '康平县', '463');
INSERT INTO `region_city` VALUES ('475', '210124', '法库县', '463');
INSERT INTO `region_city` VALUES ('476', '210181', '新民市', '463');
INSERT INTO `region_city` VALUES ('477', '210200', '大连市', '462');
INSERT INTO `region_city` VALUES ('478', '210202', '中山区', '477');
INSERT INTO `region_city` VALUES ('479', '210203', '西岗区', '477');
INSERT INTO `region_city` VALUES ('480', '210204', '沙河口区', '477');
INSERT INTO `region_city` VALUES ('481', '210211', '甘井子区', '477');
INSERT INTO `region_city` VALUES ('482', '210212', '旅顺口区', '477');
INSERT INTO `region_city` VALUES ('483', '210213', '金州区', '477');
INSERT INTO `region_city` VALUES ('484', '210214', '普兰店区', '477');
INSERT INTO `region_city` VALUES ('485', '210224', '长海县', '477');
INSERT INTO `region_city` VALUES ('486', '210281', '瓦房店市', '477');
INSERT INTO `region_city` VALUES ('487', '210283', '庄河市', '477');
INSERT INTO `region_city` VALUES ('488', '210300', '鞍山市', '462');
INSERT INTO `region_city` VALUES ('489', '210302', '铁东区', '488');
INSERT INTO `region_city` VALUES ('490', '210303', '铁西区', '488');
INSERT INTO `region_city` VALUES ('491', '210304', '立山区', '488');
INSERT INTO `region_city` VALUES ('492', '210311', '千山区', '488');
INSERT INTO `region_city` VALUES ('493', '210321', '台安县', '488');
INSERT INTO `region_city` VALUES ('494', '210323', '岫岩满族自治县', '488');
INSERT INTO `region_city` VALUES ('495', '210381', '海城市', '488');
INSERT INTO `region_city` VALUES ('496', '210400', '抚顺市', '462');
INSERT INTO `region_city` VALUES ('497', '210402', '新抚区', '496');
INSERT INTO `region_city` VALUES ('498', '210403', '东洲区', '496');
INSERT INTO `region_city` VALUES ('499', '210404', '望花区', '496');
INSERT INTO `region_city` VALUES ('500', '210411', '顺城区', '496');
INSERT INTO `region_city` VALUES ('501', '210421', '抚顺县', '496');
INSERT INTO `region_city` VALUES ('502', '210422', '新宾满族自治县', '496');
INSERT INTO `region_city` VALUES ('503', '210423', '清原满族自治县', '496');
INSERT INTO `region_city` VALUES ('504', '210500', '本溪市', '462');
INSERT INTO `region_city` VALUES ('505', '210502', '平山区', '504');
INSERT INTO `region_city` VALUES ('506', '210503', '溪湖区', '504');
INSERT INTO `region_city` VALUES ('507', '210504', '明山区', '504');
INSERT INTO `region_city` VALUES ('508', '210505', '南芬区', '504');
INSERT INTO `region_city` VALUES ('509', '210521', '本溪满族自治县', '504');
INSERT INTO `region_city` VALUES ('510', '210522', '桓仁满族自治县', '504');
INSERT INTO `region_city` VALUES ('511', '210600', '丹东市', '462');
INSERT INTO `region_city` VALUES ('512', '210602', '元宝区', '511');
INSERT INTO `region_city` VALUES ('513', '210603', '振兴区', '511');
INSERT INTO `region_city` VALUES ('514', '210604', '振安区', '511');
INSERT INTO `region_city` VALUES ('515', '210624', '宽甸满族自治县', '511');
INSERT INTO `region_city` VALUES ('516', '210681', '东港市', '511');
INSERT INTO `region_city` VALUES ('517', '210682', '凤城市', '511');
INSERT INTO `region_city` VALUES ('518', '210700', '锦州市', '462');
INSERT INTO `region_city` VALUES ('519', '210702', '古塔区', '518');
INSERT INTO `region_city` VALUES ('520', '210703', '凌河区', '518');
INSERT INTO `region_city` VALUES ('521', '210711', '太和区', '518');
INSERT INTO `region_city` VALUES ('522', '210726', '黑山县', '518');
INSERT INTO `region_city` VALUES ('523', '210727', '义县', '518');
INSERT INTO `region_city` VALUES ('524', '210781', '凌海市', '518');
INSERT INTO `region_city` VALUES ('525', '210782', '北镇市', '518');
INSERT INTO `region_city` VALUES ('526', '210800', '营口市', '462');
INSERT INTO `region_city` VALUES ('527', '210802', '站前区', '526');
INSERT INTO `region_city` VALUES ('528', '210803', '西市区', '526');
INSERT INTO `region_city` VALUES ('529', '210804', '鲅鱼圈区', '526');
INSERT INTO `region_city` VALUES ('530', '210811', '老边区', '526');
INSERT INTO `region_city` VALUES ('531', '210881', '盖州市', '526');
INSERT INTO `region_city` VALUES ('532', '210882', '大石桥市', '526');
INSERT INTO `region_city` VALUES ('533', '210900', '阜新市', '462');
INSERT INTO `region_city` VALUES ('534', '210902', '海州区', '533');
INSERT INTO `region_city` VALUES ('535', '210903', '新邱区', '533');
INSERT INTO `region_city` VALUES ('536', '210904', '太平区', '533');
INSERT INTO `region_city` VALUES ('537', '210905', '清河门区', '533');
INSERT INTO `region_city` VALUES ('538', '210911', '细河区', '533');
INSERT INTO `region_city` VALUES ('539', '210921', '阜新蒙古族自治县', '533');
INSERT INTO `region_city` VALUES ('540', '210922', '彰武县', '533');
INSERT INTO `region_city` VALUES ('541', '211000', '辽阳市', '462');
INSERT INTO `region_city` VALUES ('542', '211002', '白塔区', '541');
INSERT INTO `region_city` VALUES ('543', '211003', '文圣区', '541');
INSERT INTO `region_city` VALUES ('544', '211004', '宏伟区', '541');
INSERT INTO `region_city` VALUES ('545', '211005', '弓长岭区', '541');
INSERT INTO `region_city` VALUES ('546', '211011', '太子河区', '541');
INSERT INTO `region_city` VALUES ('547', '211021', '辽阳县', '541');
INSERT INTO `region_city` VALUES ('548', '211081', '灯塔市', '541');
INSERT INTO `region_city` VALUES ('549', '211100', '盘锦市', '462');
INSERT INTO `region_city` VALUES ('550', '211102', '双台子区', '549');
INSERT INTO `region_city` VALUES ('551', '211103', '兴隆台区', '549');
INSERT INTO `region_city` VALUES ('552', '211104', '大洼区', '549');
INSERT INTO `region_city` VALUES ('553', '211122', '盘山县', '549');
INSERT INTO `region_city` VALUES ('554', '211200', '铁岭市', '462');
INSERT INTO `region_city` VALUES ('555', '211202', '银州区', '554');
INSERT INTO `region_city` VALUES ('556', '211204', '清河区', '554');
INSERT INTO `region_city` VALUES ('557', '211221', '铁岭县', '554');
INSERT INTO `region_city` VALUES ('558', '211223', '西丰县', '554');
INSERT INTO `region_city` VALUES ('559', '211224', '昌图县', '554');
INSERT INTO `region_city` VALUES ('560', '211281', '调兵山市', '554');
INSERT INTO `region_city` VALUES ('561', '211282', '开原市', '554');
INSERT INTO `region_city` VALUES ('562', '211300', '朝阳市', '462');
INSERT INTO `region_city` VALUES ('563', '211302', '双塔区', '562');
INSERT INTO `region_city` VALUES ('564', '211303', '龙城区', '562');
INSERT INTO `region_city` VALUES ('565', '211321', '朝阳县', '562');
INSERT INTO `region_city` VALUES ('566', '211322', '建平县', '562');
INSERT INTO `region_city` VALUES ('567', '211324', '喀喇沁左翼蒙古族自治县', '562');
INSERT INTO `region_city` VALUES ('568', '211381', '北票市', '562');
INSERT INTO `region_city` VALUES ('569', '211382', '凌源市', '562');
INSERT INTO `region_city` VALUES ('570', '211400', '葫芦岛市', '462');
INSERT INTO `region_city` VALUES ('571', '211402', '连山区', '570');
INSERT INTO `region_city` VALUES ('572', '211403', '龙港区', '570');
INSERT INTO `region_city` VALUES ('573', '211404', '南票区', '570');
INSERT INTO `region_city` VALUES ('574', '211421', '绥中县', '570');
INSERT INTO `region_city` VALUES ('575', '211422', '建昌县', '570');
INSERT INTO `region_city` VALUES ('576', '211481', '兴城市', '570');
INSERT INTO `region_city` VALUES ('577', '220000', '吉林省', '0');
INSERT INTO `region_city` VALUES ('578', '220100', '长春市', '577');
INSERT INTO `region_city` VALUES ('579', '220102', '南关区', '578');
INSERT INTO `region_city` VALUES ('580', '220103', '宽城区', '578');
INSERT INTO `region_city` VALUES ('581', '220104', '朝阳区', '578');
INSERT INTO `region_city` VALUES ('582', '220105', '二道区', '578');
INSERT INTO `region_city` VALUES ('583', '220106', '绿园区', '578');
INSERT INTO `region_city` VALUES ('584', '220112', '双阳区', '578');
INSERT INTO `region_city` VALUES ('585', '220113', '九台区', '578');
INSERT INTO `region_city` VALUES ('586', '220122', '农安县', '578');
INSERT INTO `region_city` VALUES ('587', '220182', '榆树市', '578');
INSERT INTO `region_city` VALUES ('588', '220183', '德惠市', '578');
INSERT INTO `region_city` VALUES ('589', '220200', '吉林市', '577');
INSERT INTO `region_city` VALUES ('590', '220202', '昌邑区', '589');
INSERT INTO `region_city` VALUES ('591', '220203', '龙潭区', '589');
INSERT INTO `region_city` VALUES ('592', '220204', '船营区', '589');
INSERT INTO `region_city` VALUES ('593', '220211', '丰满区', '589');
INSERT INTO `region_city` VALUES ('594', '220221', '永吉县', '589');
INSERT INTO `region_city` VALUES ('595', '220281', '蛟河市', '589');
INSERT INTO `region_city` VALUES ('596', '220282', '桦甸市', '589');
INSERT INTO `region_city` VALUES ('597', '220283', '舒兰市', '589');
INSERT INTO `region_city` VALUES ('598', '220284', '磐石市', '589');
INSERT INTO `region_city` VALUES ('599', '220300', '四平市', '577');
INSERT INTO `region_city` VALUES ('600', '220302', '铁西区', '599');
INSERT INTO `region_city` VALUES ('601', '220303', '铁东区', '599');
INSERT INTO `region_city` VALUES ('602', '220322', '梨树县', '599');
INSERT INTO `region_city` VALUES ('603', '220323', '伊通满族自治县', '599');
INSERT INTO `region_city` VALUES ('604', '220381', '公主岭市', '599');
INSERT INTO `region_city` VALUES ('605', '220382', '双辽市', '599');
INSERT INTO `region_city` VALUES ('606', '220400', '辽源市', '577');
INSERT INTO `region_city` VALUES ('607', '220402', '龙山区', '606');
INSERT INTO `region_city` VALUES ('608', '220403', '西安区', '606');
INSERT INTO `region_city` VALUES ('609', '220421', '东丰县', '606');
INSERT INTO `region_city` VALUES ('610', '220422', '东辽县', '606');
INSERT INTO `region_city` VALUES ('611', '220500', '通化市', '577');
INSERT INTO `region_city` VALUES ('612', '220502', '东昌区', '611');
INSERT INTO `region_city` VALUES ('613', '220503', '二道江区', '611');
INSERT INTO `region_city` VALUES ('614', '220521', '通化县', '611');
INSERT INTO `region_city` VALUES ('615', '220523', '辉南县', '611');
INSERT INTO `region_city` VALUES ('616', '220524', '柳河县', '611');
INSERT INTO `region_city` VALUES ('617', '220581', '梅河口市', '611');
INSERT INTO `region_city` VALUES ('618', '220582', '集安市', '611');
INSERT INTO `region_city` VALUES ('619', '220600', '白山市', '577');
INSERT INTO `region_city` VALUES ('620', '220602', '浑江区', '619');
INSERT INTO `region_city` VALUES ('621', '220605', '江源区', '619');
INSERT INTO `region_city` VALUES ('622', '220621', '抚松县', '619');
INSERT INTO `region_city` VALUES ('623', '220622', '靖宇县', '619');
INSERT INTO `region_city` VALUES ('624', '220623', '长白朝鲜族自治县', '619');
INSERT INTO `region_city` VALUES ('625', '220681', '临江市', '619');
INSERT INTO `region_city` VALUES ('626', '220700', '松原市', '577');
INSERT INTO `region_city` VALUES ('627', '220702', '宁江区', '626');
INSERT INTO `region_city` VALUES ('628', '220721', '前郭尔罗斯蒙古族自治县', '626');
INSERT INTO `region_city` VALUES ('629', '220722', '长岭县', '626');
INSERT INTO `region_city` VALUES ('630', '220723', '乾安县', '626');
INSERT INTO `region_city` VALUES ('631', '220781', '扶余市', '626');
INSERT INTO `region_city` VALUES ('632', '220800', '白城市', '577');
INSERT INTO `region_city` VALUES ('633', '220802', '洮北区', '632');
INSERT INTO `region_city` VALUES ('634', '220821', '镇赉县', '632');
INSERT INTO `region_city` VALUES ('635', '220822', '通榆县', '632');
INSERT INTO `region_city` VALUES ('636', '220881', '洮南市', '632');
INSERT INTO `region_city` VALUES ('637', '220882', '大安市', '632');
INSERT INTO `region_city` VALUES ('638', '222400', '延边朝鲜族自治州', '577');
INSERT INTO `region_city` VALUES ('639', '222401', '延吉市', '638');
INSERT INTO `region_city` VALUES ('640', '222402', '图们市', '638');
INSERT INTO `region_city` VALUES ('641', '222403', '敦化市', '638');
INSERT INTO `region_city` VALUES ('642', '222404', '珲春市', '638');
INSERT INTO `region_city` VALUES ('643', '222405', '龙井市', '638');
INSERT INTO `region_city` VALUES ('644', '222406', '和龙市', '638');
INSERT INTO `region_city` VALUES ('645', '222424', '汪清县', '638');
INSERT INTO `region_city` VALUES ('646', '222426', '安图县', '638');
INSERT INTO `region_city` VALUES ('647', '230000', '黑龙江省', '0');
INSERT INTO `region_city` VALUES ('648', '230100', '哈尔滨市', '647');
INSERT INTO `region_city` VALUES ('649', '230102', '道里区', '648');
INSERT INTO `region_city` VALUES ('650', '230103', '南岗区', '648');
INSERT INTO `region_city` VALUES ('651', '230104', '道外区', '648');
INSERT INTO `region_city` VALUES ('652', '230108', '平房区', '648');
INSERT INTO `region_city` VALUES ('653', '230109', '松北区', '648');
INSERT INTO `region_city` VALUES ('654', '230110', '香坊区', '648');
INSERT INTO `region_city` VALUES ('655', '230111', '呼兰区', '648');
INSERT INTO `region_city` VALUES ('656', '230112', '阿城区', '648');
INSERT INTO `region_city` VALUES ('657', '230113', '双城区', '648');
INSERT INTO `region_city` VALUES ('658', '230123', '依兰县', '648');
INSERT INTO `region_city` VALUES ('659', '230124', '方正县', '648');
INSERT INTO `region_city` VALUES ('660', '230125', '宾县', '648');
INSERT INTO `region_city` VALUES ('661', '230126', '巴彦县', '648');
INSERT INTO `region_city` VALUES ('662', '230127', '木兰县', '648');
INSERT INTO `region_city` VALUES ('663', '230128', '通河县', '648');
INSERT INTO `region_city` VALUES ('664', '230129', '延寿县', '648');
INSERT INTO `region_city` VALUES ('665', '230183', '尚志市', '648');
INSERT INTO `region_city` VALUES ('666', '230184', '五常市', '648');
INSERT INTO `region_city` VALUES ('667', '230200', '齐齐哈尔市', '647');
INSERT INTO `region_city` VALUES ('668', '230202', '龙沙区', '667');
INSERT INTO `region_city` VALUES ('669', '230203', '建华区', '667');
INSERT INTO `region_city` VALUES ('670', '230204', '铁锋区', '667');
INSERT INTO `region_city` VALUES ('671', '230205', '昂昂溪区', '667');
INSERT INTO `region_city` VALUES ('672', '230206', '富拉尔基区', '667');
INSERT INTO `region_city` VALUES ('673', '230207', '碾子山区', '667');
INSERT INTO `region_city` VALUES ('674', '230208', '梅里斯达斡尔族区', '667');
INSERT INTO `region_city` VALUES ('675', '230221', '龙江县', '667');
INSERT INTO `region_city` VALUES ('676', '230223', '依安县', '667');
INSERT INTO `region_city` VALUES ('677', '230224', '泰来县', '667');
INSERT INTO `region_city` VALUES ('678', '230225', '甘南县', '667');
INSERT INTO `region_city` VALUES ('679', '230227', '富裕县', '667');
INSERT INTO `region_city` VALUES ('680', '230229', '克山县', '667');
INSERT INTO `region_city` VALUES ('681', '230230', '克东县', '667');
INSERT INTO `region_city` VALUES ('682', '230231', '拜泉县', '667');
INSERT INTO `region_city` VALUES ('683', '230281', '讷河市', '667');
INSERT INTO `region_city` VALUES ('684', '230300', '鸡西市', '647');
INSERT INTO `region_city` VALUES ('685', '230302', '鸡冠区', '684');
INSERT INTO `region_city` VALUES ('686', '230303', '恒山区', '684');
INSERT INTO `region_city` VALUES ('687', '230304', '滴道区', '684');
INSERT INTO `region_city` VALUES ('688', '230305', '梨树区', '684');
INSERT INTO `region_city` VALUES ('689', '230306', '城子河区', '684');
INSERT INTO `region_city` VALUES ('690', '230307', '麻山区', '684');
INSERT INTO `region_city` VALUES ('691', '230321', '鸡东县', '684');
INSERT INTO `region_city` VALUES ('692', '230381', '虎林市', '684');
INSERT INTO `region_city` VALUES ('693', '230382', '密山市', '684');
INSERT INTO `region_city` VALUES ('694', '230400', '鹤岗市', '647');
INSERT INTO `region_city` VALUES ('695', '230402', '向阳区', '694');
INSERT INTO `region_city` VALUES ('696', '230403', '工农区', '694');
INSERT INTO `region_city` VALUES ('697', '230404', '南山区', '694');
INSERT INTO `region_city` VALUES ('698', '230405', '兴安区', '694');
INSERT INTO `region_city` VALUES ('699', '230406', '东山区', '694');
INSERT INTO `region_city` VALUES ('700', '230407', '兴山区', '694');
INSERT INTO `region_city` VALUES ('701', '230421', '萝北县', '694');
INSERT INTO `region_city` VALUES ('702', '230422', '绥滨县', '694');
INSERT INTO `region_city` VALUES ('703', '230500', '双鸭山市', '647');
INSERT INTO `region_city` VALUES ('704', '230502', '尖山区', '703');
INSERT INTO `region_city` VALUES ('705', '230503', '岭东区', '703');
INSERT INTO `region_city` VALUES ('706', '230505', '四方台区', '703');
INSERT INTO `region_city` VALUES ('707', '230506', '宝山区', '703');
INSERT INTO `region_city` VALUES ('708', '230521', '集贤县', '703');
INSERT INTO `region_city` VALUES ('709', '230522', '友谊县', '703');
INSERT INTO `region_city` VALUES ('710', '230523', '宝清县', '703');
INSERT INTO `region_city` VALUES ('711', '230524', '饶河县', '703');
INSERT INTO `region_city` VALUES ('712', '230600', '大庆市', '647');
INSERT INTO `region_city` VALUES ('713', '230602', '萨尔图区', '712');
INSERT INTO `region_city` VALUES ('714', '230603', '龙凤区', '712');
INSERT INTO `region_city` VALUES ('715', '230604', '让胡路区', '712');
INSERT INTO `region_city` VALUES ('716', '230605', '红岗区', '712');
INSERT INTO `region_city` VALUES ('717', '230606', '大同区', '712');
INSERT INTO `region_city` VALUES ('718', '230621', '肇州县', '712');
INSERT INTO `region_city` VALUES ('719', '230622', '肇源县', '712');
INSERT INTO `region_city` VALUES ('720', '230623', '林甸县', '712');
INSERT INTO `region_city` VALUES ('721', '230624', '杜尔伯特蒙古族自治县', '712');
INSERT INTO `region_city` VALUES ('722', '230700', '伊春市', '647');
INSERT INTO `region_city` VALUES ('723', '230702', '伊春区', '722');
INSERT INTO `region_city` VALUES ('724', '230703', '南岔区', '722');
INSERT INTO `region_city` VALUES ('725', '230704', '友好区', '722');
INSERT INTO `region_city` VALUES ('726', '230705', '西林区', '722');
INSERT INTO `region_city` VALUES ('727', '230706', '翠峦区', '722');
INSERT INTO `region_city` VALUES ('728', '230707', '新青区', '722');
INSERT INTO `region_city` VALUES ('729', '230708', '美溪区', '722');
INSERT INTO `region_city` VALUES ('730', '230709', '金山屯区', '722');
INSERT INTO `region_city` VALUES ('731', '230710', '五营区', '722');
INSERT INTO `region_city` VALUES ('732', '230711', '乌马河区', '722');
INSERT INTO `region_city` VALUES ('733', '230712', '汤旺河区', '722');
INSERT INTO `region_city` VALUES ('734', '230713', '带岭区', '722');
INSERT INTO `region_city` VALUES ('735', '230714', '乌伊岭区', '722');
INSERT INTO `region_city` VALUES ('736', '230715', '红星区', '722');
INSERT INTO `region_city` VALUES ('737', '230716', '上甘岭区', '722');
INSERT INTO `region_city` VALUES ('738', '230722', '嘉荫县', '722');
INSERT INTO `region_city` VALUES ('739', '230781', '铁力市', '722');
INSERT INTO `region_city` VALUES ('740', '230800', '佳木斯市', '647');
INSERT INTO `region_city` VALUES ('741', '230803', '向阳区', '740');
INSERT INTO `region_city` VALUES ('742', '230804', '前进区', '740');
INSERT INTO `region_city` VALUES ('743', '230805', '东风区', '740');
INSERT INTO `region_city` VALUES ('744', '230811', '郊区', '740');
INSERT INTO `region_city` VALUES ('745', '230822', '桦南县', '740');
INSERT INTO `region_city` VALUES ('746', '230826', '桦川县', '740');
INSERT INTO `region_city` VALUES ('747', '230828', '汤原县', '740');
INSERT INTO `region_city` VALUES ('748', '230881', '同江市', '740');
INSERT INTO `region_city` VALUES ('749', '230882', '富锦市', '740');
INSERT INTO `region_city` VALUES ('750', '230883', '抚远市', '740');
INSERT INTO `region_city` VALUES ('751', '230900', '七台河市', '647');
INSERT INTO `region_city` VALUES ('752', '230902', '新兴区', '751');
INSERT INTO `region_city` VALUES ('753', '230903', '桃山区', '751');
INSERT INTO `region_city` VALUES ('754', '230904', '茄子河区', '751');
INSERT INTO `region_city` VALUES ('755', '230921', '勃利县', '751');
INSERT INTO `region_city` VALUES ('756', '231000', '牡丹江市', '647');
INSERT INTO `region_city` VALUES ('757', '231002', '东安区', '756');
INSERT INTO `region_city` VALUES ('758', '231003', '阳明区', '756');
INSERT INTO `region_city` VALUES ('759', '231004', '爱民区', '756');
INSERT INTO `region_city` VALUES ('760', '231005', '西安区', '756');
INSERT INTO `region_city` VALUES ('761', '231025', '林口县', '756');
INSERT INTO `region_city` VALUES ('762', '231081', '绥芬河市', '756');
INSERT INTO `region_city` VALUES ('763', '231083', '海林市', '756');
INSERT INTO `region_city` VALUES ('764', '231084', '宁安市', '756');
INSERT INTO `region_city` VALUES ('765', '231085', '穆棱市', '756');
INSERT INTO `region_city` VALUES ('766', '231086', '东宁市', '756');
INSERT INTO `region_city` VALUES ('767', '231100', '黑河市', '647');
INSERT INTO `region_city` VALUES ('768', '231102', '爱辉区', '767');
INSERT INTO `region_city` VALUES ('769', '231121', '嫩江县', '767');
INSERT INTO `region_city` VALUES ('770', '231123', '逊克县', '767');
INSERT INTO `region_city` VALUES ('771', '231124', '孙吴县', '767');
INSERT INTO `region_city` VALUES ('772', '231181', '北安市', '767');
INSERT INTO `region_city` VALUES ('773', '231182', '五大连池市', '767');
INSERT INTO `region_city` VALUES ('774', '231200', '绥化市', '647');
INSERT INTO `region_city` VALUES ('775', '231202', '北林区', '774');
INSERT INTO `region_city` VALUES ('776', '231221', '望奎县', '774');
INSERT INTO `region_city` VALUES ('777', '231222', '兰西县', '774');
INSERT INTO `region_city` VALUES ('778', '231223', '青冈县', '774');
INSERT INTO `region_city` VALUES ('779', '231224', '庆安县', '774');
INSERT INTO `region_city` VALUES ('780', '231225', '明水县', '774');
INSERT INTO `region_city` VALUES ('781', '231226', '绥棱县', '774');
INSERT INTO `region_city` VALUES ('782', '231281', '安达市', '774');
INSERT INTO `region_city` VALUES ('783', '231282', '肇东市', '774');
INSERT INTO `region_city` VALUES ('784', '231283', '海伦市', '774');
INSERT INTO `region_city` VALUES ('785', '232700', '大兴安岭地区', '647');
INSERT INTO `region_city` VALUES ('786', '232721', '呼玛县', '785');
INSERT INTO `region_city` VALUES ('787', '232722', '塔河县', '785');
INSERT INTO `region_city` VALUES ('788', '232723', '漠河县', '785');
INSERT INTO `region_city` VALUES ('789', '310000', '上海市', '0');
INSERT INTO `region_city` VALUES ('790', '310101', '黄浦区', '789');
INSERT INTO `region_city` VALUES ('791', '310104', '徐汇区', '789');
INSERT INTO `region_city` VALUES ('792', '310105', '长宁区', '789');
INSERT INTO `region_city` VALUES ('793', '310106', '静安区', '789');
INSERT INTO `region_city` VALUES ('794', '310107', '普陀区', '789');
INSERT INTO `region_city` VALUES ('795', '310109', '虹口区', '789');
INSERT INTO `region_city` VALUES ('796', '310110', '杨浦区', '789');
INSERT INTO `region_city` VALUES ('797', '310112', '闵行区', '789');
INSERT INTO `region_city` VALUES ('798', '310113', '宝山区', '789');
INSERT INTO `region_city` VALUES ('799', '310114', '嘉定区', '789');
INSERT INTO `region_city` VALUES ('800', '310115', '浦东新区', '789');
INSERT INTO `region_city` VALUES ('801', '310116', '金山区', '789');
INSERT INTO `region_city` VALUES ('802', '310117', '松江区', '789');
INSERT INTO `region_city` VALUES ('803', '310118', '青浦区', '789');
INSERT INTO `region_city` VALUES ('804', '310120', '奉贤区', '789');
INSERT INTO `region_city` VALUES ('805', '310151', '崇明区', '789');
INSERT INTO `region_city` VALUES ('806', '320000', '江苏省', '0');
INSERT INTO `region_city` VALUES ('807', '320100', '南京市', '806');
INSERT INTO `region_city` VALUES ('808', '320102', '玄武区', '807');
INSERT INTO `region_city` VALUES ('809', '320104', '秦淮区', '807');
INSERT INTO `region_city` VALUES ('810', '320105', '建邺区', '807');
INSERT INTO `region_city` VALUES ('811', '320106', '鼓楼区', '807');
INSERT INTO `region_city` VALUES ('812', '320111', '浦口区', '807');
INSERT INTO `region_city` VALUES ('813', '320113', '栖霞区', '807');
INSERT INTO `region_city` VALUES ('814', '320114', '雨花台区', '807');
INSERT INTO `region_city` VALUES ('815', '320115', '江宁区', '807');
INSERT INTO `region_city` VALUES ('816', '320116', '六合区', '807');
INSERT INTO `region_city` VALUES ('817', '320117', '溧水区', '807');
INSERT INTO `region_city` VALUES ('818', '320118', '高淳区', '807');
INSERT INTO `region_city` VALUES ('819', '320200', '无锡市', '806');
INSERT INTO `region_city` VALUES ('820', '320205', '锡山区', '819');
INSERT INTO `region_city` VALUES ('821', '320206', '惠山区', '819');
INSERT INTO `region_city` VALUES ('822', '320211', '滨湖区', '819');
INSERT INTO `region_city` VALUES ('823', '320213', '梁溪区', '819');
INSERT INTO `region_city` VALUES ('824', '320214', '新吴区', '819');
INSERT INTO `region_city` VALUES ('825', '320281', '江阴市', '819');
INSERT INTO `region_city` VALUES ('826', '320282', '宜兴市', '819');
INSERT INTO `region_city` VALUES ('827', '320300', '徐州市', '806');
INSERT INTO `region_city` VALUES ('828', '320302', '鼓楼区', '827');
INSERT INTO `region_city` VALUES ('829', '320303', '云龙区', '827');
INSERT INTO `region_city` VALUES ('830', '320305', '贾汪区', '827');
INSERT INTO `region_city` VALUES ('831', '320311', '泉山区', '827');
INSERT INTO `region_city` VALUES ('832', '320312', '铜山区', '827');
INSERT INTO `region_city` VALUES ('833', '320321', '丰县', '827');
INSERT INTO `region_city` VALUES ('834', '320322', '沛县', '827');
INSERT INTO `region_city` VALUES ('835', '320324', '睢宁县', '827');
INSERT INTO `region_city` VALUES ('836', '320381', '新沂市', '827');
INSERT INTO `region_city` VALUES ('837', '320382', '邳州市', '827');
INSERT INTO `region_city` VALUES ('838', '320400', '常州市', '806');
INSERT INTO `region_city` VALUES ('839', '320402', '天宁区', '838');
INSERT INTO `region_city` VALUES ('840', '320404', '钟楼区', '838');
INSERT INTO `region_city` VALUES ('841', '320411', '新北区', '838');
INSERT INTO `region_city` VALUES ('842', '320412', '武进区', '838');
INSERT INTO `region_city` VALUES ('843', '320413', '金坛区', '838');
INSERT INTO `region_city` VALUES ('844', '320481', '溧阳市', '838');
INSERT INTO `region_city` VALUES ('845', '320500', '苏州市', '806');
INSERT INTO `region_city` VALUES ('846', '320505', '虎丘区', '845');
INSERT INTO `region_city` VALUES ('847', '320506', '吴中区', '845');
INSERT INTO `region_city` VALUES ('848', '320507', '相城区', '845');
INSERT INTO `region_city` VALUES ('849', '320508', '姑苏区', '845');
INSERT INTO `region_city` VALUES ('850', '320509', '吴江区', '845');
INSERT INTO `region_city` VALUES ('851', '320581', '常熟市', '845');
INSERT INTO `region_city` VALUES ('852', '320582', '张家港市', '845');
INSERT INTO `region_city` VALUES ('853', '320583', '昆山市', '845');
INSERT INTO `region_city` VALUES ('854', '320585', '太仓市', '845');
INSERT INTO `region_city` VALUES ('855', '320600', '南通市', '806');
INSERT INTO `region_city` VALUES ('856', '320602', '崇川区', '855');
INSERT INTO `region_city` VALUES ('857', '320611', '港闸区', '855');
INSERT INTO `region_city` VALUES ('858', '320612', '通州区', '855');
INSERT INTO `region_city` VALUES ('859', '320621', '海安县', '855');
INSERT INTO `region_city` VALUES ('860', '320623', '如东县', '855');
INSERT INTO `region_city` VALUES ('861', '320681', '启东市', '855');
INSERT INTO `region_city` VALUES ('862', '320682', '如皋市', '855');
INSERT INTO `region_city` VALUES ('863', '320684', '海门市', '855');
INSERT INTO `region_city` VALUES ('864', '320700', '连云港市', '806');
INSERT INTO `region_city` VALUES ('865', '320703', '连云区', '864');
INSERT INTO `region_city` VALUES ('866', '320706', '海州区', '864');
INSERT INTO `region_city` VALUES ('867', '320707', '赣榆区', '864');
INSERT INTO `region_city` VALUES ('868', '320722', '东海县', '864');
INSERT INTO `region_city` VALUES ('869', '320723', '灌云县', '864');
INSERT INTO `region_city` VALUES ('870', '320724', '灌南县', '864');
INSERT INTO `region_city` VALUES ('871', '320800', '淮安市', '806');
INSERT INTO `region_city` VALUES ('872', '320803', '淮安区', '871');
INSERT INTO `region_city` VALUES ('873', '320804', '淮阴区', '871');
INSERT INTO `region_city` VALUES ('874', '320812', '清江浦区', '871');
INSERT INTO `region_city` VALUES ('875', '320813', '洪泽区', '871');
INSERT INTO `region_city` VALUES ('876', '320826', '涟水县', '871');
INSERT INTO `region_city` VALUES ('877', '320830', '盱眙县', '871');
INSERT INTO `region_city` VALUES ('878', '320831', '金湖县', '871');
INSERT INTO `region_city` VALUES ('879', '320900', '盐城市', '806');
INSERT INTO `region_city` VALUES ('880', '320902', '亭湖区', '879');
INSERT INTO `region_city` VALUES ('881', '320903', '盐都区', '879');
INSERT INTO `region_city` VALUES ('882', '320904', '大丰区', '879');
INSERT INTO `region_city` VALUES ('883', '320921', '响水县', '879');
INSERT INTO `region_city` VALUES ('884', '320922', '滨海县', '879');
INSERT INTO `region_city` VALUES ('885', '320923', '阜宁县', '879');
INSERT INTO `region_city` VALUES ('886', '320924', '射阳县', '879');
INSERT INTO `region_city` VALUES ('887', '320925', '建湖县', '879');
INSERT INTO `region_city` VALUES ('888', '320981', '东台市', '879');
INSERT INTO `region_city` VALUES ('889', '321000', '扬州市', '806');
INSERT INTO `region_city` VALUES ('890', '321002', '广陵区', '889');
INSERT INTO `region_city` VALUES ('891', '321003', '邗江区', '889');
INSERT INTO `region_city` VALUES ('892', '321012', '江都区', '889');
INSERT INTO `region_city` VALUES ('893', '321023', '宝应县', '889');
INSERT INTO `region_city` VALUES ('894', '321081', '仪征市', '889');
INSERT INTO `region_city` VALUES ('895', '321084', '高邮市', '889');
INSERT INTO `region_city` VALUES ('896', '321100', '镇江市', '806');
INSERT INTO `region_city` VALUES ('897', '321102', '京口区', '896');
INSERT INTO `region_city` VALUES ('898', '321111', '润州区', '896');
INSERT INTO `region_city` VALUES ('899', '321112', '丹徒区', '896');
INSERT INTO `region_city` VALUES ('900', '321181', '丹阳市', '896');
INSERT INTO `region_city` VALUES ('901', '321182', '扬中市', '896');
INSERT INTO `region_city` VALUES ('902', '321183', '句容市', '896');
INSERT INTO `region_city` VALUES ('903', '321200', '泰州市', '806');
INSERT INTO `region_city` VALUES ('904', '321202', '海陵区', '903');
INSERT INTO `region_city` VALUES ('905', '321203', '高港区', '903');
INSERT INTO `region_city` VALUES ('906', '321204', '姜堰区', '903');
INSERT INTO `region_city` VALUES ('907', '321281', '兴化市', '903');
INSERT INTO `region_city` VALUES ('908', '321282', '靖江市', '903');
INSERT INTO `region_city` VALUES ('909', '321283', '泰兴市', '903');
INSERT INTO `region_city` VALUES ('910', '321300', '宿迁市', '806');
INSERT INTO `region_city` VALUES ('911', '321302', '宿城区', '910');
INSERT INTO `region_city` VALUES ('912', '321311', '宿豫区', '910');
INSERT INTO `region_city` VALUES ('913', '321322', '沭阳县', '910');
INSERT INTO `region_city` VALUES ('914', '321323', '泗阳县', '910');
INSERT INTO `region_city` VALUES ('915', '321324', '泗洪县', '910');
INSERT INTO `region_city` VALUES ('916', '330000', '浙江省', '0');
INSERT INTO `region_city` VALUES ('917', '330100', '杭州市', '916');
INSERT INTO `region_city` VALUES ('918', '330102', '上城区', '917');
INSERT INTO `region_city` VALUES ('919', '330103', '下城区', '917');
INSERT INTO `region_city` VALUES ('920', '330104', '江干区', '917');
INSERT INTO `region_city` VALUES ('921', '330105', '拱墅区', '917');
INSERT INTO `region_city` VALUES ('922', '330106', '西湖区', '917');
INSERT INTO `region_city` VALUES ('923', '330108', '滨江区', '917');
INSERT INTO `region_city` VALUES ('924', '330109', '萧山区', '917');
INSERT INTO `region_city` VALUES ('925', '330110', '余杭区', '917');
INSERT INTO `region_city` VALUES ('926', '330111', '富阳区', '917');
INSERT INTO `region_city` VALUES ('927', '330112', '临安区', '917');
INSERT INTO `region_city` VALUES ('928', '330122', '桐庐县', '917');
INSERT INTO `region_city` VALUES ('929', '330127', '淳安县', '917');
INSERT INTO `region_city` VALUES ('930', '330182', '建德市', '917');
INSERT INTO `region_city` VALUES ('931', '330200', '宁波市', '916');
INSERT INTO `region_city` VALUES ('932', '330203', '海曙区', '931');
INSERT INTO `region_city` VALUES ('933', '330205', '江北区', '931');
INSERT INTO `region_city` VALUES ('934', '330206', '北仑区', '931');
INSERT INTO `region_city` VALUES ('935', '330211', '镇海区', '931');
INSERT INTO `region_city` VALUES ('936', '330212', '鄞州区', '931');
INSERT INTO `region_city` VALUES ('937', '330213', '奉化区', '931');
INSERT INTO `region_city` VALUES ('938', '330225', '象山县', '931');
INSERT INTO `region_city` VALUES ('939', '330226', '宁海县', '931');
INSERT INTO `region_city` VALUES ('940', '330281', '余姚市', '931');
INSERT INTO `region_city` VALUES ('941', '330282', '慈溪市', '931');
INSERT INTO `region_city` VALUES ('942', '330300', '温州市', '916');
INSERT INTO `region_city` VALUES ('943', '330302', '鹿城区', '942');
INSERT INTO `region_city` VALUES ('944', '330303', '龙湾区', '942');
INSERT INTO `region_city` VALUES ('945', '330304', '瓯海区', '942');
INSERT INTO `region_city` VALUES ('946', '330305', '洞头区', '942');
INSERT INTO `region_city` VALUES ('947', '330324', '永嘉县', '942');
INSERT INTO `region_city` VALUES ('948', '330326', '平阳县', '942');
INSERT INTO `region_city` VALUES ('949', '330327', '苍南县', '942');
INSERT INTO `region_city` VALUES ('950', '330328', '文成县', '942');
INSERT INTO `region_city` VALUES ('951', '330329', '泰顺县', '942');
INSERT INTO `region_city` VALUES ('952', '330381', '瑞安市', '942');
INSERT INTO `region_city` VALUES ('953', '330382', '乐清市', '942');
INSERT INTO `region_city` VALUES ('954', '330400', '嘉兴市', '916');
INSERT INTO `region_city` VALUES ('955', '330402', '南湖区', '954');
INSERT INTO `region_city` VALUES ('956', '330411', '秀洲区', '954');
INSERT INTO `region_city` VALUES ('957', '330421', '嘉善县', '954');
INSERT INTO `region_city` VALUES ('958', '330424', '海盐县', '954');
INSERT INTO `region_city` VALUES ('959', '330481', '海宁市', '954');
INSERT INTO `region_city` VALUES ('960', '330482', '平湖市', '954');
INSERT INTO `region_city` VALUES ('961', '330483', '桐乡市', '954');
INSERT INTO `region_city` VALUES ('962', '330500', '湖州市', '916');
INSERT INTO `region_city` VALUES ('963', '330502', '吴兴区', '962');
INSERT INTO `region_city` VALUES ('964', '330503', '南浔区', '962');
INSERT INTO `region_city` VALUES ('965', '330521', '德清县', '962');
INSERT INTO `region_city` VALUES ('966', '330522', '长兴县', '962');
INSERT INTO `region_city` VALUES ('967', '330523', '安吉县', '962');
INSERT INTO `region_city` VALUES ('968', '330600', '绍兴市', '916');
INSERT INTO `region_city` VALUES ('969', '330602', '越城区', '968');
INSERT INTO `region_city` VALUES ('970', '330603', '柯桥区', '968');
INSERT INTO `region_city` VALUES ('971', '330604', '上虞区', '968');
INSERT INTO `region_city` VALUES ('972', '330624', '新昌县', '968');
INSERT INTO `region_city` VALUES ('973', '330681', '诸暨市', '968');
INSERT INTO `region_city` VALUES ('974', '330683', '嵊州市', '968');
INSERT INTO `region_city` VALUES ('975', '330700', '金华市', '916');
INSERT INTO `region_city` VALUES ('976', '330702', '婺城区', '975');
INSERT INTO `region_city` VALUES ('977', '330703', '金东区', '975');
INSERT INTO `region_city` VALUES ('978', '330723', '武义县', '975');
INSERT INTO `region_city` VALUES ('979', '330726', '浦江县', '975');
INSERT INTO `region_city` VALUES ('980', '33072