Zone-to-zone routes
Every pickup zone to drop-off zone pair seen in 2019 with trips, median and mean minutes, distance, fare and speed.
45,836 rows · by trips ↓ Download CSV
| pu_idINTEGER | do_idINTEGER | tripsINTEGER | median_minREAL | mean_minREAL | mean_milesREAL | mean_fareREAL | mean_mphREAL |
|---|---|---|---|---|---|---|---|
| 40 | 161 | 391 | 26.667 | 28.462 | 8.275 | 27.55 | 18.86 |
| 261 | 95 | 391 | 33.983 | 36.91 | 12.931 | 39.56 | 22.6 |
| 255 | 68 | 390 | 25.567 | 27.685 | 5.537 | 21.99 | 12.72 |
| 7 | 164 | 390 | 20.475 | 23.049 | 4.793 | 19.03 | 13.93 |
| 193 | 230 | 390 | 16.483 | 19.464 | 3.843 | 16.88 | 13.42 |
| 226 | 56 | 390 | 18.05 | 19.292 | 4.675 | 17.79 | 15.96 |
| 66 | 211 | 390 | 14.4 | 15.803 | 2.828 | 13.42 | 11.49 |
| 140 | 160 | 389 | 33.083 | 33.786 | 7.591 | 28.17 | 14.53 |
| 162 | 216 | 389 | 42 | 44.311 | 14.522 | 49.14 | 22.83 |
| 125 | 116 | 389 | 27.65 | 29.39 | 8.89 | 29.48 | 18.94 |
| 157 | 132 | 389 | 29.633 | 32.743 | 11.663 | 51.94 | 25.99 |
| 170 | 165 | 389 | 42.717 | 45.185 | 13.178 | 42.4 | 18.63 |
| 186 | 159 | 388 | 31.95 | 34.084 | 8.584 | 30.39 | 18.07 |
| 100 | 217 | 388 | 36.033 | 37.245 | 6.337 | 27.76 | 10.89 |
| 88 | 95 | 388 | 32.542 | 35.688 | 12.984 | 39.17 | 23.48 |
| 166 | 87 | 388 | 34.767 | 35.815 | 9.404 | 32.56 | 16.61 |
| 141 | 49 | 388 | 30.55 | 31.51 | 8.8 | 29.66 | 17.65 |
| 82 | 160 | 388 | 7.692 | 8.534 | 1.674 | 8.36 | 12.58 |
| 25 | 148 | 388 | 12.858 | 13.429 | 2.945 | 12.73 | 14.07 |
| 76 | 35 | 388 | 14.242 | 15.327 | 2.398 | 12.02 | 9.71 |
| 42 | 186 | 387 | 28.617 | 31.208 | 6.941 | 26.3 | 14.67 |
| 231 | 82 | 387 | 30.733 | 32.571 | 9.855 | 32.28 | 19.66 |
| 144 | 217 | 387 | 15.333 | 17.071 | 2.866 | 14.24 | 11.69 |
| 161 | 159 | 387 | 24 | 25.338 | 6.515 | 22.75 | 16.2 |
| 262 | 255 | 387 | 25.15 | 26.586 | 7.22 | 25.06 | 17.19 |