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 |
|---|---|---|---|---|---|---|---|
| 198 | 14 | 7 | 46.983 | 49.276 | 14.857 | 47.07 | 18.49 |
| 52 | 165 | 7 | 30.95 | 29.702 | 6.941 | 25.19 | 14.92 |
| 227 | 149 | 7 | 26.75 | 26.774 | 5.671 | 22.43 | 12.73 |
| 45 | 3 | 7 | 50.15 | 54.05 | 18.633 | 55.25 | 21.16 |
| 36 | 26 | 7 | 33.967 | 40.029 | 10.937 | 36.93 | 17.71 |
| 24 | 53 | 7 | 35.933 | 37.221 | 13.094 | 40.57 | 21.88 |
| 19 | 28 | 7 | 20.083 | 22.729 | 6.48 | 22.79 | 19.58 |
| 220 | 32 | 7 | 26.433 | 24.926 | 4.984 | 20.86 | 13.31 |
| 123 | 162 | 7 | 42.35 | 45.869 | 16.496 | 48.2 | 22.56 |
| 116 | 83 | 7 | 35.117 | 32.914 | 9.449 | 32.36 | 19.16 |
| 256 | 254 | 7 | 42.05 | 42.155 | 18.19 | 52.79 | 26.62 |
| 258 | 135 | 7 | 16.917 | 17.321 | 4.689 | 16.93 | 16.95 |
| 191 | 226 | 7 | 36.367 | 37.162 | 13.986 | 41.79 | 23.7 |
| 219 | 92 | 7 | 26.883 | 26.524 | 9.316 | 28.36 | 22.09 |
| 76 | 21 | 7 | 33.75 | 32.957 | 10.727 | 34 | 20.09 |
| 200 | 237 | 7 | 42.5 | 45.79 | 12.207 | 39.85 | 16.51 |
| 82 | 167 | 7 | 39.767 | 49.486 | 12.247 | 45.5 | 17.68 |
| 230 | 44 | 7 | 60.033 | 60.757 | 32.013 | 87.64 | 32.56 |
| 262 | 9 | 7 | 40.3 | 39.867 | 15.397 | 46.07 | 23.86 |
| 218 | 74 | 7 | 37.05 | 38.848 | 16.31 | 46.74 | 25.99 |
| 8 | 234 | 7 | 20.8 | 25.84 | 7.531 | 25.29 | 18.19 |
| 256 | 180 | 7 | 29.85 | 30.274 | 11.847 | 37.14 | 23.88 |
| 96 | 198 | 7 | 12.633 | 14.007 | 3.757 | 13.79 | 15 |
| 129 | 259 | 7 | 37.383 | 47.105 | 15.48 | 46.14 | 24.31 |
| 193 | 3 | 7 | 36.783 | 41.452 | 13.147 | 42.07 | 21.06 |