省市区三级行政区代码（包含港澳台）sql4

已于 2023-02-12 12:53:58 修改
阅读量1.2k 收藏 1
点赞数 2
分类专栏： 工具 文章标签： 数据仓库 Powered by 金山文档
于 2023-02-12 01:30:30 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lxhJava15/article/details/128991316
版权

一、sql

INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610681', '610600', '0,610000,610600', '子长市', 'zizhangshi', '陕西省延安市子长市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610700', '610000', '0,610000', '汉中市', 'hanzhongshi', '陕西省汉中市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610702', '610700', '0,610000,610700', '汉台区', 'hantaiqu', '陕西省汉中市汉台区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610703', '610700', '0,610000,610700', '南郑区', 'nanzhengqu', '陕西省汉中市南郑区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610722', '610700', '0,610000,610700', '城固县', 'chengguxian', '陕西省汉中市城固县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610723', '610700', '0,610000,610700', '洋县', 'yangxian', '陕西省汉中市洋县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610724', '610700', '0,610000,610700', '西乡县', 'xixiangxian', '陕西省汉中市西乡县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610725', '610700', '0,610000,610700', '勉县', 'mianxian', '陕西省汉中市勉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610726', '610700', '0,610000,610700', '宁强县', 'ningqiangxian', '陕西省汉中市宁强县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610727', '610700', '0,610000,610700', '略阳县', 'lu:eyangxian', '陕西省汉中市略阳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610728', '610700', '0,610000,610700', '镇巴县', 'zhenbaxian', '陕西省汉中市镇巴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610729', '610700', '0,610000,610700', '留坝县', 'liubaxian', '陕西省汉中市留坝县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610730', '610700', '0,610000,610700', '佛坪县', 'fopingxian', '陕西省汉中市佛坪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610800', '610000', '0,610000', '榆林市', 'yulinshi', '陕西省榆林市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610802', '610800', '0,610000,610800', '榆阳区', 'yuyangqu', '陕西省榆林市榆阳区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610803', '610800', '0,610000,610800', '横山区', 'hengshanqu', '陕西省榆林市横山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610822', '610800', '0,610000,610800', '府谷县', 'fuguxian', '陕西省榆林市府谷县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610824', '610800', '0,610000,610800', '靖边县', 'jingbianxian', '陕西省榆林市靖边县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610825', '610800', '0,610000,610800', '定边县', 'dingbianxian', '陕西省榆林市定边县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610826', '610800', '0,610000,610800', '绥德县', 'suidexian', '陕西省榆林市绥德县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610827', '610800', '0,610000,610800', '米脂县', 'mizhixian', '陕西省榆林市米脂县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610828', '610800', '0,610000,610800', '佳县', 'jiaxian', '陕西省榆林市佳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610829', '610800', '0,610000,610800', '吴堡县', 'wubaoxian', '陕西省榆林市吴堡县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610830', '610800', '0,610000,610800', '清涧县', 'qingjianxian', '陕西省榆林市清涧县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610831', '610800', '0,610000,610800', '子洲县', 'zizhouxian', '陕西省榆林市子洲县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610881', '610800', '0,610000,610800', '神木市', 'shenmushi', '陕西省榆林市神木市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610900', '610000', '0,610000', '安康市', 'ankangshi', '陕西省安康市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610902', '610900', '0,610000,610900', '汉滨区', 'hanbinqu', '陕西省安康市汉滨区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610921', '610900', '0,610000,610900', '汉阴县', 'hanyinxian', '陕西省安康市汉阴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610922', '610900', '0,610000,610900', '石泉县', 'shiquanxian', '陕西省安康市石泉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610923', '610900', '0,610000,610900', '宁陕县', 'ningshanxian', '陕西省安康市宁陕县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610924', '610900', '0,610000,610900', '紫阳县', 'ziyangxian', '陕西省安康市紫阳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610925', '610900', '0,610000,610900', '岚皋县', 'langaoxian', '陕西省安康市岚皋县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610926', '610900', '0,610000,610900', '平利县', 'pinglixian', '陕西省安康市平利县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610927', '610900', '0,610000,610900', '镇坪县', 'zhenpingxian', '陕西省安康市镇坪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610929', '610900', '0,610000,610900', '白河县', 'baihexian', '陕西省安康市白河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('610981', '610900', '0,610000,610900', '旬阳市', 'xunyangshi', '陕西省安康市旬阳市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611000', '610000', '0,610000', '商洛市', 'shangluoshi', '陕西省商洛市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611002', '611000', '0,610000,611000', '商州区', 'shangzhouqu', '陕西省商洛市商州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611021', '611000', '0,610000,611000', '洛南县', 'luonanxian', '陕西省商洛市洛南县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611022', '611000', '0,610000,611000', '丹凤县', 'danfengxian', '陕西省商洛市丹凤县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611023', '611000', '0,610000,611000', '商南县', 'shangnanxian', '陕西省商洛市商南县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611024', '611000', '0,610000,611000', '山阳县', 'shanyangxian', '陕西省商洛市山阳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611025', '611000', '0,610000,611000', '镇安县', 'zhenanxian', '陕西省商洛市镇安县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('611026', '611000', '0,610000,611000', '柞水县', 'zuoshuixian', '陕西省商洛市柞水县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620000', '0', '0', '甘肃省', 'gansusheng', '甘肃省', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620100', '620000', '0,620000', '兰州市', 'lanzhoushi', '甘肃省兰州市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620102', '620100', '0,620000,620100', '城关区', 'chengguanqu', '甘肃省兰州市城关区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620103', '620100', '0,620000,620100', '七里河区', 'qilihequ', '甘肃省兰州市七里河区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620104', '620100', '0,620000,620100', '西固区', 'xiguqu', '甘肃省兰州市西固区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620105', '620100', '0,620000,620100', '安宁区', 'anningqu', '甘肃省兰州市安宁区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620111', '620100', '0,620000,620100', '红古区', 'hongguqu', '甘肃省兰州市红古区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620121', '620100', '0,620000,620100', '永登县', 'yongdengxian', '甘肃省兰州市永登县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620122', '620100', '0,620000,620100', '皋兰县', 'gaolanxian', '甘肃省兰州市皋兰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620123', '620100', '0,620000,620100', '榆中县', 'yuzhongxian', '甘肃省兰州市榆中县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620171', '620100', '0,620000,620100', '兰州新区', 'lanzhouxinqu', '甘肃省兰州市兰州新区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620200', '620000', '0,620000', '嘉峪关市', 'jiayuguanshi', '甘肃省嘉峪关市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620300', '620000', '0,620000', '金昌市', 'jinchangshi', '甘肃省金昌市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620302', '620300', '0,620000,620300', '金川区', 'jinchuanqu', '甘肃省金昌市金川区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620321', '620300', '0,620000,620300', '永昌县', 'yongchangxian', '甘肃省金昌市永昌县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620400', '620000', '0,620000', '白银市', 'baiyinshi', '甘肃省白银市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620402', '620400', '0,620000,620400', '白银区', 'baiyinqu', '甘肃省白银市白银区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620403', '620400', '0,620000,620400', '平川区', 'pingchuanqu', '甘肃省白银市平川区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620421', '620400', '0,620000,620400', '靖远县', 'jingyuanxian', '甘肃省白银市靖远县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620422', '620400', '0,620000,620400', '会宁县', 'huiningxian', '甘肃省白银市会宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620423', '620400', '0,620000,620400', '景泰县', 'jingtaixian', '甘肃省白银市景泰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620500', '620000', '0,620000', '天水市', 'tianshuishi', '甘肃省天水市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620502', '620500', '0,620000,620500', '秦州区', 'qinzhouqu', '甘肃省天水市秦州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620503', '620500', '0,620000,620500', '麦积区', 'maijiqu', '甘肃省天水市麦积区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620521', '620500', '0,620000,620500', '清水县', 'qingshuixian', '甘肃省天水市清水县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620522', '620500', '0,620000,620500', '秦安县', 'qinanxian', '甘肃省天水市秦安县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620523', '620500', '0,620000,620500', '甘谷县', 'ganguxian', '甘肃省天水市甘谷县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620524', '620500', '0,620000,620500', '武山县', 'wushanxian', '甘肃省天水市武山县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620525', '620500', '0,620000,620500', '张家川回族自治县', 'zhangjiachuanhuizuzizhixian', '甘肃省天水市张家川回族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620600', '620000', '0,620000', '武威市', 'wuweishi', '甘肃省武威市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620602', '620600', '0,620000,620600', '凉州区', 'liangzhouqu', '甘肃省武威市凉州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620621', '620600', '0,620000,620600', '民勤县', 'minqinxian', '甘肃省武威市民勤县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620622', '620600', '0,620000,620600', '古浪县', 'gulangxian', '甘肃省武威市古浪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620623', '620600', '0,620000,620600', '天祝藏族自治县', 'tianzhuzangzuzizhixian', '甘肃省武威市天祝藏族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620700', '620000', '0,620000', '张掖市', 'zhangyeshi', '甘肃省张掖市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620702', '620700', '0,620000,620700', '甘州区', 'ganzhouqu', '甘肃省张掖市甘州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620721', '620700', '0,620000,620700', '肃南裕固族自治县', 'sunanyuguzuzizhixian', '甘肃省张掖市肃南裕固族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620722', '620700', '0,620000,620700', '民乐县', 'minlexian', '甘肃省张掖市民乐县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620723', '620700', '0,620000,620700', '临泽县', 'linzexian', '甘肃省张掖市临泽县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620724', '620700', '0,620000,620700', '高台县', 'gaotaixian', '甘肃省张掖市高台县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620725', '620700', '0,620000,620700', '山丹县', 'shandanxian', '甘肃省张掖市山丹县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620800', '620000', '0,620000', '平凉市', 'pingliangshi', '甘肃省平凉市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620802', '620800', '0,620000,620800', '崆峒区', 'kongtongqu', '甘肃省平凉市崆峒区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620821', '620800', '0,620000,620800', '泾川县', 'jingchuanxian', '甘肃省平凉市泾川县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620822', '620800', '0,620000,620800', '灵台县', 'lingtaixian', '甘肃省平凉市灵台县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620823', '620800', '0,620000,620800', '崇信县', 'chongxinxian', '甘肃省平凉市崇信县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620825', '620800', '0,620000,620800', '庄浪县', 'zhuanglangxian', '甘肃省平凉市庄浪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620826', '620800', '0,620000,620800', '静宁县', 'jingningxian', '甘肃省平凉市静宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620881', '620800', '0,620000,620800', '华亭市', 'huatingshi', '甘肃省平凉市华亭市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620900', '620000', '0,620000', '酒泉市', 'jiuquanshi', '甘肃省酒泉市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620902', '620900', '0,620000,620900', '肃州区', 'suzhouqu', '甘肃省酒泉市肃州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620921', '620900', '0,620000,620900', '金塔县', 'jintaxian', '甘肃省酒泉市金塔县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620922', '620900', '0,620000,620900', '瓜州县', 'guazhouxian', '甘肃省酒泉市瓜州县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620923', '620900', '0,620000,620900', '肃北蒙古族自治县', 'subeimengguzuzizhixian', '甘肃省酒泉市肃北蒙古族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620924', '620900', '0,620000,620900', '阿克塞哈萨克族自治县', 'akesaihasakezuzizhixian', '甘肃省酒泉市阿克塞哈萨克族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620981', '620900', '0,620000,620900', '玉门市', 'yumenshi', '甘肃省酒泉市玉门市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('620982', '620900', '0,620000,620900', '敦煌市', 'dunhuangshi', '甘肃省酒泉市敦煌市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621000', '620000', '0,620000', '庆阳市', 'qingyangshi', '甘肃省庆阳市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621002', '621000', '0,620000,621000', '西峰区', 'xifengqu', '甘肃省庆阳市西峰区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621021', '621000', '0,620000,621000', '庆城县', 'qingchengxian', '甘肃省庆阳市庆城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621022', '621000', '0,620000,621000', '环县', 'huanxian', '甘肃省庆阳市环县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621023', '621000', '0,620000,621000', '华池县', 'huachixian', '甘肃省庆阳市华池县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621024', '621000', '0,620000,621000', '合水县', 'heshuixian', '甘肃省庆阳市合水县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621025', '621000', '0,620000,621000', '正宁县', 'zhengningxian', '甘肃省庆阳市正宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621026', '621000', '0,620000,621000', '宁县', 'ningxian', '甘肃省庆阳市宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621027', '621000', '0,620000,621000', '镇原县', 'zhenyuanxian', '甘肃省庆阳市镇原县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621100', '620000', '0,620000', '定西市', 'dingxishi', '甘肃省定西市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621102', '621100', '0,620000,621100', '安定区', 'andingqu', '甘肃省定西市安定区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621121', '621100', '0,620000,621100', '通渭县', 'tongweixian', '甘肃省定西市通渭县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621122', '621100', '0,620000,621100', '陇西县', 'longxixian', '甘肃省定西市陇西县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621123', '621100', '0,620000,621100', '渭源县', 'weiyuanxian', '甘肃省定西市渭源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621124', '621100', '0,620000,621100', '临洮县', 'lintaoxian', '甘肃省定西市临洮县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621125', '621100', '0,620000,621100', '漳县', 'zhangxian', '甘肃省定西市漳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621126', '621100', '0,620000,621100', '岷县', 'minxian', '甘肃省定西市岷县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621200', '620000', '0,620000', '陇南市', 'longnanshi', '甘肃省陇南市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621202', '621200', '0,620000,621200', '武都区', 'wudouqu', '甘肃省陇南市武都区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621221', '621200', '0,620000,621200', '成县', 'chengxian', '甘肃省陇南市成县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621222', '621200', '0,620000,621200', '文县', 'wenxian', '甘肃省陇南市文县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621223', '621200', '0,620000,621200', '宕昌县', 'dangchangxian', '甘肃省陇南市宕昌县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621224', '621200', '0,620000,621200', '康县', 'kangxian', '甘肃省陇南市康县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621225', '621200', '0,620000,621200', '西和县', 'xihexian', '甘肃省陇南市西和县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621226', '621200', '0,620000,621200', '礼县', 'lixian', '甘肃省陇南市礼县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621227', '621200', '0,620000,621200', '徽县', 'huixian', '甘肃省陇南市徽县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('621228', '621200', '0,620000,621200', '两当县', 'liangdangxian', '甘肃省陇南市两当县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622900', '620000', '0,620000', '临夏回族自治州', 'linxiahuizuzizhizhou', '甘肃省临夏回族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622901', '622900', '0,620000,622900', '临夏市', 'linxiashi', '甘肃省临夏回族自治州临夏市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622921', '622900', '0,620000,622900', '临夏县', 'linxiaxian', '甘肃省临夏回族自治州临夏县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622922', '622900', '0,620000,622900', '康乐县', 'kanglexian', '甘肃省临夏回族自治州康乐县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622923', '622900', '0,620000,622900', '永靖县', 'yongjingxian', '甘肃省临夏回族自治州永靖县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622924', '622900', '0,620000,622900', '广河县', 'guanghexian', '甘肃省临夏回族自治州广河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622925', '622900', '0,620000,622900', '和政县', 'hezhengxian', '甘肃省临夏回族自治州和政县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622926', '622900', '0,620000,622900', '东乡族自治县', 'dongxiangzuzizhixian', '甘肃省临夏回族自治州东乡族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('622927', '622900', '0,620000,622900', '积石山保安族东乡族撒拉族自治县', 'jishishanbaoanzudongxiangzusalazuzizhixian', '甘肃省临夏回族自治州积石山保安族东乡族撒拉族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623000', '620000', '0,620000', '甘南藏族自治州', 'gannanzangzuzizhizhou', '甘肃省甘南藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623001', '623000', '0,620000,623000', '合作市', 'hezuoshi', '甘肃省甘南藏族自治州合作市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623021', '623000', '0,620000,623000', '临潭县', 'lintanxian', '甘肃省甘南藏族自治州临潭县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623022', '623000', '0,620000,623000', '卓尼县', 'zhuonixian', '甘肃省甘南藏族自治州卓尼县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623023', '623000', '0,620000,623000', '舟曲县', 'zhouquxian', '甘肃省甘南藏族自治州舟曲县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623024', '623000', '0,620000,623000', '迭部县', 'diebuxian', '甘肃省甘南藏族自治州迭部县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623025', '623000', '0,620000,623000', '玛曲县', 'maquxian', '甘肃省甘南藏族自治州玛曲县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623026', '623000', '0,620000,623000', '碌曲县', 'liuquxian', '甘肃省甘南藏族自治州碌曲县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('623027', '623000', '0,620000,623000', '夏河县', 'xiahexian', '甘肃省甘南藏族自治州夏河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630000', '0', '0', '青海省', 'qinghaisheng', '青海省', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630100', '630000', '0,630000', '西宁市', 'xiningshi', '青海省西宁市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630102', '630100', '0,630000,630100', '城东区', 'chengdongqu', '青海省西宁市城东区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630103', '630100', '0,630000,630100', '城中区', 'chengzhongqu', '青海省西宁市城中区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630104', '630100', '0,630000,630100', '城西区', 'chengxiqu', '青海省西宁市城西区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630105', '630100', '0,630000,630100', '城北区', 'chengbeiqu', '青海省西宁市城北区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630106', '630100', '0,630000,630100', '湟中区', 'huangzhongqu', '青海省西宁市湟中区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630121', '630100', '0,630000,630100', '大通回族土族自治县', 'datonghuizutuzuzizhixian', '青海省西宁市大通回族土族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630123', '630100', '0,630000,630100', '湟源县', 'huangyuanxian', '青海省西宁市湟源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630200', '630000', '0,630000', '海东市', 'haidongshi', '青海省海东市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630202', '630200', '0,630000,630200', '乐都区', 'ledouqu', '青海省海东市乐都区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630203', '630200', '0,630000,630200', '平安区', 'pinganqu', '青海省海东市平安区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630222', '630200', '0,630000,630200', '民和回族土族自治县', 'minhehuizutuzuzizhixian', '青海省海东市民和回族土族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630223', '630200', '0,630000,630200', '互助土族自治县', 'huzhutuzuzizhixian', '青海省海东市互助土族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630224', '630200', '0,630000,630200', '化隆回族自治县', 'hualonghuizuzizhixian', '青海省海东市化隆回族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('630225', '630200', '0,630000,630200', '循化撒拉族自治县', 'xunhuasalazuzizhixian', '青海省海东市循化撒拉族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632200', '630000', '0,630000', '海北藏族自治州', 'haibeizangzuzizhizhou', '青海省海北藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632221', '632200', '0,630000,632200', '门源回族自治县', 'menyuanhuizuzizhixian', '青海省海北藏族自治州门源回族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632222', '632200', '0,630000,632200', '祁连县', 'qilianxian', '青海省海北藏族自治州祁连县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632223', '632200', '0,630000,632200', '海晏县', 'haiyanxian', '青海省海北藏族自治州海晏县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632224', '632200', '0,630000,632200', '刚察县', 'gangchaxian', '青海省海北藏族自治州刚察县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632300', '630000', '0,630000', '黄南藏族自治州', 'huangnanzangzuzizhizhou', '青海省黄南藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632301', '632300', '0,630000,632300', '同仁市', 'tongrenshi', '青海省黄南藏族自治州同仁市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632322', '632300', '0,630000,632300', '尖扎县', 'jianzhaxian', '青海省黄南藏族自治州尖扎县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632323', '632300', '0,630000,632300', '泽库县', 'zekuxian', '青海省黄南藏族自治州泽库县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632324', '632300', '0,630000,632300', '河南蒙古族自治县', 'henanmengguzuzizhixian', '青海省黄南藏族自治州河南蒙古族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632500', '630000', '0,630000', '海南藏族自治州', 'hainanzangzuzizhizhou', '青海省海南藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632521', '632500', '0,630000,632500', '共和县', 'gonghexian', '青海省海南藏族自治州共和县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632522', '632500', '0,630000,632500', '同德县', 'tongdexian', '青海省海南藏族自治州同德县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632523', '632500', '0,630000,632500', '贵德县', 'guidexian', '青海省海南藏族自治州贵德县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632524', '632500', '0,630000,632500', '兴海县', 'xinghaixian', '青海省海南藏族自治州兴海县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632525', '632500', '0,630000,632500', '贵南县', 'guinanxian', '青海省海南藏族自治州贵南县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632600', '630000', '0,630000', '果洛藏族自治州', 'guoluozangzuzizhizhou', '青海省果洛藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632621', '632600', '0,630000,632600', '玛沁县', 'maqinxian', '青海省果洛藏族自治州玛沁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632622', '632600', '0,630000,632600', '班玛县', 'banmaxian', '青海省果洛藏族自治州班玛县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632623', '632600', '0,630000,632600', '甘德县', 'gandexian', '青海省果洛藏族自治州甘德县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632624', '632600', '0,630000,632600', '达日县', 'darixian', '青海省果洛藏族自治州达日县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632625', '632600', '0,630000,632600', '久治县', 'jiuzhixian', '青海省果洛藏族自治州久治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632626', '632600', '0,630000,632600', '玛多县', 'maduoxian', '青海省果洛藏族自治州玛多县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632700', '630000', '0,630000', '玉树藏族自治州', 'yushuzangzuzizhizhou', '青海省玉树藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632701', '632700', '0,630000,632700', '玉树市', 'yushushi', '青海省玉树藏族自治州玉树市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632722', '632700', '0,630000,632700', '杂多县', 'zaduoxian', '青海省玉树藏族自治州杂多县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632723', '632700', '0,630000,632700', '称多县', 'chengduoxian', '青海省玉树藏族自治州称多县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632724', '632700', '0,630000,632700', '治多县', 'zhiduoxian', '青海省玉树藏族自治州治多县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632725', '632700', '0,630000,632700', '囊谦县', 'nangqianxian', '青海省玉树藏族自治州囊谦县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632726', '632700', '0,630000,632700', '曲麻莱县', 'qumalaixian', '青海省玉树藏族自治州曲麻莱县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632800', '630000', '0,630000', '海西蒙古族藏族自治州', 'haiximengguzuzangzuzizhizhou', '青海省海西蒙古族藏族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632801', '632800', '0,630000,632800', '格尔木市', 'geermushi', '青海省海西蒙古族藏族自治州格尔木市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632802', '632800', '0,630000,632800', '德令哈市', 'delinghashi', '青海省海西蒙古族藏族自治州德令哈市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632803', '632800', '0,630000,632800', '茫崖市', 'mangyashi', '青海省海西蒙古族藏族自治州茫崖市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632821', '632800', '0,630000,632800', '乌兰县', 'wulanxian', '青海省海西蒙古族藏族自治州乌兰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632822', '632800', '0,630000,632800', '都兰县', 'doulanxian', '青海省海西蒙古族藏族自治州都兰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632823', '632800', '0,630000,632800', '天峻县', 'tianjunxian', '青海省海西蒙古族藏族自治州天峻县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('632857', '632800', '0,630000,632800', '大柴旦行政委员会', 'dachaidanxingzhengweiyuanhui', '青海省海西蒙古族藏族自治州大柴旦行政委员会', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640000', '0', '0', '宁夏回族自治区', 'ningxiahuizuzizhiqu', '宁夏回族自治区', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640100', '640000', '0,640000', '银川市', 'yinchuanshi', '宁夏回族自治区银川市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640104', '640100', '0,640000,640100', '兴庆区', 'xingqingqu', '宁夏回族自治区银川市兴庆区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640105', '640100', '0,640000,640100', '西夏区', 'xixiaqu', '宁夏回族自治区银川市西夏区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640106', '640100', '0,640000,640100', '金凤区', 'jinfengqu', '宁夏回族自治区银川市金凤区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640121', '640100', '0,640000,640100', '永宁县', 'yongningxian', '宁夏回族自治区银川市永宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640122', '640100', '0,640000,640100', '贺兰县', 'helanxian', '宁夏回族自治区银川市贺兰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640181', '640100', '0,640000,640100', '灵武市', 'lingwushi', '宁夏回族自治区银川市灵武市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640200', '640000', '0,640000', '石嘴山市', 'shizuishanshi', '宁夏回族自治区石嘴山市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640202', '640200', '0,640000,640200', '大武口区', 'dawukouqu', '宁夏回族自治区石嘴山市大武口区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640205', '640200', '0,640000,640200', '惠农区', 'huinongqu', '宁夏回族自治区石嘴山市惠农区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640221', '640200', '0,640000,640200', '平罗县', 'pingluoxian', '宁夏回族自治区石嘴山市平罗县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640300', '640000', '0,640000', '吴忠市', 'wuzhongshi', '宁夏回族自治区吴忠市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640302', '640300', '0,640000,640300', '利通区', 'litongqu', '宁夏回族自治区吴忠市利通区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640303', '640300', '0,640000,640300', '红寺堡区', 'hongsibaoqu', '宁夏回族自治区吴忠市红寺堡区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640323', '640300', '0,640000,640300', '盐池县', 'yanchixian', '宁夏回族自治区吴忠市盐池县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640324', '640300', '0,640000,640300', '同心县', 'tongxinxian', '宁夏回族自治区吴忠市同心县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640381', '640300', '0,640000,640300', '青铜峡市', 'qingtongxiashi', '宁夏回族自治区吴忠市青铜峡市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640400', '640000', '0,640000', '固原市', 'guyuanshi', '宁夏回族自治区固原市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640402', '640400', '0,640000,640400', '原州区', 'yuanzhouqu', '宁夏回族自治区固原市原州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640422', '640400', '0,640000,640400', '西吉县', 'xijixian', '宁夏回族自治区固原市西吉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640423', '640400', '0,640000,640400', '隆德县', 'longdexian', '宁夏回族自治区固原市隆德县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640424', '640400', '0,640000,640400', '泾源县', 'jingyuanxian', '宁夏回族自治区固原市泾源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640425', '640400', '0,640000,640400', '彭阳县', 'pengyangxian', '宁夏回族自治区固原市彭阳县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640500', '640000', '0,640000', '中卫市', 'zhongweishi', '宁夏回族自治区中卫市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640502', '640500', '0,640000,640500', '沙坡头区', 'shapotouqu', '宁夏回族自治区中卫市沙坡头区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640521', '640500', '0,640000,640500', '中宁县', 'zhongningxian', '宁夏回族自治区中卫市中宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('640522', '640500', '0,640000,640500', '海原县', 'haiyuanxian', '宁夏回族自治区中卫市海原县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650000', '0', '0', '新疆维吾尔自治区', 'xinjiangweiwuerzizhiqu', '新疆维吾尔自治区', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650100', '650000', '0,650000', '乌鲁木齐市', 'wulumuqishi', '新疆维吾尔自治区乌鲁木齐市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650102', '650100', '0,650000,650100', '天山区', 'tianshanqu', '新疆维吾尔自治区乌鲁木齐市天山区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650103', '650100', '0,650000,650100', '沙依巴克区', 'shayibakequ', '新疆维吾尔自治区乌鲁木齐市沙依巴克区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650104', '650100', '0,650000,650100', '新市区', 'xinshiqu', '新疆维吾尔自治区乌鲁木齐市新市区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650105', '650100', '0,650000,650100', '水磨沟区', 'shuimogouqu', '新疆维吾尔自治区乌鲁木齐市水磨沟区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650106', '650100', '0,650000,650100', '头屯河区', 'toutunhequ', '新疆维吾尔自治区乌鲁木齐市头屯河区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650107', '650100', '0,650000,650100', '达坂城区', 'dabanchengqu', '新疆维吾尔自治区乌鲁木齐市达坂城区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650109', '650100', '0,650000,650100', '米东区', 'midongqu', '新疆维吾尔自治区乌鲁木齐市米东区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650121', '650100', '0,650000,650100', '乌鲁木齐县', 'wulumuqixian', '新疆维吾尔自治区乌鲁木齐市乌鲁木齐县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650200', '650000', '0,650000', '克拉玛依市', 'kelamayishi', '新疆维吾尔自治区克拉玛依市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650202', '650200', '0,650000,650200', '独山子区', 'dushanziqu', '新疆维吾尔自治区克拉玛依市独山子区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650203', '650200', '0,650000,650200', '克拉玛依区', 'kelamayiqu', '新疆维吾尔自治区克拉玛依市克拉玛依区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650204', '650200', '0,650000,650200', '白碱滩区', 'baijiantanqu', '新疆维吾尔自治区克拉玛依市白碱滩区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650205', '650200', '0,650000,650200', '乌尔禾区', 'wuerhequ', '新疆维吾尔自治区克拉玛依市乌尔禾区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650400', '650000', '0,650000', '吐鲁番市', 'tulufanshi', '新疆维吾尔自治区吐鲁番市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650402', '650400', '0,650000,650400', '高昌区', 'gaochangqu', '新疆维吾尔自治区吐鲁番市高昌区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650421', '650400', '0,650000,650400', '鄯善县', 'shanshanxian', '新疆维吾尔自治区吐鲁番市鄯善县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650422', '650400', '0,650000,650400', '托克逊县', 'tuokexunxian', '新疆维吾尔自治区吐鲁番市托克逊县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650500', '650000', '0,650000', '哈密市', 'hamishi', '新疆维吾尔自治区哈密市', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650502', '650500', '0,650000,650500', '伊州区', 'yizhouqu', '新疆维吾尔自治区哈密市伊州区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650521', '650500', '0,650000,650500', '巴里坤哈萨克自治县', 'balikunhasakezizhixian', '新疆维吾尔自治区哈密市巴里坤哈萨克自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('650522', '650500', '0,650000,650500', '伊吾县', 'yiwuxian', '新疆维吾尔自治区哈密市伊吾县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652300', '650000', '0,650000', '昌吉回族自治州', 'changjihuizuzizhizhou', '新疆维吾尔自治区昌吉回族自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652301', '652300', '0,650000,652300', '昌吉市', 'changjishi', '新疆维吾尔自治区昌吉回族自治州昌吉市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652302', '652300', '0,650000,652300', '阜康市', 'fukangshi', '新疆维吾尔自治区昌吉回族自治州阜康市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652323', '652300', '0,650000,652300', '呼图壁县', 'hutubixian', '新疆维吾尔自治区昌吉回族自治州呼图壁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652324', '652300', '0,650000,652300', '玛纳斯县', 'manasixian', '新疆维吾尔自治区昌吉回族自治州玛纳斯县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652325', '652300', '0,650000,652300', '奇台县', 'qitaixian', '新疆维吾尔自治区昌吉回族自治州奇台县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652327', '652300', '0,650000,652300', '吉木萨尔县', 'jimusaerxian', '新疆维吾尔自治区昌吉回族自治州吉木萨尔县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652328', '652300', '0,650000,652300', '木垒哈萨克自治县', 'muleihasakezizhixian', '新疆维吾尔自治区昌吉回族自治州木垒哈萨克自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652700', '650000', '0,650000', '博尔塔拉蒙古自治州', 'boertalamengguzizhizhou', '新疆维吾尔自治区博尔塔拉蒙古自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652701', '652700', '0,650000,652700', '博乐市', 'boleshi', '新疆维吾尔自治区博尔塔拉蒙古自治州博乐市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652702', '652700', '0,650000,652700', '阿拉山口市', 'alashankoushi', '新疆维吾尔自治区博尔塔拉蒙古自治州阿拉山口市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652722', '652700', '0,650000,652700', '精河县', 'jinghexian', '新疆维吾尔自治区博尔塔拉蒙古自治州精河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652723', '652700', '0,650000,652700', '温泉县', 'wenquanxian', '新疆维吾尔自治区博尔塔拉蒙古自治州温泉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652800', '650000', '0,650000', '巴音郭楞蒙古自治州', 'bayinguolengmengguzizhizhou', '新疆维吾尔自治区巴音郭楞蒙古自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652801', '652800', '0,650000,652800', '库尔勒市', 'kuerleshi', '新疆维吾尔自治区巴音郭楞蒙古自治州库尔勒市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652822', '652800', '0,650000,652800', '轮台县', 'luntaixian', '新疆维吾尔自治区巴音郭楞蒙古自治州轮台县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652823', '652800', '0,650000,652800', '尉犁县', 'weilixian', '新疆维吾尔自治区巴音郭楞蒙古自治州尉犁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652824', '652800', '0,650000,652800', '若羌县', 'ruoqiangxian', '新疆维吾尔自治区巴音郭楞蒙古自治州若羌县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652825', '652800', '0,650000,652800', '且末县', 'qiemoxian', '新疆维吾尔自治区巴音郭楞蒙古自治州且末县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652826', '652800', '0,650000,652800', '焉耆回族自治县', 'yanqihuizuzizhixian', '新疆维吾尔自治区巴音郭楞蒙古自治州焉耆回族自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652827', '652800', '0,650000,652800', '和静县', 'hejingxian', '新疆维吾尔自治区巴音郭楞蒙古自治州和静县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652828', '652800', '0,650000,652800', '和硕县', 'heshuoxian', '新疆维吾尔自治区巴音郭楞蒙古自治州和硕县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652829', '652800', '0,650000,652800', '博湖县', 'bohuxian', '新疆维吾尔自治区巴音郭楞蒙古自治州博湖县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652871', '652800', '0,650000,652800', '库尔勒经济技术开发区', 'kuerlejingjijishukaifaqu', '新疆维吾尔自治区巴音郭楞蒙古自治州库尔勒经济技术开发区', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652900', '650000', '0,650000', '阿克苏地区', 'akesudiqu', '新疆维吾尔自治区阿克苏地区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652901', '652900', '0,650000,652900', '阿克苏市', 'akesushi', '新疆维吾尔自治区阿克苏地区阿克苏市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652902', '652900', '0,650000,652900', '库车市', 'kucheshi', '新疆维吾尔自治区阿克苏地区库车市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652922', '652900', '0,650000,652900', '温宿县', 'wensuxian', '新疆维吾尔自治区阿克苏地区温宿县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652924', '652900', '0,650000,652900', '沙雅县', 'shayaxian', '新疆维吾尔自治区阿克苏地区沙雅县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652925', '652900', '0,650000,652900', '新和县', 'xinhexian', '新疆维吾尔自治区阿克苏地区新和县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652926', '652900', '0,650000,652900', '拜城县', 'baichengxian', '新疆维吾尔自治区阿克苏地区拜城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652927', '652900', '0,650000,652900', '乌什县', 'wushenxian', '新疆维吾尔自治区阿克苏地区乌什县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652928', '652900', '0,650000,652900', '阿瓦提县', 'awatixian', '新疆维吾尔自治区阿克苏地区阿瓦提县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('652929', '652900', '0,650000,652900', '柯坪县', 'kepingxian', '新疆维吾尔自治区阿克苏地区柯坪县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653000', '650000', '0,650000', '克孜勒苏柯尔克孜自治州', 'kezilesukeerkezizizhizhou', '新疆维吾尔自治区克孜勒苏柯尔克孜自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653001', '653000', '0,650000,653000', '阿图什市', 'atushenshi', '新疆维吾尔自治区克孜勒苏柯尔克孜自治州阿图什市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653022', '653000', '0,650000,653000', '阿克陶县', 'aketaoxian', '新疆维吾尔自治区克孜勒苏柯尔克孜自治州阿克陶县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653023', '653000', '0,650000,653000', '阿合奇县', 'aheqixian', '新疆维吾尔自治区克孜勒苏柯尔克孜自治州阿合奇县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653024', '653000', '0,650000,653000', '乌恰县', 'wuqiaxian', '新疆维吾尔自治区克孜勒苏柯尔克孜自治州乌恰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653100', '650000', '0,650000', '喀什地区', 'kashendiqu', '新疆维吾尔自治区喀什地区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653101', '653100', '0,650000,653100', '喀什市', 'kashenshi', '新疆维吾尔自治区喀什地区喀什市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653121', '653100', '0,650000,653100', '疏附县', 'shufuxian', '新疆维吾尔自治区喀什地区疏附县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653122', '653100', '0,650000,653100', '疏勒县', 'shulexian', '新疆维吾尔自治区喀什地区疏勒县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653123', '653100', '0,650000,653100', '英吉沙县', 'yingjishaxian', '新疆维吾尔自治区喀什地区英吉沙县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653124', '653100', '0,650000,653100', '泽普县', 'zepuxian', '新疆维吾尔自治区喀什地区泽普县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653125', '653100', '0,650000,653100', '莎车县', 'shachexian', '新疆维吾尔自治区喀什地区莎车县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653126', '653100', '0,650000,653100', '叶城县', 'yechengxian', '新疆维吾尔自治区喀什地区叶城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653127', '653100', '0,650000,653100', '麦盖提县', 'maigaitixian', '新疆维吾尔自治区喀什地区麦盖提县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653128', '653100', '0,650000,653100', '岳普湖县', 'yuepuhuxian', '新疆维吾尔自治区喀什地区岳普湖县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653129', '653100', '0,650000,653100', '伽师县', 'jiashixian', '新疆维吾尔自治区喀什地区伽师县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653130', '653100', '0,650000,653100', '巴楚县', 'bachuxian', '新疆维吾尔自治区喀什地区巴楚县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653131', '653100', '0,650000,653100', '塔什库尔干塔吉克自治县', 'tashenkuergantajikezizhixian', '新疆维吾尔自治区喀什地区塔什库尔干塔吉克自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653200', '650000', '0,650000', '和田地区', 'hetiandiqu', '新疆维吾尔自治区和田地区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653201', '653200', '0,650000,653200', '和田市', 'hetianshi', '新疆维吾尔自治区和田地区和田市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653221', '653200', '0,650000,653200', '和田县', 'hetianxian', '新疆维吾尔自治区和田地区和田县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653222', '653200', '0,650000,653200', '墨玉县', 'moyuxian', '新疆维吾尔自治区和田地区墨玉县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653223', '653200', '0,650000,653200', '皮山县', 'pishanxian', '新疆维吾尔自治区和田地区皮山县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653224', '653200', '0,650000,653200', '洛浦县', 'luopuxian', '新疆维吾尔自治区和田地区洛浦县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653225', '653200', '0,650000,653200', '策勒县', 'celexian', '新疆维吾尔自治区和田地区策勒县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653226', '653200', '0,650000,653200', '于田县', 'yutianxian', '新疆维吾尔自治区和田地区于田县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('653227', '653200', '0,650000,653200', '民丰县', 'minfengxian', '新疆维吾尔自治区和田地区民丰县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654000', '650000', '0,650000', '伊犁哈萨克自治州', 'yilihasakezizhizhou', '新疆维吾尔自治区伊犁哈萨克自治州', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654002', '654000', '0,650000,654000', '伊宁市', 'yiningshi', '新疆维吾尔自治区伊犁哈萨克自治州伊宁市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654003', '654000', '0,650000,654000', '奎屯市', 'kuitunshi', '新疆维吾尔自治区伊犁哈萨克自治州奎屯市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654004', '654000', '0,650000,654000', '霍尔果斯市', 'huoerguosishi', '新疆维吾尔自治区伊犁哈萨克自治州霍尔果斯市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654021', '654000', '0,650000,654000', '伊宁县', 'yiningxian', '新疆维吾尔自治区伊犁哈萨克自治州伊宁县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654022', '654000', '0,650000,654000', '察布查尔锡伯自治县', 'chabuchaerxibozizhixian', '新疆维吾尔自治区伊犁哈萨克自治州察布查尔锡伯自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654023', '654000', '0,650000,654000', '霍城县', 'huochengxian', '新疆维吾尔自治区伊犁哈萨克自治州霍城县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654024', '654000', '0,650000,654000', '巩留县', 'gongliuxian', '新疆维吾尔自治区伊犁哈萨克自治州巩留县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654025', '654000', '0,650000,654000', '新源县', 'xinyuanxian', '新疆维吾尔自治区伊犁哈萨克自治州新源县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654026', '654000', '0,650000,654000', '昭苏县', 'zhaosuxian', '新疆维吾尔自治区伊犁哈萨克自治州昭苏县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654027', '654000', '0,650000,654000', '特克斯县', 'tekesixian', '新疆维吾尔自治区伊犁哈萨克自治州特克斯县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654028', '654000', '0,650000,654000', '尼勒克县', 'nilekexian', '新疆维吾尔自治区伊犁哈萨克自治州尼勒克县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654200', '650000', '0,650000', '塔城地区', 'tachengdiqu', '新疆维吾尔自治区塔城地区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654201', '654200', '0,650000,654200', '塔城市', 'tachengshi', '新疆维吾尔自治区塔城地区塔城市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654202', '654200', '0,650000,654200', '乌苏市', 'wusushi', '新疆维吾尔自治区塔城地区乌苏市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654203', '654200', '0,650000,654200', '沙湾市', 'shawanshi', '新疆维吾尔自治区塔城地区沙湾市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654221', '654200', '0,650000,654200', '额敏县', 'eminxian', '新疆维吾尔自治区塔城地区额敏县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654224', '654200', '0,650000,654200', '托里县', 'tuolixian', '新疆维吾尔自治区塔城地区托里县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654225', '654200', '0,650000,654200', '裕民县', 'yuminxian', '新疆维吾尔自治区塔城地区裕民县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654226', '654200', '0,650000,654200', '和布克赛尔蒙古自治县', 'hebukesaiermengguzizhixian', '新疆维吾尔自治区塔城地区和布克赛尔蒙古自治县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654300', '650000', '0,650000', '阿勒泰地区', 'aletaidiqu', '新疆维吾尔自治区阿勒泰地区', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654301', '654300', '0,650000,654300', '阿勒泰市', 'aletaishi', '新疆维吾尔自治区阿勒泰地区阿勒泰市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654321', '654300', '0,650000,654300', '布尔津县', 'buerjinxian', '新疆维吾尔自治区阿勒泰地区布尔津县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654322', '654300', '0,650000,654300', '富蕴县', 'fuyunxian', '新疆维吾尔自治区阿勒泰地区富蕴县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654323', '654300', '0,650000,654300', '福海县', 'fuhaixian', '新疆维吾尔自治区阿勒泰地区福海县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654324', '654300', '0,650000,654300', '哈巴河县', 'habahexian', '新疆维吾尔自治区阿勒泰地区哈巴河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654325', '654300', '0,650000,654300', '青河县', 'qinghexian', '新疆维吾尔自治区阿勒泰地区青河县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('654326', '654300', '0,650000,654300', '吉木乃县', 'jimunaixian', '新疆维吾尔自治区阿勒泰地区吉木乃县', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659000', '650000', '0,650000', '自治区直辖县级行政区划', 'zizhiquzhixiaxianjixingzhengquhua', '新疆维吾尔自治区自治区直辖县级行政区划', '2');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659001', '659000', '0,650000,659000', '石河子市', 'shihezishi', '新疆维吾尔自治区自治区直辖县级行政区划石河子市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659002', '659000', '0,650000,659000', '阿拉尔市', 'alaershi', '新疆维吾尔自治区自治区直辖县级行政区划阿拉尔市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659003', '659000', '0,650000,659000', '图木舒克市', 'tumushukeshi', '新疆维吾尔自治区自治区直辖县级行政区划图木舒克市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659004', '659000', '0,650000,659000', '五家渠市', 'wujiaqushi', '新疆维吾尔自治区自治区直辖县级行政区划五家渠市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659005', '659000', '0,650000,659000', '北屯市', 'beitunshi', '新疆维吾尔自治区自治区直辖县级行政区划北屯市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659006', '659000', '0,650000,659000', '铁门关市', 'tiemenguanshi', '新疆维吾尔自治区自治区直辖县级行政区划铁门关市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659007', '659000', '0,650000,659000', '双河市', 'shuangheshi', '新疆维吾尔自治区自治区直辖县级行政区划双河市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659008', '659000', '0,650000,659000', '可克达拉市', 'kekedalashi', '新疆维吾尔自治区自治区直辖县级行政区划可克达拉市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659009', '659000', '0,650000,659000', '昆玉市', 'kunyushi', '新疆维吾尔自治区自治区直辖县级行政区划昆玉市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659010', '659000', '0,650000,659000', '胡杨河市', 'huyangheshi', '新疆维吾尔自治区自治区直辖县级行政区划胡杨河市', '3');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('659011', '659000', '0,650000,659000', '新星市', 'xinxingshi', '新疆维吾尔自治区自治区直辖县级行政区划新星市', '3');

INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('810000', '0', '0', '香港', 'xianggang','香港', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('820000', '0', '0', '澳门', 'aomen', '澳门', '1');
INSERT INTO `region`(`id`, `pid`, `pids`, `name`, `pinyin`, `full_name`, `level`) VALUES ('710000', '0', '0', '台湾省', 'taiwansheng', '台湾省', '1');
编程曹贼
关注
  • 2
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
省市区三级行政区代码（包含港澳台）sql3
lxhJava15的博客
02-12 888
省市区三级行政区代码（包含港澳台）sql
省市区三级行政区代码（包含港澳台）sql1
lxhJava15的博客
02-12 589
省市区三级行政区代码（包含港澳台）sql
最新全国省市区行政区划码SQL（依据官方GB-T2260更新到2020.12月）
06-22
省市区三级行政区划码，父子关系通用建表语句和最新数据 （依据官方GB-T2260更新到2020.12月），方便查询。 省市区查询下拉列表，行政区划数据内外部数据对接都可使用 —— 行政区划码是统一的传输依据 。
全国省级地级县级行政区sql与json数据
SuperMan程序人生（关注微信公众号）
01-20 4056
数据可以从 国家统计局 的官网拿，网址：http://www.stats.gov.cn/   本人这里使用的是17年的数据，用于做城市选择时的三级联动菜单用，台湾/香港/澳门的数据有些丢失。（后面会更新json数据） ，本人前端使用的是vue+elementUi框架，若有同样的，可以直接使用该dataJSON，若有其他格式需要，可以下方留言。 [ { "chil...
全国省市区县 4级数据 sql文件 2023年版
最新发布
Ares_aggs的博客
04-16 286
链接: https://pan.baidu.com/s/1VlQXo4s37JKyeGuNGHREww?这是作者2023年在高德地图上爬取的。一共44170条数据。
全国各省、市、区（sql语句）
SYJ的博客
12-26 5015
返回项目列表 一、省份（数据表） DROP TABLE IF EXISTS t_province; create table `t_province` ( `id` varchar (16), `name` varchar (32) ); insert into `t_province` (`id`, `name`) values('110000','北京市'); insert into `t_province` (`id`, `name`) values('120000','天津市'); inse
Java行政区划代码处理，包含源JSON文件，处理过后的JSON、Excel、SQL文件
weixin_43165220的博客
06-02 1343
民政部最新的行政区划代码，包含源JSON文件，处理后的JSON、Excel、SQL文件
地级市行政区域划代码
CrazyApes的博客
02-09 4852
行政区域划代码，城市编码，城市代码，城市code，CityCode，adcode
最新中国行政区划，城市代码，sql文件（含省市区行政编码，邮编，区号，拼音，经纬度坐标）
04-18
最新中国省市县行政编码，邮编，区号，拼音，经纬度坐标，层级关系等。 两种格式： 1、sql格式文件，可直接导入 2、MYSQL语句可直接执行使用
全国省市区及地区编码表结构和数据sql
06-12
全国省市区编码表数据表结构和数据，可自行添加补充，扩展补充即可
2018最新行政区划整理sql版
01-05
2018最新县级及其以上的行政区划sql执行脚本,包含上下级关系;
2018最新全国行政区划代码sql文件
04-18
1、从国家统计局下载《最新县及县以上行政区划代码（截止2018年4月10日）》 2、转成utf-8文本 3、自编php程序，读取文本入库Mysql 4、4字段设计，简洁干净 5、无毒、无污染、无外挂 6、欢迎使用
中国行政区划(省市区县)数据库 SQL文件
07-24
中国行政区划(省市区县)数据库 SQL文件，可直在数据库中接运行，生成省，市，区，县三张数据表，根据ID进行数据联动
国内最新行政区划（包含省，市，区），附赠世界行政区划（包含洲，国家，城市）（数据库SQL）
10-10
都是好货。网上淘不到这么全的。
省市区三级行政区代码（包含港澳台）sql2
lxhJava15的博客
02-12 426
省市区三级行政区代码（包含港澳台）sql2
省市区三级联动包含港澳台sql
07-11
INSERT INTO `t_sys_area` VALUES ('4', '1', '天津市', '天津市', '1', '120000', '1', '', 'TJ'); INSERT INTO `t_sys_area` VALUES ('5', '1', '河北省', '河北省', '2', '130000', '1', '', 'HB'); INSERT INTO ...
全国行政区划代码(包含港澳台)
05-28
全国行政区划代码(包含港澳台)，包含全国省市区的编码及其名称
四级地址库 国家标准的行政区划代码 省市区街道sql
07-02
四级地址库国家标准的行政区划代码省市区街道SQL是一种数据库查询语言，用于查询四级地址库中的国家标准行政区划代码、省市区和街道信息。 该SQL语句可以通过数据库查询获取所需的地址信息，方便地进行数据分析和应用开发。 例如，以下是一个简单的SQL语句示例，用于查询四级地址库中的省市区街道信息： ``` SELECT 省份, 城市, 区县, 街道 FROM 四级地址库 ``` 该语句会从名为"四级地址库"的数据库表格中选择省份（省市）、城市、区县和街道这四个字段，并将其作为查询结果返回。 使用这样的SQL语句，可以对四级地址库进行各种数据查询和分析操作。比如，可以根据某个具体的行政区划代码查询对应的省市区街道信息，也可以根据省市区名称模糊查询获取相应的行政区划代码等等。 总而言之，四级地址库国家标准的行政区划代码省市区街道SQL是一种利用数据库查询语言来访问四级地址库中的地址信息的方法，方便对地址数据进行各种操作和应用。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值