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 |
|---|---|---|---|---|---|---|---|
| 25 | 161 | 518 | 20.442 | 23.577 | 6.78 | 23.21 | 18.83 |
| 65 | 229 | 518 | 20.192 | 21.371 | 6.55 | 21.89 | 19.98 |
| 43 | 256 | 518 | 31.067 | 32.056 | 7.559 | 27.89 | 14.78 |
| 61 | 49 | 518 | 8.108 | 9.487 | 1.567 | 8.39 | 10.61 |
| 17 | 256 | 518 | 7.075 | 8.289 | 1.439 | 7.66 | 11.67 |
| 249 | 133 | 517 | 24.2 | 26.097 | 8.303 | 26.88 | 20.19 |
| 107 | 198 | 517 | 28.8 | 30.838 | 7.493 | 26.77 | 15.76 |
| 196 | 95 | 516 | 7.092 | 8.424 | 1.641 | 8.61 | 11.72 |
| 107 | 257 | 516 | 28.292 | 29.648 | 8.973 | 29.23 | 19.29 |
| 232 | 239 | 516 | 27.417 | 28.683 | 6.617 | 24.44 | 14.61 |
| 37 | 17 | 516 | 9.067 | 10.371 | 1.643 | 8.78 | 10.55 |
| 48 | 159 | 516 | 26.725 | 28.928 | 8.546 | 28.45 | 21.68 |
| 69 | 69 | 515 | 5.017 | 7.65 | 1.191 | 7.67 | 24.73 |
| 113 | 198 | 515 | 29.467 | 31.7 | 7.308 | 26.79 | 14.73 |
| 256 | 181 | 515 | 20.4 | 21.635 | 5.007 | 19.1 | 14.93 |
| 232 | 74 | 515 | 20.567 | 22.748 | 7.651 | 24.48 | 22.12 |
| 137 | 188 | 515 | 36 | 38.411 | 9.301 | 32.74 | 15.54 |
| 7 | 202 | 515 | 8.067 | 8.798 | 1.812 | 9.14 | 13.26 |
| 195 | 195 | 515 | 4.333 | 9.342 | 2.11 | 10.47 | 34.72 |
| 232 | 142 | 514 | 26.367 | 27.834 | 5.755 | 22.61 | 13.44 |
| 142 | 89 | 514 | 40.717 | 43.395 | 12.511 | 40.88 | 18.26 |
| 158 | 225 | 514 | 33.192 | 34.127 | 7.191 | 27.3 | 13.09 |
| 189 | 25 | 514 | 8.325 | 9.135 | 1.296 | 7.87 | 8.91 |
| 97 | 228 | 513 | 18.133 | 19.154 | 4.167 | 16.79 | 13.4 |
| 97 | 137 | 513 | 19.067 | 19.748 | 5.188 | 18.81 | 16.9 |