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 |
|---|---|---|---|---|---|---|---|
| 137 | 257 | 300 | 26.183 | 27.746 | 9.673 | 29.92 | 22.52 |
| 226 | 231 | 300 | 27 | 29.146 | 7.743 | 36.34 | 17.43 |
| 233 | 134 | 300 | 29.225 | 32.583 | 11.171 | 35.53 | 22.88 |
| 263 | 136 | 299 | 26.983 | 27.329 | 8.026 | 27.01 | 19.16 |
| 164 | 54 | 299 | 25.233 | 26.315 | 7.345 | 24.92 | 17.73 |
| 4 | 145 | 299 | 18.95 | 20.07 | 5.035 | 18.38 | 15.76 |
| 161 | 28 | 299 | 32.1 | 35.274 | 12.374 | 38.26 | 22.61 |
| 262 | 129 | 299 | 23.05 | 25.229 | 7.208 | 24.79 | 19.49 |
| 79 | 196 | 299 | 23.75 | 26.252 | 8.923 | 28.66 | 22.19 |
| 238 | 256 | 298 | 36.825 | 37.211 | 9.312 | 32.92 | 15.63 |
| 74 | 136 | 298 | 17.675 | 19.683 | 5.962 | 20.54 | 20.51 |
| 45 | 188 | 298 | 23.35 | 25.073 | 5.406 | 20.85 | 13.73 |
| 66 | 138 | 298 | 24.542 | 28.231 | 10.598 | 32.45 | 26.04 |
| 151 | 45 | 298 | 30.092 | 31.585 | 8.274 | 29.06 | 17.05 |
| 4 | 43 | 298 | 22.867 | 23.99 | 5.064 | 19.86 | 13.45 |
| 260 | 236 | 298 | 18.4 | 21.465 | 5.358 | 19.97 | 16.34 |
| 100 | 72 | 298 | 52.458 | 52.984 | 11.795 | 42.25 | 14.12 |
| 137 | 133 | 297 | 27.167 | 29.011 | 10.537 | 32.29 | 23.64 |
| 50 | 247 | 297 | 21.367 | 24.391 | 8.452 | 27.21 | 23.09 |
| 80 | 181 | 297 | 18.683 | 20.529 | 5.735 | 20.22 | 18 |
| 141 | 56 | 297 | 23.85 | 25.159 | 7.813 | 25.91 | 19.85 |
| 145 | 249 | 297 | 21.05 | 22.329 | 4.418 | 44.12 | 12.81 |
| 186 | 213 | 297 | 37.917 | 41.336 | 12.311 | 39.67 | 19.7 |
| 68 | 67 | 297 | 30.517 | 32.472 | 11.257 | 35.04 | 21.84 |
| 42 | 169 | 296 | 17.858 | 19.3 | 3.931 | 16.26 | 13.65 |