Borough-day duration index

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

effects_borough_daily, page 11 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-03-03	EWR	1	0	0.0833	0.0833	null	null	0.52	37.5	null	0
2019-03-03	Manhattan	191122	188026	11.0027	9.0333	-0.175328	0.401842	0.52	37.5	89	65
2019-03-03	Queens	14913	13892	28.0758	27.3167	-0.14381	0.364029	0.52	37.5	35	92
2019-03-03	Staten Island	5	0	17.3733	13.4	null	null	0.52	37.5	11	15
2019-03-04	Bronx	385	62	20.3373	18.3667	-0.16178	0.5522	0.29	33	10	69
2019-03-04	Brooklyn	2023	1202	16.4814	13.95	-0.134772	0.472215	0.29	33	27	105
2019-03-04	EWR	2	2	0.2917	0.2917	-0.093606	0.132379	0.29	33	null	0
2019-03-04	Manhattan	176986	175032	10.761	9.0333	-0.188694	0.379168	0.29	33	70	49
2019-03-04	Queens	17415	16670	27.9479	28.45	-0.155399	0.370683	0.29	33	12	110
2019-03-04	Staten Island	6	1	37.7861	36.2	-0.158273	null	0.29	33	4	22
2019-03-05	Bronx	561	105	28.7871	23.0333	0.071233	0.603388	0	26	12	64
2019-03-05	Brooklyn	2801	1723	19.9976	15.4667	-0.042407	0.485338	0	26	26	130
2019-03-05	EWR	1	1	0.2333	0.2333	-0.278713	null	0	26	null	0
2019-03-05	Manhattan	233632	231071	13.1669	10.9	0.006874	0.393548	0	26	75	81
2019-03-05	Queens	16121	15267	34.4402	32.7167	0.01487	0.334228	0	26	14	102
2019-03-05	Staten Island	16	1	47.3719	49.9583	0.5811	null	0	26	5	19
2019-03-06	Bronx	512	101	24.952	21.2333	-0.103211	0.583398	0	22.5	10	77
2019-03-06	Brooklyn	3079	1932	19.6634	15.2	0.000855	0.472953	0	22.5	28	118
2019-03-06	EWR	2	0	21.4667	21.4667	null	null	0	22.5	null	0
2019-03-06	Manhattan	249943	247276	13.4882	11.1333	0.037176	0.395896	0	22.5	81	66
2019-03-06	Queens	16064	15246	33.5489	32.2167	-0.013979	0.343765	0	22.5	11	99
2019-03-06	Staten Island	6	1	50.4583	48.8	-0.05557	null	0	22.5	4	14
2019-03-07	Bronx	468	81	26.9572	22.3	0.02068	0.633068	0	25	14	71
2019-03-07	Brooklyn	3094	1902	19.3978	15.5917	0.004585	0.449396	0	25	25	118
2019-03-07	Manhattan	255210	252389	13.8654	11.3167	0.046864	0.392843	0	25	81	70