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 |
|---|---|---|---|---|---|---|---|
| 198 | 112 | 26 | 16.2 | 17.586 | 3.574 | 14.24 | 12.88 |
| 26 | 140 | 26 | 46.758 | 46.874 | 13.545 | 41.84 | 18.06 |
| 66 | 146 | 26 | 23.875 | 23.694 | 7.286 | 24.4 | 18.93 |
| 220 | 168 | 26 | 20.75 | 22.643 | 7.532 | 24.72 | 21.48 |
| 225 | 261 | 26 | 38.558 | 38.535 | 6.219 | 26.3 | 10.09 |
| 42 | 191 | 26 | 39.908 | 41.485 | 18.64 | 53.29 | 29.14 |
| 215 | 134 | 26 | 16.483 | 19.669 | 4.57 | 16.62 | 13.84 |
| 194 | 234 | 26 | 31.742 | 31.941 | 7.743 | 27.25 | 15.24 |
| 32 | 233 | 26 | 54.692 | 54.071 | 11.98 | 43.82 | 14.13 |
| 35 | 48 | 26 | 54.517 | 56.806 | 13.184 | 45.33 | 15.09 |
| 177 | 85 | 26 | 21.583 | 22.454 | 3.455 | 16.59 | 9.57 |
| 76 | 55 | 26 | 26.542 | 30.703 | 12.134 | 37.67 | 26.06 |
| 119 | 18 | 26 | 17.142 | 18.867 | 3.289 | 14.85 | 11.07 |
| 67 | 75 | 26 | 34.467 | 35.709 | 16.233 | 45.46 | 27.77 |
| 191 | 74 | 26 | 44.225 | 45.381 | 19.942 | 56.8 | 27.77 |
| 197 | 79 | 26 | 40.692 | 40.778 | 12.988 | 44.18 | 21.1 |
| 114 | 39 | 26 | 44.867 | 44.158 | 13.108 | 42.42 | 17.97 |
| 258 | 41 | 26 | 31.075 | 32.699 | 16.13 | 43.37 | 30.21 |
| 216 | 141 | 26 | 44.142 | 44.842 | 15.633 | 51.06 | 23.21 |
| 75 | 117 | 26 | 59.5 | 61.121 | 25.354 | 70.71 | 25.54 |
| 259 | 231 | 26 | 45.442 | 46.905 | 19.471 | 52.61 | 25.62 |
| 223 | 135 | 26 | 17.45 | 18.787 | 7.797 | 24.13 | 27.64 |
| 152 | 92 | 26 | 33.425 | 38.358 | 11.736 | 37.87 | 20.15 |
| 256 | 69 | 26 | 30.15 | 30.631 | 12.47 | 37.38 | 25.47 |
| 138 | 176 | 26 | 55.917 | 58.227 | 25.198 | 70.38 | 26.66 |