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 |
|---|---|---|---|---|---|---|---|
| 254 | 208 | 18 | 19.667 | 21.765 | 6.452 | 22.19 | 17.79 |
| 145 | 205 | 18 | 42.542 | 44.631 | 15.663 | 46.48 | 23.26 |
| 250 | 69 | 18 | 29.667 | 28.733 | 5.543 | 22.56 | 12.53 |
| 39 | 80 | 18 | 32.25 | 33.429 | 6.453 | 25.53 | 11.81 |
| 205 | 39 | 18 | 31.95 | 31.471 | 10.942 | 33.79 | 21.96 |
| 129 | 152 | 18 | 28.233 | 28.395 | 7.742 | 26.69 | 17.09 |
| 162 | 117 | 18 | 69.717 | 69.578 | 20.096 | 63.75 | 19.11 |
| 45 | 29 | 18 | 36.883 | 37.863 | 14.063 | 42.45 | 25.1 |
| 121 | 68 | 18 | 27.108 | 36.206 | 11.883 | 37.26 | 22.82 |
| 143 | 183 | 18 | 26.783 | 32.789 | 14.466 | 41.2 | 29.63 |
| 75 | 180 | 18 | 51.925 | 51.2 | 15.889 | 50.78 | 29.75 |
| 197 | 19 | 18 | 22.642 | 24.824 | 8.826 | 27.05 | 22.75 |
| 249 | 201 | 18 | 42.425 | 43.955 | 23.127 | 63.36 | 31.91 |
| 13 | 219 | 18 | 44.583 | 51.865 | 23.758 | 56.14 | 29.88 |
| 198 | 170 | 18 | 28.2 | 31.327 | 7.679 | 26.43 | 15.32 |
| 112 | 166 | 18 | 32.358 | 32.456 | 9.695 | 31.58 | 18.09 |
| 208 | 183 | 18 | 5.45 | 7.228 | 1.334 | 7.06 | 10.78 |
| 16 | 135 | 18 | 16.708 | 17.967 | 5.09 | 18.28 | 17.64 |
| 82 | 205 | 18 | 35.5 | 34.881 | 10.634 | 33.95 | 19.96 |
| 17 | 223 | 18 | 21.758 | 22.987 | 8.404 | 25.68 | 23.05 |
| 195 | 234 | 18 | 26.475 | 29.763 | 7.407 | 26.22 | 15.47 |
| 166 | 83 | 18 | 30.35 | 30.903 | 8.227 | 28.75 | 16.61 |
| 243 | 76 | 18 | 52.617 | 53.084 | 20.601 | 58.98 | 24.19 |
| 54 | 236 | 18 | 32.85 | 34.587 | 10.128 | 32.33 | 18.54 |
| 177 | 205 | 18 | 31.417 | 31.257 | 11.004 | 32.28 | 21.85 |