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-07-21 | Bronx | 232 | 35 | 16.7241 | 14.45 | -0.003788 | 0.605205 | 0 | 87.5 | 136 | 53 |
| 2019-07-21 | Brooklyn | 1883 | 1124 | 14.423 | 12.3667 | -0.110915 | 0.436972 | 0 | 87.5 | 322 | 106 |
| 2019-07-21 | EWR | 2 | 2 | 4.0917 | 4.0917 | 1.475618 | 1.837292 | 0 | 87.5 | null | 0 |
| 2019-07-21 | Manhattan | 151652 | 149517 | 10.7774 | 9.05 | -0.222931 | 0.394895 | 0 | 87.5 | 346 | 55 |
| 2019-07-21 | Queens | 14805 | 13952 | 27.4879 | 26.2833 | -0.135631 | 0.390544 | 0 | 87.5 | 302 | 91 |
| 2019-07-21 | Staten Island | 7 | 2 | 42.581 | 44.5833 | 0.000839 | 0.111096 | 0 | 87.5 | 46 | 9 |
| 2019-07-22 | Bronx | 243 | 46 | 21.6493 | 16.3 | -0.149521 | 0.76542 | 1.66 | 81 | 115 | 90 |
| 2019-07-22 | Brooklyn | 1937 | 1283 | 17.2962 | 14.1167 | -0.002054 | 0.460963 | 1.66 | 81 | 285 | 108 |
| 2019-07-22 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.634131 | null | 1.66 | 81 | null | 0 |
| 2019-07-22 | Manhattan | 182657 | 180873 | 13.0563 | 10.7667 | -0.02474 | 0.387479 | 1.66 | 81 | 320 | 87 |
| 2019-07-22 | Queens | 16393 | 15437 | 32.684 | 30.6167 | 0.014323 | 0.354978 | 1.66 | 81 | 190 | 119 |
| 2019-07-22 | Staten Island | 7 | 2 | 46.5333 | 51.0167 | -0.005362 | 0.14054 | 1.66 | 81 | 37 | 6 |
| 2019-07-23 | Bronx | 199 | 33 | 22.0181 | 16.4833 | 0.042346 | 0.881008 | 0.53 | 70.5 | 138 | 62 |
| 2019-07-23 | Brooklyn | 1643 | 1084 | 18.0368 | 14.7167 | 0.033507 | 0.444488 | 0.53 | 70.5 | 299 | 112 |
| 2019-07-23 | EWR | 3 | 3 | 0.9056 | 0.3 | 0.294536 | 1.092923 | 0.53 | 70.5 | null | 0 |
| 2019-07-23 | Manhattan | 191871 | 190207 | 13.3118 | 11.1833 | -0.000093 | 0.376025 | 0.53 | 70.5 | 333 | 79 |
| 2019-07-23 | Queens | 16492 | 15804 | 32.7457 | 30.8667 | 0.014295 | 0.341745 | 0.53 | 70.5 | 213 | 101 |
| 2019-07-23 | Staten Island | 8 | 2 | 45.7604 | 43.0167 | -0.167665 | 0.0171 | 0.53 | 70.5 | 49 | 9 |
| 2019-07-24 | Bronx | 244 | 47 | 21.4688 | 17.3 | 0.088861 | 0.838011 | 0.02 | 75 | 135 | 78 |
| 2019-07-24 | Brooklyn | 1922 | 1239 | 17.2256 | 13.95 | -0.010769 | 0.471522 | 0.02 | 75 | 319 | 135 |
| 2019-07-24 | EWR | 1 | 1 | 0.1833 | 0.1833 | -0.405465 | null | 0.02 | 75 | null | 0 |
| 2019-07-24 | Manhattan | 200515 | 198567 | 14.0155 | 11.7333 | 0.034357 | 0.382972 | 0.02 | 75 | 387 | 81 |
| 2019-07-24 | Queens | 14724 | 14024 | 33.7101 | 32.7667 | 0.0435 | 0.354281 | 0.02 | 75 | 218 | 117 |
| 2019-07-24 | Staten Island | 6 | 2 | 53.425 | 38.4833 | 0.193234 | 0.264009 | 0.02 | 75 | 44 | 11 |
| 2019-07-25 | Bronx | 227 | 43 | 23.0521 | 19.45 | -0.006835 | 0.696526 | 0 | 77 | 138 | 68 |