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 |
|---|---|---|---|---|---|---|---|
| 170 | 218 | 45 | 42.417 | 48.379 | 16.512 | 48.17 | 22.54 |
| 45 | 131 | 45 | 52.3 | 50.964 | 16.634 | 50.6 | 23.29 |
| 212 | 75 | 45 | 22.283 | 26.161 | 6.809 | 23.77 | 17.79 |
| 188 | 138 | 45 | 34.583 | 37.644 | 12.617 | 39.36 | 21.85 |
| 239 | 78 | 45 | 26.4 | 30.199 | 9.374 | 30.34 | 20.68 |
| 72 | 261 | 45 | 25.667 | 30.142 | 7.871 | 26.8 | 16.98 |
| 93 | 202 | 45 | 22.033 | 24.167 | 8.387 | 49.54 | 21.98 |
| 65 | 83 | 45 | 19.117 | 20.476 | 7.27 | 22.93 | 24.27 |
| 23 | 23 | 45 | 3.217 | 8.404 | 1.541 | 16.84 | 30.66 |
| 161 | 47 | 45 | 34.05 | 37.094 | 9.571 | 33.04 | 16.98 |
| 56 | 75 | 45 | 34.933 | 36.596 | 11.122 | 36.61 | 19.78 |
| 69 | 107 | 45 | 42.15 | 41.879 | 9.271 | 33.15 | 14.08 |
| 10 | 93 | 45 | 23.9 | 27.126 | 9.956 | 37.47 | 24.73 |
| 182 | 185 | 45 | 11.067 | 10.904 | 1.881 | 9.44 | 10.95 |
| 213 | 76 | 45 | 41.9 | 43.891 | 16.327 | 48.94 | 23.71 |
| 97 | 95 | 45 | 25.017 | 26.813 | 10.437 | 31.89 | 25.39 |
| 162 | 60 | 45 | 25.417 | 30.48 | 9.059 | 30.05 | 20.39 |
| 17 | 42 | 45 | 41.267 | 41.518 | 13.936 | 42.23 | 21.94 |
| 70 | 231 | 45 | 32.65 | 35.004 | 13.48 | 39.18 | 23.93 |
| 151 | 153 | 45 | 23.15 | 24.189 | 7.605 | 25.22 | 20.28 |
| 197 | 28 | 45 | 8.517 | 10.377 | 2.324 | 10.08 | 13.27 |
| 82 | 211 | 45 | 23.667 | 26.27 | 8.604 | 50.51 | 22.15 |
| 168 | 25 | 45 | 46.633 | 47.105 | 12.413 | 41.74 | 17.26 |
| 24 | 95 | 45 | 33.067 | 37.629 | 12.619 | 39.52 | 21.4 |
| 17 | 138 | 45 | 26.35 | 29.672 | 10.29 | 31.92 | 22.83 |