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 |
|---|---|---|---|---|---|---|---|
| 48 | 62 | 561 | 39.633 | 41.147 | 9.479 | 34 | 14.48 |
| 132 | 47 | 561 | 44.733 | 47.341 | 20.792 | 59.07 | 29.04 |
| 231 | 127 | 561 | 30.783 | 33.717 | 12.657 | 38.64 | 24.03 |
| 231 | 198 | 561 | 29.05 | 30.37 | 7.655 | 27.03 | 16 |
| 161 | 69 | 560 | 23.65 | 25.507 | 7.118 | 24.06 | 17.86 |
| 45 | 17 | 560 | 19.567 | 20.946 | 4.364 | 17.53 | 13.36 |
| 263 | 95 | 560 | 30.9 | 32.847 | 10.836 | 34.36 | 21.47 |
| 146 | 48 | 559 | 18.45 | 21.657 | 3.706 | 17.47 | 11.63 |
| 80 | 17 | 559 | 10.567 | 11.087 | 2.083 | 9.77 | 11.65 |
| 140 | 61 | 559 | 38.95 | 39.912 | 10.539 | 35.63 | 17.15 |
| 7 | 70 | 559 | 11.783 | 12.653 | 3.555 | 13.38 | 18.32 |
| 226 | 68 | 559 | 23.717 | 25.856 | 5.022 | 35.35 | 13.03 |
| 4 | 50 | 559 | 22.233 | 23.653 | 4.223 | 18.23 | 11.4 |
| 151 | 88 | 558 | 31.275 | 31.909 | 8.78 | 30.03 | 17.76 |
| 61 | 188 | 558 | 10.058 | 11.478 | 1.85 | 9.67 | 10.66 |
| 52 | 234 | 558 | 26.375 | 27.096 | 5.517 | 21.88 | 12.89 |
| 37 | 225 | 558 | 7.133 | 8.333 | 1.369 | 7.66 | 10.52 |
| 42 | 132 | 557 | 39 | 41.669 | 18.151 | 52.04 | 29.14 |
| 138 | 250 | 557 | 21.95 | 24.74 | 9.864 | 29.85 | 26.11 |
| 33 | 211 | 557 | 15.75 | 16.644 | 3.054 | 13.95 | 11.7 |
| 244 | 69 | 557 | 14.617 | 15.912 | 2.54 | 12.63 | 10.26 |
| 97 | 52 | 557 | 10.483 | 11.131 | 1.637 | 9.13 | 9.43 |
| 138 | 78 | 556 | 25.133 | 27.988 | 9.94 | 31.28 | 23.29 |
| 260 | 157 | 556 | 8.475 | 9.37 | 1.813 | 8.75 | 12.13 |
| 239 | 260 | 556 | 27.025 | 29.163 | 6.451 | 24.36 | 13.91 |