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 |
|---|---|---|---|---|---|---|---|
| 35 | 150 | 16 | 37.133 | 35.26 | 10.599 | 34.97 | 19.21 |
| 3 | 75 | 16 | 40.642 | 43.501 | 10.48 | 35.21 | 16.27 |
| 144 | 250 | 16 | 34.908 | 37.855 | 14.302 | 44.06 | 24.99 |
| 14 | 255 | 16 | 28.3 | 29.644 | 11.656 | 34.91 | 25.25 |
| 62 | 210 | 16 | 27.675 | 27.896 | 6.036 | 22.4 | 13.33 |
| 261 | 218 | 16 | 54.325 | 60.069 | 23.791 | 68.19 | 25.85 |
| 70 | 238 | 16 | 35.9 | 36.205 | 9.445 | 35 | 17.37 |
| 153 | 128 | 16 | 2.767 | 2.951 | 0.541 | 4.09 | 12.18 |
| 182 | 159 | 16 | 24.833 | 25.295 | 5.033 | 20.88 | 13.98 |
| 225 | 41 | 16 | 53.425 | 54.124 | 13.752 | 47.47 | 16.11 |
| 161 | 57 | 16 | 42.992 | 47.529 | 11.163 | 39.97 | 16.17 |
| 227 | 91 | 16 | 30.267 | 33.907 | 6.553 | 26.53 | 12.43 |
| 259 | 79 | 16 | 44.392 | 48.236 | 16.111 | 45.64 | 20.76 |
| 226 | 257 | 16 | 24.125 | 26.741 | 10.57 | 31.66 | 26.16 |
| 195 | 232 | 16 | 19.667 | 19.547 | 5.521 | 19.34 | 18.38 |
| 70 | 36 | 16 | 27.967 | 27.068 | 7.865 | 25.84 | 18.42 |
| 91 | 22 | 16 | 23.867 | 24.805 | 5.432 | 21.21 | 13.97 |
| 195 | 145 | 16 | 35.55 | 39.933 | 10.468 | 32.65 | 16.86 |
| 91 | 100 | 16 | 53.067 | 60.881 | 13.29 | 48.53 | 14.17 |
| 178 | 33 | 16 | 28.25 | 28.83 | 6.381 | 23.7 | 13.58 |
| 14 | 237 | 16 | 46.942 | 46.454 | 11.308 | 38.44 | 15.74 |
| 190 | 195 | 16 | 21.042 | 23.081 | 4.629 | 18.66 | 12.63 |
| 197 | 160 | 16 | 23.575 | 21.708 | 4.738 | 17.87 | 14.1 |
| 62 | 14 | 16 | 32.667 | 33.377 | 7.569 | 28.02 | 14.14 |
| 66 | 93 | 16 | 33.867 | 37.35 | 11.679 | 37.72 | 21.45 |