Convert › F005
Clearance Rate by Offense
CJIWave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Clearance Rate by Offense - Agency F (2024) | RSSSRS | NIBRS | 887 | 9/30/2026 9:30 PM | Mapped |
| Clearance Rate by Offense - Agency H (2025) | RSSSRS | NIBRS | 16 | 9/14/2026 9:25 AM | Mapped |
| Clearance Rate by Offense - Agency C (2025) | RSSSRS | NIBRS | 10 | 9/13/2026 4:28 PM | Mapped |
| Clearance Rate by Offense - Agency I (Last 90 Days) | RSSSRS | NIBRS | 10 | 7/29/2026 9:47 PM | Mapped |
| Clearance Rate by Offense | RSSSRS | NIBRS | 8 | 9/14/2026 6:18 AM | Mapped |
| Clearance Rate by Offense - Agency L (2024) | RSSSRS | NIBRS | 6 | 8/4/2026 4:41 AM | Mapped |
| Clearance Rate by Offense - Agency J (2025) | RSSSRS | NIBRS | 0 | Never | Mapped |
| Clearance Rate by Offense - Agency D (2024) | RSSSRS | NIBRS | 0 | Never | Mapped |
8 of 8
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 8 reports
- Layout
- Standard
SELECT i.offense_code, COUNT(*) AS incidents, SUM(i.cleared) AS cleared FROM incident i WHERE i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.offense_code