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 |
|---|---|---|---|---|---|---|---|
| 56 | 125 | 37 | 32.417 | 33.59 | 10.149 | 51.74 | 19.61 |
| 211 | 147 | 37 | 26.867 | 28.782 | 10.894 | 33.45 | 23.52 |
| 42 | 146 | 37 | 23.683 | 24.199 | 6.805 | 23.37 | 17.91 |
| 51 | 69 | 37 | 37.117 | 40.154 | 9.769 | 34.36 | 16.86 |
| 87 | 252 | 37 | 35.567 | 38.168 | 17.039 | 48.09 | 27.75 |
| 196 | 102 | 37 | 10.783 | 11.674 | 2.562 | 10.95 | 13.56 |
| 261 | 251 | 37 | 27.033 | 29.927 | 14.566 | 41.35 | 31.05 |
| 255 | 77 | 37 | 27.517 | 29.086 | 6.239 | 23.28 | 13.19 |
| 70 | 74 | 37 | 14.333 | 17.923 | 6.503 | 21.15 | 24.15 |
| 233 | 172 | 37 | 41.1 | 44.682 | 19.929 | 56.35 | 28.1 |
| 49 | 211 | 37 | 20.583 | 21.94 | 4.031 | 18.54 | 11.68 |
| 244 | 208 | 37 | 22.217 | 24.285 | 8.326 | 26.74 | 22.8 |
| 65 | 29 | 37 | 31.5 | 34.715 | 13.281 | 40.54 | 25.5 |
| 88 | 130 | 37 | 45.483 | 49.449 | 16.322 | 50.04 | 21.48 |
| 43 | 28 | 37 | 32.983 | 37.72 | 13.217 | 40.78 | 23.45 |
| 76 | 123 | 37 | 25.283 | 29.227 | 10.692 | 32.47 | 23.42 |
| 159 | 212 | 37 | 17.4 | 18.926 | 4.195 | 17.07 | 13.67 |
| 49 | 7 | 37 | 26.55 | 27.827 | 7.834 | 26.58 | 18.33 |
| 69 | 236 | 37 | 27.167 | 28.689 | 4.942 | 20.67 | 11.07 |
| 49 | 39 | 37 | 30.417 | 29.631 | 5.695 | 22.68 | 11.87 |
| 70 | 186 | 37 | 34.367 | 36.065 | 10.436 | 34.78 | 18.65 |
| 17 | 87 | 37 | 21.8 | 23.579 | 4.706 | 18.4 | 13.24 |
| 225 | 74 | 37 | 37.833 | 41.916 | 13.717 | 42.87 | 21.44 |
| 100 | 222 | 37 | 58.25 | 60.336 | 18.273 | 58.78 | 19.93 |
| 247 | 164 | 37 | 33.167 | 34.047 | 8.742 | 30.57 | 16.85 |