本数据库收录了6457条身份证号码与其对应的户籍信息,旨在提供一个便于研究和数据分析的身份验证及人口分布参考工具。
根据身份证前6位的信息,整理了6457条数据,并形成了省市区县三级地区表。以下是部分案例:
INSERT INTO `area` VALUES (1, 0, 1, 11, 1100, 110000, 北京市);
INSERT INTO `area` VALUES (2, 1, 2, 11, 1101, 110100, 市辖区);
INSERT INTO `area` VALUES (3, 2, 3, 11, 1101, 110101, 东城区);
INSERT INTO `area` VALUES (4, 2, 3, 11, 1101, 110102, 西城区);
INSERT INTO `area` VALUES (5, 2, 3, 11, 1101, 110103, 崇文区);
INSERT INTO `area` VALUES (6, 2, 3, 11, 1101, 110104, 宣武区);
INSERT INTO `area` VALUES (7, 2, 3, 11, 1101, 110105, 朝阳区);
INSERT INTO `area` VALUES (8, 2, 3, 11, 1101, 110106, 丰台区);
INSERT INTO `area` VALUES (9, 2, 3, 11, 1101, 110107, 石景山区);
INSERT INTO `area` VALUES (10, 2, 3, 11, 1101, 110108, 海淀区);
INSERT INTO `area` VALUES (11, 2, 3, 11, 1101, 110109, 门头沟区);
INSERT INTO `area` VALUES (12, 2, 3, 11, 1101, 110110, 燕山区);
INSERT INTO `area` VALUES (13, 2, 3, 11, 1101, 110111, 房山区);
INSERT INTO `area` VALUES (14, 2, 3, 11, 1101, 110112, 通州区);
INSERT INTO `area` VALUES (15, 2, 3, 11, 1101, 110113, 顺义区);
INSERT INTO `area` VALUES (16, 2, 3, 11, 1101, 110114, 昌平区);
INSERT INTO `area` VALUES (17, 2, 3, 11, 1101, 110115, 大兴区);
INSERT INTO `area` VALUES (18, 2, 3, 11, 1101, 110116, 怀柔区);
INSERT INTO `area` VALUES (19, 2, 3, 11, 1101, 110117, 平谷区);