How I monitor an area, or dealing with clutter.

I have been spending significant amounts of time examining data for colleges.  Only, I have very little visibility into what is happening directly on campus, just the schools dashboard.  Fortunately, the schools are located in fixed geographic regions.  For example, almost all Va Tech students live in Blacksburg in the Zipcode of 24060.  And, the state gives the following data by zip code:

ReportDate    
ZIPCode    
NumberofCases    
NumberofTestingEncounters   
NumberofPCRTestingEncounters

The number of cases and testing are cumulative numbers.  But, by taking the time derivative (e.g., subtracting one day from the previous day), I can get the number of cases and tests per day.  And from that, I can derive a metric of percent positive.

For Va Tech, this looks like:


My overall approach is to look at the baseline number of cases (before the students arrive), compute the mean and standard deviation of the pre-arrival data, and track based on the number of standard deviations above the mean.

For Va Tech, the mean is low, so I will notice an outbreak when it is 3 standard deviations above the mean.  For 22040, that was at 8 cases a day, or 0.02% of the population.

In other places, there are either more pre-student arrival cases (noise) or non-student outbreaks (clutter).  As an example of clutter, I will show the cases for Longwood in Farmville:

The cases in Farmville around August 1 were unrelated to the university; they were the result of an outbreak at the Farmville ICE detention center.  What it means is, short of subtracting those cases from the data, the sensitivity of cases at Longwood is about 30-40 cases, or about 1% of the student body.  This is another way of says, I will not see an outbreak at Longwood until it is too late.

The following list highlights my sensitivity at the various schools:


     School     Community   Thresh  %of 
                Mean   Std.         students
     Va Tech    2.0    2.2    8.6   0.03
         GMU    4.5    2.9   13.3   0.04
         UVA    5.3    4.9   19.9   0.08
         ODU    3.0    2.7   11.0   0.04
         JMU    4.7    3.0   13.5   0.06
         CNU    3.7    2.4   10.9   0.22
         UMW    4.8    3.1   14.0   0.27
     Radford    2.2    2.5    9.7   0.12
         VCU    3.9    3.0   12.8   0.04
         W&M    1.5    1.1    4.8   0.06




Comments

Post a Comment

Popular posts from this blog

Daily Status, August 29

Image
Daily Status, August 29:Today's report was late because the data are late.  Typically, I report 1-2 hours after the data are published.  Note:  Today, I focused on the colleges.  Much of the text in other sections could be reused.  The figures are 100% from today, though.
Summary/Situational AwarenessLike yesterday, today's concern are with the universities.  Only two (W & M aare showing no increase since the students arrived.  Va Tech and UVA are showing increases, but probably consistent with the increased populations -- they have moved to monitor closely.  Meanwhile, there is large scale community spread at JMU, Radford and possibly VCU. More on this in the section title "Colleges".  The discussion of colleges will take up most of the new discussion
Across the commonwealth, there were about 1217 reported new cases (including Radford).  This with is slightly above the average number of cases in the last three week, but within 1 standard deviation. Regionally, Nor…
Read more

Virginia COVID-19 Status for Sept 10

Image
Daily Status, Sept. 10Reminder:  any sections that are unchanged since yesterday are grayed out.
The following is a rant.  It probably should be in the COMMENTARY section, but I feel the need to put it up here.   I am often asked why I do this.  I talk in general terms about reporting, etc.  But a news story yesterday shows why:  I do not trust the government to give an accurate assessment.  The intentional downplaying of the risks and numbers means that people like me have to dig into the numbers to figure out what is happening.    Summary/Situational AwarenessIt looks like some colleges are either getting a handle on the virus or achieved herd immunity: Radford and VCU are stable now.  Unfortunately, the outbreak at JMU continues to spread. And VT is starting to spiral out of control.
Across the commonwealth of Virginia, there were 1236 reported new cases of COVID-19.  The number higher than the recent trends, and is more than 1 standard deviation above the mean.  This probably is beca…
Read more

Daily Status, Sept. 11

Image
Daily Status, Sept. 11Reminder:  any sections that are unchanged since yesterday are grayed out.
This something we all need to read to protect ourselves.  I will probably write about it soon. Summary/Situational AwarenessIt looks like some colleges are either getting a handle on the virus or achieved herd immunity: Radford and VCU are stable now.  Unfortunately, the outbreak at JMU continues to spread; only about half the students returned home. And VT is spiraling out of control;  UVA could be next. 
Across the commonwealth of Virginia, there were 1115 reported new cases of COVID-19.  The number higher than the recent trends; it is about 1 standard deviation above the mean.     Overall, cases are essentially flat for the last three weeks. It is worth noting that, over over that time, 14% of the positives have been from colleges; today,  colleges account for 20% (223) of the cases are directly related to college; without the college cases, the numbers would be decreasing by 1%/day Region…
Read more