Usage & Publication License: database price dollar sign289.00

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

database structure screenshot of US 23K Top Doctors: Phone, Name of 2K Hospitals in 1K 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/

Related DBs:

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
  1. id
  2. ts
  3. city
  4. state
hospital 2,112
  1. id
  2. ts
  3. title
  4. zip_code
  5. telephone
  6. address
  7. description
  8. location_lat
  9. location_lon
hospital_info 2,112
  1. id
  2. ts
  3. hospital_type
  4. hospital_size
  5. nurse_staffing
hospital_other_other 54,482
  1. id
  2. ts
  3. title
  4. description
  5. level
  6. score
  7. total_score
  8. level_text
hospital_other_overall 7,728
  1. id
  2. ts
  3. overall
hospital_other_rank 7,734
  1. id
  2. ts
  3. title
hospital_overall 1,105
  1. id
  2. ts
  3. overall_score
hospital_review 12,155
  1. id
  2. ts
  3. title
  4. description
  5. score
hospital_speciality_other 8,208
  1. id
  2. ts
  3. title
  4. score
hospital_speciality_other_detail 29,058
  1. id
  2. ts
  3. title
  4. desciption
  5. level
  6. score
  7. yes_no
hospital_speciality_outcome 4,104
  1. id
  2. ts
  3. title
  4. score
hospital_speciality_outcome_detail 12,312
  1. id
  2. ts
  3. title
  4. score
  5. desciption
  6. level
hospital_speciality_overall 8,299
  1. id
  2. ts
  3. title
  4. score
hospital_speciality_rank 4,157
  1. id
  2. ts
  3. title
hospital_x_city 2,112
  1. id
  2. ts
hospital_x_doctor 27,855
  1. id
  2. ts

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
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: info@UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. How many eyes do you have? Use 1, 2, 3, ... to answer.

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.