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 |
|---|---|---|---|---|---|---|---|
| 45 | 47 | 14 | 52.475 | 55.79 | 13.496 | 47.04 | 17.43 |
| 236 | 245 | 14 | 46.358 | 55.498 | 21.731 | 62.79 | 26.67 |
| 179 | 191 | 14 | 28.55 | 29.014 | 13.86 | 39.96 | 30.36 |
| 90 | 19 | 14 | 47.583 | 47.838 | 17.974 | 52.95 | 24.24 |
| 62 | 227 | 14 | 26.4 | 24.769 | 4.814 | 19.19 | 12.01 |
| 81 | 248 | 14 | 20.892 | 21.965 | 6.856 | 23.57 | 19.53 |
| 60 | 261 | 14 | 40.133 | 45.324 | 14.741 | 43.54 | 20.99 |
| 135 | 65 | 14 | 28.908 | 31.176 | 13.143 | 38.23 | 26.93 |
| 247 | 33 | 14 | 41.775 | 45.565 | 13.404 | 41.04 | 19.04 |
| 52 | 74 | 14 | 23.167 | 27.431 | 11.486 | 34.07 | 27.31 |
| 128 | 166 | 14 | 20.825 | 23.723 | 5.783 | 21.75 | 15.9 |
| 246 | 111 | 14 | 27.383 | 29.105 | 7.694 | 26.68 | 16.82 |
| 78 | 248 | 14 | 6.6 | 11.469 | 1.686 | 9.61 | 13.92 |
| 191 | 45 | 14 | 75.65 | 81.648 | 27.301 | 79.28 | 20.64 |
| 29 | 170 | 14 | 47.983 | 49.771 | 17.866 | 53.3 | 21.47 |
| 257 | 68 | 14 | 24.142 | 34.44 | 10.443 | 34.04 | 19.74 |
| 218 | 42 | 14 | 36.625 | 38.908 | 17.346 | 48.81 | 28.19 |
| 255 | 93 | 14 | 32.733 | 35.182 | 9.594 | 32.29 | 19.6 |
| 68 | 46 | 14 | 47.467 | 50.949 | 19.471 | 58.73 | 24.99 |
| 200 | 239 | 14 | 22.642 | 25.006 | 10.365 | 31.69 | 26.86 |
| 211 | 20 | 14 | 46.433 | 45.752 | 15.296 | 47.32 | 20.66 |
| 213 | 252 | 14 | 3.125 | 4.81 | 2.308 | 8.39 | 38.31 |
| 32 | 27 | 14 | 80.192 | 79.852 | 30.157 | 85.79 | 23.09 |
| 167 | 259 | 14 | 24.058 | 25.356 | 8.299 | 27.33 | 21.23 |
| 202 | 49 | 14 | 33.525 | 35.725 | 7.522 | 28.07 | 13.07 |