Authoritative Hospital Database | CarePrecise
Healthcare provider data

The Authoritative Hospital Database

Current data update released September 21, 2020

6,000+ Hospitals, with employee count, patient satisfaction ratings, bed count, contact name, address, phone, fax and more.

Complete Hospital List

This is the best-in-class hospital database that brings you deep information on U.S. HIPAA-covered hospitals with their health systems, affiliated physicians and practice groups, together in one clear and concise database.

CarePrecise mines hospital data acquired from the US Department of Health and Human Services and our business partners, including information extracted from multiple databases and hundreds of millions of health insurance claims, using our QoRelate™ data collection and linking technology – aggregated and merged into one easy-to-use file for Microsoft Excel, Access, SQL, FileMaker, or any other spreadsheet, database or CRM software on PC, Mac or Linux.

 

Hospital/Physician/Group connections

A comprehensive database of U.S. hospital information.

Extracted from the CarePrecise master provider database with information all of the 6.3 million HIPAA-covered US healthcare providers and additional sources, the Authoritative Hospital Database (AHD) contains records for all HIPAA-covered hospitals. In this database of hospitals we include bed counts, patient satisfaction data, hospital system ownership, and more. Most records include a cabinet-level or director-level contact.

You get bed counts for 95% of hospitals, full contact information on 85%, and fax numbers for 62%. We include detailed patient satisfaction data, employee counts, and medical procedure volumes.

The AHD integrates directly with our extended provider data product to bring you the physicians and practice groups affiliated with the hospitals. This combination of data is the only commercially available hospital dataset of this depth.

 

At pricing made possible by advanced data collection and record linkage technology.

Our accuracy and pricing truly sets CarePrecise apart from other physician data suppliers. Read about the accuracy of our data...

 

Single Download: $899 Buy Now
Subscriptions:

1 Year Quarterly Updates: $2,023 Buy Now

1 Year Monthly Updates: $4,551 Buy Now

2 Years Quarterly: $3,641 Buy Now

2 Years Monthly: $8,192 Buy Now

 

Product Details

CarePrecise data sets connect together into a single source of truth regarding hospitals and their connected providers. For instance, by adding Gold, Platinum, or the Master Bundle data set to the Authoritative Hospital Database, it is possible to see all of the providers who practice together, including physicians, nutritionists, RNs, and all other taxonomies of healthcare providers, as well as their organizations and employers, using CarePrecise's exclusive CoLoCode co-located provider identifier. By adding the Authoritative Physician Database (APD), you can view all physicians affiliated with the hospitals and health systems.

 

Touch diagram and rotate screen to view full size...

CarePrecise

 

Printer-friendly version of the AHD database fields Click for a printer-friendly version of the fields list...

Use scroll bar inside box to view all 136 APD data fields ¬   
Table Name Name Description Data Type Size
Analysis_Hospital CCN Number assigned by Medicare to hospitals Text 6
NPI Number assigned to all HIPAA-covered providers Text 10
EIN Employer Identification Number (tax number/TIN) Text 20
HospitalName Hospital’s name Text 255
Address1 Hospital’s address, line 1 Text 100
Address2 Hospital’s address, line 2 Text 100
City Hospital’s City Text 100
State Hospital State Text 2
ZIP Code Hospital Zip Code Text 5
County Hospital County Text 25
Phone Hospital Phone Text 10
Fax Hospital Fax Text 20
Beds Number of beds Long Integer
BedDaysAvail Number of bed days available Long Integer
InternsAndResidents Number of interns and residents Double
PayrollEmployees Number of employees on payroll Double
NonPaidWorkers Number of non-paid workers Double
TotalDischarges Number of discharges/year Double
MedicareDischarges Number of Medicare discharges/year Double
MedicaidDischarges Number of Medicaid discharges/year Double
Vol_Gastrointestinal Procedure volume: Gastrointestinal Text 20
Vol_Eye Procedure volume: Eye Text 20
Vol_Nervous_system Procedure volume: Nervous system Text 20
Vol_Musculoskeletal Procedure volume: Musculoskeletal Text 20
Vol_Skin Procedure volume: Skin Text 20
Vol_Genitourinary Procedure volume: Genitourinary Text 20
Vol_Cardiovascular Procedure volume: Cardiovascular Text 20
PN Contact name prefix Text 5
FN Contact first name Text 20
MN Contact middle name Text 20
LN Contact last name Text 35
SN Contact name suffix Text 5
Title Contact title Text 35
Cred Contact credentials Text 50
Teaching Hospital Y = this is a teaching hospital Text 1
HospitalType Type of hospital Text 50
HospitalOwnership Type of hospital ownership Text 100
ParentOrgLBN Name of parent system Text 100
EmergencyService Does have emergency service? Text 50
CoLoCode Algorithmically derived from location data Text 40
Bathroom cleanliness Patient satisfaction 1-5 stars Long Integer
Communication from Nurses Patient satisfaction 1-5 stars Long Integer
Communication from Doctors Patient satisfaction 1-5 stars Long Integer
Patient received help quickly on request Patient satisfaction 1-5 stars Long Integer
Quality of pain control Patient satisfaction 1-5 stars Long Integer
Medications were explained before giving Patient satisfaction 1-5 stars Long Integer
Patient received instruction on at home recovery Patient satisfaction 1-5 stars Long Integer
Patient understood care when leaving hospital Patient satisfaction 1-5 stars Long Integer
Patient’s overall hospital rating Patient satisfaction 1-5 stars Long Integer
Area around room was quiet at night Patient satisfaction 1-5 stars Long Integer
Patient would recommend hospital Patient satisfaction 1-5 stars Long Integer
Hospital summary star rating Patient satisfaction 1-5 stars Long Integer
Table Name Field Name Description Type Size
Analysis_System HlthSysID Unique ID representing the parent system Text 20
HlthSysName Name of the health system parent to which the hospital belongs Text 100
HlthSysCity City of parent system Text 100
HlthSysState State of parent system Text 2
HlthSysPhys Total number of health system primary care physicians Long 4
HlthSysPCPhys Number of health system primary care physicians Long 4
HlthSysResidents Number of Residents across health system Long 4
HlthSysGroups Number of practice groups in the health system Long 4
HlthSysHospitals Number of hospitals in the health system Long 4
HlthSysAcuteCare Number of acute care hospitals in the health system Long 4
HlthSysBeds Number of beds across health system Long 4
HlthSysStates Number of states in which health system operates Long 4
HlthSysDischarges Number of discharges across health system Long 4
HlthSysHighUCCB True = Health System has a high uncompensated care burden Boolean 1
HlthSysInvestorOwned True = Health System is predominantly investor-owned Boolean 1

 

Data Contents

Approximate population of selected fields:

Records CCN NPI EIN Contact Name Phone Number Fax Street Address Bed Count Procedure Volumes Patient Satisfaction Ratings
6,190 100.00% 90.32% 21.71% 90.32% 93.41% 66.14% 100.00% 96.85% 71.49% 54.25%
These numbers may be taken as approximate, as data is updated continuously. New updates are released twelve times per year. Not all records are populated with all data points. Records are unduplicated per NPI and/or CCN identifier.

For a mobile-friendly view of all 67 AHD data fields, touch here.

 

Data Contents

Approximate population in a selection of the 67 AHD fields:

Swipe left to view all...

Records CCN NPI EIN Contact Name Phone Number Fax Street Address Bed Count Procedure Volumes Patient Satisfaction Ratings
6,190 100.00% 90.32% 21.71% 90.32% 93.41% 66.14% 100.00% 96.85% 71.49% 54.25%
These numbers may be taken as approximate, as data is updated continuously. New updates are released twelve times per year. Not all records are populated with all data points. Records are unduplicated per NPI and/or CCN identifier.

 

DELIVERY

Immediate download from our online store. Optional shipping via mail on a DVD disk or thumb drive is also available. Optional secure, automation-friendly FTP push delivery is available for subscribers.

 

FILE FORMATS

The downloaded zip file contains the AHD in three file formats, each containing identical data:

  • Comma Separated Values (.csv); normalized relational tables; may be used in Excel or imported into any spreadsheet or database software on Windows, Mac or Linux system.
  • Microsoft Access 2003/2007/2010/2013 (.mdb); normalized relational tables, with example queries.
  • Microsoft Excel spreadsheet (.xls).

 

SUPPORT

The Single Download option includes 30 days of free Telephone Technical Support. Subscription options come with 90 days of free Telephone Technical Support. Ongoing technical support via email. See support details.

 

SAMPLE DATA

Download sample data at this link.

 

PACKAGES

Single Download: $899 Buy Now
Subscriptions:

1 Year Quarterly Updates: $2,023 Buy Now

1 Year Monthly Updates: $4,551 Buy Now

2 Years Quarterly: $3,641 Buy Now

2 Years Monthly: $8,192 Buy Now

 

LICENSING

CarePrecise data is licensed for use by the purchaser and may not be redistributed. Review the End User License Agreement. Special redistribution licensing is also available. Unless a redistribution or multi-user license is obtained separately, the standard End User License Agreement permits the licesee to use the data in any way desired as long as it is within and for the buyer's own organization and is used by only one user at a time (may not be installed on multiple computers for use by multiple simultaneous users). Alternative licensing options are available for uses that involve distribution of the data or use of the data by more than one user and/or for public viewing, and are purchased separately. For information on licensing CarePrecise data for use in your web applications, products or services, phone 1 (877) 782-2294 extension 9.

 

MORE INFORMATION

Contact CarePrecise Sales at (877) 782-2294, sales@careprecise.com