Icon for Socrata external plugin
Open repository in Console
Updated 2 days ago
Indexed 5 hours ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/sanitary-inspections-ryb9-qzmw\".\"sanitary_inspections\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • sanitary_inspections
Upstream Metadata