Compendium of U.S. Health Systems, 2023

December 2024 New File Announcement: System, Hospital, and Outpatient Site Linkage Files for 2023 have been added.

The Compendium of U.S. Health Systems is composed of 639 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-X: 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 Y-AI: Variables identifying the extent to which systems serve children, include teaching hospitals, serve a disproportionately high share of low-income and uninsured individuals, and offer insurance products.
• Columns AJ-AL: System ownership and the total and net revenues for the systems’ hospitals.

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

2023 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, 101 KB)
  • Compendium with searchable and sortable fields (XLS, 126 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 (1 MB)
  • CSV file (1.5 MB)
• Outpatient Site Linkage File (Users should download the file. Files are too large to preview online.)
  • Excel (42.2 MB)
• Technical Documentation
  • Technical Documentation (PDF, 1 MB)
  • Compendium Hospital Linkage File, Technical Documentation (PDF, 585 KB)
  • Compendium Outpatient Linkage File, Technical Documentation (PDF, 580 KB)