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 |
|---|---|---|---|---|---|---|---|
| 242 | 116 | 7 | 28.167 | 28.524 | 7.81 | 26.79 | 17.84 |
| 63 | 45 | 7 | 43.283 | 42.262 | 8.529 | 40.57 | 12.67 |
| 8 | 161 | 7 | 21.95 | 24.469 | 6.384 | 22.64 | 18.43 |
| 71 | 29 | 7 | 27.2 | 28.833 | 6.076 | 22.61 | 13.27 |
| 258 | 28 | 7 | 21.933 | 19.417 | 4.036 | 16.36 | 12.91 |
| 4 | 3 | 7 | 40.233 | 39.145 | 15.566 | 46.32 | 26.79 |
| 36 | 15 | 7 | 39.333 | 39.064 | 13.341 | 38.89 | 22.1 |
| 208 | 145 | 7 | 41.467 | 41.069 | 11.26 | 34.7 | 16.52 |
| 218 | 192 | 7 | 26.35 | 29.948 | 8.333 | 28.63 | 16.79 |
| 169 | 100 | 7 | 36.767 | 41.136 | 10.487 | 35.88 | 16.84 |
| 134 | 64 | 7 | 27.317 | 39.036 | 10.906 | 39.62 | 20.3 |
| 180 | 163 | 7 | 52.683 | 51.405 | 10.014 | 45.5 | 12.34 |
| 36 | 258 | 7 | 36.983 | 34.214 | 4.57 | 20.99 | 8.37 |
| 197 | 13 | 7 | 37.767 | 40.855 | 17.044 | 52 | 26.33 |
| 63 | 10 | 7 | 19.167 | 19.836 | 6.841 | 22.57 | 21.17 |
| 38 | 196 | 7 | 32.717 | 35.386 | 10.264 | 33.41 | 18.81 |
| 243 | 216 | 7 | 45.583 | 44.088 | 18.671 | 51.86 | 27.86 |
| 258 | 188 | 7 | 34.75 | 33.445 | 7.71 | 26.97 | 13.75 |
| 235 | 26 | 7 | 47.467 | 50.888 | 20.264 | 59.79 | 25.01 |
| 169 | 246 | 7 | 37.4 | 39.745 | 10.346 | 36 | 18 |
| 227 | 80 | 7 | 46.467 | 41.245 | 8.391 | 32.37 | 15.3 |
| 159 | 143 | 7 | 39.383 | 37.207 | 6.257 | 26.57 | 11.26 |
| 36 | 163 | 7 | 32 | 34.757 | 9.169 | 31.29 | 16.66 |
| 165 | 48 | 7 | 50.633 | 51.848 | 12.419 | 43.57 | 15.57 |
| 155 | 48 | 7 | 55.433 | 58.102 | 17.337 | 56.21 | 19.48 |