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 |
|---|---|---|---|---|---|---|---|
| 131 | 46 | 1 | 19.95 | 19.95 | 15.24 | 40.5 | 45.83 |
| 250 | 256 | 1 | 35.433 | 35.433 | 14.18 | 41.5 | 24.01 |
| 2 | 45 | 1 | 52.083 | 52.083 | 19.27 | 52 | 22.2 |
| 160 | 52 | 1 | 54.283 | 54.283 | 9.5 | 38.5 | 10.5 |
| 123 | 148 | 1 | 14.817 | 14.817 | 2.36 | 12.5 | 9.56 |
| 47 | 253 | 1 | 11.35 | 11.35 | 8.64 | 24.5 | 45.67 |
| 112 | 12 | 1 | 29.717 | 29.717 | 7.1 | 25.5 | 14.34 |
| 244 | 58 | 1 | 23.6 | 23.6 | 9.1 | 27 | 23.14 |
| 206 | 225 | 1 | 41.033 | 41.033 | 17.6 | 51 | 25.74 |
| 139 | 87 | 1 | 1.833 | 1.833 | 26.47 | 71.5 | 866.29 |
| 248 | 24 | 1 | 16 | 16 | 8.1 | 24.5 | 30.38 |
| 3 | 196 | 1 | 26.567 | 26.567 | 13.47 | 38.5 | 30.42 |
| 60 | 251 | 1 | 56.817 | 56.817 | 30.5 | 84 | 32.21 |
| 151 | 2 | 1 | 50.233 | 50.233 | 24.8 | 70 | 29.62 |
| 9 | 253 | 1 | 10.45 | 10.45 | 4.8 | 15 | 27.56 |
| 38 | 42 | 1 | 42.333 | 42.333 | 20.17 | 55 | 28.59 |
| 190 | 136 | 1 | 47.967 | 47.967 | 18.21 | 53.5 | 22.78 |
| 2 | 80 | 1 | 31.967 | 31.967 | 15.17 | 43.5 | 28.47 |
| 192 | 50 | 1 | 46.167 | 46.167 | 10.9 | 40.5 | 14.17 |
| 165 | 34 | 1 | 45.283 | 45.283 | 7.25 | 29.5 | 9.61 |
| 152 | 54 | 1 | 35.933 | 35.933 | 12.25 | 37.5 | 20.45 |
| 171 | 216 | 1 | 18.117 | 18.117 | 8.3 | 25.5 | 27.49 |
| 147 | 102 | 1 | 36.883 | 36.883 | 10.7 | 35.5 | 17.41 |
| 46 | 137 | 1 | 37.817 | 37.817 | 17.89 | 49.5 | 28.38 |
| 133 | 124 | 1 | 35.8 | 35.8 | 16.76 | 48.5 | 28.09 |