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 |
|---|---|---|---|---|---|---|---|
| 9 | 68 | 2 | 61.067 | 61.067 | 14.85 | 50 | 15.1 |
| 228 | 28 | 2 | 35.25 | 35.25 | 20.345 | 55.75 | 35.47 |
| 219 | 60 | 2 | 38.608 | 38.608 | 18.42 | 54.72 | 28.7 |
| 128 | 246 | 2 | 17.867 | 17.867 | 9.865 | 28.5 | 33.4 |
| 196 | 183 | 2 | 32.875 | 32.875 | 10.775 | 33.5 | 25.09 |
| 70 | 212 | 2 | 26.883 | 26.883 | 9.885 | 29.75 | 22.12 |
| 167 | 131 | 2 | 25 | 25 | 13.97 | 39.7 | 33.54 |
| 215 | 40 | 2 | 64.558 | 64.558 | 22.26 | 65.75 | 23.08 |
| 153 | 31 | 2 | 15.317 | 15.317 | 3.15 | 13 | 12.37 |
| 61 | 252 | 2 | 30.492 | 30.492 | 12.97 | 39.5 | 28.8 |
| 181 | 156 | 2 | 31.258 | 31.258 | 13.87 | 41 | 30.56 |
| 17 | 53 | 2 | 43.3 | 43.3 | 12.6 | 40.75 | 18.02 |
| 126 | 114 | 2 | 52.442 | 52.442 | 11.84 | 42.25 | 13.77 |
| 201 | 210 | 2 | 26.083 | 26.083 | 8.15 | 26.5 | 23.1 |
| 208 | 62 | 2 | 55.242 | 55.242 | 19.18 | 53.56 | 21.01 |
| 182 | 233 | 2 | 56.05 | 56.05 | 10.735 | 43.36 | 11.6 |
| 243 | 59 | 2 | 16.317 | 16.317 | 3.56 | 14.25 | 13.15 |
| 94 | 87 | 2 | 50.617 | 50.617 | 16.285 | 49.75 | 19.29 |
| 70 | 8 | 2 | 10.592 | 10.592 | 4.865 | 15 | 27.19 |
| 70 | 58 | 2 | 32.892 | 32.892 | 9.97 | 43.75 | 22.73 |
| 145 | 11 | 2 | 30.35 | 30.35 | 14.675 | 42.25 | 29 |
| 61 | 196 | 2 | 43.792 | 43.792 | 8.6 | 33.75 | 12 |
| 201 | 14 | 2 | 59.142 | 59.142 | 14.815 | 51.25 | 17.56 |
| 134 | 159 | 2 | 40.433 | 40.433 | 13.255 | 41.5 | 20.06 |
| 135 | 246 | 2 | 33.017 | 33.017 | 8.41 | 30.5 | 15.28 |