# CMS Care Compare Nursing Home (Provider Information) — 5-star quality

`medicare_silver.fact_nursing_home_quality` · Medicare Advantage, Part D, Medicaid · status live · 14,695 rows

CMS Care Compare Nursing Home Provider Information (wide per-facility): the 5-star ratings (overall / health-inspection / QM / long+short-stay / staffing), certified beds, ownership + chain, staffing hours-per-resident-per-day + turnover, deficiency/fine/penalty counts + geo. The nursing-home quality comparability dimension. ~14.7k facilities, curated ~45 of 99 columns.

**Grain.** One row per (reporting_year, nursing-home CCN) — 5-star ratings, beds, staffing, deficiencies.

| column | type | meaning |
|---|---|---|
| reporting_year | int |  |
| row_seq | bigint |  |
| ccn | string |  |
| provider_name | string |  |
| state | string |  |
| zip_code | string |  |
| county | string |  |
| urban | string |  |
| ownership_type | string |  |
| provider_type | string |  |
| resides_in_hospital | string |  |
| legal_business_name | string |  |
| date_first_approved | string |  |
| chain_name | string |  |
| chain_id | string |  |
| continuing_care_retirement_community | string |  |
| special_focus_status | string |  |
| abuse_icon | string |  |
| changed_ownership_12mo | string |  |
| sprinkler_all_required | string |  |
| certified_beds | double |  |
| avg_residents_per_day | double |  |
| facilities_in_chain | double |  |
| chain_avg_overall_5star | double |  |
| chain_avg_health_inspection | double |  |
| chain_avg_staffing | double |  |
| chain_avg_qm | double |  |
| overall_rating | double |  |
| health_inspection_rating | double |  |
| qm_rating | double |  |
| long_stay_qm_rating | double |  |
| short_stay_qm_rating | double |  |
| staffing_rating | double |  |
| nurse_aide_hprd | double |  |
| lpn_hprd | double |  |
| rn_hprd | double |  |
| licensed_hprd | double |  |
| total_nurse_hprd | double |  |
| weekend_total_nurse_hprd | double |  |
| rn_weekend_hprd | double |  |
| total_nursing_turnover | double |  |
| rn_turnover | double |  |
| administrators_left | double |  |
| total_weighted_health_survey_score | double |  |
| infection_control_citations | double |  |
| number_of_fines | double |  |
| total_fines_dollars | double |  |
| payment_denials | double |  |
| total_penalties | double |  |
| latitude | double |  |
| longitude | double |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_nursing_home_quality WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_nursing_home_quality")` first.