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 |
|---|---|---|---|---|---|---|---|
| 60 | 163 | 3 | 60.95 | 68.233 | 10.78 | 45.17 | 10.19 |
| 191 | 142 | 3 | 44.6 | 47.328 | 18.233 | 54.5 | 23.53 |
| 37 | 135 | 3 | 22.15 | 21.772 | 8.243 | 23.87 | 22.98 |
| 77 | 6 | 3 | 44.7 | 45.344 | 24.613 | 69.83 | 32.95 |
| 153 | 45 | 3 | 67 | 58.939 | 14.937 | 52.26 | 18.72 |
| 70 | 91 | 3 | 51.167 | 60.572 | 16.783 | 53.5 | 17.12 |
| 146 | 5 | 3 | 56.733 | 62.561 | 29.963 | 82.5 | 30.21 |
| 191 | 79 | 3 | 57.45 | 57.556 | 19.35 | 57.1 | 20.13 |
| 32 | 262 | 3 | 21.917 | 21.767 | 8.937 | 27.67 | 25.1 |
| 82 | 81 | 3 | 26.117 | 35.367 | 13.793 | 42 | 27.08 |
| 137 | 253 | 3 | 39.367 | 36.456 | 12.153 | 33.38 | 21.51 |
| 160 | 61 | 3 | 28.683 | 27.028 | 4.433 | 19.67 | 9.96 |
| 71 | 138 | 3 | 63.417 | 54.439 | 15.847 | 51 | 18.56 |
| 75 | 251 | 3 | 62.667 | 63.583 | 23.38 | 68.17 | 22.13 |
| 70 | 242 | 3 | 18.983 | 19.794 | 9 | 27 | 27.43 |
| 223 | 139 | 2 | 31.05 | 31.05 | 14.905 | 41.75 | 28.8 |
| 198 | 149 | 2 | 56.925 | 56.925 | 11.145 | 43.25 | 11.98 |
| 21 | 138 | 2 | 37.367 | 37.367 | 22.095 | 61.75 | 35.8 |
| 256 | 178 | 2 | 29.667 | 29.667 | 9.8 | 30.75 | 20.17 |
| 66 | 1 | 2 | 66.458 | 66.458 | 23.96 | 73.5 | 23.26 |
| 101 | 74 | 2 | 59.858 | 59.858 | 18.56 | 60.5 | 18.64 |
| 102 | 100 | 2 | 58.508 | 58.508 | 14.74 | 58.5 | 14.65 |
| 18 | 22 | 2 | 65.433 | 65.433 | 24.325 | 72 | 22.34 |
| 180 | 67 | 2 | 23.058 | 23.058 | 14.455 | 42.77 | 38.22 |
| 38 | 179 | 2 | 33.525 | 33.525 | 16.825 | 47 | 29.96 |