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 |
|---|---|---|---|---|---|---|---|
| 228 | 237 | 7 | 32.85 | 33.671 | 9.51 | 30.78 | 16.83 |
| 74 | 117 | 7 | 67.95 | 65.45 | 26.971 | 75.88 | 25.01 |
| 248 | 39 | 7 | 36.683 | 38.04 | 18.461 | 52.14 | 29.23 |
| 1 | 138 | 7 | 60.767 | 65.688 | 29.69 | 84.71 | 30.91 |
| 197 | 89 | 7 | 50.7 | 49.31 | 13.85 | 47.14 | 19.72 |
| 123 | 143 | 7 | 67.133 | 64.917 | 13.534 | 44.22 | 12.87 |
| 158 | 73 | 7 | 34.783 | 37.798 | 13.567 | 41.29 | 23.1 |
| 14 | 56 | 7 | 60.383 | 63.21 | 18.943 | 57.29 | 19.07 |
| 5 | 234 | 7 | 90.383 | 89.681 | 28.374 | 86.57 | 19.21 |
| 139 | 141 | 7 | 50.55 | 58.731 | 20.99 | 60.7 | 22.95 |
| 37 | 215 | 7 | 37.567 | 41.021 | 10.673 | 36.05 | 16.33 |
| 16 | 161 | 7 | 59.133 | 52.831 | 13.15 | 44.05 | 14.21 |
| 155 | 189 | 7 | 23.1 | 23.714 | 5.783 | 21.07 | 15.05 |
| 153 | 170 | 7 | 31.683 | 38.667 | 12.344 | 35.61 | 19.99 |
| 257 | 144 | 7 | 26.1 | 27.481 | 6.803 | 24.86 | 16.74 |
| 145 | 207 | 7 | 21.933 | 30.374 | 9.526 | 33 | 22.08 |
| 174 | 233 | 7 | 44.767 | 45.683 | 13.819 | 42.64 | 19.57 |
| 164 | 176 | 7 | 51.117 | 53.336 | 20.506 | 59.64 | 23.46 |
| 159 | 129 | 7 | 30.817 | 27.476 | 7.514 | 25.93 | 17.88 |
| 171 | 148 | 7 | 50.083 | 50.607 | 13.881 | 46.57 | 16.93 |
| 36 | 91 | 7 | 33.65 | 39.019 | 7.621 | 30.57 | 12.41 |
| 135 | 205 | 7 | 24.533 | 22.29 | 5.224 | 19.84 | 14.46 |
| 89 | 193 | 7 | 45.367 | 48.595 | 13.449 | 41.48 | 16.95 |
| 247 | 256 | 7 | 30.95 | 35.31 | 11.903 | 37.36 | 22.09 |
| 7 | 133 | 7 | 36.483 | 36.276 | 14.124 | 41.21 | 25.11 |