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-01-27 | Staten Island | 11 | 0 | 23.8152 | 16.95 | null | null | 0 | 40.5 | 7 | 6 |
| 2019-01-28 | Bronx | 473 | 64 | 25.0877 | 21.5 | -0.010131 | 0.801247 | 0 | 31.5 | 5 | 53 |
| 2019-01-28 | Brooklyn | 2214 | 1275 | 19.3217 | 15.4417 | -0.0314 | 0.480109 | 0 | 31.5 | 21 | 128 |
| 2019-01-28 | EWR | 1 | 1 | 0.15 | 0.15 | -0.693147 | null | 0 | 31.5 | null | 0 |
| 2019-01-28 | Manhattan | 206841 | 204492 | 11.4698 | 9.45 | -0.104014 | 0.403585 | 0 | 31.5 | 58 | 53 |
| 2019-01-28 | Queens | 15083 | 14201 | 30.002 | 28.95 | -0.118599 | 0.321231 | 0 | 31.5 | 11 | 97 |
| 2019-01-28 | Staten Island | 11 | 1 | 36.8697 | 35.3167 | 0.016041 | null | 0 | 31.5 | 1 | 19 |
| 2019-01-29 | Bronx | 467 | 73 | 27.4618 | 22.5667 | 0.104799 | 0.694043 | 0.23 | 34 | 4 | 78 |
| 2019-01-29 | Brooklyn | 2507 | 1515 | 20.1783 | 15.3333 | -0.028117 | 0.485233 | 0.23 | 34 | 25 | 138 |
| 2019-01-29 | EWR | 1 | 1 | 0.05 | 0.05 | -1.427116 | null | 0.23 | 34 | null | 0 |
| 2019-01-29 | Manhattan | 227189 | 224665 | 12.3501 | 10.25 | -0.020185 | 0.394275 | 0.23 | 34 | 56 | 103 |
| 2019-01-29 | Queens | 12598 | 11762 | 30.704 | 29.8 | -0.065436 | 0.344106 | 0.23 | 34 | 8 | 115 |
| 2019-01-29 | Staten Island | 4 | 2 | 25.9417 | 22.9167 | 0.072581 | 0.109886 | 0.23 | 34 | 1 | 21 |
| 2019-01-30 | Bronx | 433 | 77 | 26.4306 | 21.65 | 0.069549 | 0.575949 | 0.01 | 20.5 | 5 | 66 |
| 2019-01-30 | Brooklyn | 2677 | 1629 | 18.5299 | 14.2833 | -0.062673 | 0.498392 | 0.01 | 20.5 | 23 | 145 |
| 2019-01-30 | Manhattan | 243355 | 240806 | 12.204 | 10.0667 | -0.028892 | 0.400416 | 0.01 | 20.5 | 71 | 85 |
| 2019-01-30 | Queens | 11751 | 10846 | 29.2856 | 28 | -0.090888 | 0.384863 | 0.01 | 20.5 | 7 | 109 |
| 2019-01-30 | Staten Island | 11 | 3 | 31.8591 | 23.5 | 0.00024 | 0.097737 | 0.01 | 20.5 | 1 | 10 |
| 2019-01-31 | Bronx | 423 | 59 | 24.7436 | 20.15 | -0.159333 | 0.550415 | 0 | 9 | 6 | 67 |
| 2019-01-31 | Brooklyn | 2522 | 1651 | 19.1626 | 14.65 | -0.000725 | 0.508629 | 0 | 9 | 22 | 127 |
| 2019-01-31 | EWR | 1 | 1 | 0.1833 | 0.1833 | -0.952009 | null | 0 | 9 | null | 0 |
| 2019-01-31 | Manhattan | 247472 | 244952 | 12.5995 | 10.3 | -0.011413 | 0.406189 | 0 | 9 | 66 | 80 |
| 2019-01-31 | Queens | 13738 | 12909 | 30.3023 | 29.5 | -0.064509 | 0.397741 | 0 | 9 | 9 | 102 |
| 2019-01-31 | Staten Island | 9 | 3 | 33.8722 | 38.8833 | -0.101603 | 0.250747 | 0 | 9 | 1 | 7 |
| 2019-02-01 | Bronx | 590 | 82 | 24.6452 | 21.0833 | -0.097869 | 0.694872 | 0 | 16 | 4 | 74 |