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 |
|---|---|---|---|---|---|---|---|
| 180 | 91 | 5 | 32 | 30.543 | 8.686 | 27.19 | 17.47 |
| 66 | 180 | 5 | 40.683 | 43.817 | 18.582 | 57.6 | 26.01 |
| 208 | 116 | 5 | 29.233 | 29.003 | 9.082 | 34.6 | 20.44 |
| 177 | 40 | 5 | 33.4 | 31.95 | 5.392 | 21.95 | 10.8 |
| 136 | 121 | 5 | 41.083 | 38.22 | 16.284 | 45.67 | 26.52 |
| 200 | 144 | 5 | 43.95 | 46.693 | 14.86 | 47 | 19.46 |
| 88 | 122 | 5 | 63.533 | 57.303 | 19.144 | 53.52 | 20.99 |
| 117 | 77 | 5 | 36.95 | 37.077 | 11.27 | 35.53 | 18.56 |
| 197 | 240 | 5 | 44.917 | 47.65 | 20.15 | 57.7 | 25.89 |
| 27 | 210 | 5 | 22.767 | 23.33 | 8.004 | 24.8 | 20.67 |
| 65 | 122 | 5 | 52.3 | 51.64 | 17.132 | 52.8 | 22 |
| 257 | 76 | 5 | 44.167 | 41.72 | 6.83 | 27.82 | 10.63 |
| 89 | 247 | 5 | 42.167 | 45.383 | 19.064 | 54.27 | 26.95 |
| 123 | 37 | 5 | 51.467 | 48.027 | 9.676 | 37.5 | 13.47 |
| 216 | 171 | 5 | 33.833 | 32.963 | 10.48 | 33.14 | 19.3 |
| 212 | 151 | 5 | 25.3 | 27.45 | 9.45 | 29.7 | 20.86 |
| 261 | 175 | 5 | 32.317 | 34.127 | 16.856 | 47.2 | 30.26 |
| 139 | 9 | 5 | 24.85 | 25.61 | 8.946 | 28.2 | 21.74 |
| 94 | 236 | 5 | 40.6 | 40.393 | 8.184 | 32 | 12.86 |
| 24 | 55 | 5 | 61.017 | 59.643 | 22.22 | 66.1 | 22.98 |
| 149 | 124 | 5 | 32.767 | 36.483 | 11.592 | 36.8 | 20.6 |
| 147 | 182 | 5 | 19.267 | 20.237 | 4.062 | 16.7 | 12.28 |
| 255 | 206 | 5 | 29.583 | 30.317 | 17.018 | 46.4 | 33.7 |
| 3 | 140 | 5 | 47.05 | 51.19 | 12.298 | 35.87 | 18.19 |
| 227 | 85 | 5 | 25.65 | 27.097 | 4.562 | 20.1 | 10.25 |