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 |
|---|---|---|---|---|---|---|---|
| 159 | 222 | 4 | 52.817 | 63.742 | 17.438 | 62.97 | 17.66 |
| 225 | 173 | 4 | 26.958 | 29.475 | 11.425 | 29.84 | 24.76 |
| 118 | 170 | 4 | 94.375 | 86.792 | 28.47 | 86.75 | 19.9 |
| 126 | 223 | 4 | 22.133 | 21.929 | 6.95 | 22.88 | 18.89 |
| 188 | 47 | 4 | 73.167 | 72.496 | 18.425 | 61.09 | 15.77 |
| 134 | 45 | 4 | 34.242 | 35.721 | 13.29 | 49.08 | 25.66 |
| 192 | 223 | 4 | 21.367 | 20.637 | 6.613 | 21.25 | 20.04 |
| 252 | 147 | 4 | 23.392 | 25.429 | 10.277 | 30.12 | 25.35 |
| 119 | 76 | 4 | 42.117 | 41.892 | 22.613 | 62.75 | 32.59 |
| 14 | 7 | 4 | 24.017 | 30.683 | 15.56 | 44.5 | 35.06 |
| 205 | 80 | 4 | 44.4 | 45.592 | 12.773 | 38.72 | 17.7 |
| 36 | 72 | 4 | 25.492 | 24.337 | 3.91 | 17.38 | 9.76 |
| 92 | 19 | 4 | 24.65 | 26.925 | 8.975 | 26.96 | 20.8 |
| 215 | 190 | 4 | 44.892 | 46.258 | 13.255 | 40.38 | 17.36 |
| 4 | 6 | 4 | 38.033 | 38.104 | 15.86 | 45.43 | 26.31 |
| 85 | 113 | 4 | 40.725 | 41.546 | 8.125 | 31.88 | 12.21 |
| 220 | 198 | 4 | 48.833 | 48.75 | 15.433 | 48.62 | 19.05 |
| 173 | 236 | 4 | 34.017 | 35.129 | 8.8 | 30.62 | 15.29 |
| 82 | 203 | 4 | 34.967 | 39.325 | 14.438 | 43.5 | 24.81 |
| 235 | 148 | 4 | 36.875 | 36.812 | 12.695 | 39.46 | 21.91 |
| 14 | 74 | 4 | 30.083 | 32.129 | 13.033 | 38 | 26.26 |
| 213 | 128 | 4 | 18.892 | 21.517 | 8.31 | 25.5 | 24.9 |
| 3 | 234 | 4 | 34.342 | 38.333 | 15.825 | 44.5 | 25.73 |
| 125 | 15 | 4 | 56.808 | 59.121 | 17.627 | 55.5 | 18.6 |
| 152 | 258 | 4 | 56.675 | 61.654 | 16.675 | 54.38 | 17.09 |