Templates Crime Investigation
The Vault · Crime Investigation

Case Workflow &
Data Model Reference

A complete operational reference for law enforcement and investigative teams — how Hubstream structures a criminal investigation from first report to case disposition, and what data gets captured at every stage.

Template type Starter Template
Use case Crime Investigation
Workflow stages 6 stages
Entity types 12 core entities
How It Works · 01–06

Case Workflow

Every criminal investigation moves through six stages — from first report to case disposition. Here's how Hubstream structures that journey for investigative teams.

01
Stage 1 · Intake

Report Intake & Case Opening

A new investigation opens when a report is received — from patrol, a tip line, a crime report form, a referral from another agency, or a proactive intelligence lead. Each intake channel maps to a structured form that captures the minimum required data: incident type, location, time, and initial parties. A case record is created automatically and assigned a case number.

Patrol Incident Report Public Tip Line Crime Report Form Agency Referral Proactive Intelligence Anonymous Report
02
Stage 2 · Triage & Assignment

Case Triage & Investigator Assignment

Incoming cases are reviewed and prioritized by a supervisor or triage workflow. Priority is scored based on crime type, severity, available evidence, and whether a suspect is identified. Cases are assigned to the appropriate unit or investigator, with workload visibility across the team dashboard. High-priority or multi-agency cases can be escalated immediately.

Priority Scoring Crime Type Classification Investigator Assignment Unit Routing Workload Dashboard Multi-Agency Escalation
03
Stage 3 · Investigation

Evidence Collection & Link Analysis

The investigator builds the case — collecting physical and digital evidence, recording witness and victim interviews, identifying and profiling suspects, and running link analysis. Hubstream's DataSpace connects persons, locations, vehicles, organizations, and prior cases into a network graph, surfacing patterns and associations that are invisible across disconnected records. Prior contacts, known associates, and geographic patterns are automatically surfaced from existing case data.

Evidence Logging Witness Interviews Suspect Profiling Link Analysis Network Graph Prior Contact Lookup Geographic Analysis
04
Stage 4 · Suspect Development & Legal Action

Suspect Development, Warrants & Surveillance

With a suspect identified, the team builds the evidentiary case. Warrant applications are tracked within the case record, along with surveillance logs, controlled buys, and undercover operation notes where applicable. All legal authorities and their status are logged — search warrants, arrest warrants, court orders — with expiry tracking and renewal alerts. Co-conspirators and associated networks are developed in parallel.

Warrant Tracking Surveillance Logs Controlled Operations Co-Conspirator Development Legal Authority Expiry Alerts
05
Stage 5 · Arrest & Prosecution Referral

Arrest, Evidence Package & DA Referral

At arrest, the case record is updated with the booking record, charges, and arresting officers. Hubstream auto-generates the prosecution referral package — case summary, evidence inventory, witness list, and timeline — formatted for the District Attorney or Crown Prosecutor. Charges are tracked through the court system with hearings, continuances, and plea negotiations logged against the case.

Arrest Record Charge Logging DA Referral Package Evidence Inventory Court Hearing Tracking Plea & Continuance Log
06
Stage 6 · Case Disposition & Reporting

Outcome Logging & Intelligence Reporting

When a case closes, the outcome is logged — conviction, acquittal, plea, case dismissed, or suspect deceased. All outcomes feed the analytics dashboard: clearance rates by crime type, investigator caseload trends, geographic hot spots, and repeat offender patterns. Intelligence generated during the investigation — gang affiliations, criminal networks, known locations — is retained in the system and made available to future investigations.

Case Disposition Clearance Rate Tracking Intelligence Retention Hot Spot Analysis Repeat Offender Flagging Executive Reporting
Connects with
RMS / CAD Systems NCIC / CLETS Facial Recognition LPR Systems Digital Forensic Tools Court Management Systems Gang Databases Tip Line / Crime Stoppers
Data Model · 12 Entity Types

What Gets Captured

Every entity in Hubstream's Crime Investigation template — what it represents, what fields it holds, and how it connects to the broader case record.

📁

Case / Investigation

The central record every other entity links to. Tracks the lifecycle of a single criminal case from intake to disposition.

Case Number · auto-generated Crime Type · classified by statute / UCR Status · open / active / suspended / closed Priority · scored + supervisor override Assigned Investigator(s) Unit / Division Disposition · conviction / acquittal / plea / dismissed Date Opened / Closed
📋

Incident Report

The initial report that opened the case — patrol report, tip, or referral. Preserves the original account before investigation begins.

Report Date / Time Reporting Source · patrol / public / agency Incident Description Incident Location Reporting Officer / Source Linked Case
🎯

Suspect

An individual under investigation. May be unidentified (John Doe) at case open, with identity confirmed as evidence develops.

Full Name / Aliases Date of Birth Known Addresses Physical Description Prior Record · linked cases Known Associates Gang Affiliation Status · wanted / arrested / charged / convicted
🛡️

Victim

An individual harmed by the crime. Linked to the case and to any witnesses or persons of interest they have a relationship with.

Full Name Date of Birth Contact Information Relationship to Suspect Injury / Impact Prior Reports Involving Victim Victim Services Referral
👁️

Witness

An individual who observed the crime or has relevant information. Interview records and credibility notes are attached to the witness record.

Full Name Contact Information Relationship to Parties Interview Date(s) Statement Summary Credibility Notes Willing to Testify
🗂️

Evidence

Any item — physical, digital, or documentary — collected to support the investigation. Chain of custody is maintained on every evidence record.

Evidence Type · physical / digital / documentary / forensic Description Collection Date / Location Collected By Chain of Custody Log Lab Results Storage Location
🏢

Organization / Gang

A criminal organization, gang, or group connected to the case. Enables network analysis across cases involving the same organization.

Organization Name / Gang Name Type · gang / criminal org / trafficking network Known Members Known Territories Primary Criminal Activity Linked Cases
📍

Address / Location

A physical location relevant to the case — crime scene, suspect residence, stash house, or place of business.

Street Address City / Region Coordinates (Lat/Long) Location Type · crime scene / residence / business / stash Linked Persons Linked Cases
🚗

Vehicle

A vehicle connected to the case — used in the crime, registered to a suspect, or identified via license plate reader or witness account.

Make / Model / Year / Color License Plate VIN Registered Owner Role · getaway / transport / surveillance Linked Persons / Cases
🔫

Weapon

A weapon recovered, seized, or linked to the crime — firearm, edged weapon, or other instrument. Ballistic and forensic data attached.

Weapon Type Make / Model / Caliber · firearms Serial Number Registered Owner Forensic Results ATF Trace Status Linked Cases / Suspects
⚖️

Warrant

A legal authority obtained during the investigation — arrest warrant, search warrant, or court order. Tracked from application through execution.

Warrant Type · arrest / search / court order Issued By · judge / court Issue Date Expiry Date Status · active / executed / expired Execution Date / Notes
🏛️

Arrest & Court Record

The legal record of an arrest and subsequent court proceedings — charges, hearings, pleas, and final disposition.

Arrest Date / Location Arresting Officer(s) Charges Filed Bail / Bond Status Court Dates Plea Disposition / Sentence
Link Analysis · Key Relationships

How the Entities Connect

The relationship paths that surface patterns across cases — the connections that turn individual records into an intelligence picture of criminal networks.

Suspect Prior Cases

When a suspect is added to a case, Hubstream automatically surfaces any prior cases they appear in — as a suspect, a witness, or an associate — giving investigators an immediate view of criminal history and patterns.

Suspect Known Associates

Associates linked to a suspect are surfaced from across the case database — identifying co-conspirators, gang members, and network connections that span multiple investigations and units.

Suspect Organization / Gang

Individual suspects are linked to criminal organizations or gangs, allowing investigators to see membership patterns, hierarchy, and the full scope of criminal activity tied to a network — not just a single case.

Address Multiple Cases

A single address connected to multiple cases — as a crime scene, a suspect's known residence, or a stash location — is flagged automatically, identifying problem locations and recurring criminal activity patterns.

Vehicle Suspect / Cases

A vehicle registered to or associated with a suspect is linked across all cases where it appears — connecting getaway cars, surveillance vehicles, and registered vehicles to the broader suspect profile.

Weapon Multiple Cases

A firearm or weapon linked to one case is checked against all other cases — connecting crimes committed with the same weapon and building the evidentiary chain for prosecution or ATF trace requests.

Victim Prior Reports

A victim appearing in prior cases — as a victim, witness, or associate — is surfaced automatically, helping investigators identify repeat victimization patterns, domestic violence cycles, and witness intimidation risks.

Case Related Cases (Geography / MO)

Cases with similar geographic footprints, crime types, or modus operandi are connected automatically — helping investigators identify serial offenders, crime series, and coordinated criminal activity across separate case numbers.

Add-On Modules · 02

Extend the Core Template

The Crime Investigation template covers the full investigative lifecycle. These add-ons bolt onto specific stages when your team needs a dedicated sub-workflow for specialized activity.

Extends Stage 1 · Intake

Crime Report Intake

A public or internal reporting portal that lets citizens, Crime Stoppers, or internal units submit crime reports directly into Hubstream — automatically creating a case record and routing it for triage.

Web form & email intake channel Auto-case creation on submission Anonymous report support Photo / evidence attachment Geo-tagged incident location Triage dashboard for incoming reports
View this template →
Extends Stage 3 · Investigation

Gang Intelligence Analytics

A specialized intelligence layer for investigations involving criminal organizations and street gangs — mapping membership, territory, hierarchy, and cross-case criminal activity into a persistent intelligence picture.

Gang member registry & profile management Hierarchy & affiliation mapping Territory & geographic pattern analysis Cross-case gang activity linking Intelligence retention across case closures
View this template →
Ready to build on this?

See the Template
Live in Hubstream

Request a demo and we'll walk you through how this workflow and data model work inside a real Hubstream environment — configured for your agency's case types, units, and investigative process.

Request a Demo → Back to Crime Investigation