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 |
|---|---|---|---|---|---|---|---|
| 7 | 26 | 14 | 41.817 | 45.239 | 15.256 | 46.71 | 22.31 |
| 177 | 189 | 14 | 17.392 | 19.155 | 4.071 | 16.32 | 12.62 |
| 190 | 113 | 14 | 29.558 | 28.369 | 5.724 | 23.11 | 12.61 |
| 114 | 215 | 14 | 39.108 | 40.606 | 15.49 | 46.33 | 24.94 |
| 243 | 148 | 14 | 34.2 | 38.411 | 12.332 | 39.75 | 21.12 |
| 83 | 36 | 14 | 19.758 | 21.995 | 4.894 | 18.79 | 14.23 |
| 225 | 157 | 14 | 15.358 | 16.077 | 3.226 | 13.46 | 12.27 |
| 246 | 120 | 14 | 26.692 | 26.52 | 8.713 | 27.93 | 20.68 |
| 131 | 64 | 14 | 15.008 | 16.515 | 5.537 | 18.29 | 21.6 |
| 198 | 255 | 14 | 16.942 | 19.888 | 3.505 | 14.57 | 11.29 |
| 100 | 214 | 14 | 44.958 | 45.773 | 18.209 | 53.36 | 24.45 |
| 58 | 183 | 14 | 7.508 | 7.971 | 1.077 | 6.89 | 9.2 |
| 157 | 155 | 14 | 62.142 | 62.068 | 15.773 | 54.79 | 16.34 |
| 7 | 220 | 14 | 24.508 | 26.236 | 11.089 | 33.04 | 27.79 |
| 167 | 151 | 14 | 35.958 | 34.523 | 6.729 | 26.93 | 12.04 |
| 81 | 169 | 14 | 31.675 | 32.154 | 6.897 | 26.25 | 15.19 |
| 173 | 229 | 14 | 40.033 | 40.84 | 10.176 | 35.89 | 17 |
| 173 | 192 | 14 | 13.283 | 14.388 | 4.317 | 15.5 | 19.59 |
| 149 | 180 | 14 | 33.792 | 36.144 | 11.847 | 37.2 | 21.4 |
| 88 | 84 | 14 | 43.717 | 43.285 | 24.285 | 65.61 | 33.77 |
| 211 | 135 | 14 | 32.858 | 38.531 | 12.586 | 39.68 | 21.36 |
| 228 | 249 | 14 | 22.017 | 21.426 | 5.379 | 19.75 | 14.46 |
| 64 | 15 | 14 | 14.175 | 15.72 | 7.052 | 28.77 | 29.35 |
| 22 | 178 | 13 | 11.05 | 12.351 | 2.253 | 10.65 | 11.17 |
| 68 | 187 | 13 | 38.917 | 40.435 | 18.26 | 62.85 | 26.99 |