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 |
|---|---|---|---|---|---|---|---|
| 93 | 255 | 45 | 24.617 | 26.721 | 10.365 | 31.69 | 25.22 |
| 88 | 134 | 44 | 38.275 | 43.365 | 15.122 | 45.33 | 23 |
| 219 | 238 | 44 | 53.408 | 53.347 | 18.328 | 53.07 | 22.17 |
| 140 | 120 | 44 | 18.642 | 22.886 | 6.908 | 23.67 | 21.55 |
| 113 | 210 | 44 | 42.525 | 42.613 | 17.497 | 50.97 | 25.94 |
| 74 | 189 | 44 | 43.467 | 45.532 | 12.749 | 41.02 | 18.46 |
| 4 | 177 | 44 | 34.567 | 37.27 | 7.486 | 28.93 | 12.72 |
| 140 | 150 | 44 | 44.542 | 48.687 | 21.19 | 60.88 | 28.1 |
| 166 | 198 | 44 | 37.567 | 40.094 | 10.846 | 36.55 | 16.87 |
| 135 | 226 | 44 | 32.917 | 31.638 | 8.479 | 27.48 | 17.91 |
| 133 | 85 | 44 | 11.717 | 12.341 | 1.636 | 9.77 | 8.77 |
| 238 | 175 | 44 | 42.508 | 42.872 | 17.755 | 51.7 | 25.73 |
| 237 | 175 | 44 | 40.125 | 43.5 | 15.004 | 45.88 | 22.65 |
| 24 | 255 | 44 | 37.608 | 37.997 | 10.501 | 35.22 | 17.52 |
| 196 | 145 | 44 | 19.267 | 18.472 | 6.398 | 29.61 | 23.95 |
| 121 | 205 | 44 | 21.4 | 22.702 | 4.971 | 19.3 | 13.75 |
| 106 | 80 | 44 | 20.683 | 22.787 | 5.931 | 21.35 | 17.36 |
| 42 | 31 | 44 | 21.45 | 23.498 | 7.776 | 25.27 | 21.91 |
| 215 | 139 | 44 | 12.633 | 13.541 | 3.157 | 12.74 | 14.22 |
| 136 | 41 | 44 | 22.783 | 25.526 | 6.185 | 22.53 | 15.68 |
| 41 | 31 | 44 | 24.7 | 27.536 | 8.573 | 28.14 | 20.49 |
| 205 | 121 | 44 | 21.717 | 21.897 | 4.652 | 18.44 | 13.03 |
| 157 | 141 | 44 | 16.85 | 20.249 | 5.698 | 39.02 | 18.78 |
| 61 | 186 | 44 | 42.475 | 43.925 | 8.623 | 32.33 | 12.82 |
| 43 | 126 | 44 | 28.258 | 28.875 | 7.122 | 25.55 | 15.94 |