COVID-19 Long Term Care Facility Cases

This table shows selected demographic information for Cambridge residents living in skilled nursing or assisted living facilities who are classified as confirmed, probable, or suspect cases (see “Case Count by Classification” section for definitions). Demographic information includes gender, age range, and race/ethnicity.

About the COVID-19 Rapid Testing Program: On April 9, the Broad Institute, in partnership with the City of Cambridge and Pro EMS, launched a surveillance testing pilot program in Cambridge skilled nursing and assisted living facilities. The goal of the program is to gain an accurate picture of the true infection rate in these facilities by testing all residents and workers regardless of whether they have symptoms or feel ill. Positive cases among facility residents reflect three rounds of testing in April and May of all residents at the seven skilled nursing and assisted living facilities in Cambridge, as well as other testing ordered by medical providers.

Of note:

The case count includes those who have recovered, are currently sick with COVID-19, and who have died from complications of the disease. Any category with a case count less than five is omitted to protect individual privacy.

The Cambridge case count reflects current data received from the Massachusetts Department of Public Health.

It is important to note that race and ethnicity data are collected and reported by multiple entities and may or may not reflect self-reporting by the individual case. The Cambridge Public Health Department (CPHD) is actively reaching out to cases to collect this information. Due to these efforts, race and ethnicity information have been confirmed for over 80% of Cambridge cases, as of June 2020.

Race/Ethnicity Category Definitions:

“White” indicates “White, not of Hispanic origin.”

“Black” indicates “Black, not of Hispanic origin.”

“Hispanic” refers to a person having Hispanic origin. A person having Hispanic origin may be of any race.

“Asian” indicates “Asian, not of Hispanic origin.”

"Unknown" indicates that the originating reporter or reporting system did not capture race and ethnicity information or the individual refused to provide the information.

"Other" indicates multiple races, another race that is not listed above, and cases who have reported nationality in lieu of a race category recognized by the US Census. Population data are from the U.S. Census Bureau’s 2014–2018 American Community Survey estimates and may differ from actual population counts. "Other" also includes a small number of people who identify as Native American or Native Hawaiian/Pacific islander. Because the count for Native Americans or Native Hawaiian/Pacific Islanders is currently < 5 people, these categories have been combined with “Other” to protect individual privacy.

The table is updated daily at 4 p.m.

**Living in a facility is defined as a Cambridge resident who lives in a skilled nursing or assisted living facility.

^Positive cases among facility residents reflect three rounds of testing in April and May of all residents at the seven skilled nursing and assisted living facilities in Cambridge, as well as other testing ordered by medical providers.

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-long-term-care-facility-cases-ckq7-kjti\".\"covid19_long_term_care_facility_cases\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.