get_expanded_homicide_data
Retrieve expanded homicide data from the FBI's Supplementary Homicide Report, including victim/offender demographics, weapons, and circumstances. Query by national, state, or agency level with date ranges.
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". Years with fewer than 12 months of data are flagged in a top-level "_partial_years" key (rates are unweighted averages of the available months).
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 |