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 |
|---|---|---|---|---|---|---|---|
| 216 | 130 | 120 | 14.75 | 16.009 | 3.259 | 13.68 | 13.04 |
| 140 | 227 | 120 | 33.042 | 35.395 | 12.706 | 38.7 | 23.55 |
| 140 | 242 | 120 | 29.583 | 33.112 | 10.079 | 32.67 | 19.95 |
| 196 | 83 | 120 | 11.442 | 11.597 | 2.13 | 10.28 | 11.43 |
| 229 | 174 | 120 | 27.858 | 30.278 | 12.947 | 38.37 | 27.89 |
| 139 | 139 | 120 | 6.183 | 7.449 | 1.257 | 7.66 | 21.07 |
| 256 | 106 | 120 | 19.283 | 20.472 | 5.258 | 19.08 | 16.65 |
| 24 | 4 | 120 | 26.492 | 27.854 | 7.263 | 25.57 | 16.64 |
| 107 | 210 | 120 | 50.583 | 51.573 | 18.181 | 53.76 | 22.44 |
| 83 | 196 | 120 | 9.733 | 11.481 | 2.112 | 10.12 | 11.92 |
| 170 | 178 | 120 | 37.575 | 40.9 | 12.958 | 40.89 | 20.3 |
| 42 | 194 | 120 | 13.683 | 15.453 | 4.156 | 16.19 | 17.48 |
| 171 | 92 | 120 | 9.975 | 11.227 | 1.363 | 9.25 | 8.51 |
| 234 | 182 | 120 | 35.983 | 39.866 | 12.666 | 39.95 | 21.11 |
| 191 | 25 | 120 | 70.483 | 69.654 | 17.606 | 59.48 | 16.1 |
| 43 | 36 | 120 | 35.575 | 37.947 | 8.825 | 31.69 | 14.64 |
| 65 | 198 | 120 | 21.675 | 23.062 | 5.916 | 21.15 | 16.5 |
| 43 | 225 | 120 | 41.317 | 42.94 | 9.538 | 34.69 | 13.83 |
| 28 | 186 | 120 | 29.925 | 33.432 | 12.123 | 51.43 | 23.88 |
| 193 | 41 | 120 | 22.433 | 26 | 6.152 | 22.49 | 15.6 |
| 87 | 123 | 120 | 31.067 | 33.504 | 10.55 | 33.61 | 19.88 |
| 142 | 73 | 120 | 36.442 | 38.291 | 12.778 | 40.4 | 21.06 |
| 41 | 248 | 120 | 22.692 | 24.938 | 6.844 | 23.55 | 18.32 |
| 137 | 241 | 120 | 24.1 | 28.296 | 12.176 | 35.74 | 28.91 |
| 193 | 42 | 120 | 18.525 | 21.087 | 7.098 | 23.06 | 22.64 |