Skip to main content
The Homicides module provides law enforcement with tools to document, investigate, and track homicide cases including detailed victim information, suspect data, and case circumstances.

Overview

This specialized module handles:
  • Homicide and femicide case registration
  • Victim profile documentation
  • Suspect/perpetrator information
  • Motive and circumstance tracking
  • Weapon classification
  • Relationship analysis between victim and perpetrator
  • Investigation status monitoring

Case Registration Workflow

Basic Case Information

1

Jurisdictional Data

Select the Regional Unit (UR) and specific police dependency handling the case.
2

Case Identification

Enter the preventive report number and year for case tracking.
3

Date Recording

Document the date of the incident using the date picker.

Victim Information

Detailed victim data is essential for investigation:
{
  "victima": "Last name and first name",
  "edad": "Age of victim",
  "sexo": "F or M (required)"
}
Femicide Classification: Cases involving female victims killed due to gender-based violence are classified as FEMICIDIO for specialized tracking and reporting.

Investigation Details

Motivation Analysis

The system tracks various motives behind homicides:
The database includes a comprehensive list of potential motives stored in the homicidio_motivos table:
  • Criminal activity related
  • Domestic violence
  • Robbery
  • Revenge
  • Drug-related
  • Other classified motives
Understanding the victim-perpetrator relationship is crucial for investigation:
SELECT id, descripcion 
FROM homicidio_relacion
Common relationships tracked:
  • Family member
  • Partner/spouse
  • Acquaintance
  • Stranger
  • Unknown

Crime Modality

The system categorizes how the homicide was committed:
// Crime modality options from database
SELECT descripcion 
FROM homicidio_modalidad

Method Classification

  • Premeditated
  • Crime of passion
  • During commission of another crime
  • Accident escalation

Circumstantial Factors

  • Location type
  • Time of day
  • Witnesses present
  • Associated criminal activity

Weapon Documentation

Weapon Type Classification

The system includes a comprehensive weapon tracking system:
SELECT descripcion 
FROM homicidio_tipo_armas
Available weapon categories:
  • Firearm
  • Bladed weapon
  • Blunt object
  • Strangulation
  • Other methods
Evidence Documentation: Weapon information is critical for forensic analysis and prosecution. Ensure accuracy in all weapon-related fields.

Suspect Information

Perpetrator Documentation

The system captures suspect information when available:
<input name="autor" 
       type="text" 
       id="autor" 
       size="50">
Investigation Status: The suspect field can be left blank for unsolved cases and updated as the investigation progresses.

Form Structure

Complete Data Collection

The homicide reporting form collects information in this sequence:
  1. Administrative Data
    • Regional Unit
    • Dependency
    • Preventive report number and year
    • Date of incident
  2. Victim Profile
    • Full name
    • Age
    • Gender
  3. Case Classification
    • Type (Homicide/Femicide)
    • Motivation
    • Victim-perpetrator relationship
  4. Crime Details
    • Modality
    • Weapon type and description
  5. Investigation Data
    • Suspect information
    • Case status

Database Operations

Case Submission

// Form submission trigger
<input name="GUARDAR9" 
       type="submit" 
       value="GUARDAR">
The system validates required fields:
  • Regional Unit
  • Dependency
  • Preventive report number and year
  • Date
  • Victim name
  • Gender
  • Case type
  • Relationship classification
  • Modality

Case Display and Reporting

// Display existing cases
<input type="submit" 
       name="MOSTRAR" 
       value="MOSTRAR">
Use the MOSTRAR (Show) button to review existing cases before creating new entries, preventing duplicate case registration.

Investigation Tracking

Case Status Management

While not explicitly visible in the form, the system supports tracking:

Open Cases

Active investigations

Under Investigation

Cases with active leads

Resolved

Solved cases with arrests

Data Analysis Capabilities

The homicide database enables:
Generate specific reports on gender-based violence and femicide rates across jurisdictions.
Analyze common motives in different regions to inform prevention strategies.
Track weapon types used in homicides for policy and enforcement planning.
Monitor investigation success rates and case resolution timelines.

Best Practices

Sensitive Information: Homicide cases contain highly sensitive data. Ensure proper access controls and data protection measures are in place.
Continuous Updates: Case records should be updated as investigations progress, particularly regarding suspect information and case status.
Relationship Documentation: Accurate victim-perpetrator relationship classification is crucial for domestic violence and femicide tracking.

Required Fields Summary

FieldTypeRequiredOptions
Regional UnitSelectYesUR-1 through UR-15
DependencySelectYesFrom dependencies table
Preventive NumberTextYes-
Preventive YearTextYes-
DateDateYesDate picker
Victim NameTextYes-
AgeTextNo-
GenderSelectYesF/M
Case TypeSelectYesHOMICIDIO/FEMICIDIO
MotivationSelectNoFrom motivos table
RelationshipSelectYesFrom relacion table
ModalitySelectYesFrom modalidad table
Weapon TypeSelectNoFrom tipo_armas table
Weapon DescriptionTextNo-
PerpetratorTextNo-

Build docs developers (and LLMs) love