# CMS Care Compare Home Health Agencies — per-agency quality

`medicare_silver.fact_home_health_quality` · Medicare Advantage, Part D, Medicaid · status live · 12,392 rows

CMS Care Compare Home Health Agencies (wide per-agency): identity + ownership + service-offering flags + patient-care star rating + key quality-measure rates + DTC/PPR/PPH risk-standardized rates + Medicare spending ratio. The home-health quality comparability dimension. ~12.4k agencies, curated ~30 of 96 columns.

**Grain.** One row per (reporting_year, home-health agency CCN) — star rating, measure rates, DTC/PPR/PPH, spending.

| column | type | meaning |
|---|---|---|
| reporting_year | int |  |
| row_seq | bigint |  |
| ccn | string |  |
| provider_name | string |  |
| state | string |  |
| zip_code | string |  |
| type_of_ownership | string |  |
| certification_date | string |  |
| offers_nursing | string |  |
| offers_physical_therapy | string |  |
| offers_occupational_therapy | string |  |
| offers_speech_pathology | string |  |
| offers_medical_social | string |  |
| offers_home_health_aide | string |  |
| dtc_performance | string |  |
| ppr_performance | string |  |
| pph_performance | string |  |
| quality_star_rating | double |  |
| timely_care | double |  |
| flu_shot | double |  |
| better_walking | double |  |
| better_bed | double |  |
| better_bathing | double |  |
| breathing_improved | double |  |
| better_oral_meds | double |  |
| pressure_ulcer | double |  |
| med_issues_timely | double |  |
| falls_major_injury | double |  |
| discharge_function_score | double |  |
| transfer_hinfo_provider | double |  |
| transfer_hinfo_patient | double |  |
| dtc_risk_std_rate | double |  |
| ppr_risk_std_rate | double |  |
| pph_risk_std_rate | double |  |
| medicare_spending_ratio | 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_home_health_quality WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_home_health_quality")` first.