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 |
|---|---|---|---|---|---|---|---|
| 193 | 113 | 37 | 26.25 | 26.527 | 5.525 | 21.66 | 13.23 |
| 83 | 140 | 37 | 22.817 | 24.227 | 5.068 | 20.2 | 13.8 |
| 89 | 244 | 37 | 46.6 | 49.631 | 18.285 | 55.34 | 23.62 |
| 71 | 68 | 37 | 46.667 | 49.905 | 10.964 | 40 | 13.67 |
| 50 | 85 | 37 | 39.517 | 43.295 | 11.74 | 39.13 | 17.28 |
| 193 | 87 | 37 | 27.8 | 26.374 | 8.011 | 27.59 | 20.22 |
| 81 | 174 | 37 | 17.35 | 18.928 | 3.028 | 14.85 | 10.05 |
| 150 | 90 | 37 | 74 | 73.751 | 20.507 | 66.15 | 17.13 |
| 192 | 56 | 37 | 8.1 | 8.415 | 2.598 | 10.08 | 21.34 |
| 174 | 220 | 37 | 13.3 | 14.658 | 3.271 | 13.86 | 14.75 |
| 131 | 122 | 37 | 8.75 | 11.548 | 2.135 | 10.47 | 10.51 |
| 229 | 29 | 37 | 41.267 | 47.459 | 19.144 | 55.86 | 25.82 |
| 226 | 106 | 37 | 17.85 | 21.929 | 7.233 | 23.62 | 22.03 |
| 65 | 127 | 37 | 41.6 | 44.669 | 14.981 | 45.91 | 23.3 |
| 260 | 207 | 37 | 6.583 | 7.508 | 1.847 | 9.65 | 16.45 |
| 116 | 88 | 37 | 33.45 | 34.018 | 10.425 | 33.87 | 19.93 |
| 88 | 259 | 37 | 34.617 | 41.808 | 18.894 | 53.43 | 30.01 |
| 168 | 209 | 37 | 45.983 | 46.582 | 10.825 | 38.45 | 14.82 |
| 232 | 119 | 37 | 26.967 | 28.936 | 11.345 | 33.88 | 26.02 |
| 89 | 163 | 37 | 33.083 | 39.363 | 11.693 | 36.26 | 19.52 |
| 143 | 174 | 37 | 25.583 | 31.213 | 12.866 | 37.89 | 27.63 |
| 256 | 196 | 37 | 21.467 | 21.752 | 6.815 | 22.81 | 20.1 |
| 218 | 131 | 37 | 20.533 | 21.758 | 4.534 | 17.55 | 13.14 |
| 137 | 120 | 37 | 24.033 | 26.366 | 9.085 | 29.04 | 23.57 |
| 181 | 55 | 37 | 30.25 | 30.011 | 10.897 | 33.62 | 23.63 |