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 |
|---|---|---|---|---|---|---|---|
| 14 | 210 | 90 | 19.442 | 20.918 | 7.698 | 25.38 | 23.23 |
| 189 | 234 | 90 | 28.417 | 30.399 | 5.608 | 23.42 | 11.87 |
| 255 | 41 | 90 | 30.492 | 31.627 | 10.034 | 32.17 | 19.66 |
| 52 | 225 | 90 | 22.842 | 24.829 | 4.29 | 18.43 | 11.01 |
| 213 | 212 | 90 | 9.125 | 9.592 | 1.675 | 8.92 | 11.88 |
| 190 | 49 | 90 | 10.042 | 10.46 | 1.798 | 9.09 | 10.53 |
| 162 | 29 | 90 | 47.767 | 49.838 | 19.369 | 57.21 | 24.58 |
| 171 | 171 | 90 | 5.85 | 11.8 | 1.587 | 10.96 | 8.96 |
| 65 | 260 | 90 | 15.7 | 18.485 | 7.289 | 22.69 | 26.76 |
| 261 | 247 | 89 | 33.417 | 36.164 | 12.268 | 38.13 | 22.28 |
| 107 | 126 | 89 | 25.85 | 30.665 | 9.627 | 31.44 | 21.6 |
| 167 | 74 | 89 | 18.1 | 20.507 | 3.251 | 15.83 | 10.48 |
| 98 | 98 | 89 | 3.3 | 5.855 | 1.519 | 9.66 | 56.5 |
| 189 | 144 | 89 | 16.017 | 17.638 | 3.489 | 15.53 | 12.69 |
| 243 | 247 | 89 | 12.967 | 13.62 | 2.516 | 11.7 | 11.68 |
| 107 | 171 | 89 | 35.917 | 38.087 | 13.932 | 41.78 | 23.48 |
| 149 | 210 | 89 | 8.417 | 10.337 | 1.678 | 9.83 | 9.59 |
| 261 | 200 | 89 | 36.283 | 39.534 | 15.157 | 45.53 | 24.16 |
| 142 | 94 | 89 | 29.667 | 31.34 | 9.763 | 31.64 | 19.96 |
| 50 | 51 | 89 | 31.8 | 33.916 | 16.939 | 47.6 | 32.7 |
| 152 | 233 | 89 | 30.317 | 31.636 | 6.851 | 26.01 | 13.9 |
| 4 | 194 | 89 | 17.083 | 18.795 | 8.12 | 24.45 | 27.69 |
| 232 | 146 | 89 | 23.717 | 24.6 | 6.527 | 23.06 | 17 |
| 144 | 247 | 89 | 29.983 | 32.793 | 10.804 | 34.08 | 21.36 |
| 215 | 113 | 89 | 37.633 | 38.352 | 13.85 | 50.6 | 23.1 |