Cross-posted at ACASignups.netFor those who just want the capsule version, here it is:
The official ACA Medicaid/CHIP enrollment number that the HHS Dept. has been touting up until now has been 3.9 Million. The number that I've been claiming on the spreadsheet is currently around 4.5 Million. However, based on a very detailed analysis of the first 3 HHS reports, as well as the 2 CMS reports issued last fall, I've concluded that the actual grand total of Medicaid/CHIP enrollments since the ACA exchanges launched on October 1st is actually even higher, possibly as many as 6.4 Million.
Now, before everyone starts freaking out about this claim--and it's an admittedly major one--I want to make two VERY important caveats:
First: I could be wrong, plain and simple. I've double-checked my math and my logic the best I can, and have also cross-checked it with a CMS official to be sure, but some of these numbers get kind of squirrelly. If I'm wrong about this, so be it, but if so, it's due to an honest misunderstanding on my part and is not out of any attempt to "unskew the numbers" or "cook the books". I'd say I'm about 95% sure that I'm correct, but there's too many unknowns for me to be 100% confident.
Second: Even if I'm correct, it doesn't change the fact that all 3 numbers (3.9M, 4.5M or 6.4M) include an unknown number of Medicaid/CHIP redeterminations (i.e., people who were already on Medicaid prior to the new expansion rules who are simply renewing their enrollments).OK, with those two cop-outs clearly stated, let's dig into the weeds a bit.
If you look at Week 11 on the spreadsheet, you'll see that around mid- to late-December, the Medicaid total was roughly 2 million total. Then, in Week 12, it suddenly jumped up to around 3.9 million. Where did the extra 1.85 million come from? Well, if you look at the bottom of the spreadsheet, under "Additional Enrollments Not Broken Out By State", you'll see a whopping 1.85M added to the Medicaid tally as of 12/20.
The reason for this was a report issued by the CMS stating that 3.9 million people had been enrolled in Medicaid/CHIP in October & November. Since I already had around 2 million enrollments accounted for, I wasn't sure where the rest belonged, so I just added them there for the time being until I could figure out which states they belonged under. As additional Medicaid numbers came in after 11/30, I added them to the corresponding state tally, using 3.9M as the new "starting point" as of the beginning of December. I was assuming at the time that the "one-time special transfers" such as California's 600K+ LIHP transfer and the 130K that Massachusetts transferred over from Commonwealth Care were already included in that 3.9 million lump sum figure.
This continued into Week 13 and 14, culminating in a total of roughly 4.4 million total Medicaid/CHIP enrollments as of the 1st week of January.
However, this never really sat well with me, and my concerns were proven correct when the December HHS report came out earlier this week. According to it, as of December 28th, there were only about 1.58 million Medicaid/CHIP enrollments total...only 40% of the 3.9 million figure that CMS had been boasting of a month earlier, and only 35% of the 4.4 million I had as of early January.
In addition, a friend pointed out the following footnote on the December HHS report (emphasis mine):
1 Data related to Medicaid and CHIP eligibility in this report are based on applications submitted through the Marketplaces. October and November data based on applications submitted through state Medicaid/CHIP agencies were released by the Centers for Medicare & Medicaid Services in a separate report, âMedicaid & CHIP: November Monthly Applications and Eligibility Determinations Report, December 20, 2013,â which can be accessed at http://www.medicaid.gov/... Moving-Forward-2014/Downloads/Medicaid-CHIP-Monthly-Enrollment-Report-Nov-2013.pdf. Comparable December 2013 enrollment data based on applications submitted through state Medicaid/CHIP agencies will be released in a subsequent report.In other words, the HHS report included some types of enrollments through the end of December, while other types of enrollment data were only included through the end of November. Obviously I was still missing something significant, so I contacted an official at CMS to help me straighten this out.
The response from CMS was to explain that the CMS report includes enrollments made via Direct Enrollments via the state Medicaid Agencies for all 50 states (+DC) and Exchange Enrollments via the State-Based Marketplaces (i.e., the 15 state-run ACA exchanges) and...but did NOT include Exchange Enrollments via the Federal Marketplace (i.e., the 36 states run through HC.gov).
Oh, they also informed me that some state IT systems have the ability to separate out new enrollees from renewals but others don't, which explains why they're all lumped together in both the HHS and CMS reports. (So far, the State of Washington is the only one I know of that reports renewals separately).
So, now we have a rather complicated problem, best illustrated using a 3x3 grid. I whipped up a crude grid; I thought about cleaning it up here, but decided to upload the same graphic that I sent to my CMS contact. Let's play Medicaid Tic-Tac-Toe!
As a result, the two types of reports actually overlap in two squares (duplicate numbers), yet one of the 9 squares is still left open (direct enrollments in December).
I asked the CMS official whether the solution would be to separate out the state & federal exchange numbers, then add together the numbers as follows:
--36 Federal-Run States: Add 1,2,3,7 and 8--15 State-Run States: Add 6,7 and 8 onlyThe response from the CMS official was short and to the point: Yes, this makes sense.
So, I went ahead and did exactly that the other day. You can download the entire spreadsheet for yourself here if you wish. The yellow columns are included in order to illustrate that the numbers all add up correctly across, down and otherwise for each report; they are not included in the actual totals in column L at the right, which only includes columns B, D, G, H, I and J:
Column B: Federal-Run States, Exchange enrollments, October/November
Column D: Federal-Run States, Exchange enrollments, December
Column G: All States +DC, Exchange enrollments, 12/29 - 01/15
Column H: All States +DC, Direct enrollments, October
Column H also includes: State-Run States, Exchange Enrollments, October
Column I: All States +DC, Direct enrollments, November
Column I also includes: State-Run States, Exchange Enrollments, November
Column J: One-time transfers from existing programs (LIHP in CA, etc) and other special bulk enrollments
When you tally up all of these numbers, you end up with a final tally of....6.388 Million.
And again, this still doesn't include the 9th cell, which is direct enrollments for any state in December, although I presume that some of the additions in column G probably represent some of these.
When I presented this to the official at CMS, they stated that the methodology appears to be accurate, although they cannot presently confirm the numbers, with the following caveats:
--Some of the numbers may have been from before October 1st, but weren't reported until after 10/1
--As has been noted already, some of the numbers include renewals of existing Medicaid recipients
--Some of the "Special" enrollment numbers may already be represented in the existing reports
Regarding this last point, I'd have to check directly with the individual state agencies to clarify whether I'm double-counting them or not, but in most cases it's pretty obvious that I'm not. For instance:
--California: 630K transfer from LIHP: Definitely not included, as that's more than columns H and I combined.
--District of Columbia: 30K added via ACA provisions back in 2012 (Washington Post, 07/03/12)
--Minnesota: 51K added via ACA provisions back in 2012 (Washington Post, 07/03/12)
--Maryland: 91K transfer from PAC: more than H & I combined.
--Massachusetts: 130K transfer from Commonwealth Care: the other numbers all total to zero.
--Vermont: 33K transfer from VHAP/Catamount: Far more than the 119 total in the other columns (yes, that's 119, not 199K).
That only leaves Arkansas, Oregon and West Virginia as possibly being double-counted. If this is the case for all 3 states, then the grand total would be closer to 6.1 million instead of 6.4; while I'd happily correct the total, my larger point would still be valid.
This morning I received an indirect (but nonetheless legitimate) confirmation from Glenn Kessler at the Washington Post's Fact Checker, who, ironically, made the exact same point while badmouthing the Medicaid figure.
In running his numbers, Kessler adds together the October & November numbers from both the HHS and CMS reports for those months and calls it a day, with a grand total of around 4.6 million:
And hereâs Marilyn Tavenner, CMS administrator, in a blog post titled âNationwide Enrollment for Health Care Coverage Surged in December:âFirst of all, Kessler's reference to "750,000 Medicaid/CHIP eligibility determinations made through healthcare.gov through November" is, quite simply, wrong. For October & November, this number is actually only 269,000. If you also include December in that figure, however, it does indeed total around 750,000.
âAdditionally, 3.9 million Americans learned theyâre eligible for coverage through Medicaid and the Childrenâs Health Insurance Program (CHIP) in October and November. These numbers include new eligibility determinations and some Medicaid and CHIP renewals.â
The word âsomeâ should be a tip-off. Hereâs what the number actually includes:
â¢ Medicaid and CHIP eligibility determinations made directly through state Medicaid and CHIP offices in every state.
â¢ Medicaid and CHIP eligibility determinations made directly through state-based marketplaces (where the state is running their own marketplace).
â¢ New eligibility determinations as well as renewalsâi.e., people previously enrolled in Medicaid who are deemed eligible for another year.
At first glance, one could deduce that this is essentially an accounting of everyone who signed up for Medicaid in October and November. But there is actually one piece missing:
â¢ Any of the Medicaid or CHIP eligibility determinations made through healthcare.gov. (Through November, that figure was about 750,000.)
In theory, if you wanted to know the universe of people who actually were deemed to be eligible for Medicaid in those two months, you would need to combine 3.9 million and 750,000, though CMS concedes that there is probably some duplication.
Eventually all those people who are deemed eligible for Medicaid through healthcare.gov will end up being reported by the states back to CMS, so thatâs why CMS does not combine the two figures. (Meanwhile, as The Washington Post reported, more than 100,000 also failed to be reported to states because of software defects.) But, for the moment, you could say that about 4.6 million people were found to be eligible for Medicaid and CHIP in October and November.
However, you'll notice that Kessler's Fact Check failed to include two other important numbers:
--The additional Medicaid/CHIP numbers since December (some of these have come in already), and
--The "direct/one-time special transfers" of people from existing programs noted above
Now, I do understand, to some degree, why Kessler didn't include these. He was checking a very specific claim (the 6M total claim in Pres. Obama's tweet) made on a very specific date, which was based on a very specific report. The 3.9 Million portion of the "6 Million Covered" did indeed come from the CMS report of December 20...which only included numbers from October and November. The December HHS report wasn't released until January 13th. Since the tweet he's checking was released on January 10th, he could argue that December shouldn't have been included in his "Fact Check" of a Jan. 10th tweet.
Ironically, from what I can tell, he did include the December exchange numbers, but didn't think he was.
In any event, it is now January 16th, and the December report has been released...which means that the December Medicaid/CHIP enrollments have also been released (at least for the exchanges, though not the direct enrollments). In fact, there have even been a few additional updates even since then (the HHS report only runs through 12/28, meaning up to 18 more days' worth of numbers could potentially be added by now).
When you do so, you find the actual numbers to be:
|Month||Enrollments||Source||36 Fed-Run States||15 State-Run States||Subtotal|
|December||Exchange||HHS||482,146||299,286 (not using)||482,146|
|Subtotal (Kessler's WaPo Total):||3,563,006||1,114,182||4,677,188|
|Updates since 12/28:||(various)||79,178||404,294||483,472|
|Grand Total as of 01/16/14:||3,788,977||2,599,046||6,388,023|
Caveats which could reduce the number from the 6.4M high end include:
--Some of these may be renewals of existing Medicaid recipients (this is true whether you use 3.9M, 4.6M or 6.4M as the total number)
--Some of these may be from before Oct. 1st, but not reported until after Oct. 1st (obviously these would be part of the "renewals" noted above)
--Some of the "Special" enrollment numbers may already be represented in the existing reports
--There may be other factors which have simply escaped both myself, Olav, the HHS reports, the CMS reports and the CMS official who has (unofficially) vouched for my methodology.
I'll leave the spreadsheet set to the current 4.5M tally for a day or so after publishing this lengthy screed; unless someone can verifiably contest the numbers by a notable amount, I'll be updating the spreadsheet with the new numbers laid out in this report over the weekend.
And with that, I'm calling it a day.