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 |
|---|---|---|---|---|---|---|---|
| 100 | 218 | 72 | 48.983 | 54.273 | 17.237 | 54.24 | 20.88 |
| 87 | 247 | 72 | 30.425 | 34.396 | 12.006 | 36.67 | 22.91 |
| 129 | 236 | 72 | 26.075 | 28.4 | 6.878 | 24.37 | 15.67 |
| 75 | 252 | 72 | 26.808 | 30.205 | 11.927 | 36.04 | 25.49 |
| 50 | 155 | 72 | 49.508 | 50.554 | 18.035 | 54.74 | 21.95 |
| 125 | 22 | 72 | 33.158 | 34.832 | 11.001 | 35.09 | 20.23 |
| 182 | 250 | 72 | 6.358 | 7.182 | 1.029 | 6.66 | 10.18 |
| 13 | 149 | 72 | 30.742 | 31.802 | 11.129 | 34.35 | 21.64 |
| 192 | 92 | 72 | 9.25 | 11.412 | 1.979 | 10.06 | 10.72 |
| 224 | 106 | 72 | 22.708 | 23.939 | 6.736 | 23.17 | 17.7 |
| 233 | 182 | 72 | 27.1 | 31.512 | 10.984 | 33.94 | 23.56 |
| 142 | 76 | 72 | 67.25 | 67.419 | 15.8 | 53.1 | 15.24 |
| 255 | 227 | 72 | 21.483 | 22.543 | 8.871 | 27.26 | 25.51 |
| 177 | 77 | 72 | 10.767 | 11.739 | 1.713 | 9.62 | 9.6 |
| 237 | 39 | 72 | 71.067 | 70.635 | 17.558 | 59.55 | 16.12 |
| 26 | 217 | 72 | 32.95 | 33.868 | 8.537 | 29.49 | 16.51 |
| 166 | 72 | 72 | 80.758 | 81.895 | 16.467 | 62.06 | 12.68 |
| 200 | 244 | 72 | 17.433 | 19.4 | 5.728 | 19.69 | 19.3 |
| 170 | 73 | 72 | 27.717 | 29.186 | 11.687 | 35.17 | 25.75 |
| 137 | 78 | 72 | 33.642 | 37.006 | 10.999 | 35.33 | 19.7 |
| 82 | 246 | 72 | 24.933 | 27.511 | 7.876 | 47.58 | 18.89 |
| 50 | 259 | 72 | 28.308 | 30.707 | 14.041 | 40.86 | 29.27 |
| 188 | 106 | 72 | 14.358 | 16.718 | 3.07 | 13.76 | 11.68 |
| 14 | 21 | 72 | 18.517 | 19.019 | 4.091 | 16.21 | 13.6 |
| 166 | 256 | 72 | 42.667 | 42.166 | 10.772 | 37.61 | 16.3 |