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 |
|---|---|---|---|---|---|---|---|
| 238 | 209 | 548 | 27.3 | 29.193 | 8.09 | 27.78 | 18.08 |
| 82 | 230 | 548 | 26.242 | 28.081 | 7.528 | 50.05 | 18.44 |
| 161 | 93 | 548 | 37.942 | 40.263 | 12.096 | 40.05 | 19.86 |
| 83 | 129 | 548 | 8.017 | 9.049 | 1.696 | 8.76 | 12.8 |
| 40 | 228 | 548 | 10.383 | 10.985 | 2.468 | 10.54 | 13.91 |
| 7 | 170 | 548 | 20.083 | 22.421 | 4.366 | 18.03 | 13.24 |
| 74 | 213 | 548 | 16.342 | 18.658 | 5.713 | 19.52 | 20.59 |
| 223 | 263 | 547 | 14.533 | 16.329 | 5.808 | 41.28 | 23.96 |
| 70 | 138 | 547 | 5.867 | 8.365 | 1.587 | 11.84 | 16.01 |
| 49 | 181 | 547 | 11.067 | 12.108 | 1.922 | 9.98 | 9.99 |
| 237 | 83 | 547 | 22.233 | 23.475 | 5.333 | 20.43 | 14.44 |
| 223 | 140 | 547 | 17.9 | 20.094 | 5.671 | 31.16 | 19.81 |
| 159 | 168 | 546 | 6.683 | 7.684 | 1.064 | 6.99 | 8.98 |
| 162 | 257 | 546 | 31.867 | 33.371 | 10.943 | 34.43 | 20.76 |
| 164 | 202 | 546 | 22.675 | 23.702 | 5.125 | 19.56 | 13.65 |
| 4 | 80 | 546 | 16.542 | 17.836 | 3.935 | 16 | 14.04 |
| 244 | 43 | 546 | 21.7 | 23.014 | 5.63 | 20.95 | 15.52 |
| 141 | 97 | 546 | 27.65 | 29.243 | 8.459 | 28.36 | 18.66 |
| 25 | 255 | 546 | 17.608 | 18.648 | 4.163 | 16.62 | 14.3 |
| 237 | 157 | 545 | 24.5 | 25.911 | 6.08 | 22.54 | 14.69 |
| 13 | 228 | 545 | 14.767 | 17.128 | 5.489 | 18.59 | 20.33 |
| 140 | 213 | 545 | 29.25 | 31.396 | 8.367 | 28.24 | 18.73 |
| 65 | 90 | 544 | 18.567 | 19.379 | 4.077 | 16.54 | 13.47 |
| 114 | 146 | 544 | 24.425 | 25.596 | 5.893 | 21.77 | 14.81 |
| 143 | 220 | 544 | 17.958 | 19.963 | 9.08 | 27.19 | 29.73 |