Name | n3_lyz_hotels.ctrip.com_apartment |
---|---|
Data | 1.03G (+ 0B) |
Tables | 11 (+ 0) |
Columns | 60 (+ 0) |
Table Rows | 2,030,139 (+ 0) |
Media | 32.09G (+ 0B) |
Files | 1,037,346 (+ 0) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
该短租公寓数据库包括全球87个主要城市的28,440短租公寓信息。其中公寓信息包括价格、经纬度、地址、名称、客房数量、公寓设施、公寓简介、详细评分、公寓热度以及具体的客房情况等信息。
另外,本数据包含1,415,854张高清图片。
This short apartments and rooms database contains 28,440 apartments and 26,885 rooms from 87 popular cities of 5 regions around the world. There are description, name, English name, address, latitude, longitude, score, price, recommendation scale, total room, etc. in each apartment. Besides, there are 4 tables mostly related with these apartments, they are apartment policy with 111,005 records; 28,418 apartment scores with spot, facility, service and hygiene in each; 101,270 facilities and 1,415,854 images of these apartments. It contians apartment images in the 32.09G media sets.
It totally has 11 tables in the whole world short rent apartments and rooms.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
apartment | 28,440 | address |
100%
|
description |
99.9%
|
||
name |
94.09%
|
||
name_en |
94.36%
|
||
lat |
100%
|
||
lon |
100%
|
||
score |
38%
|
||
price_from |
100%
|
||
recommendation_scale |
100%
|
||
open_time |
31.27%
|
||
total_room |
99.61%
|
||
apartment_policy | 111,005 | title |
100%
|
content |
100%
|
||
apartment_id |
100%
|
||
apartment_score | 28,418 | spot |
100%
|
facility |
100%
|
||
apartment_id |
100%
|
||
service |
100%
|
||
hygiene |
100%
|
||
city | 87 | city |
100%
|
region_id |
100%
|
||
city_en |
100%
|
||
country |
89.66%
|
||
provience |
32.18%
|
||
city_x_apartment | 28,440 | apartment_id |
100%
|
city_id |
100%
|
||
facility | 101,270 | title |
100%
|
apartment_id |
100%
|
||
facility_detail | 289,735 | content |
100%
|
facility_id |
100%
|
||
image_slug | 1,415,854 | apartment_id |
100%
|
region | 5 | region |
100%
|
room | 26,885 | room_name |
100%
|
apartment_id |
100%
|
Size (Bytes) | Files |
---|---|
32.09G | 1,037,346 |
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 1.03G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2023-01-01 (+ 95 d) | 1.03G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2022-09-27 (+ 271 d) | 1.03G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2021-12-30 (+ 115 d) | 1.03G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2021-09-05 (+ 150 d) | 1.03G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2021-04-08 (+ 68 d) | 1.03G (- 0.13G) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2021-01-29 (+ 120 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2020-10-01 (+ 38 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2020-08-23 (+ 141 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2020-04-04 (+ 196 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2019-09-21 (+ 197 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2019-03-07 (+ 43 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2019-01-23 (+ 44 d) | 1.16G (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2018-12-09 (+ 29 d) | 1.16G (+ 188.03M) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2018-11-09 (+ 27 d) | 0.98G (+ 367.45M) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2018-10-13 (+ 29 d) | 636.61M (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2018-09-13 (+ 34 d) | 636.61M (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 0B) | 1,037,346 (+ 0) |
2018-08-09 (+ 27 d) | 636.61M (+ 0B) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 32.09G (+ 791.17M) | 1,037,346 (+ 25,996) |
2018-07-12 (+ 31 d) | 636.61M (+ 176.84M) | 11 (+ 0) | 60 (+ 0) | 2,030,139 (+ 0) | 31.32G (+ 26.19G) | 1,011,350 (+ 853,110) |
2018-06-10 | 459.77M | 11 | 60 | 2,030,139 | 5.13G | 158,240 |
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.