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 |
|---|---|---|---|---|---|---|---|
| 77 | 186 | 5 | 57.6 | 57.62 | 17.91 | 56.74 | 20.87 |
| 54 | 166 | 5 | 46.65 | 43.73 | 12.612 | 41 | 17.71 |
| 179 | 119 | 5 | 14.4 | 16.337 | 6.31 | 20.3 | 24.14 |
| 124 | 91 | 5 | 22.317 | 28.407 | 9.414 | 29.79 | 22.19 |
| 7 | 72 | 5 | 41.633 | 43.35 | 11.858 | 40.1 | 17.1 |
| 79 | 204 | 5 | 46.133 | 48.623 | 28.106 | 76.4 | 35.18 |
| 219 | 160 | 5 | 26.033 | 27.6 | 10.468 | 31.4 | 23.69 |
| 7 | 200 | 5 | 26.9 | 31.593 | 12.006 | 36.5 | 26.27 |
| 129 | 78 | 5 | 20.383 | 22.89 | 10.02 | 30 | 26.75 |
| 218 | 79 | 5 | 51.55 | 53.477 | 17.086 | 52.2 | 19.81 |
| 194 | 225 | 5 | 43.317 | 46.377 | 14.936 | 46.9 | 20.35 |
| 159 | 63 | 5 | 48.183 | 61.71 | 16.508 | 53.71 | 17.67 |
| 81 | 95 | 5 | 40.767 | 44.087 | 14.984 | 46.1 | 22.44 |
| 62 | 224 | 5 | 35.05 | 34.87 | 8.118 | 29.07 | 15.29 |
| 4 | 101 | 5 | 41.55 | 42.67 | 19.686 | 55.19 | 27.92 |
| 215 | 222 | 5 | 28.733 | 27.187 | 7.852 | 26.2 | 17.56 |
| 197 | 166 | 5 | 28.8 | 31.183 | 14.384 | 47.45 | 28.85 |
| 227 | 42 | 5 | 43.983 | 56.92 | 17.028 | 53.43 | 22.04 |
| 95 | 243 | 5 | 36.133 | 38.047 | 15.15 | 44.35 | 25.56 |
| 123 | 170 | 5 | 44.583 | 44.943 | 13.874 | 43.49 | 20.53 |
| 160 | 79 | 5 | 31.55 | 33.187 | 7.794 | 27.44 | 14.63 |
| 177 | 119 | 5 | 47.633 | 55.667 | 18.55 | 58.9 | 22.26 |
| 71 | 124 | 5 | 27.117 | 39.227 | 12.244 | 39.7 | 19.63 |
| 72 | 28 | 5 | 33.583 | 33.963 | 9.73 | 31.17 | 17.77 |
| 143 | 201 | 5 | 62.467 | 73.103 | 26.502 | 79.3 | 24.47 |