Citywide crime statistics
summarize_crimeGet citywide CMPD incident counts grouped by offense, division, year, or neighborhood. Filter by year or offense to view crime trends and compare areas.
Instructions
Citywide CMPD incident counts grouped by offense, division, year, or neighborhood.
Use group_by='year' with an offense filter for trends, e.g. robberies per year since 2017.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| year | No | Calendar year. | |
| limit | No | Maximum number of records to return. | |
| offense | No | e.g. 'robbery'. | |
| group_by | No | offense | |
| patrol_division | No | e.g. 'Central', 'Providence'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| notes | No | ||
| source | Yes | ||
| filters | Yes | The SQL where clause that was applied. | |
| group_by | Yes | ||
| location | No | ||
| statistic | Yes | ||
| radius_miles | No |