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) |
Last Commit | 2023-06-19 18:12:05 (+ 169 d) |
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.
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%
|
No media sets.
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2023-06-19 (+ 169 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2023-01-01 (+ 95 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2022-09-27 (+ 271 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-12-30 (+ 115 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-09-05 (+ 150 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-04-08 (+ 68 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2021-01-29 (+ 120 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-10-01 (+ 38 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-08-23 (+ 141 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-04-04 (+ 196 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-09-21 (+ 197 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-03-07 (+ 43 d) | 142.64M (+ 0B) | 22 (+ 0) | 147 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-01-23 (+ 44 d) | 142.64M (- 0.12M) | 22 (- 2) | 147 (- 13) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-12-09 (+ 29 d) | 142.77M (+ 544K) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-11-09 (+ 27 d) | 142.23M (+ 35.39M) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-10-13 (+ 29 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-09-13 (+ 34 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-08-09 (+ 27 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-07-12 (+ 31 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-06-10 (+ 31 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-05-10 (+ 28 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-04-11 (+ 38 d) | 106.84M (+ 0B) | 24 (+ 0) | 160 (+ 0) | 528,597 (+ 5,723) | 0B (+ 0B) | 0 (+ 0) |
2018-03-03 (+ 35 d) | 106.84M (+ 66.78M) | 24 (+ 0) | 160 (+ 0) | 522,874 (+ 381,637) | 0B (+ 0B) | 0 (+ 0) |
2018-01-27 | 40.06M | 24 | 160 | 141,237 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.