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-08-20 | Brooklyn | 1596 | 1037 | 16.7766 | 14.3167 | -0.055371 | 0.465891 | 0 | 81.5 | 246 | 124 |
| 2019-08-20 | EWR | 1 | 0 | 37.0833 | 37.0833 | null | null | 0 | 81.5 | null | 0 |
| 2019-08-20 | Manhattan | 172927 | 171252 | 12.4923 | 10.5333 | -0.063122 | 0.375003 | 0 | 81.5 | 340 | 82 |
| 2019-08-20 | Queens | 14314 | 13654 | 30.8931 | 30.4 | -0.009915 | 0.359527 | 0 | 81.5 | 192 | 101 |
| 2019-08-20 | Staten Island | 6 | 2 | 59.7 | 70.975 | 0.057315 | 0.250893 | 0 | 81.5 | 36 | 6 |
| 2019-08-21 | Bronx | 165 | 35 | 18.724 | 14.0333 | -0.095287 | 0.512723 | 0.1 | 80.5 | 115 | 49 |
| 2019-08-21 | Brooklyn | 1643 | 1067 | 15.957 | 13.6 | -0.012247 | 0.442142 | 0.1 | 80.5 | 254 | 106 |
| 2019-08-21 | Manhattan | 183940 | 182256 | 12.8212 | 10.8167 | -0.032749 | 0.379279 | 0.1 | 80.5 | 360 | 78 |
| 2019-08-21 | Queens | 13817 | 13200 | 29.3563 | 28.3667 | -0.04417 | 0.350259 | 0.1 | 80.5 | 194 | 112 |
| 2019-08-21 | Staten Island | 6 | 0 | 21.8028 | 7.45 | null | null | 0.1 | 80.5 | 40 | 8 |
| 2019-08-22 | Bronx | 180 | 44 | 16.8414 | 12.8583 | -0.111983 | 0.600602 | 1.01 | 80.5 | 122 | 55 |
| 2019-08-22 | Brooklyn | 1946 | 1359 | 16.0993 | 13.0167 | 0.016158 | 0.430756 | 1.01 | 80.5 | 254 | 127 |
| 2019-08-22 | EWR | 2 | 2 | 0.6833 | 0.6833 | 0.203545 | 1.583687 | 1.01 | 80.5 | null | 0 |
| 2019-08-22 | Manhattan | 192684 | 190821 | 13.3426 | 10.9667 | -0.002454 | 0.386833 | 1.01 | 80.5 | 351 | 64 |
| 2019-08-22 | Queens | 14014 | 13355 | 32.5713 | 31.3667 | 0.033975 | 0.349739 | 1.01 | 80.5 | 200 | 105 |
| 2019-08-22 | Staten Island | 7 | 2 | 22.7143 | 11.1 | 0.089878 | 0.206313 | 1.01 | 80.5 | 37 | 9 |
| 2019-08-23 | Bronx | 182 | 29 | 19.5636 | 15.8583 | -0.063604 | 0.426454 | 0.09 | 69.5 | 131 | 68 |
| 2019-08-23 | Brooklyn | 1786 | 1201 | 16.2912 | 13.9417 | 0.013761 | 0.433929 | 0.09 | 69.5 | 245 | 114 |
| 2019-08-23 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.634131 | null | 0.09 | 69.5 | null | 0 |
| 2019-08-23 | Manhattan | 166854 | 164905 | 12.9509 | 10.8 | -0.035996 | 0.387309 | 0.09 | 69.5 | 302 | 69 |
| 2019-08-23 | Queens | 15552 | 14727 | 31.6482 | 30.4 | 0.023922 | 0.3376 | 0.09 | 69.5 | 197 | 99 |
| 2019-08-23 | Staten Island | 7 | 2 | 42.8762 | 52.5333 | -0.044123 | 0.084587 | 0.09 | 69.5 | 34 | 4 |
| 2019-08-24 | Bronx | 223 | 40 | 18.749 | 14.4667 | -0.08973 | 0.686443 | 0 | 70 | 234 | 47 |
| 2019-08-24 | Brooklyn | 2184 | 1377 | 16.1579 | 13.7667 | 0.011416 | 0.45128 | 0 | 70 | 470 | 101 |
| 2019-08-24 | EWR | 1 | 0 | 0.35 | 0.35 | null | null | 0 | 70 | null | 0 |