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 |
|---|---|---|---|---|---|---|---|
| 100 | 38 | 32 | 49.1 | 56.41 | 20.876 | 62.49 | 24.66 |
| 9 | 161 | 32 | 58.933 | 58.453 | 14.475 | 45.11 | 15.65 |
| 226 | 180 | 32 | 38.125 | 37.218 | 9.258 | 36.08 | 16.74 |
| 39 | 150 | 32 | 17.367 | 18.805 | 7.429 | 23.2 | 24.73 |
| 41 | 215 | 32 | 37.608 | 42.499 | 16.838 | 50.05 | 24.35 |
| 114 | 47 | 32 | 33.875 | 40.706 | 13.632 | 42.67 | 21.94 |
| 168 | 232 | 32 | 29.442 | 31.434 | 9.329 | 29.57 | 19.9 |
| 231 | 153 | 32 | 38.183 | 41.174 | 14.04 | 43.82 | 22.51 |
| 100 | 221 | 32 | 43.517 | 42.906 | 17.231 | 50.89 | 25.48 |
| 243 | 88 | 32 | 48.383 | 47.253 | 12.099 | 40.43 | 17.16 |
| 43 | 22 | 32 | 50.05 | 52.027 | 17.007 | 52.29 | 20.09 |
| 36 | 35 | 32 | 21.25 | 22.498 | 3.562 | 16.31 | 9.93 |
| 205 | 65 | 32 | 65.7 | 64.975 | 17.579 | 55.61 | 17.62 |
| 175 | 131 | 32 | 8.333 | 9.871 | 2.272 | 10.08 | 13.65 |
| 43 | 248 | 32 | 30.1 | 31.06 | 8.205 | 28.14 | 17.08 |
| 161 | 86 | 32 | 59.367 | 64.521 | 21.945 | 67.73 | 22.82 |
| 148 | 98 | 32 | 27.975 | 30.134 | 13.73 | 39.51 | 30.27 |
| 143 | 177 | 32 | 46.108 | 47.394 | 13.248 | 43.58 | 17.5 |
| 11 | 26 | 32 | 16.425 | 16.455 | 2.801 | 13.25 | 10.39 |
| 122 | 191 | 32 | 6.425 | 7.36 | 1.459 | 7.34 | 12.44 |
| 248 | 116 | 32 | 21.658 | 23.999 | 6.139 | 23.8 | 16.79 |
| 152 | 94 | 32 | 21.092 | 22.916 | 5.768 | 20.89 | 16.38 |
| 226 | 63 | 32 | 29.292 | 33.824 | 10.747 | 34.88 | 20.92 |
| 181 | 56 | 32 | 24.392 | 28.563 | 10.774 | 34.42 | 24.32 |
| 13 | 159 | 32 | 26.192 | 27.938 | 12.072 | 35.36 | 27.46 |