Cambridge Vaccine Demographics by Week

This open dataset shows data on Cambridge residents who have received a COVID-19 vaccine at any location (e.g., mass vaccination site, pharmacy, doctor's office). These data come from the Massachusetts Department of Public Health's weekly report on vaccine doses administered by municipality. The report is released on Thursdays. This open dataset includes data going back several weeks and complements another open dataset called "Cambridge Vaccine Demographics," which shows data for the latest week (https://data.cambridgema.gov/Public-Health/Cambridge-Vaccination-Demographics/66td-u88k)

The Moderna and Pfizer vaccines require two doses administered at least 28 days apart in order to be fully vaccinated. The J&J (Janssen) vaccine requires a single dose in order to be fully vaccinated.

The category "Residents Who Received at Least One Dose" reflects the total number of individuals in the fully and partially vaccinated categories. That is, this category comprises individuals who have received one or both doses of the Moderna/Pfizer vaccine or have received the single dose J&J (Janssen) vaccine.

The category "Fully Vaccinated Residents" comprises individuals who have received both doses of the Moderna/ Pfizer vaccine or the single-dose J&J vaccine.

The category "Partially Vaccinated Residents" comprises individuals who have received only the first dose of the Moderna/Pfizer vaccine.

Source: Weekly COVID-19 Municipality Vaccination Report. Massachusetts releases updated data each Thursday at 5 p.m.

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/cambridge-vaccine-demographics-by-week-r3q4-v3ae\".\"cambridge_vaccine_demographics_by_week\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.