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 |
|---|---|---|---|---|---|---|---|
| 7 | 102 | 39 | 24.117 | 24.997 | 9.424 | 29.28 | 24.32 |
| 54 | 97 | 39 | 12.433 | 13.324 | 2.405 | 11.27 | 11.44 |
| 93 | 197 | 39 | 11.733 | 14.673 | 5.48 | 22.23 | 27.22 |
| 258 | 196 | 39 | 14.767 | 18.603 | 3.172 | 15.13 | 12.93 |
| 202 | 162 | 39 | 11.7 | 14.429 | 2.394 | 14.94 | 10.6 |
| 39 | 231 | 39 | 49.917 | 49.165 | 16.28 | 49.27 | 22.92 |
| 148 | 47 | 39 | 30.283 | 33.838 | 12.666 | 38.3 | 25.12 |
| 51 | 41 | 39 | 32.467 | 34.032 | 11.563 | 36.14 | 21.22 |
| 144 | 130 | 39 | 39.25 | 42.387 | 14.646 | 45.49 | 23.66 |
| 174 | 136 | 39 | 15.1 | 16.074 | 2.39 | 12.37 | 9.31 |
| 256 | 54 | 39 | 13.817 | 16.524 | 5.298 | 17.97 | 21.11 |
| 224 | 200 | 39 | 31.467 | 34.751 | 15.368 | 43.79 | 28.16 |
| 223 | 80 | 39 | 18.483 | 19.959 | 6.564 | 21.65 | 22.24 |
| 216 | 228 | 39 | 42.25 | 43.672 | 21.192 | 57.17 | 30.89 |
| 82 | 114 | 39 | 21.7 | 24.772 | 8.125 | 49.86 | 22.12 |
| 239 | 63 | 39 | 47.15 | 49.268 | 15.766 | 49.48 | 20.6 |
| 125 | 155 | 39 | 39.117 | 41.264 | 13.154 | 41.79 | 19.64 |
| 262 | 240 | 39 | 19.267 | 21.602 | 9.909 | 29.31 | 30.03 |
| 134 | 258 | 39 | 15.167 | 15.323 | 3.09 | 13.12 | 12.52 |
| 79 | 191 | 39 | 41.483 | 45.819 | 17.434 | 50.93 | 25.08 |
| 145 | 258 | 39 | 29.283 | 30.7 | 8.723 | 29.34 | 18.75 |
| 95 | 263 | 39 | 37.1 | 39.565 | 12.261 | 38.93 | 20.59 |
| 63 | 61 | 39 | 20.9 | 22.225 | 4.017 | 16.67 | 11.15 |
| 254 | 159 | 39 | 22.3 | 24.72 | 8.519 | 27.15 | 22.19 |
| 158 | 119 | 39 | 31.267 | 32.55 | 10.974 | 34.87 | 21.64 |