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 |
|---|---|---|---|---|---|---|---|
| 82 | 159 | 18 | 29 | 30.953 | 8.893 | 29.68 | 18.3 |
| 143 | 102 | 18 | 40.992 | 40.747 | 10.48 | 35.83 | 15.68 |
| 188 | 55 | 18 | 40.567 | 41.328 | 10.437 | 36.72 | 16.26 |
| 13 | 251 | 18 | 25.517 | 26.738 | 13.977 | 42.56 | 33.06 |
| 165 | 217 | 18 | 33.983 | 38.279 | 6.921 | 28.45 | 12.23 |
| 261 | 16 | 18 | 43.9 | 45.934 | 19.98 | 56.55 | 27.18 |
| 92 | 152 | 18 | 40.475 | 40.815 | 11.361 | 34.01 | 17.47 |
| 248 | 170 | 18 | 40.442 | 40.874 | 10.421 | 33.41 | 16.55 |
| 162 | 221 | 18 | 36.142 | 39.368 | 17.198 | 49.25 | 26.98 |
| 76 | 68 | 18 | 64.692 | 64.389 | 14.202 | 47.98 | 14.19 |
| 17 | 50 | 18 | 38.217 | 39.013 | 8.216 | 30.75 | 13.22 |
| 193 | 217 | 18 | 17.675 | 18.463 | 4.766 | 17.28 | 16.1 |
| 159 | 81 | 18 | 26.942 | 28.944 | 9.673 | 31.12 | 21.03 |
| 141 | 8 | 18 | 18.5 | 18.517 | 4.942 | 17.69 | 16.63 |
| 122 | 19 | 18 | 11.117 | 11.525 | 2.771 | 11.28 | 14.99 |
| 261 | 78 | 18 | 39.183 | 36.851 | 14.759 | 43.42 | 25.01 |
| 255 | 165 | 18 | 29.517 | 32.8 | 10.401 | 33.5 | 20.57 |
| 61 | 238 | 18 | 49.475 | 49.43 | 13.198 | 44.03 | 17.11 |
| 42 | 117 | 18 | 72.95 | 74.646 | 25.932 | 78.68 | 21.87 |
| 196 | 146 | 18 | 22.775 | 25.287 | 5.624 | 21.38 | 13.97 |
| 152 | 205 | 18 | 48.725 | 52.548 | 18.762 | 56.8 | 23.96 |
| 13 | 167 | 18 | 41.875 | 42.961 | 14.169 | 43.58 | 21.56 |
| 44 | 118 | 18 | 16.7 | 18.883 | 7.432 | 23.72 | 25.25 |
| 43 | 91 | 18 | 63.208 | 62.3 | 17.796 | 58.61 | 19.5 |
| 88 | 102 | 18 | 35.542 | 36.737 | 11.892 | 37.33 | 20.45 |