省市区三级行政区代码（包含港澳台）sql1

一、sql

INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110000', '0', '0', '北京市', 'beijingshi', '北京市', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110100', '110000', '0,110000', '市辖区', 'shixiaqu', '北京市市辖区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110101', '110100', '0,110000,110100', '东城区', 'dongchengqu', '北京市市辖区东城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110102', '110100', '0,110000,110100', '西城区', 'xichengqu', '北京市市辖区西城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110105', '110100', '0,110000,110100', '朝阳区', 'chaoyangqu', '北京市市辖区朝阳区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110106', '110100', '0,110000,110100', '丰台区', 'fengtaiqu', '北京市市辖区丰台区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110107', '110100', '0,110000,110100', '石景山区', 'shijingshanqu', '北京市市辖区石景山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110108', '110100', '0,110000,110100', '海淀区', 'haidianqu', '北京市市辖区海淀区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110109', '110100', '0,110000,110100', '门头沟区', 'mentougouqu', '北京市市辖区门头沟区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110111', '110100', '0,110000,110100', '房山区', 'fangshanqu', '北京市市辖区房山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110112', '110100', '0,110000,110100', '通州区', 'tongzhouqu', '北京市市辖区通州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110113', '110100', '0,110000,110100', '顺义区', 'shunyiqu', '北京市市辖区顺义区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110114', '110100', '0,110000,110100', '昌平区', 'changpingqu', '北京市市辖区昌平区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110115', '110100', '0,110000,110100', '大兴区', 'daxingqu', '北京市市辖区大兴区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110116', '110100', '0,110000,110100', '怀柔区', 'huairouqu', '北京市市辖区怀柔区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110117', '110100', '0,110000,110100', '平谷区', 'pingguqu', '北京市市辖区平谷区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110118', '110100', '0,110000,110100', '密云区', 'miyunqu', '北京市市辖区密云区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('110119', '110100', '0,110000,110100', '延庆区', 'yanqingqu', '北京市市辖区延庆区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120000', '0', '0', '天津市', 'tianjinshi', '天津市', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120100', '120000', '0,120000', '市辖区', 'shixiaqu', '天津市市辖区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120101', '120100', '0,120000,120100', '和平区', 'hepingqu', '天津市市辖区和平区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120102', '120100', '0,120000,120100', '河东区', 'hedongqu', '天津市市辖区河东区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120103', '120100', '0,120000,120100', '河西区', 'hexiqu', '天津市市辖区河西区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120104', '120100', '0,120000,120100', '南开区', 'nankaiqu', '天津市市辖区南开区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120105', '120100', '0,120000,120100', '河北区', 'hebeiqu', '天津市市辖区河北区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120106', '120100', '0,120000,120100', '红桥区', 'hongqiaoqu', '天津市市辖区红桥区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120110', '120100', '0,120000,120100', '东丽区', 'dongliqu', '天津市市辖区东丽区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120111', '120100', '0,120000,120100', '西青区', 'xiqingqu', '天津市市辖区西青区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120112', '120100', '0,120000,120100', '津南区', 'jinnanqu', '天津市市辖区津南区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120113', '120100', '0,120000,120100', '北辰区', 'beichenqu', '天津市市辖区北辰区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120114', '120100', '0,120000,120100', '武清区', 'wuqingqu', '天津市市辖区武清区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120115', '120100', '0,120000,120100', '宝坻区', 'baochiqu', '天津市市辖区宝坻区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120116', '120100', '0,120000,120100', '滨海新区', 'binhaixinqu', '天津市市辖区滨海新区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120117', '120100', '0,120000,120100', '宁河区', 'ninghequ', '天津市市辖区宁河区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120118', '120100', '0,120000,120100', '静海区', 'jinghaiqu', '天津市市辖区静海区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('120119', '120100', '0,120000,120100', '蓟州区', 'jizhouqu', '天津市市辖区蓟州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130000', '0', '0', '河北省', 'hebeisheng', '河北省', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130100', '130000', '0,130000', '石家庄市', 'shijiazhuangshi', '河北省石家庄市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130102', '130100', '0,130000,130100', '长安区', 'zhanganqu', '河北省石家庄市长安区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130104', '130100', '0,130000,130100', '桥西区', 'qiaoxiqu', '河北省石家庄市桥西区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130105', '130100', '0,130000,130100', '新华区', 'xinhuaqu', '河北省石家庄市新华区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130107', '130100', '0,130000,130100', '井陉矿区', 'jingxingkuangqu', '河北省石家庄市井陉矿区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130108', '130100', '0,130000,130100', '裕华区', 'yuhuaqu', '河北省石家庄市裕华区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130109', '130100', '0,130000,130100', '藁城区', 'gaochengqu', '河北省石家庄市藁城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130110', '130100', '0,130000,130100', '鹿泉区', 'luquanqu', '河北省石家庄市鹿泉区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130111', '130100', '0,130000,130100', '栾城区', 'luanchengqu', '河北省石家庄市栾城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130121', '130100', '0,130000,130100', '井陉县', 'jingxingxian', '河北省石家庄市井陉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130123', '130100', '0,130000,130100', '正定县', 'zhengdingxian', '河北省石家庄市正定县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130125', '130100', '0,130000,130100', '行唐县', 'xingtangxian', '河北省石家庄市行唐县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130126', '130100', '0,130000,130100', '灵寿县', 'lingshouxian', '河北省石家庄市灵寿县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130127', '130100', '0,130000,130100', '高邑县', 'gaoyixian', '河北省石家庄市高邑县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130128', '130100', '0,130000,130100', '深泽县', 'shenzexian', '河北省石家庄市深泽县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130129', '130100', '0,130000,130100', '赞皇县', 'zanhuangxian', '河北省石家庄市赞皇县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130130', '130100', '0,130000,130100', '无极县', 'wujixian', '河北省石家庄市无极县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130131', '130100', '0,130000,130100', '平山县', 'pingshanxian', '河北省石家庄市平山县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130132', '130100', '0,130000,130100', '元氏县', 'yuanshixian', '河北省石家庄市元氏县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130133', '130100', '0,130000,130100', '赵县', 'zhaoxian', '河北省石家庄市赵县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130171', '130100', '0,130000,130100', '石家庄高新技术产业开发区', 'shijiazhuanggaoxinjishuchanyekaifaqu', '河北省石家庄市石家庄高新技术产业开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130172', '130100', '0,130000,130100', '石家庄循环化工园区', 'shijiazhuangxunhuanhuagongyuanqu', '河北省石家庄市石家庄循环化工园区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130181', '130100', '0,130000,130100', '辛集市', 'xinjishi', '河北省石家庄市辛集市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130183', '130100', '0,130000,130100', '晋州市', 'jinzhoushi', '河北省石家庄市晋州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130184', '130100', '0,130000,130100', '新乐市', 'xinleshi', '河北省石家庄市新乐市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130200', '130000', '0,130000', '唐山市', 'tangshanshi', '河北省唐山市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130202', '130200', '0,130000,130200', '路南区', 'lunanqu', '河北省唐山市路南区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130203', '130200', '0,130000,130200', '路北区', 'lubeiqu', '河北省唐山市路北区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130204', '130200', '0,130000,130200', '古冶区', 'guyequ', '河北省唐山市古冶区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130205', '130200', '0,130000,130200', '开平区', 'kaipingqu', '河北省唐山市开平区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130207', '130200', '0,130000,130200', '丰南区', 'fengnanqu', '河北省唐山市丰南区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130208', '130200', '0,130000,130200', '丰润区', 'fengrunqu', '河北省唐山市丰润区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130209', '130200', '0,130000,130200', '曹妃甸区', 'caofeidianqu', '河北省唐山市曹妃甸区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130224', '130200', '0,130000,130200', '滦南县', 'luannanxian', '河北省唐山市滦南县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130225', '130200', '0,130000,130200', '乐亭县', 'letingxian', '河北省唐山市乐亭县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130227', '130200', '0,130000,130200', '迁西县', 'qianxixian', '河北省唐山市迁西县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130229', '130200', '0,130000,130200', '玉田县', 'yutianxian', '河北省唐山市玉田县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130271', '130200', '0,130000,130200', '河北唐山芦台经济开发区', 'hebeitangshanlutaijingjikaifaqu', '河北省唐山市河北唐山芦台经济开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130272', '130200', '0,130000,130200', '唐山市汉沽管理区', 'tangshanshihanguguanliqu', '河北省唐山市唐山市汉沽管理区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130273', '130200', '0,130000,130200', '唐山高新技术产业开发区', 'tangshangaoxinjishuchanyekaifaqu', '河北省唐山市唐山高新技术产业开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130274', '130200', '0,130000,130200', '河北唐山海港经济开发区', 'hebeitangshanhaigangjingjikaifaqu', '河北省唐山市河北唐山海港经济开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130281', '130200', '0,130000,130200', '遵化市', 'zunhuashi', '河北省唐山市遵化市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130283', '130200', '0,130000,130200', '迁安市', 'qiananshi', '河北省唐山市迁安市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130284', '130200', '0,130000,130200', '滦州市', 'luanzhoushi', '河北省唐山市滦州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130300', '130000', '0,130000', '秦皇岛市', 'qinhuangdaoshi', '河北省秦皇岛市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130302', '130300', '0,130000,130300', '海港区', 'haigangqu', '河北省秦皇岛市海港区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130303', '130300', '0,130000,130300', '山海关区', 'shanhaiguanqu', '河北省秦皇岛市山海关区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130304', '130300', '0,130000,130300', '北戴河区', 'beidaihequ', '河北省秦皇岛市北戴河区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130306', '130300', '0,130000,130300', '抚宁区', 'funingqu', '河北省秦皇岛市抚宁区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130321', '130300', '0,130000,130300', '青龙满族自治县', 'qinglongmanzuzizhixian', '河北省秦皇岛市青龙满族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130322', '130300', '0,130000,130300', '昌黎县', 'changlixian', '河北省秦皇岛市昌黎县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130324', '130300', '0,130000,130300', '卢龙县', 'lulongxian', '河北省秦皇岛市卢龙县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130371', '130300', '0,130000,130300', '秦皇岛市经济技术开发区', 'qinhuangdaoshijingjijishukaifaqu', '河北省秦皇岛市秦皇岛市经济技术开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130372', '130300', '0,130000,130300', '北戴河新区', 'beidaihexinqu', '河北省秦皇岛市北戴河新区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130400', '130000', '0,130000', '邯郸市', 'handanshi', '河北省邯郸市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130402', '130400', '0,130000,130400', '邯山区', 'hanshanqu', '河北省邯郸市邯山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130403', '130400', '0,130000,130400', '丛台区', 'congtaiqu', '河北省邯郸市丛台区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130404', '130400', '0,130000,130400', '复兴区', 'fuxingqu', '河北省邯郸市复兴区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130406', '130400', '0,130000,130400', '峰峰矿区', 'fengfengkuangqu', '河北省邯郸市峰峰矿区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130407', '130400', '0,130000,130400', '肥乡区', 'feixiangqu', '河北省邯郸市肥乡区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130408', '130400', '0,130000,130400', '永年区', 'yongnianqu', '河北省邯郸市永年区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130423', '130400', '0,130000,130400', '临漳县', 'linzhangxian', '河北省邯郸市临漳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130424', '130400', '0,130000,130400', '成安县', 'chenganxian', '河北省邯郸市成安县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130425', '130400', '0,130000,130400', '大名县', 'damingxian', '河北省邯郸市大名县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130426', '130400', '0,130000,130400', '涉县', 'shexian', '河北省邯郸市涉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130427', '130400', '0,130000,130400', '磁县', 'cixian', '河北省邯郸市磁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130430', '130400', '0,130000,130400', '邱县', 'qiuxian', '河北省邯郸市邱县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130431', '130400', '0,130000,130400', '鸡泽县', 'jizexian', '河北省邯郸市鸡泽县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130432', '130400', '0,130000,130400', '广平县', 'guangpingxian', '河北省邯郸市广平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130433', '130400', '0,130000,130400', '馆陶县', 'guantaoxian', '河北省邯郸市馆陶县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130434', '130400', '0,130000,130400', '魏县', 'weixian', '河北省邯郸市魏县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130435', '130400', '0,130000,130400', '曲周县', 'quzhouxian', '河北省邯郸市曲周县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130471', '130400', '0,130000,130400', '邯郸经济技术开发区', 'handanjingjijishukaifaqu', '河北省邯郸市邯郸经济技术开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130473', '130400', '0,130000,130400', '邯郸冀南新区', 'handanjinanxinqu', '河北省邯郸市邯郸冀南新区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130481', '130400', '0,130000,130400', '武安市', 'wuanshi', '河北省邯郸市武安市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130500', '130000', '0,130000', '邢台市', 'xingtaishi', '河北省邢台市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130502', '130500', '0,130000,130500', '襄都区', 'xiangdouqu', '河北省邢台市襄都区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130503', '130500', '0,130000,130500', '信都区', 'xindouqu', '河北省邢台市信都区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130505', '130500', '0,130000,130500', '任泽区', 'renzequ', '河北省邢台市任泽区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130506', '130500', '0,130000,130500', '南和区', 'nanhequ', '河北省邢台市南和区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130522', '130500', '0,130000,130500', '临城县', 'linchengxian', '河北省邢台市临城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130523', '130500', '0,130000,130500', '内丘县', 'neiqiuxian', '河北省邢台市内丘县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130524', '130500', '0,130000,130500', '柏乡县', 'boxiangxian', '河北省邢台市柏乡县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130525', '130500', '0,130000,130500', '隆尧县', 'longyaoxian', '河北省邢台市隆尧县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130528', '130500', '0,130000,130500', '宁晋县', 'ningjinxian', '河北省邢台市宁晋县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130529', '130500', '0,130000,130500', '巨鹿县', 'juluxian', '河北省邢台市巨鹿县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130530', '130500', '0,130000,130500', '新河县', 'xinhexian', '河北省邢台市新河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130531', '130500', '0,130000,130500', '广宗县', 'guangzongxian', '河北省邢台市广宗县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130532', '130500', '0,130000,130500', '平乡县', 'pingxiangxian', '河北省邢台市平乡县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130533', '130500', '0,130000,130500', '威县', 'weixian', '河北省邢台市威县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130534', '130500', '0,130000,130500', '清河县', 'qinghexian', '河北省邢台市清河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130535', '130500', '0,130000,130500', '临西县', 'linxixian', '河北省邢台市临西县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130571', '130500', '0,130000,130500', '河北邢台经济开发区', 'hebeixingtaijingjikaifaqu', '河北省邢台市河北邢台经济开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130581', '130500', '0,130000,130500', '南宫市', 'nangongshi', '河北省邢台市南宫市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130582', '130500', '0,130000,130500', '沙河市', 'shaheshi', '河北省邢台市沙河市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130600', '130000', '0,130000', '保定市', 'baodingshi', '河北省保定市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130602', '130600', '0,130000,130600', '竞秀区', 'jingxiuqu', '河北省保定市竞秀区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130606', '130600', '0,130000,130600', '莲池区', 'lianchiqu', '河北省保定市莲池区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130607', '130600', '0,130000,130600', '满城区', 'manchengqu', '河北省保定市满城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130608', '130600', '0,130000,130600', '清苑区', 'qingyuanqu', '河北省保定市清苑区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130609', '130600', '0,130000,130600', '徐水区', 'xushuiqu', '河北省保定市徐水区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130623', '130600', '0,130000,130600', '涞水县', 'laishuixian', '河北省保定市涞水县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130624', '130600', '0,130000,130600', '阜平县', 'fupingxian', '河北省保定市阜平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130626', '130600', '0,130000,130600', '定兴县', 'dingxingxian', '河北省保定市定兴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130627', '130600', '0,130000,130600', '唐县', 'tangxian', '河北省保定市唐县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130628', '130600', '0,130000,130600', '高阳县', 'gaoyangxian', '河北省保定市高阳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130629', '130600', '0,130000,130600', '容城县', 'rongchengxian', '河北省保定市容城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130630', '130600', '0,130000,130600', '涞源县', 'laiyuanxian', '河北省保定市涞源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130631', '130600', '0,130000,130600', '望都县', 'wangdouxian', '河北省保定市望都县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130632', '130600', '0,130000,130600', '安新县', 'anxinxian', '河北省保定市安新县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130633', '130600', '0,130000,130600', '易县', 'yixian', '河北省保定市易县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130634', '130600', '0,130000,130600', '曲阳县', 'quyangxian', '河北省保定市曲阳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130635', '130600', '0,130000,130600', '蠡县', 'lixian', '河北省保定市蠡县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130636', '130600', '0,130000,130600', '顺平县', 'shunpingxian', '河北省保定市顺平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130637', '130600', '0,130000,130600', '博野县', 'boyexian', '河北省保定市博野县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130638', '130600', '0,130000,130600', '雄县', 'xiongxian', '河北省保定市雄县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130671', '130600', '0,130000,130600', '保定高新技术产业开发区', 'baodinggaoxinjishuchanyekaifaqu', '河北省保定市保定高新技术产业开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130672', '130600', '0,130000,130600', '保定白沟新城', 'baodingbaigouxincheng', '河北省保定市保定白沟新城', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130681', '130600', '0,130000,130600', '涿州市', 'zhuozhoushi', '河北省保定市涿州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130682', '130600', '0,130000,130600', '定州市', 'dingzhoushi', '河北省保定市定州市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130683', '130600', '0,130000,130600', '安国市', 'anguoshi', '河北省保定市安国市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130684', '130600', '0,130000,130600', '高碑店市', 'gaobeidianshi', '河北省保定市高碑店市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130700', '130000', '0,130000', '张家口市', 'zhangjiakoushi', '河北省张家口市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130702', '130700', '0,130000,130700', '桥东区', 'qiaodongqu', '河北省张家口市桥东区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130703', '130700', '0,130000,130700', '桥西区', 'qiaoxiqu', '河北省张家口市桥西区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130705', '130700', '0,130000,130700', '宣化区', 'xuanhuaqu', '河北省张家口市宣化区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130706', '130700', '0,130000,130700', '下花园区', 'xiahuayuanqu', '河北省张家口市下花园区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130708', '130700', '0,130000,130700', '万全区', 'wanquanqu', '河北省张家口市万全区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130709', '130700', '0,130000,130700', '崇礼区', 'chongliqu', '河北省张家口市崇礼区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130722', '130700', '0,130000,130700', '张北县', 'zhangbeixian', '河北省张家口市张北县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130723', '130700', '0,130000,130700', '康保县', 'kangbaoxian', '河北省张家口市康保县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130724', '130700', '0,130000,130700', '沽源县', 'guyuanxian', '河北省张家口市沽源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130725', '130700', '0,130000,130700', '尚义县', 'shangyixian', '河北省张家口市尚义县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130726', '130700', '0,130000,130700', '蔚县', 'yuxian', '河北省张家口市蔚县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130727', '130700', '0,130000,130700', '阳原县', 'yangyuanxian', '河北省张家口市阳原县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130728', '130700', '0,130000,130700', '怀安县', 'huaianxian', '河北省张家口市怀安县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130730', '130700', '0,130000,130700', '怀来县', 'huailaixian', '河北省张家口市怀来县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130731', '130700', '0,130000,130700', '涿鹿县', 'zhuoluxian', '河北省张家口市涿鹿县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130732', '130700', '0,130000,130700', '赤城县', 'chichengxian', '河北省张家口市赤城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130771', '130700', '0,130000,130700', '张家口经济开发区', 'zhangjiakoujingjikaifaqu', '河北省张家口市张家口经济开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130772', '130700', '0,130000,130700', '张家口市察北管理区', 'zhangjiakoushichabeiguanliqu', '河北省张家口市张家口市察北管理区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130773', '130700', '0,130000,130700', '张家口市塞北管理区', 'zhangjiakoushisaibeiguanliqu', '河北省张家口市张家口市塞北管理区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130800', '130000', '0,130000', '承德市', 'chengdeshi', '河北省承德市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130802', '130800', '0,130000,130800', '双桥区', 'shuangqiaoqu', '河北省承德市双桥区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130803', '130800', '0,130000,130800', '双滦区', 'shuangluanqu', '河北省承德市双滦区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130804', '130800', '0,130000,130800', '鹰手营子矿区', 'yingshouyingzikuangqu', '河北省承德市鹰手营子矿区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130821', '130800', '0,130000,130800', '承德县', 'chengdexian', '河北省承德市承德县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130822', '130800', '0,130000,130800', '兴隆县', 'xinglongxian', '河北省承德市兴隆县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130824', '130800', '0,130000,130800', '滦平县', 'luanpingxian', '河北省承德市滦平县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130825', '130800', '0,130000,130800', '隆化县', 'longhuaxian', '河北省承德市隆化县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130826', '130800', '0,130000,130800', '丰宁满族自治县', 'fengningmanzuzizhixian', '河北省承德市丰宁满族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130827', '130800', '0,130000,130800', '宽城满族自治县', 'kuanchengmanzuzizhixian', '河北省承德市宽城满族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130828', '130800', '0,130000,130800', '围场满族蒙古族自治县', 'weichangmanzumengguzuzizhixian', '河北省承德市围场满族蒙古族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130871', '130800', '0,130000,130800', '承德高新技术产业开发区', 'chengdegaoxinjishuchanyekaifaqu', '河北省承德市承德高新技术产业开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130881', '130800', '0,130000,130800', '平泉市', 'pingquanshi', '河北省承德市平泉市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130900', '130000', '0,130000', '沧州市', 'cangzhoushi', '河北省沧州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130902', '130900', '0,130000,130900', '新华区', 'xinhuaqu', '河北省沧州市新华区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130903', '130900', '0,130000,130900', '运河区', 'yunhequ', '河北省沧州市运河区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130921', '130900', '0,130000,130900', '沧县', 'cangxian', '河北省沧州市沧县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130922', '130900', '0,130000,130900', '青县', 'qingxian', '河北省沧州市青县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130923', '130900', '0,130000,130900', '东光县', 'dongguangxian', '河北省沧州市东光县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('130924', '130900', '0,130000,130900', '海兴县', 'haixingxian', '河北省沧州市海兴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full