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 |
|---|---|---|---|---|---|---|---|
| 63 | 77 | 42 | 13.817 | 14.521 | 2.482 | 12.01 | 10.81 |
| 209 | 35 | 42 | 39.833 | 42.667 | 7.585 | 30.67 | 11.49 |
| 197 | 230 | 42 | 37.858 | 41.08 | 13.616 | 50.96 | 21.68 |
| 219 | 75 | 42 | 43.65 | 44.611 | 17.246 | 53.07 | 25.25 |
| 142 | 178 | 42 | 49.392 | 49.28 | 13.84 | 44.51 | 17.23 |
| 260 | 121 | 42 | 20.433 | 22.427 | 8.047 | 25.5 | 23.77 |
| 148 | 192 | 42 | 26.217 | 28.388 | 11.797 | 35.58 | 26.88 |
| 127 | 68 | 42 | 25.475 | 27.538 | 10.25 | 31.64 | 23.61 |
| 4 | 193 | 42 | 21.367 | 23.051 | 5.569 | 20.5 | 15.8 |
| 36 | 68 | 42 | 28.8 | 30.27 | 7.534 | 26.99 | 15.45 |
| 28 | 4 | 42 | 29.517 | 31.497 | 13.355 | 51.18 | 27.71 |
| 165 | 71 | 42 | 14.467 | 17.646 | 2.66 | 13.51 | 9.87 |
| 77 | 181 | 42 | 32.633 | 33.399 | 5.859 | 24.05 | 11.03 |
| 125 | 193 | 42 | 30.35 | 32.987 | 6.902 | 26.45 | 14.12 |
| 140 | 183 | 42 | 28.108 | 32.024 | 10.907 | 34.33 | 23.27 |
| 20 | 42 | 42 | 19.35 | 21.246 | 5.141 | 19.12 | 15.66 |
| 25 | 77 | 42 | 32.2 | 33.066 | 6.15 | 25.03 | 11.81 |
| 45 | 235 | 42 | 37.292 | 38.193 | 13.704 | 41.47 | 23.3 |
| 229 | 85 | 42 | 43.4 | 45.951 | 12.238 | 41.18 | 17.17 |
| 246 | 28 | 42 | 38.125 | 40.449 | 14.146 | 44.27 | 22.22 |
| 114 | 248 | 42 | 33.075 | 36.205 | 12.601 | 38.83 | 23.02 |
| 215 | 209 | 42 | 39.5 | 40.878 | 16.493 | 52.29 | 26.91 |
| 228 | 62 | 42 | 27.125 | 27.187 | 4.906 | 20.83 | 11.71 |
| 160 | 157 | 42 | 7.492 | 9.649 | 1.512 | 8.54 | 11.4 |
| 13 | 192 | 42 | 33.383 | 34.467 | 14.445 | 42.38 | 25.43 |