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 |
|---|---|---|---|---|---|---|---|
| 8 | 238 | 40 | 18.217 | 20.527 | 5.943 | 52 | 18.76 |
| 254 | 185 | 40 | 15.1 | 19.107 | 3.526 | 15.81 | 11.18 |
| 131 | 121 | 39 | 8.133 | 9.432 | 2.086 | 9.44 | 15.28 |
| 106 | 190 | 39 | 10.65 | 11.424 | 1.821 | 9.71 | 10.22 |
| 70 | 163 | 39 | 39.867 | 40.67 | 9.878 | 36.83 | 15.26 |
| 241 | 42 | 39 | 21.15 | 21.448 | 5.539 | 19.87 | 16.79 |
| 242 | 20 | 39 | 14.15 | 16.181 | 2.853 | 13.19 | 11.11 |
| 151 | 228 | 39 | 43.2 | 44.319 | 14.195 | 44.33 | 19.98 |
| 78 | 20 | 39 | 7.467 | 9.783 | 1.279 | 8.21 | 10.13 |
| 249 | 94 | 39 | 32.35 | 34.915 | 12.751 | 39.07 | 22.79 |
| 228 | 66 | 39 | 20.733 | 22.312 | 4.309 | 17.63 | 12.59 |
| 228 | 17 | 39 | 24.15 | 28.236 | 5.075 | 21.6 | 11.83 |
| 182 | 51 | 39 | 16.383 | 18.544 | 5.625 | 19.64 | 19.87 |
| 185 | 78 | 39 | 13.867 | 15.239 | 2.472 | 12.22 | 10.89 |
| 208 | 23 | 39 | 45.833 | 46.407 | 35.015 | 91.45 | 46.29 |
| 13 | 147 | 39 | 33.5 | 35.503 | 13.663 | 40.46 | 24.65 |
| 164 | 101 | 39 | 40.367 | 44.436 | 17.742 | 51.91 | 25.95 |
| 262 | 78 | 39 | 22.117 | 25.18 | 7.634 | 25.44 | 19.79 |
| 89 | 108 | 39 | 21.167 | 23.389 | 4.375 | 18 | 12.12 |
| 13 | 194 | 39 | 34.167 | 35.36 | 12.827 | 38.91 | 23.63 |
| 107 | 108 | 39 | 42.333 | 43.633 | 15.973 | 47.87 | 22.97 |
| 37 | 228 | 39 | 26.567 | 28.81 | 8.582 | 28.38 | 19.28 |
| 141 | 175 | 39 | 38.467 | 39.797 | 14.597 | 44.04 | 23.78 |
| 116 | 25 | 39 | 40.117 | 41.277 | 12.81 | 40.59 | 19.4 |
| 256 | 190 | 39 | 21.183 | 22.761 | 5.155 | 19.76 | 13.92 |