analysis-region.sql文件 2022年最新全国各省五级行政区划代码及名称数据（省-市-区县-乡镇-村）

-- -------------------------------------------------------- -- -------------------------------------------------------- -- 导出 表 china_area_access.analysis_region 结构 CREATE TABLE IF NOT EXISTS `analysis_region` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号ID', `parent_id` int(11) DEFAULT NULL COMMENT '父ID', `region_name` varchar(128) DEFAULT NULL COMMENT '名称', `region_code` varchar(128) DEFAULT NULL COMMENT '地区代码', `parent_code` varchar(128) DEFAULT NULL COMMENT '上级地区代码', `region_level` int(11) DEFAULT NULL COMMENT '层级', `region_sort` int(11) DEFAULT NULL COMMENT '排序', `region_name_en` varchar(256) DEFAULT NULL COMMENT '英文名称', `region_shortname_en` varchar(64) DEFAULT NULL COMMENT '英文简称', PRIMARY KEY (`id`), KEY `Index_parent_id` (`parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=704751 DEFAULT CHARSET=utf8 COMMENT='中国省市区数据库'; -- 正在导出表 china_area_access.analysis_region 的数据：~703,582 rows (大约) INSERT INTO `analysis_region` (`id`, `parent_id`, `region_name`, `region_code`, `parent_code`, `region_level`, `region_sort`, `region_name_en`, `region_shortname_en`) VALUES (1, 0, '北京市', '110000000000', '0', 1, 0, 'BeiJingShi', 'BJS'), (2, 1, '市辖区', '110100000000', '110000000000', 2, 0, 'ShiXiaQu', 'SXQ'), (3, 2, '东城区', '110101000000', '110100000000', 3, 0, 'DongChengQu', 'DCQ'), (4, 3, '东华门街道', '110101001000', '110101000000', 4, 0, 'DongHuaMenJieDao', 'DHMJD'), (5, 4, '多福巷社区', '110101001001', '110101001000', 5, 0, 'DuoFuXiangSheQu', 'DFXSQ'), (6, 4, '银闸社区', '110101001002', '110101001000', 5, 0, 'YinZhaSheQu', 'YZSQ'), (7, 4, '东厂社区', '110101001005', '110101001000', 5, 0, 'DongChangSheQu', 'DCSQ'), (8, 4, '智德社区', '110101001006', '110101001000', 5, 0, 'ZhiDeSheQu', 'ZDSQ'), (9, 4, '南池子社区', '110101001007', '110101001000', 5, 0, 'NanChiZiSheQu', 'NCZSQ'), (10, 4, '黄图岗社区', '110101001008', '110101001000', 5, 0, 'HuangTuGangSheQu', 'HTGSQ'), (11, 4, '灯市口社区', '110101001009', '110101001000', 5, 0, 'DengShiKouSheQu', 'DSKSQ'), (12, 4, '正义路社区', '110101001010', '110101001000', 5, 0, 'ZhengYiLuSheQu', 'ZYLSQ'), (13, 4, '甘雨社区', '110101001011', '110101001000', 5, 0, 'GanYuSheQu', 'GYSQ'), (14, 4, '台基厂社区', '110101001013', '110101001000', 5, 0, 'TaiJiChangSheQu', 'TJCSQ'), (15, 4, '韶九社区', '110101001014', '110101001000', 5, 0, 'ShaoJiuSheQu', 'SJSQ'), (16, 4, '王府井社区', '110101001015', '110101001000', 5, 0, 'WangFuJingSheQu', 'WFJSQ'), (17, 3, '景山街道', '110101002000', '110101000000', 4, 0, 'JingShanJieDao', 'JSJD'), (18, 17, '隆福寺社区', '110101002001', '110101002000', 5, 0, 'LongFuSiSheQu', 'LFSSQ'), (19, 17, '吉祥社区', '110101002002', '110101002000', 5, 0, 'JiXiangSheQu', 'JXSQ'), (20, 17, '黄化门社区', '110101002003', '110101002000', 5, 0, 'HuangHuaMenSheQu', 'HHMSQ'), (21, 17, '钟鼓社区', '110101002004', '110101002000', 5, 0, 'ZhongGuSheQu', 'ZGSQ'), (22, 17, '魏家社区', '110101002005', '110101002000', 5, 0, 'WeiJiaSheQu', 'WJSQ'), (23, 17, '汪芝麻社区', '110101002006', '110101002000', 5, 0, 'WangZhiMaSheQu', 'WZMSQ'), (24, 17, '景山东街社区', '110101002008', '110101002000', 5, 0, 'JingShanDongJieSheQu', 'JSDJSQ'), (25, 17, '皇城根北街社区', '110101002009', '110101002000', 5, 0, 'HuangChengGenBeiJieSheQu', 'HCGBJSQ'), (26, 3, '交道口街道', '110101003000', '110101000000', 4, 0, 'JiaoDaoKouJieDao', 'JDKJD'), (27, 26, '交东社区', '110101003001', '110101003000', 5, 0, 'JiaoDongSheQu', 'JDSQ'), (28, 26, '福祥社区', '110101003002', '110101003000', 5, 0, 'FuXiangSheQu', 'FXSQ'), (29, 26, '大兴社区', '110101003003', '110101003000', 5, 0, 'DaXingSheQu', 'DXSQ'), (30, 26, '府学社区', '110101003005', '110101003000', 5, 0, 'FuXueSheQu', 'FXSQ'), (31, 26, '鼓楼苑社区', '110101003007', '110101003000', 5, 0, 'GuLouYuanSheQu', 'GLYSQ'), (32, 26, '菊儿社区', '110101003008', '110101003000', 5, 0, 'JuErSheQu', 'JESQ'), (33, 26, '南锣鼓巷社区', '110101003009', '110101003000', 5, 0, 'NanLuoGuXiangSheQu', 'NLGXSQ'), (34, 3, '安定门街道', '110101004000', '110101000000', 4, 0, 'AnDingMenJieDao', 'ADMJD'), (35, 34, '交北头条社区', '110101004001', '110101004000', 5, 0, 'JiaoBeiTouTiaoSheQu', 'JBTTSQ'), (36, 34, '北锣鼓巷社区', '110101004002', '110101004000', 5, 0, 'BeiLuoGuXiangSheQu', 'BLGXSQ'), (37, 34, '国子监社区', '110101004003', '110101004000', 5, 0, 'GuoZiJianSheQu', 'GZJSQ'), (38, 34, '钟楼湾社区', '110101004004', '110101004000', 5, 0, 'ZhongLouWanSheQu', 'ZLWSQ'), (39, 34, '宝钞南社区', '110101004005', '110101004000', 5, 0, 'BaoChaoNanSheQu', 'BCNSQ'), (40, 34, '五道营社区', '110101004006', '110101004000', 5, 0, 'WuDaoYingSheQu', 'WDYSQ'), (41, 34, '分司厅社区', '110101004009', '110101004000', 5, 0, 'FenSiTingSheQu', 'FSTSQ'), (42, 34, '国旺社区', '110101004011', '110101004000', 5, 0, 'GuoWangSheQu', 'GWSQ'), (43, 34, '花园社区', '110101004012', '110101004000', 5, 0, 'HuaYuanSheQu', 'HYSQ'), (44, 3, '北新桥街道', '110101005000', '110101000000', 4, 0, 'BeiXinQiaoJieDao', 'BXQJD'), (45, 44, '海运仓社区', '110101005001', '110101005000', 5, 0, 'HaiYunCangSheQu', 'HYCSQ'), (46, 44, '北新仓社区', '110101005002', '110101005000', 5, 0, 'BeiXinCangSheQu', 'BXCSQ'), (47, 44, '门楼社区', '110101005004', '110101005000', 5, 0, 'MenLouSheQu', 'MLSQ'), (48, 44, '十三条社区', '110101005005', '110101005000', 5, 0, 'ShiSanTiaoSheQu', 'SSTSQ'), (49, 44, '民安社区', '110101005006', '110101005000', 5, 0, 'MinAnSheQu', 'MASQ'), (50, 44, '九道湾社区', '110101005008', '110101005000', 5, 0, 'JiuDaoWanSheQu', 'JDWSQ'), (51, 44, '北官厅社区', '110101005009', '110101005000', 5, 0, 'BeiGuanTingSheQu', 'BGTSQ'), (52, 44, '青龙社区', '110101005010', '110101005000', 5, 0, 'QingLongSheQu', 'QLSQ'), (53, 44, '小菊社区', '110101005011', '110101005000', 5, 0, 'XiaoJuSheQu', 'XJSQ'), (54, 44, '藏经馆社区', '110101005012', '110101005000', 5, 0, 'ZangJingGuanSheQu', 'ZJGSQ'), (55, 44, '草园社区', '110101005014', '110101005000', 5, 0, 'CaoYuanSheQu', 'CYSQ'), (56, 44, '前永康社区', '110101005016', '110101005000', 5, 0, 'QianYongKangSheQu', 'QYKSQ'), (57, 3, '东四街道', '110101006000', '110101000000', 4, 0, 'DongSiJieDao', 'DSJD'), (58, 57, '南门仓社区', '110101006001', '110101006000', 5, 0, 'NanMenCangSheQu', 'NMCSQ'), (59, 57, '七条社区', '110101006002', '110101006000', 5, 0, 'QiTiaoSheQu', 'QTSQ'), (60, 57, '二条社区', '110101006003', '110101006000', 5, 0, 'ErTiaoSheQu', 'ETSQ'), (61, 57, '六条社区', '110101006006', '110101006000', 5, 0, 'LiuTiaoSheQu', 'LTSQ'), (62, 57, '豆瓣社区', '110101006007', '110101006000', 5, 0, 'DouBanSheQu', 'DBSQ'), (63, 57, '八条社区', '110101006008', '110101006000', 5, 0, 'BaTiaoSheQu', 'BTSQ'), (64, 57, '总院社区', '110101006009', '110101006000', 5, 0, 'ZongYuanSheQu', 'ZYSQ'), (65, 3, '朝阳门街道', '110101007000', '110101000000', 4, 0, 'ChaoYangMenJieDao', 'CYMJD'), (66, 65, '史家社区', '110101007001', '110101007000', 5, 0, 'ShiJiaSheQu', 'SJSQ'), (67, 65, '内务社区', '110101007002', '110101007000', 5, 0, 'NeiWuSheQu', 'NWSQ'), (68, 65, '演乐社区', '110101007003', '110101007000', 5, 0, 'YanLeSheQu', 'YLSQ'), (69, 65, '礼士社区', '110101007005', '110101007000', 5, 0, 'LiShiSheQu', 'LSSQ'), (70, 65, '朝内头条社区', '110101007006', '110101007000', 5, 0, 'ChaoNeiTouTiaoSheQu', 'CNTTSQ'), (71, 65, '朝西社区', '110101007007', '110101007000', 5, 0, 'ChaoXiSheQu', 'CXSQ'), (72, 65, '竹杆社区', '110101007009', '110101007000', 5, 0, 'ZhuGanSheQu', 'ZGSQ'), (73, 65, '大方家社区', '110101007011', '110101007000', 5, 0, 'DaFangJi