Using Medicaid Claims to Analyze Effectiveness of Housing Pilot Program


A local organization and mental health agency contracted with CCNY to conduct an evaluation of a housing pilot program designed to reduce long-term stays and costly services, while increasing self-sufficiency and access to sustainable independent housing.  The organization asked CCNY to analyze Medicaid claims and encounter data to (1) evaluate the program’s outcomes and effectiveness in reducing mental and physical health service utilization before, during, and after the intervention, from two different perspectives: the total number of claims and the number of unique people that had a claim, and (2) assist the customer with meetings to explain program benefits and preliminary findings in hopes of obtaining additional funding to expand the program.


CCNY’s Research and Evaluation team worked with the customer to identify participants in the program, as well as form a comparison group for analysis.  CCNY utilized the Medicaid data system to obtain claim and encounter data for program and comparison group individuals.  Analysis included data visualizations of descriptive statistics and trends of claim utilization across time.  CCNY worked with the customer to understand the evaluation methods and findings, allowing the organization to disseminate the findings to other staff and stakeholders.


The customer was able to easily identify program strengths and successes, aiding them in program planning and funding distribution for the multiple programs.  Currently, the organization has hosted two meetings with larger funding organizations in hopes of sharing the successes with other agencies statewide and obtaining more funding locally.  Our customer reports that the evaluation and its findings have been very beneficial for future budget and program planning.  In addition, this organization has since contracted with CCNY to conduct similar evaluations of different programs.