2018最新全国省市县乡镇村5级行政编码 mysql 数据库

/* Navicat Premium Data Transfer Source Server Type : MySQL Source Server Version : 50722 Source Host : 127.0.0.1 Target Server Type : MySQL Target Server Version : 50722 File Encoding : utf-8 Date: 09/18/2019 17:40:17 PM */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `kx_region_new` -- ---------------------------- DROP TABLE IF EXISTS `kx_region_new`; CREATE TABLE `kx_region_new` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `region_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '区域编码', `region_parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父级区域编码', `region_name` varchar(120) NOT NULL DEFAULT '' COMMENT '地区名称', `region_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '地区等级1=省 2=市 3=区 4=乡镇街道 5=村/社区', `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '状态 0=禁用 1=正常', PRIMARY KEY (`id`), UNIQUE KEY `uniq_region_id` (`region_id`) USING BTREE, KEY `idx_region_parent_id` (`region_parent_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=713511 DEFAULT CHARSET=utf8mb4 COMMENT='全国省市县乡镇村行政编码'; -- ---------------------------- -- Records of `kx_region_new` -- ---------------------------- BEGIN; INSERT INTO `kx_region_new` VALUES ('1', '1', '0', '全国', '0', '1'), ('2', '110000', '1', '北京市', '1', '1'), ('3', '120000', '1', '天津市', '1', '1'), ('4', '130000', '1', '河北省', '1', '1'), ('5', '140000', '1', '山西省', '1', '1'), ('6', '150000', '1', '内蒙古自治区', '1', '1'), ('7', '210000', '1', '辽宁省', '1', '1'), ('8', '220000', '1', '吉林省', '1', '1'), ('9', '230000', '1', '黑龙江省', '1', '1'), ('10', '310000', '1', '上海市', '1', '1'), ('11', '320000', '1', '江苏省', '1', '1'), ('12', '330000', '1', '浙江省', '1', '1'), ('13', '340000', '1', '安徽省', '1', '1'), ('14', '350000', '1', '福建省', '1', '1'), ('15', '360000', '1', '江西省', '1', '1'), ('16', '370000', '1', '山东省', '1', '1'), ('17', '410000', '1', '河南省', '1', '1'), ('18', '420000', '1', '湖北省', '1', '1'), ('19', '430000', '1', '湖南省', '1', '1'), ('20', '440000', '1', '广东省', '1', '1'), ('21', '450000', '1', '广西壮族自治区', '1', '1'), ('22', '460000', '1', '海南省', '1', '1'), ('23', '500000', '1', '重庆市', '1', '1'), ('24', '510000', '1', '四川省', '1', '1'), ('25', '520000', '1', '贵州省', '1', '1'), ('26', '530000', '1', '云南省', '1', '1'), ('27', '540000', '1', '西藏自治区', '1', '1'), ('28', '610000', '1', '陕西省', '1', '1'), ('29', '620000', '1', '甘肃省', '1', '1'), ('30', '630000', '1', '青海省', '1', '1'), ('31', '640000', '1', '宁夏回族自治区', '1', '1'), ('32', '650000', '1', '新疆维吾尔自治区', '1', '1'), ('33', '710000', '1', '台湾', '1', '1'), ('34', '810000', '1', '香港特别行政区', '1', '1'), ('35', '820000', '1', '澳门特别行政区', '1', '1'), ('36', '110100', '110000', '市辖区', '2', '1'), ('37', '120100', '120000', '市辖区', '2', '1'), ('38', '130100', '130000', '石家庄市', '2', '1'), ('39', '130200', '130000', '唐山市', '2', '1'), ('40', '130300', '130000', '秦皇岛市', '2', '1'), ('41', '130400', '130000', '邯郸市', '2', '1'), ('42', '130500', '130000', '邢台市', '2', '1'), ('43', '130600', '130000', '保定市', '2', '1'), ('44', '130700', '130000', '张家口市', '2', '1'), ('45', '130800', '130000', '承德市', '2', '1'), ('46', '130900', '130000', '沧州市', '2', '1'), ('47', '131000', '130000', '廊坊市', '2', '1'), ('48', '131100', '130000', '衡水市', '2', '1'), ('49', '140100', '140000', '太原市', '2', '1'), ('50', '140200', '140000', '大同市', '2', '1'), ('51', '140300', '140000', '阳泉市', '2', '1'), ('52', '140400', '140000', '长治市', '2', '1'), ('53', '140500', '140000', '晋城市', '2', '1'), ('54', '140600', '140000', '朔州市', '2', '1'), ('55', '140700', '140000', '晋中市', '2', '1'), ('56', '140800', '140000', '运城市', '2', '1'), ('57', '140900', '140000', '忻州市', '2', '1'), ('58', '141000', '140000', '临汾市', '2', '1'), ('59', '141100', '140000', '吕梁市', '2', '1'), ('60', '150100', '150000', '呼和浩特市', '2', '1'), ('61', '150200', '150000', '包头市', '2', '1'), ('62', '150300', '150000', '乌海市', '2', '1'), ('63', '150400', '150000', '赤峰市', '2', '1'), ('64', '150500', '150000', '通辽市', '2', '1'), ('65', '150600', '150000', '鄂尔多斯市', '2', '1'), ('66', '150700', '150000', '呼伦贝尔市', '2', '1'), ('67', '150800', '150000', '巴彦淖尔市', '2', '1'), ('68', '150900', '150000', '乌兰察布市', '2', '1'), ('69', '152200', '150000', '兴安盟', '2', '1'), ('70', '152500', '150000', '锡林郭勒盟', '2', '1'), ('71', '152900', '150000', '阿拉善盟', '2', '1'), ('72', '210100', '210000', '沈阳市', '2', '1'), ('73', '210200', '210000', '大连市', '2', '1'), ('74', '210300', '210000', '鞍山市', '2', '1'), ('75', '210400', '210000', '抚顺市', '2', '1'), ('76', '210500', '210000', '本溪市', '2', '1'), ('77', '210600', '210000', '丹东市', '2', '1'), ('78', '210700', '210000', '锦州市', '2', '1'), ('79', '210800', '210000', '营口市', '2', '1'), ('80', '210900', '210000', '阜新市', '2', '1'), ('81', '211000', '210000', '辽阳市', '2', '1'), ('82', '211100', '210000', '盘锦市', '2', '1'), ('83', '211200', '210000', '铁岭市', '2', '1'), ('84', '211300', '210000', '朝阳市', '2', '1'), ('85', '211400', '210000', '葫芦岛市', '2', '1'), ('86', '220100', '220000', '长春市', '2', '1'), ('87', '220200', '220000', '吉林市', '2', '1'), ('88', '220300', '220000', '四平市', '2', '1'), ('89', '220400', '220000', '辽源市', '2', '1'), ('90', '220500', '220000', '通化市', '2', '1'), ('91', '220600', '220000', '白山市', '2', '1'), ('92', '220700', '220000', '松原市', '2', '1'), ('93', '220800', '220000', '白城市', '2', '1'), ('94', '222400', '220000', '延边朝鲜族自治州', '2', '1'), ('95', '230100', '230000', '哈尔滨市', '2', '1'), ('96', '230200', '230000', '齐齐哈尔市', '2', '1'), ('97', '230300', '230000', '鸡西市', '2', '1'), ('98', '230400', '230000', '鹤岗市', '2', '1'), ('99', '230500', '230000', '双鸭山市', '2', '1'), ('100', '230600', '230000', '大庆市', '2', '1'), ('101', '230700', '230000', '伊春市', '2', '1'), ('102', '230800', '230000', '佳木斯市', '2', '1'), ('103', '230900', '230000', '七台河市', '2', '1'), ('104', '231000', '230000', '牡丹江市', '2', '1'), ('105', '231100', '230000', '黑河市', '2', '1'), ('106', '231200', '230000', '绥化市', '2', '1'), ('107', '232700', '230000', '大兴安岭地区', '2', '1'), ('108', '310100', '310000', '市辖区', '2', '1'), ('109', '320100', '320000', '南京市', '2', '1'), ('110', '320200', '320000', '无锡市', '2', '1'), ('111', '320300', '320000', '徐州市', '2', '1'), ('112', '320400', '320000', '常州市', '2', '1'), ('113', '320500', '320000', '苏州市', '2', '1'), ('114', '320600', '320000', '南通市', '2', '1'), ('115', '320700', '320000', '连云港市', '2', '1'), ('116', '320800', '320000', '淮安市', '2', '1'), ('117', '320900', '320000', '盐城市', '2', '1'), ('118', '321000', '320000', '扬州市', '2', '1'), ('119', '321100', '320000', '镇江市', '2', '1'), ('120', '321200', '320000', '泰州市', '2', '1'), ('121', '321300', '320000', '宿迁市', '2', '1'), ('122', '330100', '330000', '杭州市', '2', '1'), ('123', '330200', '330000', '宁波市', '2', '1'), ('124', '330300', '330000', '温州市', '2', '1'), ('125', '330400', '330000', '嘉兴市', '2', '1'), ('126', '330500', '330000', '湖州市', '2', '1'), ('127', '330600', '330000', '绍兴市', '2', '1'), ('128', '330700', '330000', '金华市', '2', '1'), ('129', '330800', '330000', '衢州市', '2', '1'), ('130', '