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 |
|---|---|---|---|---|---|---|---|
| 137 | 260 | 944 | 21.05 | 22.724 | 5.629 | 20.57 | 16.19 |
| 232 | 158 | 944 | 15.933 | 16.795 | 2.65 | 14.26 | 9.83 |
| 138 | 241 | 944 | 26.6 | 29.984 | 11.972 | 35.83 | 26.6 |
| 231 | 195 | 943 | 16.767 | 18.231 | 4.37 | 16.39 | 15.62 |
| 33 | 87 | 942 | 12.583 | 13.293 | 2.636 | 11.98 | 12.6 |
| 179 | 129 | 941 | 12.317 | 13.035 | 2.862 | 12.22 | 14.65 |
| 142 | 200 | 941 | 22.117 | 25.145 | 10.586 | 31.55 | 27.39 |
| 87 | 151 | 941 | 28.217 | 29.996 | 8.465 | 28.65 | 18.11 |
| 137 | 66 | 939 | 17.733 | 18.745 | 5.09 | 18.08 | 17.61 |
| 137 | 146 | 939 | 15.733 | 17.107 | 3.819 | 15.01 | 14.65 |
| 140 | 193 | 939 | 14.7 | 15.873 | 3.137 | 13.49 | 12.77 |
| 41 | 247 | 939 | 14.067 | 15.381 | 2.722 | 12.63 | 11.43 |
| 226 | 107 | 938 | 18.592 | 19.87 | 4.556 | 27.26 | 15.59 |
| 256 | 36 | 938 | 13.883 | 14.64 | 2.702 | 11.95 | 11.57 |
| 90 | 127 | 938 | 26.767 | 29.598 | 10.836 | 33.65 | 23.62 |
| 261 | 75 | 936 | 26.108 | 28.655 | 8.69 | 28.54 | 20.25 |
| 161 | 37 | 935 | 32.867 | 34.793 | 7.812 | 28.82 | 14.21 |
| 40 | 231 | 935 | 14.817 | 16.083 | 3.6 | 14.57 | 14.88 |
| 209 | 50 | 934 | 23.4 | 24.702 | 5.167 | 20.66 | 13.4 |
| 79 | 82 | 931 | 24.433 | 26.266 | 8.125 | 27.06 | 20.16 |
| 66 | 66 | 930 | 4.333 | 7.82 | 1.296 | 8.6 | 21.21 |
| 249 | 127 | 927 | 27.367 | 29.846 | 11.489 | 35.1 | 24.5 |
| 90 | 225 | 925 | 34.367 | 36.321 | 6.968 | 27.6 | 12.3 |
| 132 | 159 | 925 | 40.467 | 42.885 | 19.321 | 54.63 | 29.32 |
| 168 | 42 | 925 | 8.85 | 10.177 | 1.565 | 9.25 | 10.18 |