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 |
|---|---|---|---|---|---|---|---|
| 35 | 82 | 32 | 34.975 | 36.257 | 10.224 | 33.52 | 17.84 |
| 149 | 76 | 32 | 25.108 | 26.507 | 8.741 | 28.17 | 21.38 |
| 145 | 131 | 32 | 30.75 | 34.108 | 12.122 | 36.68 | 23.94 |
| 106 | 246 | 32 | 26.417 | 29.806 | 7.346 | 26.72 | 15.83 |
| 116 | 51 | 32 | 28.65 | 32.369 | 12.619 | 38.89 | 25.17 |
| 148 | 3 | 32 | 36.992 | 41.302 | 17.267 | 50.25 | 27.08 |
| 239 | 252 | 32 | 37.258 | 40.827 | 15.456 | 46.42 | 24.16 |
| 222 | 188 | 32 | 24.775 | 25.509 | 4.449 | 19.27 | 10.73 |
| 222 | 87 | 32 | 49.567 | 51.184 | 14.696 | 47.35 | 19.01 |
| 202 | 161 | 32 | 14.992 | 19.292 | 2.73 | 17.75 | 8.99 |
| 151 | 31 | 32 | 29.8 | 30.395 | 11.013 | 33.66 | 23.37 |
| 217 | 132 | 32 | 37.108 | 39.472 | 14.958 | 49.78 | 27.1 |
| 235 | 242 | 32 | 25.358 | 25.593 | 6.501 | 23.56 | 15.77 |
| 65 | 63 | 32 | 37.608 | 37.26 | 7.908 | 29.33 | 13.56 |
| 234 | 86 | 32 | 53.8 | 59.051 | 22.679 | 67.85 | 25.38 |
| 79 | 206 | 32 | 40.967 | 42.758 | 18.169 | 52.55 | 26.98 |
| 79 | 180 | 32 | 34.55 | 35.728 | 13.075 | 40.2 | 22.8 |
| 45 | 202 | 32 | 34.317 | 34.051 | 8.88 | 30.67 | 16.95 |
| 102 | 82 | 32 | 13.517 | 13.449 | 2.915 | 12.34 | 13.88 |
| 242 | 18 | 32 | 18.292 | 19.351 | 3.707 | 15.74 | 12.85 |
| 121 | 28 | 32 | 9.45 | 10.076 | 1.584 | 8.81 | 10.78 |
| 36 | 66 | 32 | 25.508 | 27.035 | 4.654 | 19.44 | 11.59 |
| 7 | 228 | 32 | 36.367 | 40.199 | 13.61 | 41.63 | 21.91 |
| 106 | 232 | 32 | 21.008 | 22.028 | 4.97 | 19.1 | 14.32 |
| 88 | 23 | 32 | 30.083 | 31.7 | 16.606 | 46.38 | 33.35 |