3 Star 0 Fork 1

魔工坊 / 韵达快递小程序 后端

Gitee —— 企业级 DevOps 研发管理平台
加入 Gitee
克隆/下载
data.sql 218.47 KB
一键复制 编辑 Web IDE 原始数据 按行查看 历史
周俭 提交于 2018-05-16 18:21 . put运费后台管理配置
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565
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