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 |
|---|---|---|---|---|---|---|---|
| 238 | 147 | 175 | 22.317 | 24.689 | 7.355 | 24.81 | 19.56 |
| 7 | 249 | 175 | 27.133 | 28.361 | 6.861 | 24.29 | 15.34 |
| 82 | 100 | 175 | 24.133 | 25.834 | 7.061 | 48.64 | 18.57 |
| 209 | 257 | 175 | 19.717 | 20.337 | 5.966 | 20.23 | 19.09 |
| 244 | 18 | 175 | 20.167 | 21.269 | 5.156 | 19.18 | 15.51 |
| 225 | 177 | 174 | 10.292 | 12.151 | 1.914 | 9.95 | 10.29 |
| 232 | 129 | 174 | 19.608 | 21.388 | 7.68 | 24.82 | 24.46 |
| 85 | 61 | 174 | 15.1 | 15.982 | 2.873 | 13.01 | 11.72 |
| 244 | 137 | 174 | 34.65 | 35.771 | 9.528 | 32.58 | 17.9 |
| 26 | 89 | 174 | 17.358 | 17.036 | 2.074 | 12.11 | 7.98 |
| 82 | 132 | 174 | 28.575 | 31.509 | 11.45 | 38.64 | 24.6 |
| 66 | 137 | 174 | 16.8 | 17.784 | 5.171 | 18.04 | 18.57 |
| 42 | 147 | 174 | 14.792 | 15.776 | 3.072 | 13.32 | 12.48 |
| 236 | 92 | 174 | 31.175 | 34.424 | 11.747 | 36.74 | 22.25 |
| 239 | 119 | 174 | 22.15 | 24.098 | 6.849 | 23.52 | 19.2 |
| 130 | 132 | 174 | 14.258 | 18.868 | 6.754 | 22.62 | 25.33 |
| 33 | 145 | 174 | 22.558 | 23.434 | 6.52 | 22.71 | 17.45 |
| 100 | 94 | 174 | 34.067 | 35.984 | 11.245 | 36.41 | 20.02 |
| 142 | 136 | 174 | 27.542 | 30.053 | 9.719 | 31.12 | 21.01 |
| 25 | 237 | 174 | 27.292 | 28.629 | 8.219 | 27.56 | 18.68 |
| 40 | 158 | 174 | 18.45 | 19.111 | 4.861 | 18.32 | 17.05 |
| 61 | 87 | 174 | 39.958 | 39.778 | 5.97 | 29.88 | 9.85 |
| 261 | 127 | 174 | 31.475 | 33.442 | 13.677 | 40.6 | 26.01 |
| 261 | 70 | 174 | 36.308 | 39.724 | 13.813 | 42.41 | 22.99 |
| 137 | 227 | 174 | 30.717 | 32.694 | 10.821 | 33.99 | 21.63 |