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 |
|---|---|---|---|---|---|---|---|
| 22 | 75 | 7 | 62.167 | 61.55 | 21.096 | 60.19 | 20.58 |
| 16 | 196 | 7 | 19.133 | 21.002 | 8.259 | 24.89 | 25.76 |
| 154 | 149 | 7 | 7.217 | 7.617 | 1.257 | 7.14 | 9.67 |
| 119 | 261 | 7 | 42.117 | 45.083 | 12.769 | 43.36 | 18.93 |
| 191 | 35 | 7 | 37.233 | 39.457 | 13.887 | 41.77 | 21.48 |
| 197 | 144 | 7 | 33.967 | 33.617 | 14.571 | 44.71 | 26.02 |
| 190 | 75 | 7 | 30.667 | 34.507 | 12.274 | 38.29 | 22.75 |
| 238 | 205 | 7 | 47.517 | 53.133 | 19.256 | 56.71 | 23.47 |
| 207 | 49 | 7 | 22.75 | 24.16 | 7.559 | 24.71 | 21.07 |
| 32 | 43 | 7 | 45.367 | 45.307 | 9.697 | 36.67 | 13.35 |
| 45 | 206 | 7 | 48.517 | 45.755 | 15.514 | 47.36 | 22.08 |
| 36 | 216 | 7 | 31.9 | 32.817 | 7.346 | 27.07 | 14.34 |
| 72 | 150 | 7 | 41.233 | 37 | 7.339 | 28.41 | 12.7 |
| 79 | 44 | 7 | 59.433 | 60.75 | 29.307 | 81.14 | 29.89 |
| 75 | 108 | 7 | 56.5 | 56.357 | 21.473 | 61.86 | 24.19 |
| 133 | 197 | 7 | 49.95 | 53.193 | 19.614 | 59.73 | 24.5 |
| 166 | 222 | 7 | 64.333 | 62.464 | 21.914 | 64.78 | 23.71 |
| 213 | 92 | 7 | 28.65 | 29.614 | 9.501 | 30.57 | 19.41 |
| 15 | 140 | 7 | 49.167 | 49.017 | 15.703 | 46.47 | 20.92 |
| 173 | 246 | 7 | 34.417 | 39.355 | 11.763 | 36.94 | 18.98 |
| 35 | 202 | 7 | 50.7 | 57.552 | 14.466 | 49.15 | 16.39 |
| 28 | 53 | 7 | 16.45 | 18.821 | 6.757 | 22 | 23.32 |
| 231 | 27 | 7 | 39.6 | 44.769 | 21.801 | 58.64 | 32.28 |
| 230 | 154 | 7 | 62 | 63.762 | 21.89 | 66.43 | 22.56 |
| 195 | 70 | 7 | 36.517 | 34.205 | 12.851 | 38.64 | 25.95 |