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 |
|---|---|---|---|---|---|---|---|
| 168 | 76 | 18 | 42.542 | 46.165 | 18.442 | 53.95 | 25.91 |
| 223 | 147 | 18 | 14.258 | 15.635 | 5.261 | 17.49 | 21.16 |
| 216 | 72 | 18 | 27.942 | 28.588 | 7.402 | 26.09 | 16.06 |
| 4 | 117 | 18 | 54.958 | 60.596 | 27.317 | 76.92 | 28.41 |
| 226 | 227 | 18 | 36.458 | 40.617 | 11.605 | 37.74 | 20.96 |
| 12 | 74 | 18 | 27.242 | 29.463 | 9.792 | 30.72 | 22.16 |
| 72 | 189 | 18 | 20 | 23.585 | 3.623 | 17.14 | 10.15 |
| 55 | 181 | 18 | 33.85 | 35.981 | 9.527 | 33.02 | 17.22 |
| 36 | 158 | 18 | 27.658 | 29.408 | 6.97 | 25.36 | 14.71 |
| 80 | 243 | 18 | 28.875 | 32.028 | 14.513 | 42.56 | 29.32 |
| 247 | 255 | 18 | 37.358 | 40.457 | 12.107 | 39.28 | 20.03 |
| 263 | 98 | 18 | 29.708 | 31.018 | 15.182 | 42.73 | 30.19 |
| 79 | 8 | 18 | 24.483 | 24.924 | 7.266 | 24.14 | 18.51 |
| 25 | 196 | 18 | 27.333 | 28.531 | 9.351 | 29.63 | 20.79 |
| 161 | 117 | 18 | 78.45 | 74.652 | 21.756 | 69.31 | 18.65 |
| 116 | 216 | 18 | 55.258 | 55.201 | 15.896 | 49.52 | 17.89 |
| 12 | 179 | 18 | 29.15 | 31.562 | 10.687 | 33.44 | 21.58 |
| 38 | 25 | 18 | 46.758 | 51.062 | 19.724 | 58.45 | 24.34 |
| 195 | 227 | 18 | 17 | 16.878 | 4.001 | 15.36 | 14.63 |
| 133 | 91 | 18 | 23.675 | 24.487 | 4.021 | 18.15 | 10.74 |
| 66 | 116 | 18 | 33.633 | 35.345 | 12.892 | 39.03 | 22.8 |
| 68 | 139 | 18 | 45.242 | 50.005 | 20.248 | 59.65 | 25.95 |
| 62 | 234 | 18 | 42.75 | 42.486 | 7.63 | 30.44 | 10.96 |
| 209 | 10 | 18 | 57.267 | 58.488 | 18.372 | 54.63 | 20.82 |
| 234 | 251 | 18 | 38.575 | 39.125 | 18.186 | 51.75 | 28.63 |