ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
1
The City of Boston publishes numbers as a 7-day trailing average instead of simply publishing the number of new cases per day, which averages the case numbers over the seven days prior to the published date. While the numbers are not raw, they will be accurate enough to include in the analysis
2
2
We are calculating our per 100k number for Tufts campuses by estimating the population of each campus as the total number of unique individuals tested since August 3rd. Since most--if not all--people on each campus will have been tested at least once since August 3rd, this is a close estimation of the number of people on campus
3
3
We are calculating our per 100k number for municipalities by dividing the new case number by the population of the municipality, then multiplying by 100,000
4
4
We are determining the number of new cases per day by finding the difference in cumulative positive cases between the current day and the day before
5
5
As of 1/15, all calculations will be done off of a 7-day trailing average, either calculated from raw data or published. The reason we are switching to a 7-day average is because the numbers will not fluctuate as much using this method
6
6
Columns that are highlighed in yellow are only intermediate calculations. Potential relevant data will be displayed from columns highlighted in green
7
7
Incomplete data is highlighted in yellow
8
8
Suspected reporting errors highlighted in red
9
9
***** represents a division by zero error. This is due either to incomplete data (has not been reported yet) or comparing a % change with a day that had an average new case number of zero
10
10
As of 1/23, we are calculating the population of campus (for the per 100k metric) from the weekly tests, rather than the cumulative tests, in case people left for the second semester and did not return
11
11
Due to the amount of data it takes to begin calculating 7-Day averages and percent change metrics, "good" data begins on January 16th
12
12
**More comments can be found within the data itself as Google Sheet comments**
13
13
All percent change calculations are done off of the 7-Day trailing average
14
14
***** will now represent any error due to incomplete data
15
15
All trend calculations and the per 100k metric are completed from the 7-day trailing average
16
16
On Feb. 12, we noticed anomalies with the case number data from the Medford/Somerville campus. We are waiting to update the dashboard until we get clarification about what the correct case numbers are.
17
17
On Feb. 14, after clarification from the university, we updated our formulas so our 7-day averages would not include data from the anomalous Feb. 10 date. We are still including and marking the data on Feb. 10 for reference
18
18
Statewide data on Feb. 13 was not retrieved. We averaged the data from the 12th and the 14th to include numbers for that date
19
19
Resolved reporting anomalies will be highlighted in green
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100