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 |
|---|---|---|---|---|---|---|---|
| 17 | 235 | 5 | 46.233 | 44.917 | 16.404 | 49.31 | 22.33 |
| 225 | 124 | 5 | 31.2 | 32.917 | 7.608 | 27.7 | 14.06 |
| 94 | 71 | 5 | 68.283 | 64.257 | 22.89 | 69.2 | 21.76 |
| 146 | 180 | 5 | 45.95 | 45.227 | 10.994 | 38.5 | 15.32 |
| 224 | 39 | 5 | 49.033 | 49.687 | 15.188 | 48.3 | 18.48 |
| 81 | 186 | 5 | 53.867 | 54.107 | 18.122 | 56.18 | 21.37 |
| 65 | 259 | 5 | 51.25 | 48.653 | 20.31 | 59.2 | 26 |
| 183 | 20 | 5 | 19.933 | 20.633 | 5.258 | 18.8 | 15.48 |
| 145 | 101 | 5 | 40.167 | 35.87 | 16.354 | 47.3 | 31.82 |
| 196 | 38 | 5 | 25.683 | 31.367 | 10.368 | 33.32 | 23.63 |
| 29 | 166 | 5 | 71.2 | 80.693 | 23.164 | 72.36 | 18.36 |
| 7 | 120 | 5 | 34.4 | 34.42 | 8.676 | 30.5 | 16.5 |
| 76 | 125 | 5 | 47.667 | 52.28 | 16.016 | 49.2 | 18.56 |
| 178 | 67 | 5 | 14.167 | 16.003 | 3.08 | 13.4 | 12.08 |
| 35 | 93 | 5 | 38.6 | 35.973 | 13.138 | 40.7 | 22.4 |
| 171 | 213 | 5 | 31.333 | 32.003 | 9.734 | 32.8 | 18.97 |
| 18 | 86 | 5 | 63.733 | 67.497 | 25.798 | 76.2 | 23.87 |
| 191 | 49 | 5 | 39.25 | 42.133 | 18.994 | 50.43 | 27.78 |
| 95 | 20 | 5 | 28.083 | 29.837 | 13.792 | 38.59 | 27.98 |
| 128 | 14 | 5 | 40.333 | 46.227 | 24.464 | 70.97 | 33.42 |
| 92 | 254 | 5 | 26.083 | 25.757 | 9.868 | 30.4 | 24.23 |
| 95 | 217 | 5 | 29.05 | 35.78 | 12.438 | 38.1 | 21.82 |
| 143 | 101 | 5 | 59.717 | 59.597 | 23.708 | 68.4 | 24.83 |
| 26 | 142 | 5 | 52.117 | 47.487 | 10.47 | 37.43 | 12.3 |
| 202 | 144 | 5 | 35.85 | 32.823 | 7.398 | 27.3 | 13.35 |