COVID-19 Cumulative Cases by Date 12/8/2020

This dataset is no longer being updated as of 12/8/2020. It is being retained on the Open Data Portal for its potential historical interest.

For the more recent version of this data (which is also now historical), please visit: https://data.cambridgema.gov/Public-Safety/COVID-19-Case-Count-by-Date/axxk-jvk8

The data represented in this graph are dynamic and may change over time.

Since March 20, the Cambridge Public Health Department (CPHD) has provided data regarding COVID-19 case counts based on the date that the Massachusetts Public Health Department (MDPH) reported the case to CPHD (known as report date).

Beginning March 31, 2020, CPHD began providing COVID-19 case counts based on the onset time -- the date of a positive diagnosis -- which is preferable for studying disease patterns over time. Both sets of data provide the same number of total cases. CPHD often receives onset time (positive COVID-19 diagnosis) after the report date. Thus, the graph displaying onset time is recommended as a representation of the case counts per day.

Daily case counts reflect the total number of cases to date, including active and recovered individuals.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/covid19-cumulative-cases-by-date-1282020-tdt9-vq5y\".\"covid19_cumulative_cases_by_date_1282020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.