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-10 | Staten Island | 4 | 1 | 54.65 | 54.85 | -0.256182 | null | 0.01 | 71 | 18 | 7 |
| 2019-09-11 | Bronx | 189 | 48 | 19.6064 | 15.4833 | -0.057838 | 0.589921 | 0 | 78.5 | 71 | 62 |
| 2019-09-11 | Brooklyn | 2001 | 1392 | 17.2747 | 14.35 | 0.030327 | 0.461718 | 0 | 78.5 | 177 | 132 |
| 2019-09-11 | EWR | 1 | 1 | 0.1333 | 0.1333 | -0.446287 | null | 0 | 78.5 | null | 0 |
| 2019-09-11 | Manhattan | 213488 | 211742 | 13.8223 | 11.5333 | 0.043072 | 0.395678 | 0 | 78.5 | 259 | 96 |
| 2019-09-11 | Queens | 13128 | 12481 | 33.7234 | 32.7667 | 0.031936 | 0.383014 | 0 | 78.5 | 140 | 108 |
| 2019-09-11 | Staten Island | 4 | 2 | 62.7333 | 70.9917 | -0.027906 | 0.032638 | 0 | 78.5 | 17 | 9 |
| 2019-09-12 | Bronx | 198 | 40 | 19.6529 | 14.85 | -0.077783 | 0.796773 | 0.17 | 71 | 72 | 74 |
| 2019-09-12 | Brooklyn | 2180 | 1529 | 17.0882 | 13.9417 | 0.030571 | 0.420918 | 0.17 | 71 | 160 | 162 |
| 2019-09-12 | EWR | 4 | 3 | 7.7917 | 5.5 | 1.173618 | 2.392515 | 0.17 | 71 | null | 0 |
| 2019-09-12 | Manhattan | 228166 | 226224 | 14.9903 | 12.3667 | 0.124037 | 0.397736 | 0.17 | 71 | 301 | 106 |
| 2019-09-12 | Queens | 14799 | 14244 | 39.1118 | 38.1833 | 0.145761 | 0.381288 | 0.17 | 71 | 127 | 122 |
| 2019-09-12 | Staten Island | 5 | 2 | 67.08 | 64.3167 | -0.060898 | 0.000537 | 0.17 | 71 | 19 | 12 |
| 2019-09-13 | Bronx | 225 | 45 | 22.2801 | 17.8 | 0.231403 | 0.510605 | 0 | 64.5 | 75 | 79 |
| 2019-09-13 | Brooklyn | 2310 | 1555 | 17.7067 | 14.475 | 0.042586 | 0.474592 | 0 | 64.5 | 143 | 139 |
| 2019-09-13 | EWR | 1 | 1 | 0.6333 | 0.6333 | 1.111858 | null | 0 | 64.5 | null | 0 |
| 2019-09-13 | Manhattan | 213222 | 211024 | 14.3974 | 11.9 | 0.07649 | 0.388848 | 0 | 64.5 | 272 | 95 |
| 2019-09-13 | Queens | 14793 | 14124 | 39.448 | 37.4333 | 0.154752 | 0.388069 | 0 | 64.5 | 136 | 120 |
| 2019-09-13 | Staten Island | 3 | 2 | 58.8944 | 59.95 | -0.024559 | 0.041037 | 0 | 64.5 | 14 | 12 |
| 2019-09-14 | Bronx | 210 | 40 | 16.1185 | 12.6333 | 0.060754 | 0.639992 | 0 | 67.5 | 126 | 53 |
| 2019-09-14 | Brooklyn | 2814 | 1792 | 15.9431 | 14.0833 | 0.011432 | 0.49468 | 0 | 67.5 | 356 | 105 |
| 2019-09-14 | EWR | 3 | 2 | 0.1944 | 0.2167 | -0.202733 | 0.233334 | 0 | 67.5 | null | 0 |
| 2019-09-14 | Manhattan | 202387 | 199682 | 13.2353 | 11.0667 | -0.009038 | 0.421172 | 0 | 67.5 | 378 | 75 |
| 2019-09-14 | Queens | 12071 | 11253 | 29.6574 | 29.0167 | -0.084035 | 0.399778 | 0 | 67.5 | 264 | 100 |
| 2019-09-14 | Staten Island | 7 | 0 | 47.9214 | 54.1333 | null | null | 0 | 67.5 | 37 | 9 |