Confirmed Cambridge COVID-19 Cases 4/1/2020

This dataset is no longer being updated as of 4/1/2020. It is being retained on the Open Data Portal for its potential historical interest.

For the more recent version of this data (which is also now historical), please visit: https://data.cambridgema.gov/Public-Safety/Confirmed-COVID-19-Cases-in-Cambridge/inw8-ircw

Confirmed COVID-19 cases in the City of Cambridge 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.

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/confirmed-cambridge-covid19-cases-412020-4nyp-vuze\".\"confirmed_cambridge_covid19_cases_412020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.