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 |
|---|---|---|---|---|---|---|---|
| 145 | 208 | 24 | 43.15 | 41.05 | 12.927 | 40.55 | 22.34 |
| 33 | 56 | 24 | 23.95 | 28.601 | 8.912 | 28.8 | 21.14 |
| 205 | 72 | 24 | 31.408 | 33.649 | 12.027 | 34.37 | 22.53 |
| 13 | 130 | 24 | 50.742 | 47.722 | 18.837 | 53.71 | 24.86 |
| 216 | 117 | 24 | 31.2 | 31.379 | 9.989 | 32.6 | 19.64 |
| 232 | 34 | 24 | 15.875 | 16.517 | 3.607 | 14.75 | 14.14 |
| 129 | 71 | 24 | 46.917 | 49.184 | 14.015 | 45.8 | 17.8 |
| 143 | 91 | 24 | 65.475 | 67.807 | 15.597 | 54.67 | 14.29 |
| 177 | 197 | 24 | 23.358 | 23.815 | 6.035 | 21.23 | 15.54 |
| 175 | 98 | 24 | 4.65 | 7.955 | 1.787 | 7.9 | 22.82 |
| 13 | 3 | 24 | 38.475 | 41.472 | 18.892 | 53.27 | 28.54 |
| 106 | 113 | 24 | 26.983 | 28.151 | 5.427 | 22.44 | 12.1 |
| 174 | 200 | 24 | 11.067 | 11.435 | 3.952 | 13.75 | 22.23 |
| 223 | 192 | 24 | 13.65 | 14.783 | 7.089 | 21.49 | 30.97 |
| 220 | 47 | 24 | 19.258 | 21.053 | 3.822 | 16.87 | 11.55 |
| 114 | 101 | 24 | 44.483 | 49.035 | 19.392 | 54.9 | 25.2 |
| 54 | 106 | 24 | 8.9 | 9.697 | 1.597 | 8.42 | 10.37 |
| 47 | 166 | 24 | 32.817 | 34.301 | 5.432 | 24.51 | 9.93 |
| 17 | 166 | 24 | 59.425 | 56.017 | 13.756 | 47.54 | 15.65 |
| 170 | 46 | 24 | 36.317 | 36.797 | 16.55 | 46.98 | 28.05 |
| 155 | 108 | 24 | 22.217 | 24.206 | 7.052 | 23.09 | 18.55 |
| 141 | 73 | 24 | 29.083 | 32.065 | 12.258 | 36.94 | 23.97 |
| 38 | 61 | 24 | 42.3 | 45.409 | 14.419 | 45.72 | 19.86 |
| 117 | 35 | 24 | 41.025 | 43.87 | 12.717 | 40.97 | 18.05 |
| 4 | 160 | 24 | 24.067 | 26.235 | 8.855 | 28.27 | 21.62 |