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 |
|---|---|---|---|---|---|---|---|
| 12 | 144 | 857 | 16.417 | 17.248 | 2.329 | 12.8 | 8.45 |
| 114 | 228 | 857 | 24.217 | 25.397 | 7.451 | 25.12 | 18.63 |
| 238 | 247 | 856 | 19.425 | 20.706 | 5.014 | 18.73 | 15.69 |
| 166 | 158 | 856 | 24.333 | 25.557 | 6.562 | 23.54 | 16.17 |
| 234 | 12 | 856 | 19.367 | 19.981 | 3.868 | 16.41 | 12.51 |
| 234 | 257 | 855 | 29.3 | 30.472 | 8.766 | 29.07 | 18.16 |
| 68 | 257 | 855 | 26.75 | 28.928 | 8.601 | 28.42 | 18.92 |
| 137 | 116 | 854 | 25.167 | 28.725 | 7.978 | 26.99 | 18.87 |
| 142 | 97 | 854 | 36.05 | 37.36 | 8.659 | 31.25 | 14.55 |
| 75 | 247 | 854 | 14.85 | 16.07 | 3.709 | 14.57 | 15.76 |
| 13 | 189 | 853 | 24.6 | 25.86 | 5.68 | 21.58 | 13.84 |
| 237 | 65 | 853 | 28.267 | 29.678 | 7.87 | 27.33 | 17.14 |
| 74 | 100 | 853 | 21.683 | 24.5 | 5.253 | 20.34 | 14.73 |
| 24 | 229 | 852 | 22.75 | 23.732 | 4.316 | 18.43 | 11.66 |
| 52 | 66 | 851 | 9.483 | 10.199 | 1.55 | 8.53 | 9.66 |
| 97 | 79 | 849 | 14.517 | 15.575 | 3.432 | 14.17 | 13.83 |
| 145 | 233 | 849 | 10 | 11.818 | 2.523 | 37.16 | 15.51 |
| 163 | 82 | 849 | 26.133 | 27.647 | 6.496 | 24.07 | 14.83 |
| 209 | 25 | 849 | 12.817 | 13.419 | 2.691 | 11.64 | 12.98 |
| 244 | 140 | 848 | 27.842 | 28.697 | 7.165 | 25.57 | 16.64 |
| 231 | 54 | 848 | 15.092 | 15.57 | 3.478 | 13.69 | 14.67 |
| 163 | 49 | 846 | 35.242 | 36.987 | 8.507 | 30.79 | 14.61 |
| 125 | 151 | 846 | 22.442 | 24.317 | 6.33 | 22.68 | 16.55 |
| 261 | 52 | 846 | 15.442 | 16.185 | 3.266 | 13.42 | 12.88 |
| 48 | 69 | 845 | 26.217 | 28.516 | 9.144 | 29.64 | 20.9 |