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 |
|---|---|---|---|---|---|---|---|
| 69 | 152 | 42 | 18.275 | 19.049 | 2.929 | 14.46 | 9.76 |
| 194 | 243 | 42 | 15.883 | 19.348 | 6.04 | 48.87 | 22.37 |
| 61 | 162 | 42 | 40.6 | 41.363 | 10.111 | 34.85 | 16.33 |
| 194 | 48 | 42 | 34.833 | 36.392 | 7.035 | 42.76 | 12.78 |
| 41 | 205 | 42 | 39.592 | 39.578 | 17.305 | 50.01 | 27.43 |
| 14 | 97 | 42 | 32.367 | 33.623 | 7.481 | 27.11 | 14.43 |
| 62 | 26 | 42 | 27.833 | 28.694 | 4.546 | 20.3 | 9.91 |
| 15 | 92 | 42 | 15.083 | 16.733 | 4.065 | 15.46 | 14.89 |
| 223 | 37 | 42 | 24.408 | 25.883 | 8.036 | 26.4 | 19.52 |
| 76 | 74 | 42 | 48.908 | 53.014 | 18.52 | 55 | 22.93 |
| 124 | 25 | 42 | 45.475 | 46.198 | 10.629 | 34.58 | 13.94 |
| 233 | 167 | 42 | 26.3 | 28.124 | 7.683 | 26.18 | 18.01 |
| 89 | 140 | 42 | 45.033 | 47.475 | 13.237 | 41.73 | 18.18 |
| 261 | 171 | 42 | 48.417 | 56.641 | 17.015 | 54.74 | 20.52 |
| 14 | 123 | 42 | 22.033 | 23.37 | 6.451 | 22.16 | 17.47 |
| 179 | 231 | 42 | 33.517 | 33.971 | 10.028 | 33.4 | 18.96 |
| 213 | 159 | 42 | 18.108 | 20.624 | 4.14 | 16.78 | 13.28 |
| 236 | 177 | 42 | 47.442 | 51.533 | 14.006 | 47.11 | 17.6 |
| 151 | 248 | 42 | 22.542 | 23.697 | 9.158 | 27.85 | 25.29 |
| 78 | 162 | 42 | 34.508 | 36.471 | 10.513 | 33.93 | 17.92 |
| 37 | 4 | 42 | 17.917 | 18.852 | 4.005 | 16.17 | 13.27 |
| 75 | 72 | 42 | 58.367 | 61.05 | 17.203 | 56.01 | 17.98 |
| 65 | 202 | 42 | 34.825 | 34.378 | 8.317 | 29.57 | 15.28 |
| 185 | 42 | 42 | 38.842 | 38.723 | 7.43 | 29.99 | 12.64 |
| 189 | 72 | 42 | 17.625 | 18.625 | 3.751 | 15.31 | 12.51 |