2018年底最新中国全国五级行政区划代码省市区县乡镇村MySQL数据库【单表】

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50721 Source Host : localhost:3306 Source Database : aid2018 Target Server Type : MYSQL Target Server Version : 50721 File Encoding : 65001 Date: 2018-06-25 15:04:46 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for aid2018 -- ---------------------------- DROP TABLE IF EXISTS `aid2018`; CREATE TABLE `aid2018` ( `code` char(12) NOT NULL, `name` varchar(255) DEFAULT NULL, `level` char(10) DEFAULT NULL, `parent` char(12) DEFAULT NULL, `code_short` char(12) DEFAULT NULL, PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of aid2018 -- ---------------------------- INSERT INTO `aid2018` VALUES ('110000000000', '北京市', 'province', '0', '11'); INSERT INTO `aid2018` VALUES ('110100000000', '市辖区', 'city', '110000000000', '1101'); INSERT INTO `aid2018` VALUES ('110101000000', '东城区', 'country', '110100000000', '110101'); INSERT INTO `aid2018` VALUES ('110101001000', '东华门街道办事处', 'town', '110101000000', '110101001'); INSERT INTO `aid2018` VALUES ('110101001001', '多福巷社区居委会', 'village', '110101001000', '110101001001'); INSERT INTO `aid2018` VALUES ('110101001002', '银闸社区居委会', 'village', '110101001000', '110101001002'); INSERT INTO `aid2018` VALUES ('110101001005', '东厂社区居委会', 'village', '110101001000', '110101001005'); INSERT INTO `aid2018` VALUES ('110101001006', '智德社区居委会', 'village', '110101001000', '110101001006'); INSERT INTO `aid2018` VALUES ('110101001007', '南池子社区居委会', 'village', '110101001000', '110101001007'); INSERT INTO `aid2018` VALUES ('110101001008', '黄图岗社区居委会', 'village', '110101001000', '110101001008'); INSERT INTO `aid2018` VALUES ('110101001009', '灯市口社区居委会', 'village', '110101001000', '110101001009'); INSERT INTO `aid2018` VALUES ('110101001010', '正义路社区居委会', 'village', '110101001000', '110101001010'); INSERT INTO `aid2018` VALUES ('110101001011', '甘雨社区居委会', 'village', '110101001000', '110101001011'); INSERT INTO `aid2018` VALUES ('110101001013', '台基厂社区居委会', 'village', '110101001000', '110101001013'); INSERT INTO `aid2018` VALUES ('110101001014', '韶九社区居委会', 'village', '110101001000', '110101001014'); INSERT INTO `aid2018` VALUES ('110101001015', '王府井社区居委会', 'village', '110101001000', '110101001015'); INSERT INTO `aid2018` VALUES ('110101002000', '景山街道办事处', 'town', '110101000000', '110101002'); INSERT INTO `aid2018` VALUES ('110101002001', '隆福寺社区居委会', 'village', '110101002000', '110101002001'); INSERT INTO `aid2018` VALUES ('110101002002', '吉祥社区居委会', 'village', '110101002000', '110101002002'); INSERT INTO `aid2018` VALUES ('110101002003', '黄化门社区居委会', 'village', '110101002000', '110101002003'); INSERT INTO `aid2018` VALUES ('110101002004', '钟鼓社区居委会', 'village', '110101002000', '110101002004'); INSERT INTO `aid2018` VALUES ('110101002005', '魏家社区居委会', 'village', '110101002000', '110101002005'); INSERT INTO `aid2018` VALUES ('110101002006', '汪芝麻社区居委会', 'village', '110101002000', '110101002006'); INSERT INTO `aid2018` VALUES ('110101002008', '景山东街社区居委会', 'village', '110101002000', '110101002008'); INSERT INTO `aid2018` VALUES ('110101002009', '皇城根北街社区居委会', 'village', '110101002000', '110101002009'); INSERT INTO `aid2018` VALUES ('110101003000', '交道口街道办事处', 'town', '110101000000', '110101003'); INSERT INTO `aid2018` VALUES ('110101003001', '交东社区居委会', 'village', '110101003000', '110101003001'); INSERT INTO `aid2018` VALUES ('110101003002', '福祥社区居委会', 'village', '110101003000', '110101003002'); INSERT INTO `aid2018` VALUES ('110101003003', '大兴社区居委会', 'village', '110101003000', '110101003003'); INSERT INTO `aid2018` VALUES ('110101003005', '府学社区居委会', 'village', '110101003000', '110101003005'); INSERT INTO `aid2018` VALUES ('110101003007', '鼓楼苑社区居委会', 'village', '110101003000', '110101003007'); INSERT INTO `aid2018` VALUES ('110101003008', '菊儿社区居委会', 'village', '110101003000', '110101003008'); INSERT INTO `aid2018` VALUES ('110101003009', '南锣鼓巷社区居委会', 'village', '110101003000', '110101003009'); INSERT INTO `aid2018` VALUES ('110101004000', '安定门街道办事处', 'town', '110101000000', '110101004'); INSERT INTO `aid2018` VALUES ('110101004001', '交北头条社区居委会', 'village', '110101004000', '110101004001'); INSERT INTO `aid2018` VALUES ('110101004002', '北锣鼓巷社区居委会', 'village', '110101004000', '110101004002'); INSERT INTO `aid2018` VALUES ('110101004003', '国子监社区居委会', 'village', '110101004000', '110101004003'); INSERT INTO `aid2018` VALUES ('110101004004', '钟楼湾社区居委会', 'village', '110101004000', '110101004004'); INSERT INTO `aid2018` VALUES ('110101004005', '宝钞南社区居委会', 'village', '110101004000', '110101004005'); INSERT INTO `aid2018` VALUES ('110101004006', '五道营社区居委会', 'village', '110101004000', '110101004006'); INSERT INTO `aid2018` VALUES ('110101004009', '分司厅社区居委会', 'village', '110101004000', '110101004009'); INSERT INTO `aid2018` VALUES ('110101004011', '国旺社区居委会', 'village', '110101004000', '110101004011'); INSERT INTO `aid2018` VALUES ('110101004012', '花园社区居委会', 'village', '110101004000', '110101004012'); INSERT INTO `aid2018` VALUES ('110101005000', '北新桥街道办事处', 'town', '110101000000', '110101005'); INSERT INTO `aid2018` VALUES ('110101005001', '海运仓社区居委会', 'village', '110101005000', '110101005001'); INSERT INTO `aid2018` VALUES ('110101005002', '北新仓社区居委会', 'village', '110101005000', '110101005002'); INSERT INTO `aid2018` VALUES ('110101005004', '门楼社区居委会', 'village', '110101005000', '110101005004'); INSERT INTO `aid2018` VALUES ('110101005005', '十三条社区居委会', 'village', '110101005000', '110101005005'); INSERT INTO `aid2018` VALUES ('110101005006', '民安社区居委会', 'village', '110101005000', '110101005006'); INSERT INTO `aid2018` VALUES ('110101005008', '九道湾社区居委会', 'village', '110101005000', '110101005008'); INSERT INTO `aid2018` VALUES ('110101005009', '北官厅社区居委会', 'village', '110101005000', '110101005009'); INSERT INTO `aid2018` VALUES ('110101005010', '青龙社区居委会', 'village', '110101005000', '110101005010'); INSERT INTO `aid2018` VALUES ('110101005011', '小菊社区居委会', 'village', '110101005000', '110101005011'); INSERT INTO `aid2018` VALUES ('110101005012', '藏经馆社区居委会', 'village', '110101005000', '110101005012'); INSERT INTO `aid2018` VALUES ('110101005014', '草园社区居委会', 'village', '110101005000', '110101005014'); INSERT INTO `aid2018` VALUES ('110101005016', '前永康社区居委会', 'village', '110101005000', '110101005016'); INSERT INTO `aid2018` VALUES ('110101006000', '东四街道办事处', 'town', '110101000000', '110101006'); INSERT INTO `aid2018` VALUES ('110101006001', '南门仓社区居委会', 'village', '110101006000', '110101006001'); INSERT INTO `aid2018` VALUES ('110101006002', '七条社区居委会', 'village', '110101006000', '110101006002'); INSERT INTO `aid2018` VALUES ('110101006003', '二条社区居委会', 'village', '110101006000', '110101006003'); INSERT INTO `aid2018` VALUES ('110101006006', '六条社区居委会', 'village', '110101006000', '110101006006'); INSERT INTO `aid2018` VALUES ('110101006007', '豆瓣社区居委会', 'village', '110101006000'