I put together the following visualizations from data reported on
ADHS's COVID Dashboard.
I've been copying their data to a personal spreadsheet
so that I could view the day-to-day charts,
which were not available early in AZ's reporting history.
As their reporting has increased,
I made these to visualize things they don't provide,
and to help answer questions I had like
"What time period does the current data accurately reflect?",
"How large is the reporting delay?",
"What are the effects of the state's COVID-19 response
or major changes in people's behavior?",
and "How long do I need to wait before the data is accurate enough to know that?".
A summary:
-
Reported cases are mostly for people tested 4-8 days ago,
but the reporting delay is getting longer and more variant.
-
Reported deaths are mostly for people who died within the last 2 weeks,
but sometimes they're from 8 weeks ago or longer.
-
Most infections show up in the case data about 2-3 weeks post-infection.
-
The drop in PCR rates was almost entirely due to the increase in testing.
-
Reopening lead to a lot of new infections.
As a disclaimer,
I make no claim to the accuracy of the underlying data itself;
I've worked to copy it as it was reported by ADHS.
They've made changes at various times
that have had significant impacts on the trends in the data.
Further, due to the way ADHS makes this data available,
it's extraordinarily difficult to simply copy and paste it.
Although I've done my best to ensure I've accurately copied the reported data,
it's possible I've made mistakes.
I've published them here in the hopes they're useful to others,
but without any warranty, implied or otherwise.
Note: I missed data for the following days: 17-Apr, 19-Apr, 22-Apr, 25-Apr, and 1-May.
As a result, the "reported day-of" values are copied from the previous day,
the "day-to-day change" for those days are necessarily zero,
and the following day shows the delta relative two days prior.
