Borough-day duration index

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

effects_borough_daily, page 10 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-02-27	Brooklyn	3201	1850	19.6151	15.8167	-0.017449	0.462022	0	27	28	108
2019-02-27	EWR	1	0	59.4833	59.4833	null	null	0	27	null	0
2019-02-27	Manhattan	235996	233211	13.0536	10.7833	-0.007086	0.398744	0	27	79	60
2019-02-27	Queens	15332	14377	32.7682	31.8667	-0.037666	0.348801	0	27	12	82
2019-02-27	Staten Island	12	1	34.6389	35.5917	0.202387	null	0	27	2	16
2019-02-28	Bronx	512	103	29.2318	24.5833	-0.12388	0.737177	0.03	32	12	74
2019-02-28	Brooklyn	3268	1959	20.5982	16.15	-0.010469	0.471202	0.03	32	29	143
2019-02-28	EWR	2	1	44.1167	44.1167	1.28364	null	0.03	32	null	0
2019-02-28	Manhattan	245551	242625	13.7072	11.1	0.022474	0.394377	0.03	32	81	92
2019-02-28	Queens	15764	14840	37.4029	36.2167	0.092396	0.361745	0.03	32	14	107
2019-02-28	Staten Island	8	0	54.0875	55.5917	null	null	0.03	32	2	21
2019-03-01	Bronx	777	139	26.9832	21.95	0.02592	0.770399	0.11	30.5	10	81
2019-03-01	Brooklyn	3872	2229	19.6016	15.725	0.01053	0.475832	0.11	30.5	26	141
2019-03-01	EWR	1	0	47.9667	47.9667	null	null	0.11	30.5	null	0
2019-03-01	Manhattan	245324	242091	12.9733	10.6833	0.002823	0.386012	0.11	30.5	75	86
2019-03-01	Queens	15907	14899	35.5631	34.55	0.066204	0.348699	0.11	30.5	12	129
2019-03-01	Staten Island	10	2	40.6683	40.6917	-0.004674	0.289979	0.11	30.5	3	20
2019-03-02	Bronx	502	78	18.6852	16.1583	-0.183088	0.672964	0.53	36	13	69
2019-03-02	Brooklyn	3624	2040	16.4756	14.025	-0.028825	0.493192	0.53	36	40	140
2019-03-02	EWR	1	1	3.6833	3.6833	2.507791	null	0.53	36	null	0
2019-03-02	Manhattan	222867	219590	11.6869	9.85	-0.089829	0.410319	0.53	36	85	58
2019-03-02	Queens	11706	10735	26.6062	26.65	-0.167147	0.380796	0.53	36	26	125
2019-03-02	Staten Island	7	2	33.4143	37.8333	-0.231798	0.316875	0.53	36	7	25
2019-03-03	Bronx	540	57	18.6143	16.3083	-0.051508	0.709997	0.52	37.5	7	56
2019-03-03	Brooklyn	3422	1901	16.034	13.4167	-0.084535	0.48488	0.52	37.5	43	115