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 |
|---|---|---|---|---|---|---|---|
| 65 | 48 | 611 | 27.717 | 29.333 | 6.411 | 24.67 | 14.27 |
| 66 | 148 | 611 | 13.033 | 13.514 | 2.938 | 12.97 | 14.66 |
| 168 | 75 | 610 | 9.508 | 11.772 | 2.289 | 10.48 | 13.69 |
| 74 | 4 | 610 | 18.875 | 20.827 | 6.709 | 21.73 | 21.74 |
| 28 | 28 | 610 | 7.408 | 10.499 | 2.402 | 11.91 | 20.23 |
| 226 | 95 | 610 | 19.1 | 20.4 | 5.168 | 19.16 | 16.38 |
| 75 | 235 | 610 | 16.833 | 19.987 | 5.801 | 19.95 | 20.37 |
| 142 | 14 | 609 | 37.683 | 40.104 | 13.681 | 42.32 | 21.28 |
| 50 | 223 | 609 | 28.783 | 30.46 | 6.962 | 25.88 | 14.42 |
| 52 | 195 | 609 | 7.117 | 7.475 | 1.524 | 7.37 | 12.87 |
| 162 | 106 | 607 | 30.583 | 32.279 | 8.58 | 29.32 | 16.85 |
| 170 | 198 | 607 | 24.85 | 27.052 | 7.117 | 24.68 | 16.89 |
| 114 | 257 | 607 | 23.583 | 25.007 | 7.338 | 24.61 | 18.69 |
| 152 | 43 | 607 | 14.633 | 15.422 | 2.803 | 12.85 | 11.16 |
| 137 | 202 | 607 | 19.467 | 20.361 | 4.775 | 17.64 | 14.77 |
| 100 | 40 | 607 | 29.583 | 31.238 | 7.425 | 26.52 | 15.1 |
| 211 | 42 | 606 | 30.383 | 31.79 | 9.308 | 30.92 | 18.59 |
| 186 | 92 | 606 | 37.033 | 39.681 | 12.219 | 39.67 | 20.22 |
| 260 | 173 | 606 | 13.367 | 14.558 | 2.701 | 12.22 | 11.66 |
| 138 | 139 | 606 | 32.092 | 35.387 | 14.714 | 42.75 | 27.49 |
| 142 | 189 | 606 | 40.125 | 41.542 | 9.622 | 34.47 | 14.45 |
| 166 | 114 | 605 | 31.917 | 33.498 | 7.404 | 27.88 | 13.83 |
| 255 | 66 | 605 | 15.85 | 16.802 | 3.787 | 14.8 | 15.41 |
| 114 | 152 | 605 | 25.433 | 27.553 | 8.25 | 27.67 | 18.85 |
| 132 | 57 | 605 | 25.517 | 27.297 | 10.99 | 32.58 | 26.3 |