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 |
|---|---|---|---|---|---|---|---|
| 87 | 36 | 488 | 28.375 | 29.263 | 6.787 | 24.88 | 14.56 |
| 260 | 141 | 487 | 16.6 | 18.466 | 4.168 | 18.32 | 14.82 |
| 41 | 90 | 487 | 27.667 | 28.637 | 6.224 | 23.82 | 13.95 |
| 142 | 17 | 486 | 40.542 | 42.029 | 9.192 | 33.96 | 13.75 |
| 230 | 92 | 486 | 37.717 | 39.518 | 12.436 | 40.19 | 20.2 |
| 225 | 17 | 486 | 7.55 | 8.788 | 1.372 | 7.79 | 10.59 |
| 146 | 164 | 486 | 17.967 | 20.657 | 3.591 | 16.18 | 12.02 |
| 170 | 216 | 486 | 38.433 | 42.108 | 13.92 | 48.12 | 23.25 |
| 158 | 226 | 485 | 28.35 | 30.216 | 7.004 | 26.31 | 14.71 |
| 52 | 140 | 485 | 27.867 | 28.576 | 8.353 | 27.54 | 19.08 |
| 137 | 228 | 485 | 25.767 | 27.518 | 9.826 | 30.37 | 22.79 |
| 231 | 179 | 485 | 28.4 | 29.797 | 10.044 | 31.64 | 21.63 |
| 249 | 54 | 485 | 20.417 | 21.635 | 5.059 | 18.72 | 14.93 |
| 114 | 82 | 484 | 28.217 | 29.904 | 8.922 | 29.94 | 19.12 |
| 13 | 7 | 484 | 29.95 | 31.628 | 10.779 | 33.73 | 21.58 |
| 162 | 195 | 484 | 30.467 | 32.112 | 9.293 | 30.7 | 18.42 |
| 146 | 142 | 484 | 15.592 | 17.475 | 3.166 | 16.51 | 11.87 |
| 246 | 106 | 484 | 28.467 | 30.277 | 7.179 | 25.97 | 15.03 |
| 68 | 133 | 484 | 27.1 | 30.045 | 9.464 | 30.65 | 20.15 |
| 42 | 127 | 484 | 13.675 | 14.976 | 4.232 | 16.21 | 18.75 |
| 179 | 141 | 483 | 16.3 | 17.53 | 3.67 | 15.24 | 14.21 |
| 260 | 237 | 483 | 17.6 | 19.175 | 4.403 | 19.69 | 14.89 |
| 40 | 233 | 482 | 25.442 | 26.083 | 7.577 | 25.15 | 18.35 |
| 145 | 237 | 482 | 14.758 | 15.853 | 2.832 | 19.49 | 12.36 |
| 132 | 118 | 482 | 47.675 | 51.261 | 26.674 | 72.41 | 33.63 |