Fun with MA COVID-19 Reporting 19-Nov-2020 Greater-Greater Somerville Edition

I'm still trying to figure out what color coding makes sense.... I've done more of a Fibonacci sequence once we get to red so that the upper limit of each color extends further as we get into higher case count.

Another thing I'm going to start doing is having the chronological order go right to left so that the most recent update is closest to the name of the locale.  

One last change, I'm going to use a better approximation of the cases we've seen every 2 weeks by taking the totals from the report 2 weeks ago and comparing to the report of the week.  For an explanation of why this is more appropriate, read over my post from a few weeks ago: https://funwithmacovid-19reporting.blogspot.com/2020/10/why-weekly-community-numbers-reported.html

• Green - Less than 4 cases per 100,000 people per day
• Yellow - Greater than or equal to 4 and less than 8 cases per 100,000 people per day
• Orange - Greater than or equal to 8 and less than 16 cases per 100,000 people per day
• Red - Greater than or equal to 16 and less than 24 cases per 100,000 people per day 
• Maroon- Greater than or equal to 24 and less than 40 cases per 100,000 people per day
• Purple- Greater than or equal to 40 and less than 64 cases per 100,000 people per day
• Black - Greater than or equal to 64 cases per 100,000 people per day

• Arlington - 10.6<- 7.5 <- 6.4 <- 6.7 <- 3.9 <- 0.9 <- 2.2 <- 3.0 <- 1.9 <- 2.5 <- 2.7 <- 1.4 <- 0.6 <- 0.6 
• Boston - 33.0<- 24.5 <- 19.2 <- 16.4 <- 12.0 <- 10.9 <- 10.2 <- 8.6 <- 8.0 <- 5.8 <- 5.8 <- 7.8 <- 7.1 <- 6.6 
• Cambridge - 20.1<- 9.9 <- 5.8 <- 3.9 <- 4.2 <- 3.7 <- 2.7 <- 3.1 <- 3.0 <- 2.4 <- 1.8 <- 1.6 <- 2.2 <- 2.3 
• Chelsea - 73.8<- 60.5 <- 48.0 <- 34.9 <- 26.9 <- 30.2 <- 24.3 <- 18.6 <- 20.5 <- 20.9 <- 26.4 <- 31.3 <- 30.0 <- 22.2 
• Fitchburg - 56.4<- 50.2 <- 41.0 <- 25.6 <- 6.9 <- 3.9 <- 2.5 <- 1.5 <- 1.5 <- 2.5 <- 3.2 <- 2.4 <- 2.0 <- 3.7 
• Holliston - 19.7<- 17.1 <- 17.1 <- 13.0 <- 9.8 <- 7.8 <- 5.7 <- 6.7 <- 8.8 <- 6.2 <- 3.6 <- 5.2 <- 2.6 <- 1.0 
• Lawrence - 110.8<- 88.4 <- 64.3 <- 57.3 <- 49.3 <- 41.2 <- 37.6 <- 36.5 <- 22.5 <- 14.1 <- 18.3 <- 17.0 <- 12.6 <- 9.5 
• You've got me considering whether having 64 be the start of the highest color code is appropriate... sticking with it for now though.
• Lowell - 67.4<- 46.1 <- 29.8 <- 19.7 <- 13.9 <- 15.2 <- 16.7 <- 12.3 <- 8.1 <- 6.4 <- 6.1 <- 4.3 <- 2.9 <- 2.8 
• Lynn - 64.5<- 48.4 <- 38.3 <- 27.6 <- 18.7 <- 13.6 <- 11.2 <- 12.0 <- 15.7 <- 13.2 <- 9.6 <- 12.2 <- 17.0 <- 22.2 
• Malden - 35.3<- 26.1 <- 17.1 <- 13.8 <- 12.2 <- 11.9 <- 10.9 <- 6.3 <- 4.3 <- 6.1 <- 7.3 <- 5.9 <- 3.7 <- 3.0 
• Medford - 24.1<- 18.8 <- 11.6 <- 8.8 <- 7.2 <- 6.9 <- 5.8 <- 4.8 <- 4.7 <- 4.7 <- 5.4 <- 4.1 <- 3.3 <- 4.1 
• Quincy - 13.6<- 10.3 <- 8.5 <- 6.9 <- 6.3 <- 6.9 <- 6.4 <- 4.8 <- 3.7 <- 3.2 <- 2.9 <- 2.6 <- 3.3 <- 2.8 
• Salem - 41.9<- 28.2 <- 16.8 <- 9.8 <- 6.5 <- 5.9 <- 6.7 <- 6.5 <- 4.4 <- 3.8 <- 4.9 <- 4.9 <- 6.5 <- 9.8 
• Somerville - 8.2<- 17.8 <- 10.3 <- 7.4 <- 7.1 <- 7.5 <- 6.4 <- 4.9 <- 5.2 <- 7.0 <- 7.9 <- 6.5 <- 4.7 <- 3.4 
• Springfield - 56.9<- 38.5 <- 26.3 <- 18.1 <- 11.3 <- 14.7 <- 14.6 <- 9.6 <- 5.7 <- 3.7 <- 3.6 <- 2.8 <- 3.5 <- 4.5 

• State - 31.2 <- 22.4 <- 16.3 <- 12.7 <- 9.3 <- 8.5 <- 7.6 <- 6.2 <- 5.1 <- 4.4 <- 4.4 <- 4.5 <- 4.0 <- 3.8

It's going to take me some time to get all cities/towns into a position where I can provide a count for all with my calculation but in the meantime, I'll give the tallies with the state's calculation:

(new categories and state calculation):

• Green - 39 (Less than 4 cases per 100,000 people per day)
• Yellow - 33 (Greater than or equal to 4 and less than 8 cases per 100,000 people per day)
• Orange - 101 (Greater than or equal to 8 and less than 16 cases per 100,000 people per day)
• Red - 73 (Greater than or equal to 16 and less than 24 cases per 100,000 people per day) 
• Maroon- 73 (Greater than or equal to 24 and less than 40 cases per 100,000 people per day)
• Purple- 22 (Greater than or equal to 40 and less than 64 cases per 100,000 people per day)
• Black - 10 (Greater than or equal to 64 cases per 100,000 people per day)

(Old categories and state calculation):

• Green/Grey - 39
• Yellow - 33
• Red - 279

Oh, also, according to the state, according to the state,

• 274 cities/towns have higher 2-week count this week than they did last week
• 34 cities/towns were lower
• 43 cities/towns saw no change

Have a city/town you'd like me to keep track of? Let me know and I'll get started.

Stay Safe. Stay Sane. Stay Informed.