Borough-day duration index

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

effects_borough_daily, page 67 of 81
dateTEXT	boroughTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-11-01	EWR	1	1	1.15	1.15	1.213682	null	0.11	56.5	null	0
2019-11-01	Manhattan	241572	238960	14.2274	11.8833	0.103812	0.389616	0.11	56.5	230	100
2019-11-01	Queens	14985	14303	37.7088	37.0333	0.110754	0.378918	0.11	56.5	120	149
2019-11-01	Staten Island	5	1	15.5467	16.2167	-0.045386	null	0.11	56.5	15	6
2019-11-02	Bronx	210	38	17.1167	13.825	-0.164145	0.632178	0	46.5	67	54
2019-11-02	Brooklyn	2528	1637	15.7931	13.7	0.011723	0.438137	0	46.5	217	106
2019-11-02	EWR	1	1	5.3	5.3	2.87168	null	0	46.5	null	0
2019-11-02	Manhattan	222701	220039	13.4302	11.2667	0.034017	0.419363	0	46.5	307	66
2019-11-02	Queens	10637	9885	29.2082	28.0167	-0.055233	0.402033	0	46.5	173	121
2019-11-02	Staten Island	7	0	29.2476	31.1667	null	null	0	46.5	22	15
2019-11-03	Bronx	192	32	16.3936	13.1417	-0.019375	1.141765	0	48	51	65
2019-11-03	Brooklyn	2354	1444	14.8057	12.0833	-0.069513	0.459935	0	48	204	100
2019-11-03	EWR	1	0	0.45	0.45	null	null	0	48	null	0
2019-11-03	Manhattan	179244	176687	12.2255	9.7667	-0.098412	0.469712	0	48	263	59
2019-11-03	Queens	14596	13850	28.0149	27.3667	-0.133691	0.380909	0	48	168	83
2019-11-03	Staten Island	9	0	17.9981	9.3	null	null	0	48	32	5
2019-11-04	Bronx	165	35	20.717	17.1833	-0.070158	0.835306	0	48.5	49	68
2019-11-04	Brooklyn	1591	1060	17.9788	14.9667	0.018301	0.446357	0	48.5	134	118
2019-11-04	EWR	1	0	0.0667	0.0667	null	null	0	48.5	null	0
2019-11-04	Manhattan	186649	185058	13.4911	11.1667	-0.004371	0.381125	0	48.5	193	80
2019-11-04	Queens	15773	15118	35.5107	34.0833	0.034941	0.351296	0	48.5	90	141
2019-11-04	Staten Island	8	1	39.1042	36.4	0.391467	null	0	48.5	11	11
2019-11-05	Bronx	138	27	17.3815	13	-0.012553	0.491216	0	56	47	52
2019-11-05	Brooklyn	1664	1148	15.4477	12.7833	-0.068978	0.498635	0	56	147	96
2019-11-05	EWR	1	0	60.4333	60.4333	null	null	0	56	null	0