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 |
|---|---|---|---|---|---|---|---|
| 149 | 141 | 4 | 59.442 | 61.917 | 18.723 | 53.64 | 19.38 |
| 78 | 142 | 4 | 48.283 | 47.05 | 11.828 | 40.78 | 15.16 |
| 130 | 62 | 4 | 43.2 | 44.208 | 13.31 | 43.25 | 18.94 |
| 188 | 131 | 4 | 48.658 | 50.421 | 13.09 | 43.88 | 16 |
| 128 | 161 | 4 | 36.083 | 34.625 | 10.14 | 33.37 | 18.79 |
| 259 | 232 | 4 | 40.167 | 40.258 | 18.49 | 52.12 | 28.64 |
| 122 | 9 | 4 | 19.408 | 19.65 | 4.94 | 18.88 | 15.14 |
| 160 | 90 | 4 | 26.642 | 27.413 | 8.402 | 28.12 | 19.61 |
| 218 | 70 | 4 | 27.825 | 28.054 | 11.575 | 34.38 | 24.91 |
| 262 | 58 | 4 | 23.733 | 23.846 | 9.55 | 29.25 | 25.29 |
| 101 | 41 | 4 | 37.767 | 39.492 | 19.255 | 54.38 | 30.61 |
| 77 | 101 | 4 | 24.3 | 26.592 | 14.35 | 40.25 | 32.92 |
| 108 | 107 | 4 | 41.792 | 38.867 | 14.003 | 42.62 | 20.14 |
| 260 | 47 | 4 | 37.992 | 41.304 | 10.468 | 34.75 | 17.76 |
| 78 | 261 | 4 | 50.533 | 46.783 | 15.92 | 46.26 | 21.44 |
| 198 | 85 | 4 | 32.875 | 33.083 | 6.393 | 25.62 | 11.65 |
| 114 | 38 | 4 | 42.717 | 52.45 | 22.418 | 71.75 | 27.96 |
| 22 | 183 | 4 | 47.458 | 50.554 | 25.585 | 70.88 | 32.03 |
| 25 | 171 | 4 | 38.267 | 37.225 | 15.363 | 42.88 | 25.55 |
| 255 | 111 | 4 | 18.842 | 21.638 | 7.69 | 24.25 | 22.86 |
| 185 | 232 | 4 | 33.883 | 35.946 | 14.688 | 41.65 | 25.59 |
| 194 | 209 | 4 | 25.825 | 27.438 | 10.365 | 30.75 | 24.51 |
| 10 | 19 | 4 | 26.617 | 29.479 | 8.6 | 28.77 | 20.69 |
| 32 | 184 | 4 | 18.642 | 19.675 | 4.17 | 17.88 | 16.3 |
| 97 | 9 | 4 | 32.867 | 34.146 | 14.058 | 41.75 | 29 |