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 |
|---|---|---|---|---|---|---|---|
| 41 | 94 | 80 | 23.25 | 25.705 | 6.064 | 22.63 | 15.99 |
| 42 | 209 | 80 | 32.367 | 36.06 | 10.596 | 34.35 | 19.62 |
| 181 | 77 | 80 | 26.658 | 28.658 | 5.459 | 22.12 | 12.25 |
| 87 | 259 | 80 | 49.333 | 54.787 | 19.295 | 57.47 | 24.69 |
| 134 | 170 | 80 | 25.633 | 29.362 | 11.593 | 48.99 | 26.69 |
| 261 | 123 | 80 | 30.85 | 32.009 | 10.115 | 32.6 | 19.83 |
| 261 | 1 | 80 | 35.75 | 37.422 | 14.653 | 79.65 | 25.92 |
| 42 | 94 | 80 | 21.725 | 23.421 | 5.047 | 19.84 | 14.22 |
| 42 | 61 | 80 | 50.733 | 52.48 | 15.534 | 49.56 | 19.18 |
| 136 | 244 | 80 | 19.667 | 21.508 | 3.955 | 17.25 | 12.6 |
| 226 | 52 | 80 | 26.725 | 28.194 | 7.556 | 25.68 | 17.02 |
| 163 | 16 | 80 | 37.642 | 39.846 | 16.081 | 47.81 | 25.57 |
| 56 | 196 | 80 | 7.583 | 10.316 | 1.598 | 11.68 | 11.59 |
| 74 | 181 | 80 | 33.4 | 34.549 | 12.35 | 37.77 | 23.16 |
| 87 | 175 | 80 | 50.033 | 53.183 | 17.463 | 52.31 | 22.08 |
| 100 | 108 | 80 | 45.833 | 48.059 | 17.63 | 53.1 | 23.23 |
| 7 | 207 | 80 | 7.908 | 12.032 | 2.286 | 10.54 | 11.87 |
| 143 | 70 | 80 | 33.133 | 34.653 | 11.137 | 36.01 | 21.03 |
| 190 | 33 | 80 | 18.642 | 19.911 | 3.101 | 15.19 | 9.97 |
| 72 | 25 | 80 | 33.35 | 33.682 | 5.163 | 22.88 | 9.96 |
| 230 | 73 | 80 | 38.067 | 38.682 | 12.849 | 40.46 | 21.41 |
| 166 | 95 | 80 | 32.45 | 34.77 | 12.114 | 37.83 | 22.33 |
| 76 | 216 | 80 | 16.975 | 19.492 | 5.788 | 21.13 | 19.41 |
| 238 | 51 | 80 | 33.808 | 36.136 | 14.742 | 42.91 | 26.7 |
| 61 | 112 | 80 | 21.092 | 21.506 | 4.731 | 18.02 | 13.85 |