中國省市區數據mysql腳本

1.查省

2.查市

3.查區

4.Mysql腳本

/*
Navicat MySQL Data Transfer

Source Server         : MySQL
Source Server Version : 50022
Source Host           : 127.0.0.1:3306
Source Database       : xlj

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

Date: 2014-07-19 21:22:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for china
-- ----------------------------
DROP TABLE IF EXISTS `china`;
CREATE TABLE `china` (
  `Id` int(11) NOT NULL,
  `Name` varchar(40) default NULL,
  `Pid` int(11) default NULL,
  PRIMARY KEY  (`Id`),
  KEY `FK_CHINA_REFERENCE_CHINA` (`Pid`),
  CONSTRAINT `FK_CHINA_REFERENCE_CHINA` FOREIGN KEY (`Pid`) REFERENCES `china` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of china
-- ----------------------------
INSERT INTO `china` VALUES ('0', '中國', '0');
INSERT INTO `china` VALUES ('110000', '北京市', '0');
INSERT INTO `china` VALUES ('110100', '東城區', '110000');
INSERT INTO `china` VALUES ('110200', '西城區', '110000');
INSERT INTO `china` VALUES ('110500', '朝陽區', '110000');
INSERT INTO `china` VALUES ('110600', '豐台區', '110000');
INSERT INTO `china` VALUES ('110700', '石景山區', '110000');
INSERT INTO `china` VALUES ('110800', '海澱區', '110000');
INSERT INTO `china` VALUES ('110900', '門頭溝區', '110000');
INSERT INTO `china` VALUES ('111100', '房山區', '110000');
INSERT INTO `china` VALUES ('111200', '通州區', '110000');
INSERT INTO `china` VALUES ('111300', '順義區', '110000');
INSERT INTO `china` VALUES ('111400', '昌平區', '110000');
INSERT INTO `china` VALUES ('111500', '大興區', '110000');
INSERT INTO `china` VALUES ('111600', '懷柔區', '110000');
INSERT INTO `china` VALUES ('111700', '平谷區', '110000');
INSERT INTO `china` VALUES ('112800', '密雲縣', '110000');
INSERT INTO `china` VALUES ('112900', '延慶縣', '110000');
INSERT INTO `china` VALUES ('120000', '天津市', '0');
INSERT INTO `china` VALUES ('120100', '和平區', '120000');
INSERT INTO `china` VALUES ('120200', '河東區', '120000');
INSERT INTO `china` VALUES ('120300', '河西區', '120000');
INSERT INTO `china` VALUES ('120400', '南開區', '120000');
INSERT INTO `china` VALUES ('120500', '河北區', '120000');
INSERT INTO `china` VALUES ('120600', '紅橋區', '120000');
INSERT INTO `china` VALUES ('120900', '濱海新區', '120000');
INSERT INTO `china` VALUES ('121000', '東麗區', '120000');
INSERT INTO `china` VALUES ('121100', '西青區', '120000');
INSERT INTO `china` VALUES ('121200', '津南區', '120000');
INSERT INTO `china` VALUES ('121300', '北辰區', '120000');
INSERT INTO `china` VALUES ('121400', '武清區', '120000');
INSERT INTO `china` VALUES ('121500', '寶坻區', '120000');
INSERT INTO `china` VALUES ('122100', '寧河縣', '120000');
INSERT INTO `china` VALUES ('122300', '靜海縣', '120000');
INSERT INTO `china` VALUES ('122500', '薊縣', '120000');
INSERT INTO `china` VALUES ('130000', '河北省', '0');
INSERT INTO `china` VALUES ('130100', '石家莊市', '130000');
INSERT INTO `china` VALUES ('130101', '市轄區', '130100');
INSERT INTO `china` VALUES ('130102', '長安區', '130101');
INSERT INTO `china` VALUES ('130103', '橋東區', '130101');
INSERT INTO `china` VALUES ('130104', '橋西區', '130101');
INSERT INTO `china` VALUES ('130105', '新華區', '130101');
INSERT INTO `china` VALUES ('130107', '井陉礦區', '130101');
INSERT INTO `china` VALUES ('130108', '裕華區', '130101');
INSERT INTO `china` VALUES ('130121', '井陉縣', '130100');
INSERT INTO `china` VALUES ('130123', '正定縣', '130100');
INSERT INTO `china` VALUES ('130124', '栾城縣', '130100');
INSERT INTO `china` VALUES ('130125', '行唐縣', '130100');
INSERT INTO `china` VALUES ('130126', '靈壽縣', '130100');
INSERT INTO `china` VALUES ('130127', '高邑縣', '130100');
INSERT INTO `china` VALUES ('130128', '深澤縣', '130100');
INSERT INTO `china` VALUES ('130129', '贊皇縣', '130100');
INSERT INTO `china` VALUES ('130130', '無極縣', '130100');
INSERT INTO `china` VALUES ('130131', '平山縣', '130100');
INSERT INTO `china` VALUES ('130132', '元氏縣', '130100');
INSERT INTO `china` VALUES ('130133', '趙縣', '130100');
INSERT INTO `china` VALUES ('130181', '辛集市', '130100');
INSERT INTO `china` VALUES ('130182', '藁城市', '130100');
INSERT INTO `china` VALUES ('130183', '晉州市', '130100');
INSERT INTO `china` VALUES ('130184', '新樂市', '130100');
INSERT INTO `china` VALUES ('130185', '鹿泉市', '130100');
INSERT INTO `china` VALUES ('130200', '唐山市', '130000');
INSERT INTO `china` VALUES ('130201', '市轄區', '130200');
INSERT INTO `china` VALUES ('130202', '路南區', '130201');
INSERT INTO `china` VALUES ('130203', '路北區', '130201');
INSERT INTO `china` VALUES ('130204', '古冶區', '130201');
INSERT INTO `china` VALUES ('130205', '開平區', '130201');
INSERT INTO `china` VALUES ('130207', '豐南區', '130201');
INSERT INTO `china` VALUES ('130208', '豐潤區', '130201');
INSERT INTO `china` VALUES ('130223', '灤縣', '130200');
INSERT INTO `china` VALUES ('130224', '灤南縣', '130200');
INSERT INTO `china` VALUES ('130225', '樂亭縣', '130200');
INSERT INTO `china` VALUES ('130227', '遷西縣', '130200');
INSERT INTO `china` VALUES ('130229', '玉田縣', '130200');
INSERT INTO `china` VALUES ('130230', '唐海縣', '130200');
INSERT INTO `china` VALUES ('130281', '遵化市', '130200');
INSERT INTO `china` VALUES ('130283', '遷安市', '130200');
INSERT INTO `china` VALUES ('130300', '秦皇島市', '130000');
INSERT INTO `china` VALUES ('130301', '海港區', '130300');
INSERT INTO `china` VALUES ('130303', '山海關區', '130300');
INSERT INTO `china` VALUES ('130304', '北戴河區', '130300');
INSERT INTO `china` VALUES ('130321', '青龍滿族自治縣', '130300');
INSERT INTO `china` VALUES ('130322', '昌黎縣', '130300');
INSERT INTO `china` VALUES ('130323', '撫寧縣', '130300');
INSERT INTO `china` VALUES ('130324', '盧龍縣', '130300');
INSERT INTO `china` VALUES ('130400', '邯鄲市', '130000');
INSERT INTO `china` VALUES ('130401', '市轄區', '130400');
INSERT INTO `china` VALUES ('130402', '邯山區', '130401');
INSERT INTO `china` VALUES ('130403', '叢台區', '130401');
INSERT INTO `china` VALUES ('130404', '復興區', '130401');
INSERT INTO `china` VALUES ('130406', '峰峰礦區', '130401');
INSERT INTO `china` VALUES ('130421', '邯鄲縣', '130400');
INSERT INTO `china` VALUES ('130423', '臨漳縣', '130400');
INSERT INTO `china` VALUES ('130424', '成安縣', '130400');
INSERT INTO `china` VALUES ('130425', '大名縣', '130400');
INSERT INTO `china` VALUES ('130426', '涉縣', '130400');
INSERT INTO `china` VALUES ('130427', '磁縣', '130400');
INSERT INTO `china` VALUES ('130428', '肥鄉縣', '130400');
INSERT INTO `china` VALUES ('130429', '永年縣', '130400');
INSERT INTO `china` VALUES ('130430', '邱縣', '130400');
INSERT INTO `china` VALUES ('130431', '雞澤縣', '130400');
INSERT INTO `china` VALUES ('130432', '廣平縣', '130400');
INSERT INTO `china` VALUES ('130433', '館陶縣', '130400');
INSERT INTO `china` VALUES ('130434', '魏縣', '130400');
INSERT INTO `china` VALUES ('130435', '曲周縣', '130400');
INSERT INTO `china` VALUES ('130481', '武安市', '130400');
INSERT INTO `china` VALUES ('130500', '邢台市', '130000');
INSERT INTO `china` VALUES ('130501', '市轄區', '130500');
INSERT INTO `china` VALUES ('130502', '橋東區', '130501');
INSERT INTO `china` VALUES ('130503', '橋西區', '130501');
INSERT INTO `china` VALUES ('130521', '邢台縣', '130500');
INSERT INTO `china` VALUES ('130522', '臨城縣', '130500');
INSERT INTO `china` VALUES ('130523', '內丘縣', '130500');
INSERT INTO `china` VALUES ('130524', '柏鄉縣', '130500');
INSERT INTO `china` VALUES ('130525', '隆堯縣', '130500');
INSERT INTO `china` VALUES ('130526', '任縣', '130500');
INSERT INTO `china` VALUES ('130527', '南和縣', '130500');
INSERT INTO `china` VALUES ('130528', '寧晉縣', '130500');
INSERT INTO `china` VALUES ('130529', '巨鹿縣', '130529');
INSERT INTO `china` VALUES ('130530', '新河縣', '130500');
INSERT INTO `china` VALUES ('130531', '廣宗縣', '130500');
INSERT INTO `china` VALUES ('130532', '平鄉縣', '130500');
INSERT INTO `china` VALUES ('130533', '威縣', '130500');
INSERT INTO `china` VALUES ('130534', '清河縣', '130500');
INSERT INTO `china` VALUES ('130535', '臨西縣', '130500');
INSERT INTO `china` VALUES ('130581', '南宮市', '130500');
INSERT INTO `china` VALUES ('130582', '沙河市', '130500');
INSERT INTO `china` VALUES ('130600', '保定市', '130000');
INSERT INTO `china` VALUES ('130601', '新市區', '130600');
INSERT INTO `china` VALUES ('130603', '北市區', '130600');
INSERT INTO `china` VALUES ('130604', '南市區', '130600');
INSERT INTO `china` VALUES ('130621', '滿城縣', '130600');
INSERT INTO `china` VALUES ('130622', '清苑縣', '130600');
INSERT INTO `china` VALUES ('130623', '涞水縣', '130600');
INSERT INTO `china` VALUES ('130624', '阜平縣', '130600');
INSERT INTO `china` VALUES ('130625', '徐水縣', '130600');
INSERT INTO `china` VALUES ('130626', '定興縣', '130600');
INSERT INTO `china` VALUES ('130627', '唐縣', '130600');
INSERT INTO `china` VALUES ('130628', '高陽縣', '130600');
INSERT INTO `china` VALUES ('130629', '容城縣', '130600');
INSERT INTO `china` VALUES ('130630', '涞源縣', '130600');
INSERT INTO `china` VALUES ('130631', '望都縣', '130600');
INSERT INTO `china` VALUES ('130632', '安新縣', '130600');
INSERT INTO `china` VALUES ('130633', '易縣', '130600');
INSERT INTO `china` VALUES ('130634', '曲陽縣', '130600');
INSERT INTO `china` VALUES ('130635', '蠡縣', '130600');
INSERT INTO `china` VALUES ('130636', '順平縣', '130600');
INSERT INTO `china` VALUES ('130637', '博野縣', '130600');
INSERT INTO `china` VALUES ('130638', '雄縣', '130600');
INSERT INTO `china` VALUES ('130681', '涿州市', '130600');
INSERT INTO `china` VALUES ('130682', '定州市', '130600');
INSERT INTO `china` VALUES ('130683', '安國市', '130600');
INSERT INTO `china` VALUES ('130684', '高碑店市', '130600');
INSERT INTO `china` VALUES ('130685', '白溝新城縣', '130600');
INSERT INTO `china` VALUES ('130700', '張家口市', '130000');
INSERT INTO `china` VALUES ('130701', '市轄區', '130700');
INSERT INTO `china` VALUES ('130702', '橋東區', '130701');
INSERT INTO `china` VALUES ('130703', '橋西區', '130701');
INSERT INTO `china` VALUES ('130705', '宣化區', '130701');
INSERT INTO `china` VALUES ('130706', '下花園區', '130701');
INSERT INTO `china` VALUES ('130721', '宣化縣', '130700');
INSERT INTO `china` VALUES ('130722', '張北縣', '130700');
INSERT INTO `china` VALUES ('130723', '康保縣', '130700');
INSERT INTO `china` VALUES ('130724', '沽源縣', '130700');
INSERT INTO `china` VALUES ('130725', '尚義縣', '130700');
INSERT INTO `china` VALUES ('130726', '蔚縣', '130700');
INSERT INTO `china` VALUES ('130727', '陽原縣', '130700');
INSERT INTO `china` VALUES ('130728', '懷安縣', '130700');
INSERT INTO `china` VALUES ('130729', '萬全縣', '130700');
INSERT INTO `china` VALUES ('130730', '懷來縣', '130700');
INSERT INTO `china` VALUES ('130731', '涿鹿縣', '130700');
INSERT INTO `china` VALUES ('130732', '赤城縣', '130700');
INSERT INTO `china` VALUES ('130733', '崇禮縣', '130700');
INSERT INTO `china` VALUES ('130800', '承德市', '130000');
INSERT INTO `china` VALUES ('130801', '市轄區', '130800');
INSERT INTO `china` VALUES ('130802', '雙橋區', '130801');
INSERT INTO `china` VALUES ('130803', '雙灤區', '130801');
INSERT INTO `china` VALUES ('130804', '鷹手營子礦區', '130801');
INSERT INTO `china` VALUES ('130821', '承德縣', '130800');
INSERT INTO `china` VALUES ('130822', '興隆縣', '130800');
INSERT INTO `china` VALUES ('130823', '平泉縣', '130800');
INSERT INTO `china` VALUES ('130824', '灤平縣', '130800');
INSERT INTO `china` VALUES ('130825', '隆化縣', '130800');
INSERT INTO `china` VALUES ('130826', '豐寧滿族自治縣', '130800');
INSERT INTO `china` VALUES ('130827', '寬城滿族自治縣', '130800');
INSERT INTO `china` VALUES ('130828', '圍場滿族蒙古族自治縣', '130800');
INSERT INTO `china` VALUES ('130900', '滄州市', '130000');
INSERT INTO `china` VALUES ('130901', '市轄區', '130900');
INSERT INTO `china` VALUES ('130902', '新華區', '130901');
INSERT INTO `china` VALUES ('130903', '運河區', '130901');
INSERT INTO `china` VALUES ('130921', '滄縣', '130900');
INSERT INTO `china` VALUES ('130922', '青縣', '130900');
INSERT INTO `china` VALUES ('130923', '東光縣', '130900');
INSERT INTO `china` VALUES ('130924', '海興縣', '130900');
INSERT INTO `china` VALUES ('130925', '鹽山縣', '130900');
INSERT INTO `china` VALUES ('130926', '肅寧縣', '130900');
INSERT INTO `china` VALUES ('130927', '南皮縣', '130900');
INSERT INTO `china` VALUES ('130928', '吳橋縣', '130900');
INSERT INTO `china` VALUES ('130929', '獻縣', '130900');
INSERT INTO `china` VALUES ('130930', '孟村回族自治縣', '130900');
INSERT INTO `china` VALUES ('130981', '泊頭市', '130900');
INSERT INTO `china` VALUES ('130982', '任丘市', '130900');
INSERT INTO `china` VALUES ('130983', '黃骅市', '130900');
INSERT INTO `china` VALUES ('130984', '河間市', '130900');
INSERT INTO `china` VALUES ('131000', '廊坊市', '130000');
INSERT INTO `china` VALUES ('131001', '市轄區', '131000');
INSERT INTO `china` VALUES ('131002', '安次區', '131001');
INSERT INTO `china` VALUES ('131003', '廣陽區', '131001');
INSERT INTO `china` VALUES ('131022', '固安縣', '131000');
INSERT INTO `china` VALUES ('131023', '永清縣', '131000');
INSERT INTO `china` VALUES ('131024', '香河縣', '131000');
INSERT INTO `china` VALUES ('131025', '大城縣', '131000');
INSERT INTO `china` VALUES ('131026', '文安縣', '131000');
INSERT INTO `china` VALUES ('131028', '大廠回族自治縣', '131000');
INSERT INTO `china` VALUES ('131081', '霸州市', '131000');
INSERT INTO `china` VALUES ('131082', '三河市', '131000');
INSERT INTO `china` VALUES ('131100', '衡水市', '130000');
INSERT INTO `china` VALUES ('131101', '市轄區', '131100');
INSERT INTO `china` VALUES ('131102', '桃城區', '131101');
INSERT INTO `china` VALUES ('131121', '棗強縣', '131100');
INSERT INTO `china` VALUES ('131122', '武邑縣', '131100');
INSERT INTO `china` VALUES ('131123', '武強縣', '131100');
INSERT INTO `china` VALUES ('131124', '饒陽縣', '131100');
INSERT INTO `china` VALUES ('131125', '安平縣', '131100');
INSERT INTO `china` VALUES ('131126', '故城縣', '131100');
INSERT INTO `china` VALUES ('131127', '景縣', '131100');
INSERT INTO `china` VALUES ('131128', '阜城縣', '131100');
INSERT INTO `china` VALUES ('131181', '冀州市', '131100');
INSERT INTO `china` VALUES ('131182', '深州市', '131100');
INSERT INTO `china` VALUES ('140000', '山西省', '0');
INSERT INTO `china` VALUES ('140100', '太原市', '140000');
INSERT INTO `china` VALUES ('140101', '市轄區', '140100');
INSERT INTO `china` VALUES ('140105', '小店區', '140101');
INSERT INTO `china` VALUES ('140106', '迎澤區', '140101');
INSERT INTO `china` VALUES ('140107', '杏花嶺區', '140101');
INSERT INTO `china` VALUES ('140108', '尖草坪區', '140101');
INSERT INTO `china` VALUES ('140109', '萬柏林區', '140101');
INSERT INTO `china` VALUES ('140110', '晉源區', '140101');
INSERT INTO `china` VALUES ('140121', '清徐縣', '140100');
INSERT INTO `china` VALUES ('140122', '陽曲縣', '140100');
INSERT INTO `china` VALUES ('140123', '婁煩縣', '140100');
INSERT INTO `china` VALUES ('140181', '古交市', '140100');
INSERT INTO `china` VALUES ('140200', '大同市', '140000');
INSERT INTO `china` VALUES ('140201', '市轄區', '140200');
INSERT INTO `china` VALUES ('140202', '城區', '140201');
INSERT INTO `china` VALUES ('140203', '礦區', '140201');
INSERT INTO `china` VALUES ('140211', '南郊區', '140201');
INSERT INTO `china` VALUES ('140212', '新榮區', '140201');
INSERT INTO `china` VALUES ('140221', '陽高縣', '140200');
INSERT INTO `china` VALUES ('140222', '天鎮縣', '140200');
INSERT INTO `china` VALUES ('140223', '廣靈縣', '140200');
INSERT INTO `china` VALUES ('140224', '靈丘縣', '140200');
INSERT INTO `china` VALUES ('140225', '渾源縣', '140200');
INSERT INTO `china` VALUES ('140226', '左雲縣', '140200');
INSERT INTO `china` VALUES ('140227', '大同縣', '140200');
INSERT INTO `china` VALUES ('140300', '陽泉市', '140000');
INSERT INTO `china` VALUES ('140301', '市轄區', '140300');
INSERT INTO `china` VALUES ('140302', '城區', '140301');
INSERT INTO `china` VALUES ('140303', '礦區', '140301');
INSERT INTO `china` VALUES ('140311', '郊區', '140301');
INSERT INTO `china` VALUES ('140321', '平定縣', '140300');
INSERT INTO `china` VALUES ('140322', '盂縣', '140300');
INSERT INTO `china` VALUES ('140400', '長治市', '140000');
INSERT INTO `china` VALUES ('140401', '市轄區', '140400');
INSERT INTO `china` VALUES ('140402', '城區', '140401');
INSERT INTO `china` VALUES ('140411', '郊區', '140401');
INSERT INTO `china` VALUES ('140421', '長治縣', '140400');
INSERT INTO `china` VALUES ('140423', '襄垣縣', '140400');
INSERT INTO `china` VALUES ('140424', '屯留縣', '140400');
INSERT INTO `china` VALUES ('140425', '平順縣', '140400');
INSERT INTO `china` VALUES ('140426', '黎城縣', '140400');
INSERT INTO `china` VALUES ('140427', '壺關縣', '140400');
INSERT INTO `china` VALUES ('140428', '長子縣', '140400');
INSERT INTO `china` VALUES ('140429', '武鄉縣', '140400');
INSERT INTO `china` VALUES ('140430', '沁縣', '140400');
INSERT INTO `china` VALUES ('140431', '沁源縣', '140400');
INSERT INTO `china` VALUES ('140481', '潞城市', '140400');
INSERT INTO `china` VALUES ('140500', '晉城市', '140000');
INSERT INTO `china` VALUES ('140501', '市轄區', '140500');
INSERT INTO `china` VALUES ('140502', '城區', '140501');
INSERT INTO `china` VALUES ('140521', '沁水縣', '140500');
INSERT INTO `china` VALUES ('140522', '陽城縣', '140500');
INSERT INTO `china` VALUES ('140524', '陵川縣', '140500');
INSERT INTO `china` VALUES ('140525', '澤州縣', '140500');
INSERT INTO `china` VALUES ('140581', '高平市', '140500');
INSERT INTO `china` VALUES ('140600', '朔州市', '140000');
INSERT INTO `china` VALUES ('140601', '市轄區', '140600');
INSERT INTO `china` VALUES ('140602', '朔城區', '140601');
INSERT INTO `china` VALUES ('140603', '平魯區', '140601');
INSERT INTO `china` VALUES ('140621', '山陰縣', '140600');
INSERT INTO `china` VALUES ('140622', '應縣', '140600');
INSERT INTO `china` VALUES ('140623', '右玉縣', '140600');
INSERT INTO `china` VALUES ('140624', '懷仁縣', '140600');
INSERT INTO `china` VALUES ('140700', '晉中市', '140000');
INSERT INTO `china` VALUES ('140701', '市轄區', '140700');
INSERT INTO `china` VALUES ('140702', '榆次區', '140701');
INSERT INTO `china` VALUES ('140721', '榆社縣', '140700');
INSERT INTO `china` VALUES ('140722', '左權縣', '140700');
INSERT INTO `china` VALUES ('140723', '和順縣', '140700');
INSERT INTO `china` VALUES ('140724', '昔陽縣', '140700');
INSERT INTO `china` VALUES ('140725', '壽陽縣', '140700');
INSERT INTO `china` VALUES ('140726', '太谷縣', '140700');
INSERT INTO `china` VALUES ('140727', '祁縣', '140700');
INSERT INTO `china` VALUES ('140728', '平遙縣', '140700');
INSERT INTO `china` VALUES ('140729', '靈石縣', '140700');
INSERT INTO `china` VALUES ('140781', '介休市', '140700');
INSERT INTO `china` VALUES ('140800', '運城市', '140000');
INSERT INTO `china` VALUES ('140801', '市轄區', '140800');
INSERT INTO `china` VALUES ('140802', '鹽湖區', '140801');
INSERT INTO `china` VALUES ('140821', '臨猗縣', '140800');
INSERT INTO `china` VALUES ('140822', '萬榮縣', '140800');
INSERT INTO `china` VALUES ('140823', '聞喜縣', '140800');
INSERT INTO `china` VALUES ('140824', '稷山縣', '140800');
INSERT INTO `china` VALUES ('140825', '新绛縣', '140800');
INSERT INTO `china` VALUES ('140826', '绛縣', '140800');
INSERT INTO `china` VALUES ('140827', '垣曲縣', '140800');
INSERT INTO `china` VALUES ('140828', '夏縣', '140800');
INSERT INTO `china` VALUES ('140829', '平陸縣', '140800');
INSERT INTO `china` VALUES ('140830', '芮城縣', '140800');
INSERT INTO `china` VALUES ('140881', '永濟市', '140800');
INSERT INTO `china` VALUES ('140882', '河津市', '140800');
INSERT INTO `china` VALUES ('140900', '忻州市', '140000');
INSERT INTO `china` VALUES ('140901', '忻府區', '140900');
INSERT INTO `china` VALUES ('140921', '定襄縣', '140900');
INSERT INTO `china` VALUES ('140922', '五台縣', '140900');
INSERT INTO `china` VALUES ('140923', '代縣', '140900');
INSERT INTO `china` VALUES ('140924', '繁峙縣', '140900');
INSERT INTO `china` VALUES ('140925', '寧武縣', '140900');
INSERT INTO `china` VALUES ('140926', '靜樂縣', '140900');
INSERT INTO `china` VALUES ('140927', '神池縣', '140900');
INSERT INTO `china` VALUES ('140928', '五寨縣', '140900');
INSERT INTO `china` VALUES ('140929', '岢岚縣', '140900');
INSERT INTO `china` VALUES ('140930', '河曲縣', '140900');
INSERT INTO `china` VALUES ('140931', '保德縣', '140900');
INSERT INTO `china` VALUES ('140932', '偏關縣', '140900');
INSERT INTO `china` VALUES ('140981', '原平市', '140900');
INSERT INTO `china` VALUES ('141000', '臨汾市', '140000');
INSERT INTO `china` VALUES ('141001', '市轄區', '141000');
INSERT INTO `china` VALUES ('141002', '堯都區', '141000');
INSERT INTO `china` VALUES ('141021', '曲沃縣', '141000');
INSERT INTO `china` VALUES ('141022', '翼城縣', '141000');
INSERT INTO `china` VALUES ('141023', '襄汾縣', '141000');
INSERT INTO `china` VALUES ('141024', '洪洞縣', '141000');
INSERT INTO `china` VALUES ('141025', '古縣', '141000');
INSERT INTO `china` VALUES ('141026', '安澤縣', '141000');
INSERT INTO `china` VALUES ('141027', '浮山縣', '141000');
INSERT INTO `china` VALUES ('141028', '吉縣', '141000');
INSERT INTO `china` VALUES ('141029', '鄉寧縣', '141000');
INSERT INTO `china` VALUES ('141030', '大寧縣', '141000');
INSERT INTO `china` VALUES ('141031', '隰縣', '141000');
INSERT INTO `china` VALUES ('141032', '永和縣', '141000');
INSERT INTO `china` VALUES ('141033', '蒲縣', '141000');
INSERT INTO `china` VALUES ('141034', '汾西縣', '141000');
INSERT INTO `china` VALUES ('141081', '侯馬市', '141000');
INSERT INTO `china` VALUES ('141082', '霍州市', '141000');
INSERT INTO `china` VALUES ('141100', '呂梁市', '140000');
INSERT INTO `china` VALUES ('141101', '市轄區', '141100');
INSERT INTO `china` VALUES ('141102', '離石區', '141101');
INSERT INTO `china` VALUES ('141121', '文水縣', '141100');
INSERT INTO `china` VALUES ('141122', '交城縣', '141100');
INSERT INTO `china` VALUES ('141123', '興縣', '141100');
INSERT INTO `china` VALUES ('141124', '臨縣', '141100');
INSERT INTO `china` VALUES ('141125', '柳林縣', '141100');
INSERT INTO `china` VALUES ('141126', '石樓縣', '141100');
INSERT INTO `china` VALUES ('141127', '岚縣', '141100');
INSERT INTO `china` VALUES ('141128', '方山縣', '141100');
INSERT INTO `china` VALUES ('141129', '中陽縣', '141100');
INSERT INTO `china` VALUES ('141130', '交口縣', '141100');
INSERT INTO `china` VALUES ('141181', '孝義市', '141100');
INSERT INTO `china` VALUES ('141182', '汾陽市', '141100');
INSERT INTO `china` VALUES ('150000', '內蒙古自治區', '0');
INSERT INTO `china` VALUES ('150100', '呼和浩特市', '150000');
INSERT INTO `china` VALUES ('150101', '市轄區', '150100');
INSERT INTO `china` VALUES ('150102', '新城區', '150101');
INSERT INTO `china` VALUES ('150103', '回民區', '150101');
INSERT INTO `china` VALUES ('150104', '玉泉區', '150101');
INSERT INTO `china` VALUES ('150105', '賽罕區', '150101');
INSERT INTO `china` VALUES ('150121', '土默特左旗', '150100');
INSERT INTO `china` VALUES ('150122', '托克托縣', '150100');
INSERT INTO `china` VALUES ('150123', '和林格爾縣', '150100');
INSERT INTO `china` VALUES ('150124', '清水河縣', '150100');
INSERT INTO `china` VALUES ('150125', '武川縣', '150100');
INSERT INTO `china` VALUES ('150200', '包頭市', '150000');
INSERT INTO `china` VALUES ('150201', '市轄區', '150200');
INSERT INTO `china` VALUES ('150202', '東河區', '150201');
INSERT INTO `china` VALUES ('150203', '昆都侖區', '150201');
INSERT INTO `china` VALUES ('150204', '青山區', '150201');
INSERT INTO `china` VALUES ('150205', '石拐區', '150201');
INSERT INTO `china` VALUES ('150206', '白雲礦區', '150201');
INSERT INTO `china` VALUES ('150207', '九原區', '150201');
INSERT INTO `china` VALUES ('150221', '土默特右旗', '150200');
INSERT INTO `china` VALUES ('150222', '固陽縣', '150200');
INSERT INTO `china` VALUES ('150223', '達爾罕茂明安聯合旗', '150200');
INSERT INTO `china` VALUES ('150300', '烏海市', '150000');
INSERT INTO `china` VALUES ('150301', '市轄區', '150300');
INSERT INTO `china` VALUES ('150302', '海勃灣區', '150301');
INSERT INTO `china` VALUES ('150303', '海南區', '150301');
INSERT INTO `china` VALUES ('150304', '烏達區', '150301');
INSERT INTO `china` VALUES ('150400', '赤峰市', '150000');
INSERT INTO `china` VALUES ('150401', '市轄區', '150400');
INSERT INTO `china` VALUES ('150402', '紅山區', '150401');
INSERT INTO `china` VALUES ('150403', '元寶山區', '150401');
INSERT INTO `china` VALUES ('150404', '松山區', '150401');
INSERT INTO `china` VALUES ('150421', '阿魯科爾沁旗', '150400');
INSERT INTO `china` VALUES ('150422', '巴林左旗', '150400');
INSERT INTO `china` VALUES ('150423', '巴林右旗', '150400');
INSERT INTO `china` VALUES ('150424', '林西縣', '150400');
INSERT INTO `china` VALUES ('150425', '克什克騰旗', '150400');
INSERT INTO `china` VALUES ('150426', '翁牛特旗', '150400');
INSERT INTO `china` VALUES ('150428', '喀喇沁旗', '150400');
INSERT INTO `china` VALUES ('150429', '寧城縣', '150400');
INSERT INTO `china` VALUES ('150430', '敖漢旗', '150400');
INSERT INTO `china` VALUES ('150500', '通遼市', '150000');
INSERT INTO `china` VALUES ('150501', '市轄區', '150500');
INSERT INTO `china` VALUES ('150502', '科爾沁區', '150501');
INSERT INTO `china` VALUES ('150521', '科爾沁左翼中旗', '150500');
INSERT INTO `china` VALUES ('150522', '科爾沁左翼後旗', '150500');
INSERT INTO `china` VALUES ('150523', '開魯縣', '150500');
INSERT INTO `china` VALUES ('150524', '庫倫旗', '150500');
INSERT INTO `china` VALUES ('150525', '奈曼旗', '150500');
INSERT INTO `china` VALUES ('150526', '扎魯特旗', '150500');
INSERT INTO `china` VALUES ('150581', '霍林郭勒市', '150500');
INSERT INTO `china` VALUES ('150600', '鄂爾多斯市', '150000');
INSERT INTO `china` VALUES ('150602', '東勝區', '150600');
INSERT INTO `china` VALUES ('150621', '達拉特旗', '150600');
INSERT INTO `china` VALUES ('150622', '准格爾旗', '150600');
INSERT INTO `china` VALUES ('150623', '鄂托克前旗', '150600');
INSERT INTO `china` VALUES ('150624', '鄂托克旗', '150600');
INSERT INTO `china` VALUES ('150625', '杭錦旗', '150600');
INSERT INTO `china` VALUES ('150626', '烏審旗', '150600');
INSERT INTO `china` VALUES ('150627', '伊金霍洛旗', '150600');
INSERT INTO `china` VALUES ('150700', '呼倫貝爾市', '150000');
INSERT INTO `china` VALUES ('150701', '市轄區', '150700');
INSERT INTO `china` VALUES ('150702', '海拉爾區', '150701');
INSERT INTO `china` VALUES ('150721', '阿榮旗', '150700');
INSERT INTO `china` VALUES ('150722', '莫力達瓦達斡爾族自治旗', '150700');
INSERT INTO `china` VALUES ('150723', '鄂倫春自治旗', '150700');
INSERT INTO `china` VALUES ('150724', '鄂溫克族自治旗', '150700');
INSERT INTO `china` VALUES ('150725', '陳巴爾虎旗', '150700');
INSERT INTO `china` VALUES ('150726', '新巴爾虎左旗', '150700');
INSERT INTO `china` VALUES ('150727', '新巴爾虎右旗', '150700');
INSERT INTO `china` VALUES ('150781', '滿洲裡市', '150700');
INSERT INTO `china` VALUES ('150782', '牙克石市', '150700');
INSERT INTO `china` VALUES ('150783', '扎蘭屯市', '150700');
INSERT INTO `china` VALUES ('150784', '額爾古納市', '150700');
INSERT INTO `china` VALUES ('150785', '根河市', '150700');
INSERT INTO `china` VALUES ('150800', '巴彥淖爾市', '150000');
INSERT INTO `china` VALUES ('150801', '市轄區', '150800');
INSERT INTO `china` VALUES ('150802', '臨河區', '150800');
INSERT INTO `china` VALUES ('150821', '五原縣', '150800');
INSERT INTO `china` VALUES ('150822', '磴口縣', '150800');
INSERT INTO `china` VALUES ('150823', '烏拉特前旗', '150800');
INSERT INTO `china` VALUES ('150824', '烏拉特中旗', '150800');
INSERT INTO `china` VALUES ('150825', '烏拉特後旗', '150800');
INSERT INTO `china` VALUES ('150826', '杭錦後旗', '150800');
INSERT INTO `china` VALUES ('150900', '烏蘭察布市', '150000');
INSERT INTO `china` VALUES ('150901', '市轄區', '150900');
INSERT INTO `china` VALUES ('150902', '集寧區', '150901');
INSERT INTO `china` VALUES ('150921', '卓資縣', '150900');
INSERT INTO `china` VALUES ('150922', '化德縣', '150900');
INSERT INTO `china` VALUES ('150923', '商都縣', '150900');
INSERT INTO `china` VALUES ('150924', '興和縣', '150900');
INSERT INTO `china` VALUES ('150925', '涼城縣', '150900');
INSERT INTO `china` VALUES ('150926', '察哈爾右翼前旗', '150900');
INSERT INTO `china` VALUES ('150927', '察哈爾右翼中旗', '150900');
INSERT INTO `china` VALUES ('150928', '察哈爾右翼後旗', '150900');
INSERT INTO `china` VALUES ('150929', '四子王旗', '150900');
INSERT INTO `china` VALUES ('150981', '豐鎮市', '150900');
INSERT INTO `china` VALUES ('152200', '興安盟', '150000');
INSERT INTO `china` VALUES ('152201', '烏蘭浩特市', '152200');
INSERT INTO `china` VALUES ('152202', '阿爾山市', '152200');
INSERT INTO `china` VALUES ('152221', '科爾沁右翼前旗', '152200');
INSERT INTO `china` VALUES ('152222', '科爾沁右翼中旗', '152200');
INSERT INTO `china` VALUES ('152223', '扎赉特旗', '152200');
INSERT INTO `china` VALUES ('152224', '突泉縣', '152200');
INSERT INTO `china` VALUES ('152500', '錫林郭勒盟', '150000');
INSERT INTO `china` VALUES ('152501', '二連浩特市', '152500');
INSERT INTO `china` VALUES ('152502', '錫林浩特市', '152500');
INSERT INTO `china` VALUES ('152522', '阿巴嘎旗', '152500');
INSERT INTO `china` VALUES ('152523', '蘇尼特左旗', '152500');
INSERT INTO `china` VALUES ('152524', '蘇尼特右旗', '152500');
INSERT INTO `china` VALUES ('152525', '東烏珠穆沁旗', '152500');
INSERT INTO `china` VALUES ('152526', '西烏珠穆沁旗', '152500');
INSERT INTO `china` VALUES ('152527', '太僕寺旗', '152500');
INSERT INTO `china` VALUES ('152528', '鑲黃旗', '152500');
INSERT INTO `china` VALUES ('152529', '正鑲白旗', '152500');
INSERT INTO `china` VALUES ('152530', '正藍旗', '152500');
INSERT INTO `china` VALUES ('152531', '多倫縣', '152500');
INSERT INTO `china` VALUES ('152900', '阿拉善盟', '150000');
INSERT INTO `china` VALUES ('152921', '阿拉善左旗', '152900');
INSERT INTO `china` VALUES ('152922', '阿拉善右旗', '152900');
INSERT INTO `china` VALUES ('152923', '額濟納旗', '152900');
INSERT INTO `china` VALUES ('210000', '遼寧省', '0');
INSERT INTO `china` VALUES ('210100', '沈陽市', '210000');
INSERT INTO `china` VALUES ('210101', '市轄區', '210100');
INSERT INTO `china` VALUES ('210102', '和平區', '210101');
INSERT INTO `china` VALUES ('210103', '沈河區', '210101');
INSERT INTO `china` VALUES ('210104', '大東區', '210101');
INSERT INTO `china` VALUES ('210105', '皇姑區', '210101');
INSERT INTO `china` VALUES ('210106', '鐵西區', '210101');
INSERT INTO `china` VALUES ('210111', '蘇家屯區', '210101');
INSERT INTO `china` VALUES ('210112', '東陵區', '210101');
INSERT INTO `china` VALUES ('210113', '新城子區', '210101');
INSERT INTO `china` VALUES ('210114', '於洪區', '210101');
INSERT INTO `china` VALUES ('210122', '遼中縣', '210100');
INSERT INTO `china` VALUES ('210123', '康平縣', '210100');
INSERT INTO `china` VALUES ('210124', '法庫縣', '210100');
INSERT INTO `china` VALUES ('210181', '新民市', '210100');
INSERT INTO `china` VALUES ('210182', '沈北新區', '210100');
INSERT INTO `china` VALUES ('210200', '大連市', '210000');
INSERT INTO `china` VALUES ('210201', '市轄區', '210200');
INSERT INTO `china` VALUES ('210202', '中山區', '210201');
INSERT INTO `china` VALUES ('210203', '西崗區', '210201');
INSERT INTO `china` VALUES ('210204', '沙河口區', '210201');
INSERT INTO `china` VALUES ('210211', '甘井子區', '210201');
INSERT INTO `china` VALUES ('210212', '旅順口區', '210201');
INSERT INTO `china` VALUES ('210213', '金州區', '210201');
INSERT INTO `china` VALUES ('210224', '長海縣', '210200');
INSERT INTO `china` VALUES ('210281', '瓦房店市', '210200');
INSERT INTO `china` VALUES ('210282', '普蘭店市', '210200');
INSERT INTO `china` VALUES ('210283', '莊河市', '210200');
INSERT INTO `china` VALUES ('210300', '鞍山市', '210000');
INSERT INTO `china` VALUES ('210301', '市轄區', '210300');
INSERT INTO `china` VALUES ('210302', '鐵東區', '210301');
INSERT INTO `china` VALUES ('210303', '鐵西區', '210301');
INSERT INTO `china` VALUES ('210304', '立山區', '210301');
INSERT INTO `china` VALUES ('210311', '千山區', '210301');
INSERT INTO `china` VALUES ('210321', '台安縣', '210300');
INSERT INTO `china` VALUES ('210323', '岫巖滿族自治縣', '210300');
INSERT INTO `china` VALUES ('210381', '海城市', '210300');
INSERT INTO `china` VALUES ('210400', '撫順市', '210000');
INSERT INTO `china` VALUES ('210401', '市轄區', '210400');
INSERT INTO `china` VALUES ('210402', '新撫區', '210401');
INSERT INTO `china` VALUES ('210403', '東洲區', '210401');
INSERT INTO `china` VALUES ('210404', '望花區', '210401');
INSERT INTO `china` VALUES ('210411', '順城區', '210401');
INSERT INTO `china` VALUES ('210421', '撫順縣', '210400');
INSERT INTO `china` VALUES ('210422', '新賓滿族自治縣', '210400');
INSERT INTO `china` VALUES ('210423', '清原滿族自治縣', '210400');
INSERT INTO `china` VALUES ('210500', '本溪市', '210000');
INSERT INTO `china` VALUES ('210501', '市轄區', '210500');
INSERT INTO `china` VALUES ('210502', '平山區', '210501');
INSERT INTO `china` VALUES ('210503', '溪湖??', '210501');
INSERT INTO `china` VALUES ('210504', '明山區', '210501');
INSERT INTO `china` VALUES ('210505', '南芬區', '210501');
INSERT INTO `china` VALUES ('210521', '本溪滿族自治縣', '210500');
INSERT INTO `china` VALUES ('210522', '桓仁滿族自治縣', '210500');
INSERT INTO `china` VALUES ('210600', '丹東市', '210000');
INSERT INTO `china` VALUES ('210601', '市轄區', '210600');
INSERT INTO `china` VALUES ('210602', '元寶區', '210601');
INSERT INTO `china` VALUES ('210603', '振興區', '210601');
INSERT INTO `china` VALUES ('210604', '振安區', '210601');
INSERT INTO `china` VALUES ('210624', '寬甸滿族自治縣', '210600');
INSERT INTO `china` VALUES ('210681', '東港市', '210600');
INSERT INTO `china` VALUES ('210682', '鳳城市', '210600');
INSERT INTO `china` VALUES ('210700', '錦州市', '210000');
INSERT INTO `china` VALUES ('210701', '市轄區', '210700');
INSERT INTO `china` VALUES ('210702', '古塔區', '210701');
INSERT INTO `china` VALUES ('210703', '凌河區', '210701');
INSERT INTO `china` VALUES ('210711', '太和區', '210701');
INSERT INTO `china` VALUES ('210726', '黑山縣', '210700');
INSERT INTO `china` VALUES ('210727', '義縣', '210700');
INSERT INTO `china` VALUES ('210781', '凌海市', '210700');
INSERT INTO `china` VALUES ('210782', '北寧市', '210700');
INSERT INTO `china` VALUES ('210800', '營口市', '210000');
INSERT INTO `china` VALUES ('210801', '市轄區', '210800');
INSERT INTO `china` VALUES ('210802', '站前區', '210801');
INSERT INTO `china` VALUES ('210803', '西市區', '210801');
INSERT INTO `china` VALUES ('210804', '鲅魚圈區', '210801');
INSERT INTO `china` VALUES ('210811', '老邊區', '210801');
INSERT INTO `china` VALUES ('210881', '蓋州市', '210800');
INSERT INTO `china` VALUES ('210882', '大石橋市', '210800');
INSERT INTO `china` VALUES ('210900', '阜新市', '210000');
INSERT INTO `china` VALUES ('210901', '市轄區', '210900');
INSERT INTO `china` VALUES ('210902', '海州區', '210901');
INSERT INTO `china` VALUES ('210903', '新邱區', '210901');
INSERT INTO `china` VALUES ('210904', '太平區', '210901');
INSERT INTO `china` VALUES ('210905', '清河門區', '210901');
INSERT INTO `china` VALUES ('210911', '細河區', '210901');
INSERT INTO `china` VALUES ('210921', '阜新蒙古族自治縣', '210900');
INSERT INTO `china` VALUES ('210922', '彰武縣', '210900');
INSERT INTO `china` VALUES ('211000', '遼陽市', '210000');
INSERT INTO `china` VALUES ('211001', '市轄區', '211000');
INSERT INTO `china` VALUES ('211002', '白塔區', '211001');
INSERT INTO `china` VALUES ('211003', '文聖區', '211001');
INSERT INTO `china` VALUES ('211004', '宏偉區', '211001');
INSERT INTO `china` VALUES ('211005', '弓長嶺區', '211001');
INSERT INTO `china` VALUES ('211011', '太子河區', '211001');
INSERT INTO `china` VALUES ('211021', '遼陽縣', '211000');
INSERT INTO `china` VALUES ('211081', '燈塔市', '211000');
INSERT INTO `china` VALUES ('211100', '盤錦市', '210000');
INSERT INTO `china` VALUES ('211101', '市轄區', '211100');
INSERT INTO `china` VALUES ('211102', '雙台子區', '211101');
INSERT INTO `china` VALUES ('211103', '興隆台區', '211101');
INSERT INTO `china` VALUES ('211121', '大窪縣', '211100');
INSERT INTO `china` VALUES ('211122', '盤山縣', '211100');
INSERT INTO `china` VALUES ('211200', '鐵嶺市', '210000');
INSERT INTO `china` VALUES ('211201', '市轄區', '211200');
INSERT INTO `china` VALUES ('211202', '銀州區', '211201');
INSERT INTO `china` VALUES ('211204', '清河區', '211201');
INSERT INTO `china` VALUES ('211221', '鐵嶺縣', '211200');
INSERT INTO `china` VALUES ('211223', '西豐縣', '211200');
INSERT INTO `china` VALUES ('211224', '昌圖縣', '211200');
INSERT INTO `china` VALUES ('211281', '調兵山市', '211200');
INSERT INTO `china` VALUES ('211282', '開原市', '211200');
INSERT INTO `china` VALUES ('211300', '朝陽市', '210000');
INSERT INTO `china` VALUES ('211301', '市轄區', '211300');
INSERT INTO `china` VALUES ('211302', '雙塔區', '211301');
INSERT INTO `china` VALUES ('211303', '龍城區', '211301');
INSERT INTO `china` VALUES ('211321', '朝陽縣', '211300');
INSERT INTO `china` VALUES ('211322', '建平縣', '211300');
INSERT INTO `china` VALUES ('211324', '喀喇沁左翼蒙古族自治縣', '211300');
INSERT INTO `china` VALUES ('211381', '北票市', '211300');
INSERT INTO `china` VALUES ('211382', '凌源市', '211300');
INSERT INTO `china` VALUES ('211400', '葫蘆島市', '210000');
INSERT INTO `china` VALUES ('211401', '市轄區', '211400');
INSERT INTO `china` VALUES ('211402', '連山區', '211401');
INSERT INTO `china` VALUES ('211403', '龍港區', '211401');
INSERT INTO `china` VALUES ('211404', '南票區', '211401');
INSERT INTO `china` VALUES ('211421', '綏中縣', '211400');
INSERT INTO `china` VALUES ('211422', '建昌縣', '211400');
INSERT INTO `china` VALUES ('211481', '興城市', '211400');
INSERT INTO `china` VALUES ('220000', '吉林省', '0');
INSERT INTO `china` VALUES ('220100', '長春市', '220000');
INSERT INTO `china` VALUES ('220101', '市轄區', '220100');
INSERT INTO `china` VALUES ('220102', '南關區', '220101');
INSERT INTO `china` VALUES ('220103', '寬城區', '220101');
INSERT INTO `china` VALUES ('220104', '朝陽區', '220101');
INSERT INTO `china` VALUES ('220105', '二道區', '220101');
INSERT INTO `china` VALUES ('220106', '綠園區', '220101');
INSERT INTO `china` VALUES ('220112', '雙陽區', '220101');
INSERT INTO `china` VALUES ('220122', '農安縣', '220100');
INSERT INTO `china` VALUES ('220181', '九台市', '220100');
INSERT INTO `china` VALUES ('220182', '榆樹市', '220100');
INSERT INTO `china` VALUES ('220183', '德惠市', '220100');
INSERT INTO `china` VALUES ('220200', '吉林市', '220000');
INSERT INTO `china` VALUES ('220201', '市轄區', '220200');
INSERT INTO `china` VALUES ('220202', '昌邑區', '220201');
INSERT INTO `china` VALUES ('220203', '龍潭區', '220201');
INSERT INTO `china` VALUES ('220204', '船營區', '220201');
INSERT INTO `china` VALUES ('220211', '豐滿區', '220201');
INSERT INTO `china` VALUES ('220221', '永吉縣', '220200');
INSERT INTO `china` VALUES ('220281', '蛟河市', '220200');
INSERT INTO `china` VALUES ('220282', '桦甸市', '220200');
INSERT INTO `china` VALUES ('220283', '舒蘭市', '220200');
INSERT INTO `china` VALUES ('220284', '磐石市', '220200');
INSERT INTO `china` VALUES ('220300', '四平市', '220000');
INSERT INTO `china` VALUES ('220301', '市轄區', '220300');
INSERT INTO `china` VALUES ('220302', '鐵西區', '220301');
INSERT INTO `china` VALUES ('220303', '鐵東區', '220301');
INSERT INTO `china` VALUES ('220322', '梨樹縣', '220300');
INSERT INTO `china` VALUES ('220323', '伊通滿族自治縣', '220300');
INSERT INTO `china` VALUES ('220381', '公主嶺市', '220300');
INSERT INTO `china` VALUES ('220382', '雙遼市', '220300');
INSERT INTO `china` VALUES ('220400', '遼源市', '220000');
INSERT INTO `china` VALUES ('220401', '市轄區', '220400');
INSERT INTO `china` VALUES ('220402', '龍山區', '220401');
INSERT INTO `china` VALUES ('220403', '西安區', '220401');
INSERT INTO `china` VALUES ('220421', '東豐縣', '220400');
INSERT INTO `china` VALUES ('220422', '東遼縣', '220400');
INSERT INTO `china` VALUES ('220500', '通化市', '220000');
INSERT INTO `china` VALUES ('220501', '市轄區', '220500');
INSERT INTO `china` VALUES ('220502', '東昌區', '220501');
INSERT INTO `china` VALUES ('220503', '二道江區', '220501');
INSERT INTO `china` VALUES ('220521', '通化縣', '220500');
INSERT INTO `china` VALUES ('220523', '輝南縣', '220500');
INSERT INTO `china` VALUES ('220524', '柳河縣', '220500');
INSERT INTO `china` VALUES ('220581', '梅河口市', '220500');
INSERT INTO `china` VALUES ('220582', '集安市', '220500');
INSERT INTO `china` VALUES ('220600', '白山市', '220000');
INSERT INTO `china` VALUES ('220601', '市轄區', '220600');
INSERT INTO `china` VALUES ('220602', '八道江區', '220601');
INSERT INTO `china` VALUES ('220621', '撫松縣', '220600');
INSERT INTO `china` VALUES ('220622', '靖宇縣', '220600');
INSERT INTO `china` VALUES ('220623', '長白朝鮮族自治縣', '220600');
INSERT INTO `china` VALUES ('220625', '江源區', '220600');
INSERT INTO `china` VALUES ('220681', '臨江市', '220600');
INSERT INTO `china` VALUES ('220700', '松原市', '220000');
INSERT INTO `china` VALUES ('220701', '市轄區', '220700');
INSERT INTO `china` VALUES ('220702', '寧江區', '220701');
INSERT INTO `china` VALUES ('220721', '前郭爾羅斯蒙古族自治縣', '220700');
INSERT INTO `china` VALUES ('220722', '長嶺縣', '220700');
INSERT INTO `china` VALUES ('220723', '乾安縣', '220700');
INSERT INTO `china` VALUES ('220724', '扶余市', '220700');
INSERT INTO `china` VALUES ('220800', '白城市', '220000');
INSERT INTO `china` VALUES ('220801', '市轄區', '220800');
INSERT INTO `china` VALUES ('220802', '洮北區', '220800');
INSERT INTO `china` VALUES ('220821', '鎮赉縣', '220800');
INSERT INTO `china` VALUES ('220822', '通榆縣', '220800');
INSERT INTO `china` VALUES ('220881', '洮南市', '220800');
INSERT INTO `china` VALUES ('220882', '大安市', '220800');
INSERT INTO `china` VALUES ('222400', '延邊朝鮮族自治州', '220000');
INSERT INTO `china` VALUES ('222401', '延吉市', '222400');
INSERT INTO `china` VALUES ('222402', '圖們市', '222400');
INSERT INTO `china` VALUES ('222403', '敦化市', '222400');
INSERT INTO `china` VALUES ('222404', '珲春市', '222400');
INSERT INTO `china` VALUES ('222405', '龍井市', '222400');
INSERT INTO `china` VALUES ('222406', '和龍市', '222400');
INSERT INTO `china` VALUES ('222424', '汪清縣', '222400');
INSERT INTO `china` VALUES ('222426', '安圖縣', '222400');
INSERT INTO `china` VALUES ('230000', '黑龍江省', '0');
INSERT INTO `china` VALUES ('230100', '哈爾濱市', '230000');
INSERT INTO `china` VALUES ('230101', '市轄區', '230100');
INSERT INTO `china` VALUES ('230102', '道裡區', '230101');
INSERT INTO `china` VALUES ('230103', '南崗區', '230101');
INSERT INTO `china` VALUES ('230104', '道外區', '230101');
INSERT INTO `china` VALUES ('230106', '香坊區', '230101');
INSERT INTO `china` VALUES ('230107', '動力區', '230101');
INSERT INTO `china` VALUES ('230108', '平房區', '230101');
INSERT INTO `china` VALUES ('230109', '松北區', '230101');
INSERT INTO `china` VALUES ('230111', '呼蘭區', '230101');
INSERT INTO `china` VALUES ('230123', '依蘭縣', '230100');
INSERT INTO `china` VALUES ('230124', '方正縣', '230100');
INSERT INTO `china` VALUES ('230125', '賓縣', '230100');
INSERT INTO `china` VALUES ('230126', '巴彥縣', '230100');
INSERT INTO `china` VALUES ('230127', '木蘭縣', '230100');
INSERT INTO `china` VALUES ('230128', '通河縣', '230100');
INSERT INTO `china` VALUES ('230129', '延壽縣', '230100');
INSERT INTO `china` VALUES ('230181', '阿城市', '230100');
INSERT INTO `china` VALUES ('230182', '雙城市', '230100');
INSERT INTO `china` VALUES ('230183', '尚志市', '230100');
INSERT INTO `china` VALUES ('230184', '五常市', '230100');
INSERT INTO `china` VALUES ('230200', '齊齊哈爾市', '230000');
INSERT INTO `china` VALUES ('230201', '市轄區', '230200');
INSERT INTO `china` VALUES ('230202', '龍沙區', '230201');
INSERT INTO `china` VALUES ('230203', '建華區', '230201');
INSERT INTO `china` VALUES ('230204', '鐵鋒區', '230201');
INSERT INTO `china` VALUES ('230205', '昂昂溪區', '230201');
INSERT INTO `china` VALUES ('230206', '富拉爾基區', '230201');
INSERT INTO `china` VALUES ('230207', '碾子山區', '230201');
INSERT INTO `china` VALUES ('230208', '梅裡斯達斡爾族區', '230201');
INSERT INTO `china` VALUES ('230221', '龍江縣', '230200');
INSERT INTO `china` VALUES ('230223', '依安縣', '230200');
INSERT INTO `china` VALUES ('230224', '泰來縣', '230200');
INSERT INTO `china` VALUES ('230225', '甘南縣', '230200');
INSERT INTO `china` VALUES ('230227', '富裕縣', '230200');
INSERT INTO `china` VALUES ('230229', '克山縣', '230200');
INSERT INTO `china` VALUES ('230230', '克東縣', '230200');
INSERT INTO `china` VALUES ('230231', '拜泉縣', '230200');
INSERT INTO `china` VALUES ('230281', '讷河市', '230200');
INSERT INTO `china` VALUES ('230300', '雞西市', '230000');
INSERT INTO `china` VALUES ('230301', '市轄區', '230300');
INSERT INTO `china` VALUES ('230302', '雞冠區', '230301');
INSERT INTO `china` VALUES ('230303', '恆山區', '230301');
INSERT INTO `china` VALUES ('230304', '滴道區', '230301');
INSERT INTO `china` VALUES ('230305', '梨樹區', '230301');
INSERT INTO `china` VALUES ('230306', '城子河區', '230301');
INSERT INTO `china` VALUES ('230307', '麻山區', '230301');
INSERT INTO `china` VALUES ('230321', '雞東縣', '230300');
INSERT INTO `china` VALUES ('230381', '虎林市', '230300');
INSERT INTO `china` VALUES ('230382', '密山市', '230300');
INSERT INTO `china` VALUES ('230400', '鶴崗市', '230000');
INSERT INTO `china` VALUES ('230401', '市轄區', '230400');
INSERT INTO `china` VALUES ('230402', '向陽區', '230401');
INSERT INTO `china` VALUES ('230403', '工農區', '230401');
INSERT INTO `china` VALUES ('230404', '南山區', '230401');
INSERT INTO `china` VALUES ('230405', '興安區', '230401');
INSERT INTO `china` VALUES ('230406', '東山區', '230401');
INSERT INTO `china` VALUES ('230407', '興山區', '230401');
INSERT INTO `china` VALUES ('230421', '蘿北縣', '230400');
INSERT INTO `china` VALUES ('230422', '綏濱縣', '230400');
INSERT INTO `china` VALUES ('230500', '雙鴨山市', '230000');
INSERT INTO `china` VALUES ('230501', '市轄區', '230500');
INSERT INTO `china` VALUES ('230502', '尖山區', '230501');
INSERT INTO `china` VALUES ('230503', '嶺東區', '230501');
INSERT INTO `china` VALUES ('230505', '四方台區', '230501');
INSERT INTO `china` VALUES ('230506', '寶山區', '230501');
INSERT INTO `china` VALUES ('230521', '集賢縣', '230500');
INSERT INTO `china` VALUES ('230522', '友誼縣', '230500');
INSERT INTO `china` VALUES ('230523', '寶清縣', '230500');
INSERT INTO `china` VALUES ('230524', '饒河縣', '230500');
INSERT INTO `china` VALUES ('230600', '大慶市', '230000');
INSERT INTO `china` VALUES ('230601', '市轄區', '230600');
INSERT INTO `china` VALUES ('230602', '薩爾圖區', '230601');
INSERT INTO `china` VALUES ('230603', '龍鳳區', '230601');
INSERT INTO `china` VALUES ('230604', '讓胡路區', '230601');
INSERT INTO `china` VALUES ('230605', '紅崗區', '230601');
INSERT INTO `china` VALUES ('230606', '大同區', '230601');
INSERT INTO `china` VALUES ('230621', '肇州縣', '230600');
INSERT INTO `china` VALUES ('230622', '肇源縣', '230600');
INSERT INTO `china` VALUES ('230623', '林甸縣', '230600');
INSERT INTO `china` VALUES ('230624', '杜爾伯特蒙古族自治縣', '230600');
INSERT INTO `china` VALUES ('230700', '伊春市', '230000');
INSERT INTO `china` VALUES ('230701', '市轄區', '230700');
INSERT INTO `china` VALUES ('230702', '伊春區', '230701');
INSERT INTO `china` VALUES ('230703', '南岔區', '230701');
INSERT INTO `china` VALUES ('230704', '友好區', '230701');
INSERT INTO `china` VALUES ('230705', '西林區', '230701');
INSERT INTO `china` VALUES ('230706', '翠巒區', '230701');
INSERT INTO `china` VALUES ('230707', '新青區', '230701');
INSERT INTO `china` VALUES ('230708', '美溪區', '230701');
INSERT INTO `china` VALUES ('230709', '金山屯區', '230701');
INSERT INTO `china` VALUES ('230710', '五營區', '230701');
INSERT INTO `china` VALUES ('230711', '烏馬河區', '230701');
INSERT INTO `china` VALUES ('230712', '湯旺河區', '230701');
INSERT INTO `china` VALUES ('230713', '帶嶺區', '230701');
INSERT INTO `china` VALUES ('230714', '烏伊嶺區', '230701');
INSERT INTO `china` VALUES ('230715', '紅星區', '230701');
INSERT INTO `china` VALUES ('230716', '上甘嶺區', '230701');
INSERT INTO `china` VALUES ('230722', '嘉蔭縣', '230700');
INSERT INTO `china` VALUES ('230781', '鐵力市', '230700');
INSERT INTO `china` VALUES ('230800', '佳木斯市', '230000');
INSERT INTO `china` VALUES ('230801', '市轄區', '230800');
INSERT INTO `china` VALUES ('230803', '向陽區', '230801');
INSERT INTO `china` VALUES ('230804', '前進區', '230801');
INSERT INTO `china` VALUES ('230805', '東風區', '230801');
INSERT INTO `china` VALUES ('230811', '郊區', '230801');
INSERT INTO `china` VALUES ('230822', '桦南縣', '230800');
INSERT INTO `china` VALUES ('230826', '桦川縣', '230800');
INSERT INTO `china` VALUES ('230828', '湯原縣', '230800');
INSERT INTO `china` VALUES ('230833', '撫遠縣', '230800');
INSERT INTO `china` VALUES ('230881', '同江市', '230800');
INSERT INTO `china` VALUES ('230882', '富錦市', '230800');
INSERT INTO `china` VALUES ('230900', '七台河市', '230000');
INSERT INTO `china` VALUES ('230901', '市轄區', '230900');
INSERT INTO `china` VALUES ('230902', '新興區', '230901');
INSERT INTO `china` VALUES ('230903', '桃山區', '230901');
INSERT INTO `china` VALUES ('230904', '茄子河區', '230901');
INSERT INTO `china` VALUES ('230921', '勃利縣', '230900');
INSERT INTO `china` VALUES ('231000', '牡丹江市', '230000');
INSERT INTO `china` VALUES ('231001', '市轄區', '231000');
INSERT INTO `china` VALUES ('231002', '東安區', '231001');
INSERT INTO `china` VALUES ('231003', '陽明區', '231001');
INSERT INTO `china` VALUES ('231004', '愛民區', '231001');
INSERT INTO `china` VALUES ('231005', '西安區', '231001');
INSERT INTO `china` VALUES ('231024', '東寧縣', '231000');
INSERT INTO `china` VALUES ('231025', '林口縣', '231000');
INSERT INTO `china` VALUES ('231081', '綏芬河市', '231000');
INSERT INTO `china` VALUES ('231083', '海林市', '231000');
INSERT INTO `china` VALUES ('231084', '寧安市', '231000');
INSERT INTO `china` VALUES ('231085', '穆稜市', '231000');
INSERT INTO `china` VALUES ('231100', '黑河市', '230000');
INSERT INTO `china` VALUES ('231101', '市轄區', '231100');
INSERT INTO `china` VALUES ('231102', '愛輝區', '231101');
INSERT INTO `china` VALUES ('231121', '嫩江縣', '231100');
INSERT INTO `china` VALUES ('231123', '遜克縣', '231100');
INSERT INTO `china` VALUES ('231124', '孫吳縣', '231100');
INSERT INTO `china` VALUES ('231181', '北安市', '231100');
INSERT INTO `china` VALUES ('231182', '五大連池市', '231100');
INSERT INTO `china` VALUES ('231200', '綏化市', '230000');
INSERT INTO `china` VALUES ('231201', '北林區', '231200');
INSERT INTO `china` VALUES ('231221', '望奎縣', '231200');
INSERT INTO `china` VALUES ('231222', '蘭西縣', '231200');
INSERT INTO `china` VALUES ('231223', '青岡縣', '231200');
INSERT INTO `china` VALUES ('231224', '慶安縣', '231200');
INSERT INTO `china` VALUES ('231225', '明水縣', '231200');
INSERT INTO `china` VALUES ('231226', '綏稜縣', '231200');
INSERT INTO `china` VALUES ('231281', '安達市', '231200');
INSERT INTO `china` VALUES ('231282', '肇東市', '231200');
INSERT INTO `china` VALUES ('231283', '海倫市', '231200');
INSERT INTO `china` VALUES ('232700', '大興安嶺地區', '230000');
INSERT INTO `china` VALUES ('232701', '加格達奇區', '232700');
INSERT INTO `china` VALUES ('232702', '松嶺區', '232700');
INSERT INTO `china` VALUES ('232703', '新林區', '232700');
INSERT INTO `china` VALUES ('232704', '呼中區', '232700');
INSERT INTO `china` VALUES ('232721', '呼瑪縣', '232700');
INSERT INTO `china` VALUES ('232722', '塔河縣', '232700');
INSERT INTO `china` VALUES ('232723', '漠河縣', '232700');
INSERT INTO `china` VALUES ('310000', '上海市', '0');
INSERT INTO `china` VALUES ('310100', '黃浦區', '310000');
INSERT INTO `china` VALUES ('310300', '盧灣區', '310000');
INSERT INTO `china` VALUES ('310400', '徐匯區', '310000');
INSERT INTO `china` VALUES ('310500', '長寧區', '310000');
INSERT INTO `china` VALUES ('310600', '靜安區', '310000');
INSERT INTO `china` VALUES ('310700', '普陀區', '310000');
INSERT INTO `china` VALUES ('310800', '閘北區', '310000');
INSERT INTO `china` VALUES ('310900', '虹口區', '310000');
INSERT INTO `china` VALUES ('311000', '楊浦區', '310000');
INSERT INTO `china` VALUES ('311200', '闵行區', '310000');
INSERT INTO `china` VALUES ('311300', '寶山區', '310000');
INSERT INTO `china` VALUES ('311400', '嘉定區', '310000');
INSERT INTO `china` VALUES ('311500', '浦東新區', '310000');
INSERT INTO `china` VALUES ('311600', '金山區', '310000');
INSERT INTO `china` VALUES ('311700', '松江區', '310000');
INSERT INTO `china` VALUES ('311800', '青浦區', '310000');
INSERT INTO `china` VALUES ('311900', '南匯區', '310000');
INSERT INTO `china` VALUES ('312000', '奉賢區', '310000');
INSERT INTO `china` VALUES ('313000', '崇明縣', '310000');
INSERT INTO `china` VALUES ('320000', '江蘇省', '0');
INSERT INTO `china` VALUES ('320100', '南京市', '320000');
INSERT INTO `china` VALUES ('320101', '市轄區', '320100');
INSERT INTO `china` VALUES ('320102', '玄武區', '320101');
INSERT INTO `china` VALUES ('320103', '白下區', '320101');
INSERT INTO `china` VALUES ('320104', '秦淮區', '320101');
INSERT INTO `china` VALUES ('320105', '建邺區', '320101');
INSERT INTO `china` VALUES ('320106', '鼓樓區', '320101');
INSERT INTO `china` VALUES ('320107', '下關區', '320101');
INSERT INTO `china` VALUES ('320111', '浦口區', '320101');
INSERT INTO `china` VALUES ('320113', '棲霞區', '320101');
INSERT INTO `china` VALUES ('320114', '雨花台區', '320101');
INSERT INTO `china` VALUES ('320115', '江寧區', '320101');
INSERT INTO `china` VALUES ('320116', '六合區', '320101');
INSERT INTO `china` VALUES ('320124', '溧水區', '320100');
INSERT INTO `china` VALUES ('320125', '高淳區', '320100');
INSERT INTO `china` VALUES ('320200', '無錫市', '320000');
INSERT INTO `china` VALUES ('320201', '市轄區', '320200');
INSERT INTO `china` VALUES ('320202', '崇安區', '320201');
INSERT INTO `china` VALUES ('320203', '南長區', '320201');
INSERT INTO `china` VALUES ('320204', '北塘區', '320201');
INSERT INTO `china` VALUES ('320205', '錫山區', '320201');
INSERT INTO `china` VALUES ('320206', '惠山區', '320201');
INSERT INTO `china` VALUES ('320211', '濱湖區', '320201');
INSERT INTO `china` VALUES ('320281', '江陰市', '320200');
INSERT INTO `china` VALUES ('320282', '宜興市', '320200');
INSERT INTO `china` VALUES ('320300', '徐州市', '320000');
INSERT INTO `china` VALUES ('320301', '泉山區', '320300');
INSERT INTO `china` VALUES ('320302', '鼓樓區', '320300');
INSERT INTO `china` VALUES ('320303', '雲龍區', '320300');
INSERT INTO `china` VALUES ('320304', '九裡區', '320301');
INSERT INTO `china` VALUES ('320305', '賈汪區', '320300');
INSERT INTO `china` VALUES ('320321', '豐縣', '320300');
INSERT INTO `china` VALUES ('320322', '沛縣', '320300');
INSERT INTO `china` VALUES ('320323', '銅山縣', '320300');
INSERT INTO `china` VALUES ('320324', '睢寧縣', '320300');
INSERT INTO `china` VALUES ('320381', '新沂市', '320300');
INSERT INTO `china` VALUES ('320382', '邳州市', '320300');
INSERT INTO `china` VALUES ('320400', '常州市', '320000');
INSERT INTO `china` VALUES ('320401', '市轄區', '320400');
INSERT INTO `china` VALUES ('320402', '天寧區', '320401');
INSERT INTO `china` VALUES ('320404', '鐘樓區', '320401');
INSERT INTO `china` VALUES ('320405', '戚墅堰區', '320401');
INSERT INTO `china` VALUES ('320411', '新北區', '320401');
INSERT INTO `china` VALUES ('320412', '武進區', '320401');
INSERT INTO `china` VALUES ('320481', '溧陽市', '320400');
INSERT INTO `china` VALUES ('320482', '金壇市', '320400');
INSERT INTO `china` VALUES ('320500', '蘇州市', '320000');
INSERT INTO `china` VALUES ('320501', '市轄區', '320500');
INSERT INTO `china` VALUES ('320502', '滄浪區', '320501');
INSERT INTO `china` VALUES ('320503', '平江區', '320501');
INSERT INTO `china` VALUES ('320504', '金阊區', '320501');
INSERT INTO `china` VALUES ('320505', '虎丘區', '320501');
INSERT INTO `china` VALUES ('320506', '吳中區', '320501');
INSERT INTO `china` VALUES ('320507', '相城區', '320501');
INSERT INTO `china` VALUES ('320581', '常熟市', '320500');
INSERT INTO `china` VALUES ('320582', '張家港市', '320500');
INSERT INTO `china` VALUES ('320583', '昆山市', '320500');
INSERT INTO `china` VALUES ('320584', '吳江市', '320500');
INSERT INTO `china` VALUES ('320585', '太倉市', '320500');
INSERT INTO `china` VALUES ('320600', '南通市', '320000');
INSERT INTO `china` VALUES ('320601', '市轄區', '320600');
INSERT INTO `china` VALUES ('320602', '崇川區', '320601');
INSERT INTO `china` VALUES ('320611', '港閘區', '320601');
INSERT INTO `china` VALUES ('320621', '海安縣', '320600');
INSERT INTO `china` VALUES ('320623', '如東縣', '320600');
INSERT INTO `china` VALUES ('320681', '啟東市', '320600');
INSERT INTO `china` VALUES ('320682', '如皋市', '320600');
INSERT INTO `china` VALUES ('320683', '通州市', '320600');
INSERT INTO `china` VALUES ('320684', '海門市', '320600');
INSERT INTO `china` VALUES ('320700', '連雲港市', '320000');
INSERT INTO `china` VALUES ('320701', '市轄區', '320700');
INSERT INTO `china` VALUES ('320703', '連雲區', '320701');
INSERT INTO `china` VALUES ('320705', '新浦區', '320701');
INSERT INTO `china` VALUES ('320706', '海州區', '320701');
INSERT INTO `china` VALUES ('320721', '贛榆縣', '320700');
INSERT INTO `china` VALUES ('320722', '東海縣', '320700');
INSERT INTO `china` VALUES ('320723', '灌雲縣', '320700');
INSERT INTO `china` VALUES ('320724', '灌南縣', '320700');
INSERT INTO `china` VALUES ('320800', '淮安市', '320000');
INSERT INTO `china` VALUES ('320801', '市轄區', '320800');
INSERT INTO `china` VALUES ('320802', '清河區', '320801');
INSERT INTO `china` VALUES ('320803', '楚州區', '320801');
INSERT INTO `china` VALUES ('320804', '淮陰區', '320801');
INSERT INTO `china` VALUES ('320811', '清浦區', '320801');
INSERT INTO `china` VALUES ('320826', '漣水縣', '320800');
INSERT INTO `china` VALUES ('320829', '洪澤縣', '320800');
INSERT INTO `china` VALUES ('320830', '盱眙縣', '320800');
INSERT INTO `china` VALUES ('320831', '金湖縣', '320800');
INSERT INTO `china` VALUES ('320900', '鹽城市', '320000');
INSERT INTO `china` VALUES ('320901', '市轄區', '320900');
INSERT INTO `china` VALUES ('320902', '亭湖區', '320901');
INSERT INTO `china` VALUES ('320903', '鹽都區', '320901');
INSERT INTO `china` VALUES ('320921', '響水縣', '320900');
INSERT INTO `china` VALUES ('320922', '濱海縣', '320900');
INSERT INTO `china` VALUES ('320923', '阜寧縣', '320900');
INSERT INTO `china` VALUES ('320924', '射陽縣', '320900');
INSERT INTO `china` VALUES ('320925', '建湖縣', '320900');
INSERT INTO `china` VALUES ('320981', '東台市', '320900');
INSERT INTO `china` VALUES ('320982', '大豐市', '320900');
INSERT INTO `china` VALUES ('321000', '揚州市', '320000');
INSERT INTO `china` VALUES ('321001', '市轄區', '321000');
INSERT INTO `china` VALUES ('321002', '廣陵區', '321001');
INSERT INTO `china` VALUES ('321003', '邗江區', '321001');
INSERT INTO `china` VALUES ('321011', '維揚區', '321001');
INSERT INTO `china` VALUES ('321023', '寶應縣', '321000');
INSERT INTO `china` VALUES ('321081', '儀征市', '321000');
INSERT INTO `china` VALUES ('321084', '高郵市', '321000');
INSERT INTO `china` VALUES ('321088', '江都市', '321000');
INSERT INTO `china` VALUES ('321100', '鎮江市', '320000');
INSERT INTO `china` VALUES ('321101', '市轄區', '321100');
INSERT INTO `china` VALUES ('321102', '京口區', '321101');
INSERT INTO `china` VALUES ('321111', '潤州區', '321101');
INSERT INTO `china` VALUES ('321112', '丹徒區', '321101');
INSERT INTO `china` VALUES ('321181', '丹陽市', '321100');
INSERT INTO `china` VALUES ('321182', '揚中市', '321100');
INSERT INTO `china` VALUES ('321183', '句容市', '321100');
INSERT INTO `china` VALUES ('321200', '泰州市', '320000');
INSERT INTO `china` VALUES ('321201', '市轄區', '321200');
INSERT INTO `china` VALUES ('321202', '海陵區', '321201');
INSERT INTO `china` VALUES ('321203', '高港區', '321201');
INSERT INTO `china` VALUES ('321281', '興化市', '321200');
INSERT INTO `china` VALUES ('321282', '靖江市', '321200');
INSERT INTO `china` VALUES ('321283', '泰興市', '321200');
INSERT INTO `china` VALUES ('321284', '姜堰市', '321200');
INSERT INTO `china` VALUES ('321300', '宿遷市', '320000');
INSERT INTO `china` VALUES ('321301', '市轄區', '321300');
INSERT INTO `china` VALUES ('321302', '宿城區', '321301');
INSERT INTO `china` VALUES ('321311', '宿豫區', '321301');
INSERT INTO `china` VALUES ('321322', '沭陽縣', '321300');
INSERT INTO `china` VALUES ('321323', '泗陽縣', '321300');
INSERT INTO `china` VALUES ('321324', '泗洪縣', '321300');
INSERT INTO `china` VALUES ('330000', '浙江省', '0');
INSERT INTO `china` VALUES ('330100', '杭州市', '330000');
INSERT INTO `china` VALUES ('330101', '市轄區', '330100');
INSERT INTO `china` VALUES ('330102', '上城區', '330101');
INSERT INTO `china` VALUES ('330103', '下城區', '330101');
INSERT INTO `china` VALUES ('330104', '江干區', '330101');
INSERT INTO `china` VALUES ('330105', '拱墅區', '330101');
INSERT INTO `china` VALUES ('330106', '西湖區', '330101');
INSERT INTO `china` VALUES ('330108', '濱江區', '330101');
INSERT INTO `china` VALUES ('330109', '蕭山區', '330101');
INSERT INTO `china` VALUES ('330110', '余杭區', '330101');
INSERT INTO `china` VALUES ('330122', '桐廬縣', '330100');
INSERT INTO `china` VALUES ('330127', '淳安縣', '330100');
INSERT INTO `china` VALUES ('330182', '建德市', '330100');
INSERT INTO `china` VALUES ('330183', '富陽市', '330100');
INSERT INTO `china` VALUES ('330185', '臨安市', '330100');
INSERT INTO `china` VALUES ('330200', '寧波市', '330000');
INSERT INTO `china` VALUES ('330201', '市轄區', '330200');
INSERT INTO `china` VALUES ('330203', '海曙區', '330201');
INSERT INTO `china` VALUES ('330204', '江東區', '330201');
INSERT INTO `china` VALUES ('330205', '江北區', '330201');
INSERT INTO `china` VALUES ('330206', '北侖區', '330201');
INSERT INTO `china` VALUES ('330211', '鎮海區', '330201');
INSERT INTO `china` VALUES ('330212', '鄞州區', '330201');
INSERT INTO `china` VALUES ('330225', '象山縣', '330200');
INSERT INTO `china` VALUES ('330226', '寧海縣', '330200');
INSERT INTO `china` VALUES ('330281', '余姚市', '330200');
INSERT INTO `china` VALUES ('330282', '慈溪市', '330200');
INSERT INTO `china` VALUES ('330283', '奉化市', '330200');
INSERT INTO `china` VALUES ('330300', '溫州市', '330000');
INSERT INTO `china` VALUES ('330301', '市轄區', '330300');
INSERT INTO `china` VALUES ('330302', '鹿城區', '330301');
INSERT INTO `china` VALUES ('330303', '龍灣區', '330301');
INSERT INTO `china` VALUES ('330304', '瓯海區', '330301');
INSERT INTO `china` VALUES ('330322', '洞頭縣', '330300');
INSERT INTO `china` VALUES ('330324', '永嘉縣', '330300');
INSERT INTO `china` VALUES ('330326', '平陽縣', '330300');
INSERT INTO `china` VALUES ('330327', '蒼南縣', '330300');
INSERT INTO `china` VALUES ('330328', '文成縣', '330300');
INSERT INTO `china` VALUES ('330329', '泰順縣', '330300');
INSERT INTO `china` VALUES ('330381', '瑞安市', '330300');
INSERT INTO `china` VALUES ('330382', '樂清市', '330300');
INSERT INTO `china` VALUES ('330400', '嘉興市', '330000');
INSERT INTO `china` VALUES ('330401', '市轄區', '330400');
INSERT INTO `china` VALUES ('330402', '南湖區', '330401');
INSERT INTO `china` VALUES ('330411', '秀洲區', '330401');
INSERT INTO `china` VALUES ('330421', '嘉善縣', '330400');
INSERT INTO `china` VALUES ('330424', '海鹽縣', '330400');
INSERT INTO `china` VALUES ('330481', '海寧市', '330400');
INSERT INTO `china` VALUES ('330482', '平湖市', '330400');
INSERT INTO `china` VALUES ('330483', '桐鄉市', '330400');
INSERT INTO `china` VALUES ('330500', '湖州市', '330000');
INSERT INTO `china` VALUES ('330501', '市轄區', '330500');
INSERT INTO `china` VALUES ('330502', '吳興區', '330501');
INSERT INTO `china` VALUES ('330503', '南浔區', '330501');
INSERT INTO `china` VALUES ('330521', '德清縣', '330500');
INSERT INTO `china` VALUES ('330522', '長興縣', '330500');
INSERT INTO `china` VALUES ('330523', '安吉縣', '330500');
INSERT INTO `china` VALUES ('330600', '紹興市', '330000');
INSERT INTO `china` VALUES ('330601', '市轄區', '330600');
INSERT INTO `china` VALUES ('330602', '越城區', '330601');
INSERT INTO `china` VALUES ('330621', '紹興縣', '330600');
INSERT INTO `china` VALUES ('330624', '新昌縣', '330600');
INSERT INTO `china` VALUES ('330681', '諸暨市', '330600');
INSERT INTO `china` VALUES ('330682', '上虞市', '330600');
INSERT INTO `china` VALUES ('330683', '嵊州市', '330600');
INSERT INTO `china` VALUES ('330700', '金華市', '330000');
INSERT INTO `china` VALUES ('330701', '市轄區', '330700');
INSERT INTO `china` VALUES ('330702', '婺城區', '330701');
INSERT INTO `china` VALUES ('330703', '金東區', '330701');
INSERT INTO `china` VALUES ('330723', '武義縣', '330700');
INSERT INTO `china` VALUES ('330726', '浦江縣', '330700');
INSERT INTO `china` VALUES ('330727', '磐安縣', '330700');
INSERT INTO `china` VALUES ('330781', '蘭溪市', '330700');
INSERT INTO `china` VALUES ('330782', '義烏市', '330700');
INSERT INTO `china` VALUES ('330783', '東陽市', '330700');
INSERT INTO `china` VALUES ('330784', '永康市', '330700');
INSERT INTO `china` VALUES ('330800', '衢州市', '330000');
INSERT INTO `china` VALUES ('330801', '市轄區', '330800');
INSERT INTO `china` VALUES ('330802', '柯城區', '330801');
INSERT INTO `china` VALUES ('330803', '衢江區', '330801');
INSERT INTO `china` VALUES ('330822', '常山縣', '330800');
INSERT INTO `china` VALUES ('330824', '開化縣', '330800');
INSERT INTO `china` VALUES ('330825', '龍游縣', '330800');
INSERT INTO `china` VALUES ('330881', '江山市', '330800');
INSERT INTO `china` VALUES ('330900', '舟山市', '330000');
INSERT INTO `china` VALUES ('330901', '市轄區', '330900');
INSERT INTO `china` VALUES ('330902', '定海區', '330901');
INSERT INTO `china` VALUES ('330903', '普陀區', '330901');
INSERT INTO `china` VALUES ('330921', '岱山縣', '330900');
INSERT INTO `china` VALUES ('330922', '嵊泗縣', '330900');
INSERT INTO `china` VALUES ('331000', '台州市', '330000');
INSERT INTO `china` VALUES ('331001', '市轄區', '331000');
INSERT INTO `china` VALUES ('331002', '椒江區', '331001');
INSERT INTO `china` VALUES ('331003', '黃巖區', '331001');
INSERT INTO `china` VALUES ('331004', '路橋區', '331001');
INSERT INTO `china` VALUES ('331021', '玉環縣', '331000');
INSERT INTO `china` VALUES ('331022', '三門縣', '331000');
INSERT INTO `china` VALUES ('331023', '天台縣', '331000');
INSERT INTO `china` VALUES ('331024', '仙居縣', '331000');
INSERT INTO `china` VALUES ('331081', '溫嶺市', '331000');
INSERT INTO `china` VALUES ('331082', '臨海市', '331000');
INSERT INTO `china` VALUES ('331100', '麗水市', '330000');
INSERT INTO `china` VALUES ('331101', '市轄區', '331100');
INSERT INTO `china` VALUES ('331102', '蓮都區', '331101');
INSERT INTO `china` VALUES ('331121', '青田縣', '331100');
INSERT INTO `china` VALUES ('331122', '缙雲縣', '331100');
INSERT INTO `china` VALUES ('331123', '遂昌縣', '331100');
INSERT INTO `china` VALUES ('331124', '松陽縣', '331100');
INSERT INTO `china` VALUES ('331125', '雲和縣', '331100');
INSERT INTO `china` VALUES ('331126', '慶元縣', '331100');
INSERT INTO `china` VALUES ('331127', '景寧畲族自治縣', '331100');
INSERT INTO `china` VALUES ('331181', '龍泉市', '331100');
INSERT INTO `china` VALUES ('340000', '安徽省', '0');
INSERT INTO `china` VALUES ('340100', '合肥市', '340000');
INSERT INTO `china` VALUES ('340101', '市轄區', '340100');
INSERT INTO `china` VALUES ('340102', '瑤海區', '340101');
INSERT INTO `china` VALUES ('340103', '廬陽區', '340101');
INSERT INTO `china` VALUES ('340104', '蜀山區', '340101');
INSERT INTO `china` VALUES ('340111', '包河區', '340101');
INSERT INTO `china` VALUES ('340121', '長豐縣', '340100');
INSERT INTO `china` VALUES ('340122', '肥東縣', '340100');
INSERT INTO `china` VALUES ('340123', '肥西縣', '340100');
INSERT INTO `china` VALUES ('340124', '廬江縣', '340100');
INSERT INTO `china` VALUES ('340181', '巢湖市', '340100');
INSERT INTO `china` VALUES ('340200', '蕪湖市', '340000');
INSERT INTO `china` VALUES ('340201', '市轄區', '340200');
INSERT INTO `china` VALUES ('340202', '鏡湖區', '340201');
INSERT INTO `china` VALUES ('340203', '馬塘區', '340201');
INSERT INTO `china` VALUES ('340207', '鸠江區', '340201');
INSERT INTO `china` VALUES ('340221', '蕪湖縣', '340200');
INSERT INTO `china` VALUES ('340222', '繁昌縣', '340200');
INSERT INTO `china` VALUES ('340223', '南陵縣', '340200');
INSERT INTO `china` VALUES ('340225', '無為縣', '340200');
INSERT INTO `china` VALUES ('340300', '蚌埠市', '340000');
INSERT INTO `china` VALUES ('340301', '市轄區', '340300');
INSERT INTO `china` VALUES ('340302', '龍子湖區', '340301');
INSERT INTO `china` VALUES ('340303', '蚌山區', '340301');
INSERT INTO `china` VALUES ('340304', '禹會區', '340301');
INSERT INTO `china` VALUES ('340311', '淮上區', '340301');
INSERT INTO `china` VALUES ('340321', '懷遠縣', '340300');
INSERT INTO `china` VALUES ('340322', '五河縣', '340300');
INSERT INTO `china` VALUES ('340323', '固鎮縣', '340300');
INSERT INTO `china` VALUES ('340400', '淮南市', '340000');
INSERT INTO `china` VALUES ('340401', '市轄區', '340400');
INSERT INTO `china` VALUES ('340402', '大通區', '340401');
INSERT INTO `china` VALUES ('340403', '田家庵區', '340401');
INSERT INTO `china` VALUES ('340404', '謝家集區', '340401');
INSERT INTO `china` VALUES ('340405', '八公山區', '340401');
INSERT INTO `china` VALUES ('340406', '潘集區', '340401');
INSERT INTO `china` VALUES ('340421', '鳳台縣', '340400');
INSERT INTO `china` VALUES ('340500', '馬鞍山市', '340000');
INSERT INTO `china` VALUES ('340501', '市轄區', '340500');
INSERT INTO `china` VALUES ('340502', '金家莊區', '340501');
INSERT INTO `china` VALUES ('340503', '花山區', '340501');
INSERT INTO `china` VALUES ('340504', '雨山區', '340501');
INSERT INTO `china` VALUES ('340521', '當塗縣', '340500');
INSERT INTO `china` VALUES ('340522', '含山縣', '340500');
INSERT INTO `china` VALUES ('340523', '和縣', '340500');
INSERT INTO `china` VALUES ('340600', '淮北市', '340000');
INSERT INTO `china` VALUES ('340601', '市轄區', '340600');
INSERT INTO `china` VALUES ('340602', '杜集區', '340601');
INSERT INTO `china` VALUES ('340603', '相山區', '340601');
INSERT INTO `china` VALUES ('340604', '烈山區', '340601');
INSERT INTO `china` VALUES ('340621', '濉溪縣', '340600');
INSERT INTO `china` VALUES ('340700', '銅陵市', '340000');
INSERT INTO `china` VALUES ('340701', '市轄區', '340700');
INSERT INTO `china` VALUES ('340702', '銅官山區', '340701');
INSERT INTO `china` VALUES ('340703', '獅子山區', '340701');
INSERT INTO `china` VALUES ('340711', '郊區', '340701');
INSERT INTO `china` VALUES ('340721', '銅陵縣', '340700');
INSERT INTO `china` VALUES ('340800', '安慶市', '340000');
INSERT INTO `china` VALUES ('340801', '市轄區', '340800');
INSERT INTO `china` VALUES ('340802', '迎江區', '340801');
INSERT INTO `china` VALUES ('340803', '大觀區', '340801');
INSERT INTO `china` VALUES ('340811', '宜秀區', '340801');
INSERT INTO `china` VALUES ('340822', '懷寧縣', '340800');
INSERT INTO `china` VALUES ('340823', '枞陽縣', '340800');
INSERT INTO `china` VALUES ('340824', '潛山縣', '340800');
INSERT INTO `china` VALUES ('340825', '太湖縣', '340800');
INSERT INTO `china` VALUES ('340826', '宿松縣', '340800');
INSERT INTO `china` VALUES ('340827', '望江縣', '340800');
INSERT INTO `china` VALUES ('340828', '岳西縣', '340800');
INSERT INTO `china` VALUES ('340881', '桐城市', '340800');
INSERT INTO `china` VALUES ('341000', '黃山市', '340000');
INSERT INTO `china` VALUES ('341001', '黃山區', '341000');
INSERT INTO `china` VALUES ('341002', '屯溪區', '341000');
INSERT INTO `china` VALUES ('341004', '徽州區', '341000');
INSERT INTO `china` VALUES ('341021', '歙縣', '341000');
INSERT INTO `china` VALUES ('341022', '休寧縣', '341000');
INSERT INTO `china` VALUES ('341023', '黟縣', '341000');
INSERT INTO `china` VALUES ('341024', '祁門縣', '341000');
INSERT INTO `china` VALUES ('341091', '湯口鎮', '341000');
INSERT INTO `china` VALUES ('341100', '滁州市', '340000');
INSERT INTO `china` VALUES ('341101', '市轄區', '341100');
INSERT INTO `china` VALUES ('341102', '琅琊區', '341101');
INSERT INTO `china` VALUES ('341103', '南谯區', '341101');
INSERT INTO `china` VALUES ('341122', '來安縣', '341100');
INSERT INTO `china` VALUES ('341124', '全椒縣', '341100');
INSERT INTO `china` VALUES ('341125', '定遠縣', '341100');
INSERT INTO `china` VALUES ('341126', '鳳陽縣', '341100');
INSERT INTO `china` VALUES ('341181', '天長市', '341100');
INSERT INTO `china` VALUES ('341182', '明光市', '341100');
INSERT INTO `china` VALUES ('341200', '阜陽市', '340000');
INSERT INTO `china` VALUES ('341201', '颍泉區', '341200');
INSERT INTO `china` VALUES ('341202', '颍州區', '341200');
INSERT INTO `china` VALUES ('341203', '颍東區', '341200');
INSERT INTO `china` VALUES ('341221', '臨泉縣', '341200');
INSERT INTO `china` VALUES ('341222', '太和縣', '341200');
INSERT INTO `china` VALUES ('341225', '阜南縣', '341200');
INSERT INTO `china` VALUES ('341226', '颍上縣', '341200');
INSERT INTO `china` VALUES ('341282', '界首市', '341200');
INSERT INTO `china` VALUES ('341300', '宿州市', '340000');
INSERT INTO `china` VALUES ('341301', '市轄區', '341300');
INSERT INTO `china` VALUES ('341302', '埇橋區', '341301');
INSERT INTO `china` VALUES ('341321', '砀山縣', '341300');
INSERT INTO `china` VALUES ('341322', '蕭縣', '341300');
INSERT INTO `china` VALUES ('341323', '靈璧縣', '341300');
INSERT INTO `china` VALUES ('341324', '泗縣', '341300');
INSERT INTO `china` VALUES ('341402', '居巢區', null);
INSERT INTO `china` VALUES ('341500', '六安市', '340000');
INSERT INTO `china` VALUES ('341501', '市轄區', '341500');
INSERT INTO `china` VALUES ('341502', '金安區', '341501');
INSERT INTO `china` VALUES ('341503', '裕安區', '341501');
INSERT INTO `china` VALUES ('341521', '壽縣', '341500');
INSERT INTO `china` VALUES ('341522', '霍邱縣', '341500');
INSERT INTO `china` VALUES ('341523', '舒城縣', '341500');
INSERT INTO `china` VALUES ('341524', '金寨縣', '341500');
INSERT INTO `china` VALUES ('341525', '霍山縣', '341500');
INSERT INTO `china` VALUES ('341600', '亳州市', '340000');
INSERT INTO `china` VALUES ('341601', '谯城區', '341600');
INSERT INTO `china` VALUES ('341621', '渦陽縣', '341600');
INSERT INTO `china` VALUES ('341622', '蒙城縣', '341600');
INSERT INTO `china` VALUES ('341623', '利辛縣', '341600');
INSERT INTO `china` VALUES ('341700', '池州市', '340000');
INSERT INTO `china` VALUES ('341701', '市轄區', '341700');
INSERT INTO `china` VALUES ('341702', '貴池區', '341701');
INSERT INTO `china` VALUES ('341721', '東至縣', '341700');
INSERT INTO `china` VALUES ('341722', '石台縣', '341700');
INSERT INTO `china` VALUES ('341723', '青陽縣', '341700');
INSERT INTO `china` VALUES ('341800', '宣城市', '340000');
INSERT INTO `china` VALUES ('341801', '市轄區', '341800');
INSERT INTO `china` VALUES ('341802', '宣州區', '341801');
INSERT INTO `china` VALUES ('341821', '郎溪縣', '341800');
INSERT INTO `china` VALUES ('341822', '廣德縣', '341800');
INSERT INTO `china` VALUES ('341823', '泾縣', '341800');
INSERT INTO `china` VALUES ('341824', '績溪縣', '341800');
INSERT INTO `china` VALUES ('341825', '旌德縣', '341800');
INSERT INTO `china` VALUES ('341881', '寧國市', '341800');
INSERT INTO `china` VALUES ('350000', '福建省', '0');
INSERT INTO `china` VALUES ('350100', '福州市', '350000');
INSERT INTO `china` VALUES ('350101', '市轄區', '350100');
INSERT INTO `china` VALUES ('350102', '鼓樓區', '350101');
INSERT INTO `china` VALUES ('350103', '台江區', '350101');
INSERT INTO `china` VALUES ('350104', '倉山區', '350101');
INSERT INTO `china` VALUES ('350105', '馬尾區', '350101');
INSERT INTO `china` VALUES ('350111', '晉安區', '350101');
INSERT INTO `china` VALUES ('350121', '閩侯縣', '350100');
INSERT INTO `china` VALUES ('350122', '連江縣', '350100');
INSERT INTO `china` VALUES ('350123', '羅源縣', '350100');
INSERT INTO `china` VALUES ('350124', '閩清縣', '350100');
INSERT INTO `china` VALUES ('350125', '永泰縣', '350100');
INSERT INTO `china` VALUES ('350128', '平潭縣', '350100');
INSERT INTO `china` VALUES ('350181', '福清市', '350100');
INSERT INTO `china` VALUES ('350182', '長樂市', '350100');
INSERT INTO `china` VALUES ('350200', '廈門市', '350000');
INSERT INTO `china` VALUES ('350201', '市轄區', '350200');
INSERT INTO `china` VALUES ('350203', '思明區', '350201');
INSERT INTO `china` VALUES ('350205', '海滄區', '350201');
INSERT INTO `china` VALUES ('350206', '湖裡區', '350201');
INSERT INTO `china` VALUES ('350211', '集美區', '350201');
INSERT INTO `china` VALUES ('350212', '同安區', '350201');
INSERT INTO `china` VALUES ('350213', '翔安區', '350201');
INSERT INTO `china` VALUES ('350300', '莆田市', '350000');
INSERT INTO `china` VALUES ('350301', '市轄區', '350300');
INSERT INTO `china` VALUES ('350302', '城廂區', '350301');
INSERT INTO `china` VALUES ('350303', '涵江區', '350301');
INSERT INTO `china` VALUES ('350304', '荔城區', '350301');
INSERT INTO `china` VALUES ('350305', '秀嶼區', '350301');
INSERT INTO `china` VALUES ('350322', '仙游縣', '350300');
INSERT INTO `china` VALUES ('350400', '三明市', '350000');
INSERT INTO `china` VALUES ('350401', '市轄區', '350400');
INSERT INTO `china` VALUES ('350402', '梅列區', '350401');
INSERT INTO `china` VALUES ('350403', '三元區', '350401');
INSERT INTO `china` VALUES ('350421', '明溪縣', '350400');
INSERT INTO `china` VALUES ('350423', '清流縣', '350400');
INSERT INTO `china` VALUES ('350424', '寧化縣', '350400');
INSERT INTO `china` VALUES ('350425', '大田縣', '350400');
INSERT INTO `china` VALUES ('350426', '尤溪縣', '350400');
INSERT INTO `china` VALUES ('350427', '沙縣', '350400');
INSERT INTO `china` VALUES ('350428', '將樂縣', '350400');
INSERT INTO `china` VALUES ('350429', '泰寧縣', '350400');
INSERT INTO `china` VALUES ('350430', '建寧縣', '350400');
INSERT INTO `china` VALUES ('350481', '永安市', '350400');
INSERT INTO `china` VALUES ('350500', '泉州市', '350000');
INSERT INTO `china` VALUES ('350501', '市轄區', '350500');
INSERT INTO `china` VALUES ('350502', '鯉城區', '350501');
INSERT INTO `china` VALUES ('350503', '豐澤區', '350501');
INSERT INTO `china` VALUES ('350504', '洛江區', '350501');
INSERT INTO `china` VALUES ('350505', '泉港區', '350501');
INSERT INTO `china` VALUES ('350521', '惠安縣', '350500');
INSERT INTO `china` VALUES ('350524', '安溪縣', '350500');
INSERT INTO `china` VALUES ('350525', '永春縣', '350500');
INSERT INTO `china` VALUES ('350526', '德化縣', '350500');
INSERT INTO `china` VALUES ('350527', '金門縣', '350500');
INSERT INTO `china` VALUES ('350581', '石獅市', '350500');
INSERT INTO `china` VALUES ('350582', '晉江市', '350500');
INSERT INTO `china` VALUES ('350583', '南安市', '350500');
INSERT INTO `china` VALUES ('350600', '漳州市', '350000');
INSERT INTO `china` VALUES ('350601', '市轄區', '350600');
INSERT INTO `china` VALUES ('350602', '芗城區', '350601');
INSERT INTO `china` VALUES ('350603', '龍文區', '350601');
INSERT INTO `china` VALUES ('350622', '雲霄縣', '350600');
INSERT INTO `china` VALUES ('350623', '漳浦縣', '350600');
INSERT INTO `china` VALUES ('350624', '诏安縣', '350600');
INSERT INTO `china` VALUES ('350625', '長泰縣', '350600');
INSERT INTO `china` VALUES ('350626', '東山縣', '350600');
INSERT INTO `china` VALUES ('350627', '南靖縣', '350600');
INSERT INTO `china` VALUES ('350628', '平和縣', '350600');
INSERT INTO `china` VALUES ('350629', '華安縣', '350600');
INSERT INTO `china` VALUES ('350681', '龍海市', '350600');
INSERT INTO `china` VALUES ('350700', '南平市', '350000');
INSERT INTO `china` VALUES ('350701', '市轄區', '350700');
INSERT INTO `china` VALUES ('350702', '延平區', '350701');
INSERT INTO `china` VALUES ('350721', '順昌縣', '350700');
INSERT INTO `china` VALUES ('350722', '浦城縣', '350700');
INSERT INTO `china` VALUES ('350723', '光澤縣', '350700');
INSERT INTO `china` VALUES ('350724', '松溪縣', '350700');
INSERT INTO `china` VALUES ('350725', '政和縣', '350700');
INSERT INTO `china` VALUES ('350781', '邵武市', '350700');
INSERT INTO `china` VALUES ('350782', '武夷山市', '350700');
INSERT INTO `china` VALUES ('350783', '建瓯市', '350700');
INSERT INTO `china` VALUES ('350784', '建陽市', '350700');
INSERT INTO `china` VALUES ('350800', '龍巖市', '350000');
INSERT INTO `china` VALUES ('350801', '市轄區', '350800');
INSERT INTO `china` VALUES ('350802', '新羅區', '350801');
INSERT INTO `china` VALUES ('350821', '長汀縣', '350800');
INSERT INTO `china` VALUES ('350822', '永定縣', '350800');
INSERT INTO `china` VALUES ('350823', '上杭縣', '350800');
INSERT INTO `china` VALUES ('350824', '武平縣', '350800');
INSERT INTO `china` VALUES ('350825', '連城縣', '350800');
INSERT INTO `china` VALUES ('350881', '漳平市', '350800');
INSERT INTO `china` VALUES ('350900', '寧德市', '350000');
INSERT INTO `china` VALUES ('350901', '市轄區', '350900');
INSERT INTO `china` VALUES ('350902', '蕉城區', '350901');
INSERT INTO `china` VALUES ('350921', '霞浦縣', '350900');
INSERT INTO `china` VALUES ('350922', '古田縣', '350900');
INSERT INTO `china` VALUES ('350923', '屏南縣', '350900');
INSERT INTO `china` VALUES ('350924', '壽寧縣', '350900');
INSERT INTO `china` VALUES ('350925', '周寧縣', '350900');
INSERT INTO `china` VALUES ('350926', '柘榮縣', '350900');
INSERT INTO `china` VALUES ('350981', '福安市', '350900');
INSERT INTO `china` VALUES ('350982', '福鼎市', '350900');
INSERT INTO `china` VALUES ('360000', '江西省', '0');
INSERT INTO `china` VALUES ('360100', '南昌市', '360000');
INSERT INTO `china` VALUES ('360101', '市轄區', '360100');
INSERT INTO `china` VALUES ('360102', '東湖區', '360101');
INSERT INTO `china` VALUES ('360103', '西湖區', '360101');
INSERT INTO `china` VALUES ('360104', '青雲譜區', '360101');
INSERT INTO `china` VALUES ('360105', '灣裡區', '360101');
INSERT INTO `china` VALUES ('360111', '青山湖區', '360101');
INSERT INTO `china` VALUES ('360121', '南昌縣', '360100');
INSERT INTO `china` VALUES ('360122', '新建縣', '360100');
INSERT INTO `china` VALUES ('360123', '安義縣', '360100');
INSERT INTO `china` VALUES ('360124', '進賢縣', '360100');
INSERT INTO `china` VALUES ('360200', '景德鎮市', '360000');
INSERT INTO `china` VALUES ('360201', '市轄區', '360200');
INSERT INTO `china` VALUES ('360202', '昌江區', '360201');
INSERT INTO `china` VALUES ('360203', '珠山區', '360201');
INSERT INTO `china` VALUES ('360222', '浮梁縣', '360200');
INSERT INTO `china` VALUES ('360281', '樂平市', '360200');
INSERT INTO `china` VALUES ('360300', '萍鄉市', '360000');
INSERT INTO `china` VALUES ('360301', '市轄區', '360300');
INSERT INTO `china` VALUES ('360302', '安源區', '360301');
INSERT INTO `china` VALUES ('360313', '湘東區', '360301');
INSERT INTO `china` VALUES ('360321', '蓮花縣', '360300');
INSERT INTO `china` VALUES ('360322', '上栗縣', '360300');
INSERT INTO `china` VALUES ('360323', '蘆溪縣', '360300');
INSERT INTO `china` VALUES ('360400', '九江市', '360000');
INSERT INTO `china` VALUES ('360401', '市轄區', '360400');
INSERT INTO `china` VALUES ('360402', '廬山區', '360401');
INSERT INTO `china` VALUES ('360403', '浔陽區', '360401');
INSERT INTO `china` VALUES ('360421', '九江縣', '360400');
INSERT INTO `china` VALUES ('360423', '武寧縣', '360400');
INSERT INTO `china` VALUES ('360424', '修水縣', '360400');
INSERT INTO `china` VALUES ('360425', '永修縣', '360400');
INSERT INTO `china` VALUES ('360426', '德安縣', '360400');
INSERT INTO `china` VALUES ('360427', '星子縣', '360400');
INSERT INTO `china` VALUES ('360428', '都昌縣', '360400');
INSERT INTO `china` VALUES ('360429', '湖口縣', '360400');
INSERT INTO `china` VALUES ('360430', '彭澤縣', '360400');
INSERT INTO `china` VALUES ('360481', '瑞昌市', '360400');
INSERT INTO `china` VALUES ('360482', '共青城市', '360400');
INSERT INTO `china` VALUES ('360500', '新余市', '360000');
INSERT INTO `china` VALUES ('360501', '市轄區', '360500');
INSERT INTO `china` VALUES ('360502', '渝水區', '360501');
INSERT INTO `china` VALUES ('360521', '分宜縣', '360500');
INSERT INTO `china` VALUES ('360600', '鷹潭市', '360000');
INSERT INTO `china` VALUES ('360601', '市轄區', '360600');
INSERT INTO `china` VALUES ('360602', '月湖區', '360601');
INSERT INTO `china` VALUES ('360622', '余江縣', '360600');
INSERT INTO `china` VALUES ('360681', '貴溪市', '360600');
INSERT INTO `china` VALUES ('360700', '贛州市', '360000');
INSERT INTO `china` VALUES ('360701', '市轄區', '360700');
INSERT INTO `china` VALUES ('360702', '章貢區', '360701');
INSERT INTO `china` VALUES ('360721', '贛縣', '360700');
INSERT INTO `china` VALUES ('360722', '信豐縣', '360700');
INSERT INTO `china` VALUES ('360723', '大余縣', '360700');
INSERT INTO `china` VALUES ('360724', '上猶縣', '360700');
INSERT INTO `china` VALUES ('360725', '崇義縣', '360700');
INSERT INTO `china` VALUES ('360726', '安遠縣', '360700');
INSERT INTO `china` VALUES ('360727', '龍南縣', '360700');
INSERT INTO `china` VALUES ('360728', '定南縣', '360700');
INSERT INTO `china` VALUES ('360729', '全南縣', '360700');
INSERT INTO `china` VALUES ('360730', '寧都縣', '360700');
INSERT INTO `china` VALUES ('360731', '於都縣', '360700');
INSERT INTO `china` VALUES ('360732', '興國縣', '360700');
INSERT INTO `china` VALUES ('360733', '會昌縣', '360700');
INSERT INTO `china` VALUES ('360734', '尋烏縣', '360700');
INSERT INTO `china` VALUES ('360735', '石城縣', '360700');
INSERT INTO `china` VALUES ('360781', '瑞金市', '360700');
INSERT INTO `china` VALUES ('360782', '南康市', '360700');
INSERT INTO `china` VALUES ('360800', '吉安市', '360000');
INSERT INTO `china` VALUES ('360801', '市轄區', '360800');
INSERT INTO `china` VALUES ('360802', '吉州區', '360801');
INSERT INTO `china` VALUES ('360803', '青原區', '360801');
INSERT INTO `china` VALUES ('360821', '吉安縣', '360800');
INSERT INTO `china` VALUES ('360822', '吉水縣', '360800');
INSERT INTO `china` VALUES ('360823', '峽江縣', '360800');
INSERT INTO `china` VALUES ('360824', '新干縣', '360800');
INSERT INTO `china` VALUES ('360825', '永豐縣', '360800');
INSERT INTO `china` VALUES ('360826', '泰和縣', '360800');
INSERT INTO `china` VALUES ('360827', '遂川縣', '360800');
INSERT INTO `china` VALUES ('360828', '萬安縣', '360800');
INSERT INTO `china` VALUES ('360829', '安福縣', '360800');
INSERT INTO `china` VALUES ('360830', '永新縣', '360800');
INSERT INTO `china` VALUES ('360881', '井岡山市', '360800');
INSERT INTO `china` VALUES ('360900', '宜春市', '360000');
INSERT INTO `china` VALUES ('360901', '市轄區', '360900');
INSERT INTO `china` VALUES ('360902', '袁州區', '360901');
INSERT INTO `china` VALUES ('360921', '奉新縣', '360900');
INSERT INTO `china` VALUES ('360922', '萬載縣', '360900');
INSERT INTO `china` VALUES ('360923', '上高縣', '360900');
INSERT INTO `china` VALUES ('360924', '宜豐縣', '360900');
INSERT INTO `china` VALUES ('360925', '靖安縣', '360900');
INSERT INTO `china` VALUES ('360926', '銅鼓縣', '360900');
INSERT INTO `china` VALUES ('360981', '豐城市', '360900');
INSERT INTO `china` VALUES ('360982', '樟樹市', '360900');
INSERT INTO `china` VALUES ('360983', '高安市', '360900');
INSERT INTO `china` VALUES ('361000', '撫州市', '360000');
INSERT INTO `china` VALUES ('361001', '市轄區', '361000');
INSERT INTO `china` VALUES ('361002', '臨川區', '361001');
INSERT INTO `china` VALUES ('361021', '南城縣', '361000');
INSERT INTO `china` VALUES ('361022', '黎川縣', '361000');
INSERT INTO `china` VALUES ('361023', '南豐縣', '361000');
INSERT INTO `china` VALUES ('361024', '崇仁縣', '361000');
INSERT INTO `china` VALUES ('361025', '樂安縣', '361000');
INSERT INTO `china` VALUES ('361026', '宜黃縣', '361000');
INSERT INTO `china` VALUES ('361027', '金溪縣', '361000');
INSERT INTO `china` VALUES ('361028', '資溪縣', '361000');
INSERT INTO `china` VALUES ('361029', '東鄉縣', '361000');
INSERT INTO `china` VALUES ('361030', '廣昌縣', '361000');
INSERT INTO `china` VALUES ('361100', '上饒市', '360000');
INSERT INTO `china` VALUES ('361101', '市轄區', '361100');
INSERT INTO `china` VALUES ('361102', '信州區', '361101');
INSERT INTO `china` VALUES ('361121', '上饒縣', '361100');
INSERT INTO `china` VALUES ('361122', '廣豐縣', '361100');
INSERT INTO `china` VALUES ('361123', '玉山縣', '361100');
INSERT INTO `china` VALUES ('361124', '鉛山縣', '361100');
INSERT INTO `china` VALUES ('361125', '橫峰縣', '361100');
INSERT INTO `china` VALUES ('361126', '弋陽縣', '361100');
INSERT INTO `china` VALUES ('361127', '余干縣', '361100');
INSERT INTO `china` VALUES ('361128', '鄱陽縣', '361100');
INSERT INTO `china` VALUES ('361129', '萬年縣', '361100');
INSERT INTO `china` VALUES ('361130', '婺源縣', '361100');
INSERT INTO `china` VALUES ('361181', '德興市', '361100');
INSERT INTO `china` VALUES ('370000', '山東省', '0');
INSERT INTO `china` VALUES ('370100', '濟南市', '370000');
INSERT INTO `china` VALUES ('370101', '市轄區', '370100');
INSERT INTO `china` VALUES ('370102', '歷下區', '370101');
INSERT INTO `china` VALUES ('370103', '市中區', '370101');
INSERT INTO `china` VALUES ('370104', '槐蔭區', '370101');
INSERT INTO `china` VALUES ('370105', '天橋區', '370101');
INSERT INTO `china` VALUES ('370112', '歷城區', '370101');
INSERT INTO `china` VALUES ('370113', '長清區', '370101');
INSERT INTO `china` VALUES ('370124', '平陰縣', '370100');
INSERT INTO `china` VALUES ('370125', '濟陽縣', '370100');
INSERT INTO `china` VALUES ('370126', '商河縣', '370100');
INSERT INTO `china` VALUES ('370181', '章丘市', '370100');
INSERT INTO `china` VALUES ('370200', '青島市', '370000');
INSERT INTO `china` VALUES ('370201', '市轄區', '370200');
INSERT INTO `china` VALUES ('370202', '市南區', '370201');
INSERT INTO `china` VALUES ('370203', '市北區', '370201');
INSERT INTO `china` VALUES ('370205', '四方區', '370201');
INSERT INTO `china` VALUES ('370211', '黃島區', '370201');
INSERT INTO `china` VALUES ('370212', '崂山區', '370201');
INSERT INTO `china` VALUES ('370213', '李滄區', '370201');
INSERT INTO `china` VALUES ('370214', '城陽區', '370201');
INSERT INTO `china` VALUES ('370281', '膠州市', '370200');
INSERT INTO `china` VALUES ('370282', '即墨市', '370200');
INSERT INTO `china` VALUES ('370283', '平度市', '370200');
INSERT INTO `china` VALUES ('370284', '膠南市', '370200');
INSERT INTO `china` VALUES ('370285', '萊西市', '370200');
INSERT INTO `china` VALUES ('370300', '淄博市', '370000');
INSERT INTO `china` VALUES ('370301', '市轄區', '370300');
INSERT INTO `china` VALUES ('370302', '淄川區', '370301');
INSERT INTO `china` VALUES ('370303', '張店區', '370301');
INSERT INTO `china` VALUES ('370304', '博山區', '370301');
INSERT INTO `china` VALUES ('370305', '臨淄區', '370301');
INSERT INTO `china` VALUES ('370306', '周村區', '370301');
INSERT INTO `china` VALUES ('370321', '桓台縣', '370300');
INSERT INTO `china` VALUES ('370322', '高青縣', '370300');
INSERT INTO `china` VALUES ('370323', '沂源縣', '370300');
INSERT INTO `china` VALUES ('370400', '棗莊市', '370000');
INSERT INTO `china` VALUES ('370401', '市轄區', '370400');
INSERT INTO `china` VALUES ('370402', '市中區', '370401');
INSERT INTO `china` VALUES ('370403', '薛城區', '370401');
INSERT INTO `china` VALUES ('370404', '峄城區', '370401');
INSERT INTO `china` VALUES ('370405', '台兒莊區', '370401');
INSERT INTO `china` VALUES ('370406', '山亭區', '370401');
INSERT INTO `china` VALUES ('370481', '滕州市', '370400');
INSERT INTO `china` VALUES ('370500', '東營市', '370000');
INSERT INTO `china` VALUES ('370501', '市轄區', '370500');
INSERT INTO `china` VALUES ('370502', '東營區', '370501');
INSERT INTO `china` VALUES ('370503', '河口區', '370501');
INSERT INTO `china` VALUES ('370521', '墾利縣', '370500');
INSERT INTO `china` VALUES ('370522', '利津縣', '370500');
INSERT INTO `china` VALUES ('370523', '廣饒縣', '370500');
INSERT INTO `china` VALUES ('370600', '煙台市', '370000');
INSERT INTO `china` VALUES ('370601', '市轄區', '370600');
INSERT INTO `china` VALUES ('370602', '芝罘區', '370601');
INSERT INTO `china` VALUES ('370611', '福山區', '370601');
INSERT INTO `china` VALUES ('370612', '牟平區', '370601');
INSERT INTO `china` VALUES ('370613', '萊山區', '370601');
INSERT INTO `china` VALUES ('370634', '長島縣', '370600');
INSERT INTO `china` VALUES ('370681', '龍口市', '370600');
INSERT INTO `china` VALUES ('370682', '萊陽市', '370600');
INSERT INTO `china` VALUES ('370683', '萊州市', '370600');
INSERT INTO `china` VALUES ('370684', '蓬萊市', '370600');
INSERT INTO `china` VALUES ('370685', '招遠市', '370600');
INSERT INTO `china` VALUES ('370686', '棲霞市', '370600');
INSERT INTO `china` VALUES ('370687', '海陽市', '370600');
INSERT INTO `china` VALUES ('370700', '濰坊市', '370000');
INSERT INTO `china` VALUES ('370701', '市轄區', '370700');
INSERT INTO `china` VALUES ('370702', '濰城區', '370701');
INSERT INTO `china` VALUES ('370703', '寒亭區', '370701');
INSERT INTO `china` VALUES ('370704', '坊子區', '370701');
INSERT INTO `china` VALUES ('370705', '奎文區', '370701');
INSERT INTO `china` VALUES ('370724', '臨朐縣', '370700');
INSERT INTO `china` VALUES ('370725', '昌樂縣', '370700');
INSERT INTO `china` VALUES ('370781', '青州市', '370700');
INSERT INTO `china` VALUES ('370782', '諸城市', '370700');
INSERT INTO `china` VALUES ('370783', '壽光市', '370700');
INSERT INTO `china` VALUES ('370784', '安丘市', '370700');
INSERT INTO `china` VALUES ('370785', '高密市', '370700');
INSERT INTO `china` VALUES ('370786', '昌邑市', '370700');
INSERT INTO `china` VALUES ('370800', '濟寧市', '370000');
INSERT INTO `china` VALUES ('370801', '市轄區', '370800');
INSERT INTO `china` VALUES ('370802', '市中區', '370801');
INSERT INTO `china` VALUES ('370811', '任城區', '370801');
INSERT INTO `china` VALUES ('370826', '微山縣', '370800');
INSERT INTO `china` VALUES ('370827', '魚台縣', '370800');
INSERT INTO `china` VALUES ('370828', '金鄉縣', '370800');
INSERT INTO `china` VALUES ('370829', '嘉祥縣', '370800');
INSERT INTO `china` VALUES ('370830', '汶上縣', '370800');
INSERT INTO `china` VALUES ('370831', '泗水縣', '370800');
INSERT INTO `china` VALUES ('370832', '梁山縣', '370800');
INSERT INTO `china` VALUES ('370881', '曲阜市', '370800');
INSERT INTO `china` VALUES ('370882', '兖州市', '370800');
INSERT INTO `china` VALUES ('370883', '鄒城市', '370800');
INSERT INTO `china` VALUES ('370900', '泰安市', '370000');
INSERT INTO `china` VALUES ('370901', '岱岳區', '370900');
INSERT INTO `china` VALUES ('370902', '泰山區', '370900');
INSERT INTO `china` VALUES ('370921', '寧陽縣', '370900');
INSERT INTO `china` VALUES ('370923', '東平縣', '370900');
INSERT INTO `china` VALUES ('370982', '新泰市', '370900');
INSERT INTO `china` VALUES ('370983', '肥城市', '370900');
INSERT INTO `china` VALUES ('371000', '威海市', '370000');
INSERT INTO `china` VALUES ('371001', '市轄區', '371000');
INSERT INTO `china` VALUES ('371002', '環翠區', '371001');
INSERT INTO `china` VALUES ('371081', '文登市', '371000');
INSERT INTO `china` VALUES ('371082', '榮成市', '371000');
INSERT INTO `china` VALUES ('371083', '乳山市', '371000');
INSERT INTO `china` VALUES ('371100', '日照市', '370000');
INSERT INTO `china` VALUES ('371101', '市轄區', '371100');
INSERT INTO `china` VALUES ('371102', '東港區', '371101');
INSERT INTO `china` VALUES ('371103', '岚山區', '371101');
INSERT INTO `china` VALUES ('371121', '五蓮縣', '371100');
INSERT INTO `china` VALUES ('371122', '莒縣', '371100');
INSERT INTO `china` VALUES ('371200', '萊蕪市', '370000');
INSERT INTO `china` VALUES ('371201', '市轄區', '371200');
INSERT INTO `china` VALUES ('371202', '萊城區', '371201');
INSERT INTO `china` VALUES ('371203', '鋼城區', '371201');
INSERT INTO `china` VALUES ('371300', '臨沂市', '370000');
INSERT INTO `china` VALUES ('371301', '市轄區', '371300');
INSERT INTO `china` VALUES ('371302', '蘭山區', '371301');
INSERT INTO `china` VALUES ('371311', '羅莊區', '371301');
INSERT INTO `china` VALUES ('371312', '河東區', '371301');
INSERT INTO `china` VALUES ('371321', '沂南縣', '371300');
INSERT INTO `china` VALUES ('371322', '郯城縣', '371300');
INSERT INTO `china` VALUES ('371323', '沂水縣', '371300');
INSERT INTO `china` VALUES ('371324', '蒼山縣', '371300');
INSERT INTO `china` VALUES ('371325', '費縣', '371300');
INSERT INTO `china` VALUES ('371326', '平邑縣', '371300');
INSERT INTO `china` VALUES ('371327', '莒南縣', '371300');
INSERT INTO `china` VALUES ('371328', '蒙陰縣', '371300');
INSERT INTO `china` VALUES ('371329', '臨沭縣', '371300');
INSERT INTO `china` VALUES ('371400', '德州市', '370000');
INSERT INTO `china` VALUES ('371401', '市轄區', '371400');
INSERT INTO `china` VALUES ('371402', '德城區', '371401');
INSERT INTO `china` VALUES ('371421', '陵縣', '371400');
INSERT INTO `china` VALUES ('371422', '寧津縣', '371400');
INSERT INTO `china` VALUES ('371423', '慶雲縣', '371400');
INSERT INTO `china` VALUES ('371424', '臨邑縣', '371400');
INSERT INTO `china` VALUES ('371425', '齊河縣', '371400');
INSERT INTO `china` VALUES ('371426', '平原縣', '371400');
INSERT INTO `china` VALUES ('371427', '夏津縣', '371400');
INSERT INTO `china` VALUES ('371428', '武城縣', '371400');
INSERT INTO `china` VALUES ('371481', '樂陵市', '371400');
INSERT INTO `china` VALUES ('371482', '禹城市', '371400');
INSERT INTO `china` VALUES ('371500', '聊城市', '370000');
INSERT INTO `china` VALUES ('371501', '市轄區', '371500');
INSERT INTO `china` VALUES ('371502', '東昌府區', '371501');
INSERT INTO `china` VALUES ('371521', '陽谷縣', '371500');
INSERT INTO `china` VALUES ('371522', '莘縣', '371500');
INSERT INTO `china` VALUES ('371523', '茌平縣', '371500');
INSERT INTO `china` VALUES ('371524', '東阿縣', '371500');
INSERT INTO `china` VALUES ('371525', '冠縣', '371500');
INSERT INTO `china` VALUES ('371526', '高唐縣', '371500');
INSERT INTO `china` VALUES ('371581', '臨清市', '371500');
INSERT INTO `china` VALUES ('371600', '濱州市', '370000');
INSERT INTO `china` VALUES ('371601', '市轄區', '371600');
INSERT INTO `china` VALUES ('371602', '濱城區', '371601');
INSERT INTO `china` VALUES ('371621', '惠民縣', '371600');
INSERT INTO `china` VALUES ('371622', '陽信縣', '371600');
INSERT INTO `china` VALUES ('371623', '無棣縣', '371600');
INSERT INTO `china` VALUES ('371624', '沾化縣', '371600');
INSERT INTO `china` VALUES ('371625', '博興縣', '371600');
INSERT INTO `china` VALUES ('371626', '鄒平縣', '371600');
INSERT INTO `china` VALUES ('371700', '菏澤市', '370000');
INSERT INTO `china` VALUES ('371701', '市轄區', '371700');
INSERT INTO `china` VALUES ('371702', '牡丹區', '371701');
INSERT INTO `china` VALUES ('371721', '曹縣', '371700');
INSERT INTO `china` VALUES ('371722', '單縣', '371700');
INSERT INTO `china` VALUES ('371723', '成武縣', '371700');
INSERT INTO `china` VALUES ('371724', '巨野縣', '371700');
INSERT INTO `china` VALUES ('371725', '郓城縣', '371700');
INSERT INTO `china` VALUES ('371726', '鄄城縣', '371700');
INSERT INTO `china` VALUES ('371727', '定陶縣', '371700');
INSERT INTO `china` VALUES ('371728', '東明縣', '371700');
INSERT INTO `china` VALUES ('410000', '河南省', '0');
INSERT INTO `china` VALUES ('410100', '鄭州市', '410000');
INSERT INTO `china` VALUES ('410101', '金水區', '410100');
INSERT INTO `china` VALUES ('410102', '中原區', '410100');
INSERT INTO `china` VALUES ('410103', '二七區', '410100');
INSERT INTO `china` VALUES ('410104', '管城回族區', '410100');
INSERT INTO `china` VALUES ('410106', '上街區', '410100');
INSERT INTO `china` VALUES ('410108', '惠濟區', '410100');
INSERT INTO `china` VALUES ('410122', '中牟縣', '410100');
INSERT INTO `china` VALUES ('410181', '鞏義市', '410100');
INSERT INTO `china` VALUES ('410182', '荥陽市', '410100');
INSERT INTO `china` VALUES ('410183', '新密市', '410100');
INSERT INTO `china` VALUES ('410184', '新鄭市', '410100');
INSERT INTO `china` VALUES ('410185', '登封市', '410100');
INSERT INTO `china` VALUES ('410200', '開封市', '410000');
INSERT INTO `china` VALUES ('410201', '市轄區', '410200');
INSERT INTO `china` VALUES ('410202', '龍亭區', '410201');
INSERT INTO `china` VALUES ('410203', '順河回族區', '410201');
INSERT INTO `china` VALUES ('410204', '鼓樓區', '410201');
INSERT INTO `china` VALUES ('410205', '禹王台區', '410201');
INSERT INTO `china` VALUES ('410211', '金明區', '410201');
INSERT INTO `china` VALUES ('410221', '杞縣', '410200');
INSERT INTO `china` VALUES ('410222', '通許縣', '410200');
INSERT INTO `china` VALUES ('410223', '尉氏縣', '410200');
INSERT INTO `china` VALUES ('410224', '開封縣', '410200');
INSERT INTO `china` VALUES ('410225', '蘭考縣', '410200');
INSERT INTO `china` VALUES ('410300', '洛陽市', '410000');
INSERT INTO `china` VALUES ('410301', '市轄區', '410300');
INSERT INTO `china` VALUES ('410302', '老城區', '410301');
INSERT INTO `china` VALUES ('410303', '西工區', '410301');
INSERT INTO `china` VALUES ('410304', '廛河回族區', '410301');
INSERT INTO `china` VALUES ('410305', '澗西區', '410301');
INSERT INTO `china` VALUES ('410306', '吉利區', '410301');
INSERT INTO `china` VALUES ('410307', '洛龍區', '410301');
INSERT INTO `china` VALUES ('410322', '孟津縣', '410300');
INSERT INTO `china` VALUES ('410323', '新安縣', '410300');
INSERT INTO `china` VALUES ('410324', '栾川縣', '410300');
INSERT INTO `china` VALUES ('410325', '嵩縣', '410300');
INSERT INTO `china` VALUES ('410326', '汝陽縣', '410300');
INSERT INTO `china` VALUES ('410327', '宜陽縣', '410300');
INSERT INTO `china` VALUES ('410328', '洛寧縣', '410300');
INSERT INTO `china` VALUES ('410329', '伊川縣', '410300');
INSERT INTO `china` VALUES ('410381', '偃師市', '410300');
INSERT INTO `china` VALUES ('410400', '平頂山市', '410000');
INSERT INTO `china` VALUES ('410401', '市轄區', '410400');
INSERT INTO `china` VALUES ('410402', '新華區', '410401');
INSERT INTO `china` VALUES ('410403', '衛東區', '410401');
INSERT INTO `china` VALUES ('410404', '石龍區', '410401');
INSERT INTO `china` VALUES ('410411', '湛河區', '410401');
INSERT INTO `china` VALUES ('410421', '寶豐縣', '410400');
INSERT INTO `china` VALUES ('410422', '葉縣', '410400');
INSERT INTO `china` VALUES ('410423', '魯山縣', '410400');
INSERT INTO `china` VALUES ('410425', '郏縣', '410400');
INSERT INTO `china` VALUES ('410481', '舞鋼市', '410400');
INSERT INTO `china` VALUES ('410482', '汝州市', '410400');
INSERT INTO `china` VALUES ('410500', '安陽市', '410000');
INSERT INTO `china` VALUES ('410501', '市轄區', '410500');
INSERT INTO `china` VALUES ('410502', '文峰區', '410501');
INSERT INTO `china` VALUES ('410503', '北關區', '410501');
INSERT INTO `china` VALUES ('410505', '殷都區', '410501');
INSERT INTO `china` VALUES ('410506', '龍安區', '410501');
INSERT INTO `china` VALUES ('410522', '安陽縣', '410500');
INSERT INTO `china` VALUES ('410523', '湯陰縣', '410500');
INSERT INTO `china` VALUES ('410526', '滑縣', '410500');
INSERT INTO `china` VALUES ('410527', '內黃縣', '410500');
INSERT INTO `china` VALUES ('410581', '林州市', '410500');
INSERT INTO `china` VALUES ('410600', '鶴壁市', '410000');
INSERT INTO `china` VALUES ('410601', '市轄區', '410600');
INSERT INTO `china` VALUES ('410602', '鶴山區', '410601');
INSERT INTO `china` VALUES ('410603', '山城區', '410601');
INSERT INTO `china` VALUES ('410611', '淇濱區', '410601');
INSERT INTO `china` VALUES ('410621', '浚縣', '410600');
INSERT INTO `china` VALUES ('410622', '淇縣', '410600');
INSERT INTO `china` VALUES ('410700', '新鄉市', '410000');
INSERT INTO `china` VALUES ('410701', '市轄區', '410700');
INSERT INTO `china` VALUES ('410702', '紅旗區', '410700');
INSERT INTO `china` VALUES ('410703', '衛濱區', '410700');
INSERT INTO `china` VALUES ('410704', '鳳泉區', '410700');
INSERT INTO `china` VALUES ('410711', '牧野區', '410700');
INSERT INTO `china` VALUES ('410721', '新鄉縣', '410700');
INSERT INTO `china` VALUES ('410724', '獲嘉縣', '410700');
INSERT INTO `china` VALUES ('410725', '原陽縣', '410700');
INSERT INTO `china` VALUES ('410726', '延津縣', '410700');
INSERT INTO `china` VALUES ('410727', '封丘縣', '410700');
INSERT INTO `china` VALUES ('410728', '長垣縣', '410700');
INSERT INTO `china` VALUES ('410781', '衛輝市', '410700');
INSERT INTO `china` VALUES ('410782', '輝縣市', '410700');
INSERT INTO `china` VALUES ('410800', '焦作市', '410000');
INSERT INTO `china` VALUES ('410801', '市轄區', '410800');
INSERT INTO `china` VALUES ('410802', '解放區', '410801');
INSERT INTO `china` VALUES ('410803', '中站區', '410801');
INSERT INTO `china` VALUES ('410804', '馬村區', '410801');
INSERT INTO `china` VALUES ('410811', '山陽區', '410801');
INSERT INTO `china` VALUES ('410821', '修武縣', '410800');
INSERT INTO `china` VALUES ('410822', '博愛縣', '410800');
INSERT INTO `china` VALUES ('410823', '武陟縣', '410800');
INSERT INTO `china` VALUES ('410825', '溫縣', '410800');
INSERT INTO `china` VALUES ('410882', '沁陽市', '410800');
INSERT INTO `china` VALUES ('410883', '孟州市', '410800');
INSERT INTO `china` VALUES ('410900', '濮陽市', '410000');
INSERT INTO `china` VALUES ('410901', '市轄區', '410900');
INSERT INTO `china` VALUES ('410902', '華龍區', '410901');
INSERT INTO `china` VALUES ('410922', '清豐縣', '410900');
INSERT INTO `china` VALUES ('410923', '南樂縣', '410900');
INSERT INTO `china` VALUES ('410926', '范縣', '410900');
INSERT INTO `china` VALUES ('410927', '台前縣', '410900');
INSERT INTO `china` VALUES ('410928', '濮陽縣', '410900');
INSERT INTO `china` VALUES ('411000', '許昌市', '410000');
INSERT INTO `china` VALUES ('411001', '市轄區', '411000');
INSERT INTO `china` VALUES ('411002', '魏都區', '411001');
INSERT INTO `china` VALUES ('411023', '許昌縣', '411000');
INSERT INTO `china` VALUES ('411024', '鄢陵縣', '411000');
INSERT INTO `china` VALUES ('411025', '襄城縣', '411000');
INSERT INTO `china` VALUES ('411081', '禹州市', '411000');
INSERT INTO `china` VALUES ('411082', '長葛市', '411000');
INSERT INTO `china` VALUES ('411100', '漯河市', '410000');
INSERT INTO `china` VALUES ('411101', '召陵區', '411100');
INSERT INTO `china` VALUES ('411102', '源匯區', '411100');
INSERT INTO `china` VALUES ('411103', '郾城區', '411100');
INSERT INTO `china` VALUES ('411121', '舞陽縣', '411100');
INSERT INTO `china` VALUES ('411122', '臨颍縣', '411100');
INSERT INTO `china` VALUES ('411200', '三門峽市', '410000');
INSERT INTO `china` VALUES ('411201', '市轄區', '411200');
INSERT INTO `china` VALUES ('411202', '湖濱區', '411201');
INSERT INTO `china` VALUES ('411221', '渑池縣', '411200');
INSERT INTO `china` VALUES ('411222', '陝縣', '411200');
INSERT INTO `china` VALUES ('411224', '盧氏縣', '411200');
INSERT INTO `china` VALUES ('411281', '義馬市', '411200');
INSERT INTO `china` VALUES ('411282', '靈寶市', '411200');
INSERT INTO `china` VALUES ('411300', '南陽市', '410000');
INSERT INTO `china` VALUES ('411301', '市轄區', '411300');
INSERT INTO `china` VALUES ('411302', '宛城區', '411301');
INSERT INTO `china` VALUES ('411303', '臥龍區', '411301');
INSERT INTO `china` VALUES ('411321', '南召縣', '411300');
INSERT INTO `china` VALUES ('411322', '方城縣', '411300');
INSERT INTO `china` VALUES ('411323', '西峽縣', '411300');
INSERT INTO `china` VALUES ('411324', '鎮平縣', '411300');
INSERT INTO `china` VALUES ('411325', '內鄉縣', '411300');
INSERT INTO `china` VALUES ('411326', '淅川縣', '411300');
INSERT INTO `china` VALUES ('411327', '社旗縣', '411300');
INSERT INTO `china` VALUES ('411328', '唐河縣', '411300');
INSERT INTO `china` VALUES ('411329', '新野縣', '411300');
INSERT INTO `china` VALUES ('411330', '桐柏縣', '411300');
INSERT INTO `china` VALUES ('411381', '鄧州市', '411300');
INSERT INTO `china` VALUES ('411400', '商丘市', '410000');
INSERT INTO `china` VALUES ('411401', '市轄區', '411400');
INSERT INTO `china` VALUES ('411402', '梁園區', '411400');
INSERT INTO `china` VALUES ('411403', '睢陽區', '411400');
INSERT INTO `china` VALUES ('411421', '民權縣', '411400');
INSERT INTO `china` VALUES ('411422', '睢縣', '411400');
INSERT INTO `china` VALUES ('411423', '寧陵縣', '411400');
INSERT INTO `china` VALUES ('411424', '柘城縣', '411400');
INSERT INTO `china` VALUES ('411425', '虞城縣', '411400');
INSERT INTO `china` VALUES ('411426', '夏邑縣', '411400');
INSERT INTO `china` VALUES ('411481', '永城市', '411400');
INSERT INTO `china` VALUES ('411482', '新區', '411400');
INSERT INTO `china` VALUES ('411500', '信陽市', '410000');
INSERT INTO `china` VALUES ('411501', '市轄區', '411500');
INSERT INTO `china` VALUES ('411502', '浉河區', '411501');
INSERT INTO `china` VALUES ('411503', '平橋區', '411501');
INSERT INTO `china` VALUES ('411521', '羅山縣', '411500');
INSERT INTO `china` VALUES ('411522', '光山縣', '411500');
INSERT INTO `china` VALUES ('411523', '新縣', '411500');
INSERT INTO `china` VALUES ('411524', '商城縣', '411500');
INSERT INTO `china` VALUES ('411525', '固始縣', '411500');
INSERT INTO `china` VALUES ('411526', '潢川縣', '411500');
INSERT INTO `china` VALUES ('411527', '淮濱縣', '411500');
INSERT INTO `china` VALUES ('411528', '息縣', '411500');
INSERT INTO `china` VALUES ('411600', '周口市', '410000');
INSERT INTO `china` VALUES ('411601', '市轄區', '411600');
INSERT INTO `china` VALUES ('411602', '川匯區', '411601');
INSERT INTO `china` VALUES ('411621', '扶溝縣', '411600');
INSERT INTO `china` VALUES ('411622', '西華縣', '411600');
INSERT INTO `china` VALUES ('411623', '商水縣', '411600');
INSERT INTO `china` VALUES ('411624', '沈丘縣', '411600');
INSERT INTO `china` VALUES ('411625', '鄲城縣', '411600');
INSERT INTO `china` VALUES ('411626', '淮陽縣', '411600');
INSERT INTO `china` VALUES ('411627', '太康縣', '411600');
INSERT INTO `china` VALUES ('411628', '鹿邑縣', '411600');
INSERT INTO `china` VALUES ('411681', '項城市', '411600');
INSERT INTO `china` VALUES ('411700', '駐馬店市', '410000');
INSERT INTO `china` VALUES ('411701', '市轄區', '411700');
INSERT INTO `china` VALUES ('411702', '驿城區', '411701');
INSERT INTO `china` VALUES ('411721', '西平縣', '411700');
INSERT INTO `china` VALUES ('411722', '上蔡縣', '411700');
INSERT INTO `china` VALUES ('411723', '平輿縣', '411700');
INSERT INTO `china` VALUES ('411724', '正陽縣', '411700');
INSERT INTO `china` VALUES ('411725', '確山縣', '411700');
INSERT INTO `china` VALUES ('411726', '泌陽縣', '411700');
INSERT INTO `china` VALUES ('411727', '汝南縣', '411700');
INSERT INTO `china` VALUES ('411728', '遂平縣', '411700');
INSERT INTO `china` VALUES ('411729', '新蔡縣', '411700');
INSERT INTO `china` VALUES ('411800', '濟源市', '410000');
INSERT INTO `china` VALUES ('411801', '市轄區', '411800');
INSERT INTO `china` VALUES ('420000', '湖北省', '0');
INSERT INTO `china` VALUES ('420100', '武漢市', '420000');
INSERT INTO `china` VALUES ('420101', '市轄區', '420100');
INSERT INTO `china` VALUES ('420102', '江岸區', '420101');
INSERT INTO `china` VALUES ('420103', '江漢區', '420101');
INSERT INTO `china` VALUES ('420104', '硚口區', '420101');
INSERT INTO `china` VALUES ('420105', '漢陽區', '420101');
INSERT INTO `china` VALUES ('420106', '武昌區', '420101');
INSERT INTO `china` VALUES ('420107', '青山區', '420101');
INSERT INTO `china` VALUES ('420111', '洪山區', '420101');
INSERT INTO `china` VALUES ('420112', '東西湖區', '420101');
INSERT INTO `china` VALUES ('420113', '漢南區', '420101');
INSERT INTO `china` VALUES ('420114', '蔡甸區', '420101');
INSERT INTO `china` VALUES ('420115', '江夏區', '420101');
INSERT INTO `china` VALUES ('420116', '黃陂區', '420101');
INSERT INTO `china` VALUES ('420117', '新洲區', '420100');
INSERT INTO `china` VALUES ('420200', '黃石市', '420000');
INSERT INTO `china` VALUES ('420201', '市轄區', '420200');
INSERT INTO `china` VALUES ('420202', '黃石港區', '420201');
INSERT INTO `china` VALUES ('420203', '西塞山區', '420201');
INSERT INTO `china` VALUES ('420204', '下陸區', '420201');
INSERT INTO `china` VALUES ('420205', '鐵山區', '420201');
INSERT INTO `china` VALUES ('420222', '陽新縣', '420200');
INSERT INTO `china` VALUES ('420281', '大冶市', '420200');
INSERT INTO `china` VALUES ('420300', '十堰市', '420000');
INSERT INTO `china` VALUES ('420301', '市轄區', '420300');
INSERT INTO `china` VALUES ('420302', '茅箭區', '420301');
INSERT INTO `china` VALUES ('420303', '張灣區', '420301');
INSERT INTO `china` VALUES ('420321', '鄖縣', '420300');
INSERT INTO `china` VALUES ('420322', '鄖西縣', '420300');
INSERT INTO `china` VALUES ('420323', '竹山縣', '420300');
INSERT INTO `china` VALUES ('420324', '竹溪縣', '420300');
INSERT INTO `china` VALUES ('420325', '房縣', '420300');
INSERT INTO `china` VALUES ('420381', '丹江口市', '420300');
INSERT INTO `china` VALUES ('420500', '宜昌市', '420000');
INSERT INTO `china` VALUES ('420501', '市轄區', '420500');
INSERT INTO `china` VALUES ('420502', '西陵區', '420501');
INSERT INTO `china` VALUES ('420503', '伍家崗區', '420501');
INSERT INTO `china` VALUES ('420504', '點軍區', '420501');
INSERT INTO `china` VALUES ('420505', '猇亭區', '420501');
INSERT INTO `china` VALUES ('420506', '夷陵區', '420501');
INSERT INTO `china` VALUES ('420525', '遠安縣', '420500');
INSERT INTO `china` VALUES ('420526', '興山縣', '420500');
INSERT INTO `china` VALUES ('420527', '秭歸縣', '420500');
INSERT INTO `china` VALUES ('420528', '長陽土家族自治縣', '420500');
INSERT INTO `china` VALUES ('420529', '五峰土家族自治縣', '420500');
INSERT INTO `china` VALUES ('420581', '宜都市', '420500');
INSERT INTO `china` VALUES ('420582', '當陽市', '420500');
INSERT INTO `china` VALUES ('420583', '枝江市', '420500');
INSERT INTO `china` VALUES ('420600', '襄陽市', '420000');
INSERT INTO `china` VALUES ('420601', '市轄區', '420600');
INSERT INTO `china` VALUES ('420602', '襄城區', '420601');
INSERT INTO `china` VALUES ('420606', '樊城區', '420601');
INSERT INTO `china` VALUES ('420607', '襄州區', '420601');
INSERT INTO `china` VALUES ('420624', '南漳縣', '420600');
INSERT INTO `china` VALUES ('420625', '谷城縣', '420600');
INSERT INTO `china` VALUES ('420626', '保康縣', '420600');
INSERT INTO `china` VALUES ('420682', '老河口市', '420600');
INSERT INTO `china` VALUES ('420683', '棗陽市', '420600');
INSERT INTO `china` VALUES ('420684', '宜城市', '420600');
INSERT INTO `china` VALUES ('420700', '鄂州市', '420000');
INSERT INTO `china` VALUES ('420701', '市轄區', '420700');
INSERT INTO `china` VALUES ('420702', '梁子湖區', '420701');
INSERT INTO `china` VALUES ('420703', '華容區', '420701');
INSERT INTO `china` VALUES ('420704', '鄂城區', '420701');
INSERT INTO `china` VALUES ('420800', '荊門市', '420000');
INSERT INTO `china` VALUES ('420801', '市轄區', '420800');
INSERT INTO `china` VALUES ('420802', '東寶區', '420801');
INSERT INTO `china` VALUES ('420804', '掇刀區', '420801');
INSERT INTO `china` VALUES ('420821', '京山縣', '420800');
INSERT INTO `china` VALUES ('420822', '沙洋縣', '420800');
INSERT INTO `china` VALUES ('420881', '鐘祥市', '420800');
INSERT INTO `china` VALUES ('420900', '孝感市', '420000');
INSERT INTO `china` VALUES ('420901', '市轄區', '420900');
INSERT INTO `china` VALUES ('420902', '孝南區', '420901');
INSERT INTO `china` VALUES ('420921', '孝昌縣', '420900');
INSERT INTO `china` VALUES ('420922', '大悟縣', '420900');
INSERT INTO `china` VALUES ('420923', '雲夢縣', '420900');
INSERT INTO `china` VALUES ('420981', '應城市', '420900');
INSERT INTO `china` VALUES ('420982', '安陸市', '420900');
INSERT INTO `china` VALUES ('420984', '漢川市', '420900');
INSERT INTO `china` VALUES ('421000', '荊州市', '420000');
INSERT INTO `china` VALUES ('421001', '市轄區', '421000');
INSERT INTO `china` VALUES ('421002', '沙市區', '421001');
INSERT INTO `china` VALUES ('421003', '荊州區', '421001');
INSERT INTO `china` VALUES ('421022', '公安縣', '421000');
INSERT INTO `china` VALUES ('421023', '監利縣', '421000');
INSERT INTO `china` VALUES ('421024', '江陵縣', '421000');
INSERT INTO `china` VALUES ('421081', '石首市', '421000');
INSERT INTO `china` VALUES ('421083', '洪湖市', '421000');
INSERT INTO `china` VALUES ('421087', '松滋市', '421000');
INSERT INTO `china` VALUES ('421100', '黃岡市', '420000');
INSERT INTO `china` VALUES ('421101', '市轄區', '421100');
INSERT INTO `china` VALUES ('421102', '黃州區', '421101');
INSERT INTO `china` VALUES ('421121', '團風縣', '421100');
INSERT INTO `china` VALUES ('421122', '紅安縣', '421100');
INSERT INTO `china` VALUES ('421123', '羅田縣', '421100');
INSERT INTO `china` VALUES ('421124', '英山縣', '421100');
INSERT INTO `china` VALUES ('421125', '浠水縣', '421100');
INSERT INTO `china` VALUES ('421126', '蕲春縣', '421100');
INSERT INTO `china` VALUES ('421127', '黃梅縣', '421100');
INSERT INTO `china` VALUES ('421181', '麻城市', '421100');
INSERT INTO `china` VALUES ('421182', '武穴市', '421100');
INSERT INTO `china` VALUES ('421200', '鹹寧市', '420000');
INSERT INTO `china` VALUES ('421201', '市轄區', '421200');
INSERT INTO `china` VALUES ('421202', '鹹安區', '421201');
INSERT INTO `china` VALUES ('421221', '嘉魚縣', '421200');
INSERT INTO `china` VALUES ('421222', '通城縣', '421200');
INSERT INTO `china` VALUES ('421223', '崇陽縣', '421200');
INSERT INTO `china` VALUES ('421224', '通山縣', '421200');
INSERT INTO `china` VALUES ('421281', '赤壁市', '421200');
INSERT INTO `china` VALUES ('421300', '隨州市', '420000');
INSERT INTO `china` VALUES ('421301', '市轄區', '421300');
INSERT INTO `china` VALUES ('421302', '曾都區', '421301');
INSERT INTO `china` VALUES ('421381', '廣水市', '421300');
INSERT INTO `china` VALUES ('422800', '恩施土家族苗族自治州', '420000');
INSERT INTO `china` VALUES ('422801', '恩施市', '422800');
INSERT INTO `china` VALUES ('422802', '利川市', '422800');
INSERT INTO `china` VALUES ('422822', '建始縣', '422800');
INSERT INTO `china` VALUES ('422823', '巴東縣', '422800');
INSERT INTO `china` VALUES ('422825', '宣恩縣', '422800');
INSERT INTO `china` VALUES ('422826', '鹹豐縣', '422800');
INSERT INTO `china` VALUES ('422827', '來鳳縣', '422800');
INSERT INTO `china` VALUES ('422828', '鶴峰縣', '422800');
INSERT INTO `china` VALUES ('429000', '省直轄行政單位', '420000');
INSERT INTO `china` VALUES ('429004', '仙桃市', '429000');
INSERT INTO `china` VALUES ('429005', '潛江市', '429000');
INSERT INTO `china` VALUES ('429006', '天門市', '429000');
INSERT INTO `china` VALUES ('429021', '神農架林區', '429000');
INSERT INTO `china` VALUES ('430000', '湖南省', '0');
INSERT INTO `china` VALUES ('430100', '長沙市', '430000');
INSERT INTO `china` VALUES ('430101', '市轄區', '430100');
INSERT INTO `china` VALUES ('430102', '芙蓉區', '430101');
INSERT INTO `china` VALUES ('430103', '天心區', '430101');
INSERT INTO `china` VALUES ('430104', '岳麓區', '430101');
INSERT INTO `china` VALUES ('430105', '開福區', '430101');
INSERT INTO `china` VALUES ('430111', '雨花區', '430101');
INSERT INTO `china` VALUES ('430121', '長沙縣', '430100');
INSERT INTO `china` VALUES ('430122', '望城縣', '430100');
INSERT INTO `china` VALUES ('430124', '寧鄉縣', '430100');
INSERT INTO `china` VALUES ('430181', '浏陽市', '430100');
INSERT INTO `china` VALUES ('430200', '株洲市', '430000');
INSERT INTO `china` VALUES ('430201', '市轄區', '430200');
INSERT INTO `china` VALUES ('430202', '荷塘區', '430201');
INSERT INTO `china` VALUES ('430203', '蘆淞區', '430201');
INSERT INTO `china` VALUES ('430204', '石峰區', '430201');
INSERT INTO `china` VALUES ('430211', '天元區', '430201');
INSERT INTO `china` VALUES ('430221', '株洲縣', '430200');
INSERT INTO `china` VALUES ('430223', '攸縣', '430200');
INSERT INTO `china` VALUES ('430224', '茶陵縣', '430200');
INSERT INTO `china` VALUES ('430225', '炎陵縣', '430200');
INSERT INTO `china` VALUES ('430281', '醴陵市', '430200');
INSERT INTO `china` VALUES ('430300', '湘潭市', '430000');
INSERT INTO `china` VALUES ('430301', '市轄區', '430300');
INSERT INTO `china` VALUES ('430302', '雨湖區', '430301');
INSERT INTO `china` VALUES ('430304', '岳塘區', '430301');
INSERT INTO `china` VALUES ('430321', '湘潭縣', '430300');
INSERT INTO `china` VALUES ('430381', '湘鄉市', '430300');
INSERT INTO `china` VALUES ('430382', '韶山市', '430300');
INSERT INTO `china` VALUES ('430400', '衡陽市', '430000');
INSERT INTO `china` VALUES ('430401', '市轄區', '430400');
INSERT INTO `china` VALUES ('430405', '珠晖區', '430401');
INSERT INTO `china` VALUES ('430406', '雁峰區', '430401');
INSERT INTO `china` VALUES ('430407', '石鼓區', '430401');
INSERT INTO `china` VALUES ('430408', '蒸湘區', '430401');
INSERT INTO `china` VALUES ('430412', '南岳區', '430401');
INSERT INTO `china` VALUES ('430421', '衡陽縣', '430400');
INSERT INTO `china` VALUES ('430422', '衡南縣', '430400');
INSERT INTO `china` VALUES ('430423', '衡山縣', '430400');
INSERT INTO `china` VALUES ('430424', '衡東縣', '430400');
INSERT INTO `china` VALUES ('430426', '祁東縣', '430400');
INSERT INTO `china` VALUES ('430481', '耒陽市', '430400');
INSERT INTO `china` VALUES ('430482', '常寧市', '430400');
INSERT INTO `china` VALUES ('430500', '邵陽市', '430000');
INSERT INTO `china` VALUES ('430501', '市轄區', '430500');
INSERT INTO `china` VALUES ('430502', '雙清區', '430501');
INSERT INTO `china` VALUES ('430503', '大祥區', '430501');
INSERT INTO `china` VALUES ('430511', '北塔區', '430501');
INSERT INTO `china` VALUES ('430521', '邵東縣', '430500');
INSERT INTO `china` VALUES ('430522', '新邵縣', '430500');
INSERT INTO `china` VALUES ('430523', '邵陽縣', '430500');
INSERT INTO `china` VALUES ('430524', '隆回縣', '430500');
INSERT INTO `china` VALUES ('430525', '洞口縣', '430500');
INSERT INTO `china` VALUES ('430527', '綏寧縣', '430500');
INSERT INTO `china` VALUES ('430528', '新寧縣', '430500');
INSERT INTO `china` VALUES ('430529', '城步苗族自治縣', '430500');
INSERT INTO `china` VALUES ('430581', '武岡市', '430500');
INSERT INTO `china` VALUES ('430600', '岳陽市', '430000');
INSERT INTO `china` VALUES ('430601', '市轄區', '430600');
INSERT INTO `china` VALUES ('430602', '岳陽樓區', '430601');
INSERT INTO `china` VALUES ('430603', '雲溪區', '430601');
INSERT INTO `china` VALUES ('430611', '君山區', '430601');
INSERT INTO `china` VALUES ('430621', '岳陽縣', '430600');
INSERT INTO `china` VALUES ('430623', '華容縣', '430600');
INSERT INTO `china` VALUES ('430624', '湘陰縣', '430600');
INSERT INTO `china` VALUES ('430626', '平江縣', '430600');
INSERT INTO `china` VALUES ('430681', '汨羅市', '430600');
INSERT INTO `china` VALUES ('430682', '臨湘市', '430600');
INSERT INTO `china` VALUES ('430700', '常德市', '430000');
INSERT INTO `china` VALUES ('430701', '市轄區', '430700');
INSERT INTO `china` VALUES ('430702', '武陵區', '430701');
INSERT INTO `china` VALUES ('430703', '鼎城區', '430701');
INSERT INTO `china` VALUES ('430721', '安鄉縣', '430700');
INSERT INTO `china` VALUES ('430722', '漢壽縣', '430700');
INSERT INTO `china` VALUES ('430723', '澧縣', '430700');
INSERT INTO `china` VALUES ('430724', '臨澧縣', '430700');
INSERT INTO `china` VALUES ('430725', '桃源縣', '430700');
INSERT INTO `china` VALUES ('430726', '石門縣', '430700');
INSERT INTO `china` VALUES ('430781', '津市市', '430700');
INSERT INTO `china` VALUES ('430800', '張家界市', '430000');
INSERT INTO `china` VALUES ('430801', '市轄區', '430800');
INSERT INTO `china` VALUES ('430802', '永定區', '430801');
INSERT INTO `china` VALUES ('430811', '武陵源區', '430801');
INSERT INTO `china` VALUES ('430821', '慈利縣', '430800');
INSERT INTO `china` VALUES ('430822', '桑植縣', '430800');
INSERT INTO `china` VALUES ('430900', '益陽市', '430000');
INSERT INTO `china` VALUES ('430901', '市轄區', '430900');
INSERT INTO `china` VALUES ('430902', '資陽區', '430901');
INSERT INTO `china` VALUES ('430903', '赫山區', '430901');
INSERT INTO `china` VALUES ('430921', '南縣', '430900');
INSERT INTO `china` VALUES ('430922', '桃江縣', '430900');
INSERT INTO `china` VALUES ('430923', '安化縣', '430900');
INSERT INTO `china` VALUES ('430981', '沅江市', '430900');
INSERT INTO `china` VALUES ('431000', '郴州市', '430000');
INSERT INTO `china` VALUES ('431001', '市轄區', '431000');
INSERT INTO `china` VALUES ('431002', '北湖區', '431001');
INSERT INTO `china` VALUES ('431003', '蘇仙區', '431001');
INSERT INTO `china` VALUES ('431021', '桂陽縣', '431000');
INSERT INTO `china` VALUES ('431022', '宜章縣', '431000');
INSERT INTO `china` VALUES ('431023', '永興縣', '431000');
INSERT INTO `china` VALUES ('431024', '嘉禾縣', '431000');
INSERT INTO `china` VALUES ('431025', '臨武縣', '431000');
INSERT INTO `china` VALUES ('431026', '汝城縣', '431000');
INSERT INTO `china` VALUES ('431027', '桂東縣', '431000');
INSERT INTO `china` VALUES ('431028', '安仁縣', '431000');
INSERT INTO `china` VALUES ('431081', '資興市', '431000');
INSERT INTO `china` VALUES ('431100', '永州市', '430000');
INSERT INTO `china` VALUES ('431101', '市轄區', '431100');
INSERT INTO `china` VALUES ('431102', '零陵區', '431101');
INSERT INTO `china` VALUES ('431103', '冷水灘區', '431101');
INSERT INTO `china` VALUES ('431121', '祁陽縣', '431100');
INSERT INTO `china` VALUES ('431122', '東安縣', '431100');
INSERT INTO `china` VALUES ('431123', '雙牌縣', '431100');
INSERT INTO `china` VALUES ('431124', '道縣', '431100');
INSERT INTO `china` VALUES ('431125', '江永縣', '431100');
INSERT INTO `china` VALUES ('431126', '寧遠縣', '431100');
INSERT INTO `china` VALUES ('431127', '藍山縣', '431100');
INSERT INTO `china` VALUES ('431128', '新田縣', '431100');
INSERT INTO `china` VALUES ('431129', '江華瑤族自治縣', '431100');
INSERT INTO `china` VALUES ('431200', '懷化市', '430000');
INSERT INTO `china` VALUES ('431201', '市轄區', '431200');
INSERT INTO `china` VALUES ('431202', '鶴城區', '431201');
INSERT INTO `china` VALUES ('431221', '中方縣', '431200');
INSERT INTO `china` VALUES ('431222', '沅陵縣', '431200');
INSERT INTO `china` VALUES ('431223', '辰溪縣', '431200');
INSERT INTO `china` VALUES ('431224', '溆浦縣', '431200');
INSERT INTO `china` VALUES ('431225', '會同縣', '431200');
INSERT INTO `china` VALUES ('431226', '麻陽苗族自治縣', '431200');
INSERT INTO `china` VALUES ('431227', '新晃侗族自治縣', '431200');
INSERT INTO `china` VALUES ('431228', '芷江侗族自治縣', '431200');
INSERT INTO `china` VALUES ('431229', '靖州苗族侗族自治縣', '431200');
INSERT INTO `china` VALUES ('431230', '通道侗族自治縣', '431200');
INSERT INTO `china` VALUES ('431281', '洪江市', '431200');
INSERT INTO `china` VALUES ('431300', '婁底市', '430000');
INSERT INTO `china` VALUES ('431301', '市轄區', '431300');
INSERT INTO `china` VALUES ('431302', '婁星區', '431301');
INSERT INTO `china` VALUES ('431321', '雙峰縣', '431300');
INSERT INTO `china` VALUES ('431322', '新化縣', '431300');
INSERT INTO `china` VALUES ('431381', '冷水江市', '431300');
INSERT INTO `china` VALUES ('431382', '漣源市', '431300');
INSERT INTO `china` VALUES ('433100', '湘西土家族苗族自治州', '430000');
INSERT INTO `china` VALUES ('433101', '吉首市', '433100');
INSERT INTO `china` VALUES ('433122', '泸溪縣', '433100');
INSERT INTO `china` VALUES ('433123', '鳳凰縣', '433100');
INSERT INTO `china` VALUES ('433124', '花垣縣', '433100');
INSERT INTO `china` VALUES ('433125', '保靖縣', '433100');
INSERT INTO `china` VALUES ('433126', '古丈縣', '433100');
INSERT INTO `china` VALUES ('433127', '永順縣', '433100');
INSERT INTO `china` VALUES ('433130', '龍山縣', '433100');
INSERT INTO `china` VALUES ('440000', '廣東省', '0');
INSERT INTO `china` VALUES ('440100', '廣州市', '440000');
INSERT INTO `china` VALUES ('440101', '市轄區', '440100');
INSERT INTO `china` VALUES ('440103', '荔灣區', '440101');
INSERT INTO `china` VALUES ('440104', '越秀區', '440101');
INSERT INTO `china` VALUES ('440105', '海珠區', '440101');
INSERT INTO `china` VALUES ('440106', '天河區', '440101');
INSERT INTO `china` VALUES ('440111', '白雲區', '440101');
INSERT INTO `china` VALUES ('440112', '黃埔區', '440101');
INSERT INTO `china` VALUES ('440113', '番禺區', '440101');
INSERT INTO `china` VALUES ('440114', '花都區', '440101');
INSERT INTO `china` VALUES ('440115', '南沙區', '440101');
INSERT INTO `china` VALUES ('440116', '蘿崗區', '440101');
INSERT INTO `china` VALUES ('440183', '增城市', '440100');
INSERT INTO `china` VALUES ('440184', '從化市', '440100');
INSERT INTO `china` VALUES ('440200', '韶關市', '440000');
INSERT INTO `china` VALUES ('440201', '市轄區', '440200');
INSERT INTO `china` VALUES ('440203', '武江區', '440201');
INSERT INTO `china` VALUES ('440204', '浈江區', '440201');
INSERT INTO `china` VALUES ('440205', '曲江區', '440201');
INSERT INTO `china` VALUES ('440222', '始興縣', '440200');
INSERT INTO `china` VALUES ('440224', '仁化縣', '440200');
INSERT INTO `china` VALUES ('440229', '翁源縣', '440200');
INSERT INTO `china` VALUES ('440232', '乳源瑤族自治縣', '440200');
INSERT INTO `china` VALUES ('440233', '新豐縣', '440200');
INSERT INTO `china` VALUES ('440281', '樂昌市', '440200');
INSERT INTO `china` VALUES ('440282', '南雄市', '440200');
INSERT INTO `china` VALUES ('440300', '深圳市', '440000');
INSERT INTO `china` VALUES ('440301', '市轄區', '440300');
INSERT INTO `china` VALUES ('440303', '羅湖區', '440301');
INSERT INTO `china` VALUES ('440304', '福田區', '440301');
INSERT INTO `china` VALUES ('440305', '南山區', '440301');
INSERT INTO `china` VALUES ('440306', '寶安區', '440301');
INSERT INTO `china` VALUES ('440307', '龍崗區', '440301');
INSERT INTO `china` VALUES ('440308', '鹽田區', '440301');
INSERT INTO `china` VALUES ('440400', '珠海市', '440000');
INSERT INTO `china` VALUES ('440401', '市轄區', '440400');
INSERT INTO `china` VALUES ('440402', '香洲區', '440401');
INSERT INTO `china` VALUES ('440403', '斗門區', '440401');
INSERT INTO `china` VALUES ('440404', '金灣區', '440401');
INSERT INTO `china` VALUES ('440500', '汕頭市', '440000');
INSERT INTO `china` VALUES ('440501', '市轄區', '440500');
INSERT INTO `china` VALUES ('440507', '龍湖區', '440501');
INSERT INTO `china` VALUES ('440511', '金平區', '440501');
INSERT INTO `china` VALUES ('440512', '濠江區', '440501');
INSERT INTO `china` VALUES ('440513', '潮陽區', '440501');
INSERT INTO `china` VALUES ('440514', '潮南區', '440501');
INSERT INTO `china` VALUES ('440515', '澄海區', '440501');
INSERT INTO `china` VALUES ('440523', '南澳縣', '440500');
INSERT INTO `china` VALUES ('440600', '佛山市', '440000');
INSERT INTO `china` VALUES ('440601', '市轄區', '440600');
INSERT INTO `china` VALUES ('440604', '禅城區', '440600');
INSERT INTO `china` VALUES ('440605', '南海區', '440600');
INSERT INTO `china` VALUES ('440606', '順德區', '440600');
INSERT INTO `china` VALUES ('440607', '三水區', '440600');
INSERT INTO `china` VALUES ('440608', '高明區', '440600');
INSERT INTO `china` VALUES ('440700', '江門市', '440000');
INSERT INTO `china` VALUES ('440701', '市轄區', '440700');
INSERT INTO `china` VALUES ('440703', '蓬江區', '440701');
INSERT INTO `china` VALUES ('440704', '江海區', '440701');
INSERT INTO `china` VALUES ('440705', '新會區', '440701');
INSERT INTO `china` VALUES ('440781', '台山市', '440700');
INSERT INTO `china` VALUES ('440783', '開平市', '440700');
INSERT INTO `china` VALUES ('440784', '鶴山市', '440700');
INSERT INTO `china` VALUES ('440785', '恩平市', '440700');
INSERT INTO `china` VALUES ('440800', '湛江市', '440000');
INSERT INTO `china` VALUES ('440801', '市轄區', '440800');
INSERT INTO `china` VALUES ('440802', '赤坎區', '440801');
INSERT INTO `china` VALUES ('440803', '霞山區', '440801');
INSERT INTO `china` VALUES ('440804', '坡頭區', '440801');
INSERT INTO `china` VALUES ('440811', '麻章區', '440801');
INSERT INTO `china` VALUES ('440823', '遂溪縣', '440800');
INSERT INTO `china` VALUES ('440825', '徐聞縣', '440800');
INSERT INTO `china` VALUES ('440881', '廉江市', '440800');
INSERT INTO `china` VALUES ('440882', '雷州市', '440800');
INSERT INTO `china` VALUES ('440883', '吳川市', '440800');
INSERT INTO `china` VALUES ('440900', '茂名市', '440000');
INSERT INTO `china` VALUES ('440901', '市轄區', '440900');
INSERT INTO `china` VALUES ('440902', '茂南區', '440901');
INSERT INTO `china` VALUES ('440903', '茂港區', '440901');
INSERT INTO `china` VALUES ('440923', '電白縣', '440900');
INSERT INTO `china` VALUES ('440981', '高州市', '440900');
INSERT INTO `china` VALUES ('440982', '化州市', '440900');
INSERT INTO `china` VALUES ('440983', '信宜市', '440900');
INSERT INTO `china` VALUES ('441200', '肇慶市', '440000');
INSERT INTO `china` VALUES ('441201', '市轄區', '441200');
INSERT INTO `china` VALUES ('441202', '端州區', '441201');
INSERT INTO `china` VALUES ('441203', '鼎湖區', '441201');
INSERT INTO `china` VALUES ('441223', '廣寧縣', '441200');
INSERT INTO `china` VALUES ('441224', '懷集縣', '441200');
INSERT INTO `china` VALUES ('441225', '封開縣', '441200');
INSERT INTO `china` VALUES ('441226', '德慶縣', '441200');
INSERT INTO `china` VALUES ('441283', '高要市', '441200');
INSERT INTO `china` VALUES ('441284', '四會市', '441200');
INSERT INTO `china` VALUES ('441300', '惠州市', '440000');
INSERT INTO `china` VALUES ('441301', '市轄區', '441300');
INSERT INTO `china` VALUES ('441302', '惠城區', '441301');
INSERT INTO `china` VALUES ('441303', '惠陽區', '441301');
INSERT INTO `china` VALUES ('441322', '博羅縣', '441300');
INSERT INTO `china` VALUES ('441323', '惠東縣', '441300');
INSERT INTO `china` VALUES ('441324', '龍門縣', '441300');
INSERT INTO `china` VALUES ('441400', '梅州市', '440000');
INSERT INTO `china` VALUES ('441401', '市轄區', '441400');
INSERT INTO `china` VALUES ('441402', '梅江區', '441401');
INSERT INTO `china` VALUES ('441421', '梅縣', '441400');
INSERT INTO `china` VALUES ('441422', '大埔縣', '441400');
INSERT INTO `china` VALUES ('441423', '豐順縣', '441400');
INSERT INTO `china` VALUES ('441424', '五華縣', '441400');
INSERT INTO `china` VALUES ('441426', '平遠縣', '441400');
INSERT INTO `china` VALUES ('441427', '蕉嶺縣', '441400');
INSERT INTO `china` VALUES ('441481', '興寧市', '441400');
INSERT INTO `china` VALUES ('441500', '汕尾市', '440000');
INSERT INTO `china` VALUES ('441501', '市轄區', '441500');
INSERT INTO `china` VALUES ('441502', '城區', '441501');
INSERT INTO `china` VALUES ('441521', '海豐縣', '441500');
INSERT INTO `china` VALUES ('441523', '陸河縣', '441500');
INSERT INTO `china` VALUES ('441581', '陸豐市', '441500');
INSERT INTO `china` VALUES ('441600', '河源市', '440000');
INSERT INTO `china` VALUES ('441601', '市轄區', '441600');
INSERT INTO `china` VALUES ('441602', '源城區', '441601');
INSERT INTO `china` VALUES ('441621', '紫金縣', '441600');
INSERT INTO `china` VALUES ('441622', '龍川縣', '441600');
INSERT INTO `china` VALUES ('441623', '連平縣', '441600');
INSERT INTO `china` VALUES ('441624', '和平縣', '441600');
INSERT INTO `china` VALUES ('441625', '東源縣', '441600');
INSERT INTO `china` VALUES ('441700', '陽江市', '440000');
INSERT INTO `china` VALUES ('441701', '市轄區', '441700');
INSERT INTO `china` VALUES ('441702', '江城區', '441701');
INSERT INTO `china` VALUES ('441721', '陽西縣', '441700');
INSERT INTO `china` VALUES ('441723', '陽東縣', '441700');
INSERT INTO `china` VALUES ('441781', '陽春市', '441700');
INSERT INTO `china` VALUES ('441800', '清遠市', '440000');
INSERT INTO `china` VALUES ('441801', '市轄區', '441800');
INSERT INTO `china` VALUES ('441802', '清城區', '441801');
INSERT INTO `china` VALUES ('441821', '佛岡縣', '441800');
INSERT INTO `china` VALUES ('441823', '陽山縣', '441800');
INSERT INTO `china` VALUES ('441825', '連山壯族瑤族自治縣', '441800');
INSERT INTO `china` VALUES ('441826', '連南瑤族自治縣', '441800');
INSERT INTO `china` VALUES ('441827', '清新縣', '441800');
INSERT INTO `china` VALUES ('441881', '英德市', '441800');
INSERT INTO `china` VALUES ('441882', '連州市', '441800');
INSERT INTO `china` VALUES ('441900', '東莞市', '440000');
INSERT INTO `china` VALUES ('442000', '中山市', '440000');
INSERT INTO `china` VALUES ('445100', '潮州市', '440000');
INSERT INTO `china` VALUES ('445101', '市轄區', '445100');
INSERT INTO `china` VALUES ('445102', '湘橋區', '445101');
INSERT INTO `china` VALUES ('445121', '潮安區', '445100');
INSERT INTO `china` VALUES ('445122', '饒平縣', '445100');
INSERT INTO `china` VALUES ('445200', '揭陽市', '440000');
INSERT INTO `china` VALUES ('445201', '市轄區', '445200');
INSERT INTO `china` VALUES ('445202', '榕城區', '445201');
INSERT INTO `china` VALUES ('445221', '揭東縣', '445200');
INSERT INTO `china` VALUES ('445222', '揭西縣', '445200');
INSERT INTO `china` VALUES ('445224', '惠來縣', '445200');
INSERT INTO `china` VALUES ('445281', '普寧市', '445200');
INSERT INTO `china` VALUES ('445300', '雲浮市', '440000');
INSERT INTO `china` VALUES ('445301', '市轄區', '445300');
INSERT INTO `china` VALUES ('445302', '雲城區', '445301');
INSERT INTO `china` VALUES ('445321', '新興縣', '445300');
INSERT INTO `china` VALUES ('445322', '郁南縣', '445300');
INSERT INTO `china` VALUES ('445323', '雲安縣', '445300');
INSERT INTO `china` VALUES ('445381', '羅定市', '445300');
INSERT INTO `china` VALUES ('450000', '廣西壯族自治區', '0');
INSERT INTO `china` VALUES ('450100', '南寧市', '450000');
INSERT INTO `china` VALUES ('450101', '市轄區', '450100');
INSERT INTO `china` VALUES ('450102', '興寧區', '450101');
INSERT INTO `china` VALUES ('450103', '青秀區', '450101');
INSERT INTO `china` VALUES ('450105', '江南區', '450101');
INSERT INTO `china` VALUES ('450107', '西鄉塘區', '450101');
INSERT INTO `china` VALUES ('450108', '良慶區', '450101');
INSERT INTO `china` VALUES ('450109', '邕寧區', '450101');
INSERT INTO `china` VALUES ('450122', '武鳴縣', '450100');
INSERT INTO `china` VALUES ('450123', '隆安縣', '450100');
INSERT INTO `china` VALUES ('450124', '馬山縣', '450100');
INSERT INTO `china` VALUES ('450125', '上林縣', '450100');
INSERT INTO `china` VALUES ('450126', '賓陽縣', '450100');
INSERT INTO `china` VALUES ('450127', '橫縣', '450100');
INSERT INTO `china` VALUES ('450200', '柳州市', '450000');
INSERT INTO `china` VALUES ('450201', '市轄區', '450200');
INSERT INTO `china` VALUES ('450202', '城中區', '450201');
INSERT INTO `china` VALUES ('450203', '魚峰區', '450201');
INSERT INTO `china` VALUES ('450204', '柳南區', '450201');
INSERT INTO `china` VALUES ('450205', '柳北區', '450201');
INSERT INTO `china` VALUES ('450221', '柳江縣', '450200');
INSERT INTO `china` VALUES ('450222', '柳城縣', '450200');
INSERT INTO `china` VALUES ('450223', '鹿寨縣', '450200');
INSERT INTO `china` VALUES ('450224', '融安縣', '450200');
INSERT INTO `china` VALUES ('450225', '融水苗族自治縣', '450200');
INSERT INTO `china` VALUES ('450226', '三江侗族自治縣', '450200');
INSERT INTO `china` VALUES ('450300', '桂林市', '450000');
INSERT INTO `china` VALUES ('450301', '市轄區', '450300');
INSERT INTO `china` VALUES ('450302', '秀峰區', '450301');
INSERT INTO `china` VALUES ('450303', '疊彩區', '450301');
INSERT INTO `china` VALUES ('450304', '象山區', '450301');
INSERT INTO `china` VALUES ('450305', '七星區', '450301');
INSERT INTO `china` VALUES ('450311', '雁山區', '450301');
INSERT INTO `china` VALUES ('450321', '陽朔縣', '450300');
INSERT INTO `china` VALUES ('450322', '臨桂區', '450300');
INSERT INTO `china` VALUES ('450323', '靈川縣', '450300');
INSERT INTO `china` VALUES ('450324', '全州縣', '450300');
INSERT INTO `china` VALUES ('450325', '興安縣', '450300');
INSERT INTO `china` VALUES ('450326', '永福縣', '450300');
INSERT INTO `china` VALUES ('450327', '灌陽縣', '450300');
INSERT INTO `china` VALUES ('450328', '龍勝各族自治縣', '450300');
INSERT INTO `china` VALUES ('450329', '資源縣', '450300');
INSERT INTO `china` VALUES ('450330', '平樂縣', '450300');
INSERT INTO `china` VALUES ('450331', '荔浦縣', '450300');
INSERT INTO `china` VALUES ('450332', '恭城瑤族自治縣', '450300');
INSERT INTO `china` VALUES ('450400', '梧州市', '450000');
INSERT INTO `china` VALUES ('450401', '市轄區', '450400');
INSERT INTO `china` VALUES ('450403', '萬秀區', '450401');
INSERT INTO `china` VALUES ('450404', '蝶山區', '450401');
INSERT INTO `china` VALUES ('450405', '長洲區', '450401');
INSERT INTO `china` VALUES ('450421', '蒼梧縣', '450400');
INSERT INTO `china` VALUES ('450422', '籐縣', '450400');
INSERT INTO `china` VALUES ('450423', '蒙山縣', '450400');
INSERT INTO `china` VALUES ('450481', '岑溪市', '450400');
INSERT INTO `china` VALUES ('450500', '北海市', '450000');
INSERT INTO `china` VALUES ('450501', '市轄區', '450500');
INSERT INTO `china` VALUES ('450502', '海城區', '450501');
INSERT INTO `china` VALUES ('450503', '銀海區', '450501');
INSERT INTO `china` VALUES ('450512', '鐵山港區', '450501');
INSERT INTO `china` VALUES ('450521', '合浦縣', '450500');
INSERT INTO `china` VALUES ('450600', '防城港市', '450000');
INSERT INTO `china` VALUES ('450601', '市轄區', '450600');
INSERT INTO `china` VALUES ('450602', '港口區', '450601');
INSERT INTO `china` VALUES ('450603', '防城區', '450601');
INSERT INTO `china` VALUES ('450621', '上思縣', '450600');
INSERT INTO `china` VALUES ('450681', '東興市', '450600');
INSERT INTO `china` VALUES ('450700', '欽州市', '450000');
INSERT INTO `china` VALUES ('450701', '市轄區', '450700');
INSERT INTO `china` VALUES ('450702', '欽南區', '450700');
INSERT INTO `china` VALUES ('450703', '欽北區', '450700');
INSERT INTO `china` VALUES ('450721', '靈山縣', '450700');
INSERT INTO `china` VALUES ('450722', '浦北縣', '450700');
INSERT INTO `china` VALUES ('450800', '貴港市', '450000');
INSERT INTO `china` VALUES ('450801', '市轄區', '450800');
INSERT INTO `china` VALUES ('450802', '港北區', '450801');
INSERT INTO `china` VALUES ('450803', '港南區', '450801');
INSERT INTO `china` VALUES ('450804', '覃塘區', '450801');
INSERT INTO `china` VALUES ('450821', '平南縣', '450800');
INSERT INTO `china` VALUES ('450881', '桂平市', '450800');
INSERT INTO `china` VALUES ('450900', '玉林市', '450000');
INSERT INTO `china` VALUES ('450901', '市轄區', '450900');
INSERT INTO `china` VALUES ('450902', '玉州區', '450901');
INSERT INTO `china` VALUES ('450921', '容縣', '450900');
INSERT INTO `china` VALUES ('450922', '陸川縣', '450900');
INSERT INTO `china` VALUES ('450923', '博白縣', '450900');
INSERT INTO `china` VALUES ('450924', '興業縣', '450900');
INSERT INTO `china` VALUES ('450981', '北流市', '450900');
INSERT INTO `china` VALUES ('451000', '百色市', '450000');
INSERT INTO `china` VALUES ('451001', '市轄區', '451000');
INSERT INTO `china` VALUES ('451002', '右江區', '451001');
INSERT INTO `china` VALUES ('451021', '田陽縣', '451000');
INSERT INTO `china` VALUES ('451022', '田東縣', '451000');
INSERT INTO `china` VALUES ('451023', '平果縣', '451000');
INSERT INTO `china` VALUES ('451024', '德保縣', '451000');
INSERT INTO `china` VALUES ('451025', '靖西縣', '451000');
INSERT INTO `china` VALUES ('451026', '那坡縣', '451000');
INSERT INTO `china` VALUES ('451027', '凌雲縣', '451000');
INSERT INTO `china` VALUES ('451028', '樂業縣', '451000');
INSERT INTO `china` VALUES ('451029', '田林縣', '451000');
INSERT INTO `china` VALUES ('451030', '西林縣', '451000');
INSERT INTO `china` VALUES ('451031', '隆林各族自治縣', '451000');
INSERT INTO `china` VALUES ('451100', '賀州市', '450000');
INSERT INTO `china` VALUES ('451101', '市轄區', '451100');
INSERT INTO `china` VALUES ('451102', '八步區', '451101');
INSERT INTO `china` VALUES ('451121', '昭平縣', '451100');
INSERT INTO `china` VALUES ('451122', '鐘山縣', '451100');
INSERT INTO `china` VALUES ('451123', '富川瑤族自治縣', '451100');
INSERT INTO `china` VALUES ('451200', '河池市', '450000');
INSERT INTO `china` VALUES ('451201', '市轄區', '451200');
INSERT INTO `china` VALUES ('451202', '金城江區', '451201');
INSERT INTO `china` VALUES ('451221', '南丹縣', '451200');
INSERT INTO `china` VALUES ('451222', '天峨縣', '451200');
INSERT INTO `china` VALUES ('451223', '鳳山縣', '451200');
INSERT INTO `china` VALUES ('451224', '東蘭縣', '451200');
INSERT INTO `china` VALUES ('451225', '羅城仫佬族自治縣', '451200');
INSERT INTO `china` VALUES ('451226', '環江毛南族自治縣', '451200');
INSERT INTO `china` VALUES ('451227', '巴馬瑤族自治縣', '451200');
INSERT INTO `china` VALUES ('451228', '都安瑤族自治縣', '451200');
INSERT INTO `china` VALUES ('451229', '大化瑤族自治縣', '451200');
INSERT INTO `china` VALUES ('451281', '宜州市', '451200');
INSERT INTO `china` VALUES ('451300', '來賓市', '450000');
INSERT INTO `china` VALUES ('451301', '市轄區', '451300');
INSERT INTO `china` VALUES ('451302', '興賓區', '451301');
INSERT INTO `china` VALUES ('451321', '忻城縣', '451300');
INSERT INTO `china` VALUES ('451322', '象州縣', '451300');
INSERT INTO `china` VALUES ('451323', '武宣縣', '451300');
INSERT INTO `china` VALUES ('451324', '金秀瑤族自治縣', '451300');
INSERT INTO `china` VALUES ('451381', '合山市', '451300');
INSERT INTO `china` VALUES ('451400', '崇左市', '450000');
INSERT INTO `china` VALUES ('451401', '市轄區', '451400');
INSERT INTO `china` VALUES ('451402', '江洲區', '451401');
INSERT INTO `china` VALUES ('451421', '扶綏縣', '451400');
INSERT INTO `china` VALUES ('451422', '寧明縣', '451400');
INSERT INTO `china` VALUES ('451423', '龍州縣', '451400');
INSERT INTO `china` VALUES ('451424', '大新縣', '451400');
INSERT INTO `china` VALUES ('451425', '天等縣', '451400');
INSERT INTO `china` VALUES ('451481', '憑祥市', '451400');
INSERT INTO `china` VALUES ('460000', '海南省', '0');
INSERT INTO `china` VALUES ('460100', '海口市', '460000');
INSERT INTO `china` VALUES ('460101', '市轄區', '460100');
INSERT INTO `china` VALUES ('460105', '秀英區', '460101');
INSERT INTO `china` VALUES ('460106', '龍華區', '460101');
INSERT INTO `china` VALUES ('460107', '瓊山區', '460101');
INSERT INTO `china` VALUES ('460108', '美蘭區', '460101');
INSERT INTO `china` VALUES ('460200', '三亞市', '460000');
INSERT INTO `china` VALUES ('460201', '市轄區', '460200');
INSERT INTO `china` VALUES ('469000', '省直轄縣級行政單位', '460000');
INSERT INTO `china` VALUES ('469001', '五指山市', '469000');
INSERT INTO `china` VALUES ('469002', '瓊海市', '469000');
INSERT INTO `china` VALUES ('469003', '儋州市', '469000');
INSERT INTO `china` VALUES ('469005', '文昌市', '469000');
INSERT INTO `china` VALUES ('469006', '萬寧市', '469000');
INSERT INTO `china` VALUES ('469007', '東方市', '469000');
INSERT INTO `china` VALUES ('469025', '定安縣', '469000');
INSERT INTO `china` VALUES ('469026', '屯昌縣', '469000');
INSERT INTO `china` VALUES ('469027', '澄邁縣', '469000');
INSERT INTO `china` VALUES ('469028', '臨高縣', '469000');
INSERT INTO `china` VALUES ('469030', '白沙黎族自治縣', '469000');
INSERT INTO `china` VALUES ('469031', '昌江黎族自治縣', '469000');
INSERT INTO `china` VALUES ('469033', '樂東黎族自治縣', '469000');
INSERT INTO `china` VALUES ('469034', '陵水黎族自治縣', '469000');
INSERT INTO `china` VALUES ('469035', '保亭黎族苗族自治縣', '469000');
INSERT INTO `china` VALUES ('469036', '瓊中黎族苗族自治縣', '469000');
INSERT INTO `china` VALUES ('469037', '西沙群島', '469000');
INSERT INTO `china` VALUES ('469038', '南沙群島', '469000');
INSERT INTO `china` VALUES ('469039', '中沙群島的島礁及其海域', '469000');
INSERT INTO `china` VALUES ('500000', '重慶市', '0');
INSERT INTO `china` VALUES ('500100', '萬州區', '500000');
INSERT INTO `china` VALUES ('500101', '萬州區', '500100');
INSERT INTO `china` VALUES ('500200', '涪陵區', '500000');
INSERT INTO `china` VALUES ('500201', '涪陵區', '500200');
INSERT INTO `china` VALUES ('500300', '渝中區', '500000');
INSERT INTO `china` VALUES ('500301', '渝中區', '500300');
INSERT INTO `china` VALUES ('500400', '大渡口區', '500000');
INSERT INTO `china` VALUES ('500401', '大渡口區', '500400');
INSERT INTO `china` VALUES ('500500', '江北區', '500000');
INSERT INTO `china` VALUES ('500501', '江北區', '500500');
INSERT INTO `china` VALUES ('500600', '沙坪壩區', '500000');
INSERT INTO `china` VALUES ('500601', '沙坪壩區', '500600');
INSERT INTO `china` VALUES ('500700', '九龍坡區', '500000');
INSERT INTO `china` VALUES ('500701', '九龍坡區', '500700');
INSERT INTO `china` VALUES ('500800', '南岸區', '500000');
INSERT INTO `china` VALUES ('500801', '南岸區', '500800');
INSERT INTO `china` VALUES ('500900', '北碚區', '500000');
INSERT INTO `china` VALUES ('500901', '北碚區', '500900');
INSERT INTO `china` VALUES ('501000', '萬盛區', '500000');
INSERT INTO `china` VALUES ('501001', '萬盛區', '501000');
INSERT INTO `china` VALUES ('501100', '雙橋區', '500000');
INSERT INTO `china` VALUES ('501101', '雙橋區', '501100');
INSERT INTO `china` VALUES ('501200', '渝北區', '500000');
INSERT INTO `china` VALUES ('501201', '渝北區', '501200');
INSERT INTO `china` VALUES ('501300', '巴南區', '500000');
INSERT INTO `china` VALUES ('501301', '巴南區', '501300');
INSERT INTO `china` VALUES ('501400', '黔江區', '500000');
INSERT INTO `china` VALUES ('501401', '黔江區', '501400');
INSERT INTO `china` VALUES ('501500', '長壽區', '500000');
INSERT INTO `china` VALUES ('501501', '長壽區', '501500');
INSERT INTO `china` VALUES ('502200', '綦江區', '500000');
INSERT INTO `china` VALUES ('502201', '綦江區', '502200');
INSERT INTO `china` VALUES ('502300', '潼南縣', '500000');
INSERT INTO `china` VALUES ('502301', '潼南縣', '502300');
INSERT INTO `china` VALUES ('502400', '銅梁縣', '500000');
INSERT INTO `china` VALUES ('502401', '銅梁縣', '502400');
INSERT INTO `china` VALUES ('502500', '大足區', '500000');
INSERT INTO `china` VALUES ('502501', '大足區', '502500');
INSERT INTO `china` VALUES ('502600', '榮昌縣', '500000');
INSERT INTO `china` VALUES ('502601', '榮昌縣', '502600');
INSERT INTO `china` VALUES ('502700', '璧山縣', '500000');
INSERT INTO `china` VALUES ('502701', '璧山縣', '502700');
INSERT INTO `china` VALUES ('502800', '梁平縣', '500000');
INSERT INTO `china` VALUES ('502801', '梁平縣', '502800');
INSERT INTO `china` VALUES ('502900', '城口縣', '500000');
INSERT INTO `china` VALUES ('502901', '城口縣', '502900');
INSERT INTO `china` VALUES ('503000', '豐都縣', '500000');
INSERT INTO `china` VALUES ('503001', '豐都縣', '503000');
INSERT INTO `china` VALUES ('503100', '墊江縣', '500000');
INSERT INTO `china` VALUES ('503101', '墊江縣', '503100');
INSERT INTO `china` VALUES ('503200', '武隆縣', '500000');
INSERT INTO `china` VALUES ('503201', '武隆縣', '503200');
INSERT INTO `china` VALUES ('503300', '忠縣', '500000');
INSERT INTO `china` VALUES ('503301', '忠縣', '503300');
INSERT INTO `china` VALUES ('503400', '開縣', '500000');
INSERT INTO `china` VALUES ('503401', '開縣', '503400');
INSERT INTO `china` VALUES ('503500', '雲陽縣', '500000');
INSERT INTO `china` VALUES ('503501', '雲陽縣', '503500');
INSERT INTO `china` VALUES ('503600', '奉節縣', '500000');
INSERT INTO `china` VALUES ('503601', '奉節縣', '503600');
INSERT INTO `china` VALUES ('503700', '巫山縣', '500000');
INSERT INTO `china` VALUES ('503701', '巫山縣', '503700');
INSERT INTO `china` VALUES ('503800', '巫溪縣', '500000');
INSERT INTO `china` VALUES ('503801', '巫溪縣', '503800');
INSERT INTO `china` VALUES ('504000', '石柱縣', '500000');
INSERT INTO `china` VALUES ('504001', '石柱縣', '504000');
INSERT INTO `china` VALUES ('504100', '秀山縣', '500000');
INSERT INTO `china` VALUES ('504101', '秀山縣', '504100');
INSERT INTO `china` VALUES ('504200', '酉陽縣', '500000');
INSERT INTO `china` VALUES ('504201', '酉陽縣', '504200');
INSERT INTO `china` VALUES ('504300', '彭水縣', '500000');
INSERT INTO `china` VALUES ('504301', '彭水縣', '504300');
INSERT INTO `china` VALUES ('508100', '江津區', '500000');
INSERT INTO `china` VALUES ('508101', '江津區', '508100');
INSERT INTO `china` VALUES ('508200', '合川區', '500000');
INSERT INTO `china` VALUES ('508201', '合川區', '508200');
INSERT INTO `china` VALUES ('508300', '永川區', '500000');
INSERT INTO `china` VALUES ('508301', '永川區', '508300');
INSERT INTO `china` VALUES ('508400', '南川區', '500000');
INSERT INTO `china` VALUES ('508401', '南川區', '508400');
INSERT INTO `china` VALUES ('510000', '四川省', '0');
INSERT INTO `china` VALUES ('510100', '成都市', '510000');
INSERT INTO `china` VALUES ('510101', '市轄區', '510100');
INSERT INTO `china` VALUES ('510104', '錦江區', '510101');
INSERT INTO `china` VALUES ('510105', '青羊區', '510101');
INSERT INTO `china` VALUES ('510106', '金牛區', '510101');
INSERT INTO `china` VALUES ('510107', '武侯區', '510101');
INSERT INTO `china` VALUES ('510108', '成華區', '510101');
INSERT INTO `china` VALUES ('510112', '龍泉驿區', '510100');
INSERT INTO `china` VALUES ('510113', '青白江區', '510101');
INSERT INTO `china` VALUES ('510114', '新都區', '510101');
INSERT INTO `china` VALUES ('510115', '溫江區', '510101');
INSERT INTO `china` VALUES ('510121', '金堂縣', '510100');
INSERT INTO `china` VALUES ('510122', '雙流縣', '510100');
INSERT INTO `china` VALUES ('510124', '郫縣', '510100');
INSERT INTO `china` VALUES ('510129', '大邑縣', '510100');
INSERT INTO `china` VALUES ('510131', '蒲江縣', '510100');
INSERT INTO `china` VALUES ('510132', '新津縣', '510100');
INSERT INTO `china` VALUES ('510181', '都江堰市', '510100');
INSERT INTO `china` VALUES ('510182', '彭州市', '510100');
INSERT INTO `china` VALUES ('510183', '邛崃市', '510100');
INSERT INTO `china` VALUES ('510184', '崇州市', '510100');
INSERT INTO `china` VALUES ('510300', '自貢市', '510000');
INSERT INTO `china` VALUES ('510301', '市轄區', '510300');
INSERT INTO `china` VALUES ('510302', '自流井區', '510301');
INSERT INTO `china` VALUES ('510303', '貢井區', '510301');
INSERT INTO `china` VALUES ('510304', '大安區', '510301');
INSERT INTO `china` VALUES ('510311', '沿灘區', '510301');
INSERT INTO `china` VALUES ('510321', '榮縣', '510300');
INSERT INTO `china` VALUES ('510322', '富順縣', '510300');
INSERT INTO `china` VALUES ('510400', '攀枝花市', '510000');
INSERT INTO `china` VALUES ('510401', '市轄區', '510400');
INSERT INTO `china` VALUES ('510402', '東區', '510401');
INSERT INTO `china` VALUES ('510403', '西區', '510401');
INSERT INTO `china` VALUES ('510411', '仁和區', '510401');
INSERT INTO `china` VALUES ('510421', '米易縣', '510400');
INSERT INTO `china` VALUES ('510422', '鹽邊縣', '510400');
INSERT INTO `china` VALUES ('510500', '泸州市', '510000');
INSERT INTO `china` VALUES ('510501', '市轄區', '510500');
INSERT INTO `china` VALUES ('510502', '江陽區', '510501');
INSERT INTO `china` VALUES ('510503', '納溪區', '510501');
INSERT INTO `china` VALUES ('510504', '龍馬潭區', '510501');
INSERT INTO `china` VALUES ('510521', '泸縣', '510500');
INSERT INTO `china` VALUES ('510522', '合江縣', '510500');
INSERT INTO `china` VALUES ('510524', '敘永縣', '510500');
INSERT INTO `china` VALUES ('510525', '古蔺縣', '510500');
INSERT INTO `china` VALUES ('510600', '德陽市', '510000');
INSERT INTO `china` VALUES ('510601', '市轄區', '510600');
INSERT INTO `china` VALUES ('510603', '旌陽區', '510601');
INSERT INTO `china` VALUES ('510623', '中江縣', '510600');
INSERT INTO `china` VALUES ('510626', '羅江縣', '510600');
INSERT INTO `china` VALUES ('510681', '廣漢市', '510600');
INSERT INTO `china` VALUES ('510682', '什邡市', '510600');
INSERT INTO `china` VALUES ('510683', '綿竹市', '510600');
INSERT INTO `china` VALUES ('510700', '綿陽市', '510000');
INSERT INTO `china` VALUES ('510701', '市轄區', '510700');
INSERT INTO `china` VALUES ('510703', '涪城區', '510701');
INSERT INTO `china` VALUES ('510704', '游仙區', '510701');
INSERT INTO `china` VALUES ('510722', '三台縣', '510700');
INSERT INTO `china` VALUES ('510723', '鹽亭縣', '510700');
INSERT INTO `china` VALUES ('510724', '安縣', '510700');
INSERT INTO `china` VALUES ('510725', '梓潼縣', '510700');
INSERT INTO `china` VALUES ('510726', '北川羌族自治縣', '510700');
INSERT INTO `china` VALUES ('510727', '平武縣', '510700');
INSERT INTO `china` VALUES ('510781', '江油市', '510700');
INSERT INTO `china` VALUES ('510800', '廣元市', '510000');
INSERT INTO `china` VALUES ('510801', '市轄區', '510800');
INSERT INTO `china` VALUES ('510802', '市中區', '510801');
INSERT INTO `china` VALUES ('510811', '元壩區', '510801');
INSERT INTO `china` VALUES ('510812', '朝天區', '510801');
INSERT INTO `china` VALUES ('510821', '旺蒼縣', '510800');
INSERT INTO `china` VALUES ('510822', '青川縣', '510800');
INSERT INTO `china` VALUES ('510823', '劍閣縣', '510800');
INSERT INTO `china` VALUES ('510824', '蒼溪縣', '510800');
INSERT INTO `china` VALUES ('510900', '遂寧市', '510000');
INSERT INTO `china` VALUES ('510901', '市轄區', '510900');
INSERT INTO `china` VALUES ('510903', '船山區', '510901');
INSERT INTO `china` VALUES ('510904', '安居區', '510901');
INSERT INTO `china` VALUES ('510921', '蓬溪縣', '510900');
INSERT INTO `china` VALUES ('510922', '射洪縣', '510900');
INSERT INTO `china` VALUES ('510923', '大英縣', '510900');
INSERT INTO `china` VALUES ('511000', '內江市', '510000');
INSERT INTO `china` VALUES ('511001', '市轄區', '511000');
INSERT INTO `china` VALUES ('511002', '市中區', '511001');
INSERT INTO `china` VALUES ('511011', '東興區', '511001');
INSERT INTO `china` VALUES ('511024', '威遠縣', '511000');
INSERT INTO `china` VALUES ('511025', '資中縣', '511000');
INSERT INTO `china` VALUES ('511028', '隆昌縣', '511000');
INSERT INTO `china` VALUES ('511100', '樂山市', '510000');
INSERT INTO `china` VALUES ('511101', '市轄區', '511100');
INSERT INTO `china` VALUES ('511102', '市中區', '511101');
INSERT INTO `china` VALUES ('511111', '沙灣區', '511101');
INSERT INTO `china` VALUES ('511112', '五通橋區', '511101');
INSERT INTO `china` VALUES ('511113', '金口河區', '511101');
INSERT INTO `china` VALUES ('511123', '犍為縣', '511100');
INSERT INTO `china` VALUES ('511124', '井研縣', '511100');
INSERT INTO `china` VALUES ('511126', '夾江縣', '511100');
INSERT INTO `china` VALUES ('511129', '沐川縣', '511100');
INSERT INTO `china` VALUES ('511132', '峨邊彝族自治縣', '511100');
INSERT INTO `china` VALUES ('511133', '馬邊彝族自治縣', '511100');
INSERT INTO `china` VALUES ('511181', '峨眉山市', '511100');
INSERT INTO `china` VALUES ('511300', '南充市', '510000');
INSERT INTO `china` VALUES ('511301', '市轄區', '511300');
INSERT INTO `china` VALUES ('511302', '順慶區', '511301');
INSERT INTO `china` VALUES ('511303', '高坪區', '511301');
INSERT INTO `china` VALUES ('511304', '嘉陵區', '511301');
INSERT INTO `china` VALUES ('511321', '南部縣', '511300');
INSERT INTO `china` VALUES ('511322', '營山縣', '511300');
INSERT INTO `china` VALUES ('511323', '蓬安縣', '511300');
INSERT INTO `china` VALUES ('511324', '儀隴縣', '511300');
INSERT INTO `china` VALUES ('511325', '西充縣', '511300');
INSERT INTO `china` VALUES ('511381', '阆中市', '511300');
INSERT INTO `china` VALUES ('511400', '眉山市', '510000');
INSERT INTO `china` VALUES ('511401', '市轄區', '511400');
INSERT INTO `china` VALUES ('511402', '東坡區', '511401');
INSERT INTO `china` VALUES ('511421', '仁壽縣', '511400');
INSERT INTO `china` VALUES ('511422', '彭山縣', '511400');
INSERT INTO `china` VALUES ('511423', '洪雅縣', '511400');
INSERT INTO `china` VALUES ('511424', '丹稜縣', '511400');
INSERT INTO `china` VALUES ('511425', '青神縣', '511400');
INSERT INTO `china` VALUES ('511500', '宜賓市', '510000');
INSERT INTO `china` VALUES ('511501', '市轄區', '511500');
INSERT INTO `china` VALUES ('511502', '翠屏區', '511500');
INSERT INTO `china` VALUES ('511521', '宜賓縣', '511500');
INSERT INTO `china` VALUES ('511522', '南溪縣', '511500');
INSERT INTO `china` VALUES ('511523', '江安縣', '511500');
INSERT INTO `china` VALUES ('511524', '長寧縣', '511500');
INSERT INTO `china` VALUES ('511525', '高縣', '511500');
INSERT INTO `china` VALUES ('511526', '珙縣', '511500');
INSERT INTO `china` VALUES ('511527', '筠連縣', '511500');
INSERT INTO `china` VALUES ('511528', '興文縣', '511500');
INSERT INTO `china` VALUES ('511529', '屏山縣', '511500');
INSERT INTO `china` VALUES ('511600', '廣安市', '510000');
INSERT INTO `china` VALUES ('511601', '市轄區', '511600');
INSERT INTO `china` VALUES ('511602', '廣安區', '511601');
INSERT INTO `china` VALUES ('511621', '岳池縣', '511600');
INSERT INTO `china` VALUES ('511622', '武勝縣', '511600');
INSERT INTO `china` VALUES ('511623', '鄰水縣', '511600');
INSERT INTO `china` VALUES ('511681', '華蓥市', '511600');
INSERT INTO `china` VALUES ('511682', '廣安區', '511600');
INSERT INTO `china` VALUES ('511700', '達州市', '510000');
INSERT INTO `china` VALUES ('511701', '市轄區', '511700');
INSERT INTO `china` VALUES ('511702', '通川區', '511701');
INSERT INTO `china` VALUES ('511721', '達川區', '511700');
INSERT INTO `china` VALUES ('511722', '宣漢縣', '511700');
INSERT INTO `china` VALUES ('511723', '開江縣', '511700');
INSERT INTO `china` VALUES ('511724', '大竹縣', '511700');
INSERT INTO `china` VALUES ('511725', '渠縣', '511700');
INSERT INTO `china` VALUES ('511781', '萬源市', '511700');
INSERT INTO `china` VALUES ('511800', '雅安市', '510000');
INSERT INTO `china` VALUES ('511801', '雨城區', '511800');
INSERT INTO `china` VALUES ('511802', '雨城區', '511801');
INSERT INTO `china` VALUES ('511821', '名山區', '511800');
INSERT INTO `china` VALUES ('511822', '荥經縣', '511800');
INSERT INTO `china` VALUES ('511823', '漢源縣', '511800');
INSERT INTO `china` VALUES ('511824', '石棉縣', '511800');
INSERT INTO `china` VALUES ('511825', '天全縣', '511800');
INSERT INTO `china` VALUES ('511826', '蘆山縣', '511800');
INSERT INTO `china` VALUES ('511827', '寶興縣', '511800');
INSERT INTO `china` VALUES ('511900', '巴中市', '510000');
INSERT INTO `china` VALUES ('511901', '市轄區', '511900');
INSERT INTO `china` VALUES ('511902', '巴州區', '511901');
INSERT INTO `china` VALUES ('511921', '通江縣', '511900');
INSERT INTO `china` VALUES ('511922', '南江縣', '511900');
INSERT INTO `china` VALUES ('511923', '平昌縣', '511900');
INSERT INTO `china` VALUES ('512000', '資陽市', '510000');
INSERT INTO `china` VALUES ('512001', '市轄區', '512000');
INSERT INTO `china` VALUES ('512002', '雁江區', '512001');
INSERT INTO `china` VALUES ('512021', '安岳縣', '512000');
INSERT INTO `china` VALUES ('512022', '樂至縣', '512000');
INSERT INTO `china` VALUES ('512081', '簡陽市', '512000');
INSERT INTO `china` VALUES ('513200', '阿壩藏族羌族自治州', '510000');
INSERT INTO `china` VALUES ('513221', '汶川縣', '513200');
INSERT INTO `china` VALUES ('513222', '理縣', '513200');
INSERT INTO `china` VALUES ('513223', '茂縣', '513200');
INSERT INTO `china` VALUES ('513224', '松潘縣', '513200');
INSERT INTO `china` VALUES ('513225', '九寨溝縣', '513200');
INSERT INTO `china` VALUES ('513226', '金川縣', '513200');
INSERT INTO `china` VALUES ('513227', '小金縣', '513200');
INSERT INTO `china` VALUES ('513228', '黑水縣', '513200');
INSERT INTO `china` VALUES ('513229', '馬爾康縣', '513200');
INSERT INTO `china` VALUES ('513230', '壤塘縣', '513200');
INSERT INTO `china` VALUES ('513231', '阿壩縣', '513200');
INSERT INTO `china` VALUES ('513232', '若爾蓋縣', '513200');
INSERT INTO `china` VALUES ('513233', '紅原縣', '513200');
INSERT INTO `china` VALUES ('513300', '甘孜藏族自治州', '510000');
INSERT INTO `china` VALUES ('513321', '康定縣', '513300');
INSERT INTO `china` VALUES ('513322', '泸定縣', '513300');
INSERT INTO `china` VALUES ('513323', '丹巴縣', '513300');
INSERT INTO `china` VALUES ('513324', '九龍縣', '513300');
INSERT INTO `china` VALUES ('513325', '雅江縣', '513300');
INSERT INTO `china` VALUES ('513326', '道孚縣', '513300');
INSERT INTO `china` VALUES ('513327', '爐霍縣', '513300');
INSERT INTO `china` VALUES ('513328', '甘孜縣', '513300');
INSERT INTO `china` VALUES ('513329', '新龍縣', '513300');
INSERT INTO `china` VALUES ('513330', '德格縣', '513300');
INSERT INTO `china` VALUES ('513331', '白玉縣', '513300');
INSERT INTO `china` VALUES ('513332', '石渠縣', '513300');
INSERT INTO `china` VALUES ('513333', '色達縣', '513300');
INSERT INTO `china` VALUES ('513334', '理塘縣', '513300');
INSERT INTO `china` VALUES ('513335', '巴塘縣', '513300');
INSERT INTO `china` VALUES ('513336', '鄉城縣', '513300');
INSERT INTO `china` VALUES ('513337', '稻城縣', '513300');
INSERT INTO `china` VALUES ('513338', '得榮縣', '513300');
INSERT INTO `china` VALUES ('513400', '涼山彝族自治州', '510000');
INSERT INTO `china` VALUES ('513401', '西昌市', '513400');
INSERT INTO `china` VALUES ('513422', '木裡藏族自治縣', '513400');
INSERT INTO `china` VALUES ('513423', '鹽源縣', '513400');
INSERT INTO `china` VALUES ('513424', '德昌縣', '513400');
INSERT INTO `china` VALUES ('513425', '會理縣', '513400');
INSERT INTO `china` VALUES ('513426', '會東縣', '513400');
INSERT INTO `china` VALUES ('513427', '寧南縣', '513400');
INSERT INTO `china` VALUES ('513428', '普格縣', '513400');
INSERT INTO `china` VALUES ('513429', '布拖縣', '513400');
INSERT INTO `china` VALUES ('513430', '金陽縣', '513400');
INSERT INTO `china` VALUES ('513431', '昭覺縣', '513400');
INSERT INTO `china` VALUES ('513432', '喜德縣', '513400');
INSERT INTO `china` VALUES ('513433', '冕寧縣', '513400');
INSERT INTO `china` VALUES ('513434', '越西縣', '513400');
INSERT INTO `china` VALUES ('513435', '甘洛縣', '513400');
INSERT INTO `china` VALUES ('513436', '美姑縣', '513400');
INSERT INTO `china` VALUES ('513437', '雷波縣', '513400');
INSERT INTO `china` VALUES ('520000', '貴州省', '0');
INSERT INTO `china` VALUES ('520100', '貴陽市', '520000');
INSERT INTO `china` VALUES ('520101', '市轄區', '520100');
INSERT INTO `china` VALUES ('520102', '南明區', '520101');
INSERT INTO `china` VALUES ('520103', '雲巖區', '520101');
INSERT INTO `china` VALUES ('520111', '花溪區', '520101');
INSERT INTO `china` VALUES ('520112', '烏當區', '520100');
INSERT INTO `china` VALUES ('520113', '白雲區', '520101');
INSERT INTO `china` VALUES ('520114', '小河區', '520101');
INSERT INTO `china` VALUES ('520121', '開陽縣', '520100');
INSERT INTO `china` VALUES ('520122', '息烽縣', '520100');
INSERT INTO `china` VALUES ('520123', '修文縣', '520100');
INSERT INTO `china` VALUES ('520181', '清鎮市', '520100');
INSERT INTO `china` VALUES ('520200', '六盤水市', '520000');
INSERT INTO `china` VALUES ('520201', '鐘山區', '520200');
INSERT INTO `china` VALUES ('520203', '六枝特區', '520200');
INSERT INTO `china` VALUES ('520221', '水城縣', '520200');
INSERT INTO `china` VALUES ('520222', '盤縣', '520200');
INSERT INTO `china` VALUES ('520300', '遵義市', '520000');
INSERT INTO `china` VALUES ('520301', '市轄區', '520300');
INSERT INTO `china` VALUES ('520302', '紅花崗區', '520301');
INSERT INTO `china` VALUES ('520303', '匯川區', '520301');
INSERT INTO `china` VALUES ('520321', '遵義縣', '520300');
INSERT INTO `china` VALUES ('520322', '桐梓縣', '520300');
INSERT INTO `china` VALUES ('520323', '綏陽縣', '520300');
INSERT INTO `china` VALUES ('520324', '正安縣', '520300');
INSERT INTO `china` VALUES ('520325', '道真仡佬族苗族自治縣', '520300');
INSERT INTO `china` VALUES ('520326', '務川仡佬族苗族自治縣', '520300');
INSERT INTO `china` VALUES ('520327', '鳳岡縣', '520300');
INSERT INTO `china` VALUES ('520328', '湄潭縣', '520300');
INSERT INTO `china` VALUES ('520329', '余慶縣', '520300');
INSERT INTO `china` VALUES ('520330', '習水縣', '520300');
INSERT INTO `china` VALUES ('520381', '赤水市', '520300');
INSERT INTO `china` VALUES ('520382', '仁懷市', '520300');
INSERT INTO `china` VALUES ('520400', '安順市', '520000');
INSERT INTO `china` VALUES ('520401', '市轄區', '520400');
INSERT INTO `china` VALUES ('520402', '西秀區', '520401');
INSERT INTO `china` VALUES ('520421', '平壩縣', '520400');
INSERT INTO `china` VALUES ('520422', '普定縣', '520400');
INSERT INTO `china` VALUES ('520423', '鎮寧布依族苗族自治縣', '520400');
INSERT INTO `china` VALUES ('520424', '關嶺布依族苗族自治縣', '520400');
INSERT INTO `china` VALUES ('520425', '紫雲苗族布依族自治縣', '520400');
INSERT INTO `china` VALUES ('522200', '銅仁市', '520000');
INSERT INTO `china` VALUES ('522201', '碧江區', '522200');
INSERT INTO `china` VALUES ('522222', '江口縣', '522200');
INSERT INTO `china` VALUES ('522223', '玉屏侗族自治縣', '522200');
INSERT INTO `china` VALUES ('522224', '石阡縣', '522200');
INSERT INTO `china` VALUES ('522225', '思南縣', '522200');
INSERT INTO `china` VALUES ('522226', '印江土家族苗族自治縣', '522200');
INSERT INTO `china` VALUES ('522227', '德江縣', '522200');
INSERT INTO `china` VALUES ('522228', '沿河土家族自治縣', '522200');
INSERT INTO `china` VALUES ('522229', '松桃苗族自治縣', '522200');
INSERT INTO `china` VALUES ('522230', '萬山區', '522200');
INSERT INTO `china` VALUES ('522300', '黔西南布依族苗族自治州', '520000');
INSERT INTO `china` VALUES ('522301', '興義市', '522300');
INSERT INTO `china` VALUES ('522322', '興仁縣', '522300');
INSERT INTO `china` VALUES ('522323', '普安縣', '522300');
INSERT INTO `china` VALUES ('522324', '晴隆縣', '522300');
INSERT INTO `china` VALUES ('522325', '貞豐縣', '522300');
INSERT INTO `china` VALUES ('522326', '望谟縣', '522300');
INSERT INTO `china` VALUES ('522327', '冊亨縣', '522300');
INSERT INTO `china` VALUES ('522328', '安龍縣', '522300');
INSERT INTO `china` VALUES ('522400', '畢節市', '520000');
INSERT INTO `china` VALUES ('522401', '七星關區', '522400');
INSERT INTO `china` VALUES ('522422', '大方縣', '522400');
INSERT INTO `china` VALUES ('522423', '黔西縣', '522400');
INSERT INTO `china` VALUES ('522424', '金沙縣', '522400');
INSERT INTO `china` VALUES ('522425', '織金縣', '522400');
INSERT INTO `china` VALUES ('522426', '納雍縣', '522400');
INSERT INTO `china` VALUES ('522427', '威寧彝族回族苗族自治縣', '522400');
INSERT INTO `china` VALUES ('522428', '赫章縣', '522400');
INSERT INTO `china` VALUES ('522600', '黔東南苗族侗族自治州', '520000');
INSERT INTO `china` VALUES ('522601', '凱裡市', '522600');
INSERT INTO `china` VALUES ('522622', '黃平縣', '522600');
INSERT INTO `china` VALUES ('522623', '施秉縣', '522600');
INSERT INTO `china` VALUES ('522624', '三穗縣', '522600');
INSERT INTO `china` VALUES ('522625', '鎮遠縣', '522600');
INSERT INTO `china` VALUES ('522626', '岑鞏縣', '522600');
INSERT INTO `china` VALUES ('522627', '天柱縣', '522600');
INSERT INTO `china` VALUES ('522628', '錦屏縣', '522600');
INSERT INTO `china` VALUES ('522629', '劍河縣', '522600');
INSERT INTO `china` VALUES ('522630', '台江縣', '522600');
INSERT INTO `china` VALUES ('522631', '黎平縣', '522600');
INSERT INTO `china` VALUES ('522632', '榕江縣', '522600');
INSERT INTO `china` VALUES ('522633', '從江縣', '522600');
INSERT INTO `china` VALUES ('522634', '雷山縣', '522600');
INSERT INTO `china` VALUES ('522635', '麻江縣', '522600');
INSERT INTO `china` VALUES ('522636', '丹寨縣', '522600');
INSERT INTO `china` VALUES ('522700', '黔南布依族苗族自治州', '520000');
INSERT INTO `china` VALUES ('522701', '都勻市', '522700');
INSERT INTO `china` VALUES ('522702', '福泉市', '522700');
INSERT INTO `china` VALUES ('522722', '荔波縣', '522700');
INSERT INTO `china` VALUES ('522723', '貴定縣', '522700');
INSERT INTO `china` VALUES ('522725', '甕安縣', '522700');
INSERT INTO `china` VALUES ('522726', '獨山縣', '522700');
INSERT INTO `china` VALUES ('522727', '平塘縣', '522700');
INSERT INTO `china` VALUES ('522728', '羅甸縣', '522700');
INSERT INTO `china` VALUES ('522729', '長順縣', '522700');
INSERT INTO `china` VALUES ('522730', '龍裡縣', '522700');
INSERT INTO `china` VALUES ('522731', '惠水縣', '522700');
INSERT INTO `china` VALUES ('522732', '三都水族自治縣', '522700');
INSERT INTO `china` VALUES ('530000', '雲南省', '0');
INSERT INTO `china` VALUES ('530100', '昆明市', '530000');
INSERT INTO `china` VALUES ('530101', '市轄區', '530100');
INSERT INTO `china` VALUES ('530102', '五華區', '530101');
INSERT INTO `china` VALUES ('530103', '盤龍區', '530101');
INSERT INTO `china` VALUES ('530111', '官渡區', '530101');
INSERT INTO `china` VALUES ('530112', '西山區', '530101');
INSERT INTO `china` VALUES ('530113', '東川區', '530101');
INSERT INTO `china` VALUES ('530121', '呈貢縣', '530100');
INSERT INTO `china` VALUES ('530122', '晉寧縣', '530100');
INSERT INTO `china` VALUES ('530124', '富民縣', '530100');
INSERT INTO `china` VALUES ('530125', '宜良縣', '530100');
INSERT INTO `china` VALUES ('530126', '石林彝族自治縣', '530100');
INSERT INTO `china` VALUES ('530127', '嵩明縣', '530100');
INSERT INTO `china` VALUES ('530128', '祿勸彝族苗族自治縣', '530100');
INSERT INTO `china` VALUES ('530129', '尋甸回族彝族自治縣', '530100');
INSERT INTO `china` VALUES ('530181', '安寧市', '530100');
INSERT INTO `china` VALUES ('530300', '曲靖市', '530000');
INSERT INTO `china` VALUES ('530301', '市轄區', '530300');
INSERT INTO `china` VALUES ('530302', '麒麟區', '530301');
INSERT INTO `china` VALUES ('530321', '馬龍縣', '530300');
INSERT INTO `china` VALUES ('530322', '陸良縣', '530300');
INSERT INTO `china` VALUES ('530323', '師宗縣', '530300');
INSERT INTO `china` VALUES ('530324', '羅平縣', '530300');
INSERT INTO `china` VALUES ('530325', '富源縣', '530300');
INSERT INTO `china` VALUES ('530326', '會澤縣', '530300');
INSERT INTO `china` VALUES ('530328', '沾益縣', '530300');
INSERT INTO `china` VALUES ('530381', '宣威市', '530300');
INSERT INTO `china` VALUES ('530400', '玉溪市', '530000');
INSERT INTO `china` VALUES ('530401', '市轄區', '530400');
INSERT INTO `china` VALUES ('530402', '紅塔區', '530401');
INSERT INTO `china` VALUES ('530421', '江川縣', '530400');
INSERT INTO `china` VALUES ('530422', '澄江縣', '530400');
INSERT INTO `china` VALUES ('530423', '通海縣', '530400');
INSERT INTO `china` VALUES ('530424', '華寧縣', '530400');
INSERT INTO `china` VALUES ('530425', '易門縣', '530400');
INSERT INTO `china` VALUES ('530426', '峨山彝族自治縣', '530400');
INSERT INTO `china` VALUES ('530427', '新平彝族傣族自治縣', '530400');
INSERT INTO `china` VALUES ('530428', '元江哈尼族彝族傣族自治縣', '530400');
INSERT INTO `china` VALUES ('530500', '保山市', '530000');
INSERT INTO `china` VALUES ('530501', '市轄區', '530500');
INSERT INTO `china` VALUES ('530502', '隆陽區', '530500');
INSERT INTO `china` VALUES ('530521', '施甸縣', '530500');
INSERT INTO `china` VALUES ('530522', '騰沖縣', '530500');
INSERT INTO `china` VALUES ('530523', '龍陵縣', '530500');
INSERT INTO `china` VALUES ('530524', '昌寧縣', '530500');
INSERT INTO `china` VALUES ('530600', '昭通市', '530000');
INSERT INTO `china` VALUES ('530601', '市轄區', '530600');
INSERT INTO `china` VALUES ('530602', '昭陽區', '530601');
INSERT INTO `china` VALUES ('530621', '魯甸縣', '530600');
INSERT INTO `china` VALUES ('530622', '巧家縣', '530600');
INSERT INTO `china` VALUES ('530623', '鹽津縣', '530600');
INSERT INTO `china` VALUES ('530624', '大關縣', '530600');
INSERT INTO `china` VALUES ('530625', '永善縣', '530600');
INSERT INTO `china` VALUES ('530626', '綏江縣', '530600');
INSERT INTO `china` VALUES ('530627', '鎮雄縣', '530600');
INSERT INTO `china` VALUES ('530628', '彝良縣', '530600');
INSERT INTO `china` VALUES ('530629', '威信縣', '530600');
INSERT INTO `china` VALUES ('530630', '水富縣', '530600');
INSERT INTO `china` VALUES ('530700', '麗江市', '530000');
INSERT INTO `china` VALUES ('530701', '市轄區', '530700');
INSERT INTO `china` VALUES ('530702', '古城區', '530701');
INSERT INTO `china` VALUES ('530721', '玉龍納西族自治縣', '530700');
INSERT INTO `china` VALUES ('530722', '永勝縣', '530700');
INSERT INTO `china` VALUES ('530723', '華坪縣', '530700');
INSERT INTO `china` VALUES ('530724', '寧蒗彝族自治縣', '530700');
INSERT INTO `china` VALUES ('530800', '普洱市', '530000');
INSERT INTO `china` VALUES ('530801', '市轄區', '530800');
INSERT INTO `china` VALUES ('530802', '翠雲區', '530801');
INSERT INTO `china` VALUES ('530821', '寧洱哈尼族彝族自治縣', '530800');
INSERT INTO `china` VALUES ('530822', '墨江哈尼族自治縣', '530800');
INSERT INTO `china` VALUES ('530823', '景東彝族自治縣', '530800');
INSERT INTO `china` VALUES ('530824', '景谷傣族彝族自治縣', '530800');
INSERT INTO `china` VALUES ('530825', '鎮沅彝族哈尼族拉祜族自治縣', '530800');
INSERT INTO `china` VALUES ('530826', '江城哈尼族彝族自治縣', '530800');
INSERT INTO `china` VALUES ('530827', '孟連傣族拉祜族佤族自治縣', '530800');
INSERT INTO `china` VALUES ('530828', '瀾滄拉祜族自治縣', '530800');
INSERT INTO `china` VALUES ('530829', '西盟佤族自治縣', '530800');
INSERT INTO `china` VALUES ('530900', '臨滄市', '530000');
INSERT INTO `china` VALUES ('530901', '市轄區', '530900');
INSERT INTO `china` VALUES ('530902', '臨翔區', '530901');
INSERT INTO `china` VALUES ('530921', '鳳慶縣', '530900');
INSERT INTO `china` VALUES ('530922', '雲縣', '530900');
INSERT INTO `china` VALUES ('530923', '永德縣', '530900');
INSERT INTO `china` VALUES ('530924', '鎮康縣', '530900');
INSERT INTO `china` VALUES ('530925', '雙江拉祜族佤族布朗族傣族自治縣', '530900');
INSERT INTO `china` VALUES ('530926', '耿馬傣族佤族自治縣', '530900');
INSERT INTO `china` VALUES ('530927', '滄源佤族自治縣', '530900');
INSERT INTO `china` VALUES ('532300', '楚雄彝族自治州', '530000');
INSERT INTO `china` VALUES ('532301', '楚雄市', '532300');
INSERT INTO `china` VALUES ('532322', '雙柏縣', '532300');
INSERT INTO `china` VALUES ('532323', '牟定縣', '532300');
INSERT INTO `china` VALUES ('532324', '南華縣', '532300');
INSERT INTO `china` VALUES ('532325', '姚安縣', '532300');
INSERT INTO `china` VALUES ('532326', '大姚縣', '532300');
INSERT INTO `china` VALUES ('532327', '永仁縣', '532300');
INSERT INTO `china` VALUES ('532328', '元謀縣', '532300');
INSERT INTO `china` VALUES ('532329', '武定縣', '532300');
INSERT INTO `china` VALUES ('532331', '祿豐縣', '532300');
INSERT INTO `china` VALUES ('532500', '紅河哈尼族彝族自治州', '530000');
INSERT INTO `china` VALUES ('532501', '個舊市', '532500');
INSERT INTO `china` VALUES ('532502', '開遠市', '532500');
INSERT INTO `china` VALUES ('532522', '蒙自市', '532500');
INSERT INTO `china` VALUES ('532523', '屏邊苗族自治縣', '532500');
INSERT INTO `china` VALUES ('532524', '建水縣', '532500');
INSERT INTO `china` VALUES ('532525', '石屏縣', '532500');
INSERT INTO `china` VALUES ('532526', '彌勒市', '532500');
INSERT INTO `china` VALUES ('532527', '泸西縣', '532500');
INSERT INTO `china` VALUES ('532528', '元陽縣', '532500');
INSERT INTO `china` VALUES ('532529', '紅河縣', '532500');
INSERT INTO `china` VALUES ('532530', '金平苗族瑤族傣族自治縣', '532500');
INSERT INTO `china` VALUES ('532531', '綠春縣', '532500');
INSERT INTO `china` VALUES ('532532', '河口瑤族自治縣', '532500');
INSERT INTO `china` VALUES ('532600', '文山壯族苗族自治州', '530000');
INSERT INTO `china` VALUES ('532621', '文山市', '532600');
INSERT INTO `china` VALUES ('532622', '硯山縣', '532600');
INSERT INTO `china` VALUES ('532623', '西疇縣', '532600');
INSERT INTO `china` VALUES ('532624', '麻栗坡縣', '532600');
INSERT INTO `china` VALUES ('532625', '馬關縣', '532600');
INSERT INTO `china` VALUES ('532626', '丘北縣', '532600');
INSERT INTO `china` VALUES ('532627', '廣南縣', '532600');
INSERT INTO `china` VALUES ('532628', '富寧縣', '532600');
INSERT INTO `china` VALUES ('532800', '西雙版納傣族自治州', '530000');
INSERT INTO `china` VALUES ('532801', '景洪市', '532800');
INSERT INTO `china` VALUES ('532822', '勐海縣', '532800');
INSERT INTO `china` VALUES ('532823', '勐臘縣', '532800');
INSERT INTO `china` VALUES ('532900', '大理白族自治州', '530000');
INSERT INTO `china` VALUES ('532901', '大理市', '532900');
INSERT INTO `china` VALUES ('532922', '漾濞彝族自治縣', '532900');
INSERT INTO `china` VALUES ('532923', '祥雲縣', '532900');
INSERT INTO `china` VALUES ('532924', '賓川縣', '532900');
INSERT INTO `china` VALUES ('532925', '彌渡縣', '532900');
INSERT INTO `china` VALUES ('532926', '南澗彝族自治縣', '532900');
INSERT INTO `china` VALUES ('532927', '巍山彝族回族自治縣', '532900');
INSERT INTO `china` VALUES ('532928', '永平縣', '532900');
INSERT INTO `china` VALUES ('532929', '雲龍縣', '532900');
INSERT INTO `china` VALUES ('532930', '洱源縣', '532900');
INSERT INTO `china` VALUES ('532931', '劍川縣', '532900');
INSERT INTO `china` VALUES ('532932', '鶴慶縣', '532900');
INSERT INTO `china` VALUES ('533100', '德宏傣族景頗族自治州', '530000');
INSERT INTO `china` VALUES ('533102', '瑞麗市', '533100');
INSERT INTO `china` VALUES ('533103', '潞西市', '533100');
INSERT INTO `china` VALUES ('533122', '梁河縣', '533100');
INSERT INTO `china` VALUES ('533123', '盈江縣', '533100');
INSERT INTO `china` VALUES ('533124', '隴川縣', '533100');
INSERT INTO `china` VALUES ('533300', '怒江傈僳族自治州', '530000');
INSERT INTO `china` VALUES ('533321', '泸水縣', '533300');
INSERT INTO `china` VALUES ('533323', '福貢縣', '533300');
INSERT INTO `china` VALUES ('533324', '貢山獨龍族怒族自治縣', '533300');
INSERT INTO `china` VALUES ('533325', '蘭坪白族普米族自治縣', '533300');
INSERT INTO `china` VALUES ('533400', '迪慶藏族自治州', '530000');
INSERT INTO `china` VALUES ('533421', '香格裡拉縣', '533400');
INSERT INTO `china` VALUES ('533422', '德欽縣', '533400');
INSERT INTO `china` VALUES ('533423', '維西傈僳族自治縣', '533400');
INSERT INTO `china` VALUES ('540000', '西藏自治區', '0');
INSERT INTO `china` VALUES ('540100', '拉薩市', '540000');
INSERT INTO `china` VALUES ('540101', '市轄區', '540100');
INSERT INTO `china` VALUES ('540102', '城關區', '540101');
INSERT INTO `china` VALUES ('540121', '林周縣', '540100');
INSERT INTO `china` VALUES ('540122', '當雄縣', '540100');
INSERT INTO `china` VALUES ('540123', '尼木縣', '540100');
INSERT INTO `china` VALUES ('540124', '曲水縣', '540100');
INSERT INTO `china` VALUES ('540125', '堆龍德慶縣', '540100');
INSERT INTO `china` VALUES ('540126', '達孜縣', '540100');
INSERT INTO `china` VALUES ('540127', '墨竹工卡縣', '540100');
INSERT INTO `china` VALUES ('542100', '昌都地區', '540000');
INSERT INTO `china` VALUES ('542121', '昌都縣', '542100');
INSERT INTO `china` VALUES ('542122', '江達縣', '542100');
INSERT INTO `china` VALUES ('542123', '貢覺縣', '542100');
INSERT INTO `china` VALUES ('542124', '類烏齊縣', '542100');
INSERT INTO `china` VALUES ('542125', '丁青縣', '542100');
INSERT INTO `china` VALUES ('542126', '察雅縣', '542100');
INSERT INTO `china` VALUES ('542127', '八宿縣', '542100');
INSERT INTO `china` VALUES ('542128', '左貢縣', '542100');
INSERT INTO `china` VALUES ('542129', '芒康縣', '542100');
INSERT INTO `china` VALUES ('542132', '洛隆縣', '542100');
INSERT INTO `china` VALUES ('542133', '邊壩縣', '542100');
INSERT INTO `china` VALUES ('542200', '山南地區', '540000');
INSERT INTO `china` VALUES ('542221', '乃東縣', '542200');
INSERT INTO `china` VALUES ('542222', '扎囊縣', '542200');
INSERT INTO `china` VALUES ('542223', '貢嘎縣', '542200');
INSERT INTO `china` VALUES ('542224', '桑日縣', '542200');
INSERT INTO `china` VALUES ('542225', '瓊結縣', '542200');
INSERT INTO `china` VALUES ('542226', '曲松縣', '542200');
INSERT INTO `china` VALUES ('542227', '措美縣', '542200');
INSERT INTO `china` VALUES ('542228', '洛扎縣', '542200');
INSERT INTO `china` VALUES ('542229', '加查縣', '542200');
INSERT INTO `china` VALUES ('542231', '隆子縣', '542200');
INSERT INTO `china` VALUES ('542232', '錯那縣', '542200');
INSERT INTO `china` VALUES ('542233', '浪卡子縣', '542200');
INSERT INTO `china` VALUES ('542300', '日喀則地區', '540000');
INSERT INTO `china` VALUES ('542301', '日喀則市', '542300');
INSERT INTO `china` VALUES ('542322', '南木林縣', '542300');
INSERT INTO `china` VALUES ('542323', '江孜縣', '542300');
INSERT INTO `china` VALUES ('542324', '定日縣', '542300');
INSERT INTO `china` VALUES ('542325', '薩迦縣', '542300');
INSERT INTO `china` VALUES ('542326', '拉孜縣', '542300');
INSERT INTO `china` VALUES ('542327', '昂仁縣', '542300');
INSERT INTO `china` VALUES ('542328', '謝通門縣', '542300');
INSERT INTO `china` VALUES ('542329', '白朗縣', '542300');
INSERT INTO `china` VALUES ('542330', '仁布縣', '542300');
INSERT INTO `china` VALUES ('542331', '康馬縣', '542300');
INSERT INTO `china` VALUES ('542332', '定結縣', '542300');
INSERT INTO `china` VALUES ('542333', '仲巴縣', '542300');
INSERT INTO `china` VALUES ('542334', '亞東縣', '542300');
INSERT INTO `china` VALUES ('542335', '吉隆縣', '542300');
INSERT INTO `china` VALUES ('542336', '聶拉木縣', '542300');
INSERT INTO `china` VALUES ('542337', '薩嘎縣', '542300');
INSERT INTO `china` VALUES ('542338', '崗巴縣', '542300');
INSERT INTO `china` VALUES ('542400', '那曲地區', '540000');
INSERT INTO `china` VALUES ('542421', '那曲縣', '542400');
INSERT INTO `china` VALUES ('542422', '嘉黎縣', '542400');
INSERT INTO `china` VALUES ('542423', '比如縣', '542400');
INSERT INTO `china` VALUES ('542424', '聶榮縣', '542400');
INSERT INTO `china` VALUES ('542425', '安多縣', '542400');
INSERT INTO `china` VALUES ('542426', '申扎縣', '542400');
INSERT INTO `china` VALUES ('542427', '索縣', '542400');
INSERT INTO `china` VALUES ('542428', '班戈縣', '542400');
INSERT INTO `china` VALUES ('542429', '巴青縣', '542400');
INSERT INTO `china` VALUES ('542430', '尼瑪縣', '542400');
INSERT INTO `china` VALUES ('542500', '阿裡地區', '540000');
INSERT INTO `china` VALUES ('542521', '普蘭縣', '542500');
INSERT INTO `china` VALUES ('542522', '札達縣', '542500');
INSERT INTO `china` VALUES ('542523', '噶爾縣', '542500');
INSERT INTO `china` VALUES ('542524', '日土縣', '542500');
INSERT INTO `china` VALUES ('542525', '革吉縣', '542500');
INSERT INTO `china` VALUES ('542526', '改則縣', '542500');
INSERT INTO `china` VALUES ('542527', '措勤縣', '542500');
INSERT INTO `china` VALUES ('542600', '林芝地區', '540000');
INSERT INTO `china` VALUES ('542621', '林芝縣', '542600');
INSERT INTO `china` VALUES ('542622', '工布江達縣', '542600');
INSERT INTO `china` VALUES ('542623', '米林縣', '542600');
INSERT INTO `china` VALUES ('542624', '墨脫縣', '542600');
INSERT INTO `china` VALUES ('542625', '波密縣', '542600');
INSERT INTO `china` VALUES ('542626', '察隅縣', '542600');
INSERT INTO `china` VALUES ('542627', '朗縣', '542600');
INSERT INTO `china` VALUES ('610000', '陝西省', '0');
INSERT INTO `china` VALUES ('610100', '西安市', '610000');
INSERT INTO `china` VALUES ('610101', '長安區', '610100');
INSERT INTO `china` VALUES ('610102', '新城區', '610100');
INSERT INTO `china` VALUES ('610103', '碑林區', '610100');
INSERT INTO `china` VALUES ('610104', '蓮湖區', '610100');
INSERT INTO `china` VALUES ('610111', '灞橋區', '610100');
INSERT INTO `china` VALUES ('610112', '未央區', '610100');
INSERT INTO `china` VALUES ('610113', '雁塔區', '610100');
INSERT INTO `china` VALUES ('610114', '閻良區', '610100');
INSERT INTO `china` VALUES ('610115', '臨潼區', '610100');
INSERT INTO `china` VALUES ('610122', '藍田縣', '610100');
INSERT INTO `china` VALUES ('610124', '周至縣', '610100');
INSERT INTO `china` VALUES ('610125', '戶縣', '610100');
INSERT INTO `china` VALUES ('610126', '高陵縣', '610100');
INSERT INTO `china` VALUES ('610200', '銅川市', '610000');
INSERT INTO `china` VALUES ('610201', '市轄區', '610200');
INSERT INTO `china` VALUES ('610202', '王益區', '610201');
INSERT INTO `china` VALUES ('610203', '印台區', '610201');
INSERT INTO `china` VALUES ('610204', '耀州區', '610201');
INSERT INTO `china` VALUES ('610222', '宜君縣', '610200');
INSERT INTO `china` VALUES ('610300', '寶雞市', '610000');
INSERT INTO `china` VALUES ('610301', '市轄區', '610300');
INSERT INTO `china` VALUES ('610302', '渭濱區', '610301');
INSERT INTO `china` VALUES ('610303', '金台區', '610301');
INSERT INTO `china` VALUES ('610304', '陳倉區', '610301');
INSERT INTO `china` VALUES ('610322', '鳳翔縣', '610300');
INSERT INTO `china` VALUES ('610323', '岐山縣', '610300');
INSERT INTO `china` VALUES ('610324', '扶風縣', '610300');
INSERT INTO `china` VALUES ('610326', '眉縣', '610300');
INSERT INTO `china` VALUES ('610327', '隴縣', '610300');
INSERT INTO `china` VALUES ('610328', '千陽縣', '610300');
INSERT INTO `china` VALUES ('610329', '麟游縣', '610300');
INSERT INTO `china` VALUES ('610330', '鳳縣', '610300');
INSERT INTO `china` VALUES ('610331', '太白縣', '610300');
INSERT INTO `china` VALUES ('610400', '鹹陽市', '610000');
INSERT INTO `china` VALUES ('610401', '市轄區', '610400');
INSERT INTO `china` VALUES ('610402', '秦都區', '610401');
INSERT INTO `china` VALUES ('610404', '渭城區', '610401');
INSERT INTO `china` VALUES ('610422', '三原縣', '610400');
INSERT INTO `china` VALUES ('610423', '泾陽縣', '610400');
INSERT INTO `china` VALUES ('610424', '乾縣', '610400');
INSERT INTO `china` VALUES ('610425', '禮泉縣', '610400');
INSERT INTO `china` VALUES ('610426', '永壽縣', '610400');
INSERT INTO `china` VALUES ('610427', '彬縣', '610400');
INSERT INTO `china` VALUES ('610428', '長武縣', '610400');
INSERT INTO `china` VALUES ('610429', '旬邑縣', '610400');
INSERT INTO `china` VALUES ('610430', '淳化縣', '610400');
INSERT INTO `china` VALUES ('610431', '武功縣', '610400');
INSERT INTO `china` VALUES ('610481', '興平市', '610400');
INSERT INTO `china` VALUES ('610500', '渭南市', '610000');
INSERT INTO `china` VALUES ('610501', '市轄區', '610500');
INSERT INTO `china` VALUES ('610502', '臨渭區', '610501');
INSERT INTO `china` VALUES ('610521', '華縣', '610500');
INSERT INTO `china` VALUES ('610522', '潼關縣', '610500');
INSERT INTO `china` VALUES ('610523', '大荔縣', '610500');
INSERT INTO `china` VALUES ('610524', '合陽縣', '610500');
INSERT INTO `china` VALUES ('610525', '澄城縣', '610500');
INSERT INTO `china` VALUES ('610526', '蒲城縣', '610500');
INSERT INTO `china` VALUES ('610527', '白水縣', '610500');
INSERT INTO `china` VALUES ('610528', '富平縣', '610500');
INSERT INTO `china` VALUES ('610581', '韓城市', '610500');
INSERT INTO `china` VALUES ('610582', '華陰市', '610500');
INSERT INTO `china` VALUES ('610600', '延安市', '610000');
INSERT INTO `china` VALUES ('610601', '市轄區', '610600');
INSERT INTO `china` VALUES ('610602', '寶塔區', '610601');
INSERT INTO `china` VALUES ('610621', '延長縣', '610600');
INSERT INTO `china` VALUES ('610622', '延川縣', '610600');
INSERT INTO `china` VALUES ('610623', '子長縣', '610600');
INSERT INTO `china` VALUES ('610624', '安塞縣', '610600');
INSERT INTO `china` VALUES ('610625', '志丹縣', '610600');
INSERT INTO `china` VALUES ('610626', '吳起縣', '610600');
INSERT INTO `china` VALUES ('610627', '甘泉縣', '610600');
INSERT INTO `china` VALUES ('610628', '富縣', '610600');
INSERT INTO `china` VALUES ('610629', '洛川縣', '610600');
INSERT INTO `china` VALUES ('610630', '宜川縣', '610600');
INSERT INTO `china` VALUES ('610631', '黃龍縣', '610600');
INSERT INTO `china` VALUES ('610632', '黃陵縣', '610600');
INSERT INTO `china` VALUES ('610700', '漢中市', '610000');
INSERT INTO `china` VALUES ('610701', '市轄區', '610700');
INSERT INTO `china` VALUES ('610702', '漢台區', '610701');
INSERT INTO `china` VALUES ('610721', '南鄭縣', '610700');
INSERT INTO `china` VALUES ('610722', '城固縣', '610700');
INSERT INTO `china` VALUES ('610723', '洋縣', '610700');
INSERT INTO `china` VALUES ('610724', '西鄉縣', '610700');
INSERT INTO `china` VALUES ('610725', '勉縣', '610700');
INSERT INTO `china` VALUES ('610726', '寧強縣', '610700');
INSERT INTO `china` VALUES ('610727', '略陽縣', '610700');
INSERT INTO `china` VALUES ('610728', '鎮巴縣', '610700');
INSERT INTO `china` VALUES ('610729', '留壩縣', '610700');
INSERT INTO `china` VALUES ('610730', '佛坪縣', '610700');
INSERT INTO `china` VALUES ('610800', '榆林市', '610000');
INSERT INTO `china` VALUES ('610801', '市轄區', '610800');
INSERT INTO `china` VALUES ('610802', '榆陽區', '610800');
INSERT INTO `china` VALUES ('610821', '神木縣', '610800');
INSERT INTO `china` VALUES ('610822', '府谷縣', '610800');
INSERT INTO `china` VALUES ('610823', '橫山縣', '610800');
INSERT INTO `china` VALUES ('610824', '靖邊縣', '610800');
INSERT INTO `china` VALUES ('610825', '定邊縣', '610800');
INSERT INTO `china` VALUES ('610826', '綏德縣', '610800');
INSERT INTO `china` VALUES ('610827', '米脂縣', '610800');
INSERT INTO `china` VALUES ('610828', '佳縣', '610800');
INSERT INTO `china` VALUES ('610829', '吳堡縣', '610800');
INSERT INTO `china` VALUES ('610830', '清澗縣', '610800');
INSERT INTO `china` VALUES ('610831', '子洲縣', '610800');
INSERT INTO `china` VALUES ('610900', '安康市', '610000');
INSERT INTO `china` VALUES ('610901', '市轄區', '610900');
INSERT INTO `china` VALUES ('610902', '漢濱區', '610901');
INSERT INTO `china` VALUES ('610921', '漢陰縣', '610900');
INSERT INTO `china` VALUES ('610922', '石泉縣', '610900');
INSERT INTO `china` VALUES ('610923', '寧陝縣', '610900');
INSERT INTO `china` VALUES ('610924', '紫陽縣', '610900');
INSERT INTO `china` VALUES ('610925', '岚皋縣', '610900');
INSERT INTO `china` VALUES ('610926', '平利縣', '610900');
INSERT INTO `china` VALUES ('610927', '鎮坪縣', '610900');
INSERT INTO `china` VALUES ('610928', '旬陽縣', '610900');
INSERT INTO `china` VALUES ('610929', '白河縣', '610900');
INSERT INTO `china` VALUES ('611000', '商洛市', '610000');
INSERT INTO `china` VALUES ('611001', '市轄區', '611000');
INSERT INTO `china` VALUES ('611002', '商州區', '611001');
INSERT INTO `china` VALUES ('611021', '洛南縣', '611000');
INSERT INTO `china` VALUES ('611022', '丹鳳縣', '611000');
INSERT INTO `china` VALUES ('611023', '商南縣', '611000');
INSERT INTO `china` VALUES ('611024', '山陽縣', '611000');
INSERT INTO `china` VALUES ('611025', '鎮安縣', '611000');
INSERT INTO `china` VALUES ('611026', '柞水縣', '611000');
INSERT INTO `china` VALUES ('611100', '楊凌示范區', '610000');
INSERT INTO `china` VALUES ('611103', '楊凌區', '611100');
INSERT INTO `china` VALUES ('620000', '甘肅省', '0');
INSERT INTO `china` VALUES ('620100', '蘭州市', '620000');
INSERT INTO `china` VALUES ('620101', '市轄區', '620100');
INSERT INTO `china` VALUES ('620102', '城關區', '620101');
INSERT INTO `china` VALUES ('620103', '七裡河區', '620101');
INSERT INTO `china` VALUES ('620104', '西固區', '620101');
INSERT INTO `china` VALUES ('620105', '安寧區', '620101');
INSERT INTO `china` VALUES ('620111', '紅古區', '620101');
INSERT INTO `china` VALUES ('620121', '永登縣', '620100');
INSERT INTO `china` VALUES ('620122', '皋蘭縣', '620100');
INSERT INTO `china` VALUES ('620123', '榆中縣', '620100');
INSERT INTO `china` VALUES ('620200', '嘉峪關市', '620000');
INSERT INTO `china` VALUES ('620201', '市轄區', '620200');
INSERT INTO `china` VALUES ('620300', '金昌市', '620000');
INSERT INTO `china` VALUES ('620301', '金川區', '620300');
INSERT INTO `china` VALUES ('620321', '永昌縣', '620300');
INSERT INTO `china` VALUES ('620400', '白銀市', '620000');
INSERT INTO `china` VALUES ('620401', '市轄區', '620400');
INSERT INTO `china` VALUES ('620402', '白銀區', '620401');
INSERT INTO `china` VALUES ('620403', '平川區', '620401');
INSERT INTO `china` VALUES ('620421', '靖遠縣', '620400');
INSERT INTO `china` VALUES ('620422', '會寧縣', '620400');
INSERT INTO `china` VALUES ('620423', '景泰縣', '620400');
INSERT INTO `china` VALUES ('620500', '天水市', '620000');
INSERT INTO `china` VALUES ('620501', '麥積區', '620500');
INSERT INTO `china` VALUES ('620502', '秦州區', '620500');
INSERT INTO `china` VALUES ('620521', '清水縣', '620500');
INSERT INTO `china` VALUES ('620522', '秦安縣', '620500');
INSERT INTO `china` VALUES ('620523', '甘谷縣', '620500');
INSERT INTO `china` VALUES ('620524', '武山縣', '620500');
INSERT INTO `china` VALUES ('620525', '張家川回族自治縣', '620500');
INSERT INTO `china` VALUES ('620600', '武威市', '620000');
INSERT INTO `china` VALUES ('620601', '市轄區', '620600');
INSERT INTO `china` VALUES ('620602', '涼州區', '620601');
INSERT INTO `china` VALUES ('620621', '民勤縣', '620600');
INSERT INTO `china` VALUES ('620622', '古浪縣', '620600');
INSERT INTO `china` VALUES ('620623', '天祝藏族自治縣', '620600');
INSERT INTO `china` VALUES ('620700', '張掖市', '620000');
INSERT INTO `china` VALUES ('620701', '市轄區', '620700');
INSERT INTO `china` VALUES ('620702', '甘州區', '620701');
INSERT INTO `china` VALUES ('620721', '肅南裕固族自治縣', '620700');
INSERT INTO `china` VALUES ('620722', '民樂縣', '620700');
INSERT INTO `china` VALUES ('620723', '臨澤縣', '620700');
INSERT INTO `china` VALUES ('620724', '高台縣', '620700');
INSERT INTO `china` VALUES ('620725', '山丹縣', '620700');
INSERT INTO `china` VALUES ('620800', '平涼市', '620000');
INSERT INTO `china` VALUES ('620801', '市轄區', '620800');
INSERT INTO `china` VALUES ('620802', '崆峒區', '620801');
INSERT INTO `china` VALUES ('620821', '泾川縣', '620800');
INSERT INTO `china` VALUES ('620822', '靈台縣', '620800');
INSERT INTO `china` VALUES ('620823', '崇信縣', '620800');
INSERT INTO `china` VALUES ('620824', '華亭縣', '620800');
INSERT INTO `china` VALUES ('620825', '莊浪縣', '620800');
INSERT INTO `china` VALUES ('620826', '靜寧縣', '620800');
INSERT INTO `china` VALUES ('620900', '酒泉市', '620000');
INSERT INTO `china` VALUES ('620901', '市轄區', '620900');
INSERT INTO `china` VALUES ('620902', '肅州區', '620901');
INSERT INTO `china` VALUES ('620921', '金塔縣', '620900');
INSERT INTO `china` VALUES ('620922', '瓜洲縣', '620900');
INSERT INTO `china` VALUES ('620923', '肅北蒙古族自治縣', '620900');
INSERT INTO `china` VALUES ('620924', '阿克塞哈薩克族自治縣', '620900');
INSERT INTO `china` VALUES ('620981', '玉門市', '620900');
INSERT INTO `china` VALUES ('620982', '敦煌市', '620900');
INSERT INTO `china` VALUES ('621000', '慶陽市', '620000');
INSERT INTO `china` VALUES ('621001', '市轄區', '621000');
INSERT INTO `china` VALUES ('621002', '西峰區', '621001');
INSERT INTO `china` VALUES ('621021', '慶城縣', '621000');
INSERT INTO `china` VALUES ('621022', '環縣', '621000');
INSERT INTO `china` VALUES ('621023', '華池縣', '621000');
INSERT INTO `china` VALUES ('621024', '合水縣', '621000');
INSERT INTO `china` VALUES ('621025', '正寧縣', '621000');
INSERT INTO `china` VALUES ('621026', '寧縣', '621000');
INSERT INTO `china` VALUES ('621027', '鎮原縣', '621000');
INSERT INTO `china` VALUES ('621100', '定西市', '620000');
INSERT INTO `china` VALUES ('621101', '市轄區', '621100');
INSERT INTO `china` VALUES ('621102', '安定區', '621101');
INSERT INTO `china` VALUES ('621121', '通渭縣', '621100');
INSERT INTO `china` VALUES ('621122', '隴西縣', '621100');
INSERT INTO `china` VALUES ('621123', '渭源縣', '621100');
INSERT INTO `china` VALUES ('621124', '臨洮縣', '621100');
INSERT INTO `china` VALUES ('621125', '漳縣', '621100');
INSERT INTO `china` VALUES ('621126', '岷縣', '621100');
INSERT INTO `china` VALUES ('621200', '隴南市', '620000');
INSERT INTO `china` VALUES ('621201', '武都區', '621200');
INSERT INTO `china` VALUES ('621221', '成縣', '621200');
INSERT INTO `china` VALUES ('621222', '文縣', '621200');
INSERT INTO `china` VALUES ('621223', '宕昌縣', '621200');
INSERT INTO `china` VALUES ('621224', '康縣', '621200');
INSERT INTO `china` VALUES ('621225', '西和縣', '621200');
INSERT INTO `china` VALUES ('621226', '禮縣', '621200');
INSERT INTO `china` VALUES ('621227', '徽縣', '621200');
INSERT INTO `china` VALUES ('621228', '兩當縣', '621200');
INSERT INTO `china` VALUES ('622900', '臨夏回族自治州', '620000');
INSERT INTO `china` VALUES ('622901', '臨夏市', '622900');
INSERT INTO `china` VALUES ('622921', '臨夏縣', '622900');
INSERT INTO `china` VALUES ('622922', '康樂縣', '622900');
INSERT INTO `china` VALUES ('622923', '永靖縣', '622900');
INSERT INTO `china` VALUES ('622924', '廣河縣', '622900');
INSERT INTO `china` VALUES ('622925', '和政縣', '622900');
INSERT INTO `china` VALUES ('622926', '東鄉族自治縣', '622900');
INSERT INTO `china` VALUES ('622927', '積石山保安族東鄉族撒拉族自治縣', '622900');
INSERT INTO `china` VALUES ('623000', '甘南藏族自治州', '620000');
INSERT INTO `china` VALUES ('623001', '合作市', '623000');
INSERT INTO `china` VALUES ('623021', '臨潭縣', '623000');
INSERT INTO `china` VALUES ('623022', '卓尼縣', '623000');
INSERT INTO `china` VALUES ('623023', '舟曲縣', '623000');
INSERT INTO `china` VALUES ('623024', '迭部縣', '623000');
INSERT INTO `china` VALUES ('623025', '瑪曲縣', '623000');
INSERT INTO `china` VALUES ('623026', '碌曲縣', '623000');
INSERT INTO `china` VALUES ('623027', '夏河縣', '623000');
INSERT INTO `china` VALUES ('630000', '青海省', '0');
INSERT INTO `china` VALUES ('630100', '西寧市', '630000');
INSERT INTO `china` VALUES ('630101', '市轄區', '630100');
INSERT INTO `china` VALUES ('630102', '城東區', '630101');
INSERT INTO `china` VALUES ('630103', '城中區', '630101');
INSERT INTO `china` VALUES ('630104', '城西區', '630101');
INSERT INTO `china` VALUES ('630105', '城北區', '630101');
INSERT INTO `china` VALUES ('630121', '大通回族土族自治縣', '630100');
INSERT INTO `china` VALUES ('630122', '湟中縣', '630100');
INSERT INTO `china` VALUES ('630123', '湟源縣', '630100');
INSERT INTO `china` VALUES ('632100', '海東市', '630000');
INSERT INTO `china` VALUES ('632121', '平安縣', '632100');
INSERT INTO `china` VALUES ('632122', '民和回族土族自治縣', '632100');
INSERT INTO `china` VALUES ('632123', '樂都區', '632100');
INSERT INTO `china` VALUES ('632126', '互助土族自治縣', '632100');
INSERT INTO `china` VALUES ('632127', '化隆回族自治縣', '632100');
INSERT INTO `china` VALUES ('632128', '循化撒拉族自治縣', '632100');
INSERT INTO `china` VALUES ('632200', '海北藏族自治州', '630000');
INSERT INTO `china` VALUES ('632221', '門源回族自治縣', '632200');
INSERT INTO `china` VALUES ('632222', '祁連縣', '632200');
INSERT INTO `china` VALUES ('632223', '海晏縣', '632200');
INSERT INTO `china` VALUES ('632224', '剛察縣', '632200');
INSERT INTO `china` VALUES ('632300', '黃南藏族自治州', '630000');
INSERT INTO `china` VALUES ('632321', '同仁縣', '632300');
INSERT INTO `china` VALUES ('632322', '尖扎縣', '632300');
INSERT INTO `china` VALUES ('632323', '澤庫縣', '632300');
INSERT INTO `china` VALUES ('632324', '河南蒙古族自治縣', '632300');
INSERT INTO `china` VALUES ('632500', '海南藏族自治州', '630000');
INSERT INTO `china` VALUES ('632521', '共和縣', '632500');
INSERT INTO `china` VALUES ('632522', '同德縣', '632500');
INSERT INTO `china` VALUES ('632523', '貴德縣', '632500');
INSERT INTO `china` VALUES ('632524', '興海縣', '632500');
INSERT INTO `china` VALUES ('632525', '貴南縣', '632500');
INSERT INTO `china` VALUES ('632600', '果洛藏族自治州', '630000');
INSERT INTO `china` VALUES ('632621', '瑪沁縣', '632600');
INSERT INTO `china` VALUES ('632622', '班瑪縣', '632600');
INSERT INTO `china` VALUES ('632623', '甘德縣', '632600');
INSERT INTO `china` VALUES ('632624', '達日縣', '632600');
INSERT INTO `china` VALUES ('632625', '久治縣', '632600');
INSERT INTO `china` VALUES ('632626', '瑪多縣', '632600');
INSERT INTO `china` VALUES ('632700', '玉樹藏族自治州', '630000');
INSERT INTO `china` VALUES ('632721', '玉樹縣', '632700');
INSERT INTO `china` VALUES ('632722', '雜多縣', '632700');
INSERT INTO `china` VALUES ('632723', '稱多縣', '632700');
INSERT INTO `china` VALUES ('632724', '治多縣', '632700');
INSERT INTO `china` VALUES ('632725', '囊謙縣', '632700');
INSERT INTO `china` VALUES ('632726', '曲麻萊縣', '632700');
INSERT INTO `china` VALUES ('632800', '海西蒙古族藏族自治州', '630000');
INSERT INTO `china` VALUES ('632801', '格爾木市', '632800');
INSERT INTO `china` VALUES ('632802', '德令哈市', '632800');
INSERT INTO `china` VALUES ('632821', '烏蘭縣', '632800');
INSERT INTO `china` VALUES ('632822', '都蘭縣', '632800');
INSERT INTO `china` VALUES ('632823', '天峻縣', '632800');
INSERT INTO `china` VALUES ('640000', '寧夏回族自治區', '0');
INSERT INTO `china` VALUES ('640100', '銀川市', '640000');
INSERT INTO `china` VALUES ('640104', '興慶區', '640100');
INSERT INTO `china` VALUES ('640105', '西夏區', '640100');
INSERT INTO `china` VALUES ('640106', '金鳳區', '640100');
INSERT INTO `china` VALUES ('640121', '永寧縣', '640100');
INSERT INTO `china` VALUES ('640122', '賀蘭縣', '640100');
INSERT INTO `china` VALUES ('640181', '靈武市', '640100');
INSERT INTO `china` VALUES ('640200', '石嘴山市', '640000');
INSERT INTO `china` VALUES ('640202', '大武口區', '640200');
INSERT INTO `china` VALUES ('640205', '惠農縣', '640200');
INSERT INTO `china` VALUES ('640221', '平羅縣', '640200');
INSERT INTO `china` VALUES ('640300', '吳忠市', '640000');
INSERT INTO `china` VALUES ('640301', '紅寺堡區', '640300');
INSERT INTO `china` VALUES ('640302', '利通區', '640300');
INSERT INTO `china` VALUES ('640323', '鹽池縣', '640300');
INSERT INTO `china` VALUES ('640324', '同心縣', '640300');
INSERT INTO `china` VALUES ('640381', '青銅峽市', '640300');
INSERT INTO `china` VALUES ('640400', '固原市', '640000');
INSERT INTO `china` VALUES ('640401', '市轄區', '640400');
INSERT INTO `china` VALUES ('640402', '原州區', '640400');
INSERT INTO `china` VALUES ('640422', '西吉縣', '640400');
INSERT INTO `china` VALUES ('640423', '隆德縣', '640400');
INSERT INTO `china` VALUES ('640424', '泾源縣', '640400');
INSERT INTO `china` VALUES ('640425', '彭陽縣', '640400');
INSERT INTO `china` VALUES ('640500', '中衛市', '640000');
INSERT INTO `china` VALUES ('640501', '市轄區', '640500');
INSERT INTO `china` VALUES ('640502', '沙坡頭區', '640500');
INSERT INTO `china` VALUES ('640521', '中寧縣', '640500');
INSERT INTO `china` VALUES ('640522', '海原縣', '640500');
INSERT INTO `china` VALUES ('650000', '新疆維吾爾自治區', '0');
INSERT INTO `china` VALUES ('650100', '烏魯木齊市', '650000');
INSERT INTO `china` VALUES ('650101', '市轄區', '650100');
INSERT INTO `china` VALUES ('650102', '天山區', '650101');
INSERT INTO `china` VALUES ('650103', '沙依巴克區', '650101');
INSERT INTO `china` VALUES ('650104', '新市區', '650101');
INSERT INTO `china` VALUES ('650105', '水磨溝區', '650101');
INSERT INTO `china` VALUES ('650106', '頭屯河區', '650101');
INSERT INTO `china` VALUES ('650107', '達坂城區', '650101');
INSERT INTO `china` VALUES ('650108', '東山區', '650101');
INSERT INTO `china` VALUES ('650121', '烏魯木齊縣', '650100');
INSERT INTO `china` VALUES ('650200', '克拉瑪依市', '650000');
INSERT INTO `china` VALUES ('650201', '市轄區', '650200');
INSERT INTO `china` VALUES ('650202', '獨山子區', '650201');
INSERT INTO `china` VALUES ('650203', '克拉瑪依區', '650201');
INSERT INTO `china` VALUES ('650204', '白鹼灘區', '650201');
INSERT INTO `china` VALUES ('650205', '烏爾禾區', '650201');
INSERT INTO `china` VALUES ('652100', '吐魯番地區', '650000');
INSERT INTO `china` VALUES ('652101', '吐魯番市', '652100');
INSERT INTO `china` VALUES ('652122', '鄯善縣', '652100');
INSERT INTO `china` VALUES ('652123', '托克遜縣', '652100');
INSERT INTO `china` VALUES ('652200', '哈密地區', '650000');
INSERT INTO `china` VALUES ('652201', '哈密市', '652200');
INSERT INTO `china` VALUES ('652222', '巴裡坤哈薩克自治縣', '652200');
INSERT INTO `china` VALUES ('652223', '伊吾縣', '652200');
INSERT INTO `china` VALUES ('652300', '昌吉回族自治州', '650000');
INSERT INTO `china` VALUES ('652301', '昌吉市', '652300');
INSERT INTO `china` VALUES ('652302', '阜康市', '652300');
INSERT INTO `china` VALUES ('652303', '米泉市', '652300');
INSERT INTO `china` VALUES ('652323', '呼圖壁縣', '652300');
INSERT INTO `china` VALUES ('652324', '瑪納斯縣', '652300');
INSERT INTO `china` VALUES ('652325', '奇台縣', '652300');
INSERT INTO `china` VALUES ('652327', '吉木薩爾縣', '652300');
INSERT INTO `china` VALUES ('652328', '木壘哈薩克自治縣', '652300');
INSERT INTO `china` VALUES ('652700', '博爾塔拉蒙古自治州', '650000');
INSERT INTO `china` VALUES ('652701', '博樂市', '652700');
INSERT INTO `china` VALUES ('652722', '精河縣', '652700');
INSERT INTO `china` VALUES ('652723', '溫泉縣', '652700');
INSERT INTO `china` VALUES ('652800', '巴音郭楞蒙古自治州', '650000');
INSERT INTO `china` VALUES ('652801', '庫爾勒市', '652800');
INSERT INTO `china` VALUES ('652822', '輪台縣', '652800');
INSERT INTO `china` VALUES ('652823', '尉犁縣', '652800');
INSERT INTO `china` VALUES ('652824', '若羌縣', '652800');
INSERT INTO `china` VALUES ('652825', '且末縣', '652800');
INSERT INTO `china` VALUES ('652826', '焉耆回族自治縣', '652800');
INSERT INTO `china` VALUES ('652827', '和靜縣', '652800');
INSERT INTO `china` VALUES ('652828', '和碩縣', '652800');
INSERT INTO `china` VALUES ('652829', '博湖縣', '652800');
INSERT INTO `china` VALUES ('652900', '阿克蘇地區', '650000');
INSERT INTO `china` VALUES ('652901', '阿克蘇市', '652900');
INSERT INTO `china` VALUES ('652922', '溫宿縣', '652900');
INSERT INTO `china` VALUES ('652923', '庫車縣', '652900');
INSERT INTO `china` VALUES ('652924', '沙雅縣', '652900');
INSERT INTO `china` VALUES ('652925', '新和縣', '652900');
INSERT INTO `china` VALUES ('652926', '拜城縣', '652900');
INSERT INTO `china` VALUES ('652927', '烏什縣', '652900');
INSERT INTO `china` VALUES ('652928', '阿瓦提縣', '652900');
INSERT INTO `china` VALUES ('652929', '柯坪縣', '652900');
INSERT INTO `china` VALUES ('653000', '克孜勒蘇柯爾克孜自治州', '650000');
INSERT INTO `china` VALUES ('653001', '阿圖什市', '653000');
INSERT INTO `china` VALUES ('653022', '阿克陶縣', '653000');
INSERT INTO `china` VALUES ('653023', '阿合奇縣', '653000');
INSERT INTO `china` VALUES ('653024', '烏恰縣', '653000');
INSERT INTO `china` VALUES ('653100', '喀什地區', '650000');
INSERT INTO `china` VALUES ('653101', '喀什市', '653100');
INSERT INTO `china` VALUES ('653121', '疏附縣', '653100');
INSERT INTO `china` VALUES ('653122', '疏勒縣', '653100');
INSERT INTO `china` VALUES ('653123', '英吉沙縣', '653100');
INSERT INTO `china` VALUES ('653124', '澤普縣', '653100');
INSERT INTO `china` VALUES ('653125', '莎車縣', '653100');
INSERT INTO `china` VALUES ('653126', '葉城縣', '653100');
INSERT INTO `china` VALUES ('653127', '麥蓋提縣', '653100');
INSERT INTO `china` VALUES ('653128', '岳普湖縣', '653100');
INSERT INTO `china` VALUES ('653129', '伽師縣', '653100');
INSERT INTO `china` VALUES ('653130', '巴楚縣', '653100');
INSERT INTO `china` VALUES ('653131', '塔什庫爾干塔吉克自治縣', '653100');
INSERT INTO `china` VALUES ('653200', '和田地區', '650000');
INSERT INTO `china` VALUES ('653201', '和田市', '653200');
INSERT INTO `china` VALUES ('653221', '和田縣', '653200');
INSERT INTO `china` VALUES ('653222', '墨玉縣', '653200');
INSERT INTO `china` VALUES ('653223', '皮山縣', '653200');
INSERT INTO `china` VALUES ('653224', '洛浦縣', '653200');
INSERT INTO `china` VALUES ('653225', '策勒縣', '653200');
INSERT INTO `china` VALUES ('653226', '於田縣', '653200');
INSERT INTO `china` VALUES ('653227', '民豐縣', '653200');
INSERT INTO `china` VALUES ('654000', '伊犁哈薩克自治州', '650000');
INSERT INTO `china` VALUES ('654002', '伊寧市', '654000');
INSERT INTO `china` VALUES ('654003', '奎屯市', '654000');
INSERT INTO `china` VALUES ('654021', '伊寧縣', '654000');
INSERT INTO `china` VALUES ('654022', '察布查爾錫伯自治縣', '654000');
INSERT INTO `china` VALUES ('654023', '霍城縣', '654000');
INSERT INTO `china` VALUES ('654024', '鞏留縣', '654000');
INSERT INTO `china` VALUES ('654025', '新源縣', '654000');
INSERT INTO `china` VALUES ('654026', '昭蘇縣', '654000');
INSERT INTO `china` VALUES ('654027', '特克斯縣', '654000');
INSERT INTO `china` VALUES ('654028', '尼勒克縣', '654000');
INSERT INTO `china` VALUES ('654200', '塔城地區', '650000');
INSERT INTO `china` VALUES ('654201', '塔城市', '654200');
INSERT INTO `china` VALUES ('654202', '烏蘇市', '654200');
INSERT INTO `china` VALUES ('654221', '額敏縣', '654200');
INSERT INTO `china` VALUES ('654223', '沙灣縣', '654200');
INSERT INTO `china` VALUES ('654224', '托裡縣', '654200');
INSERT INTO `china` VALUES ('654225', '裕民縣', '654200');
INSERT INTO `china` VALUES ('654226', '和布克賽爾蒙古自治縣', '654200');
INSERT INTO `china` VALUES ('654300', '阿勒泰地區', '650000');
INSERT INTO `china` VALUES ('654301', '阿勒泰市', '654300');
INSERT INTO `china` VALUES ('654321', '布爾津縣', '654300');
INSERT INTO `china` VALUES ('654322', '富蘊縣', '654300');
INSERT INTO `china` VALUES ('654323', '福海縣', '654300');
INSERT INTO `china` VALUES ('654324', '哈巴河縣', '654300');
INSERT INTO `china` VALUES ('654325', '青河縣', '654300');
INSERT INTO `china` VALUES ('654326', '吉木乃縣', '654300');
INSERT INTO `china` VALUES ('659000', '省直轄行政單位', '650000');
INSERT INTO `china` VALUES ('659001', '石河子市', '659000');
INSERT INTO `china` VALUES ('659002', '阿拉爾市', '659000');
INSERT INTO `china` VALUES ('659003', '圖木舒克市', '659000');
INSERT INTO `china` VALUES ('659004', '五家渠市', '659000');
INSERT INTO `china` VALUES ('990000', '新疆建設兵團', '0');
INSERT INTO `china` VALUES ('990100', '第一師', '990000');
INSERT INTO `china` VALUES ('990200', '第二師', '990000');
INSERT INTO `china` VALUES ('990300', '第三師', '990000');
INSERT INTO `china` VALUES ('990400', '第四師', '990000');
INSERT INTO `china` VALUES ('990500', '第五師', '990000');
INSERT INTO `china` VALUES ('990600', '第六師', '990000');
INSERT INTO `china` VALUES ('990700', '第七師', '990000');
INSERT INTO `china` VALUES ('990800', '第八師', '990000');
INSERT INTO `china` VALUES ('990900', '第九師', '990000');
INSERT INTO `china` VALUES ('991000', '第十師', '990000');
INSERT INTO `china` VALUES ('991100', '建工師', '990000');
INSERT INTO `china` VALUES ('991200', '第十二師', '990000');
INSERT INTO `china` VALUES ('991300', '第十三師', '990000');
INSERT INTO `china` VALUES ('991400', '第十四師', '990000');