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 |
|---|---|---|---|---|---|---|---|
| 82 | 17 | 15 | 20.5 | 21.714 | 6.694 | 22.53 | 19.47 |
| 235 | 238 | 15 | 22.917 | 27.399 | 7.404 | 25.5 | 18.79 |
| 116 | 70 | 15 | 26.783 | 30.313 | 10.428 | 32.43 | 22.16 |
| 112 | 258 | 15 | 28.533 | 29.979 | 8.754 | 29.2 | 18.63 |
| 143 | 98 | 15 | 27.633 | 30.848 | 14.981 | 42.55 | 29.96 |
| 7 | 136 | 15 | 24.433 | 25.4 | 9.957 | 30.47 | 24.08 |
| 216 | 129 | 15 | 26.3 | 31.379 | 10.748 | 33.25 | 21.98 |
| 246 | 6 | 15 | 32.383 | 36.16 | 16.169 | 46.5 | 27.77 |
| 49 | 86 | 15 | 57.117 | 58.817 | 18.138 | 57.03 | 19.17 |
| 145 | 52 | 15 | 21.083 | 23.133 | 7.699 | 24.97 | 22.25 |
| 255 | 55 | 15 | 29.833 | 32.474 | 15.668 | 44.6 | 31.4 |
| 31 | 242 | 15 | 15.267 | 14.814 | 2.472 | 12.03 | 10.95 |
| 197 | 218 | 15 | 17.783 | 19.732 | 4.548 | 17.5 | 14.79 |
| 233 | 23 | 15 | 39.133 | 37.003 | 19.577 | 55.32 | 30.97 |
| 41 | 258 | 15 | 50.233 | 51.801 | 15.355 | 46.89 | 19.34 |
| 38 | 69 | 15 | 73 | 75.567 | 20.929 | 72.47 | 17.63 |
| 83 | 232 | 15 | 24.967 | 25.363 | 7.35 | 24.69 | 18.47 |
| 45 | 51 | 15 | 76.483 | 68.208 | 19.083 | 60.4 | 20.26 |
| 72 | 211 | 15 | 53.783 | 51.248 | 7.674 | 35.2 | 9.45 |
| 79 | 222 | 15 | 54.717 | 54.906 | 12.78 | 43.42 | 15.32 |
| 249 | 3 | 15 | 39.567 | 40.74 | 17.041 | 49.7 | 26.22 |
| 24 | 36 | 15 | 43.783 | 44.308 | 11.861 | 40.03 | 16.32 |
| 182 | 243 | 15 | 23.75 | 24.927 | 5.085 | 19.61 | 13.72 |
| 71 | 52 | 15 | 32.533 | 34.666 | 6.439 | 26.73 | 11.5 |
| 250 | 136 | 15 | 28.667 | 29.844 | 6.319 | 24.39 | 13.89 |