全部省市縣資料庫(MySQL腳本) (轉)

/*
MySQL - 5.5.47
************
*/
/*!40101 SET NAMES utf8 */;

create table `base_area` (
    `codeid` mediumint (12),
    `parentid` int (12),
    `cityName` varchar (180)
);
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('11','0','北京');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1101','11','北京市轄');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110101','1101','東城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110102','1101','西城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110103','1101','崇文區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110104','1101','宣武區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110105','1101','朝陽區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110106','1101','丰台區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110107','1101','石景山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110108','1101','海澱區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110109','1101','門頭溝區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110111','1101','房山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110112','1101','通州區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110113','1101','順義區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110114','1101','昌平區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1102','11','北京縣轄');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110224','1102','大興縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110226','1102','平谷縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110227','1102','懷柔縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110228','1102','密雲縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('110229','1102','延慶縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('12','0','天津');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1201','12','天津市轄');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120101','1201','和平區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120102','1201','河東區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120103','1201','河西區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120104','1201','南開區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120105','1201','河北區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120106','1201','紅橋區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120107','1201','塘沽區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120108','1201','漢沽區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120109','1201','大港區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120110','1201','東麗區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120111','1201','西青區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120112','1201','津南區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120113','1201','北辰區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120114','1201','武清區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1202','12','天津縣轄');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120221','1202','寧河縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120223','1202','靜海縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120224','1202','寶坻縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('120225','1202','薊  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('13','0','河北');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1301','13','石家莊');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130101','1301','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130102','1301','長安區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130103','1301','橋東區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130104','1301','橋西區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130105','1301','新華區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130106','1301','郊  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130107','1301','井陘礦區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130121','1301','井陘縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130123','1301','正定縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130124','1301','欒城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130125','1301','行唐縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130126','1301','靈壽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130127','1301','高邑縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130128','1301','深澤縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130129','1301','贊皇縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130130','1301','無極縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130131','1301','平山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130132','1301','元氏縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130133','1301','趙  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130181','1301','辛集市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130182','1301','藁城市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130183','1301','晉州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130184','1301','新樂市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130185','1301','鹿泉市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1302','13','唐山');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130201','1302','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130202','1302','路南區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130203','1302','路北區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130204','1302','古冶區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130205','1302','開平區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130206','1302','新  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130221','1302','豐潤縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130223','1302','灤  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130224','1302','灤南縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130225','1302','樂亭縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130227','1302','遷西縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130229','1302','玉田縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130230','1302','唐海縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130281','1302','遵化市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130282','1302','丰南市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130283','1302','遷安市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1303','13','秦皇島');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130301','1303','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130302','1303','海港區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130303','1303','山海關區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130304','1303','北戴河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130321','1303','青龍滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130322','1303','昌黎縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130323','1303','撫寧縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130324','1303','盧龍縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1304','13','邯鄲');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130401','1304','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130402','1304','邯山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130403','1304','叢台區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130404','1304','復興區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130406','1304','峰峰礦區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130421','1304','邯鄲縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130423','1304','臨漳縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130424','1304','成安縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130425','1304','大名縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130426','1304','涉  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130427','1304','磁  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130428','1304','肥鄉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130429','1304','永年縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130430','1304','邱  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130431','1304','雞澤縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130432','1304','廣平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130433','1304','館陶縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130434','1304','魏  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130435','1304','曲周縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130481','1304','武安市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1305','13','邢台');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130501','1305','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130502','1305','橋東區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130503','1305','橋西區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130521','1305','邢台縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130522','1305','臨城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130523','1305','內丘縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130524','1305','柏鄉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130525','1305','隆堯縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130526','1305','任  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130527','1305','南和縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130528','1305','寧晉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130529','1305','巨鹿縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130530','1305','新河縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130531','1305','廣宗縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130532','1305','平鄉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130533','1305','威  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130534','1305','清河縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130535','1305','臨西縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130581','1305','南宮市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130582','1305','沙河市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1306','13','保定');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130601','1306','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130602','1306','新市區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130603','1306','北市區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130604','1306','南市區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130621','1306','滿城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130622','1306','清苑縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130623','1306','淶水縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130624','1306','阜平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130625','1306','徐水縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130626','1306','定興縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130627','1306','唐  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130628','1306','高陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130629','1306','容城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130630','1306','淶源縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130631','1306','望都縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130632','1306','安新縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130633','1306','易  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130634','1306','曲陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130635','1306','蠡  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130636','1306','順平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130637','1306','博野縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130638','1306','雄  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130681','1306','涿州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130682','1306','定州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130683','1306','安國市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130684','1306','高碑店市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1307','13','張家口');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130701','1307','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130702','1307','橋東區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130703','1307','橋西區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130705','1307','宣化區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130706','1307','下花園區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130721','1307','宣化縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130722','1307','張北縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130723','1307','康保縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130724','1307','沽源縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130725','1307','尚義縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130726','1307','蔚  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130727','1307','陽原縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130728','1307','懷安縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130729','1307','萬全縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130730','1307','懷來縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130731','1307','涿鹿縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130732','1307','赤城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130733','1307','崇禮縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1308','13','承德');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130801','1308','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130802','1308','雙橋區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130803','1308','雙灤區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130804','1308','鷹手營子礦區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130821','1308','承德縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130822','1308','興隆縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130823','1308','平泉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130824','1308','灤平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130825','1308','隆化縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130826','1308','豐寧滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130827','1308','寬城滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130828','1308','圍場滿族蒙古族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1309','13','滄州');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130901','1309','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130902','1309','新華區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130903','1309','運河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130921','1309','滄  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130922','1309','青  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130923','1309','東光縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130924','1309','海興縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130925','1309','鹽山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130926','1309','肅寧縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130927','1309','南皮縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130928','1309','吳橋縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130929','1309','獻  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130930','1309','孟村回族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130981','1309','泊頭市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130982','1309','任丘市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130983','1309','黃驊市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('130984','1309','河間市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1310','13','廊坊');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131001','1310','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131002','1310','安次區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131003','1310','廊坊市廣陽區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131022','1310','固安縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131023','1310','永清縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131024','1310','香河縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131025','1310','大城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131026','1310','文安縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131028','1310','大廠回族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131081','1310','霸州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131082','1310','三河市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1311','13','衡水');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131101','1311','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131102','1311','桃城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131121','1311','棗強縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131122','1311','武邑縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131123','1311','武強縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131124','1311','饒陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131125','1311','安平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131126','1311','故城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131127','1311','景  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131128','1311','阜城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131181','1311','冀州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('131182','1311','深州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('14','0','山西');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1401','14','太原');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140101','1401','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140105','1401','小店區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140106','1401','迎澤區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140107','1401','杏花嶺區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140108','1401','尖草坪區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140109','1401','萬柏林區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140110','1401','晉源區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140121','1401','清徐縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140122','1401','陽曲縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140123','1401','婁煩縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140181','1401','古交市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1402','14','大同');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140201','1402','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140202','1402','城  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140203','1402','礦  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140211','1402','南郊區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140212','1402','新榮區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140221','1402','陽高縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140222','1402','天鎮縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140223','1402','廣靈縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140224','1402','靈丘縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140225','1402','渾源縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140226','1402','左雲縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140227','1402','大同縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1403','14','陽泉');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140301','1403','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140302','1403','城  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140303','1403','礦  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140311','1403','郊  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140321','1403','平定縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140322','1403','盂  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1404','14','長治');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140401','1404','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140402','1404','城  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140411','1404','郊  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140421','1404','長治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140423','1404','襄垣縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140424','1404','屯留縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140425','1404','平順縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140426','1404','黎城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140427','1404','壺關縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140428','1404','長子縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140429','1404','武鄉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140430','1404','沁  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140431','1404','沁源縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140481','1404','潞城市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1405','14','晉城');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140501','1405','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140502','1405','城  區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140521','1405','沁水縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140522','1405','陽城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140524','1405','陵川縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140525','1405','澤州縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140581','1405','高平市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1406','14','朔州');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140601','1406','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140602','1406','朔城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140603','1406','平魯區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140621','1406','山陰縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140622','1406','應  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140623','1406','右玉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140624','1406','懷仁縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1407','14','晉中');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140701','1407','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140702','1407','榆次區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140721','1407','榆社縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140722','1407','左權縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140723','1407','和順縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140724','1407','昔陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140725','1407','壽陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140726','1407','太谷縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140727','1407','祁  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140728','1407','平遙縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140729','1407','靈石縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140781','1407','介休市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1408','14','運城');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140801','1408','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140802','1408','鹽湖區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140821','1408','臨猗縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140822','1408','萬榮縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140823','1408','聞喜縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140824','1408','稷山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140825','1408','新絳縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140826','1408','絳  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140827','1408','垣曲縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140828','1408','夏  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140829','1408','平陸縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140830','1408','芮城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140881','1408','永濟市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140882','1408','河津市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1409','14','忻州');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140901','1409','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140902','1409','忻府區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140921','1409','定襄縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140922','1409','五台縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140923','1409','代  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140924','1409','繁峙縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140925','1409','寧武縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140926','1409','靜樂縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140927','1409','神池縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140928','1409','五寨縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140929','1409','岢嵐縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140930','1409','河曲縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140931','1409','保德縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140932','1409','偏關縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('140981','1409','原平市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1410','14','臨汾');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141001','1410','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141002','1410','堯都區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141021','1410','曲沃縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141022','1410','翼城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141023','1410','襄汾縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141024','1410','洪洞縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141025','1410','古  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141026','1410','安澤縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141027','1410','浮山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141028','1410','吉  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141029','1410','鄉寧縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141030','1410','大寧縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141031','1410','隰  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141032','1410','永和縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141033','1410','蒲  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141034','1410','汾西縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141081','1410','侯馬市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('141082','1410','霍州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1423','14','呂梁地區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142301','1423','孝義市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142302','1423','離石市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142303','1423','汾陽市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142322','1423','文水縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142323','1423','交城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142325','1423','興  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142326','1423','臨  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142327','1423','柳林縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142328','1423','石樓縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142329','1423','嵐  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142330','1423','方山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142332','1423','中陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('142333','1423','交口縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('15','0','內蒙古');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1501','15','呼和浩特');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150101','1501','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150102','1501','新城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150103','1501','回民區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150104','1501','玉泉區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150105','1501','賽罕區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150121','1501','土默特左旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150122','1501','托克托縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150123','1501','和林格爾縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150124','1501','清水河縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150125','1501','武川縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1502','15','包頭');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150201','1502','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150202','1502','東河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150203','1502','昆都倫區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150204','1502','青山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150205','1502','石拐區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150206','1502','白雲礦區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150207','1502','九原區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150221','1502','土默特右旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150222','1502','固陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150223','1502','達爾罕茂明安聯合旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1503','15','烏海');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150301','1503','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150302','1503','海勃灣區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150303','1503','海南區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150304','1503','烏達區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1504','15','赤峰');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150401','1504','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150402','1504','紅山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150403','1504','元寶山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150404','1504','松山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150421','1504','阿魯科爾沁旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150422','1504','巴林左旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150423','1504','巴林右旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150424','1504','林西縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150425','1504','克什克騰旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150426','1504','翁牛特旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150428','1504','喀喇沁旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150429','1504','寧城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150430','1504','敖漢旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1505','15','通遼');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150501','1505','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150502','1505','科爾沁區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150521','1505','科爾沁左翼中旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150522','1505','科爾沁左翼後旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150523','1505','開魯縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150524','1505','庫倫旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150525','1505','奈曼旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150526','1505','扎魯特旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('150581','1505','霍林郭勒市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1521','15','呼倫貝爾盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152101','1521','海拉爾市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152102','1521','滿洲里市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152103','1521','扎蘭屯市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152104','1521','牙克石市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152105','1521','根河市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152106','1521','額爾古納市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152122','1521','阿榮旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152123','1521','莫力達瓦達斡爾族自治');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152127','1521','鄂倫春自治旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152128','1521','鄂溫克族自治旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152129','1521','新巴爾虎右旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152130','1521','新巴爾虎左旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152131','1521','陳巴爾虎旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1522','15','興安盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152201','1522','烏蘭浩特市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152202','1522','阿爾山市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152221','1522','科爾沁右翼前旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152222','1522','科爾沁右翼中旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152223','1522','扎賚特旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152224','1522','突泉縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1525','15','錫林郭勒盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152501','1525','二連浩特市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152502','1525','錫林浩特市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152522','1525','阿巴嘎旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152523','1525','蘇尼特左旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152524','1525','蘇尼特右旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152525','1525','東烏珠穆沁旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152526','1525','西烏珠穆沁旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152527','1525','太僕寺旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152528','1525','鑲黃旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152529','1525','正鑲白旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152530','1525','正藍旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152531','1525','多倫縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1526','15','烏蘭察布盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152601','1526','集寧市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152602','1526','豐鎮市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152624','1526','卓資縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152625','1526','化德縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152626','1526','商都縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152627','1526','興和縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152629','1526','涼城縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152630','1526','察哈爾右翼前旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152631','1526','察哈爾右翼中旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152632','1526','察哈爾右翼後旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152634','1526','四子王旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1527','15','伊克昭盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152701','1527','東勝市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152722','1527','達拉特旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152723','1527','準格爾旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152724','1527','鄂托克前旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152725','1527','鄂托克旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152726','1527','杭錦旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152727','1527','烏審旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152728','1527','伊金霍洛旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1528','15','巴彥淖爾盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152801','1528','臨河市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152822','1528','五原縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152823','1528','磴口縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152824','1528','烏拉特前旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152825','1528','烏拉特中旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152826','1528','烏拉特後旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152827','1528','杭錦後旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('1529','15','阿拉善盟');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152921','1529','阿拉善左旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152922','1529','阿拉善右旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('152923','1529','額濟納旗');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('21','0','遼寧');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2101','21','沈陽');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210101','2101','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210102','2101','和平區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210103','2101','沈河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210104','2101','大東區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210105','2101','皇姑區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210106','2101','鐵西區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210111','2101','蘇家屯區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210112','2101','東陵區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210113','2101','新城子區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210114','2101','於洪區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210122','2101','遼中縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210123','2101','康平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210124','2101','法庫縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210181','2101','新民市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2102','21','大連');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210201','2102','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210202','2102','中山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210203','2102','西崗區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210204','2102','沙河口區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210211','2102','甘井子區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210212','2102','旅順口區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210213','2102','金州區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210224','2102','長海縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210281','2102','瓦房店市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210282','2102','普蘭店市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210283','2102','莊河市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2103','21','鞍山');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210301','2103','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210302','2103','鐵東區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210303','2103','鐵西區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210304','2103','立山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210311','2103','千山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210321','2103','台安縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210323','2103','岫岩滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210381','2103','海城市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2104','21','撫順');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210401','2104','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210402','2104','新撫區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210403','2104','東洲區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210404','2104','望花區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210411','2104','順城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210421','2104','撫順縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210422','2104','新賓滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210423','2104','清原滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2105','21','本溪');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210501','2105','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210502','2105','平山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210503','2105','溪湖區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210504','2105','明山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210505','2105','南芬區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210521','2105','本溪滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210522','2105','桓仁滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2106','21','丹東');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210601','2106','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210602','2106','元寶區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210603','2106','振興區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210604','2106','振安區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210624','2106','寬甸滿族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210681','2106','東港市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210682','2106','鳳城市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2107','21','錦州');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210701','2107','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210702','2107','古塔區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210703','2107','凌河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210711','2107','太和區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210726','2107','黑山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210727','2107','義  縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210781','2107','凌海市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210782','2107','北寧市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2108','21','營口');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210801','2108','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210802','2108','站前區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210803','2108','西市區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210804','2108','鮁魚圈區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210811','2108','老邊區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210881','2108','蓋州市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210882','2108','大石橋市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2109','21','阜新');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210901','2109','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210902','2109','海州區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210903','2109','新邱區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210904','2109','太平區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210905','2109','清河門區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210911','2109','細河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210921','2109','阜新蒙古族自治縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('210922','2109','彰武縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2110','21','遼陽');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211001','2110','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211002','2110','白塔區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211003','2110','文聖區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211004','2110','巨集偉區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211005','2110','弓長嶺區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211011','2110','太子河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211021','2110','遼陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211081','2110','燈塔市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2111','21','盤錦');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211101','2111','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211102','2111','雙檯子區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211103','2111','興隆台區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211121','2111','大窪縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211122','2111','盤山縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2112','21','鐵嶺');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211201','2112','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211202','2112','銀州區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211204','2112','清河區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211221','2112','鐵嶺縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211223','2112','西豐縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211224','2112','昌圖縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211281','2112','鐵法市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211282','2112','開原市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2113','21','朝陽');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211301','2113','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211302','2113','雙塔區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211303','2113','龍城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211321','2113','朝陽縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211322','2113','建平縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211324','2113','喀喇沁左翼蒙古族自治');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211381','2113','北票市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211382','2113','凌源市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2114','21','葫蘆島');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211401','2114','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211402','2114','連山區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211403','2114','龍港區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211404','2114','南票區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211421','2114','綏中縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211422','2114','建昌縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('211481','2114','興城市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('22','0','吉林');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2201','22','長春');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220101','2201','市轄區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220102','2201','南關區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220103','2201','寬城區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220104','2201','朝陽區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220105','2201','二道區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220106','2201','綠園區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220112','2201','雙陽區');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220122','2201','農安縣');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220181','2201','九台市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220182','2201','榆樹市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('220183','2201','德惠市');
insert into `base_area` (`codeid`, `parentid`, `cityName`) values('2202','22','吉林');
insert into `base_