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 |
|---|---|---|---|---|---|---|---|
| 225 | 148 | 37 | 21.55 | 24.886 | 4.586 | 19.01 | 12.28 |
| 9 | 9 | 37 | 4.4 | 7.838 | 1.255 | 8.25 | 11.54 |
| 100 | 122 | 37 | 46.583 | 47.75 | 16.049 | 49.46 | 21.79 |
| 137 | 192 | 37 | 24.433 | 29.843 | 10.342 | 31.86 | 24.16 |
| 233 | 72 | 37 | 50.183 | 50.868 | 11.831 | 41.95 | 14.67 |
| 225 | 222 | 37 | 28.233 | 28.76 | 4.844 | 20.63 | 10.6 |
| 167 | 244 | 37 | 16.9 | 22.107 | 3.653 | 16.8 | 11.12 |
| 7 | 89 | 37 | 41.317 | 42.972 | 14.706 | 45.15 | 22.9 |
| 74 | 215 | 37 | 35.033 | 36.355 | 14.597 | 43.32 | 25.78 |
| 219 | 43 | 37 | 49.067 | 48.403 | 17.269 | 52.67 | 23.46 |
| 148 | 60 | 37 | 27.133 | 29.785 | 12.343 | 36.64 | 26.75 |
| 93 | 194 | 37 | 11.133 | 14.095 | 8.239 | 50.91 | 41.27 |
| 63 | 37 | 37 | 20.317 | 21.359 | 3.695 | 16.15 | 10.64 |
| 70 | 131 | 37 | 17.45 | 19.677 | 7.929 | 24.34 | 28.37 |
| 255 | 193 | 37 | 15.483 | 18.521 | 3.911 | 15.47 | 13.67 |
| 13 | 15 | 37 | 58.433 | 58.945 | 19.738 | 57.75 | 21.63 |
| 202 | 75 | 37 | 21.15 | 21.649 | 4.607 | 19.12 | 13.59 |
| 108 | 29 | 37 | 9.933 | 11.475 | 1.859 | 9.86 | 10.4 |
| 234 | 19 | 37 | 34.767 | 36.668 | 17.677 | 50.16 | 30.4 |
| 134 | 239 | 37 | 32.183 | 33.186 | 14.485 | 50.91 | 27.07 |
| 186 | 251 | 37 | 44.283 | 46.727 | 17.967 | 54.32 | 23.88 |
| 229 | 34 | 37 | 32.4 | 31.392 | 7.423 | 26.97 | 15.38 |
| 231 | 215 | 37 | 57.533 | 60.266 | 18.677 | 57.75 | 20.4 |
| 92 | 196 | 37 | 19.717 | 21.325 | 4.532 | 18.36 | 13.79 |
| 81 | 140 | 37 | 56.85 | 53.778 | 13.714 | 45.89 | 17.07 |