This is a collection of doctors with 7,339 records across over 1,333 cities of 51 states in America. Each record is comprised of title, specialty, rating, address locality, address region, postal code, etc. It also contains 4,735 education records, 83 languages spoken, 60 specialties, etc. information of these doctors related. The whole United States doctors data set has 18 tables.
| Name | n3_chennan_doctor_zocdoc_com |
|---|---|
| Data | 14.89M (+ 0B) |
| Tables | 18 (+ 0) |
| Columns | 80 (+ 0) |
| Table Rows | 66,820 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| award_and_publication | 1,541 | value |
100%
|
| board_certification | 57 | value |
100%
|
| city | 1,333 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_doctor | 13,279 | city_id |
100%
|
| doctor_id |
100%
|
||
| doctor | 7,339 | title |
100%
|
| speciality |
100%
|
||
| rating |
45.81%
|
||
| professional_statement |
21.8%
|
||
| street_address |
45.99%
|
||
| address_locality |
98.99%
|
||
| address_region |
98.99%
|
||
| postal_code |
98.99%
|
||
| address_country |
45.99%
|
||
| latitude |
45.99%
|
||
| longitude |
45.99%
|
||
| doctor_x_award_and_publication | 1,905 | doctor_id |
100%
|
| award_and_publication_id |
100%
|
||
| doctor_x_board_certification | 2,602 | doctor_id |
100%
|
| board_certification_id |
100%
|
||
| doctor_x_education | 8,761 | doctor_id |
100%
|
| education_id |
100%
|
||
| doctor_x_in_network_insurance | 10,254 | doctor_id |
100%
|
| in_network_insurance_id |
100%
|
||
| doctor_x_languages_spoken | 6,144 | doctor_id |
100%
|
| languages_spoken_id |
100%
|
||
| doctor_x_professional_membership | 2,250 | doctor_id |
100%
|
| professional_membership_id |
100%
|
||
| doctor_x_specialty | 5,820 | doctor_id |
100%
|
| specialty_id |
100%
|
||
| education | 4,735 | value |
100%
|
| in_network_insurance | 128 | value |
100%
|
| languages_spoken | 83 | value |
100%
|
| professional_membership | 478 | value |
100%
|
| specialty | 60 | value |
100%
|
| state | 51 | 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
No media sets.
