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 |
|---|---|---|---|---|---|---|---|
| 248 | 194 | 2 | 18.658 | 18.658 | 5.895 | 19.5 | 21.7 |
| 3 | 252 | 2 | 19.025 | 19.025 | 7.85 | 24.5 | 25.01 |
| 177 | 19 | 2 | 31.575 | 31.575 | 11.755 | 35.5 | 22.56 |
| 83 | 217 | 2 | 22.825 | 22.825 | 6.275 | 21.75 | 17.59 |
| 191 | 93 | 2 | 15.2 | 15.2 | 6.8 | 21.5 | 30.21 |
| 132 | 99 | 2 | 63.117 | 63.117 | 33.515 | 89.75 | 32.63 |
| 101 | 179 | 2 | 43.667 | 43.667 | 17.11 | 50 | 23.93 |
| 190 | 258 | 2 | 43.067 | 43.067 | 8.865 | 32.75 | 12.4 |
| 49 | 136 | 2 | 37.7 | 37.7 | 16.38 | 47.25 | 26.65 |
| 29 | 88 | 2 | 65.008 | 65.008 | 16.18 | 54.25 | 14.81 |
| 192 | 35 | 2 | 28.283 | 28.283 | 8.885 | 28.5 | 19.31 |
| 66 | 135 | 2 | 28.525 | 28.525 | 14.375 | 41.5 | 30.68 |
| 242 | 9 | 2 | 35.775 | 35.775 | 11.03 | 36 | 18.5 |
| 38 | 211 | 2 | 51.9 | 51.9 | 21.65 | 63.5 | 25.1 |
| 26 | 258 | 2 | 42.083 | 42.083 | 18.02 | 52.5 | 25.83 |
| 3 | 218 | 2 | 62.058 | 62.058 | 16.835 | 53.75 | 16.59 |
| 165 | 121 | 2 | 43.358 | 43.358 | 18.15 | 52 | 26.33 |
| 134 | 259 | 2 | 34.758 | 34.758 | 15.6 | 45.25 | 30.25 |
| 124 | 165 | 2 | 24.5 | 24.5 | 11.45 | 34 | 28.73 |
| 220 | 66 | 2 | 54.925 | 54.925 | 17.73 | 55.75 | 19.48 |
| 253 | 216 | 2 | 22.333 | 22.333 | 7.85 | 24.5 | 21.81 |
| 72 | 69 | 2 | 58.642 | 58.642 | 20.65 | 62 | 21.2 |
| 21 | 209 | 2 | 34.117 | 34.117 | 10.77 | 39.55 | 19.24 |
| 191 | 167 | 2 | 28.242 | 28.242 | 14.355 | 41.25 | 30.72 |
| 64 | 85 | 2 | 59.817 | 59.817 | 18.59 | 59 | 18.56 |