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-12-27 | Bronx | 137 | 29 | 18.3159 | 12.8 | -0.174172 | 0.503086 | 0 | 50 | 3 | 0 |
| 2019-12-27 | Brooklyn | 1104 | 695 | 14.8492 | 12.325 | -0.105314 | 0.460738 | 0 | 50 | 4 | 0 |
| 2019-12-27 | Manhattan | 143712 | 142067 | 12.65 | 10.6667 | -0.079428 | 0.406927 | 0 | 50 | 43 | 0 |
| 2019-12-27 | Queens | 13732 | 13134 | 30.5231 | 28.7583 | -0.071972 | 0.361292 | 0 | 50 | 5 | 0 |
| 2019-12-27 | Staten Island | 9 | 1 | 52.0407 | 47.2 | 0.102415 | null | 0 | 50 | 5 | 0 |
| 2019-12-28 | Bronx | 169 | 38 | 16.5192 | 12.0167 | -0.267553 | 0.989891 | 0 | 47 | 5 | 0 |
| 2019-12-28 | Brooklyn | 1315 | 814 | 14.5489 | 12.5333 | -0.12153 | 0.491388 | 0 | 47 | 8 | 0 |
| 2019-12-28 | Manhattan | 147581 | 145514 | 12.9637 | 10.75 | -0.074703 | 0.452701 | 0 | 47 | 50 | 0 |
| 2019-12-28 | Queens | 12854 | 12191 | 28.399 | 26.2 | -0.110381 | 0.364134 | 0 | 47 | 11 | 0 |
| 2019-12-28 | Staten Island | 9 | 1 | 36.3556 | 40.7667 | -0.063605 | null | 0 | 47 | 5 | 0 |
| 2019-12-29 | Bronx | 185 | 28 | 16.3126 | 13.05 | -0.146444 | 0.755534 | 0.25 | 41.5 | 3 | 0 |
| 2019-12-29 | Brooklyn | 1394 | 850 | 14.6637 | 12.5583 | -0.113174 | 0.454191 | 0.25 | 41.5 | 9 | 0 |
| 2019-12-29 | EWR | 1 | 1 | 0.05 | 0.05 | -1.921813 | null | 0.25 | 41.5 | null | 0 |
| 2019-12-29 | Manhattan | 138492 | 136518 | 12.1464 | 10.0833 | -0.130501 | 0.426617 | 0.25 | 41.5 | 37 | 0 |
| 2019-12-29 | Queens | 14701 | 13943 | 28.7292 | 26.2667 | -0.118554 | 0.38279 | 0.25 | 41.5 | 10 | 0 |
| 2019-12-29 | Staten Island | 10 | 1 | 34.0633 | 37.1583 | -0.462747 | null | 0.25 | 41.5 | 3 | 0 |
| 2019-12-30 | Bronx | 142 | 21 | 19.6033 | 16.7583 | -0.217174 | 0.585565 | 0.74 | 39 | 2 | 0 |
| 2019-12-30 | Brooklyn | 1090 | 723 | 14.3083 | 11.8917 | -0.12954 | 0.520744 | 0.74 | 39 | 2 | 0 |
| 2019-12-30 | Manhattan | 148147 | 146775 | 12.0505 | 9.9833 | -0.091455 | 0.3983 | 0.74 | 39 | 39 | 0 |
| 2019-12-30 | Queens | 13872 | 13264 | 31.2497 | 29.35 | -0.037963 | 0.343672 | 0.74 | 39 | 5 | 0 |
| 2019-12-30 | Staten Island | 7 | 1 | 41.2071 | 42.55 | -0.318979 | null | 0.74 | 39 | 2 | 0 |
| 2019-12-31 | Bronx | 256 | 38 | 14.9738 | 13.175 | -0.293816 | 1.025927 | 0.02 | 40.5 | null | 0 |
| 2019-12-31 | Brooklyn | 1522 | 988 | 14.2974 | 12.2 | -0.167917 | 0.55721 | 0.02 | 40.5 | 2 | 0 |
| 2019-12-31 | Manhattan | 144242 | 142313 | 11.0454 | 9.0167 | -0.131234 | 0.431519 | 0.02 | 40.5 | 22 | 0 |
| 2019-12-31 | Queens | 10878 | 10182 | 25.4467 | 24.9667 | -0.173463 | 0.388619 | 0.02 | 40.5 | 2 | 0 |