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 |
|---|---|---|---|---|---|---|---|
| 152 | 261 | 31 | 33.883 | 36.261 | 9.489 | 33.32 | 17.01 |
| 76 | 26 | 31 | 39.117 | 41.872 | 10.412 | 33.35 | 15.96 |
| 70 | 168 | 31 | 13.5 | 16.39 | 6.825 | 21.08 | 26.56 |
| 129 | 87 | 31 | 37.85 | 38.39 | 12.123 | 38.94 | 21.32 |
| 107 | 38 | 31 | 52.667 | 59.617 | 19.642 | 58.35 | 22.06 |
| 155 | 124 | 31 | 21.283 | 23.345 | 8.927 | 28.25 | 24.51 |
| 61 | 47 | 31 | 49.15 | 50.435 | 19.361 | 57 | 24.1 |
| 236 | 124 | 31 | 49.417 | 53.857 | 17.914 | 54.05 | 21.41 |
| 262 | 197 | 31 | 35.917 | 37.079 | 15.211 | 46.87 | 27.57 |
| 53 | 95 | 31 | 14.95 | 15.83 | 5.134 | 17.56 | 20.47 |
| 243 | 107 | 31 | 34.783 | 35.117 | 10.42 | 34.26 | 19.17 |
| 14 | 106 | 31 | 17.883 | 18.873 | 4.557 | 18.29 | 15.53 |
| 129 | 181 | 31 | 36.167 | 39.477 | 10.473 | 36.14 | 18.48 |
| 243 | 261 | 31 | 42.667 | 44.974 | 12.228 | 39.25 | 17.59 |
| 93 | 196 | 31 | 15.917 | 18.901 | 4.674 | 18.82 | 15.52 |
| 254 | 182 | 31 | 17.617 | 18.402 | 5.423 | 19.15 | 18.77 |
| 74 | 10 | 31 | 37.467 | 37.472 | 15.296 | 45.17 | 26.35 |
| 217 | 181 | 31 | 20.7 | 22.394 | 4.787 | 18.74 | 14.21 |
| 129 | 33 | 31 | 37.15 | 36.744 | 9.035 | 30.52 | 16.79 |
| 229 | 77 | 31 | 50.567 | 52.034 | 14.056 | 46.14 | 17.7 |
| 188 | 14 | 31 | 26.3 | 30.329 | 7.917 | 27.64 | 16.4 |
| 48 | 6 | 31 | 39.283 | 42.859 | 16.834 | 50.05 | 24.43 |
| 48 | 214 | 31 | 42.6 | 47.038 | 17.39 | 51.63 | 23.13 |
| 56 | 70 | 31 | 12.183 | 11.473 | 2.31 | 10.58 | 12.71 |
| 121 | 197 | 31 | 19.483 | 20.854 | 3.556 | 16.47 | 11.18 |