全国省市县区划代码2020年

CREATE TABLE `tb_json` ( `code` varchar(255) DEFAULT NULL, `num` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `up` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110000', '1', '北京市', '000000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110101', '3', '东城区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110102', '3', '西城区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110105', '3', '朝阳区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110106', '3', '丰台区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110107', '3', '石景山区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110108', '3', '海淀区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110109', '3', '门头沟区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110111', '3', '房山区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110112', '3', '通州区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110113', '3', '顺义区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110114', '3', '昌平区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110115', '3', '大兴区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110116', '3', '怀柔区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110117', '3', '平谷区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110118', '3', '密云区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('110119', '3', '延庆区', '110000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120000', '1', '天津市', '000000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120101', '3', '和平区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120102', '3', '河东区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120103', '3', '河西区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120104', '3', '南开区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120105', '3', '河北区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120106', '3', '红桥区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120110', '3', '东丽区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120111', '3', '西青区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120112', '3', '津南区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120113', '3', '北辰区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120114', '3', '武清区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120115', '3', '宝坻区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120116', '3', '滨海新区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120117', '3', '宁河区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120118', '3', '静海区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('120119', '3', '蓟州区', '120000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130000', '1', '河北省', '000000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130100', '2', '石家庄市', '130000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130102', '3', '长安区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130104', '3', '桥西区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130105', '3', '新华区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130107', '3', '井陉矿区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130108', '3', '裕华区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130109', '3', '藁城区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130110', '3', '鹿泉区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130111', '3', '栾城区', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130121', '3', '井陉县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130123', '3', '正定县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130125', '3', '行唐县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130126', '3', '灵寿县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130127', '3', '高邑县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130128', '3', '深泽县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130129', '3', '赞皇县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130130', '3', '无极县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130131', '3', '平山县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130132', '3', '元氏县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130133', '3', '赵县', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130181', '3', '辛集市', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130183', '3', '晋州市', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130184', '3', '新乐市', '130100'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130200', '2', '唐山市', '130000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130202', '3', '路南区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130203', '3', '路北区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130204', '3', '古冶区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130205', '3', '开平区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130207', '3', '丰南区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130208', '3', '丰润区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130209', '3', '曹妃甸区', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130224', '3', '滦南县', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130225', '3', '乐亭县', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130227', '3', '迁西县', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130229', '3', '玉田县', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130281', '3', '遵化市', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130283', '3', '迁安市', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130284', '3', '滦州市', '130200'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130300', '2', '秦皇岛市', '130000'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130302', '3', '海港区', '130300'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130303', '3', '山海关区', '130300'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130304', '3', '北戴河区', '130300'); INSERT INTO `tb_json`(`code`, `num`, `name`, `up`) VALUES ('130306', '3', '抚宁区', '130300'); INSERT INTO `tb_json`(`code`, `num`, `name`,