Borough-day duration index

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

effects_borough_daily, page 2 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-01-23	Queens	13755	12894	30.0836	29.25	-0.094473	0.354957	0	41.5	6	88
2019-01-23	Staten Island	7	2	33.4048	30.7667	-0.188275	0.030328	0	41.5	1	21
2019-01-24	Bronx	449	80	29.1151	22.7167	-0.067512	0.851006	1.33	47	4	56
2019-01-24	Brooklyn	2828	1808	19.0968	14.0667	-0.016379	0.483458	1.33	47	22	123
2019-01-24	EWR	1	1	0.8833	0.8833	0.620388	null	1.33	47	null	0
2019-01-24	Manhattan	247448	245005	13.3332	10.9833	0.046267	0.414058	1.33	47	61	94
2019-01-24	Queens	14330	13516	32.5907	30.2833	-0.000021	0.370368	1.33	47	11	113
2019-01-24	Staten Island	11	0	39.9652	32.6833	null	null	1.33	47	1	14
2019-01-25	Bronx	553	112	24.6849	20.5333	-0.099111	0.760628	0	34	4	70
2019-01-25	Brooklyn	3033	1826	19.0576	15.2833	-0.01176	0.491201	0	34	19	143
2019-01-25	EWR	1	1	0.0833	0.0833	-1.740466	null	0	34	null	0
2019-01-25	Manhattan	254717	251783	12.7011	10.45	-0.003845	0.400619	0	34	57	73
2019-01-25	Queens	14955	13976	31.5336	30.2833	-0.033582	0.35446	0	34	8	127
2019-01-25	Staten Island	9	2	31.2019	26.8667	-0.290231	0.016289	0	34	1	17
2019-01-26	Bronx	360	66	17.6541	14.0917	-0.007462	0.596611	0	29.5	13	56
2019-01-26	Brooklyn	2892	1775	15.3286	12.575	-0.080256	0.513825	0	29.5	37	106
2019-01-26	EWR	1	0	0.4167	0.4167	null	null	0	29.5	null	0
2019-01-26	Manhattan	239948	236948	11.821	9.8667	-0.067508	0.427251	0	29.5	72	77
2019-01-26	Queens	10839	9814	26.3296	26.1	-0.135995	0.425904	0	29.5	22	112
2019-01-26	Staten Island	12	1	22.6792	18.2917	-0.660086	null	0	29.5	5	9
2019-01-27	Bronx	385	52	17.8271	14.8833	-0.023414	0.798135	0	40.5	6	41
2019-01-27	Brooklyn	2645	1504	15.0882	12.5833	-0.114726	0.492776	0	40.5	41	93
2019-01-27	EWR	1	0	44.2667	44.2667	null	null	0	40.5	null	0
2019-01-27	Manhattan	188570	185695	11.1001	9.2333	-0.16404	0.408616	0	40.5	74	71
2019-01-27	Queens	14663	13657	26.494	25.8833	-0.191675	0.364985	0	40.5	24	88