This is a comprehensive doctors database with 5,499,669 records from 83,538 cities of 3,213 states in American. Each record has title, address, telephone number, distance, name, description, service and additional service. All these US doctors are classified into 63 categories, such as Anesthesiologist, Colorectal Doctor, Endocrinologist, Hematologist, Internist, etc. It also includes 26,758 details of these doctors. These doctors of this database are some specialites including family and general medicine, pediatrics, gynecology, anesthesiology and surgery. These data can help someone or hospital to have a professional doctor to stay healthy, to get healthy, to receive medication or to get a referral.
There are 10 tables in the whole United States doctors data set.
| Name | n3_chennan_doctor_wellness_com |
|---|---|
| Data | 10.31G (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 62 (+ 0) |
| Table Rows | 26,667,136 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 63 | title |
100%
|
| category_2 | 2,271,356 | title |
100%
|
| category_2_x_doctor | 5,733,612 | category_2_id |
100%
|
| doctor_id |
100%
|
||
| city | 83,538 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_category_2 | 2,271,356 | city_id |
100%
|
| category_2_id |
100%
|
||
| detail | 26,758 | key |
100%
|
| value |
99.99%
|
||
| doctor | 5,499,669 | title |
100%
|
| address |
100%
|
||
| telephone |
99.46%
|
||
| distance |
99.48%
|
||
| name |
48.16%
|
||
| description |
86.51%
|
||
| serivice |
86.51%
|
||
| additional_service |
1.29%
|
||
| doctor_2 | 62,997 | title |
100%
|
| address |
100%
|
||
| telephone |
99.44%
|
||
| distance |
54.34%
|
||
| name |
45.98%
|
||
| description |
86.16%
|
||
| serivice |
86.16%
|
||
| additional_service |
1.1%
|
||
| doctor_x_detail | 10,714,574 | doctor_id |
100%
|
| detail_id |
100%
|
||
| state | 3,213 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
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
No media sets.
