area_code_info.sql

java GUI 实现的简单的身份证号码解析系统

USE pubs
GO

CREATE TABLE area_code_info
(
    [id] INT IDENTITY(1,1),
    area_code CHAR(6) PRIMARY KEY,
    area_name VARCHAR(36) NOT NULL
)

INSERT INTO area_code_info VALUES('110100','北京市市辖区')
INSERT INTO area_code_info VALUES('110101','北京市东城区')
INSERT INTO area_code_info VALUES('110102','北京市西城区')
INSERT INTO area_code_info VALUES('110103','北京市崇文区')
INSERT INTO area_code_info VALUES('110104','北京市宣武区')
INSERT INTO area_code_info VALUES('110105','北京市朝阳区')
INSERT INTO area_code_info VALUES('110106','北京市丰台区')
INSERT INTO area_code_info VALUES('110107','北京市石景山区')
INSERT INTO area_code_info VALUES('110108','北京市海淀区')
INSERT INTO area_code_info VALUES('110109','北京市门头沟区')
INSERT INTO area_code_info VALUES('110111','北京市房山区')
INSERT INTO area_code_info VALUES('110112','北京市通州区')
INSERT INTO area_code_info VALUES('110113','北京市顺义区')
INSERT INTO area_code_info VALUES('110114','北京市昌平区')
INSERT INTO area_code_info VALUES('110115','北京市大兴区')
INSERT INTO area_code_info VALUES('110116','北京市怀柔区')
INSERT INTO area_code_info VALUES('110117','北京市平谷区')
INSERT INTO area_code_info VALUES('110200','北京市北京市县')
INSERT INTO area_code_info VALUES('110228','北京市密云县')
INSERT INTO area_code_info VALUES('110229','北京市延庆县')
INSERT INTO area_code_info VALUES('120000','天津市天津市')
INSERT INTO area_code_info VALUES('120100','天津市市辖区')
INSERT INTO area_code_info VALUES('120101','天津市和平区')
INSERT INTO area_code_info VALUES('120102','天津市河东区')
INSERT INTO area_code_info VALUES('120103','天津市河西区')
INSERT INTO area_code_info VALUES('120104','天津市南开区')
INSERT INTO area_code_info VALUES('120105','天津市河北区')
INSERT INTO area_code_info VALUES('120106','天津市红桥区')
INSERT INTO area_code_info VALUES('120107','天津市塘沽区')
INSERT INTO area_code_info VALUES('120108','天津市汉沽区')
INSERT INTO area_code_info VALUES('120109','天津市大港区')
INSERT INTO area_code_info VALUES('120110','天津市东丽区')
INSERT INTO area_code_info VALUES('120111','天津市西青区')
INSERT INTO area_code_info VALUES('120112','天津市津南区')
INSERT INTO area_code_info VALUES('120113','天津市北辰区')
INSERT INTO area_code_info VALUES('120114','天津市武清区')
INSERT INTO area_code_info VALUES('120115','天津市宝坻区')
INSERT INTO area_code_info VALUES('120200','天津市县')
INSERT INTO area_code_info VALUES('120221','天津市宁河县')
INSERT INTO area_code_info VALUES('120223','天津市静海县')
INSERT INTO area_code_info VALUES('120225','天津市蓟县')
INSERT INTO area_code_info VALUES('130000','河北省河北省')
INSERT INTO area_code_info VALUES('130100','河北省石家庄市')
INSERT INTO area_code_info VALUES('130101','河北省市辖区')
INSERT INTO area_code_info VALUES('130102','河北省长安区')
INSERT INTO area_code_info VALUES('130103','河北省桥东区')
INSERT INTO area_code_info VALUES('130104','河北省桥西区')
INSERT INTO area_code_info VALUES('130105','河北省新华区')
INSERT INTO area_code_info VALUES('130107','河北省井陉矿区')
INSERT INTO area_code_info VALUES('130108','河北省裕华区')
INSERT INTO area_code_info VALUES('130121','河北省井陉县')
INSERT INTO area_code_info VALUES('130123','河北省正定县')
INSERT INTO area_code_info VALUES('130124','河北省栾城县')
INSERT INTO area_code_info VALUES('130125','河北省行唐县')
INSERT INTO area_code_info VALUES('130126','河北省灵寿县')
INSERT INTO area_code_info VALUES('130127','河北省高邑县')
INSERT INTO area_code_info VALUES('130128','河北省深泽县')
INSERT INTO area_code_info VALUES('130129','河北省赞皇县')
INSERT INTO area_code_info VALUES('130130','河北省无极县')
INSERT INTO area_code_info VALUES('130131','河北省平山县')
INSERT INTO area_code_info VALUES('130132','河北省元氏县')
INSERT INTO area_code_info VALUES('130133','河北省赵县')
INSERT INTO area_code_info VALUES('130181','河北省辛集市')
INSERT INTO area_code_info VALUES('130182','河北省藁城市')
INSERT INTO area_code_info VALUES('130183','河北省晋州市')
INSERT INTO area_code_info VALUES('130184','河北省新乐市')
INSERT INTO area_code_info VALUES('130185','河北省鹿泉市')
INSERT INTO area_code_info VALUES('130200','河北省唐山市')
INSERT INTO area_code_info VALUES('130201','河北省市辖区')
INSERT INTO area_code_info VALUES('130202','河北省路南区')
INSERT INTO area_code_info VALUES('130203','河北省路北区')
INSERT INTO area_code_info VALUES('130204','河北省古冶区')
INSERT INTO area_code_info VALUES('130205','河北省开平区')
INSERT INTO area_code_info VALUES('130207','河北省丰南区')
INSERT INTO area_code_info VALUES('130208','河北省丰润区')
INSERT INTO area_code_info VALUES('130223','河北省滦县')
INSERT INTO area_code_info VALUES('130224','河北省滦南县')
INSERT INTO area_code_info VALUES('130225','河北省乐亭县')
INSERT INTO area_code_info VALUES('130227','河北省迁西县')
INSERT INTO area_code_info VALUES('130229','河北省玉田县')
INSERT INTO area_code_info VALUES('130230','河北省唐海县')
INSERT INTO area_code_info VALUES('130281','河北省遵化市')
INSERT INTO area_code_info VALUES('130283','河北省迁安市')
INSERT INTO area_code_info VALUES('130300','河北省秦皇岛市')
INSERT INTO area_code_info VALUES('130301','河北省市辖区')
INSERT INTO area_code_info VALUES('130302','河北省海港区')
INSERT INTO area_code_info VALUES('130303','河北省山海关区')
INSERT INTO area_code_info VALUES('130304','河北省北戴河区')
INSERT INTO area_code_info VALUES('130321','河北省青龙满族自治县')
INSERT INTO area_code_info VALUES('130322','河北省昌黎县')
INSERT INTO area_code_info VALUES('130323','河北省抚宁县')
INSERT INTO area_code_info VALUES('130324','河北省卢龙县')
INSERT INTO area_code_info VALUES('130400','河北省邯郸市')
INSERT INTO area_code_info VALUES('130401','河北省市辖区')
INSERT INTO area_code_info VALUES('130402','河北省邯山区')
INSERT INTO area_code_info VALUES('130403','河北省丛台区')
INSERT INTO area_code_info VALUES('130404','河北省复兴区')
INSERT INTO area_code_info VALUES('130406','河北省峰峰矿区')
INSERT INTO area_code_info VALUES('130421','河北省邯郸县')
INSERT INTO area_code_info VALUES('130423','河北省临漳县')
INSERT INTO area_code_info VALUES('130424','河北省成安县')
INSERT INTO area_code_info VALUES('130425','河北省大名县')
INSERT INTO area_code_info VALUES('130426','河北省涉县')
INSERT INTO area_code_info VALUES('130427','河北省磁县')
INSERT INTO area_code_info VALUES('130428','河北省肥乡县')
INSERT INTO area_code_info VALUES('130429','河北省永年县')
INSERT INTO area_code_info VALUES('130430','河北省邱县')
INSERT INTO area_code_info VALUES('130431','河北省鸡泽县')
INSERT INTO area_code_info VALUES('130432','河北省广平县')
INSERT INTO area_code_info VALUES('130433','河北省馆陶县')
INSERT INTO area_code_info VALUES('130434','河北省魏县')
INSERT INTO area_code_info VALUES('130435','河北省曲周县')
INSERT INTO area_code_info VALUES('130481','河北省武安市')
INSERT INTO area_code_info VALUES('130500','河北省邢台市')
INSERT INTO area_code_info VALUES('130501','河北省市辖区')
INSERT INTO area_code_info VALUES('130502','河北省桥东区')
INSERT INTO area_code_info VALUES('130503','河北省桥西区')
INSERT INTO area_code_info VALUES('130521','河北省邢台县')
INSERT INTO area_code_info VALUES('130522','河北省临城县')
INSERT INTO area_code_info VALUES('130523','河北省内丘县')
INSERT INTO area_code_info VALUES('130524','河北省柏乡县')
INSERT INTO area_code_info VALUES('130525','河北省隆尧县')
INSERT INTO area_code_info VALUES('130526','河北省任县')
INSERT INTO area_code_info VALUES('130527','河北省南和县')
INSERT INTO area_code_info VALUES('130528','河北省宁晋县')
INSERT INTO area_code_info VALUES('130529','河北省巨鹿县')
INSERT INTO area_code_info VALUES('130530','河北省新河县')
INSERT INTO area_code_info VALUES('130531','河北省广宗县')
INSERT INTO area_code_info VALUES('130532','河北省平乡县')
INSERT INTO area_code_info VALUES('130533','河北省威县')
INSERT INTO area_code_info VALUES('130534','河北省清河县')
INSERT INTO area_code_info VALUES('130535','河北省临西县')
INSERT INTO area_code_info VALUES('130581','河北省南宫市')
INSERT INTO area_code_info VALUES('130582','河北省沙河市')
INSERT INTO area_code_info VALUES('130600','河北省保定市')
INSERT INTO area_code_info VALUES('130601','河北省市辖区')
INSERT INTO area_code_info VALUES('130602','河北省新市区')
INSERT INTO area_code_info VALUES('130603','河北省北市区')
INSERT INTO area_code_info VALUES('130604','河北省南市区')
INSERT INTO area_code_info VALUES('130621','河北省满城县')
INSERT INTO area_code_info VALUES('130622','河北省清苑县')
INSERT INTO area_code_info VALUES('130623','河北省涞水县')
INSERT INTO area_code_info VALUES('130624','河北省阜平县')
INSERT INTO area_code_info VALUES('130625','河北省徐水县')
INSERT INTO area_code_info VALUES('130626','河北省定兴县')
INSERT INTO area_code_info VALUES('130627','河北省唐县')
INSERT INTO area_code_info VALUES('130628','河北省高阳县')
INSERT INTO area_code_info VALUES('130629','河北省容城县')
INSERT INTO area_code_info VALUES('130630','河北省涞源县')
INSERT INTO area_code_info VALUES('130631','河北省望都县')
INSERT INTO area_code_info VALUES('130632','河北省安新县')
INSERT INTO area_code_info VALUES('130633','河北省易县')
INSERT INTO area_code_info VALUES('130634','河北省曲阳县')
INSERT INTO area_code_info VALUES('130635','河北省蠡县')
INSERT INTO area_code_info VALUES('130636','河北省顺平县')
INSERT INTO area_code_info VALUES('130637','河北省博野县')
INSERT INTO area_code_info VALUES('130638','河北省雄县')
INSERT INTO area_code_info VALUES('130681','河北省涿州市')
INSERT INTO area_code_info VALUES('130682','河北省定州市')
INSERT INTO area_code_info VALUES('130683','河北省安国市')
INSERT INTO area_code_info VALUES('130684','河北省高碑店市')
INSERT INTO area_code_info VALUES('130700','河北省张家口市')
INSERT INTO area_code_info VALUES('130701','河北省市辖区')
INSERT INTO area_code_info VALUES('130702','河北省桥东区')
INSERT INTO area_code_info VALUES('130703','河北省桥西区')
INSERT INTO area_code_info VALUES('130705','河北省宣化区')
INSERT INTO area_code_info VALUES('130706','河北省下花园区')
INSERT INTO area_code_info VALUES('130721','河北省宣化县')
INSERT INTO area_code_info VALUES('130722','河北省张北县')
INSERT INTO area_code_info VALUES('130723','河北省康保县')
INSERT INTO area_code_info VALUES('130724','河北省沽源县')
INSERT INTO area_code_info VALUES('130725','河北省尚义县')
INSERT INTO area_code_info VALUES('130726','河北省蔚县')
INSERT INTO area_code_info VALUES('130727','河北省阳原县')
INSERT INTO area_code_info VALUES('130728','河北省怀安县')
INSERT INTO area_code_info VALUES('130729','河北省万全县')
INSERT INTO area_code_info VALUES('130730','河北省怀来县')
INSERT INTO area_code_info VALUES('130731','河北省涿鹿县')
INSERT INTO area_code_info VALUES('130732','河北省赤城县')
INSERT INTO area_code_info VALUES('130733','河北省崇礼县')
INSERT INTO area_code_info VALUES('130800','河北省承德市')
INSERT INTO area_code_info VALUES('130801','河北省市辖区')
INSERT INTO area_code_info VALUES('130802','河北省双桥区')