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 |
|---|---|---|---|---|---|---|---|
| 20 | 43 | 5 | 39.217 | 42.86 | 10.726 | 36.9 | 15.42 |
| 215 | 39 | 5 | 26.95 | 26.4 | 9.974 | 30.36 | 23.54 |
| 259 | 244 | 5 | 27.617 | 28.447 | 7.826 | 26.44 | 17.13 |
| 167 | 24 | 5 | 27.9 | 29.373 | 4.95 | 21.5 | 10.51 |
| 147 | 193 | 5 | 32.867 | 34.907 | 7.386 | 26.15 | 12.83 |
| 81 | 142 | 5 | 64.95 | 74.333 | 18.782 | 62.3 | 15.87 |
| 198 | 91 | 5 | 35.5 | 36.17 | 7.084 | 27.13 | 11.93 |
| 22 | 68 | 5 | 39.933 | 40.807 | 11.904 | 39.5 | 17.43 |
| 158 | 187 | 5 | 38.933 | 39.963 | 18.628 | 52.5 | 29.08 |
| 93 | 85 | 5 | 39.933 | 47.24 | 15.392 | 47.7 | 20.16 |
| 42 | 16 | 5 | 32.317 | 36.107 | 15.016 | 43.43 | 26.42 |
| 139 | 134 | 5 | 23.883 | 26.527 | 9.056 | 27.66 | 20.18 |
| 209 | 31 | 5 | 29.75 | 31.797 | 14.692 | 40.72 | 28.57 |
| 241 | 57 | 5 | 27.5 | 27.65 | 13.182 | 37.34 | 28.71 |
| 186 | 30 | 5 | 50.783 | 49.897 | 17.684 | 53.6 | 21.31 |
| 69 | 114 | 5 | 39.55 | 42.773 | 11.476 | 38.2 | 16.89 |
| 40 | 202 | 5 | 31.85 | 35.87 | 9.29 | 31.5 | 16.13 |
| 71 | 224 | 5 | 54.817 | 55.497 | 11.83 | 44.7 | 13.8 |
| 36 | 215 | 5 | 47.95 | 45.573 | 10.816 | 37.4 | 15.13 |
| 160 | 148 | 5 | 27.8 | 34.98 | 8.544 | 34.17 | 17.91 |
| 151 | 150 | 5 | 48.167 | 48.8 | 22.324 | 63.3 | 27.81 |
| 98 | 63 | 5 | 34.45 | 33.287 | 8.298 | 28.8 | 15.18 |
| 228 | 56 | 5 | 43.533 | 42.087 | 14.11 | 42.41 | 22.22 |
| 35 | 134 | 5 | 24.317 | 24.367 | 6.784 | 24.2 | 17.81 |
| 209 | 214 | 5 | 32.75 | 30.717 | 13.288 | 38.4 | 26.41 |