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 |
|---|---|---|---|---|---|---|---|
| 63 | 74 | 8 | 33.608 | 36.09 | 16.316 | 45.93 | 28.36 |
| 128 | 209 | 8 | 43.342 | 46.385 | 14.832 | 46.42 | 20.09 |
| 92 | 147 | 8 | 29.092 | 28.638 | 9.419 | 29.88 | 20 |
| 54 | 226 | 8 | 28.008 | 28.406 | 7.916 | 27.06 | 17.35 |
| 45 | 15 | 8 | 43.242 | 49.427 | 18.121 | 53.97 | 24.93 |
| 160 | 107 | 8 | 26.433 | 28.067 | 7.98 | 30.07 | 17.78 |
| 95 | 209 | 8 | 37.35 | 39.844 | 12.36 | 37.47 | 19.8 |
| 232 | 221 | 8 | 26.383 | 29.273 | 14.324 | 41 | 30.37 |
| 159 | 97 | 8 | 47.383 | 46.1 | 13.974 | 43.06 | 19.31 |
| 86 | 77 | 8 | 47.183 | 45.473 | 14.32 | 44.97 | 19.56 |
| 7 | 11 | 8 | 34.025 | 39.279 | 17.971 | 52.56 | 29.63 |
| 5 | 233 | 8 | 86.8 | 88.354 | 29.492 | 88.25 | 20.3 |
| 69 | 232 | 8 | 25.375 | 27.137 | 10.514 | 31.63 | 23.81 |
| 62 | 117 | 8 | 52.667 | 58.648 | 16.836 | 53.18 | 17.51 |
| 232 | 156 | 8 | 34.883 | 38.983 | 20.525 | 56.19 | 33.33 |
| 7 | 94 | 8 | 25.8 | 26.142 | 9.312 | 28.94 | 21.9 |
| 39 | 130 | 8 | 30.35 | 30.002 | 10.329 | 32.03 | 21.75 |
| 78 | 59 | 8 | 7.117 | 8.263 | 1.196 | 7.25 | 9.1 |
| 17 | 194 | 8 | 35.7 | 35.706 | 12.99 | 40.17 | 22.24 |
| 248 | 261 | 8 | 45.025 | 47.19 | 13.95 | 43.88 | 18.5 |
| 191 | 229 | 8 | 47.842 | 47.954 | 15.768 | 47.18 | 20.72 |
| 54 | 80 | 8 | 19.025 | 17.5 | 5.08 | 17.75 | 19.22 |
| 149 | 52 | 8 | 31.383 | 34.827 | 12.026 | 36.34 | 22.66 |
| 210 | 261 | 8 | 43.15 | 43.169 | 13.57 | 43.65 | 19.02 |
| 240 | 200 | 8 | 6.558 | 10.233 | 2.806 | 10.75 | 16.2 |