这是一个全国医疗诊所信息数据库，共包含有12,710家医疗诊所且每家诊所记录中有描述，地址，最低价，资本消耗，总分，评论数，经度，纬度，区域，街道，电话等信息。这些医疗诊所遍布全国3,450个地区，1,180个城市的13,149个街道。数据中包含有医疗诊所的65,805个客户信息；49,234个服务项目及每个服务项目的描述，内容，价格，总结，原价，折扣及销售数量以及10,713个其它服务项目。除此之外，该数据中有42,184张医疗图片且存储在7.96G的文件夹中。整个中国医疗诊所信息数据库共有17个表。
In this medical clinics database, there are 12,710 records with description, address, lowest price, per capital consumption, score overall, comment count, latitude, longitude, area, street, telephone number and open time in each. These medical clinics are over 13,149 streets from 1,180 cities of 3,450 areas in China. Besides, there are 65,805 clients and 49,234 service items with description, content, price, summary, original price, discount and sale count in each and 10,713 other services of these clinics. The medical clinics data also comes with 42,184 medical images in the 7.96G media set. The whole China medical clinics data set totally has 17 tables.
| Name | n3_lyz_meituan.com/yiliao |
|---|---|
| Data | 219.52M (+ 67.20M) |
| Tables | 17 (+ 0) |
| Columns | 98 (+ 0) |
| Table Rows | 866,495 (+ 0) |
| Media | 7.96G (+ 0B) |
| Files | 32,474 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| area | 3,450 | area |
100%
|
| city_id |
100%
|
||
| category | 301 | category |
100%
|
| city | 1,180 | city |
100%
|
| city_x_category | 6,381 | city_id |
100%
|
| category_id |
100%
|
||
| city_x_category_x_yiliao | 238,384 | city_x_category_id |
100%
|
| yiliao_id |
100%
|
||
| client | 65,805 | user_name |
99.99%
|
| user_lever |
100%
|
||
| comment_image_slug | 23,467 | yiliao_comment_id |
100%
|
| image_slug | 42,184 | yiliao_id |
100%
|
| other_service | 10,713 | other_service |
100%
|
| yiliao_id |
100%
|
||
| service_item | 49,234 | description |
0%
|
| yiliao_id |
100%
|
||
| content |
99.94%
|
||
| price |
99.94%
|
||
| summary |
99.94%
|
||
| price_original |
96.68%
|
||
| discount |
96.79%
|
||
| sale_count |
93.03%
|
||
| service_item_detail | 155,006 | content |
100%
|
| price |
100%
|
||
| service_item_id |
100%
|
||
| quantity |
100%
|
||
| street | 13,149 | street |
100%
|
| area_id |
100%
|
||
| yiliao | 12,710 | description |
0%
|
| yiliao |
100%
|
||
| address |
100%
|
||
| lowest_price |
100%
|
||
| per_capita_consumption |
100%
|
||
| score_overall |
100%
|
||
| comment_count |
100%
|
||
| latitude |
100%
|
||
| longitude |
100%
|
||
| area |
100%
|
||
| street |
68.06%
|
||
| telephone |
71.84%
|
||
| opentime |
68.21%
|
||
| yiliao_comment | 87,462 | uniq |
100%
|
| comment |
99.97%
|
||
| yiliao_id |
100%
|
||
| time |
100%
|
||
| yiliao_comment_x_client | 87,462 | yiliao_comment_id |
100%
|
| client_id |
100%
|
||
| yiliao_score | 69,607 | content |
100%
|
| count |
100%
|
||
| yiliao_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
YILIAO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 7.96G | 32,474 |
