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 |
|---|---|---|---|---|---|---|---|
| 223 | 236 | 582 | 17.15 | 18.981 | 6.031 | 41.08 | 21.2 |
| 170 | 106 | 582 | 28.992 | 30.348 | 8.069 | 27.77 | 16.81 |
| 141 | 173 | 581 | 26.917 | 27.973 | 6.968 | 25.02 | 15.8 |
| 161 | 196 | 581 | 27.8 | 30.074 | 8.379 | 28.96 | 18.17 |
| 33 | 236 | 581 | 28.533 | 29.625 | 9.197 | 29.57 | 19.83 |
| 170 | 157 | 580 | 17.167 | 20.142 | 5.969 | 21.66 | 19.97 |
| 181 | 195 | 580 | 11.05 | 12.104 | 2.15 | 10.27 | 11.13 |
| 226 | 173 | 580 | 19.175 | 20.261 | 3.95 | 16.55 | 12.26 |
| 239 | 25 | 579 | 33.45 | 35.299 | 9.754 | 32.71 | 17.5 |
| 49 | 225 | 579 | 11.217 | 11.887 | 2.114 | 10.07 | 11.09 |
| 148 | 83 | 579 | 14.85 | 17.319 | 6.799 | 21.59 | 26.41 |
| 116 | 186 | 579 | 24.8 | 26.301 | 7.073 | 25.05 | 17.31 |
| 33 | 164 | 579 | 24.767 | 26.082 | 6.081 | 22.75 | 14.84 |
| 68 | 198 | 578 | 32.367 | 34.785 | 8.47 | 29.93 | 15.44 |
| 100 | 198 | 578 | 32.875 | 35.201 | 7.943 | 29.06 | 14.54 |
| 12 | 233 | 577 | 17.383 | 18.755 | 5.495 | 19.18 | 19.3 |
| 238 | 129 | 577 | 32.267 | 32.917 | 8.278 | 29.14 | 15.92 |
| 13 | 41 | 577 | 29.783 | 31.718 | 8.948 | 30.31 | 17.8 |
| 13 | 80 | 577 | 23.633 | 25.148 | 6.779 | 23.73 | 17.14 |
| 48 | 173 | 577 | 32.9 | 35.321 | 8.631 | 30.83 | 15.73 |
| 107 | 106 | 577 | 27.167 | 28.023 | 6.467 | 23.96 | 14.41 |
| 246 | 129 | 576 | 32.558 | 34.814 | 8.478 | 30.22 | 15.52 |
| 224 | 50 | 576 | 21.867 | 23.264 | 3.589 | 17.09 | 10.12 |
| 40 | 162 | 575 | 28.533 | 30.192 | 8.334 | 28.14 | 17.93 |
| 209 | 43 | 575 | 25.883 | 27.326 | 6.872 | 24.67 | 16.48 |