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 |
|---|---|---|---|---|---|---|---|
| 71 | 11 | 2 | 27.975 | 27.975 | 7.955 | 24.16 | 18.26 |
| 54 | 143 | 2 | 28.825 | 28.825 | 8.14 | 27.5 | 18.35 |
| 112 | 253 | 2 | 28.45 | 28.45 | 8.415 | 28.75 | 20.37 |
| 115 | 51 | 2 | 61.842 | 61.842 | 38.52 | 100.42 | 37.27 |
| 210 | 64 | 2 | 39.117 | 39.117 | 23.645 | 60.83 | 36.3 |
| 83 | 86 | 2 | 40.175 | 40.175 | 17.73 | 50.75 | 27.47 |
| 135 | 220 | 2 | 31.267 | 31.267 | 16.95 | 45.82 | 33.56 |
| 53 | 258 | 2 | 23.933 | 23.933 | 9.84 | 30.25 | 25.06 |
| 131 | 61 | 2 | 32.142 | 32.142 | 12.145 | 37.75 | 22.7 |
| 58 | 68 | 2 | 40.917 | 40.917 | 16.76 | 47.5 | 24.49 |
| 85 | 114 | 2 | 40.967 | 40.967 | 9.35 | 32.5 | 13.84 |
| 35 | 163 | 2 | 82.3 | 82.3 | 13.795 | 46.36 | 10.07 |
| 86 | 38 | 2 | 27.492 | 27.492 | 8.59 | 24.59 | 18.9 |
| 227 | 63 | 2 | 52.95 | 52.95 | 16.95 | 52 | 20.91 |
| 123 | 151 | 2 | 5.967 | 5.967 | 1.165 | 6.75 | 11.66 |
| 106 | 60 | 2 | 54.675 | 54.675 | 18.425 | 58.25 | 20.24 |
| 91 | 32 | 2 | 48.35 | 48.35 | 25.035 | 59.92 | 30.97 |
| 200 | 20 | 2 | 17.95 | 17.95 | 3.56 | 15.25 | 11.78 |
| 98 | 79 | 2 | 36.525 | 36.525 | 13.065 | 40.46 | 21.52 |
| 180 | 225 | 2 | 27.117 | 27.117 | 6.385 | 23.75 | 13.9 |
| 86 | 36 | 2 | 47.108 | 47.108 | 14.615 | 45.25 | 19.13 |
| 3 | 117 | 2 | 50.225 | 50.225 | 28.35 | 72.85 | 34.75 |
| 252 | 234 | 2 | 37.417 | 37.417 | 14.685 | 43.5 | 24.98 |
| 219 | 67 | 2 | 43.242 | 43.242 | 18 | 50.5 | 25.06 |
| 207 | 75 | 2 | 21.208 | 21.208 | 6.645 | 36.25 | 18.87 |