![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Local COVID-19 updates
Nov. 17th, 2020 05:49 pmI noticed an issue in yesterday's post where the positivity rate was up from the previous day's report, but was reported as down from the previous day. As it turns out, that was an artifact of my only using one day's raw data and the state's changing some of its data over time. Specifically, the positivity numbers are now coming from the "TestingByDate.xlsx" file, which reports tests based on the date the test was adminstered - not the date the test was reported. Thus, as time goes on, late-reported tests get added to the TestingByDate.xlsx spreadsheet and numbers for earlier dates can change. To avoid that problem going forward, I changed my code again; now, data from earlier days is pulled from that day's raw data, rather than from the current day's raw data. A nice side effect of that code change was that it became easy to implement a two-week lookback as well, and that's included below as well.
As of 5PM today, the Commonwealth of Massachusetts is reporting 20 newly reported confirmed deaths (8 more than yesterday - up 66.7%) for a total of 10,130 and 2,263 newly reported confirmed cases (296 more than yesterday - up 15.0%) for a total of 186,774. The seven day average positivity rate is 3.25%, compared to 3.17% yesterday. Excluding higher education, the seven day average positivity rate is 5.30%, compared to 5.25% yesterday. The number of estimated active cases was 32,309 (541 more than yesterday - up 1.7%). The state also reported zero newly reported probable deaths (same as yesterday) for a total of 230 and 262 newly reported probable cases (65 more than yesterday - up 33.0%) for a total of 6,190. Combining the confirmed and probable numbers gives 20 new deaths for a total of 10,360 and 2,525 new cases for a total of 192,964. There were 835 COVID-19 patients in hospital (54 more than yesterday - up 6.9%), 159 COVID-19 patients in ICUs (same as yesterday) and 73 COVID-19 patients on ventilators (intubated) (1 less than yesterday - down 1.4%).
Of the Commonwealth's four "key metrics" listed on page 2 of the report, the 7-day average of newly confirmed cases is 1,785 (131 less than yesterday - down 6.8%), 1,036% above the lowest observed value of 157 on July 4 and 23% below the highest observed value of 2,300 on April 20. The 7-day weighted average of positive molecular test rate is 3.2% (0 more than yesterday - up 2.6%), 320% above the lowest observed value of 0.8% on September 21 and 88% below the highest observed value of 27.7% on April 15. The 7-day average number of COVID-19 patients in hospital is 724 (31 more than yesterday - up 4.5%), 367% above the lowest observed value of 155 on August 26 and 82% below the highest observed value of 3,874 on April 27. The 7-day average number of COVID-19 deaths is 21 (same as yesterday), 90% above the lowest observed value of 11 on September 9. and 88% below the highest observed value of 175 on April 24.
Two weeks ago, the 7 day confirmed case average was 853, the 7 day confirmed deaths average was 16, the 7 day hospitalization average was 432, and the 7 day weighted average positivity rate (excluding higher education) was 3.2%.
Continuing bad news on the day-by-day front, with deaths, new cases, active cases, positivity, and hospitalization all up. The longer-term trends aren't great, either, and keep going in the wrong directions. On the other hand, things aren't nearly as bleak as they were back in April, when we were looking at hospitalizations approaching four thousand and positivity over twenty-five percent. So that's something, at least.
The town of Acton has yet to post an update today. As of the most recent report at 10PM on November 10, the town of Acton reported 256 cumulative cases of COVID-19 in town with 23 individuals in isolation, 212 recovered and 21 fatalities.
As of 5PM today, the Commonwealth of Massachusetts is reporting 20 newly reported confirmed deaths (8 more than yesterday - up 66.7%) for a total of 10,130 and 2,263 newly reported confirmed cases (296 more than yesterday - up 15.0%) for a total of 186,774. The seven day average positivity rate is 3.25%, compared to 3.17% yesterday. Excluding higher education, the seven day average positivity rate is 5.30%, compared to 5.25% yesterday. The number of estimated active cases was 32,309 (541 more than yesterday - up 1.7%). The state also reported zero newly reported probable deaths (same as yesterday) for a total of 230 and 262 newly reported probable cases (65 more than yesterday - up 33.0%) for a total of 6,190. Combining the confirmed and probable numbers gives 20 new deaths for a total of 10,360 and 2,525 new cases for a total of 192,964. There were 835 COVID-19 patients in hospital (54 more than yesterday - up 6.9%), 159 COVID-19 patients in ICUs (same as yesterday) and 73 COVID-19 patients on ventilators (intubated) (1 less than yesterday - down 1.4%).
Of the Commonwealth's four "key metrics" listed on page 2 of the report, the 7-day average of newly confirmed cases is 1,785 (131 less than yesterday - down 6.8%), 1,036% above the lowest observed value of 157 on July 4 and 23% below the highest observed value of 2,300 on April 20. The 7-day weighted average of positive molecular test rate is 3.2% (0 more than yesterday - up 2.6%), 320% above the lowest observed value of 0.8% on September 21 and 88% below the highest observed value of 27.7% on April 15. The 7-day average number of COVID-19 patients in hospital is 724 (31 more than yesterday - up 4.5%), 367% above the lowest observed value of 155 on August 26 and 82% below the highest observed value of 3,874 on April 27. The 7-day average number of COVID-19 deaths is 21 (same as yesterday), 90% above the lowest observed value of 11 on September 9. and 88% below the highest observed value of 175 on April 24.
Two weeks ago, the 7 day confirmed case average was 853, the 7 day confirmed deaths average was 16, the 7 day hospitalization average was 432, and the 7 day weighted average positivity rate (excluding higher education) was 3.2%.
Continuing bad news on the day-by-day front, with deaths, new cases, active cases, positivity, and hospitalization all up. The longer-term trends aren't great, either, and keep going in the wrong directions. On the other hand, things aren't nearly as bleak as they were back in April, when we were looking at hospitalizations approaching four thousand and positivity over twenty-five percent. So that's something, at least.
The town of Acton has yet to post an update today. As of the most recent report at 10PM on November 10, the town of Acton reported 256 cumulative cases of COVID-19 in town with 23 individuals in isolation, 212 recovered and 21 fatalities.