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-12 | Manhattan | 185589 | 183426 | 14.2137 | 11.4 | 0.042883 | 0.419335 | 0 | 79.5 | 318 | 108 |
| 2019-07-12 | Queens | 16502 | 15606 | 35.7452 | 32.5833 | 0.098624 | 0.396774 | 0 | 79.5 | 208 | 133 |
| 2019-07-12 | Staten Island | 5 | 2 | 55.59 | 62.55 | 0.229579 | 0.247783 | 0 | 79.5 | 34 | 10 |
| 2019-07-13 | Bronx | 292 | 59 | 17.5882 | 13.925 | 0.073793 | 0.568125 | 0 | 77.5 | 217 | 60 |
| 2019-07-13 | Brooklyn | 3237 | 1951 | 17.092 | 14.5667 | 0.021754 | 0.470335 | 0 | 77.5 | 430 | 113 |
| 2019-07-13 | EWR | 1 | 1 | 0.15 | 0.15 | -0.606136 | null | 0 | 77.5 | null | 0 |
| 2019-07-13 | Manhattan | 184141 | 180516 | 13.3657 | 10.9833 | -0.054007 | 0.429825 | 0 | 77.5 | 416 | 60 |
| 2019-07-13 | Queens | 12435 | 11369 | 29.0439 | 27.65 | -0.055137 | 0.414372 | 0 | 77.5 | 397 | 100 |
| 2019-07-13 | Staten Island | 4 | 0 | 74.0958 | 75.1083 | null | null | 0 | 77.5 | 53 | 13 |
| 2019-07-14 | Bronx | 319 | 50 | 17.2218 | 14.05 | 0.00883 | 0.515027 | 0 | 82.5 | 145 | 53 |
| 2019-07-14 | Brooklyn | 2204 | 1289 | 14.9339 | 12.625 | -0.070341 | 0.442543 | 0 | 82.5 | 333 | 110 |
| 2019-07-14 | EWR | 2 | 0 | 42.2333 | 42.2333 | null | null | 0 | 82.5 | null | 0 |
| 2019-07-14 | Manhattan | 148643 | 146070 | 11.3515 | 9.45 | -0.19675 | 0.396878 | 0 | 82.5 | 361 | 43 |
| 2019-07-14 | Queens | 15604 | 14717 | 30.8444 | 28.85 | -0.042861 | 0.396136 | 0 | 82.5 | 315 | 102 |
| 2019-07-14 | Staten Island | 11 | 2 | 38.4727 | 29.2167 | 0.282951 | 0.40948 | 0 | 82.5 | 50 | 5 |
| 2019-07-15 | Bronx | 234 | 43 | 20.4134 | 15.075 | -0.1957 | 0.814325 | 0 | 76.5 | 118 | 78 |
| 2019-07-15 | Brooklyn | 1650 | 1050 | 17.5263 | 14.3 | -0.03261 | 0.424338 | 0 | 76.5 | 288 | 131 |
| 2019-07-15 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.139434 | null | 0 | 76.5 | null | 0 |
| 2019-07-15 | Manhattan | 169995 | 168279 | 12.7644 | 10.5833 | -0.064391 | 0.379652 | 0 | 76.5 | 318 | 86 |
| 2019-07-15 | Queens | 16041 | 15296 | 33.311 | 32.3833 | -0.023392 | 0.331807 | 0 | 76.5 | 196 | 123 |
| 2019-07-15 | Staten Island | 9 | 0 | 37.5074 | 20.8667 | null | null | 0 | 76.5 | 36 | 15 |
| 2019-07-16 | Bronx | 244 | 39 | 24.8328 | 18.975 | -0.113584 | 0.919688 | 0 | 81.5 | 136 | 75 |
| 2019-07-16 | Brooklyn | 1893 | 1254 | 17.4535 | 14.8 | -0.035527 | 0.457381 | 0 | 81.5 | 300 | 140 |
| 2019-07-16 | Manhattan | 199874 | 198029 | 13.6486 | 11.3 | 0.018482 | 0.396733 | 0 | 81.5 | 356 | 100 |
| 2019-07-16 | Queens | 14587 | 13801 | 34.5214 | 33.35 | 0.037446 | 0.343562 | 0 | 81.5 | 216 | 130 |