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-04-15 | Queens | 16575 | 15795 | 33.6696 | 31.1333 | 0.017516 | 0.355639 | 0.96 | 55.5 | 183 | 123 |
| 2019-04-15 | Staten Island | 8 | 0 | 57.6229 | 59.6667 | null | null | 0.96 | 55.5 | 27 | 4 |
| 2019-04-16 | Bronx | 354 | 72 | 26.8718 | 21.3167 | -0.022081 | 0.600677 | 0 | 55 | 129 | 69 |
| 2019-04-16 | Brooklyn | 2671 | 1714 | 18.1817 | 14.4333 | 0.022966 | 0.421132 | 0 | 55 | 202 | 135 |
| 2019-04-16 | EWR | 2 | 2 | 0.6333 | 0.6333 | 0.425388 | 0.714787 | 0 | 55 | null | 0 |
| 2019-04-16 | Manhattan | 220857 | 218503 | 13.7555 | 11.3667 | 0.031599 | 0.389686 | 0 | 55 | 313 | 90 |
| 2019-04-16 | Queens | 16533 | 15608 | 33.4975 | 31.3667 | 0.031801 | 0.347962 | 0 | 55 | 190 | 112 |
| 2019-04-16 | Staten Island | 10 | 3 | 49.16 | 53.9917 | -0.107044 | 0.037494 | 0 | 55 | 31 | 7 |
| 2019-04-17 | Bronx | 381 | 62 | 24.9364 | 20.6333 | -0.125 | 0.668845 | 0.01 | 55.5 | 134 | 59 |
| 2019-04-17 | Brooklyn | 2703 | 1776 | 17.728 | 14.15 | 0.013178 | 0.44074 | 0.01 | 55.5 | 216 | 130 |
| 2019-04-17 | Manhattan | 233150 | 230809 | 13.9925 | 11.5833 | 0.052483 | 0.392449 | 0.01 | 55.5 | 336 | 81 |
| 2019-04-17 | Queens | 14408 | 13625 | 33.8995 | 32.6833 | 0.02579 | 0.381005 | 0.01 | 55.5 | 204 | 123 |
| 2019-04-17 | Staten Island | 10 | 1 | 36.365 | 31.925 | -0.29953 | null | 0.01 | 55.5 | 36 | 9 |
| 2019-04-18 | Bronx | 291 | 68 | 20.8703 | 14.55 | 0.091788 | 1.076868 | 0 | 56.5 | 126 | 56 |
| 2019-04-18 | Brooklyn | 2767 | 1939 | 17.1389 | 13.65 | 0.046677 | 0.465344 | 0 | 56.5 | 210 | 100 |
| 2019-04-18 | EWR | 7 | 6 | 15.8619 | 15.4333 | 2.911074 | 1.679505 | 0 | 56.5 | null | 0 |
| 2019-04-18 | Manhattan | 233838 | 231518 | 14.5578 | 11.9333 | 0.087278 | 0.404955 | 0 | 56.5 | 349 | 78 |
| 2019-04-18 | Queens | 15646 | 14855 | 36.9839 | 35.6833 | 0.096413 | 0.38596 | 0 | 56.5 | 201 | 83 |
| 2019-04-18 | Staten Island | 5 | 2 | 46.4067 | 55.7667 | -0.101421 | 0.591784 | 0 | 56.5 | 34 | 7 |
| 2019-04-19 | Bronx | 334 | 59 | 16.6332 | 13.0667 | 0.171346 | 0.725531 | 0.01 | 69 | 137 | 55 |
| 2019-04-19 | Brooklyn | 2722 | 1808 | 15.1114 | 12.65 | -0.04216 | 0.464677 | 0.01 | 69 | 199 | 110 |
| 2019-04-19 | EWR | 1 | 1 | 0.3 | 0.3 | -0.130053 | null | 0.01 | 69 | null | 0 |
| 2019-04-19 | Manhattan | 211692 | 209091 | 12.2424 | 10.2667 | -0.067084 | 0.394167 | 0.01 | 69 | 296 | 61 |
| 2019-04-19 | Queens | 13380 | 12566 | 27.9027 | 27.45 | -0.12936 | 0.380158 | 0.01 | 69 | 191 | 94 |
| 2019-04-19 | Staten Island | 6 | 1 | 21.5667 | 11.075 | -0.062732 | null | 0.01 | 69 | 27 | 7 |