该短租公寓数据库包含中国国内376个城市的272,300家短租公寓信息，包括名称、地址、经纬度、价格及收费标准、房屋简介、房间设施情况、周围环境、热度、房屋特色以及详细的客户打分情况。除此之外，数据中还有关于短租房周边环境信息，额外收费，房间特点，设施等信息且包含有2,540,860张短租房图片。该短租房信息数据库共有14个表。
In the houses for short rent database, there are 272,300 records of 376 cities in China. Each house has name, description, original price, final price, capacity, room, bed, capacity information, unit level, comment count, district, house type, latitude, longitude, area, etc. This short rental houses database also contains the details of house around, house extra fee, house facility, house feature, house policy, house price, etc. for someone who easily get the appropriate house. It also comes with 2,540,860 images of these houses and they are stored in the 143.83G photo images media set.
The whole China short rent houses database consists of 14 tables.
| Name | n3_lyz_tujia.com |
|---|---|
| Data | 3.39G (- 0.30G) |
| Tables | 14 (+ 0) |
| Columns | 87 (+ 0) |
| Table Rows | 12,182,716 (+ 0) |
| Media | 143.83G (+ 0B) |
| Files | 2,188,697 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 376 | city |
100%
|
| city_x_house | 274,403 | house_id |
100%
|
| city_id |
100%
|
||
| house | 272,300 | name |
100%
|
| description |
57.09%
|
||
| original_price |
96.78%
|
||
| final_price |
96.78%
|
||
| product_price |
0%
|
||
| price_tip |
5.73%
|
||
| capacity |
100%
|
||
| room |
84.08%
|
||
| bed |
99.89%
|
||
| capacity_info |
99.91%
|
||
| unitlevel |
100%
|
||
| score |
43.12%
|
||
| comment_count |
100%
|
||
| room_infor |
84.08%
|
||
| district |
95.48%
|
||
| house_type |
99.17%
|
||
| latitude |
100%
|
||
| longitude |
100%
|
||
| area |
100%
|
||
| location |
72%
|
||
| distance_location |
68.54%
|
||
| address |
57.09%
|
||
| recommen_count |
41.56%
|
||
| overall_score |
41.56%
|
||
| hygiene_score |
41.56%
|
||
| decoration_score |
41.56%
|
||
| traffic_score |
41.56%
|
||
| house_around | 590,315 | title |
87.48%
|
| description |
99.87%
|
||
| house_id |
100%
|
||
| house_extra_fee | 253,415 | title |
100%
|
| house_id |
100%
|
||
| house_extra_fee_content | 292,133 | content |
100%
|
| house_extra_fee_id |
100%
|
||
| mark |
0%
|
||
| house_facility | 858,014 | title |
100%
|
| house_id |
100%
|
||
| house_facility_detail | 4,285,515 | content |
100%
|
| house_facility_id |
100%
|
||
| house_feature | 838,743 | title |
100%
|
| house_id |
100%
|
||
| value |
34.26%
|
||
| house_policy | 775,963 | title |
100%
|
| house_id |
100%
|
||
| house_policy_detail | 886,974 | content |
87.3%
|
| house_policy_id |
100%
|
||
| mark |
41.52%
|
||
| house_price_detail | 313,705 | product_name |
100%
|
| house_id |
100%
|
||
| final_price |
97.26%
|
||
| image_slug | 2,540,860 | house_id |
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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 143.83G | 2,188,697 |
