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 |
|---|---|---|---|---|---|---|---|
| 196 | 144 | 33 | 28.267 | 27.346 | 8.996 | 51.08 | 21.27 |
| 129 | 61 | 33 | 30.65 | 32.975 | 11.14 | 34.91 | 21.26 |
| 223 | 252 | 33 | 17.783 | 20.401 | 8.122 | 26.53 | 26.95 |
| 196 | 258 | 33 | 17.4 | 18.356 | 4.305 | 16.47 | 14.49 |
| 21 | 143 | 33 | 56.517 | 58.184 | 14.707 | 48.53 | 15.32 |
| 209 | 77 | 33 | 50.917 | 49.967 | 8.676 | 34.99 | 10.59 |
| 51 | 168 | 33 | 27.367 | 29.157 | 10.177 | 32.2 | 22.76 |
| 52 | 36 | 33 | 24.933 | 25.594 | 6.048 | 22.23 | 14.89 |
| 145 | 63 | 33 | 36.933 | 39.08 | 11.891 | 39.71 | 19.7 |
| 32 | 259 | 33 | 11.883 | 12.313 | 2.779 | 11.65 | 13.91 |
| 218 | 236 | 33 | 59.217 | 58.799 | 17.465 | 52.93 | 29.69 |
| 233 | 77 | 33 | 45.933 | 47.305 | 13.135 | 43.44 | 17.62 |
| 179 | 8 | 33 | 6.117 | 6.727 | 1.126 | 6.7 | 9.79 |
| 74 | 195 | 33 | 39.3 | 40.479 | 13.547 | 41.78 | 21.43 |
| 194 | 79 | 33 | 26.917 | 29.841 | 8.558 | 28.58 | 19.1 |
| 239 | 10 | 33 | 51.017 | 55.267 | 19.462 | 57.32 | 22.34 |
| 148 | 32 | 33 | 33.5 | 34.222 | 15.058 | 43.52 | 27.28 |
| 141 | 124 | 33 | 41.983 | 48.721 | 13.416 | 44.82 | 17.68 |
| 60 | 213 | 33 | 11.683 | 11.981 | 2.521 | 10.97 | 13.04 |
| 244 | 3 | 33 | 30.3 | 31.571 | 9.615 | 31.95 | 20.04 |
| 112 | 42 | 33 | 30.767 | 32.6 | 9.758 | 31.85 | 19.23 |
| 92 | 130 | 33 | 25.35 | 25.882 | 6.264 | 23.29 | 15.72 |
| 168 | 220 | 33 | 20.65 | 23.835 | 6.909 | 23.86 | 19.8 |
| 42 | 14 | 33 | 47.083 | 48.675 | 17.68 | 52.56 | 23.33 |
| 12 | 89 | 33 | 25.567 | 26.371 | 7.491 | 25.52 | 18.51 |