Maryland Data Reconstruction

Reconstruction of Maryland's case data was made simpler by the fact that there are only four jurisdictions to monitor: Frederick County, Montgomery County, Prince George's County, and Charles County.

Maryland's first reported COVID-19 cases were on March 5th 2020. I began pulling the daily MDH COVID-19 data on March 27th. Hence, information for the dates between March 5th and March 26th need to be determined.

As MDH 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. Compared to the reconstruction of Virginia's data, the task for Maryland was made a bit easier by the fact that there are only four jurisdictions in Maryland to monitor.

  • Montgomery County - Reporting from Bethesda Magazine in the form of near-daily updates provided the bulk of information updates for Montgomery County, as well as for Prince George's County. An unstructured dataset of confirmed cases from the Washington Post ("Known coronavirus cases in D.C., Maryland and Virginia", updated regularly) filled in any remaining gaps.
  • Prince George's County - Reporting from Bethesda Magazine in the form of near-daily updates provided the bulk of information updates for Prince George's County(as well as for Montgomery County). An unstructured dataset of confirmed cases from the Washington Post ("Known coronavirus cases in D.C., Maryland and Virginia", updated regularly) filled in any remaining gaps.
  • Charles County - Local reporting from thebaynet.com provided near-daily updates on case information in southeastern Maryland, including Charles County, as well as other jurisdictions in Maryland. An unstructured dataset of confirmed cases from the Washington Post ("Known coronavirus cases in D.C., Maryland and Virginia", updated regularly) filled in any remaining gaps.
***Reconstructed Data***

Date Frederick Montgomery Prince George's Charles Total Suburban MD
5-Mar-20 0 3 0 0 3
6-Mar-20 0 3 0 0 3
7-Mar-20 0 3 0 0 3
8-Mar-20 0 4 0 0 4
9-Mar-20 0 4 1 0 5
10-Mar-20 0 5 3 0 8
11-Mar-20 0 6 4 0 10
12-Mar-20 0 6 4 0 10
13-Mar-20 0 6 6 1 13
14-Mar-20 0 10 7 1 18
15-Mar-20 0 12 9 1 22
16-Mar-20 1 15 11 1 28
17-Mar-20 1 24 19 1 45
18-Mar-20 1 31 20 2 54
19-Mar-20 1 33 23 2 59
20-Mar-20 1 51 31 2 85
21-Mar-20 1 68 36 4 109
22-Mar-20 1 83 40 5 129
23-Mar-20 2 93 47 5 147
24-Mar-20 4 107 63 5 179
25-Mar-20 7 127 76 8 218
26-Mar-20 14 164 101 10 289
**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