这是一个全国酒店信息数据库，共有来自1,176个城市的225,314家酒店。每家酒店记录中有描述，地址，地区名，最低价，酒店级别，位置描述，装饰，电话等信息。该数据中有四个与酒店信息密切相关的表，分别是1,118,683个酒店客户；1,449,605个酒店评论和1,349,735个酒店房间及每个房间的标题，区域，价格，床和窗户。除此之外，数据中还包含有4,066,230个酒店图片且存储在2.24G的文件包中。整个酒店信息数据库共有12个表。
In this hotels database, there are 225,314 hotels records and 1,349,735 rooms from these hotels of 1,176 cities in China. Each hotel is comprised of description, address, area name, lowest price, hotel star, position description, score overall, comment count, sale count, latitude, longitude, mark numbers, class, opening, telephone and decoration. Each room consists of hotel, area, price from, bed and window. Besides, there are three tables mostly related with these hotels, they are 1,118,683 hotel clients with user name; 1,449,605 hotel comments with hotel, score text, score and comment in each and 54 tags of these hotels. The hotels data also comes with 4,066,230 images in 2.24G media set. The whole China hotels data set totally has 12 tables.
| Name | n3_lyz_hotel.meituan.com |
|---|---|
| Data | 2.79G (+ 103.80M) |
| Tables | 12 (+ 0) |
| Columns | 78 (+ 0) |
| Table Rows | 11,165,763 (+ 0) |
| Media | 2.24G (+ 0B) |
| Files | 26,086 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 1,176 | city |
100%
|
| rank |
100%
|
||
| first_char |
100%
|
||
| city_x_hotel | 272,116 | city_id |
100%
|
| hotel_id |
100%
|
||
| hotel | 225,314 | description |
83.23%
|
| title |
100%
|
||
| address |
99.99%
|
||
| area_name |
100%
|
||
| lowest_price |
100%
|
||
| hotel_star |
78.72%
|
||
| position_desc |
100%
|
||
| socre_overall |
100%
|
||
| comment_count |
95.62%
|
||
| sale_count |
92.62%
|
||
| lat |
100%
|
||
| lng |
100%
|
||
| mark_numbers |
100%
|
||
| class |
96.1%
|
||
| decoration |
76.85%
|
||
| opening |
80.89%
|
||
| telephone |
85.15%
|
||
| hotel_client | 1,118,683 | username |
100%
|
| hotel_comment | 1,449,605 | comment |
99.98%
|
| hotel_id |
100%
|
||
| scoretext |
100%
|
||
| score |
100%
|
||
| hotel_comment_x_hotel_client | 1,449,605 | hotel_comment_id |
100%
|
| hotel_client_id |
100%
|
||
| hotel_x_tag | 319,238 | hotel_id |
100%
|
| tag_id |
100%
|
||
| image_category | 914,007 | image_category |
100%
|
| hotel_id |
100%
|
||
| image_slug | 4,066,230 | image_category_id |
100%
|
| title |
46.66%
|
||
| room | 1,349,735 | hotel_id |
100%
|
| title |
100%
|
||
| area |
33.76%
|
||
| price_from |
100%
|
||
| bed |
95.82%
|
||
| window |
97.42%
|
||
| tag | 54 | tag |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
HOTEL_IMAGE
| Size (Bytes) | Files |
|---|---|
| 2.24G | 26,086 |
