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 |
|---|---|---|---|---|---|---|---|
| 20 | 209 | 1 | 39.033 | 39.033 | 14.3 | 41.5 | 21.98 |
| 28 | 11 | 1 | 89.133 | 89.133 | 19.73 | 68.5 | 13.28 |
| 154 | 52 | 1 | 35.75 | 35.75 | 14.51 | 41 | 24.35 |
| 108 | 262 | 1 | 79.183 | 79.183 | 29.42 | 86 | 22.29 |
| 27 | 145 | 1 | 62.583 | 62.583 | 23.91 | 65.38 | 22.92 |
| 96 | 186 | 1 | 48.55 | 48.55 | 9.9 | 52 | 12.23 |
| 58 | 234 | 1 | 77.867 | 77.867 | 15.99 | 60 | 12.32 |
| 29 | 101 | 1 | 40.9 | 40.9 | 24.57 | 66 | 36.04 |
| 108 | 62 | 1 | 49.717 | 49.717 | 7.41 | 33.5 | 8.94 |
| 182 | 72 | 1 | 44.967 | 44.967 | 19.3 | 58 | 25.75 |
| 156 | 35 | 1 | 82.317 | 82.317 | 24.3 | 72 | 17.71 |
| 222 | 205 | 1 | 18.233 | 18.233 | 9.3 | 27.5 | 30.6 |
| 3 | 129 | 1 | 29.267 | 29.267 | 12.15 | 35 | 24.91 |
| 23 | 109 | 1 | 26.867 | 26.867 | 5.68 | 22 | 12.68 |
| 139 | 232 | 1 | 59.783 | 59.783 | 19.5 | 60 | 19.57 |
| 11 | 247 | 1 | 43.817 | 43.817 | 21.09 | 57 | 28.88 |
| 14 | 254 | 1 | 79.583 | 79.583 | 25 | 72.5 | 18.85 |
| 206 | 97 | 1 | 16.333 | 16.333 | 4.1 | 15 | 15.06 |
| 25 | 19 | 1 | 33.867 | 33.867 | 17.57 | 48.5 | 31.13 |
| 200 | 190 | 1 | 74.067 | 74.067 | 19.26 | 68.62 | 15.6 |
| 247 | 178 | 1 | 56.733 | 56.733 | 21.77 | 63 | 23.02 |
| 178 | 221 | 1 | 28.6 | 28.6 | 12.1 | 36 | 25.38 |
| 254 | 28 | 1 | 36.683 | 36.683 | 17.02 | 49.5 | 27.84 |
| 39 | 180 | 1 | 17.7 | 17.7 | 5.35 | 31.51 | 18.14 |
| 64 | 244 | 1 | 70.1 | 70.1 | 16.44 | 56 | 14.07 |