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,