Convert › F001
Part A Offense Counts
Wave 1| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Part A Offense Counts - Agency B (2025) | WIWeb Intelligence | NIBRS | 1,455 | 9/30/2026 7:57 PM | Mapped |
| Part A Offense Counts - Agency K (Last 90 Days) | WIWeb Intelligence | NIBRS | 1,008 | 9/30/2026 1:59 PM | Mapped |
| Part A Offense Counts - Agency D (2026 YTD) | WIWeb Intelligence | NIBRS | 782 | 9/30/2026 6:21 PM | Mapped |
| Part A Offense Counts - Agency H (Last 90 Days) | WIWeb Intelligence | NIBRS | 11 | 7/31/2026 1:47 PM | Mapped |
| Part A Offense Counts - Agency I (2025) | WIWeb Intelligence | NIBRS | 11 | 8/5/2026 5:56 PM | Mapped |
| Part A Offense Counts - Agency G (2026 YTD) | WIWeb Intelligence | NIBRS | 7 | 9/28/2026 8:28 AM | Mapped |
| Part A Offense Counts - Agency F (Last 90 Days) | WIWeb Intelligence | NIBRS | 7 | 6/2/2026 10:16 PM | Mapped |
| Part A Offense Counts - Agency J (2026 YTD) | WIWeb Intelligence | 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 o.offense_desc, o.crime_against, COUNT(*) AS offenses FROM incident i JOIN offense_code o ON o.offense_code = i.offense_code WHERE o.nibrs_group = 'A' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY o.offense_desc, o.crime_against