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 |
|---|---|---|---|---|---|---|---|
| 13 | 56 | 21 | 31.717 | 36.76 | 13.884 | 41.5 | 23.9 |
| 81 | 168 | 21 | 22.517 | 26.856 | 10.292 | 29.62 | 26.81 |
| 131 | 82 | 21 | 25.183 | 28.774 | 8.294 | 27.16 | 18.7 |
| 220 | 69 | 21 | 21.467 | 22.856 | 5.664 | 21.08 | 16.12 |
| 137 | 139 | 21 | 47.983 | 57.475 | 19.453 | 58.52 | 24.59 |
| 226 | 208 | 21 | 32.25 | 35.755 | 13.732 | 40.09 | 24.86 |
| 224 | 51 | 21 | 50.7 | 57.322 | 16.281 | 51.19 | 20.35 |
| 106 | 39 | 21 | 35.1 | 38.433 | 10.736 | 35.6 | 17.69 |
| 116 | 12 | 21 | 27.65 | 29.381 | 9.854 | 31.36 | 20.79 |
| 189 | 13 | 21 | 24.3 | 27.817 | 4.626 | 21.29 | 10.7 |
| 97 | 29 | 21 | 36.2 | 36.671 | 13.404 | 41.36 | 23.63 |
| 5 | 118 | 21 | 34.6 | 34.011 | 7.038 | 27.86 | 12.84 |
| 141 | 9 | 21 | 33.967 | 39.721 | 13.319 | 41.45 | 22.48 |
| 246 | 77 | 21 | 51.283 | 55.094 | 13.089 | 46.31 | 15.26 |
| 129 | 63 | 21 | 24.917 | 27.557 | 10.088 | 31.64 | 23.12 |
| 237 | 101 | 21 | 48.517 | 47.898 | 19.215 | 56.23 | 25.53 |
| 235 | 25 | 21 | 48.667 | 50.91 | 16.221 | 50.18 | 20.61 |
| 98 | 130 | 21 | 16.133 | 17.69 | 3.789 | 15.57 | 13.36 |
| 227 | 90 | 21 | 30.317 | 30.543 | 9.157 | 29.23 | 18.77 |
| 90 | 86 | 21 | 63.45 | 67.13 | 24.214 | 73.67 | 23.65 |
| 60 | 147 | 21 | 11.083 | 14.403 | 1.666 | 10.57 | 8.05 |
| 247 | 240 | 21 | 18.85 | 19.721 | 7.09 | 22.63 | 24.04 |
| 257 | 75 | 21 | 37.617 | 39.883 | 14.173 | 42.75 | 22.67 |
| 233 | 19 | 21 | 33.867 | 36.406 | 16.41 | 47.45 | 32.97 |
| 63 | 148 | 21 | 48.2 | 47.247 | 8.579 | 52.62 | 11.06 |