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 |
|---|---|---|---|---|---|---|---|
| 145 | 28 | 61 | 26.45 | 30.64 | 9.633 | 31.36 | 22.38 |
| 220 | 153 | 61 | 5.367 | 6.01 | 0.865 | 5.89 | 9.26 |
| 17 | 231 | 61 | 25.733 | 27.154 | 4.614 | 20.77 | 11.06 |
| 89 | 67 | 61 | 17.333 | 18.631 | 3.584 | 15.14 | 12.08 |
| 161 | 53 | 61 | 35.733 | 38.309 | 12.969 | 40.4 | 21.38 |
| 95 | 41 | 61 | 27.117 | 30.082 | 10.337 | 32.48 | 21.66 |
| 235 | 18 | 61 | 12.483 | 12.66 | 2.041 | 10.41 | 10.24 |
| 163 | 94 | 61 | 31.233 | 34.235 | 10.057 | 33.34 | 19.64 |
| 205 | 42 | 61 | 39.967 | 42.164 | 18.461 | 52.7 | 27.56 |
| 244 | 148 | 61 | 39.067 | 40.396 | 11.223 | 37.51 | 18.16 |
| 88 | 235 | 61 | 41.383 | 45.019 | 14.388 | 44.36 | 23.73 |
| 14 | 132 | 61 | 37.317 | 40.568 | 20.568 | 55.01 | 34.29 |
| 243 | 79 | 61 | 42.033 | 41.243 | 10.647 | 34.99 | 17.1 |
| 79 | 252 | 61 | 33.167 | 36.468 | 15.297 | 44.63 | 27.11 |
| 164 | 94 | 61 | 30.667 | 33.433 | 11.444 | 35.78 | 21.83 |
| 233 | 21 | 61 | 40.3 | 41.049 | 14.689 | 44.2 | 22.56 |
| 243 | 128 | 61 | 9.267 | 9.955 | 1.919 | 9.22 | 13.14 |
| 193 | 232 | 61 | 19 | 20.343 | 6.668 | 22.25 | 21.82 |
| 68 | 31 | 61 | 38.033 | 39.131 | 14.237 | 43.72 | 23.3 |
| 37 | 48 | 61 | 29.317 | 35.34 | 8.104 | 28.6 | 15.14 |
| 256 | 143 | 61 | 32.383 | 33.512 | 7.505 | 27.91 | 14.11 |
| 51 | 259 | 61 | 15.65 | 17.563 | 3.802 | 15.67 | 13.85 |
| 88 | 177 | 61 | 39.1 | 40.653 | 8.5 | 32.03 | 13.2 |
| 33 | 41 | 61 | 36.517 | 37.316 | 11.42 | 36.18 | 19.33 |
| 137 | 47 | 61 | 31.017 | 34.118 | 9.655 | 32.12 | 19 |