Database
US 23K Top Doctors: Phone, Name of 2K Hospitals in 1K Cities
United States 23,975 top doctors: name gender, phone of 2,112 hospitals: zip code, address, tel. from 1,612 cities
Description: This is a high-volume 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, specialty, sub-specialty, board certification, office city, office zip, office address, office state and fax number in each record.
From the whole US hospitals & doctors database, it has 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 specialty 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 database has 24 tables.
Data Samples (JSON, CSV, XML, Excel):
http://n3.datasn.io/data/api/v1/n3_lyz/usa_hospital_information_1/main/list/
Database Statistics
- Size: 52.95 MB
- Tables: 16
- Records: 2,112
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Database Structure
Table | Records | Fields |
---|---|---|
city | 1,612 |
|
hospital | 2,112 |
|
hospital_info | 2,112 |
|
hospital_other_other | 54,482 |
|
hospital_other_overall | 7,728 |
|
hospital_other_rank | 7,734 |
|
hospital_overall | 1,105 |
|
hospital_review | 12,155 |
|
hospital_speciality_other | 8,208 |
|
hospital_speciality_other_detail | 29,058 |
|
hospital_speciality_outcome | 4,104 |
|
hospital_speciality_outcome_detail | 12,312 |
|
hospital_speciality_overall | 8,299 |
|
hospital_speciality_rank | 4,157 |
|
hospital_x_city | 2,112 |
|
hospital_x_doctor | 27,855 |
|
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
city
- Abbeville
- Abbeville
- Minneapolis
- Abilene
- Abington
- Lansdale
- Lincoln
- Phoenix
- Glendale
- Goodyear
- Kaplan
- Crowley
- Bangor
- Lafayette
- Church Point
- Kittanning
- Acoma
- San Antonio
- Atlantic City
- Steubenville
- Greenfield
- Seaman
- Decatur
- Worcester
- Greenfield
- Chillicothe
- Waverly
- Saranac Lake
- Billings
- Las Cruces
- Searcy
- Houston
- Toledo
- Washington
- Rockville
- Takoma Park
- Los Angeles
- La Grange
- Hanford
- Portland
- Reedley
- Normal
- Oak Lawn
- Libertyville
- Eureka
- Downers Grove
- Barrington
- Chicago
- Park Ridge
- Elgin
- Hazel Crest
- Massillon
- Fond Du Lac
- Anaheim
- Aiken
- Burlington
- Oakland
- Alameda
- Anchorage
- Albany
- Natrona Heights
- Plainview
- Ruston
- Greenville
- Kilgore
- Iola
- Fairfax
- Kinder
- Alliance
- Blackwell
- Holly Springs
- Meridian
- Clinton
- Oklahoma City
- Durant
- Madill
- Midwest City
- Ponca City
- Pryor
- Seminole
- La Mesa
- Amarillo
- American Fork
- Amery
- Albuquerque
- Covington
- Denham Springs
- Edmond
- Clinton
- Greenwood
- Berlin
- Franklin
- Durango
- Anderson
- Newburyport
- Annapolis
- Osceola
- Anoka
- Anson
- La Junta
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.