January to June data on traffic accidents from the Philadelphia Police Department, 2019-24.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	1	1	22-000567	1/3/2024	20:31	Greenland Dr	(2300)	FALSE	FALSE	TRUE	23	M	FALSE	FALSE	FALSE	FALSE
2	3	3	39-001225	1/7/2024	06:32	Sugdens Row	(3200)	FALSE	FALSE	TRUE		M	FALSE	FALSE	FALSE	FALSE
3	4	4	15-002883	1/11/2024	18:52	Aramingo Ave	(4600)	TRUE	FALSE	FALSE	25	M	FALSE	FALSE	FALSE	FALSE
4	5	5	22-002332	1/13/2024	06:00	N Broad St	Poplar St	FALSE	FALSE	TRUE	55	M	FALSE	FALSE	FALSE	TRUE
5	6	6	24-004694	1/20/2024	01:07	Frankford Ave	Allegheny Ave	TRUE	FALSE	FALSE	23	M	FALSE	FALSE	FALSE	FALSE
6	7	7	35-003917	1/20/2024	20:50	N 10th St	(6101)	FALSE	FALSE	TRUE	52	M	FALSE	FALSE	FALSE	TRUE
7	8	8	02-003729	1/28/2024	21:53	Oxford Ave	(6700)	FALSE	FALSE	TRUE	57	M	FALSE	FALSE	FALSE	TRUE
8	9	9	25-005715	1/29/2024	20:38	W Wyoming Ave	(400)	FALSE	FALSE	TRUE	57	F	FALSE	FALSE	FALSE	FALSE
9	10	10	18-004086	1/24/2024	12:30	Baltimore Ave	5909	FALSE	TRUE	FALSE	54	F	FALSE	FALSE	FALSE	FALSE
10	11	11	08-006273	2/25/2024	02:30	Knights Road	(12600)	TRUE	FALSE	FALSE	24	M	FALSE	FALSE	FALSE	FALSE
11	12	12	14-010662	2/27/2024	23:10	Ogontz Ave	(7900)	FALSE	FALSE	TRUE	47	M	FALSE	FALSE	FALSE	TRUE
12	13	13	03-009258	3/1/2024	02:45	Pattison Ave	(22)	FALSE	TRUE	FALSE	18	F	FALSE	FALSE	FALSE	FALSE
13	14	14	06-009538	3/3/2024	15:53	Juniper St	Locust St	FALSE	FALSE	TRUE	64	M	FALSE	FALSE	FALSE	TRUE
14	15	15	08-007685	3/6/2024	19:08	Frankford Ave	(9200)	FALSE	FALSE	TRUE	63	M	FALSE	FALSE	FALSE	FALSE
15	17	17	24-015496	3/3/2024	18:26	Somerset St	Richmond St	TRUE	FALSE	FALSE	34	M	FALSE	FALSE	FALSE	FALSE
16	18	18	25-018054	3/23/2024	05:40	Erie Ave	St Chris Dr	TRUE	FALSE	FALSE	44	M	FALSE	FALSE	FALSE	FALSE
17	19	19	02-012572	3/25/2024	16:33	Roosevelt Blvd	(7510)	TRUE	FALSE	FALSE	75	M	FALSE	FALSE	TRUE	FALSE
18	20	20	17-009285	3/28/2024	21:50	Grays Ferry Ave	30th St	FALSE	FALSE	TRUE	64	M	FALSE	FALSE	FALSE	TRUE
19	21	21	24-023147	4/1/2024	06:40	Wheatsheaf Ln	(2121)	FALSE	FALSE	TRUE	48	M	FALSE	FALSE	FALSE	FALSE
20	22	22	12-027481	4/8/2024	12:56	Island Ave	(2100)	TRUE	FALSE	FALSE	79	M	FALSE	FALSE	FALSE	FALSE
21	23	23	39-014070	1/10/2024	10:39	N Broad St	Westmoreland St	FALSE	FALSE	TRUE	65	M	FALSE	FALSE	FALSE	FALSE
22	24	24	26-010704	3/13/2024	19:20	Lehigh Ave	Frankford Ave	FALSE	TRUE	FALSE	48	F	TRUE	FALSE	FALSE	FALSE
23	25	25	35-021672	4/10/2024	20:30	Ogontz Ave	(5300)	FALSE	TRUE	FALSE	27	M	FALSE	FALSE	FALSE	TRUE
24	26	26	25-024861	4/21/2024	12:32	W Roosevelt Blvd	(410)	FALSE	TRUE	FALSE	16	M	FALSE	FALSE	TRUE	FALSE
25	27	27	18-020699	4/24/2024	05:35	Spruce St	(3600)	FALSE	FALSE	TRUE	55	M	FALSE	FALSE	FALSE	TRUE
26	28	28	24-030367	4/27/2024	20:49	Lehigh Ave	(1901)	FALSE	FALSE	TRUE	60	M	FALSE	FALSE	FALSE	FALSE
27	29	29	39-027441	5/2/2024	18:19	Sterner St	(2500)	TRUE	FALSE	FALSE	36	M	TRUE	FALSE	FALSE	FALSE
28	30	30	02-020470	5/8/2024	18:00	Comly St	(215)	FALSE	FALSE	TRUE	02	F	FALSE	FALSE	FALSE	FALSE
29	31	31	39-031267	5/17/2024	00:24	N Broad St	(4132)	TRUE	FALSE	FALSE	32	M	TRUE	FALSE	FALSE	FALSE
30	32	32	02-021072	5/11/2024	20:42	Tabor Rd	(5300)	FALSE	FALSE	TRUE	29	M	FALSE	FALSE	FALSE	TRUE
31	33	33	16-019094	5/25/2024	21:39	Mount Vernon St	(3220)	FALSE	FALSE	TRUE	07	M	FALSE	FALSE	FALSE	FALSE
32	34	34	25-034938	5/28/2024	20:08	Hunting Park Av	Front St	TRUE	FALSE	FALSE	55	M	TRUE	FALSE	FALSE	FALSE
33	35	35	24-039753	5/28/2024	23:58	E Torresdale Ave	(1801)	FALSE	FALSE	TRUE	44	M	FALSE	FALSE	FALSE	TRUE
34	36	36	08-018593	5/30/2024	21:11	State Road	(8400)	FALSE	TRUE	FALSE	17	M	FALSE	FALSE	FALSE	TRUE
35	37	37	26-027283	6/8/2024	20:22	Lehigh Ave	Lawrence St	TRUE	FALSE	FALSE	30	M	TRUE	FALSE	FALSE	FALSE
36	38	38	39-038469	6/13/2024	20:29	N Broad St	Westmoreland St	TRUE	FALSE	FALSE	35	M	FALSE	FALSE	FALSE	FALSE
37	39	39	07-017309	6/17/2024	00:45	Welsh Road	(1100)	TRUE	FALSE	FALSE	59	M	FALSE	FALSE	FALSE	FALSE
38	40	40	08-020624	6/18/2024	16:46	Roosevelt Blvd	(15001)	TRUE	FALSE	FALSE	26	F	FALSE	FALSE	TRUE	FALSE
39	41	41	22-045054	6/23/2024	00:52	Cecil B Moore Av	20th St	TRUE	FALSE	FALSE	38	M	FALSE	FALSE	FALSE	TRUE
40	42	42	35-040092	6/23/2024	00:52	W Godfrey Av	(600)	TRUE	FALSE	FALSE	29	M	FALSE	FALSE	FALSE	FALSE
41	43	43	39-041273	6/25/2024	01:42	N Broad St	(4100)	TRUE	FALSE	FALSE			FALSE	FALSE	FALSE	FALSE
42	43	44	39-041273	6/25/2024	01:42	N Broad St	(4100)	TRUE	FALSE	FALSE	46	M	FALSE	FALSE	FALSE	FALSE
43	44	45	03-029582	6/25/2024	06:00	S Front St	(1000)	FALSE	FALSE	TRUE	68	M	FALSE	FALSE	FALSE	FALSE
44	Incident ID	Victim ID	DC#	DATE	TIME	Primary Street	Secondary Street	DRIVER	PASSENGER	PEDESTRIAN	AGE	SEX	MOTORCYCLE	BICYCLE	R Blvd	LTS
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