身份证归属地对照表(2020年版),文档为txt文件,后缀改成.sql即可导入数据...
/*
Navicat MySQL Data Transfer
Source Server        : localhost
Source Server Version : 50151
Source Host          : localhost:3306
Source Database      : address
Target Server Type    : MYSQL
Target Server Version : 50151
File Encoding        : 65001
Date: 2013-04-18 09:16:16
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `areas`
-- ----------------------------
DROP TABLE IF EXISTS `areas`;
CREATE TABLE `areas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`areaid` varchar(20) NOT NULL,
`area` varchar(50) NOT NULL,
`cityid` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8 COMMENT='行政区域县区信息表';
-- ----------------------------
-- Records of areas
-- ----------------------------
INSERT INTO `areas` VALUES ('1', '110101', '东城区', '110100');
INSERT INTO `areas` VALUES ('2', '110102', '西城区', '110100');
INSERT INTO `areas` VALUES ('3', '110103', '崇文区', '110100');
INSERT INTO `areas` VALUES ('4', '110104', '宣武区', '110100');
INSERT INTO `areas` VALUES ('5', '110105', '朝阳区', '110100');
INSERT INTO `areas` VALUES ('6', '110106', '丰台区', '110100');
INSERT INTO `areas` VALUES ('7', '110107', '石景山区', '110100');
INSERT INTO `areas` VALUES ('8', '110108', '海淀区', '110100');
INSERT INTO `areas` VALUES ('9', '110109', '门头沟区', '110100');
INSERT INTO `areas` VALUES ('10', '110111', '房山区', '110100');
INSERT INTO `areas` VALUES ('11', '110112', '通州区', '110100');
INSERT INTO `areas` VALUES ('12', '110113', '顺义区', '110100');
INSERT INTO `areas` VALUES ('13', '110114', '昌平区', '110100');
INSERT INTO `areas` VALUES ('14', '110115', '大兴区', '110100');
INSERT INTO `areas` VALUES ('15', '110116', '怀柔区', '110100');
INSERT INTO `areas` VALUES ('16', '110117', '平谷区', '110100');
INSERT INTO `areas` VALUES ('17', '110228', '密云县', '110200');
INSERT INTO `areas` VALUES ('18', '110229', '延庆县', '110200');
INSERT INTO `areas` VALUES ('19', '120101', '和平区', '120100');
INSERT INTO `areas` VALUES ('20', '120102', '河东区', '120100');
INSERT INTO `areas` VALUES ('21', '120103', '河西区', '120100');
INSERT INTO `areas` VALUES ('22', '120104', '南开区', '120100');
INSERT INTO `areas` VALUES ('23', '120105', '河北区', '120100');
INSERT INTO `areas` VALUES ('24', '120106', '红桥区', '120100');
INSERT INTO `areas` VALUES ('25', '120107', '塘沽区', '120100');
INSERT INTO `areas` VALUES ('26', '120108', '汉沽区', '120100');
INSERT INTO `areas` VALUES ('27', '120109', '大港区', '120100');
INSERT INTO `areas` VALUES ('28', '120110', '东丽区', '120100');
INSERT INTO `areas` VALUES ('29', '120111', '西青区', '120100');
INSERT INTO `areas` VALUES ('30', '120112', '津南区', '120100');
INSERT INTO `areas` VALUES ('31', '120113', '北辰区', '120100');
INSERT INTO `areas` VALUES ('
32', '120114', '武清区', '120100');
INSERT INTO `areas` VALUES ('33', '120115', '宝坻区', '120100');
INSERT INTO `areas` VALUES ('34', '120221', '宁河县', '120200');
INSERT INTO `areas` VALUES ('35', '120223', '静海县', '120200');
INSERT INTO `areas` VALUES ('36', '120225', '蓟　县', '120200');
INSERT INTO `areas` VALUES ('37', '130101', '市辖区', '130100');
INSERT INTO `areas` VALUES ('38', '130102', '长安区', '130100');
INSERT INTO `areas` VALUES ('39', '130103', '桥东区', '130100');
INSERT INTO `areas` VALUES ('40', '130104', '桥西区', '130100');
INSERT INTO `areas` VALUES ('41', '130105', '新华区', '130100');
INSERT INTO `areas` VALUES ('42', '130107', '井陉矿区', '130100');
INSERT INTO `areas` VALUES ('43', '130108', '裕华区', '130100');
INSERT INTO `areas` VALUES ('44', '130121', '井陉县', '130100');
INSERT INTO `areas` VALUES ('45', '130123', '正定县', '130100');
INSERT INTO `areas` VALUES ('46', '130124', '栾城县', '130100');
INSERT INTO `areas` VALUES ('47', '130125', '行唐县', '130100');
INSERT INTO `areas` VALUES ('48', '130126', '灵寿县', '130100');
INSERT INTO `areas` VALUES ('49', '130127', '高邑县', '130100');
INSERT INTO `areas` VALUES ('50', '130128', '深泽县', '130100');
INSERT INTO `areas` VALUES ('51', '130129', '赞皇县', '130100');
INSERT INTO `areas` VALUES ('52', '130130', '无极县', '130100');
INSERT INTO `areas` VALUES ('53', '130131', '平山县', '130100');
INSERT INTO `areas` VALUES ('54', '130132', '元氏县', '130100');
INSERT INTO `areas` VALUES ('55', '130133', '赵　县', '130100');
身份证号码查询婚姻INSERT INTO `areas` VALUES ('56', '130181', '辛集市', '130100');
INSERT INTO `areas` VALUES ('57', '130182', '藁城市', '130100');
INSERT INTO `areas` VALUES ('58', '130183', '晋州市', '130100');
INSERT INTO `areas` VALUES ('59', '130184', '新乐市', '130100');
INSERT INTO `areas` VALUES ('60', '130185', '鹿泉市', '130100');
INSERT INTO `areas` VALUES ('61', '130201', '市辖区', '130200');
INSERT INTO `areas` VALUES ('62', '130202', '路南区', '130200');
INSERT INTO `areas` VALUES ('63', '130203', '路北区', '130200');
INSERT INTO `areas` VALUES ('64', '130204', '古冶区', '130200');
INSERT INTO `areas` VALUES ('65', '130205', '开平区', '130200');
INSERT INTO `areas` VALUES ('66', '130207', '丰南区', '130200');
INSERT INTO `areas` VALUES ('67', '130208', '丰润区', '130200');
INSERT INTO `areas` VALUES ('68', '130223', '滦　县', '130200');
INSERT INTO `areas` VALUES ('69', '130224', '滦南县', '130200');
INSERT INTO `areas` VALUES ('70', '130225', '乐亭县', '130200');
INSERT INTO `areas` VALUES ('71', '130227', '迁西县', '130200');
INSERT INTO `areas` VALUES ('72', '130229', '玉田县', '130200');
INSERT INTO `areas` VALUES ('73', '130230', '唐海县', '130200');
INSERT INTO `areas` VALUES ('74', '130281', '遵化市', '130200');
INSERT INTO `areas` VALUES ('75', '130283', '迁安市', '1
30200');
INSERT INTO `areas` VALUES ('76', '130301', '市辖区', '130300');
INSERT INTO `areas` VALUES ('77', '130302', '海港区', '130300');
INSERT INTO `areas` VALUES ('78', '130303', '山海关区', '130300');
INSERT INTO `areas` VALUES ('79', '130304', '北戴河区', '130300');
INSERT INTO `areas` VALUES ('80', '130321', '青龙满族自治县', '130300');
INSERT INTO `areas` VALUES ('81', '130322', '昌黎县', '130300');
INSERT INTO `areas` VALUES ('82', '130323', '抚宁县', '130300');
INSERT INTO `areas` VALUES ('83', '130324', '卢龙县', '130300');
INSERT INTO `areas` VALUES ('84', '130401', '市辖区', '130400');
INSERT INTO `areas` VALUES ('85', '130402', '邯山区', '130400');
INSERT INTO `areas` VALUES ('86', '130403', '丛台区', '130400');
INSERT INTO `areas` VALUES ('87', '130404', '复兴区', '130400');
INSERT INTO `areas` VALUES ('88', '130406', '峰峰矿区', '130400');
INSERT INTO `areas` VALUES ('89', '130421', '邯郸县', '130400');
INSERT INTO `areas` VALUES ('90', '130423', '临漳县', '130400');
INSERT INTO `areas` VALUES ('91', '130424', '成安县', '130400');
INSERT INTO `areas` VALUES ('92', '130425', '大名县', '130400');
INSERT INTO `areas` VALUES ('93', '130426', '涉　县', '130400');
INSERT INTO `areas` VALUES ('94', '130427', '磁　县', '130400');
INSERT INTO `areas` VALUES ('95', '130428', '肥乡县', '130400');
INSERT INTO `areas` VALUES ('96', '130429', '永年县', '130400');
INSERT INTO `areas` VALUES ('97', '130430', '邱　县', '130400');
INSERT INTO `areas` VALUES ('98', '130431', '鸡泽县', '130400');
INSERT INTO `areas` VALUES ('99', '130432', '广平县', '130400');
INSERT INTO `areas` VALUES ('100', '130433', '馆陶县', '130400');
INSERT INTO `areas` VALUES ('101', '130434', '魏　县', '130400');
INSERT INTO `areas` VALUES ('102', '130435', '曲周县', '130400');
INSERT INTO `areas` VALUES ('103', '130481', '武安市', '130400');
INSERT INTO `areas` VALUES ('104', '130501', '市辖区', '130500');
INSERT INTO `areas` VALUES ('105', '130502', '桥东区', '130500');
INSERT INTO `areas` VALUES ('106', '130503', '桥西区', '130500');
INSERT INTO `areas` VALUES ('107', '130521', '邢台县', '130500');
INSERT INTO `areas` VALUES ('108', '130522', '临城县', '130500');
INSERT INTO `areas` VALUES ('109', '130523', '内丘县', '130500');
INSERT INTO `areas` VALUES ('110', '130524', '柏乡县', '130500');
INSERT INTO `areas` VALUES ('111', '130525', '隆尧县', '130500');
INSERT INTO `areas` VALUES ('112', '130526', '任　县', '130500');
INSERT INTO `areas` VALUES ('113', '130527', '南和县', '130500');
INSERT INTO `areas` VALUES ('114', '130528', '宁晋县', '130500');
INSERT INTO `areas` VALUES ('115', '130529', '巨鹿县', '130500');
INSERT INTO `areas` VALUES ('116', '130530', '新河县', '130500');
INSERT INTO `areas` VALUES ('117', '130531', '广宗县', '130500');
INSERT INTO `areas` VALUES ('118', '130532', '平乡
县', '130500');
INSERT INTO `areas` VALUES ('119', '130533', '威　县', '130500');
INSERT INTO `areas` VALUES ('120', '130534', '清河县', '130500');
INSERT INTO `areas` VALUES ('121', '130535', '临西县', '130500');
INSERT INTO `areas` VALUES ('122', '130581', '南宫市', '130500');
INSERT INTO `areas` VALUES ('123', '130582', '沙河市', '130500');
INSERT INTO `areas` VALUES ('124', '130601', '市辖区', '130600');
INSERT INTO `areas` VALUES ('125', '130602', '新市区', '130600');
INSERT INTO `areas` VALUES ('126', '130603', '北市区', '130600');
INSERT INTO `areas` VALUES ('127', '130604', '南市区', '130600');
INSERT INTO `areas` VALUES ('128', '130621', '满城县', '130600');
INSERT INTO `areas` VALUES ('129', '130622', '清苑县', '130600');
INSERT INTO `areas` VALUES ('130', '130623', '涞水县', '130600');
INSERT INTO `areas` VALUES ('131', '130624', '阜平县', '130600');
INSERT INTO `areas` VALUES ('132', '130625', '徐水县', '130600');
INSERT INTO `areas` VALUES ('133', '130626', '定兴县', '130600');
INSERT INTO `areas` VALUES ('134', '130627', '唐　县', '130600');
INSERT INTO `areas` VALUES ('135', '130628', '高阳县', '130600');
INSERT INTO `areas` VALUES ('136', '130629', '容城县', '130600');
INSERT INTO `areas` VALUES ('137', '130630', '涞源县', '130600');
INSERT INTO `areas` VALUES ('138', '130631', '望都县', '130600');
INSERT INTO `areas` VALUES ('139', '130632', '安新县', '130600');
INSERT INTO `areas` VALUES ('140', '130633', '易　县', '130600');
INSERT INTO `areas` VALUES ('141', '130634', '曲阳县', '130600');
INSERT INTO `areas` VALUES ('142', '130635', '蠡　县', '130600');
INSERT INTO `areas` VALUES ('143', '130636', '顺平县', '130600');
INSERT INTO `areas` VALUES ('144', '130637', '博野县', '130600');
INSERT INTO `areas` VALUES ('145', '130638', '雄　县', '130600');
INSERT INTO `areas` VALUES ('146', '130681', '涿州市', '130600');
INSERT INTO `areas` VALUES ('147', '130682', '定州市', '130600');
INSERT INTO `areas` VALUES ('148', '130683', '安国市', '130600');
INSERT INTO `areas` VALUES ('149', '130684', '高碑店市', '130600');
INSERT INTO `areas` VALUES ('150', '130701', '市辖区', '130700');
INSERT INTO `areas` VALUES ('151', '130702', '桥东区', '130700');
INSERT INTO `areas` VALUES ('152', '130703', '桥西区', '130700');
INSERT INTO `areas` VALUES ('153', '130705', '宣化区', '130700');
INSERT INTO `areas` VALUES ('154', '130706', '下花园区', '130700');
INSERT INTO `areas` VALUES ('155', '130721', '宣化县', '130700');
INSERT INTO `areas` VALUES ('156', '130722', '张北县', '130700');
INSERT INTO `areas` VALUES ('157', '130723', '康保县', '130700');
INSERT INTO `areas` VALUES ('158', '130724', '沽源县', '130700');
INSERT INTO `areas` VALUES ('159', '130725', '尚义县', '130700');
INSERT INTO `areas` VALUES ('160', '130726', '蔚　县', '130700');
INSERT INTO `areas` VALUES ('161', '1
30727', '阳原县', '130700');
INSERT INTO `areas` VALUES ('162', '130728', '怀安县', '130700');
INSERT INTO `areas` VALUES ('163', '130729', '万全县', '130700');
INSERT INTO `areas` VALUES ('164', '130730', '怀来县', '130700');
INSERT INTO `areas` VALUES ('165', '130731', '涿鹿县', '130700');
INSERT INTO `areas` VALUES ('166', '130732', '赤城县', '130700');
INSERT INTO `areas` VALUES ('167', '130733', '崇礼县', '130700');
INSERT INTO `areas` VALUES ('168', '130801', '市辖区', '130800');
INSERT INTO `areas` VALUES ('169', '130802', '双桥区', '130800');
INSERT INTO `areas` VALUES ('170', '130803', '双滦区', '130800');
INSERT INTO `areas` VALUES ('171', '130804', '鹰手营子矿区', '130800');
INSERT INTO `areas` VALUES ('172', '130821', '承德县', '130800');
INSERT INTO `areas` VALUES ('173', '130822', '兴隆县', '130800');
INSERT INTO `areas` VALUES ('174', '130823', '平泉县', '130800');
INSERT INTO `areas` VALUES ('175', '130824', '滦平县', '130800');
INSERT INTO `areas` VALUES ('176', '130825', '隆化县', '130800');
INSERT INTO `areas` VALUES ('177', '130826', '丰宁满族自治县', '130800');
INSERT INTO `areas` VALUES ('178', '130827', '宽城满族自治县', '130800');
INSERT INTO `areas` VALUES ('179', '130828', '围场满族蒙古族自治县', '130800');
INSERT INTO `areas` VALUES ('180', '130901', '市辖区', '130900');
INSERT INTO `areas` VALUES ('181', '130902', '新华区', '130900');
INSERT INTO `areas` VALUES ('182', '130903', '运河区', '130900');
INSERT INTO `areas` VALUES ('183', '130921', '沧　县', '130900');
INSERT INTO `areas` VALUES ('184', '130922', '青　县', '130900');
INSERT INTO `areas` VALUES ('185', '130923', '东光县', '130900');
INSERT INTO `areas` VALUES ('186', '130924', '海兴县', '130900');
INSERT INTO `areas` VALUES ('187', '130925', '盐山县', '130900');
INSERT INTO `areas` VALUES ('188', '130926', '肃宁县', '130900');
INSERT INTO `areas` VALUES ('189', '130927', '南皮县', '130900');
INSERT INTO `areas` VALUES ('190', '130928', '吴桥县', '130900');
INSERT INTO `areas` VALUES ('191', '130929', '献　县', '130900');
INSERT INTO `areas` VALUES ('192', '130930', '孟村回族自治县', '130900');
INSERT INTO `areas` VALUES ('193', '130981', '泊头市', '130900');
INSERT INTO `areas` VALUES ('194', '130982', '任丘市', '130900');
INSERT INTO `areas` VALUES ('195', '130983', '黄骅市', '130900');
INSERT INTO `areas` VALUES ('196', '130984', '河间市', '130900');
INSERT INTO `areas` VALUES ('197', '131001', '市辖区', '131000');
INSERT INTO `areas` VALUES ('198', '131002', '安次区', '131000');
INSERT INTO `areas` VALUES ('199', '131003', '广阳区', '131000');
INSERT INTO `areas` VALUES ('200', '131022', '固安县', '131000');
INSERT INTO `areas` VALUES ('201', '131023', '永清县', '131000');
INSERT INTO `areas` VALUES ('202', '131024', '香河县', '131000');
INSERT INTO `areas` VALUES ('20

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。