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 |
|---|---|---|---|---|---|---|---|
| 151 | 95 | 132 | 32.042 | 33.803 | 13.044 | 39.5 | 24.43 |
| 28 | 142 | 132 | 36.117 | 37.76 | 13.807 | 51.4 | 23.22 |
| 24 | 7 | 132 | 25.267 | 27.044 | 6.537 | 23.85 | 15.28 |
| 234 | 72 | 132 | 46.383 | 47.145 | 9.548 | 35.75 | 12.64 |
| 170 | 11 | 132 | 37.375 | 39.741 | 15.196 | 45.24 | 24.77 |
| 74 | 261 | 132 | 26.608 | 28.875 | 9.873 | 31.04 | 23.02 |
| 238 | 49 | 132 | 40.658 | 40.843 | 11.193 | 37.44 | 17.3 |
| 164 | 252 | 132 | 30.467 | 33.153 | 14.227 | 41.73 | 26.97 |
| 141 | 63 | 132 | 46.892 | 48.738 | 9.7 | 41.84 | 12.48 |
| 145 | 88 | 132 | 20.95 | 22.675 | 7.092 | 42.29 | 20.77 |
| 49 | 79 | 132 | 19.9 | 20.505 | 4.282 | 17.42 | 13.21 |
| 232 | 243 | 131 | 26.35 | 28.522 | 11.901 | 35.02 | 26.68 |
| 181 | 100 | 131 | 31.15 | 33.02 | 7.192 | 27.27 | 13.89 |
| 25 | 71 | 131 | 26.383 | 28.223 | 4.941 | 21.08 | 11.3 |
| 162 | 39 | 131 | 54.083 | 55.701 | 15.701 | 50.72 | 17.44 |
| 79 | 212 | 131 | 27.1 | 29.039 | 11.356 | 34.1 | 25.19 |
| 170 | 64 | 131 | 33 | 39.5 | 16.197 | 46.9 | 27.86 |
| 146 | 151 | 131 | 20.55 | 22.528 | 5.216 | 19.48 | 15.06 |
| 181 | 142 | 131 | 37.35 | 38.846 | 9.341 | 33.15 | 15.18 |
| 119 | 41 | 131 | 13.683 | 14.838 | 3.161 | 13.3 | 14.41 |
| 229 | 56 | 131 | 25.55 | 26.602 | 7.945 | 26.56 | 19.25 |
| 152 | 137 | 131 | 28.65 | 29.636 | 7.469 | 26.62 | 16.43 |
| 145 | 41 | 131 | 23.35 | 25.576 | 6.362 | 22.55 | 16.06 |
| 42 | 182 | 131 | 21.817 | 24.321 | 7.046 | 23.82 | 19.11 |
| 43 | 92 | 131 | 36.517 | 39.149 | 11.692 | 38.21 | 19.16 |