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-03-12 | Bronx | 408 | 66 | 28.4519 | 23.9833 | 0.056619 | 0.431393 | 0 | 39 | 16 | 69 |
| 2019-03-12 | Brooklyn | 2477 | 1551 | 19.2255 | 15.05 | -0.035833 | 0.467007 | 0 | 39 | 25 | 128 |
| 2019-03-12 | EWR | 1 | 1 | 0.1667 | 0.1667 | -0.587787 | null | 0 | 39 | null | 0 |
| 2019-03-12 | Manhattan | 234702 | 232241 | 13.0497 | 10.8667 | -0.002369 | 0.385133 | 0 | 39 | 78 | 85 |
| 2019-03-12 | Queens | 15438 | 14633 | 32.8049 | 31.55 | -0.022557 | 0.331655 | 0 | 39 | 14 | 108 |
| 2019-03-12 | Staten Island | 5 | 3 | 40.5433 | 52.05 | -0.034426 | 0.140467 | 0 | 39 | 4 | 15 |
| 2019-03-13 | Bronx | 441 | 81 | 28.2545 | 24.9 | -0.11585 | 0.769112 | 0 | 40.5 | 10 | 58 |
| 2019-03-13 | Brooklyn | 2702 | 1642 | 19.9911 | 15.3417 | -0.02534 | 0.458138 | 0 | 40.5 | 25 | 122 |
| 2019-03-13 | Manhattan | 237008 | 234409 | 13.354 | 11.05 | 0.008102 | 0.378851 | 0 | 40.5 | 79 | 73 |
| 2019-03-13 | Queens | 15811 | 14955 | 33.3563 | 31.95 | -0.021795 | 0.327106 | 0 | 40.5 | 9 | 99 |
| 2019-03-13 | Staten Island | 6 | 2 | 42.5667 | 37.4833 | -0.056421 | 0.064538 | 0 | 40.5 | 4 | 13 |
| 2019-03-14 | Bronx | 488 | 73 | 27.7592 | 24.95 | -0.032121 | 0.584984 | 0 | 49.5 | 15 | 58 |
| 2019-03-14 | Brooklyn | 3113 | 1858 | 20.3618 | 16.0833 | -0.023006 | 0.469107 | 0 | 49.5 | 21 | 114 |
| 2019-03-14 | EWR | 1 | 1 | 0.3333 | 0.3333 | 0.287682 | null | 0 | 49.5 | null | 0 |
| 2019-03-14 | Manhattan | 244929 | 242045 | 13.8917 | 11.4167 | 0.032532 | 0.385287 | 0 | 49.5 | 80 | 100 |
| 2019-03-14 | Queens | 15738 | 14790 | 34.6572 | 33.8667 | 0.028087 | 0.35473 | 0 | 49.5 | 13 | 120 |
| 2019-03-14 | Staten Island | 9 | 2 | 47.2019 | 64.6833 | -0.01766 | 0.191865 | 0 | 49.5 | 5 | 9 |
| 2019-03-15 | Bronx | 502 | 92 | 26.4887 | 21.9167 | 0.006529 | 0.500821 | 0.39 | 62 | 13 | 70 |
| 2019-03-15 | Brooklyn | 3580 | 2247 | 19.2714 | 14.75 | 0.004963 | 0.43276 | 0.39 | 62 | 22 | 141 |
| 2019-03-15 | EWR | 1 | 0 | 0.2 | 0.2 | null | null | 0.39 | 62 | null | 0 |
| 2019-03-15 | Manhattan | 249192 | 245967 | 13.5186 | 11.05 | 0.021744 | 0.388409 | 0.39 | 62 | 72 | 82 |
| 2019-03-15 | Queens | 15305 | 14285 | 36.5817 | 35.9333 | 0.093083 | 0.368666 | 0.39 | 62 | 12 | 115 |
| 2019-03-15 | Staten Island | 5 | 2 | 45.5067 | 59.5833 | -0.105901 | 0.200509 | 0.39 | 62 | 3 | 19 |
| 2019-03-16 | Bronx | 412 | 61 | 19.1059 | 16.0833 | -0.008598 | 0.631302 | 0 | 47.5 | 13 | 61 |
| 2019-03-16 | Brooklyn | 3762 | 2196 | 16.3977 | 13.7 | -0.018273 | 0.426403 | 0 | 47.5 | 23 | 96 |