The smallest feed by volume, but the only one with a true closure timestamp and a public permalink for every ticket.
Socrata, dataset 2z9k-mv9g
79requests on Wednesday, October 28
67daily average over the last 90 days
0categories above the alert threshold on Wednesday, October 28
5,873requests in the last 90 days
Volume
Ninety days of daily requests
Latest day
What moved
Construction Complaint6 vs 3.0 usual · z 1.72.0×
Missed Recycling Pickup4 vs 2.0 usual · z 1.42.0×
Sidewalk Defect3 vs 1.7 usual · z 1.01.8×
Tree Pruning Request3 vs 2.0 usual · z 0.71.5×
Bike Lane Obstruction23 vs 17.3 usual · z 1.41.3×
Traffic Sign Issue3 vs 2.3 usual · z 0.41.3×
Compared against the same weekday over the previous four weeks. Highlighted rows cleared the alert bar: at least 1.8× normal with a Poisson z of 2.5 or more.
Mix
Most reported in the last 30 days
The filled bar is the last 30 days; the bar behind it is the 30 days before that. The percentage is the change between them.
Bike Lane Obstruction
427
-1%
Other
146
-36%
Missed Trash Pickup
92
-26%
Missed Food Waste Pickup (Green Bin)
81
-11%
Roadkill / Dead Animal
72
-5%
Traffic/Pedestrian Signal Issue
56
+30%
Tree Pruning Request
55
-31%
Traffic Sign Issue
51
+2%
Rodent Sighting
48
+7%
Construction Complaint
45
-29%
Parking Complaint (Internal)
45
+50%
Sidewalk Obstruction
44
-32%
Cambridge only
Status of the last 12 months
Cambridge's terminal state is Archived, not Closed. Reading Closed alone would capture well under 1% of its tickets. Acknowledged means seen but not finished.
Archived15,90776.2%
Closed3,40616.3%
Acknowledged1,1105.3%
Open4462.1%
Reading this feed
What the data can and cannot tell you
Service requests filed through Commonwealth Connect, Cambridge's SeeClickFix-based reporting system.
The terminal status is Archived, not Closed. Fewer than 1% of tickets ever carry the Closed label.
Tickets that began as internal work orders are included but have their details suppressed, which inflates the Other category.
Usable history starts in 2016, when the dataset was created. Rows dated earlier are a scattered handful.
Daily volume is low enough that most individual categories cannot clear a same-day significance test. Quiet days here are genuinely quiet.