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 |
|---|---|---|---|---|---|---|---|
| 16 | 10 | 8 | 24.617 | 25.16 | 10.562 | 32.87 | 26.9 |
| 13 | 5 | 8 | 37.625 | 39.573 | 22.476 | 61.75 | 35.52 |
| 36 | 85 | 8 | 27.5 | 28.492 | 6.578 | 23.75 | 14.44 |
| 60 | 20 | 8 | 8.542 | 10.142 | 1.633 | 8.81 | 11.5 |
| 45 | 201 | 8 | 49.592 | 53.133 | 23.045 | 66.62 | 29.33 |
| 248 | 259 | 8 | 14.783 | 16.683 | 6.019 | 19.5 | 22.91 |
| 226 | 78 | 8 | 25.658 | 29.59 | 12.252 | 37.19 | 26.89 |
| 90 | 109 | 8 | 47.233 | 49.319 | 23.389 | 65.62 | 28.75 |
| 166 | 121 | 8 | 42.95 | 42.387 | 14.676 | 44.25 | 21.68 |
| 112 | 16 | 8 | 26.167 | 30.894 | 13.576 | 39.62 | 27.41 |
| 119 | 233 | 8 | 35.117 | 34.796 | 7.779 | 27.88 | 14.42 |
| 213 | 94 | 8 | 18.233 | 20.863 | 5.929 | 21.03 | 18.71 |
| 34 | 158 | 8 | 24.667 | 23.663 | 4.415 | 19.31 | 12.57 |
| 10 | 208 | 8 | 26.942 | 33.94 | 16.645 | 64.02 | 33.04 |
| 113 | 58 | 8 | 66.658 | 64.56 | 15.549 | 53.81 | 15.86 |
| 69 | 59 | 8 | 10.233 | 11.156 | 1.47 | 9 | 8.24 |
| 106 | 116 | 8 | 42.467 | 54.065 | 15.102 | 50.25 | 19.01 |
| 13 | 241 | 8 | 31.642 | 35.01 | 16.864 | 47.56 | 30.88 |
| 125 | 150 | 8 | 31.242 | 35.908 | 17.203 | 48.75 | 30.69 |
| 91 | 216 | 8 | 25.883 | 26.706 | 9.3 | 28.78 | 21.13 |
| 129 | 22 | 8 | 46.925 | 48.075 | 17.078 | 51.81 | 23.95 |
| 42 | 19 | 8 | 33.875 | 36.269 | 18.503 | 52.25 | 31.61 |
| 193 | 53 | 8 | 26.125 | 28.771 | 8.268 | 28.25 | 18.08 |
| 92 | 57 | 8 | 6.842 | 8.902 | 2.049 | 9 | 14.72 |
| 85 | 238 | 8 | 53.667 | 55.773 | 14.994 | 47.22 | 17.1 |