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 |
|---|---|---|---|---|---|---|---|
| 234 | 174 | 78 | 37.725 | 44.335 | 15.439 | 47.09 | 23.13 |
| 89 | 228 | 78 | 16.05 | 18.083 | 4.306 | 16.7 | 15.53 |
| 7 | 4 | 78 | 21.542 | 23.423 | 6.935 | 23.49 | 19.29 |
| 77 | 61 | 78 | 17.883 | 18.933 | 3.107 | 14.67 | 10.3 |
| 68 | 171 | 78 | 43.1 | 44.766 | 14.396 | 45.4 | 20.49 |
| 42 | 120 | 78 | 12.233 | 12.302 | 2.468 | 11.75 | 13.5 |
| 162 | 118 | 78 | 45.55 | 46.769 | 21.622 | 61.78 | 28.41 |
| 228 | 49 | 78 | 18.375 | 20.907 | 3.648 | 16.48 | 11.41 |
| 205 | 139 | 77 | 8.917 | 9.756 | 1.782 | 8.94 | 11.55 |
| 71 | 177 | 77 | 18.333 | 19.168 | 3.358 | 15.16 | 10.95 |
| 66 | 226 | 77 | 19.283 | 20.015 | 6.581 | 21.78 | 22.27 |
| 151 | 20 | 77 | 23.233 | 26.147 | 8.806 | 28.21 | 22.63 |
| 158 | 216 | 77 | 52.3 | 55.753 | 18.487 | 52.4 | 22.11 |
| 239 | 54 | 77 | 33.167 | 36.046 | 10.177 | 33.57 | 17.82 |
| 246 | 136 | 77 | 28.45 | 29.292 | 10.642 | 33.1 | 23.63 |
| 75 | 55 | 77 | 52.1 | 54.866 | 22.068 | 63.73 | 25.4 |
| 237 | 72 | 77 | 60.85 | 61.327 | 14.294 | 49.7 | 14.98 |
| 80 | 140 | 77 | 25.117 | 27.154 | 6.699 | 24.37 | 16.01 |
| 48 | 34 | 77 | 32.433 | 33.763 | 7.628 | 28.26 | 14.44 |
| 243 | 68 | 77 | 25.367 | 27.526 | 9.131 | 29.88 | 21.67 |
| 102 | 95 | 77 | 9.617 | 13.753 | 2.519 | 11.83 | 11.71 |
| 229 | 71 | 77 | 47.9 | 49.463 | 12.895 | 42.76 | 16.46 |
| 177 | 97 | 77 | 23.233 | 24.061 | 4.211 | 18.12 | 11.25 |
| 100 | 194 | 77 | 29.8 | 32.983 | 8.123 | 28.87 | 16 |
| 55 | 29 | 77 | 9.75 | 10.798 | 1.824 | 9.47 | 10.75 |