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 |
|---|---|---|---|---|---|---|---|
| 132 | 154 | 605 | 22.567 | 26.417 | 13.818 | 38.41 | 34.54 |
| 42 | 141 | 605 | 20.933 | 21.9 | 4.175 | 17.22 | 12.6 |
| 146 | 230 | 604 | 18.192 | 20.194 | 3.317 | 16.07 | 11.22 |
| 65 | 52 | 604 | 9.042 | 9.401 | 1.387 | 8.03 | 9.25 |
| 233 | 14 | 604 | 30.65 | 32.766 | 12.698 | 37.77 | 24.72 |
| 132 | 147 | 603 | 38.217 | 41.205 | 19.624 | 55.07 | 31.06 |
| 100 | 62 | 603 | 42.817 | 44.56 | 9.487 | 35.24 | 13.57 |
| 116 | 163 | 603 | 20.083 | 21.332 | 5.666 | 20.68 | 17.43 |
| 181 | 231 | 603 | 17.267 | 18.695 | 3.77 | 15.88 | 12.94 |
| 24 | 158 | 603 | 21.85 | 22.775 | 6.155 | 21.75 | 17.01 |
| 230 | 216 | 602 | 46.7 | 51.389 | 15.48 | 50.35 | 20.48 |
| 141 | 247 | 602 | 19.825 | 21.439 | 6.148 | 21.06 | 18.82 |
| 48 | 196 | 601 | 29.433 | 32.092 | 8.799 | 30.28 | 17.94 |
| 43 | 66 | 600 | 33.067 | 34.556 | 8.516 | 30 | 15.82 |
| 112 | 37 | 600 | 14.142 | 15.122 | 2.619 | 12.05 | 10.68 |
| 223 | 260 | 600 | 9.708 | 10.573 | 2.629 | 11.05 | 16.35 |
| 145 | 234 | 600 | 15.725 | 17.696 | 3.376 | 40.33 | 12.7 |
| 4 | 142 | 599 | 22.983 | 25.064 | 4.889 | 19.9 | 12.61 |
| 97 | 34 | 599 | 7.3 | 8.054 | 1.295 | 7.41 | 10.42 |
| 144 | 14 | 599 | 25.35 | 27.236 | 9.765 | 30.33 | 23.21 |
| 87 | 188 | 597 | 26.567 | 27.983 | 6.157 | 23.03 | 13.92 |
| 161 | 200 | 597 | 31.517 | 34.016 | 12.16 | 37.79 | 22.92 |
| 25 | 188 | 595 | 16.267 | 17.566 | 3.197 | 14.22 | 11.77 |
| 261 | 195 | 595 | 17.3 | 19.251 | 4.586 | 17.39 | 15.59 |
| 125 | 61 | 595 | 26.383 | 28.145 | 5.729 | 22.54 | 12.86 |