Case Surveillance File: July 2022 Downloads
The massive Case Surveillance File is one of our favorite tables to parse from the CDC. Unlike the other exports which will sometimes hide their data in couched population numbers, the Case Surveillance file has a single row for every “confirmed” COVID-19 case which has made its way up to the CDC.
It currently stands at 77.5 MILLION rows and weighs in at 9.3GB! You need some decent machinery and something like a professional business intelligence tool to parse it - which we do! (We use a Macbook pro and Tableau over here)
Here’s a quick sample of what we parsed and for paid subscribers we have an entire powerpoint for you to peruse and some excel file downloads for deeper dives below the paywall.
So, each row represents a case, we don’t have the state (that’s in another file which is more problematic) but we do have age range, ethnicity, hospitalization status, icu, death and a few other ones.
So, for example, we can do some interesting analysis on COVID-19 deaths between age, sex, and ethnicity:
We can also look at case fatality rate and show what kind of risk President Biden faces at his age. Spoiler: it’s a LOT lower than what President Trump faced and it’s comparable to the risk of a 40 or 50 year old in Spring 2020:
Become a paid subscriber for $7 a month or $70 for the entire year for access to powerpoints, excel files an other items below:
Keep reading with a 7-day free trial
Subscribe to Rational Ground by Justin Hart to keep reading this post and get 7 days of free access to the full post archives.