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 |
|---|---|---|---|---|---|---|---|
| 217 | 177 | 63 | 24.433 | 24.331 | 4.076 | 17.73 | 10.54 |
| 14 | 163 | 63 | 50.667 | 51.57 | 12.061 | 43.12 | 14.82 |
| 72 | 137 | 63 | 47.95 | 48.463 | 10.527 | 37.16 | 13.64 |
| 146 | 125 | 63 | 19.967 | 23.874 | 6.165 | 21.98 | 16.65 |
| 17 | 91 | 63 | 21.967 | 23.881 | 5.219 | 19.96 | 13.9 |
| 141 | 76 | 63 | 48.85 | 51.24 | 14.969 | 48.19 | 19.09 |
| 247 | 140 | 63 | 22.833 | 23.492 | 5.899 | 21.25 | 17.3 |
| 80 | 236 | 63 | 27.25 | 29.764 | 8.104 | 27.73 | 17.51 |
| 130 | 151 | 63 | 34.15 | 35.431 | 14.98 | 51.02 | 26.77 |
| 145 | 66 | 63 | 23.067 | 25.57 | 6.742 | 23.6 | 17.97 |
| 249 | 242 | 63 | 31.55 | 37.012 | 14.119 | 42.37 | 24.7 |
| 75 | 54 | 63 | 30 | 31.435 | 11.133 | 34.54 | 23.15 |
| 129 | 166 | 63 | 28.283 | 29.711 | 8.219 | 28.4 | 17.75 |
| 42 | 179 | 63 | 21.2 | 21.812 | 5.372 | 20.02 | 16.61 |
| 145 | 135 | 63 | 23.717 | 25.389 | 9.314 | 28.78 | 24.38 |
| 8 | 193 | 63 | 7.367 | 7.463 | 1.623 | 7.71 | 14.38 |
| 11 | 14 | 63 | 12.35 | 14.51 | 3.567 | 15.14 | 16.16 |
| 139 | 218 | 63 | 9.783 | 9.29 | 2.2 | 9.48 | 14.66 |
| 7 | 209 | 63 | 30.133 | 31.009 | 9.404 | 30.83 | 19.46 |
| 113 | 39 | 63 | 47.217 | 49.11 | 13.661 | 45.07 | 17.03 |
| 75 | 160 | 63 | 31.517 | 34.621 | 10.124 | 33.29 | 18.57 |
| 211 | 177 | 63 | 32.667 | 35.424 | 6.976 | 27.63 | 12.42 |
| 7 | 243 | 63 | 25.233 | 25.974 | 9.214 | 29.44 | 22.52 |
| 194 | 116 | 63 | 16.55 | 19.296 | 4.66 | 41.43 | 15.85 |
| 232 | 83 | 63 | 14.333 | 17.917 | 7.115 | 22.41 | 27.95 |