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 |
|---|---|---|---|---|---|---|---|
| 255 | 124 | 8 | 30.583 | 32.002 | 13.76 | 40.88 | 26.51 |
| 67 | 65 | 8 | 44.167 | 43.983 | 6.936 | 29.41 | 9.72 |
| 56 | 42 | 8 | 30.567 | 31.702 | 11.841 | 37.74 | 23.69 |
| 19 | 252 | 8 | 17.183 | 17.496 | 8.326 | 24.56 | 32.31 |
| 208 | 259 | 8 | 26.867 | 24.74 | 6.61 | 23.8 | 17.92 |
| 151 | 171 | 8 | 35.083 | 39.192 | 13.596 | 42.38 | 22.78 |
| 26 | 5 | 8 | 37.992 | 41.867 | 17.875 | 53.19 | 26.78 |
| 9 | 131 | 8 | 9.333 | 10.41 | 1.988 | 9.56 | 11.45 |
| 32 | 127 | 8 | 29.142 | 28.483 | 4.48 | 20.56 | 10.29 |
| 66 | 202 | 8 | 25.533 | 26.196 | 9.128 | 28.31 | 20.82 |
| 177 | 9 | 8 | 35.283 | 35.35 | 11.885 | 36.34 | 20.57 |
| 21 | 150 | 8 | 17.1 | 16.89 | 3.853 | 15.32 | 14.51 |
| 217 | 135 | 8 | 35.033 | 35.033 | 10.486 | 34.42 | 19.32 |
| 53 | 192 | 8 | 13.108 | 13.879 | 4.199 | 14.33 | 18.64 |
| 169 | 117 | 8 | 49.725 | 55.665 | 26.07 | 72.5 | 29.96 |
| 200 | 259 | 8 | 19.067 | 24.183 | 6.973 | 27.05 | 19.14 |
| 207 | 68 | 8 | 40.792 | 37.565 | 8.303 | 34.38 | 14.09 |
| 216 | 26 | 8 | 52.692 | 49.537 | 17.319 | 49.76 | 21.42 |
| 165 | 66 | 8 | 30.908 | 30.479 | 7.344 | 26.75 | 15.39 |
| 238 | 150 | 8 | 52.933 | 51.562 | 23.219 | 65.75 | 27.43 |
| 175 | 75 | 8 | 47.85 | 47.367 | 16.301 | 47.38 | 21.45 |
| 167 | 68 | 8 | 43.642 | 43.948 | 11.046 | 36.22 | 16.06 |
| 93 | 247 | 8 | 24.225 | 26.562 | 11.221 | 35.88 | 26.79 |
| 241 | 68 | 8 | 54.033 | 53.696 | 13.84 | 47.44 | 17.3 |
| 40 | 76 | 8 | 37.083 | 39.617 | 9.1 | 31.86 | 14.91 |