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 |
|---|---|---|---|---|---|---|---|
| 238 | 201 | 2 | 52.808 | 52.808 | 29.225 | 78.5 | 33.43 |
| 31 | 100 | 2 | 39.983 | 39.983 | 11.685 | 37.75 | 18.27 |
| 106 | 111 | 2 | 9.933 | 9.933 | 1.505 | 8.25 | 9.01 |
| 159 | 11 | 2 | 60.917 | 60.917 | 23.56 | 68 | 23.29 |
| 11 | 209 | 2 | 28.5 | 28.5 | 11.455 | 42.75 | 26.73 |
| 70 | 180 | 2 | 27.908 | 27.908 | 10.49 | 32.64 | 22.38 |
| 180 | 22 | 2 | 44.2 | 44.2 | 15.115 | 48.75 | 21.21 |
| 227 | 246 | 2 | 28.2 | 28.2 | 9.55 | 29.75 | 20.31 |
| 171 | 41 | 2 | 43.525 | 43.525 | 13.415 | 42.25 | 18.48 |
| 125 | 59 | 2 | 33.667 | 33.667 | 13.21 | 39.5 | 24.06 |
| 69 | 34 | 2 | 49.925 | 49.925 | 15.27 | 47.27 | 19.16 |
| 177 | 174 | 2 | 41.633 | 41.633 | 21.81 | 61.25 | 33.33 |
| 136 | 148 | 2 | 45.192 | 45.192 | 13.55 | 42.5 | 18.08 |
| 18 | 217 | 2 | 33.792 | 33.792 | 16.825 | 48.02 | 32.28 |
| 114 | 105 | 2 | 17.458 | 17.458 | 3.6 | 15 | 12.69 |
| 56 | 169 | 2 | 38.583 | 38.583 | 13.845 | 42 | 22.55 |
| 77 | 142 | 2 | 67.625 | 67.625 | 15.03 | 54.38 | 13.69 |
| 218 | 7 | 2 | 32.55 | 32.55 | 14.14 | 38.09 | 26.18 |
| 112 | 86 | 2 | 48.167 | 48.167 | 27.8 | 75.5 | 34.83 |
| 255 | 180 | 2 | 27.933 | 27.933 | 10.185 | 30.75 | 21.86 |
| 250 | 239 | 2 | 24.583 | 24.583 | 6.58 | 23.5 | 15.46 |
| 147 | 129 | 2 | 18.1 | 18.1 | 7.115 | 22.75 | 24.32 |
| 162 | 99 | 2 | 52.733 | 52.733 | 27.945 | 75.75 | 31.8 |
| 93 | 150 | 2 | 57.642 | 57.642 | 21.61 | 49.5 | 22.86 |
| 57 | 170 | 2 | 29.242 | 29.242 | 8.295 | 28 | 18.38 |