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 |
|---|---|---|---|---|---|---|---|
| 130 | 86 | 21 | 38.2 | 40.497 | 11.293 | 38.17 | 17.86 |
| 198 | 258 | 21 | 15.383 | 15.59 | 3.643 | 13.87 | 14.47 |
| 130 | 169 | 21 | 62.55 | 63.323 | 17.074 | 57.9 | 17.37 |
| 152 | 240 | 21 | 18.983 | 21.74 | 8.061 | 25.5 | 25.39 |
| 29 | 155 | 21 | 19.433 | 20.06 | 5.371 | 19.72 | 16.91 |
| 205 | 71 | 21 | 39.133 | 39.862 | 12.412 | 40.01 | 19.9 |
| 257 | 142 | 21 | 36.583 | 36.279 | 10.784 | 35.19 | 18.68 |
| 163 | 57 | 21 | 33.2 | 36.156 | 10.277 | 34.67 | 17.65 |
| 211 | 18 | 21 | 39.867 | 42.867 | 15.779 | 47.69 | 23.68 |
| 18 | 185 | 21 | 10.233 | 12.584 | 2.635 | 11.52 | 13.86 |
| 258 | 107 | 21 | 37.85 | 39.815 | 11.093 | 40.45 | 18.27 |
| 198 | 76 | 21 | 19.567 | 20.463 | 4.07 | 18.24 | 12.47 |
| 47 | 116 | 21 | 21.3 | 24.521 | 3.882 | 18.23 | 10.48 |
| 243 | 26 | 21 | 54.533 | 57.097 | 19.092 | 57.99 | 21.5 |
| 202 | 43 | 21 | 15.517 | 17.055 | 2.66 | 14.58 | 9.86 |
| 116 | 97 | 21 | 43.75 | 44.009 | 13.24 | 42.44 | 18.82 |
| 56 | 4 | 21 | 25 | 24.65 | 8.908 | 49.17 | 23.03 |
| 54 | 228 | 21 | 9.667 | 11.602 | 3.592 | 12.93 | 21.01 |
| 161 | 206 | 21 | 48.633 | 43.406 | 17.117 | 50.43 | 22.39 |
| 89 | 222 | 21 | 26.383 | 30.253 | 6.313 | 24.49 | 13.17 |
| 191 | 216 | 21 | 21.567 | 22.574 | 8.299 | 24.37 | 23 |
| 89 | 142 | 21 | 38.817 | 44.861 | 11.916 | 39.16 | 17.58 |
| 17 | 160 | 21 | 36.533 | 34.208 | 6.014 | 25.21 | 10.91 |
| 107 | 122 | 21 | 53.483 | 49.371 | 15.834 | 48.31 | 21.5 |
| 26 | 25 | 21 | 24.567 | 24.363 | 5.07 | 20.21 | 14.54 |