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 |
|---|---|---|---|---|---|---|---|
| 25 | 9 | 7 | 60 | 56.474 | 14.757 | 45.93 | 16.77 |
| 185 | 75 | 7 | 31.25 | 34.074 | 9.269 | 30.49 | 17.82 |
| 80 | 215 | 7 | 33.333 | 43.631 | 11.327 | 36.37 | 19.08 |
| 211 | 111 | 7 | 21.817 | 24.057 | 6.884 | 23.36 | 19.04 |
| 178 | 88 | 7 | 37.983 | 41.764 | 7.727 | 31.17 | 11.84 |
| 40 | 29 | 7 | 28.567 | 28.526 | 11.114 | 33.36 | 24.62 |
| 194 | 70 | 7 | 18.883 | 19.548 | 8.037 | 29.36 | 29.42 |
| 106 | 210 | 7 | 27.633 | 30.145 | 13.904 | 40.36 | 28.51 |
| 190 | 232 | 7 | 19.617 | 21.617 | 5.247 | 19.71 | 15.34 |
| 47 | 68 | 7 | 47.1 | 47.752 | 10.944 | 39.57 | 14.9 |
| 36 | 195 | 7 | 21.05 | 28.948 | 7.389 | 26.36 | 18.42 |
| 161 | 30 | 7 | 49.95 | 48.893 | 17.746 | 53.5 | 22.67 |
| 146 | 52 | 7 | 22.233 | 25.955 | 8.49 | 26.71 | 20.81 |
| 159 | 77 | 7 | 40.433 | 43.664 | 18.726 | 55.43 | 27.62 |
| 40 | 146 | 7 | 22.717 | 23.893 | 8.279 | 26.14 | 21.21 |
| 14 | 142 | 7 | 48.517 | 51.324 | 12.839 | 42.66 | 16.6 |
| 101 | 140 | 7 | 42.667 | 46.686 | 20.541 | 58.3 | 29.05 |
| 45 | 117 | 7 | 60.317 | 58.519 | 26.964 | 71.46 | 28.46 |
| 218 | 138 | 7 | 21 | 22.955 | 9.379 | 28 | 24.16 |
| 158 | 94 | 7 | 26.967 | 32.243 | 12.219 | 37.79 | 25 |
| 213 | 194 | 7 | 23.267 | 27.664 | 8.409 | 27.36 | 18.89 |
| 7 | 253 | 7 | 13.033 | 14.552 | 5.849 | 18.93 | 25.64 |
| 24 | 81 | 7 | 35.1 | 35.862 | 12.794 | 39.14 | 23.01 |
| 207 | 193 | 7 | 23.2 | 24.948 | 2.931 | 16.5 | 8.9 |
| 88 | 27 | 7 | 39.333 | 47.798 | 22.77 | 63.71 | 31.19 |