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 |
|---|---|---|---|---|---|---|---|
| 260 | 258 | 79 | 21.35 | 23.186 | 6.732 | 22.81 | 18.12 |
| 174 | 51 | 79 | 15.017 | 16.663 | 3.077 | 14.13 | 11.95 |
| 68 | 29 | 79 | 40.7 | 42.819 | 17.555 | 51.59 | 25.87 |
| 79 | 250 | 79 | 26.05 | 29.095 | 12.736 | 37.1 | 28.13 |
| 76 | 231 | 79 | 53.733 | 56.076 | 13.646 | 51.6 | 15.56 |
| 232 | 197 | 79 | 31.05 | 35.737 | 12.861 | 39.21 | 23.73 |
| 141 | 21 | 79 | 42.267 | 43.694 | 16.086 | 48.2 | 23.17 |
| 68 | 131 | 79 | 45.433 | 49.477 | 15.192 | 48.63 | 20.57 |
| 88 | 258 | 79 | 62.767 | 61.16 | 14.397 | 46.9 | 15.23 |
| 168 | 242 | 79 | 23.133 | 24.174 | 6.854 | 23.39 | 18.27 |
| 95 | 145 | 79 | 26.683 | 27.414 | 6.796 | 23.88 | 15.68 |
| 227 | 181 | 79 | 17.65 | 19.636 | 3.035 | 14.65 | 10.17 |
| 198 | 80 | 79 | 14.55 | 14.877 | 2.655 | 12.32 | 12.32 |
| 40 | 80 | 79 | 16.633 | 18.661 | 5.352 | 18.68 | 19.12 |
| 74 | 225 | 79 | 42.717 | 43.826 | 12.563 | 40.93 | 18.52 |
| 235 | 69 | 79 | 14.617 | 15.156 | 2.333 | 11.82 | 9.75 |
| 145 | 65 | 79 | 20.117 | 24.675 | 6.51 | 23.25 | 18.03 |
| 233 | 248 | 79 | 24.983 | 27.742 | 9.739 | 30.01 | 22.95 |
| 100 | 178 | 79 | 41.117 | 45.217 | 12.341 | 40.95 | 17.45 |
| 39 | 222 | 79 | 11.5 | 11.578 | 1.988 | 9.97 | 10.9 |
| 262 | 17 | 79 | 34.083 | 34.475 | 9.375 | 31.92 | 17.19 |
| 216 | 75 | 78 | 40.833 | 44.143 | 16.435 | 49.27 | 23.91 |
| 233 | 123 | 78 | 41.933 | 43.216 | 14.962 | 45.26 | 21.43 |
| 117 | 117 | 78 | 6.408 | 10.377 | 1.886 | 11.64 | 10.97 |
| 216 | 140 | 78 | 39.358 | 42.023 | 15.934 | 47.47 | 25.21 |