The Authoritative Hospital Database™
Current data update released January 17, 2023
7,000+ Hospitals, with ownership status, health system, employee count, patient satisfaction ratings, bed count, contact name, address, phone, fax, Placekey, and more.
This is the best-in-class hospital database that brings you deep information on U.S. HIPAA-covered hospitals with their health systems, HCAHPS patient satisfaction data, contacts, NPI-to-CCN rollup, service areas, bed counts, employment levels, payments, and more, into 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.
A comprehensive database of U.S. hospital information.
Extracted from the CarePrecise master provider database with information on all of the 7.3 million HIPAA-covered US healthcare providers, the Authoritative Hospital Database (AHD) contains records for all U.S. 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 85% of hospitals, full contact information on 87%, and fax numbers for 62% and NPI numbers for 87%. We include detailed patient satisfaction data, employee counts, and medical procedure volumes, as well as per-hospital service volumes by Zip Code.
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.
Hospital Service Areas
The AHD includes data on the number of patient cases served in each Zip Code, the total Medicare charges per Zip, along with the total days of care. View the reach and patient load, and calculate total Medicare revenues and cases per hospital.
Health Systems
View the health systems with their hospitals, total number of residents, number of system primary care physicians, number of affiliated practice groups, number of acute care hospitals, number of beds, and total discharges (patients) per system. See which systems have a high level of uncompensated care, and which are primarily owned by private investors.
Hospital NPI to CCN Rollup
CarePrecise Exclusive: Using advanced record-linkage technology, the AHD includes a crosswalk from CCN to NPI 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 specific facility types, as well as separate contact names. To get the most from this powerful new feature, you'll also want the CarePrecise Advanced dataset, which contains all of the publicly available NPI registry data and hospital affiliations of individual clinicians.
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:
$939
Subscriptions:
1 Year Quarterly Updates:
$2,113
1 Year Monthly Updates:
$4,754
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...
Click for a printer-friendly version of the fields list...
| Table Name | Name | Description | Data Type | Size |
| Analysis_Hospital | CCN | Number assigned by Medicare to hospitals - the unique identifier for hospitals | Text | 6 |
| NPI | Number assigned to all HIPAA-covered providers - hospitals may have several NPI numbers | 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/CBSA | MSA/CBSA 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 where available. 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: 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
For Hospitals: Approximate data population in a selection of the AHD fields:
| Hospitals | CCN | NPI | EIN | Contact Name | Phone Number | Fax | Street Address | Bed Count | Procedure Volume | Patient Satisfaction Ratings | Decision Makers |
| 8,113 | 100.00% | 77.31% | 16.60% | 76.63% | 88.18% | 55.75% | 100.00% | 74.07% | 42.72% | 43.57% | 5,424 |
| 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 CCN unique identifier. | |||||||||||
For All Included Facilities: Approximate data population in a selection of AHD fields:
| All Medical Facilities |
Non-Hospital Facilities |
CCN | NPI | Contact Name | Phone Number | Fax | Street Address | Bed Count (Hospitals) |
Patient Satisfaction Ratings | Decision Makers |
| 51,595 | 43,482 | 100.00% | 24.49% | 24.39% | 95.31% | 18.56% | 100.00% | 74.07% | 49.50% | 11,100 |
| 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 CCN unique identifier. | ||||||||||
For a mobile-friendly view of all 67 AHD data fields, touch here.
Data Contents
Approximate data population in a selection of the AHD fields
Swipe left to view all...
| Hospitals | CCN | NPI | EIN | Contact Name | Phone Number | Fax | Street Address | Bed Count | Procedure Volume | Patient Satisfaction Ratings | Decision Makers |
| 51,217 | 100.00% | 23.24% | 2.70% | 23.13% | 95.27% | 17.71% | 100.00% | 41.37% | 6.77% | 49.87% | 10,483 |
| 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 for subscribers. See support details.
SAMPLE DATA
Download sample data at this link.
PACKAGES
Single Download:
$939
Subscriptions:
1 Year Quarterly Updates:
$2,113
1 Year Monthly Updates:
$4,754
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