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 |
|---|---|---|---|---|---|---|---|
| 127 | 246 | 59 | 19.833 | 22.827 | 9.471 | 29.05 | 27.68 |
| 152 | 148 | 59 | 31.883 | 33.9 | 9.647 | 32.58 | 18.13 |
| 33 | 223 | 59 | 23.633 | 25.362 | 10.494 | 31.11 | 26.68 |
| 262 | 60 | 59 | 17.733 | 19.663 | 6.553 | 21.69 | 21.84 |
| 229 | 155 | 59 | 50.383 | 51.588 | 20.732 | 60.06 | 25.39 |
| 123 | 91 | 59 | 18.483 | 18.233 | 2.979 | 14.17 | 9.95 |
| 144 | 200 | 59 | 36.2 | 40.177 | 15.224 | 46.24 | 24.42 |
| 61 | 217 | 59 | 12.55 | 15.306 | 2.635 | 12.53 | 12 |
| 155 | 149 | 59 | 12.767 | 13.488 | 2.27 | 11.18 | 10.51 |
| 246 | 71 | 59 | 40.767 | 43.588 | 11.073 | 37.87 | 15.91 |
| 181 | 43 | 59 | 34.767 | 36.635 | 10.275 | 34.31 | 17.7 |
| 113 | 102 | 59 | 35.65 | 37.906 | 9.128 | 32.01 | 15.55 |
| 177 | 49 | 59 | 18.883 | 20.805 | 3.789 | 16.72 | 11.37 |
| 203 | 218 | 59 | 12.433 | 13.221 | 3.129 | 12.76 | 15.09 |
| 119 | 161 | 59 | 19.583 | 24.918 | 8.091 | 26.3 | 22.18 |
| 215 | 166 | 59 | 38.95 | 39.216 | 14.903 | 51.96 | 24.17 |
| 148 | 155 | 59 | 39.183 | 39.337 | 14.038 | 42.86 | 22.16 |
| 170 | 47 | 59 | 35.033 | 36.973 | 9.877 | 33.16 | 18.14 |
| 76 | 181 | 59 | 39.583 | 40.748 | 7.165 | 28.49 | 10.81 |
| 209 | 139 | 59 | 80.717 | 81.287 | 24.596 | 74.24 | 19.02 |
| 37 | 231 | 59 | 23.817 | 27.496 | 5.305 | 21.78 | 12.93 |
| 260 | 102 | 59 | 19.767 | 20.546 | 4.759 | 17.96 | 14.42 |
| 225 | 68 | 59 | 42.633 | 42.997 | 7.871 | 29.46 | 11.63 |
| 148 | 242 | 59 | 32.7 | 33.749 | 14.384 | 41.92 | 26.38 |
| 223 | 246 | 59 | 37.7 | 37.886 | 9.305 | 34.25 | 15.18 |