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 |
|---|---|---|---|---|---|---|---|
| 49 | 65 | 807 | 8.867 | 9.935 | 1.511 | 8.63 | 9.82 |
| 140 | 69 | 807 | 19.1 | 20.883 | 5.532 | 19.69 | 17.78 |
| 113 | 179 | 806 | 27.967 | 28.645 | 6.457 | 23.85 | 14.48 |
| 236 | 247 | 806 | 19.242 | 21.59 | 4.512 | 18.01 | 13.98 |
| 232 | 100 | 805 | 22.15 | 23.197 | 3.775 | 17.53 | 11.02 |
| 33 | 61 | 805 | 19.4 | 20.969 | 3.548 | 16.01 | 10.87 |
| 230 | 188 | 805 | 41.183 | 42.766 | 10.257 | 36.02 | 15.14 |
| 189 | 97 | 804 | 6.225 | 6.845 | 0.999 | 6.49 | 9.32 |
| 145 | 68 | 803 | 21.833 | 23.534 | 3.727 | 44.64 | 11.01 |
| 125 | 112 | 802 | 23.925 | 24.926 | 5.127 | 20.86 | 13.25 |
| 41 | 159 | 802 | 15.05 | 16.099 | 2.846 | 13.11 | 11.32 |
| 234 | 198 | 802 | 30.217 | 32.827 | 7.852 | 28.09 | 15.42 |
| 65 | 68 | 802 | 20.9 | 22.721 | 4.775 | 19.16 | 13.52 |
| 170 | 217 | 801 | 27.45 | 28.751 | 5.459 | 23.06 | 12.05 |
| 132 | 212 | 801 | 34.333 | 37.489 | 18.432 | 51.27 | 32.2 |
| 138 | 57 | 801 | 12.433 | 13.636 | 3.08 | 12.87 | 14.94 |
| 12 | 45 | 801 | 12.183 | 13.193 | 1.64 | 10.01 | 7.95 |
| 261 | 17 | 800 | 25.408 | 26.528 | 5.009 | 20.64 | 11.91 |
| 50 | 33 | 800 | 29.575 | 30.719 | 7.103 | 25.88 | 14.54 |
| 142 | 49 | 800 | 38.3 | 39.724 | 9.123 | 32.81 | 14.39 |
| 138 | 38 | 800 | 30.242 | 33.419 | 14.518 | 42.18 | 28.38 |
| 223 | 138 | 800 | 9.9 | 11.607 | 3.161 | 13.38 | 19.7 |
| 33 | 255 | 799 | 16.417 | 17.225 | 4.05 | 15.93 | 15.02 |
| 74 | 186 | 798 | 25.017 | 27.374 | 5.682 | 22.28 | 14.06 |
| 33 | 45 | 798 | 9.942 | 11.506 | 2.327 | 10.83 | 13.78 |