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 |
|---|---|---|---|---|---|---|---|
| 146 | 121 | 34 | 26.075 | 26.469 | 10.439 | 31.85 | 24.65 |
| 148 | 175 | 34 | 29.208 | 31.956 | 15.188 | 43.38 | 30.31 |
| 153 | 136 | 34 | 5.992 | 7.121 | 1.114 | 6.68 | 9.66 |
| 79 | 1 | 34 | 44.958 | 46.489 | 14.904 | 69.98 | 21.29 |
| 167 | 174 | 34 | 25.658 | 26.984 | 5.389 | 21.78 | 13.1 |
| 234 | 221 | 34 | 38.325 | 39.241 | 14.976 | 45.04 | 24.28 |
| 85 | 177 | 34 | 22.133 | 22.346 | 3.998 | 17.2 | 11.62 |
| 141 | 39 | 34 | 56.942 | 61.308 | 18.903 | 58.75 | 20.08 |
| 123 | 108 | 34 | 8.35 | 10.425 | 1.687 | 9.03 | 10.58 |
| 262 | 248 | 33 | 18.367 | 20.609 | 6.863 | 22.39 | 21.54 |
| 17 | 222 | 33 | 30.3 | 31.178 | 5.56 | 23.78 | 11.13 |
| 45 | 196 | 33 | 26.767 | 31.045 | 9.695 | 30.99 | 21.16 |
| 261 | 131 | 33 | 44.95 | 45.405 | 17.795 | 51.02 | 24.95 |
| 95 | 68 | 33 | 37.683 | 39.424 | 9.906 | 35.09 | 16.16 |
| 116 | 259 | 33 | 21.05 | 23.556 | 8.89 | 27.7 | 23.67 |
| 12 | 41 | 33 | 32.983 | 36.619 | 9.787 | 33.5 | 16.86 |
| 28 | 209 | 33 | 33.233 | 37.2 | 15.13 | 52.09 | 25.54 |
| 257 | 65 | 33 | 21.45 | 21.714 | 4.121 | 17.68 | 13.93 |
| 119 | 127 | 33 | 13.533 | 15.066 | 3.45 | 14.2 | 15.64 |
| 215 | 24 | 33 | 41.417 | 40.658 | 15.698 | 52.7 | 24.82 |
| 257 | 97 | 33 | 18.2 | 18.788 | 3.102 | 14.67 | 10.29 |
| 255 | 258 | 33 | 26.45 | 28.173 | 9.04 | 29.27 | 20.18 |
| 37 | 85 | 33 | 24.1 | 24.178 | 4.855 | 18.85 | 12.73 |
| 112 | 116 | 33 | 31.667 | 33.681 | 11.982 | 36.53 | 22.75 |
| 54 | 132 | 33 | 41.15 | 41.858 | 22.29 | 59.62 | 33.78 |