中国省市县数据库(201905统计局）+ 自关联查询

中国省市县数据sql（2019年5月）摘自国家统计局，包括23个省（含台湾)，4个直辖市，5个自治区，2个特别行政区

数据概括

行政区划： 23个省，5个自治区，4个直辖市，2个特别行政区
***23个省：***河北省、山西省、吉林省、辽宁省、黑龙江省、陕西省、甘肃省、青海省、山东省、福建省、浙江省、台湾省、河南省、湖北省、湖南省、江西省、江苏省、安徽省、广东省、海南省、四川省、贵州省、云南省。
***4个直辖市：***北京市、上海市、天津市、重庆市。
***5个自治区：***内蒙古自治区、新疆维吾尔自治区、宁夏回族自治区、广西壮族自治区、西藏自治区。
***2个特别行政区：***香港特别行政区、澳门特别行政区。

SQL代码

DROP TABLE IF EXISTS China;

CREATE TABLE China(id int  PRIMARY KEY, 
name varchar(50) NOT NULL,
parent_id int  DEFAULT 0);

LOCK TABLES `China` WRITE;
/*!40000 ALTER TABLE `China` DISABLE KEYS */;

INSERT INTO `China` (`id`, `name`, `parent_id`)
VALUES
(0,'中国',0),
(110000,'北京',0),
(110101,'东城',110100),
(110102,'西城',110100),
(110103,'崇文',110100),
(110104,'宣武',110100),
(110105,'朝阳',110100),
(110106,'丰台',110100),
(110107,'石景山',110100),
(110108,'海淀',110100),
(110109,'门头沟',110100),
(110111,'房山',110100),
(110112,'通州',110100),
(110113,'顺义',110100),
(110114,'昌平',110100),
(110115,'大兴',110100),
(110116,'怀柔',110100),
(110117,'平谷',110100),
(110228,'密云',110100),
(110229,'延庆',110100),
(110230,'其它',110100),
(120000,'天津',0),
(120100,'天津市',120000),
(120101,'和平',120100),
(120102,'河东',120100),
(120103,'河西',120100),
(120104,'南开',120100),
(120105,'河北',120100),
(120106,'红桥',120100),
(120107,'塘沽',120100),
(120108,'汉沽',120100),
(120109,'大港',120100),
(120110,'东丽',120100),
(120111,'西青',120100),
(120112,'津南',120100),
(120113,'北辰',120100),
(120114,'武清',120100),
(120115,'宝坻',120100),
(120221,'宁河',120100),
(120223,'静海',120100),
(120225,'蓟县',120100),
(120226,'其它',120100),
(130000,'河北',0),
(130100,'石家庄',130000),
(130102,'长安区',130100),
(130103,'桥东区',130100),
(130104,'桥西区',130100),
(130105,'新华区',130100),
(130107,'井陉矿区',130100),
(130108,'裕华区',130100),
(130121,'井陉县',130100),
(130123,'正定县',130100),
(130124,'栾城县',130100),
(130125,'行唐县',130100),
(130126,'灵寿县',130100),
(130127,'高邑县',130100),
(130128,'深泽县',130100),
(130129,'赞皇县',130100),
(130130,'无极县',130100),
(130131,'平山县',130100),
(130132,'元氏县',130100),
(130133,'赵县',130100),
(130181,'辛集市',130100),
(130182,'藁城市',130100),
(130183,'晋州市',130100),
(130184,'新乐市',130100),
(130185,'鹿泉市',130100),
(130186,'其它区',130100),
(130200,'唐山',130000),
(130202,'路南区',130200),
(130203,'路北区',130200),
(130204,'古冶区',130200),
(130205,'开平区',130200),
(130207,'丰南区',130200),
(130208,'丰润区',130200),
(130223,'滦县',130200),
(130224,'滦南县',130200),
(130225,'乐亭县',130200),
(130227,'迁西县',130200),
(130229,'玉田县',130200),
(130230,'唐海县',130200),
(130281,'遵化市',130200),
(130283,'迁安市',130200),
(130284,'其它区',130200),
(130300,'秦皇岛',130000),
(130302,'海港区',130300),
(130303,'山海关区',130300),
(130304,'北戴河区',130300),
(130321,'青龙满族自治县',130300),
(130322,'昌黎县',130300),
(130323,'抚宁县',130300),
(130324,'卢龙县',130300),
(130398,'其它区',130300),
(130399,'经济技术开发区',130300),
(130400,'邯郸',130000),
(130402,'邯山区',130400),
(130403,'丛台区',130400),
(130404,'复兴区',130400),
(130406,'峰峰矿区',130400),
(130421,'邯郸县',130400),
(130423,'临漳县',130400),
(130424,'成安县',130400),
(130425,'大名县',130400),
(130426,'涉县',130400),
(130427,'磁县',130400),
(130428,'肥乡县',130400),
(130429,'永年县',130400),
(130430,'邱县',130400),
(130431,'鸡泽县',130400),
(130432,'广平县',130400),
(130433,'馆陶县',130400),
(130434,'魏县',130400),
(130435,'曲周县',130400),
(130481,'武安市',130400),
(130482,'其它区',130400),
(130500,'邢台',130000),
(130502,'桥东区',130500),
(130503,'桥西区',130500),
(130521,'邢台县',130500),
(130522,'临城县',130500),
(130523,'内丘县',130500),
(130524,'柏乡县',130500),
(130525,'隆尧县',130500),
(130526,'任县',130500),
(130527,'南和县',130500),
(130528,'宁晋县',130500),
(130529,'巨鹿县',130500),
(130530,'新河县',130500),
(130531,'广宗县',130500),
(130532,'平乡县',130500),
(130533,'威县',130500),
(130534,'清河县',130500),
(130535,'临西县',130500),
(130581,'南宫市',130500),
(130582,'沙河市',130500),
(130583,'其它区',130500),
(130600,'保定',130000),
(130602,'新市区',130600),
(130603,'北市区',130600),
(130604,'南市区',130600),
(130621,'满城县',130600),
(130622,'清苑县',130600),
(130623,'涞水县',130600),
(130624,'阜平县',130600),
(130625,'徐水县',130600),
(130626,'定兴县',130600),
(130627,'唐县',130600),
(130628,'高阳县',130600),
(130629,'容城县',130600),
(130630,'涞源县',130600),
(130631,'望都县',130600),
(130632,'安新县',130600),
(130633,'易县',130600),
(130634,'曲阳县',130600),
(130635,'蠡县',130600),
(130636,'顺平县',130600),
(130637,'博野县',130600),
(130638,'雄县',130600),
(130681,'涿州市',130600),
(130682,'定州市',130600),
(130683,'安国市',130600),
(130684,'高碑店市',130600),
(130698,'高开区',130600),
(130699,'其它区',130600),
(130700,'张家口',130000),
(130702,'桥东区',130700),
(130703,'桥西区',130700),
(130705,'宣化区',130700),
(130706,'下花园区',130700),
(130721,'宣化县',130700),
(130722,'张北县',130700),
(130723,'康保县',130700),
(130724,'沽源县',130700),
(130725,'尚义县',130700),
(130726,'蔚县',130700),
(130727,'阳原县',130700),
(130728,'怀安县',130700),
(130729,'万全县',130700),
(130730,'怀来县',130700),
(130731,'涿鹿县',130700),
(130732,'赤城县',130700),
(130733,'崇礼县',130700),
(130734,'其它区',130700),
(130800,'承德',130000),
(130802,'双桥区',130800),
(130803,'双滦区',130800),
(130804,'鹰手营子矿区',130800),
(130821,'承德县',130800),
(130822,'兴隆县',130800),
(130823,'平泉县',130800),
(130824,'滦平县',130800),
(130825,'隆化县',130800),
(130826,'丰宁满族自治县',130800),
(130827,'宽城满族自治县',130800),
(130828,'围场满族蒙古族自治县',130800),
(130829,'其它区',130800),
(130900,'沧州',130000),
(130902,'新华区',130900),
(130903,'运河区',130900),
(130921,'沧县',130900),
(130922,'青县',130900),
(130923,'东光县',130900),
(130924,'海兴县',130900),
(130925,'盐山县',130900),
(130926,'肃宁县',130900),
(130927,'南皮县',130900),
(130928,'吴桥县',130900),
(130929,'献县',130900),
(130930,'孟村回族自治县',130900),
(130981,'泊头市',130900),
(130982,'任丘市',130900),
(130983,'黄骅市',130900),
(130984,'河间市',130900),
(130985,'其它区',130900),
(131000,'廊坊',130000),
(131002,'安次区',131000),
(131003,'广阳区',131000),
(131022,'固安县',131000),
(131023,'永清县',131000),
(131024,'香河县',131000),
(131025,'大城县',131000),
(131026,'文安县',131000),
(131028,'大厂回族自治县',131000),
(131051,'开发区',131000),
(131052,'燕郊经济技术开发区',131000),
(131081,'霸州市',131000),
(131082,'三河市',131000),
(131083,'其它区',131000),
(131100,'衡水',130000),
(131102,'桃城区',131100),
(131121,'枣强县',131100),
(131122,'武邑县',131100),
(131123,'武强县',131100),
(131124,'饶阳县',131100),
(131125,'安平县',131100),
(131126,'故城县',131100),
(131127,'景县',131100),
(131128,'阜城县',131100),
(131181,'冀州市',131100),
(131182,'深州市',131100),
(131183,'其它区',131100),
(140000,'山西',0),
(140100,'太原',140000),
(140105,'小店区',140100),
(140106,'迎泽区',140100),
(140107,'杏花岭区',140100),
(140108,'尖草坪区',140100),
(140109,'万柏林区',140100),
(140110,'晋源区',140100),
(140121,'清徐县',140100),
(140122,'阳曲县',140100),
(140123,'娄烦县',140100),
(140181,'古交市',140100),
(140182,'其它区',140100),
(140200,'大同',140000),
(140202,'城区',140200),
(140203,'矿区',140200),
(140211,'南郊区',140200),
(140212,'新荣区',140200),
(140221,'阳高县',140200),
(140222,'天镇县',140200),
(140223,'广灵县',140200),
(140224,'灵丘县',140200),
(140225,'浑源县',140200),
(140226,'左云县',140200),
(140227,'大同县',140200),
(140228,'其它区',140200),
(140300,'阳泉',140000),
(140302,'城区',140300),
(140303,'矿区',140300),
(140311,'郊区',140300),
(140321,'平定县',140300),
(140322,'盂县',140300),
(140323,'其它区',140300),
(140400,'长治',140000),
(140421,'长治县',140400),
(140423,'襄垣县',140400),
(140424,'屯留县',140400),
(140425,'平顺县',140400),
(140426,'黎城县',140400),
(140427,'壶关县',140400),
(140428,'长子县',140400),
(140429,'武乡县',140400),
(140430,'沁县',140400),
(140431,'沁源县',140400),
(140481,'潞城市',140400),
(140482,'城区',140400),
(140483,'郊区',140400),
(140484,'高新区',140400),
(140485,'其它区',140400),
(140500,'晋城',140000),
(140502,'城区',140500),
(140521,'沁水县',140500),
(140522,'阳城县',140500),
(140524,'陵川县',140500),
(140525,'泽州县',140500),
(140581,'高平市',140500),
(140582,'其它区',140500),
(140600,'朔州',140000),
(140602,'朔城区',140600),
(140603,'平鲁区',140600),
(140621,'山阴县',140600),
(140622,'应县',140600),
(140623,'右玉县',140600),
(140624,'怀仁县',140600),
(140625,'其它区',140600),
(140700,'晋中',140000),
(140702,'榆次区',140700),
(140721,'榆社县',140700),
(140722,'左权县',140700),
(140723,'和顺县',140700),
(140724,'昔阳县',140700),
(140725,'寿阳县',140700),
(140726,'太谷县',140700),
(140727,'祁县',140700),
(140728,'平遥县',140700),
(140729,'灵石县',140700),
(140781,'介休市',140700),
(140782,'其它区',140700),
(140800,'运城',140000),
(140802,'盐湖区',140800),
(140821,'临猗县',140800),
(140822,'万荣县',140800),
(140823,'闻喜县',140800),
(140824,'稷山县',140800),
(140825,'新绛县',140800),
(140826,'绛县',140800),
(140827,'垣曲县',140800),
(140828,'夏县',140800),
(140829,'平陆县',140800),
(140830,'芮城县',140800),
(140881,'永济市',140800),
(140882,'河津市',140800),
(140883,'其它区',140800),
(140900,'忻州',140000),
(140902,'忻府区',140900),
(140921,'定襄县',140900),
(140922,'五台县',140900),
(140923,'代县',140900),
(140924,'繁峙县',140900),
(140925,'宁武县',140900),
(140926,'静乐县',140900),
(140927,'神池县',140900),
(140928,'五寨县',140900),
(140929,'岢岚县',140900),
(140930,'河曲县',140900),
(140931,'保德县',140900),
(140932,'偏关县',140900),
(140981,'原平市',140900),
(140982,'其它区',140900),
(141000,'临汾',140000),
(141002,'尧都区',141000),
(141021,'曲沃县',141000),
(141022,'翼城县',141000),
(141023,'襄汾县',141000),
(141024,'洪洞县',141000),
(141025,'古县',141000),
(141026,'安泽县',141000),
(141027,'浮山县',141000),
(141028,'吉县',141000),
(141029,'乡宁县',141000),
(141030,'大宁县',141000),
(141031,'隰县',141000),
(141032,'永和县',141000),
(141033,'蒲县',141000),
(141034,'汾西县',141000),
(141081,'侯马市',141000),
(141082,'霍州市',141000),
(141083,'其它区',141000),
(141100,'吕梁',140000),
(141102,'离石区',141100),
(141121,'文水县',141100),
(141122,'交城县',141100),
(141123,'兴县',141100),
(141124,'临县',141100),
(141125,'柳林县',141100),
(141126,'石楼县',141100),
(141127,'岚县',141100),
(141128,'方山县',141100),
(141129,'中阳县',141100),
(141130,'交口县',141100),
(141181,'孝义市',141100),
(141182,'汾阳市',141100),
(141183,'其它区',141100),
(150000,'内蒙',0),
(150100,'呼和浩特',150000),
(150102,'新城区',150100),
(150103,'回民区',150100),
(150104,'玉泉区',150100),
(150105,'赛罕区',150100),
(150121,'土默特左旗',150100),
(150122,'托克托县',150100),
(150123,'和林格尔县',150100),
(150124,'清水河县',150100),
(150125,'武川县',150100),
(150126,'其它区',150100),
(150200,'包头',150000),
(150202,'东河区',150200),
(150203,'昆都仑区',150200),
(150204,'青山区',150200),
(150205,'石拐区',150200),
(150206,'白云矿区',150200),
(150207,'九原区',150200),
(150221,'土默特右旗',150200),
(150222,'固阳县',150200),
(150223,'达尔罕茂明安联合旗',150200),
(150224,'其它区',150200),
(150300,'乌海',150000),
(150302,'海勃湾区',150300),
(150303,'海南区',150300),
(150304,'乌达区',150300),
(150305,'其它区',150300),
(150400,'赤峰',150000),
(150402,'红山区',150400),
(150403,'元宝山区',150400),
(150404,'松山区',150400),
(150421,'阿鲁科尔沁旗',150400),
(150422,'巴林左旗',150400),
(150423,'巴林右旗',150400),
(150424,'林西县',150400),
(150425,'克什克腾旗',150400),
(150426,'翁牛特旗',150400),
(150428,'喀喇沁旗',150400),
(150429,'宁城县',150400),
(150430,'敖汉旗',150400),
(150431,'其它区',150400),
(150500,'通辽',150000),
(150502,'科尔沁区',150500),
(150521,'科尔沁左翼中旗',150500),
(150522,'科尔沁左翼后旗',150500),
(150523,'开鲁县',150500),
(150524,'库伦旗',150500),
(150525,'奈曼旗',150500),
(150526,'扎鲁特旗',150500),
(150581,'霍林郭勒市',150500),
(150582,'其它区',150500),
(150600,'鄂尔多斯',150000),
(150602,'东胜区',150600),
(150621,'达拉特旗',150600),
(150622,'准格尔旗',150600),
(150623,'鄂托克前旗',150600),
(150624,'鄂托克旗',150600),
(150625,'杭锦旗',150600),
(150626,'乌审旗',150600),
(150627,'伊金霍洛旗',150600),
(150628,'其它区',150600),
(150700,'呼伦贝尔',150000),
(150702,'海拉尔区',150700),
(150721,'阿荣旗',150700),
(150722,'莫力达瓦达斡尔族自治旗',150700),
(150723,'鄂伦春自治旗',150700),
(150724,'鄂温克族自治旗',150700),
(150725,'陈巴尔虎旗',150700),
(150726,'新巴尔虎左旗',150700),
(150727,'新巴尔虎右旗',150700),
(150781,'满洲里市',150700),
(150782,'牙克石市',150700),
(150783,'扎兰屯市',150700),
(150784,'额尔古纳市',150700),
(150785,'根河市',150700),
(150786,'其它区',150700),
(150800,'巴彦淖尔',150000),
(150802,'临河区',150800),
(150821,'五原县',150800),
(150822,'磴口县',150800),
(150823,'乌拉特前旗',150800),
(150824,'乌拉特中旗',150800),
(150825,'乌拉特后旗',150800),
(150826,'杭锦后旗',150800),
(150827,'其它区',150800),
(150900,'乌兰察布',150000),
(150902,'集宁区',150900),
(150921,'卓资县',150900),
(150922,'化德县',150900),
(150923,'商都县',150900),
(150924,'兴和县',150900),
(150925,'凉城县',150900),
(150926,'察哈尔右翼前旗',150900),
(150927,'察哈尔右翼中旗',150900),
(150928,'察哈尔右翼后旗',150900),
(150929,'四子王旗',150900),
(150981,'丰镇市',150900),
(150982,'其它区',150900),
(152200,'兴安盟',150000),
(152201,'乌兰浩特市',152200),
(152202,'阿尔山市',152200),
(152221,'科尔沁右翼前旗',152200),
(152222,'科尔沁右翼中旗',152200),
(152223,'扎赉特旗',152200),
(152224,'突泉县',152200),
(152225,'其它区',152200),
(152500,'锡林郭勒盟',150000),
(152501,'二连浩特市',152500),
(152502,'锡林浩特市',152500),
(152522,'阿巴嘎旗',152500),
(152523,'苏尼特左旗',152500),
(152524,'苏尼特右旗',152500),
(152525,'东乌珠穆沁旗',152500),
(152526,'西乌珠穆沁旗',152500),
(152527,'太仆寺旗',152500),
(152528,'镶黄旗',152500),
(152529,'正镶白旗',152500),
(152530,'正蓝旗',152500),
(152531,'多伦县',152500),
(152532,'其它区',152500),
(152900,'阿拉善盟',150000),
(152921,'阿拉善左旗',152900),
(152922,'阿拉善右旗',152900),
(152923,'额济纳旗',152900),
(152924,'其它区',152900),
(210000,'辽宁',0),
(210100,'沈阳',210000),
(210102,'和平区',210100),
(210103,'沈河区',210100),
(210104,'大东区',210100),
(210105,'皇姑区',210100),
(210106,'铁西区',210100),
(210111,'苏家屯区',210100),
(210112,'东陵区',210100),
(210113,'新城子区',210100),
(210114,'于洪区',210100),
(210122,'辽中县',210100),
(210123,'康平县',210100),
(210124,'法库县',210100),
(210181,'新民市',210100),
(210182,'浑南新区',210100),
(210183,'张士开发区',210100),
(210184,'沈北新区',210100),
(210185,'其它区',210100),
(210200,'大连',210000),
(210202,'中山区',210200),
(210203,'西岗区',210200),
(210204,'沙河口区',210200),
(210211,'甘井子区',210200),
(210212,'旅顺口区',210200),
(210213,'金州区',210200),
(210224,'长海县',210200),
(210251,'开发区',210200),
(210281,'瓦房店市',210200),
(210282,'普兰店市',210200),
(210283,'庄河市',210200),
(210297,'岭前区',210200),
(210298,'其它区',210200),
(210300,'鞍山',210000),
(210302,'铁东区',210300),
(210303,'铁西区',210300),
(210304,'立山区',210300),
(210311,'千山区',210300),
(210321,'台安县',210300),
(210323,'岫岩满族自治县',210300),
(210351,'高新区',210300),
(210381,'海城市',210300),
(210382,'其它区',210300),
(210400,'抚顺',210000),
(210402,'新抚区',210400),
(210403,'东洲区',210400),
(210404,'望花区',210400),
(210411,'顺城区',210400),
(210421,'抚顺县',210400),
(210422,'新宾满族自治县',210400),
(210423,'清原满族自治县',210400),
(210424,'其它区',210400),
(210500,'本溪',210000),
(210502,'平山区',210500),
(210503,'溪湖区',210500),
(210504,'明山区',210500),
(210505,'南芬区',210500),
(210521,'本溪满族自治县',210500),
(210522,'桓仁满族自治县',210500),
(210523,'其它区',210500),
(210600,'丹东',210000),
(210602,'元宝区',210600),
(210603,'振兴区',210600),
(210604,'振安区',210600),
(210624,'宽甸满族自治县',210600),
(210681,'东港市',210600),
(210682,'凤城市',210600),
(210683,'其它区',210600),
(210700,'锦州',210000),
(210702,'古塔区',210700),
(210703,'凌河区',210700),
(210711,'太和区',210700),
(210726,'黑山县',210700),
(210727,'义县',210700),
(210781,'凌海市',210700),
(210782,'北镇市',210700),
(210783,'其它区',210700),
(210800,'营口',210000),
(210802,'站前区',210800),
(210803,'西市区',210800),
(210804,'鲅鱼圈区',210800),
(210811,'老边区',210800),
(210881,'盖州市',210800),
(210882,'大石桥市',210800),
(210883,'其它区',210800),
(210900,'阜新',210000),
(210902,'海州区',210900),
(210903,'新邱区',210900),
(210904,'太平区',210900),
(210905,'清河门区',210900),
(210911,'细河区',210900),
(210921,'阜新蒙古族自治县',210900),
(210922,'彰武县',210900),
(210923,'其它区',210900),
(211000,'辽阳',210000),
(211002,'白塔区',211000),
(211003,'文圣区',211000),
(211004,'宏伟区',211000),
(211005,'弓长岭区',211000),
(211011,'太子河区',211000),
(211021,'辽阳县',211000),
(211081,'灯塔市',211000),
(211082,'其它区',211000),
(211100,'盘锦',210000),
(211102,'双台子区',211100),
(211103,'兴隆台区',211100),
(211121,'大洼县',211100),
(211122,'盘山县',211100),
(211123,'其它区',211100),
(211200,'铁岭',210000),
(211202,'银州区',211200),
(211204,'清河区',211200),
(211221,'铁岭县',211200),
(211223,'西丰县',211200),
(211224,'昌图县',211200),
(211281,'调兵山市',211200),
(211282,'开原市',211200),
(211283,'其它区',211200),
(211300,'朝阳',210000),
(211302,'双塔区',211300),
(211303,'龙城区',211300),
(211321,'朝阳县',211300),
(211322,'建平县',211300),
(211324,'喀喇沁左翼蒙古族自治县',211300),
(211381,'北票市',211300),
(211382,'凌源市',211300),
(211383,'其它区',211300),
(211400,'葫芦岛',210000),
(211402,'连山区',211400),
(211403,'龙港区',211400),
(211404,'南票区',211400),
(211421,'绥中县',211400),
(211422,'建昌县',211400),
(211481,'兴城市',211400),
(211482,'其它区',211400),
(220000,'吉林',0),
(220100,'长春',220000),
(220102,'南关区',220100),
(220103,'宽城区',220100),
(220104,'朝阳区',220100),
(220105,'二道区',220100),
(220106,'绿园区',220100),
(220112,'双阳区',220100),
(220122,'农安县',220100),
(220181,'九台市',220100),
(220182,'榆树市',220100),
(220183,'德惠市',220100),
(220184,'高新技术产业开发区',220100),
(220185,'汽车产业开发区',220100),
(220186,'经济技术开发区',220100),
(220187,'净月旅游开发区',220100),
(220188,'其它区',220100),
(220200,'吉林',220000),
(220202,'昌邑区',220200),
(220203,'龙潭区',220200),
(220204,'船营区',220200),
(220211,'丰满区',220200),
(220221,'永吉县',220200),
(220281,'蛟河市',220200),
(220282,'桦甸市',220200),
(220283,'舒兰市',220200),
(220284,'磐石市',220200),
(220285,'其它区',220200),
(220300,'四平',220000),
(220302,'铁西区',220300),
(220303,'铁东区',220300),
(220322,'梨树县',220300),
(220323,'伊通满族自治县',220300),
(220381,'公主岭市',220300),
(220382,'双辽市',220300),
(220383,'其它区',220300),
(220400,'辽源',220000),
(220402,'龙山区',220400),
(220403,'西安区',220400),
(220421,'东丰县',220400),
(220422,'东辽县',220400),
(220423,'其它区',220400),
(220500,'通化',220000),
(220502,'东昌区',220500),
(220503,'二道江区',220500),
(220521,'通化县',220500),
(220523,'辉南县',220500),
(220524,'柳河县',220500),
(220581,'梅河口市',220500),
(220582,'集安市',220500),
(220583,'其它区',220500),
(220600,'白山',220000),
(220602,'八道江区',220600),
(220621,'抚松县',220600),
(220622,'靖宇县',220600),
(220623,'长白朝鲜族自治县',220600),
(220625,'江源县',220600),
(220681,'临江市',220600),
(220682,'其它区',220600),
(220700,'松原',220000),
(220702,'宁江区',220700),
(220721,'前郭尔罗斯蒙古族自治县',220700),
(220722,'长岭县',220700),
(220723,'乾安县',220700),
(220724,'扶余县',220700),
(220725,'其它区',220700),
(220800,'白城',220000),
(220802,'洮北区',220800),
(220821,'镇赉县',220800),
(220822,'通榆县',220800),
(220881,'洮南市',220800),
(220882,'大安市',220800),
(220883,'其它区',220800),
(222400,'延边',220000),
(222401,'延吉市',222400),
(222402,