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 |
|---|---|---|---|---|---|---|---|
| 85 | 250 | 18 | 45.217 | 47.516 | 21.403 | 56.6 | 28.48 |
| 168 | 200 | 18 | 20.658 | 22.098 | 8.698 | 27.13 | 24.72 |
| 93 | 25 | 18 | 29.283 | 33.39 | 12.344 | 37.25 | 24.35 |
| 239 | 124 | 18 | 55.158 | 60.571 | 17.302 | 56.79 | 18.54 |
| 234 | 172 | 18 | 42.008 | 44.401 | 19.336 | 55.39 | 27 |
| 249 | 98 | 18 | 34.183 | 38.954 | 14.251 | 43.5 | 23.37 |
| 225 | 215 | 18 | 34.525 | 34.88 | 10.659 | 33.13 | 19.17 |
| 183 | 58 | 18 | 6.717 | 7.601 | 1.036 | 6.72 | 8.86 |
| 232 | 250 | 18 | 31.025 | 36.169 | 13.507 | 40.32 | 25.09 |
| 235 | 50 | 18 | 22.6 | 26.804 | 9.347 | 30.21 | 23.16 |
| 40 | 22 | 18 | 21.567 | 23.165 | 6.545 | 22.58 | 17.49 |
| 246 | 175 | 18 | 43.45 | 46.016 | 16.449 | 51.19 | 22.79 |
| 81 | 69 | 18 | 36.783 | 39.442 | 9.293 | 32.88 | 16.91 |
| 255 | 247 | 18 | 27.175 | 28.854 | 12.682 | 37.17 | 27.1 |
| 168 | 146 | 18 | 23.158 | 24.099 | 5.553 | 20.2 | 14.43 |
| 232 | 28 | 18 | 32.417 | 36.743 | 14.047 | 43.41 | 26.53 |
| 166 | 76 | 18 | 52.35 | 59.342 | 19.54 | 59.76 | 21.51 |
| 256 | 152 | 18 | 32.775 | 35.461 | 11.344 | 36.22 | 20.21 |
| 131 | 38 | 18 | 20.125 | 22.119 | 5.101 | 19.06 | 14.2 |
| 173 | 166 | 18 | 33.492 | 36.631 | 8.799 | 32.03 | 14.85 |
| 220 | 259 | 18 | 19.783 | 19.755 | 5.599 | 20.74 | 17.73 |
| 247 | 259 | 18 | 20.45 | 25.458 | 8.631 | 27.64 | 22.42 |
| 10 | 101 | 18 | 28.283 | 29.85 | 11.291 | 33.92 | 24.17 |
| 228 | 54 | 18 | 9.983 | 11.581 | 2.403 | 10.53 | 14.22 |
| 223 | 15 | 18 | 20.133 | 23.692 | 9.478 | 29 | 27.37 |