Borough-day duration index

Per pickup borough and day: trips, the duration index, permitted events and collisions in that borough.

effects_borough_daily, page 42 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-07-16	Staten Island	11	0	30.497	10.25	null	null	0	81.5	47	13
2019-07-17	Bronx	248	45	26.039	22.925	-0.122055	0.808284	1.82	83	137	62
2019-07-17	Brooklyn	2246	1518	17.741	14.4833	0.030457	0.48141	1.82	83	307	126
2019-07-17	EWR	2	0	0.3917	0.3917	null	null	1.82	83	null	0
2019-07-17	Manhattan	218713	216686	14.1223	11.7333	0.075191	0.39808	1.82	83	393	88
2019-07-17	Queens	12754	12127	33.9081	33.6167	0.033363	0.365765	1.82	83	220	128
2019-07-17	Staten Island	10	2	40.955	24.3083	0.197728	0.279629	1.82	83	45	4
2019-07-18	Bronx	241	40	23.6274	18.4167	-0.043583	0.46013	0.51	75	138	66
2019-07-18	Brooklyn	1971	1273	18.1596	14.7	0.033186	0.437103	0.51	75	299	130
2019-07-18	EWR	4	3	3.3333	0.8417	1.632869	2.185895	0.51	75	null	0
2019-07-18	Manhattan	204674	202678	14.5934	12.0167	0.07508	0.397733	0.51	75	376	99
2019-07-18	Queens	16537	15795	34.5164	32.5833	0.07476	0.353585	0.51	75	223	121
2019-07-18	Staten Island	4	2	54.0583	49.25	0.112214	0.158694	0.51	75	44	12
2019-07-19	Bronx	445	89	21.6533	16.9167	0.194944	0.557298	0	81	128	74
2019-07-19	Brooklyn	2510	1645	17.875	14.3833	0.045449	0.446558	0	81	293	143
2019-07-19	EWR	3	2	0.1389	0.1833	-0.419165	0.142427	0	81	null	0
2019-07-19	Manhattan	207746	204981	13.6663	11.15	0.006764	0.395919	0	81	315	96
2019-07-19	Queens	15383	14583	33.6211	32.1167	0.048593	0.37471	0	81	207	120
2019-07-19	Staten Island	10	2	32.4683	15.8417	0.129611	0.195385	0	81	34	4
2019-07-20	Bronx	226	43	17.8041	13.8417	-0.267751	0.902187	0	88.5	202	68
2019-07-20	Brooklyn	2136	1293	14.6812	12.5167	-0.078366	0.479781	0	88.5	425	128
2019-07-20	EWR	3	3	14.1389	7.95	3.060368	1.963538	0	88.5	null	0
2019-07-20	Manhattan	172855	170391	11.3766	9.6167	-0.151947	0.397581	0	88.5	410	70
2019-07-20	Queens	12018	11173	26.3498	25.5	-0.136051	0.407422	0	88.5	379	108
2019-07-20	Staten Island	4	0	51.9167	48.4833	null	null	0	88.5	50	12