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 |
|---|---|---|---|---|---|---|---|
| 33 | 74 | 86 | 28.583 | 31.539 | 10.809 | 33.49 | 22.37 |
| 193 | 255 | 86 | 16.333 | 17.104 | 3.411 | 14.34 | 12.26 |
| 50 | 56 | 86 | 36.9 | 38.247 | 10.338 | 35.47 | 17.55 |
| 170 | 167 | 86 | 26.908 | 29.559 | 8.366 | 27.93 | 18.62 |
| 170 | 98 | 86 | 29.658 | 32.303 | 12.217 | 36.65 | 24.72 |
| 95 | 233 | 86 | 23.375 | 26.131 | 8.522 | 28.9 | 22.2 |
| 140 | 252 | 86 | 33.342 | 36.815 | 13.672 | 41.2 | 24.25 |
| 227 | 26 | 86 | 10.317 | 11.59 | 1.419 | 9.18 | 8.06 |
| 179 | 43 | 86 | 19.092 | 21.912 | 4.666 | 18.44 | 14.28 |
| 261 | 157 | 86 | 29.092 | 30.025 | 9.303 | 30.07 | 19.94 |
| 48 | 219 | 86 | 54.042 | 56.111 | 17.653 | 54.77 | 20.95 |
| 29 | 210 | 86 | 9.133 | 9.44 | 1.738 | 8.68 | 11.15 |
| 80 | 89 | 86 | 23.05 | 25.118 | 8.562 | 27.69 | 22.53 |
| 233 | 130 | 86 | 34.625 | 37.175 | 13.728 | 41.16 | 23.83 |
| 56 | 229 | 86 | 19.225 | 20.94 | 8.059 | 51.51 | 25.07 |
| 229 | 182 | 86 | 29.717 | 31.475 | 10.407 | 32.74 | 21.42 |
| 65 | 197 | 86 | 29.408 | 31.415 | 13.143 | 39.2 | 27.45 |
| 90 | 185 | 86 | 41.925 | 42.441 | 15.148 | 45.37 | 22.48 |
| 161 | 15 | 86 | 36.65 | 39.344 | 15.832 | 46.82 | 25.73 |
| 41 | 25 | 86 | 38.85 | 40.302 | 11.885 | 38.31 | 18.67 |
| 141 | 47 | 86 | 27.183 | 28.908 | 7.576 | 26.33 | 17.36 |
| 78 | 42 | 86 | 21.275 | 22.405 | 5.495 | 20.54 | 15.93 |
| 249 | 92 | 86 | 38.2 | 42.172 | 13.945 | 44.15 | 21.77 |
| 148 | 213 | 86 | 28 | 30.724 | 13.157 | 38.64 | 27.7 |
| 66 | 217 | 86 | 12.267 | 12.813 | 2.614 | 11.66 | 13.59 |