This doctors database can assist you to find the right doctors in your area. There are 105,809 doctors over 2,350 popular cities of 52 states in America. Each doctor has title, image alt, general information, street address, address locality, address region, postal code, fax, phone number, latitude and longitude. In the table education, there are 135,490 records of these doctors. In addition, there are 657 specialties, 194 languages spoken and 6,173 insurance accepted records of these doctors.
The whole US doctors data set has 14 tables.
| Name | n3_chennan_doctor_healthgrades_com |
|---|---|
| Data | 265.23M (+ 0B) |
| Tables | 14 (+ 0) |
| Columns | 66 (+ 0) |
| Table Rows | 1,607,348 (+ 0) |
| Media | 823.03K (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 21,721 | title |
100%
|
| city_id |
100%
|
||
| city |
100%
|
||
| category_1_x_doctor | 111,717 | category_1_id |
100%
|
| doctor_id |
100%
|
||
| city | 2,350 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| doctor | 105,809 | title |
100%
|
| image_alt |
100%
|
||
| general_info |
99.97%
|
||
| street_address |
94.39%
|
||
| address_locality |
99.93%
|
||
| address_region |
99.93%
|
||
| postal_code |
99.93%
|
||
| fax |
79.39%
|
||
| phone |
91.77%
|
||
| latitude |
99.91%
|
||
| longitude |
99.91%
|
||
| doctor_x_education | 237,986 | doctor_id |
100%
|
| education_id |
100%
|
||
| doctor_x_insurance_accepted | 714,106 | doctor_id |
100%
|
| insurance_accepted_id |
100%
|
||
| doctor_x_languages_spoken | 135,304 | doctor_id |
100%
|
| languages_spoken_id |
100%
|
||
| doctor_x_specialties | 135,789 | doctor_id |
100%
|
| specialties_id |
100%
|
||
| education | 135,490 | key |
100%
|
| value |
100%
|
||
| insurance_accepted | 6,173 | value |
100%
|
| languages_spoken | 194 | value |
100%
|
| specialties | 657 | value |
100%
|
| state | 52 | title |
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 |
|---|---|
| 823.03K | 300 |
