Bellinghamscan.com header image
Civic TechnologyAI Implementation

Automated Daily Crime Report & Newsletter

Local safety intelligence shared with 1,000+ subscribers every day

The Challenge

Crime Data ≠ Safety Intelligence

The Bellingham Police Department publishes incident data daily, however, the raw feed makes seeing the full picture nearly impossible for the residents it actually affects. Our insight: passive transparency wasn't translating into active intelligence.

Key Pain Points

  • Official crime data didn't offer safety insights
  • No geographic visualization
  • Inability to correlate incidents to patterns
  • Passive transparency failing to inform communities
The Solution

Daily Intelligence Reports

Recognizing the gap between publicly available incident data and everyday understanding, we developed the Bellingham Scan - an automated daily newsletter & online report that helps Bellingham residents see what's happening across the city. Organizing incidents by location, timing, and type, the Bellingham Scan turns scattered data into a clear, day-to-day public safety intelligence. Since our launch in November of 2025, we've seen tremendous support from our local community and are preparing to deploy the framework throughout communities across Washington.

Technologies & Methods

PostgreSQLWeb ScrapingData EnrichmentWebapp Development
The Results

A Community Favorite

Just over 3 months into operation, the Bellingham Scan sends daily crime intelligence to more than 1,000 subscribers, 80% of which engage with our publications every single day.

1000+
Subscribers
Engaged community members receiving regular updates
20,000+
Incidents Indexed
Historical incidents we've processed
2 people
Team Size
High impact, lean operation
Multi-city
Expansion
Actively deploying to communities across WA

Want similar results?

Discover how technology can maximize your impact without bloating processes.