Virginia Data Reconstruction

Virginia's first reported COVID-19 case was on March 7th 2020. I began pulling the daily VDH COVID-19 data on March 27th. Hence, information for the dates between March 7th and March 26th need to be determined.

As VDH does not publish historic case data, we need need to reconstruct the data ourselves. Due to difference in available information between each jurisdiction, we need to take a different approach for each one.

  • City of Alexandria- The city publishes a daily summary ("City News Releases") of information related to COVID-19 in the form of a press release, including new case data. However, due to differences between when the City identifies cases and when it was reported to VDH, there is sometimes a lag or latency. For Alexandria, thus, I relied mostly on a handful of press reports, such as ARLnow.com and the Prince William Times (see below).
  • Arlington County - The news organization ARLnow.com has been publishing near-daily updated on new COVID-19 case information in Arlington based upon VDH's daily updates. Hence, the archives of ARLnow.com function as an effective historic dataset for Arlington's cases. In some occasions, these articles also mention case information in neighborhood Alexandria.
  • City of Fairfax - The City of Fairfax, and the City of Falls Church both fall under VDH's "Fairfax" health division. For this reason, and to avoid having very-small jurisdictions take up space in my charts, I will follow this approach (much like with Manassas and Manassas Park being bundled with Prince William County).
  • Fairfax County - The Fairfax County government hosts a blog which covers a number of COVID-19 related topics, including new case information, which have been updated on a near-daily basis. These numbers correspond precisely with the daily-published VDH data, so unlike Alexandria's updates, they require no further analysis. Of note, the City of Fairfax and the City of Falls Church are both reported under totals for Fairfax County, as they are all members of the VDH's "Fairfax" health division.
  • City of Falls Church - The City of Fairfax, and the City of Falls Church both fall under VDH's "Fairfax" health division. For this reason, and to avoid having very-small jurisdictions take up space in my charts, I will follow this approach (much like with Manassas and Manassas Park being bundled with Prince William County).
  • Loudoun County - Two media sources, loudounnow.com, and the Prince William Times provided the bulk of data for Loudoun County. Both sources provided updates using VDH data for Loudoun County and other jurisdictions.
  • City of Manassas - The City of Manassas, and the City of Manassas Park both fall under VDH's "Prince William" health division. For this reason, and to avoid having very-small jurisdictions take up space in my charts, I will follow this approach (much like with Falls Church and Fairfax City being bundled with Fairfax County).
  • City of Manassas Park - The City of Manassas, and the City of Manassas Park both fall under VDH's "Prince William" health division. For this reason, and to avoid having very-small jurisdictions take up space in my charts, I will follow this approach (much like with Falls Church and Fairfax City being bundled with Fairfax County).

***Reconstructed Data***
Date Alexandria Arlington Fairfax Loudoun
Prince William Total NOVA
7-Mar-20 0 0 0 0
1 1
8-Mar-20 0 0 1 0
1 2
9-Mar-20 1 0 2 0
1 4
10-Mar-20 1 0 2 1
1 5
11-Mar-20 1 1 2 1
1 6
12-Mar-20 2 1 4 2
1 10
13-Mar-20 5 1 6 3
2 17
14-Mar-20 5 1 10 5
2 23
15-Mar-20 5 2 10 5
3 25
16-Mar-20 9 2 10 5
3 29
17-Mar-20 13 2 12 5
4 36
18-Mar-20 14 2 14 5
4 39
19-Mar-20 17 4 16 5
11 53
20-Mar-20 17 4 16 5
11 58
21-Mar-20 22 5 22 14
14 77
22-Mar-20 26 5 31 15
18 95
23-Mar-20 34 6 43 15
18 116
24-Mar-20 36 8 46 18
23 131
25-Mar-20 46 9 77 20
34 186
26-Mar-20 54 14 80 28
39 215
**Note** - Will try to add raw spreadsheet at a later date. Available upon request via e-mail for now.

Comments

Post a Comment

Popular posts from this blog

End of the Road

My work on this blog is ending as of today. It appears, for better or worse, that the public is moving on from COVID-19, and it doesn't make sense to continue computing statistics for an issue of increasingly marginal public concern. Perhaps it is fitting that this is all occurring in early March, which is almost two years to the date since this all began . My initial effort was to try to do something productive with the situation, particularly as many of us felt fairly helpless. I hope at least some of my analysis was useful to you. I will not be making any more updates, revisions, etc. I will keep all of the posts and data up in perpetuity, or at least as long as Google/Blogger keeps this blog up.
Read more

February 3-9 2022 Update

Image
This post updates COVID-19 confirmed case data for the DC Metropolitan area as of 9 February 2022 2022  (covering 3 -9 February) .  The total confirmed cases in the DC area rose by 10,528 t o  933,857   ( average daily increase of 1,504 )  from  the previous total of  923,329 . Fatalities rose  by 210 t o  9,025   ( average daily increase of 30 )  from  the previous total of  8,815 . This will be my last weekly update, although I'll continue to do the monthly update. With the apparent retreat of the omicron variant, which occurred nearly as rapidly as it took off in December, I'm not really sure what relevance the case counts have any more (if they ever did, particularly once vaccines became available). If this is, as some experts claim, approaching an endemic status, then I don't really have much rationale for watching weekly movements. Cases DC Region: 933,857 By State DC Region (933,857) Maryland: 392,181 District of Columbia: 132,628 Virginia: 409,048 By Jurisdiction Ma
Read more

February 2022 Summary Statistics

Image
I will present some summary statistics which can explain the trends that we observed during the month of February 2022. This complements similar reports from   previous months . The post-peak decline of Omicron continued throughout the month. As of late February, the DC area is under 1,000 reported daily cases. This is the first time the region has been at that level since early December 2021 . Note that the apparent "spike" of infections in mid-late February was driven by single datum for 16 February (10,554 cases), which itself was driven by an unusual datum for Maryland (9,839 cases). I presume this was  backlog, and you will note that the downward trend continued. Total Case Growth Total cases on  31 January: 919,425 Total  cases  on 28 February: 959,092 Total  case  increase: 39,667 Smallest daily case increase: 343 (28 February) Largest daily case increase: 10,554  (16 February) Average daily increase: 1,417 Total Fatality Growth Total fatalities on  31 January: 8,756 T
Read more