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 |
|---|---|---|---|---|---|---|---|
| 55 | 108 | 55 | 9.717 | 11.558 | 1.828 | 10.28 | 10.37 |
| 194 | 24 | 55 | 18.2 | 19.2 | 4.131 | 47.62 | 13.76 |
| 168 | 241 | 55 | 19.183 | 23.069 | 5.952 | 21.59 | 18.97 |
| 160 | 196 | 55 | 7.317 | 7.7 | 1.256 | 9.95 | 16.87 |
| 36 | 226 | 55 | 17.2 | 18.045 | 4.234 | 15.87 | 14.65 |
| 85 | 25 | 55 | 24.75 | 25.111 | 4.157 | 18.62 | 10.96 |
| 263 | 28 | 55 | 28.35 | 32.114 | 13.405 | 39.66 | 27.83 |
| 181 | 82 | 55 | 32.817 | 36.419 | 9.715 | 33.14 | 17.77 |
| 70 | 141 | 55 | 24.233 | 28.709 | 7.37 | 25.78 | 16.63 |
| 223 | 61 | 55 | 33.433 | 37.064 | 9.972 | 35.32 | 17.98 |
| 91 | 97 | 55 | 35.617 | 36.388 | 6.134 | 25.47 | 10.33 |
| 113 | 167 | 55 | 31.083 | 36.508 | 10.588 | 34.7 | 19.33 |
| 226 | 53 | 55 | 23.85 | 27.307 | 9.139 | 29.05 | 22.15 |
| 69 | 94 | 55 | 11.267 | 12.163 | 2.633 | 11.06 | 14.11 |
| 164 | 183 | 55 | 33.733 | 35.634 | 13.549 | 41.15 | 24.04 |
| 87 | 167 | 55 | 37.3 | 42.797 | 12.225 | 40.09 | 19.41 |
| 148 | 182 | 55 | 32.183 | 32.657 | 13.928 | 40.85 | 26.82 |
| 33 | 55 | 55 | 29.85 | 31.018 | 12.262 | 36.67 | 24.86 |
| 39 | 62 | 55 | 25.4 | 25.805 | 4.214 | 19.23 | 10.08 |
| 79 | 201 | 55 | 44.75 | 47.217 | 23.987 | 66.62 | 31.53 |
| 75 | 52 | 55 | 32.883 | 35.065 | 10.282 | 33.18 | 18.76 |
| 78 | 159 | 55 | 21.7 | 21.068 | 3.077 | 15.44 | 9.52 |
| 143 | 198 | 55 | 38.9 | 41.008 | 9.133 | 33.45 | 13.97 |
| 196 | 140 | 55 | 25.683 | 29.18 | 8.209 | 31.69 | 18.61 |
| 130 | 125 | 55 | 39.3 | 39.169 | 15.128 | 51.85 | 24.79 |