Compendium of U.S. Health Systems, 2022

December 2024 New File Announcement: Group Practice Linkage File for 2022 has been added. 

August 2024 New File Announcement: Outpatient Site, Nursing Home, and Home Health Organization Linkage files for 2022 have been added.

The Compendium of U.S. Health Systems is composed of 640 U.S. health systems, defined in this analysis to include at least one hospital and at least one group of physicians providing comprehensive care, and who are connected with each other and with the hospital through common ownership or joint management.

The Compendium database includes:

• Columns A-D: System identification number (a unique number assigned by AHRQ), name, home office city, and State.
• Columns E-H: Indicators of which data source identified the health system and health system identification numbers in the originating data source.
• Columns I-R: Total counts of system hospitals, physician groups, physicians, primary care physicians, physician assistants, nurse practitioners, nurses, nursing homes, and the extent to which systems own or manage hospitals in multiple States, total acute care beds, discharges, and residents.
• Columns S-AD: Variables identifying the extent to which systems include investor-owned hospitals, serve children, include teaching hospitals, serve a disproportionately high share of low-income and uninsured individuals, and offer insurance products.

If you would like to report a possible data discrepancy, please email CHSP@ahrq.hhs.gov.

2022 Compendium Files

• System File—Your computer should automatically prompt you to open the file in a spreadsheet application to view the data.
  • Compendium of U.S. Health Systems (CSV, 98 KB)
  • Compendium with searchable and sortable fields (XLS, 119 KB)
• Hospital Linkage File—We recommend that Excel users download only the Excel version of the file. If Excel is used to open the CSV file, the program will automatically drop the zeros in fields with leading zeros.
  • Excel (950 KB)
  • CSV file (1 MB)
• Nursing Home Linkage File—We recommend that Excel users download only the Excel version of the file. If Excel is used to open the CSV file, the program will automatically drop the zeros in fields with leading zeros.
  • Excel (1.4 MB)
  • CSV (2 MB)
• Home Health Care Organization Linkage File—We recommend that Excel users download only the Excel version of the file. If Excel is used to open the CSV file, the program will automatically drop the zeros in fields with leading zeros.
  • Excel (1.2 MB)
  • CSV (1.6 MB)
• Outpatient Site Linkage File (Users should download the file. Files are too large to preview online.)
  • Excel (42.4 MB)
• New December 2024: Group Practice Linkage File—We recommend that Excel users download only the Excel version of the file. If Excel is used to open the CSV file, the program will automatically drop the zeros in fields with leading zeros. 
  • Excel (2 MB) 
  • CSV (3.3 MB)  
• Technical Documentation
  • Technical Documentation (PDF, 970 KB)
  • Compendium Hospital Linkage File, Technical Documentation (PDF, 484 KB)
  • Compendium Nursing Home Linkage File, Technical Documentation (PDF, 726 KB)
  • Compendium Home Health Care Linkage File, Technical Documentation (PDF, 929 KB)
  • Compendium Outpatient Linkage File, Technical Documentation (PDF, 449 KB)
  • Compendium Group Practice Linkage File, Technical Documentation (PDF, 1.6 MB)