Icon for Socrata external plugin
Open repository in Console
Updated 3 months ago
Indexed 4 hours ago

COVID-19 Counts by Age Cohort

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/covid19-counts-by-age-cohort-negp-icdt\".\"covid19_counts_by_age_cohort\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_counts_by_age_cohort
Upstream Metadata