Part A Offense Counts - Agency D (2026 YTD)

{
 "document": {
  "id": 27997,
  "cuid": "A45e5d233a91bc9bf643bf4",
  "name": "Part A Offense Counts - Agency D (2026 YTD)",
  "folder": "Public Folders/Agency D/NIBRS",
  "owner": "Administrator"
 },
 "dataProviders": [
  {
   "id": "DP0",
   "name": "Query 1",
   "dataSourceType": "unx",
   "dataSourceName": "Justice Reporting.unx",
   "queryplan": "<queryplan custom=\"false\" editable=\"true\"><statement index=\"1\">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 = 4 AND i.occurred_date BETWEEN '2026-01-01' AND '2026-09-30' GROUP BY o.offense_desc, o.crime_against</statement></queryplan>"
  }
 ],
 "reports": [
  {
   "id": 1,
   "name": "Report 1",
   "elements": [
    {
     "type": "XTable",
     "dataProvider": "DP0"
    }
   ]
  }
 ],
 "alerters": [],
 "variables": [],
 "parameters": []
}