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 |
|---|---|---|---|---|---|---|---|
| 152 | 31 | 8 | 21.783 | 22.723 | 8.42 | 26.31 | 22.55 |
| 40 | 63 | 8 | 33.05 | 33.113 | 7.82 | 28.19 | 14.51 |
| 146 | 241 | 8 | 28.408 | 27.79 | 12.053 | 34.11 | 26.57 |
| 180 | 61 | 8 | 26.7 | 35.017 | 5.849 | 26.06 | 11.41 |
| 54 | 234 | 8 | 21.65 | 21.927 | 5.417 | 19.88 | 15.52 |
| 148 | 27 | 8 | 40.458 | 42.337 | 24.328 | 65.94 | 35.32 |
| 191 | 42 | 8 | 35.942 | 42.627 | 18.98 | 53.4 | 29.19 |
| 177 | 28 | 8 | 24.758 | 35.237 | 10.569 | 31.66 | 18.87 |
| 80 | 124 | 8 | 48.758 | 49.346 | 7.664 | 36.62 | 9.89 |
| 254 | 231 | 8 | 45.167 | 44.206 | 18.891 | 55.38 | 26.47 |
| 141 | 222 | 8 | 51.117 | 57.054 | 18.019 | 54.87 | 20.82 |
| 230 | 27 | 8 | 54.375 | 57.325 | 25.694 | 72.62 | 27.71 |
| 191 | 90 | 8 | 41.175 | 42.285 | 19.597 | 55.11 | 28.09 |
| 69 | 68 | 8 | 36.833 | 39.794 | 9.803 | 34.94 | 16.42 |
| 223 | 155 | 8 | 53.525 | 53.377 | 21.249 | 61.88 | 25.32 |
| 7 | 187 | 8 | 59.6 | 58.942 | 24.961 | 70.38 | 25.68 |
| 60 | 48 | 8 | 40.533 | 41.623 | 11.51 | 36.24 | 17.9 |
| 135 | 70 | 8 | 15.733 | 17.467 | 5.947 | 19.75 | 23.12 |
| 174 | 31 | 8 | 8.608 | 12.219 | 2.584 | 12.82 | 15.03 |
| 11 | 227 | 8 | 16.242 | 18.873 | 3.419 | 15.75 | 11.79 |
| 56 | 263 | 8 | 30.983 | 31.873 | 9.682 | 43.06 | 20.09 |
| 153 | 48 | 8 | 29.85 | 29.2 | 10.348 | 33.12 | 22.97 |
| 179 | 14 | 8 | 30.517 | 33.24 | 16.34 | 45.44 | 31.28 |
| 152 | 66 | 8 | 40.508 | 41.508 | 11.601 | 38.5 | 17.45 |
| 142 | 253 | 8 | 39.917 | 53.644 | 15.588 | 51.06 | 19.12 |