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 |
|---|---|---|---|---|---|---|---|
| 132 | 109 | 237 | 57.933 | 60.867 | 30.046 | 82.12 | 31.99 |
| 229 | 228 | 237 | 29.4 | 31.32 | 11.028 | 34.16 | 22.68 |
| 82 | 223 | 237 | 11.767 | 12.743 | 3.564 | 13.34 | 17.66 |
| 87 | 62 | 236 | 26.117 | 27.518 | 5.815 | 22.23 | 13.29 |
| 193 | 138 | 236 | 19.95 | 21.393 | 5.25 | 19.95 | 15.95 |
| 42 | 136 | 236 | 19.2 | 20.443 | 4.902 | 18.7 | 15.86 |
| 10 | 140 | 236 | 37.342 | 41.589 | 15.859 | 51.57 | 25.5 |
| 223 | 170 | 236 | 23.408 | 25.015 | 7.127 | 26.86 | 19.28 |
| 45 | 12 | 236 | 10.267 | 11.777 | 1.51 | 9.37 | 8.81 |
| 256 | 7 | 236 | 20.158 | 20.924 | 5.977 | 20.83 | 18.04 |
| 226 | 70 | 236 | 16.208 | 17.559 | 4.449 | 17 | 16.27 |
| 82 | 70 | 236 | 12.183 | 13.507 | 2.618 | 11.79 | 12.73 |
| 144 | 227 | 236 | 22.767 | 23.788 | 7.923 | 25.42 | 21.54 |
| 142 | 83 | 236 | 28.283 | 30.394 | 6.394 | 24.75 | 13.32 |
| 230 | 126 | 236 | 30.042 | 32.494 | 9.984 | 32.57 | 19.81 |
| 41 | 47 | 236 | 20.7 | 22.464 | 4.888 | 19.01 | 14.08 |
| 76 | 77 | 235 | 10.167 | 10.849 | 1.72 | 9.69 | 9.86 |
| 161 | 194 | 235 | 26.383 | 28.165 | 7.068 | 26.14 | 16.02 |
| 211 | 95 | 235 | 31.333 | 33.048 | 10.718 | 34.66 | 20.97 |
| 4 | 244 | 235 | 26.517 | 27.682 | 10.655 | 32.54 | 24.77 |
| 97 | 90 | 235 | 21.217 | 22.541 | 4.732 | 18.83 | 13.51 |
| 229 | 247 | 235 | 20.45 | 23.019 | 6.709 | 22.83 | 19.3 |
| 153 | 127 | 235 | 3.833 | 4.701 | 0.847 | 5.35 | 13.03 |
| 42 | 233 | 235 | 23.25 | 25.445 | 6.193 | 22.1 | 16.58 |
| 4 | 226 | 235 | 21.583 | 23.086 | 6.153 | 21.68 | 16.79 |