全国行政区域身份证代码表(EXCEL版)

card_area_idprovince_namecity_nameDELETEFROMidentity_card_area_infoWHERE1=1;110101北京市市辖区东城区北京市市辖区东城区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110101,'北京市','市辖区东城区');110102北京市市辖区西城区北京市市辖区西城区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110102,'北京市','市辖区西城区');110103北京市市辖区崇文区北京市市辖区崇文区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110103,'北京市','市辖区崇文区');110104北京市市辖区宣武区北京市市辖区宣武区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110104,'北京市','市辖区宣武区');110105北京市市辖区朝阳区北京市市辖区朝阳区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110105,'北京市','市辖区朝阳区');110106北京市市辖区丰台区北京市市辖区丰台区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110106,'北京市','市辖区丰台区');110107北京市市辖区石景山区北京市市辖区石景山区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110107,'北京市','市辖区石景山区');110108北京市市辖区海淀区北京市市辖区海淀区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110108,'北京市','市辖区海淀区');110109北京市市辖区门头沟区北京市市辖区门头沟区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110109,'北京市','市辖区门头沟区');110111北京市市辖区房山区北京市市辖区房山区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110111,'北京市','市辖区房山区');110112北京市市辖区通州区北京市市辖区通州区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110112,'北京市','市辖区通州区');110113北京市市辖区顺义区北京市市辖区顺义区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110113,'北京市','市辖区顺义区');110114北京市市辖区昌平区北京市市辖区昌平区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110114,'北京市','市辖区昌平区');110115北京市市辖区大兴区北京市市辖区大兴区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110115,'北京市','市辖区大兴区');110116北京市市辖区怀柔区北京市市辖区怀柔区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110116,'北京市','市辖区怀柔区');110117北京市市辖区平谷区北京市市辖区平谷区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110117,'北京市','市辖区平谷区');110228北京市县密云县北京市县密云县INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110228,'北京市','县密云县');110229北京市县延庆县北京市县延庆县INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(110229,'北京市','县延庆县');120101天津市市辖区和平区天津市市辖区和平区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120101,'天津市','市辖区和平区');120102天津市市辖区河东区天津市市辖区河东区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120102,'天津市','市辖区河东区');120103天津市市辖区河西区天津市市辖区河西区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120103,'天津市','市辖区河西区');120104天津市市辖区南开区天津市市辖区南开区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120104,'天津市','市辖区南开区');120105天津市市辖区河北区天津市市辖区河北区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120105,'天津市','市辖区河北区');120106天津市市辖区红桥区天津市市辖区红桥区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120106,'天津市','市辖区红桥区');120107天津市市辖区塘沽区天津市市辖区塘沽区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120107,'天津市','市辖区塘沽区');120108天津市市辖区汉沽区天津市市辖区汉沽区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120108,'天津市','市辖区汉沽区');120109天津市市辖区大港区天津市市辖区大港区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120109,'天津市','市辖区大港区');120110天津市市辖区东丽区天津市市辖区东丽区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120110,'天津市','市辖区东丽区');120111天津市市辖区西青区天津市市辖区西青区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120111,'天津市','市辖区西青区');120112天津市市辖区津南区天津市市辖区津南区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120112,'天津市','市辖区津南区');120113天津市市辖区北辰区天津市市辖区北辰区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120113,'天津市','市辖区北辰区');120114天津市市辖区武清区天津市市辖区武清区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120114,'天津市','市辖区武清区');120115天津市市辖区宝坻区天津市市辖区宝坻区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120115,'天津市','市辖区宝坻区');120221天津市县宁河县天津市县宁河县INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120221,'天津市','县宁河县');120223天津市县静海县天津市县静海县INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120223,'天津市','县静海县');120225天津市县蓟县天津市县蓟县INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(120225,'天津市','县蓟县');130101河北省石家庄市市辖区河北省石家庄市市辖区INSERTINTOods_base.identity_card_area_info(card_area_id,province_name,city_name)VALUES(130101,'河北省','