最新省市区地区数据sql版本（2019年1月）

版本

统计标准2017版

来源

http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/

建表

CREATE TABLE `ly_district` (
  `id` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `code` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL COMMENT '省市区县编码',
  `name` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL COMMENT '省市区县名称',
  `type` TINYINT(2) DEFAULT NULL COMMENT '省市区县等级级别',
  `parent_code` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL COMMENT '省市区县父级编码',
  `target` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT '省市区县代码';

预览

下载地址

https://pan.baidu.com/s/1HA00Fovf2AD48fQBkBRvGw  提取 8s7k

 sql示例

INSERT INTO ly_district (id,CODE,NAME,`type`,parent_code,target) VALUES 
('0021cc58e099439e9cfbea5861524de3','421003000000','荆州区',3,'421000000000','10/421003.html')
,('003b4cb25ba24d99b5d9dfc64bf58ad9','530500000000','保山市',2,'530000000000','53/5305.html')
,('004f5da06c5f4d05be77ed0e53e96fbc','330382000000','乐清市',3,'330300000000','03/330382.html')
,('0056fd8606f04054bab8b5d9e42704aa','610623000000','子长县',3,'610600000000','06/610623.html')
,('005fe7b35a134dbcb35f4de1096d6c62','150402000000','红山区',3,'150400000000','04/150402.html')
,('0072cff9c4184daca6036593b7a51f79','150172000000','呼和浩特经济技术开发区',3,'150100000000','01/150172.html')
,('0074435c41184fd29ca635014c596e35','511124000000','井研县',3,'511100000000','11/511124.html')
,('00a8cc019428450b86a5b8cd6155f076','451122000000','钟山县',3,'451100000000','11/451122.html')
,('00af1f16c6d2429f90159aa1e2d33b5b','330304000000','瓯海区',3,'330300000000','03/330304.html')
,('00b8d3094938421a908b2e1023961930','341523000000','舒城县',3,'341500000000','15/341523.html')
;
INSERT INTO ly_district (id,CODE,NAME,`type`,parent_code,target) VALUES 
('00ddb16a726f4363bac4bf3e2113ddd9','230231000000','拜泉县',3,'230200000000','02/230231.html')
,('01077de9ae314941a9b06077c7c034f8','540172000000','拉萨经济技术开发区',3,'540100000000','01/540172.html')
,('010c535ff255434fad759d0c9682f0fa','370784000000','安丘市',3,'370700000000','07/370784.html')
,('0120bad588c54033b3ab15c88617c0c3','130434000000','魏县',3,'130400000000','04/130434.html')
,('01251ff62da049f1b77dd8dd80bc4e46','522702000000','福泉市',3,'522700000000','27/522702.html')
,('012825196e05480486392cc27e3fd124','330110000000','余杭区',3,'330100000000','01/330110.html')
,('0129b011836c4ea88f908379338734e7','630123000000','湟源县',3,'630100000000','01/630123.html')
,('01473722a5fe43e3acadb41e0cefa248','441426000000','平远县',3,'441400000000','14/441426.html')
,('0154b843177848138b1ec4952a7ae60e','511132000000','峨边彝族自治县',3,'511100000000','11/511132.html')
,('015b74b7bb064580a9256f7a7409bf9f','540236000000','萨嘎县',3,'540200000000','02/540236.html')
;
INSERT INTO ly_district (id,CODE,NAME,`type`,parent_code,target) VALUES 
('01a541f97fa644438f43ba2c12cc7535','533400000000','迪庆藏族自治州',2,'530000000000','53/5334.html')
,('01aabdfdca794f8981364daf53edd0ea','430225000000','炎陵县',3,'430200000000','02/430225.html')
,('01b4b5ae72a146c3a120fc214dcdb5bf','441481000000','兴宁市',3,'441400000000','14/441481.html')
,('01b6f2a5177342899a5bc459d3858a31','451023000000','平果县',3,'451000000000','10/451023.html')
,('01d383fe113b43e6af6059c0420099ed','210604000000','振安区',3,'210600000000','06/210604.html')
,('01f2357886b9480d87b235d8216b6f2c','371603000000','沾化区',3,'371600000000','16/371603.html')
,('01f69436eb0d43be95664ef803f65356','140925000000','宁武县',3,'140900000000','09/140925.html')
,('020471de12a54c5ca80aad3fc1bfea20','211481000000','兴城市',3,'211400000000','14/211481.html')
,('02095ad48e5140fe89ac481177be3ae9','431171000000','永州经济技术开发区',3,'431100000000','11/431171.html')
,('020e9ea478864b9e8cd13abc17249f3b','140371000000','山西阳泉经济开发区',3,'140300000000','03/140371.html')
;