COVID-19 Counts by Age Cohort 5/11/2023

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

This dataset contains weekly totals of COVID-19 cases among Cambridge residents by age group.

Of note:

The graphs do not include COVID-19 cases among Cambridge residents living in skilled nursing or assisted living facilities.

The case counts comprise confirmed cases and two types of probable cases: (1) people who receive a positive antigen test and (2) people who are a known contact of a confirmed case and have received a clinical diagnosis based on their symptoms. The case counts do not include antibody positive cases.

Cases are assigned to a given week based on the date of symptom onset. If that information is not available, the date reflects the test date (if available), or the report date (when a laboratory reports results to the state health department).

Dates on the line graphs reflect the start date of the week. For instance, June 7 represents the week of June 7-13.

Counts for the most recent week are incomplete. Case counts for individual weeks going back in time may change as more information becomes available.

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-counts-by-age-cohort-5112023-negp-icdt\".\"covid19_counts_by_age_cohort_5112023\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.