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 |
|---|---|---|---|---|---|---|---|
| 25 | 67 | 74 | 19.967 | 22.855 | 6.727 | 22.39 | 18.97 |
| 164 | 192 | 74 | 26.45 | 28.678 | 10.545 | 32.52 | 23.62 |
| 80 | 158 | 74 | 24.45 | 25.838 | 5.449 | 24 | 13.23 |
| 49 | 52 | 74 | 12.342 | 13.295 | 2.404 | 11.2 | 11.53 |
| 261 | 83 | 74 | 29.333 | 29.615 | 9.49 | 30.68 | 20.82 |
| 205 | 231 | 74 | 52.1 | 52.976 | 20.634 | 59.26 | 24.08 |
| 237 | 259 | 74 | 29.15 | 34.141 | 12.635 | 38.22 | 24.79 |
| 256 | 85 | 74 | 30.217 | 36.507 | 5.466 | 23.96 | 10.98 |
| 256 | 257 | 74 | 19.733 | 22.2 | 7.178 | 23.73 | 22.21 |
| 230 | 175 | 74 | 40.508 | 42.353 | 15.217 | 46.05 | 22.94 |
| 215 | 41 | 73 | 32.917 | 36.529 | 14.441 | 51.2 | 26.05 |
| 229 | 133 | 73 | 32.25 | 33.968 | 11.789 | 36.6 | 22.26 |
| 194 | 138 | 73 | 17.05 | 19.342 | 7.843 | 27.05 | 28.51 |
| 28 | 43 | 73 | 33.75 | 34.477 | 11.898 | 46.89 | 21.61 |
| 88 | 28 | 73 | 49.633 | 52.806 | 16.413 | 51.42 | 20.95 |
| 14 | 55 | 73 | 17.633 | 18.313 | 5.991 | 20.19 | 21.42 |
| 39 | 225 | 73 | 28.117 | 28.795 | 4.802 | 20.98 | 10.44 |
| 213 | 182 | 73 | 10.767 | 11.931 | 2.045 | 10.14 | 11.12 |
| 196 | 107 | 73 | 21.617 | 23.288 | 7.998 | 45.21 | 22.92 |
| 7 | 254 | 73 | 33.433 | 33.264 | 12.327 | 37.41 | 22.47 |
| 76 | 91 | 73 | 22.617 | 23.667 | 5.476 | 20.61 | 14.26 |
| 210 | 91 | 73 | 14.2 | 15.111 | 2.915 | 12.91 | 11.74 |
| 168 | 140 | 73 | 17.6 | 20.731 | 4.361 | 17.21 | 15.2 |
| 151 | 147 | 73 | 27.8 | 29.292 | 6.639 | 24.42 | 14.3 |
| 143 | 182 | 73 | 27.033 | 30.973 | 11.51 | 35.03 | 24.79 |