edschweppe | Not a local COVID-19 update

You're viewing

edschweppe's journal
Create a Dreamwidth Account Learn More

Reload page in style: site light

There's apparently some sort of technical issue with the Commonwealth's COVID-19 dashboard. The expected raw data download for today is not available, and the dashboard webpage has the following notice:

PLEASE NOTE: Due to a technical issue, the interactive dashboard is not available at this time. This dashboard will be posted as soon as possible.

Now, it does appear as though the data has been updated in the Tableau dashboard - it's currently showing 66 newly confirmed deaths, 1,553 newly reported confirmed cases, and 102,052 newly reported confirmed tests. However, without the raw data, I can't generate the wall-o-text; so I'll just wait on that one.

Flat | Top-Level Comments Only

From:

edschweppe

Well, it turns out the state changed their raw data format again, naturally in a manner which broke my code. Here's what the wall-o-text should have looked like, minus the cut tags and commentary.

As of 5PM today, the Commonwealth of Massachusetts is reporting 66 newly reported confirmed deaths (29 more than yesterday - up 78.4%) for a total of 15,925 deaths, 1,553 newly reported confirmed cases (573 more than yesterday - up 58.5%) for a total of 553,220 cases, and 102,052 newly reported molecular tests (46,045 more than yesterday - up 82.2%). The seven day average positivity rate is 1.82%, compared to 1.82% yesterday. Excluding higher education, the seven day average positivity rate is 3.04%, compared to 3.02% yesterday. The number of estimated active cases was 28,550 (317 less than yesterday - down 1.1%). The state also reported 4 newly reported probable deaths (3 more than yesterday - up 300.0%) for a total of 327 and 346 newly reported probable cases (162 more than yesterday - up 88.0%) for a total of 31,523. Combining the confirmed and probable numbers gives 70 new deaths for a total of 16,252 and 1,899 new cases for a total of 584,743. There were 755 COVID-19 patients in hospital (20 less than yesterday - down 2.6%), 173 COVID-19 patients in ICUs (14 less than yesterday - down 7.5%) and 109 COVID-19 patients on ventilators (intubated) (7 less than yesterday - down 6.0%).

Today being Wednesday, the weekly data points were also updated. The average age of hospitalized patients over the past week is 69 (same as last week) while the average age of deaths over the last two weeks is 77 (1 less than last week - down 1.3%). The fourteen-day average test turnaround time (from sample draw to DPH report) is 1.41 (compared to 1.36 last week). The average daily incidence per 100k population over the last 14 days is 21.3 (compared to 23.3 last week).

Of the four overview trends (formerly the Page 2 "key metrics"), the 7-day average of newly confirmed cases is 1,076.0 (40 less than yesterday - down 3.6%), 585% above the lowest observed value of 157.0 on 7/4/2020 and 83.0% below the highest observed value of 6,242.0 on 1/8/2021. The 7-day weighted average of positive molecular test rate is 1.82% (0 more than yesterday - up 0.1%), 136% above the lowest observed value of 0.8% on 9/21/2020 and 93% below the highest observed value of 27.7% on 4/15/2020. The 7-day average number of COVID-19 patients in hospital is 800.0 (15 less than yesterday - down 1.8%), 416% above the lowest observed value of 155.0 on 8/26/2020 and 80% below the highest observed value of 3,874.0 on 4/27/2020. The 7-day average number of COVID-19 deaths is 39.0 (4 more than yesterday - up 11.4%), 254% above the lowest observed value of 11.0 on 9/9/2020 and 78% below the highest observed value of 175.0 on 4/24/2020.

Statewide, hospitals reported 9,213 non-ICU beds, of which 7,310 (79.3%) were occupied by non-COVID patients, 582 (6.3%) were occupied by COVID patients, and 1,321 (14.3%) remained available. Hospitals also reported 1,420 ICU beds, of which 867 (61.1%) were occupied by non-COVID patients, 173 (12.2%) were occupied by COVID patients, and 380 (26.8%) remained available. By comparison, hospitals reported yesterday a total of 9,159 non-ICU beds, of which 6,945 (75.8%) were occupied by non-COVID patients, 588 (6%) were occupied by COVID patients, and 1,626 (17.8%) remained available. Hospitals also reported yesterday a total of 1,422 ICU beds, of which 811 (57.0%) were occupied by non-COVID patients, 187 (13.2%) were occupied by COVID patients, and 424 (29.8%) remained available.

Two weeks ago, the 7 day confirmed case average was 1,268.0, the 7 day confirmed deaths average was 47.0, the 7 day hospitalization average was 1,182.0, and the 7 day weighted average positivity rate was 2.20% (or 3.63% excluding higher education).

The daily raw data file used to create this report is available here.

The town of Acton's current Google Data Studio dashboard is showing 16 active and 775 cumulative cases as of March 2. The most recent "newsflash style update" at 5PM on February 26, 2021 reported 766 cumulative cases with 27 individuals in isolation, 707 persons recovered and 32 fatalities.