RECORD LAYOUT FOR RETAS (see also Word documents for codes and more specific explanations). field_name field_type field_len field_dec description STATE C 2 0 State code ORI C 7 0 Originating agency identifier GRP C 2 0 Geographic group DIVIS C 1 0 Geographic division YEAR C 2 0 Year MSA C 3 0 Metropolitan Statistical Area AGENCY C 24 0 Agency name AGENST C 6 0 Agency state name POP N 11 0 Population STATUS C 1 0 "0 = Not reported, 1 = regular" MURDER N 4 0 Murder Offenses RAPE N 6 0 Rape offenses ROBHWY N 6 0 Robbery offenses - Highway ROBHSE N 6 0 Robbery - Common house ROBGAS N 4 0 Robbery - Gas station ROBSTOR N 6 0 Robbery - Chain store ROBRES N 6 0 Robbery - Residence ROBBANK N 4 0 Robbery - Bank ROBMISC N 6 0 Robbery - Miscellaneous ROBTOT N 6 0 Total Robbery BURGRNT N 6 0 Burglary Offenses - Resident night BURGRD N 6 0 Burglary - Resident day BURGRU N 6 0 Burglary - Resident unknown BURGNORNT N 6 0 Burglary - Non-resident night BURGNORD N 6 0 Burglary - Non-resident day BURGNORU N 6 0 Burglary - Non-resident unknown BURGTOT N 6 0 Total Burglary LARC200 N 6 0 Larceny offenses - Over $200 LARC50100 N 6 0 Larceny - $50 to $200 LARC50 N 6 0 Larceny - Under $50 LARCTOT N 6 0 Total Larceny VEHTHEFT N 6 0 Motor vehicle theft LARCPICKP N 6 0 Larceny - Pocket picking LARCPURSE N 6 0 Larceny - Purse snatching LARCSHOP N 6 0 Larceny - Shoplifting LARCAUTO N 6 0 Larceny - From auto LARCAUTAC N 6 0 Larceny - Auto accessories LARCBIKE N 6 0 Larceny - Bicycle LARCBLDG N 6 0 Larceny - From building LARCCOIN N 6 0 Larceny - Coin machine LARCOTH N 6 0 Larceny - All other MRDERVAL N 11 0 Murder Value RAPEVAL N 11 0 Rape Value ROBVHWY N 11 0 Robbery Value - Highway ROBVHSE N 11 0 Robbery Value - Common house ROBVGAS N 11 0 Robbery Value - Gas station ROBVSTOR N 11 0 Robbery Value - Chain store ROBVRES N 11 0 Robbery Value - Residence ROBVBANK N 11 0 Robbery Value - Bank ROBVMISC N 11 0 Robbery Value - Misc ROBVTOT N 11 0 Total Robbery value BURGVRNT N 11 0 Burglary value - Resident night BURGVRD N 11 0 Burglary - Resident day BURGVRU N 11 0 Burglary - Resident unknown BURGVNONT N 11 0 Burglary - Non-resident night BURGVNOD N 11 0 Burglary - Non-resident day BURGVNOU N 11 0 Burglary - Non-resident unknown BURGVTOT N 11 0 Total Burglary Value LARCV200 N 11 0 Larceny value - Over $200 LARCV50100 N 11 0 Larceny value - $50 - $200 LARCV50 N 11 0 Larceny value - Under $50 LARCVTOT N 11 0 Total larceny value VEHTHEFTV N 11 0 Motor vehicle theft value TOTVALUE N 11 0 "Total value of all previous ""values""" LARAVPICKP N 11 0 Larceny Analysis value - Pocket picking LARCAVPURS N 11 0 Larceny analysis - Purse snatching LARCAVSHOP N 11 0 Larceny anaylsis - Shoplifting LARCAVAUTO N 11 0 Larceny analysis - From auto LARCAVAUTA N 11 0 Larceny analysis - Auto accessories LARCAVBIKE N 11 0 Larceny analysis - Bicycle LARCAVBLDG N 11 0 Larceny analysis - From building LARCAVCOIN N 11 0 Larceny analysis - Coin machine LARCAVOTH N 11 0 Larceny analysis - all other AUTORECLOC N 6 0 Auto theft by type - Stolen and recovered locally AUTORECOTH N 6 0 Auto stolen and recovered elsewhere TOTAL N 6 0 Total of all locally stolen vehicles AUTOOTHER N 11 0 Autos stolen elsewhere and recovered locally STMONEY N 11 0 Stolen property by type and value - Currency STJEWEL N 11 0 Stolen property - Jewelry and precious metals STCLOTH N 11 0 Stolen property - Clothing STLOCAUTO N 11 0 Stolen property - Locally stolen motor vehicles STOFFICE N 11 0 Stolen property - Office equipment STELECTR N 11 0 "Stolen property - Televisions, radios, stereos" STGUNS N 11 0 Stolen property - Firearms STHHOLD N 11 0 Stolen property - Household goods STCONSUM N 11 0 Stolen property - Consumable goods STLIVEST N 11 0 Stolen property - Livestock STMISC N 11 0 Stolen property - Miscellaneous TOTVALST N 11 0 Total value of stolen property RECMONEY N 11 0 Recovered property by type and value - Currency RECJEWEL N 11 0 Recovered property - Jewelry and precious metals RECCLOTH N 11 0 Recovered property - Clothing RECAUTO N 11 0 Recovered property - Locally Recovered motor vehicles RECOFFICE N 11 0 Recovered property - Office equipment RECELECTR N 11 0 "Recovered property - Televisions, radios, stereos" RECGUNS N 11 0 Recovered property - Firearms RECHHOLD N 11 0 Recovered property - Household goods RECCONSUM N 11 0 Recovered property - Consumable goods RECLIVEST N 11 0 Recovered property - Livestock RECMISC N 11 0 Recovered property - Miscellaneous TOTVALREC N 11 0 Total value of recovered property MONTH C 2 0 Number of month