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 |
|---|---|---|---|---|---|---|---|
| 219 | 95 | 12 | 27.283 | 30.133 | 7.827 | 26.69 | 16.42 |
| 256 | 70 | 12 | 19.392 | 20.571 | 7.945 | 24.92 | 24.82 |
| 85 | 149 | 12 | 16.942 | 16.881 | 2.953 | 13.62 | 11.11 |
| 45 | 81 | 12 | 51.317 | 52.946 | 18.162 | 54.42 | 24.76 |
| 258 | 74 | 12 | 49.258 | 47.696 | 15.379 | 46.39 | 21.22 |
| 180 | 140 | 12 | 47.9 | 54.262 | 13.093 | 48 | 15.41 |
| 121 | 7 | 12 | 25.067 | 27.208 | 8.982 | 28.83 | 20.73 |
| 3 | 212 | 12 | 16.5 | 16.282 | 4.851 | 17.46 | 18.02 |
| 179 | 215 | 12 | 31.583 | 34.106 | 11.456 | 36.46 | 23.86 |
| 36 | 151 | 12 | 34.858 | 38.8 | 12.302 | 38.88 | 19.47 |
| 149 | 72 | 12 | 21.167 | 21.319 | 4.293 | 17.6 | 12.5 |
| 114 | 194 | 12 | 28.225 | 27.843 | 9.003 | 28.54 | 20.38 |
| 51 | 243 | 12 | 30.9 | 34.228 | 11.172 | 35.11 | 20.74 |
| 80 | 28 | 12 | 24.567 | 26.25 | 10.346 | 31.25 | 24.7 |
| 86 | 201 | 12 | 21.508 | 24.111 | 5.071 | 19.67 | 12.95 |
| 76 | 167 | 12 | 48.467 | 50.926 | 19.478 | 54.9 | 23.85 |
| 239 | 205 | 12 | 54.192 | 55.128 | 18.765 | 56.79 | 20.7 |
| 152 | 17 | 12 | 45.317 | 45.336 | 13.127 | 43.04 | 18.11 |
| 88 | 19 | 12 | 48.575 | 53.25 | 21.028 | 59.12 | 26.26 |
| 257 | 39 | 12 | 37.783 | 36.256 | 6.447 | 26.63 | 10.81 |
| 185 | 94 | 12 | 18.883 | 18.217 | 3.394 | 14.88 | 11.3 |
| 25 | 124 | 12 | 58.483 | 55.247 | 11.811 | 43.07 | 13.29 |
| 43 | 150 | 12 | 62.45 | 60.228 | 21.981 | 65.04 | 23.24 |
| 85 | 26 | 12 | 20.725 | 23.374 | 3.438 | 17.04 | 9.41 |
| 259 | 159 | 12 | 29.442 | 30.467 | 10.002 | 30.62 | 20.59 |