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 |
|---|---|---|---|---|---|---|---|
| 242 | 68 | 4 | 55.092 | 53.658 | 14.285 | 48.2 | 17.41 |
| 122 | 76 | 4 | 29.092 | 28.304 | 10.527 | 32.88 | 23.3 |
| 258 | 234 | 4 | 48.892 | 46.962 | 10.967 | 42 | 14.28 |
| 260 | 15 | 4 | 24.775 | 24.133 | 10.613 | 31.62 | 27.96 |
| 147 | 70 | 4 | 27.217 | 27.754 | 8.745 | 28.75 | 20.99 |
| 192 | 83 | 4 | 22.067 | 20.954 | 4.885 | 18.62 | 14.01 |
| 41 | 96 | 4 | 33.442 | 36.6 | 14.59 | 43.88 | 25.12 |
| 51 | 97 | 4 | 54.317 | 59.767 | 20.358 | 61.5 | 21.66 |
| 47 | 97 | 4 | 53.342 | 68.483 | 15.94 | 59.25 | 18.51 |
| 169 | 145 | 4 | 33.142 | 32.704 | 10.062 | 30.05 | 19.35 |
| 62 | 23 | 4 | 62.933 | 65.2 | 17.875 | 61 | 18.22 |
| 177 | 7 | 4 | 38.842 | 36.6 | 11.008 | 35.88 | 18.9 |
| 137 | 154 | 4 | 34.008 | 38.362 | 20.492 | 57.12 | 32.76 |
| 51 | 238 | 4 | 48.108 | 52.967 | 14.327 | 47.91 | 16.9 |
| 235 | 87 | 4 | 58.917 | 57.029 | 13.953 | 46 | 14.93 |
| 224 | 1 | 4 | 36.542 | 40.588 | 16.797 | 66.88 | 25.48 |
| 71 | 168 | 4 | 52.55 | 54.467 | 17.545 | 55.75 | 21.29 |
| 17 | 258 | 4 | 29.717 | 29.579 | 6.312 | 24.12 | 13.03 |
| 242 | 56 | 4 | 23.475 | 23.408 | 9.963 | 28.62 | 25.65 |
| 73 | 135 | 4 | 16.758 | 15.871 | 3.175 | 13.5 | 12.54 |
| 18 | 195 | 4 | 72.092 | 78.425 | 19.99 | 66.75 | 15.73 |
| 81 | 119 | 4 | 20.267 | 20.608 | 9.405 | 28.05 | 28.14 |
| 36 | 155 | 4 | 39.033 | 41.929 | 9.29 | 33.62 | 14.54 |
| 222 | 88 | 4 | 29.317 | 31.012 | 21.085 | 52 | 41.31 |
| 151 | 84 | 4 | 81.25 | 78.229 | 29.71 | 87 | 23.14 |