Borough-day duration index

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

effects_borough_daily, page 34 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-06-12	EWR	7	2	12.6929	0.5667	-0.97818	1.762738	0	66.5	null	0
2019-06-12	Manhattan	220184	217947	14.4509	11.95	0.076585	0.395991	0	66.5	369	88
2019-06-12	Queens	15292	14570	35.692	34.4667	0.067864	0.36729	0	66.5	240	136
2019-06-12	Staten Island	7	0	57.5262	66.2333	null	null	0	66.5	40	13
2019-06-13	Bronx	289	47	25.8845	21.2167	0.061331	0.286632	0.6	60	138	71
2019-06-13	Brooklyn	2760	1849	19.0392	14.7	0.042578	0.469807	0.6	60	262	128
2019-06-13	EWR	2	1	45.9583	45.9583	-0.143101	null	0.6	60	null	0
2019-06-13	Manhattan	230635	228303	14.7859	12.1	0.111203	0.406526	0.6	60	350	82
2019-06-13	Queens	14901	14151	35.6299	34.4	0.070281	0.375778	0.6	60	231	108
2019-06-13	Staten Island	14	2	29.2429	18.6	0.116039	0.227259	0.6	60	43	12
2019-06-14	Bronx	345	54	24.5038	18.5167	-0.000442	0.699097	0	65.5	157	75
2019-06-14	Brooklyn	2660	1704	18.9715	15.1833	0.051864	0.450482	0	65.5	247	154
2019-06-14	EWR	1	1	0.3667	0.3667	0.070618	null	0	65.5	null	0
2019-06-14	Manhattan	209444	206916	14.0542	11.4333	0.039317	0.390076	0	65.5	323	107
2019-06-14	Queens	16134	15340	35.7253	34.25	0.096833	0.378367	0	65.5	228	145
2019-06-14	Staten Island	5	0	50.3167	58.5167	null	null	0	65.5	34	12
2019-06-15	Bronx	294	43	19.2473	14.55	-0.028942	0.538453	0	70.5	204	78
2019-06-15	Brooklyn	3039	1913	16.6107	14.1833	0.051008	0.434606	0	70.5	415	117
2019-06-15	EWR	2	2	1.7667	1.7667	1.048895	1.199571	0	70.5	null	0
2019-06-15	Manhattan	193184	190193	11.9753	10.0333	-0.107625	0.399847	0	70.5	475	54
2019-06-15	Queens	12230	11276	28.8359	27.2833	-0.061272	0.395818	0	70.5	395	134
2019-06-15	Staten Island	6	0	38.2333	38.8333	null	null	0	70.5	43	9
2019-06-16	Bronx	363	66	14.6321	12.1833	0.048102	0.70598	0.04	72.5	134	66
2019-06-16	Brooklyn	2569	1417	15.1745	13.05	-0.068377	0.48218	0.04	72.5	328	109
2019-06-16	Manhattan	157581	154944	11.3195	9.3	-0.197047	0.401424	0.04	72.5	373	60