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 | 147 | 7 | 44.95 | 52.355 | 14.231 | 46.5 | 17.42 |
| 77 | 68 | 7 | 46.267 | 48.157 | 14.609 | 39.19 | 19.44 |
| 129 | 213 | 7 | 21.767 | 23.912 | 8.893 | 28.14 | 25.8 |
| 113 | 23 | 7 | 35.983 | 39.524 | 16.246 | 47.86 | 24.73 |
| 223 | 175 | 7 | 22.933 | 24.186 | 11.087 | 32.45 | 28.78 |
| 112 | 85 | 7 | 23.817 | 27.886 | 7.799 | 26.64 | 18.03 |
| 219 | 122 | 7 | 20 | 20.062 | 6.131 | 22.54 | 18.62 |
| 198 | 144 | 7 | 35.233 | 38.867 | 6.641 | 28.29 | 11.09 |
| 198 | 161 | 7 | 36.933 | 38.786 | 7.811 | 29.38 | 13.22 |
| 235 | 170 | 7 | 40.133 | 44.945 | 10.73 | 38.15 | 15.25 |
| 215 | 136 | 7 | 48.267 | 45.529 | 18.8 | 53.39 | 25.83 |
| 135 | 165 | 7 | 45.617 | 48.605 | 15.016 | 46.06 | 20.01 |
| 154 | 76 | 7 | 27.6 | 25.548 | 7.501 | 26.03 | 19.6 |
| 15 | 137 | 7 | 43.983 | 44.281 | 15.164 | 46.57 | 20.7 |
| 37 | 168 | 7 | 32.7 | 38.029 | 13.49 | 42.21 | 24.36 |
| 145 | 86 | 7 | 66.167 | 67.019 | 22.37 | 68.64 | 21.52 |
| 26 | 233 | 7 | 36 | 40.112 | 11.924 | 38.09 | 19.3 |
| 202 | 171 | 7 | 25.433 | 27.21 | 8.67 | 28.07 | 19.86 |
| 85 | 14 | 7 | 29.05 | 30.348 | 7.291 | 27 | 14.99 |
| 86 | 231 | 7 | 78.833 | 75.321 | 29.103 | 83.64 | 24.17 |
| 39 | 143 | 7 | 64.333 | 66.86 | 21.011 | 65.86 | 18.82 |
| 168 | 59 | 7 | 16.267 | 17.743 | 3.746 | 15.29 | 13.19 |
| 224 | 182 | 7 | 32.333 | 37.31 | 11.934 | 36.71 | 20.69 |
| 45 | 122 | 7 | 33.167 | 36.329 | 16.646 | 44.04 | 28.48 |
| 93 | 208 | 7 | 22.467 | 26.424 | 13.826 | 63.64 | 31.1 |