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 |
|---|---|---|---|---|---|---|---|
| 90 | 145 | 1857 | 20.8 | 22.383 | 4.438 | 18.21 | 12.72 |
| 143 | 114 | 1857 | 24.583 | 25.727 | 4.394 | 19.22 | 10.87 |
| 48 | 80 | 1856 | 30.033 | 31.934 | 6.983 | 26.4 | 13.93 |
| 100 | 112 | 1854 | 23.975 | 25.511 | 5.188 | 20.66 | 12.89 |
| 166 | 229 | 1854 | 26.192 | 27.286 | 4.893 | 20.8 | 11.43 |
| 24 | 246 | 1854 | 16.942 | 18.095 | 4.764 | 17.55 | 17.03 |
| 186 | 179 | 1852 | 27.867 | 29.094 | 5.893 | 23.29 | 13.05 |
| 232 | 113 | 1850 | 12.35 | 12.971 | 1.782 | 10.64 | 8.68 |
| 249 | 223 | 1850 | 31.783 | 32.632 | 8.625 | 29.56 | 16.83 |
| 97 | 61 | 1847 | 13.467 | 14.478 | 2.585 | 11.88 | 11.3 |
| 41 | 132 | 1843 | 41.567 | 44.529 | 18.018 | 52.01 | 27.23 |
| 25 | 49 | 1843 | 10.1 | 10.872 | 1.711 | 9.14 | 10.12 |
| 113 | 7 | 1841 | 27.333 | 28.407 | 6.48 | 23.87 | 14.64 |
| 224 | 100 | 1840 | 16.45 | 17.712 | 2.249 | 12.86 | 8.47 |
| 33 | 65 | 1839 | 6.567 | 7.273 | 0.877 | 6.64 | 7.43 |
| 170 | 97 | 1838 | 26.392 | 27.81 | 6.457 | 23.89 | 14.81 |
| 234 | 17 | 1838 | 30.15 | 31.403 | 5.924 | 24.23 | 11.97 |
| 236 | 168 | 1837 | 12.833 | 14.61 | 3.545 | 13.8 | 16.23 |
| 48 | 25 | 1836 | 30.892 | 32.356 | 7.443 | 27.12 | 14.61 |
| 148 | 198 | 1834 | 20.867 | 22.118 | 6.008 | 21.1 | 17.1 |
| 262 | 224 | 1834 | 12.117 | 12.912 | 3.841 | 13.9 | 19.45 |
| 140 | 112 | 1833 | 19.883 | 21.175 | 4.576 | 18.04 | 13.55 |
| 161 | 260 | 1831 | 21.9 | 23.282 | 5.136 | 19.9 | 13.91 |
| 43 | 125 | 1830 | 28.758 | 29.689 | 4.952 | 21.76 | 10.57 |
| 113 | 244 | 1829 | 27.6 | 30.273 | 9.715 | 31.6 | 20.65 |