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 |
|---|---|---|---|---|---|---|---|
| 74 | 124 | 7 | 48.417 | 52.086 | 18.27 | 54.43 | 23.82 |
| 37 | 152 | 7 | 39.133 | 41.04 | 13.626 | 41.43 | 20.6 |
| 92 | 263 | 7 | 46.567 | 43.724 | 11.027 | 35.95 | 16.83 |
| 157 | 263 | 7 | 28 | 26.49 | 8.233 | 35.02 | 18.93 |
| 85 | 255 | 7 | 29.333 | 28.252 | 6.679 | 24.5 | 15.4 |
| 52 | 149 | 7 | 31.483 | 30.207 | 10.863 | 32.64 | 21.33 |
| 175 | 162 | 7 | 59.483 | 52.607 | 16.667 | 51 | 20.41 |
| 235 | 89 | 7 | 57.4 | 63.779 | 24.953 | 65.8 | 24.25 |
| 146 | 32 | 7 | 28.217 | 30.86 | 12.321 | 36.64 | 24.76 |
| 227 | 106 | 7 | 15.15 | 15.598 | 2.791 | 13.07 | 12.05 |
| 171 | 145 | 7 | 28.35 | 41.8 | 12.494 | 39.87 | 21.4 |
| 81 | 90 | 7 | 47.35 | 56.01 | 19.711 | 60.36 | 23.33 |
| 197 | 36 | 7 | 25.433 | 26.59 | 6.1 | 22.74 | 14.09 |
| 19 | 121 | 7 | 13.083 | 13.171 | 5.267 | 16.23 | 26.52 |
| 49 | 218 | 7 | 43.267 | 44.893 | 14.82 | 48.69 | 20.85 |
| 117 | 188 | 7 | 45.15 | 46.517 | 13.8 | 44.79 | 18.13 |
| 228 | 43 | 7 | 39.917 | 50.724 | 12.926 | 42.94 | 17.22 |
| 4 | 149 | 7 | 32.267 | 30.774 | 12.357 | 36.36 | 24.63 |
| 72 | 113 | 7 | 73.067 | 66.636 | 9.291 | 40.32 | 8.8 |
| 32 | 140 | 7 | 43.5 | 40.188 | 9.769 | 34.21 | 16.12 |
| 20 | 68 | 7 | 59.35 | 58.007 | 14.664 | 51.29 | 15.39 |
| 48 | 253 | 7 | 32.533 | 39.94 | 12.727 | 40.43 | 20.05 |
| 142 | 214 | 7 | 59.633 | 59.971 | 19.693 | 59.93 | 20.49 |
| 33 | 235 | 7 | 37.533 | 38.536 | 15.246 | 44.21 | 24.57 |
| 178 | 150 | 7 | 17.517 | 17.962 | 3.973 | 15.36 | 13.41 |