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 |
|---|---|---|---|---|---|---|---|
| 90 | 250 | 102 | 33.858 | 35.95 | 13.694 | 41.34 | 24.25 |
| 74 | 81 | 102 | 24.442 | 27.126 | 10.798 | 32.73 | 26.26 |
| 163 | 250 | 102 | 26.483 | 30.851 | 11.252 | 34.82 | 24.12 |
| 193 | 68 | 102 | 22.75 | 27.199 | 5.249 | 21.69 | 13.31 |
| 130 | 90 | 102 | 36.617 | 37.178 | 13.286 | 51.71 | 23.14 |
| 148 | 63 | 102 | 31.442 | 34.208 | 10.196 | 33.6 | 19.37 |
| 234 | 102 | 102 | 32.65 | 33.349 | 9.387 | 31.68 | 19.47 |
| 168 | 236 | 102 | 15.758 | 17.792 | 3.326 | 15.38 | 12.81 |
| 246 | 1 | 102 | 29.05 | 34.516 | 16.634 | 80.32 | 33.27 |
| 177 | 75 | 102 | 53.517 | 56.463 | 18.483 | 57.41 | 20.53 |
| 79 | 194 | 102 | 24.783 | 25.374 | 8.25 | 26.14 | 20.95 |
| 226 | 224 | 102 | 17.942 | 19.169 | 4.647 | 33 | 16.01 |
| 89 | 65 | 102 | 27.492 | 28.596 | 5.254 | 21.61 | 11.94 |
| 161 | 178 | 102 | 44.65 | 46.088 | 13.505 | 43.78 | 18.74 |
| 26 | 21 | 102 | 14.942 | 16.195 | 2.545 | 12.52 | 10.02 |
| 234 | 11 | 102 | 36.15 | 37.848 | 14.411 | 43.13 | 23.87 |
| 162 | 122 | 102 | 33.183 | 35.476 | 14.088 | 41.68 | 25.42 |
| 203 | 203 | 102 | 4.142 | 7.188 | 1.628 | 12.05 | 21.3 |
| 209 | 67 | 102 | 23.633 | 26.01 | 8.577 | 27.47 | 21.65 |
| 114 | 85 | 102 | 30.025 | 31.698 | 8.381 | 29.07 | 16.69 |
| 145 | 61 | 102 | 25.708 | 27.127 | 6.522 | 23.52 | 15.25 |
| 142 | 153 | 102 | 23.483 | 25.679 | 9.761 | 30.18 | 24.18 |
| 137 | 212 | 102 | 27.083 | 30.133 | 10.147 | 31.78 | 22.55 |
| 226 | 181 | 102 | 26.925 | 27.827 | 8.062 | 27.41 | 18.67 |
| 68 | 93 | 102 | 37.683 | 41.851 | 12.18 | 41.01 | 19.19 |