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 |
|---|---|---|---|---|---|---|---|
| 50 | 22 | 133 | 36.567 | 38.16 | 13.782 | 42.08 | 22.22 |
| 163 | 20 | 133 | 35.35 | 37.676 | 12.32 | 39.14 | 20.67 |
| 140 | 131 | 133 | 37.583 | 41.511 | 14.747 | 44.33 | 23.28 |
| 129 | 230 | 133 | 30.9 | 34.519 | 8.035 | 29.65 | 14.98 |
| 230 | 29 | 133 | 48.083 | 50.369 | 19.243 | 57.56 | 24.35 |
| 56 | 107 | 133 | 20.483 | 23.541 | 8.203 | 44.77 | 23.69 |
| 170 | 147 | 133 | 21.817 | 24.497 | 7.871 | 25.65 | 20.65 |
| 196 | 164 | 133 | 21.467 | 24.12 | 7.733 | 47.35 | 22.24 |
| 161 | 29 | 133 | 48.933 | 52.706 | 19.435 | 57.92 | 23.46 |
| 140 | 10 | 133 | 34.9 | 40.676 | 15.647 | 46.08 | 25.37 |
| 146 | 148 | 133 | 20.9 | 22.002 | 5.908 | 20.74 | 16.88 |
| 37 | 76 | 133 | 22.717 | 23.868 | 4.078 | 17.9 | 10.65 |
| 140 | 93 | 133 | 29.283 | 31.935 | 11.711 | 36.01 | 24.24 |
| 213 | 242 | 133 | 15.15 | 16.482 | 3.688 | 14.99 | 14.17 |
| 62 | 89 | 133 | 13.983 | 14.782 | 2.477 | 11.9 | 10.99 |
| 188 | 137 | 133 | 38.7 | 39.042 | 9.291 | 31.95 | 15.09 |
| 13 | 127 | 132 | 31.35 | 33.982 | 13.127 | 39.41 | 24.47 |
| 42 | 225 | 132 | 46.717 | 47.676 | 13.592 | 43.71 | 18.22 |
| 186 | 252 | 132 | 36.808 | 40.508 | 14.419 | 44.54 | 23.21 |
| 140 | 67 | 132 | 35.667 | 36.958 | 14.273 | 42.45 | 24.67 |
| 163 | 213 | 132 | 33.983 | 38.582 | 10.298 | 34.08 | 18.32 |
| 52 | 141 | 132 | 27.942 | 29.288 | 8.455 | 27.92 | 18.64 |
| 75 | 89 | 132 | 48.1 | 49.725 | 15.363 | 48.47 | 20.35 |
| 41 | 182 | 132 | 25.133 | 27.954 | 7.671 | 26.13 | 18.21 |
| 164 | 235 | 132 | 28.142 | 31.948 | 10.426 | 33.05 | 21.65 |