Sanitary Inspections

This dataset contains the findings of sanitary inspections carried out by the City of Cambridge's Inspectional Services Department. Inspectors visit establishments at least once every six months for routine inspections. The dataset includes the results of inspections that resulted in sanitary violation citations as well as records of inspections that discovered no sanitary violations. If no code number list listed for a given row, then that inspection resulted in no citations.

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/sanitary-inspections-ryb9-qzmw\".\"sanitary_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.