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 |
|---|---|---|---|---|---|---|---|
| 61 | 229 | 50 | 39.383 | 43.935 | 10.636 | 37.36 | 15.98 |
| 246 | 149 | 50 | 41.108 | 41.743 | 14.017 | 43.32 | 20.69 |
| 228 | 67 | 50 | 14.525 | 16.19 | 3.055 | 14.52 | 12.25 |
| 79 | 32 | 50 | 30.175 | 33.481 | 13.923 | 40.7 | 26.56 |
| 50 | 153 | 50 | 19.917 | 20.45 | 10.07 | 29.3 | 30.25 |
| 36 | 76 | 50 | 24.658 | 25.156 | 4.365 | 18.46 | 11.13 |
| 10 | 139 | 50 | 11.767 | 12.046 | 2.834 | 11.69 | 14.49 |
| 260 | 36 | 50 | 20.375 | 20.907 | 5.051 | 18.73 | 15.39 |
| 144 | 28 | 50 | 29.333 | 32.882 | 13.788 | 40.88 | 26.98 |
| 262 | 31 | 50 | 22.992 | 24.723 | 9.072 | 28.16 | 23.51 |
| 209 | 78 | 50 | 50.167 | 54.102 | 14.443 | 46.13 | 18.08 |
| 97 | 55 | 50 | 32.4 | 35.96 | 13.211 | 40.21 | 24.35 |
| 129 | 89 | 50 | 43.458 | 46.904 | 14.137 | 45.47 | 21.56 |
| 215 | 151 | 50 | 35.942 | 39.261 | 15.797 | 52 | 26.2 |
| 193 | 114 | 50 | 23.033 | 25.687 | 6.027 | 22.22 | 14.99 |
| 21 | 14 | 50 | 17.992 | 18.272 | 4.657 | 18.11 | 15.94 |
| 94 | 235 | 50 | 9.375 | 10.613 | 1.307 | 8.49 | 8.3 |
| 36 | 48 | 50 | 30.633 | 34.312 | 8.661 | 29.79 | 16.06 |
| 61 | 164 | 50 | 47.933 | 51.933 | 9.901 | 38.98 | 12.12 |
| 231 | 81 | 50 | 43.125 | 48.342 | 19.956 | 57.79 | 26.09 |
| 54 | 158 | 50 | 16.892 | 16.725 | 4.714 | 16.77 | 17.49 |
| 39 | 216 | 50 | 22.8 | 22.855 | 7.472 | 25.91 | 22.48 |
| 145 | 166 | 50 | 29.55 | 31.192 | 6.949 | 27.26 | 14.4 |
| 24 | 78 | 50 | 27.55 | 29.069 | 7.738 | 26.03 | 17.31 |
| 196 | 237 | 50 | 24.567 | 27.072 | 7.926 | 37.47 | 18.81 |