Cambridge Sanitary Inspections Explorer

Interactive local explorer for sanitary inspection records: map, timelines, top code descriptions, streets/businesses, lag distributions, and a filterable table. This dataset appears to be row-level (often multiple rows per inspection case, e.g., one row per code/violation), so the app shows both row counts and unique case counts.

Tip: use the timeline range slider/zoom to focus on a period. Date filtering applies to the selected date field (issue/open/closed/corrected/submit).

Filtered rows
–
of total
Unique cases
–
of total
Unique businesses
–
non-null business names
Rows with code description
–
violation/code rows share
Rows/cases with coordinates
–
mappable records
Median lag (selected)
–
positive days only

Timeline

Counts by selected date field

Map of cases

Case-level points linked to filtered rows
case has code no code listed

Top code descriptions (row-level)

Top streets

Top businesses

Lag distribution

Recent filtered rows

DateCaseBusinessAddressCode #Code description
Data caveats worth keeping in mind: this export appears to mix inspection/case-level and violation/code-level information in the same table (multiple rows can belong to one case), some records lack coordinates, some date fields are missing, and lag calculations can be negative in a small number of records (likely data-entry/order-of-events quirks). Treat patterns as clues for follow-up, not final causal conclusions.