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 |
|---|---|---|---|---|---|---|---|
| 17 | 69 | 4 | 49.367 | 49.438 | 15.067 | 48.7 | 19.22 |
| 34 | 42 | 4 | 27.325 | 28 | 11.652 | 34 | 26.05 |
| 93 | 39 | 4 | 28.958 | 29.725 | 12.992 | 37.5 | 26.83 |
| 157 | 73 | 4 | 18.933 | 19.625 | 6.475 | 20.75 | 22.16 |
| 35 | 121 | 4 | 29.783 | 30.925 | 9.363 | 31.04 | 18.49 |
| 250 | 231 | 4 | 50.408 | 56.242 | 15.8 | 51.62 | 19.29 |
| 102 | 83 | 4 | 20.208 | 18.675 | 3.897 | 15.75 | 12.62 |
| 171 | 79 | 4 | 47.05 | 46.796 | 13.287 | 42.38 | 17.86 |
| 257 | 50 | 4 | 34.058 | 33.267 | 9.67 | 32.75 | 17.81 |
| 85 | 169 | 4 | 58.7 | 61.971 | 19.605 | 60.45 | 19.61 |
| 28 | 256 | 4 | 21.842 | 22.863 | 10.932 | 44.75 | 35.14 |
| 145 | 60 | 4 | 23.817 | 24.283 | 9.547 | 29 | 24.44 |
| 112 | 131 | 4 | 24.342 | 24.5 | 12.29 | 35.38 | 30.76 |
| 95 | 174 | 4 | 41.925 | 41.942 | 14.783 | 46.75 | 21.8 |
| 9 | 179 | 4 | 20.483 | 22.896 | 8.865 | 26.24 | 24.33 |
| 60 | 25 | 4 | 67.817 | 65.404 | 16.562 | 53.88 | 15.49 |
| 223 | 47 | 4 | 19.292 | 22.083 | 8.668 | 26.5 | 25.61 |
| 50 | 184 | 4 | 24.433 | 25.358 | 14.925 | 41.77 | 35.5 |
| 143 | 19 | 4 | 37.933 | 45.675 | 21.87 | 61 | 31.75 |
| 95 | 51 | 4 | 29.642 | 32.425 | 13.475 | 40 | 25.4 |
| 243 | 183 | 4 | 24.417 | 36.363 | 7.987 | 25.25 | 19.33 |
| 197 | 255 | 4 | 26.317 | 32.042 | 14.84 | 42 | 30.68 |
| 91 | 13 | 4 | 34.933 | 35.117 | 9.22 | 32.27 | 15.91 |
| 254 | 24 | 4 | 44.283 | 41.079 | 12.23 | 38.8 | 18.47 |
| 21 | 225 | 4 | 37.983 | 39.596 | 9.105 | 30.66 | 13.96 |