RECORD LAYOUT FOR RETA (see also Word documents for codes and more specific explanations). field_name field_type field_len field_dec description STATE C 2 0 Numeric State code ORI C 7 0 Originating Agency Identifier GRP C 2 0 Population group DIVIS C 1 0 Geographic division YEAR C 2 0 Year data reflects SEQNUM C 5 0 Sequence number JUVAGE C 2 0 Juvenile age limit in state where agency is located CORECTY C 1 0 Core city indicator COVBY C 7 0 Covered by COVBYGRP C 1 Covered by group LSTUPDT C 6 0 Date of last update FLDOFCE C 4 0 Numeric code for local FBI field office MTHSRPTD C 2 Number of months reported AGENCYCT C 1 Agency count POP N 11 0 Population of city POPCO C 3 0 Population of county POPMSA C 3 0 MSA code POPGRP2 C 15 0 Population of smaller county if city resides in two counties POPGRP3 C 15 0 Population of smallest county if city resides in three counties. CENPOP1 N 11 0 "Population of biggest county, most recent census" CENPOP2 N 11 0 "Population of second biggest county, most recent census" CENPOP3 N 11 0 "Population of third biggest county, most recent census" POPSRC C 1 0 "Values 1-9, but field is obsolete" FLWUP C 1 0 Designates whether or not agency shold be sent a follow-up MAILGRP C 1 0 Special Mailing group MAILADD C 1 0 Special mailing address AGENCY C 24 0 Agency name AGCYST C 6 0 Agency state name ADDRS1 C 30 0 First line of mailing address ADDRS2 C 30 0 Second line of mailing address ADDRS3 C 30 0 Third line of mailing address ADDRS4 C 29 0 Fourth line of mailing address ZIP C 5 0 Zip code OLDPOPGRP C 1 Old population group - population group from previous year MTHINCL C 2 0 Month included in LASTUP C 6 0 Date of last update CARD0 C 1 0 Card 0 type CARD1 C 1 0 Card 1 type CARD2 C 1 0 Card 2 type CARD3 C 1 0 Card 3 type CARD4 C 1 0 Card 4 type CARD0PT C 1 0 "Card 0 p/t - show whether data has ""breakdown"" offenses (P), or only totals (T)." CARD1PT C 1 0 Card 1 p/t CARD2PT C 1 0 Card 2 p/t CARD3PT C 1 0 Card 3 p/t Card0 = the "number of unfounded offenses" MURDER N 4 0 Murder (Card 0) MANSLAUT N 4 Manslaughter (Card 0) RAPET N 4 0 Rape total (Card 0) RAPEFRC N 4 0 Rape by force (Card 0) RAPEATPT N 4 Attempted rape (Card 0) ROBT N 4 0 Robbery total (Card 0) ROBGUN N 4 0 Robbery with a gun (Card 0) ROBKNIFE N 4 Robbery with a knife (Card 0) ROBOTHER N 4 Robbery - other weapon (Card 0) ROBSTRNG N 4 Strong-arm robbery (Card 0) ASLTT N 6 0 Assault total (Card 0) ASGUN N 4 0 Assault with a gun (Card 0) ASKNF N 4 0 Assault with a knife (Card 0) ASOTH N 4 0 Assault - other weapon (Card 0) ASHAND N 4 0 "Assault with hands, feet, etc (Card 0)" ASSMPL N 6 0 Simple assault (Card 0) BURGT N 6 0 Burglary total (Card 0) BURGFRC N 6 0 Burglary - forcible entry (Card 0) BURGNOFRC N 4 Burglary - no forced entry (Card 0) BURGATPT N 6 Attempted burglary (Card 0) LARCT N 6 0 Larceny total (Card 0) VEHTHFTT N 6 Motor vehicle theft total (Card 0) AUTOTHFT N 6 Auto theft (Card 0) TBTHFT N 4 0 "Truck, bus theft (Card 0)" OTHVEHTHFT N 4 Other vehicle theft (Card 0) ALLFTOT N 6 0 Grand total of all fields (Card 0) LARC50 N 4 0 Larceny under $50.00 (Card 0) Card1 = "Number of Actual Offenses" MRDR1 N 6 0 Murder (Card 1) MANSLT1 N 4 0 Manslaughter (Card 1) RAPET1 N 6 0 Rape total (Card 1) RAPEFRC1 N 6 Rape by force (Card 1) RAPEAT1 N 4 0 Attempted rape (Card 1) ROBT1 N 6 0 Robbery total (Card 1) ROBGUN1 N 6 0 Robbery with a gun (Card 1) ROBKNF1 N 6 0 Robbery with a knife (Card 1) ROBOTH1 N 6 0 Robbery - other weapon (Card 1) ROBSTRNG1 N 6 Strong-arm robbery (Card 1) ASLTT1 N 6 0 Assault total (Card 1) ASGUN1 N 6 0 Assault with a gun (Card 1) ASKNF1 N 6 0 Assault with a knife (Card 1) ASOTH1 N 6 0 Assault - other weapon (Card 1) ASHAND1 N 6 0 "Assault with hands, feet, etc (Card 1)" ASSMPL1 N 6 0 Simple assault (Card 1) BURGT1 N 6 0 Burglary total (Card 1) BURGFRC1 N 6 Burglary - forcible entry (Card 1) BURGNOFRC1 N 6 Burglary - no forced entry (Card 1) BURGATPT1 N 6 Attempted burglary (Card 1) LARCT1 N 11 0 Larceny total (Card 1) VHTHFTT1 N 6 Motor vehicle theft total (Card 1) AUTOTHFT1 N 6 Auto theft (Card 1) TBTHFT1 N 6 0 "Truck, bus theft (Card 1)" OTHVEHTHF1 N 6 Other vehicle theft (Card 1) ALLFTOT1 N 11 Grand total of all fields (Card 1) LARC501 N 4 0 Larceny under $50.00 (Card 1) Card2 = "Total Offenses Cleared by Arrest" MRDR2 N 4 0 Murder (Card 2) MANSLAT2 N 4 Manslaughter (Card 2) RAPET2 N 6 0 Rape total (Card 2) RAPEFRC2 N 6 Rape by force (Card 2) RAPEAT2 N 4 0 Attempted rape (Card 2) ROBT2 N 6 0 Robbery total (Card 2) ROBGUN2 N 6 0 Robbery with a gun (Card 2) ROBKNF2 N 4 0 Robbery with a knife (Card 2) ROBOTH2 N 4 0 Robbery - other weapon (Card 2) ROBSTRG2 N 6 Strong-arm robbery (Card 2) ASSLTT2 N 6 0 Assault total (Card 2) ASGUN2 N 6 0 Assault with a gun (Card 2) ASKNF2 N 6 0 Assault with a knife (Card 2) ASOTH2 N 6 0 Assault - other weapon (Card 2) ASHAND2 N 6 0 "Assault with hands, feet, etc (Card 2)" ASSMPL2 N 6 0 Simple assault (Card 2) BURGT2 N 6 0 Burglary total (Card 2) BURGFC2 N 6 0 Burglary - forcible entry (Card 2) BURGNOFC2 N 6 Burglary - no forced entry (Card 2) BURGAT2 N 4 0 Attempted burglary (Card 2) LARCT2 N 6 0 Larceny total (Card 2) VEHTFTT2 N 6 Motor vehicle theft total (Card 2) AUTOTFT2 N 6 Auto theft (Card 2) TBTFT2 N 6 0 "Truck, bus theft (Card 2)" OTHVTFT2 N 4 Other vehicle theft (Card 2) ALLFTOT2 N 6 Grand total of all fields (Card 2) LARC502 N 4 0 Larceny under $50.00 (Card 2) Card3 = "Number of Clearances Under 18" MRDR3 N 4 0 Murder (Card 3) MANSLT3 N 4 0 Manslaughter (Card 3) RAPET3 N 4 0 Rape total (Card 3) RAPEFCE3 N 4 Rape by force (Card 3) RAPEAT3 N 4 0 Attempted rape (Card 3) ROBT3 N 4 0 Robbery total (Card 3) ROBGUN3 N 4 0 Robbery with a gun (Card 3) ROBKNF3 N 4 0 Robbery with a knife (Card 3) ROBOTR3 N 4 0 Robbery - other weapon (Card 3) ROBSTRG3 N 4 Strong-arm robbery (Card 3) ASSLTT3 N 6 0 Assault total (Card 3) ASGUN3 N 4 0 Assault with a gun (Card 3) ASKNF3 N 4 0 Assault with a knife (Card 3) ASOTHR3 N 4 0 Assault - other weapon (Card 3) ASHND3 N 4 0 "Assault with hands, feet, etc (Card 3)" ASSMPL3 N 6 0 Simple assault (Card 3) BURGT3 N 6 0 Burglary total (Card 3) BGFRC3 N 6 0 Burglary - forcible entry (Card 3) BGNOFRC3 N 4 Burglary - no forced entry (Card 3) BGATPT3 N 4 0 Attempted burglary (Card 3) LARCT3 N 6 0 Larceny total (Card 3) VEHTFTT3 N 6 Motor vehicle theft total (Card 3) AUTOTFT3 N 6 Auto theft (Card 3) TBTFT3 N 4 0 "Truck, bus theft (Card 3)" OTHVEHTFT3 N 4 Other vehicle theft (Card 3) ALLFLDST3 N 6 Grand total of all fields (Card 3) LARC503 N 4 0 Larceny under $50.00 (Card 3) Card4 = Police Assault data POLFELON N 4 Number of police killed by felonious acts POLACCID N 4 Number of officers killed by accidental or negligent acts POLASLT N 6 0 Number of officers assaulted MONTH C 2 0 Number of reported month