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 |
|---|---|---|---|---|---|---|---|
| 49 | 249 | 62 | 21.842 | 25.61 | 5.085 | 21.46 | 12.88 |
| 29 | 123 | 62 | 9.95 | 10.244 | 1.623 | 8.92 | 10.93 |
| 186 | 175 | 61 | 39.117 | 43.385 | 15.292 | 46.89 | 23.7 |
| 143 | 225 | 61 | 46.017 | 46.693 | 9.798 | 36.46 | 13.25 |
| 75 | 31 | 61 | 25.717 | 26.278 | 8.646 | 27.75 | 21.39 |
| 41 | 225 | 61 | 44.15 | 45.311 | 13.496 | 43.3 | 18.47 |
| 247 | 18 | 61 | 17.117 | 18.069 | 3.571 | 15.02 | 12.57 |
| 233 | 258 | 61 | 34.417 | 35.983 | 10.477 | 34.56 | 18.74 |
| 137 | 10 | 61 | 37.333 | 42.39 | 14.608 | 45.35 | 23.07 |
| 135 | 98 | 61 | 13.45 | 16.244 | 3.802 | 15.07 | 14.55 |
| 70 | 166 | 61 | 24.783 | 26.72 | 8.607 | 28.34 | 19.96 |
| 68 | 219 | 61 | 47.283 | 51.699 | 18.113 | 56.39 | 23.26 |
| 37 | 107 | 61 | 27.1 | 31.36 | 5.859 | 23.57 | 12.17 |
| 146 | 159 | 61 | 22.083 | 23.585 | 7.071 | 24.03 | 18.95 |
| 60 | 60 | 61 | 3.6 | 6.973 | 0.976 | 6.83 | 20.79 |
| 12 | 189 | 61 | 24.3 | 24.88 | 5.115 | 19.89 | 12.67 |
| 161 | 120 | 61 | 24.6 | 27.542 | 8.145 | 27.36 | 19.6 |
| 125 | 67 | 61 | 27.733 | 30.037 | 9.53 | 30.74 | 20.21 |
| 151 | 37 | 61 | 40.367 | 43.676 | 11.73 | 39.45 | 17.08 |
| 229 | 191 | 61 | 36.35 | 37.512 | 15.485 | 45.34 | 25.72 |
| 42 | 3 | 61 | 30.5 | 30.981 | 9.49 | 30.94 | 20.07 |
| 238 | 258 | 61 | 56.883 | 58.009 | 14.784 | 49.29 | 20.05 |
| 130 | 211 | 61 | 38.733 | 39.701 | 14.577 | 52.26 | 23.72 |
| 208 | 213 | 61 | 8.133 | 8.309 | 2.487 | 9.99 | 24.82 |
| 211 | 70 | 61 | 33.65 | 35.17 | 10.969 | 35.8 | 20.93 |