Report inventory › Arrest Detail with Incident - Agency H (Last 90 Days)
WI
Arrest Detail with Incident - Agency H (Last 90 Days)
ConsolidateAgency_H/Arrests/Arrest_Detail_with_Incident_-_Agency_H_(Last_90_Days).json
{
"document": {
"id": 53225,
"cuid": "A15859ae6a0dfa5417caf9e",
"name": "Arrest Detail with Incident - Agency H (Last 90 Days)",
"folder": "Public Folders/Agency H/Arrests",
"owner": "Administrator"
},
"dataProviders": [
{
"id": "DP0",
"name": "Query 1",
"dataSourceType": "unx",
"dataSourceName": "Justice Reporting.unx",
"queryplan": "<queryplan custom=\"false\" editable=\"true\"><statement index=\"1\">SELECT r.arrest_id, r.arrest_date, i.incident_id, i.occurred_date, i.beat FROM arrest r JOIN incident i ON i.incident_id = r.incident_id WHERE r.agency_id = 8 AND r.arrest_date BETWEEN '2026-07-02' AND '2026-09-30'</statement></queryplan>"
}
],
"reports": [
{
"id": 1,
"name": "Report 1",
"elements": [
{
"type": "VTable",
"dataProvider": "DP0"
}
],
"sections": [
{
"name": "Agency"
}
]
}
],
"alerters": [
{
"name": "Highlight late"
}
],
"variables": [],
"parameters": []
}