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

COVID-19 Community Cases

COVID-19 cases for residents in the City of Cambridge community outside of long term care facilities, as reported by the Cambridge Public Health Department. This dataset summarizes cases by age cohort and gender.

Cambridge Public Health Department (CPHD) data regarding case counts come directly from MDPH and their surveillance system (MAVEN). We use the language and terminology per the Centers for Disease Control and Prevention (CDC) guidance, and recent guidance categorizes all confirmed or presumptive positive cases as positive. CPHD understands that case counts may be higher, due to a number of factors:

(1) Testing capabilities have been increased by other area lab organizations and hospitals and not all of the test results are reported to MDPH or CPHD.

(2) People may be asymptomatic (or have very mild symptoms) and do not realize that they may have COVID-19 and need to be tested.

(3) Providers may be offering diagnoses based on symptoms and history (rather than testing) and telling patients that they are likely positive and should stay home and self-quarantine for 14 days. (e.g, Someone might call their provider with a few symptoms and indicate that they were with someone from Biogen. In this case, the doctor may assume positive for COVID-19 and ask the patient to self-isolate at home for two weeks).

This is the process that the CPHD, and all local health departments, is following.

Total positive cases include total deaths. Any count <5 will be suppressed for privacy reasons

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-community-cases-jpj7-da7k\".\"covid19_community_cases\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • covid19_community_cases
Upstream Metadata