Borough-day duration index

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

effects_borough_daily, page 15 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-03-20	Queens	16416	15501	31.935	30.9333	-0.046315	0.321135	0	45	117	110
2019-03-20	Staten Island	6	1	32.2139	33.575	-0.020505	null	0	45	19	5
2019-03-21	Bronx	468	75	30.6619	25.9833	-0.056268	0.628476	0.75	43.5	73	62
2019-03-21	Brooklyn	3003	1930	19.7398	14.5167	0.018547	0.438908	0.75	43.5	116	124
2019-03-21	EWR	3	2	25.8722	1.2667	-0.161911	2.082033	0.75	43.5	null	0
2019-03-21	Manhattan	239889	237227	14.1946	11.5833	0.072315	0.403258	0.75	43.5	157	88
2019-03-21	Queens	15569	14686	37.6831	36.2833	0.089445	0.372163	0.75	43.5	122	104
2019-03-21	Staten Island	6	1	38.4361	34.5833	-0.160015	null	0.75	43.5	17	11
2019-03-22	Bronx	482	74	30.2711	25.3583	0.05219	0.449757	0.68	43.5	70	80
2019-03-22	Brooklyn	3068	1856	19.6454	15.1167	0.00292	0.456712	0.68	43.5	117	144
2019-03-22	EWR	3	3	0.1722	0.15	-0.84191	1.235459	0.68	43.5	null	0
2019-03-22	Manhattan	237217	234385	13.1052	10.8167	0.005383	0.387357	0.68	43.5	137	93
2019-03-22	Queens	15647	14657	34.222	32.5833	0.051092	0.367206	0.68	43.5	114	118
2019-03-22	Staten Island	4	0	66.3208	76.075	null	null	0.68	43.5	16	11
2019-03-23	Bronx	357	44	19.8831	17.45	-0.0417	0.51165	0	41.5	73	54
2019-03-23	Brooklyn	3228	1928	15.6392	13.025	-0.034923	0.497893	0	41.5	143	122
2019-03-23	EWR	1	0	39.95	39.95	null	null	0	41.5	null	0
2019-03-23	Manhattan	223813	220679	12.1115	10.1833	-0.068975	0.407575	0	41.5	196	54
2019-03-23	Queens	13682	12556	27.6795	26.9667	-0.11543	0.388474	0	41.5	141	108
2019-03-23	Staten Island	7	1	31.3	32.55	0.129537	null	0	41.5	16	4
2019-03-24	Bronx	377	43	18.8293	15.4833	-0.090922	0.565492	0	49	53	36
2019-03-24	Brooklyn	3062	1704	15.6555	12.925	-0.095068	0.448585	0	49	151	89
2019-03-24	EWR	2	2	0.0833	0.0833	-1.119023	0.028866	0	49	null	0
2019-03-24	Manhattan	176870	173845	11.9847	9.8667	-0.128938	0.404595	0	49	182	53
2019-03-24	Queens	17098	15988	29.4676	28.1833	-0.100439	0.359233	0	49	128	108