Convert › F007
Burglary by Beat
CJIWave 1| Name | Source | Folder | Runs | Last run | Mapping |
|---|---|---|---|---|---|
| Burglary by Beat - Agency C (2025) | CoCognos | Incidents | 1,904 | 9/30/2026 11:26 PM | Mapped |
| Burglary by Beat - Agency J (2024) | CoCognos | Incidents | 363 | 9/28/2026 12:37 PM | Mapped |
| Burglary by Beat - Agency E (Last 90 Days) | CoCognos | Incidents | 19 | 9/29/2026 5:48 AM | Mapped |
| Burglary by Beat - Agency D (2026 YTD) | CoCognos | Incidents | 17 | 9/25/2026 2:45 AM | Mapped |
| Burglary by Beat - Agency J (2026 YTD) | CoCognos | Incidents | 17 | 8/13/2026 9:07 PM | Mapped |
| Burglary by Beat - Agency F (2026 YTD) | CoCognos | Incidents | 16 | 9/29/2026 1:16 PM | Mapped |
| Burglary by Beat - Agency G (2024) | CoCognos | Incidents | 15 | 9/15/2026 11:22 AM | Mapped |
| Burglary by Beat - Agency K (2024) | CoCognos | Incidents | 14 | 8/19/2026 11:25 AM | Mapped |
| Burglary by Beat - Agency G (2025) | CoCognos | Incidents | 11 | 8/15/2026 7:51 AM | Mapped |
| Copy of Burglary by Beat | CoCognos | user413 | 11 | 7/21/2026 4:05 PM | Mapped |
| Burglary by Beat - Agency C (2024) | CoCognos | Incidents | 8 | 9/12/2026 8:00 PM | Mapped |
| Burglary by Beat - Agency F (Last 90 Days) | CoCognos | Incidents | 8 | 9/21/2026 1:27 AM | Mapped |
| Burglary by Beat - Agency A (2026 YTD) | CoCognos | Incidents | 8 | 8/29/2026 6:22 PM | Mapped |
| Copy of Burglary by Beat | CoCognos | user252 | 7 | 9/25/2026 12:57 AM | Mapped |
| Burglary by Beat - Agency B (Last 90 Days) | CoCognos | Incidents | 7 | 9/3/2026 11:28 AM | Mapped |
| Burglary by Beat - Agency A (2024) | CoCognos | Incidents | 7 | 9/22/2026 1:37 AM | Mapped |
| Burglary by Beat - Agency I (2024) | CoCognos | Incidents | 6 | 5/27/2026 8:07 PM | Mapped |
| Burglary by Beat - Agency E (2024) | CoCognos | Incidents | 0 | Never | Mapped |
| Copy of Burglary by Beat | CoCognos | user565 | 0 | Never | Mapped |
| Burglary by Beat - Agency E (2026 YTD) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency G (2026 YTD) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency H (2025) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency I (Last 90 Days) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency H (2024) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency B (2026 YTD) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency C (Last 90 Days) | CoCognos | Incidents | 0 | Never | Mapped |
| Burglary by Beat - Agency K (2025) | CoCognos | Incidents | 0 | Never | Mapped |
27 of 27
Template
- Target
- Paginated report
- Parameters
- @Agency, @DateFrom, @DateTo
- Security
- Row-level, by agency
- Replaces
- 27 reports
- Layout
- Standard
SELECT i.beat, CONVERT(char(7), i.occurred_date, 126) AS month, COUNT(*) AS incidents FROM incident i WHERE i.offense_code = '220' AND i.agency_id = @Agency AND i.occurred_date BETWEEN @DateFrom AND @DateTo GROUP BY i.beat, CONVERT(char(7), i.occurred_date, 126)