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 |
|---|---|---|---|---|---|---|---|
| 131 | 131 | 127 | 6.867 | 10.071 | 2.034 | 11.03 | 26.32 |
| 87 | 182 | 127 | 56.983 | 57.111 | 15.4 | 49.32 | 18.76 |
| 261 | 220 | 127 | 32.35 | 36.563 | 15.178 | 44.54 | 27.08 |
| 148 | 71 | 127 | 28.85 | 30.987 | 7.947 | 27.76 | 16.08 |
| 181 | 22 | 126 | 22.575 | 23.693 | 6.2 | 21.97 | 16.47 |
| 144 | 173 | 126 | 26.358 | 29.832 | 10.24 | 33.04 | 22.36 |
| 89 | 48 | 126 | 45.875 | 46.47 | 10.971 | 37.32 | 15.19 |
| 209 | 155 | 126 | 60.333 | 60.174 | 19.648 | 60.06 | 20.91 |
| 51 | 81 | 126 | 11.825 | 13.039 | 2.39 | 11.65 | 14.07 |
| 219 | 161 | 126 | 48.683 | 50.106 | 15.699 | 52.08 | 21.04 |
| 231 | 35 | 126 | 38.925 | 40.784 | 8.019 | 30.61 | 12.6 |
| 114 | 196 | 126 | 27.3 | 29.056 | 9.424 | 30.5 | 20.86 |
| 177 | 225 | 126 | 9.983 | 11.732 | 1.626 | 9.83 | 9.26 |
| 95 | 129 | 126 | 19.283 | 20.921 | 5.42 | 20.04 | 16.37 |
| 152 | 164 | 126 | 27.225 | 27.747 | 6.464 | 24.53 | 14.89 |
| 229 | 54 | 126 | 27.592 | 28.307 | 8.098 | 26.89 | 18.41 |
| 186 | 60 | 126 | 35.85 | 38.376 | 11.917 | 38.23 | 20.29 |
| 130 | 231 | 126 | 40.942 | 44.446 | 15.839 | 52.35 | 23.85 |
| 14 | 209 | 126 | 37.658 | 38.223 | 10.718 | 38.04 | 17.53 |
| 231 | 1 | 126 | 32.408 | 37.681 | 14.031 | 75.32 | 25.49 |
| 231 | 56 | 126 | 35.3 | 37.528 | 11.484 | 36.95 | 19.91 |
| 40 | 256 | 126 | 18.433 | 19.894 | 4.878 | 18.1 | 16.72 |
| 179 | 262 | 126 | 14.542 | 17.869 | 4.639 | 16.75 | 17.25 |
| 7 | 37 | 126 | 24.442 | 27.314 | 7.318 | 25.54 | 17.26 |
| 48 | 135 | 126 | 38.6 | 42.267 | 12.504 | 40.72 | 19.51 |