Compendium of U.S. Health Systems, 2023
September 2025 New File Announcement: 2023 Nursing Home and Home Health Care Organization Files and an updated version of the 2023 System File with Medicare Advantage plan ownership variables 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-AK: 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 AL-AN: 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, 112 KB)
- Compendium with searchable and sortable fields (XLS, 129 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.
- Outpatient Site Linkage File (Users should download the file. Files are too large to preview online.)
- Excel (42 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.
- 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.
- Technical Documentation
- Technical Documentation (PDF, 1 935 KB)
- Compendium Hospital Linkage File, Technical Documentation (PDF, 585 KB)
- Compendium Outpatient Linkage File, Technical Documentation (PDF, 580 KB)
- Compendium Nursing Home Linkage File, Technical Documentation (PDF, 392 KB)
- Compendium Home Health Care Linkage File, Technical Documentation (PDF, 399 KB)