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 |
|---|---|---|---|---|---|---|---|
| 163 | 47 | 67 | 26.633 | 29.939 | 9.468 | 30.7 | 21.03 |
| 129 | 225 | 67 | 28.55 | 30.277 | 8.421 | 28.63 | 17.23 |
| 146 | 261 | 67 | 26.1 | 27.15 | 8.305 | 27.63 | 20.2 |
| 52 | 239 | 67 | 38.067 | 38.636 | 9.508 | 33.58 | 15.41 |
| 10 | 116 | 67 | 40.417 | 41.832 | 16.507 | 52.56 | 25.5 |
| 17 | 137 | 67 | 28.067 | 29.562 | 6.894 | 25.18 | 15.09 |
| 72 | 85 | 67 | 13.817 | 14.403 | 2.167 | 11.38 | 9.45 |
| 8 | 7 | 67 | 7.883 | 8.815 | 1.337 | 7.84 | 10.05 |
| 222 | 61 | 67 | 25.05 | 25.91 | 4.4 | 19.48 | 10.6 |
| 146 | 13 | 67 | 25.55 | 27.803 | 8.835 | 29.14 | 21.1 |
| 87 | 135 | 67 | 32.783 | 34.346 | 14.063 | 40.84 | 26.16 |
| 209 | 241 | 67 | 65.467 | 65.442 | 15.374 | 52.46 | 15.18 |
| 215 | 218 | 67 | 11.383 | 12.167 | 2.327 | 10.68 | 11.9 |
| 141 | 177 | 67 | 44.9 | 45.201 | 11.041 | 38.61 | 18.37 |
| 246 | 78 | 67 | 27.333 | 30.021 | 11.602 | 35.17 | 25.78 |
| 166 | 61 | 67 | 49.783 | 51.001 | 14.146 | 46.61 | 17.45 |
| 234 | 205 | 67 | 46.95 | 51.362 | 16.806 | 51.64 | 21.38 |
| 49 | 170 | 67 | 24.733 | 28.346 | 7.229 | 25.57 | 16.61 |
| 262 | 136 | 67 | 18.017 | 21.654 | 7.605 | 24.48 | 23.8 |
| 45 | 152 | 67 | 32.417 | 33.458 | 9.559 | 32.02 | 18.46 |
| 76 | 140 | 67 | 54.567 | 55.491 | 17.913 | 55.2 | 20.78 |
| 92 | 192 | 67 | 9 | 9.982 | 1.71 | 9.13 | 10.46 |
| 163 | 219 | 67 | 52.5 | 57.477 | 17.075 | 52.92 | 19.73 |
| 151 | 82 | 67 | 36.35 | 36.448 | 9.032 | 32.07 | 15.48 |
| 218 | 132 | 67 | 7.35 | 8.375 | 3.178 | 11.83 | 25.51 |