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 |
|---|---|---|---|---|---|---|---|
| 9 | 218 | 6 | 32.658 | 33.442 | 10.078 | 32.5 | 18.01 |
| 246 | 204 | 6 | 41.242 | 53.764 | 28.392 | 78.42 | 37.21 |
| 25 | 212 | 6 | 42.025 | 45.608 | 14.352 | 46.92 | 21.94 |
| 17 | 51 | 6 | 40.85 | 41.442 | 20.66 | 57.53 | 30.36 |
| 134 | 173 | 6 | 15.317 | 19.064 | 5.707 | 19.4 | 19.94 |
| 254 | 243 | 6 | 32.217 | 34.808 | 7.383 | 28.19 | 15.13 |
| 262 | 218 | 6 | 42.975 | 44.444 | 17.575 | 51.25 | 25.05 |
| 125 | 31 | 6 | 40.6 | 46.514 | 15.698 | 48.83 | 21.2 |
| 14 | 148 | 6 | 27.675 | 28.403 | 9.613 | 36 | 21.33 |
| 168 | 13 | 6 | 29.25 | 31.328 | 10.693 | 32.33 | 21.17 |
| 228 | 114 | 6 | 31.892 | 31.714 | 6.4 | 24.58 | 12.22 |
| 85 | 249 | 6 | 29.842 | 30.781 | 8.005 | 27.42 | 15.8 |
| 223 | 31 | 6 | 22.933 | 28.292 | 9.05 | 29.75 | 23.19 |
| 60 | 209 | 6 | 44.833 | 48.283 | 13.867 | 45.06 | 18.79 |
| 228 | 198 | 6 | 30.033 | 34.197 | 10.308 | 31.67 | 20.09 |
| 81 | 72 | 6 | 59.5 | 63.331 | 22.263 | 66.44 | 22.14 |
| 78 | 130 | 6 | 44.583 | 44.378 | 15.933 | 46.49 | 22.69 |
| 70 | 177 | 6 | 19.925 | 20.297 | 10.662 | 30.75 | 33.08 |
| 7 | 21 | 6 | 55.475 | 52.619 | 18.322 | 56.32 | 21.66 |
| 166 | 178 | 6 | 53.367 | 53.278 | 16.49 | 52.67 | 19.17 |
| 16 | 197 | 6 | 27.242 | 27.361 | 9.325 | 29.21 | 21.14 |
| 66 | 216 | 6 | 39.333 | 39.075 | 19.09 | 65.67 | 31.1 |
| 68 | 27 | 6 | 58.242 | 57.542 | 25.47 | 72.5 | 26.71 |
| 142 | 96 | 6 | 45.917 | 44.042 | 12.465 | 41.75 | 18.56 |
| 91 | 108 | 6 | 19.35 | 19.15 | 6.398 | 21.15 | 20.57 |