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 |
|---|---|---|---|---|---|---|---|
| 39 | 197 | 33 | 28.683 | 28.499 | 8.055 | 28.23 | 17.26 |
| 147 | 261 | 33 | 46 | 47.617 | 12.94 | 43.03 | 16.97 |
| 219 | 211 | 33 | 53 | 55.225 | 17.015 | 52.33 | 19.91 |
| 76 | 205 | 33 | 24.967 | 27.161 | 8.494 | 27.79 | 20.15 |
| 3 | 244 | 33 | 49.1 | 48.93 | 8.763 | 36.36 | 11.42 |
| 186 | 8 | 33 | 27.083 | 27.485 | 6.459 | 23.85 | 15.11 |
| 232 | 92 | 33 | 26.4 | 30.986 | 12.483 | 36.54 | 26.91 |
| 36 | 90 | 33 | 28.783 | 28.402 | 7.001 | 24.8 | 15.21 |
| 4 | 220 | 33 | 31.5 | 37.116 | 13.972 | 42.18 | 25.39 |
| 112 | 209 | 33 | 19.4 | 23.379 | 5.776 | 22.23 | 17.18 |
| 218 | 134 | 33 | 21.6 | 21.738 | 5.843 | 18.68 | 17.49 |
| 162 | 215 | 33 | 40.6 | 47.314 | 14.107 | 45.73 | 20.68 |
| 16 | 174 | 33 | 29.483 | 31.363 | 12.473 | 37.9 | 25.7 |
| 114 | 213 | 33 | 29.317 | 32.731 | 13.026 | 39.58 | 25.36 |
| 135 | 132 | 33 | 13.933 | 17.846 | 6.937 | 26.82 | 28.11 |
| 190 | 228 | 33 | 18.05 | 18.737 | 3.781 | 15.52 | 12.51 |
| 39 | 87 | 33 | 51.733 | 50.643 | 16.067 | 47.32 | 20.31 |
| 247 | 142 | 33 | 30.367 | 31.976 | 6.572 | 25.59 | 12.98 |
| 61 | 40 | 33 | 17.317 | 18.169 | 3.631 | 14.86 | 12.38 |
| 211 | 55 | 33 | 34.667 | 39.183 | 15.219 | 45.24 | 24.9 |
| 125 | 247 | 33 | 32.917 | 36.257 | 11.321 | 36.62 | 19.95 |
| 97 | 116 | 33 | 34.217 | 38.202 | 13.645 | 41.59 | 23.37 |
| 169 | 242 | 33 | 24.45 | 24.178 | 5.666 | 21.15 | 14.71 |
| 238 | 165 | 33 | 51.7 | 53.366 | 15.808 | 50.65 | 18.62 |
| 181 | 166 | 33 | 39.35 | 41.227 | 12.426 | 40.17 | 19.18 |