Report inventory › Vehicle Crime Summary - Agency C (2026 YTD)
WI
Vehicle Crime Summary - Agency C (2026 YTD)
ConsolidateAgency_C/Incidents/Vehicle_Crime_Summary_-_Agency_C_(2026_YTD).json
{
"document": {
"id": 91719,
"cuid": "Ab611d677c3fc0ec15df1df",
"name": "Vehicle Crime Summary - Agency C (2026 YTD)",
"folder": "Public Folders/Agency C/Incidents",
"owner": "Administrator"
},
"dataProviders": [
{
"id": "DP0",
"name": "Query 1",
"dataSourceType": "unx",
"dataSourceName": "Justice Reporting.unx",
"queryplan": "<queryplan custom=\"false\" editable=\"true\"><statement index=\"1\">SELECT i.offense_code, COUNT(*) AS incidents, SUM(i.property_loss) AS loss FROM incident i WHERE i.offense_code IN ('23F','240') AND i.agency_id = 3 AND i.occurred_date BETWEEN '2026-01-01' AND '2026-09-30' GROUP BY i.offense_code</statement></queryplan>"
}
],
"reports": [
{
"id": 1,
"name": "Report 1",
"elements": [
{
"type": "VBarChart",
"dataProvider": "DP0"
}
]
}
],
"alerters": [],
"variables": [],
"parameters": []
}