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 |
|---|---|---|---|---|---|---|---|
| 193 | 125 | 12 | 29.975 | 29.826 | 6.967 | 25.92 | 15.44 |
| 60 | 81 | 12 | 23.542 | 25.733 | 7.094 | 24.77 | 18.37 |
| 45 | 218 | 12 | 57.975 | 67.431 | 20.622 | 64 | 20.85 |
| 259 | 220 | 12 | 17.7 | 19.553 | 4.415 | 17.15 | 14.46 |
| 235 | 32 | 12 | 23.433 | 23.037 | 4.509 | 19.1 | 13.09 |
| 29 | 87 | 12 | 32.975 | 36.465 | 14.334 | 44.5 | 25.22 |
| 261 | 192 | 12 | 38.233 | 41.381 | 14.901 | 44.67 | 22.88 |
| 47 | 212 | 12 | 14.442 | 16.537 | 2.882 | 13.75 | 11.6 |
| 119 | 143 | 12 | 25.142 | 25.585 | 7.543 | 25.06 | 18.72 |
| 43 | 192 | 12 | 33.192 | 36.814 | 11.591 | 36.54 | 20.03 |
| 191 | 195 | 12 | 52.558 | 55.583 | 29.551 | 81.71 | 34.1 |
| 14 | 230 | 12 | 47.675 | 46.332 | 11.576 | 39.71 | 16.14 |
| 158 | 147 | 12 | 31.783 | 31.244 | 12.381 | 37.33 | 24.01 |
| 228 | 111 | 12 | 3.825 | 4.708 | 0.956 | 5.5 | 12.6 |
| 65 | 78 | 12 | 44.983 | 44.343 | 15.676 | 47 | 22.18 |
| 129 | 235 | 12 | 21.775 | 30.415 | 10.293 | 30.88 | 26.82 |
| 185 | 249 | 12 | 47.525 | 47.942 | 15.681 | 49.08 | 20.19 |
| 29 | 188 | 12 | 38.3 | 38.99 | 6.717 | 27.16 | 10.89 |
| 56 | 18 | 12 | 35.567 | 35.881 | 14.994 | 44.09 | 26.3 |
| 169 | 230 | 12 | 29.825 | 35.708 | 10.168 | 35.33 | 19.74 |
| 168 | 144 | 12 | 51.45 | 52.267 | 10.383 | 39.01 | 13.25 |
| 62 | 246 | 12 | 39.125 | 39.635 | 8.513 | 31.46 | 13.12 |
| 254 | 220 | 12 | 16.175 | 17.067 | 4.212 | 16.05 | 15.96 |
| 239 | 39 | 12 | 68.217 | 70.308 | 19.884 | 62.83 | 17.97 |
| 256 | 119 | 12 | 25.5 | 27.833 | 12.851 | 36.62 | 28.98 |