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 |
|---|---|---|---|---|---|---|---|
| 80 | 6 | 2 | 29.742 | 29.742 | 14.665 | 42 | 30.95 |
| 189 | 171 | 2 | 42.508 | 42.508 | 15.395 | 45.75 | 21.86 |
| 152 | 26 | 2 | 45.292 | 45.292 | 15.685 | 47.75 | 21.37 |
| 80 | 115 | 2 | 28.825 | 28.825 | 14.355 | 40.75 | 32.82 |
| 97 | 44 | 2 | 46.55 | 46.55 | 25.99 | 73.25 | 34.61 |
| 72 | 257 | 2 | 24.117 | 24.117 | 3.855 | 17.46 | 9.58 |
| 108 | 186 | 2 | 49.308 | 49.308 | 15.8 | 49.25 | 20.37 |
| 10 | 136 | 2 | 42.608 | 42.608 | 20.44 | 57 | 34.25 |
| 243 | 55 | 2 | 72.45 | 72.45 | 25.415 | 75.75 | 21.07 |
| 94 | 191 | 2 | 35.108 | 35.108 | 15.82 | 43.1 | 26.98 |
| 51 | 177 | 2 | 40.408 | 40.408 | 18.615 | 53.04 | 31.8 |
| 36 | 202 | 2 | 37.842 | 37.842 | 8.73 | 31.25 | 13.67 |
| 258 | 208 | 2 | 49.633 | 49.633 | 14.705 | 49.5 | 19.58 |
| 189 | 196 | 2 | 29.8 | 29.8 | 9.95 | 30.75 | 20.11 |
| 222 | 40 | 2 | 26.867 | 26.867 | 18.82 | 50.25 | 42.57 |
| 86 | 148 | 2 | 61.575 | 61.575 | 24.43 | 71 | 24.29 |
| 126 | 183 | 2 | 17.917 | 17.917 | 5.465 | 19.5 | 18.88 |
| 202 | 121 | 2 | 41.483 | 41.483 | 12.745 | 40.75 | 19.44 |
| 58 | 259 | 2 | 16.608 | 16.608 | 4.815 | 16.5 | 17.42 |
| 242 | 165 | 2 | 62.667 | 62.667 | 26.44 | 75.75 | 26.73 |
| 155 | 158 | 2 | 58.017 | 58.017 | 22.805 | 64 | 27.28 |
| 242 | 90 | 2 | 41.467 | 41.467 | 14.19 | 43.25 | 20.93 |
| 194 | 66 | 2 | 51.008 | 51.008 | 15.035 | 46.5 | 23.13 |
| 45 | 214 | 2 | 32.017 | 32.017 | 13.6 | 40.25 | 25.59 |
| 3 | 31 | 2 | 9.958 | 9.958 | 2.56 | 10.5 | 14.1 |