ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Data Dictionary for the 2023 SafeTREC Traffic Safety Facts
2
The following data dictionary contains the filter queries used for the 10 different program areas of the 2023 SafeTREC Traffic Safety Facts.
3
Data Sources: Provisional Statewide Integrated Traffic Records System (SWITRS) and Fatality Analysis Reporting System (FARS)
4
Disclaimer 1: 2021 SWITRS data was provisional as of March 2023. For FARS, the 2021 Annual Report File was used. As a result, the same queries may yield a different result if using 2021 SWITRS or FARS data that has been updated.
5
Disclaimer 2: When using either SWITRS or FARS data, tables need to be appropriately joined in order to produce the correct number of crashes or victims. For more information on the relational structures of SWITRS and FARS, please see the resources below the data table.
6
7
Program AreaSWITRS QUERIESFARS QUERIES
8
Alcohol-Impaired Driving or Alcohol-Involved Driving party.PARTY_TYPE =1 AND party.PARTY_SOBRIETY IN ('B','C','D')Multiple imputation method
9
Distracted Drivingparty.OAF_1 = 'F' OR party.OAF_2 = 'F' OR party.SP_INFO_2 IN ('B','1')acc_aux.A_DIST=1*
10
Drug-Involved Drivingparty.PARTY_TYPE=1 AND party.PARTY_DRUG_PHYSICAL = Eperson.PER_TYPE=1 & ((drugs.DRUGRES>=100 & drugs.DRUGRES>=996 | drugs.DRUGRES == 998))
11
Emergency Medical ServicesNANA
12
Motorcycle Safetyparty.STWD_VEHICLE_TYPE IN ('C','O') AND victim.VICTIM_ROLE IN (1, 2)vehicle.VPICBODYCLASS IN (6|12|80|81|82|83|85|87|90|94| 98|100|103|104|109|110|114|125| 996) AND person.PER_TYPE IN (1|2|9)
13
14
Occupant
Protection		Occupant Protection
(General)		party.STWD_VEHICLE_TYPE IN ('A','B','D','E') AND
victim.VICTIM_ROLE IN (1, 2) AND
(victim.VICTIM_SAFETY_EQUIP_1 IN ('A','D','F','H','K','R','T','U') OR
victim.VICTIM_SAFETY_EQUIP_2 IN ('A','D','F','H','K','R','T','U'))		(((vehicle.VPICBODYCLASS IN (2, 7, 8, 9, 11, 60, 111, 119) OR vehicle.ICFINALBODY IN (2, 7, 8, 9, 11, 60, 111, 119)) AND (vehicle.GVWR_FROM IN (11,12) AND vehicle.GVWR_TO IN (11,12))) OR vehicle.VPICBODYCLASS IN (1, 3, 5, 10, 13, 15)) AND
person.PER_TYP IN (1|2|9)
15
16
17
Child Passenger SafetyOccupant Protection (General) AND victim.VICTIM_AGE < 15Occupant Protection (General) AND person.AGE < 15
18
Pedestrian and
Bicycle Safety		Pedestrianvictim.VICTIM_ROLE = 3person.PER_TYP=5
19
Bicyclistvictim.VICTIM_ROLE = 4 OR
(party.PARTY_TYPE = 4 AND victim.VICTIM_ROLE = 2)		person.PER_TYP in (6|7)
20
Speeding-Related and Other Crashescrash.PCF_VIOL_CATEGORY = '03' OR party.OAF_VIOL_CAT = '25'vehicle.SPEEDREL IN (2 | 3 | 4 | 5)
21
Older Adult Road Users victim.VICTIM_AGE >= 65 AND victim.VICTIM_AGE <= 125person.AGE>=65 AND person.AGE<=125
22
*FARS auxiliary accident file.
23
24
For more information on how SWITRS data is orgazined and the different variables available in each tables, please see UC Berkeley SafeTREC Transportation Injury Mapping System (TIMS) help FAQ page.
25
For more information on how FARS data is organized and the different variables availabe in each table, please see the FARS Reporting System Analytical User’s Manual. For more information on how FARS auxiliary tables are organized and the different variables available in each table, please see the FARS Auxiliary Datasets Analytical User’s Manual.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100