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-09-02 | Bronx | 115 | 20 | 14.2952 | 11.25 | -0.217553 | 0.740028 | 0.3 | 71.5 | 24 | 45 |
| 2019-09-02 | Brooklyn | 1348 | 791 | 14.5271 | 12.1083 | -0.134923 | 0.48574 | 0.3 | 71.5 | 102 | 116 |
| 2019-09-02 | EWR | 3 | 2 | 0.2 | 0.1833 | -0.448971 | 0.061526 | 0.3 | 71.5 | null | 0 |
| 2019-09-02 | Manhattan | 110710 | 109262 | 10.2617 | 8.4 | -0.307509 | 0.391843 | 0.3 | 71.5 | 92 | 43 |
| 2019-09-02 | Queens | 15357 | 14589 | 25.9424 | 25.1833 | -0.190063 | 0.378675 | 0.3 | 71.5 | 87 | 90 |
| 2019-09-02 | Staten Island | 5 | 1 | 44.3533 | 43.5833 | -0.20958 | null | 0.3 | 71.5 | 13 | 3 |
| 2019-09-03 | Bronx | 187 | 42 | 20.1783 | 15.4667 | -0.066517 | 0.701282 | 0 | 74.5 | 46 | 70 |
| 2019-09-03 | Brooklyn | 1673 | 1064 | 17.1162 | 14.0833 | 0.009363 | 0.44282 | 0 | 74.5 | 117 | 136 |
| 2019-09-03 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.96361 | null | 0 | 74.5 | null | 0 |
| 2019-09-03 | Manhattan | 167138 | 165519 | 12.5706 | 10.35 | -0.062434 | 0.38349 | 0 | 74.5 | 183 | 79 |
| 2019-09-03 | Queens | 17564 | 16730 | 35.016 | 33.45 | 0.045038 | 0.324787 | 0 | 74.5 | 97 | 128 |
| 2019-09-03 | Staten Island | 6 | 2 | 52.5139 | 50.5917 | 0.199863 | 0.189499 | 0 | 74.5 | 16 | 8 |
| 2019-09-04 | Bronx | 220 | 40 | 21.0167 | 17.0583 | -0.110125 | 0.524144 | 0 | 77.5 | 47 | 63 |
| 2019-09-04 | Brooklyn | 2052 | 1364 | 17.0023 | 14.25 | 0.004354 | 0.4672 | 0 | 77.5 | 134 | 140 |
| 2019-09-04 | Manhattan | 195408 | 193611 | 13.3503 | 11.1667 | 0.011275 | 0.385111 | 0 | 77.5 | 217 | 57 |
| 2019-09-04 | Queens | 14033 | 13331 | 33.6004 | 32.4167 | 0.028512 | 0.348691 | 0 | 77.5 | 121 | 93 |
| 2019-09-04 | Staten Island | 5 | 2 | 55.6967 | 57.3833 | 0.261557 | 0.372359 | 0 | 77.5 | 14 | 7 |
| 2019-09-05 | Bronx | 234 | 59 | 20.142 | 16.2833 | -0.062054 | 0.793351 | 0 | 69.5 | 54 | 71 |
| 2019-09-05 | Brooklyn | 2064 | 1361 | 16.7268 | 14.05 | -0.012513 | 0.452101 | 0 | 69.5 | 127 | 141 |
| 2019-09-05 | EWR | 2 | 1 | 7.825 | 7.825 | 0.374693 | null | 0 | 69.5 | null | 0 |
| 2019-09-05 | Manhattan | 210048 | 208191 | 13.8334 | 11.6167 | 0.0388 | 0.38112 | 0 | 69.5 | 249 | 88 |
| 2019-09-05 | Queens | 14052 | 13325 | 32.9141 | 32 | 0.044459 | 0.360809 | 0 | 69.5 | 109 | 114 |
| 2019-09-05 | Staten Island | 4 | 1 | 61.4333 | 66.0833 | 0.07143 | null | 0 | 69.5 | 14 | 10 |
| 2019-09-06 | Bronx | 220 | 49 | 21.628 | 16.8083 | 0.218135 | 0.939637 | 0.32 | 62.5 | 50 | 60 |
| 2019-09-06 | Brooklyn | 2236 | 1556 | 17.3581 | 13.925 | 0.04695 | 0.432133 | 0.32 | 62.5 | 119 | 128 |