Borough-day duration index

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

effects_borough_daily, page 5 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-02-05	EWR	1	1	0.1833	0.1833	-0.405465	null	0	54.5	null	0
2019-02-05	Manhattan	221020	218422	12.622	10.6167	-0.04379	0.3801	0	54.5	60	81
2019-02-05	Queens	13895	12973	29.6819	29.2667	-0.114089	0.318702	0	54.5	8	90
2019-02-05	Staten Island	13	1	16.909	8.4167	0.102654	null	0	54.5	2	14
2019-02-06	Bronx	474	68	28.0989	24.4333	-0.01114	0.709666	0.45	40.5	4	70
2019-02-06	Brooklyn	3022	1813	19.6599	15.0833	-0.002771	0.439079	0.45	40.5	26	121
2019-02-06	Manhattan	244336	241581	13.2148	10.8833	0.015461	0.386407	0.45	40.5	64	82
2019-02-06	Queens	13263	12382	32.3946	31.9	-0.037848	0.348556	0.45	40.5	7	117
2019-02-06	Staten Island	9	2	40.3759	42.8	0.199301	0.000563	0.45	40.5	1	13
2019-02-07	Bronx	474	86	28.9926	23.7333	0.014167	0.538407	0.07	41.5	5	47
2019-02-07	Brooklyn	2987	1790	20.3424	15.5333	-0.012823	0.439246	0.07	41.5	24	104
2019-02-07	EWR	4	3	0.2125	0.1667	-0.803439	0.69589	0.07	41.5	null	0
2019-02-07	Manhattan	241827	238971	13.4867	11.1667	0.017568	0.385115	0.07	41.5	66	77
2019-02-07	Queens	14240	13308	33.3348	32.6	-0.006697	0.326902	0.07	41.5	9	105
2019-02-07	Staten Island	18	3	30.2852	19.875	0.107493	0.206311	0.07	41.5	2	14
2019-02-08	Bronx	546	95	26.3251	22.5917	-0.05227	0.706019	0.37	43.5	4	69
2019-02-08	Brooklyn	3266	2018	20.2799	15.6083	0.01519	0.4972	0.37	43.5	22	130
2019-02-08	EWR	4	4	0.55	0.2167	-0.273572	1.799659	0.37	43.5	null	0
2019-02-08	Manhattan	253310	250378	13.4079	11.0667	0.037272	0.39458	0.37	43.5	55	77
2019-02-08	Queens	14724	13758	34.1763	32.3167	-0.000897	0.343058	0.37	43.5	9	115
2019-02-08	Staten Island	10	3	46.4583	51.4583	0.203464	0.061698	0.37	43.5	2	18
2019-02-09	Bronx	338	37	20.0141	17.3333	0.061818	0.931322	0	27.5	13	61
2019-02-09	Brooklyn	3468	2065	15.7744	13.1667	-0.064564	0.497526	0	27.5	39	116
2019-02-09	Manhattan	246519	243319	12.4138	10.3167	-0.029924	0.435018	0	27.5	82	72
2019-02-09	Queens	10650	9653	26.5316	25.9583	-0.157074	0.388526	0	27.5	26	100