RECORD LAYOUT FOR POLICE (see also Word documents for codes and more specific explanations). field_name field_type field_len field_dec description ID C 1 0 Identifier code for the PE master file STATE C 2 0 Numeric State Code ORI C 7 0 ORI Code. Originating Agency Identifier GRP C 2 0 Population group DIV C 1 0 Division YEAR C 2 0 Year NUMBER C 5 0 Sequence Number MSA C 3 0 MSA POP N 11 0 Population AGENCY C 24 0 Agency Name STATE2 C 6 0 State Name MOFF N 6 0 Male officers MCIV N 6 0 Male civilian MTOT N 6 0 Male total FOFF N 6 0 Female officers FCIV N 6 0 Female civilian FTOT N 6 0 Female total TOTEMP N 11 0 Total employees ORATE F 12 2 "Officer Rate per 1,000 Population" ERATE F 12 2 "Employee Rate per 1,000 Population" XVDAY N 4 0 One Man Vehicle- Day Shift XVEVE N 4 0 One Man Vehicle- Evening Shift XVNT N 4 0 One Man Vehicle- Night Shift XVOTH N 4 0 One Man Vehicle - Other Shift XVTOT N 4 0 One Man Vehicle- Total Shift YVDAY N 4 0 Two Man Vehicle- Day Shift YVEVE N 4 0 Two Man Vehicle- Evening Shift YVNT N 4 0 Two Man Vehicle- Night Shift YVOTH N 4 0 Two Man Vehicle - Other Shift YVTOT N 4 0 Two Man Vehicle- Total Shift XFDAY N 4 0 One Man Foot - Day Shift XFEVE N 4 0 One Man Foot- Evening Shift XFNT N 4 0 One Man Foot- Night Shift XFOTH N 4 0 One Man Foot - Other Shift XFTOT N 4 0 One Man Foot- Total Shift YFDAY N 4 0 Two Man Foot - Day Shift YFEVE N 4 0 Two Man Foot- Evening Shift YFNT N 4 0 Two Man Foot - Night Shift YFOTH N 4 0 Two Man Foot - Other Shift YFTOT N 4 0 Two Man Foot- Total Shift OPDAY N 4 0 Other Patrols - Day Shift OPEVE N 4 0 Other Patrols- Evening Shift OPNT N 4 0 Other Patrols - Night Shift OPOTH N 4 0 Other Patrols - Other Shift OPTOT N 4 0 Other Patrols- Total Shift TPDAY N 4 0 Total Patrols - Day Shift TPEVE N 4 0 Total Patrols- Evening Shift TPNT N 4 0 Total Patrols - Night Shift TPOTH N 4 0 Total Patrols - Other Shift TPTOT N 4 0 Total Patrols- Total Shift RPT C 1 0 Report Indicator RCD C 1 0 Record Indicator MTHIND C 12 0 Month Indicator MTHINC C 2 0 Month Included COVBY C 1 0 Covered By SHFT C 1 0 Shift Data M_F C 1 0 No Male/Female Breakdown AINJ C 1 0 Assault - Injury ANOI C 1 0 Assault - No Injury OKFEL N 4 0 Officers Killed - Felonious Acts OKACC N 4 0 Officers Killed - Accident INFIRE N 4 0 Assaults With Injury - Firearms INKNI N 4 0 Assaults With Injury - Knife INOTH N 4 0 Assaults With Injury - Other INHAND N 6 0 "Assaults With Injury - Hands, Feet, etc." INTOT N 6 0 Assaults With Injury - Total NOINFIR N 4 0 Assaults Without Injury - Firearms NOINKNI N 4 0 Assaults Without Injury - Knife NOINOTH N 4 0 Assaults Without Injury - Other NOINHA N 6 0 "Assaults Without Injury - Hands, Feet, etc." NOINTOT N 6 0 Assaults Without Injury - Total CTOTA N 6 0 Disturbance Calls - Total Assaults CFIRE N 4 0 Disturbance Calls - Type of Weapon - Firearms CKNI N 4 0 Disturbance Calls - Knife COTH N 4 0 Disturbance Calls - Other CHAND N 6 0 "Disturbance Calls - Hands, Feet, etc." C2V N 4 0 Disturbance Calls-Two Man Vehicle C1AL N 4 0 Disturbance Calls-One Man Alone C1AS N 4 0 Disturbance Calls-One Man Assisted CDAL N 4 0 Disturbance Calls-Detective Alone CDAS N 4 0 Disturbance Calls-Detective Assisted COAL N 4 0 Disturbance Calls-Other Alone COAS N 4 0 Disturbance Calls-Other Assisted CLRDA N 6 0 Disturbance Calls - Number of Police Assaults Cleared BTOTA N 4 0 Burglary - Total Assaults BFIRE N 4 0 Burglary - Type of Weapon - Firearms BKNI N 4 0 Burglary - Knife BOTH N 4 0 Burglary - Other BHAND N 4 0 "Burglary - Hands, Feet, etc." B2V N 4 0 Burglary -Two Man Vehicle B1AL N 4 0 Burglary-One Man Alone B1AS N 4 0 Burglary-One Man Assisted BDAL N 4 0 Burglary-Detective Alone BDAS N 4 0 Burglary-Detective Assisted BOAL N 4 0 Burglary-Other Alone BOAS N 4 0 Burglary-Other Assisted BLRD N 4 0 Burglary - Number of Police Assaults Cleared RTOTA N 4 0 Robbery - Total Assaults RFIRE N 4 0 Robbery - Type of Weapon - Firearms RKNI N 4 0 Robbery - Knife ROTH N 4 0 Robbery - Other RHAND N 4 0 "Robbery - Hands, Feet, etc." R2V N 4 0 Robbery -Two Man Vehicle R1AL N 4 0 Robbery-One Man Alone R1AS N 4 0 Robbery-One Man Assisted RDAL N 4 0 Robbery-Detective Alone RDAS N 4 0 Robbery-Detective Assisted ROAL N 4 0 Robbery-Other Alone ROAS N 4 0 Robbery-Other Assisted RLRD N 4 0 Robbery - Number of Police Assaults Cleared ATOTA N 4 0 Attempting Other Arrests - Total Assaults AFIRE N 4 0 Attempting Other Arrests - Type of Weapon - Firearms AKNI N 4 0 Attempting Other Arrests - Knife AOTH N 4 0 Attempting Other Arrests - Other AHAND N 4 0 "Attempting Other Arrests - Hands, Feet, etc." A2V N 4 0 Attempting Other Arrests -Two Man Vehicle A1AL N 4 0 Attempting Other Arrests-One Man Alone A1AS N 4 0 Attempting Other Arrests-One Man Assisted ADAL N 4 0 Attempting Other Arrests-Detective Alone ADAS N 4 0 Attempting Other Arrests-Detective Assisted AOAL N 4 0 Attempting Other Arrests-Other Alone AOAS N 4 0 Attempting Other Arrests-Other Assisted ALRD N 4 0 Attempting Other Arrests - Number of Police Assaults Cleared CITOTA N 4 0 Civil Disorder - Total Assaults CIFIRE N 4 0 Civil Disorder - Type of Weapon - Firearms CIKNI N 4 0 Civil Disorder - Knife CIOTH N 4 0 Civil Disorder - Other CIHAND N 4 0 "Civil Disorder - Hands, Feet, etc." CI2V N 4 0 Civil Disorder -Two Man Vehicle CI1AL N 4 0 Civil Disorder-One Man Alone CI1AS N 4 0 Civil Disorder-One Man Assisted CIDAL N 4 0 Civil Disorder-Detective Alone CIDAS N 4 0 Civil Disorder-Detective Assisted CIOAL N 4 0 Civil Disorder-Other Alone CIOAS N 4 0 Civil Disorder-Other Assisted CLRDB N 4 0 Civil Disorder - Number of Police Assaults Cleared CUTOTA N 6 0 Custody of Prisonersr - Total Assaults CUFIRE N 4 0 Custody of Prisoners - Type of Weapon - Firearms CUKNI N 4 0 Custody of Prisoners - Knife CUOTH N 4 0 Custody of Prisoners - Other CUHAND N 6 0 "Custody of Prisoners - Hands, Feet, etc." CU2V N 4 0 Custody of Prisoners -Two Man Vehicle CU1AL N 4 0 Custody of Prisoners-One Man Alone CU1AS N 4 0 Custody of Prisoners-One Man Assisted CUDAL N 4 0 Custody of Prisoners-Detective Alone CUDAS N 4 0 Custody of Prisoners-Detective Assisted CUOAL N 4 0 Custody of Prisoners-Other Alone CUOAS N 6 0 Custody of Prisoners-Other Assisted CLRDC N 4 0 Custody of Prisoners - Number of Police Assaults Cleared STOTA N 4 0 Suspicious Persons - Total Assaults SFIRE N 4 0 Suspicious Persons - Type of Weapon - Firearms SKNI N 4 0 Suspicious Persons - Knife SOTH N 4 0 Suspicious Persons - Other SHAND N 4 0 "Suspicious Persons - Hands, Feet, etc." S2V N 4 0 Suspicious Persons -Two Man Vehicle S1AL N 4 0 Suspicious Persons-One Man Alone S1AS N 4 0 Suspicious Persons-One Man Assisted SDAL N 4 0 Suspicious Persons-Detective Alone SDAS N 4 0 Suspicious Persons-Detective Assisted SOAL N 4 0 Suspicious Persons-Other Alone SOAS N 4 0 Suspicious Persons-Other Assisted CLRDD N 4 0 Suspicious Persons - Number of Police Assaults Cleared AMTOTA N 4 0 Ambush - No Warning - Total Assaults AMFIRE N 4 0 Ambush - No Warning - Type of Weapon - Firearms AMKNI N 4 0 Ambush - No Warning - Knife AMOTH N 4 0 Ambush - No Warning - Other AMHAND N 4 0 "Ambush - No Warning - Hands, Feet, etc." AM2V N 4 0 Ambush - No Warning -Two Man Vehicle AM1AL N 4 0 Ambush - No Warning-One Man Alone AM1AS N 4 0 Ambush - No Warning-One Man Assisted AMDAL N 4 0 Ambush - No Warning-Detective Alone AMDAS N 4 0 Ambush - No Warning-Detective Assisted AMOAL N 4 0 Ambush - No Warning-Other Alone AMOAS N 4 0 Ambush - No Warning-Other Assisted CLRD2 N 4 0 Ambush - No Warning - Number of Police Assaults Cleared MTOTA N 4 0 Mentally Deranged - Total Assaults MFIRE N 4 0 Mentally Deranged - Type of Weapon - Firearms MKNI N 4 0 Mentally Deranged - Knife MOTH N 4 0 Mentally Deranged - Other MHAND N 4 0 "Mentally Deranged - Hands, Feet, etc." M2V N 4 0 Mentally Deranged -Two Man Vehicle M1AL N 4 0 Mentally Deranged-One Man Alone M1AS N 4 0 Mentally Deranged-One Man Assisted MDAL N 4 0 Mentally Deranged-Detective Alone MDAS N 4 0 Mentally Deranged-Detective Assisted MOAL N 4 0 Mentally Deranged-Other Alone MOAS N 4 0 Mentally Deranged-Other Assisted CLRD3 N 4 0 Mentally Deranged - Number of Police Assaults Cleared TTOTA N 4 0 Traffic Pursuits and Stops - Total Assaults TFIRE N 4 0 Traffic Pursuits and Stops- Type of Weapon - Firearms TKNI N 4 0 Traffic Pursuits and Stops - Knife TOTH N 4 0 Traffic Pursuits and Stops - Other THAND N 4 0 "Traffic Pursuits and Stops - Hands, Feet, etc." T2V N 4 0 Traffic Pursuits and Stops -Two Man Vehicle T1AL N 4 0 Traffic Pursuits and Stops-One Man Alone T1AS N 4 0 Traffic Pursuits and Stops-One Man Assisted TDAL N 4 0 Traffic Pursuits and Stops-Detective Alone TDAS N 4 0 Traffic Pursuits and Stops-Detective Assisted TOAL N 4 0 Traffic Pursuits and Stops-Other Alone TOAS N 4 0 Traffic Pursuits and Stops-Other Assisted CLRD4 N 4 0 Traffic Pursuits and Stops - Number of Police Assaults Cleared OTTOTA N 6 0 All Other - Total Assaults OTFIRE N 4 0 All Other- Type of Weapon - Firearms OTKNI N 4 0 All Other - Knife OTOTH N 4 0 All Other - Other OTHAND N 4 0 "All Other - Hands, Feet, etc." OT2V N 4 0 All Other -Two Man Vehicle OT1AL N 4 0 All Other-One Man Alone OT1AS N 4 0 All Other-One Man Assisted OTDAL N 4 0 All Other-Detective Alone OTDAS N 4 0 All Other-Detective Assisted OTOAL N 4 0 All Other-Other Alone OTOAS N 4 0 All Other-Other Assisted CLRD5 N 6 0 All Other - Number of Police Assaults Cleared TOTOTA N 6 0 Total Calls - Total Assaults TOFIRE N 4 0 Total Calls - Type of Weapon - Firearms TOKNI N 4 0 Total Calls - Knife TOOTH N 6 0 Total Calls - Other TOHAND N 6 0 "Total Calls - Hands, Feet, etc." TO2V N 6 0 Total Calls -Two Man Vehicle TO1AL N 6 0 Total Calls -One Man Alone TO1AS N 6 0 Total Calls -One Man Assisted TODAL N 4 0 Total Calls -Detective Alone TODAS N 4 0 Total Calls -Detective Assisted TOOAL N 4 0 Total Calls -Other Alone TOOAS N 6 0 Total Calls -Other Assisted CLRD6 N 6 0 Total Calls - Number of Police Assaults Cleared L00_02 N 4 0 Time of Assaults 0001 to 0200 L02_04 N 4 0 Time of Assaults 0201 to 0400 L04_06 N 4 0 Time of Assaults 0401 to 0600 L06_08 N 4 0 Time of Assaults 0601 to 0800 L08_10 N 4 0 Time of Assaults 0801 to 1000 L10_12 N 4 0 Time of Assaults 1001 to 1200 L12_14 N 4 0 Time of Assaults 1201 to 1400 L14_16 N 4 0 Time of Assaults 1401 to 1600 L16_18 N 4 0 Time of Assaults 1601 to 1800 L18_20 N 4 0 Time of Assaults 1801 to 2000 L20_22 N 4 0 Time of Assaults 2001 to 2200 L22_24 N 4 0 Time of Assaults 2201 to 2400 MONTH C 2 0 Month