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
65requests on Thursday, October 15
68daily average over the last 90 days
1category above the alert threshold on Thursday, October 15
6,083requests in the last 90 days
Volume
Ninety days of daily requests
Latest day
What moved
Traffic/Pedestrian Signal Issue3 vs 1.0 usual · z 2.03.0×
Missed Trash Pickup8 vs 3.0 usual · z 2.92.7×
Missed Recycling Pickup3 vs 1.7 usual · z 1.01.8×
Missed Food Waste Pickup (Green Bin)7 vs 4.5 usual · z 1.21.6×
Other12 vs 9.8 usual · z 0.71.2×
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
460
-11%
Other
223
-7%
Missed Trash Pickup
125
+1%
Tree Pruning Request
93
+52%
Missed Food Waste Pickup (Green Bin)
83
-3%
Botanical Obstruction
82
+91%
Roadkill / Dead Animal
78
-18%
Construction Complaint
58
+4%
Traffic Sign Issue
58
+21%
Sidewalk Obstruction
56
-19%
Trees - General Inquiry
55
+62%
Overflowing Public Trash/Recycling Receptacle
52
-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.
Archived16,52779.6%
Closed2,71113.1%
Acknowledged1,0675.1%
Open4522.2%
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.