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 |
|---|---|---|---|---|---|---|---|
| 239 | 126 | 86 | 27.208 | 29.562 | 8.147 | 27.73 | 18.04 |
| 43 | 54 | 86 | 31.933 | 33.75 | 10.492 | 33.8 | 19.71 |
| 114 | 149 | 86 | 34.975 | 36.821 | 11.37 | 36.35 | 19.41 |
| 246 | 85 | 86 | 40.933 | 43.824 | 10.359 | 36.98 | 14.99 |
| 42 | 242 | 86 | 22.608 | 25.518 | 7.558 | 25.34 | 19.48 |
| 80 | 83 | 86 | 12.1 | 12.753 | 4.193 | 14.59 | 22.69 |
| 242 | 254 | 86 | 17.858 | 19.521 | 3.686 | 15.87 | 11.83 |
| 35 | 17 | 86 | 20.975 | 22.51 | 3.661 | 16.87 | 10.23 |
| 196 | 163 | 86 | 30.2 | 31.315 | 8.379 | 48.73 | 17.77 |
| 211 | 173 | 86 | 29.825 | 32.011 | 10.148 | 33.32 | 20.38 |
| 80 | 177 | 86 | 21.292 | 22.915 | 3.71 | 16.47 | 10.54 |
| 113 | 35 | 86 | 40.208 | 43.19 | 8.916 | 33.89 | 13.3 |
| 210 | 155 | 86 | 13.575 | 13.981 | 2.658 | 12.21 | 11.73 |
| 145 | 97 | 86 | 18.2 | 20.876 | 5.6 | 19.7 | 17.34 |
| 134 | 230 | 86 | 34.392 | 36.705 | 12.163 | 51.89 | 21.86 |
| 223 | 50 | 86 | 33.508 | 34.128 | 8.944 | 36.06 | 16.68 |
| 164 | 15 | 86 | 33.217 | 34.862 | 15.421 | 44.91 | 28.13 |
| 97 | 82 | 86 | 25.317 | 26.75 | 8.399 | 27.88 | 20.53 |
| 161 | 177 | 85 | 43.75 | 45.009 | 11.517 | 39.46 | 17.6 |
| 220 | 136 | 85 | 9.217 | 10.167 | 1.484 | 8.56 | 9.67 |
| 170 | 174 | 85 | 31.667 | 34.446 | 13.719 | 40.74 | 25.55 |
| 7 | 116 | 85 | 19.517 | 23.353 | 7.213 | 24.18 | 20.2 |
| 90 | 213 | 85 | 31.267 | 36.666 | 12.89 | 39.77 | 23.46 |
| 129 | 207 | 85 | 6.65 | 6.815 | 1.641 | 8.87 | 15.93 |
| 195 | 228 | 85 | 10.633 | 12.385 | 3.141 | 12.74 | 16.5 |