Juvenile Arrests

Wave 3

8 reports · 114 runs (12 mo) · Simple · Target: Paginated report

Member reports Template Power BI output Validation (6)

Name	Source	Folder	Runs	Last run	Mapping
Juvenile Arrests - Agency E (2026 YTD)	WIWeb Intelligence	Arrests	42	9/3/2026 3:28 AM	Mapped
Juvenile Arrests - Agency J (2024)	WIWeb Intelligence	Arrests	29	9/30/2026 5:23 AM	Mapped
Juvenile Arrests - Agency L (2025)	WIWeb Intelligence	Arrests	15	7/20/2026 4:23 PM	Mapped
Juvenile Arrests - Agency D (2026 YTD)	WIWeb Intelligence	Arrests	11	9/20/2026 1:20 PM	Mapped
Juvenile Arrests - Agency H (Last 90 Days)	WIWeb Intelligence	Arrests	11	7/16/2026 5:56 PM	Mapped
Juvenile Arrests - Agency C (2025)	WIWeb Intelligence	Arrests	6	4/26/2026 11:38 PM	Mapped
Juvenile Arrests - Agency F (2024)	WIWeb Intelligence	Arrests	0	Never	Mapped
Juvenile Arrests - Agency K (2024)	WIWeb Intelligence	Arrests	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 r.arrest_id,
       r.arrest_date,
       r.charge_code,
       r.arrestee_age
FROM arrest r
WHERE r.arrestee_age < 18
  AND r.agency_id = @Agency
  AND r.arrest_date BETWEEN @DateFrom AND @DateTo