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 |
|---|---|---|---|---|---|---|---|
| 182 | 10 | 2 | 45.842 | 45.842 | 13.31 | 43.5 | 17.42 |
| 247 | 40 | 2 | 55.842 | 55.842 | 14.865 | 47.5 | 15.99 |
| 91 | 69 | 2 | 56.658 | 56.658 | 22.665 | 63.55 | 24.01 |
| 66 | 208 | 2 | 31.375 | 31.375 | 17.73 | 48.5 | 33.92 |
| 126 | 36 | 2 | 37.95 | 37.95 | 13.115 | 40.5 | 20.66 |
| 228 | 118 | 2 | 34.4 | 34.4 | 16.38 | 47.75 | 28.47 |
| 55 | 50 | 2 | 41.642 | 41.642 | 9.5 | 34.5 | 11.64 |
| 169 | 129 | 2 | 33.2 | 33.2 | 11.435 | 35.75 | 20.62 |
| 5 | 70 | 2 | 93.558 | 93.558 | 33.53 | 97.5 | 21.53 |
| 38 | 246 | 2 | 71.658 | 71.658 | 19.865 | 64.25 | 17.07 |
| 173 | 232 | 2 | 13.733 | 13.733 | 5.08 | 16 | 19.78 |
| 223 | 128 | 2 | 16.842 | 16.842 | 9.115 | 52 | 32.63 |
| 92 | 112 | 2 | 28.633 | 28.633 | 9.345 | 30.5 | 21.11 |
| 43 | 156 | 2 | 48.283 | 48.283 | 23.795 | 67 | 29.87 |
| 242 | 139 | 2 | 83.892 | 83.892 | 20.88 | 72.8 | 17.12 |
| 56 | 174 | 2 | 49.033 | 49.033 | 14.74 | 43.68 | 18.04 |
| 59 | 162 | 2 | 27.725 | 27.725 | 10.875 | 31.75 | 24.89 |
| 55 | 243 | 2 | 94.917 | 94.917 | 24.585 | 80.5 | 15.64 |
| 191 | 43 | 2 | 54.417 | 54.417 | 20.24 | 59.5 | 23.4 |
| 38 | 88 | 2 | 65.342 | 65.342 | 24.305 | 71.5 | 24.52 |
| 127 | 139 | 2 | 53.033 | 53.033 | 22.53 | 57.87 | 28.37 |
| 102 | 7 | 2 | 29.625 | 29.625 | 6.05 | 22.75 | 12.27 |
| 102 | 39 | 2 | 32.625 | 32.625 | 8.25 | 28.5 | 14.85 |
| 83 | 177 | 2 | 22.517 | 22.517 | 7.66 | 23.24 | 20.49 |
| 95 | 208 | 2 | 37.325 | 37.325 | 15.23 | 44.25 | 24.72 |