Darren Fishell

Darren Fishell

Business Intelligence Developer

Track Maine coronavirus cases and rates by county

Written on July 13, 2021

COVID-19, the illness caused by the novel coronavirus, continues to spread throughout Maine, with the first signs emerging of “community spread” in Cumberland County as of Tuesday, March 17.

The Maine CDC is publishing details about each confirmed case in the state, as well as negative tests, which are visualized below.

As the Maine CDC publishes these numbers, its director, Dr. Nirav Shah, has noted that it’s unclear how much the data lags behind the real spread of the virus.

“What we know about outbreaks is that we are often just detecting the tip of the iceberg,” Shah told reporters on March 22, according to Maine Public.

The dashboards below update daily from Google Sheets.

For ongoing coverage of coronavirus in Maine, see the free coverage from the Bangor Daily News, the Portland Press Herald and Maine Public. On Twitter, OpenMaine also has some cool digital resources in the works.

The chart on the left warrants a close look, as it reflects the growth trend in cases, on a logarithmic scale. As The New York Times detailed:

Unconstrained, the coronavirus spreads exponentially, the caseload doubling at a steady rate. That curve, plotted linearly, is a skyrocketing curve. Plotted logarithmically, however, it transforms into a straight line — which means that deviations from the exponential spread of the virus become much easier to discern.

That kind of curve is great to show places avoiding exponential case growth, but it can mask the still concerning linear growth, as is the case in Cumberland County.

This trend is visible in the county-level chart below, also since the first day that an area hit 10 cases or more.

We can also use the current growth rate in confirmed COVID-19 cases to calculate how long it is taking for cases to double, called the doubling time.

The chart below shows this doubling time for each state, also starting from the first day where each state had at least 10 cases.

The process behind the charts

The data above is scraped from the Maine CDC website in Python, based on table names at the CDC’s coronavirus webpage (more details in this Github repository). The scraper runs every hour from 11 a.m. to 6 p.m. and stores a time series of the daily updates from the Maine CDC, starting March 10.

Tableau Public refreshes every 24 hours, in the afternoon.

You can find the raw output in this project at data.world or this Google Sheet.

The sources include four of the different tables that the Maine CDC is publishing separately: a summary of cases, cases by county, cases by age and cases by sex.