{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["CrimeData_IncidentsByClearedExc"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"CrimeData_IncidentsByClearedExc","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,2,2],[2,4,2,6],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[35,2,35,8]],"flags":["formulas_cached_only"]}
["Incidents Cleared¹\nby Offense Category, 2022"]
[]
[{"$nulls":4},"Incidents Cleared³"]
["Offense Category",null,null,"Total Incidents²","Total Incidents Cleared","Cleared by Arrest","Cleared by Exceptional Means"]
["Total",null,null,"496,406","103,070","84,322","18,748"]
["Crimes Against Person",null,null,"144,458","51,738","38,038","13,700"]
["    Assault Offenses",null,null,"136,091","50,123","36,871","13,252"]
["    Homicide Offenses",null,null,"868","315","294","21"]
["    Human Trafficking",null,null,"28","4","4","0"]
["    Kidnapping/Abduction",null,null,"1,030","496","423","73"]
["    Sex Offenses",null,null,"6,255","752","411","341"]
["    Sex Offenses, Non-Forcible",null,null,"186","48","35","13"]
["Crimes Against Property",null,null,"317,163","28,269","23,525","4,744"]
["    Arson",null,null,"842","136","120","16"]
["    Bribery",null,null,"9","4","4","0"]
["    Burglary/Breaking and Entering",null,null,"20,592","1,906","1,689","217"]
["    Counterfeiting/Forgery",null,null,"4,659","390","354","36"]
["    Destruction/Damage/Vandalism",null,null,"81,908","8,723","6,499","2,224"]
["    Embezzlement",null,null,"155","93","93","0"]
["    Extortion/Blackmail",null,null,"434","47","33","14"]
["    Fraud Offenses",null,null,"40,117","2,664","2,479","185"]
["    Larceny/Theft Offenses",null,null,"124,586","11,380","9,751","1,629"]
["    Motor Vehicle Theft",null,null,"31,685","1,395","1,165","230"]
["    Robbery",null,null,"11,331","1,111","923","188"]
["    Stolen Property Offenses",null,null,"845","420","415","5"]
["Crimes Against Society",null,null,"34,785","23,063","22,759","304"]
["    Animal Cruelty",null,null,"224","70","67","3"]
["    Drug/Narcotic Offenses",null,null,"22,212","16,988","16,798","190"]
["    Gambling Offenses",null,null,"3","1","1","0"]
["    Pornography/Obscene Material",null,null,"1,150","200","148","52"]
["    Prostitution Offenses",null,null,"190","89","86","3"]
["    Weapons Law Violations",null,null,"11,006","5,715","5,659","56"]
[]
[]
[]
[null,null,"¹In the National Incident-Based Reporting System, the submission of arrestee data in connection with an incident automatically clears all offenses within the incident. \n²The actual number of incidents is 6,255. However, the column figures will not add to the total because incidents may include more than one offense type, and one incident was counted for each offense type within each offense category in this table.\n³Clearance figures in this table represent the total number of incidents cleared and a breakdown of the clearance method for each offense category."]