Borough-day duration index
Per pickup borough and day: trips, the duration index, permitted events and collisions in that borough.
2,001 rows Download CSV
| dateTEXT | boroughTEXT | tripsINTEGER | indexed_tripsINTEGER | mean_minREAL | median_minREAL | mean_log_ratioREAL | sd_log_ratioREAL | precipitationREAL | tavgREAL | eventsINTEGER | collisionsINTEGER |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019-01-03 | Manhattan | 3 | 3 | 7.8111 | 9.8333 | -0.330168 | 0.359862 | 0 | 40.5 | 62 | 64 |
| 2019-01-05 | Brooklyn | 1 | 0 | 2.25 | 2.25 | null | null | 0.5 | 44 | 39 | 90 |
| 2019-01-05 | Manhattan | 2 | 2 | 7.45 | 7.45 | -0.01544 | 0.079464 | 0.5 | 44 | 75 | 52 |
| 2019-01-15 | Queens | 1 | 1 | 4.2667 | 4.2667 | -0.056941 | null | 0 | 30.5 | 7 | 106 |
| 2019-01-18 | Manhattan | 51 | 51 | 13.4307 | 10.7 | -0.117315 | 0.329635 | 0.05 | 34 | 49 | 71 |
| 2019-01-18 | Queens | 1 | 1 | 67.9333 | 67.9333 | 0.279537 | null | 0.05 | 34 | 7 | 115 |
| 2019-01-19 | Manhattan | 4 | 4 | 19.0792 | 7.1 | 0.174788 | 0.660851 | 0.29 | 34.5 | 79 | 67 |
| 2019-01-20 | Brooklyn | 3 | 2 | 15.8 | 13.5 | 0.106922 | 0.206006 | 0.88 | 28 | 40 | 95 |
| 2019-01-20 | Manhattan | 302 | 299 | 9.2363 | 7.775 | -0.235685 | 0.411304 | 0.88 | 28 | 79 | 45 |
| 2019-01-20 | Queens | 22 | 21 | 24.3189 | 25.4167 | -0.110515 | 0.202582 | 0.88 | 28 | 24 | 69 |
| 2019-01-21 | Bronx | 232 | 45 | 17.5925 | 15.6917 | -0.299428 | 0.928784 | 0 | 9 | 5 | 43 |
| 2019-01-21 | Brooklyn | 1415 | 814 | 13.9382 | 11.1333 | -0.233686 | 0.52624 | 0 | 9 | 20 | 93 |
| 2019-01-21 | EWR | 1 | 1 | 0.05 | 0.05 | -1.704748 | null | 0 | 9 | null | 0 |
| 2019-01-21 | Manhattan | 162043 | 160284 | 9.3088 | 7.6 | -0.292817 | 0.406378 | 0 | 9 | 57 | 62 |
| 2019-01-21 | Queens | 15595 | 14868 | 25.9385 | 25.8 | -0.230368 | 0.361078 | 0 | 9 | 9 | 67 |
| 2019-01-21 | Staten Island | 7 | 0 | 32.3119 | 42.5167 | null | null | 0 | 9 | 2 | 12 |
| 2019-01-22 | Bronx | 408 | 68 | 27.5068 | 23.8417 | 0.026499 | 0.658095 | 0 | 22 | 3 | 61 |
| 2019-01-22 | Brooklyn | 2296 | 1422 | 19.3812 | 15.275 | -0.035963 | 0.477253 | 0 | 22 | 25 | 119 |
| 2019-01-22 | EWR | 1 | 1 | 0.0333 | 0.0333 | -2.656757 | null | 0 | 22 | null | 0 |
| 2019-01-22 | Manhattan | 217637 | 215305 | 11.994 | 10 | -0.050346 | 0.402599 | 0 | 22 | 56 | 70 |
| 2019-01-22 | Queens | 16588 | 15710 | 31.6197 | 30.1667 | -0.050257 | 0.325736 | 0 | 22 | 8 | 112 |
| 2019-01-22 | Staten Island | 11 | 1 | 29.1227 | 35.75 | -0.720546 | null | 0 | 22 | 1 | 15 |
| 2019-01-23 | Bronx | 415 | 79 | 26.7955 | 21.0333 | -0.221197 | 0.877874 | 0 | 41.5 | 4 | 56 |
| 2019-01-23 | Brooklyn | 2553 | 1436 | 19.0478 | 15.5833 | -0.041499 | 0.483349 | 0 | 41.5 | 22 | 111 |
| 2019-01-23 | Manhattan | 227098 | 224585 | 12.8963 | 10.75 | 0.000009 | 0.410571 | 0 | 41.5 | 63 | 83 |