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 |
|---|---|---|---|---|---|---|---|
| 215 | 247 | 4 | 30.575 | 31.567 | 13.067 | 37.41 | 24.66 |
| 235 | 128 | 4 | 11.292 | 13.904 | 2.625 | 12.25 | 12.21 |
| 8 | 82 | 4 | 17.342 | 19.042 | 3.64 | 15.62 | 12.33 |
| 256 | 220 | 4 | 29.242 | 28.988 | 16.52 | 45.12 | 34.22 |
| 41 | 139 | 4 | 50.5 | 50.604 | 20.295 | 58.12 | 25.68 |
| 54 | 227 | 4 | 12.083 | 14.379 | 4.735 | 16 | 21.22 |
| 18 | 151 | 4 | 20.925 | 24.042 | 7.992 | 25.38 | 21.24 |
| 235 | 117 | 4 | 58.4 | 57.854 | 27.237 | 75.49 | 29.47 |
| 5 | 129 | 4 | 99.642 | 91.196 | 31.252 | 93.38 | 22.47 |
| 136 | 238 | 4 | 23.617 | 25.496 | 8.178 | 22.56 | 19.64 |
| 232 | 128 | 4 | 33.525 | 33.771 | 13.312 | 39.62 | 24.46 |
| 114 | 187 | 4 | 35.25 | 39.825 | 17.555 | 50.12 | 27.77 |
| 40 | 18 | 4 | 50.017 | 46.379 | 19.443 | 54.62 | 25.82 |
| 71 | 86 | 4 | 61.067 | 60.925 | 15.855 | 53.88 | 15.61 |
| 247 | 46 | 4 | 25.375 | 28.438 | 11.945 | 34.75 | 26.84 |
| 203 | 168 | 4 | 29.6 | 29.771 | 19.207 | 49.54 | 38.87 |
| 195 | 94 | 4 | 51.708 | 58.675 | 19.145 | 58.88 | 20.55 |
| 78 | 138 | 4 | 24.9 | 27.537 | 10.075 | 30.75 | 23.78 |
| 22 | 5 | 4 | 47.275 | 47.029 | 17.968 | 54 | 23.36 |
| 122 | 175 | 4 | 9.8 | 10.504 | 2.025 | 9.75 | 11.74 |
| 12 | 214 | 4 | 28.767 | 31.938 | 12.998 | 37.12 | 26.32 |
| 120 | 138 | 4 | 19.8 | 21.762 | 8.795 | 26.5 | 26.17 |
| 15 | 25 | 4 | 61.558 | 60.867 | 17.352 | 56.36 | 17.56 |
| 35 | 102 | 4 | 25.05 | 25.433 | 5.045 | 20.38 | 13.18 |
| 63 | 159 | 4 | 40.558 | 40.083 | 18.665 | 51.44 | 28.9 |