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 |
|---|---|---|---|---|---|---|---|
| 114 | 8 | 9 | 24.433 | 27.389 | 9.101 | 29.22 | 21.34 |
| 54 | 112 | 9 | 15.383 | 18.065 | 6.341 | 20.22 | 22.06 |
| 51 | 230 | 9 | 68.717 | 61.543 | 18.582 | 58.81 | 19.83 |
| 198 | 65 | 9 | 36.733 | 38.091 | 5.078 | 25.11 | 8.46 |
| 85 | 7 | 9 | 37.4 | 36.381 | 12.408 | 38.22 | 21.41 |
| 93 | 86 | 9 | 48.733 | 51.183 | 17.409 | 53.72 | 21.94 |
| 151 | 178 | 9 | 44.867 | 45.524 | 15.621 | 47.08 | 21.46 |
| 247 | 158 | 9 | 34.883 | 34.035 | 10.461 | 34.5 | 18.76 |
| 224 | 56 | 9 | 29.5 | 30.378 | 9.243 | 30.44 | 19.83 |
| 28 | 83 | 9 | 20.483 | 22.248 | 6.29 | 21.56 | 17.49 |
| 34 | 36 | 9 | 18.583 | 18.098 | 3.002 | 14.06 | 10.14 |
| 24 | 227 | 9 | 40.633 | 45.396 | 14.683 | 47.39 | 20.8 |
| 196 | 236 | 9 | 26.517 | 28.644 | 9.481 | 34.67 | 20.56 |
| 121 | 100 | 9 | 39.55 | 37.554 | 11.939 | 37.55 | 19.71 |
| 42 | 26 | 9 | 54.033 | 51.961 | 18.582 | 54.74 | 21.64 |
| 257 | 85 | 9 | 14.517 | 14.619 | 2.499 | 12.11 | 10.66 |
| 78 | 45 | 9 | 57.45 | 59.994 | 14.534 | 49.89 | 14.97 |
| 16 | 28 | 9 | 20.133 | 20.37 | 6.29 | 21.54 | 18.94 |
| 17 | 239 | 9 | 33.3 | 39.25 | 10.722 | 36 | 16.59 |
| 226 | 185 | 9 | 33.333 | 34.165 | 14.28 | 42 | 26.44 |
| 211 | 254 | 9 | 45.917 | 49.441 | 18.68 | 55.78 | 23.71 |
| 92 | 65 | 9 | 52.05 | 47.598 | 13.357 | 43.09 | 20.03 |
| 76 | 11 | 9 | 25.95 | 25.617 | 12.183 | 35.36 | 29 |
| 188 | 198 | 9 | 33.733 | 34.637 | 5.968 | 24.89 | 11.22 |
| 248 | 48 | 9 | 39.217 | 38.678 | 11.37 | 36.9 | 18.43 |