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 |
|---|---|---|---|---|---|---|---|
| 163 | 174 | 82 | 31 | 33.176 | 13.811 | 41.18 | 26.97 |
| 263 | 195 | 82 | 27.375 | 27.897 | 10.812 | 32.29 | 24.32 |
| 35 | 91 | 82 | 17.3 | 17.634 | 3.26 | 14.58 | 11.49 |
| 127 | 241 | 82 | 11.342 | 11.565 | 2.111 | 10.14 | 11.75 |
| 163 | 131 | 82 | 39.467 | 42.093 | 13.886 | 43.32 | 21.08 |
| 93 | 88 | 82 | 29.375 | 31.913 | 13.555 | 51.75 | 27.31 |
| 233 | 155 | 82 | 48.692 | 50.715 | 17.991 | 53.46 | 22.22 |
| 41 | 250 | 82 | 19.683 | 22.141 | 7.303 | 23.69 | 21.58 |
| 138 | 118 | 82 | 57.125 | 60.027 | 23.994 | 68.62 | 26.39 |
| 262 | 212 | 82 | 18.317 | 20.022 | 6.744 | 22.01 | 22.3 |
| 36 | 79 | 82 | 20.675 | 21.894 | 5.265 | 19.49 | 15.02 |
| 142 | 51 | 82 | 36.217 | 40.383 | 16.472 | 48.35 | 26.38 |
| 247 | 230 | 82 | 36.342 | 37.074 | 7.885 | 30.43 | 13.93 |
| 249 | 213 | 82 | 30.525 | 33.876 | 12.867 | 38.71 | 24.78 |
| 45 | 168 | 82 | 25.525 | 29.77 | 9.853 | 30.63 | 23.25 |
| 163 | 71 | 82 | 56.8 | 57.596 | 13.59 | 46.98 | 15.09 |
| 113 | 28 | 82 | 38.917 | 41.951 | 13.3 | 41.81 | 20.6 |
| 3 | 51 | 82 | 12.425 | 13.457 | 2.268 | 11.36 | 10.95 |
| 65 | 39 | 82 | 39.95 | 42.029 | 10.814 | 37.4 | 16.71 |
| 7 | 171 | 82 | 19.2 | 21.789 | 7.25 | 23.76 | 21.84 |
| 239 | 20 | 82 | 29.017 | 31.204 | 10.434 | 33.02 | 21.79 |
| 260 | 50 | 82 | 23.2 | 27.445 | 5.978 | 33.08 | 14.52 |
| 113 | 126 | 82 | 28.108 | 30.821 | 10.199 | 32.27 | 21.62 |
| 247 | 254 | 82 | 19.017 | 22.396 | 7.667 | 24.35 | 22.69 |
| 189 | 133 | 82 | 13.567 | 14.871 | 3.446 | 13.62 | 14.48 |