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 |
|---|---|---|---|---|---|---|---|
| 246 | 67 | 139 | 30.633 | 32.409 | 11.445 | 35.38 | 22.01 |
| 65 | 26 | 138 | 26.25 | 27.001 | 6.948 | 24.72 | 16.51 |
| 10 | 125 | 138 | 50.025 | 50.974 | 16.514 | 52.24 | 21.2 |
| 244 | 113 | 138 | 32.267 | 33.435 | 9.174 | 31.45 | 17.66 |
| 234 | 28 | 138 | 33.892 | 38.003 | 12.969 | 40.4 | 22.78 |
| 7 | 258 | 138 | 29.633 | 31.477 | 10.553 | 33.64 | 21.63 |
| 97 | 141 | 138 | 26.367 | 27.264 | 8.027 | 26.6 | 19.25 |
| 140 | 85 | 138 | 51.783 | 52.975 | 13.055 | 44.45 | 15.92 |
| 42 | 18 | 138 | 20.575 | 22.325 | 5.608 | 20.48 | 16.35 |
| 107 | 208 | 138 | 33.008 | 36.945 | 13.563 | 40.94 | 23.85 |
| 90 | 119 | 138 | 26.808 | 30.858 | 10.269 | 32.7 | 21.82 |
| 107 | 92 | 138 | 31.65 | 35.1 | 12.015 | 37.22 | 22.72 |
| 170 | 254 | 138 | 43.058 | 46.778 | 14.385 | 45.14 | 20.69 |
| 134 | 28 | 138 | 4.742 | 7.208 | 1.877 | 8.9 | 14.57 |
| 256 | 209 | 138 | 18.025 | 19.188 | 4.072 | 17.69 | 13.95 |
| 228 | 106 | 138 | 6.717 | 7.57 | 1.519 | 7.97 | 13.19 |
| 107 | 47 | 138 | 42.325 | 46.009 | 10.467 | 37.45 | 15.88 |
| 141 | 28 | 138 | 31.575 | 34.307 | 13.061 | 39.46 | 24.88 |
| 246 | 92 | 138 | 38.975 | 42.597 | 13.539 | 43.26 | 20.98 |
| 249 | 193 | 138 | 25.6 | 27.157 | 6.068 | 22.55 | 14.88 |
| 168 | 213 | 138 | 13.367 | 14.655 | 4.285 | 15.42 | 19.71 |
| 148 | 119 | 138 | 24.317 | 26.94 | 11.121 | 33.12 | 26.46 |
| 76 | 33 | 138 | 51.392 | 50.885 | 8.06 | 33.78 | 9.91 |
| 241 | 241 | 138 | 4.767 | 9.087 | 1.606 | 9.22 | 10.65 |
| 230 | 85 | 138 | 42.808 | 45.884 | 11.624 | 39.87 | 16.03 |