Code Book

James J. Nolan, III

West Virginia University

F. Carson Mencken

Baylor University

Jack McDevitt

Northeastern University

January 2004

This project was funded by the Office of Juvenile Justice and Delinquency Prevention (OJJDP) under grant number 2001-JR-BX-0006.

NIBRS HATE CRIME FILE IN MICROSOFT ACCESS FORMAT (version 2000)

SUMMARY OF TABLES AND VARIABLES

NIBRS9500 Database – Administrative Table

Variable Number	Variable Name	Variable Description
1	Segment	NIBRS segment
2	State	State where incident occurred
3	ORI	Agency identifier
4	Incnum	Incident number
5	incident_date	Date of incident
6	numrecords	Number of records per ORI and incident number
7	report/date indicator	Indicates whether the incident date (incident_date) is the report date or date of occurrence
8	time	Time of incident
9	total offense segments	Total number of offense segments in the incident
10	total victim segments	Total number of victim segments in the incident
11	total offender segments	Total number of offender segments in the incident
12	total arrestee segments	Total number of arrestee segments in the incident
13	city submission	Indicator for FBI whether jurisdiction reported through the state UCR program or directly to the FBI
14	cleared exceptionally	Type of exceptional clearance
15	clearance date	Date incident was cleared

NIBRS9500 Database – Incident Table

Variable Number	Variable Name	Variable Description
1	incident	Agency number (ORI) combined with incident number
2	vage	Age of youngest victim in the incident
3	numvicti	The number of victims in this incident
4	typevict	Category of incident based on age of youngest victim in the incident
5	oage	Age of youngest offender in the incident
6	numoffen	Number of offenders in the incident
7	typeoff	Category of incident based on age of youngest offender in incident
8	agenum	Category of incident based on age group and number of offenders
9	vagenum	Category of incident based on age group and number of victims
10	state	State where incident occurred
11	incdate	Date of incident
12	repdate	Indicates whether the incdate (variable 11) reflects the incident date or report date
13	time	Time of incident
14	ucroffen	UCR offense code
15	ousing	Indicates whether the offender was suspected of using alcohol, drugs, etc.
16	location	Type of location where the incident occurred
17	weapon	Weapon or force used by the offender in the incident
18	bias	Specific bias motivation in the incident
19	victype	Indicates whether the victim was an individual (person) or some other type, e.g., business, government, school, etc.
20	vrace	Race of first victim in the incident
21	vsex	Sex of first victim in the incident
22	victage	Age of first victim in the incident
23	injury	Injury suffered by the first victim in the incident
24	vorelati	Relationship of first victim in the incident to the first offender in the incident
25	osex	Sex of first offender in the incident
26	offage	Age of first offender in the incident
27	offrace	Race of first offender in the incident
28	arrdate	Date of arrest in the incident
29	aage	Age of first arrestee in incident
30	asex	Sex of first arrestee in incident
31	arace	Race of first arrestee in incident
32	aresiden	Resident status of first arrestee in incident
33	n_arrest	Number of individuals arrested in the incident
34	biastype	General category of bias in incident

NIBRS9500 Database – Victim Table

Variable Number	Variable Name	Variable Description
1	incident	Agency number (ORI) combined with incident number
2	numvicti	The total number of victims in the incident
3	typevict	Category of incident based on age of youngest victim in the incident
4	numoffen	The number of offenders in this incident
5	typeoff	Category of incident based on the age of the youngest offender in the incident
6	agenum	Category of incident based on age group and number of offenders
7	vagenum	Category of incident based on age group and number of victims
8	state	State where incident occurred
9	incdate	Date of incident
10	UCR1	UCR offense code for offense #1
11	UCR2	UCR offense code for offense #2
12	UCR3	UCR offense code for offense #3
13	vtype	Indicates whether the victim was an individual (person) or some other type, e.g., business, government, school, etc.
14	vage	Victim age
15	vsex	Victim sex
16	vrace	Victim race
17	vethn	Victim ethnicity
18	vresiden	Resident status of the victim
19	injury1	Nature of victim’s injury #1
20	injury2	Nature of victim’s injury #2
21	injury3	Nature of victim’s injury #3
22	O1	Indicator of first offender in incident
23	vorel1	Relationship of victim to first offender in incident
24	O2	Indicator of second offender in incident
25	Vorel2	Relationship of victim to second offender in incident
26	using11	Offender 1 suspected of using... #1
27	using12	Offender 1 suspected of using… #2
28	using13	Offender 1 suspected of using… #3
29	using21	Offender 2 suspected of using… #1
30	using22	Offender 2 suspected of using… #2
31	using23	Offender 2 suspected of using… #3
32	using31	Offender 3 suspected of using… #1
33	using32	Offender 3 suspected of using… #2
34	using33	Offender 3 suspected of using… #3
35	locat1	First location of occurrence listed in the incident
36	locat2	Second location of occurrence listed in the incident
37	locat3	Third location of occurrence listed in the incident
38	numprem	Number of premises entered
39	entry1	Method of entry #1
40	entry2	Method of entry #2
41	entry3	Method of entry #3
42	crim11	Type criminal activity – added information on incident (up to three per offense)
43	crim12	Type criminal activity – added information on incident (up to three per offense)
44	crim13	Type criminal activity – added information on incident (up to three per offense)
45	crim21	Type criminal activity – added information on incident (up to three per offense)
46	crim22	Type criminal activity – added information on incident (up to three per offense)
47	crim23	Type criminal activity – added information on incident (up to three per offense)
48	crim31	Type criminal activity – added information on incident (up to three per offense)
49	crim32	Type criminal activity – added information on incident (up to three per offense)
50	crim33	Type criminal activity – added information on incident (up to three per offense)
51	wea11	Weapon/force used – up to three per offense in each incident – first offense/first weapon
52	wea12	Weapon/force used – up to three per offense in each incident – first offense/second weapon
53