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 |
|---|---|---|---|---|---|---|---|
| 174 | 127 | 6 | 16.258 | 15.656 | 3.54 | 14.17 | 14.16 |
| 92 | 91 | 6 | 39.892 | 44.578 | 14.748 | 46.42 | 21.27 |
| 207 | 83 | 6 | 15.567 | 15.553 | 4.017 | 19.92 | 15.91 |
| 137 | 27 | 6 | 41.992 | 49.228 | 24.588 | 68.25 | 32 |
| 258 | 65 | 6 | 52.1 | 47.658 | 10.148 | 36.28 | 15.53 |
| 96 | 95 | 6 | 11.617 | 14.15 | 2.752 | 12.25 | 12.15 |
| 116 | 198 | 6 | 48.483 | 48.106 | 14.288 | 46.42 | 18.67 |
| 160 | 112 | 6 | 20.5 | 19.272 | 5.935 | 20.42 | 19.15 |
| 157 | 188 | 6 | 26.267 | 30.633 | 6.878 | 25.17 | 13.77 |
| 124 | 219 | 6 | 10.4 | 13.1 | 5.09 | 17.08 | 29.44 |
| 113 | 176 | 6 | 43.942 | 44.992 | 18.298 | 52.67 | 24.63 |
| 108 | 67 | 6 | 15.75 | 16.083 | 3.703 | 15.33 | 14.11 |
| 250 | 225 | 6 | 36.533 | 37.117 | 16.815 | 47.69 | 27.85 |
| 215 | 73 | 6 | 23.025 | 23.875 | 6.09 | 21.74 | 15.69 |
| 248 | 137 | 6 | 47.4 | 49.453 | 11.002 | 39.5 | 15.42 |
| 193 | 71 | 6 | 42.908 | 43.789 | 9.497 | 34.42 | 13.56 |
| 179 | 64 | 6 | 22.608 | 31.767 | 13.132 | 40.25 | 31.99 |
| 247 | 144 | 6 | 39.8 | 40.186 | 11.122 | 37.7 | 17.45 |
| 40 | 24 | 6 | 33.317 | 36.681 | 11.962 | 37.42 | 20.24 |
| 197 | 108 | 6 | 42.008 | 42.511 | 16.815 | 47.06 | 24.67 |
| 63 | 14 | 6 | 38.425 | 43.058 | 18.15 | 53.32 | 27.18 |
| 237 | 30 | 6 | 66.708 | 68.836 | 23.502 | 69.67 | 20.38 |
| 95 | 17 | 6 | 34.725 | 34.558 | 8.008 | 29.17 | 14.26 |
| 91 | 158 | 6 | 54.425 | 56.456 | 10.302 | 41.58 | 11.34 |
| 169 | 82 | 6 | 40.225 | 45.147 | 13.255 | 45.25 | 18.84 |