What each bundle holds
Every table includes a CSV file and a Parquet file with the same rows. A blank cell means the source published no value. Every bundle is rebuilt each week from the data the site publishes. The release date is in each README.
Hospital ownership and changes of owner
This dataset contains owners, private equity flags and changes of ownership for every hospital CMS enrolls. It uses the CMS enrollment, owner and change-of-ownership files.
Release: 2026-11-21. Download size: 0.5 MB.
Tables and rows
hospitals: 5,170owners: 11,360ownership_changes: 475
Data dictionary for the main table (hospitals)
| Column | Type | Meaning |
|---|---|---|
ccn | VARCHAR | CMS Certification Number of the hospital, six characters. |
legal_name | VARCHAR | Legal business name on the Medicare enrollment. |
dba_name | VARCHAR | Doing-business-as name on the enrollment, when CMS lists one. |
enrollment_state | VARCHAR | State of the Medicare enrollment. |
owner_rows | BIGINT | Number of owner rows CMS lists for the enrollment. |
individual_owners | BIGINT | Number of those owners that are people rather than organizations. |
private_equity_status | VARCHAR | CMS marks an organizational owner as flagged when it is a private equity company. The status is none_flagged when CMS answers no for every organizational owner. The status is missing when CMS left the answer blank. |
private_equity_organizations | BIGINT | Number of organizational owners the private equity answer covers. |
ownership_changes | BIGINT | Number of changes of ownership CMS records for the hospital since 2016-01-01. |
latest_change_date | DATE | Effective date of the most recent recorded change of ownership. |
First rows of the main table (hospitals)
| ccn | legal_name | dba_name | enrollment_state | owner_rows | individual_owners | private_equity_status | private_equity_organizations | ownership_changes | latest_change_date |
|---|---|---|---|---|---|---|---|---|---|
| 010001 | HOUSTON COUNTY HEALTHCARE AUTHORITY | SOUTHEAST HEALTH MEDICAL CENTER | AL | 18 | 0 | missing | 0 | ||
| 010005 | HH HEALTH SYSTEM - MARSHALL LLC | MARSHALL MEDICAL CENTERS | AL | 7 | 0 | none_flagged | 1 | 0 | |
| 010006 | RCHP - FLORENCE LLC | NORTH ALABAMA MEDICAL CENTER | AL | 11 | 0 | none_flagged | 4 | 0 |
Sources and file dates
- CMS Hospital Enrollments, 2026-10-01: https://data.cms.gov/sites/default/files/2026-10/961708ac-2136-43cb-9587-ac64af23b6ab/Hospital_Enrollments_2026.09.29.csv
- CMS Hospital All Owners, 2026-10-01: https://data.cms.gov/sites/default/files/2026-10/2517a8c1-44a2-4620-8d65-c72bfae27c3c/Hospital_All_Owners_2026.09.29.csv
- CMS Hospital Change of Ownership, 2026-09-01: https://data.cms.gov/sites/default/files/2026-10/f94c78c7-c3b0-4935-bc54-a1f4126703c0/Hospital_CHOW_2026.09.29.csv
Buy the journalist licence, $200 per dataset Buy the academic licence, $2,000 per dataset
CMS hospital quality measures and star ratings
This dataset holds the CMS overall star rating, complications and deaths, infections, maternal health, patient survey stars and patient survey answer percentages. It covers every hospital listed in the CMS general information file.
Release: 2026-11-21. Download size: 6.0 MB.
Tables and rows
hospitals: 5,435star_rating_groups: 27,175complications_and_deaths: 95,740infections: 28,722maternal_health: 17,945patient_survey_stars: 52,657patient_survey_answers: 373,386footnotes: 32
Data dictionary for the main table (hospitals)
| Column | Type | Meaning |
|---|---|---|
ccn | VARCHAR | CMS Certification Number of the hospital. |
name | VARCHAR | Hospital name as CMS publishes it. |
address | VARCHAR | Street address. |
city | VARCHAR | City. |
state | VARCHAR | State. |
zip | VARCHAR | ZIP code. |
county | VARCHAR | County. |
phone | VARCHAR | Phone number as published. |
hospital_type | VARCHAR | Hospital type as CMS publishes it. |
ownership | VARCHAR | Ownership category as CMS publishes it. |
emergency_services | VARCHAR | Whether the hospital provides emergency services, as published. |
birthing_friendly | VARCHAR | CMS birthing-friendly designation text, when published. |
overall_star_rating | BIGINT | CMS overall hospital star rating, 1 to 5. The field is empty when CMS publishes none. |
overall_star_rating_status | VARCHAR | Why the star rating is empty, when it is. |
overall_star_rating_footnote | VARCHAR | CMS footnote number for the star rating; see footnotes. |
patient_survey_stars | BIGINT | HCAHPS summary star rating, 1 to 5. |
patient_survey_stars_status | VARCHAR | Why the survey star rating is empty, when it is. |
patient_survey_stars_footnote | VARCHAR | CMS footnote number for the survey star rating. |
completed_surveys | BIGINT | Number of completed HCAHPS surveys. |
survey_response_rate_percent | DOUBLE | HCAHPS survey response rate in percent. |
First rows of the main table (hospitals)
| ccn | name | address | city | state | zip | county | phone | hospital_type | ownership | emergency_services | birthing_friendly | overall_star_rating | overall_star_rating_status | overall_star_rating_footnote | patient_survey_stars | patient_survey_stars_status | patient_survey_stars_footnote | completed_surveys | survey_response_rate_percent |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 010001 | SOUTHEAST HEALTH MEDICAL CENTER | 1108 ROSS CLARK CIRCLE | DOTHAN | AL | 36301 | HOUSTON | (334) 793-8701 | Acute Care Hospitals | Government - Hospital District or Authority | Yes | Y | 4 | 3 | 1977 | 18 | ||||
| 010005 | MARSHALL MEDICAL CENTERS | 2505 U S HIGHWAY 431 NORTH | BOAZ | AL | 35957 | MARSHALL | (256) 593-8310 | Acute Care Hospitals | Government - Hospital District or Authority | Yes | Y | 3 | 3 | 764 | 18 | ||||
| 010006 | NORTH ALABAMA MEDICAL CENTER | 1701 VETERANS DRIVE | FLORENCE | AL | 35630 | LAUDERDALE | (256) 768-8400 | Acute Care Hospitals | Proprietary | Yes | Y | 2 | 2 | 1754 | 17 |
Sources and file dates
- Healthcare Associated Infections - Hospital, Wed, 21 Oct 2026 16:33:41 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/43825e12dc0c923df9ba5cbdf473c9d5_1792599610/Healthcare_Associated_Infections-Hospital.csv
- Patient survey (HCAHPS) - Hospital, Wed, 21 Oct 2026 16:33:23 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/78a50346fbe828ea0ce2837847af6a7c_1792599592/HCAHPS-Hospital.csv
- Maternal Health - Hospital, Thu, 29 Oct 2026 16:10:44 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/a4ec69ec51849447e9631f61f696f938_1793289945/Maternal_Health-Hospital_2.csv
- Complications and Deaths - National, Wed, 21 Oct 2026 16:33:06 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/aba37eca11edcd4272afff9e6dc78bda_1792599558/Complications_and_Deaths-National.csv
- Hospital General Information, Tue, 27 Oct 2026 00:10:57 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/d3bf87c5505155f549d603688414f3c6_1793059553/Hospital_General_Information_2.csv
- Footnote Crosswalk, Thu, 16 Oct 2025 16:10:27 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/f29bb7c812e242f6edfef0a4b7d0eaca_1760630713/Footnote_Crosswalk.csv
- Complications and Deaths - Hospital, Wed, 21 Oct 2026 16:33:01 GMT: https://data.cms.gov/provider-data/sites/default/files/resources/6af7c44d77436e5a1caac3ce39a83fe9_1792599556/Complications_and_Deaths-Hospital.csv
Buy the journalist licence, $200 per dataset Buy the academic licence, $2,000 per dataset
Doctor ratings with the method
OpenHealth publishes every doctor score for knee replacement, hip replacement, bypass surgery, stents and hysterectomy. Each score includes the range, the label, the affiliated hospitals behind the score and the test results of each model.
Release: 2026-11-21. Download size: 1.5 MB.
Tables and rows
doctor_scores: 16,277doctor_score_hospitals: 32,556procedures: 5
Data dictionary for the main table (doctor_scores)
| Column | Type | Meaning |
|---|---|---|
npi | VARCHAR | National Provider Identifier of the doctor. |
name | VARCHAR | Name as the CMS clinician file publishes it. The field is empty when the file does not name the NPI. |
credential | VARCHAR | Credential from the CMS clinician file. |
procedure | VARCHAR | Procedure slug used on getopenhealth.org. |
procedure_title | VARCHAR | Procedure name. |
measure | VARCHAR | CMS hospital outcome measure the score predicts. |
score_percent | BIGINT | Predicted result at the hospitals the doctor is affiliated with, in whole percent below (negative) or above (positive) the national rate. Lower is better. |
interval_low | BIGINT | Low end of the 80% range of the score. |
interval_high | BIGINT | High end of the 80% range of the score. |
label | VARCHAR | better means a lower predicted rate, near means near the national rate, and higher means a higher predicted rate. |
national_rate | DOUBLE | National rate of the measure. |
unit | VARCHAR | Unit of the national rate. |
yearly_operating_count | DOUBLE | Doctor's average yearly count as the operating clinician in Medicare billing over the years shown. |
first_year | BIGINT | First Medicare billing year used. |
last_year | BIGINT | Last Medicare billing year used. |
affiliated_hospitals | BIGINT | Number of affiliated hospitals with a prediction behind the score. |
listable | BOOLEAN | This is true when getopenhealth.org may list the doctor for the procedure. A doctor labelled higher is never listed. |
model | VARCHAR | Model version. |
First rows of the main table (doctor_scores)
| npi | name | credential | procedure | procedure_title | measure | score_percent | interval_low | interval_high | label | national_rate | unit | yearly_operating_count | first_year | last_year | affiliated_hospitals | listable | model |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1003000639 | PEYMAN BENHARASH | MD | heart-bypass | Coronary artery bypass grafting | MORT_30_CABG | -7 | -49 | 36 | near | 2.3 | % | 9.3 | 2022 | 2024 | 3 | True | ml-4 |
| 1003077728 | CLAYTON A KAISER | MD | heart-bypass | Coronary artery bypass grafting | MORT_30_CABG | -15 | -52 | 22 | near | 2.3 | % | 82.7 | 2022 | 2024 | 2 | True | ml-4 |
| 1003201260 | WILLIAM Z CHANCELLOR | MD | heart-bypass | Coronary artery bypass grafting | MORT_30_CABG | -1 | -40 | 39 | near | 2.3 | % | 3.7 | 2022 | 2024 | 2 | True | ml-4 |
Sources and file dates
- OpenHealth doctor scores, model ml-4, 2026-11-21: https://getopenhealth.org/method
- CMS Doctors and Clinicians National Downloadable File (names and credentials), 2026-11-12: https://data.cms.gov/provider-data/dataset/mj5m-pzi6
Buy the journalist licence, $200 per dataset Buy the academic licence, $2,000 per dataset
Nursing homes
This dataset contains CMS star ratings, inspection citations, penalties, payroll staffing and owners for every nursing home in the CMS provider file.
Release: 2026-11-21. Download size: 14.6 MB.
Tables and rows
homes: 14,686citations: 418,682penalties: 15,007staffing_quarters: 115,456owners: 43,256
Data dictionary for the main table (homes)
| Column | Type | Meaning |
|---|---|---|
ccn | VARCHAR | CMS Certification Number of the nursing home. |
name | VARCHAR | Provider name. |
legal_name | VARCHAR | Legal business name. |
address | VARCHAR | Street address. |
city | VARCHAR | City. |
state | VARCHAR | State. |
zip | VARCHAR | ZIP code. |
county | VARCHAR | County. |
phone | VARCHAR | Phone number as published. |
lat | DOUBLE | Latitude CMS publishes. |
lon | DOUBLE | Longitude CMS publishes. |
beds | BIGINT | Certified beds. |
residents | DOUBLE | Average residents per day. |
provider_type | VARCHAR | Medicare, Medicaid or both. |
ownership_type | VARCHAR | Ownership type as published. |
chain | VARCHAR | Chain name, when CMS lists one. |
in_hospital | BOOLEAN | This is true when the home is inside a hospital. |
continuing_care_community | BOOLEAN | This is true when the home is part of a continuing care retirement community. |
special_focus | VARCHAR | CMS special focus facility status, when published. |
first_approved | DATE | Date first approved to participate. |
changed_owner_last_12_months | BOOLEAN | CMS flag for a change of owner in the last 12 months. |
abuse_icon | BOOLEAN | CMS abuse icon flag. |
rating_overall | BIGINT | CMS overall star rating, 1 to 5. |
rating_inspections | BIGINT | Health inspection star rating. |
rating_quality | BIGINT | Quality measure star rating. |
rating_staffing | BIGINT | Staffing star rating. |
rating_long_stay | BIGINT | Long-stay quality star rating. |
rating_short_stay | BIGINT | Short-stay quality star rating. |
nurse_hours_per_resident_day | DOUBLE | Reported total nurse staffing hours per resident per day. |
rn_hours_per_resident_day | DOUBLE | Reported registered nurse hours per resident per day. |
weekend_nurse_hours_per_resident_day | DOUBLE | Reported weekend total nurse hours per resident per day. |
weekend_rn_hours_per_resident_day | DOUBLE | Reported weekend registered nurse hours per resident per day. |
nursing_turnover_percent | DOUBLE | Total nursing staff turnover in percent. |
rn_turnover_percent | DOUBLE | Registered nurse turnover in percent. |
last_inspection_date | DATE | Date of the most recent standard health inspection. |
last_inspection_deficiencies | BIGINT | Deficiencies cited at that inspection. |
complaint_deficiencies | BIGINT | Complaint deficiencies in the CMS summary. |
penalties | BIGINT | Penalties in the last three years. |
fines | BIGINT | Fines in the last three years. |
fines_dollars | DOUBLE | Total fines in dollars. |
payment_denials | BIGINT | Payment denials. |
private_equity_status | VARCHAR | The status is flagged, none_flagged or missing, based on the CMS owner file answers. |
cms_processing_date | DATE | CMS processing date of the provider file. |
First rows of the main table (homes)
| ccn | name | legal_name | address | city | state | zip | county | phone | lat | lon | beds | residents | provider_type | ownership_type | chain | in_hospital | continuing_care_community | special_focus | first_approved | changed_owner_last_12_months | abuse_icon | rating_overall | rating_inspections | rating_quality | rating_staffing | rating_long_stay | rating_short_stay | nurse_hours_per_resident_day | rn_hours_per_resident_day | weekend_nurse_hours_per_resident_day | weekend_rn_hours_per_resident_day | nursing_turnover_percent | rn_turnover_percent | last_inspection_date | last_inspection_deficiencies | complaint_deficiencies | penalties | fines | fines_dollars | payment_denials | private_equity_status | cms_processing_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 015009 | BURNS NURSING HOME, INC. | BURNS NURSING HOME, INC. | 701 MONROE STREET NW | RUSSELLVILLE | AL | 35653 | Franklin | 2563324110 | 34.5149 | -87.736 | 57 | 50.0 | Medicare and Medicaid | For profit - Corporation | False | False | 1969-09-01 | False | False | 2 | 2 | 4 | 4 | 5 | 3 | 3.95 | 0.91 | 3.18 | 0.52 | 41.8 | 28.6 | 2023-03-02 | 4 | 0 | 0 | 0 | 0.0 | 0 | missing | 2026-10-01 | ||
| 015010 | COOSA VALLEY HEALTHCARE CENTER | COOSA VALLEY HEALTHCARE CENTER LLC | 260 WEST WALNUT STREET | SYLACAUGA | AL | 35150 | Talladega | 2562495604 | 33.1637 | -86.254 | 85 | 75.1 | Medicare and Medicaid | For profit - Corporation | {'homes': 5, 'id': '419', 'name': 'PRIME HEALTH CARE ENTERPRISES', 'overall': 4.2} | False | False | 1967-01-01 | False | False | 5 | 5 | 2 | 5 | 3 | 1 | 4.35 | 0.88 | 3.55 | 0.4 | 44.9 | 8.3 | 2022-04-09 | 0 | 0 | 0 | 0 | 0.0 | 0 | none_flagged | 2026-10-01 | |
| 015012 | HIGHLANDS HEALTH AND REHAB | HH HEALTH SYSTEM - JACKSON LLC | 380 WOODS COVE ROAD | SCOTTSBORO | AL | 35768 | Jackson | 2562183708 | 34.6611 | -86.047 | 50 | 44.7 | Medicare and Medicaid | Government - County | {'homes': 3, 'id': '610', 'name': 'HUNTSVILLE HOSPITAL HEALTH SYSTEM', 'overall': 3.0} | False | False | 1967-01-01 | False | False | 5 | 4 | 5 | 5 | 5 | 5 | 4.7 | 1.17 | 3.73 | 0.56 | 39.3 | 41.7 | 2022-03-24 | 0 | 0 | 0 | 0 | 0.0 | 0 | none_flagged | 2026-10-01 |
Sources and file dates
- Nursing Home Provider Information, 2026-10-01: https://data.cms.gov/provider-data/sites/default/files/resources/0970c657767e40f8521187d02ba8d0ed_1792181744/NH_ProviderInfo_Oct2026.csv
- Nursing Home Health Deficiencies, 2026-10-01: https://data.cms.gov/provider-data/sites/default/files/resources/327fc64eff7ccc64fd7d23c853bb1ade_1792181729/NH_HealthCitations_Oct2026.csv
- Nursing Home Penalties, 2026-10-01: https://data.cms.gov/provider-data/sites/default/files/resources/4d0e526b8cf3d0b78294803291483073_1792181741/NH_Penalties_Oct2026.csv
- Nursing Home State and US Averages, 2026-10-01: https://data.cms.gov/provider-data/sites/default/files/resources/e0c4bde60d7ad96dcb0e011dbb182112_1792181753/NH_StateUSAverages_Oct2026.csv
- CMS Skilled Nursing Facility Enrollments, 2026-10-01: https://data.cms.gov/sites/default/files/2026-10/4674b04e-948d-45c6-b70e-2ad30b3e7b0d/SNF_Enrollments_2026.09.29.csv
- CMS Skilled Nursing Facility All Owners, 2026-10-01: https://data.cms.gov/sites/default/files/2026-10/f60332c1-eab0-49b8-a4be-55c1b3da4449/SNF_All_Owners_2026.09.29.csv
- CMS Skilled Nursing Facility Change of Ownership, 2026-09-01: https://data.cms.gov/sites/default/files/2026-10/89166aa5-0fb8-49d6-bef5-f970876794b5/SNF_CHOW_2026.09.29.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2024Q3, 2024Q3: https://data.cms.gov/sites/default/files/2025-01/0e5403bd-0ae6-4177-b2fa-ecd9e0944316/PBJ_dailynursestaffing_CY2024Q3.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2024Q4, 2024Q4: https://data.cms.gov/sites/default/files/2025-04/4f8bee34-7c03-4bda-9ed9-756db4200310/PBJ_dailynursestaffing_CY2024Q4.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2025Q1, 2025Q1: https://data.cms.gov/sites/default/files/2025-07/e8e9efa9-9498-4286-a31c-ed4e5548a30c/PBJ_dailynursestaffing_CY2025Q1.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2025Q2, 2025Q2: https://data.cms.gov/sites/default/files/2025-10/0fd38f13-e99e-4b2f-8162-50603c89966d/PBJ_dailynursestaffing_CY2025Q2.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2025Q3, 2025Q3: https://data.cms.gov/sites/default/files/2026-01/13db0b58-0df6-4288-8567-fc2a4f6ba415/PBJ_dailynursestaffing_CY2025Q3.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2025Q4, 2025Q4: https://data.cms.gov/sites/default/files/2026-04/8f85c7d4-a1f6-4b36-ad20-17abc8aa57d2/PBJ_dailynursestaffing_CY2025Q4.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2026Q1, 2026Q1: https://data.cms.gov/sites/default/files/2026-06/5c2f045b-7246-457a-9fac-c7fb92f7c352/PBJ_dailynursestaffing_CY2026Q1.csv
- CMS Payroll Based Journal Daily Nurse Staffing 2026Q2, 2026Q2: https://data.cms.gov/sites/default/files/2026-10/80764db3-e543-4584-8d8b-a0bba30e703b/PBJ_dailynursestaffing_CY2026Q2.csv
Buy the journalist licence, $200 per dataset Buy the academic licence, $2,000 per dataset
Prices
Each group has one posted price. OpenHealth does not provide quotes or sales calls.
Journalist licence
$200 per dataset
A working journalist or one newsroom can use this licence for published reporting.
Academic licence
$2,000 per dataset
One research group at a university or nonprofit can use this licence for research, teaching and publication.
Commercial licence
$5,000 a year for all four datasets
One company can use this licence internally and inside its own products and services.
After payment, you receive download links by email. The links stop working after a set time, so save the files when they arrive.
The licence terms in plain words
- The underlying CMS records are US government works with no copyright. The licence covers OpenHealth's compiled and cleaned files and its doctor scores.
- The journalist licence lets you publish stories, charts and tables built from the files, and quote rows. Credit OpenHealth and the original source. Do not post or pass on the full files.
- The academic licence lets you use the files for research, teaching and papers, and share them with collaborators on the same project. Cite OpenHealth and the original source. No commercial use and no public posting of the full files.
- Commercial licence: You can use the files inside your company and in your own products. You can show figures from the files to your customers. Do not resell the files as a dataset. The licence is a yearly subscription. While the licence is active, the page at /account/recover gives download links to the newest release. The licence includes every weekly release in your year.
- Every licence requires you to keep the source notes with any figure you publish. A doctor score describes the doctor's affiliated hospitals, not the doctor alone, and you must describe it that way.
- The files contain public records as published, with no warranty. Report a wrong figure at /corrections.
What is not for sale
The site shows hospital price files, insurer negotiated rates, the Oregon payment report, HCUP figures and state surgeon reports, but no bundle includes them. Their terms do not allow resale, or nobody has checked that they do.
Patients never pay for OpenHealth, and the public site stays free. No rating, placement, order or badge is for sale. A purchase changes nothing on the site.