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 |
|---|---|---|---|---|---|---|---|
| 70 | 237 | 24 | 28.058 | 32.708 | 9.26 | 30.87 | 19.02 |
| 195 | 142 | 24 | 36.1 | 37.571 | 9.728 | 34.19 | 16.37 |
| 60 | 248 | 24 | 7.375 | 9.292 | 1.696 | 8.67 | 10.95 |
| 213 | 247 | 24 | 24.367 | 25.042 | 6.008 | 20.09 | 14.83 |
| 140 | 122 | 24 | 44.925 | 48.414 | 16.221 | 49.9 | 22.33 |
| 263 | 16 | 24 | 29.783 | 35.144 | 16.327 | 46.67 | 30.35 |
| 192 | 129 | 24 | 20.158 | 20.717 | 4.911 | 18.77 | 15.9 |
| 263 | 178 | 24 | 36.85 | 39.76 | 15.329 | 44.9 | 24.92 |
| 263 | 155 | 24 | 55.817 | 55.781 | 22.437 | 63.63 | 24.73 |
| 87 | 81 | 24 | 44.85 | 49.551 | 19.597 | 57.09 | 25.25 |
| 130 | 101 | 24 | 19.708 | 21.29 | 6.62 | 22.7 | 19.66 |
| 141 | 191 | 24 | 46.592 | 46.311 | 18.051 | 53.25 | 25.22 |
| 177 | 130 | 24 | 22.45 | 25.564 | 8.418 | 26.26 | 20.88 |
| 13 | 121 | 24 | 39.008 | 43.233 | 15.791 | 47.65 | 24.03 |
| 78 | 212 | 24 | 10.542 | 11.956 | 2.224 | 10.65 | 12.19 |
| 182 | 48 | 24 | 48.375 | 44.049 | 12.538 | 40.56 | 19.57 |
| 82 | 63 | 24 | 24.242 | 27.397 | 7.494 | 25.96 | 17.42 |
| 36 | 87 | 24 | 23.583 | 26.403 | 6.36 | 23.29 | 15.9 |
| 124 | 37 | 24 | 29.1 | 30.301 | 7.66 | 25.82 | 15.45 |
| 197 | 129 | 24 | 21.525 | 23.697 | 8.401 | 26.66 | 22.77 |
| 3 | 168 | 24 | 20.325 | 23.644 | 7.87 | 24.79 | 22.79 |
| 60 | 235 | 24 | 22.65 | 22.612 | 4.052 | 17.64 | 11.62 |
| 100 | 57 | 24 | 32.275 | 34.997 | 11.063 | 36.42 | 20.51 |
| 7 | 131 | 24 | 22.933 | 25.89 | 11.287 | 33.42 | 28.83 |
| 26 | 29 | 24 | 29.733 | 30.369 | 5.369 | 22.97 | 11.5 |