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 |
|---|---|---|---|---|---|---|---|
| 25 | 191 | 69 | 73.35 | 71.852 | 21.473 | 66.02 | 19.36 |
| 137 | 205 | 69 | 45.35 | 49.313 | 16.544 | 49.73 | 22.4 |
| 137 | 93 | 69 | 27 | 32.712 | 11.602 | 36.32 | 24.11 |
| 39 | 17 | 69 | 32.433 | 33.185 | 5.836 | 23.99 | 10.91 |
| 146 | 116 | 69 | 28.1 | 31.05 | 7.926 | 27.87 | 16.69 |
| 246 | 35 | 69 | 60 | 60.143 | 10.464 | 42.52 | 11.17 |
| 140 | 139 | 69 | 47.2 | 51.035 | 19.846 | 57.6 | 24.52 |
| 52 | 62 | 69 | 16.133 | 17.168 | 3.033 | 13.75 | 11.09 |
| 36 | 177 | 69 | 13.95 | 14.587 | 2.372 | 11.46 | 10.32 |
| 161 | 150 | 69 | 49.067 | 52.371 | 20.391 | 59.97 | 24.83 |
| 138 | 221 | 69 | 48.45 | 54.154 | 21.967 | 62.86 | 26.74 |
| 229 | 126 | 69 | 22.833 | 24.6 | 7.779 | 25.76 | 19.77 |
| 223 | 8 | 69 | 3.867 | 4.333 | 1 | 7.59 | 19.26 |
| 260 | 74 | 69 | 19.65 | 22.589 | 6.508 | 22.04 | 19.8 |
| 170 | 180 | 69 | 37.75 | 40.196 | 12.327 | 40.62 | 19.87 |
| 247 | 48 | 69 | 28.1 | 29.521 | 8.032 | 28.03 | 17.78 |
| 141 | 16 | 69 | 34.45 | 36.716 | 15.337 | 45.02 | 26.89 |
| 170 | 78 | 69 | 36.05 | 38.735 | 10.727 | 35.64 | 18.82 |
| 79 | 20 | 69 | 30.15 | 33.994 | 13.626 | 40.24 | 25.97 |
| 114 | 185 | 69 | 37.583 | 41.785 | 15.253 | 45.7 | 23.82 |
| 163 | 76 | 69 | 42.533 | 47.402 | 15.245 | 48.23 | 23.55 |
| 123 | 133 | 69 | 13 | 14.529 | 2.83 | 12.96 | 12.88 |
| 255 | 54 | 69 | 15.433 | 16.081 | 5.168 | 17.51 | 21.94 |
| 165 | 133 | 69 | 11.367 | 12.114 | 1.914 | 10.15 | 10.62 |
| 244 | 129 | 69 | 25.183 | 27.66 | 9.3 | 29.51 | 21.74 |