get_expanded_homicide_data
Retrieve expanded homicide data from the Supplementary Homicide Report with victim and offender demographics, weapon types, and circumstances. Filter by national, state, or agency level and date range.
Instructions
Get Supplementary Homicide Report (SHR) data with expanded details on homicides including victim/offender demographics, weapons, and circumstances.
Args: level: Geographic level — "national", "state", or "agency" data_type: "counts" for time series or "totals" for demographic/detail breakdowns from_date: Start date in mm-yyyy format (e.g., "01-2020") to_date: End date in mm-yyyy format (e.g., "12-2022") state: Two-letter state abbreviation (required when level is "state") ori: Agency ORI code (required when level is "agency") aggregate: Aggregation level — "yearly" (default, sums monthly into yearly) or "monthly" (monthly granularity). Only applies when data_type is "counts".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ori | No | ||
| level | Yes | ||
| state | No | ||
| to_date | Yes | ||
| aggregate | No | yearly | |
| data_type | Yes | ||
| from_date | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |