这是一个中国短租房信息数据库，共包含有来自全国275个城市的77,027个短租房。每个短租房中有描述，价格，地区，位置，等级，评论数，收藏数，容量，房间等。这些短租房共来自29,299位主人，共有客户152,493位。在该短租房数据库中，还包含有这些短租房的10个电器；9个浴室；79张床；170,637个评论；15个房间设施；9个厨房；353,065房间规则和6个房间服务。除此之外，短租房数据中还有1,081,175张短租房图片且存储在4.91G的媒体文件夹中。整个中国短租房信息数据库共有25个表。
This is a short rent apartments database having 77,027 records from 275 cities in China. Each record is comprised of description, price, location, class, comment number, collection number, capacity, room and etc. These short rent apartments belong to 29,299 owners and there are 152,493 clients. In this apartments for short rent data, there are other 8 tables mostly related with these apartments, they are 10 hourse appliances; 9 hourse bathroom records; 79 hourse beds; hourse comment with 170,637 records; 15 hourse facilities; hourse kitchens with 9 records; 353,065 hourse rules and hourse service with 6 records. Besides, The short rent houses data also has 1,081,175 hourse images in the 4.91G media set. The whole China short rent apartments data set totally has 25 tables.
| Name | n3_lyz_phoenix.meituan.com |
|---|---|
| Data | 928.17M (+ 367.75M) |
| Tables | 25 (+ 0) |
| Columns | 123 (+ 0) |
| Table Rows | 4,048,147 (+ 0) |
| Media | 4.91G (+ 0B) |
| Files | 9,410 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 275 | city |
100%
|
| city_x_hourse | 77,027 | city_id |
100%
|
| hourse_id |
100%
|
||
| client | 152,493 | nick_name |
100%
|
| hourse | 77,027 | hourse_description |
53.93%
|
| price |
100%
|
||
| title |
99.9%
|
||
| district |
100%
|
||
| location |
100%
|
||
| rating |
45.48%
|
||
| class |
43.71%
|
||
| comment_count |
46.6%
|
||
| collection_count |
100%
|
||
| consume_count |
100%
|
||
| house_desc |
16.34%
|
||
| capacity |
100%
|
||
| room |
99.15%
|
||
| layout |
100%
|
||
| area |
91.4%
|
||
| score_overall |
42.7%
|
||
| information_correct |
42.7%
|
||
| communication |
42.7%
|
||
| clean |
42.7%
|
||
| cost_performance |
42.7%
|
||
| around_description |
50.48%
|
||
| bright_spot |
91.65%
|
||
| hourse_appliance | 10 | title |
100%
|
| hourse_bathroom | 9 | title |
100%
|
| hourse_bed | 79 | title |
100%
|
| hourse_comment | 170,637 | comment |
99.64%
|
| hourse_id |
100%
|
||
| mark |
100%
|
||
| total_socre |
100%
|
||
| hourse_comment_x_client | 170,634 | hourse_comment_id |
100%
|
| client_id |
100%
|
||
| hourse_facility | 15 | title |
100%
|
| hourse_kitchen | 9 | title |
100%
|
| hourse_rule | 353,065 | title |
100%
|
| content |
100%
|
||
| hourse_id |
100%
|
||
| hourse_service | 6 | title |
100%
|
| hourse_x_hourse_appliance | 270,771 | hourse_id |
100%
|
| hourse_appliance_id |
100%
|
||
| hourse_x_hourse_bathroom | 504,669 | hourse_id |
100%
|
| hourse_bathroom_id |
100%
|
||
| hourse_x_hourse_bed | 92,794 | hourse_id |
100%
|
| hourse_bed_id |
100%
|
||
| hourse_x_hourse_facility | 381,645 | hourse_id |
100%
|
| hourse_facility_id |
100%
|
||
| hourse_x_hourse_kitchen | 157,955 | hourse_id |
100%
|
| hourse_kitchen_id |
100%
|
||
| hourse_x_hourse_service | 164,124 | hourse_id |
100%
|
| hourse_service_id |
100%
|
||
| hourse_x_owner | 71,004 | owner_id |
100%
|
| hourse_id |
100%
|
||
| image_slug | 1,081,175 | hourse_id |
100%
|
| owner | 29,299 | mark |
99.96%
|
| title |
100%
|
||
| comment_count |
100%
|
||
| hourse_count |
100%
|
||
| answer_rating |
100%
|
||
| answer_time |
100%
|
||
| tag | 56 | tag |
98.21%
|
| tag_x_hourse | 293,369 | tag_id |
100%
|
| hourse_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
HOURSE_IMAGE
| Size (Bytes) | Files |
|---|---|
| 4.91G | 9,410 |
