﻿_id	id	device_id	record_oid	count_start_date	count_end_date	average_daily_car_traffic	average_daily_bike_traffic	counter_number	counter_type	speed_limit	max_speed	median_speed	percent_over_limit	speed85_percent	speed95_percent	longitude	latitude	neighborhood	council_district	ward	tract	public_works_division	pli_division	police_zone	fire_zone
1	1011743669	85	1445865260	2019-04-18	2019-04-26	4949		6	StatTrak	25		29	77	34	37	-79.96777201	40.45573295	Polish Hill	7	6	42003060500	6	6	2	2-6
2	1026101993	140	1121444006	2019-01-24					Intersection Study							-79.9522495	40.46615676	Central Lawrenceville	7	9	42003090200	2	9	2	3-6
3	1032382575	11	1539892711	2018-08-28	2018-09-04					35	63	33	28	38	41	-80.07646887	40.46071714	Windgap	2	28	42003563000	5	28	6	1-16
4	103627606	9	734195080	2018-07-17	2018-08-01	2741			StatTrak	25	61	28	70	31	33	-79.91433497	40.43737854	Squirrel Hill South	5	14	42003140800	3	14	4	2-18
5	1039546167	144														-80.01921111	40.49079426	Perry North	1	26	42003260200	1	26	1	1-15
6	1041392556	76	571347213	2019-03-22	2019-03-29	1046		2	StatTrak	25		19	2	21	23	-80.01423363	40.45810596	Central Northside	6	25	42003250300	1	25	1	1-21
7	1047444948	17	1366891391	2018-10-18						25						-79.94227261	40.44628196	Squirrel Hill North	8	14	42003140100	3	14	4	2-26
8	1053645660	87	804208919	2019-04-18	2019-04-26	3015		4	StatTrak	25		26	58	31	34	-79.96459248	40.45711932	Polish Hill	7	6	42003060500	6	6	2	2-6
9	1073440033	156	1736165318	2017-07-28					Intersection Study							-79.96038525	40.43898325	Central Oakland	3	4	42003040500	3	4	4	2-14
10	1092885547	143														-79.9209585	40.467294	East Liberty	9	11	42003111300	2	11	5	3-8
11	1102260248	8	1088318339	2018-07-16	2018-08-01	5592			StatTrak	25	61	28	70	31	33	-79.91192545	40.43562019	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
12	1110382210	47	106669941	2019-05-31	2019-06-06				StatTrak	25		29	75	35	38	-79.92737032	40.42372166	Greenfield	5	15	42003151700	3	15	4	2-15
13	1117908706	130	1566356938	2018-06-04					Intersection Study							-79.98551968	40.43679226	Bluff	6	1	42003010300	3	1	2	2-4
14	1130122192	65	1341476139	2019-02-05	2019-02-14	1455			StatTrak	25		22	23	28	32	-79.97955406	40.43648236	Bluff	6	1	42003010300	3	1	2	2-1
15	115502120	176	1215642552	2019-08-09	2019-08-19	11500		5	StatTrak	25		37	98	41	44	-80.05240317	40.45192582	Crafton Heights	2	20	42003281400	5	20	6	1-16
16	1155507145	72	1207664438	2019-02-14	2019-02-21	6793		1	StatTrak	25		26		30		-79.94374469	40.45270903	Shadyside	8	7	42003070900	2	7	4	3-22
17	1156129090	159														-79.9576785	40.48178403	Upper Lawrenceville	7	10	42003101100	2	10	2	3-5
18	1158858353	36	1131386560	2018-06-25	2018-07-12	7688			StatTrak	25	64	32	92	35	38	-79.92331564	40.47816127	Highland Park	7	11	42003110200	2	11	5	3-9
19	1159852619	118	1024536191	2019-07-09	2019-07-12	10350		12	StatTrak	25		29	78	34	39	-80.00193738	40.4478489	North Shore	1	22	42003563200	6	22	1	1-20
20	1181317290	50	547249635	2018-12-28	2019-01-10	9435		11	StatTrak	25		29	79	34	38	-79.9269309	40.47015706	East Liberty	9	11	42003111300	2	11	5	3-8
21	1195830691	23	914441129	2019-12-15	2019-12-24	3860		2	StatTrak	25		24	36	29	34	-80.00955705	40.4331717	Mount Washington	2	19	42003190300	5	19	3	4-27
22	1204353487	173	604849055	2019-08-09	2019-08-19	9709		6	StatTrak	25		29	79	34	36	-80.01587315	40.40252762	Brookline	4	19	42003191700	5	19	6	4-26
23	1212908013	18	2140917772	2018-09-21	2018-10-17				Tube	25						-80.00338687	40.43293366	South Shore	3	19	42003980700	5	19	3	4-2
24	1234866649	20	1631657541	2018-09-21	2018-10-17				Tube							-79.99510153	40.43430152	Bluff	6	1	42003010300	6	1	2	2-4
25	1241651644	137	1512307687	2019-06-06					Intersection Study							-79.96011943	40.44050937	Central Oakland	3	4	42003040500	3	4	4	2-14
26	1263398518	202	1714736490	2019-11-04	2019-11-13	613		2	StatTrak	25		22	25	27	31	-79.92741399	40.45231499	Shadyside	8	7	42003070600	2	7	4	3-11
27	1292111053	179	1825903801	2019-08-30	2019-09-09	1163		15	StatTrak	25		25	44	29	32	-79.92397388	40.46907146	East Liberty	9	11	42003111300	2	11	5	3-8
28	129975666	169	403208613	2019-08-01	2019-08-09	7686		3	StatTrak	25		30	89	35	38	-80.01423835	40.42978268	Mount Washington	2	19	42003190300	5	19	3	4-1
29	1317856239	128	1699722646	2018-11-06					Intersection Study							-79.96180918	40.42477666	South Side Flats	3	16	42003160900	3	16	3	4-24
30	1329900951	133	1615505629	2019-07-18	2019-07-26	3239		2	StatTrak	25		27	62	32	35	-79.91652254	40.44443596	Squirrel Hill North	8	14	42003140300	3	14	4	2-18
31	133236567	73	1441617442	2019-02-14	2019-02-22	1120		CHECK # AND DIRECTION	StatTrak	25		21	17	26	29	-79.94571343	40.45549902	Bloomfield	7	8	42003080400	2	8	5	2-23
32	1345473232	26	1550819866	2018-11-14	2018-11-20	9546			StatTrak	25	59	28	68	31	34	-79.92779001	40.43688097	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
33	1354544991	114	87062605	2019-06-28	2019-07-05	6984		14	StatTrak	35		29	14	35	39	-79.9406417	40.4563822	Bloomfield	7	8	42003080400	2	8	5	3-1
34	137432711	61	1367249115	2019-03-07	2019-03-14	8512		1	StatTrak	25	30	26	52	31	35	-79.91439666	40.46062267	Larimer	9	12	42003120800	2	12	5	3-10
35	1400409572	106	677650724	2019-06-13	2019-06-20	4448			StatTrak	25		28	68	25		-79.93595346	40.46180227	Friendship	9	8	42003080700	2	8	5	3-23
36	1408140580	212	1715086530	2019-06-11	2019-06-11		2063	Tuesday SPC video data								-79.95862613	40.43102343	South Oakland	3	4	42003980800	3	4	4	2-2
37	1412494129	116	159026183	2019-07-05	2019-07-11	3150		6	StatTrak			34	95	39	43	-79.93727559	40.43804843	Squirrel Hill North	5	14	42003140100	3	14	4	2-8
38	1419330323	92	1083199734	2019-04-26	2019-05-04	12335			StatTrak	25		31	87	36	39	-79.89620029	40.4444114	Point Breeze	9	14	42003140600	3	14	4	3-14
39	1432224337	150	2014846017						StatTrak	25						-80.04879395	40.43135694	Westwood	2	28	42003563100	5	28	6	1-18
40	144345379	192	383914084	2019-10-14	2019-10-21	16729		3	StatTrak	25		30	86	35	38	-79.89667461	40.43681375	Regent Square	5	14	42003141000	3	14	4	2-16
41	1463283046	115	665615900	2019-06-28	2019-07-05	8911		15	StatTrak			27		33	37	-79.93166971	40.45903735	East Liberty	7	8	42003111500	2	8	5	3-23
42	1466903750	3	2009670262	2018-09-13	2018-09-20	8407			StatTrak	25	77	32	97	36	39	-79.92899198	40.4693202	East Liberty	9	11	42003111300	2	11	5	3-4
43	1468921509	132	1461288045	2019-07-18	2019-07-26	1265		1	StatTrak	25		26	56	30	33	-79.91650754	40.44561249	Point Breeze	8	14	42003140400	3	14	4	2-17
44	1503643471	55	1966066309	2019-01-14	2019-01-22	1786		14	StatTrak	25		18	4	21	24	-79.96050515	40.47360042	Central Lawrenceville	7	9	42003090100	2	9	2	3-3
45	1530178639	68	676704832	2019-02-05	2019-02-14				StatTrak							-79.98086521	40.43660264	Bluff	6	1	42003010300	3	1	2	2-1
46	1533566550	196	1464305119	2019-10-21	2019-10-29	527		4	StatTrak	25		23	25	27	30	-79.98968666	40.41812496	Knoxville	3	30	42003300100	5	30	3	4-6
47	1566340195	24	1549751514	2019-10-21	2019-10-28	3776		5	StatTrak	25		25	47	30	33	-79.9493951	40.44112373	Central Oakland	5	4	42003040600	3	4	4	2-8
48	1568219989	31	2101724073	2019-01-14	2019-01-22	6443			StatTrak	25		25	47	32	36	-79.98064703	40.45349731	Strip District	7	2	42003020300	6	2	2	2-25
49	1581659026	7	371546790	2018-10-19	2018-11-08		198		Tube							-79.95142134	40.44225095	Central Oakland	3	4	42003982200	3	4	4	2-8
50	1591011355	165														-79.96331914	40.43938259	West Oakland	6	4	42003040200	3	4	4	2-14
51	1592268905	111	242374247	2019-06-28	2019-07-05	6984		11	StatTrak	35		30	14	35	39	-79.95007952	40.45402427	Bloomfield	7	8	42003080400	2	8	5	2-23
52	1598018270	71	1717624375	2019-02-14	2019-02-18			2	StatTrak							-79.94205758	40.45106804	Shadyside	8	7	42003070900	2	7	4	3-22
53	1604686268	37	1114667008	2018-06-05	2018-06-21	976			StatTrak	25		27.2		28.7	29.8	-79.92591208	40.42485559	Greenfield	5	15	42003151700	3	15	4	2-15
54	1628179164	14	747494082	2018-06-05	2018-06-21											-79.92618443	40.42126864	Greenfield	5	15	42003151700	3	15	4	2-15
55	1635967977	12	1029658716	2019-12-12	2019-12-24	1080		16	StatTrak	25		24	39	31	36	-79.9155315	40.471092	Highland Park	7	11	42003110600	2	11	5	3-9
56	1658184502	60	1739195149	2019-03-08	2019-03-14	1218		5	StatTrak	25		19	10	24	27	-79.91288926	40.46107368	Larimer	9	12	42003120800	2	12	5	3-12
57	1667548447	62	1755445415	2019-03-07	2019-03-14	728		2	StatTrak	25		22	22	27	29	-79.91397019	40.46013288	Larimer	9	12	42003120800	2	12	5	3-10
58	1669534769	10	1211728398	2018-08-20	2018-09-04	2931			StatTrak	25	73	32	44	36	40	-80.07339585	40.45766034	Windgap	2	28	42003563000	5	28	6	1-16
59	1670424503	45	256296411	2018-12-11	2018-12-20	2046		2	StatTrak	25	56	30	85	35	38	-80.02553687	40.40494914	Beechview	4	19	42003192000	5	19	6	4-28
60	1679750822	146	1502387803						StatTrak	25						-79.9654313	40.41840112	South Side Slopes	3	16	42003160800	3	16	3	4-22
61	1683704966	74	2021427153	2019-02-14	2019-02-22	7111			StatTrak	25		32	91	38	41	-79.94753931	40.45629549	Bloomfield	7	8	42003080400	2	8	5	2-23
62	1691716209	33	104424121	2019-12-12	2019-12-24	1530		5	StatTrak	25		22	15	25	28	-79.96058225	40.45581498	Upper Hill	6	5	42003050600	3	5	2	2-22
63	1706030566	131	461114479	2018-12-04					Intersection Study							-79.92916037	40.46265524	East Liberty	9	8	42003111500	2	8	5	3-23
64	1715881199	134	892947564	2019-08-30	2019-09-09	781		12	StatTrak	25		24	35	28	31	-79.91884232	40.44270124	Squirrel Hill North	8	14	42003140300	3	14	4	2-18
65	1717007839	155	296679783	2017-08-04					Intersection Study							-79.98924526	40.44881881	Strip District	7	2	42003020300	6	2	2	2-3
66	1719894567	52	647961876	2019-01-02	2019-01-10	5490		13	StatTrak	25		33	96	37	39	-79.91556754	40.43463262	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
67	1748063787	138	2093126519	2019-06-06					Intersection Study							-79.96322543	40.44463282	North Oakland	8	4	42003982200	3	4	4	2-10
68	1762392161	117	445302996	2019-07-09	2019-07-12			1	StatTrak	25		31	89	36	39	-80.00378538	40.44698296	North Shore	1	22	42003563200	6	22	1	1-20
69	1764179882	218	2070392086	2019-11-22	2019-12-04	4016		3	StatTrak	25		33	95	37	40	-79.94220469	40.4807247	Stanton Heights	9	10	42003101800	2	10	5	3-5
70	1767041391	217	1950664877	2019-11-22	2019-12-04	6090		2	StatTrak	25		30	76	35	38	-79.93672854	40.48122548	Stanton Heights	7	10	42003101800	2	10	5	3-7
71	1768576138	75	648748382	2019-03-22	2019-03-29	9405		11	StatTrak	25		39	98	45	50	-80.02854943	40.45486521	Manchester	6	21	42003210700	1	21	1	1-8
72	1778941167	171	755918726	2019-08-01	2019-08-09	8243		5	StatTrak	25		31	92	36	39	-79.98340694	40.42169397	South Side Slopes	3	17	42003170600	3	17	3	4-3
73	1780264395	154	1346599065	2017-11-30					Intersection Study							-79.96202491	40.43571895	South Oakland	6	4	42003040900	3	4	4	2-10
74	1783830298	99	644311719	2019-05-28	2019-06-05	927		2	StatTrak	25		22	26	28	32	-79.9358625	40.439286	Squirrel Hill North	8	14	42003140100	3	14	4	2-8
75	1784275556	108	215436152	2019-06-13	2019-06-20				StatTrak	25		21	8	24		-79.92935523	40.4806988	Morningside	7	10	42003101400	2	10	5	3-7
76	181106020	184	2107178505	2019-09-09	2019-09-17	763		14	StatTrak	25		22	20	27	30	-80.02645665	40.40951121	Beechview	4	19	42003191600	5	19	6	4-28
77	1811704043	164														-79.94499233	40.40869619	Hazelwood	5	15	42003562900	3	15	4	2-13
78	1831547274	122	404240136	2019-03-02					Intersection Study							-79.96256825	40.43853938	South Oakland	6	4	42003040900	3	4	4	2-14
79	1838413170	208	367296608	2019-11-14	2019-12-04	317		4	StatTrak	25		22	21	27	30	-79.91835449	40.47036337	Highland Park	7	11	42003110600	2	11	5	3-9
80	1858604360	43	1603853069	2018-12-04	2018-12-08	768		2	StatTrak	25	20	19.3	0	19.5	19.8	-79.96113978	40.45873516	Polish Hill	7	6	42003060500	6	6	2	2-6
81	1885274692	13	563616731	2019-12-12	2019-12-24	4548			StatTrak			28		32	35	-79.91541	40.47216898	Highland Park	7	11	42003110600	2	11	5	3-9
82	1890248654	182	414168419	2019-09-09	2019-09-17	1410		11	StatTrak	25		18	1	20	22	-80.01451118	40.48540243	Perry North	1	26	42003260700	1	26	1	1-15
83	1892724639	206	1551520471	2019-11-14	2019-11-22	2450		3	StatTrak	25		25	43	29	32	-79.93147351	40.4350968	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
84	1901404544	124	1353107740	2019-07-09					Intersection Study							-79.96308762	40.46819844	Lower Lawrenceville	7	6	42003060300	2	6	2	3-3
85	1909253901	200	382287114	2019-11-04	2019-11-13	416		3	StatTrak	25		22	21	27	30	-79.93259811	40.44978768	Shadyside	8	7	42003070300	2	7	4	3-22
86	1910901085	211	1129909123	2019-06-11	2019-06-11		954	Tuesday SPC video count								-79.9619266	40.42706242	South Side Flats	3	16	42003160900	3	16	3	4-24
87	1920331937	57	951153209	2019-01-24	2019-01-27	5151			StatTrak	25		30	82	36	40	-79.91268541	40.46014717	Larimer	9	12	42003120800	2	12	5	3-10
88	1922660255	104														-79.91220792	40.44320727	Point Breeze	9	14	42003981100	3	14	4	2-18
89	1927765267	220	2128886737	2019-12-12	2019-12-24	4550		3	StatTrak	25		28	77	32	35	-79.95546822	40.44952206	North Oakland	8	4	42003562000	3	4	4	2-7
90	1931690242	95	670720124	2019-05-16	2019-05-28			3	StatTrak	25						-79.99753526	40.38585034	Overbrook	4	32	42003320700	5	32	3	4-25
91	193365102	152	1397392243	2018-04-05					Intersection Study							-79.9173396	40.45747705	Larimer	9	12	42003120800	2	12	5	3-13
92	1937275532	15	1524870004	2018-10-18	2018-11-08		88		Tube							-79.95222986	40.44355804	North Oakland	8	4	42003982200	3	4	4	2-8
93	1944653312	214														-79.92723824	40.41953524	Greenfield	5	15	42003151700	3	15	4	2-12
94	1949792833	34	423973251	2019-04-19	2019-04-26	13788		5	StatTrak	25		38	98	45	50	-79.87884462	40.45609866	East Hills	9	13	42003130600	2	13	5	3-17
95	1950996584	167	1709615411	2019-08-01	2019-08-09	5831		1	StatTrak	25		25	48	30	33	-80.01896038	40.43810096	Duquesne Heights	2	19	42003191100	5	19	3	4-1
96	1962477925	185	1815733444	2019-09-09	2019-09-17	1468		5	StatTrak	25		21	21	27	32	-80.02168961	40.39386195	Brookline	4	19	42003191800	5	19	6	4-26
97	1970919677	51	152378178	2018-12-28	2019-01-10	5787		11	StatTrak	25		28	68	32	36	-79.92516869	40.4710773	East Liberty	9	11	42003111300	2	11	5	3-9
98	197297885	44	1074767029	2018-12-11	2018-12-20	4301		1	StatTrak	25	61	27	60	32	36			Mount Washington	2	19	42003190300	5	19	3	4-1
99	1978276806	35	1470358683						StatTrak							-79.89508807	40.46746757	Lincoln-Lemington-Belmar	9	12	42003561900	2	12	5	3-18
100	1991312704	109	1227701093	2019-06-14	2019-06-24	3304			StatTrak	25			60	31	35	-80.05406427	40.45416573	Sheraden	2	20	42003562500	5	20	6	1-16
101	1999344253	30	869081196						StatTrak							-80.03886571	40.43751249	Elliott	2	20	42003562600	5	20	6	1-17
102	1999971120	28	821675395	2018-11-20	2018-11-29	1802		1	StatTrak	25	60	28	71	32	35	-79.93023611	40.48119172	Morningside	7	10	42003101400	2	10	5	3-7
103	2010535291	32	349231465	2019-10-21	2019-10-29	1049		1	StatTrak	25		21	15	25	29	-79.95893404	40.45986096	Polish Hill	7	6	42003060500	6	6	2	2-6
104	2010764703	112	337528599	2019-06-28	2019-07-05	7579		12	StatTrak	35		34	40	39	43	-79.95056556	40.45414752	North Oakland	6	5	42003562000	3	5	4	2-23
105	2036930509	69	1766709460	2019-02-14	2019-02-19	7621		6	StatTrak	25		26		32	37	-79.94232312	40.44625098	Squirrel Hill North	8	14	42003140100	3	14	4	2-26
106	2043200367	19	198025605	2018-09-21	2018-10-17				Tube							-80.00353171	40.43277645	South Shore	3	19	42003980700	5	19	3	4-2
107	2049722358	5	788509482	2018-10-17	2018-10-29	4015			StatTrak	25	56	29	81	33	36	-80.01367658	40.43088376	Mount Washington	2	19	42003190300	5	19	3	4-1
108	2051810147	215														-79.9714485	40.45971601	Strip District	7	6	42003020300	6	6	2	3-2
109	2081817713	16	1173781973	2018-10-18	2018-11-08	3580			Tube							-79.94878377	40.44199223	North Oakland	8	4	42003982200	3	4	4	2-8
110	2101056227	39	390219700	2018-06-25	2018-07-11	5327			StatTrak	25	49	21	10	24	28	-79.91887807	40.47948497	Highland Park	7	11	42003980100	2	11	5	3-9
111	2105934554	170	537629304	2019-08-01	2019-08-09	9075		4	StatTrak	25		32	91	37	40	-80.00697132	40.42044846	Mount Washington	2	19	42003191500	5	19	3	4-16
112	2140403077	89	1958633037			16711			StatTrak	25		34	90	41	45	-79.98250998	40.45106102	Strip District	7	2	42003020300	6	2	2	2-3
113	2144656649	145														-80.02346881	40.41684574	Beechview	4	19	42003191600	5	19	6	4-28
114	2146294802	194	1598450025	2019-12-12	2019-12-24	5015		4	StatTrak	25		32	94	36	39	-79.91097942	40.43563381	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
115	227010728	90	1841997569	2019-01-14	2019-01-22	2305			StatTrak	25		19	6	23	25	-79.99886586	40.43812771	Central Business District	6	1	42003020100	6	1	2	1-4
116	227082796	209	1717953508	2019-11-14	2019-12-02	995		1		25		20	9	24	27	-79.91624686	40.47001795	Highland Park	7	11	42003110600	2	11	5	3-9
117	235210908	139	1849077535	2019-06-06					Intersection Study							-79.95373577	40.44320393	North Oakland	3	4	42003982200	3	4	4	2-7
118	249390037	166														-79.946262	40.46212801	Bloomfield	7	8	42003080900	2	8	5	3-6
119	26685456	42	1014355185													-79.98255105	40.45456098	Strip District	7	2	42003020300	6	2	2	2-25
120	275496503	180	1511161277	2019-08-30	2019-09-09	317		16	StatTrak	25	45	21	22	27	32	-79.92604991	40.46882391	East Liberty	9	11	42003111300	2	11	5	3-8
121	283927123	160														-79.9599285	40.439268	Central Oakland	3	4	42003040500	3	4	4	2-14
122	286504681	119	378111062	2019-07-09	2019-07-18			4	StatTrak	25						-79.916863	40.44124594	Squirrel Hill North	8	14	42003140300	3	14	4	2-18
123	300989656	147	1324522674	2019-10-21	2019-10-29	2436		3	StatTrak	25		30	85	34	37	-79.97742	40.40932501	St. Clair	3	16	42003561700	3	16	3	4-8
124	301291530	181	98475052	2019-09-09	2019-09-17	6943		11	StatTrak	35		33	26	37	40	-80.01776679	40.47042636	Perry South	6	26	42003261500	1	26	1	1-12
125	314332417	67	1277351795	2019-02-05	2019-02-14	1363			StatTrak	25		17	9	23	28	-79.97778916	40.4365681	Bluff	6	1	42003010300	3	1	2	2-1
126	325834347	40	1847569204	2018-08-10	2018-08-17	338			StatTrak	25	45	23		28	30	-80.03719351	40.43872645	Elliott	2	20	42003562600	5	20	6	1-17
127	335439540	135	2108033802	2019-07-18	2019-07-26	4354		3	StatTrak	25		25	41	29	33	-79.9235397	40.45919972	Shadyside	8	7	42003070800	2	7	4	3-11
128	340863639	94	690167521	2020-12-15	2020-12-23	1468		5	StatTrak	25	56		24	28	31	-79.98843731	40.39126208	Carrick	4	29	42003290400	3	29	3	4-23
129	345918218	195														-79.97741025	40.40932007	St. Clair	3	16	42003561700	3	16	3	4-8
130	348266598	183	793526528	2019-09-09	2019-09-17	3302		13	StatTrak	25		35	97	40	43	-80.01384775	40.48801855	Perry North	1	26	42003260200	1	26	1	1-15
131	358321678	21	236359592	2018-09-21	2018-10-17											-80.00995024	40.44562784	North Shore	1	22	42003981200	6	22	1	1-7
132	364823086	6	109955947	2018-10-17	2018-11-08		102		Tube							-79.9519779	40.44357372	North Oakland	8	4	42003982200	3	4	4	2-8
133	370215367	178	305312914	2019-08-30	2019-09-09	483		13	StatTrak	25		26	51	33	37	-79.92909548	40.47153004	East Liberty	7	11	42003111300	2	11	5	3-8
134	37342806	141														-79.977251	40.45822535	Strip District	7	6	42003020300	6	6	2	2-25
135	382839437	59	334434337	2019-05-01	2019-05-07	3827			StatTrak	25		28	69	33	37	-79.91227235	40.46057165	Larimer	9	12	42003120800	2	12	5	3-12
136	41516750	161														-79.945821	40.447503	Shadyside	8	7	42003070900	2	7	4	2-9
137	424435594	123	944115427	2019-05-20					Intersection Study							-79.97623766	40.45752252	Strip District	7	6	42003020300	6	6	2	3-2
138	428229895	25	845788920	2018-11-08	2018-11-14	382			StatTrak	25	43	16	0	20	24	-79.960275	40.43979142	Central Oakland	6	4	42003040500	3	4	4	2-14
139	435095238	102														-79.92710128	40.42447666	Greenfield	5	15	42003151700	3	15	4	2-15
140	454488789	199	632149062	2019-11-04	2019-11-13	9600		4	StatTrak	35		33	32	38	41	-80.05070591	40.43335152	Westwood	2	28	42003563100	5	28	6	1-18
141	462461649	78	374364494	2019-03-22	2019-03-29	2386		4	StatTrak	25		27	65	32	36	-80.00926886	40.45110551	Allegheny Center	1	22	42003562700	1	22	1	1-7
142	495567113	105	1458021409	2019-06-13	2019-06-20	1270			StatTrak	25		21	15	25		-79.93721678	40.45957376	Bloomfield	7	8	42003080600	2	8	5	3-23
143	503144889	174	12984207	2019-08-09	2019-08-19	3427		1	StatTrak	25		35	97	40	43	-80.04435805	40.44894144	Elliott	2	20	42003562600	5	20	6	1-17
144	511073981	207	871644629	2019-11-14	2019-12-04	155		6	StatTrak	25		21	21	27	31	-79.91919042	40.47070028	Highland Park	7	11	42003110600	2	11	5	3-9
145	534535231	4	457410812	2018-10-17	2018-10-29	7619			StatTrak	25	71	32	94	34	36	-80.0140905	40.42962	Mount Washington	2	19	42003191400	5	19	3	4-1
146	552155483	79	1302989701	2019-03-22	2019-04-29	1924		5	StatTrak	25		24	38	29	32	-79.99704872	40.45771003	East Allegheny	1	23	42003563200	1	23	1	1-5
147	558341587	56	1046267212	2019-01-14	2019-01-22	936		16	StatTrak	25		22	24	27	32	-79.96103086	40.47503836	Central Lawrenceville	7	9	42003090100	2	9	2	3-3
148	559773473	41	726411339	2017-11-20					Intersection Study							-79.9528885	40.4636283	Bloomfield	7	9	42003090300	2	9	5	3-6
149	562963377	177	995469639	2019-08-30	2019-10-09	541		11	StatTrak	25		24	38	29	33	-79.91768838	40.43915109	Squirrel Hill North	5	14	42003140300	3	14	4	2-18
150	563226335	2	70105834	2019-09-24	2019-10-08	867		5	StatTrak	25		19	8	24	27	-79.947801	40.464072	Bloomfield	7	8	42003080900	2	8	5	3-6
151	583558220	213	1610564825	2019-06-11	2019-06-11		1278	Tuesday SPC video data								-79.95684514	40.42929208	South Oakland	3	4	42003980800	3	4	4	2-12
152	589731012	198	211963031	2019-11-04	2019-11-13	5800		5	StatTrak	35		40	87	45	48	-80.04611129	40.43825783	Westwood	2	28	42003562600	5	28	6	1-17
153	594098653	187	1074954009	2019-09-24	2019-10-08	719		3	StatTrak	25		21	11	25	27	-79.92598252	40.42405251	Squirrel Hill South	5	14	42003141400	3	14	4	2-15
154	596116859	70	1435552894	2019-02-14	2019-02-22	5859		4	StatTrak	25		30	83	35	38	-79.94271741	40.44877794	Shadyside	8	7	42003070900	2	7	4	3-22
155	597499467	163														-79.9834994	40.45328303	Strip District	7	2	42003020300	6	2	2	2-25
156	607205051	129	1884276852	2019-07-01					Intersection Study							-79.97101147	40.46110505	Strip District	7	6	42003020300	6	6	2	3-2
157	609406388	204	424741047	2019-11-14	2019-11-22	1390		2	StatTrak	25		21	8	24	27	-79.92797767	40.44542381	Squirrel Hill North	8	14	42003140200	3	14	4	2-17
158	610049666	126	687814145	2019-05-09					Intersection Study							-80.0239777	40.4505028	Chateau	6	21	42003980600	1	21	1	1-8
159	615223154	175	1247630628	2019-08-09	2019-08-19	131		4	StatTrak	25		22	29	29	33	-80.07365573	40.45640109	Windgap	2	28	42003563000	5	28	6	1-16
160	617004784	188	1101847582	2019-09-24	2019-10-08	1183		4	StatTrak	25		19	6	23	26	-79.92610297	40.42109337	Squirrel Hill South	5	14	42003141400	3	14	4	2-15
161	626984277	127	744399552	2019-03-13					Intersection Study							-79.92335097	40.42959334	Squirrel Hill South	5	14	42003141400	3	14	4	2-21
162	627026154	162														-79.9442732	40.45466833	Bloomfield	7	8	42003080400	2	8	5	2-23
163	633942490	1	1348699590	2018-12-28	2019-01-09	6513		14	StatTrak	25		34	97	39	43	-79.91215393	40.4431866	Point Breeze	9	14	42003981100	3	14	4	2-18
164	638221590	48	43884302	2019-09-24	2019-10-08	571			StatTrak	25		19	8	24	95	-79.93387468	40.43666494	Squirrel Hill South	5	14	42003980500	3	14	4	2-21
165	643622454	120	469728564	2019-07-09	2019-07-18			3	StatTrak	25						-79.9251926	40.44395674	Squirrel Hill North	8	14	42003140300	3	14	4	2-18
166	655507460	216														-79.9452344	40.45993546	Bloomfield	7	8	42003080900	2	8	5	3-6
167	658228067	168	2069832401	2019-08-01	2019-08-09	4921		2	StatTrak	25		29	81	33	36	-80.01381925	40.43073623	Mount Washington	2	19	42003190300	5	19	3	4-1
168	706207575	97	1467628094	2019-05-16	2019-05-28			5	StatTrak	25						-80.01562722	40.39425912	Brookline	4	19	42003191700	5	19	6	4-26
169	706404914	98	2058412732	2019-10-12	2019-10-21	1625		2	StatTrak	25		23	23	27	31	-79.99949288	40.393387	Brookline	4	32	42003320600	5	32	6	4-25
170	72320601	101	1352281779	2019-06-01	2019-06-11	2238			StatTrak			29		34	37	-80.01752014	40.43229119	Mount Washington	2	19	42003190300	5	19	3	4-1
171	731272720	110	901449477	2019-06-14	2019-06-24	3876			StatTrak	25		27	68	31	34	-80.05544829	40.45370317	Sheraden	2	20	42003202200	5	20	6	1-16
172	735958826	197	2014643189	2019-10-21	2019-10-29	777		2	StatTrak	25		26	58	31	34	-79.98978792	40.38262219	Overbrook	4	32	42003320400	5	32	3	4-23
173	736311994	121	1704999560	2019-07-09	2019-07-26	929		5?	StatTrak	25		22	25	27	31	-79.89519209	40.44343621	Point Breeze	9	14	42003140600	3	14	4	3-14
174	742086325	86	1760887247	2019-04-18	2019-04-26	5663		1	StatTrak	25		24	36	28	31	-79.96410968	40.45818056	Polish Hill	7	6	42003060500	6	6	2	2-6
175	743292552	64	500747930	2019-02-05	2019-02-14				StatTrak							-79.9827432	40.43616593	Bluff	6	1	42003010300	3	1	2	2-1
176	743497140	93	943727004	2019-05-16	2019-05-28			2	StatTrak							-79.99008016	40.38958486	Carrick	4	29	42003290400	3	29	3	4-23
177	772514898	186	999716292	2019-08-30	2019-09-09	4254		4	StatTrak	25		30	83	35	38	-79.93040579	40.4717683	East Liberty	9	11	42003111300	2	11	5	3-8
178	802597781	158														-79.928802	40.46659201	East Liberty	9	11	42003111500	2	11	5	3-8
179	833145460	58	486368234	2019-05-01	2019-05-08	6747			StatTrak	25		27	64	32	36	-79.91261299	40.45995942	Larimer	9	12	42003120800	2	12	5	3-10
180	836677742	91	1836746369	2018-12-04	2018-12-07	927			StatTrak	25		19.3	0	19.5	19.8	-79.9581303	40.45578027	Upper Hill	6	5	42003050600	3	5	2	2-22
181	845176518	191	1670061854	2019-10-14	2019-10-21	1107		11	StatTrak	25		23	33	23	32	-79.89650287	40.44068644	Point Breeze	9	14	42003140600	3	14	4	3-14
182	845300324	63	1060785814	2019-02-05	2019-02-14	2547		2	StatTrak	25		20	12	25	28	-79.98436862	40.4361006	Bluff	6	1	42003010300	3	1	2	2-4
183	856876185	77	675961298	2019-03-22	2019-03-31	23		3	StatTrak	25		14	0	17		-80.01294617	40.45661205	Central Northside	1	22	42003220600	1	22	1	1-21
184	857278686	27	1738651448	2018-11-20	2018-11-29	2475			StatTrak	25	59	24	40	29	32	-79.92530461	40.48692397	Morningside	7	10	42003101400	2	10	5	3-7
185	881392986	107	757964277	2019-06-13	2019-06-20	1231			StatTrak	25		21	10	25		-79.92819115	40.48115579	Morningside	7	10	42003101400	2	10	5	3-7
186	886617272	29	810841420						StatTrak							-80.03777271	40.43797182	Elliott	2	20	42003562600	5	20	6	1-17
187	888525454	201	600630272	2019-11-04	2019-11-13			6	StatTrak	25		21	17	26	29	-79.92717887	40.45150195	Shadyside	8	7	42003070600	2	7	4	3-11
188	906694669	210	1566003055	2019-06-11	2019-06-11		892	Tuesday SPC Video count								-79.96306663	40.42832794	South Side Flats	3	16	42003160900	3	16	3	4-24
189	919072428	136	2104195251	2019-10-08	2019-10-15	7700		6	StatTrak	25		32	81	37	40	-79.91802458	40.46058382	East Liberty	9	12	42003111500	2	12	5	3-10
190	92152273	193	267047974	2019-12-12	2019-12-24	5262		1	StatTrak	25		25	49	30	35	-79.91045413	40.43763509	Squirrel Hill South	5	14	42003980300	3	14	4	2-21
191	938626817	172	1989358980	2019-08-01	2019-08-09			6	StatTrak							-79.99064237	40.3864772	Carrick	4	29	42003290400	3	29	3	4-23
192	945509221	53	1316151566	2019-01-14	2019-01-22	5850		12	StatTrak	25		22	21	27	31	-79.96265897	40.47074741	Central Lawrenceville	7	9	42003090100	2	9	2	3-3
193	947828592	66	1764794992	2019-02-05	2019-02-14				StatTrak							-79.98160863	40.43614347	Bluff	6	1	42003010300	3	1	2	2-1
194	956529597	153	2008214585	2018-06-27					Intersection Study							-79.98406358	40.45235838	Strip District	7	2	42003020300	6	2	2	2-3
195	963269671	142														-79.90429	40.41988	Swisshelm Park	5	14	42003141100	3	14	4	2-19
196	969791742	203	21253671	2019-11-04	2019-11-13	766		1	StatTrak	25		20	11	24	28	-79.93247992	40.45062189	Shadyside	8	7	42003070300	2	7	4	3-22
197	977387533	96	1988657290	2019-05-16	2019-05-28			4	StatTrak	25						-80.00567637	40.38843812	Brookline	4	32	42003320600	5	32	6	4-25
198	979579410	54	732845995	2019-01-14	2019-01-22	573		13	StatTrak	25		18	4	22	25	-79.96410468	40.47152482	Central Lawrenceville	7	9	42003090100	2	9	2	3-3
199	980353019	219	685222674	2019-11-22	2019-12-04	2150		5	StatTrak	25		28	73	34	49	-79.93528241	40.47356601	Stanton Heights	9	10	42003100500	2	10	5	3-7
200	983997146	113	1721221853	2019-06-28	2019-07-05	15000		13	StatTrak	35		29		35	39	-79.94134444	40.45609443	Bloomfield	7	8	42003080400	2	8	5	3-1
201	990099842	88														-79.99912584	40.43778315	Central Business District	6	1	42003020100	6	1	2	1-4
202	992607449	157														-79.9315695	40.45833	East Liberty	7	8	42003111500	2	8	5	3-11
203	995190042	205	112841430	2019-11-14	2019-11-22	1316		5	StatTrak	25		25	50	30	32	-79.92986334	40.43559683	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
204	1390951989	223	34971343	2019-12-30	2020-01-14	450		3	StatTrak	25		20	11	24	28	-80.02596555	40.45295851	Manchester	6	21	42003210700	1	21	1	1-8
205	1787114552	226	898910124	2019-12-30	2020-01-14	877		1	StatTrak	25		23	29	28	32	-80.00902355	40.45646362	Central Northside	1	22	42003220600	1	22	1	1-21
206	2137013195	221	2090543825	2019-12-30	2020-01-14	477		2	StatTrak	25		20	11	24	28	-80.01681888	40.45270551	Allegheny West	1	22	42003562700	1	22	1	1-7
207	45033818	224	632421281	2019-12-30	2020-01-14	384		6	StatTrak	25		21	17	26	32	-80.02443778	40.45322719	Manchester	6	21	42003210700	1	21	1	1-8
208	619209258	225	1008926761	2019-12-30	2020-01-14	1043		5	StatTrak	25		24	34	28	32	-80.02830301	40.47246526	Marshall-Shadeland	1	27	42003271500	1	27	1	1-14
209	631180472	222	289077370	2019-12-30	2020-01-14	1105		4	StatTrak	25		21	21	27	33	-80.02041849	40.45511379	Manchester	6	21	42003210700	1	21	1	1-8
232	276865270	227	2030304291	2020-01-23	2020-01-31	334		6	StatTrak	25		21	20	27	31	-79.9664035	40.46525641	Lower Lawrenceville	7	6	42003060300	2	6	2	3-3
233	1533656734	228	228469783	2020-01-23	2020-01-31	3138		1	StatTrak	25		28	65	33	37	-79.96724479	40.46516856	Lower Lawrenceville	7	6	42003060300	2	6	2	3-3
234	2099401196	229	1991979153	2020-01-23	2020-01-31	5921		3	StatTrak	25		25	44	30	37	-79.97151973	40.46098888	Strip District	7	6	42003020300	6	6	2	3-2
235	1084152705	230	1951529248	2020-01-23	2020-01-31	1036		4	StatTrak	25		20	14	25	29	-79.92426331	40.43582877	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
236	422288517	231	1246031363	2020-01-23	2020-01-31	463		2	StatTrak	25		27	62	32	36	-79.91769609	40.4248555	Squirrel Hill South	5	14	42003141400	3	14	4	2-21
265	2109407346	232	2062678770	2020-01-17	2020-01-24	1328		5	StatTrak	25		28	73	32	35	-80.01226277	40.4851894	Perry North	1	26	42003260700	1	26	1	1-15
298	373163087	233	411197110	2020-02-05	2020-02-13	223		4	StatTrak	25		20	14	25	32	-79.92337727	40.42157076	Squirrel Hill South	5	14	42003141400	3	14	4	2-15
299	1908186545	234	895575392	2020-02-05	2020-02-13	1446		Check Radar	StatTrak	25		28	72	32	35	-80.02501879	40.41892104	Beechview	4	19	42003191600	5	19	6	4-28
300	1153517202	235														-79.97892764	40.4227748	South Side Slopes	3	17	42003170600	3	17	3	4-3
301	1073085531	236	1359349771	2020-12-03	2020-12-11	871		2	StatTrak	20		18	3	21	24	-79.97155373	40.42283983	South Side Slopes	3	16	42003160800	3	16	3	4-22
302	1471518402	237	427738533	2020-02-05	2020-02-13	2224		3	StatTrak	25		28	73	32	35	-79.9773935	40.41781495	Arlington	3	16	42003160800	3	16	3	4-22
303	1425434092	238	821450226	2020-02-05	2020-02-13	2347		1	StatTrak	25		25	50	30	34	-79.97419563	40.41728605	Arlington	3	16	42003561600	3	16	3	4-22
304	695774116	239	1866996667	2020-02-05	2020-02-13	868		2	StatTrak	25		21	13	25	29	-79.99004485	40.38951511	Carrick	4	29	42003290400	3	29	3	4-23
331	757372218	240	86803959	2020-02-14	2020-02-22	5357		5	StatTrak	25		29	78	35	39	-79.89986633	40.45821247	Homewood North	9	13	42003130300	2	13	5	3-17
364	1674924052	241	661669417	2020-02-14	2020-02-22	6446		6	StatTrak	25		31	87	36	40	-79.90015639	40.45728166	Homewood South	9	13	42003130300	2	13	5	3-17
365	1968083477	242	1451739989	2020-02-14	2020-02-22	3819		1	StatTrak	25		24	37	29	32	-79.90118099	40.45542852	Homewood South	9	13	42003130300	2	13	5	3-17
366	1206641937	243	1116951503	2020-02-14	2020-02-22	2253		3	StatTrak	25		29	75	34	38	-79.90102988	40.45638085	Homewood South	9	13	42003130300	2	13	5	3-17
367	1624270451	244	1558284736	2020-02-14	2020-02-22	2651		4	StatTrak	25		30	81	36	39	-79.89907723	40.45228261	Point Breeze North	9	14	42003140500	2	14	4	3-14
368	1788338498	245	1524542857	2020-02-14	2020-02-22	7277		2	StatTrak	25		32	95	37	41	-79.89358943	40.44935164	Point Breeze North	9	14	42003140500	2	14	4	3-14
397	412595515	246	168158378	2020-03-03	2020-03-11			1	StatTrak	25						-79.91486777	40.45162043	Point Breeze	8	14	42003140400	3	14	4	2-17
398	188614060	247	1949557608	2020-03-03	2020-03-11			2	StatTrak	25						-79.91212119	40.4493181	Point Breeze	8	14	42003140400	3	14	4	2-17
399	149692142	248	485207398	2020-03-03	2020-03-11			4	StatTrak	25						-79.90885425	40.44824039	Point Breeze	8	14	42003140600	3	14	4	3-14
400	1831921949	249	503027751	2020-03-03	2020-03-11	1671		6	StatTrak	25		29		35		-79.90204144	40.44799545	Point Breeze	9	14	42003140600	3	14	4	3-14
401	1071105336	250	1587325508	2020-03-04	2020-03-12			5	StatTrak							-79.97607339	40.41703426	Arlington	3	16	42003561600	3	16	3	4-22
402	211740980	251	1468820472	2020-03-04	2020-03-12			3	StatTrak							-79.97599721	40.417567	South Side Slopes	3	16	42003160800	3	16	3	4-22
430	1569746323	252	2083972553	2020-03-19	2020-03-27			6	StatTrak							-79.94855466	40.46222049	Bloomfield	7	8	42003080900	2	8	5	3-6
431	181242809	253	1002358491	2020-03-19	2020-03-27			2	StatTrak							-79.94829475	40.46510432	Bloomfield	7	9	42003080900	2	9	5	3-6
432	1191932721	254	876365385	2020-03-19	2020-03-27			5								-79.97917022	40.42216775	South Side Slopes	3	17	42003170600	3	17	3	4-3
433	1613398642	255	97073868	2020-03-19	2020-03-27			3	StatTrak							-80.00249215	40.42253654	Mount Washington	3	18	42003180700	5	18	3	4-5
434	1120210172	256	1974939792	2020-03-19	2020-03-27			1	StatTrak							-80.02134971	40.45876079	California-Kirkbride	6	21	42003250700	1	21	1	1-9
435	1498975372	257	1295352317	2020-03-19	2020-03-27			4	StatTrak							-80.01060446	40.47058702	Perry South	6	26	42003261400	1	26	1	1-23
463	1789153149	258	1003248000	2020-08-21	2020-08-31	3702		#2	StatTrak	25		33	97	38	41	-79.9193171	40.4210525	Squirrel Hill South	5	14	42003141400	3	14	4	2-15
464	1476877637	259	264167988	2020-08-21	2020-08-28	175		#1	StatTrak			23		29	32	-79.91485617	40.43550166	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
465	793543075	260	1597773420	2020-09-02	2020-09-10	346		#1	StatTrak			21		26	29	-79.92116942	40.47357505	Highland Park	7	11	42003110200	2	11	5	3-9
466	1599865645	261	830991831	2020-09-02	2020-09-10	393		#2	StatTrak			21		26	29	-79.92007374	40.47537361	Highland Park	7	11	42003110200	2	11	5	3-9
467	799096979	262	1169829155	2020-09-04	2020-09-11	79		#5	StatTrak	25		15		18	21	-79.94695283	40.46512943	Bloomfield	7	8	42003080900	2	8	5	3-6
468	450517570	263	922974279	2020-08-28	2020-09-08	493		#4	StatTrak			23		27	29	-80.00827709	40.38761838	Brookline	4	32	42003191800	5	32	6	4-25
469	111651765	264	2131302388	2020-09-16	2020-09-24	1713		#1	StatTrak			25		31	34	-79.94659232	40.46458393	Bloomfield	7	8	42003080900	2	8	5	3-6
470	950865722	265	1160607646	2020-09-16	2020-09-24	77		#2	StatTrak			16		21	25	-79.94889466	40.46544568	Bloomfield	7	9	42003090300	2	9	5	3-6
471	1322907977	266	2037369760	2020-09-29	2020-10-07	450		#4	StatTrak	25	66	32	84	38	43	-79.96181268	40.45666994	Polish Hill	7	6	42003060500	3	6	2	2-24
472	1148857711	267	866628456	2020-09-29	2020-10-07	403		#5	StatTrak	25	53	27	58	33	36	-79.95823663	40.45833334	Upper Hill	6	5	42003060500	3	5	2	2-24
473	1747903211	268	1990052827	2020-09-29	2020-10-08	434		#3	StatTrak			21		26	29	-79.98463267	40.39480996	Carrick	4	29	42003290200	3	29	3	4-12
474	1271744444	269	903509181	2020-09-24	2020-10-02	58		#6	StatTrak			17		22	27	-79.92284404	40.46883801	East Liberty	9	11	42003111300	2	11	5	3-8
475	129759562	270	1173026235	2020-07-15	2020-07-23	630			StatTrak			20		23	25	-79.91890991	40.47721007	Highland Park	7	11	42003110200	2	11	5	3-9
476	428626891	271	599138140	2020-07-15	2020-07-23	765			StatTrak			21		25	30	-79.91879726	40.4771611	Highland Park	7	11	42003110200	2	11	5	3-9
477	49936170	272	217811209	2020-07-06	2020-07-15	447			StatTrak			24		29	33	-79.98265596	40.38844253	Carrick	4	29	42003290400	3	29	3	4-15
478	356579717	273	371928739	2020-07-15	2020-07-23	240			StatTrak			19		24	27	-79.98024734	40.39179289	Carrick	4	29	42003290400	3	29	3	4-15
479	1197544687	274	876907650	2020-07-06	2020-07-14	421			StatTrak			21		26	30	-79.9217699	40.47252006	Highland Park	7	11	42003110200	2	11	5	3-9
480	756230800	275	1042493214	2020-07-15	2020-07-23	1577			StatTrak			23		29	33	-80.00243993	40.42175003	Beltzhoover	3	18	42003562400	5	18	3	4-5
481	550216999	276	860508874	2020-07-06	2020-07-15	79			StatTrak			20		25	29	-79.92197383	40.47025672	Highland Park	7	11	42003110200	2	11	5	3-9
482	1485225020	277	932056673	2020-07-06	2020-07-15	410			StatTrak			22		27	31	-79.92325325	40.47211761	Highland Park	7	11	42003110200	2	11	5	3-9
483	518712801	278	1302109006	2020-07-27	2020-08-04	338			StatTrak			17		21	25	-79.94591523	40.46490639	Bloomfield	7	8	42003080900	2	8	5	3-6
484	255361105	279	39803703	2020-07-27	2020-08-04	439			StatTrak			20		25	31	-79.93416179	40.46259636	Friendship	9	8	42003080700	2	8	5	3-23
485	967589290	280	2015844570	2020-07-27	2020-08-04	377			StatTrak			19		24	28.2	-79.93953694	40.46372282	Bloomfield	7	8	42003080900	2	8	5	3-23
486	1488834790	281	1844845892	2020-07-27	2020-08-04	305			StatTrak			24		29	32	-79.90525948	40.44609087	Point Breeze	9	14	42003140600	3	14	4	3-14
487	995942627	282	1710930717	2020-07-27	2020-08-04	4732			StatTrak			32		37	40	-79.91870003	40.46439187	East Liberty	9	11	42003111500	2	11	5	3-10
488	54863761	283	125626905	2020-07-27	2020-08-04	5804			StatTrak			33		38	41	-79.91824673	40.46446534	Larimer	9	12	42003120800	2	12	5	3-10
489	1772898101	284	1809645121	2020-08-06	2020-08-14	3117			StatTrak			35		41	45	-80.03547017	40.46880982	Marshall-Shadeland	1	27	42003271500	1	27	1	1-14
490	768305302	285	1819743631	2020-08-06	2020-08-14	2679			StatTrak			35		41	45	-80.03866736	40.4741476	Brighton Heights	1	27	42003270300	1	27	1	1-14
491	448047523	286	1528757788	2020-08-07	2020-08-14	5259			StatTrak			37		43	48	-80.02850145	40.46115005	California-Kirkbride	6	21	42003210700	1	21	1	1-9
492	1142659093	287	1490013197	2020-08-06	2020-08-06	8112			StatTrak			30		35	39	-79.95666167	40.44954575	North Oakland	8	4	42003562000	3	4	4	2-23
493	1131354794	288	1831132941	2020-08-07	2020-08-14	579			StatTrak			28		33	37	-80.00918142	40.40218727	Brookline	4	19	42003191700	5	19	6	4-26
494	1507531891	289	1274441265	2020-08-07	2020-08-14	8429			StatTrak			35		41	45	-80.02766265	40.46441817	Marshall-Shadeland	1	27	42003270400	1	27	1	1-9
495	1193077063	290	185718524	2020-08-28	2020-09-08	567			StatTrak			23		27	30	-80.01293626	40.3897406	Brookline	4	19	42003191800	5	19	6	4-26
496	1290494208	291	336694800	2020-08-28	2020-09-08	277		#6	StatTrak			26		31	34	-80.02245273	40.38884988	Brookline	4	19	42003191800	5	19	6	4-26
497	1210892177	292	1907761525	2020-09-15	2020-09-23	2770			StatTrak			38		43	46	-80.01360379	40.48786252	Perry North	1	26	42003260700	1	26	1	1-15
498	1031619422	293	2039426244	2020-09-15	2020-09-23	177			StatTrak			21		28	33	-80.01430335	40.48696945	Perry North	1	26	42003260700	1	26	1	1-15
499	785478146	294	803211323	2020-09-15	2020-09-23	1226			StatTrak			29		34	37	-79.98822297	40.473502	Spring Garden	1	26	42003241200	1	26	1	1-11
500	1447326289	295	111179609	2020-09-15	2020-09-23	945			StatTrak			23		29	32	-80.027661	40.47003801	Marshall-Shadeland	1	27	42003271500	1	27	1	1-14
501	1238476148	296	1524260833	2020-02-14	2020-02-22	6446			StatTrak			31		36	40	-79.89349606	40.45567614	Homewood South	9	13	42003130300	2	13	5	3-17
529	427254216	297	1574024593	2020-02-14	2020-02-22	5357			StatTrak			29		35	39	-79.89286851	40.45656534	Homewood South	9	13	42003130300	2	13	5	3-17
530	1624280389	298	1681154440	2020-02-14	2020-02-22	3819			StatTrak			24		29	32	-79.89475251	40.45396124	Homewood South	9	13	42003130300	2	13	5	3-17
531	318972132	299	1479047291	2020-02-14	2020-02-22	2253			StatTrak			29		34	38	-79.89380242	40.45474616	Homewood South	9	13	42003130300	2	13	5	3-17
532	1282562954	300	741491457	2020-02-14	2020-02-22	7277			StatTrak			32		37	41	-79.89111527	40.45286614	Homewood South	9	13	42003130400	2	13	5	3-17
533	1102956184	301	1734336793	2020-02-14	2020-02-22	2651			StatTrak			30		36	39	-79.89774569	40.45444177	Homewood South	9	13	42003130300	2	13	5	3-17
534	806927494	302	968047295	2019-11-14	2019-12-02	317			StatTrak			22		27	30	-79.91792948	40.47080132	Highland Park	7	11	42003110600	2	11	5	3-9
535	1215979940	303	310322564	2019-11-22	2019-12-02	4016			StatTrak			33		37	40	-79.93759535	40.48126172	Stanton Heights	9	10	42003100500	2	10	5	3-7
536	699716104	304	1070642071			10001			StatTrak			27		32	35	-79.9212985	40.44382105	Squirrel Hill North	8	14	42003140300	3	14	4	2-18
537	72946739	305	2017245451	2020-10-06				6	StatTrak							-79.95927762	40.46754854	Central Lawrenceville	7	9	42003090200	2	9	2	3-3
538	749666891	306	734320697	2020-09-29	2020-10-08	7119		2	StatTrak			29		34	37	-79.99445701	40.41411303	Knoxville	3	30	42003300100	5	30	3	4-7
539	33843989	307	1371902444	2020-09-29	2020-10-08	263		1	StatTrak			23		28	31	-80.04074993	40.44259004	Elliott	2	20	42003562600	5	20	6	1-17
562	723046862	308	866451140	2020-10-14	2020-10-22	799		3	StatTrak			20		28	32	-79.92441255	40.43681766	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
595	1747387604	309	1970095666	2020-10-08	2020-10-17	1061		5	StatTrak	25	61	25	48	30	33	-80.02849077	40.47274658	Marshall-Shadeland	1	27	42003271500	1	27	1	1-14
596	1378444744	310	1663677069	2020-10-06	2020-10-14	900		6	StatTrak	25	49	22	27	28	32	-79.95850965	40.46683292	Central Lawrenceville	7	9	42003090200	2	9	2	3-3
628	410602600	311	1431627012	2020-10-27	2020-11-04	608		2	StatTrak	25		21	9	24	27	-80.02464896	40.45228501	Manchester	6	21	42003210700	1	21	1	1-8
629	401135888	312	1645819786	2020-10-27	2020-11-04	3190		3	StatTrak	25		27	59	32	36	-80.01674181	40.45370554	Central Northside	1	22	42003220600	1	22	1	1-7
630	763158204	313	283499688	2020-10-27	2020-11-04	3913		5	StatTrak	25	93	33	95	37	40	-79.99323602	40.40280999	Carrick	4	29	42003290100	3	29	3	4-23
631	1177739956	314	244677539	2020-10-27	2020-11-04	525		6	StatTrak	25	47	23	31	29	33	-80.02234	40.49200899	Perry North	1	26	42003260200	1	26	1	1-15
632	2034185540	316	190985760	2020-10-17	2020-10-27	6291		4	StatTrak	25	70	30	81	35	38	-79.9795506	40.42154758	South Side Slopes	3	17	42003170600	3	17	3	4-3
661	1105202061	317	873441779	2020-11-04	2020-11-13	560		1	StatTrak			17		20	24	-80.02719102	40.45764707	Manchester	6	21	42003210700	1	21	1	1-8
662	1195234534	318	1130428778	2020-11-05	2020-11-13	4182		3	StatTrak			32		36	39	-80.01561595	40.47287536	Perry South	6	26	42003261500	1	26	1	1-23
663	767387264	319	2134404796	2020-11-05	2020-11-13	3824		2	StatTrak			29		35	39	-80.01958026	40.45922375	California-Kirkbride	6	25	42003250700	1	25	1	1-9
694	2118942201	320	571016153	2020-11-05	2020-11-13	3091		6	StatTrak	25	58	28	70	32	35	-79.94670324	40.45108406	Shadyside	8	7	42003070900	2	7	4	2-9
695	2068404339	321	535664332	2020-11-05	2020-11-13	10113		5	StatTrak	25	64	29	79	33	36	-79.93737586	40.4539823	Shadyside	8	7	42003070900	2	7	4	3-22
696	588990751	322	1277360834	2020-11-05	2020-11-13	2265		4	StatTrak	25	59	24	40	29	34	-79.91167091	40.46279869	Larimer	9	12	42003120400	2	12	5	3-12
697	1703344824	323	61593219	2020-11-20	2020-11-30	577		1	StatTrak	25		26	54	32	35	-79.93077047	40.42171014	Greenfield	5	15	42003151700	3	15	4	2-12
698	49750232	324	887132706	2020-11-20	2020-11-30			2	StatTrak	25		26	57	31	34	-79.93428685	40.41961507	Hazelwood	5	15	42003562900	3	15	4	2-12
699	230934835	325	40065525	2020-11-20	2020-11-30	2183		3	StatTrak	25		32	93	37	40	-79.92471136	40.41471407	Hazelwood	5	15	42003562300	3	15	4	2-12
727	938946316	326	224998963	2020-11-19	2020-12-02	63		4	StatTrak	25		21	22	27	31	-79.99731197	40.46439502	Spring Hill-City View	1	24	42003262000	1	24	1	1-24
728	713909736	327	766860178	2020-11-19	2020-12-02	419		5	StatTrak	25		25	47	30	34	-80.00928535	40.46520311	Fineview	6	26	42003261400	1	26	1	1-10
729	70878715	328	248864678	2020-11-19	2020-12-02	2697		6	StatTrak			29	82	34	37	-80.03755298	40.48450199	Brighton Heights	1	27	42003270100	1	27	1	1-14
730	614417587	329	1406278027	2020-12-03	2020-12-11	115		1	StatTrak	25		18	3	22	24	-79.98109634	40.4310019	South Side Flats	3	17	42003170200	3	17	3	4-24
731	2065174971	330	2006513535	2020-12-04	2020-12-14	6641		3	StatTrak	25		36	97	42	47	-80.02850078	40.45468025	Manchester	6	21	42003210700	1	21	1	1-8
732	1004625028	331	640242903	2020-12-04	2020-12-14	693		4	StatTrak	25		22	15	26	28	-80.01142902	40.48533317	Perry North	1	26	42003260700	1	26	1	1-15
733	667038165	332	1235035075	2020-12-04	2020-12-14	2718		5	StatTrak	25		33	94	38	42	-80.01248003	40.488466	Perry North	1	26	42003260200	1	26	1	1-15
734	786591987	333	2138413979	2020-12-04	2020-12-14	6191		6	StatTrak	35		43	91	50	55	-80.01126197	40.49159501	Perry North	1	26	42003260200	1	26	1	1-15
760	592949364	334	1764428554	2020-12-15	2020-12-23	195		2	StatTrak	25	51	20	19	27	33	-79.89405799	40.46385703	Lincoln-Lemington-Belmar	9	12	42003561900	2	12	5	3-18
761	1469659733	335	1095139650	2020-12-15	2020-12-23	2737		1	StatTrak	25	68	31	82	35	38	-79.91322128	40.4269095	Squirrel Hill South	5	14	42003141400	3	14	4	2-20
762	2147460777	336	67646009	2020-12-16	2020-12-23	666		4	StatTrak	25	44	24	39	29	31	-79.92099399	40.38795361	New Homestead	5	31	42003310300	3	31	4	4-20
763	1844854594	337	37034468	2020-12-15	2020-12-23	126		3	StatTrak	25	46	20	14	25	30	-79.915459	40.37251402	Lincoln Place	5	31	42003310200	3	31	4	4-20
764	621691967	338	1599660994	2020-12-15	2020-12-23	6417		6	StatTrak	25	71	26	50	30	33	-79.98746298	40.38457499	Carrick	4	29	42003290400	3	29	3	4-23
793	1564003903	339	645659849	2021-01-08	2021-01-16	816		4	StatTrak	25	64	23	28	28	31	-80.02622501	40.47477001	Marshall-Shadeland	1	27	42003271500	1	27	1	1-14
794	179318306	340	1151539482	2021-01-08	2021-01-16	109		5	StatTrak	25	46	23	29	29	32	-80.02653615	40.47419055	Marshall-Shadeland	1	27	42003271500	1	27	1	1-14
795	425649408	341	6129295	2021-01-08	2021-01-16	5843		6	StatTrak	25	79	28	73	33	38	-80.01639999	40.45874402	California-Kirkbride	6	25	42003250700	1	25	1	1-21
826	1817567735	342	87863528	2021-01-08	2021-01-20	5218		1	StatTrak	25		26	54	31	34	-79.93615283	40.45157485	Shadyside	8	7	42003070300	2	7	4	3-22
827	1923682482	343	1076917557	2021-01-08	2021-01-20	9022		2	StatTrak	25		30	85	34	37	-79.93741279	40.45406691	Shadyside	8	7	42003070900	2	7	4	3-22
828	779473088	344	506869136	2021-01-08	2021-01-16			3	StatTrak							-79.92921649	40.46940851	East Liberty	9	11	42003111300	2	11	5	3-4
859	606875725	345	635306010	2021-01-21				1	StatTrak	25						-79.95312895	40.43896209	Central Oakland	3	4	42003040500	3	4	4	2-11
860	1111892992	346	2049624150	2021-01-21	2021-01-29	7148		2	StatTrak	25		23	30	28	31	-79.95567906	40.43647049	Central Oakland	3	4	42003040500	3	4	4	2-11
861	1192944420	347	1098903159	2021-01-24	2021-02-01	4044		4	StatTrak	25	87	30	82	34	38	-79.98028983	40.41784591	South Side Slopes	3	17	42003170600	3	17	3	4-22
862	308210711	348	1122068978	2021-01-24	2021-02-01	2065		5	StatTrak	25	66	25	49	32	36	-79.97241017	40.417547	South Side Slopes	3	16	42003160800	3	16	3	4-22
863	1934819285	349	1424302140	2021-01-24	2021-02-01	3116		6	StatTrak	25	67	31	84	36	40	-79.96401997	40.42017301	South Side Slopes	3	16	42003160800	3	16	3	4-22
892	853507387	350	1135201370	2021-01-22	2021-01-30	2171		3	StatTrak	30		32		38	43	-80.0404424	40.47809797	Brighton Heights	1	27	42003270300	1	27	1	1-14
893	1864843360	351	1306423661	2021-02-02	2021-02-12	4821		2	StatTrak				75	33	36	-79.919198	40.43085803	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
894	1304722150	352	921103195	2021-02-02	2021-02-12	4042		3	StatTrak	25		28	74	33	36	-79.92331787	40.42632537	Squirrel Hill South	5	14	42003141400	3	14	4	2-21
895	56799300	353	268781922	2021-02-02	2021-02-12	5649		1	StatTrak			28	69	32	35	-79.91879315	40.43409469	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
896	702788420	354	342001643	2021-02-04	2021-02-12	4120		4	StatTrak	25		26	56	31	35	-79.92251329	40.45732249	Shadyside	8	7	42003070800	2	7	4	3-11
897	1042370979	355	310905035	2021-02-04	2021-02-12	7117		5	StatTrak	25		32	89	37	40	-79.92106574	40.44621903	Point Breeze	8	14	42003140400	3	14	4	2-17
898	721409644	356	1474777154	2021-02-04	2021-02-12	7802		6	StatTrak	25		29	76	33	37	-79.91975782	40.44084469	Squirrel Hill North	8	14	42003140300	3	14	4	2-18
925	406919888	357														-80.00153	40.41995928	Beltzhoover	3	18	42003562400	5	18	3	4-16
926	836551162	358														-80.06155631	40.44737238			28	42003464300	5	28		1-16
927	655822402	359														-80.06387162	40.44929333	Sheraden	2	20	42003202200	5	20	6	1-16
928	904759944	360														-80.06661589	40.42370894	Oakwood	2	28	42003562800	5	28	6	1-19
929	816314407	361														-80.05216029	40.43617598	Westwood	2	28	42003563100	5	28	6	1-18
958	929455212	362														-80.035543	40.40833998	Banksville	2	20	42003202300	5	20	6	4-9
959	1199749411	363														-80.01747791	40.48864348	Perry North	1	26	42003260200	1	26	1	1-15
960	6941614	364														-80.01614208	40.48627122	Perry North	1	26	42003260200	1	26	1	1-15
961	641233999	365														-80.01308076	40.48036043	Perry North	1	26	42003980400	1	26	1	1-15
962	1720372548	366														-80.01214207	40.47732154	Perry North	1	26	42003260700	1	26	1	1-23
963	927954449	367														-80.00936934	40.47165704	Perry South	6	26	42003261500	1	26	1	1-23
964	1666177048	368														-80.0131246	40.43422538	Mount Washington	2	19	42003190300	5	19	3	4-1
991	1224179419	369	1109192446	2021-03-12	2021-03-22	793		1	StatTrak	25	56	25	49	31	34	-80.01839397	40.46885302	Perry South	6	26	42003261500	1	26	1	1-12
992	1525753837	370	1214724225	2021-03-12	2021-03-22	157		2	StatTrak	25	31	18	2	22	24	-80.0107899	40.46497006	Perry South	6	25	42003261400	1	25	1	1-10
1024	940895432	371														-80.01325401	40.43347101	Mount Washington	2	19	42003190300	5	19	3	4-1
1025	324950885	372														-80.01346591	40.43239304	Mount Washington	2	19	42003190300	5	19	3	4-1
1026	1208878284	373														-80.0136188	40.43101085	Mount Washington	2	19	42003190300	5	19	3	4-1
1057	1335069399	374	540091931	2021-03-24	2021-04-01	2320		1	StatTrak		56	26	58	30	33	-79.92633385	40.4873215	Morningside	7	10	42003101400	2	10	5	3-7
1058	647944396	375	1963389764	2021-03-24	2021-04-01	462		2	StatTrak		42	21	12	25	28	-79.92517128	40.48584856	Morningside	7	10	42003101400	2	10	5	3-7
1059	682438710	376	1777671555	2021-03-24	2021-04-01	2170		3	StatTrak		66	25	46	30	33	-79.92517061	40.48705928	Morningside	7	10	42003101400	2	10	5	3-7
1060	2070723283	377	1671464686	2021-03-24	2021-04-01	3885		4	StatTrak		65	32	92	37	40	-79.923427	40.48774467	Morningside	7	10	42003101400	2	10	5	3-7
1061	490978388	378	149938512	2021-03-24	2021-04-01	396		5	StatTrak	15	48	25	50	30	33	-79.93950986	40.40419507	Hazelwood	5	15	42003562300	3	15	4	2-13
1062	729640239	379														-79.93891542	40.40403823	Hazelwood	5	15	42003562300	3	15	4	2-13
1090	552643712	380	122880372	2021-04-05	2021-04-14	1352		1	StatTrak		48	26	55	31	34	-80.05547894	40.45365757	Sheraden	2	20	42003202200	5	20	6	1-16
1091	7634720	381	1512624332	2021-04-05	2021-04-14	2571		2	StatTrak		51	28	78	32	34	-80.06976556	40.4584772	Chartiers City	2	20	42003563000	5	20	6	1-16
1092	1759296050	382	461558164	2021-04-05	2021-04-14	1368		3	StatTrak		67	26	51	30	34	-80.02410933	40.45839718	Manchester	6	21	42003210700	1	21	1	1-8
1093	1590127600	383	924914303	2021-04-05	2021-04-14	222		4	StatTrak	25	59	20	18	27	30	-80.02647261	40.45688048	Manchester	6	21	42003210700	1	21	1	1-8
1094	1873460113	384	77483144	2021-04-05	2021-04-14	550		5	StatTrak	25	49	24	39	29	32	-80.02375201	40.4545818	Manchester	6	21	42003210700	1	21	1	1-8
1095	730252976	385														-80.01738981	40.45564717	Central Northside	1	22	42003220600	1	22	1	1-9
1123	629581327	386	1850837930	2021-04-15	2021-04-23	4278		1	StatTrak	25	58	30	87	35	38	-79.92128895	40.43510017	Squirrel Hill South	5	14	42003140800	3	14	4	2-21
1124	572121094	387	111314139	2021-04-15	2021-04-23	3891		2	StatTrak	25	56	24	38	29	32	-79.92767797	40.43334851	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
1125	1131825798	388	1554633502	2021-04-15	2021-04-23	1470		3	StatTrak	25	52	26	53	30	33	-79.92737622	40.43056167	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
1126	1607615396	389	842389384	2021-04-15	2021-04-23	5422		4	StatTrak	25	68	34	97	39	42	-79.93164496	40.4335445	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
1127	1972575753	390	2036218181	2021-04-15	2021-04-23	709		5	StatTrak	25	67	25	46	29	32	-79.92879377	40.43554114	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
1156	710660947	391	1065696916	2021-04-28	2021-05-06	3834		1	StatTrak	25	75	25	47	30	33	-79.92831365	40.45769213	Shadyside	8	7	42003070500	2	7	4	3-11
1157	869990233	392	116450044	2021-04-28	2021-05-06	7572		2	StatTrak	25	81	23	24	27	29	-79.93530005	40.4533723	Shadyside	8	7	42003070300	2	7	4	3-22
1158	566900803	393	1170781399	2021-04-28	2021-05-06	3738		3	StatTrak	25	64	25	45	29	32	-79.94394699	40.45062781	Shadyside	8	7	42003070900	2	7	4	2-9
1189	578171830	394	1979412300	2021-04-28	2021-05-06	8025		4	StatTrak	25	62	26	59	31	35	-80.02505029	40.39493174	Brookline	4	19	42003191800	5	19	6	4-26
1190	1417086478	395	290367959	2021-04-28	2021-05-06	8498		5	StatTrak	25	74	30	89	34	37	-80.02114767	40.39911595	Brookline	4	19	42003191900	5	19	6	4-26
1191	1513188293	396	1486881228	2021-04-28	2021-05-06	7903		6	StatTrak	25	103	35	96	40	43	-80.01517188	40.40466808	Brookline	4	19	42003191700	5	19	6	4-26
1222	1807120511	397	459231747	2021-05-11	2021-05-19	2421		2	StatTrak	25	74	27	57	33	37	-79.89826109	40.4533888	Homewood South	9	13	42003130300	2	13	5	3-17
1223	351053814	398	87221602	2021-05-11	2021-05-19	1670		3	StatTrak	25	57	21	18	26	30	-79.89498603	40.46102413	Homewood North	9	13	42003130200	2	13	5	3-17
1224	875500968	399	698383717	2021-05-11	2021-05-19	4184		4	StatTrak	25	84	34	96	38		-80.02979687	40.49442341				42003429700				
1225	603379701	400	1486294292	2021-05-11	2021-05-19	937		5	StatTrak	25	57	26	55	31		-80.00480112	40.48540553	Summer Hill	1	26	42003261200	1	26	1	1-15
1226	504395374	401	1119323351	2021-05-11	2021-05-19	2523		6	StatTrak	25	25	24	39	29		-79.99150951	40.46208233	Spring Hill-City View	1	24	42003262000	1	24	1	1-24
1255	1537413465	402	1787290229	2021-05-25				1	StatTrak	25						-79.89581215	40.45843232	Homewood North	9	13	42003130200	2	13	5	3-17
1288	1167043215	403	1466393598	2021-05-21				6	StatTrak	25						-79.89716181	40.47021554	Lincoln-Lemington-Belmar	9	12	42003561900	2	12	5	3-18
1289	1085928260	404	946266285	2021-05-21				4	StatTrak	25						-79.87166582	40.45470922	East Hills	9	13	42003130600	2	13	5	3-19
1290	1689187063	405	1747490015	2021-05-21				3	StatTrak	25						-79.86931821	40.45070309	East Hills	9	13	42003130600	2	13	5	3-19
1291	1388421819	406	1886843630	2021-05-21				1	StatTrak	25						-79.99063981	40.38631266	Carrick	4	29	42003290400	3	29	3	4-23
1292	1427370645	407	2052848618	2021-05-21				5	StatTrak	25						-79.89379431	40.46115952	Homewood North	9	13	42003130100	2	13	5	3-17
1321	434083600	408	1452803107	2021-06-03	2021-06-11	2465		6	StatTrak	25	67	27	61	33	38	-79.86962776	40.45418533	East Hills	9	13	42003130600	2	13	5	3-19
1322	758271465	409	175878135	2021-06-03	2021-06-11	654		5	StatTrak	25	58	23	31	28	31.65	-79.9083819	40.46278312	Larimer	9	12	42003120400	2	12	5	3-12
1323	564617016	410	1853670524	2021-06-03		2807		4	StatTrak	25	76	28	69	33	36	-79.9129657	40.46380122	Larimer	9	12	42003120800	2	12	5	3-12
1324	1821807873	411	71269012	2021-06-03	2021-06-11	623		3	StatTrak	25	39	16	3	20	24	-79.92919551	40.45265715	Shadyside	8	7	42003070500	2	7	4	3-11
1325	284761113	412	1486633590	2021-06-03	2021-06-11	2585		2	StatTrak	25	57	23	28	27	30	-79.96551908	40.44081815	West Oakland	6	4	42003040200	3	4	4	2-10
1326	95491588	413	1333913708	2021-06-03	2021-06-11	3621		1	StatTrak	25	63	28	70	32	36	-79.99759863	40.42470702	Mount Washington	3	18	42003180700	5	18	3	4-5
1354	1925644354	414	73977255	2021-06-29	2021-07-07			6	StatTrak	25	48	28	73	33	37	-79.87988603	40.45069498	East Hills	9	13	42003130600	2	13	5	3-17
1355	442888756	415	1668923437	2021-06-15	2021-06-23	1817		6	StatTrak	25	59	23	25	27	30	-79.9804392	40.42437344	South Side Slopes	3	17	42003170600	3	17	3	4-3
1356	1051538241	416	22306407	2021-06-28	2021-07-07			2	StatTrak	25	42	21	23	27	31	-79.93547054	40.46395905	Bloomfield	9	8	42003080700	2	8	5	3-23
1357	485111600	417	623157968	2021-06-28	2021-07-07			1	StatTrak	25						-80.01344177	40.4325183	Mount Washington	2	19	42003190300	5	19	3	4-1
1358	1473613946	418	304282221	2021-06-28	2021-07-07			3	StatTrak	25	56	23	33	29	34	-79.89124594	40.46468598	Lincoln-Lemington-Belmar	9	12	42003561900	2	12	5	3-18
1359	1378242439	419	530061422	2021-06-28	2021-07-07			4	StatTrak	25	63	29	72	36	40	-79.87917919	40.45205265	East Hills	9	13	42003130600	2	13	5	3-17
1360	293756163	420	1730012022	2021-06-28	2021-07-07			5	StatTrak	25	36	20	6	23	26	-79.88106721	40.45120513	East Hills	9	13	42003130600	2	13	5	3-17
1361	5216219	421	1382452398	2021-06-29	2021-07-07	5605		7	StatTrak	25	75	29	77	33	36	-79.92671506	40.42595842	Greenfield	5	15	42003151700	3	15	4	2-15
1362	1376631013	422	651815798	2021-06-29	2021-07-07			5	StatTrak	25	47	23	24	27	29	-79.92642663	40.43678189	Squirrel Hill South	5	14	42003141300	3	14	4	2-21
1363	1671608614	423	1290715814	2021-06-15	2021-06-23	809		1	StatTrak	25	38	17	2	21	23	-80.01019315	40.45780138	Central Northside	6	25	42003250300	1	25	1	1-21
1364	1101807875	424	1231032838	2021-06-15	2021-06-23			1	StatTrak	25	51	26	53	29	32	-80.00797228	40.45910547	Central Northside	6	25	42003250900	1	25	1	1-10
1365	1214039853	425	1941456903	2021-06-15	2021-06-23			3	StatTrak	25	72	29	79	33	37	-79.92075284	40.47040848	Highland Park	7	11	42003110200	2	11	5	3-9
1366	257117947	426	129119643	2021-06-15	2021-06-23			5	StatTrak	15	62	21	13	25	28	-79.89558291	40.45338614	Homewood South	9	13	42003130300	2	13	5	3-17
1367	464876196	427	325746791	2021-06-15	2021-06-23			4	StatTrak	15	57	21	17	26	29	-79.8940004	40.45287589	Homewood South	9	13	42003130300	2	13	5	3-17
1387	618384995	428														-80.01334332	40.43317131	Mount Washington	2	19	42003190300	5	19	3	4-1
1388	1140544457	429	1023986428	2021-07-09	2021-07-19	910		2	StatTrak	25	51	23	29	28	30	-79.94042785	40.46103362	Bloomfield	7	8	42003080600	2	8	5	3-23
1389	742131013	430	1933384987	2021-07-09	2021-07-19	271		3	StatTrak	25	39	20	10	25	27	-79.95300464	40.46517311	Bloomfield	7	9	42003090300	2	9	5	3-6
1390	368912259	431	1965316306	2021-07-09	2021-07-19	3454		4	StatTrak	25	51	23	31	28	32	-79.95589338	40.46623117	Central Lawrenceville	7	9	42003090200	2	9	2	3-3
1391	1374032413	432														-79.98468254	40.46164703	Troy Hill	1	24	42003240600	1	24	1	1-2
1392	112611055	433														-79.99026664	40.46542949	Spring Hill-City View	1	24	42003262000	1	24	1	1-11
1393	1132416719	434														-80.00907404	40.49719598	Summer Hill	1	26	42003261200	1	26	1	1-15
1394	1037219067	435														-80.03777058	40.48255664	Brighton Heights	1	27	42003270100	1	27	1	1-14
1420	1329604877	436	1001258944	2021-07-21				2	StatTrak	25						-79.96037954	40.4550574	Upper Hill	6	5	42003050600	3	5	2	2-22
1421	704127706	437	1832664152	2021-07-21				3	StatTrak	25						-79.96677427	40.45014681	Middle Hill	6	5	42003050100	3	5	2	2-5
1422	1814538648	438	1741898762	2021-07-21				4	StatTrak	25						-79.98065059	40.44082605	Crawford-Roberts	6	3	42003030500	3	3	2	2-1
