2023全国酒店数据

数据内容字段结构

`hotel_id` int(11) NOT NULL,
`name` varchar(100) DEFAULT NULL,
`name_en` varchar(100) DEFAULT NULL,
`short_name` varchar(100) DEFAULT NULL,
`province` varchar(20) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`city` varchar(20) DEFAULT NULL,
`star` int(11) DEFAULT NULL,
`open_year` varchar(30) DEFAULT NULL,
`fitment_year` varchar(30) DEFAULT NULL,
`room_quantity` varchar(10) DEFAULT NULL,
`zone` varchar(30) DEFAULT NULL,
`area` varchar(20) DEFAULT NULL,
`address` varchar(100) DEFAULT NULL,
`phones` varchar(60) DEFAULT NULL,
`main_photo` varchar(1024) DEFAULT NULL,
`lat` varchar(20) DEFAULT NULL,
`lng` varchar(20) DEFAULT NULL,
`comment_total` varchar(20) DEFAULT NULL,
`total_score` varchar(20) DEFAULT NULL,
`health_score` varchar(20) DEFAULT NULL,
`enviromental_score` varchar(20) DEFAULT NULL,
`service_score` varchar(20) DEFAULT NULL,
`facilities_score` varchar(20) DEFAULT NULL,
`recommend_percent` varchar(20) DEFAULT NULL,
`honor_tags` text DEFAULT NULL,
`bullet_screen_info` varchar(200) DEFAULT NULL,
`has_certificate` varchar(10) DEFAULT NULL,
`hotel_facilities_full` text DEFAULT NULL,
`hotel_policy` varchar(50) DEFAULT NULL,
`updated` datetime DEFAULT NULL,
`hotel_facilities_popular` varchar(512) DEFAULT NULL,
`hotel_awards` varchar(100) DEFAULT NULL,
`images` varchar(2048) DEFAULT NULL,
`description` text DEFAULT NULL,
`traffic` varchar(2048) DEFAULT NULL,
`video_url` varchar(512) DEFAULT NULL,
`min_price` varchar(10) DEFAULT NULL,
`min_price_checkin_date` varchar(30) DEFAULT NULL,
`base_rooms` text DEFAULT NULL,
`url` varchar(1024) DEFAULT NULL,
`cer` varchar(2048) DEFAULT NULL,