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 |
|---|---|---|---|---|---|---|---|
| 15 | 80 | 1 | 34.667 | 34.667 | 12.28 | 37.15 | 21.25 |
| 55 | 238 | 1 | 81.417 | 81.417 | 20.77 | 73 | 15.31 |
| 122 | 227 | 1 | 55.283 | 55.283 | 26.03 | 73 | 28.25 |
| 150 | 230 | 1 | 73 | 73 | 20.3 | 65.5 | 16.68 |
| 16 | 238 | 1 | 40.717 | 40.717 | 16.5 | 51.93 | 24.31 |
| 34 | 22 | 1 | 33.233 | 33.233 | 5.8 | 24 | 10.47 |
| 192 | 19 | 1 | 29.2 | 29.2 | 7.14 | 24.5 | 14.67 |
| 171 | 21 | 1 | 71.5 | 71.5 | 22.6 | 68.5 | 18.97 |
| 12 | 5 | 1 | 48.2 | 48.2 | 24.74 | 68 | 30.8 |
| 157 | 257 | 1 | 20.833 | 20.833 | 11.32 | 32 | 32.6 |
| 228 | 258 | 1 | 62.5 | 62.5 | 10.7 | 45 | 10.27 |
| 240 | 82 | 1 | 31.567 | 31.567 | 18.14 | 49.5 | 34.48 |
| 242 | 62 | 1 | 67.383 | 67.383 | 19 | 61 | 16.92 |
| 23 | 43 | 1 | 6.167 | 6.167 | 1.26 | 7 | 12.26 |
| 102 | 220 | 1 | 60 | 60 | 20.5 | 62.5 | 20.5 |
| 208 | 195 | 1 | 45.733 | 45.733 | 19.95 | 55.5 | 26.17 |
| 102 | 246 | 1 | 34.917 | 34.917 | 9.4 | 31.5 | 16.15 |
| 149 | 122 | 1 | 50.467 | 50.467 | 20.71 | 61 | 24.62 |
| 80 | 191 | 1 | 101.917 | 101.917 | 23.36 | 75 | 13.75 |
| 35 | 223 | 1 | 70.917 | 70.917 | 11.62 | 42.02 | 9.83 |
| 81 | 128 | 1 | 28 | 28 | 5.5 | 21 | 11.79 |
| 248 | 233 | 1 | 53.583 | 53.583 | 10.58 | 29.52 | 11.85 |
| 154 | 25 | 1 | 50.183 | 50.183 | 15.7 | 50 | 18.77 |
| 121 | 55 | 1 | 67.9 | 67.9 | 24.38 | 74 | 21.54 |
| 185 | 26 | 1 | 148.467 | 148.467 | 25.89 | 100 | 10.46 |