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 |
|---|---|---|---|---|---|---|---|
| 238 | 130 | 49 | 45.967 | 49.04 | 16.448 | 50.03 | 21.89 |
| 45 | 247 | 49 | 35.267 | 38.648 | 11.482 | 36.6 | 20.14 |
| 138 | 245 | 49 | 47.8 | 51.947 | 23.01 | 64.24 | 28.56 |
| 224 | 152 | 49 | 24.733 | 26.74 | 8.148 | 26.93 | 19.99 |
| 260 | 216 | 49 | 27.883 | 28.858 | 10.198 | 34.96 | 23.86 |
| 130 | 117 | 49 | 45.633 | 46.752 | 13.347 | 45.01 | 17.81 |
| 114 | 71 | 49 | 34.6 | 35.852 | 9.054 | 31.65 | 15.36 |
| 195 | 162 | 49 | 30.567 | 32.383 | 9.047 | 30.02 | 17.16 |
| 48 | 58 | 49 | 31.733 | 33.513 | 14.681 | 42.32 | 27.88 |
| 112 | 160 | 49 | 16.25 | 18.522 | 5.021 | 17.97 | 17.72 |
| 169 | 51 | 49 | 25.5 | 26.265 | 8.5 | 28.36 | 21.05 |
| 196 | 216 | 49 | 21.017 | 22.452 | 6.353 | 27.49 | 19.02 |
| 237 | 10 | 49 | 49.65 | 51.488 | 16.161 | 49.55 | 19.91 |
| 189 | 48 | 49 | 35.833 | 37.415 | 7.832 | 29.91 | 13.47 |
| 32 | 3 | 49 | 7 | 8.877 | 1.386 | 8.16 | 9.5 |
| 25 | 222 | 49 | 39.767 | 42.063 | 9.797 | 35.52 | 14.56 |
| 94 | 74 | 49 | 28.583 | 29.849 | 5.589 | 23.12 | 12.01 |
| 151 | 94 | 49 | 26.45 | 28.415 | 7.596 | 26.29 | 17.99 |
| 169 | 136 | 49 | 12.45 | 13.634 | 1.783 | 10.46 | 8.81 |
| 88 | 210 | 49 | 31.933 | 33.041 | 15.409 | 44.11 | 29.53 |
| 218 | 219 | 49 | 9.183 | 10.215 | 2.276 | 10.09 | 14.55 |
| 14 | 155 | 49 | 30.65 | 32.574 | 11.012 | 34.21 | 22.09 |
| 126 | 167 | 49 | 8.733 | 8.975 | 1.108 | 7.47 | 8.31 |
| 261 | 10 | 49 | 51.933 | 60.587 | 20.847 | 56.38 | 22.83 |
| 241 | 244 | 49 | 22.25 | 23.912 | 5.616 | 20.98 | 15.63 |