cambridgema-gov/covid19-neighborhood-case-count-7v3g-pi6d
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 hours ago
Indexed 4 hours ago

COVID-19 Neighborhood Case Count

This dataset shows positive COVID-19 Cases in Cambridge by neighborhood. It is reported to Cambridge by the Commonwealth of Massachusetts once per day. Of Note:

Population data are from Cambridge Community Development, and are sourced from the 2013-2017 American Community Survey estimates, and may differ from actual population counts.

Cases for which the home address is missing, misspelled, or incorrect (i.e., not an actual Cambridge address) may not be represented on the maps. For these reasons, the total case count reflected in the maps is lower than the current case count for the city.

The maps reflect the time period of March 10, 2020 (first known positive case) through present. Cases are not removed from the maps when a resident recovers or passes away.

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

Data are updated once per day. Case counts are subject to change.

The Cambridge Public Health Department (CPHD) is using a tool called “geocoder,” developed by the City’s Information Technology Department, to assign the home addresses of cases to one of the city’s 13 neighborhoods. The geocoder tries to match each case address to the City's official address list. Cambridge's geocoder is run locally and off-network to ensure health data privacy.

To learn more about the demographics of the city’s neighborhoods, see City of Cambridge Neighborhood Statistical Profile 2019.

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-neighborhood-case-count-7v3g-pi6d\".\"covid19_neighborhood_case_count\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_neighborhood_case_count
     
     
     
     
     
Upstream Metadata