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 |
|---|---|---|---|---|---|---|---|
| 167 | 31 | 2 | 25.033 | 25.033 | 4.585 | 20.75 | 10.78 |
| 240 | 162 | 2 | 25.408 | 25.408 | 7.635 | 24.75 | 12.52 |
| 58 | 213 | 2 | 17.717 | 17.717 | 4.38 | 15.75 | 14.85 |
| 255 | 219 | 2 | 32.867 | 32.867 | 16.275 | 46.25 | 29.71 |
| 38 | 66 | 2 | 92.85 | 92.85 | 25.21 | 62.11 | 18.91 |
| 174 | 33 | 2 | 84.733 | 84.733 | 19.65 | 61.17 | 14.04 |
| 49 | 59 | 2 | 53.2 | 53.2 | 15.3 | 50.25 | 17.39 |
| 179 | 96 | 2 | 32.242 | 32.242 | 10.85 | 35 | 21.05 |
| 115 | 6 | 2 | 4.975 | 4.975 | 1.14 | 6 | 13.72 |
| 29 | 3 | 2 | 72.683 | 72.683 | 30.75 | 86 | 26.76 |
| 96 | 80 | 2 | 23.092 | 23.092 | 3.51 | 16.5 | 9.22 |
| 83 | 126 | 2 | 24.575 | 24.575 | 8.035 | 24.5 | 19.78 |
| 102 | 61 | 2 | 66.75 | 66.75 | 30.2 | 154.5 | 22.26 |
| 227 | 218 | 2 | 54.875 | 54.875 | 20.705 | 64.86 | 22.65 |
| 37 | 29 | 2 | 33.958 | 33.958 | 11.66 | 37.75 | 20.72 |
| 101 | 173 | 2 | 37.3 | 37.3 | 12.2 | 38.75 | 20.36 |
| 212 | 141 | 2 | 17.883 | 17.883 | 7.75 | 23.25 | 25.99 |
| 223 | 133 | 2 | 34.15 | 34.15 | 15.18 | 43.5 | 27.17 |
| 16 | 13 | 2 | 56.775 | 56.775 | 21.265 | 63.75 | 23.91 |
| 222 | 189 | 2 | 31.1 | 31.1 | 5.79 | 23.75 | 11.18 |
| 86 | 126 | 2 | 50.908 | 50.908 | 23.295 | 66.25 | 27.9 |
| 252 | 197 | 2 | 30.883 | 30.883 | 8.7 | 30.25 | 22.1 |
| 77 | 168 | 2 | 40.067 | 40.067 | 18.3 | 51.86 | 29.25 |
| 76 | 221 | 2 | 37.125 | 37.125 | 21.365 | 59.25 | 35.21 |
| 210 | 135 | 2 | 43.092 | 43.092 | 16.43 | 52.52 | 22.92 |