该数据库是一个医院和医生信息集合，共包含有16个分类下的7,987家医院，98,386个系和476,807位医生。这些医院来自全国31个省份的496个城市。每家医院信息中有城市，级别，特征，地址，电话，描述等。在医生表中，每个医生记录中有系，职位，级别，专长，实践经验，得分，访客量等。整个中国医院，系和医生信息数据库共有10个表。
This is a hospitals, faculties and doctors database from 496 cities of 31 provinces in China. There are 7,987 hospitals by 16 categories. Each hospital consists of city, level, feature, address, telephone number, description and etc. In table doctor, it has 476,807 records with faculty, job title, level, specialty, practice experience, score, visits suggest and etc. It also comes with 98,386 faculties with faculty category, doctor quantity and description in each. The whole China hospitals, faculties and doctors database totally has 10 tables.
| Name | n3a2_haodf_com_hospital |
|---|---|
| Data | 424.09M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 57 (+ 0) |
| Table Rows | 603,861 (+ 0) |
| Media | 8.03G (+ 0B) |
| Files | 18,534 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 16 | title |
100%
|
| city | 496 | title |
100%
|
| province_id |
100%
|
||
| city_id |
8.06%
|
||
| doctor | 476,807 | title |
100%
|
| faculty_id |
100%
|
||
| level |
94.4%
|
||
| job_title |
22.08%
|
||
| specialty |
31.62%
|
||
| practice_experience |
20.77%
|
||
| score |
38.23%
|
||
| visits_suggest |
4.17%
|
||
| visits_suggest_pubdate |
38.22%
|
||
| faculty | 98,386 | title |
100%
|
| faculty_category_id |
100%
|
||
| doctor_quantity |
100%
|
||
| description |
99.83%
|
||
| faculty_category | 19,276 | title |
100%
|
| hospital_id |
100%
|
||
| hospital | 7,987 | title |
100%
|
| city_id |
100%
|
||
| level |
94.8%
|
||
| feature |
6.02%
|
||
| address |
98.37%
|
||
| how_to_get |
22.95%
|
||
| telephone |
95.62%
|
||
| description |
78.58%
|
||
| province | 31 | title |
100%
|
| province_x_category_1 | 496 | province_id |
100%
|
| category_1_id |
100%
|
||
| province_x_category_1_x_hospital | 366 | province_x_category_1_id |
100%
|
| hospital_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
DOCTOR_IMAGE
| Size (Bytes) | Files |
|---|---|
| 8.03G | 18,534 |
