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 |
|---|---|---|---|---|---|---|---|
| 102 | 134 | 9 | 10.167 | 9.746 | 1.668 | 9.06 | 13.1 |
| 24 | 173 | 9 | 33.517 | 36.57 | 9.493 | 33.04 | 16.45 |
| 64 | 145 | 9 | 23.15 | 25.452 | 14.324 | 40.39 | 34.88 |
| 82 | 18 | 9 | 24.117 | 30.748 | 13.377 | 39.28 | 28.43 |
| 208 | 230 | 9 | 46.167 | 45.815 | 14.769 | 42.63 | 21.44 |
| 233 | 27 | 9 | 51.083 | 50.911 | 26.776 | 72.94 | 32.07 |
| 135 | 68 | 9 | 35.333 | 37.741 | 11.894 | 41.6 | 21.57 |
| 49 | 116 | 9 | 42.633 | 46.381 | 13.831 | 44.78 | 19.19 |
| 133 | 149 | 9 | 17.65 | 18.594 | 3.549 | 14.72 | 11.83 |
| 230 | 187 | 9 | 48.533 | 54.769 | 23.222 | 67.44 | 26.82 |
| 136 | 152 | 9 | 20.083 | 20.626 | 5.621 | 20 | 17.54 |
| 129 | 211 | 9 | 46.717 | 47.3 | 10.841 | 39.5 | 15.33 |
| 22 | 76 | 9 | 40.733 | 43.915 | 12.803 | 42 | 21.24 |
| 117 | 216 | 9 | 34.65 | 33.376 | 10.039 | 32.71 | 19.17 |
| 235 | 164 | 9 | 47.683 | 49.478 | 10.866 | 38 | 13.94 |
| 98 | 205 | 9 | 19.5 | 19.243 | 4.44 | 20.22 | 14.22 |
| 177 | 50 | 9 | 52.383 | 53.065 | 10.552 | 38.86 | 12.24 |
| 20 | 231 | 9 | 35.433 | 35.057 | 15.49 | 44.5 | 26.74 |
| 144 | 183 | 9 | 41.1 | 40.55 | 16.197 | 48.17 | 24.88 |
| 260 | 227 | 9 | 25.433 | 28.75 | 12.636 | 36.72 | 28.66 |
| 196 | 124 | 9 | 23.083 | 24.685 | 6.723 | 27.17 | 17.21 |
| 200 | 238 | 9 | 24.433 | 31.385 | 10.408 | 32.19 | 26.85 |
| 195 | 262 | 9 | 34.667 | 36.193 | 11.003 | 34.28 | 19.26 |
| 173 | 41 | 9 | 31.2 | 35.207 | 8.42 | 29.66 | 15.28 |
| 28 | 157 | 9 | 36.667 | 29.596 | 10.832 | 36.33 | 23.11 |