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 |
|---|---|---|---|---|---|---|---|
| 36 | 140 | 19 | 29.1 | 35.498 | 7.897 | 29.73 | 15.2 |
| 193 | 8 | 19 | 11.2 | 12.678 | 2.205 | 10.53 | 10.92 |
| 150 | 165 | 19 | 18.083 | 21.733 | 4.148 | 18.06 | 11.34 |
| 148 | 6 | 19 | 26.733 | 29.701 | 14.237 | 40.5 | 29.9 |
| 18 | 159 | 19 | 21.483 | 22.396 | 4.813 | 18.8 | 13.2 |
| 51 | 182 | 19 | 19.067 | 18.99 | 5.642 | 19.69 | 18.71 |
| 224 | 174 | 19 | 27.917 | 29.584 | 13.735 | 39.37 | 28.88 |
| 191 | 41 | 19 | 42.233 | 46.667 | 21.275 | 60.23 | 28.16 |
| 72 | 136 | 19 | 59.567 | 61.218 | 23.98 | 69.75 | 23.88 |
| 133 | 48 | 19 | 38.417 | 40.256 | 10.843 | 37.13 | 17.28 |
| 54 | 49 | 19 | 15.833 | 17.338 | 3.292 | 14.32 | 12.08 |
| 113 | 108 | 19 | 37.75 | 38.552 | 14.611 | 43.79 | 23.41 |
| 119 | 237 | 19 | 34.217 | 32.981 | 6.307 | 24.16 | 12.42 |
| 241 | 128 | 19 | 9.217 | 9.243 | 1.355 | 10.53 | 9.64 |
| 76 | 79 | 19 | 52.317 | 54.419 | 13.342 | 44.7 | 15.92 |
| 120 | 42 | 19 | 6.15 | 6.694 | 1.989 | 8.5 | 21.78 |
| 216 | 65 | 19 | 59.65 | 57.181 | 13.881 | 49.86 | 15.47 |
| 98 | 229 | 19 | 52.25 | 50.735 | 14.104 | 44.18 | 17.12 |
| 69 | 81 | 19 | 25.75 | 27.396 | 8.963 | 29.51 | 21.2 |
| 118 | 23 | 19 | 13.15 | 17.156 | 3.325 | 14.89 | 12.41 |
| 61 | 78 | 19 | 62.117 | 66.347 | 19.384 | 61.01 | 18.96 |
| 202 | 41 | 19 | 33.4 | 32.22 | 7.192 | 26.32 | 14.3 |
| 238 | 123 | 19 | 56.35 | 55.978 | 17.079 | 53.76 | 18.89 |
| 195 | 74 | 19 | 39.367 | 42.822 | 13.789 | 42.53 | 20.46 |
| 216 | 86 | 19 | 26.767 | 29.38 | 9.988 | 32.95 | 21.3 |