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 |
|---|---|---|---|---|---|---|---|
| 93 | 161 | 719 | 28.283 | 30.16 | 10.085 | 50.99 | 22.28 |
| 261 | 7 | 719 | 29.683 | 30.99 | 10.198 | 32.45 | 20.79 |
| 61 | 17 | 718 | 8.133 | 9.249 | 1.501 | 8.24 | 10.78 |
| 217 | 217 | 718 | 3.933 | 5.941 | 0.808 | 6.23 | 13.61 |
| 236 | 66 | 718 | 28.642 | 30.533 | 8.76 | 29.03 | 18.5 |
| 68 | 106 | 717 | 27.983 | 29.919 | 6.938 | 25.49 | 14.69 |
| 33 | 137 | 717 | 19.917 | 20.624 | 5.696 | 19.89 | 17.68 |
| 141 | 69 | 717 | 18.3 | 20.085 | 5.638 | 19.53 | 18.42 |
| 79 | 133 | 717 | 24.617 | 26.36 | 9.092 | 28.79 | 22.1 |
| 7 | 137 | 716 | 20.767 | 22.652 | 4.687 | 18.45 | 13.83 |
| 4 | 261 | 716 | 12.8 | 13.818 | 3.641 | 14.1 | 17.38 |
| 231 | 133 | 716 | 22.192 | 24.201 | 6.916 | 23.42 | 19.1 |
| 145 | 100 | 716 | 17.942 | 19.763 | 3.003 | 45.46 | 10.36 |
| 65 | 164 | 716 | 22.592 | 24.062 | 5.502 | 21.08 | 14.73 |
| 138 | 194 | 716 | 21.625 | 25.277 | 7.772 | 26.83 | 22.05 |
| 12 | 163 | 716 | 31.192 | 32.19 | 6.415 | 25.71 | 12.73 |
| 249 | 62 | 716 | 26.817 | 28.474 | 6.387 | 23.73 | 14.13 |
| 48 | 198 | 715 | 32.383 | 34.462 | 8.359 | 29.5 | 15.27 |
| 68 | 220 | 713 | 26.5 | 29.138 | 11.557 | 35.07 | 25.54 |
| 255 | 97 | 712 | 14.25 | 15.077 | 3.119 | 13.06 | 13.34 |
| 226 | 263 | 711 | 17.033 | 18.63 | 4.161 | 17 | 14.59 |
| 12 | 246 | 710 | 17.975 | 19.726 | 3.884 | 16.58 | 12.74 |
| 189 | 189 | 710 | 4.217 | 5.884 | 0.922 | 6.57 | 20.81 |
| 230 | 157 | 710 | 25.3 | 27.695 | 7.078 | 25.71 | 16.27 |
| 263 | 127 | 710 | 17.267 | 19.538 | 7.195 | 23.13 | 24.37 |