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 |
|---|---|---|---|---|---|---|---|
| 142 | 10 | 171 | 71.25 | 67.966 | 17.445 | 55.89 | 17.12 |
| 230 | 78 | 171 | 29.45 | 32.644 | 11.155 | 35.25 | 22.55 |
| 238 | 153 | 171 | 19.25 | 20.91 | 7.759 | 24.59 | 23.86 |
| 13 | 247 | 171 | 35.3 | 39.117 | 12.633 | 40.12 | 21.54 |
| 71 | 72 | 171 | 9.85 | 11.473 | 1.833 | 9.73 | 9.95 |
| 262 | 80 | 171 | 25.3 | 26.764 | 7.495 | 25.54 | 17.8 |
| 234 | 136 | 171 | 37.567 | 39.996 | 12.283 | 39.55 | 20.31 |
| 14 | 67 | 171 | 7.933 | 8.826 | 1.456 | 8.25 | 10.52 |
| 90 | 22 | 171 | 37.533 | 38.971 | 12.228 | 38.77 | 19.86 |
| 263 | 189 | 171 | 32.783 | 35.205 | 10.485 | 34.21 | 19.18 |
| 113 | 67 | 170 | 29.333 | 31.615 | 10.469 | 33.29 | 20.83 |
| 13 | 70 | 170 | 35.375 | 39.781 | 14.134 | 42.61 | 24.27 |
| 237 | 213 | 170 | 29.308 | 31.974 | 8.622 | 29.06 | 18.21 |
| 146 | 231 | 170 | 28.875 | 30.404 | 7.726 | 27.39 | 16.67 |
| 189 | 225 | 170 | 15.842 | 16.336 | 2.99 | 13.26 | 11.36 |
| 100 | 47 | 170 | 31.683 | 34.51 | 10.45 | 34.17 | 20.54 |
| 239 | 188 | 170 | 44.667 | 47.482 | 12.457 | 42.08 | 16.57 |
| 65 | 7 | 170 | 22.117 | 25.278 | 8.849 | 27.99 | 23.26 |
| 170 | 16 | 170 | 32.033 | 34.251 | 14.851 | 42.98 | 28.13 |
| 75 | 51 | 170 | 26.267 | 30.437 | 11.375 | 34.59 | 25.39 |
| 52 | 17 | 170 | 17.467 | 18.423 | 3.374 | 14.89 | 11.58 |
| 48 | 51 | 170 | 36.658 | 40.595 | 17.394 | 50.96 | 28.65 |
| 68 | 3 | 170 | 37.283 | 39.832 | 17.311 | 50.26 | 27.72 |
| 41 | 88 | 170 | 31.583 | 33.243 | 10.091 | 32.49 | 19.55 |
| 256 | 228 | 170 | 18.842 | 20.482 | 7.427 | 23.74 | 23.77 |