Convert › F001
Arrests by Charge
CJIWave 1| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Arrests by Charge - Agency L (2026 YTD) | CRCrystal | Arrests | 1,176 | 9/30/2026 7:10 PM | Mapped |
| Arrests by Charge - Agency I (2025) | RSSSRS | Arrests | 1,075 | 9/30/2026 9:49 PM | Mapped |
| Arrests by Charge - Agency A (2024) | RSSSRS | Arrests | 679 | 9/29/2026 11:35 PM | Mapped |
| Arrests by Charge - Agency E (2024) | CRCrystal | Arrests | 74 | 9/27/2026 6:43 AM | Mapped |
| Arrests by Charge - Agency D (2024) | RSSSRS | Arrests | 33 | 9/22/2026 4:25 PM | Mapped |
| Arrests by Charge - Agency H (2025) | RSSSRS | Arrests | 16 | 9/7/2026 5:27 PM | Mapped |
| Arrests by Charge | RSSSRS | Arrests | 15 | 9/21/2026 2:24 PM | Mapped |
| Arrests by Charge - Agency K (Last 90 Days) | CRCrystal | Arrests | 15 | 9/30/2026 7:23 PM | Mapped |
| Arrests by Charge - Agency A (Last 90 Days) | CRCrystal | Arrests | 9 | 9/18/2026 1:49 PM | Mapped |
| Arrests by Charge - Agency F (2025) | RSSSRS | Arrests | 8 | 8/28/2026 12:55 PM | Mapped |
| Arrests by Charge - Agency B (2024) | CRCrystal | Arrests | 7 | 7/24/2026 2:12 PM | Mapped |
| Arrests by Charge - Agency F (2026 YTD) | CRCrystal | Arrests | 7 | 9/12/2026 4:27 AM | Mapped |
| Arrests by Charge - Agency E (Last 90 Days) | RSSSRS | Arrests | 0 | Never | Mapped |
| Arrests by Charge - Agency G (2024) | CRCrystal | Arrests | 0 | Never | Mapped |
| Arrests by Charge - Agency C (2026 YTD) | CRCrystal | Arrests | 0 | Never | Mapped |
15 of 15
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 15 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