2022年最新最全身份证前六位地区对照表（excel和sql双版）

insert into bj_addr (num,addr) values ('110101','北京市东城区'); insert into bj_addr (num,addr) values ('110102','北京市西城区'); insert into bj_addr (num,addr) values ('110103','北京市崇文区'); insert into bj_addr (num,addr) values ('110104','北京市宣武区'); insert into bj_addr (num,addr) values ('110105','北京市朝阳区'); insert into bj_addr (num,addr) values ('110106','北京市丰台区'); insert into bj_addr (num,addr) values ('110107','北京市石景山区'); insert into bj_addr (num,addr) values ('110108','北京市海淀区'); insert into bj_addr (num,addr) values ('110109','北京市门头沟区'); insert into bj_addr (num,addr) values ('110110','北京市燕山区'); insert into bj_addr (num,addr) values ('110111','北京市房山区'); insert into bj_addr (num,addr) values ('110112','北京市通州区'); insert into bj_addr (num,addr) values ('110113','北京市顺义区'); insert into bj_addr (num,addr) values ('110114','北京市昌平区'); insert into bj_addr (num,addr) values ('110115','北京市大兴区'); insert into bj_addr (num,addr) values ('110116','北京市怀柔区'); insert into bj_addr (num,addr) values ('110117','北京市平谷区'); insert into bj_addr (num,addr) values ('110221','北京市昌平县'); insert into bj_addr (num,addr) values ('110222','北京市顺义县'); insert into bj_addr (num,addr) values ('110223','北京市通县'); insert into bj_addr (num,addr) values ('110224','北京市大兴县'); insert into bj_addr (num,addr) values ('110225','北京市房山县'); insert into bj_addr (num,addr) values ('110226','北京市平谷县'); insert into bj_addr (num,addr) values ('110227','北京市怀柔县'); insert into bj_addr (num,addr) values ('110228','北京市密云县'); insert into bj_addr (num,addr) values ('110229','北京市延庆县'); insert into bj_addr (num,addr) values ('120101','天津市和平区'); insert into bj_addr (num,addr) values ('120102','天津市河东区'); insert into bj_addr (num,addr) values ('120103','天津市河西区'); insert into bj_addr (num,addr) values ('120104','天津市南开区'); insert into bj_addr (num,addr) values ('120105','天津市河北区'); insert into bj_addr (num,addr) values ('120106','天津市红桥区'); insert into bj_addr (num,addr) values ('120107','天津市塘沽区'); insert into bj_addr (num,addr) values ('120108','天津市汉沽区'); insert into bj_addr (num,addr) values ('120109','天津市大港区'); insert into bj_addr (num,addr) values ('120110','天津市东丽区'); insert into bj_addr (num,addr) values ('120111','天津市西青区'); insert into bj_addr (num,addr) values ('120112','天津市津南区'); insert into bj_addr (num,addr) values ('120113','天津市北辰区'); insert into bj_addr (num,addr) values ('120114','天津市武清区'); insert into bj_addr (num,addr) values ('120115','天津市宝坻区'); insert into bj_addr (num,addr) values ('120221','天津市宁河县'); insert into bj_addr (num,addr) values ('120222','天津市武清县'); insert into bj_addr (num,addr) values ('120223','天津市静海县'); insert into bj_addr (num,addr) values ('120224','天津市宝坻县'); insert into bj_addr (num,addr) values ('120225','天津市蓟县'); insert into bj_addr (num,addr) values ('130101','河北省石家庄市市辖区'); insert into bj_addr (num,addr) values ('130102','河北省石家庄市长安区'); insert into bj_addr (num,addr) values ('130103','河北省石家庄市桥东区'); insert into bj_addr (num,addr) values ('130104','河北省石家庄市桥西区'); insert into bj_addr (num,addr) values ('130105','河北省石家庄市新华区'); insert into bj_addr (num,addr) values ('130106','河北省石家庄市郊区'); insert into bj_addr (num,addr) values ('130107','河北省石家庄市井陉矿区'); insert into bj_addr (num,addr) values ('130108','河北省石家庄市裕华区'); insert into bj_addr (num,addr) values ('130121','河北省石家庄市井陉县'); insert into bj_addr (num,addr) values ('130122','河北省石家庄市获鹿县'); insert into bj_addr (num,addr) values ('130123','河北省石家庄市正定县'); insert into bj_addr (num,addr) values ('130124','河北省石家庄市栾城县'); insert into bj_addr (num,addr) values ('130125','河北省石家庄市行唐县'); insert into bj_addr (num,addr) values ('130126','河北省石家庄市灵寿县'); insert into bj_addr (num,addr) values ('130127','河北省石家庄市高邑县'); insert into bj_addr (num,addr) values ('130128','河北省石家庄市深泽县'); insert into bj_addr (num,addr) values ('130129','河北省石家庄市赞皇县'); insert into bj_addr (num,addr) values ('130130','河北省石家庄市无极县'); insert into bj_addr (num,addr) values ('130131','河北省石家庄市平山县'); insert into bj_addr (num,addr) values ('130132','河北省石家庄市元氏县'); insert into bj_addr (num,addr) values ('130133','河北省石家庄市赵县'); insert into bj_addr (num,addr) values ('130181','河北省石家庄市辛集市'); insert into bj_addr (num,addr) values ('130182','河北省石家庄市藁城市'); insert into bj_addr (num,addr) values ('130183','河北省石家庄市晋州市'); insert into bj_addr (num,addr) values ('130184','河北省石家庄市新乐市'); insert into bj_addr (num,addr) values ('130185','河北省石家庄市鹿泉市'); insert into bj_addr (num,addr) values ('130201','河北省唐山市市辖区'); insert into bj_addr (num,addr) values ('130202','河北省唐山市路南区'); insert into bj_addr (num,addr) values ('130203','河北省唐山市路北区'); insert into bj_addr (num,addr) values ('130204','河北省唐山市古冶区'); insert into bj_addr (num,addr) values ('130205','河北省唐山市开平区'); insert into bj_addr (num,addr) values ('130206','河北省唐山市新区'); insert into bj_addr (num,addr) values ('130207','河北省唐山市丰南区'); insert into bj_addr (num,addr) values ('130208','河北省唐山市丰润区'); insert into bj_addr (num,addr) values ('130221','河北省唐山市丰润县'); insert into bj_addr (num,addr) values ('130222','河北省唐山市丰南县'); insert into bj_addr (num,addr) values ('130223','河北省唐山市滦县'); insert into bj_addr (num,addr) values ('130224','河北省唐山市滦南县'); insert into bj_addr (num,addr) values ('130225','河北省唐山市乐亭县'); insert into bj_addr (num,addr) values ('130226','河北省唐山市迁安县'); insert into bj_addr (num,addr) values ('130227','河北省唐山市迁西县'); insert into bj_addr (num,addr) values ('130228','河北省唐山市遵化县'); insert into bj_addr (num,addr) values ('130229','河北省唐山市玉田县'); insert into bj_addr (num,addr) values ('130230','河北省唐山市唐海县'); insert into bj_addr (num,addr) values ('130281','河北省唐山市遵化市'); insert into bj_addr (num,addr) values ('130282','河北省唐山市丰南市'); insert into bj_addr (num,addr) values ('130283','河北省唐山市迁安市'); insert into bj_addr (num,addr) values ('130301','河北省秦皇岛市市辖区'); insert into bj_addr (num,addr) values ('130302','河北省秦皇岛市海港区'); insert into bj_addr (num,addr) values ('130303','河北省秦皇岛市山海关区'); insert into bj_addr (num,addr) values ('130304','河北省秦皇岛市北戴河区'); insert into bj_addr (num,addr) values ('130321','河北省秦皇岛市青龙满族自治县'); insert into bj_addr (num,addr) values ('130322','河北省秦皇岛市昌黎县'); insert into bj_addr (num,addr) values ('130323','河北省秦皇岛市抚宁县'); insert into bj_addr (num,addr) values ('130324','河北省秦皇岛市卢龙县'); insert into bj_addr (num,addr) values ('130401','河北省邯郸市市辖区'); insert into bj_addr (num,addr) values ('13