#SARS2 NYC

This project was presented by Scarlett at the 2020 APPAM meeting. We used the ACS, MEPS, and Medicaid data to estimate the number of people in NYC with conditions such as COPD, HIV, Cancer, etc which would put them at higher risk of severe complications with Covid. We also looked at people with pairs or triplets of the conditions. We focused on individuals aged 50+.

This repository contains the code that involves the MEPS. We used the Medicaid data to estimate the number of people with these conditions. Using the MEPS, we then calculated the ratio of privately insured people to Medicaid people with these conditions and repeated this for other insurances to scale the Medicaid data esimates (which theoretically should be better than the MEPS).

Output

The result of this work are in the AgeCatSexTableSherry_BenEdits(AutoRecovered) sheets, which puts together all of the ACS, MEPS, etc pieces of the project. MEPSEstimates is the MEPS results.

Usage:

1. Navigate to https://github.com/gliedgroup/template.
2. Click the green Use this template button to make a new repo.
3. Create the repository under gliedgroup instead of your personal account (Check nesting)