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 |
|---|---|---|---|---|---|---|---|
| 220 | 170 | 42 | 59.333 | 57.978 | 11.986 | 45.08 | 13.3 |
| 167 | 126 | 42 | 8.458 | 11.443 | 1.707 | 9.64 | 9.02 |
| 151 | 92 | 42 | 30.025 | 33.45 | 11.575 | 36.43 | 21.74 |
| 215 | 132 | 42 | 16.667 | 29.849 | 9.689 | 35.85 | 26.8 |
| 42 | 188 | 42 | 57.108 | 57.76 | 17.391 | 53.02 | 19.37 |
| 151 | 36 | 42 | 42.675 | 44.261 | 11.738 | 39.24 | 16.79 |
| 233 | 85 | 42 | 41.408 | 41.417 | 11.263 | 37.45 | 17.18 |
| 17 | 195 | 42 | 16.742 | 19.334 | 5.099 | 18.14 | 18.16 |
| 128 | 244 | 42 | 14.3 | 15.15 | 2.964 | 13.08 | 12.7 |
| 129 | 255 | 42 | 16.067 | 17.375 | 5.474 | 18.88 | 20.85 |
| 95 | 90 | 42 | 34.633 | 36.347 | 9.318 | 32.5 | 16.2 |
| 24 | 194 | 42 | 20.142 | 21.874 | 4.576 | 21.32 | 12.77 |
| 113 | 94 | 42 | 36.117 | 37.801 | 12.538 | 38.77 | 21.58 |
| 228 | 52 | 42 | 13.575 | 14.586 | 2.659 | 12.07 | 11.61 |
| 195 | 225 | 42 | 28.567 | 30.154 | 6.318 | 24.18 | 13.48 |
| 139 | 226 | 42 | 49.975 | 48.989 | 15.293 | 45.75 | 20.31 |
| 65 | 92 | 42 | 29.433 | 31.291 | 12.835 | 38.08 | 27.28 |
| 4 | 159 | 42 | 25.425 | 28.418 | 8.881 | 28.81 | 21.28 |
| 224 | 195 | 42 | 21.333 | 23.412 | 7.14 | 24.56 | 20.59 |
| 244 | 144 | 42 | 35.775 | 36.325 | 10.513 | 35.13 | 18.48 |
| 92 | 15 | 42 | 13.625 | 15.417 | 4.198 | 16.71 | 18.02 |
| 8 | 236 | 42 | 13.292 | 16.267 | 5.162 | 48.89 | 21.81 |
| 62 | 45 | 42 | 25.192 | 25.706 | 4.888 | 20.22 | 13.26 |
| 211 | 92 | 42 | 40.35 | 40.85 | 13.292 | 41.9 | 20.87 |
| 179 | 25 | 42 | 34.75 | 34.249 | 10.519 | 33.71 | 19.14 |