这是一个娱乐场所数据库，共包含有来自全国1,180个城市，3,451个区域, 13,149个街道的93,329个娱乐场所记录，这些娱乐场所被分为181个类别。每个娱乐场所记录中有描述，娱乐，地址，最低价格，总评分，评论数，经度，纬度，区域，街道，电话，营业时间和人均消费量。整个娱乐场所数据库中有其它4个表和娱乐场所密切相关，它们分别是383,863个娱乐评论记录且每个记录中有独特性，星级指数，时间，用户智能终端数据，用户名称及用户级别；609,667个娱乐评论标记记录且每个记录中有内容和点击数量；398,202个服务项目记录且每个记录中有总结，价格，原价，折后价格，折扣，时间，异常时间，预定，适合的人，规则，服务，详细内容和内容描述以及49,293个其它服务项目记录。整个娱乐场所数据中还包含有475,752张娱乐场所图片且存储在206.35M的媒体文件夹中。该全国娱乐场所数据库共有15个表。
This is an entertainments database with 93,329 records by 181 categories. All these entertainments are from 13,149 streets of 3,451 areas in 1,180 cities of China.
Each record is comprised of description, entertainment, address, lowest price, score overall, comment count, latitude, longitude, area, street, telephone, opentime and per capita consumption. There are 5 tables mostly related with these entertainments, they are 383,863 entertainment comment records with uniq, comment, entertainment id, title, star index, time, user idt, user name and user level in each; 609,667entertainment comment mark records with content and count in each; 398,202 service item records with entertainment id, summary, price, original price, title, discount price, discount, time, exception time, book, people fit for, rule, service, detail content and content description in each and 49,293 other service records. This China entertainments data also comes with 475,752 images of these entertainments and they are keeped in the 206.35M media set.
The whole China entertainments data set totaly has 15 tables.
| Name | n3_lyz_meituan.com/xiuxianyule |
|---|---|
| Data | 1.36G (+ 1.16G) |
| Tables | 15 (+ 0) |
| Columns | 105 (+ 0) |
| Table Rows | 2,575,059 (+ 0) |
| Media | 206.35M (+ 0B) |
| Files | 1,355 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| area | 3,451 | area |
100%
|
| city_id |
100%
|
||
| category | 181 | category |
100%
|
| city | 1,180 | city |
100%
|
| city_x_category | 12,115 | city_id |
100%
|
| category_id |
100%
|
||
| city_x_category_x_entertainment | 105,035 | city_x_category_id |
100%
|
| entertainment_id |
100%
|
||
| comment_image_slug | 429,839 | entertainment_comment_id |
100%
|
| entertainment | 93,329 | description |
0%
|
| entertainment |
100%
|
||
| address |
100%
|
||
| lowest_price |
100%
|
||
| score_overall |
100%
|
||
| comment_count |
100%
|
||
| latitude |
100%
|
||
| longitude |
100%
|
||
| area |
100%
|
||
| street |
51.51%
|
||
| telephone |
95.66%
|
||
| opentime |
93.02%
|
||
| per_capita_consumption |
100%
|
||
| entertainment_comment | 383,863 | uniq |
100%
|
| comment |
100%
|
||
| entertainment_id |
100%
|
||
| title |
92.25%
|
||
| star_index |
100%
|
||
| time |
100%
|
||
| user_idt |
100%
|
||
| user_name |
99.99%
|
||
| userlevel |
100%
|
||
| entertainment_comment_mark | 609,667 | content |
100%
|
| count |
100%
|
||
| entertainment_id |
100%
|
||
| image_slug | 475,752 | entertainment_id |
100%
|
| opentime |
0%
|
||
| other_service | 49,293 | other_service |
100%
|
| entertainment_id |
100%
|
||
| service_item | 398,202 | entertainment_id |
100%
|
| summary |
98.13%
|
||
| price |
0%
|
||
| original_price |
98.13%
|
||
| title |
98.13%
|
||
| discount_price |
98.13%
|
||
| discount |
98.13%
|
||
| time |
98.1%
|
||
| exception_time |
18.7%
|
||
| book |
98.1%
|
||
| people_fit_for |
18.48%
|
||
| rule |
98.1%
|
||
| service |
57.46%
|
||
| detail_content |
98.06%
|
||
| content_description |
59.56%
|
||
| service_item_detail | 3 | content |
100%
|
| service_item_id |
100%
|
||
| count |
66.67%
|
||
| price |
100%
|
||
| entertainment_id |
0%
|
||
| totle_price |
100%
|
||
| street | 13,149 | street |
100%
|
| area_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
ENTERTAINMENT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 206.35M | 1,355 |
