The problem
Repeat demand was visible in daily work but hard to measure across legacy records. Names, identifiers, and arrest histories had to be reconciled before the pattern could be trusted or used.
Project
C.O.A.P.
Turned fragmented arrest records into a recurring four-agency response to chronic offending.
OutcomeThe analysis showed that roughly 38% of arrestees accounted for 73% of arrests, then became an operating multi-agency program.
What I did
I cleaned and reconciled records covering 4,375 people and 10,046 arrests, identified the concentration, built the visual explanation, and helped turn the finding into a recurring candidate-review process shared across four agencies.
What happened
The work moved from analysis to implementation: a branded program, multi-agency launch, public explanation, and continuing analytical support rather than a report left on a shelf.
The evidence
The point, made visible.
The numbers and working sequence provide context for the outcome.
- 4,375
- People analyzed
- 10,046
- Arrests reviewed
- 4
- Partner agencies
EvidenceAnalysis + Implementation
38% → 73%Share of people → share of arrests