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 |
|---|---|---|---|---|---|---|---|
| 68 | 180 | 39 | 47.05 | 52.322 | 13.51 | 45.94 | 17.08 |
| 236 | 10 | 39 | 44.1 | 49.841 | 17.419 | 50.57 | 23.58 |
| 127 | 132 | 39 | 43.833 | 45.248 | 21.966 | 53.35 | 31.47 |
| 65 | 168 | 39 | 28.15 | 30.281 | 12.055 | 35.74 | 26.71 |
| 261 | 248 | 39 | 47.567 | 51.554 | 14.866 | 46.54 | 20.27 |
| 68 | 53 | 39 | 41.6 | 45.106 | 14.608 | 46.12 | 20.76 |
| 129 | 17 | 39 | 20.383 | 22.955 | 7.531 | 24.71 | 21.24 |
| 216 | 100 | 39 | 52.65 | 56.464 | 14.748 | 51.22 | 17.3 |
| 76 | 258 | 39 | 12.983 | 16.368 | 2.96 | 14.01 | 11.73 |
| 249 | 60 | 39 | 32.75 | 36.98 | 13.34 | 40.72 | 23.13 |
| 236 | 76 | 39 | 53.067 | 57.441 | 16.522 | 53.51 | 18.33 |
| 171 | 16 | 39 | 12.45 | 14.905 | 3.495 | 13.92 | 13.92 |
| 91 | 33 | 39 | 43.05 | 42.492 | 7.586 | 29.62 | 10.98 |
| 24 | 49 | 39 | 38.083 | 40.859 | 12.06 | 39.4 | 18.45 |
| 140 | 63 | 39 | 47.533 | 51.693 | 13.719 | 45.73 | 18 |
| 34 | 17 | 39 | 9.017 | 10.032 | 1.685 | 8.71 | 11.05 |
| 158 | 11 | 39 | 31.2 | 31.351 | 12.937 | 38.32 | 25.37 |
| 151 | 250 | 39 | 26.45 | 30.473 | 9.914 | 31.42 | 21.9 |
| 36 | 65 | 39 | 17.683 | 21.504 | 4.29 | 17.55 | 13.53 |
| 86 | 65 | 39 | 64.567 | 69.393 | 25.026 | 73.25 | 22.28 |
| 209 | 123 | 38 | 31.483 | 33.661 | 10.224 | 33.09 | 19.7 |
| 220 | 18 | 38 | 12.075 | 13.589 | 2.349 | 11.2 | 10.62 |
| 246 | 63 | 38 | 46.95 | 48.943 | 13.527 | 44.49 | 18.26 |
| 239 | 121 | 38 | 43.592 | 43.254 | 14.243 | 45.2 | 20.86 |
| 24 | 66 | 38 | 37.317 | 38.218 | 10.648 | 35.53 | 17.57 |