Name | n3_lyz_hotels.ctrip.com |
---|---|
Data | 3.44G (+ 0B) |
Tables | 17 (+ 0) |
Columns | 99 (+ 0) |
Table Rows | 16,874,864 (+ 0) |
Media | 45.07G (+ 0B) |
Files | 1,312,894 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
该酒店数据库包含中国国内366个城市的263,817家酒店信息以及其中819,705条客房信息,数据包含酒店的名称、等级、地址、电话、传真、详细评分、价格、经纬度、热度、酒店简介、酒店设施、客房设施、周边情况等信息。
另外,本数据包含1264099张高清图片。
This is a hotels database having 263,817 hotels and 819,705 rooms from 366 cities of China. Each hotel has address, description, class, price from, name, latitude, longitude, short name, score, recommendation_scale, comment count, style, open time, total room, telephone, fax number, etc and there are area, floor, bed, cigarette, facility, bathroom, etc. in each of room. In the whole hotels & rooms database, it also contains 60,800 hotel around informations, hotel_policy with 1,017,434 records, 355,576 hotel score records, price detail with 1,244,988 records, and etc. It has 2,279,369 images and these images are stored in the 45.07G medai sets.
The whole China hotels and rooms database totally has 17 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
around_detail | 218,708 | content |
100%
|
hotel_around_id |
100%
|
||
city | 366 | city |
100%
|
group |
100%
|
||
city_x_hotel | 264,049 | city_id |
100%
|
hotel_id |
100%
|
||
facility | 969,007 | title |
100%
|
hotel_id |
100%
|
||
facility_detail | 2,498,519 | content |
100%
|
facility_id |
100%
|
||
hotel | 263,817 | address |
99.97%
|
description |
99.99%
|
||
class |
34.67%
|
||
price_from |
100%
|
||
name |
99.97%
|
||
lat |
99.97%
|
||
lon |
99.97%
|
||
shortname |
70.25%
|
||
score |
99.97%
|
||
recommendation_scale |
99.97%
|
||
comment_count |
99.97%
|
||
style |
99.97%
|
||
open_time |
71.43%
|
||
renovation |
21.11%
|
||
total_room |
88.64%
|
||
telephone |
99.92%
|
||
fax |
22.76%
|
||
hotel_around | 60,800 | title |
100%
|
hotel_id |
100%
|
||
hotel_detail | 5,262,914 | content |
100%
|
hotel_overview_id |
100%
|
||
hotel_overview | 1,319,010 | title |
100%
|
hotel_id |
100%
|
||
hotel_policy | 1,017,434 | title |
100%
|
content |
91.2%
|
||
hotel_id |
100%
|
||
hotel_score | 355,576 | spot |
100%
|
facility |
100%
|
||
hotel_id |
100%
|
||
service |
100%
|
||
hygiene |
100%
|
||
hotel_x_mark | 300,502 | hotel_id |
100%
|
mark_id |
100%
|
||
image_slug | 2,279,369 | hotel_id |
100%
|
mark | 100 | mark |
100%
|
price_detail | 1,244,988 | price_type |
32.26%
|
sale_type |
10.44%
|
||
price |
57.4%
|
||
room_id |
100%
|
||
agentname |
19.6%
|
||
break_frist |
100%
|
||
degree_of_satisfaction |
100%
|
||
room | 819,705 | room_title |
100%
|
area |
0%
|
||
floor |
0%
|
||
hotel_id |
100%
|
||
bed |
0%
|
||
add_bed |
0%
|
||
cigarette |
0.02%
|
||
facility |
90.39%
|
||
bathroom |
79.7%
|
Size (Bytes) | Files |
---|---|
45.07G | 1,312,894 |
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2023-01-01 (+ 95 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2022-09-27 (+ 271 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2021-12-30 (+ 115 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2021-09-05 (+ 150 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2021-04-08 (+ 68 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2021-01-29 (+ 120 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2020-10-01 (+ 38 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2020-08-23 (+ 141 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2020-04-04 (+ 196 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2019-09-21 (+ 197 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2019-03-07 (+ 43 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2019-01-23 (+ 44 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2018-12-09 (+ 29 d) | 3.44G (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2018-11-09 (+ 27 d) | 3.44G (+ 2.53G) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2018-10-13 (+ 29 d) | 930.48M (+ 0B) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 0) | 45.07G (+ 0B) | 1,312,894 (+ 0) |
2018-09-13 (+ 34 d) | 930.48M (+ 91.33M) | 17 (+ 0) | 99 (+ 0) | 16,874,864 (+ 1,567,735) | 45.07G (+ 39.46G) | 1,312,894 (+ 1,153,447) |
2018-08-09 (+ 27 d) | 839.16M (+ 76.72M) | 17 (+ 1) | 99 (+ 8) | 15,307,129 (+ 2,176,932) | 5.61G (+ 5.61G) | 159,447 (+ 159,447) |
2018-07-12 (+ 31 d) | 762.44M (+ 165.84M) | 16 (+ 0) | 91 (+ 0) | 13,130,197 (+ 7,268,282) | 0B (+ 0B) | 0 (+ 0) |
2018-06-10 | 596.59M | 16 | 91 | 5,861,915 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.