Borough-day duration index

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

effects_borough_daily, page 8 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-02-18	Manhattan	162635	160601	10.2102	8.4833	-0.269383	0.384097	0.09	34	57	43
2019-02-18	Queens	17095	16175	27.2067	26.5333	-0.202235	0.335367	0.09	34	17	90
2019-02-18	Staten Island	12	2	38.3389	36.825	-0.022972	0.042907	0.09	34	2	8
2019-02-19	Bronx	418	65	28.8258	24.925	-0.07223	0.763334	0	29.5	8	60
2019-02-19	Brooklyn	2224	1241	19.6651	16.3083	-0.069211	0.477499	0	29.5	25	101
2019-02-19	EWR	1	1	0.1333	0.1333	-0.628609	null	0	29.5	null	0
2019-02-19	Manhattan	202343	199918	12.8787	10.6833	-0.036697	0.390685	0	29.5	56	79
2019-02-19	Queens	16161	15300	31.9888	30.5667	-0.069858	0.312484	0	29.5	14	102
2019-02-19	Staten Island	9	0	47.3907	41.15	null	null	0	29.5	3	14
2019-02-20	Bronx	432	68	22.019	19.0833	-0.240193	0.631212	0.57	29.5	6	61
2019-02-20	Brooklyn	2509	1450	18.2743	14.9333	-0.068901	0.460874	0.57	29.5	26	122
2019-02-20	EWR	1	0	0.05	0.05	null	null	0.57	29.5	null	0
2019-02-20	Manhattan	211554	209130	12.4742	10.45	-0.021124	0.395801	0.57	29.5	70	75
2019-02-20	Queens	12769	11948	28.8344	28.7667	-0.136114	0.348882	0.57	29.5	16	125
2019-02-20	Staten Island	12	0	35.6069	39.6917	null	null	0.57	29.5	4	34
2019-02-21	Bronx	435	71	25.564	21.7833	-0.042151	0.410997	0.1	42.5	9	58
2019-02-21	Brooklyn	2771	1638	19.2346	15.6333	-0.023646	0.402951	0.1	42.5	25	116
2019-02-21	EWR	2	1	43.175	43.175	-1.098612	null	0.1	42.5	null	0
2019-02-21	Manhattan	219105	216485	13.4627	11.1833	0.005678	0.383269	0.1	42.5	68	90
2019-02-21	Queens	16009	15091	33.1966	32.5333	0.007069	0.335493	0.1	42.5	18	90
2019-02-21	Staten Island	9	1	45.9722	42.4667	0.320908	null	0.1	42.5	3	19
2019-02-22	Bronx	488	86	23.601	20.4083	-0.121127	0.784854	0	40	7	58
2019-02-22	Brooklyn	3051	1763	18.9217	15.2833	-0.037504	0.418345	0	40	24	112
2019-02-22	Manhattan	230306	227305	12.9669	10.8333	-0.009454	0.384606	0	40	58	69
2019-02-22	Queens	14580	13573	31.3603	30.8333	-0.047392	0.335955	0	40	17	97