ArizonaCyclistFatalities.xls

	A	B	C	D	E	F	G	H	I	J	K	L	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG
1	Please send updates to: cazbikeweb@cazbike.org
2	2020 Arizona Cyclists Killed
3				Bicyclist				Motorist				FARS (prelim file --- light yellow background									ASDM ----- (light green backgound) ------												LOCATION
4	#	Date	Time	Name	Age	City / County	Location	Age	Vehicle/info	comments	link	ST_CASE	sUrbanRural	sLighting	sModel	BikeDir	BikePos	BikeLoc	CrashGroup	CrashType	IncidentID	link	IncidentDateTime	County	City	Oncic	Encic	eCollisionManner	eLightCondition	TotalUnits	TotalNonMotorists	Hit&Run	OnRoad	CrossingFeature	Latitude	Longitude	map link	eTrafficWayType	eIntersectionType	eJunctionRelation	eWeather	b_UnitNumber	eNonMotoristLocation	b_Sex	b_Age	b_Violation1	b_SafetyDevice	b_PersonType	b_Lane	b_Direction	b_Action	c_UnitNumber	c_Sex	c_Age	c_Violation1	c_Lane	c_Direction	c_Action

5		1/5/2020									datafile only										3641915	click	2020-01-05 12:58:00	MARICOPA	UNSPECIFIED_999	Maricopa County S.O.	Maricopa County S.O.	OTHER_97	DAYLIGHT	2	1	0	07 NORTHERN AVE	177th Ave	33.55167071	-112.4399309	click	TWO_WAY_NOT_DIVIDED	NOT_REPORTED_255	INTERSECTION_4_WAY		1	AT_INTERSECTION_NOT_IN_CROSSWALK	Male	86	RAN_STOP_SIGN	NONE_USED	PEDALCYCLIST	LANE_1	NORTH	GOING_STRAIGHT_AHEAD	2	Female	51	NO_IMPROPER_ACTION	LANE_1	EAST	GOING_STRAIGHT_AHEAD
6		1/17/2020	530pm	Mario Hernandez Roman	25 / M		15th and Southern			hit/run	https://azbikelaw.org/phoenix-bicyclist-killed-by-hit-run-suv-driver/	(not yet in datafile) as of 5/2020
7		2/25/2020									datafile only										3637785	click	2020-02-25 18:35:00	NAVAJO	SNOWFLAKE	Snowflake	Snowflake	OTHER_97	DUSK	2	1	0	09N OLD WOODRUFF RD E	E 24th St N	34.54239158	-110.0527846	click	TWO_WAY_NOT_DIVIDED	NOT_AT_INTERSECTION_0	NOT_JUNCTION_RELATED_0		2	SHOULDER_ROADSIDE	Male	60	NO_IMPROPER_ACTION	HELMET_USED	PEDALCYCLIST	LANE_1	SOUTH	GOING_STRAIGHT_AHEAD	1	Male	24	SPEED_TOO_FAST_FOR_CONDITIONS	LANE_1	NORTH	NEGOTIATING_A_CURVE
8		3/30/2020									datafile only										3640559	click	2020-03-30 5:50:00	COCHISE	BENSON	Dept. of Public Safety	Benson	OTHER_97	DARK_NOT_LIGHTED	2	1	1	I 010 0	M306	31.97370075	-110.2864073	click	TWO_WAY_DIVIDED_UNPROTECTED_PAINTED_4_FEET_MEDIAN	NOT_AT_INTERSECTION_0	NOT_JUNCTION_RELATED_0		2	NOT_AT_INTERSECTION_ON_ROADWAY_NOT_IN_CROSSWALK	Male	59	OTHER_97	NONE_USED	PEDALCYCLIST	LANE_2	WEST	UNKNOWN_99	1	Unspec	119	UNKNOWN_99	UNKNOWN_99	WEST	GOING_STRAIGHT_AHEAD
9		4/1/2020		NR	61 / F	Pima co.	Manville rd														3640096	click	2020-04-01 18:37:00	PIMA	UNSPECIFIED_999	Pima County S.O.	Pima County S.O.	SIDESWIPE_SAME_DIRECTION	DUSK	2	1	0	10 MANVILLE RD	Avra Rd	32.29173881	-111.2489225	click	TWO_WAY_NOT_DIVIDED	NOT_AT_INTERSECTION_0	NOT_JUNCTION_RELATED_0		2	OTHER_97	Female	61	NO_IMPROPER_ACTION	NOT_APPLICABLE_0	PEDALCYCLIST	LANE_1	WEST	GOING_STRAIGHT_AHEAD	1	Female	27	OTHER_97	CROSSWALK_20	WEST	GOING_STRAIGHT_AHEAD
10		5/6/2020	2300	Anthony Groth	61 / M	Phoenix	7th St and Hatcher	26 / F	sedan	poss. dui?	https://azbikelaw.org/man-on-bike-hit-and-killed-by-car-in-north-phoenix/
11		5/9/2020	morning?	Ed Rockland	70's / M	Chandler	Hunt Highway near Val Vista.			distracted	https://azbikelaw.org/killed-in-bike-lane-by-distracted-driver/
12		5/10/2020	around 7p	Nicole Hicks	35 / F	phoenix	32nd & Broadway		truck and horse trailer	driver red light violation	https://azbikelaw.org/woman-bicyclist-killed-in-collision-w-truck-horse-trailer/
13		5/21/2020	around 7p
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31	SELECT i.IncidentID, i.IncidentDateTime, i.IncidentYear, LOVCounty.name County,LOVCity.name City, OffNcic.name Oncic,ExtNcic.name Encic, i.OfficerId, i.OfficerNcic, i.ExtendedNcic, i.eCollisionManner, i.eLightCondition, i.TotalUnits, i.TotalNonMotorists, i.eInjurySeverity, i.InjurySeverity, i.HitAndRunFlag, i.OnRoad, i.CrossingFeature, i.Latitude, i.Longitude, i.eTrafficWayType, i.eIntersectionType, i.eJunctionRelation, i.eWeather, p_bike.UnitNumber b_UnitNumber, p_bike.eNonMotoristLocation, p_bike.eSex b_Sex, p_bike.Age b_Age, p_bike.eViolation1 b_Violation1, p_bike.eSafetyDevice b_SafetyDevice, p_bike.ePersonType b_PersonType, u_bike.eLane b_Lane, u_bike.eTravelDirection b_Direction, u_bike.eUnitAction b_Action, p_car.UnitNumber c_UnitNumber, p_car.eSex c_Sex, p_car.Age c_Age, p_car.eViolation1 c_Violation1, u_car.eLane c_Lane, u_car.eTravelDirection c_Direction, u_car.eUnitAction c_Action FROM (((( 2020_incident AS i JOIN 2020_person AS p_bike ON i.IncidentID = p_bike.IncidentID) JOIN 2020_unit AS u_bike ON p_bike.UnitID = u_bike.UnitID) JOIN 2020_person AS p_car ON i.IncidentID = p_car.IncidentID) JOIN 2020_unit AS u_car ON p_car.UnitID = u_car.UnitID ) LEFT OUTER JOIN LOVCounty ON i.CountyId = LOVCounty.id LEFT OUTER JOIN LOVCity ON i.CityId = LOVCity.id LEFT OUTER JOIN LOVNcic AS OffNcic ON i.OfficerNcic = OffNcic.id LEFT OUTER JOIN LOVNcic AS ExtNcic ON i.ExtendedNcic = ExtNcic.id WHERE p_bike.eInjuryStatus = 'FATAL' AND p_bike.ePersonType = 'PEDALCYCLIST' AND p_car.ePersonType='DRIVER' ORDER BY i.IncidentDateTime;
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