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 |
|---|---|---|---|---|---|---|---|
| 23 | 53 | 6 | 82.233 | 81.392 | 31.258 | 88.5 | 23.28 |
| 228 | 29 | 6 | 29.858 | 27.694 | 8.475 | 27.81 | 18.51 |
| 47 | 59 | 6 | 6.075 | 5.978 | 0.927 | 6.08 | 9.98 |
| 258 | 209 | 6 | 60.608 | 61.236 | 11.81 | 41.74 | 12.02 |
| 164 | 5 | 6 | 48.825 | 47.978 | 27.943 | 76.17 | 35.61 |
| 242 | 127 | 6 | 38.725 | 41.572 | 10.69 | 36.71 | 15.3 |
| 130 | 69 | 6 | 32.458 | 32.272 | 14.817 | 45.08 | 28.59 |
| 235 | 240 | 6 | 13.933 | 13.542 | 4.417 | 15.5 | 20.8 |
| 102 | 186 | 6 | 54.842 | 54.464 | 9.637 | 41.08 | 10.78 |
| 37 | 219 | 6 | 29.442 | 28.531 | 11.323 | 34.33 | 23.65 |
| 249 | 86 | 6 | 48.708 | 54.825 | 24.812 | 75.75 | 28.33 |
| 124 | 149 | 6 | 25.633 | 26.003 | 11.1 | 33.58 | 26.5 |
| 261 | 156 | 6 | 33.008 | 33.303 | 16.723 | 47.42 | 30.31 |
| 160 | 223 | 6 | 23.933 | 29.425 | 9.282 | 30.42 | 17.09 |
| 35 | 233 | 6 | 48.942 | 54.192 | 14.988 | 50.42 | 17.51 |
| 155 | 232 | 6 | 62.933 | 66.194 | 19.518 | 60.57 | 17.88 |
| 208 | 159 | 6 | 23.042 | 22.586 | 6.323 | 21.83 | 18.36 |
| 158 | 176 | 6 | 43.775 | 48.697 | 19 | 55.25 | 24.19 |
| 177 | 238 | 6 | 69.433 | 73.956 | 14.057 | 55.5 | 11.66 |
| 136 | 262 | 6 | 38.075 | 38.083 | 8.682 | 32 | 15.13 |
| 90 | 84 | 6 | 50.95 | 51.733 | 24.562 | 76.42 | 28.87 |
| 129 | 96 | 6 | 23.475 | 26.447 | 6.013 | 23.75 | 14.12 |
| 116 | 217 | 6 | 33.017 | 34.453 | 13.353 | 40.33 | 23.77 |
| 124 | 22 | 6 | 30.167 | 29.889 | 14.372 | 40.64 | 29.66 |
| 107 | 184 | 6 | 31.692 | 36.197 | 15.605 | 44.5 | 27.4 |