Two datasets from public data provided the Centers for Medicare & Medicaid Services, https://data.cms.gov.
cms_patient_experience contains some lightly cleaned data from
"Hospice - Provider Data", which provides a list of hospice agencies
along with some data on quality of patient care,
https://data.cms.gov/provider-data/dataset/252m-zfp9.
cms_patient_care "Doctors and Clinicians Quality Payment Program PY 2020
Virtual Group Public Reporting",
https://data.cms.gov/provider-data/dataset/8c70-d353
cms_patient_experience
cms_patient_carecms_patient_experience is a data frame with 500 observations and
five variables:
Organisation ID and name
Measure code and title
Measure performance rate
cms_patient_care is a data frame with 252 observations and
five variables:
Facility ID and name
Abbreviated measurement title, suitable for use as variable name
Measure score
Whether score refers to the rating out of 100 ("observed"), or the maximum possible value of the raw score ("denominator")
cms_patient_experience %>%
dplyr::distinct(measure_cd, measure_title)
#> # A tibble: 6 × 2
#> measure_cd measure_title
#> <chr> <chr>
#> 1 CAHPS_GRP_1 CAHPS for MIPS SSM: Getting Timely Care, Appointments, and Infor…
#> 2 CAHPS_GRP_2 CAHPS for MIPS SSM: How Well Providers Communicate
#> 3 CAHPS_GRP_3 CAHPS for MIPS SSM: Patient's Rating of Provider
#> 4 CAHPS_GRP_5 CAHPS for MIPS SSM: Health Promotion and Education
#> 5 CAHPS_GRP_8 CAHPS for MIPS SSM: Courteous and Helpful Office Staff
#> 6 CAHPS_GRP_12 CAHPS for MIPS SSM: Stewardship of Patient Resources
cms_patient_experience %>%
pivot_wider(
id_cols = starts_with("org"),
names_from = measure_cd,
values_from = prf_rate
)
#> # A tibble: 95 × 8
#> org_pac_id org_nm CAHPS_GRP_1 CAHPS_GRP_2 CAHPS_GRP_3 CAHPS_GRP_5 CAHPS_GRP_8
#> <chr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl>
#> 1 0446157747 USC C… 63 87 86 57 85
#> 2 0446162697 ASSOC… 59 85 83 63 88
#> 3 0547164295 BEAVE… 49 NA 75 44 73
#> 4 0749333730 CAPE … 67 84 85 65 82
#> 5 0840104360 ALLIA… 66 87 87 64 87
#> 6 0840109864 REX H… 73 87 84 67 91
#> 7 0840513552 SCL H… 58 83 76 58 78
#> 8 0941545784 GRITM… 46 86 81 54 NA
#> 9 1052612785 COMMU… 65 84 80 58 87
#> 10 1254237779 OUR L… 61 NA NA 65 NA
#> # ℹ 85 more rows
#> # ℹ 1 more variable: CAHPS_GRP_12 <dbl>
cms_patient_care %>%
pivot_wider(
names_from = type,
values_from = score
)
#> # A tibble: 126 × 5
#> ccn facility_name measure_abbr denominator observed
#> <chr> <chr> <chr> <dbl> <dbl>
#> 1 011500 BAPTIST HOSPICE beliefs_add… 202 100
#> 2 011500 BAPTIST HOSPICE composite_p… 202 88.1
#> 3 011500 BAPTIST HOSPICE dyspena_tre… 110 99.1
#> 4 011500 BAPTIST HOSPICE dyspnea_scr… 202 100
#> 5 011500 BAPTIST HOSPICE opioid_bowel 61 100
#> 6 011500 BAPTIST HOSPICE pain_assess… 107 100
#> 7 011500 BAPTIST HOSPICE pain_screen… 202 88.6
#> 8 011500 BAPTIST HOSPICE treat_pref 202 100
#> 9 011500 BAPTIST HOSPICE visits_immi… 232 96.1
#> 10 011501 SOUTHERNCARE NEW BEACON N. BIRMINGH… beliefs_add… 525 100
#> # ℹ 116 more rows
cms_patient_care %>%
pivot_wider(
names_from = measure_abbr,
values_from = score
)
#> # A tibble: 28 × 12
#> ccn facility_name type beliefs_addressed composite_process
#> <chr> <chr> <chr> <dbl> <dbl>
#> 1 011500 BAPTIST HOSPICE deno… 202 202
#> 2 011500 BAPTIST HOSPICE obse… 100 88.1
#> 3 011501 SOUTHERNCARE NEW BEACON N. … deno… 525 525
#> 4 011501 SOUTHERNCARE NEW BEACON N. … obse… 100 100
#> 5 011502 COMFORT CARE COASTAL HOSPIC… deno… 295 295
#> 6 011502 COMFORT CARE COASTAL HOSPIC… obse… 100 99.3
#> 7 011503 SAAD HOSPICE SERVICES deno… 694 694
#> 8 011503 SAAD HOSPICE SERVICES obse… 99.9 96
#> 9 011505 HOSPICE FAMILY CARE deno… 600 600
#> 10 011505 HOSPICE FAMILY CARE obse… 97.8 92
#> # ℹ 18 more rows
#> # ℹ 7 more variables: dyspena_treatment <dbl>, dyspnea_screening <dbl>,
#> # opioid_bowel <dbl>, pain_assessment <dbl>, pain_screening <dbl>,
#> # treat_pref <dbl>, visits_imminent <dbl>
cms_patient_care %>%
pivot_wider(
names_from = c(measure_abbr, type),
values_from = score
)
#> # A tibble: 14 × 20
#> ccn facility_name beliefs_addressed_de…¹ beliefs_addressed_ob…²
#> <chr> <chr> <dbl> <dbl>
#> 1 011500 BAPTIST HOSPICE 202 100
#> 2 011501 SOUTHERNCARE NEW BEACON… 525 100
#> 3 011502 COMFORT CARE COASTAL HO… 295 100
#> 4 011503 SAAD HOSPICE SERVICES 694 99.9
#> 5 011505 HOSPICE FAMILY CARE 600 97.8
#> 6 011506 SOUTHERNCARE NEW BEACON… 589 100
#> 7 011508 SOUTHERNCARE NEW BEACON… 420 100
#> 8 011510 CULLMAN REGIONAL HOSPICE 54 100
#> 9 011511 HOSPICE OF THE VALLEY, … 179 100
#> 10 011512 SOUTHERNCARE NEW BEACON… 396 100
#> 11 011513 SHEPHERD'S COVE HOSPICE 335 99.1
#> 12 011514 ST VINCENT'S HOSPICE 210 100
#> 13 011516 HOSPICE OF LIMESTONE CO… 103 100
#> 14 011517 HOSPICE OF WEST ALABAMA 400 99.8
#> # ℹ abbreviated names: ¹beliefs_addressed_denominator,
#> # ²beliefs_addressed_observed
#> # ℹ 16 more variables: composite_process_denominator <dbl>,
#> # composite_process_observed <dbl>, dyspena_treatment_denominator <dbl>,
#> # dyspena_treatment_observed <dbl>, dyspnea_screening_denominator <dbl>,
#> # dyspnea_screening_observed <dbl>, opioid_bowel_denominator <dbl>,
#> # opioid_bowel_observed <dbl>, pain_assessment_denominator <dbl>, …