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 |
|---|---|---|---|---|---|---|---|
| 52 | 260 | 15 | 24.683 | 24.292 | 9.342 | 27.97 | 23.83 |
| 229 | 57 | 15 | 28.183 | 28.218 | 9.313 | 29.53 | 20.47 |
| 45 | 212 | 15 | 32.767 | 34.547 | 13.743 | 40.3 | 25.28 |
| 88 | 94 | 15 | 29 | 34.289 | 14.945 | 43.5 | 28.69 |
| 174 | 119 | 15 | 24.65 | 24.594 | 6.065 | 22.28 | 15.66 |
| 37 | 50 | 15 | 36.7 | 48.282 | 7.924 | 34.47 | 11.83 |
| 78 | 51 | 15 | 23.617 | 24.017 | 7.986 | 25.94 | 21.2 |
| 49 | 224 | 15 | 20.7 | 21.482 | 6.009 | 20.83 | 17.55 |
| 117 | 76 | 15 | 29.883 | 28.316 | 9.995 | 31.72 | 21.85 |
| 216 | 62 | 15 | 33.8 | 35.367 | 8.985 | 31.23 | 15.98 |
| 236 | 222 | 15 | 66.1 | 66.146 | 18.907 | 61.18 | 18.72 |
| 169 | 61 | 15 | 59.433 | 60.302 | 19.416 | 59.85 | 20.49 |
| 80 | 136 | 15 | 33.733 | 39.586 | 14.746 | 44.9 | 23.84 |
| 169 | 213 | 15 | 20.45 | 19.869 | 4.391 | 16.98 | 13.85 |
| 68 | 58 | 15 | 30.25 | 32.856 | 15.627 | 44.57 | 29.77 |
| 86 | 186 | 15 | 64.833 | 64.432 | 20.822 | 56.41 | 19.47 |
| 234 | 203 | 15 | 51.95 | 52.718 | 20.524 | 59.37 | 25.74 |
| 124 | 150 | 15 | 25.817 | 27.688 | 11.363 | 33.31 | 25.71 |
| 95 | 19 | 15 | 18.483 | 18.801 | 7.686 | 23.36 | 26.94 |
| 32 | 208 | 15 | 16.967 | 20.302 | 6.273 | 21.8 | 18.07 |
| 34 | 114 | 15 | 17.483 | 17.087 | 3.351 | 14.5 | 12.04 |
| 19 | 197 | 15 | 21.217 | 25.154 | 9.548 | 28.05 | 23.51 |
| 263 | 201 | 15 | 51.317 | 58.833 | 26.85 | 75.49 | 31.09 |
| 71 | 234 | 15 | 40.3 | 42.841 | 9.381 | 33.84 | 13.77 |
| 193 | 66 | 15 | 28.633 | 30.281 | 7.131 | 25.62 | 15.16 |