This is a high-volume hospitals & doctors database of 2,112 hospitals having 23,975 doctors over 1,612 popular cities in the United States. In table hospital, there are title, zip code, telephone number, address, description, latitude and longitude fields. In table doctor, it consists of name, gender, title, phone number, years of experience, description, speciality, sub-specialty, board certification, office city, office zip, office address, office state and fax number in each record.
In the whole US hospitals & doctors data set, there are 6 doctor information related tables, they are doctor award table with 19,158 records; doctor certification with 62,929 records; doctor education with 23,543 records; doctor insurance with 148,179 records and doctor training with 65,668 records. Besides, it has 13 hospital information related tables, such as hospital information with size, type, nurse staffing fields; hospital level with title, description, level, score, total score, level text and hospital other rank id fields; hospital other overall table with 7,728 records; hospital other rank table with 7,734 records; hospital speciality outcome with 4,104 records, etc. This abundant US hospitals with doctors database is filled with detailed hospitals and doctors specific information to satisfy someone's professional needs.
The whole United States hospitals & doctors data has 22 tables.
| Name | n3_lyz_health.usnews.com |
|---|---|
| Data | 142.64M (+ 0B) |
| Tables | 22 (+ 0) |
| Columns | 147 (+ 0) |
| Table Rows | 528,597 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 1,612 | city |
100%
|
| state |
100%
|
||
| doctor | 23,975 | name |
100%
|
| gender |
100%
|
||
| title |
100%
|
||
| phone |
100%
|
||
| years_of_experience |
100%
|
||
| description |
100%
|
||
| speciality |
100%
|
||
| subspecialty |
99.97%
|
||
| board_certification |
81.25%
|
||
| office_city |
99.88%
|
||
| office_zip |
99.88%
|
||
| office_address |
99.88%
|
||
| office_state |
99.88%
|
||
| fax |
74.61%
|
||
| doctor_award | 19,158 | organization_name |
94.56%
|
| year |
0%
|
||
| description |
72.57%
|
||
| name |
100%
|
||
| doctor_id |
100%
|
||
| doctor_certification | 62,929 | title |
100%
|
| time |
100%
|
||
| description |
0%
|
||
| name |
0%
|
||
| doctor_id |
100%
|
||
| doctor_education | 23,543 | institution |
100%
|
| start_year |
100%
|
||
| end_year |
100%
|
||
| program_name |
100%
|
||
| institution_type |
100%
|
||
| doctor_id |
100%
|
||
| doctor_insurance | 148,179 | insurance |
100%
|
| doctor_id |
100%
|
||
| doctor_training | 65,668 | institution |
100%
|
| start_year |
100%
|
||
| end_year |
100%
|
||
| program_name |
100%
|
||
| institution_type |
100%
|
||
| doctor_id |
100%
|
||
| hospital | 2,112 | title |
100%
|
| zip_code |
100%
|
||
| telephone |
100%
|
||
| address |
100%
|
||
| description |
94.46%
|
||
| location_lat |
100%
|
||
| location_lon |
100%
|
||
| hospital_info | 2,112 | hospital_type |
99.95%
|
| hospital_size |
100%
|
||
| nurse_staffing |
71.5%
|
||
| hospital_id |
100%
|
||
| hospital_other_other | 54,482 | title |
100%
|
| description |
100%
|
||
| level |
74.06%
|
||
| score |
67.43%
|
||
| total_score |
67.43%
|
||
| level_text |
18.11%
|
||
| hospital_other_rank_id |
100%
|
||
| hospital_other_overall | 7,728 | overall |
100%
|
| hospital_other_rank_id |
100%
|
||
| hospital_other_rank | 7,734 | title |
100%
|
| hospital_id |
100%
|
||
| hospital_overall | 1,105 | overall_score |
100%
|
| hospital_id |
100%
|
||
| hospital_review | 12,155 | title |
100%
|
| description |
100%
|
||
| score |
100%
|
||
| hospital_id |
100%
|
||
| hospital_speciality_other | 8,208 | title |
100%
|
| score |
100%
|
||
| hospital_speciality_rank_id |
100%
|
||
| hospital_speciality_other_detail | 29,058 | title |
100%
|
| desciption |
100%
|
||
| level |
55.72%
|
||
| score |
55.72%
|
||
| yes_no |
44.28%
|
||
| hospital_speciality_other_id |
100%
|
||
| hospital_speciality_outcome | 4,104 | title |
100%
|
| score |
100%
|
||
| hospital_speciality_rank_id |
100%
|
||
| hospital_speciality_outcome_detail | 12,312 | title |
100%
|
| score |
100%
|
||
| hospital_speciality_outcome_id |
100%
|
||
| desciption |
100%
|
||
| level |
100%
|
||
| hospital_speciality_overall | 8,299 | title |
100%
|
| score |
99.63%
|
||
| hospital_speciality_rank_id |
100%
|
||
| hospital_speciality_rank | 4,157 | title |
100%
|
| hospital_id |
100%
|
||
| hospital_x_city | 2,112 | hospital_id |
100%
|
| city_id |
100%
|
||
| hospital_x_doctor | 27,855 | hospital_id |
100%
|
| doctor_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
No media sets.
