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 |
|---|---|---|---|---|---|---|---|
| 54 | 24 | 2 | 31.608 | 31.608 | 11.14 | 34.14 | 22.9 |
| 17 | 18 | 2 | 56.458 | 56.458 | 18.92 | 54.11 | 20.11 |
| 172 | 82 | 2 | 80.208 | 80.208 | 14.66 | 70.47 | 10.1 |
| 246 | 253 | 2 | 46.042 | 46.042 | 14.885 | 46.5 | 19.63 |
| 177 | 219 | 2 | 33.85 | 33.85 | 11.115 | 36 | 21.52 |
| 150 | 246 | 2 | 34.708 | 34.708 | 16.845 | 52 | 30.31 |
| 125 | 201 | 2 | 64.242 | 64.242 | 25.57 | 74.75 | 23.83 |
| 20 | 106 | 2 | 33.65 | 33.65 | 18.825 | 52.5 | 33.57 |
| 177 | 4 | 2 | 29.467 | 29.467 | 5.57 | 22.25 | 11.62 |
| 101 | 48 | 2 | 72.858 | 72.858 | 18.48 | 63.5 | 15.83 |
| 18 | 65 | 2 | 60.325 | 60.325 | 17.995 | 56.5 | 18.18 |
| 4 | 108 | 2 | 41.658 | 41.658 | 16.38 | 49 | 23.64 |
| 243 | 54 | 2 | 44.558 | 44.558 | 14.275 | 45.75 | 19.47 |
| 52 | 201 | 2 | 40.467 | 40.467 | 20.85 | 57.25 | 31.1 |
| 248 | 252 | 2 | 15.392 | 15.392 | 6.365 | 20 | 24.75 |
| 51 | 63 | 2 | 30.408 | 30.408 | 17.425 | 51.33 | 34.77 |
| 56 | 62 | 2 | 26.983 | 26.983 | 10.235 | 29.92 | 22.86 |
| 220 | 158 | 2 | 33.142 | 33.142 | 12.305 | 36.05 | 22.28 |
| 12 | 109 | 2 | 38.083 | 38.083 | 17.125 | 47.75 | 27.1 |
| 108 | 119 | 2 | 42.733 | 42.733 | 25.22 | 66.5 | 35.98 |
| 181 | 206 | 2 | 39.483 | 39.483 | 12.6 | 39.75 | 21.18 |
| 12 | 196 | 2 | 39.883 | 39.883 | 11.715 | 38.25 | 18.23 |
| 20 | 4 | 2 | 45.692 | 45.692 | 13.39 | 41.5 | 17.58 |
| 67 | 45 | 2 | 26.517 | 26.517 | 5.97 | 22.25 | 13.95 |
| 209 | 176 | 2 | 34.833 | 34.833 | 16.625 | 46.5 | 28.67 |