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 |
|---|---|---|---|---|---|---|---|
| 227 | 61 | 17 | 37.133 | 38.515 | 6.133 | 27.13 | 10.45 |
| 63 | 89 | 17 | 37.433 | 40.606 | 7.888 | 30.85 | 12.29 |
| 239 | 55 | 17 | 61.617 | 57.924 | 20.098 | 60.47 | 21.93 |
| 238 | 22 | 17 | 45.333 | 50.133 | 17.854 | 54.32 | 22.7 |
| 102 | 157 | 17 | 15.2 | 16.19 | 2.808 | 12.94 | 10.75 |
| 32 | 42 | 17 | 35.6 | 36.333 | 8.601 | 29.91 | 15.51 |
| 18 | 243 | 17 | 19.15 | 21.098 | 3.42 | 15.62 | 10.46 |
| 242 | 247 | 17 | 37.117 | 34.31 | 7.595 | 28 | 14.31 |
| 48 | 156 | 17 | 50.5 | 49.903 | 22.2 | 63.29 | 28.47 |
| 45 | 78 | 17 | 46.7 | 50.25 | 14.192 | 45.9 | 19.39 |
| 200 | 153 | 17 | 11.517 | 11.388 | 2.541 | 10.71 | 13.76 |
| 212 | 244 | 17 | 24.133 | 26.638 | 6.092 | 22.41 | 16.34 |
| 159 | 262 | 17 | 13.867 | 14.655 | 4.024 | 14.68 | 17.4 |
| 261 | 47 | 17 | 45.983 | 50.403 | 14.231 | 45.31 | 19.51 |
| 109 | 109 | 17 | 6.067 | 12.295 | 1.409 | 9.71 | 9.76 |
| 47 | 243 | 17 | 18.583 | 17.925 | 3.175 | 16.88 | 12.29 |
| 167 | 166 | 17 | 26.733 | 26.868 | 4.528 | 19.74 | 10.36 |
| 49 | 143 | 17 | 43.217 | 45.324 | 9.224 | 35.76 | 12.86 |
| 161 | 156 | 17 | 51.483 | 51.31 | 21.426 | 62.18 | 25.17 |
| 33 | 130 | 17 | 44.417 | 45.018 | 14.179 | 44.19 | 20.48 |
| 125 | 119 | 17 | 33.017 | 38.902 | 11.262 | 37.41 | 19.33 |
| 41 | 39 | 17 | 45.55 | 49.363 | 22.622 | 64.38 | 28.95 |
| 236 | 180 | 17 | 52.083 | 55.212 | 14.778 | 49.09 | 17.46 |
| 179 | 228 | 17 | 35.933 | 37.936 | 14.53 | 42.5 | 24.77 |
| 262 | 177 | 17 | 42.767 | 41.526 | 12.964 | 41.21 | 19.29 |