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 |
|---|---|---|---|---|---|---|---|
| 169 | 42 | 88 | 19.333 | 20.712 | 4.133 | 17.33 | 13.57 |
| 242 | 213 | 88 | 15.742 | 17.48 | 3.653 | 15.51 | 13.04 |
| 132 | 111 | 88 | 40.283 | 43.293 | 24.03 | 65.64 | 35.54 |
| 61 | 257 | 88 | 17.825 | 17.595 | 3.303 | 14.33 | 11.74 |
| 87 | 56 | 88 | 33.458 | 34.918 | 11.979 | 36.94 | 21.64 |
| 98 | 28 | 88 | 11.325 | 12.601 | 2.516 | 11.44 | 12.46 |
| 231 | 147 | 88 | 42.567 | 45.512 | 12.576 | 41.56 | 18.31 |
| 239 | 160 | 88 | 37.067 | 38.667 | 9.528 | 33.58 | 15.33 |
| 142 | 165 | 88 | 48.867 | 52.526 | 13.824 | 46.47 | 16.86 |
| 100 | 63 | 88 | 48.125 | 49.474 | 12.646 | 43.38 | 16.78 |
| 186 | 77 | 88 | 53.317 | 52.728 | 13.637 | 46.43 | 16.51 |
| 113 | 159 | 88 | 30.1 | 34.162 | 9.048 | 30.6 | 17.91 |
| 239 | 185 | 88 | 33.075 | 33.737 | 12.532 | 38.01 | 24.4 |
| 262 | 208 | 88 | 22.3 | 24.288 | 9.554 | 29.14 | 26.21 |
| 216 | 39 | 88 | 20.417 | 23.428 | 7.247 | 24.53 | 21.47 |
| 10 | 224 | 88 | 38.708 | 40.397 | 14.835 | 52 | 24 |
| 107 | 147 | 88 | 26.175 | 28.925 | 8.693 | 28.6 | 20.07 |
| 49 | 113 | 88 | 23.15 | 23.585 | 4.724 | 19.03 | 12.13 |
| 158 | 177 | 87 | 36.567 | 39.5 | 8.928 | 32.33 | 14.14 |
| 65 | 85 | 87 | 23.267 | 25.586 | 4.833 | 20.36 | 12.29 |
| 98 | 135 | 87 | 16.167 | 16.834 | 3.525 | 14.83 | 13.2 |
| 236 | 259 | 87 | 29.533 | 32.104 | 11.732 | 35.8 | 23.87 |
| 119 | 235 | 87 | 7.417 | 8.529 | 1.591 | 9.16 | 14.79 |
| 262 | 228 | 87 | 29.417 | 31.705 | 12.306 | 36.68 | 24.56 |
| 164 | 73 | 87 | 27.417 | 31.092 | 12.233 | 37.01 | 25.01 |