Since tracking and analyzing data is what I'm best known for...and since I'm mostly stuck sitting in front of the computer all day whether I like it or not these days anyway...I've started my own daily COVID-19 spreadsheet.

Again, I'm not the one who compiled the data itself--many other teams with far better resources than I have are doing that--but I'm pulling their work together and adding some additional context, such as per capita info by state/territory.

Nationally:

After a TON of tedious work porting data over into my county-level COVID-19 tracking spreadsheet, I've completed charts breaking out confirmed cases in two additional states: Minnesota and Texas.

Minnesota was an obvious choice, given that it was the closest swing state won by Donald Trump. Texas may seem like an unusual choice given that it's considered to be a solid red state and that it hasn't seen the type of ugly outbreak of COVID-19 (yet) that several other states have, but I happened to discover that unlike states like Florida and Georgia, Texas's Health Dept. dashboard makes it quite easy to download the historic case and fatality data I need to compile these charts, so I decided to go for it. The results in both states are interesting for different reasons.

via MNsure:

MNsure releases Request for Proposal for the Minnesota Insulin Safety Net Program’s Public Awareness Campaign

  • Submissions accepted until May 26, 2020

ST. PAUL, Minn.—On April 15, 2020, Governor Walz signed the Alec Smith Insulin Affordability Act to provide relief to Minnesotans struggling to afford their insulin. MNsure, the state’s health insurance exchange, is responsible for a creating a public awareness campaign to promote the Insulin Safety Net Program. The public awareness campaign will inform Minnesotans in urgent need of insulin how to access the state’s safety net program, and highlight the availability of insulin manufacturers' patient assistance programs.​ 

The request for proposal (RFP) seeks proposals from qualified firms or contractors capable of producing a statewide public awareness campaign to increase awareness of the Insulin Safety Net Program. The anticipated time frame of the campaign is July 2020 through June 2023.

For weeks now, I've been tracking the daily COVID-19 numbers at the county level in several states; particularly Michigan, Wisconsin and Pennsylvania. While the pandemic hit the more densely-populated areas first (which tend to lean Democratic), the trendlines in Michigan and Wisconsin have been clearly moving towards the more rural, Republican-leaning counties increasing their share of the cases and corresponding deaths as time has passed.

Pennsylvania has been different--after a less dramatic shift from blue to red counties in late March, PA seems to have levelled off, with new cases holding pretty steady between the two.

It's been another week, so I figured I should post and update...and it's more of the same in all three cases. First up, Michigan:

Since tracking and analyzing data is what I'm best known for...and since I'm mostly stuck sitting in front of the computer all day whether I like it or not these days anyway...I've started my own daily COVID-19 spreadsheet.

Again, I'm not the one who compiled the data itself--many other teams with far better resources than I have are doing that--but I'm pulling their work together and adding some additional context, such as per capita info by state/territory.

Nationally:

via Covered California:

Covered California for Small Business Works to Help Struggling Businesses Keep Employees Covered During the COVID-19 Pandemic

  • Covered California for Small Business will allow small businesses an additional 30-day grace period to make their premium payments for the months of April and May.
  • Employers interested in the program will be able to defer up to 75 percent of their premium payments for April and May in an effort to keep thousands of small business employees insured during the current health care crisis.
  • A survey found that more than three out of every four Covered California for Small Business employers are either operating in a limited capacity or are temporarily closed.

Since tracking and analyzing data is what I'm best known for...and since I'm mostly stuck sitting in front of the computer all day whether I like it or not these days anyway...I've started my own daily COVID-19 spreadsheet.

Again, I'm not the one who compiled the data itself--many other teams with far better resources than I have are doing that--but I'm pulling their work together and adding some additional context, such as per capita info by state/territory.

Nationally:

One of the biggest non-COVID19 related healthcare policy stories in the news this week was the Monday ruling by the U.S. Supreme Court stating that yes, the federal government does, in fact, have to keep its contractual obligation to make $12 billion in payments legally owed to a bunch of health insurance carriers.

As I've explained many times over the years, the idea behind the ACA's Risk Corridor program was that the launch of the major ACA regulations starting in 2014 involved such a radical reworking of requirements for private health insurance policies (especially on the individual market) that it was unreasonable to expect insurance companies to be able to accurately predict how well or poorly they would fare under the new rules. While the "free market" is supposed to be a "sink or swim" environment, it was agreed that this was so dramatic a change that the carriers should be given "training wheels" of sorts to smooth out the bumpy ride for the first three years.

Since tracking and analyzing data is what I'm best known for...and since I'm mostly stuck sitting in front of the computer all day whether I like it or not these days anyway...I've started my own daily COVID-19 spreadsheet.

Again, I'm not the one who compiled the data itself--many other teams with far better resources than I have are doing that--but I'm pulling their work together and adding some additional context, such as per capita info by state/territory.

Nationally:

Since tracking and analyzing data is what I'm best known for...and since I'm mostly stuck sitting in front of the computer all day whether I like it or not these days anyway...I've started my own daily COVID-19 spreadsheet.

Again, I'm not the one who compiled the data itself--many other teams with far better resources than I have are doing that--but I'm pulling their work together and adding some additional context, such as per capita info by state/territory.

Nationally:

US Chamber of Commerce, which supported ACA repeal bills in 2017, now among those calling for *increasing* ACA subsidies temporarily due to coronavirus crisis https://t.co/QtxCkKqCqX

— Peter Sullivan (@PeterSullivan4) April 28, 2020

Yes, it's true:

Dear Speaker Pelosi, Leader McConnell, Leader McCarthy and Leader Schumer: Thank you for your swift action to help overcome the COVID-19 crisis. Your action is speeding support to hospitals, doctors, nurses, businesses and workers from critical investments in equipment to direct assistance to cover immediate expenses. More must be done, and we stand united in our commitment to work with you and to work together.

Two weeks ago, Covered California reported that 58,000 residents had enrolled in ACA exchange coverage during their COVID-19 Special Enrollment Period, of which roughly 20,000 did so via standard SEPs (losing coverage, moving, getting married/divorced, etc), while an additional 38,000 took advantage of the COVID-specific SEP.

Today they issued a press release with updated numbers and more:

Covered California Continues to See Strong Consumer Interest in Quality Health Care Coverage During the COVID-19 Pandemic

Over the past few days, I've collected and analyzed the daily COVID-19 cases at the county level in Michigan and Wisconsin to see what patterns are emerging as time goes by. I've tried to do this via two criteria: Population density (urban vs. rural) and politically (red vs. blue). The latter, of course, shouldn't even be a thing, but of course it is; pretty much every policy decision being made by the Trump Administration is based on tribal politics, so it'd be naive not to look at the data in that light.

So far, I've found clear and obvious trends in both midwest states, which happen to be two of the three most closely-watched swing states this year: While the urban centers (Detroit/Metro Detroit in Michigan; Milwaukee/Madison in Wisconsin) started out with much higher rates of infection than the rest of the state, over the past few weeks this has shifted dramatically, and appears set to continue to do so.

Since tracking and analyzing data is what I'm best known for...and since I'm mostly stuck sitting in front of the computer all day whether I like it or not these days anyway...I've started my own daily COVID-19 spreadsheet.

Again, I'm not the one who compiled the data itself--many other teams with far better resources than I have are doing that--but I'm pulling their work together and adding some additional context, such as per capita info by state/territory.

Nationally:

  • 5.59 million tests have been completed in the U.S. (1.7% of the population)
  • 23,000 more Americans tested positive today. 1.01 million have tested positive to date.

Yes, that's right: Today the United States of America broke 1 million cases of COVID-19. Hooray for us. Yay team.

Yesterday I had a lengthy post in which I noted that the claims by certain Republicans/"MAGA" types that the COVID-19 pandemic was limited to "blue" areas and "big cities" (wink, wink) is quickly unraveling...at least here in Michigan.

Today, I've run the numbers and put together similar Red/Blue and Urban/Rural breakouts for another extremely closely-watched swing state: Wisconsin.

For Michigan, I was able to separate out the City of Detroit itself from the rest of Wayne County. I also included the wider "Metro Detroit Area", which consists of both Oakland and Macomb County along with the part of Wayne County outside of Detroit.

I'm a lot less familiar with Wisconsin, and they don't break out Milwaukee separately anyway, so I went with Milwaukee County, Dane County (which includes the 2nd largest city in the state, Madison), and the Rest of Wisconsin. Here's what the breakout of COVID-19 cases has looked like over time. Once again, it's really only relevant after the state reached 100 cases:

Pages