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 |
|---|---|---|---|---|---|---|---|
| 92 | 251 | 1 | 42.35 | 42.35 | 26.6 | 70 | 37.69 |
| 177 | 30 | 1 | 45.183 | 45.183 | 12.75 | 42 | 16.93 |
| 49 | 115 | 1 | 34.133 | 34.133 | 20.67 | 56.5 | 36.33 |
| 181 | 101 | 1 | 42.933 | 42.933 | 17.3 | 51 | 24.18 |
| 191 | 33 | 1 | 47.6 | 47.6 | 17.3 | 51.5 | 21.81 |
| 86 | 150 | 1 | 45.3 | 45.3 | 14.48 | 46.5 | 19.18 |
| 38 | 74 | 1 | 50.55 | 50.55 | 17.5 | 52 | 20.77 |
| 19 | 222 | 1 | 25.517 | 25.517 | 14.1 | 38.5 | 33.15 |
| 191 | 23 | 1 | 76.483 | 76.483 | 31.9 | 89.5 | 25.03 |
| 85 | 159 | 1 | 94.75 | 94.75 | 20.4 | 70 | 12.92 |
| 120 | 47 | 1 | 4.25 | 4.25 | 1.74 | 6.5 | 24.56 |
| 115 | 83 | 1 | 28.167 | 28.167 | 19.39 | 52.5 | 41.3 |
| 131 | 52 | 1 | 61.183 | 61.183 | 16.25 | 52 | 15.94 |
| 245 | 6 | 1 | 17.883 | 17.883 | 3.21 | 15 | 10.77 |
| 192 | 159 | 1 | 16.117 | 16.117 | 11.41 | 31.5 | 42.48 |
| 257 | 36 | 1 | 26.25 | 26.25 | 5.8 | 21.5 | 13.26 |
| 80 | 109 | 1 | 45.017 | 45.017 | 26.97 | 71.5 | 35.95 |
| 173 | 25 | 1 | 32.483 | 32.483 | 11.15 | 35 | 20.6 |
| 5 | 142 | 1 | 85.1 | 85.1 | 29.59 | 90.5 | 20.86 |
| 220 | 155 | 1 | 65.917 | 65.917 | 27.8 | 78.5 | 25.3 |
| 214 | 161 | 1 | 23.367 | 23.367 | 11.38 | 32.5 | 29.22 |
| 213 | 29 | 1 | 78.417 | 78.417 | 24.68 | 76 | 18.88 |
| 65 | 101 | 1 | 86 | 86 | 18.51 | 60 | 12.91 |
| 95 | 183 | 1 | 24.033 | 24.033 | 10.3 | 31 | 25.71 |
| 55 | 206 | 1 | 17.517 | 17.517 | 10.61 | 29.5 | 36.34 |