You are here

In which data from my site is plugged into an interactive U.S. map!

2018 MIDTERM ELECTION

You must enable javascript in your browser to view the
countdown

Time: DHMS

Tue, 12/15/2015 - 10:30am

OK, this is pretty nifty! You know those way-cool interactive color-coded maps that you see on major media sites like the NY Times? The ones where you can roll over each state and get pop-up data, etc?

Well, a company called Graphiq which specializes in exactly these maps has done just that with some of my data. The map below shows the percentage of those eligible to enroll in ACA exchange policies who were enrolled as of June 2015. Obviously these numbers have likely shifted since June, and will look quite different starting in January, but this is the most recent hard data available.

To calculate the number of uninsured who are eligible for exchange coverage, I took the KFF's estimate of how many uninsured are eligible for APTC assistance, then added in those who would have to pay full price due to being either above the 400% FPL income threshold or who have unaccepted ESI offers. I also had to subtract out those who are ineligible due to being caught in the Medicaid Gap or who are undocumented immigrants.

It's important to note that KFF's study only broke these out completely for 21 states. For the other 30 (including DC), my estimate of the “undocumented immigrant” number is based on an earlier study by KFF from a year or so ago, in conjunction with a Pew Research survey from a couple of years earlier.

Then, to break out the remaining number between “ESI offer” and “>400% FPL income”, I just did a rough ratio breakdown based on the other states. That is, for the 21 known states, KFF estimates roughly 15% have ESI offers to 12% with higher than 400% incomes, or roughly a 55/45 split. So, for example, if a given state has 100,000 ESI+400%, I broke it out 55K / 45K.

I know this isn’t exactly the most accurate way of doing it, but it’s the best I could do under the circumstances.