这是一个国际短租房信息数据库，有来自524个城市的35,531个房东的148,415家短租房。每个短租房记录中包含有描述，经度，纬度，房间，床，容量，产品价格，原价，最终价格，房间类型，房间风格，总结，地址等。在该数据中还有其它8个与短租房信息密切相关的表，它们分别是公寓的10个浴室；9个周边环境记录；17个房间设施；10个房间特征；10个厨房；4个房间政策；7个房间规则以及2个房间服务。除此之外，数据中还包含有1,132,714张图片且存储在4.15G媒体文件夹中。整个国际短租房信息数据库共有28个表。
This is an international apartments for short rent database having 148,415 records with description, longitude, latitude, room, bed, capacity, product price, original price, final price, house style, house type, area, summary, address and etc. in each. These apartments are from 35,531 owners and has 10 bathrooms; house around with 9 records; 17 house facilities; 10 house features; 10 house kitchens; 4 house policy records; 7 house rules and 2 house services. It also comes with 1,132,714 images of these apartments in the 4.15G media set. The whole international short rent apartments data set totally has 28 tables.
| Name | n3_lyz_tujia_international |
|---|---|
| Data | 943.09M (+ 769.23M) |
| Tables | 28 (+ 0) |
| Columns | 117 (+ 0) |
| Table Rows | 3,685,024 (+ 0) |
| Media | 4.15G (+ 0B) |
| Files | 72,823 (+ 0) |
Data Samples
Database APIs
Media Files
- hourse_image Bytes: 4.15G / Files: 72,823
- photo_image Bytes: 0P / Files: 0
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bathroom | 10 | title |
100%
|
| city | 524 | title |
100%
|
| city_x_hourse | 148,415 | city_id |
100%
|
| hourse_id |
100%
|
||
| hourse | 148,415 | description |
46.15%
|
| title |
100%
|
||
| longitude |
100%
|
||
| latitude |
100%
|
||
| room |
99.97%
|
||
| bed |
100%
|
||
| capacity |
100%
|
||
| product_price |
94.01%
|
||
| original_price |
94.01%
|
||
| final_price |
94.01%
|
||
| house_type |
59.02%
|
||
| house_style |
100%
|
||
| area |
100%
|
||
| summary |
100%
|
||
| comment_count |
100%
|
||
| overall_score |
100%
|
||
| address |
47.2%
|
||
| hourse_around | 9 | title |
100%
|
| hourse_facility | 17 | title |
100%
|
| hourse_facility_detail | 0 | content |
0%
|
| hourse_facility_id |
0%
|
||
| hourse_feature | 10 | title |
100%
|
| hourse_fee | 74,711 | title |
100%
|
| value |
88.7%
|
||
| hourse_id |
100%
|
||
| hourse_kitchen | 10 | title |
100%
|
| hourse_policy | 4 | title |
100%
|
| value |
100%
|
||
| hourse_rule | 7 | title |
100%
|
| hourse_service | 2 | title |
100%
|
| hourse_x_bathroom | 439,075 | hourse_id |
100%
|
| bathroom_id |
100%
|
||
| hourse_x_hourse_around | 93,229 | hourse_id |
100%
|
| hourse_around_id |
100%
|
||
| hourse_x_hourse_facility | 398,944 | hourse_id |
100%
|
| hourse_facility_id |
100%
|
||
| hourse_x_hourse_feature | 92,811 | hourse_id |
100%
|
| hourse_feature_id |
100%
|
||
| hourse_x_hourse_kitchen | 55,486 | hourse_id |
100%
|
| hourse_kitchen_id |
100%
|
||
| hourse_x_hourse_policy | 279,856 | hourse_id |
100%
|
| hourse_policy_id |
100%
|
||
| hourse_x_hourse_rule | 295,237 | hourse_id |
100%
|
| hourse_rule_id |
100%
|
||
| hourse_x_hourse_service | 41,248 | hourse_id |
100%
|
| hourse_service_id |
100%
|
||
| hourse_x_mark | 378,521 | hourse_id |
100%
|
| mark_id |
100%
|
||
| hourse_x_owner | 69,962 | hourse_id |
100%
|
| owner_id |
100%
|
||
| image_slug | 1,132,714 | hourse_id |
100%
|
| mark | 276 | mark |
100%
|
| owner | 35,531 | title |
100%
|
| type |
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
HOURSE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 4.15G | 72,823 |
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 0P | 0 |
