Law Enforcement Agency Database Agent
Gene spends 15-20 hours every week manually matching data across five separate sources: an Excel file with 18,000 agency names and budgets, a regional database with police chief contacts, Louisiana's LIBERS compliance map, six purchased state datasets, and trade show lead sheets. Building a single call list for a campaign requires opening all five files, finding matching records, and copying contact info into a new spreadsheet. A query like 'which non-compliant Southeast agencies are using Lemus?' takes two days of opening files, finding matching records, and copying contact info into a new spreadsheet.
Gene's sales team imports all five sources into one queryable database. A filter for 'non-compliant Southeast agencies using Lemus' returns results in seconds. The team exports a contact list with agency names, chief contacts, emails, phone numbers, and metadata (size, budget, current vendor) formatted for Zoho CRM or email campaigns. Personnel changes are updated manually in the database and reflected in future exports. Saved queries let the team re-run recurring campaigns monthly without rebuilding filters.
15-20 hours a week cross-referencing five spreadsheets to build one call list
Gene's sales team targets 18,000 US law enforcement agencies.
15-20 hours per week on manual cross-referencing that should be a simple database query
Eight annual events generating 10-15 leads each, but no centralized system to organize and follow up on collected contacts
Five separate files with agency data, compliance status, contact info, and vendor assignments that don't talk to each other
One queryable database replaces five spreadsheets
Complex multi-source queries run in minutes instead of days of manual spreadsheet matching
Manual update interface keeps contact lists current when chiefs change, without waiting for annual database refreshes
CSV exports include agency-level data (size, budget, vendor, compliance status) and contact-level data (name, title, email, phone) formatted for immediate use in Zoho or email tools
Build a filter set once, save it, re-run it monthly as your team works through the list
The agent consolidates Excel files, regional contact databases, NIBRS compliance maps, purchased state datasets, and trade show leads into a single platform. Filter by NIBRS compliance status, current RMS vendor (Lemus, QuickPD, ProPhoenix, Mark43, legacy systems), geography, and event proximity. Export contact lists formatted for Zoho CRM or email campaigns in seconds. Gene's sales team answers complex targeting questions in ten minutes instead of two days.
Import, filter, export
The agent consolidates your existing data sources into one queryable platform, then surfaces exactly the agencies you need to reach for each campaign.
Upload Excel files with agency names and budgets, regional databases with police chief contacts, NIBRS compliance maps, and purchased state datasets. The agent normalizes different column names and formats into a unified schema.
Query the consolidated database by NIBRS compliance status (compliant vs non-compliant), current RMS vendor (Lemus, QuickPD, legacy systems), state or region, and proximity to upcoming trade shows. Combine filters to find exactly who you need to reach.
Download filtered results as CSV with agency names, chief contacts, emails, phone numbers, and metadata (size, budget, current vendor). Format is ready for Zoho CRM import or email campaign tools.
Manually add or edit contacts when a new chief is hired or someone is promoted. Changes are saved immediately and reflected in future exports.
Build a filter set for a campaign (e.g., 'Southeast non-NIBRS agencies using legacy software'), save it, and re-run it monthly to track progress and avoid duplicate outreach.
Excel files with agency names, sizes, and budgets +
Master list of 18,000 US law enforcement agencies with officer counts and budget information
Regional database with police chief contacts +
Current police chiefs, captains, and IT directors with names, titles, emails, and phone numbers, updated annually
State NIBRS compliance data +
Louisiana LIBERS map and other state datasets showing which agencies are compliant or non-compliant with National Incident-Based Reporting System
Six-state purchased datasets +
Additional agency details and compliance information from purchased data sources
Trade show lead sheets +
Contacts collected at eight annual events with agency names, attendee names, and expressed interest notes
Normalize and consolidate data +
Map different column names and formats from five sources into unified schema with agencies, contacts, and metadata
Deduplicate agencies +
Match agencies across sources using name and state as composite key to avoid duplicate records
Enrich with compliance and vendor status +
Link NIBRS compliance data and current RMS vendor assignments to each agency record
Geocode for event proximity +
Calculate distance from each agency location to upcoming trade show locations for proximity-based filtering
Apply multi-criteria filters +
Enable simultaneous filtering by NIBRS status, vendor, geography, agency size, and event proximity
Queryable agency database +
Consolidated platform with 18,000 agencies, contacts, compliance status, vendor assignments, and metadata accessible via web interface
Filtered contact lists +
CSV exports with agency names, chief contacts, emails, phone numbers, size, budget, NIBRS status, and current vendor
Campaign-ready exports for Zoho CRM +
CSV formatted for direct import into Zoho CRM with standardized column names and phone number formatting
Saved queries +
Reusable filter sets for recurring campaigns (e.g., 'Q2 Southeast NIBRS Non-Compliant') that show current result count and track progress over time
Updated contact records +
Manual CRUD interface for adding, editing, or removing contacts when personnel changes occur at agencies
Is this for you?
- + RMS software vendors targeting non-compliant agencies - Companies selling records management systems to law enforcement can identify and reach the 35-40% of US agencies still not reporting to NIBRS
- + Sales teams with multiple data sources - Teams managing agency databases, regional contact lists, compliance data, and purchased datasets across separate files and spreadsheets
- + Trade show-driven sales motions - Sales organizations attending 5+ events per year and collecting leads that need to be organized, deduplicated, and followed up on systematically
- + Vendor displacement campaigns - Teams targeting agencies using legacy RMS platforms (Lemus, QuickPD, Access-based systems) for replacement sales
- + Small to mid-size sales teams - Organizations with 1-5 sales reps who need to build targeted call lists without manual spreadsheet work
- - Agencies that don't segment by compliance or vendor status - If your sales motion doesn't rely on NIBRS compliance or current RMS vendor as targeting criteria, the core filtering logic won't apply
- - Fully automated dialer workflows - This platform exports contact lists for manual outreach. If you need click-to-call automation or call sequencing, that's a separate integration
- - Real-time NIBRS status monitoring - The database uses static compliance data from state sources. If you need continuous monitoring of compliance status changes, this isn't the right tool
- - Agencies with 100+ person sales teams - This build is optimized for small teams (1-5 reps) managing 18K prospects. Enterprise-scale CRM systems may be more appropriate
Scoped build plus usage-based runs
The agent is built as a custom web application hosted on Railway. Pricing covers the initial build, data import setup, and query interface. Ongoing costs are based on monthly database queries and contact list exports.
- Initial build includes prototype with 200 synthetic agencies and full query/export functionality
- Data import setup covers mapping your Excel files, regional database, and state datasets into the unified schema
- Monthly usage costs depend on query volume and export frequency
- Zoho CRM integration starts with CSV export; direct API sync is a future phase
How long does it take to build a targeted call list from five spreadsheets?
With the agent, ten minutes. Gene's team imports Excel files, regional contact databases, NIBRS compliance maps, and purchased state datasets into one queryable platform. A filter like 'non-compliant Southeast agencies using Lemus' returns results instantly. Without the agent, the same query takes two days of opening files, finding matching records, and copying contact info into a new spreadsheet.
Can I filter agencies by NIBRS compliance status and current RMS vendor at the same time?
Yes. The agent supports combination filters. You can query by NIBRS compliance status (compliant or non-compliant), current RMS vendor (Lemus, QuickPD, ProPhoenix, Mark43, legacy systems), geography (state or region), agency size, and proximity to trade show events. Apply multiple filters simultaneously to find exactly who you need to reach for each campaign.
What happens when a police chief changes or someone gets promoted?
You manually add or edit the contact in the agent's interface. Update the name, title, email, or phone number for that person at the agency. Changes are saved immediately and reflected in all future exports. This keeps your contact lists current without waiting for annual database refreshes.
Can I export contact lists formatted for Zoho CRM?
Yes. The agent exports filtered results as CSV with agency names, chief contacts, emails, phone numbers, and metadata (size, budget, current vendor, NIBRS status). The format is ready for direct import into Zoho CRM or email campaign tools. Your sales team can download a call list and load it into Zoho in seconds.
How do I find agencies near an upcoming trade show?
Enter the trade show location and radius (for example, 150 miles from Miami). The agent calculates distance from each agency location to the event and surfaces nearby agencies. You can then filter those results by NIBRS compliance status, vendor, or other criteria to build a pre-event outreach list.
Can I save a filter set and re-run it monthly?
Yes. Build a filter set for a campaign (for example, 'Southeast non-NIBRS agencies using legacy software'), save it with a name, and re-run it anytime. Each saved query shows the filter criteria, result count when saved, and current result count. This lets you track progress on recurring campaigns without rebuilding filters each time.
What data sources does the agent consolidate?
The agent imports Excel files with agency names and budgets, regional databases with police chief contacts, state NIBRS compliance data (like Louisiana's LIBERS map), purchased state datasets, and trade show lead sheets. All five sources are normalized into one queryable database so you stop manually cross-referencing separate files.
Is this tool built for large enterprise sales teams?
No. The agent is optimized for small to mid-size sales teams (1-5 reps) managing 18,000 prospects. If your organization has 100+ person sales teams, enterprise-scale CRM systems may be more appropriate. The agent is designed to eliminate spreadsheet work for teams that need to build targeted call lists without manual data entry.
Stop spending 15 hours a week on spreadsheet work. Start building targeted call lists in minutes.
The agent consolidates your five data sources into one queryable platform. Filter by NIBRS compliance, vendor, geography, and event proximity. Export contact lists ready for Zoho or email campaigns. Your sales team gets the intelligence they need to reach the right agencies at the right time.