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.

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.

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
Subscriptions:

1 Year Quarterly Updates: $2,023

1 Year Monthly Updates: $4,551

2 Years Quarterly: $3,641

2 Years Monthly: $8,192

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

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
Subscriptions:

1 Year Quarterly Updates: $2,023

1 Year Monthly Updates: $4,551

2 Years Quarterly: $3,641

2 Years Monthly: $8,192

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