中国五级行政区划地址表-行政区域地址表-截至2024年5月-SQL文件-开封即用

INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (1, '11', '1101', '110101', '110101001', '110101001001', '多福巷社区居委会', 1, '2023-09-21 02:32:56', '2023-09-21 02:32:56'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (2, '11', '1101', '110101', '110101001', '110101001002', '银闸社区居委会', 1, '2023-09-21 02:32:56', '2023-09-21 02:32:56'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (3, '11', '1101', '110101', '110101001', '110101001005', '东厂社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (4, '11', '1101', '110101', '110101001', '110101001006', '智德社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (5, '11', '1101', '110101', '110101001', '110101001007', '南池子社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (6, '11', '1101', '110101', '110101001', '110101001009', '灯市口社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (7, '11', '1101', '110101', '110101001', '110101001010', '正义路社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (8, '11', '1101', '110101', '110101001', '110101001013', '台基厂社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (9, '11', '1101', '110101', '110101001', '110101001014', '韶九社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (10, '11', '1101', '110101', '110101001', '110101001015', '王府井社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (11, '11', '1101', '110101', '110101002', '110101002001', '隆福寺社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (12, '11', '1101', '110101', '110101002', '110101002002', '吉祥社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (13, '11', '1101', '110101', '110101002', '110101002003', '黄化门社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (14, '11', '1101', '110101', '110101002', '110101002004', '钟鼓社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (15, '11', '1101', '110101', '110101002', '110101002005', '魏家社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (16, '11', '1101', '110101', '110101002', '110101002006', '汪芝麻社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (17, '11', '1101', '110101', '110101002', '110101002008', '景山东街社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (18, '11', '1101', '110101', '110101002', '110101002009', '皇城根北街社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (19, '11', '1101', '110101', '110101003', '110101003001', '交东社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (20, '11', '1101', '110101', '110101003', '110101003002', '福祥社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (21, '11', '1101', '110101', '110101003', '110101003003', '大兴社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (22, '11', '1101', '110101', '110101003', '110101003005', '府学社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (23, '11', '1101', '110101', '110101003', '110101003007', '鼓楼苑社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (24, '11', '1101', '110101', '110101003', '110101003008', '菊儿社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `update_at`) VALUES (25, '11', '1101', '110101', '110101003', '110101003009', '南锣鼓巷社区居委会', 1, '2023-09-21 03:00:23', '2023-09-21 03:00:23'); INSERT INTO `yn_s_address_villages` (`id`, `province_code`, `city_code`, `area_code`, `street_code`, `villages_code`, `villages_name`, `status`, `create_at`, `