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 |
|---|---|---|---|---|---|---|---|
| 135 | 148 | 35 | 37.983 | 40.278 | 12.547 | 38.86 | 20.49 |
| 235 | 263 | 35 | 29.167 | 30.76 | 6.827 | 25.7 | 15.29 |
| 51 | 208 | 35 | 12.433 | 14.368 | 4.691 | 16.29 | 21.08 |
| 65 | 108 | 35 | 30.533 | 32.108 | 12.495 | 37.77 | 25.55 |
| 66 | 42 | 35 | 28.3 | 32.36 | 11.889 | 36.16 | 24.51 |
| 70 | 233 | 35 | 21.9 | 24.386 | 8.813 | 28.17 | 23.27 |
| 100 | 64 | 35 | 32.35 | 35.307 | 16.997 | 48.76 | 30.41 |
| 254 | 173 | 35 | 59.217 | 57.873 | 12.295 | 46.24 | 13.32 |
| 116 | 182 | 35 | 24.417 | 25.415 | 7.256 | 24.45 | 17.91 |
| 175 | 92 | 35 | 19.233 | 26.171 | 7.263 | 25.19 | 17.22 |
| 189 | 232 | 35 | 16.7 | 18.824 | 4.11 | 17.6 | 13.93 |
| 121 | 9 | 35 | 9.933 | 12.274 | 2.375 | 10.89 | 12.13 |
| 37 | 92 | 35 | 30.15 | 30.674 | 9.088 | 29.05 | 18.97 |
| 254 | 136 | 35 | 20.567 | 21.15 | 3.868 | 16.75 | 11.4 |
| 193 | 70 | 35 | 17.617 | 19.556 | 5.101 | 18.7 | 16.95 |
| 216 | 148 | 35 | 51.217 | 54.244 | 13.376 | 51.43 | 15.85 |
| 92 | 226 | 35 | 20.417 | 23.923 | 7.5 | 24.76 | 20.41 |
| 44 | 135 | 35 | 67.05 | 72.239 | 39.607 | 107.44 | 34.59 |
| 239 | 34 | 34 | 42.317 | 40.377 | 10.291 | 35.81 | 16.32 |
| 60 | 242 | 34 | 13.842 | 15.055 | 2.878 | 12.84 | 11.87 |
| 79 | 96 | 34 | 33.617 | 34.917 | 13.078 | 39.7 | 23.84 |
| 108 | 14 | 34 | 14.917 | 15.245 | 5.25 | 17.97 | 21.74 |
| 242 | 241 | 34 | 29.717 | 29.352 | 4.899 | 21.37 | 10.8 |
| 94 | 18 | 34 | 7.025 | 7.126 | 0.824 | 6.46 | 8.14 |
| 49 | 161 | 34 | 34.883 | 34.47 | 7.889 | 28.91 | 14.72 |