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 |
|---|---|---|---|---|---|---|---|
| 112 | 205 | 7 | 39.433 | 40.181 | 14.397 | 42.73 | 21.8 |
| 72 | 74 | 7 | 55.717 | 58.652 | 18.666 | 58.36 | 20.51 |
| 207 | 70 | 7 | 6.833 | 11.588 | 3.809 | 13 | 18.01 |
| 69 | 39 | 7 | 62.2 | 67.667 | 21.659 | 65.28 | 19.71 |
| 150 | 178 | 7 | 21.233 | 23.09 | 4.944 | 19.64 | 12.77 |
| 153 | 20 | 7 | 13.367 | 14.081 | 2.684 | 11.79 | 11.53 |
| 29 | 222 | 7 | 25.433 | 28.69 | 10.977 | 26.65 | 23.7 |
| 152 | 197 | 7 | 38.633 | 38.555 | 14.186 | 42.64 | 25.17 |
| 146 | 182 | 7 | 36.75 | 37.279 | 10.879 | 34.29 | 18.58 |
| 79 | 122 | 7 | 51.55 | 49.988 | 18.054 | 53.57 | 23.59 |
| 168 | 184 | 7 | 22.817 | 26.793 | 9.104 | 29.14 | 23.74 |
| 117 | 95 | 7 | 42.183 | 40.89 | 12.906 | 39.57 | 19.27 |
| 70 | 86 | 7 | 47.5 | 46.555 | 16.404 | 50.57 | 22.45 |
| 114 | 245 | 7 | 37 | 38.914 | 16.079 | 46.36 | 25.58 |
| 136 | 137 | 7 | 34.583 | 35.276 | 11.95 | 36.13 | 21.16 |
| 197 | 71 | 7 | 43.05 | 45.317 | 11.159 | 38.64 | 15.05 |
| 38 | 216 | 7 | 23.783 | 23.376 | 9.58 | 27.6 | 24.8 |
| 90 | 175 | 7 | 31.317 | 38.269 | 15.056 | 44.64 | 28.14 |
| 250 | 76 | 7 | 44.417 | 44.826 | 16.956 | 49.99 | 23.74 |
| 205 | 112 | 7 | 50.3 | 50.11 | 14.764 | 46.19 | 18.85 |
| 250 | 173 | 7 | 26.183 | 26.864 | 9.664 | 29.29 | 21.9 |
| 15 | 238 | 7 | 41.05 | 41.25 | 15.516 | 46.07 | 23.97 |
| 29 | 228 | 7 | 26.8 | 32.44 | 10.546 | 32.33 | 20.59 |
| 169 | 68 | 7 | 33.317 | 29.788 | 11.067 | 33.91 | 23.42 |
| 126 | 3 | 7 | 17.483 | 20.688 | 6.157 | 21.14 | 19.34 |