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 |
|---|---|---|---|---|---|---|---|
| 97 | 230 | 263 | 27.75 | 29.813 | 6.942 | 25.55 | 15.28 |
| 262 | 66 | 263 | 22.933 | 24.192 | 8.179 | 25.92 | 22.13 |
| 28 | 48 | 262 | 36.525 | 38.186 | 12.589 | 51.59 | 21.51 |
| 158 | 198 | 262 | 32.3 | 34.502 | 8.809 | 30.55 | 15.85 |
| 33 | 262 | 262 | 26.075 | 27.674 | 8.896 | 28.23 | 20.61 |
| 97 | 217 | 262 | 14.025 | 14.913 | 2.587 | 12.12 | 11.38 |
| 164 | 134 | 262 | 32.15 | 35.758 | 12.049 | 39.03 | 22.06 |
| 56 | 164 | 262 | 21.725 | 24.071 | 8.095 | 51.78 | 22.63 |
| 125 | 14 | 262 | 25.317 | 27.213 | 9.925 | 30.45 | 23.09 |
| 97 | 48 | 262 | 30.067 | 31.02 | 6.741 | 25.39 | 14.18 |
| 146 | 239 | 262 | 18.375 | 19.878 | 3.997 | 17.29 | 13.2 |
| 142 | 173 | 262 | 34.333 | 36.672 | 7.897 | 29.76 | 13.62 |
| 181 | 230 | 262 | 31.083 | 33.704 | 7.893 | 28.81 | 15.09 |
| 142 | 70 | 262 | 33.225 | 35.672 | 9.923 | 33.6 | 17.9 |
| 140 | 225 | 262 | 38.017 | 39.072 | 9.117 | 32.94 | 14.84 |
| 263 | 40 | 261 | 28.667 | 29.892 | 9.923 | 30.89 | 21.1 |
| 188 | 97 | 261 | 14.6 | 15.664 | 2.791 | 12.89 | 11.57 |
| 113 | 220 | 261 | 33.967 | 36.581 | 13.112 | 40.43 | 22.79 |
| 148 | 258 | 261 | 26.983 | 29.621 | 11.157 | 34.3 | 24.36 |
| 163 | 217 | 261 | 36.267 | 36.345 | 6.991 | 28.52 | 12.8 |
| 255 | 141 | 261 | 22.85 | 24.658 | 6.087 | 22.08 | 15.54 |
| 107 | 83 | 261 | 23.9 | 26.004 | 6.947 | 24.38 | 17.84 |
| 33 | 227 | 260 | 15.192 | 16.701 | 4.854 | 17.07 | 18.39 |
| 41 | 169 | 260 | 22.2 | 23.466 | 5.149 | 19.95 | 14.38 |
| 100 | 22 | 260 | 38.908 | 42.163 | 13.825 | 43.12 | 20.83 |