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 |
|---|---|---|---|---|---|---|---|
| 64 | 98 | 5 | 10.3 | 10.587 | 4.582 | 15.1 | 26.91 |
| 62 | 205 | 5 | 37.617 | 41.01 | 11.942 | 38.89 | 17.77 |
| 205 | 174 | 5 | 34.517 | 32.9 | 17.614 | 46.46 | 32.41 |
| 263 | 101 | 5 | 31.367 | 33.553 | 19.44 | 53.1 | 35.82 |
| 180 | 237 | 5 | 54.317 | 55.093 | 12.262 | 50.5 | 14.48 |
| 192 | 90 | 5 | 34.833 | 34.857 | 9.968 | 32.7 | 16.12 |
| 140 | 156 | 5 | 54.15 | 55.337 | 23.966 | 67.4 | 27.73 |
| 225 | 247 | 5 | 44.983 | 50.947 | 14.826 | 47.05 | 18.38 |
| 81 | 237 | 5 | 55.05 | 58.73 | 14.404 | 46.49 | 14.99 |
| 188 | 147 | 5 | 49.3 | 52.173 | 18.668 | 56.5 | 22.36 |
| 121 | 234 | 5 | 45.633 | 45.09 | 11.518 | 38.5 | 15.95 |
| 65 | 38 | 5 | 59.4 | 61.467 | 17.712 | 54.64 | 17.61 |
| 78 | 17 | 5 | 45.333 | 56.953 | 18.826 | 57.7 | 22.71 |
| 83 | 239 | 5 | 37.133 | 38.533 | 7.494 | 30 | 11.69 |
| 77 | 93 | 5 | 28.117 | 27.883 | 10.166 | 31.6 | 22.63 |
| 113 | 84 | 5 | 45.217 | 47.153 | 24.404 | 67.2 | 31.71 |
| 254 | 33 | 5 | 64.333 | 68.24 | 20.136 | 62.9 | 18.39 |
| 97 | 31 | 5 | 52.9 | 55.523 | 18.378 | 55.4 | 23.29 |
| 39 | 28 | 5 | 26.733 | 29.477 | 11.238 | 32.8 | 23.92 |
| 144 | 128 | 5 | 49.217 | 48.873 | 13.632 | 44.4 | 17.95 |
| 101 | 35 | 5 | 26.3 | 28.593 | 15.54 | 43.5 | 33.03 |
| 256 | 215 | 5 | 35.383 | 36.003 | 12.186 | 37.9 | 22.66 |
| 139 | 16 | 5 | 24.633 | 23.16 | 9.726 | 29.2 | 25.94 |
| 39 | 113 | 5 | 43.6 | 48.12 | 12.914 | 41.66 | 15.72 |
| 12 | 51 | 5 | 42.283 | 41.76 | 20.032 | 55.4 | 29.78 |