省市区基础数据

1. 简介

项目中如果用到需要获取省市区树形结构的,可以使用该组件。

2. 基础环境

  1. java8+
  2. 开发框架 springboot2.0.4,spring5,jersey2,swagger2,hibernate-validate4,jpa,hibernate5

3. 如何使用

3.1. 添加依赖

<dependency>
    <groupId>com.jpxx.area</groupId>
    <artifactId>area-web-api</artifactId>
    <version>BASE-1.1.0-SNAPSHOT</version>
</dependency>

3.2. 服务注册

在项目的***ResouceConfig注册 FileApi.class (com.jpxx.area.web.api.AreaApi.class) 即可。

3.3. 注意事项

因Area表id自增策略为strategy = "increment",故不能多个后台服务同时连Area表新增省市县数据,以免导致id冲突。

3.4. 插入省市区基础数据

INSERT INTO `common_area` (`code`, `create_time`, `enable`, `name`, `parent_code`)
VALUES
    ('101000','2016-08-09 12:24:40',b'1','北京','0'),
    ('102000','2016-08-09 12:24:40',b'1','天津','0'),
    ('110000','2016-08-09 12:24:40',b'1','北京市','101000'),
    ('110100','2016-08-09 12:24:40',b'1','市辖区','110000'),
    ('110101','2016-08-09 12:24:40',b'1','东城区','110000'),
    ('110102','2016-08-09 12:24:40',b'1','西城区','110000'),
    ('110105','2016-08-09 12:24:40',b'1','朝阳区','110000'),
    ('110106','2016-08-09 12:24:40',b'1','丰台区','110000'),
    ('110107','2016-08-09 12:24:40',b'1','石景山区','110000'),
    ('110108','2016-08-09 12:24:40',b'1','海淀区','110000'),
    ('110109','2016-08-09 12:24:40',b'1','门头沟区','110000'),
    ('110111','2016-08-09 12:24:40',b'1','房山区','110000'),
    ('110112','2016-08-09 12:24:40',b'1','通州区','110000'),
    ('110113','2016-08-09 12:24:40',b'1','顺义区','110000'),
    ('110114','2016-08-09 12:24:40',b'1','昌平区','110000'),
    ('110115','2016-08-09 12:24:40',b'1','大兴区','110000'),
    ('110116','2016-08-09 12:24:40',b'1','怀柔区','110000'),
    ('110117','2016-08-09 12:24:40',b'1','平谷区','110000'),
    ('110200','2016-08-09 12:24:40',b'1','县','110000'),
    ('110228','2016-08-09 12:24:40',b'1','密云县','110000'),
    ('110229','2016-08-09 12:24:40',b'1','延庆县','110000'),
    ('120000','2016-08-09 12:24:40',b'1','天津市','102000'),
    ('120100','2016-08-09 12:24:40',b'1','市辖区','120000'),
    ('120101','2016-08-09 12:24:40',b'1','和平区','120000'),
    ('120102','2016-08-09 12:24:40',b'1','河东区','120000'),
    ('120103','2016-08-09 12:24:40',b'1','河西区','120000'),
    ('120104','2016-08-09 12:24:40',b'1','南开区','120000'),
    ('120105','2016-08-09 12:24:40',b'1','河北区','120000'),
    ('120106','2016-08-09 12:24:40',b'1','红桥区','120000'),
    ('120110','2016-08-09 12:24:40',b'1','东丽区','120000'),
    ('120111','2016-08-09 12:24:40',b'1','西青区','120000'),
    ('120112','2016-08-09 12:24:40',b'1','津南区','120000'),
    ('120113','2016-08-09 12:24:40',b'1','北辰区','120000'),
    ('120114','2016-08-09 12:24:40',b'1','武清区','120000'),
    ('120115','2016-08-09 12:24:40',b'1','宝坻区','120000'),
    ('120116','2016-08-09 12:24:40',b'1','滨海新区','120000'),
    ('120200','2016-08-09 12:24:40',b'1','县','120000'),
    ('120221','2016-08-09 12:24:40',b'1','宁河县','120000'),
    ('120223','2016-08-09 12:24:40',b'1','静海县','120000'),
    ('120225','2016-08-09 12:24:40',b'1','蓟县','120000'),
    ('130000','2016-08-09 12:24:40',b'1','河北省','0'),
    ('130100','2016-08-09 12:24:40',b'1','石家庄市','130000'),
    ('130101','2016-08-09 12:24:40',b'1','市辖区','130100'),
    ('130102','2016-08-09 12:24:40',b'1','长安区','130100'),
    ('130103','2016-08-09 12:24:40',b'1','桥东区','130100'),
    ('130104','2016-08-09 12:24:40',b'1','桥西区','130100'),
    ('130105','2016-08-09 12:24:40',b'1','新华区','130100'),
    ('130107','2016-08-09 12:24:40',b'1','井陉矿区','130100'),
    ('130108','2016-08-09 12:24:40',b'1','裕华区','130100'),
    ('130121','2016-08-09 12:24:40',b'1','井陉县','130100'),
    ('130123','2016-08-09 12:24:40',b'1','正定县','130100'),
    ('130124','2016-08-09 12:24:40',b'1','栾城县','130100'),
    ('130125','2016-08-09 12:24:40',b'1','行唐县','130100'),
    ('130126','2016-08-09 12:24:40',b'1','灵寿县','130100'),
    ('130127','2016-08-09 12:24:40',b'1','高邑县','130100'),
    ('130128','2016-08-09 12:24:40',b'1','深泽县','130100'),
    ('130129','2016-08-09 12:24:40',b'1','赞皇县','130100'),
    ('130130','2016-08-09 12:24:40',b'1','无极县','130100'),
    ('130131','2016-08-09 12:24:40',b'1','平山县','130100'),
    ('130132','2016-08-09 12:24:40',b'1','元氏县','130100'),
    ('130133','2016-08-09 12:24:40',b'1','赵县','130100'),
    ('130181','2016-08-09 12:24:40',b'1','辛集市','130100'),
    ('130182','2016-08-09 12:24:40',b'1','藁城市','130100'),
    ('130183','2016-08-09 12:24:40',b'1','晋州市','130100'),
    ('130184','2016-08-09 12:24:40',b'1','新乐市','130100'),
    ('130185','2016-08-09 12:24:40',b'1','鹿泉市','130100'),
    ('130200','2016-08-09 12:24:40',b'1','唐山市','130000'),
    ('130201','2016-08-09 12:24:40',b'1','市辖区','130200'),
    ('130202','2016-08-09 12:24:40',b'1','路南区','130200'),
    ('130203','2016-08-09 12:24:40',b'1','路北区','130200'),
    ('130204','2016-08-09 12:24:40',b'1','古冶区','130200'),
    ('130205','2016-08-09 12:24:40',b'1','开平区','130200'),
    ('130207','2016-08-09 12:24:40',b'1','丰南区','130200'),
    ('130208','2016-08-09 12:24:40',b'1','丰润区','130200'),
    ('130223','2016-08-09 12:24:40',b'1','滦县','130200'),
    ('130224','2016-08-09 12:24:40',b'1','滦南县','130200'),
    ('130225','2016-08-09 12:24:40',b'1','乐亭县','130200'),
    ('130227','2016-08-09 12:24:40',b'1','迁西县','130200'),
    ('130229','2016-08-09 12:24:40',b'1','玉田县','130200'),
    ('130230','2016-08-09 12:24:40',b'1','唐海县','130200'),
    ('130281','2016-08-09 12:24:40',b'1','遵化市','130200'),
    ('130283','2016-08-09 12:24:40',b'1','迁安市','130200'),
    ('130300','2016-08-09 12:24:40',b'1','秦皇岛市','130000'),
    ('130301','2016-08-09 12:24:40',b'1','市辖区','130300'),
    ('130302','2016-08-09 12:24:40',b'1','海港区','130300'),
    ('130303','2016-08-09 12:24:40',b'1','山海关区','130300'),
    ('130304','2016-08-09 12:24:40',b'1','北戴河区','130300'),
    ('130321','2016-08-09 12:24:40',b'1','青龙满族自治县','130300'),
    ('130322','2016-08-09 12:24:40',b'1','昌黎县','130300'),
    ('130323','2016-08-09 12:24:40',b'1','抚宁县','130300'),
    ('130324','2016-08-09 12:24:40',b'1','卢龙县','130300'),
    ('130400','2016-08-09 12:24:40',b'1','邯郸市','130000'),
    ('130401','2016-08-09 12:24:40',b'1','市辖区','130400'),
    ('130402','2016-08-09 12:24:40',b'1','邯山区','130400'),
    ('130403','2016-08-09 12:24:40',b'1','丛台区','130400'),
    ('130404','2016-08-09 12:24:40',b'1','复兴区','130400'),
    ('130406','2016-08-09 12:24:40',b'1','峰峰矿区','130400'),
    ('130421','2016-08-09 12:24:40',b'1','邯郸县','130400'),
    ('130423','2016-08-09 12:24:40',b'1','临漳县','130400'),
    ('130424','2016-08-09 12:24:40',b'1','成安县','130400'),
    ('130425','2016-08-09 12:24:40',b'1','大名县','130400'),
    ('130426','2016-08-09 12:24:40',b'1','涉县','130400'),
    ('130427','2016-08-09 12:24:40',b'1','磁县','130400'),
    ('130428','2016-08-09 12:24:40',b'1','肥乡县','130400'),
    ('130429','2016-08-09 12:24:40',b'1','永年县','130400'),
    ('130430','2016-08-09 12:24:40',b'1','邱县','130400'),
    ('130431','2016-08-09 12:24:40',b'1','鸡泽县','130400'),
    ('130432','2016-08-09 12:24:40',b'1','广平县','130400'),
    ('130433','2016-08-09 12:24:40',b'1','馆陶县','130400'),
    ('130434','2016-08-09 12:24:40',b'1','魏县','130400'),
    ('130435','2016-08-09 12:24:40',b'1','曲周县','130400'),
    ('130481','2016-08-09 12:24:40',b'1','武安市','130400'),
    ('130500','2016-08-09 12:24:40',b'1','邢台市','130000'),
    ('130501','2016-08-09 12:24:40',b'1','市辖区','130500'),
    ('130502','2016-08-09 12:24:40',b'1','桥东区','130500'),
    ('130503','2016-08-09 12:24:40',b'1','桥西区','130500'),
    ('130521','2016-08-09 12:24:40',b'1','邢台县','130500'),
    ('130522','2016-08-09 12:24:40',b'1','临城县','130500'),
    ('130523','2016-08-09 12:24:40',b'1','内丘县','130500'),
    ('130524','2016-08-09 12:24:40',b'1','柏乡县','130500'),
    ('130525','2016-08-09 12:24:40',b'1','隆尧县','130500'),
    ('130526','2016-08-09 12:24:40',b'1','任县','130500'),
    ('130527','2016-08-09 12:24:40',b'1','南和县','130500'),
    ('130528','2016-08-09 12:24:40',b'1','宁晋县','130500'),
    ('130529','2016-08-09 12:24:40',b'1','巨鹿县','130500'),
    ('130530','2016-08-09 12:24:40',b'1','新河县','130500'),
    ('130531','2016-08-09 12:24:40',b'1','广宗县','130500'),
    ('130532','2016-08-09 12:24:40',b'1','平乡县','130500'),
    ('130533','2016-08-09 12:24:40',b'1','威县','130500'),
    ('130534','2016-08-09 12:24:40',b'1','清河县','130500'),
    ('130535','2016-08-09 12:24:40',b'1','临西县','130500'),
    ('130581','2016-08-09 12:24:40',b'1','南宫市','130500'),
    ('130582','2016-08-09 12:24:40',b'1','沙河市','130500'),
    ('130600','2016-08-09 12:24:40',b'1','保定市','130000'),
    ('130601','2016-08-09 12:24:40',b'1','市辖区','130600'),
    ('130602','2016-08-09 12:24:40',b'1','新市区','130600'),
    ('130603','2016-08-09 12:24:40',b'1','北市区','130600'),
    ('130604','2016-08-09 12:24:40',b'1','南市区','130600'),
    ('130621','2016-08-09 12:24:40',b'1','满城县','130600'),
    ('130622','2016-08-09 12:24:40',b'1','清苑县','130600'),
    ('130623','2016-08-09 12:24:40',b'1','涞水县','130600'),
    ('130624','2016-08-09 12:24:40',b'1','阜平县','130600'),
    ('130625','2016-08-09 12:24:40',b'1','徐水县','130600'),
    ('130626','2016-08-09 12:24:40',b'1','定兴县','130600'),
    ('130627','2016-08-09 12:24:40',b'1','唐县','130600'),
    ('130628','2016-08-09 12:24:40',b'1','高阳县','130600'),
    ('130629','2016-08-09 12:24:40',b'1','容城县','130600'),
    ('130630','2016-08-09 12:24:40',b'1','涞源县','130600'),
    ('130631','2016-08-09 12:24:40',b'1','望都县','130600'),
    ('130632','2016-08-09 12:24:40',b'1','安新县','130600'),
    ('130633','2016-08-09 12:24:40',b'1','易县','130600'),
    ('130634','2016-08-09 12:24:40',b'1','曲阳县','130600'),
    ('130635','2016-08-09 12:24:40',b'1','蠡县','130600'),
    ('130636','2016-08-09 12:24:40',b'1','顺平县','130600'),
    ('130637','2016-08-09 12:24:40',b'1','博野县','130600'),
    ('130638','2016-08-09 12:24:40',b'1','雄县','130600'),
    ('130681','2016-08-09 12:24:40',b'1','涿州市','130600'),
    ('130682','2016-08-09 12:24:40',b'1','定州市','130600'),
    ('130683','2016-08-09 12:24:40',b'1','安国市','130600'),
    ('130684','2016-08-09 12:24:40',b'1','高碑店市','130600'),
    ('130700','2016-08-09 12:24:40',b'1','张家口市','130000'),
    ('130701','2016-08-09 12:24:40',b'1','市辖区','130700'),
    ('130702','2016-08-09 12:24:40',b'1','桥东区','130700'),
    ('130703','2016-08-09 12:24:40',b'1','桥西区','130700'),
    ('130705','2016-08-09 12:24:40',b'1','宣化区','130700'),
    ('130706','2016-08-09 12:24:40',b'1','下花园区','130700'),
    ('130721','2016-08-09 12:24:40',b'1','宣化县','130700'),
    ('130722','2016-08-09 12:24:40',b'1','张北县','130700'),
    ('130723','2016-08-09 12:24:40',b'1','康保县','130700'),
    ('130724','2016-08-09 12:24:40',b'1','沽源县','130700'),
    ('130725','2016-08-09 12:24:40',b'1','尚义县','130700'),
    ('130726','2016-08-09 12:24:40',b'1','蔚县','130700'),
    ('130727','2016-08-09 12:24:40',b'1','阳原县','130700'),
    ('130728','2016-08-09 12:24:40',b'1','怀安县','130700'),
    ('130729','2016-08-09 12:24:40',b'1','万全县','130700'),
    ('130730','2016-08-09 12:24:40',b'1','怀来县','130700'),
    ('130731','2016-08-09 12:24:40',b'1','涿鹿县','130700'),
    ('130732','2016-08-09 12:24:40',b'1','赤城县','130700'),
    ('130733','2016-08-09 12:24:40',b'1','崇礼县','130700'),
    ('130800','2016-08-09 12:24:40',b'1','承德市','130000'),
    ('130801','2016-08-09 12:24:40',b'1','市辖区','130800'),
    ('130802','2016-08-09 12:24:40',b'1','双桥区','130800'),
    ('130803','2016-08-09 12:24:40',b'1','双滦区','130800'),
    ('130804','2016-08-09 12:24:40',b'1','鹰手营子矿区','130800'),
    ('130821','2016-08-09 12:24:40',b'1','承德县','130800'),
    ('130822','2016-08-09 12:24:40',b'1','兴隆县','130800'),
    ('130823','2016-08-09 12:24:40',b'1','平泉县','130800'),
    ('130824','2016-08-09 12:24:40',b'1','滦平县','130800'),
    ('130825','2016-08-09 12:24:40',b'1','隆化县','130800'),
    ('130826','2016-08-09 12:24:40',b'1','丰宁满族自治县','130800'),
    ('130827','2016-08-09 12:24:40',b'1','宽城满族自治县','130800'),
    ('130828','2016-08-09 12:24:40',b'1','围场满族蒙古族自治县','130800'),
    ('130900','2016-08-09 12:24:40',b'1','沧州市','130000'),
    ('130901','2016-08-09 12:24:40',b'1','市辖区','130900'),
    ('130902','2016-08-09 12:24:40',b'1','新华区','130900'),
    ('130903','2016-08-09 12:24:40',b'1','运河区','130900'),
    ('130921','2016-08-09 12:24:40',b'1','沧县','130900'),
    ('130922','2016-08-09 12:24:40',b'1','青县','130900'),
    ('130923','2016-08-09 12:24:40',b'1','东光县','130900'),
    ('130924','2016-08-09 12:24:40',b'1','海兴县','130900'),
    ('130925','2016-08-09 12:24:40',b'1','盐山县','130900'),
    ('130926','2016-08-09 12:24:40',b'1','肃宁县','130900'),
    ('130927','2016-08-09 12:24:40',b'1','南皮县','130900'),
    ('130928','2016-08-09 12:24:40',b'1','吴桥县','130900'),
    ('130929','2016-08-09 12:24:40',b'1','献县','130900'),
    ('130930','2016-08-09 12:24:40',b'1','孟村回族自治县','130900'),
    ('130981','2016-08-09 12:24:40',b'1','泊头市','130900'),
    ('130982','2016-08-09 12:24:40',b'1','任丘市','130900'),
    ('130983','2016-08-09 12:24:40',b'1','黄骅市','130900'),
    ('130984','2016-08-09 12:24:40',b'1','河间市','130900'),
    ('131000','2016-08-09 12:24:40',b'1','廊坊市','130000'),
    ('131001','2016-08-09 12:24:40',b'1','市辖区','131000'),
    ('131002','2016-08-09 12:24:40',b'1','安次区','131000'),
    ('131003','2016-08-09 12:24:40',b'1','广阳区','131000'),
    ('131022','2016-08-09 12:24:40',b'1','固安县','131000'),
    ('131023','2016-08-09 12:24:40',b'1','永清县','131000'),
    ('131024','2016-08-09 12:24:40',b'1','香河县','131000'),
    ('131025','2016-08-09 12:24:40',b'1','大城县','131000'),
    ('131026','2016-08-09 12:24:40',b'1','文安县','131000'),
    ('131028','2016-08-09 12:24:40',b'1','大厂回族自治县','131000'),
    ('131081','2016-08-09 12:24:40',b'1','霸州市','131000'),
    ('131082','2016-08-09 12:24:40',b'1','三河市','131000'),
    ('131100','2016-08-09 12:24:40',b'1','衡水市','130000'),
    ('131101','2016-08-09 12:24:40',b'1','市辖区','131100'),
    ('131102','2016-08-09 12:24:40',b'1','桃城区','131100'),
    ('131121','2016-08-09 12:24:40',b'1','枣强县','131100'),
    ('131122','2016-08-09 12:24:40',b'1','武邑县','131100'),
    ('131123','2016-08-09 12:24:40',b'1','武强县','131100'),
    ('131124','2016-08-09 12:24:40',b'1','饶阳县','131100'),
    ('131125','2016-08-09 12:24:40',b'1','安平县','131100'),
    ('131126','2016-08-09 12:24:40',b'1','故城县','131100'),
    ('131127','2016-08-09 12:24:40',b'1','景县','131100'),
    ('131128','2016-08-09 12:24:40',b'1','阜城县','131100'),
    ('131181','2016-08-09 12:24:40',b'1','冀州市','131100'),
    ('131182','2016-08-09 12:24:40',b'1','深州市','131100'),
    ('140000','2016-08-09 12:24:40',b'1','山西省','0'),
    ('140100','2016-08-09 12:24:40',b'1','太原市','140000'),
    ('140101','2016-08-09 12:24:40',b'1','市辖区','140100'),
    ('140105','2016-08-09 12:24:40',b'1','小店区','140100'),
    ('140106','2016-08-09 12:24:40',b'1','迎泽区','140100'),
    ('140107','2016-08-09 12:24:40',b'1','杏花岭区','140100'),
    ('140108','2016-08-09 12:24:40',b'1','尖草坪区','140100'),
    ('140109','2016-08-09 12:24:40',b'1','万柏林区','140100'),
    ('140110','2016-08-09 12:24:40',b'1','晋源区','140100'),
    ('140121','2016-08-09 12:24:40',b'1','清徐县','140100'),
    ('140122','2016-08-09 12:24:40',b'1','阳曲县','140100'),
    ('140123','2016-08-09 12:24:40',b'1','娄烦县','140100'),
    ('140181','2016-08-09 12:24:40',b'1','古交市','140100'),
    ('140200','2016-08-09 12:24:40',b'1','大同市','140000'),
    ('140201','2016-08-09 12:24:40',b'1','市辖区','140200'),
    ('140202','2016-08-09 12:24:40',b'1','城区','140200'),
    ('140203','2016-08-09 12:24:40',b'1','矿区','140200'),
    ('140211','2016-08-09 12:24:40',b'1','南郊区','140200'),
    ('140212','2016-08-09 12:24:40',b'1','新荣区','140200'),
    ('140221','2016-08-09 12:24:40',b'1','阳高县','140200'),
    ('140222','2016-08-09 12:24:40',b'1','天镇县','140200'),
    ('140223','2016-08-09 12:24:40',b'1','广灵县','140200'),
    ('140224','2016-08-09 12:24:40',b'1','灵丘县','140200'),
    ('140225','2016-08-09 12:24:40',b'1','浑源县','140200'),
    ('140226','2016-08-09 12:24:40',b'1','左云县','140200'),
    ('140227','2016-08-09 12:24:40',b'1','大同县','140200'),
    ('140300','2016-08-09 12:24:40',b'1','阳泉市','140000'),
    ('140301','2016-08-09 12:24:40',b'1','市辖区','140300'),
    ('140302','2016-08-09 12:24:40',b'1','城区','140300'),
    ('140303','2016-08-09 12:24:40',b'1','矿区','140300'),
    ('140311','2016-08-09 12:24:40',b'1','郊区','140300'),
    ('140321','2016-08-09 12:24:40',b'1','平定县','140300'),
    ('140322','2016-08-09 12:24:40',b'1','盂县','140300'),
    ('140400','2016-08-09 12:24:40',b'1','长治市','140000'),
    ('140401','2016-08-09 12:24:40',b'1','市辖区','140400'),
    ('140402','2016-08-09 12:24:40',b'1','城区','140400'),
    ('140411','2016-08-09 12:24:40',b'1','郊区','140400'),
    ('140421','2016-08-09 12:24:40',b'1','长治县','140400'),
    ('140423','2016-08-09 12:24:40',b'1','襄垣县','140400'),
    ('140424','2016-08-09 12:24:40',b'1','屯留县','140400'),
    ('140425','2016-08-09 12:24:40',b'1','平顺县','140400'),
    ('140426','2016-08-09 12:24:40',b'1','黎城县','140400'),
    ('140427','2016-08-09 12:24:40',b'1','壶关县','140400'),
    ('140428','2016-08-09 12:24:40',b'1','长子县','140400'),
    ('140429','2016-08-09 12:24:40',b'1','武乡县','140400'),
    ('140430','2016-08-09 12:24:40',b'1','沁县','140400'),
    ('140431','2016-08-09 12:24:40',b'1','沁源县','140400'),
    ('140481','2016-08-09 12:24:40',b'1','潞城市','140400'),
    ('140500','2016-08-09 12:24:40',b'1','晋城市','140000'),
    ('140501','2016-08-09 12:24:40',b'1','市辖区','140500'),
    ('140502','2016-08-09 12:24:40',b'1','城区','140500'),
    ('140521','2016-08-09 12:24:40',b'1','沁水县','140500'),
    ('140522','2016-08-09 12:24:40',b'1','阳城县','140500'),
    ('140524','2016-08-09 12:24:40',b'1','陵川县','140500'),
    ('140525','2016-08-09 12:24:40',b'1','泽州县','140500'),
    ('140581','2016-08-09 12:24:40',b'1','高平市','140500'),
    ('140600','2016-08-09 12:24:40',b'1','朔州市','140000'),
    ('140601','2016-08-09 12:24:40',b'1','市辖区','140600'),
    ('140602','2016-08-09 12:24:40',b'1','朔城区','140600'),
    ('140603','2016-08-09 12:24:40',b'1','平鲁区','140600'),
    ('140621','2016-08-09 12:24:40',b'1','山阴县','140600'),
    ('140622','2016-08-09 12:24:40',b'1','应县','140600'),
    ('140623','2016-08-09 12:24:40',b'1','右玉县','140600'),
    ('140624','2016-08-09 12:24:40',b'1','怀仁县','140600'),
    ('140700','2016-08-09 12:24:40',b'1','晋中市','140000'),
    ('140701','2016-08-09 12:24:40',b'1','市辖区','140700'),
    ('140702','2016-08-09 12:24:40',b'1','榆次区','140700'),
    ('140721','2016-08-09 12:24:40',b'1','榆社县','140700'),
    ('140722','2016-08-09 12:24:40',b'1','左权县','140700'),
    ('140723','2016-08-09 12:24:40',b'1','和顺县','140700'),
    ('140724','2016-08-09 12:24:40',b'1','昔阳县','140700'),
    ('140725','2016-08-09 12:24:40',b'1','寿阳县','140700'),
    ('140726','2016-08-09 12:24:40',b'1','太谷县','140700'),
    ('140727','2016-08-09 12:24:40',b'1','祁县','140700'),
    ('140728','2016-08-09 12:24:40',b'1','平遥县','140700'),
    ('140729','2016-08-09 12:24:40',b'1','灵石县','140700'),
    ('140781','2016-08-09 12:24:40',b'1','介休市','140700'),
    ('140800','2016-08-09 12:24:40',b'1','运城市','140000'),
    ('140801','2016-08-09 12:24:40',b'1','市辖区','140800'),
    ('140802','2016-08-09 12:24:40',b'1','盐湖区','140800'),
    ('140821','2016-08-09 12:24:40',b'1','临猗县','140800'),
    ('140822','2016-08-09 12:24:40',b'1','万荣县','140800'),
    ('140823','2016-08-09 12:24:40',b'1','闻喜县','140800'),
    ('140824','2016-08-09 12:24:40',b'1','稷山县','140800'),
    ('140825','2016-08-09 12:24:40',b'1','新绛县','140800'),
    ('140826','2016-08-09 12:24:40',b'1','绛县','140800'),
    ('140827','2016-08-09 12:24:40',b'1','垣曲县','140800'),
    ('140828','2016-08-09 12:24:40',b'1','夏县','140800'),
    ('140829','2016-08-09 12:24:40',b'1','平陆县','140800'),
    ('140830','2016-08-09 12:24:40',b'1','芮城县','140800'),
    ('140881','2016-08-09 12:24:40',b'1','永济市','140800'),
    ('140882','2016-08-09 12:24:40',b'1','河津市','140800'),
    ('140900','2016-08-09 12:24:40',b'1','忻州市','140000'),
    ('140901','2016-08-09 12:24:40',b'1','市辖区','140900'),
    ('140902','2016-08-09 12:24:40',b'1','忻府区','140900'),
    ('140921','2016-08-09 12:24:40',b'1','定襄县','140900'),
    ('140922','2016-08-09 12:24:40',b'1','五台县','140900'),
    ('140923','2016-08-09 12:24:40',b'1','代县','140900'),
    ('140924','2016-08-09 12:24:40',b'1','繁峙县','140900'),
    ('140925','2016-08-09 12:24:40',b'1','宁武县','140900'),
    ('140926','2016-08-09 12:24:40',b'1','静乐县','140900'),
    ('140927','2016-08-09 12:24:40',b'1','神池县','140900'),
    ('140928','2016-08-09 12:24:40',b'1','五寨县','140900'),
    ('140929','2016-08-09 12:24:40',b'1','岢岚县','140900'),
    ('140930','2016-08-09 12:24:40',b'1','河曲县','140900'),
    ('140931','2016-08-09 12:24:40',b'1','保德县','140900'),
    ('140932','2016-08-09 12:24:40',b'1','偏关县','140900'),
    ('140981','2016-08-09 12:24:40',b'1','原平市','140900'),
    ('141000','2016-08-09 12:24:40',b'1','临汾市','140000'),
    ('141001','2016-08-09 12:24:40',b'1','市辖区','141000'),
    ('141002','2016-08-09 12:24:40',b'1','尧都区','141000'),
    ('141021','2016-08-09 12:24:40',b'1','曲沃县','141000'),
    ('141022','2016-08-09 12:24:40',b'1','翼城县','141000'),
    ('141023','2016-08-09 12:24:40',b'1','襄汾县','141000'),
    ('141024','2016-08-09 12:24:40',b'1','洪洞县','141000'),
    ('141025','2016-08-09 12:24:40',b'1','古县','141000'),
    ('141026','2016-08-09 12:24:40',b'1','安泽县','141000'),
    ('141027','2016-08-09 12:24:40',b'1','浮山县','141000'),
    ('141028','2016-08-09 12:24:40',b'1','吉县','141000'),
    ('141029','2016-08-09 12:24:40',b'1','乡宁县','141000'),
    ('141030','2016-08-09 12:24:40',b'1','大宁县','141000'),
    ('141031','2016-08-09 12:24:40',b'1','隰县','141000'),
    ('141032','2016-08-09 12:24:40',b'1','永和县','141000'),
    ('141033','2016-08-09 12:24:40',b'1','蒲县','141000'),
    ('141034','2016-08-09 12:24:40',b'1','汾西县','141000'),
    ('141081','2016-08-09 12:24:40',b'1','侯马市','141000'),
    ('141082','2016-08-09 12:24:40',b'1','霍州市','141000'),
    ('141100','2016-08-09 12:24:40',b'1','吕梁市','140000'),
    ('141101','2016-08-09 12:24:40',b'1','市辖区','141100'),
    ('141102','2016-08-09 12:24:40',b'1','离石区','141100'),
    ('141121','2016-08-09 12:24:40',b'1','文水县','141100'),
    ('141122','2016-08-09 12:24:40',b'1','交城县','141100'),
    ('141123','2016-08-09 12:24:40',b'1','兴县','141100'),
    ('141124','2016-08-09 12:24:40',b'1','临县','141100'),
    ('141125','2016-08-09 12:24:40',b'1','柳林县','141100'),
    ('141126','2016-08-09 12:24:40',b'1','石楼县','141100'),
    ('141127','2016-08-09 12:24:40',b'1','岚县','141100'),
    ('141128','2016-08-09 12:24:40',b'1','方山县','141100'),
    ('141129','2016-08-09 12:24:40',b'1','中阳县','141100'),
    ('141130','2016-08-09 12:24:40',b'1','交口县','141100'),
    ('141181','2016-08-09 12:24:40',b'1','孝义市','141100'),
    ('141182','2016-08-09 12:24:40',b'1','汾阳市','141100'),
    ('150000','2016-08-09 12:24:40',b'1','内蒙古自治区','0'),
    ('150100','2016-08-09 12:24:40',b'1','呼和浩特市','150000'),
    ('150101','2016-08-09 12:24:40',b'1','市辖区','150100'),
    ('150102','2016-08-09 12:24:40',b'1','新城区','150100'),
    ('150103','2016-08-09 12:24:40',b'1','回民区','150100'),
    ('150104','2016-08-09 12:24:40',b'1','玉泉区','150100'),
    ('150105','2016-08-09 12:24:40',b'1','赛罕区','150100'),
    ('150121','2016-08-09 12:24:40',b'1','土默特左旗','150100'),
    ('150122','2016-08-09 12:24:40',b'1','托克托县','150100'),
    ('150123','2016-08-09 12:24:40',b'1','和林格尔县','150100'),
    ('150124','2016-08-09 12:24:40',b'1','清水河县','150100'),
    ('150125','2016-08-09 12:24:40',b'1','武川县','150100'),
    ('150200','2016-08-09 12:24:40',b'1','包头市','150000'),
    ('150201','2016-08-09 12:24:40',b'1','市辖区','150200'),
    ('150202','2016-08-09 12:24:40',b'1','东河区','150200'),
    ('150203','2016-08-09 12:24:40',b'1','昆都仑区','150200'),
    ('150204','2016-08-09 12:24:40',b'1','青山区','150200'),
    ('150205','2016-08-09 12:24:40',b'1','石拐区','150200'),
    ('150206','2016-08-09 12:24:40',b'1','白云鄂博矿区','150200'),
    ('150207','2016-08-09 12:24:40',b'1','九原区','150200'),
    ('150221','2016-08-09 12:24:40',b'1','土默特右旗','150200'),
    ('150222','2016-08-09 12:24:40',b'1','固阳县','150200'),
    ('150223','2016-08-09 12:24:40',b'1','达尔罕茂明安联合旗','150200'),
    ('150300','2016-08-09 12:24:40',b'1','乌海市','150000'),
    ('150301','2016-08-09 12:24:40',b'1','市辖区','150300'),
    ('150302','2016-08-09 12:24:40',b'1','海勃湾区','150300'),
    ('150303','2016-08-09 12:24:40',b'1','海南区','150300'),
    ('150304','2016-08-09 12:24:40',b'1','乌达区','150300'),
    ('150400','2016-08-09 12:24:40',b'1','赤峰市','150000'),
    ('150401','2016-08-09 12:24:40',b'1','市辖区','150400'),
    ('150402','2016-08-09 12:24:40',b'1','红山区','150400'),
    ('150403','2016-08-09 12:24:40',b'1','元宝山区','150400'),
    ('150404','2016-08-09 12:24:40',b'1','松山区','150400'),
    ('150421','2016-08-09 12:24:40',b'1','阿鲁科尔沁旗','150400'),
    ('150422','2016-08-09 12:24:40',b'1','巴林左旗','150400'),
    ('150423','2016-08-09 12:24:40',b'1','巴林右旗','150400'),
    ('150424','2016-08-09 12:24:40',b'1','林西县','150400'),
    ('150425','2016-08-09 12:24:40',b'1','克什克腾旗','150400'),
    ('150426','2016-08-09 12:24:40',b'1','翁牛特旗','150400'),
    ('150428','2016-08-09 12:24:40',b'1','喀喇沁旗','150400'),
    ('150429','2016-08-09 12:24:40',b'1','宁城县','150400'),
    ('150430','2016-08-09 12:24:40',b'1','敖汉旗','150400'),
    ('150500','2016-08-09 12:24:40',b'1','通辽市','150000'),
    ('150501','2016-08-09 12:24:40',b'1','市辖区','150500'),
    ('150502','2016-08-09 12:24:40',b'1','科尔沁区','150500'),
    ('150521','2016-08-09 12:24:40',b'1','科尔沁左翼中旗','150500'),
    ('150522','2016-08-09 12:24:40',b'1','科尔沁左翼后旗','150500'),
    ('150523','2016-08-09 12:24:40',b'1','开鲁县','150500'),
    ('150524','2016-08-09 12:24:40',b'1','库伦旗','150500'),
    ('150525','2016-08-09 12:24:40',b'1','奈曼旗','150500'),
    ('150526','2016-08-09 12:24:40',b'1','扎鲁特旗','150500'),
    ('150581','2016-08-09 12:24:40',b'1','霍林郭勒市','150500'),
    ('150600','2016-08-09 12:24:40',b'1','鄂尔多斯市','150000'),
    ('150601','2016-08-09 12:24:40',b'1','市辖区','150600'),
    ('150602','2016-08-09 12:24:40',b'1','东胜区','150600'),
    ('150621','2016-08-09 12:24:40',b'1','达拉特旗','150600'),
    ('150622','2016-08-09 12:24:40',b'1','准格尔旗','150600'),
    ('150623','2016-08-09 12:24:40',b'1','鄂托克前旗','150600'),
    ('150624','2016-08-09 12:24:40',b'1','鄂托克旗','150600'),
    ('150625','2016-08-09 12:24:40',b'1','杭锦旗','150600'),
    ('150626','2016-08-09 12:24:40',b'1','乌审旗','150600'),
    ('150627','2016-08-09 12:24:40',b'1','伊金霍洛旗','150600'),
    ('150700','2016-08-09 12:24:40',b'1','呼伦贝尔市','150000'),
    ('150701','2016-08-09 12:24:40',b'1','市辖区','150700'),
    ('150702','2016-08-09 12:24:40',b'1','海拉尔区','150700'),
    ('150721','2016-08-09 12:24:40',b'1','阿荣旗','150700'),
    ('150722','2016-08-09 12:24:40',b'1','莫力达瓦达斡尔族自治旗','150700'),
    ('150723','2016-08-09 12:24:40',b'1','鄂伦春自治旗','150700'),
    ('150724','2016-08-09 12:24:40',b'1','鄂温克族自治旗','150700'),
    ('150725','2016-08-09 12:24:40',b'1','陈巴尔虎旗','150700'),
    ('150726','2016-08-09 12:24:40',b'1','新巴尔虎左旗','150700'),
    ('150727','2016-08-09 12:24:40',b'1','新巴尔虎右旗','150700'),
    ('150781','2016-08-09 12:24:40',b'1','满洲里市','150700'),
    ('150782','2016-08-09 12:24:40',b'1','牙克石市','150700'),
    ('150783','2016-08-09 12:24:40',b'1','扎兰屯市','150700'),
    ('150784','2016-08-09 12:24:40',b'1','额尔古纳市','150700'),
    ('150785','2016-08-09 12:24:40',b'1','根河市','150700'),
    ('150800','2016-08-09 12:24:40',b'1','巴彦淖尔市','150000'),
    ('150801','2016-08-09 12:24:40',b'1','市辖区','150800'),
    ('150802','2016-08-09 12:24:40',b'1','临河区','150800'),
    ('150821','2016-08-09 12:24:40',b'1','五原县','150800'),
    ('150822','2016-08-09 12:24:40',b'1','磴口县','150800'),
    ('150823','2016-08-09 12:24:40',b'1','乌拉特前旗','150800'),
    ('150824','2016-08-09 12:24:40',b'1','乌拉特中旗','150800'),
    ('150825','2016-08-09 12:24:40',b'1','乌拉特后旗','150800'),
    ('150826','2016-08-09 12:24:40',b'1','杭锦后旗','150800'),
    ('150900','2016-08-09 12:24:40',b'1','乌兰察布市','150000'),
    ('150901','2016-08-09 12:24:40',b'1','市辖区','150900'),
    ('150902','2016-08-09 12:24:40',b'1','集宁区','150900'),
    ('150921','2016-08-09 12:24:40',b'1','卓资县','150900'),
    ('150922','2016-08-09 12:24:40',b'1','化德县','150900'),
    ('150923','2016-08-09 12:24:40',b'1','商都县','150900'),
    ('150924','2016-08-09 12:24:40',b'1','兴和县','150900'),
    ('150925','2016-08-09 12:24:40',b'1','凉城县','150900'),
    ('150926','2016-08-09 12:24:40',b'1','察哈尔右翼前旗','150900'),
    ('150927','2016-08-09 12:24:40',b'1','察哈尔右翼中旗','150900'),
    ('150928','2016-08-09 12:24:40',b'1','察哈尔右翼后旗','150900'),
    ('150929','2016-08-09 12:24:40',b'1','四子王旗','150900'),
    ('150981','2016-08-09 12:24:40',b'1','丰镇市','150900'),
    ('152200','2016-08-09 12:24:40',b'1','兴安盟','150000'),
    ('152201','2016-08-09 12:24:40',b'1','乌兰浩特市','152200'),
    ('152202','2016-08-09 12:24:40',b'1','阿尔山市','152200'),
    ('152221','2016-08-09 12:24:40',b'1','科尔沁右翼前旗','152200'),
    ('152222','2016-08-09 12:24:40',b'1','科尔沁右翼中旗','152200'),
    ('152223','2016-08-09 12:24:40',b'1','扎赉特旗','152200'),
    ('152224','2016-08-09 12:24:40',b'1','突泉县','152200'),
    ('152500','2016-08-09 12:24:40',b'1','锡林郭勒盟','150000'),
    ('152501','2016-08-09 12:24:40',b'1','二连浩特市','152500'),
    ('152502','2016-08-09 12:24:40',b'1','锡林浩特市','152500'),
    ('152522','2016-08-09 12:24:40',b'1','阿巴嘎旗','152500'),
    ('152523','2016-08-09 12:24:40',b'1','苏尼特左旗','152500'),
    ('152524','2016-08-09 12:24:40',b'1','苏尼特右旗','152500'),
    ('152525','2016-08-09 12:24:40',b'1','东乌珠穆沁旗','152500'),
    ('152526','2016-08-09 12:24:40',b'1','西乌珠穆沁旗','152500'),
    ('152527','2016-08-09 12:24:40',b'1','太仆寺旗','152500'),
    ('152528','2016-08-09 12:24:40',b'1','镶黄旗','152500'),
    ('152529','2016-08-09 12:24:40',b'1','正镶白旗','152500'),
    ('152530','2016-08-09 12:24:40',b'1','正蓝旗','152500'),
    ('152531','2016-08-09 12:24:40',b'1','多伦县','152500'),
    ('152900','2016-08-09 12:24:40',b'1','阿拉善盟','150000'),
    ('152921','2016-08-09 12:24:40',b'1','阿拉善左旗','152900'),
    ('152922','2016-08-09 12:24:40',b'1','阿拉善右旗','152900'),
    ('152923','2016-08-09 12:24:40',b'1','额济纳旗','152900'),
    ('210000','2016-08-09 12:24:40',b'1','辽宁省','0'),
    ('210100','2016-08-09 12:24:40',b'1','沈阳市','210000'),
    ('210101','2016-08-09 12:24:40',b'1','市辖区','210100'),
    ('210102','2016-08-09 12:24:40',b'1','和平区','210100'),
    ('210103','2016-08-09 12:24:40',b'1','沈河区','210100'),
    ('210104','2016-08-09 12:24:40',b'1','大东区','210100'),
    ('210105','2016-08-09 12:24:40',b'1','皇姑区','210100'),
    ('210106','2016-08-09 12:24:40',b'1','铁西区','210100'),
    ('210111','2016-08-09 12:24:40',b'1','苏家屯区','210100'),
    ('210112','2016-08-09 12:24:40',b'1','东陵区','210100'),
    ('210113','2016-08-09 12:24:40',b'1','沈北新区','210100'),
    ('210114','2016-08-09 12:24:40',b'1','于洪区','210100'),
    ('210122','2016-08-09 12:24:40',b'1','辽中县','210100'),
    ('210123','2016-08-09 12:24:40',b'1','康平县','210100'),
    ('210124','2016-08-09 12:24:40',b'1','法库县','210100'),
    ('210181','2016-08-09 12:24:40',b'1','新民市','210100'),
    ('210200','2016-08-09 12:24:40',b'1','大连市','210000'),
    ('210201','2016-08-09 12:24:40',b'1','市辖区','210200'),
    ('210202','2016-08-09 12:24:40',b'1','中山区','210200'),
    ('210203','2016-08-09 12:24:40',b'1','西岗区','210200'),
    ('210204','2016-08-09 12:24:40',b'1','沙河口区','210200'),
    ('210211','2016-08-09 12:24:40',b'1','甘井子区','210200'),
    ('210212','2016-08-09 12:24:40',b'1','旅顺口区','210200'),
    ('210213','2016-08-09 12:24:40',b'1','金州区','210200'),
    ('210224','2016-08-09 12:24:40',b'1','长海县','210200'),
    ('210281','2016-08-09 12:24:40',b'1','瓦房店市','210200'),
    ('210282','2016-08-09 12:24:40',b'1','普兰店市','210200'),
    ('210283','2016-08-09 12:24:40',b'1','庄河市','210200'),
    ('210300','2016-08-09 12:24:40',b'1','鞍山市','210000'),
    ('210301','2016-08-09 12:24:40',b'1','市辖区','210300'),
    ('210302','2016-08-09 12:24:40',b'1','铁东区','210300'),
    ('210303','2016-08-09 12:24:40',b'1','铁西区','210300'),
    ('210304','2016-08-09 12:24:40',b'1','立山区','210300'),
    ('210311','2016-08-09 12:24:40',b'1','千山区','210300'),
    ('210321','2016-08-09 12:24:40',b'1','台安县','210300'),
    ('210323','2016-08-09 12:24:40',b'1','岫岩满族自治县','210300'),
    ('210381','2016-08-09 12:24:40',b'1','海城市','210300'),
    ('210400','2016-08-09 12:24:40',b'1','抚顺市','210000'),
    ('210401','2016-08-09 12:24:40',b'1','市辖区','210400'),
    ('210402','2016-08-09 12:24:40',b'1','新抚区','210400'),
    ('210403','2016-08-09 12:24:40',b'1','东洲区','210400'),
    ('210404','2016-08-09 12:24:40',b'1','望花区','210400'),
    ('210411','2016-08-09 12:24:40',b'1','顺城区','210400'),
    ('210421','2016-08-09 12:24:40',b'1','抚顺县','210400'),
    ('210422','2016-08-09 12:24:40',b'1','新宾满族自治县','210400'),
    ('210423','2016-08-09 12:24:40',b'1','清原满族自治县','210400'),
    ('210500','2016-08-09 12:24:40',b'1','本溪市','210000'),
    ('210501','2016-08-09 12:24:40',b'1','市辖区','210500'),
    ('210502','2016-08-09 12:24:40',b'1','平山区','210500'),
    ('210503','2016-08-09 12:24:40',b'1','溪湖区','210500'),
    ('210504','2016-08-09 12:24:40',b'1','明山区','210500'),
    ('210505','2016-08-09 12:24:40',b'1','南芬区','210500'),
    ('210521','2016-08-09 12:24:40',b'1','本溪满族自治县','210500'),
    ('210522','2016-08-09 12:24:40',b'1','桓仁满族自治县','210500'),
    ('210600','2016-08-09 12:24:40',b'1','丹东市','210000'),
    ('210601','2016-08-09 12:24:40',b'1','市辖区','210600'),
    ('210602','2016-08-09 12:24:40',b'1','元宝区','210600'),
    ('210603','2016-08-09 12:24:40',b'1','振兴区','210600'),
    ('210604','2016-08-09 12:24:40',b'1','振安区','210600'),
    ('210624','2016-08-09 12:24:40',b'1','宽甸满族自治县','210600'),
    ('210681','2016-08-09 12:24:40',b'1','东港市','210600'),
    ('210682','2016-08-09 12:24:40',b'1','凤城市','210600'),
    ('210700','2016-08-09 12:24:40',b'1','锦州市','210000'),
    ('210701','2016-08-09 12:24:40',b'1','市辖区','210700'),
    ('210702','2016-08-09 12:24:40',b'1','古塔区','210700'),
    ('210703','2016-08-09 12:24:40',b'1','凌河区','210700'),
    ('210711','2016-08-09 12:24:40',b'1','太和区','210700'),
    ('210726','2016-08-09 12:24:40',b'1','黑山县','210700'),
    ('210727','2016-08-09 12:24:40',b'1','义县','210700'),
    ('210781','2016-08-09 12:24:40',b'1','凌海市','210700'),
    ('210782','2016-08-09 12:24:40',b'1','北镇市','210700'),
    ('210800','2016-08-09 12:24:40',b'1','营口市','210000'),
    ('210801','2016-08-09 12:24:40',b'1','市辖区','210800'),
    ('210802','2016-08-09 12:24:40',b'1','站前区','210800'),
    ('210803','2016-08-09 12:24:40',b'1','西市区','210800'),
    ('210804','2016-08-09 12:24:40',b'1','鲅鱼圈区','210800'),
    ('210811','2016-08-09 12:24:40',b'1','老边区','210800'),
    ('210881','2016-08-09 12:24:40',b'1','盖州市','210800'),
    ('210882','2016-08-09 12:24:40',b'1','大石桥市','210800'),
    ('210900','2016-08-09 12:24:40',b'1','阜新市','210000'),
    ('210901','2016-08-09 12:24:40',b'1','市辖区','210900'),
    ('210902','2016-08-09 12:24:40',b'1','海州区','210900'),
    ('210903','2016-08-09 12:24:40',b'1','新邱区','210900'),
    ('210904','2016-08-09 12:24:40',b'1','太平区','210900'),
    ('210905','2016-08-09 12:24:40',b'1','清河门区','210900'),
    ('210911','2016-08-09 12:24:40',b'1','细河区','210900'),
    ('210921','2016-08-09 12:24:40',b'1','阜新蒙古族自治县','210900'),
    ('210922','2016-08-09 12:24:40',b'1','彰武县','210900'),
    ('211000','2016-08-09 12:24:40',b'1','辽阳市','210000'),
    ('211001','2016-08-09 12:24:40',b'1','市辖区','211000'),
    ('211002','2016-08-09 12:24:40',b'1','白塔区','211000'),
    ('211003','2016-08-09 12:24:40',b'1','文圣区','211000'),
    ('211004','2016-08-09 12:24:40',b'1','宏伟区','211000'),
    ('211005','2016-08-09 12:24:40',b'1','弓长岭区','211000'),
    ('211011','2016-08-09 12:24:40',b'1','太子河区','211000'),
    ('211021','2016-08-09 12:24:40',b'1','辽阳县','211000'),
    ('211081','2016-08-09 12:24:40',b'1','灯塔市','211000'),
    ('211100','2016-08-09 12:24:40',b'1','盘锦市','210000'),
    ('211101','2016-08-09 12:24:40',b'1','市辖区','211100'),
    ('211102','2016-08-09 12:24:40',b'1','双台子区','211100'),
    ('211103','2016-08-09 12:24:40',b'1','兴隆台区','211100'),
    ('211121','2016-08-09 12:24:40',b'1','大洼县','211100'),
    ('211122','2016-08-09 12:24:40',b'1','盘山县','211100'),
    ('211200','2016-08-09 12:24:40',b'1','铁岭市','210000'),
    ('211201','2016-08-09 12:24:40',b'1','市辖区','211200'),
    ('211202','2016-08-09 12:24:40',b'1','银州区','211200'),
    ('211204','2016-08-09 12:24:40',b'1','清河区','211200'),
    ('211221','2016-08-09 12:24:40',b'1','铁岭县','211200'),
    ('211223','2016-08-09 12:24:40',b'1','西丰县','211200'),
    ('211224','2016-08-09 12:24:40',b'1','昌图县','211200'),
    ('211281','2016-08-09 12:24:40',b'1','调兵山市','211200'),
    ('211282','2016-08-09 12:24:40',b'1','开原市','211200'),
    ('211300','2016-08-09 12:24:40',b'1','朝阳市','210000'),
    ('211301','2016-08-09 12:24:40',b'1','市辖区','211300'),
    ('211302','2016-08-09 12:24:40',b'1','双塔区','211300'),
    ('211303','2016-08-09 12:24:40',b'1','龙城区','211300'),
    ('211321','2016-08-09 12:24:40',b'1','朝阳县','211300'),
    ('211322','2016-08-09 12:24:40',b'1','建平县','211300'),
    ('211324','2016-08-09 12:24:40',b'1','喀喇沁左翼蒙古族自治县','211300'),
    ('211381','2016-08-09 12:24:40',b'1','北票市','211300'),
    ('211382','2016-08-09 12:24:40',b'1','凌源市','211300'),
    ('211400','2016-08-09 12:24:40',b'1','葫芦岛市','210000'),
    ('211401','2016-08-09 12:24:40',b'1','市辖区','211400'),
    ('211402','2016-08-09 12:24:40',b'1','连山区','211400'),
    ('211403','2016-08-09 12:24:40',b'1','龙港区','211400'),
    ('211404','2016-08-09 12:24:40',b'1','南票区','211400'),
    ('211421','2016-08-09 12:24:40',b'1','绥中县','211400'),
    ('211422','2016-08-09 12:24:40',b'1','建昌县','211400'),
    ('211481','2016-08-09 12:24:40',b'1','兴城市','211400'),
    ('220000','2016-08-09 12:24:40',b'1','吉林省','0'),
    ('220100','2016-08-09 12:24:40',b'1','长春市','220000'),
    ('220101','2016-08-09 12:24:40',b'1','市辖区','220100'),
    ('220102','2016-08-09 12:24:40',b'1','南关区','220100'),
    ('220103','2016-08-09 12:24:40',b'1','宽城区','220100'),
    ('220104','2016-08-09 12:24:40',b'1','朝阳区','220100'),
    ('220105','2016-08-09 12:24:40',b'1','二道区','220100'),
    ('220106','2016-08-09 12:24:40',b'1','绿园区','220100'),
    ('220112','2016-08-09 12:24:40',b'1','双阳区','220100'),
    ('220122','2016-08-09 12:24:40',b'1','农安县','220100'),
    ('220181','2016-08-09 12:24:40',b'1','九台市','220100'),
    ('220182','2016-08-09 12:24:40',b'1','榆树市','220100'),
    ('220183','2016-08-09 12:24:40',b'1','德惠市','220100'),
    ('220200','2016-08-09 12:24:40',b'1','吉林市','220000'),
    ('220201','2016-08-09 12:24:40',b'1','市辖区','220200'),
    ('220202','2016-08-09 12:24:40',b'1','昌邑区','220200'),
    ('220203','2016-08-09 12:24:40',b'1','龙潭区','220200'),
    ('220204','2016-08-09 12:24:40',b'1','船营区','220200'),
    ('220211','2016-08-09 12:24:40',b'1','丰满区','220200'),
    ('220221','2016-08-09 12:24:40',b'1','永吉县','220200'),
    ('220281','2016-08-09 12:24:40',b'1','蛟河市','220200'),
    ('220282','2016-08-09 12:24:40',b'1','桦甸市','220200'),
    ('220283','2016-08-09 12:24:40',b'1','舒兰市','220200'),
    ('220284','2016-08-09 12:24:40',b'1','磐石市','220200'),
    ('220300','2016-08-09 12:24:40',b'1','四平市','220000'),
    ('220301','2016-08-09 12:24:40',b'1','市辖区','220300'),
    ('220302','2016-08-09 12:24:40',b'1','铁西区','220300'),
    ('220303','2016-08-09 12:24:40',b'1','铁东区','220300'),
    ('220322','2016-08-09 12:24:40',b'1','梨树县','220300'),
    ('220323','2016-08-09 12:24:40',b'1','伊通满族自治县','220300'),
    ('220381','2016-08-09 12:24:40',b'1','公主岭市','220300'),
    ('220382','2016-08-09 12:24:40',b'1','双辽市','220300'),
    ('220400','2016-08-09 12:24:40',b'1','辽源市','220000'),
    ('220401','2016-08-09 12:24:40',b'1','市辖区','220400'),
    ('220402','2016-08-09 12:24:40',b'1','龙山区','220400'),
    ('220403','2016-08-09 12:24:40',b'1','西安区','220400'),
    ('220421','2016-08-09 12:24:40',b'1','东丰县','220400'),
    ('220422','2016-08-09 12:24:40',b'1','东辽县','220400'),
    ('220500','2016-08-09 12:24:40',b'1','通化市','220000'),
    ('220501','2016-08-09 12:24:40',b'1','市辖区','220500'),
    ('220502','2016-08-09 12:24:40',b'1','东昌区','220500'),
    ('220503','2016-08-09 12:24:40',b'1','二道江区','220500'),
    ('220521','2016-08-09 12:24:40',b'1','通化县','220500'),
    ('220523','2016-08-09 12:24:40',b'1','辉南县','220500'),
    ('220524','2016-08-09 12:24:40',b'1','柳河县','220500'),
    ('220581','2016-08-09 12:24:40',b'1','梅河口市','220500'),
    ('220582','2016-08-09 12:24:40',b'1','集安市','220500'),
    ('220600','2016-08-09 12:24:40',b'1','白山市','220000'),
    ('220601','2016-08-09 12:24:40',b'1','市辖区','220600'),
    ('220602','2016-08-09 12:24:40',b'1','八道江区','220600'),
    ('220605','2016-08-09 12:24:40',b'1','江源区','220600'),
    ('220621','2016-08-09 12:24:40',b'1','抚松县','220600'),
    ('220622','2016-08-09 12:24:40',b'1','靖宇县','220600'),
    ('220623','2016-08-09 12:24:40',b'1','长白朝鲜族自治县','220600'),
    ('220681','2016-08-09 12:24:40',b'1','临江市','220600'),
    ('220700','2016-08-09 12:24:40',b'1','松原市','220000'),
    ('220701','2016-08-09 12:24:40',b'1','市辖区','220700'),
    ('220702','2016-08-09 12:24:40',b'1','宁江区','220700'),
    ('220721','2016-08-09 12:24:40',b'1','前郭尔罗斯蒙古族自治县','220700'),
    ('220722','2016-08-09 12:24:40',b'1','长岭县','220700'),
    ('220723','2016-08-09 12:24:40',b'1','乾安县','220700'),
    ('220724','2016-08-09 12:24:40',b'1','扶余县','220700'),
    ('220800','2016-08-09 12:24:40',b'1','白城市','220000'),
    ('220801','2016-08-09 12:24:40',b'1','市辖区','220800'),
    ('220802','2016-08-09 12:24:40',b'1','洮北区','220800'),
    ('220821','2016-08-09 12:24:40',b'1','镇赉县','220800'),
    ('220822','2016-08-09 12:24:40',b'1','通榆县','220800'),
    ('220881','2016-08-09 12:24:40',b'1','洮南市','220800'),
    ('220882','2016-08-09 12:24:40',b'1','大安市','220800'),
    ('222400','2016-08-09 12:24:40',b'1','延边朝鲜族自治州','220000'),
    ('222401','2016-08-09 12:24:40',b'1','延吉市','222400'),
    ('222402','2016-08-09 12:24:40',b'1','图们市','222400'),
    ('222403','2016-08-09 12:24:40',b'1','敦化市','222400'),
    ('222404','2016-08-09 12:24:40',b'1','珲春市','222400'),
    ('222405','2016-08-09 12:24:40',b'1','龙井市','222400'),
    ('222406','2016-08-09 12:24:40',b'1','和龙市','222400'),
    ('222424','2016-08-09 12:24:40',b'1','汪清县','222400'),
    ('222426','2016-08-09 12:24:40',b'1','安图县','222400'),
    ('230000','2016-08-09 12:24:40',b'1','黑龙江省','0'),
    ('230100','2016-08-09 12:24:40',b'1','哈尔滨市','230000'),
    ('230101','2016-08-09 12:24:40',b'1','市辖区','230100'),
    ('230102','2016-08-09 12:24:40',b'1','道里区','230100'),
    ('230103','2016-08-09 12:24:40',b'1','南岗区','230100'),
    ('230104','2016-08-09 12:24:40',b'1','道外区','230100'),
    ('230108','2016-08-09 12:24:40',b'1','平房区','230100'),
    ('230109','2016-08-09 12:24:40',b'1','松北区','230100'),
    ('230110','2016-08-09 12:24:40',b'1','香坊区','230100'),
    ('230111','2016-08-09 12:24:40',b'1','呼兰区','230100'),
    ('230112','2016-08-09 12:24:40',b'1','阿城区','230100'),
    ('230123','2016-08-09 12:24:40',b'1','依兰县','230100'),
    ('230124','2016-08-09 12:24:40',b'1','方正县','230100'),
    ('230125','2016-08-09 12:24:40',b'1','宾县','230100'),
    ('230126','2016-08-09 12:24:40',b'1','巴彦县','230100'),
    ('230127','2016-08-09 12:24:40',b'1','木兰县','230100'),
    ('230128','2016-08-09 12:24:40',b'1','通河县','230100'),
    ('230129','2016-08-09 12:24:40',b'1','延寿县','230100'),
    ('230182','2016-08-09 12:24:40',b'1','双城市','230100'),
    ('230183','2016-08-09 12:24:40',b'1','尚志市','230100'),
    ('230184','2016-08-09 12:24:40',b'1','五常市','230100'),
    ('230200','2016-08-09 12:24:40',b'1','齐齐哈尔市','230000'),
    ('230201','2016-08-09 12:24:40',b'1','市辖区','230200'),
    ('230202','2016-08-09 12:24:40',b'1','龙沙区','230200'),
    ('230203','2016-08-09 12:24:40',b'1','建华区','230200'),
    ('230204','2016-08-09 12:24:40',b'1','铁锋区','230200'),
    ('230205','2016-08-09 12:24:40',b'1','昂昂溪区','230200'),
    ('230206','2016-08-09 12:24:40',b'1','富拉尔基区','230200'),
    ('230207','2016-08-09 12:24:40',b'1','碾子山区','230200'),
    ('230208','2016-08-09 12:24:40',b'1','梅里斯达斡尔族区','230200'),
    ('230221','2016-08-09 12:24:40',b'1','龙江县','230200'),
    ('230223','2016-08-09 12:24:40',b'1','依安县','230200'),
    ('230224','2016-08-09 12:24:40',b'1','泰来县','230200'),
    ('230225','2016-08-09 12:24:40',b'1','甘南县','230200'),
    ('230227','2016-08-09 12:24:40',b'1','富裕县','230200'),
    ('230229','2016-08-09 12:24:40',b'1','克山县','230200'),
    ('230230','2016-08-09 12:24:40',b'1','克东县','230200'),
    ('230231','2016-08-09 12:24:40',b'1','拜泉县','230200'),
    ('230281','2016-08-09 12:24:40',b'1','讷河市','230200'),
    ('230300','2016-08-09 12:24:40',b'1','鸡西市','230000'),
    ('230301','2016-08-09 12:24:40',b'1','市辖区','230300'),
    ('230302','2016-08-09 12:24:40',b'1','鸡冠区','230300'),
    ('230303','2016-08-09 12:24:40',b'1','恒山区','230300'),
    ('230304','2016-08-09 12:24:40',b'1','滴道区','230300'),
    ('230305','2016-08-09 12:24:40',b'1','梨树区','230300'),
    ('230306','2016-08-09 12:24:40',b'1','城子河区','230300'),
    ('230307','2016-08-09 12:24:40',b'1','麻山区','230300'),
    ('230321','2016-08-09 12:24:40',b'1','鸡东县','230300'),
    ('230381','2016-08-09 12:24:40',b'1','虎林市','230300'),
    ('230382','2016-08-09 12:24:40',b'1','密山市','230300'),
    ('230400','2016-08-09 12:24:40',b'1','鹤岗市','230000'),
    ('230401','2016-08-09 12:24:40',b'1','市辖区','230400'),
    ('230402','2016-08-09 12:24:40',b'1','向阳区','230400'),
    ('230403','2016-08-09 12:24:40',b'1','工农区','230400'),
    ('230404','2016-08-09 12:24:40',b'1','南山区','230400'),
    ('230405','2016-08-09 12:24:40',b'1','兴安区','230400'),
    ('230406','2016-08-09 12:24:40',b'1','东山区','230400'),
    ('230407','2016-08-09 12:24:40',b'1','兴山区','230400'),
    ('230421','2016-08-09 12:24:40',b'1','萝北县','230400'),
    ('230422','2016-08-09 12:24:40',b'1','绥滨县','230400'),
    ('230500','2016-08-09 12:24:40',b'1','双鸭山市','230000'),
    ('230501','2016-08-09 12:24:40',b'1','市辖区','230500'),
    ('230502','2016-08-09 12:24:40',b'1','尖山区','230500'),
    ('230503','2016-08-09 12:24:40',b'1','岭东区','230500'),
    ('230505','2016-08-09 12:24:40',b'1','四方台区','230500'),
    ('230506','2016-08-09 12:24:40',b'1','宝山区','230500'),
    ('230521','2016-08-09 12:24:40',b'1','集贤县','230500'),
    ('230522','2016-08-09 12:24:40',b'1','友谊县','230500'),
    ('230523','2016-08-09 12:24:40',b'1','宝清县','230500'),
    ('230524','2016-08-09 12:24:40',b'1','饶河县','230500'),
    ('230600','2016-08-09 12:24:40',b'1','大庆市','230000'),
    ('230601','2016-08-09 12:24:40',b'1','市辖区','230600'),
    ('230602','2016-08-09 12:24:40',b'1','萨尔图区','230600'),
    ('230603','2016-08-09 12:24:40',b'1','龙凤区','230600'),
    ('230604','2016-08-09 12:24:40',b'1','让胡路区','230600'),
    ('230605','2016-08-09 12:24:40',b'1','红岗区','230600'),
    ('230606','2016-08-09 12:24:40',b'1','大同区','230600'),
    ('230621','2016-08-09 12:24:40',b'1','肇州县','230600'),
    ('230622','2016-08-09 12:24:40',b'1','肇源县','230600'),
    ('230623','2016-08-09 12:24:40',b'1','林甸县','230600'),
    ('230624','2016-08-09 12:24:40',b'1','杜尔伯特蒙古族自治县','230600'),
    ('230700','2016-08-09 12:24:40',b'1','伊春市','230000'),
    ('230701','2016-08-09 12:24:40',b'1','市辖区','230700'),
    ('230702','2016-08-09 12:24:40',b'1','伊春区','230700'),
    ('230703','2016-08-09 12:24:40',b'1','南岔区','230700'),
    ('230704','2016-08-09 12:24:40',b'1','友好区','230700'),
    ('230705','2016-08-09 12:24:40',b'1','西林区','230700'),
    ('230706','2016-08-09 12:24:40',b'1','翠峦区','230700'),
    ('230707','2016-08-09 12:24:40',b'1','新青区','230700'),
    ('230708','2016-08-09 12:24:40',b'1','美溪区','230700'),
    ('230709','2016-08-09 12:24:40',b'1','金山屯区','230700'),
    ('230710','2016-08-09 12:24:40',b'1','五营区','230700'),
    ('230711','2016-08-09 12:24:40',b'1','乌马河区','230700'),
    ('230712','2016-08-09 12:24:40',b'1','汤旺河区','230700'),
    ('230713','2016-08-09 12:24:40',b'1','带岭区','230700'),
    ('230714','2016-08-09 12:24:40',b'1','乌伊岭区','230700'),
    ('230715','2016-08-09 12:24:40',b'1','红星区','230700'),
    ('230716','2016-08-09 12:24:40',b'1','上甘岭区','230700'),
    ('230722','2016-08-09 12:24:40',b'1','嘉荫县','230700'),
    ('230781','2016-08-09 12:24:40',b'1','铁力市','230700'),
    ('230800','2016-08-09 12:24:40',b'1','佳木斯市','230000'),
    ('230801','2016-08-09 12:24:40',b'1','市辖区','230800'),
    ('230803','2016-08-09 12:24:40',b'1','向阳区','230800'),
    ('230804','2016-08-09 12:24:40',b'1','前进区','230800'),
    ('230805','2016-08-09 12:24:40',b'1','东风区','230800'),
    ('230811','2016-08-09 12:24:40',b'1','郊区','230800'),
    ('230822','2016-08-09 12:24:40',b'1','桦南县','230800'),
    ('230826','2016-08-09 12:24:40',b'1','桦川县','230800'),
    ('230828','2016-08-09 12:24:40',b'1','汤原县','230800'),
    ('230833','2016-08-09 12:24:40',b'1','抚远县','230800'),
    ('230881','2016-08-09 12:24:40',b'1','同江市','230800'),
    ('230882','2016-08-09 12:24:40',b'1','富锦市','230800'),
    ('230900','2016-08-09 12:24:40',b'1','七台河市','230000'),
    ('230901','2016-08-09 12:24:40',b'1','市辖区','230900'),
    ('230902','2016-08-09 12:24:40',b'1','新兴区','230900'),
    ('230903','2016-08-09 12:24:40',b'1','桃山区','230900'),
    ('230904','2016-08-09 12:24:40',b'1','茄子河区','230900'),
    ('230921','2016-08-09 12:24:40',b'1','勃利县','230900'),
    ('231000','2016-08-09 12:24:40',b'1','牡丹江市','230000'),
    ('231001','2016-08-09 12:24:40',b'1','市辖区','231000'),
    ('231002','2016-08-09 12:24:40',b'1','东安区','231000'),
    ('231003','2016-08-09 12:24:40',b'1','阳明区','231000'),
    ('231004','2016-08-09 12:24:40',b'1','爱民区','231000'),
    ('231005','2016-08-09 12:24:40',b'1','西安区','231000'),
    ('231024','2016-08-09 12:24:40',b'1','东宁县','231000'),
    ('231025','2016-08-09 12:24:40',b'1','林口县','231000'),
    ('231081','2016-08-09 12:24:40',b'1','绥芬河市','231000'),
    ('231083','2016-08-09 12:24:40',b'1','海林市','231000'),
    ('231084','2016-08-09 12:24:40',b'1','宁安市','231000'),
    ('231085','2016-08-09 12:24:40',b'1','穆棱市','231000'),
    ('231100','2016-08-09 12:24:40',b'1','黑河市','230000'),
    ('231101','2016-08-09 12:24:40',b'1','市辖区','231100'),
    ('231102','2016-08-09 12:24:40',b'1','爱辉区','231100'),
    ('231121','2016-08-09 12:24:40',b'1','嫩江县','231100'),
    ('231123','2016-08-09 12:24:40',b'1','逊克县','231100'),
    ('231124','2016-08-09 12:24:40',b'1','孙吴县','231100'),
    ('231181','2016-08-09 12:24:40',b'1','北安市','231100'),
    ('231182','2016-08-09 12:24:40',b'1','五大连池市','231100'),
    ('231200','2016-08-09 12:24:40',b'1','绥化市','230000'),
    ('231201','2016-08-09 12:24:40',b'1','市辖区','231200'),
    ('231202','2016-08-09 12:24:40',b'1','北林区','231200'),
    ('231221','2016-08-09 12:24:40',b'1','望奎县','231200'),
    ('231222','2016-08-09 12:24:40',b'1','兰西县','231200'),
    ('231223','2016-08-09 12:24:40',b'1','青冈县','231200'),
    ('231224','2016-08-09 12:24:40',b'1','庆安县','231200'),
    ('231225','2016-08-09 12:24:40',b'1','明水县','231200'),
    ('231226','2016-08-09 12:24:40',b'1','绥棱县','231200'),
    ('231281','2016-08-09 12:24:40',b'1','安达市','231200'),
    ('231282','2016-08-09 12:24:40',b'1','肇东市','231200'),
    ('231283','2016-08-09 12:24:40',b'1','海伦市','231200'),
    ('232700','2016-08-09 12:24:40',b'1','大兴安岭地区','230000'),
    ('232721','2016-08-09 12:24:40',b'1','呼玛县','232700'),
    ('232722','2016-08-09 12:24:40',b'1','塔河县','232700'),
    ('232723','2016-08-09 12:24:40',b'1','漠河县','232700'),
    ('301000','2016-08-09 12:24:40',b'1','上海','0'),
    ('310000','2016-08-09 12:24:40',b'1','上海市','301000'),
    ('310100','2016-08-09 12:24:40',b'1','市辖区','310000'),
    ('310101','2016-08-09 12:24:40',b'1','黄浦区','310000'),
    ('310104','2016-08-09 12:24:40',b'1','徐汇区','310000'),
    ('310105','2016-08-09 12:24:40',b'1','长宁区','310000'),
    ('310106','2016-08-09 12:24:40',b'1','静安区','310000'),
    ('310107','2016-08-09 12:24:40',b'1','普陀区','310000'),
    ('310108','2016-08-09 12:24:40',b'1','闸北区','310000'),
    ('310109','2016-08-09 12:24:40',b'1','虹口区','310000'),
    ('310110','2016-08-09 12:24:40',b'1','杨浦区','310000'),
    ('310112','2016-08-09 12:24:40',b'1','闵行区','310000'),
    ('310113','2016-08-09 12:24:40',b'1','宝山区','310000'),
    ('310114','2016-08-09 12:24:40',b'1','嘉定区','310000'),
    ('310115','2016-08-09 12:24:40',b'1','浦东新区','310000'),
    ('310116','2016-08-09 12:24:40',b'1','金山区','310000'),
    ('310117','2016-08-09 12:24:40',b'1','松江区','310000'),
    ('310118','2016-08-09 12:24:40',b'1','青浦区','310000'),
    ('310120','2016-08-09 12:24:40',b'1','奉贤区','310000'),
    ('310200','2016-08-09 12:24:40',b'1','县','310000'),
    ('310230','2016-08-09 12:24:40',b'1','崇明县','310000'),
    ('320000','2016-08-09 12:24:40',b'1','江苏省','0'),
    ('320100','2016-08-09 12:24:40',b'1','南京市','320000'),
    ('320101','2016-08-09 12:24:40',b'1','市辖区','320100'),
    ('320102','2016-08-09 12:24:40',b'1','玄武区','320100'),
    ('320103','2016-08-09 12:24:40',b'1','白下区','320100'),
    ('320104','2016-08-09 12:24:40',b'1','秦淮区','320100'),
    ('320105','2016-08-09 12:24:40',b'1','建邺区','320100'),
    ('320106','2016-08-09 12:24:40',b'1','鼓楼区','320100'),
    ('320107','2016-08-09 12:24:40',b'1','下关区','320100'),
    ('320111','2016-08-09 12:24:40',b'1','浦口区','320100'),
    ('320113','2016-08-09 12:24:40',b'1','栖霞区','320100'),
    ('320114','2016-08-09 12:24:40',b'1','雨花台区','320100'),
    ('320115','2016-08-09 12:24:40',b'1','江宁区','320100'),
    ('320116','2016-08-09 12:24:40',b'1','六合区','320100'),
    ('320124','2016-08-09 12:24:40',b'1','溧水县','320100'),
    ('320125','2016-08-09 12:24:40',b'1','高淳县','320100'),
    ('320200','2016-08-09 12:24:40',b'1','无锡市','320000'),
    ('320201','2016-08-09 12:24:40',b'1','市辖区','320200'),
    ('320202','2016-08-09 12:24:40',b'1','崇安区','320200'),
    ('320203','2016-08-09 12:24:40',b'1','南长区','320200'),
    ('320204','2016-08-09 12:24:40',b'1','北塘区','320200'),
    ('320205','2016-08-09 12:24:40',b'1','锡山区','320200'),
    ('320206','2016-08-09 12:24:40',b'1','惠山区','320200'),
    ('320211','2016-08-09 12:24:40',b'1','滨湖区','320200'),
    ('320281','2016-08-09 12:24:40',b'1','江阴市','320200'),
    ('320282','2016-08-09 12:24:40',b'1','宜兴市','320200'),
    ('320300','2016-08-09 12:24:40',b'1','徐州市','320000'),
    ('320301','2016-08-09 12:24:40',b'1','市辖区','320300'),
    ('320302','2016-08-09 12:24:40',b'1','鼓楼区','320300'),
    ('320303','2016-08-09 12:24:40',b'1','云龙区','320300'),
    ('320305','2016-08-09 12:24:40',b'1','贾汪区','320300'),
    ('320311','2016-08-09 12:24:40',b'1','泉山区','320300'),
    ('320312','2016-08-09 12:24:40',b'1','铜山区','320300'),
    ('320321','2016-08-09 12:24:40',b'1','丰县','320300'),
    ('320322','2016-08-09 12:24:40',b'1','沛县','320300'),
    ('320324','2016-08-09 12:24:40',b'1','睢宁县','320300'),
    ('320381','2016-08-09 12:24:40',b'1','新沂市','320300'),
    ('320382','2016-08-09 12:24:40',b'1','邳州市','320300'),
    ('320400','2016-08-09 12:24:40',b'1','常州市','320000'),
    ('320401','2016-08-09 12:24:40',b'1','市辖区','320400'),
    ('320402','2016-08-09 12:24:40',b'1','天宁区','320400'),
    ('320404','2016-08-09 12:24:40',b'1','钟楼区','320400'),
    ('320405','2016-08-09 12:24:40',b'1','戚墅堰区','320400'),
    ('320411','2016-08-09 12:24:40',b'1','新北区','320400'),
    ('320412','2016-08-09 12:24:40',b'1','武进区','320400'),
    ('320481','2016-08-09 12:24:40',b'1','溧阳市','320400'),
    ('320482','2016-08-09 12:24:40',b'1','金坛市','320400'),
    ('320500','2016-08-09 12:24:40',b'1','苏州市','320000'),
    ('320501','2016-08-09 12:24:40',b'1','市辖区','320500'),
    ('320502','2016-08-09 12:24:40',b'1','沧浪区','320500'),
    ('320503','2016-08-09 12:24:40',b'1','平江区','320500'),
    ('320504','2016-08-09 12:24:40',b'1','金阊区','320500'),
    ('320505','2016-08-09 12:24:40',b'1','虎丘区','320500'),
    ('320506','2016-08-09 12:24:40',b'1','吴中区','320500'),
    ('320507','2016-08-09 12:24:40',b'1','相城区','320500'),
    ('320581','2016-08-09 12:24:40',b'1','常熟市','320500'),
    ('320582','2016-08-09 12:24:40',b'1','张家港市','320500'),
    ('320583','2016-08-09 12:24:40',b'1','昆山市','320500'),
    ('320584','2016-08-09 12:24:40',b'1','吴江市','320500'),
    ('320585','2016-08-09 12:24:40',b'1','太仓市','320500'),
    ('320600','2016-08-09 12:24:40',b'1','南通市','320000'),
    ('320601','2016-08-09 12:24:40',b'1','市辖区','320600'),
    ('320602','2016-08-09 12:24:40',b'1','崇川区','320600'),
    ('320611','2016-08-09 12:24:40',b'1','港闸区','320600'),
    ('320612','2016-08-09 12:24:40',b'1','通州区','320600'),
    ('320621','2016-08-09 12:24:40',b'1','海安县','320600'),
    ('320623','2016-08-09 12:24:40',b'1','如东县','320600'),
    ('320681','2016-08-09 12:24:40',b'1','启东市','320600'),
    ('320682','2016-08-09 12:24:40',b'1','如皋市','320600'),
    ('320684','2016-08-09 12:24:40',b'1','海门市','320600'),
    ('320700','2016-08-09 12:24:40',b'1','连云港市','320000'),
    ('320701','2016-08-09 12:24:40',b'1','市辖区','320700'),
    ('320703','2016-08-09 12:24:40',b'1','连云区','320700'),
    ('320705','2016-08-09 12:24:40',b'1','新浦区','320700'),
    ('320706','2016-08-09 12:24:40',b'1','海州区','320700'),
    ('320721','2016-08-09 12:24:40',b'1','赣榆县','320700'),
    ('320722','2016-08-09 12:24:40',b'1','东海县','320700'),
    ('320723','2016-08-09 12:24:40',b'1','灌云县','320700'),
    ('320724','2016-08-09 12:24:40',b'1','灌南县','320700'),
    ('320800','2016-08-09 12:24:40',b'1','淮安市','320000'),
    ('320801','2016-08-09 12:24:40',b'1','市辖区','320800'),
    ('320802','2016-08-09 12:24:40',b'1','清河区','320800'),
    ('320803','2016-08-09 12:24:40',b'1','楚州区','320800'),
    ('320804','2016-08-09 12:24:40',b'1','淮阴区','320800'),
    ('320811','2016-08-09 12:24:40',b'1','清浦区','320800'),
    ('320826','2016-08-09 12:24:40',b'1','涟水县','320800'),
    ('320829','2016-08-09 12:24:40',b'1','洪泽县','320800'),
    ('320830','2016-08-09 12:24:40',b'1','盱眙县','320800'),
    ('320831','2016-08-09 12:24:40',b'1','金湖县','320800'),
    ('320900','2016-08-09 12:24:40',b'1','盐城市','320000'),
    ('320901','2016-08-09 12:24:40',b'1','市辖区','320900'),
    ('320902','2016-08-09 12:24:40',b'1','亭湖区','320900'),
    ('320903','2016-08-09 12:24:40',b'1','盐都区','320900'),
    ('320921','2016-08-09 12:24:40',b'1','响水县','320900'),
    ('320922','2016-08-09 12:24:40',b'1','滨海县','320900'),
    ('320923','2016-08-09 12:24:40',b'1','阜宁县','320900'),
    ('320924','2016-08-09 12:24:40',b'1','射阳县','320900'),
    ('320925','2016-08-09 12:24:40',b'1','建湖县','320900'),
    ('320981','2016-08-09 12:24:40',b'1','东台市','320900'),
    ('320982','2016-08-09 12:24:40',b'1','大丰市','320900'),
    ('321000','2016-08-09 12:24:40',b'1','扬州市','320000'),
    ('321001','2016-08-09 12:24:40',b'1','市辖区','321000'),
    ('321002','2016-08-09 12:24:40',b'1','广陵区','321000'),
    ('321003','2016-08-09 12:24:40',b'1','邗江区','321000'),
    ('321012','2016-08-09 12:24:40',b'1','江都区','321000'),
    ('321023','2016-08-09 12:24:40',b'1','宝应县','321000'),
    ('321081','2016-08-09 12:24:40',b'1','仪征市','321000'),
    ('321084','2016-08-09 12:24:40',b'1','高邮市','321000'),
    ('321100','2016-08-09 12:24:40',b'1','镇江市','320000'),
    ('321101','2016-08-09 12:24:40',b'1','市辖区','321100'),
    ('321102','2016-08-09 12:24:40',b'1','京口区','321100'),
    ('321111','2016-08-09 12:24:40',b'1','润州区','321100'),
    ('321112','2016-08-09 12:24:40',b'1','丹徒区','321100'),
    ('321181','2016-08-09 12:24:40',b'1','丹阳市','321100'),
    ('321182','2016-08-09 12:24:40',b'1','扬中市','321100'),
    ('321183','2016-08-09 12:24:40',b'1','句容市','321100'),
    ('321200','2016-08-09 12:24:40',b'1','泰州市','320000'),
    ('321201','2016-08-09 12:24:40',b'1','市辖区','321200'),
    ('321202','2016-08-09 12:24:40',b'1','海陵区','321200'),
    ('321203','2016-08-09 12:24:40',b'1','高港区','321200'),
    ('321281','2016-08-09 12:24:40',b'1','兴化市','321200'),
    ('321282','2016-08-09 12:24:40',b'1','靖江市','321200'),
    ('321283','2016-08-09 12:24:40',b'1','泰兴市','321200'),
    ('321284','2016-08-09 12:24:40',b'1','姜堰市','321200'),
    ('321300','2016-08-09 12:24:40',b'1','宿迁市','320000'),
    ('321301','2016-08-09 12:24:40',b'1','市辖区','321300'),
    ('321302','2016-08-09 12:24:40',b'1','宿城区','321300'),
    ('321311','2016-08-09 12:24:40',b'1','宿豫区','321300'),
    ('321322','2016-08-09 12:24:40',b'1','沭阳县','321300'),
    ('321323','2016-08-09 12:24:40',b'1','泗阳县','321300'),
    ('321324','2016-08-09 12:24:40',b'1','泗洪县','321300'),
    ('330000','2016-08-09 12:24:40',b'1','浙江省','0'),
    ('330100','2016-08-09 12:24:40',b'1','杭州市','330000'),
    ('330101','2016-08-09 12:24:40',b'1','市辖区','330100'),
    ('330102','2016-08-09 12:24:40',b'1','上城区','330100'),
    ('330103','2016-08-09 12:24:40',b'1','下城区','330100'),
    ('330104','2016-08-09 12:24:40',b'1','江干区','330100'),
    ('330105','2016-08-09 12:24:40',b'1','拱墅区','330100'),
    ('330106','2016-08-09 12:24:40',b'1','西湖区','330100'),
    ('330108','2016-08-09 12:24:40',b'1','滨江区','330100'),
    ('330109','2016-08-09 12:24:40',b'1','萧山区','330100'),
    ('330110','2016-08-09 12:24:40',b'1','余杭区','330100'),
    ('330122','2016-08-09 12:24:40',b'1','桐庐县','330100'),
    ('330127','2016-08-09 12:24:40',b'1','淳安县','330100'),
    ('330182','2016-08-09 12:24:40',b'1','建德市','330100'),
    ('330183','2016-08-09 12:24:40',b'1','富阳市','330100'),
    ('330185','2016-08-09 12:24:40',b'1','临安市','330100'),
    ('330200','2016-08-09 12:24:40',b'1','宁波市','330000'),
    ('330201','2016-08-09 12:24:40',b'1','市辖区','330200'),
    ('330203','2016-08-09 12:24:40',b'1','海曙区','330200'),
    ('330204','2016-08-09 12:24:40',b'1','江东区','330200'),
    ('330205','2016-08-09 12:24:40',b'1','江北区','330200'),
    ('330206','2016-08-09 12:24:40',b'1','北仑区','330200'),
    ('330211','2016-08-09 12:24:40',b'1','镇海区','330200'),
    ('330212','2016-08-09 12:24:40',b'1','鄞州区','330200'),
    ('330225','2016-08-09 12:24:40',b'1','象山县','330200'),
    ('330226','2016-08-09 12:24:40',b'1','宁海县','330200'),
    ('330281','2016-08-09 12:24:40',b'1','余姚市','330200'),
    ('330282','2016-08-09 12:24:40',b'1','慈溪市','330200'),
    ('330283','2016-08-09 12:24:40',b'1','奉化市','330200'),
    ('330300','2016-08-09 12:24:40',b'1','温州市','330000'),
    ('330301','2016-08-09 12:24:40',b'1','市辖区','330300'),
    ('330302','2016-08-09 12:24:40',b'1','鹿城区','330300'),
    ('330303','2016-08-09 12:24:40',b'1','龙湾区','330300'),
    ('330304','2016-08-09 12:24:40',b'1','瓯海区','330300'),
    ('330322','2016-08-09 12:24:40',b'1','洞头县','330300'),
    ('330324','2016-08-09 12:24:40',b'1','永嘉县','330300'),
    ('330326','2016-08-09 12:24:40',b'1','平阳县','330300'),
    ('330327','2016-08-09 12:24:40',b'1','苍南县','330300'),
    ('330328','2016-08-09 12:24:40',b'1','文成县','330300'),
    ('330329','2016-08-09 12:24:40',b'1','泰顺县','330300'),
    ('330381','2016-08-09 12:24:40',b'1','瑞安市','330300'),
    ('330382','2016-08-09 12:24:40',b'1','乐清市','330300'),
    ('330400','2016-08-09 12:24:40',b'1','嘉兴市','330000'),
    ('330401','2016-08-09 12:24:40',b'1','市辖区','330400'),
    ('330402','2016-08-09 12:24:40',b'1','南湖区','330400'),
    ('330411','2016-08-09 12:24:40',b'1','秀洲区','330400'),
    ('330421','2016-08-09 12:24:40',b'1','嘉善县','330400'),
    ('330424','2016-08-09 12:24:40',b'1','海盐县','330400'),
    ('330481','2016-08-09 12:24:40',b'1','海宁市','330400'),
    ('330482','2016-08-09 12:24:40',b'1','平湖市','330400'),
    ('330483','2016-08-09 12:24:40',b'1','桐乡市','330400'),
    ('330500','2016-08-09 12:24:40',b'1','湖州市','330000'),
    ('330501','2016-08-09 12:24:40',b'1','市辖区','330500'),
    ('330502','2016-08-09 12:24:40',b'1','吴兴区','330500'),
    ('330503','2016-08-09 12:24:40',b'1','南浔区','330500'),
    ('330521','2016-08-09 12:24:40',b'1','德清县','330500'),
    ('330522','2016-08-09 12:24:40',b'1','长兴县','330500'),
    ('330523','2016-08-09 12:24:40',b'1','安吉县','330500'),
    ('330600','2016-08-09 12:24:40',b'1','绍兴市','330000'),
    ('330601','2016-08-09 12:24:40',b'1','市辖区','330600'),
    ('330602','2016-08-09 12:24:40',b'1','越城区','330600'),
    ('330621','2016-08-09 12:24:40',b'1','绍兴县','330600'),
    ('330624','2016-08-09 12:24:40',b'1','新昌县','330600'),
    ('330681','2016-08-09 12:24:40',b'1','诸暨市','330600'),
    ('330682','2016-08-09 12:24:40',b'1','上虞市','330600'),
    ('330683','2016-08-09 12:24:40',b'1','嵊州市','330600'),
    ('330700','2016-08-09 12:24:40',b'1','金华市','330000'),
    ('330701','2016-08-09 12:24:40',b'1','市辖区','330700'),
    ('330702','2016-08-09 12:24:40',b'1','婺城区','330700'),
    ('330703','2016-08-09 12:24:40',b'1','金东区','330700'),
    ('330723','2016-08-09 12:24:40',b'1','武义县','330700'),
    ('330726','2016-08-09 12:24:40',b'1','浦江县','330700'),
    ('330727','2016-08-09 12:24:40',b'1','磐安县','330700'),
    ('330781','2016-08-09 12:24:40',b'1','兰溪市','330700'),
    ('330782','2016-08-09 12:24:40',b'1','义乌市','330700'),
    ('330783','2016-08-09 12:24:40',b'1','东阳市','330700'),
    ('330784','2016-08-09 12:24:40',b'1','永康市','330700'),
    ('330800','2016-08-09 12:24:40',b'1','衢州市','330000'),
    ('330801','2016-08-09 12:24:40',b'1','市辖区','330800'),
    ('330802','2016-08-09 12:24:40',b'1','柯城区','330800'),
    ('330803','2016-08-09 12:24:40',b'1','衢江区','330800'),
    ('330822','2016-08-09 12:24:40',b'1','常山县','330800'),
    ('330824','2016-08-09 12:24:40',b'1','开化县','330800'),
    ('330825','2016-08-09 12:24:40',b'1','龙游县','330800'),
    ('330881','2016-08-09 12:24:40',b'1','江山市','330800'),
    ('330900','2016-08-09 12:24:40',b'1','舟山市','330000'),
    ('330901','2016-08-09 12:24:40',b'1','市辖区','330900'),
    ('330902','2016-08-09 12:24:40',b'1','定海区','330900'),
    ('330903','2016-08-09 12:24:40',b'1','普陀区','330900'),
    ('330921','2016-08-09 12:24:40',b'1','岱山县','330900'),
    ('330922','2016-08-09 12:24:40',b'1','嵊泗县','330900'),
    ('331000','2016-08-09 12:24:40',b'1','台州市','330000'),
    ('331001','2016-08-09 12:24:40',b'1','市辖区','331000'),
    ('331002','2016-08-09 12:24:40',b'1','椒江区','331000'),
    ('331003','2016-08-09 12:24:40',b'1','黄岩区','331000'),
    ('331004','2016-08-09 12:24:40',b'1','路桥区','331000'),
    ('331021','2016-08-09 12:24:40',b'1','玉环县','331000'),
    ('331022','2016-08-09 12:24:40',b'1','三门县','331000'),
    ('331023','2016-08-09 12:24:40',b'1','天台县','331000'),
    ('331024','2016-08-09 12:24:40',b'1','仙居县','331000'),
    ('331081','2016-08-09 12:24:40',b'1','温岭市','331000'),
    ('331082','2016-08-09 12:24:40',b'1','临海市','331000'),
    ('331100','2016-08-09 12:24:40',b'1','丽水市','330000'),
    ('331101','2016-08-09 12:24:40',b'1','市辖区','331100'),
    ('331102','2016-08-09 12:24:40',b'1','莲都区','331100'),
    ('331121','2016-08-09 12:24:40',b'1','青田县','331100'),
    ('331122','2016-08-09 12:24:40',b'1','缙云县','331100'),
    ('331123','2016-08-09 12:24:40',b'1','遂昌县','331100'),
    ('331124','2016-08-09 12:24:40',b'1','松阳县','331100'),
    ('331125','2016-08-09 12:24:40',b'1','云和县','331100'),
    ('331126','2016-08-09 12:24:40',b'1','庆元县','331100'),
    ('331127','2016-08-09 12:24:40',b'1','景宁畲族自治县','331100'),
    ('331181','2016-08-09 12:24:40',b'1','龙泉市','331100'),
    ('340000','2016-08-09 12:24:40',b'1','安徽省','0'),
    ('340100','2016-08-09 12:24:40',b'1','合肥市','340000'),
    ('340101','2016-08-09 12:24:40',b'1','市辖区','340100'),
    ('340102','2016-08-09 12:24:40',b'1','瑶海区','340100'),
    ('340103','2016-08-09 12:24:40',b'1','庐阳区','340100'),
    ('340104','2016-08-09 12:24:40',b'1','蜀山区','340100'),
    ('340111','2016-08-09 12:24:40',b'1','包河区','340100'),
    ('340121','2016-08-09 12:24:40',b'1','长丰县','340100'),
    ('340122','2016-08-09 12:24:40',b'1','肥东县','340100'),
    ('340123','2016-08-09 12:24:40',b'1','肥西县','340100'),
    ('340124','2016-08-09 12:24:40',b'1','庐江县','340100'),
    ('340181','2016-08-09 12:24:40',b'1','巢湖市','340100'),
    ('340200','2016-08-09 12:24:40',b'1','芜湖市','340000'),
    ('340201','2016-08-09 12:24:40',b'1','市辖区','340200'),
    ('340202','2016-08-09 12:24:40',b'1','镜湖区','340200'),
    ('340203','2016-08-09 12:24:40',b'1','弋江区','340200'),
    ('340207','2016-08-09 12:24:40',b'1','鸠江区','340200'),
    ('340208','2016-08-09 12:24:40',b'1','三山区','340200'),
    ('340221','2016-08-09 12:24:40',b'1','芜湖县','340200'),
    ('340222','2016-08-09 12:24:40',b'1','繁昌县','340200'),
    ('340223','2016-08-09 12:24:40',b'1','南陵县','340200'),
    ('340225','2016-08-09 12:24:40',b'1','无为县','340200'),
    ('340300','2016-08-09 12:24:40',b'1','蚌埠市','340000'),
    ('340301','2016-08-09 12:24:40',b'1','市辖区','340300'),
    ('340302','2016-08-09 12:24:40',b'1','龙子湖区','340300'),
    ('340303','2016-08-09 12:24:40',b'1','蚌山区','340300'),
    ('340304','2016-08-09 12:24:40',b'1','禹会区','340300'),
    ('340311','2016-08-09 12:24:40',b'1','淮上区','340300'),
    ('340321','2016-08-09 12:24:40',b'1','怀远县','340300'),
    ('340322','2016-08-09 12:24:40',b'1','五河县','340300'),
    ('340323','2016-08-09 12:24:40',b'1','固镇县','340300'),
    ('340400','2016-08-09 12:24:40',b'1','淮南市','340000'),
    ('340401','2016-08-09 12:24:40',b'1','市辖区','340400'),
    ('340402','2016-08-09 12:24:40',b'1','大通区','340400'),
    ('340403','2016-08-09 12:24:40',b'1','田家庵区','340400'),
    ('340404','2016-08-09 12:24:40',b'1','谢家集区','340400'),
    ('340405','2016-08-09 12:24:40',b'1','八公山区','340400'),
    ('340406','2016-08-09 12:24:40',b'1','潘集区','340400'),
    ('340421','2016-08-09 12:24:40',b'1','凤台县','340400'),
    ('340500','2016-08-09 12:24:40',b'1','马鞍山市','340000'),
    ('340501','2016-08-09 12:24:40',b'1','市辖区','340500'),
    ('340502','2016-08-09 12:24:40',b'1','金家庄区','340500'),
    ('340503','2016-08-09 12:24:40',b'1','花山区','340500'),
    ('340504','2016-08-09 12:24:40',b'1','雨山区','340500'),
    ('340521','2016-08-09 12:24:40',b'1','当涂县','340500'),
    ('340522','2016-08-09 12:24:40',b'1','含山县','340500'),
    ('340523','2016-08-09 12:24:40',b'1','和县','340500'),
    ('340600','2016-08-09 12:24:40',b'1','淮北市','340000'),
    ('340601','2016-08-09 12:24:40',b'1','市辖区','340600'),
    ('340602','2016-08-09 12:24:40',b'1','杜集区','340600'),
    ('340603','2016-08-09 12:24:40',b'1','相山区','340600'),
    ('340604','2016-08-09 12:24:40',b'1','烈山区','340600'),
    ('340621','2016-08-09 12:24:40',b'1','濉溪县','340600'),
    ('340700','2016-08-09 12:24:40',b'1','铜陵市','340000'),
    ('340701','2016-08-09 12:24:40',b'1','市辖区','340700'),
    ('340702','2016-08-09 12:24:40',b'1','铜官山区','340700'),
    ('340703','2016-08-09 12:24:40',b'1','狮子山区','340700'),
    ('340711','2016-08-09 12:24:40',b'1','郊区','340700'),
    ('340721','2016-08-09 12:24:40',b'1','铜陵县','340700'),
    ('340800','2016-08-09 12:24:40',b'1','安庆市','340000'),
    ('340801','2016-08-09 12:24:40',b'1','市辖区','340800'),
    ('340802','2016-08-09 12:24:40',b'1','迎江区','340800'),
    ('340803','2016-08-09 12:24:40',b'1','大观区','340800'),
    ('340811','2016-08-09 12:24:40',b'1','宜秀区','340800'),
    ('340822','2016-08-09 12:24:40',b'1','怀宁县','340800'),
    ('340823','2016-08-09 12:24:40',b'1','枞阳县','340800'),
    ('340824','2016-08-09 12:24:40',b'1','潜山县','340800'),
    ('340825','2016-08-09 12:24:40',b'1','太湖县','340800'),
    ('340826','2016-08-09 12:24:40',b'1','宿松县','340800'),
    ('340827','2016-08-09 12:24:40',b'1','望江县','340800'),
    ('340828','2016-08-09 12:24:40',b'1','岳西县','340800'),
    ('340881','2016-08-09 12:24:40',b'1','桐城市','340800'),
    ('341000','2016-08-09 12:24:40',b'1','黄山市','340000'),
    ('341001','2016-08-09 12:24:40',b'1','市辖区','341000'),
    ('341002','2016-08-09 12:24:40',b'1','屯溪区','341000'),
    ('341003','2016-08-09 12:24:40',b'1','黄山区','341000'),
    ('341004','2016-08-09 12:24:40',b'1','徽州区','341000'),
    ('341021','2016-08-09 12:24:40',b'1','歙县','341000'),
    ('341022','2016-08-09 12:24:40',b'1','休宁县','341000'),
    ('341023','2016-08-09 12:24:40',b'1','黟县','341000'),
    ('341024','2016-08-09 12:24:40',b'1','祁门县','341000'),
    ('341100','2016-08-09 12:24:40',b'1','滁州市','340000'),
    ('341101','2016-08-09 12:24:40',b'1','市辖区','341100'),
    ('341102','2016-08-09 12:24:40',b'1','琅琊区','341100'),
    ('341103','2016-08-09 12:24:40',b'1','南谯区','341100'),
    ('341122','2016-08-09 12:24:40',b'1','来安县','341100'),
    ('341124','2016-08-09 12:24:40',b'1','全椒县','341100'),
    ('341125','2016-08-09 12:24:40',b'1','定远县','341100'),
    ('341126','2016-08-09 12:24:40',b'1','凤阳县','341100'),
    ('341181','2016-08-09 12:24:40',b'1','天长市','341100'),
    ('341182','2016-08-09 12:24:40',b'1','明光市','341100'),
    ('341200','2016-08-09 12:24:40',b'1','阜阳市','340000'),
    ('341201','2016-08-09 12:24:40',b'1','市辖区','341200'),
    ('341202','2016-08-09 12:24:40',b'1','颍州区','341200'),
    ('341203','2016-08-09 12:24:40',b'1','颍东区','341200'),
    ('341204','2016-08-09 12:24:40',b'1','颍泉区','341200'),
    ('341221','2016-08-09 12:24:40',b'1','临泉县','341200'),
    ('341222','2016-08-09 12:24:40',b'1','太和县','341200'),
    ('341225','2016-08-09 12:24:40',b'1','阜南县','341200'),
    ('341226','2016-08-09 12:24:40',b'1','颍上县','341200'),
    ('341282','2016-08-09 12:24:40',b'1','界首市','341200'),
    ('341300','2016-08-09 12:24:40',b'1','宿州市','340000'),
    ('341301','2016-08-09 12:24:40',b'1','市辖区','341300'),
    ('341302','2016-08-09 12:24:40',b'1','埇桥区','341300'),
    ('341321','2016-08-09 12:24:40',b'1','砀山县','341300'),
    ('341322','2016-08-09 12:24:40',b'1','萧县','341300'),
    ('341323','2016-08-09 12:24:40',b'1','灵璧县','341300'),
    ('341324','2016-08-09 12:24:40',b'1','泗县','341300'),
    ('341500','2016-08-09 12:24:40',b'1','六安市','340000'),
    ('341501','2016-08-09 12:24:40',b'1','市辖区','341500'),
    ('341502','2016-08-09 12:24:40',b'1','金安区','341500'),
    ('341503','2016-08-09 12:24:40',b'1','裕安区','341500'),
    ('341521','2016-08-09 12:24:40',b'1','寿县','341500'),
    ('341522','2016-08-09 12:24:40',b'1','霍邱县','341500'),
    ('341523','2016-08-09 12:24:40',b'1','舒城县','341500'),
    ('341524','2016-08-09 12:24:40',b'1','金寨县','341500'),
    ('341525','2016-08-09 12:24:40',b'1','霍山县','341500'),
    ('341600','2016-08-09 12:24:40',b'1','亳州市','340000'),
    ('341601','2016-08-09 12:24:40',b'1','市辖区','341600'),
    ('341602','2016-08-09 12:24:40',b'1','谯城区','341600'),
    ('341621','2016-08-09 12:24:40',b'1','涡阳县','341600'),
    ('341622','2016-08-09 12:24:40',b'1','蒙城县','341600'),
    ('341623','2016-08-09 12:24:40',b'1','利辛县','341600'),
    ('341700','2016-08-09 12:24:40',b'1','池州市','340000'),
    ('341701','2016-08-09 12:24:40',b'1','市辖区','341700'),
    ('341702','2016-08-09 12:24:40',b'1','贵池区','341700'),
    ('341721','2016-08-09 12:24:40',b'1','东至县','341700'),
    ('341722','2016-08-09 12:24:40',b'1','石台县','341700'),
    ('341723','2016-08-09 12:24:40',b'1','青阳县','341700'),
    ('341800','2016-08-09 12:24:40',b'1','宣城市','340000'),
    ('341801','2016-08-09 12:24:40',b'1','市辖区','341800'),
    ('341802','2016-08-09 12:24:40',b'1','宣州区','341800'),
    ('341821','2016-08-09 12:24:40',b'1','郎溪县','341800'),
    ('341822','2016-08-09 12:24:40',b'1','广德县','341800'),
    ('341823','2016-08-09 12:24:40',b'1','泾县','341800'),
    ('341824','2016-08-09 12:24:40',b'1','绩溪县','341800'),
    ('341825','2016-08-09 12:24:40',b'1','旌德县','341800'),
    ('341881','2016-08-09 12:24:40',b'1','宁国市','341800'),
    ('350000','2016-08-09 12:24:40',b'1','福建省','0'),
    ('350100','2016-08-09 12:24:40',b'1','福州市','350000'),
    ('350101','2016-08-09 12:24:40',b'1','市辖区','350100'),
    ('350102','2016-08-09 12:24:40',b'1','鼓楼区','350100'),
    ('350103','2016-08-09 12:24:40',b'1','台江区','350100'),
    ('350104','2016-08-09 12:24:40',b'1','仓山区','350100'),
    ('350105','2016-08-09 12:24:40',b'1','马尾区','350100'),
    ('350111','2016-08-09 12:24:40',b'1','晋安区','350100'),
    ('350121','2016-08-09 12:24:40',b'1','闽侯县','350100'),
    ('350122','2016-08-09 12:24:40',b'1','连江县','350100'),
    ('350123','2016-08-09 12:24:40',b'1','罗源县','350100'),
    ('350124','2016-08-09 12:24:40',b'1','闽清县','350100'),
    ('350125','2016-08-09 12:24:40',b'1','永泰县','350100'),
    ('350128','2016-08-09 12:24:40',b'1','平潭县','350100'),
    ('350181','2016-08-09 12:24:40',b'1','福清市','350100'),
    ('350182','2016-08-09 12:24:40',b'1','长乐市','350100'),
    ('350200','2016-08-09 12:24:40',b'1','厦门市','350000'),
    ('350201','2016-08-09 12:24:40',b'1','市辖区','350200'),
    ('350203','2016-08-09 12:24:40',b'1','思明区','350200'),
    ('350205','2016-08-09 12:24:40',b'1','海沧区','350200'),
    ('350206','2016-08-09 12:24:40',b'1','湖里区','350200'),
    ('350211','2016-08-09 12:24:40',b'1','集美区','350200'),
    ('350212','2016-08-09 12:24:40',b'1','同安区','350200'),
    ('350213','2016-08-09 12:24:40',b'1','翔安区','350200'),
    ('350300','2016-08-09 12:24:40',b'1','莆田市','350000'),
    ('350301','2016-08-09 12:24:40',b'1','市辖区','350300'),
    ('350302','2016-08-09 12:24:40',b'1','城厢区','350300'),
    ('350303','2016-08-09 12:24:40',b'1','涵江区','350300'),
    ('350304','2016-08-09 12:24:40',b'1','荔城区','350300'),
    ('350305','2016-08-09 12:24:40',b'1','秀屿区','350300'),
    ('350322','2016-08-09 12:24:40',b'1','仙游县','350300'),
    ('350400','2016-08-09 12:24:40',b'1','三明市','350000'),
    ('350401','2016-08-09 12:24:40',b'1','市辖区','350400'),
    ('350402','2016-08-09 12:24:40',b'1','梅列区','350400'),
    ('350403','2016-08-09 12:24:40',b'1','三元区','350400'),
    ('350421','2016-08-09 12:24:40',b'1','明溪县','350400'),
    ('350423','2016-08-09 12:24:40',b'1','清流县','350400'),
    ('350424','2016-08-09 12:24:40',b'1','宁化县','350400'),
    ('350425','2016-08-09 12:24:40',b'1','大田县','350400'),
    ('350426','2016-08-09 12:24:40',b'1','尤溪县','350400'),
    ('350427','2016-08-09 12:24:40',b'1','沙县','350400'),
    ('350428','2016-08-09 12:24:40',b'1','将乐县','350400'),
    ('350429','2016-08-09 12:24:40',b'1','泰宁县','350400'),
    ('350430','2016-08-09 12:24:40',b'1','建宁县','350400'),
    ('350481','2016-08-09 12:24:40',b'1','永安市','350400'),
    ('350500','2016-08-09 12:24:40',b'1','泉州市','350000'),
    ('350501','2016-08-09 12:24:40',b'1','市辖区','350500'),
    ('350502','2016-08-09 12:24:40',b'1','鲤城区','350500'),
    ('350503','2016-08-09 12:24:40',b'1','丰泽区','350500'),
    ('350504','2016-08-09 12:24:40',b'1','洛江区','350500'),
    ('350505','2016-08-09 12:24:40',b'1','泉港区','350500'),
    ('350521','2016-08-09 12:24:40',b'1','惠安县','350500'),
    ('350524','2016-08-09 12:24:40',b'1','安溪县','350500'),
    ('350525','2016-08-09 12:24:40',b'1','永春县','350500'),
    ('350526','2016-08-09 12:24:40',b'1','德化县','350500'),
    ('350527','2016-08-09 12:24:40',b'1','金门县','350500'),
    ('350581','2016-08-09 12:24:40',b'1','石狮市','350500'),
    ('350582','2016-08-09 12:24:40',b'1','晋江市','350500'),
    ('350583','2016-08-09 12:24:40',b'1','南安市','350500'),
    ('350600','2016-08-09 12:24:40',b'1','漳州市','350000'),
    ('350601','2016-08-09 12:24:40',b'1','市辖区','350600'),
    ('350602','2016-08-09 12:24:40',b'1','芗城区','350600'),
    ('350603','2016-08-09 12:24:40',b'1','龙文区','350600'),
    ('350622','2016-08-09 12:24:40',b'1','云霄县','350600'),
    ('350623','2016-08-09 12:24:40',b'1','漳浦县','350600'),
    ('350624','2016-08-09 12:24:40',b'1','诏安县','350600'),
    ('350625','2016-08-09 12:24:40',b'1','长泰县','350600'),
    ('350626','2016-08-09 12:24:40',b'1','东山县','350600'),
    ('350627','2016-08-09 12:24:40',b'1','南靖县','350600'),
    ('350628','2016-08-09 12:24:40',b'1','平和县','350600'),
    ('350629','2016-08-09 12:24:40',b'1','华安县','350600'),
    ('350681','2016-08-09 12:24:40',b'1','龙海市','350600'),
    ('350700','2016-08-09 12:24:40',b'1','南平市','350000'),
    ('350701','2016-08-09 12:24:40',b'1','市辖区','350700'),
    ('350702','2016-08-09 12:24:40',b'1','延平区','350700'),
    ('350721','2016-08-09 12:24:40',b'1','顺昌县','350700'),
    ('350722','2016-08-09 12:24:40',b'1','浦城县','350700'),
    ('350723','2016-08-09 12:24:40',b'1','光泽县','350700'),
    ('350724','2016-08-09 12:24:40',b'1','松溪县','350700'),
    ('350725','2016-08-09 12:24:40',b'1','政和县','350700'),
    ('350781','2016-08-09 12:24:40',b'1','邵武市','350700'),
    ('350782','2016-08-09 12:24:40',b'1','武夷山市','350700'),
    ('350783','2016-08-09 12:24:40',b'1','建瓯市','350700'),
    ('350784','2016-08-09 12:24:40',b'1','建阳市','350700'),
    ('350800','2016-08-09 12:24:40',b'1','龙岩市','350000'),
    ('350801','2016-08-09 12:24:40',b'1','市辖区','350800'),
    ('350802','2016-08-09 12:24:40',b'1','新罗区','350800'),
    ('350821','2016-08-09 12:24:40',b'1','长汀县','350800'),
    ('350822','2016-08-09 12:24:40',b'1','永定县','350800'),
    ('350823','2016-08-09 12:24:40',b'1','上杭县','350800'),
    ('350824','2016-08-09 12:24:40',b'1','武平县','350800'),
    ('350825','2016-08-09 12:24:40',b'1','连城县','350800'),
    ('350881','2016-08-09 12:24:40',b'1','漳平市','350800'),
    ('350900','2016-08-09 12:24:40',b'1','宁德市','350000'),
    ('350901','2016-08-09 12:24:40',b'1','市辖区','350900'),
    ('350902','2016-08-09 12:24:40',b'1','蕉城区','350900'),
    ('350921','2016-08-09 12:24:40',b'1','霞浦县','350900'),
    ('350922','2016-08-09 12:24:40',b'1','古田县','350900'),
    ('350923','2016-08-09 12:24:40',b'1','屏南县','350900'),
    ('350924','2016-08-09 12:24:40',b'1','寿宁县','350900'),
    ('350925','2016-08-09 12:24:40',b'1','周宁县','350900'),
    ('350926','2016-08-09 12:24:40',b'1','柘荣县','350900'),
    ('350981','2016-08-09 12:24:40',b'1','福安市','350900'),
    ('350982','2016-08-09 12:24:40',b'1','福鼎市','350900'),
    ('360000','2016-08-09 12:24:40',b'1','江西省','0'),
    ('360100','2016-08-09 12:24:40',b'1','南昌市','360000'),
    ('360101','2016-08-09 12:24:40',b'1','市辖区','360100'),
    ('360102','2016-08-09 12:24:40',b'1','东湖区','360100'),
    ('360103','2016-08-09 12:24:40',b'1','西湖区','360100'),
    ('360104','2016-08-09 12:24:40',b'1','青云谱区','360100'),
    ('360105','2016-08-09 12:24:40',b'1','湾里区','360100'),
    ('360111','2016-08-09 12:24:40',b'1','青山湖区','360100'),
    ('360121','2016-08-09 12:24:40',b'1','南昌县','360100'),
    ('360122','2016-08-09 12:24:40',b'1','新建县','360100'),
    ('360123','2016-08-09 12:24:40',b'1','安义县','360100'),
    ('360124','2016-08-09 12:24:40',b'1','进贤县','360100'),
    ('360200','2016-08-09 12:24:40',b'1','景德镇市','360000'),
    ('360201','2016-08-09 12:24:40',b'1','市辖区','360200'),
    ('360202','2016-08-09 12:24:40',b'1','昌江区','360200'),
    ('360203','2016-08-09 12:24:40',b'1','珠山区','360200'),
    ('360222','2016-08-09 12:24:40',b'1','浮梁县','360200'),
    ('360281','2016-08-09 12:24:40',b'1','乐平市','360200'),
    ('360300','2016-08-09 12:24:40',b'1','萍乡市','360000'),
    ('360301','2016-08-09 12:24:40',b'1','市辖区','360300'),
    ('360302','2016-08-09 12:24:40',b'1','安源区','360300'),
    ('360313','2016-08-09 12:24:40',b'1','湘东区','360300'),
    ('360321','2016-08-09 12:24:40',b'1','莲花县','360300'),
    ('360322','2016-08-09 12:24:40',b'1','上栗县','360300'),
    ('360323','2016-08-09 12:24:40',b'1','芦溪县','360300'),
    ('360400','2016-08-09 12:24:40',b'1','九江市','360000'),
    ('360401','2016-08-09 12:24:40',b'1','市辖区','360400'),
    ('360402','2016-08-09 12:24:40',b'1','庐山区','360400'),
    ('360403','2016-08-09 12:24:40',b'1','浔阳区','360400'),
    ('360421','2016-08-09 12:24:40',b'1','九江县','360400'),
    ('360423','2016-08-09 12:24:40',b'1','武宁县','360400'),
    ('360424','2016-08-09 12:24:40',b'1','修水县','360400'),
    ('360425','2016-08-09 12:24:40',b'1','永修县','360400'),
    ('360426','2016-08-09 12:24:40',b'1','德安县','360400'),
    ('360427','2016-08-09 12:24:40',b'1','星子县','360400'),
    ('360428','2016-08-09 12:24:40',b'1','都昌县','360400'),
    ('360429','2016-08-09 12:24:40',b'1','湖口县','360400'),
    ('360430','2016-08-09 12:24:40',b'1','彭泽县','360400'),
    ('360481','2016-08-09 12:24:40',b'1','瑞昌市','360400'),
    ('360482','2016-08-09 12:24:40',b'1','共青城市','360400'),
    ('360500','2016-08-09 12:24:40',b'1','新余市','360000'),
    ('360501','2016-08-09 12:24:40',b'1','市辖区','360500'),
    ('360502','2016-08-09 12:24:40',b'1','渝水区','360500'),
    ('360521','2016-08-09 12:24:40',b'1','分宜县','360500'),
    ('360600','2016-08-09 12:24:40',b'1','鹰潭市','360000'),
    ('360601','2016-08-09 12:24:40',b'1','市辖区','360600'),
    ('360602','2016-08-09 12:24:40',b'1','月湖区','360600'),
    ('360622','2016-08-09 12:24:40',b'1','余江县','360600'),
    ('360681','2016-08-09 12:24:40',b'1','贵溪市','360600'),
    ('360700','2016-08-09 12:24:40',b'1','赣州市','360000'),
    ('360701','2016-08-09 12:24:40',b'1','市辖区','360700'),
    ('360702','2016-08-09 12:24:40',b'1','章贡区','360700'),
    ('360721','2016-08-09 12:24:40',b'1','赣县','360700'),
    ('360722','2016-08-09 12:24:40',b'1','信丰县','360700'),
    ('360723','2016-08-09 12:24:40',b'1','大余县','360700'),
    ('360724','2016-08-09 12:24:40',b'1','上犹县','360700'),
    ('360725','2016-08-09 12:24:40',b'1','崇义县','360700'),
    ('360726','2016-08-09 12:24:40',b'1','安远县','360700'),
    ('360727','2016-08-09 12:24:40',b'1','龙南县','360700'),
    ('360728','2016-08-09 12:24:40',b'1','定南县','360700'),
    ('360729','2016-08-09 12:24:40',b'1','全南县','360700'),
    ('360730','2016-08-09 12:24:40',b'1','宁都县','360700'),
    ('360731','2016-08-09 12:24:40',b'1','于都县','360700'),
    ('360732','2016-08-09 12:24:40',b'1','兴国县','360700'),
    ('360733','2016-08-09 12:24:40',b'1','会昌县','360700'),
    ('360734','2016-08-09 12:24:40',b'1','寻乌县','360700'),
    ('360735','2016-08-09 12:24:40',b'1','石城县','360700'),
    ('360781','2016-08-09 12:24:40',b'1','瑞金市','360700'),
    ('360782','2016-08-09 12:24:40',b'1','南康市','360700'),
    ('360800','2016-08-09 12:24:40',b'1','吉安市','360000'),
    ('360801','2016-08-09 12:24:40',b'1','市辖区','360800'),
    ('360802','2016-08-09 12:24:40',b'1','吉州区','360800'),
    ('360803','2016-08-09 12:24:40',b'1','青原区','360800'),
    ('360821','2016-08-09 12:24:40',b'1','吉安县','360800'),
    ('360822','2016-08-09 12:24:40',b'1','吉水县','360800'),
    ('360823','2016-08-09 12:24:40',b'1','峡江县','360800'),
    ('360824','2016-08-09 12:24:40',b'1','新干县','360800'),
    ('360825','2016-08-09 12:24:40',b'1','永丰县','360800'),
    ('360826','2016-08-09 12:24:40',b'1','泰和县','360800'),
    ('360827','2016-08-09 12:24:40',b'1','遂川县','360800'),
    ('360828','2016-08-09 12:24:40',b'1','万安县','360800'),
    ('360829','2016-08-09 12:24:40',b'1','安福县','360800'),
    ('360830','2016-08-09 12:24:40',b'1','永新县','360800'),
    ('360881','2016-08-09 12:24:40',b'1','井冈山市','360800'),
    ('360900','2016-08-09 12:24:40',b'1','宜春市','360000'),
    ('360901','2016-08-09 12:24:40',b'1','市辖区','360900'),
    ('360902','2016-08-09 12:24:40',b'1','袁州区','360900'),
    ('360921','2016-08-09 12:24:40',b'1','奉新县','360900'),
    ('360922','2016-08-09 12:24:40',b'1','万载县','360900'),
    ('360923','2016-08-09 12:24:40',b'1','上高县','360900'),
    ('360924','2016-08-09 12:24:40',b'1','宜丰县','360900'),
    ('360925','2016-08-09 12:24:40',b'1','靖安县','360900'),
    ('360926','2016-08-09 12:24:40',b'1','铜鼓县','360900'),
    ('360981','2016-08-09 12:24:40',b'1','丰城市','360900'),
    ('360982','2016-08-09 12:24:40',b'1','樟树市','360900'),
    ('360983','2016-08-09 12:24:40',b'1','高安市','360900'),
    ('361000','2016-08-09 12:24:40',b'1','抚州市','360000'),
    ('361001','2016-08-09 12:24:40',b'1','市辖区','361000'),
    ('361002','2016-08-09 12:24:40',b'1','临川区','361000'),
    ('361021','2016-08-09 12:24:40',b'1','南城县','361000'),
    ('361022','2016-08-09 12:24:40',b'1','黎川县','361000'),
    ('361023','2016-08-09 12:24:40',b'1','南丰县','361000'),
    ('361024','2016-08-09 12:24:40',b'1','崇仁县','361000'),
    ('361025','2016-08-09 12:24:40',b'1','乐安县','361000'),
    ('361026','2016-08-09 12:24:40',b'1','宜黄县','361000'),
    ('361027','2016-08-09 12:24:40',b'1','金溪县','361000'),
    ('361028','2016-08-09 12:24:40',b'1','资溪县','361000'),
    ('361029','2016-08-09 12:24:40',b'1','东乡县','361000'),
    ('361030','2016-08-09 12:24:40',b'1','广昌县','361000'),
    ('361100','2016-08-09 12:24:40',b'1','上饶市','360000'),
    ('361101','2016-08-09 12:24:40',b'1','市辖区','361100'),
    ('361102','2016-08-09 12:24:40',b'1','信州区','361100'),
    ('361121','2016-08-09 12:24:40',b'1','上饶县','361100'),
    ('361122','2016-08-09 12:24:40',b'1','广丰县','361100'),
    ('361123','2016-08-09 12:24:40',b'1','玉山县','361100'),
    ('361124','2016-08-09 12:24:40',b'1','铅山县','361100'),
    ('361125','2016-08-09 12:24:40',b'1','横峰县','361100'),
    ('361126','2016-08-09 12:24:40',b'1','弋阳县','361100'),
    ('361127','2016-08-09 12:24:40',b'1','余干县','361100'),
    ('361128','2016-08-09 12:24:40',b'1','鄱阳县','361100'),
    ('361129','2016-08-09 12:24:40',b'1','万年县','361100'),
    ('361130','2016-08-09 12:24:40',b'1','婺源县','361100'),
    ('361181','2016-08-09 12:24:40',b'1','德兴市','361100'),
    ('370000','2016-08-09 12:24:40',b'1','山东省','0'),
    ('370100','2016-08-09 12:24:40',b'1','济南市','370000'),
    ('370101','2016-08-09 12:24:40',b'1','市辖区','370100'),
    ('370102','2016-08-09 12:24:40',b'1','历下区','370100'),
    ('370103','2016-08-09 12:24:40',b'1','市中区','370100'),
    ('370104','2016-08-09 12:24:40',b'1','槐荫区','370100'),
    ('370105','2016-08-09 12:24:40',b'1','天桥区','370100'),
    ('370112','2016-08-09 12:24:40',b'1','历城区','370100'),
    ('370113','2016-08-09 12:24:40',b'1','长清区','370100'),
    ('370124','2016-08-09 12:24:40',b'1','平阴县','370100'),
    ('370125','2016-08-09 12:24:40',b'1','济阳县','370100'),
    ('370126','2016-08-09 12:24:40',b'1','商河县','370100'),
    ('370181','2016-08-09 12:24:40',b'1','章丘市','370100'),
    ('370200','2016-08-09 12:24:40',b'1','青岛市','370000'),
    ('370201','2016-08-09 12:24:40',b'1','市辖区','370200'),
    ('370202','2016-08-09 12:24:40',b'1','市南区','370200'),
    ('370203','2016-08-09 12:24:40',b'1','市北区','370200'),
    ('370205','2016-08-09 12:24:40',b'1','四方区','370200'),
    ('370211','2016-08-09 12:24:40',b'1','黄岛区','370200'),
    ('370212','2016-08-09 12:24:40',b'1','崂山区','370200'),
    ('370213','2016-08-09 12:24:40',b'1','李沧区','370200'),
    ('370214','2016-08-09 12:24:40',b'1','城阳区','370200'),
    ('370281','2016-08-09 12:24:40',b'1','胶州市','370200'),
    ('370282','2016-08-09 12:24:40',b'1','即墨市','370200'),
    ('370283','2016-08-09 12:24:40',b'1','平度市','370200'),
    ('370284','2016-08-09 12:24:40',b'1','胶南市','370200'),
    ('370285','2016-08-09 12:24:40',b'1','莱西市','370200'),
    ('370300','2016-08-09 12:24:40',b'1','淄博市','370000'),
    ('370301','2016-08-09 12:24:40',b'1','市辖区','370300'),
    ('370302','2016-08-09 12:24:40',b'1','淄川区','370300'),
    ('370303','2016-08-09 12:24:40',b'1','张店区','370300'),
    ('370304','2016-08-09 12:24:40',b'1','博山区','370300'),
    ('370305','2016-08-09 12:24:40',b'1','临淄区','370300'),
    ('370306','2016-08-09 12:24:40',b'1','周村区','370300'),
    ('370321','2016-08-09 12:24:40',b'1','桓台县','370300'),
    ('370322','2016-08-09 12:24:40',b'1','高青县','370300'),
    ('370323','2016-08-09 12:24:40',b'1','沂源县','370300'),
    ('370400','2016-08-09 12:24:40',b'1','枣庄市','370000'),
    ('370401','2016-08-09 12:24:40',b'1','市辖区','370400'),
    ('370402','2016-08-09 12:24:40',b'1','市中区','370400'),
    ('370403','2016-08-09 12:24:40',b'1','薛城区','370400'),
    ('370404','2016-08-09 12:24:40',b'1','峄城区','370400'),
    ('370405','2016-08-09 12:24:40',b'1','台儿庄区','370400'),
    ('370406','2016-08-09 12:24:40',b'1','山亭区','370400'),
    ('370481','2016-08-09 12:24:40',b'1','滕州市','370400'),
    ('370500','2016-08-09 12:24:40',b'1','东营市','370000'),
    ('370501','2016-08-09 12:24:40',b'1','市辖区','370500'),
    ('370502','2016-08-09 12:24:40',b'1','东营区','370500'),
    ('370503','2016-08-09 12:24:40',b'1','河口区','370500'),
    ('370521','2016-08-09 12:24:40',b'1','垦利县','370500'),
    ('370522','2016-08-09 12:24:40',b'1','利津县','370500'),
    ('370523','2016-08-09 12:24:40',b'1','广饶县','370500'),
    ('370600','2016-08-09 12:24:40',b'1','烟台市','370000'),
    ('370601','2016-08-09 12:24:40',b'1','市辖区','370600'),
    ('370602','2016-08-09 12:24:40',b'1','芝罘区','370600'),
    ('370611','2016-08-09 12:24:40',b'1','福山区','370600'),
    ('370612','2016-08-09 12:24:40',b'1','牟平区','370600'),
    ('370613','2016-08-09 12:24:40',b'1','莱山区','370600'),
    ('370634','2016-08-09 12:24:40',b'1','长岛县','370600'),
    ('370681','2016-08-09 12:24:40',b'1','龙口市','370600'),
    ('370682','2016-08-09 12:24:40',b'1','莱阳市','370600'),
    ('370683','2016-08-09 12:24:40',b'1','莱州市','370600'),
    ('370684','2016-08-09 12:24:40',b'1','蓬莱市','370600'),
    ('370685','2016-08-09 12:24:40',b'1','招远市','370600'),
    ('370686','2016-08-09 12:24:40',b'1','栖霞市','370600'),
    ('370687','2016-08-09 12:24:40',b'1','海阳市','370600'),
    ('370700','2016-08-09 12:24:40',b'1','潍坊市','370000'),
    ('370701','2016-08-09 12:24:40',b'1','市辖区','370700'),
    ('370702','2016-08-09 12:24:40',b'1','潍城区','370700'),
    ('370703','2016-08-09 12:24:40',b'1','寒亭区','370700'),
    ('370704','2016-08-09 12:24:40',b'1','坊子区','370700'),
    ('370705','2016-08-09 12:24:40',b'1','奎文区','370700'),
    ('370724','2016-08-09 12:24:40',b'1','临朐县','370700'),
    ('370725','2016-08-09 12:24:40',b'1','昌乐县','370700'),
    ('370781','2016-08-09 12:24:40',b'1','青州市','370700'),
    ('370782','2016-08-09 12:24:40',b'1','诸城市','370700'),
    ('370783','2016-08-09 12:24:40',b'1','寿光市','370700'),
    ('370784','2016-08-09 12:24:40',b'1','安丘市','370700'),
    ('370785','2016-08-09 12:24:40',b'1','高密市','370700'),
    ('370786','2016-08-09 12:24:40',b'1','昌邑市','370700'),
    ('370800','2016-08-09 12:24:40',b'1','济宁市','370000'),
    ('370801','2016-08-09 12:24:40',b'1','市辖区','370800'),
    ('370802','2016-08-09 12:24:40',b'1','市中区','370800'),
    ('370811','2016-08-09 12:24:40',b'1','任城区','370800'),
    ('370826','2016-08-09 12:24:40',b'1','微山县','370800'),
    ('370827','2016-08-09 12:24:40',b'1','鱼台县','370800'),
    ('370828','2016-08-09 12:24:40',b'1','金乡县','370800'),
    ('370829','2016-08-09 12:24:40',b'1','嘉祥县','370800'),
    ('370830','2016-08-09 12:24:40',b'1','汶上县','370800'),
    ('370831','2016-08-09 12:24:40',b'1','泗水县','370800'),
    ('370832','2016-08-09 12:24:40',b'1','梁山县','370800'),
    ('370881','2016-08-09 12:24:40',b'1','曲阜市','370800'),
    ('370882','2016-08-09 12:24:40',b'1','兖州市','370800'),
    ('370883','2016-08-09 12:24:40',b'1','邹城市','370800'),
    ('370900','2016-08-09 12:24:40',b'1','泰安市','370000'),
    ('370901','2016-08-09 12:24:40',b'1','市辖区','370900'),
    ('370902','2016-08-09 12:24:40',b'1','泰山区','370900'),
    ('370911','2016-08-09 12:24:40',b'1','岱岳区','370900'),
    ('370921','2016-08-09 12:24:40',b'1','宁阳县','370900'),
    ('370923','2016-08-09 12:24:40',b'1','东平县','370900'),
    ('370982','2016-08-09 12:24:40',b'1','新泰市','370900'),
    ('370983','2016-08-09 12:24:40',b'1','肥城市','370900'),
    ('371000','2016-08-09 12:24:40',b'1','威海市','370000'),
    ('371001','2016-08-09 12:24:40',b'1','市辖区','371000'),
    ('371002','2016-08-09 12:24:40',b'1','环翠区','371000'),
    ('371081','2016-08-09 12:24:40',b'1','文登市','371000'),
    ('371082','2016-08-09 12:24:40',b'1','荣成市','371000'),
    ('371083','2016-08-09 12:24:40',b'1','乳山市','371000'),
    ('371100','2016-08-09 12:24:40',b'1','日照市','370000'),
    ('371101','2016-08-09 12:24:40',b'1','市辖区','371100'),
    ('371102','2016-08-09 12:24:40',b'1','东港区','371100'),
    ('371103','2016-08-09 12:24:40',b'1','岚山区','371100'),
    ('371121','2016-08-09 12:24:40',b'1','五莲县','371100'),
    ('371122','2016-08-09 12:24:40',b'1','莒县','371100'),
    ('371200','2016-08-09 12:24:40',b'1','莱芜市','370000'),
    ('371201','2016-08-09 12:24:40',b'1','市辖区','371200'),
    ('371202','2016-08-09 12:24:40',b'1','莱城区','371200'),
    ('371203','2016-08-09 12:24:40',b'1','钢城区','371200'),
    ('371300','2016-08-09 12:24:40',b'1','临沂市','370000'),
    ('371301','2016-08-09 12:24:40',b'1','市辖区','371300'),
    ('371302','2016-08-09 12:24:40',b'1','兰山区','371300'),
    ('371311','2016-08-09 12:24:40',b'1','罗庄区','371300'),
    ('371312','2016-08-09 12:24:40',b'1','河东区','371300'),
    ('371321','2016-08-09 12:24:40',b'1','沂南县','371300'),
    ('371322','2016-08-09 12:24:40',b'1','郯城县','371300'),
    ('371323','2016-08-09 12:24:40',b'1','沂水县','371300'),
    ('371324','2016-08-09 12:24:40',b'1','苍山县','371300'),
    ('371325','2016-08-09 12:24:40',b'1','费县','371300'),
    ('371326','2016-08-09 12:24:40',b'1','平邑县','371300'),
    ('371327','2016-08-09 12:24:40',b'1','莒南县','371300'),
    ('371328','2016-08-09 12:24:40',b'1','蒙阴县','371300'),
    ('371329','2016-08-09 12:24:40',b'1','临沭县','371300'),
    ('371400','2016-08-09 12:24:40',b'1','德州市','370000'),
    ('371401','2016-08-09 12:24:40',b'1','市辖区','371400'),
    ('371402','2016-08-09 12:24:40',b'1','德城区','371400'),
    ('371421','2016-08-09 12:24:40',b'1','陵县','371400'),
    ('371422','2016-08-09 12:24:40',b'1','宁津县','371400'),
    ('371423','2016-08-09 12:24:40',b'1','庆云县','371400'),
    ('371424','2016-08-09 12:24:40',b'1','临邑县','371400'),
    ('371425','2016-08-09 12:24:40',b'1','齐河县','371400'),
    ('371426','2016-08-09 12:24:40',b'1','平原县','371400'),
    ('371427','2016-08-09 12:24:40',b'1','夏津县','371400'),
    ('371428','2016-08-09 12:24:40',b'1','武城县','371400'),
    ('371481','2016-08-09 12:24:40',b'1','乐陵市','371400'),
    ('371482','2016-08-09 12:24:40',b'1','禹城市','371400'),
    ('371500','2016-08-09 12:24:40',b'1','聊城市','370000'),
    ('371501','2016-08-09 12:24:40',b'1','市辖区','371500'),
    ('371502','2016-08-09 12:24:40',b'1','东昌府区','371500'),
    ('371521','2016-08-09 12:24:40',b'1','阳谷县','371500'),
    ('371522','2016-08-09 12:24:40',b'1','莘县','371500'),
    ('371523','2016-08-09 12:24:40',b'1','茌平县','371500'),
    ('371524','2016-08-09 12:24:40',b'1','东阿县','371500'),
    ('371525','2016-08-09 12:24:40',b'1','冠县','371500'),
    ('371526','2016-08-09 12:24:40',b'1','高唐县','371500'),
    ('371581','2016-08-09 12:24:40',b'1','临清市','371500'),
    ('371600','2016-08-09 12:24:40',b'1','滨州市','370000'),
    ('371601','2016-08-09 12:24:40',b'1','市辖区','371600'),
    ('371602','2016-08-09 12:24:40',b'1','滨城区','371600'),
    ('371621','2016-08-09 12:24:40',b'1','惠民县','371600'),
    ('371622','2016-08-09 12:24:40',b'1','阳信县','371600'),
    ('371623','2016-08-09 12:24:40',b'1','无棣县','371600'),
    ('371624','2016-08-09 12:24:40',b'1','沾化县','371600'),
    ('371625','2016-08-09 12:24:40',b'1','博兴县','371600'),
    ('371626','2016-08-09 12:24:40',b'1','邹平县','371600'),
    ('371700','2016-08-09 12:24:40',b'1','菏泽市','370000'),
    ('371701','2016-08-09 12:24:40',b'1','市辖区','371700'),
    ('371702','2016-08-09 12:24:40',b'1','牡丹区','371700'),
    ('371721','2016-08-09 12:24:40',b'1','曹县','371700'),
    ('371722','2016-08-09 12:24:40',b'1','单县','371700'),
    ('371723','2016-08-09 12:24:40',b'1','成武县','371700'),
    ('371724','2016-08-09 12:24:40',b'1','巨野县','371700'),
    ('371725','2016-08-09 12:24:40',b'1','郓城县','371700'),
    ('371726','2016-08-09 12:24:40',b'1','鄄城县','371700'),
    ('371727','2016-08-09 12:24:40',b'1','定陶县','371700'),
    ('371728','2016-08-09 12:24:40',b'1','东明县','371700'),
    ('410000','2016-08-09 12:24:40',b'1','河南省','0'),
    ('410100','2016-08-09 12:24:40',b'1','郑州市','410000'),
    ('410101','2016-08-09 12:24:40',b'1','市辖区','410100'),
    ('410102','2016-08-09 12:24:40',b'1','中原区','410100'),
    ('410103','2016-08-09 12:24:40',b'1','二七区','410100'),
    ('410104','2016-08-09 12:24:40',b'1','管城回族区','410100'),
    ('410105','2016-08-09 12:24:40',b'1','金水区','410100'),
    ('410106','2016-08-09 12:24:40',b'1','上街区','410100'),
    ('410108','2016-08-09 12:24:40',b'1','惠济区','410100'),
    ('410122','2016-08-09 12:24:40',b'1','中牟县','410100'),
    ('410181','2016-08-09 12:24:40',b'1','巩义市','410100'),
    ('410182','2016-08-09 12:24:40',b'1','荥阳市','410100'),
    ('410183','2016-08-09 12:24:40',b'1','新密市','410100'),
    ('410184','2016-08-09 12:24:40',b'1','新郑市','410100'),
    ('410185','2016-08-09 12:24:40',b'1','登封市','410100'),
    ('410200','2016-08-09 12:24:40',b'1','开封市','410000'),
    ('410201','2016-08-09 12:24:40',b'1','市辖区','410200'),
    ('410202','2016-08-09 12:24:40',b'1','龙亭区','410200'),
    ('410203','2016-08-09 12:24:40',b'1','顺河回族区','410200'),
    ('410204','2016-08-09 12:24:40',b'1','鼓楼区','410200'),
    ('410205','2016-08-09 12:24:40',b'1','禹王台区','410200'),
    ('410211','2016-08-09 12:24:40',b'1','金明区','410200'),
    ('410221','2016-08-09 12:24:40',b'1','杞县','410200'),
    ('410222','2016-08-09 12:24:40',b'1','通许县','410200'),
    ('410223','2016-08-09 12:24:40',b'1','尉氏县','410200'),
    ('410224','2016-08-09 12:24:40',b'1','开封县','410200'),
    ('410225','2016-08-09 12:24:40',b'1','兰考县','410200'),
    ('410300','2016-08-09 12:24:40',b'1','洛阳市','410000'),
    ('410301','2016-08-09 12:24:40',b'1','市辖区','410300'),
    ('410302','2016-08-09 12:24:40',b'1','老城区','410300'),
    ('410303','2016-08-09 12:24:40',b'1','西工区','410300'),
    ('410304','2016-08-09 12:24:40',b'1','瀍河回族区','410300'),
    ('410305','2016-08-09 12:24:40',b'1','涧西区','410300'),
    ('410306','2016-08-09 12:24:40',b'1','吉利区','410300'),
    ('410311','2016-08-09 12:24:40',b'1','洛龙区','410300'),
    ('410322','2016-08-09 12:24:40',b'1','孟津县','410300'),
    ('410323','2016-08-09 12:24:40',b'1','新安县','410300'),
    ('410324','2016-08-09 12:24:40',b'1','栾川县','410300'),
    ('410325','2016-08-09 12:24:40',b'1','嵩县','410300'),
    ('410326','2016-08-09 12:24:40',b'1','汝阳县','410300'),
    ('410327','2016-08-09 12:24:40',b'1','宜阳县','410300'),
    ('410328','2016-08-09 12:24:40',b'1','洛宁县','410300'),
    ('410329','2016-08-09 12:24:40',b'1','伊川县','410300'),
    ('410381','2016-08-09 12:24:40',b'1','偃师市','410300'),
    ('410400','2016-08-09 12:24:40',b'1','平顶山市','410000'),
    ('410401','2016-08-09 12:24:40',b'1','市辖区','410400'),
    ('410402','2016-08-09 12:24:40',b'1','新华区','410400'),
    ('410403','2016-08-09 12:24:40',b'1','卫东区','410400'),
    ('410404','2016-08-09 12:24:40',b'1','石龙区','410400'),
    ('410411','2016-08-09 12:24:40',b'1','湛河区','410400'),
    ('410421','2016-08-09 12:24:40',b'1','宝丰县','410400'),
    ('410422','2016-08-09 12:24:40',b'1','叶县','410400'),
    ('410423','2016-08-09 12:24:40',b'1','鲁山县','410400'),
    ('410425','2016-08-09 12:24:40',b'1','郏县','410400'),
    ('410481','2016-08-09 12:24:40',b'1','舞钢市','410400'),
    ('410482','2016-08-09 12:24:40',b'1','汝州市','410400'),
    ('410500','2016-08-09 12:24:40',b'1','安阳市','410000'),
    ('410501','2016-08-09 12:24:40',b'1','市辖区','410500'),
    ('410502','2016-08-09 12:24:40',b'1','文峰区','410500'),
    ('410503','2016-08-09 12:24:40',b'1','北关区','410500'),
    ('410505','2016-08-09 12:24:40',b'1','殷都区','410500'),
    ('410506','2016-08-09 12:24:40',b'1','龙安区','410500'),
    ('410522','2016-08-09 12:24:40',b'1','安阳县','410500'),
    ('410523','2016-08-09 12:24:40',b'1','汤阴县','410500'),
    ('410526','2016-08-09 12:24:40',b'1','滑县','410500'),
    ('410527','2016-08-09 12:24:40',b'1','内黄县','410500'),
    ('410581','2016-08-09 12:24:40',b'1','林州市','410500'),
    ('410600','2016-08-09 12:24:40',b'1','鹤壁市','410000'),
    ('410601','2016-08-09 12:24:40',b'1','市辖区','410600'),
    ('410602','2016-08-09 12:24:40',b'1','鹤山区','410600'),
    ('410603','2016-08-09 12:24:40',b'1','山城区','410600'),
    ('410611','2016-08-09 12:24:40',b'1','淇滨区','410600'),
    ('410621','2016-08-09 12:24:40',b'1','浚县','410600'),
    ('410622','2016-08-09 12:24:40',b'1','淇县','410600'),
    ('410700','2016-08-09 12:24:40',b'1','新乡市','410000'),
    ('410701','2016-08-09 12:24:40',b'1','市辖区','410700'),
    ('410702','2016-08-09 12:24:40',b'1','红旗区','410700'),
    ('410703','2016-08-09 12:24:40',b'1','卫滨区','410700'),
    ('410704','2016-08-09 12:24:40',b'1','凤泉区','410700'),
    ('410711','2016-08-09 12:24:40',b'1','牧野区','410700'),
    ('410721','2016-08-09 12:24:40',b'1','新乡县','410700'),
    ('410724','2016-08-09 12:24:40',b'1','获嘉县','410700'),
    ('410725','2016-08-09 12:24:40',b'1','原阳县','410700'),
    ('410726','2016-08-09 12:24:40',b'1','延津县','410700'),
    ('410727','2016-08-09 12:24:40',b'1','封丘县','410700'),
    ('410728','2016-08-09 12:24:40',b'1','长垣县','410700'),
    ('410781','2016-08-09 12:24:40',b'1','卫辉市','410700'),
    ('410782','2016-08-09 12:24:40',b'1','辉县市','410700'),
    ('410800','2016-08-09 12:24:40',b'1','焦作市','410000'),
    ('410801','2016-08-09 12:24:40',b'1','市辖区','410800'),
    ('410802','2016-08-09 12:24:40',b'1','解放区','410800'),
    ('410803','2016-08-09 12:24:40',b'1','中站区','410800'),
    ('410804','2016-08-09 12:24:40',b'1','马村区','410800'),
    ('410811','2016-08-09 12:24:40',b'1','山阳区','410800'),
    ('410821','2016-08-09 12:24:40',b'1','修武县','410800'),
    ('410822','2016-08-09 12:24:40',b'1','博爱县','410800'),
    ('410823','2016-08-09 12:24:40',b'1','武陟县','410800'),
    ('410825','2016-08-09 12:24:40',b'1','温县','410800'),
    ('410882','2016-08-09 12:24:40',b'1','沁阳市','410800'),
    ('410883','2016-08-09 12:24:40',b'1','孟州市','410800'),
    ('410900','2016-08-09 12:24:40',b'1','濮阳市','410000'),
    ('410901','2016-08-09 12:24:40',b'1','市辖区','410900'),
    ('410902','2016-08-09 12:24:40',b'1','华龙区','410900'),
    ('410922','2016-08-09 12:24:40',b'1','清丰县','410900'),
    ('410923','2016-08-09 12:24:40',b'1','南乐县','410900'),
    ('410926','2016-08-09 12:24:40',b'1','范县','410900'),
    ('410927','2016-08-09 12:24:40',b'1','台前县','410900'),
    ('410928','2016-08-09 12:24:40',b'1','濮阳县','410900'),
    ('411000','2016-08-09 12:24:40',b'1','许昌市','410000'),
    ('411001','2016-08-09 12:24:40',b'1','市辖区','411000'),
    ('411002','2016-08-09 12:24:40',b'1','魏都区','411000'),
    ('411023','2016-08-09 12:24:40',b'1','许昌县','411000'),
    ('411024','2016-08-09 12:24:40',b'1','鄢陵县','411000'),
    ('411025',