Daily duration index

Per day: trips, mean minutes and the composition-adjusted duration index (mean log of minutes / route-hour median), with weather, events and collisions.

351 rows Download CSV

effects_daily, page 1 of 15
dateTEXT	tripsINTEGER	indexed_tripsINTEGER	mean_minREAL	median_minREAL	mean_log_ratioREAL	sd_log_ratioREAL	precipitationREAL	snowREAL	snow_depthREAL	tavgREAL	eventsINTEGER	collisionsINTEGER
2019-01-03	3	3	7.8111	9.8333	-0.330168	0.359862	0	0	0	40.5	106	343
2019-01-05	3	2	5.7167	4.8	-0.01544	0.079464	0.5	0	0	44	152	288
2019-01-15	1	1	4.2667	4.2667	-0.056941	null	0	0	0	30.5	94	381
2019-01-18	52	52	14.4788	10.8917	-0.109684	0.330995	0.05	0.5	1.2	34	85	400
2019-01-19	4	4	19.0792	7.1	0.174788	0.660851	0.29	0.2	0	34.5	156	328
2019-01-20	327	322	10.3112	8.2333	-0.225394	0.401733	0.88	0	0	28	155	267
2019-01-21	179293	176012	10.8034	8.2	-0.287278	0.404005	0	0	0	9	93	277
2019-01-22	236941	232507	13.467	10.5833	-0.050243	0.398514	0	0	0	22	93	377
2019-01-23	243828	238996	13.9546	11.2333	-0.005413	0.409065	0	0	0	41.5	96	359
2019-01-24	265067	260410	14.4636	11.4667	0.043397	0.412793	1.33	0	0	47	99	400
2019-01-25	273268	267700	13.8271	10.9333	-0.0055	0.39932	0	0	0	34	89	430
2019-01-26	254052	248604	12.4886	10.1667	-0.070289	0.428139	0	0	0	29.5	149	360
2019-01-27	206275	200908	12.2589	9.7833	-0.165513	0.406731	0	0	0	40.5	152	299
2019-01-28	224623	220034	12.8214	10	-0.104509	0.399502	0	0	0	31.5	96	350
2019-01-29	242766	238018	13.4126	10.6833	-0.022438	0.392856	0.23	0	0	34	94	455
2019-01-30	258227	253361	13.0716	10.4333	-0.031733	0.400738	0.01	0.4	0	20.5	107	415
2019-01-31	264165	259575	13.6029	10.75	-0.014024	0.406715	0	0	0	9	104	383
2019-02-01	278003	272412	13.7634	10.8667	0.006243	0.407459	0	0	0	16	90	421
2019-02-02	249020	243195	12.4021	10.05	-0.084068	0.430323	0	0	0	25	163	375
2019-02-03	207435	201254	11.9552	9.5833	-0.186164	0.398171	0	0	0	43	160	313
2019-02-04	218926	213882	13.5771	10.6	-0.091159	0.388526	0	0	0	51	96	404
2019-02-05	238136	233041	13.7149	11.1	-0.047919	0.378166	0	0	0	54.5	100	357
2019-02-06	261104	255846	14.2916	11.3333	0.012746	0.38535	0.45	0	0	40.5	102	403
2019-02-07	259550	254161	14.6838	11.6667	0.016074	0.382814	0.07	0	0	41.5	106	347
2019-02-08	271860	266256	14.6422	11.5833	0.035097	0.39326	0.37	0	0	43.5	92	409