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 |
|---|---|---|---|---|---|---|---|
| 128 | 213 | 4 | 19.892 | 20.212 | 8.842 | 26.5 | 26.16 |
| 147 | 255 | 4 | 36.592 | 37.35 | 12.19 | 39.25 | 19.66 |
| 200 | 129 | 4 | 36.675 | 35.558 | 13.59 | 40 | 24.57 |
| 193 | 55 | 4 | 64.983 | 60.712 | 24.227 | 87.12 | 26.65 |
| 112 | 130 | 4 | 23.567 | 23.408 | 10.402 | 30.62 | 27.11 |
| 189 | 151 | 4 | 36.908 | 37.646 | 11.67 | 37.25 | 18.87 |
| 252 | 192 | 4 | 18.925 | 17.808 | 4.755 | 17.75 | 16.44 |
| 228 | 247 | 4 | 51.333 | 50.296 | 17.352 | 51.25 | 21.36 |
| 8 | 13 | 4 | 26.417 | 31.25 | 12.508 | 44.75 | 28.65 |
| 175 | 112 | 4 | 47.733 | 47.817 | 14.447 | 45.9 | 20.46 |
| 38 | 232 | 4 | 46.033 | 47.729 | 22.117 | 61.25 | 32.72 |
| 87 | 187 | 4 | 32.058 | 31.179 | 16.71 | 46.88 | 32.77 |
| 123 | 49 | 4 | 37.975 | 42.308 | 9.043 | 33.14 | 12.86 |
| 79 | 5 | 4 | 48.092 | 50.233 | 27.083 | 82.88 | 33.44 |
| 197 | 45 | 4 | 40.808 | 42.583 | 16.18 | 52.55 | 23.96 |
| 112 | 29 | 4 | 39.583 | 47.696 | 15.058 | 49 | 26.87 |
| 258 | 71 | 4 | 29.2 | 33.121 | 6.035 | 25.12 | 11.32 |
| 124 | 28 | 4 | 25.758 | 25.163 | 6.748 | 23.25 | 16.38 |
| 25 | 167 | 4 | 42.467 | 46.529 | 16.71 | 50.75 | 22.04 |
| 256 | 247 | 4 | 22.65 | 25.825 | 11.793 | 34 | 30.47 |
| 174 | 107 | 4 | 44.433 | 40.75 | 12.915 | 40.75 | 18.38 |
| 248 | 88 | 4 | 58.967 | 58.021 | 14.337 | 44.88 | 15.08 |
| 7 | 118 | 4 | 62.917 | 63.104 | 29.938 | 84.25 | 28.51 |
| 249 | 184 | 4 | 41.725 | 43.779 | 17.407 | 51.62 | 25.91 |
| 192 | 93 | 4 | 7.217 | 8.167 | 2.393 | 9.38 | 17.85 |