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 |
|---|---|---|---|---|---|---|---|
| 37 | 171 | 3 | 23.583 | 30.583 | 9.803 | 31.33 | 20.98 |
| 153 | 138 | 3 | 35.4 | 36.144 | 13.297 | 40 | 24.24 |
| 57 | 196 | 3 | 17.417 | 15.217 | 2.95 | 13 | 12.55 |
| 17 | 151 | 3 | 29.833 | 31.722 | 11.343 | 35.33 | 21.64 |
| 135 | 117 | 3 | 51.583 | 51.433 | 13.82 | 46.5 | 16.07 |
| 250 | 25 | 3 | 53.433 | 57.372 | 17.487 | 55.33 | 18.72 |
| 102 | 125 | 3 | 52.85 | 52.822 | 9.047 | 36.67 | 10.28 |
| 52 | 214 | 3 | 24.25 | 22.733 | 11.28 | 32.5 | 30.94 |
| 147 | 141 | 3 | 28.433 | 25.372 | 6.823 | 22.83 | 17.52 |
| 155 | 86 | 3 | 36.75 | 36.667 | 12.293 | 38.33 | 20.12 |
| 61 | 111 | 3 | 25.467 | 28.717 | 3.317 | 19.67 | 9.49 |
| 241 | 181 | 3 | 42.333 | 52.417 | 21.053 | 60.83 | 25.84 |
| 42 | 52 | 3 | 32.65 | 44.194 | 13.25 | 41.67 | 19.67 |
| 206 | 172 | 3 | 28.967 | 27.206 | 6.597 | 23 | 14.76 |
| 168 | 216 | 3 | 26.417 | 29.606 | 16.363 | 45.33 | 33.86 |
| 101 | 93 | 3 | 43.983 | 35.05 | 10.307 | 35.33 | 18.99 |
| 20 | 81 | 3 | 13.733 | 14.311 | 3.37 | 13.22 | 14.52 |
| 121 | 25 | 3 | 52.4 | 60.572 | 13.213 | 46.35 | 13.53 |
| 155 | 63 | 3 | 34.9 | 33.528 | 6.96 | 25.72 | 13.09 |
| 59 | 61 | 3 | 62.333 | 60.578 | 20.367 | 62.17 | 20.45 |
| 69 | 123 | 3 | 69.5 | 73.433 | 23.1 | 70.83 | 19 |
| 22 | 114 | 3 | 43.717 | 43.9 | 12.077 | 40.5 | 16.63 |
| 93 | 175 | 3 | 16.3 | 19.206 | 6.9 | 23 | 27.26 |
| 191 | 148 | 3 | 42.8 | 40.817 | 17.56 | 50.33 | 27.49 |
| 152 | 6 | 3 | 41.7 | 41.65 | 19.597 | 55 | 28.25 |