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 |
|---|---|---|---|---|---|---|---|
| 196 | 36 | 6 | 16.95 | 16.883 | 6.275 | 20.33 | 22.31 |
| 58 | 236 | 6 | 34.25 | 41.483 | 10.342 | 35.48 | 17.09 |
| 82 | 228 | 6 | 32.533 | 30.183 | 11.258 | 33.5 | 21.81 |
| 17 | 116 | 6 | 40.258 | 39.525 | 13.633 | 42.17 | 21.42 |
| 167 | 132 | 6 | 54.933 | 56.353 | 20.218 | 60.67 | 23.14 |
| 197 | 139 | 6 | 21.767 | 23.275 | 7.755 | 25.67 | 22.08 |
| 133 | 236 | 6 | 34.683 | 35.486 | 13.857 | 41.26 | 23.75 |
| 20 | 95 | 6 | 38.383 | 40.464 | 12.947 | 39.84 | 19.78 |
| 191 | 145 | 6 | 48.75 | 48.508 | 13.933 | 45.33 | 17.96 |
| 205 | 108 | 6 | 45.6 | 42.528 | 17.303 | 50.06 | 25.67 |
| 178 | 217 | 6 | 41.783 | 40.347 | 9.218 | 34.25 | 13.96 |
| 235 | 223 | 6 | 19.908 | 21.9 | 7.965 | 25.25 | 24.44 |
| 191 | 91 | 6 | 34.483 | 35.944 | 17.773 | 50.5 | 30.63 |
| 167 | 48 | 6 | 53.367 | 52.108 | 10.203 | 38.09 | 12.2 |
| 53 | 16 | 6 | 16.15 | 21.975 | 6.437 | 21.33 | 20.09 |
| 37 | 166 | 6 | 39.408 | 42.769 | 11.968 | 39.67 | 17.09 |
| 98 | 223 | 6 | 21.142 | 21.364 | 8.99 | 27.08 | 26.47 |
| 47 | 65 | 6 | 35.475 | 39.094 | 15.962 | 44.81 | 25.89 |
| 55 | 253 | 6 | 27.608 | 28.167 | 21.095 | 55.01 | 45.3 |
| 31 | 239 | 6 | 42.508 | 41.731 | 14.265 | 45 | 21.42 |
| 72 | 208 | 6 | 59.667 | 57.586 | 21.748 | 59.08 | 23.53 |
| 136 | 146 | 6 | 30.425 | 30.844 | 9.995 | 30.3 | 19.92 |
| 166 | 64 | 6 | 40.467 | 49.414 | 19.078 | 56.92 | 25.08 |
| 102 | 33 | 6 | 44.117 | 44.439 | 7.178 | 29.01 | 9.7 |
| 97 | 156 | 6 | 30.808 | 30.864 | 18.04 | 49.75 | 35.53 |