COVID-19 Case Count by Date 3/1/2020-11/24/2022

This dataset is no longer being updated as of 11/24/2022. It is being retained on the Open Data Portal for its potential historical interest.

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-case-count-by-date-31202011242022-axxk-jvk8\".\"covid19_case_count_by_date_31202011242022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.