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 |
|---|---|---|---|---|---|---|---|
| 215 | 56 | 23 | 21.7 | 24.859 | 7.285 | 25.28 | 20.04 |
| 200 | 69 | 23 | 29.067 | 30.408 | 7.735 | 25.94 | 15.72 |
| 43 | 78 | 23 | 34.333 | 34.047 | 8.561 | 30.41 | 16.2 |
| 133 | 150 | 23 | 28.183 | 30.276 | 6.395 | 24.41 | 13.13 |
| 143 | 135 | 23 | 43.183 | 43.302 | 12.199 | 40.48 | 18.35 |
| 12 | 37 | 23 | 32.35 | 32.643 | 6.446 | 25.78 | 12.74 |
| 82 | 180 | 23 | 20.6 | 21.973 | 5.188 | 19.54 | 15.89 |
| 34 | 217 | 23 | 8.683 | 8.565 | 1.178 | 7.41 | 8.86 |
| 149 | 188 | 23 | 26.183 | 27.159 | 4.377 | 19.34 | 9.93 |
| 179 | 171 | 23 | 20.017 | 21.524 | 7.722 | 24.93 | 22.99 |
| 39 | 163 | 23 | 48.133 | 54.049 | 18.683 | 55.85 | 21.89 |
| 87 | 117 | 23 | 54.85 | 55.873 | 25.427 | 70.76 | 28.41 |
| 82 | 168 | 23 | 17.467 | 24.041 | 8.112 | 26.26 | 22.88 |
| 157 | 202 | 23 | 27.967 | 29.038 | 5.707 | 21.77 | 11.92 |
| 130 | 203 | 23 | 21.967 | 24.707 | 6.902 | 24.13 | 18.73 |
| 189 | 75 | 23 | 39.383 | 37.7 | 11.038 | 35.96 | 18.33 |
| 106 | 71 | 23 | 34.65 | 34.125 | 5.175 | 23.92 | 9.73 |
| 155 | 22 | 23 | 27.167 | 29.629 | 6.084 | 24.16 | 13.32 |
| 254 | 7 | 23 | 42.4 | 42.249 | 12.582 | 40.15 | 18.68 |
| 237 | 180 | 23 | 44.333 | 46.999 | 13.664 | 44.37 | 18.44 |
| 196 | 73 | 23 | 11.967 | 13.889 | 4.77 | 16.15 | 21.53 |
| 101 | 28 | 23 | 24.483 | 26.5 | 8.573 | 29.2 | 20 |
| 94 | 247 | 23 | 13.6 | 13.885 | 2.42 | 10.94 | 11.69 |
| 256 | 168 | 23 | 21.3 | 23.736 | 9.926 | 30 | 26.32 |
| 157 | 4 | 23 | 18.8 | 19.53 | 6.497 | 47.41 | 20.85 |