Comments (3)
summeney
commented on May 24, 2024
1
INSERT INTO city (_id, name, city_id, province_id) VALUES ('1', '市辖区', '110100000000', '110000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('2', '市辖区', '120100000000', '120000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('3', '石家庄市', '130100000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('4', '唐山市', '130200000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('5', '秦皇岛市', '130300000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('6', '邯郸市', '130400000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('7', '邢台市', '130500000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('8', '保定市', '130600000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('9', '张家口市', '130700000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('10', '承德市', '130800000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('11', '沧州市', '130900000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('12', '廊坊市', '131000000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('13', '衡水市', '131100000000', '130000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('14', '太原市', '140100000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('15', '大同市', '140200000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('16', '阳泉市', '140300000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('17', '长治市', '140400000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('18', '晋城市', '140500000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('19', '朔州市', '140600000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('20', '晋中市', '140700000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('21', '运城市', '140800000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('22', '忻州市', '140900000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('23', '临汾市', '141000000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('24', '吕梁市', '141100000000', '140000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('25', '呼和浩特市', '150100000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('26', '包头市', '150200000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('27', '乌海市', '150300000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('28', '赤峰市', '150400000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('29', '通辽市', '150500000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('30', '鄂尔多斯市', '150600000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('31', '呼伦贝尔市', '150700000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('32', '巴彦淖尔市', '150800000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('33', '乌兰察布市', '150900000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('34', '兴安盟', '152200000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('35', '锡林郭勒盟', '152500000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('36', '阿拉善盟', '152900000000', '150000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('37', '沈阳市', '210100000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('38', '大连市', '210200000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('39', '鞍山市', '210300000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('40', '抚顺市', '210400000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('41', '本溪市', '210500000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('42', '丹东市', '210600000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('43', '锦州市', '210700000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('44', '营口市', '210800000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('45', '阜新市', '210900000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('46', '辽阳市', '211000000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('47', '盘锦市', '211100000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('48', '铁岭市', '211200000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('49', '朝阳市', '211300000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('50', '葫芦岛市', '211400000000', '210000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('51', '长春市', '220100000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('52', '吉林市', '220200000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('53', '四平市', '220300000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('54', '辽源市', '220400000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('55', '通化市', '220500000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('56', '白山市', '220600000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('57', '松原市', '220700000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('58', '白城市', '220800000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('59', '延边朝鲜族自治州', '222400000000', '220000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('60', '哈尔滨市', '230100000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('61', '齐齐哈尔市', '230200000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('62', '鸡西市', '230300000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('63', '鹤岗市', '230400000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('64', '双鸭山市', '230500000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('65', '大庆市', '230600000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('66', '伊春市', '230700000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('67', '佳木斯市', '230800000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('68', '七台河市', '230900000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('69', '牡丹江市', '231000000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('70', '黑河市', '231100000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('71', '绥化市', '231200000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('72', '大兴安岭地区', '232700000000', '230000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('73', '市辖区', '310100000000', '310000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('74', '南京市', '320100000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('75', '无锡市', '320200000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('76', '徐州市', '320300000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('77', '常州市', '320400000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('78', '苏州市', '320500000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('79', '南通市', '320600000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('80', '连云港市', '320700000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('81', '淮安市', '320800000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('82', '盐城市', '320900000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('83', '扬州市', '321000000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('84', '镇江市', '321100000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('85', '泰州市', '321200000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('86', '宿迁市', '321300000000', '320000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('87', '杭州市', '330100000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('88', '宁波市', '330200000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('89', '温州市', '330300000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('90', '嘉兴市', '330400000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('91', '湖州市', '330500000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('92', '绍兴市', '330600000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('93', '金华市', '330700000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('94', '衢州市', '330800000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('95', '舟山市', '330900000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('96', '台州市', '331000000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('97', '丽水市', '331100000000', '330000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('98', '合肥市', '340100000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('99', '芜湖市', '340200000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('100', '蚌埠市', '340300000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('101', '淮南市', '340400000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('102', '马鞍山市', '340500000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('103', '淮北市', '340600000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('104', '铜陵市', '340700000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('105', '安庆市', '340800000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('106', '黄山市', '341000000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('107', '滁州市', '341100000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('108', '阜阳市', '341200000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('109', '宿州市', '341300000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('110', '六安市', '341500000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('111', '亳州市', '341600000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('112', '池州市', '341700000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('113', '宣城市', '341800000000', '340000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('114', '福州市', '350100000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('115', '厦门市', '350200000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('116', '莆田市', '350300000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('117', '三明市', '350400000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('118', '泉州市', '350500000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('119', '漳州市', '350600000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('120', '南平市', '350700000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('121', '龙岩市', '350800000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('122', '宁德市', '350900000000', '350000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('123', '南昌市', '360100000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('124', '景德镇市', '360200000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('125', '萍乡市', '360300000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('126', '九江市', '360400000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('127', '新余市', '360500000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('128', '鹰潭市', '360600000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('129', '赣州市', '360700000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('130', '吉安市', '360800000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('131', '宜春市', '360900000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('132', '抚州市', '361000000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('133', '上饶市', '361100000000', '360000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('134', '济南市', '370100000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('135', '青岛市', '370200000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('136', '淄博市', '370300000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('137', '枣庄市', '370400000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('138', '东营市', '370500000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('139', '烟台市', '370600000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('140', '潍坊市', '370700000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('141', '济宁市', '370800000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('142', '泰安市', '370900000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('143', '威海市', '371000000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('144', '日照市', '371100000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('145', '临沂市', '371300000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('146', '德州市', '371400000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('147', '聊城市', '371500000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('148', '滨州市', '371600000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('149', '菏泽市', '371700000000', '370000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('150', '郑州市', '410100000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('151', '开封市', '410200000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('152', '洛阳市', '410300000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('153', '平顶山市', '410400000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('154', '安阳市', '410500000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('155', '鹤壁市', '410600000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('156', '新乡市', '410700000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('157', '焦作市', '410800000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('158', '濮阳市', '410900000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('159', '许昌市', '411000000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('160', '漯河市', '411100000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('161', '三门峡市', '411200000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('162', '南阳市', '411300000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('163', '商丘市', '411400000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('164', '信阳市', '411500000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('165', '周口市', '411600000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('166', '驻马店市', '411700000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('167', '省直辖县级行政区划', '419000000000', '410000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('168', '武汉市', '420100000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('169', '黄石市', '420200000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('170', '十堰市', '420300000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('171', '宜昌市', '420500000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('172', '襄阳市', '420600000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('173', '鄂州市', '420700000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('174', '荆门市', '420800000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('175', '孝感市', '420900000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('176', '荆州市', '421000000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('177', '黄冈市', '421100000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('178', '咸宁市', '421200000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('179', '随州市', '421300000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('180', '恩施土家族苗族自治州', '422800000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('181', '省直辖县级行政区划', '429000000000', '420000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('182', '长沙市', '430100000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('183', '株洲市', '430200000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('184', '湘潭市', '430300000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('185', '衡阳市', '430400000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('186', '邵阳市', '430500000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('187', '岳阳市', '430600000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('188', '常德市', '430700000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('189', '张家界市', '430800000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('190', '益阳市', '430900000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('191', '郴州市', '431000000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('192', '永州市', '431100000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('193', '怀化市', '431200000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('194', '娄底市', '431300000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('195', '湘西土家族苗族自治州', '433100000000', '430000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('196', '广州市', '440100000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('197', '韶关市', '440200000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('198', '深圳市', '440300000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('199', '珠海市', '440400000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('200', '汕头市', '440500000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('201', '佛山市', '440600000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('202', '江门市', '440700000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('203', '湛江市', '440800000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('204', '茂名市', '440900000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('205', '肇庆市', '441200000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('206', '惠州市', '441300000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('207', '梅州市', '441400000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('208', '汕尾市', '441500000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('209', '河源市', '441600000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('210', '阳江市', '441700000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('211', '清远市', '441800000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('212', '东莞市', '441900000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('213', '中山市', '442000000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('214', '潮州市', '445100000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('215', '揭阳市', '445200000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('216', '云浮市', '445300000000', '440000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('217', '南宁市', '450100000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('218', '柳州市', '450200000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('219', '桂林市', '450300000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('220', '梧州市', '450400000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('221', '北海市', '450500000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('222', '防城港市', '450600000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('223', '钦州市', '450700000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('224', '贵港市', '450800000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('225', '玉林市', '450900000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('226', '百色市', '451000000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('227', '贺州市', '451100000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('228', '河池市', '451200000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('229', '来宾市', '451300000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('230', '崇左市', '451400000000', '450000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('231', '海口市', '460100000000', '460000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('232', '三亚市', '460200000000', '460000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('233', '三沙市', '460300000000', '460000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('234', '儋州市', '460400000000', '460000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('235', '省直辖县级行政区划', '469000000000', '460000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('236', '市辖区', '500100000000', '500000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('237', '县', '500200000000', '500000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('238', '成都市', '510100000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('239', '自贡市', '510300000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('240', '攀枝花市', '510400000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('241', '泸州市', '510500000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('242', '德阳市', '510600000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('243', '绵阳市', '510700000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('244', '广元市', '510800000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('245', '遂宁市', '510900000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('246', '内江市', '511000000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('247', '乐山市', '511100000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('248', '南充市', '511300000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('249', '眉山市', '511400000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('250', '宜宾市', '511500000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('251', '广安市', '511600000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('252', '达州市', '511700000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('253', '雅安市', '511800000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('254', '巴中市', '511900000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('255', '资阳市', '512000000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('256', '阿坝藏族羌族自治州', '513200000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('257', '甘孜藏族自治州', '513300000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('258', '凉山彝族自治州', '513400000000', '510000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('259', '贵阳市', '520100000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('260', '六盘水市', '520200000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('261', '遵义市', '520300000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('262', '安顺市', '520400000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('263', '毕节市', '520500000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('264', '铜仁市', '520600000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('265', '黔西南布依族苗族自治州', '522300000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('266', '黔东南苗族侗族自治州', '522600000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('267', '黔南布依族苗族自治州', '522700000000', '520000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('268', '昆明市', '530100000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('269', '曲靖市', '530300000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('270', '玉溪市', '530400000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('271', '保山市', '530500000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('272', '昭通市', '530600000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('273', '丽江市', '530700000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('274', '普洱市', '530800000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('275', '临沧市', '530900000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('276', '楚雄彝族自治州', '532300000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('277', '红河哈尼族彝族自治州', '532500000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('278', '文山壮族苗族自治州', '532600000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('279', '西双版纳傣族自治州', '532800000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('280', '大理白族自治州', '532900000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('281', '德宏傣族景颇族自治州', '533100000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('282', '怒江傈僳族自治州', '533300000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('283', '迪庆藏族自治州', '533400000000', '530000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('284', '拉萨市', '540100000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('285', '日喀则市', '540200000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('286', '昌都市', '540300000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('287', '林芝市', '540400000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('288', '山南市', '540500000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('289', '那曲市', '540600000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('290', '阿里地区', '542500000000', '540000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('291', '西安市', '610100000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('292', '铜川市', '610200000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('293', '宝鸡市', '610300000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('294', '咸阳市', '610400000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('295', '渭南市', '610500000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('296', '延安市', '610600000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('297', '汉中市', '610700000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('298', '榆林市', '610800000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('299', '安康市', '610900000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('300', '商洛市', '611000000000', '610000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('301', '兰州市', '620100000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('302', '嘉峪关市', '620200000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('303', '金昌市', '620300000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('304', '白银市', '620400000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('305', '天水市', '620500000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('306', '武威市', '620600000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('307', '张掖市', '620700000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('308', '平凉市', '620800000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('309', '酒泉市', '620900000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('310', '庆阳市', '621000000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('311', '定西市', '621100000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('312', '陇南市', '621200000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('313', '临夏回族自治州', '622900000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('314', '甘南藏族自治州', '623000000000', '620000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('315', '西宁市', '630100000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('316', '海东市', '630200000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('317', '海北藏族自治州', '632200000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('318', '黄南藏族自治州', '632300000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('319', '海南藏族自治州', '632500000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('320', '果洛藏族自治州', '632600000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('321', '玉树藏族自治州', '632700000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('322', '海西蒙古族藏族自治州', '632800000000', '630000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('323', '银川市', '640100000000', '640000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('324', '石嘴山市', '640200000000', '640000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('325', '吴忠市', '640300000000', '640000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('326', '固原市', '640400000000', '640000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('327', '中卫市', '640500000000', '640000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('328', '乌鲁木齐市', '650100000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('329', '克拉玛依市', '650200000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('330', '吐鲁番市', '650400000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('331', '哈密市', '650500000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('332', '昌吉回族自治州', '652300000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('333', '博尔塔拉蒙古自治州', '652700000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('334', '巴音郭楞蒙古自治州', '652800000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('335', '阿克苏地区', '652900000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('336', '克孜勒苏柯尔克孜自治州', '653000000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('337', '喀什地区', '653100000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('338', '和田地区', '653200000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('339', '伊犁哈萨克自治州', '654000000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('340', '塔城地区', '654200000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('341', '阿勒泰地区', '654300000000', '650000000000');
INSERT INTO city (_id, name, city_id, province_id) VALUES ('342', '自治区直辖县级行政区划', '659000000000', '650000000000');
from china_regions.
summeney
commented on May 24, 2024
1
INSERT INTO province (_id, name, province_id) VALUES ('2', '天津市', '120000000000');
INSERT INTO province (_id, name, province_id) VALUES ('3', '河北省', '130000000000');
INSERT INTO province (_id, name, province_id) VALUES ('4', '山西省', '140000000000');
INSERT INTO province (_id, name, province_id) VALUES ('5', '内蒙古自治区', '150000000000');
INSERT INTO province (_id, name, province_id) VALUES ('6', '辽宁省', '210000000000');
INSERT INTO province (_id, name, province_id) VALUES ('7', '吉林省', '220000000000');
INSERT INTO province (_id, name, province_id) VALUES ('8', '黑龙江省', '230000000000');
INSERT INTO province (_id, name, province_id) VALUES ('9', '上海市', '310000000000');
INSERT INTO province (_id, name, province_id) VALUES ('10', '江苏省', '320000000000');
INSERT INTO province (_id, name, province_id) VALUES ('11', '浙江省', '330000000000');
INSERT INTO province (_id, name, province_id) VALUES ('12', '安徽省', '340000000000');
INSERT INTO province (_id, name, province_id) VALUES ('13', '福建省', '350000000000');
INSERT INTO province (_id, name, province_id) VALUES ('14', '江西省', '360000000000');
INSERT INTO province (_id, name, province_id) VALUES ('15', '山东省', '370000000000');
INSERT INTO province (_id, name, province_id) VALUES ('16', '河南省', '410000000000');
INSERT INTO province (_id, name, province_id) VALUES ('17', '湖北省', '420000000000');
INSERT INTO province (_id, name, province_id) VALUES ('18', '湖南省', '430000000000');
INSERT INTO province (_id, name, province_id) VALUES ('19', '广东省', '440000000000');
INSERT INTO province (_id, name, province_id) VALUES ('20', '广西壮族自治区', '450000000000');
INSERT INTO province (_id, name, province_id) VALUES ('21', '海南省', '460000000000');
INSERT INTO province (_id, name, province_id) VALUES ('22', '重庆市', '500000000000');
INSERT INTO province (_id, name, province_id) VALUES ('23', '四川省', '510000000000');
INSERT INTO province (_id, name, province_id) VALUES ('24', '贵州省', '520000000000');
INSERT INTO province (_id, name, province_id) VALUES ('25', '云南省', '530000000000');
INSERT INTO province (_id, name, province_id) VALUES ('26', '西藏自治区', '540000000000');
INSERT INTO province (_id, name, province_id) VALUES ('27', '陕西省', '610000000000');
INSERT INTO province (_id, name, province_id) VALUES ('28', '甘肃省', '620000000000');
INSERT INTO province (_id, name, province_id) VALUES ('29', '青海省', '630000000000');
INSERT INTO province (_id, name, province_id) VALUES ('30', '宁夏回族自治区', '640000000000');
INSERT INTO province (_id, name, province_id) VALUES ('31', '**维吾尔自治区', '650000000000');
from china_regions.
allforlove1997
commented on May 24, 2024
可以用notepad++的文本替换功能，将（示例） '_id', 'name', 'county_id', 'city_id' 批量替换为 _id, name, county_id, city_id 这种的带有反引号的类型就行了，其他表同理，反引号是`
from china_regions.
Related Issues (20)
- data has update
- 这个项目用不了了么
- **，香港，澳门都没有 ？？？？ HOT 4
- 2019年底最新的已经发布了
- 按照操作步骤出现异常 HOT 1
- 省市区全部整合到一张就好了。这样太麻烦。。。 HOT 3
- 2020-11-23的数据更新 共享
- sql文件中天津市数据重复 HOT 1
- 请问有英文版的吗 HOT 1
- 建议sql以这种格式插入
- 没有东莞和中山市一级以下的数据
- js数据不全 HOT 1
- 没有**省 HOT 1
- 为什么中山市，东莞市，儋州市都没有地区信息 HOT 1
- 数据未更新，这个项目还在维护么
- 市辖区在第三级是不是多余的？ HOT 1
- 这个库已经不更新了吗？杭州市2021年底撤换了两个市，并没有更新数据 HOT 1
- 有没有含港澳台的版本
- 统计局数据地址更新了 现在是 http://www.stats.gov.cn/sj/tjbz/qhdm/
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from china_regions.