最全中国和美国省、州、市数据库脚本，可直接复制运行

拼搏现实的明天。 2021-12-15 22:59 182阅读 0赞

## 这里附上SQL脚本 ##

### 中国省份数据 ###

/*
    Date: 03/07/2019 13:22:07
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for Provincial
    -- ----------------------------
    DROP TABLE IF EXISTS `Provincial`;
    CREATE TABLE `Provincial`  (
      `pid` int(11) NOT NULL,
      `Provincial` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`pid`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of Provincial
    -- ----------------------------
    INSERT INTO `Provincial` VALUES (1, '北京市');
    INSERT INTO `Provincial` VALUES (2, '天津市');
    INSERT INTO `Provincial` VALUES (3, '上海市');
    INSERT INTO `Provincial` VALUES (4, '重庆市');
    INSERT INTO `Provincial` VALUES (5, '河北省');
    INSERT INTO `Provincial` VALUES (6, '山西省');
    INSERT INTO `Provincial` VALUES (7, '台湾省');
    INSERT INTO `Provincial` VALUES (8, '辽宁省');
    INSERT INTO `Provincial` VALUES (9, '吉林省');
    INSERT INTO `Provincial` VALUES (10, '黑龙江省');
    INSERT INTO `Provincial` VALUES (11, '江苏省');
    INSERT INTO `Provincial` VALUES (12, '浙江省');
    INSERT INTO `Provincial` VALUES (13, '安徽省');
    INSERT INTO `Provincial` VALUES (14, '福建省');
    INSERT INTO `Provincial` VALUES (15, '江西省');
    INSERT INTO `Provincial` VALUES (16, '山东省');
    INSERT INTO `Provincial` VALUES (17, '河南省');
    INSERT INTO `Provincial` VALUES (18, '湖北省');
    INSERT INTO `Provincial` VALUES (19, '湖南省');
    INSERT INTO `Provincial` VALUES (20, '广东省');
    INSERT INTO `Provincial` VALUES (21, '甘肃省');
    INSERT INTO `Provincial` VALUES (22, '四川省');
    INSERT INTO `Provincial` VALUES (23, '贵州省');
    INSERT INTO `Provincial` VALUES (24, '海南省');
    INSERT INTO `Provincial` VALUES (25, '云南省');
    INSERT INTO `Provincial` VALUES (26, '青海省');
    INSERT INTO `Provincial` VALUES (27, '陕西省');
    INSERT INTO `Provincial` VALUES (28, '广西壮族自治区');
    INSERT INTO `Provincial` VALUES (29, '西藏自治区');
    INSERT INTO `Provincial` VALUES (30, '宁夏回族自治区');
    INSERT INTO `Provincial` VALUES (31, '新疆维吾尔自治区');
    INSERT INTO `Provincial` VALUES (32, '内蒙古自治区');
    INSERT INTO `Provincial` VALUES (33, '澳门特别行政区');
    INSERT INTO `Provincial` VALUES (34, '香港特别行政区');
    
    SET FOREIGN_KEY_CHECKS = 1;

### 中国城市数据 ###

/*
    Date: 03/07/2019 13:21:55
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for City
    -- ----------------------------
    DROP TABLE IF EXISTS `City`;
    CREATE TABLE `City`  (
      `cid` int(11) NOT NULL,
      `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
      `pid` int(11) NULL DEFAULT NULL,
      PRIMARY KEY (`city`) USING BTREE,
      INDEX `faask`(`pid`) USING BTREE,
      CONSTRAINT `faask` FOREIGN KEY (`pid`) REFERENCES `Provincial` (`pid`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of City
    -- ----------------------------
    INSERT INTO `City` VALUES (10, '七台河市', 10);
    INSERT INTO `City` VALUES (7, '万宁市', 24);
    INSERT INTO `City` VALUES (2, '三亚市', 24);
    INSERT INTO `City` VALUES (4, '三明市', 14);
    INSERT INTO `City` VALUES (12, '三门峡市', 17);
    INSERT INTO `City` VALUES (1, '上海市', 3);
    INSERT INTO `City` VALUES (11, '上饶市', 15);
    INSERT INTO `City` VALUES (8, '东方市', 24);
    INSERT INTO `City` VALUES (17, '东莞市', 20);
    INSERT INTO `City` VALUES (5, '东营市', 16);
    INSERT INTO `City` VALUES (5, '中卫市', 30);
    INSERT INTO `City` VALUES (18, '中山市', 20);
    INSERT INTO `City` VALUES (13, '临夏回族自治州', 21);
    INSERT INTO `City` VALUES (10, '临汾市', 6);
    INSERT INTO `City` VALUES (13, '临沂市', 16);
    INSERT INTO `City` VALUES (8, '临沧市', 25);
    INSERT INTO `City` VALUES (12, '临高县', 24);
    INSERT INTO `City` VALUES (6, '丹东市', 8);
    INSERT INTO `City` VALUES (11, '丽水市', 12);
    INSERT INTO `City` VALUES (6, '丽江市', 25);
    INSERT INTO `City` VALUES (9, '乌兰察布市', 32);
    INSERT INTO `City` VALUES (3, '乌海市', 32);
    INSERT INTO `City` VALUES (21, '乌苏市', 31);
    INSERT INTO `City` VALUES (1, '乌鲁木齐市', 31);
    INSERT INTO `City` VALUES (15, '乐东黎族自治县', 24);
    INSERT INTO `City` VALUES (10, '乐山市', 22);
    INSERT INTO `City` VALUES (4, '九江市', 15);
    INSERT INTO `City` VALUES (16, '云林县', 7);
    INSERT INTO `City` VALUES (21, '云浮市', 20);
    INSERT INTO `City` VALUES (6, '五家渠市', 31);
    INSERT INTO `City` VALUES (3, '五指山市', 24);
    INSERT INTO `City` VALUES (15, '亳州市', 13);
    INSERT INTO `City` VALUES (13, '仙桃市', 18);
    INSERT INTO `City` VALUES (7, '伊 春 市', 10);
    INSERT INTO `City` VALUES (18, '伊宁市', 31);
    INSERT INTO `City` VALUES (6, '佛山市', 20);
    INSERT INTO `City` VALUES (9, '佳木斯市', 10);
    INSERT INTO `City` VALUES (17, '保亭黎族苗族自治县', 24);
    INSERT INTO `City` VALUES (6, '保定市', 5);
    INSERT INTO `City` VALUES (4, '保山市', 25);
    INSERT INTO `City` VALUES (15, '信阳市', 17);
    INSERT INTO `City` VALUES (5, '儋州市', 24);
    INSERT INTO `City` VALUES (2, '克拉玛依市', 31);
    INSERT INTO `City` VALUES (14, '六安市', 13);
    INSERT INTO `City` VALUES (2, '六盘水市', 23);
    INSERT INTO `City` VALUES (1, '兰州市', 21);
    INSERT INTO `City` VALUES (11, '兴安盟', 32);
    INSERT INTO `City` VALUES (9, '内江市', 22);
    INSERT INTO `City` VALUES (21, '凉山彝族自治州', 22);
    INSERT INTO `City` VALUES (2, '包头市', 32);
    INSERT INTO `City` VALUES (1, '北京市', 1);
    INSERT INTO `City` VALUES (5, '北海市', 28);
    INSERT INTO `City` VALUES (3, '十堰市', 18);
    INSERT INTO `City` VALUES (1, '南京市', 11);
    INSERT INTO `City` VALUES (11, '南充市', 22);
    INSERT INTO `City` VALUES (1, '南宁市', 28);
    INSERT INTO `City` VALUES (7, '南平市', 14);
    INSERT INTO `City` VALUES (15, '南投县', 7);
    INSERT INTO `City` VALUES (1, '南昌市', 15);
    INSERT INTO `City` VALUES (6, '南通市', 11);
    INSERT INTO `City` VALUES (13, '南阳市', 17);
    INSERT INTO `City` VALUES (17, '博乐市', 31);
    INSERT INTO `City` VALUES (2, '厦门市', 14);
    INSERT INTO `City` VALUES (4, '双鸭山市', 10);
    INSERT INTO `City` VALUES (22, '台东县', 7);
    INSERT INTO `City` VALUES (13, '台中县', 7);
    INSERT INTO `City` VALUES (4, '台中市', 7);
    INSERT INTO `City` VALUES (8, '台北县', 7);
    INSERT INTO `City` VALUES (1, '台北市', 7);
    INSERT INTO `City` VALUES (18, '台南县', 7);
    INSERT INTO `City` VALUES (5, '台南市', 7);
    INSERT INTO `City` VALUES (10, '台州市', 12);
    INSERT INTO `City` VALUES (1, '合肥市', 13);
    INSERT INTO `City` VALUES (8, '吉安市', 15);
    INSERT INTO `City` VALUES (2, '吉林市', 9);
    INSERT INTO `City` VALUES (7, '吐鲁番市', 31);
    INSERT INTO `City` VALUES (11, '吕梁市', 6);
    INSERT INTO `City` VALUES (3, '吴忠市', 30);
    INSERT INTO `City` VALUES (16, '周口市', 17);
    INSERT INTO `City` VALUES (7, '呼伦贝尔市', 32);
    INSERT INTO `City` VALUES (1, '呼和浩特市', 32);
    INSERT INTO `City` VALUES (11, '和田市', 31);
    INSERT INTO `City` VALUES (11, '咸宁市', 18);
    INSERT INTO `City` VALUES (4, '咸阳市', 27);
    INSERT INTO `City` VALUES (10, '哈密市', 31);
    INSERT INTO `City` VALUES (1, '哈尔滨市', 10);
    INSERT INTO `City` VALUES (2, '唐山市', 5);
    INSERT INTO `City` VALUES (14, '商丘市', 17);
    INSERT INTO `City` VALUES (10, '商洛市', 27);
    INSERT INTO `City` VALUES (9, '喀什市', 31);
    INSERT INTO `City` VALUES (17, '嘉义县', 7);
    INSERT INTO `City` VALUES (7, '嘉义市', 7);
    INSERT INTO `City` VALUES (4, '嘉兴市', 12);
    INSERT INTO `City` VALUES (5, '嘉峪关市', 21);
    INSERT INTO `City` VALUES (3, '四平市', 9);
    INSERT INTO `City` VALUES (4, '固原市', 30);
    INSERT INTO `City` VALUES (5, '图木舒克市', 31);
    INSERT INTO `City` VALUES (3, '基隆市', 7);
    INSERT INTO `City` VALUES (20, '塔城市', 31);
    INSERT INTO `City` VALUES (6, '大 庆 市', 10);
    INSERT INTO `City` VALUES (13, '大兴安岭地区', 10);
    INSERT INTO `City` VALUES (2, '大同市', 6);
    INSERT INTO `City` VALUES (13, '大理白族自治州', 25);
    INSERT INTO `City` VALUES (2, '大连市', 8);
    INSERT INTO `City` VALUES (4, '天水市', 21);
    INSERT INTO `City` VALUES (1, '天津市', 2);
    INSERT INTO `City` VALUES (14, '天门市', 18);
    INSERT INTO `City` VALUES (1, '太原市', 6);
    INSERT INTO `City` VALUES (19, '奎屯市', 31);
    INSERT INTO `City` VALUES (10, '威海市', 16);
    INSERT INTO `City` VALUES (13, '娄底市', 19);
    INSERT INTO `City` VALUES (9, '孝感市', 18);
    INSERT INTO `City` VALUES (9, '宁德市', 14);
    INSERT INTO `City` VALUES (2, '宁波市', 12);
    INSERT INTO `City` VALUES (8, '安庆市', 13);
    INSERT INTO `City` VALUES (9, '安康市', 27);
    INSERT INTO `City` VALUES (5, '安阳市', 17);
    INSERT INTO `City` VALUES (4, '安顺市', 23);
    INSERT INTO `City` VALUES (10, '定安县', 24);
    INSERT INTO `City` VALUES (11, '定西市', 21);
    INSERT INTO `City` VALUES (9, '宜兰县', 7);
    INSERT INTO `City` VALUES (13, '宜宾市', 22);
    INSERT INTO `City` VALUES (5, '宜昌市', 18);
    INSERT INTO `City` VALUES (9, '宜春市', 15);
    INSERT INTO `City` VALUES (3, '宝鸡市', 27);
    INSERT INTO `City` VALUES (17, '宣城市', 13);
    INSERT INTO `City` VALUES (12, '宿州市', 13);
    INSERT INTO `City` VALUES (13, '宿迁市', 11);
    INSERT INTO `City` VALUES (20, '屏东县', 7);
    INSERT INTO `City` VALUES (11, '屯昌县', 24);
    INSERT INTO `City` VALUES (4, '山南地区', 29);
    INSERT INTO `City` VALUES (6, '岳阳市', 19);
    INSERT INTO `City` VALUES (14, '崇左市', 28);
    INSERT INTO `City` VALUES (13, '巢湖市', 13);
    INSERT INTO `City` VALUES (17, '巴中市', 22);
    INSERT INTO `City` VALUES (8, '巴彦淖尔市', 32);
    INSERT INTO `City` VALUES (4, '常州市', 11);
    INSERT INTO `City` VALUES (7, '常德市', 19);
    INSERT INTO `City` VALUES (8, '平凉市', 21);
    INSERT INTO `City` VALUES (4, '平顶山市', 17);
    INSERT INTO `City` VALUES (7, '广元市', 22);
    INSERT INTO `City` VALUES (14, '广安市', 22);
    INSERT INTO `City` VALUES (1, '广州市', 20);
    INSERT INTO `City` VALUES (10, '庆阳市', 21);
    INSERT INTO `City` VALUES (13, '库尔勒市', 31);
    INSERT INTO `City` VALUES (10, '廊坊市', 5);
    INSERT INTO `City` VALUES (6, '延安市', 27);
    INSERT INTO `City` VALUES (9, '延边朝鲜族自治州', 9);
    INSERT INTO `City` VALUES (2, '开封市', 17);
    INSERT INTO `City` VALUES (7, '张家口市', 5);
    INSERT INTO `City` VALUES (8, '张家界市', 19);
    INSERT INTO `City` VALUES (7, '张掖市', 21);
    INSERT INTO `City` VALUES (14, '彰化县', 7);
    INSERT INTO `City` VALUES (3, '徐州市', 11);
    INSERT INTO `City` VALUES (14, '德宏傣族景颇族自治州', 25);
    INSERT INTO `City` VALUES (14, '德州市', 16);
    INSERT INTO `City` VALUES (5, '德阳市', 22);
    INSERT INTO `City` VALUES (9, '忻州市', 6);
    INSERT INTO `City` VALUES (12, '怀化市', 19);
    INSERT INTO `City` VALUES (15, '怒江傈傈族自治州', 25);
    INSERT INTO `City` VALUES (7, '思茅市', 25);
    INSERT INTO `City` VALUES (17, '恩施土家族苗族自治州', 18);
    INSERT INTO `City` VALUES (11, '惠州市', 20);
    INSERT INTO `City` VALUES (1, '成都市', 22);
    INSERT INTO `City` VALUES (10, '扬州市', 11);
    INSERT INTO `City` VALUES (8, '承德市', 5);
    INSERT INTO `City` VALUES (10, '抚州市', 15);
    INSERT INTO `City` VALUES (4, '抚顺市', 8);
    INSERT INTO `City` VALUES (1, '拉萨市', 29);
    INSERT INTO `City` VALUES (20, '揭阳市', 20);
    INSERT INTO `City` VALUES (3, '攀枝花市', 22);
    INSERT INTO `City` VALUES (9, '文山壮族苗族自治州', 25);
    INSERT INTO `City` VALUES (6, '文昌市', 24);
    INSERT INTO `City` VALUES (7, '新乡市', 17);
    INSERT INTO `City` VALUES (5, '新余市', 15);
    INSERT INTO `City` VALUES (11, '新竹县', 7);
    INSERT INTO `City` VALUES (6, '新竹市', 7);
    INSERT INTO `City` VALUES (2, '无锡市', 11);
    INSERT INTO `City` VALUES (5, '日喀则地区', 29);
    INSERT INTO `City` VALUES (11, '日照市', 16);
    INSERT INTO `City` VALUES (1, '昆明市', 25);
    INSERT INTO `City` VALUES (14, '昌吉市　', 31);
    INSERT INTO `City` VALUES (14, '昌江黎族自治县', 24);
    INSERT INTO `City` VALUES (3, '昌都地区', 29);
    INSERT INTO `City` VALUES (5, '昭通市', 25);
    INSERT INTO `City` VALUES (7, '晋中市', 6);
    INSERT INTO `City` VALUES (5, '晋城市', 6);
    INSERT INTO `City` VALUES (2, '景德镇市', 15);
    INSERT INTO `City` VALUES (2, '曲靖市', 25);
    INSERT INTO `City` VALUES (6, '朔州市', 6);
    INSERT INTO `City` VALUES (13, '朝阳市', 8);
    INSERT INTO `City` VALUES (5, '本溪市', 8);
    INSERT INTO `City` VALUES (13, '来宾市', 28);
    INSERT INTO `City` VALUES (1, '杭州市', 12);
    INSERT INTO `City` VALUES (7, '松原市', 9);
    INSERT INTO `City` VALUES (7, '林芝地区', 29);
    INSERT INTO `City` VALUES (6, '果洛藏族自治州', 26);
    INSERT INTO `City` VALUES (4, '枣庄市', 16);
    INSERT INTO `City` VALUES (2, '柳州市', 28);
    INSERT INTO `City` VALUES (2, '株洲市', 19);
    INSERT INTO `City` VALUES (3, '桂林市', 28);
    INSERT INTO `City` VALUES (10, '桃园县', 7);
    INSERT INTO `City` VALUES (12, '梅州市', 20);
    INSERT INTO `City` VALUES (4, '梧州市', 28);
    INSERT INTO `City` VALUES (12, '楚雄彝族自治州', 25);
    INSERT INTO `City` VALUES (8, '榆林市', 27);
    INSERT INTO `City` VALUES (6, '武威市', 21);
    INSERT INTO `City` VALUES (1, '武汉市', 18);
    INSERT INTO `City` VALUES (6, '毕节地区', 23);
    INSERT INTO `City` VALUES (11, '永州市', 19);
    INSERT INTO `City` VALUES (7, '汉中市', 27);
    INSERT INTO `City` VALUES (4, '汕头市', 20);
    INSERT INTO `City` VALUES (13, '汕尾市', 20);
    INSERT INTO `City` VALUES (7, '江门市', 20);
    INSERT INTO `City` VALUES (16, '池州市', 13);
    INSERT INTO `City` VALUES (1, '沈阳市', 8);
    INSERT INTO `City` VALUES (9, '沧州市', 5);
    INSERT INTO `City` VALUES (12, '河池市', 28);
    INSERT INTO `City` VALUES (14, '河源市', 20);
    INSERT INTO `City` VALUES (5, '泉州市', 14);
    INSERT INTO `City` VALUES (9, '泰安市', 16);
    INSERT INTO `City` VALUES (12, '泰州市', 11);
    INSERT INTO `City` VALUES (4, '泸州市', 22);
    INSERT INTO `City` VALUES (3, '洛阳市', 17);
    INSERT INTO `City` VALUES (1, '济南市', 16);
    INSERT INTO `City` VALUES (8, '济宁市', 16);
    INSERT INTO `City` VALUES (18, '济源市', 17);
    INSERT INTO `City` VALUES (2, '海东地区', 26);
    INSERT INTO `City` VALUES (3, '海北藏族自治州', 26);
    INSERT INTO `City` VALUES (5, '海南藏族自治州', 26);
    INSERT INTO `City` VALUES (1, '海口市', 24);
    INSERT INTO `City` VALUES (8, '海西蒙古族藏族自治州', 26);
    INSERT INTO `City` VALUES (3, '淄博市', 16);
    INSERT INTO `City` VALUES (6, '淮北市', 13);
    INSERT INTO `City` VALUES (4, '淮南市', 13);
    INSERT INTO `City` VALUES (8, '淮安市', 11);
    INSERT INTO `City` VALUES (2, '深圳市', 20);
    INSERT INTO `City` VALUES (16, '清远市', 20);
    INSERT INTO `City` VALUES (3, '温州市', 12);
    INSERT INTO `City` VALUES (5, '渭南市', 27);
    INSERT INTO `City` VALUES (5, '湖州市', 12);
    INSERT INTO `City` VALUES (3, '湘潭市', 19);
    INSERT INTO `City` VALUES (14, '湘西土家族苗族自治州', 19);
    INSERT INTO `City` VALUES (8, '湛江市', 20);
    INSERT INTO `City` VALUES (10, '滁州市', 13);
    INSERT INTO `City` VALUES (16, '滨州市', 16);
    INSERT INTO `City` VALUES (11, '漯河市', 17);
    INSERT INTO `City` VALUES (6, '漳州市', 14);
    INSERT INTO `City` VALUES (7, '潍坊市', 16);
    INSERT INTO `City` VALUES (15, '潜江市', 18);
    INSERT INTO `City` VALUES (19, '潮州市', 20);
    INSERT INTO `City` VALUES (9, '澄迈县', 24);
    INSERT INTO `City` VALUES (21, '澎湖县', 7);
    INSERT INTO `City` VALUES (1, '澳门特别行政区', 33);
    INSERT INTO `City` VALUES (9, '濮阳市', 17);
    INSERT INTO `City` VALUES (6, '烟台市', 16);
    INSERT INTO `City` VALUES (8, '焦作市', 17);
    INSERT INTO `City` VALUES (8, '牡丹江市', 10);
    INSERT INTO `City` VALUES (9, '玉林市', 28);
    INSERT INTO `City` VALUES (7, '玉树藏族自治州', 26);
    INSERT INTO `City` VALUES (3, '玉溪市', 25);
    INSERT INTO `City` VALUES (3, '珠海市', 20);
    INSERT INTO `City` VALUES (18, '琼中黎族苗族自治县', 24);
    INSERT INTO `City` VALUES (4, '琼海市', 24);
    INSERT INTO `City` VALUES (14, '甘南藏族自治州', 21);
    INSERT INTO `City` VALUES (20, '甘孜藏族自治州', 22);
    INSERT INTO `City` VALUES (8, '白城市', 9);
    INSERT INTO `City` VALUES (6, '白山市', 9);
    INSERT INTO `City` VALUES (13, '白沙黎族自治县', 24);
    INSERT INTO `City` VALUES (3, '白银市', 21);
    INSERT INTO `City` VALUES (10, '百色市', 28);
    INSERT INTO `City` VALUES (9, '益阳市', 19);
    INSERT INTO `City` VALUES (9, '盐城市', 11);
    INSERT INTO `City` VALUES (11, '盘锦市', 8);
    INSERT INTO `City` VALUES (12, '眉山市', 22);
    INSERT INTO `City` VALUES (2, '石嘴山市', 30);
    INSERT INTO `City` VALUES (1, '石家庄市', 5);
    INSERT INTO `City` VALUES (3, '石河子市　', 31);
    INSERT INTO `City` VALUES (16, '神农架林区', 18);
    INSERT INTO `City` VALUES (1, '福州市', 14);
    INSERT INTO `City` VALUES (3, '秦皇岛市', 5);
    INSERT INTO `City` VALUES (16, '米泉市', 31);
    INSERT INTO `City` VALUES (10, '红河哈尼族彝族自治州', 25);
    INSERT INTO `City` VALUES (6, '绍兴市', 12);
    INSERT INTO `City` VALUES (12, '绥 化 市', 10);
    INSERT INTO `City` VALUES (6, '绵阳市', 22);
    INSERT INTO `City` VALUES (15, '聊城市', 16);
    INSERT INTO `City` VALUES (10, '肇庆市', 20);
    INSERT INTO `City` VALUES (2, '自贡市', 22);
    INSERT INTO `City` VALUES (9, '舟山市', 12);
    INSERT INTO `City` VALUES (2, '芜湖市', 13);
    INSERT INTO `City` VALUES (23, '花莲县', 7);
    INSERT INTO `City` VALUES (5, '苏州市', 11);
    INSERT INTO `City` VALUES (12, '苗栗县', 7);
    INSERT INTO `City` VALUES (9, '茂名市', 20);
    INSERT INTO `City` VALUES (4, '荆州市', 18);
    INSERT INTO `City` VALUES (8, '荆门市', 18);
    INSERT INTO `City` VALUES (3, '莆田市', 14);
    INSERT INTO `City` VALUES (12, '莱芜市', 16);
    INSERT INTO `City` VALUES (17, '菏泽市', 16);
    INSERT INTO `City` VALUES (3, '萍乡市', 15);
    INSERT INTO `City` VALUES (8, '营口市', 8);
    INSERT INTO `City` VALUES (14, '葫芦岛市', 8);
    INSERT INTO `City` VALUES (3, '蚌埠市', 13);
    INSERT INTO `City` VALUES (11, '衡水市', 5);
    INSERT INTO `City` VALUES (4, '衡阳市', 19);
    INSERT INTO `City` VALUES (8, '衢州市', 12);
    INSERT INTO `City` VALUES (6, '襄樊市', 18);
    INSERT INTO `City` VALUES (11, '西双版纳傣族自治州', 25);
    INSERT INTO `City` VALUES (1, '西宁市', 26);
    INSERT INTO `City` VALUES (1, '西安市', 27);
    INSERT INTO `City` VALUES (10, '许昌市', 17);
    INSERT INTO `City` VALUES (8, '贵港市', 28);
    INSERT INTO `City` VALUES (1, '贵阳市', 23);
    INSERT INTO `City` VALUES (11, '贺州市', 28);
    INSERT INTO `City` VALUES (18, '资阳市', 22);
    INSERT INTO `City` VALUES (7, '赣州市', 15);
    INSERT INTO `City` VALUES (4, '赤峰市', 32);
    INSERT INTO `City` VALUES (4, '辽源市', 9);
    INSERT INTO `City` VALUES (10, '辽阳市', 8);
    INSERT INTO `City` VALUES (15, '达州市', 22);
    INSERT INTO `City` VALUES (8, '运城市', 6);
    INSERT INTO `City` VALUES (7, '连云港市', 11);
    INSERT INTO `City` VALUES (16, '迪庆藏族自治州', 25);
    INSERT INTO `City` VALUES (5, '通化市', 9);
    INSERT INTO `City` VALUES (5, '通辽市', 32);
    INSERT INTO `City` VALUES (8, '遂宁市', 22);
    INSERT INTO `City` VALUES (3, '遵义市', 23);
    INSERT INTO `City` VALUES (5, '邢台市', 5);
    INSERT INTO `City` VALUES (2, '那曲地区', 29);
    INSERT INTO `City` VALUES (4, '邯郸市', 5);
    INSERT INTO `City` VALUES (5, '邵阳市', 19);
    INSERT INTO `City` VALUES (1, '郑州市', 17);
    INSERT INTO `City` VALUES (10, '郴州市', 19);
    INSERT INTO `City` VALUES (6, '鄂尔多斯市', 32);
    INSERT INTO `City` VALUES (7, '鄂州市', 18);
    INSERT INTO `City` VALUES (9, '酒泉市', 21);
    INSERT INTO `City` VALUES (1, '重庆市', 4);
    INSERT INTO `City` VALUES (7, '金华市', 12);
    INSERT INTO `City` VALUES (2, '金昌市', 21);
    INSERT INTO `City` VALUES (7, '钦州市', 28);
    INSERT INTO `City` VALUES (12, '铁岭市', 8);
    INSERT INTO `City` VALUES (5, '铜仁地区', 23);
    INSERT INTO `City` VALUES (2, '铜川市', 27);
    INSERT INTO `City` VALUES (7, '铜陵市', 13);
    INSERT INTO `City` VALUES (1, '银川市', 30);
    INSERT INTO `City` VALUES (10, '锡林郭勒盟', 32);
    INSERT INTO `City` VALUES (7, '锦州市', 8);
    INSERT INTO `City` VALUES (11, '镇江市', 11);
    INSERT INTO `City` VALUES (1, '长春市', 9);
    INSERT INTO `City` VALUES (1, '长沙市', 19);
    INSERT INTO `City` VALUES (4, '长治市', 6);
    INSERT INTO `City` VALUES (15, '阜康市', 31);
    INSERT INTO `City` VALUES (9, '阜新市', 8);
    INSERT INTO `City` VALUES (11, '阜阳市', 13);
    INSERT INTO `City` VALUES (6, '防城港市', 28);
    INSERT INTO `City` VALUES (15, '阳江市', 20);
    INSERT INTO `City` VALUES (3, '阳泉市', 6);
    INSERT INTO `City` VALUES (8, '阿克苏市', 31);
    INSERT INTO `City` VALUES (22, '阿勒泰市', 31);
    INSERT INTO `City` VALUES (12, '阿图什市', 31);
    INSERT INTO `City` VALUES (19, '阿坝藏族羌族自治州', 22);
    INSERT INTO `City` VALUES (12, '阿拉善盟', 32);
    INSERT INTO `City` VALUES (4, '阿拉尔市', 31);
    INSERT INTO `City` VALUES (6, '阿里地区', 29);
    INSERT INTO `City` VALUES (12, '陇南市', 21);
    INSERT INTO `City` VALUES (16, '陵水黎族自治县', 24);
    INSERT INTO `City` VALUES (12, '随州市', 18);
    INSERT INTO `City` VALUES (16, '雅安市', 22);
    INSERT INTO `City` VALUES (2, '青岛市', 16);
    INSERT INTO `City` VALUES (3, '鞍山市', 8);
    INSERT INTO `City` VALUES (5, '韶关市', 20);
    INSERT INTO `City` VALUES (1, '香港特别行政区', 34);
    INSERT INTO `City` VALUES (5, '马鞍山市', 13);
    INSERT INTO `City` VALUES (17, '驻马店市', 17);
    INSERT INTO `City` VALUES (19, '高雄县', 7);
    INSERT INTO `City` VALUES (2, '高雄市', 7);
    INSERT INTO `City` VALUES (5, '鸡 西 市', 10);
    INSERT INTO `City` VALUES (3, '鹤 岗 市', 10);
    INSERT INTO `City` VALUES (6, '鹤壁市', 17);
    INSERT INTO `City` VALUES (6, '鹰潭市', 15);
    INSERT INTO `City` VALUES (10, '黄冈市', 18);
    INSERT INTO `City` VALUES (4, '黄南藏族自治州', 26);
    INSERT INTO `City` VALUES (9, '黄山市', 13);
    INSERT INTO `City` VALUES (2, '黄石市', 18);
    INSERT INTO `City` VALUES (11, '黑 河 市', 10);
    INSERT INTO `City` VALUES (8, '黔东南苗族侗族自治州', 23);
    INSERT INTO `City` VALUES (9, '黔南布依族苗族自治州', 23);
    INSERT INTO `City` VALUES (7, '黔西南布依族苗族自治州', 23);
    INSERT INTO `City` VALUES (2, '齐齐哈尔市', 10);
    INSERT INTO `City` VALUES (8, '龙岩市', 14);
    
    SET FOREIGN_KEY_CHECKS = 1;

### 美国州的数据 ###

/*
     Date: 03/07/2019 13:19:07
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for state
    -- ----------------------------
    DROP TABLE IF EXISTS `state`;
    CREATE TABLE `state`  (
      `id` int(11) NOT NULL,
      `capitalen` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `capital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `ch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `en_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of state
    -- ----------------------------
    INSERT INTO `state` VALUES (1, 'Montgomery', '蒙哥马利', '阿拉巴马州', 'AL', 'Alabama', '');
    INSERT INTO `state` VALUES (2, 'Juneau', '朱诺', '阿拉斯加州', 'AK', 'Alaska', '');
    INSERT INTO `state` VALUES (3, 'Phoenix', '菲尼克斯', '阿利桑那州', 'AZ', 'Arizona', '');
    INSERT INTO `state` VALUES (4, 'Little rock', '小石城', '阿肯色州', 'AR', 'Arkansas', '');
    INSERT INTO `state` VALUES (5, 'Sacramento', '萨克拉门托', '加利福尼亚州', 'CA', 'California', '');
    INSERT INTO `state` VALUES (6, 'Denver', '丹佛', '科罗拉多州', 'CO', 'Colorado', '');
    INSERT INTO `state` VALUES (7, 'Hartford', '哈特福德', '康涅狄格州', 'CT', 'Connecticut', '');
    INSERT INTO `state` VALUES (8, 'Dover', '多佛', '特拉华州', 'DE', 'Delaware', '');
    INSERT INTO `state` VALUES (9, 'Tallahassee', '塔拉哈西', '佛罗里达州', 'FL', 'Florida', '');
    INSERT INTO `state` VALUES (10, 'Atlanta', '亚特兰大', '乔治亚州', 'GA', 'Georgia', '');
    INSERT INTO `state` VALUES (11, 'Honolulu', '檀香山火努鲁鲁', '夏威夷州', 'HI', 'Hawaii', '');
    INSERT INTO `state` VALUES (12, 'Boise', '博伊西', '爱达荷州', 'ID', 'Idaho', '');
    INSERT INTO `state` VALUES (13, 'Springfield', '斯普林菲尔德', '伊利诺斯州', 'IL', 'Illinois', '');
    INSERT INTO `state` VALUES (14, 'Indianapolis', '印第安纳波利斯', '印第安纳州', 'IN', 'Indiana', '');
    INSERT INTO `state` VALUES (15, 'Des Moines', '得梅因', '爱荷华州', 'IA', 'Iowa', '');
    INSERT INTO `state` VALUES (16, 'Topeka', '托皮卡', '堪萨斯州', 'KS', 'Kansas', '');
    INSERT INTO `state` VALUES (17, 'Frankfort', '法兰克福', '肯塔基州', 'KY', 'Kentucky', '');
    INSERT INTO `state` VALUES (18, 'Baton Rouge', '巴吞鲁日', '路易斯安那州', 'LA', 'Louisiana', '');
    INSERT INTO `state` VALUES (19, 'Augusta', '奥古斯塔', '缅因州', 'ME', 'Maine', '');
    INSERT INTO `state` VALUES (20, 'Annapolis', '安纳波利斯', '马里兰州', 'MD', 'Maryland', '');
    INSERT INTO `state` VALUES (21, 'Boston', '波士顿', '马萨诸塞州', 'MA', 'Massachusetts', '');
    INSERT INTO `state` VALUES (22, 'Lansing', '兰辛', '密歇根州', 'MI', 'Michigan', '');
    INSERT INTO `state` VALUES (23, 'St. Paul', '圣保罗', '明尼苏达州', 'MN', 'Minnesota', '');
    INSERT INTO `state` VALUES (24, 'Jackson', '杰克逊', '密西西比州', 'MS', 'Mississippi', '');
    INSERT INTO `state` VALUES (25, 'Jefferson City', '杰斐逊城', '密苏里州', 'MO', 'Missouri', '');
    INSERT INTO `state` VALUES (26, 'Helena', '海伦娜', '蒙大拿州', 'MT', 'Montana', '');
    INSERT INTO `state` VALUES (27, 'Lincoln', '林肯', '内布拉斯加州', 'NE', 'Nebraska', '');
    INSERT INTO `state` VALUES (28, 'Carson City', '卡森城', '内华达州', 'NV', 'Nevada', '');
    INSERT INTO `state` VALUES (29, 'Concord', '康科德', '新罕布什尔州', 'NH', 'New hampshire', '');
    INSERT INTO `state` VALUES (30, 'Trenton', '特伦顿', '新泽西州', 'NJ', 'New jersey', '');
    INSERT INTO `state` VALUES (31, 'Santa Fe', '圣菲', '新墨西哥州', 'NM', 'New mexico', '');
    INSERT INTO `state` VALUES (32, 'Albany', '奥尔巴尼', '纽约州', 'NY', 'New York', '');
    INSERT INTO `state` VALUES (33, 'Raleigh', '纳罗利', '北卡罗来纳州', 'NC', 'North Carolina', '');
    INSERT INTO `state` VALUES (34, 'Bismarck', '俾斯麦', '北达科他州', 'ND', 'North Dakota', '');
    INSERT INTO `state` VALUES (35, 'Columbus', '哥伦布', '俄亥俄州', 'OH', 'Ohio', '');
    INSERT INTO `state` VALUES (36, 'Oklahoma City', '俄克拉何马城', '俄克拉荷马州', 'OK', 'Oklahoma', '');
    INSERT INTO `state` VALUES (37, 'Salem', '塞勒姆', '俄勒冈州', 'OR', 'Oregon', '');
    INSERT INTO `state` VALUES (38, 'Harrisburg', '哈里斯堡', '宾夕法尼亚州', 'PA', 'Pennsylvania', '');
    INSERT INTO `state` VALUES (39, 'Providence', '普罗维登斯', '罗得岛州', 'RI', 'Rhode island', '');
    INSERT INTO `state` VALUES (40, 'Columbia', '哥伦比亚', '南卡罗来纳州', 'SC', 'South carolina', '');
    INSERT INTO `state` VALUES (41, 'Pierre', '皮尔', '南达科他州', 'SD', 'South dakota', '');
    INSERT INTO `state` VALUES (42, 'Nashville', '纳什维尔', '田纳西州', 'TN', 'Tennessee', '');
    INSERT INTO `state` VALUES (43, 'Austin', '奥斯汀', '得克萨斯州', 'TX', 'Texas', '');
    INSERT INTO `state` VALUES (44, 'Salt Lake City', '盐湖城', '犹他州', 'UT', 'Utah', '');
    INSERT INTO `state` VALUES (45, 'Montpelier', '蒙彼利埃', '佛蒙特州', 'VT', 'Vermont', '');
    INSERT INTO `state` VALUES (46, 'Richmond', '里士满', '弗吉尼亚州', 'VA', 'Virginia', '');
    INSERT INTO `state` VALUES (47, 'Olympia', '奥林匹亚', '华盛顿州', 'WA', 'Washington', '');
    INSERT INTO `state` VALUES (48, 'Charleston', '查尔斯顿', '西弗吉尼亚州', 'WV', 'West Virginia', '');
    INSERT INTO `state` VALUES (49, 'Madison', '麦迪逊', '威斯康辛州', 'WI', 'Wisconsin', '');
    INSERT INTO `state` VALUES (50, 'Cheyenne', '夏延', '怀俄明州', 'WY', 'Wyoming', '');
    
    SET FOREIGN_KEY_CHECKS = 1;

### 美国重要城市的数据 ###

/*
     Date: 03/07/2019 13:19:17
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for city
    -- ----------------------------
    DROP TABLE IF EXISTS `city`;
    CREATE TABLE `city`  (
      `rank_id` bigint(20) NOT NULL,
      `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `eng_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      `population` bigint(20) NULL DEFAULT NULL,
      `state_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`rank_id`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of city
    -- ----------------------------
    INSERT INTO `city` VALUES (1, '纽约市', 'New York, New York', 8250567, 'NY');
    INSERT INTO `city` VALUES (2, '洛杉矶', 'Los Angeles, California', 3849368, 'CA');
    INSERT INTO `city` VALUES (3, '芝加哥', 'Chicago, Illinois', 2873326, 'IL');
    INSERT INTO `city` VALUES (4, '休士顿', 'Houston, Texas', 2144491, 'TX');
    INSERT INTO `city` VALUES (5, '菲尼克斯', 'Phoenix, Arizona', 1512986, 'AZ');
    INSERT INTO `city` VALUES (6, '费城', 'Philadelphia, Pennsylvania', 1448396, 'PA');
    INSERT INTO `city` VALUES (7, '圣安东尼奥', 'San Antonio, Texas', 1296682, 'TX');
    INSERT INTO `city` VALUES (8, '圣迭戈', 'San Diego, California', 1256951, 'CA');
    INSERT INTO `city` VALUES (9, '达拉斯', 'Dallas, Texas', 1232940, 'TX');
    INSERT INTO `city` VALUES (10, '圣荷西', 'San Jose, California', 929936, 'CA');
    INSERT INTO `city` VALUES (11, '底特律', 'Detroit, Michigan', 918849, 'MI');
    INSERT INTO `city` VALUES (12, '杰克逊维尔', 'Jacksonville, Florida', 794555, 'FL');
    INSERT INTO `city` VALUES (13, '印第安纳波利斯', 'Indianapolis, Indiana', 785597, 'IN');
    INSERT INTO `city` VALUES (14, '旧金山', 'San Francisco, California', 744041, 'CA');
    INSERT INTO `city` VALUES (15, '哥伦布', 'Columbus, Ohio', 733203, 'OH');
    INSERT INTO `city` VALUES (16, '奥斯汀', 'Austin, Texas', 709893, 'TX');
    INSERT INTO `city` VALUES (17, '孟菲斯', 'Memphis, Tennessee', 670902, 'TN');
    INSERT INTO `city` VALUES (18, '福和市', 'Fort Worth, Texas', 653320, 'TX');
    INSERT INTO `city` VALUES (19, '巴尔的摩', 'Baltimore, Maryland', 640961, 'MD');
    INSERT INTO `city` VALUES (20, '夏洛特', 'Charlotte, North Carolina', 630478, 'NC');
    INSERT INTO `city` VALUES (21, '厄尔巴索', 'El Paso, Texas', 609415, 'TX');
    INSERT INTO `city` VALUES (22, '密尔沃基', 'Milwaukee, Wisconsin', 602782, 'WI');
    INSERT INTO `city` VALUES (23, '波士顿', 'Boston, Massachusetts', 590763, 'MA');
    INSERT INTO `city` VALUES (24, '西雅图', 'Seattle, Washington', 582454, 'WA');
    INSERT INTO `city` VALUES (25, '华盛顿', 'Washington, D. C.', 581530, 'WA');
    INSERT INTO `city` VALUES (26, '丹佛', 'Denver, Colorado', 566974, 'CO');
    INSERT INTO `city` VALUES (27, '路易维尔', 'Louisville, Kentucky', 554496, 'KY');
    INSERT INTO `city` VALUES (28, '拉斯维加斯', 'Las Vegas, Nevada', 552539, 'NV');
    INSERT INTO `city` VALUES (29, '纳什维尔', 'Nashville, Tennessee', 552120, 'TN');
    INSERT INTO `city` VALUES (30, '俄克拉荷马城', 'Oklahoma City, Oklahoma', 537734, 'OK');
    INSERT INTO `city` VALUES (31, '波特兰', 'Portland, Oregon', 537081, 'OR');
    INSERT INTO `city` VALUES (32, '图森', 'Tucson, Arizona', 518956, 'AZ');
    INSERT INTO `city` VALUES (33, '阿布奎基', 'Albuquerque, New Mexico', 504949, 'NM');
    INSERT INTO `city` VALUES (34, '亚特兰大', 'Atlanta, Georgia', 486411, 'GA');
    INSERT INTO `city` VALUES (35, '长滩', 'Long Beach, California', 472494, 'CA');
    INSERT INTO `city` VALUES (36, '弗雷斯诺', 'Fresno, California', 466714, 'CA');
    INSERT INTO `city` VALUES (37, '萨克拉门托', 'Sacramento, California', 453781, 'CA');
    INSERT INTO `city` VALUES (38, '梅萨', 'Mesa, Arizona', 447541, 'AZ');
    INSERT INTO `city` VALUES (39, '堪萨斯城', 'Kansas City, Missouri', 447306, 'MO');
    INSERT INTO `city` VALUES (40, '克里夫兰', 'Cleveland, Ohio', 444323, 'OH');
    INSERT INTO `city` VALUES (41, '弗吉尼亚比奇', 'Virginia Beach, Virginia', 435619, 'VA');
    INSERT INTO `city` VALUES (42, '奥马哈', 'Omaha, Nebraska', 419545, 'NE');
    INSERT INTO `city` VALUES (43, '迈阿密', 'Miami, Florida', 404048, 'FL');
    INSERT INTO `city` VALUES (44, '奥克兰', 'Oakland, California', 397067, 'CA');
    INSERT INTO `city` VALUES (45, '图尔萨', 'Tulsa, Oklahoma', 382872, 'OK');
    INSERT INTO `city` VALUES (46, '檀香山', 'Honolulu, Hawai\'i', 377357, 'HI');
    INSERT INTO `city` VALUES (47, '明尼亚波利斯', 'Minneapolis, Minnesota', 372833, 'MN');
    INSERT INTO `city` VALUES (48, '科罗拉多泉', 'Colorado Springs, Colorado', 372437, 'CO');
    INSERT INTO `city` VALUES (49, '阿灵顿', 'Arlington, Texas', 367197, 'TX');
    INSERT INTO `city` VALUES (50, '威奇托', 'Wichita, Kansas', 357698, 'KS');
    INSERT INTO `city` VALUES (51, '罗利', 'Raleigh, North Carolina', 356321, 'NC');
    INSERT INTO `city` VALUES (52, '圣路易斯', 'St. Louis, Missouri', 353837, 'MO');
    INSERT INTO `city` VALUES (53, '圣安娜', 'Santa Ana, California', 340024, 'CA');
    INSERT INTO `city` VALUES (54, '安那罕', 'Anaheim, California', 334425, 'CA');
    INSERT INTO `city` VALUES (55, '坦帕', 'Tampa, Florida', 332888, 'FL');
    INSERT INTO `city` VALUES (56, '辛辛那提', 'Cincinnati, Ohio', 332252, 'OH');
    INSERT INTO `city` VALUES (57, '匹兹堡', 'Pittsburgh, Pennsylvania', 312819, 'PA');
    INSERT INTO `city` VALUES (58, '贝克斯菲尔德', 'Bakersfield, California', 308392, 'CA');
    INSERT INTO `city` VALUES (59, '奥罗拉', 'Aurora, Colorado', 303582, 'CO');
    INSERT INTO `city` VALUES (60, '托莱多', 'Toledo, Ohio', 298446, 'OH');
    INSERT INTO `city` VALUES (61, '里弗塞得', 'Riverside, California', 293761, 'CA');
    INSERT INTO `city` VALUES (62, '斯托克顿', 'Stockton, California', 290141, 'CA');
    INSERT INTO `city` VALUES (63, '科珀斯克里斯蒂', 'Corpus Christi, Texas', 285267, 'TX');
    INSERT INTO `city` VALUES (64, '纽瓦克', 'Newark, New Jersey', 281402, 'NJ');
    INSERT INTO `city` VALUES (65, '安克雷奇', 'Anchorage, Alaska', 278700, 'AK');
    INSERT INTO `city` VALUES (66, '布法罗', 'Buffalo, New York', 276059, 'NY');
    INSERT INTO `city` VALUES (67, '圣保罗', 'St. Paul, Minnesota', 273535, 'MN');
    INSERT INTO `city` VALUES (68, '列克星顿', 'Lexington, Kentucky', 270789, 'KY');
    INSERT INTO `city` VALUES (69, '普拉诺', 'Plano, Texas', 255009, 'TX');
    INSERT INTO `city` VALUES (70, '韦恩堡', 'Fort Wayne, Indiana', 248637, 'IN');
    INSERT INTO `city` VALUES (71, '圣彼德斯堡', 'St. Petersburg, Florida', 248098, 'FL');
    INSERT INTO `city` VALUES (72, '格伦代尔', 'Glendale, Arizona', 246531, 'AZ');
    INSERT INTO `city` VALUES (73, '泽西城', 'Jersey City, New Jersey', 241789, 'NJ');
    INSERT INTO `city` VALUES (74, '林肯', 'Lincoln, Nebraska', 241167, 'NE');
    INSERT INTO `city` VALUES (75, '亨德森', 'Henderson, Nevada', 240614, 'NV');
    INSERT INTO `city` VALUES (76, '钱德勒', 'Chandler, Arizona', 240595, 'AZ');
    INSERT INTO `city` VALUES (77, '诺福克', 'Norfolk, Virginia', 238832, 'VA');
    INSERT INTO `city` VALUES (78, '格林斯伯勒', 'Greensboro, North Carolina', 236865, 'NC');
    INSERT INTO `city` VALUES (79, '斯科茨代尔', 'Scottsdale, Arizona', 231127, 'AZ');
    INSERT INTO `city` VALUES (80, '巴吞鲁日', 'Baton Rouge, Louisiana', 229553, 'LA');
    INSERT INTO `city` VALUES (81, '伯明翰', 'Birmingham, Alabama', 229424, 'AL');
    INSERT INTO `city` VALUES (82, '麦迪逊', 'Madison, Wisconsin', 223389, 'WI');
    INSERT INTO `city` VALUES (83, '新奥尔良', 'New Orleans, Louisiana', 223388, 'LA');
    INSERT INTO `city` VALUES (84, '切萨皮克', 'Chesapeake, Virginia', 220560, 'VA');
    INSERT INTO `city` VALUES (85, '奥兰多', 'Orlando, Florida', 220186, 'FL');
    INSERT INTO `city` VALUES (86, '加兰', 'Garland, Texas', 217963, 'TX');
    INSERT INTO `city` VALUES (87, '海厄利亚', 'Hialeah, Florida', 217141, 'FL');
    INSERT INTO `city` VALUES (88, '拉雷多', 'Laredo, Texas', 215484, 'TX');
    INSERT INTO `city` VALUES (89, '丘拉维斯塔', 'Chula Vista, California', 212756, 'CA');
    INSERT INTO `city` VALUES (90, '拉伯克', 'Lubbock, Texas', 212169, 'TX');
    INSERT INTO `city` VALUES (91, '雷诺', 'Reno, Nevada', 210255, 'NV');
    INSERT INTO `city` VALUES (92, '阿克伦', 'Akron, Ohio', 209704, 'OH');
    INSERT INTO `city` VALUES (93, '达勒姆', 'Durham, North Carolina', 209009, 'NC');
    INSERT INTO `city` VALUES (94, '罗彻斯特', 'Rochester, New York', 208123, 'NY');
    INSERT INTO `city` VALUES (95, '莫德斯托', 'Modesto, California', 205721, 'CA');
    INSERT INTO `city` VALUES (96, '蒙哥马利', 'Montgomery, Alabama', 201998, 'AL');
    INSERT INTO `city` VALUES (97, '弗里蒙特', 'Fremont, California', 201691, 'CA');
    INSERT INTO `city` VALUES (98, '什里夫波特', 'Shreveport, Louisiana', 200199, 'LA');
    INSERT INTO `city` VALUES (99, '阿灵顿', 'Arlington, Virginia', 199776, 'VA');
    INSERT INTO `city` VALUES (100, '格伦代尔', 'Glendale, California', 199463, 'CA');
    INSERT INTO `city` VALUES (101, '圣贝纳迪诺', 'San Bernardino, California', 198985, 'CA');
    INSERT INTO `city` VALUES (102, '博伊西', 'Boise, Idaho', 198638, 'ID');
    INSERT INTO `city` VALUES (103, '斯波坎', 'Spokane, Washington', 198081, 'WA');
    INSERT INTO `city` VALUES (104, '扬克斯', 'Yonkers, New York', 197852, 'NY');
    INSERT INTO `city` VALUES (105, '北拉斯维加斯', 'North Las Vegas, Nevada', 197567, 'NV');
    INSERT INTO `city` VALUES (106, '温斯顿-塞勒姆', 'Winston-Salem, North Carolina', 196990, 'NC');
    INSERT INTO `city` VALUES (107, '塔科马', 'Tacoma, Washington', 196532, 'WA');
    INSERT INTO `city` VALUES (108, '欧文', 'Irving, Texas', 196084, 'TX');
    INSERT INTO `city` VALUES (109, '亨丁顿滩', 'Huntington Beach, California', 194436, 'CA');
    INSERT INTO `city` VALUES (110, '尔湾', 'Irvine, California', 193956, 'CA');
    INSERT INTO `city` VALUES (111, '得梅因', 'Des Moines, Iowa', 193886, 'IA');
    INSERT INTO `city` VALUES (112, '大急流城', 'Great Rapids, Michigan', 193083, 'MI');
    INSERT INTO `city` VALUES (113, '里士满', 'Richmond, Virginia', 192913, 'VA');
    INSERT INTO `city` VALUES (114, '莫比尔', 'Mobile, Alabama', 192830, 'AL');
    INSERT INTO `city` VALUES (115, '吉尔伯特', 'Gilbert, Arizona', 191517, 'AZ');
    INSERT INTO `city` VALUES (116, '奥古斯塔', 'Augusta, Georgia', 189366, 'GA');
    INSERT INTO `city` VALUES (117, '哥伦布', 'Columbus, Georgia', 188660, 'GA');
    INSERT INTO `city` VALUES (118, '劳德代尔堡', 'Fort Lauderdale, Florida', 185804, 'FL');
    INSERT INTO `city` VALUES (119, '阿马里诺', 'Amarillo, Texas', 185525, 'TX');
    INSERT INTO `city` VALUES (120, '奥克斯纳德', 'Oxnard, California', 184463, 'CA');
    INSERT INTO `city` VALUES (121, '小石城', 'Little Rock, Arkansas', 184422, 'AR');
    INSERT INTO `city` VALUES (122, '莫雷诺谷', 'Moreno Valley, California', 183571, 'CA');
    INSERT INTO `city` VALUES (123, '诺克斯维尔', 'Knoxville, Tennessee', 182337, 'TN');
    INSERT INTO `city` VALUES (124, '盐湖城', 'Salt Lake City, Utah', 178858, 'UT');
    INSERT INTO `city` VALUES (125, '纽波特纽斯', 'Newport News, Virginia', 178281, 'VA');
    INSERT INTO `city` VALUES (126, '杰克逊', 'Jackson, Mississippi', 176614, 'MS');
    INSERT INTO `city` VALUES (127, '乌斯特', 'Worcester, Massachusetts', 175454, 'MA');
    INSERT INTO `city` VALUES (128, '普洛威顿斯', 'Providence, Rhode Island', 175255, 'RI');
    INSERT INTO `city` VALUES (129, '安大略', 'Ontario, California', 173351, 'CA');
    INSERT INTO `city` VALUES (130, '布朗斯维尔', 'Brownsville, Texas', 172437, 'TX');
    INSERT INTO `city` VALUES (131, '库卡蒙格牧场', 'Rancho Cucamonga, California', 170714, 'CA');
    INSERT INTO `city` VALUES (132, '奥罗拉', 'Aurora, Illinois', 170617, 'IL');
    INSERT INTO `city` VALUES (133, '方塔纳', 'Fontana, California', 170099, 'CA');
    INSERT INTO `city` VALUES (134, '坦佩', 'Tempe, Arizona', 169712, 'AZ');
    INSERT INTO `city` VALUES (135, '罗克福德', 'Rockford, Illinois', 155138, 'IL');
    INSERT INTO `city` VALUES (136, '亨茨维尔', 'Huntsville, Alabama', 168132, 'AL');
    INSERT INTO `city` VALUES (137, '费页特维', 'Fayetteville, North Carolina', 168033, 'NC');
    INSERT INTO `city` VALUES (138, '圣塔克拉利塔', 'Santa Clarita, California', 168008, 'CA');
    INSERT INTO `city` VALUES (139, '欧弗兰帕克', 'Overland Park, Kansas', 166722, 'KS');
    INSERT INTO `city` VALUES (140, '园林市', 'Garden Grove, California', 166296, 'CA');
    INSERT INTO `city` VALUES (141, '欧申赛德', 'Oceanside, California', 165803, 'CA');
    INSERT INTO `city` VALUES (142, '塔拉哈西', 'Tallahassee, Florida', 159012, 'FL');
    INSERT INTO `city` VALUES (143, '温哥华', 'Vancouver, Washington', 158855, 'WA');
    INSERT INTO `city` VALUES (144, '代顿', 'Dayton, Ohio', 156771, 'OH');
    INSERT INTO `city` VALUES (145, '查塔诺加', 'Chattanooga, Tennessee', 168293, 'TN');
    INSERT INTO `city` VALUES (146, '波莫纳', 'Pomona, California', 154271, 'CA');
    INSERT INTO `city` VALUES (147, '圣罗莎', 'Santa Rosa, California', 154212, 'CA');
    INSERT INTO `city` VALUES (148, '大草原城', 'Grand Prairie, Texas', 153812, 'TX');
    INSERT INTO `city` VALUES (149, '塞勒姆', 'Salem, Oregon', 152239, 'OR');
    INSERT INTO `city` VALUES (150, '开普科勒尔', 'Cape Coral, Florida', 151389, 'FL');
    INSERT INTO `city` VALUES (151, '斯普林菲尔德', 'Springfield, Massachusetts', 151176, 'MA');
    INSERT INTO `city` VALUES (152, '斯普林菲尔德', 'Springfield, Missouri', 150797, 'MO');
    INSERT INTO `city` VALUES (153, '科洛纳', 'Corona, California', 150253, 'CA');
    INSERT INTO `city` VALUES (154, '潘布鲁克派恩斯', 'Pembroke Pines, Florida', 150064, 'FL');
    INSERT INTO `city` VALUES (155, '帕特森', 'Paterson, New Jersey', 148708, 'NJ');
    INSERT INTO `city` VALUES (156, '尤金', 'Eugene, Oregon', 146356, 'OR');
    INSERT INTO `city` VALUES (157, '好莱坞', 'Hollywood, Florida', 145794, 'FL');
    INSERT INTO `city` VALUES (158, '萨利纳斯', 'Salinas, California', 145032, 'CA');
    INSERT INTO `city` VALUES (159, '汉普顿', 'Hampton, Virginia', 145017, 'VA');
    INSERT INTO `city` VALUES (160, '帕萨迪纳', 'Pasadena, Texas', 144793, 'TX');
    INSERT INTO `city` VALUES (161, '帕萨迪纳', 'Pasadena, California', 144133, 'CA');
    INSERT INTO `city` VALUES (162, '圣露西港', 'Port St. Lucie, Florida', 143868, 'FL');
    INSERT INTO `city` VALUES (163, '堪萨斯城', 'Kansas City, Kansas', 143801, 'KS');
    INSERT INTO `city` VALUES (164, '内珀维尔', 'Naperville, Illinois', 142901, 'IL');
    INSERT INTO `city` VALUES (165, '乔利埃特', 'Joliet, Illinois', 142702, 'IL');
    INSERT INTO `city` VALUES (166, '苏瀑', 'Sioux Falls, South Dakota', 142396, 'SD');
    INSERT INTO `city` VALUES (167, '托伦斯', 'Torrance, California', 142350, 'CA');
    INSERT INTO `city` VALUES (168, '皮奥里亚', 'Peoria, Arizona', 142024, 'AZ');
    INSERT INTO `city` VALUES (169, '兰开斯特', 'Lancaster, California', 140804, 'CA');
    INSERT INTO `city` VALUES (170, '雪城', 'Syracuse, New York', 140658, 'NY州');
    INSERT INTO `city` VALUES (171, '海沃德', 'Hayward, California', 140606, 'CA');
    INSERT INTO `city` VALUES (172, '莱克伍德', 'Lakewood, Colorado', 140024, 'CO');
    INSERT INTO `city` VALUES (173, '棕榈谷', 'Palmdale, California', 138790, 'CA');
    INSERT INTO `city` VALUES (174, '亚历山德里亚', 'Alexandria, Virginia', 138237, 'VA');
    INSERT INTO `city` VALUES (175, '布里奇波特', 'Bridgeport, Connecticut', 137912, '康涅狄格州');
    INSERT INTO `city` VALUES (176, '橙市', 'Orange, California', 135070, 'CA');
    INSERT INTO `city` VALUES (177, '沃伦', 'Warren, Michigan', 134589, 'MI');
    INSERT INTO `city` VALUES (178, '埃斯孔迪多', 'Escondido, California', 133510, 'CA');
    INSERT INTO `city` VALUES (179, '富勒顿', 'Fullerton, California', 132918, 'CA');
    INSERT INTO `city` VALUES (180, '梅斯基特', 'Mesquite, Texas', 131447, 'TX');
    INSERT INTO `city` VALUES (181, '森尼韦尔', 'Sunnyvale, California', 130519, 'CA');
    INSERT INTO `city` VALUES (182, '科勒尔斯普林斯', 'Coral Springs, Florida', 129805, 'FL');
    INSERT INTO `city` VALUES (183, '科林斯堡', 'Fort Collins, Colorado', 129467, 'CO');
    INSERT INTO `city` VALUES (184, '埃尔克格罗夫', 'Elk Grove, California', 129184, 'CA');
    INSERT INTO `city` VALUES (185, '斯特灵海茨', 'Sterling Heights, Michigan', 127991, 'MI');
    INSERT INTO `city` VALUES (186, '沙瓦纳', 'Savannah, Georgia', 127889, 'GA');
    INSERT INTO `city` VALUES (187, '麦卡伦', 'McAllen, Texas', 126411, 'TX');
    INSERT INTO `city` VALUES (188, '伊丽莎白', 'Elizabeth, New Jersey', 126179, 'NJ');
    INSERT INTO `city` VALUES (189, '哈特福德', 'Hartford, Connecticut', 124512, '康涅狄格州');
    INSERT INTO `city` VALUES (190, '锡达拉皮兹', 'Cedar Rapids, Iowa', 124417, 'IA');
    INSERT INTO `city` VALUES (191, '千橡市', 'Thousand Oaks, California', 124207, 'CA');
    INSERT INTO `city` VALUES (192, '纽黑文', 'New Haven, Connecticut', 124001, '康涅狄格州');
    INSERT INTO `city` VALUES (193, '埃尔蒙特', 'El Monte, California', 123162, 'CA');
    INSERT INTO `city` VALUES (194, '康科德', 'Concord, California', 122204, 'CA');
    INSERT INTO `city` VALUES (195, '托皮卡', 'Topeka, Kansas', 122113, 'KS');
    INSERT INTO `city` VALUES (196, '卡罗尔顿', 'Carrollton, Texas', 121604, 'TX');
    INSERT INTO `city` VALUES (197, '韦科', 'Waco, Texas', 121496, 'TX');
    INSERT INTO `city` VALUES (198, '西米谷', 'Simi Valley, California', 121288, 'CA');
    INSERT INTO `city` VALUES (199, '西瓦利城', 'West Valley, Utah', 120235, 'UT');
    INSERT INTO `city` VALUES (200, '哥伦比亚', 'Columbia, South Carolina', 119961, 'SC');
    INSERT INTO `city` VALUES (201, '斯坦福', 'Stamford, Connecticut', 119261, '康涅狄格州');
    INSERT INTO `city` VALUES (202, '贝尔维尤', 'Bellevue, Washington', 118186, 'WA');
    INSERT INTO `city` VALUES (203, '弗林特', 'Flint, Michigan', 117068, 'MI');
    INSERT INTO `city` VALUES (204, '瓦列霍', 'Vallejo, California', 116844, 'CA');
    INSERT INTO `city` VALUES (205, '斯普林菲尔德', 'Springfield, Illinois', 116482, 'IL');
    INSERT INTO `city` VALUES (206, '埃文斯维尔', 'Evansville, Indiana', 115738, 'IN');
    INSERT INTO `city` VALUES (207, '英格尔伍德', 'Inglewood, California', 114914, 'CA');
    INSERT INTO `city` VALUES (208, '阿比林', 'Abilene, Texas', 114797, 'TX');
    INSERT INTO `city` VALUES (209, '奥拉西', 'Olathe, Kansas', 114662, 'KS');
    INSERT INTO `city` VALUES (210, '兰盛', 'Lansing, Michigan', 114276, 'MI');
    INSERT INTO `city` VALUES (211, '拉法叶', 'Lafayette, Louisiana', 114214, 'LA');
    INSERT INTO `city` VALUES (212, '普若佛', 'Provo, Utah', 113984, 'UT');
    INSERT INTO `city` VALUES (213, '维塞利亚', 'Visalia, California', 113487, 'CA');
    INSERT INTO `city` VALUES (214, '安娜堡', 'Ann Arbor, Michigan', 113206, 'MI');
    INSERT INTO `city` VALUES (215, '克拉克斯维尔', 'Clarksville, Tennessee', 113175, 'TN');
    INSERT INTO `city` VALUES (216, '皮奥里亚', 'Peoria, Illinois', 113107, 'IL');
    INSERT INTO `city` VALUES (217, '卡瑞市', 'Cary, North Carolina', 112414, 'NC');
    INSERT INTO `city` VALUES (218, '雅典', 'Athens, Georgia', 111580, 'GA');
    INSERT INTO `city` VALUES (219, '博蒙特', 'Beaumont, Texas', 109856, 'TX');
    INSERT INTO `city` VALUES (220, '科斯塔梅萨', 'Costa Mesa, California', 109809, 'CA');
    INSERT INTO `city` VALUES (221, '登顿', 'Denton, Texas', 109561, 'TX');
    INSERT INTO `city` VALUES (222, '曼彻斯特', 'Manchester, New Hampshire', 109497, 'SH');
    INSERT INTO `city` VALUES (223, '独立城', 'Independence, Missouri', 109400, 'MO');
    INSERT INTO `city` VALUES (224, '唐尼', 'Downey, California', 109376, 'CA');
    INSERT INTO `city` VALUES (225, '桑顿', 'Thornton, Colorado', 109155, 'CO');
    INSERT INTO `city` VALUES (226, '盖恩斯维尔', 'Gainesville, Florida', 108655, 'FL');
    INSERT INTO `city` VALUES (227, '圣克拉拉', 'Santa Clara, California', 108518, 'CA');
    INSERT INTO `city` VALUES (228, '米拉马尔', 'Miramar, Florida', 108072, 'FL');
    INSERT INTO `city` VALUES (229, '查尔斯顿', 'Charleston, South Carolina', 107845, 'SC');
    INSERT INTO `city` VALUES (230, '西柯汶纳', 'West Covina, California', 107745, 'CA');
    INSERT INTO `city` VALUES (231, '克利尔沃特', 'Clearwater, Florida', 107742, 'FL');
    INSERT INTO `city` VALUES (232, '麦金尼', 'McKinney, Texas', 107530, 'TX');
    INSERT INTO `city` VALUES (233, '阿伦敦', 'Allentown, Pennsylvania', 107294, 'PA');
    INSERT INTO `city` VALUES (234, '沃特伯里', 'Waterbury, Connecticut', 107251, '康涅狄格州');
    INSERT INTO `city` VALUES (235, '罗斯维尔', 'Roseville, California', 107158, 'CA');
    INSERT INTO `city` VALUES (236, '西敏', 'Westminster, Colorado', 105753, 'CO');
    INSERT INTO `city` VALUES (237, '诺沃克', 'Norwalk, California', 105240, 'CA');
    INSERT INTO `city` VALUES (238, '南本德', 'South Bend, Indiana', 104905, 'IN');
    INSERT INTO `city` VALUES (239, '费尔菲尔德', 'Fairfield, California', 104897, 'CA');
    INSERT INTO `city` VALUES (240, '阿瓦达', 'Arvada, Colorado', 104830, 'CO');
    INSERT INTO `city` VALUES (241, '庞帕诺比奇', 'Pompano Beach, Florida', 104402, 'FL');
    INSERT INTO `city` VALUES (242, '伯班克', 'Burbank, California', 104317, 'CA');
    INSERT INTO `city` VALUES (243, '文图拉', 'San Buenaventura, California', 104092, 'CA');
    INSERT INTO `city` VALUES (244, '普韦布洛', 'Pueblo, Colorado', 103730, 'CO');
    INSERT INTO `city` VALUES (245, '洛厄尔', 'Lowell, Massachusetts', 103229, 'MA');
    INSERT INTO `city` VALUES (246, '诺曼', 'Norman, Oklahoma', 102827, 'OK');
    INSERT INTO `city` VALUES (247, '里士满', 'Richmond, California', 102120, 'CA');
    INSERT INTO `city` VALUES (248, '米德兰', 'Midland, Texas', 102073, 'TX');
    INSERT INTO `city` VALUES (249, '伊利', 'Erie, Pennsylvania', 102036, 'PA');
    INSERT INTO `city` VALUES (250, '基林', 'Killeen, Texas', 102003, 'TX');
    INSERT INTO `city` VALUES (251, '埃尔金', 'Elgin, Illinois', 101903, 'IL');
    INSERT INTO `city` VALUES (252, '柏克莱', 'Berkeley, California', 101555, 'CA');
    INSERT INTO `city` VALUES (253, '朴茨茅斯', 'Portsmouth, Virginia', 101377, 'VA');
    INSERT INTO `city` VALUES (254, '剑桥', 'Cambridge, Massachusetts', 101365, 'MA');
    INSERT INTO `city` VALUES (255, '戴利城', 'Daly City, California', 101005, 'CA');
    INSERT INTO `city` VALUES (256, '安条克', 'Antioch, California', 100586, 'CA');
    INSERT INTO `city` VALUES (257, '格林贝', 'Green Bay, Wisconsin', 100353, 'WI');
    INSERT INTO `city` VALUES (258, '西约旦', 'West Jordan, Utah', 100280, 'UT');
    INSERT INTO `city` VALUES (259, '比灵斯', 'Billings, Montana', 10014, 'MT');
    
    SET FOREIGN_KEY_CHECKS = 1;

## 辛苦整理的…… ##