Healthcare / hospital reference / DOCUMENTED CSV
Hospital Facility & Quality Reference
Add hospital names, locations, facility types, ownership and CMS quality context to a research portfolio. Includes a separate patient-experience table with observation periods, score statuses and explained footnotes.
CMS files released August 13, 2026 · HCAHPS period October 2024–September 2025 · fixed edition
01 / KNOW THE FIT
A useful join starts
with a clear meaning.
What you can do with it
Enrich hospital research lists, provider-market studies or regional service plans with facility attributes and selected patient-experience measures. Start from CMS facility IDs and compare the same survey question and observation period across your portfolio.
What one row means
The main table has one row per CMS facility ID. Patient experience is a separate table with one row per facility, measure and observation period. A measure identifies a specific answer category, linear mean or survey-star score; the hospital overall rating remains a separate attribute.
Unique keyfacility_id
How to join it
Import facility_id and ZIP codes as text, preserving zeros and letter suffixes. Filter patient_experience.csv to your measure_id and period_start/period_end before joining for one row per hospital. Keep longer relationships deliberately when analyzing multiple measures. CMS facility IDs are not NPIs.
Coverage, with the edges visible
All 5,419 facilities in the retained CMS General Information file. Of these, 3,174 have overall ratings and 2,245 do not. The HCAHPS table contains 325,720 observations: 68 measures for each of 4,790 facilities, including unavailable results. The remaining 629 facilities are absent from that survey file. The published scope includes the states, territories and hospital types present in CMS’s files.
Keep in mind
- This is a dated CMS edition, not a live hospital directory. Published ownership and contact details are retained as supplied, without independent current verification.
- Overall hospital stars, patient-survey stars, answer percentages and linear means are different measures. The overall rating combines domains with different measurement periods; it does not inherit the survey period.
- Unavailable and inapplicable values remain distinct from zero. Footnotes may qualify published scores. Completed-survey counts and response rates repeat across measures; do not sum them across survey rows.
- No NPI crosswalk, county-FIPS assignment, geocoding, historical facility mergers, individual patient data or full set of underlying CMS quality measures is included. County names and ZIPs alone do not establish a geographic join.
Keeps the facility and survey grains separate; verifies every survey’s parent and repeated facility attributes; preserves identifier text; standardizes observation dates; adds blank-safe numeric fields, explicit statuses and original cells; resolves CMS footnotes. Independent acceptance compares every delivered source-derived field with the original CSVs. Retained raw, staging and preparation layers support offline reprocessing. How we prepare and version our data →
02 / TRY THE SHAPE
Real rows. Before you buy.
These are the first three rows from the delivered CSV, showing 6 of 18 fields. The free download contains the first five rows and all 18 fields; it is a format sample, not a coverage test.
| facility_id | facility_name | state | hospital_type | overall_rating | overall_rating_status |
|---|---|---|---|---|---|
| 010001 | SOUTHEAST HEALTH MEDICAL CENTER | AL | Acute Care Hospitals | 4 | published |
| 010005 | MARSHALL MEDICAL CENTERS | AL | Acute Care Hospitals | 3 | published |
| 010006 | NORTH ALABAMA MEDICAL CENTER | AL | Acute Care Hospitals | 2 | published |
03 / NO GUESSING
Main table fields, explained.
The main table’s field dictionary from the current download. CSV has no built-in types; these are the intended import types.
| Field | Type | Meaning |
|---|---|---|
facility_id | string | CMS six-character facility identifier, preserved as text, including leading zeros and letter suffixes. This is not an NPI. |
facility_name | string | CMS published facility name; original case retained. |
address | string | CMS street address, unchanged; not geocoded or independently verified. |
city | string | Published city/town label. |
state | string | Published two-letter state/territory label. |
zip_code | string | Published ZIP identifier preserved as text; not a county or Census ZCTA crosswalk. |
county_name | string | Published county/parish label, not a county FIPS code. |
telephone | string | Published facility telephone string, unchanged. |
hospital_type | string | CMS hospital category, including acute, critical access, psychiatric and federal facilities. |
ownership | string | CMS ownership category exactly as supplied; not independently researched corporate ownership. |
emergency_services | string | CMS Yes/No emergency-services indicator. |
birthing_friendly_source | string | Original CMS Y or blank designation field. Blank is not converted to No. |
overall_rating | integer | Published overall hospital star rating 1–5; blank when unavailable. Different from a patient survey rating. |
overall_rating_status | string | published or not_available; unavailable never becomes zero. |
overall_rating_source | string | Original CMS rating cell, including Not Available. |
overall_rating_footnote_codes | string | Original comma-separated CMS footnote codes, including whitespace. |
overall_rating_footnote_text | string | CMS explanations joined in source-code order with |; blank if no footnote. |
source_row | integer | One-based row number in retained Hospital General Information, excluding header. |
04 / INSIDE THE DOWNLOAD
Data, with its context.
One ZIP · 6.3 MB · 18 files. No account or subscription required.
README.mdImport guidance, method, attribution, and limitationsacceptance.jsonIndependent original-source cell and coverage checksall_tables_dictionary.jsonField types and definitions for all five tableschecksums.jsonSHA-256 checksums for the release filesdata_dictionary.jsonTypes and definitions for every fieldexample.pyNotebook-compatible hospital portfolio joinexample_input.csvFictional project labels paired with real CMS facility IDsexample_output.txtChecked printed outputexample_result.csvChecked portfolio with names, ratings, survey result, periods and footnotesfacilities.csvMain prepared table · UTF-8 CSVfootnotes.csvCMS explanatory footnote codes and textmeasures.csvOne definition per HCAHPS measure, including its applicable result typemetadata.jsonSource provenance, production time, counts, and CSV checksumpatient_experience.csvAll facility / HCAHPS measure / period observations, with values, original cells, statuses and footnotesprovenance.jsonRetained source identifiers, URLs and file checksumsquality_report.jsonCoverage, missingness and product-specific quality checksrevision.jsonChanges and free-upgrade eligibility for this ACD revisionsource_row_status.csvEvery facility and survey source row accounted for
05 / DATES THAT MEAN SOMETHING
Sources, versions & changes.
Source versions identify the inputs. Our processing revision describes how we prepare them. Either kind of change creates a new ACD release; the package date records when it was built.
Current source versions
- CMS dataset release date
- August 13, 2026 — both selected datasets
- CMS dataset modified date
- July 22, 2026
- HCAHPS observation period
- October 1, 2024–September 30, 2025
- Overall-rating observation periods
- Multiple measure-specific periods; not the HCAHPS period
- ACD source capture
- October 17, 2026
- ACD preparation revision
- 1 · separate facility and survey tables
- Package prepared (UTC)
- CMS Hospital General Information
- CMS Patient survey (HCAHPS) - Hospital
- CMS hospital dictionary and public-domain reuse statement
Source: Centers for Medicare & Medicaid Services. The original public reporting data are freely available in the public domain. ACD sells preparation, validation and documentation. Independent preparation; no CMS endorsement.
RELEASE HISTORY
Oct 17, 2026 · current package (UTC)
First ACD release of these retained CMS inputs: facilities, patient experience, measure definitions, footnotes and source-row accounting, with dictionaries, provenance, independent acceptance and a checked Python example. No prior ACD release comparison is claimed.
Hospital reference: source and preparation recordProcessing corrections and improvements for your purchased source edition are free. Genuinely new source editions may be sold separately. See the update policy and access instructions.
Check the downloaded CSV’s integrity
The metadata file inside the ZIP records this SHA-256 checksum for facilities.csv. A matching checksum confirms identical CSV bytes.
fac7d180b42e0f1314fd77514c472da1a2ebe6691c51dfbdd99034bc74df721cREADY TO PUT IT TO WORK?
Hospital Facility & Quality Reference
$29 USD · one time · 5,419 hospital facility records