MySQL全国行政区域身份证代码 2017 一张表

/* Navicat MySQL Data Transfer Source Server : Linux Source Server Version : 50720 Source Host : www.mx88.win:2602 Source Database : news_cms Target Server Type : MYSQL Target Server Version : 50720 File Encoding : 65001 Date: 2017-12-09 22:55:34 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for cms_sbg_citys -- ---------------------------- DROP TABLE IF EXISTS `cms_sbg_citys`; CREATE TABLE `cms_sbg_citys` ( `id` int(11) NOT NULL, `parent_id` int(10) unsigned DEFAULT '0' COMMENT '父ID', `cids` varchar(10) DEFAULT '' COMMENT '身份证区号', `title` varchar(20) DEFAULT '' COMMENT '城市名称 ', `py_j` varchar(5) DEFAULT '' COMMENT '拼音 简', `py` varchar(50) DEFAULT '' COMMENT '拼音', `city_type` varchar(20) DEFAULT '' COMMENT '城市类型', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of cms_sbg_citys -- ---------------------------- INSERT INTO `cms_sbg_citys` VALUES ('1', '0', '110000', '北京', 'bj', 'beijing', '市'); INSERT INTO `cms_sbg_citys` VALUES ('2', '0', '120000', '天津', 'tj', 'tianjin', '市'); INSERT INTO `cms_sbg_citys` VALUES ('3', '0', '310000', '上海', 'sh', 'shanghai', '市'); INSERT INTO `cms_sbg_citys` VALUES ('4', '0', '500000', '重庆', 'zq', 'zhongqing', '市'); INSERT INTO `cms_sbg_citys` VALUES ('5', '0', '130000', '河北', 'hb', 'hebei', '省'); INSERT INTO `cms_sbg_citys` VALUES ('6', '0', '140000', '山西', 'sx', 'shanxi', '省'); INSERT INTO `cms_sbg_citys` VALUES ('7', '0', '150000', '内蒙古', 'nmg', 'neimenggu', '自治区'); INSERT INTO `cms_sbg_citys` VALUES ('8', '0', '210000', '辽宁', 'ln', 'liaoning', '省'); INSERT INTO `cms_sbg_citys` VALUES ('9', '0', '220000', '吉林', 'jl', 'jilin', '省'); INSERT INTO `cms_sbg_citys` VALUES ('10', '0', '230000', '黑龙江', 'hlj', 'heilongjiang', '省'); INSERT INTO `cms_sbg_citys` VALUES ('11', '0', '320000', '江苏', 'js', 'jiangsu', '省'); INSERT INTO `cms_sbg_citys` VALUES ('12', '0', '330000', '浙江', 'zj', 'zhejiang', '省'); INSERT INTO `cms_sbg_citys` VALUES ('13', '0', '340000', '安徽', 'ah', 'anhui', '省'); INSERT INTO `cms_sbg_citys` VALUES ('14', '0', '350000', '福建', 'fj', 'fujian', '省'); INSERT INTO `cms_sbg_citys` VALUES ('15', '0', '360000', '江西', 'jx', 'jiangxi', '省'); INSERT INTO `cms_sbg_citys` VALUES ('16', '0', '370000', '山东', 'sd', 'shandong', '省'); INSERT INTO `cms_sbg_citys` VALUES ('17', '0', '410000', '河南', 'hn', 'henan', '省'); INSERT INTO `cms_sbg_citys` VALUES ('18', '0', '420000', '湖北', 'hb', 'hubei', '省'); INSERT INTO `cms_sbg_citys` VALUES ('19', '0', '430000', '湖南', 'hn', 'hunan', '省'); INSERT INTO `cms_sbg_citys` VALUES ('20', '0', '440000', '广东', 'gd', 'guangdong', '省'); INSERT INTO `cms_sbg_citys` VALUES ('21', '0', '450000', '广西', 'gx', 'guangxi', '自治区'); INSERT INTO `cms_sbg_citys` VALUES ('22', '0', '460000', '海南', 'hn', 'hainan', '省'); INSERT INTO `cms_sbg_citys` VALUES ('23', '0', '510000', '四川', 'sc', 'sichuan', '省'); INSERT INTO `cms_sbg_citys` VALUES ('24', '0', '520000', '贵州', 'gz', 'guizhou', '省'); INSERT INTO `cms_sbg_citys` VALUES ('25', '0', '530000', '云南', 'yn', 'yunnan', '省'); INSERT INTO `cms_sbg_citys` VALUES ('26', '0', '540000', '西藏', 'xz', 'xizang', '自治区'); INSERT INTO `cms_sbg_citys` VALUES ('27', '0', '610000', '陕西', 'sx', 'shanxi', '省'); INSERT INTO `cms_sbg_citys` VALUES ('28', '0', '620000', '甘肃', 'gs', 'gansu', '省'); INSERT INTO `cms_sbg_citys` VALUES ('29', '0', '630000', '青海', 'qh', 'qinghai', '省'); INSERT INTO `cms_sbg_citys` VALUES ('30', '0', '640000', '宁夏', 'nx', 'ningxia', '自治区'); INSERT INTO `cms_sbg_citys` VALUES ('31', '0', '650000', '新疆', 'xj', 'xinjiang', '自治区'); INSERT INTO `cms_sbg_citys` VALUES ('32', '0', '710000', '台湾', 'tw', 'taiwan', '省'); INSERT INTO `cms_sbg_citys` VALUES ('33', '0', '810000', '香港', 'xg', 'xianggang', '特别行政区'); INSERT INTO `cms_sbg_citys` VALUES ('34', '0', '820000', '澳门', 'am', 'aomen', '特别行政区'); INSERT INTO `cms_sbg_citys` VALUES ('35', '0', '', '海外', 'hw', 'haiwai', ''); INSERT INTO `cms_sbg_citys` VALUES ('36', '1', '110101', '东城', 'dc', 'dongcheng', '区'); INSERT INTO `cms_sbg_citys` VALUES ('37', '1', '110102', '西城', 'xc', 'xicheng', '区'); INSERT INTO `cms_sbg_citys` VALUES ('38', '1', '110103', '崇文', 'cw', 'chongwen', '区'); INSERT INTO `cms_sbg_citys` VALUES ('39', '1', '110104', '宣武', 'xw', 'xuanwu', '区'); INSERT INTO `cms_sbg_citys` VALUES ('40', '1', '110105', '朝阳', 'cy', 'chaoyang', '区'); INSERT INTO `cms_sbg_citys` VALUES ('41', '1', '110106', '丰台', 'ft', 'fengtai', '区'); INSERT INTO `cms_sbg_citys` VALUES ('42', '1', '110107', '石景山', 'sjs', 'shijingshan', '区'); INSERT INTO `cms_sbg_citys` VALUES ('43', '1', '110108', '海淀', 'hd', 'haidian', '区'); INSERT INTO `cms_sbg_citys` VALUES ('44', '1', '110109', '门头沟', 'mtg', 'mentougou', '区'); INSERT INTO `cms_sbg_citys` VALUES ('45', '1', '110111', '房山', 'fs', 'fangshan', '区'); INSERT INTO `cms_sbg_citys` VALUES ('46', '1', '110112', '通州', 'tz', 'tongzhou', '区'); INSERT INTO `cms_sbg_citys` VALUES ('47', '1', '110113', '顺义', 'sy', 'shunyi', '区'); INSERT INTO `cms_sbg_citys` VALUES ('48', '1', '110114', '昌平', 'cp', 'changping', '区'); INSERT INTO `cms_sbg_citys` VALUES ('49', '1', '110115', '大兴', 'dx', 'daxing', '区'); INSERT INTO `cms_sbg_citys` VALUES ('50', '1', '110116', '怀柔', 'hr', 'huairou', '区'); INSERT INTO `cms_sbg_citys` VALUES ('51', '1', '110117', '平谷', 'pg', 'pinggu', '区'); INSERT INTO `cms_sbg_citys` VALUES ('52', '1', '110228', '密云', 'my', 'miyun', '区'); INSERT INTO `cms_sbg_citys` VALUES ('53', '1', '110229', '延庆', 'yq', 'yanqing', '区'); INSERT INTO `cms_sbg_citys` VALUES ('54', '2', '120101', '和平', 'hp', 'heping', '区'); INSERT INTO `cms_sbg_citys` VALUES ('55', '2', '120102', '河东', 'hd', 'hedong', '区'); INSERT INTO `cms_sbg_citys` VALUES ('56', '2', '120103', '河西', 'hx', 'hexi', '区'); INSERT INTO `cms_sbg_citys` VALUES ('57', '2', '120104', '南开', 'nk', 'nankai', '区'); INSERT INTO `cms_sbg_citys` VALUES ('58', '2', '120105', '河北', 'hb', 'hebei', '区'); INSERT INTO `cms_sbg_citys` VALUES ('59', '2', '120106', '红桥', 'hq', 'hongqiao', '区'); INSERT INTO `cms_sbg_citys` VALUES ('60', '2', '120110', '东丽', 'dl', 'dongli', '区'); INSERT INTO `cms_sbg_citys` VALUES ('61', '2', '120111', '西青', 'xq', 'xiqing', '区'); INSERT INTO `cms_sbg_citys` VALUES ('62', '2', '120112', '津南', 'jn', 'jinnan', '区'); INSERT INTO `cms_sbg_citys` VALUES ('63', '2', '120113', '北辰', 'bc', 'beichen', '区'); INSERT INTO `cms_sbg_citys` VALUES ('64', '2', '120114', '武清', 'wq', 'wuqing', '区'); INSERT INTO `cms_sbg_citys` VALUES ('65', '2', '120115', '宝坻', 'bc', 'baochi', '区'); INSERT INTO `cms_sbg_citys` VALUES ('66', '2', '120116', '滨海新区', 'bhxq', 'binhaixinqu', ''); INSERT INTO `cms_sbg_citys` VALUES ('67', '2', '120221', '宁河', 'nh', 'ninghe', '区'); INSERT INTO `cms_sbg_citys` VALUES ('68', '2', '120223', '蓟州', 'jz', 'jizhou', '区'); INSERT INTO `cms_sbg_citys` VALUES ('69', '2', '120225', '静海', 'jh', 'jinghai', '区'); INSERT INTO `cms_sbg_citys` VALUES ('70', '3', '310101', '黄浦', 'hp', 'huangpu', '区'); INSERT INTO `cms_sbg_citys` VALUES ('71', '3', '310104', '徐汇', 'xh', 'xuhui', '区'); INSERT INTO `cms_sbg_citys` VALUES ('72', '3', '310105', '长宁', 'zn', 'zhangning', '区'); INSERT INTO `cms_sbg_citys` VALUES ('73', '3', '310106', '静安', 'ja', 'jingan', '区'); INSERT INTO `cms_sbg_citys` VALUES ('74', '3', '310107', '普陀', 'pt', 'putuo', '区'); INSERT INTO `cms_sbg_citys` VALUE