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 |
|---|---|---|---|---|---|---|---|
| 94 | 136 | 38 | 8.467 | 9.224 | 0.967 | 8.53 | 7.37 |
| 35 | 246 | 38 | 61.242 | 59.096 | 10.723 | 43.62 | 11.14 |
| 163 | 192 | 38 | 34.108 | 35.396 | 11.411 | 36.7 | 20.33 |
| 92 | 134 | 38 | 17.233 | 20.267 | 5.332 | 19.38 | 17.56 |
| 97 | 67 | 38 | 23.075 | 23.916 | 6.951 | 23.86 | 18.5 |
| 191 | 38 | 38 | 7.208 | 10.11 | 1.871 | 9.78 | 14.4 |
| 217 | 137 | 38 | 27.883 | 27.368 | 4.716 | 19.73 | 11.03 |
| 211 | 212 | 38 | 25.342 | 31.585 | 12.253 | 37.37 | 26.52 |
| 181 | 244 | 38 | 43.592 | 44.196 | 15.833 | 47.49 | 22.87 |
| 50 | 94 | 38 | 29.675 | 33.492 | 10.25 | 33.7 | 21.26 |
| 80 | 35 | 38 | 27 | 31.219 | 5.007 | 22.28 | 10.52 |
| 49 | 237 | 38 | 34.892 | 36.574 | 9.152 | 31.76 | 15.73 |
| 71 | 37 | 38 | 24.65 | 26.208 | 4.256 | 18.81 | 10.28 |
| 162 | 153 | 38 | 29.725 | 34.926 | 11.346 | 35.9 | 23 |
| 136 | 69 | 38 | 16.842 | 20.799 | 4.215 | 17.55 | 13.67 |
| 168 | 32 | 38 | 20.542 | 25.169 | 7.144 | 24.9 | 19.76 |
| 8 | 8 | 38 | 9.392 | 13.421 | 3.624 | 13.64 | 14.11 |
| 261 | 126 | 38 | 35.292 | 37.172 | 12.943 | 39.97 | 22.66 |
| 144 | 16 | 38 | 39.925 | 40.491 | 17.132 | 50.1 | 27.17 |
| 71 | 197 | 38 | 35.233 | 35.8 | 12.205 | 38.52 | 21.4 |
| 171 | 261 | 38 | 85.408 | 85.536 | 18.933 | 72.79 | 13.58 |
| 7 | 247 | 38 | 22.467 | 28.235 | 7.218 | 24.85 | 18.69 |
| 224 | 198 | 38 | 26.267 | 28.115 | 7.053 | 25.28 | 16.14 |
| 223 | 14 | 38 | 38.333 | 43.261 | 17.294 | 50.35 | 27.1 |
| 197 | 92 | 38 | 15.525 | 17.111 | 6.184 | 20.39 | 22.99 |