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 |
|---|---|---|---|---|---|---|---|
| 129 | 15 | 21 | 17.967 | 18.835 | 7.686 | 23.8 | 26.5 |
| 152 | 32 | 21 | 25.467 | 26.621 | 9.744 | 29.9 | 23.05 |
| 195 | 125 | 21 | 16.583 | 16.041 | 4.25 | 28.43 | 16.42 |
| 50 | 118 | 21 | 44.8 | 48.458 | 20.02 | 58.45 | 26.01 |
| 82 | 16 | 21 | 18.767 | 21.072 | 9.049 | 27.42 | 27.45 |
| 207 | 162 | 21 | 20.95 | 22.98 | 6.626 | 28.95 | 18.8 |
| 48 | 59 | 21 | 28.233 | 32.579 | 11.046 | 34.83 | 22.77 |
| 250 | 183 | 21 | 9.617 | 10.233 | 2.272 | 10.14 | 14.04 |
| 127 | 234 | 21 | 31.617 | 34.277 | 11.171 | 36.19 | 21.1 |
| 143 | 1 | 21 | 34.183 | 40.388 | 18.185 | 70.31 | 29.57 |
| 232 | 174 | 21 | 30.917 | 38.924 | 15.699 | 45.17 | 28.32 |
| 130 | 223 | 21 | 24.967 | 26.639 | 10.417 | 32.15 | 26.01 |
| 95 | 63 | 21 | 21.117 | 25.27 | 6.365 | 22.36 | 16.09 |
| 93 | 9 | 21 | 13.033 | 14.104 | 4.32 | 15.07 | 19.19 |
| 195 | 88 | 21 | 14.75 | 14.385 | 3.7 | 26.67 | 17.38 |
| 52 | 7 | 21 | 28.75 | 28.793 | 10.072 | 31.48 | 21.52 |
| 41 | 12 | 21 | 34.667 | 34.184 | 9.563 | 32.29 | 17.56 |
| 154 | 13 | 21 | 29.35 | 32.841 | 16.248 | 51.38 | 32.16 |
| 3 | 146 | 21 | 36.283 | 40.393 | 13.395 | 42.39 | 21.06 |
| 131 | 216 | 21 | 18.283 | 21.272 | 6.031 | 20.35 | 19.25 |
| 134 | 7 | 21 | 23.2 | 24.881 | 9.035 | 28.36 | 22.89 |
| 146 | 171 | 21 | 26.233 | 27.505 | 8.863 | 28.9 | 20.08 |
| 36 | 246 | 21 | 30.617 | 32.051 | 7.684 | 27.64 | 14.76 |
| 82 | 250 | 21 | 48.517 | 50.01 | 9.927 | 41.26 | 13.92 |
| 14 | 48 | 21 | 47.2 | 47.038 | 11.116 | 40.44 | 15.07 |