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 |
|---|---|---|---|---|---|---|---|
| 145 | 82 | 466 | 16.717 | 18.253 | 4.327 | 16.56 | 15.21 |
| 140 | 220 | 466 | 31.867 | 34.249 | 10.426 | 33.86 | 20.37 |
| 79 | 157 | 466 | 21.317 | 23.088 | 7.103 | 24.01 | 19.91 |
| 140 | 257 | 465 | 27.983 | 30.199 | 11.836 | 35.45 | 25.76 |
| 74 | 248 | 465 | 15.783 | 18.013 | 5.547 | 18.98 | 20.18 |
| 50 | 61 | 464 | 40.025 | 42.621 | 9.589 | 34.7 | 14.24 |
| 262 | 152 | 464 | 20.175 | 20.937 | 4.221 | 17.22 | 12.88 |
| 209 | 145 | 464 | 21.142 | 22.429 | 7.267 | 23.79 | 20.5 |
| 132 | 23 | 464 | 48.9 | 54.288 | 28.248 | 77.08 | 34.12 |
| 74 | 147 | 463 | 13.317 | 14.629 | 3.214 | 13.27 | 14.33 |
| 97 | 113 | 463 | 17.05 | 18.276 | 3.725 | 15.56 | 12.81 |
| 179 | 170 | 463 | 18.317 | 20.716 | 4.49 | 17.51 | 14.65 |
| 132 | 221 | 463 | 43.717 | 46.87 | 24.191 | 65.91 | 33.34 |
| 4 | 17 | 463 | 19.617 | 20.929 | 4.562 | 18.07 | 13.7 |
| 223 | 75 | 463 | 13.017 | 15.851 | 5.345 | 33.33 | 24.34 |
| 132 | 94 | 463 | 46.867 | 50.818 | 22.054 | 62.92 | 28.44 |
| 125 | 52 | 462 | 19.133 | 19.738 | 3.99 | 15.9 | 12.77 |
| 65 | 237 | 462 | 24.192 | 25.787 | 7.307 | 24.72 | 18.3 |
| 75 | 213 | 461 | 19.1 | 21.875 | 6.613 | 22.19 | 20.47 |
| 263 | 25 | 461 | 25.55 | 27.407 | 9.29 | 29.19 | 21.91 |
| 88 | 243 | 461 | 33.1 | 37.279 | 13.422 | 40.74 | 24.36 |
| 113 | 95 | 461 | 32.733 | 35.243 | 10.564 | 34.5 | 19.3 |
| 24 | 113 | 461 | 30.133 | 31.103 | 6.482 | 25.19 | 13.25 |
| 4 | 138 | 461 | 25.517 | 27.813 | 10.813 | 32.89 | 25.5 |
| 88 | 42 | 460 | 25.892 | 28.45 | 10.922 | 32.98 | 25.75 |