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 |
|---|---|---|---|---|---|---|---|
| 260 | 20 | 8 | 24.617 | 27.054 | 12.098 | 35.44 | 28.1 |
| 55 | 164 | 8 | 55.2 | 57.463 | 18.376 | 56.43 | 20.27 |
| 191 | 225 | 8 | 43.508 | 39.91 | 14.129 | 42.44 | 22.21 |
| 123 | 137 | 8 | 41.717 | 44.525 | 13.287 | 41.06 | 18.85 |
| 114 | 206 | 8 | 39.683 | 46.192 | 17.22 | 51.81 | 23.72 |
| 258 | 32 | 8 | 32.133 | 32.619 | 16.594 | 44.79 | 30.77 |
| 159 | 61 | 8 | 48.425 | 47.044 | 16.418 | 50.88 | 21.74 |
| 14 | 190 | 8 | 25.867 | 28.175 | 7.435 | 26.39 | 16.66 |
| 252 | 173 | 8 | 14.4 | 17.431 | 4.462 | 17.06 | 19.05 |
| 51 | 188 | 8 | 54.142 | 54.592 | 23.78 | 66.38 | 26.33 |
| 242 | 142 | 8 | 41.367 | 42.067 | 12.481 | 35.62 | 18.31 |
| 256 | 135 | 8 | 19.65 | 20.156 | 9.636 | 28.12 | 29.34 |
| 77 | 124 | 8 | 16.8 | 17.333 | 3.316 | 14.44 | 11.82 |
| 239 | 77 | 8 | 51.733 | 53.204 | 17.354 | 53.85 | 21.09 |
| 11 | 29 | 8 | 14.533 | 14.327 | 3.279 | 13.75 | 14.83 |
| 40 | 74 | 8 | 31 | 32.5 | 11.801 | 36.06 | 22.47 |
| 211 | 242 | 8 | 40.558 | 41.515 | 16.203 | 48.75 | 24.59 |
| 72 | 198 | 8 | 26.483 | 30.508 | 4.74 | 21.69 | 10.08 |
| 192 | 160 | 8 | 17.442 | 22.387 | 4.711 | 19.06 | 14.56 |
| 229 | 38 | 8 | 44.517 | 60.398 | 20.242 | 63.6 | 24.42 |
| 25 | 175 | 8 | 71.033 | 65.242 | 15.309 | 52.75 | 15.72 |
| 85 | 191 | 8 | 58.967 | 61.131 | 17.295 | 53.48 | 17.45 |
| 65 | 242 | 8 | 44.417 | 46.756 | 18.136 | 52.73 | 24.69 |
| 7 | 31 | 8 | 30.842 | 31.275 | 10.843 | 34.06 | 21.35 |
| 77 | 100 | 8 | 61.908 | 58.219 | 14.748 | 50.92 | 15.59 |