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 |
|---|---|---|---|---|---|---|---|
| 135 | 236 | 42 | 39.658 | 42.822 | 13.168 | 41.87 | 20.49 |
| 247 | 51 | 42 | 23.592 | 27.502 | 9.723 | 30.62 | 24.7 |
| 166 | 228 | 42 | 39.908 | 43.485 | 14.377 | 44.71 | 20.85 |
| 68 | 9 | 42 | 37.167 | 40.154 | 14.456 | 44.44 | 22.87 |
| 249 | 180 | 42 | 39.383 | 42.904 | 14.782 | 45.69 | 21.7 |
| 261 | 173 | 42 | 34 | 34.936 | 12.941 | 39.37 | 22.82 |
| 35 | 74 | 42 | 53.575 | 54.353 | 17.685 | 54.65 | 21.69 |
| 151 | 139 | 42 | 76.45 | 75.577 | 22.499 | 71.36 | 19.24 |
| 196 | 121 | 42 | 12.825 | 14.107 | 4.512 | 15.7 | 21.95 |
| 89 | 166 | 42 | 38.35 | 40.605 | 14.107 | 41.88 | 21.32 |
| 107 | 63 | 42 | 45.917 | 47.875 | 12.803 | 43.11 | 17.68 |
| 257 | 25 | 42 | 16.492 | 18.519 | 3.317 | 14.8 | 12.33 |
| 211 | 71 | 42 | 33.758 | 35.701 | 8.33 | 29.85 | 14.69 |
| 102 | 160 | 42 | 9.208 | 9.719 | 1.887 | 8.81 | 11.74 |
| 155 | 55 | 42 | 20.717 | 23.015 | 6.948 | 23.21 | 19.11 |
| 238 | 85 | 42 | 52.508 | 55.053 | 14.66 | 47.95 | 16.96 |
| 210 | 65 | 42 | 39.2 | 40.279 | 12.437 | 38.07 | 19.01 |
| 231 | 47 | 42 | 47.358 | 48.202 | 14.503 | 45.82 | 19.58 |
| 114 | 121 | 42 | 33.975 | 34.428 | 13.288 | 40 | 24.34 |
| 193 | 28 | 42 | 27.608 | 29.467 | 10.877 | 33.64 | 23.31 |
| 95 | 157 | 42 | 15.367 | 18.455 | 4.208 | 16.59 | 14.85 |
| 75 | 196 | 42 | 36.683 | 38.223 | 10.35 | 34.7 | 18.03 |
| 143 | 208 | 42 | 32.858 | 35.872 | 13.565 | 40.14 | 24.73 |
| 50 | 258 | 42 | 40.417 | 42.796 | 12.717 | 41.56 | 18.53 |
| 70 | 252 | 42 | 12.083 | 12.348 | 5.167 | 16.84 | 28.78 |