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 |
|---|---|---|---|---|---|---|---|
| 260 | 70 | 260 | 10.717 | 12.332 | 3.053 | 12.55 | 16.91 |
| 255 | 186 | 260 | 26.95 | 28.319 | 5.407 | 21.94 | 12.24 |
| 45 | 166 | 260 | 35.5 | 36.951 | 8.726 | 31.72 | 15.23 |
| 107 | 220 | 260 | 33.742 | 36.571 | 12.923 | 39.68 | 22.94 |
| 41 | 7 | 260 | 22.333 | 23.247 | 5.712 | 20.98 | 15.8 |
| 246 | 168 | 260 | 29.225 | 30.982 | 8.936 | 29.94 | 18.6 |
| 256 | 158 | 260 | 21.7 | 22.526 | 4.187 | 20.28 | 11.94 |
| 135 | 170 | 260 | 26.35 | 27.704 | 15.858 | 44.85 | 35.41 |
| 140 | 18 | 260 | 30.308 | 34.405 | 9.565 | 31.81 | 18.79 |
| 255 | 137 | 260 | 19.108 | 20.532 | 4.469 | 17.45 | 13.94 |
| 93 | 87 | 259 | 28.567 | 30.277 | 13.249 | 51.45 | 28.03 |
| 234 | 200 | 259 | 34.3 | 37.416 | 13.519 | 41.62 | 23.08 |
| 230 | 18 | 259 | 30.95 | 33.096 | 12.298 | 37.78 | 23.57 |
| 229 | 89 | 259 | 35.3 | 37.787 | 12.202 | 38.35 | 21.01 |
| 114 | 67 | 259 | 26.583 | 27.894 | 10.107 | 31.48 | 22.75 |
| 229 | 70 | 259 | 24.483 | 26.894 | 8.563 | 28.44 | 21.13 |
| 239 | 194 | 258 | 23.8 | 25.098 | 6.412 | 26.42 | 15.85 |
| 138 | 201 | 258 | 48.575 | 50.511 | 20.37 | 58.49 | 25.76 |
| 263 | 167 | 258 | 19.1 | 20.403 | 5.11 | 18.73 | 16.29 |
| 141 | 200 | 258 | 29.067 | 31.256 | 11.74 | 35.7 | 24.2 |
| 80 | 132 | 258 | 33.142 | 35.717 | 14.623 | 49.82 | 28.28 |
| 256 | 48 | 258 | 28.333 | 30.499 | 6.249 | 24.59 | 15.34 |
| 236 | 119 | 258 | 19.617 | 22.019 | 5.425 | 19.75 | 16.66 |
| 48 | 71 | 258 | 52.042 | 52.998 | 12.217 | 43.31 | 14.81 |
| 232 | 217 | 258 | 10.7 | 11.592 | 2.548 | 11.35 | 14.41 |