Authoritative Hospital Database | CarePrecise
Healthcare provider data

The Authoritative Hospital Database

Current data update released September 21, 2021

6,000+ Hospitals, with ownership status, health system, 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, hospital charges and cases by Zip Code®, 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.

 

NEW: Hospital NPI to CCN Rollup

A CarePrecise Exclusive. Using advanced record-linkage technology, the AHD now includes a new file that makes it possible to mine the vast hospital information available in the National Provider Identifier registry database. Hospitals may have dozens of NPI records, each with its own information about a unit, listing facility type and/or medical specialties practiced, as well as separate contact names. To wield the power of this new feature, you'll need the CarePrecise Master Bundle, which contains all of the publicly available NPI registry data.

 

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.

 

Rotate screen to view diagram 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 AHD 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
HlthSysID Health System ID key to Health System table Test 20
HlthSysName Name of the health system to which the hospital belongs Text 100
MSA MSA of hospital location Text 5
Population Population of hospital's location zip code Long Integer
Rural/Urban Hospital is located in a Zip Code considered rural (R) or urban (U) Text 1
Placekey® (beta) Open source key identifying the business and the location. See the Placekey website. Text 100
Table Name Name Description Data 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
File (Beta):
AuthoritativeHospitalDB_RollupNPI
The purpose of this file is to present all of the Type 2 National Provider Identifier records belonging to each particular hospital/CCN Number. It is prepared by automation using the CoLoCode and hospital-specific taxonomy codes in a proprietary record-linkage system, and should not be relied upon as perfectly complete. NPI records are not rolled up to a company per se, but to a hospital entity occupying the physical location reported in the NPI record. It is possible that separate businesses own an NPI record ascribed to the hospital, such as a hospital-located clinical pharmacy, laboratory, or physician group, which could roll it up with the hospital's CCN.
Table Name Name Description Data Type Size
tAHD_Rollup_NPI>>CCN NPI NPI number found for hospital (algorithmically-derived *) Text 10
CCN Number assigned by Medicare to hospitals Text 10
HospName Legal Business Name of hospital CCN record Text 255
File: AuthoritativeHospitalDB_ServiceArea
The purpose of this file is to present the service area days of care, patient counts and payments by U.S. Zip Code.
Table Name Name Description Data Type Size
HospServiceArea CCN Number assigned by Medicare to hospitals Text 6
Zip_Hospital Hospital zip code Text 10
Zip_Patient Patient residence zip code Text 10
DaysOfCare Days of care provided to patients residing in Zip_Patient Long 4
TotalCharges Total charges for patients residing in Zip_Patient in Dollars Long 4
TotalCases Total cases for patients residing in Zip_Patient Long 4
MSA MSA of hospital location Text 5
Rural/Urban_Patient Patient is located in a Zip Code considered rural (R) or urban (U) Text 1
* Algorithmically-derived fields do not come from a federal source directly, but are derived using proprietary CarePrecise technology and should be expected to contain some incorrect data.

 

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,160 100.00% 86.54% 21.82% 86.54% 89.97% 62.74% 100.00% 96.75% 71.49% 54.29%
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,160 100.00% 86.54% 21.82% 86.54% 89.97% 62.74% 100.00% 96.75% 71.49% 54.29%
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 (.xlsx).

 

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 licensee 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