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 |
|---|---|---|---|---|---|---|---|
| 148 | 72 | 143 | 31.617 | 32.702 | 7.737 | 27.86 | 14.87 |
| 140 | 133 | 143 | 33.917 | 36.196 | 12.389 | 38.42 | 22.34 |
| 52 | 236 | 143 | 35.333 | 36.929 | 9.889 | 33.05 | 17.09 |
| 239 | 136 | 143 | 24.55 | 26.207 | 8.475 | 27.39 | 21.05 |
| 79 | 123 | 143 | 35.367 | 36.842 | 12.978 | 39.91 | 22.35 |
| 21 | 231 | 142 | 41.975 | 42.912 | 10.608 | 36.48 | 15.33 |
| 28 | 132 | 142 | 12.342 | 18.79 | 7.133 | 32.76 | 28.21 |
| 114 | 56 | 142 | 28.783 | 29.129 | 10.564 | 33.26 | 22.48 |
| 170 | 252 | 142 | 33.042 | 36.549 | 13.757 | 41.24 | 25.03 |
| 262 | 40 | 142 | 25.183 | 27.79 | 9.63 | 29.52 | 22.06 |
| 166 | 179 | 142 | 23.55 | 25.158 | 5.781 | 22.02 | 14.68 |
| 148 | 235 | 142 | 23.083 | 26.24 | 12.554 | 36.22 | 31.33 |
| 88 | 34 | 142 | 16.133 | 17.201 | 3.744 | 14.98 | 14.53 |
| 41 | 194 | 142 | 13.575 | 15.187 | 3.071 | 15.39 | 13.31 |
| 69 | 116 | 142 | 13.158 | 14.14 | 2.081 | 11.15 | 9.44 |
| 145 | 17 | 142 | 21.933 | 22.795 | 5.355 | 19.85 | 14.85 |
| 138 | 120 | 142 | 22.633 | 26.233 | 9.561 | 30.1 | 24.21 |
| 88 | 55 | 142 | 35.008 | 35.495 | 14.16 | 41.7 | 25.68 |
| 80 | 137 | 142 | 20.075 | 21.897 | 5.184 | 19.78 | 15.67 |
| 106 | 227 | 142 | 11.858 | 12.462 | 2.65 | 11.43 | 13.33 |
| 145 | 238 | 142 | 22.225 | 24.714 | 4.997 | 21.12 | 13.03 |
| 114 | 69 | 142 | 30.567 | 32.032 | 10.707 | 33.76 | 21.34 |
| 230 | 98 | 142 | 35.767 | 37.436 | 13.129 | 40.43 | 22.55 |
| 166 | 169 | 142 | 20.458 | 22.577 | 5.659 | 20.43 | 16.8 |
| 246 | 241 | 142 | 29.358 | 30.894 | 11.949 | 36.01 | 24.97 |