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-10-28 | Bronx | 144 | 32 | 19.2145 | 14.5333 | -0.246088 | 0.86959 | 0 | 59 | 66 | 71 |
| 2019-10-28 | Brooklyn | 1742 | 1218 | 17.0721 | 13.625 | -0.043676 | 0.402536 | 0 | 59 | 148 | 110 |
| 2019-10-28 | Manhattan | 185084 | 183455 | 13.2085 | 11.1 | -0.018259 | 0.378375 | 0 | 59 | 217 | 72 |
| 2019-10-28 | Queens | 15348 | 14738 | 33.3762 | 32.25 | -0.014694 | 0.353256 | 0 | 59 | 114 | 128 |
| 2019-10-28 | Staten Island | 5 | 1 | 41.5133 | 34.4167 | 0.16872 | null | 0 | 59 | 13 | 6 |
| 2019-10-29 | Bronx | 162 | 38 | 21.7307 | 15.8 | -0.004254 | 0.632657 | 0.07 | 56.5 | 72 | 73 |
| 2019-10-29 | Brooklyn | 1649 | 1163 | 16.8999 | 13.9667 | 0.005809 | 0.4363 | 0.07 | 56.5 | 165 | 137 |
| 2019-10-29 | EWR | 3 | 2 | 0.3111 | 0.2167 | -0.539003 | 0.118125 | 0.07 | 56.5 | null | 0 |
| 2019-10-29 | Manhattan | 209679 | 208053 | 14.5062 | 12.1167 | 0.102606 | 0.395965 | 0.07 | 56.5 | 236 | 83 |
| 2019-10-29 | Queens | 12811 | 12246 | 35.7033 | 34.8333 | 0.075892 | 0.369736 | 0.07 | 56.5 | 126 | 110 |
| 2019-10-29 | Staten Island | 8 | 1 | 44.7104 | 38.925 | 0.138435 | null | 0.07 | 56.5 | 14 | 5 |
| 2019-10-30 | Bronx | 151 | 29 | 22.5366 | 17.6833 | 0.019636 | 0.733655 | 0.06 | 60.5 | 71 | 65 |
| 2019-10-30 | Brooklyn | 2024 | 1429 | 17.3121 | 14.0833 | 0.035933 | 0.411209 | 0.06 | 60.5 | 182 | 121 |
| 2019-10-30 | EWR | 4 | 4 | 0.4708 | 0.45 | -0.471561 | 1.518666 | 0.06 | 60.5 | null | 0 |
| 2019-10-30 | Manhattan | 212015 | 210302 | 14.0462 | 11.8333 | 0.065902 | 0.380927 | 0.06 | 60.5 | 264 | 80 |
| 2019-10-30 | Queens | 13011 | 12478 | 35.0359 | 33.5 | 0.055849 | 0.382385 | 0.06 | 60.5 | 141 | 114 |
| 2019-10-30 | Staten Island | 6 | 2 | 60.975 | 57.1833 | 0.087591 | 0.06148 | 0.06 | 60.5 | 15 | 9 |
| 2019-10-31 | Bronx | 175 | 40 | 20.8095 | 16.0667 | -0.120341 | 0.559584 | 0.54 | 65.5 | 70 | 78 |
| 2019-10-31 | Brooklyn | 1933 | 1356 | 16.8818 | 14.0667 | 0.034708 | 0.434896 | 0.54 | 65.5 | 177 | 133 |
| 2019-10-31 | EWR | 2 | 1 | 1.2667 | 1.2667 | 1.683546 | null | 0.54 | 65.5 | null | 0 |
| 2019-10-31 | Manhattan | 211763 | 209842 | 13.9444 | 11.5333 | 0.085098 | 0.41662 | 0.54 | 65.5 | 260 | 72 |
| 2019-10-31 | Queens | 13241 | 12625 | 33.2755 | 32.5333 | 0.011402 | 0.40058 | 0.54 | 65.5 | 131 | 116 |
| 2019-10-31 | Staten Island | 6 | 2 | 42.4 | 31.9667 | -0.115135 | 0.238971 | 0.54 | 65.5 | 13 | 7 |
| 2019-11-01 | Bronx | 239 | 63 | 18.8123 | 14.6167 | -0.008362 | 0.535693 | 0.11 | 56.5 | 61 | 95 |
| 2019-11-01 | Brooklyn | 2717 | 1884 | 16.708 | 13.95 | 0.049878 | 0.447077 | 0.11 | 56.5 | 133 | 172 |