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 |
|---|---|---|---|---|---|---|---|
| 20 | 242 | 31 | 14.067 | 16.489 | 3.133 | 13.98 | 11.51 |
| 231 | 128 | 31 | 34.117 | 36.528 | 13.514 | 41.92 | 22.82 |
| 80 | 26 | 31 | 42.433 | 42.042 | 10.428 | 34.95 | 16.5 |
| 219 | 74 | 31 | 34.7 | 36.154 | 16.23 | 51.26 | 30.01 |
| 258 | 95 | 31 | 13.283 | 14.699 | 2.911 | 12.44 | 12.88 |
| 42 | 95 | 31 | 25.533 | 27.146 | 12.016 | 35.53 | 27.69 |
| 261 | 150 | 31 | 33.4 | 34.118 | 15.486 | 44.21 | 28.37 |
| 247 | 143 | 31 | 32.067 | 31.613 | 6.859 | 26.07 | 13.91 |
| 246 | 39 | 31 | 55.2 | 58.922 | 18.146 | 57.38 | 19.99 |
| 241 | 65 | 31 | 69.283 | 71.713 | 18.284 | 60.99 | 15.8 |
| 66 | 177 | 31 | 28.9 | 31.281 | 5.777 | 23.29 | 11.63 |
| 37 | 138 | 31 | 23.117 | 26.017 | 8.869 | 28.66 | 22.65 |
| 242 | 174 | 31 | 19.617 | 27.006 | 5.063 | 21.81 | 12.47 |
| 131 | 205 | 31 | 12.9 | 15.728 | 3.005 | 13.13 | 12.12 |
| 139 | 191 | 31 | 15.6 | 15.344 | 3.401 | 13.98 | 13.57 |
| 52 | 26 | 31 | 21.05 | 23.348 | 5.103 | 20.31 | 14.49 |
| 158 | 124 | 31 | 47.517 | 54.242 | 20.762 | 59.68 | 24.97 |
| 134 | 100 | 31 | 33.433 | 36.105 | 11.74 | 50.55 | 22.08 |
| 209 | 159 | 31 | 26.983 | 33.609 | 10.741 | 33.34 | 21.84 |
| 49 | 129 | 31 | 20.117 | 25.548 | 7.943 | 26.68 | 22.8 |
| 113 | 77 | 31 | 43.1 | 43.323 | 9.942 | 35.65 | 13.99 |
| 97 | 24 | 31 | 30.667 | 34.88 | 11.236 | 36 | 20.65 |
| 48 | 101 | 31 | 54.25 | 52.572 | 19.616 | 58.07 | 23.8 |
| 170 | 206 | 31 | 44.867 | 47.213 | 19.697 | 56.58 | 25.9 |
| 225 | 26 | 31 | 35.667 | 37.085 | 7.809 | 30.01 | 13.52 |