Get the Current Hospital Data Set from CMS with {healthyR.data}

[This article was first published on Steve's Data Tips and Tricks, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Introduction

Getting data for health care in the US can sometimes be hard. With my R package {healthyR.data} I am hoping to alleviate some of that pain.

Right now the package is bring actively developed from what was a simple yet sleepy simulated administrative data set is getting supercharged into a a full blow package that will retrieve data from outside sources. One such source is CMS.

At the start, and this is going to be a long road, I have started to build some functionality around getting the current hospital data from CMS. Let’s take a look at how it works.

Function

Here is the function which has no parameters. This function will download the current and the official hospital data sets from the CMS.gov website.

The function makes use of a temporary directory and file to save and unzip the data. This will grab the current Hospital Data Files, unzip them and return a list of tibbles with each tibble named after the data file.

The function returns a list object with all of the current hospital data as a tibble. It does not save the data anywhere so if you want to save it you will have to do that manually.

This also means that you would have to store the data as a variable in order to access the data later on. It does have a given attributes and a class so that it can be piped into other functions.

current_hosp_data()

Now let’s see it in action.

Example

We will download the current hospital data sets and take a look.

library(healthyR.data)
library(dplyr)

current_hospital_dataset <- current_hosp_data()

This function downloads 70 files. Let’s see which ones have been downloaded.

names(current_hospital_dataset)
 [1] "ASC_Facility.csv"                                                
 [2] "ASC_National.csv"                                                
 [3] "ASC_State.csv"                                                   
 [4] "ASCQR_OAS_CAHPS_BY_ASC.csv"                                      
 [5] "ASCQR_OAS_CAHPS_NATIONAL.csv"                                    
 [6] "ASCQR_OAS_CAHPS_STATE.csv"                                       
 [7] "CJR_PY6_Quality_Reporting_July_2022_Production_File.csv"         
 [8] "CMS_PSI_6_decimal_file.csv"                                      
 [9] "Complications_and_Deaths_Hospital.csv"                           
[10] "Complications_and_Deaths_National.csv"                           
[11] "Complications_and_Deaths_State.csv"                              
[12] "Data_Updates_January_2023.csv"                                   
[13] "Footnote_Crosswalk.csv"                                          
[14] "FY_2023_HAC_Reduction_Program_Hospital.csv"                      
[15] "FY_2023_Hospital_Readmissions_Reduction_Program_Hospital.csv"    
[16] "FY2021_Distribution_of_Net_Change_in_Base_Op_DRG_Payment_Amt.csv"
[17] "FY2021_Net_Change_in_Base_Op_DRG_Payment_Amt.csv"                
[18] "FY2021_Percent_Change_in_Medicare_Payments.csv"                  
[19] "FY2021_Value_Based_Incentive_Payment_Amount.csv"                 
[20] "HCAHPS_Hospital.csv"                                             
[21] "HCAHPS_National.csv"                                             
[22] "HCAHPS_State.csv"                                                
[23] "Healthcare_Associated_Infections_Hospital.csv"                   
[24] "Healthcare_Associated_Infections_National.csv"                   
[25] "Healthcare_Associated_Infections_State.csv"                      
[26] "Hospital_General_Information.csv"                                
[27] "HOSPITAL_QUARTERLY_MSPB_6_DECIMALS.csv"                          
[28] "hvbp_clinical_outcomes.csv"                                      
[29] "hvbp_efficiency_and_cost_reduction.csv"                          
[30] "hvbp_person_and_community_engagement.csv"                        
[31] "hvbp_safety.csv"                                                 
[32] "hvbp_tps.csv"                                                    
[33] "IPFQR_QualityMeasures_Facility.csv"                              
[34] "IPFQR_QualityMeasures_National.csv"                              
[35] "IPFQR_QualityMeasures_State.csv"                                 
[36] "Maternal_Health_Hospital.csv"                                    
[37] "Maternal_Health_National.csv"                                    
[38] "Maternal_Health_State.csv"                                       
[39] "Measure_Dates.csv"                                               
[40] "Medicare_Hospital_Spending_by_Claim.csv"                         
[41] "Medicare_Hospital_Spending_Per_Patient_Hospital.csv"             
[42] "Medicare_Hospital_Spending_Per_Patient_National.csv"             
[43] "Medicare_Hospital_Spending_Per_Patient_State.csv"                
[44] "OAS_CAHPS_Footnotes.csv"                                         
[45] "OQR_OAS_CAHPS_BY_HOSPITAL.csv"                                   
[46] "OQR_OAS_CAHPS_NATIONAL.csv"                                      
[47] "OQR_OAS_CAHPS_STATE.csv"                                         
[48] "Outpatient_Imaging_Efficiency_Hospital.csv"                      
[49] "Outpatient_Imaging_Efficiency_National.csv"                      
[50] "Outpatient_Imaging_Efficiency_State.csv"                         
[51] "Payment_National.csv"                                            
[52] "Payment_State.csv"                                               
[53] "Payment_and_Value_of_Care_Hospital.csv"                          
[54] "PCH_HCAHPS_HOSPITAL.csv"                                         
[55] "PCH_HCAHPS_NATIONAL.csv"                                         
[56] "PCH_HCAHPS_STATE.csv"                                            
[57] "PCH_HEALTHCARE_ASSOCIATED_INFECTIONS_HOSPITAL.csv"               
[58] "PCH_ONCOLOGY_CARE_MEASURES_HOSPITAL.csv"                         
[59] "PCH_OUTCOMES_HOSPITAL.csv"                                       
[60] "PCH_OUTCOMES_NATIONAL.csv"                                       
[61] "Timely_and_Effective_Care_Hospital.csv"                          
[62] "Timely_and_Effective_Care_National.csv"                          
[63] "Timely_and_Effective_Care_State.csv"                             
[64] "Unplanned_Hospital_Visits_Hospital.csv"                          
[65] "Unplanned_Hospital_Visits_National.csv"                          
[66] "Unplanned_Hospital_Visits_State.csv"                             
[67] "VA_IPF.csv"                                                      
[68] "VA_TE.csv"                                                       
[69] "Value_of_Care_National.csv"                                      
[70] "Veterans_Health_Administration_Provider_Level_Data.csv"          

More to come in the future!

To leave a comment for the author, please follow the link and comment on their blog: Steve's Data Tips and Tricks.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)