Convert › F004
Arrests by Charge
Wave 2| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Arrests by Charge - Agency C (2025) | WIWeb Intelligence | Arrests | 700 | 9/30/2026 10:21 PM | Mapped |
| Arrests by Charge - Agency E (2024) | WIWeb Intelligence | Arrests | 448 | 9/29/2026 11:28 PM | Mapped |
| Arrests by Charge - Agency H (Last 90 Days) | WIWeb Intelligence | Arrests | 60 | 9/23/2026 11:27 PM | Mapped |
| Arrests by Charge - Agency D (2026 YTD) | WIWeb Intelligence | Arrests | 33 | 9/21/2026 3:38 PM | Mapped |
| Arrests by Charge - Agency B (2025) | WIWeb Intelligence | Arrests | 7 | 8/14/2026 5:19 AM | Mapped |
| Arrests by Charge - Agency A (2025) | WIWeb Intelligence | Arrests | 7 | 4/7/2026 3:06 PM | Mapped |
| Arrests by Charge - Agency G (2024) | WIWeb Intelligence | Arrests | 6 | 7/24/2026 2:54 AM | Mapped |
7 of 7
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 7 reports
- Layout
- Standard
SELECT r.charge_code, r.arrest_type, COUNT(*) AS arrests FROM arrest r WHERE r.agency_id = @Agency AND r.arrest_date BETWEEN @DateFrom AND @DateTo GROUP BY r.charge_code, r.arrest_type