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 |
|---|---|---|---|---|---|---|---|
| 147 | 13 | 2 | 44 | 44 | 13.57 | 42 | 19.46 |
| 239 | 109 | 2 | 71.842 | 71.842 | 26.315 | 78.5 | 22.84 |
| 12 | 126 | 2 | 53.342 | 53.342 | 14.615 | 48.5 | 18.65 |
| 52 | 108 | 2 | 33.392 | 33.392 | 11.52 | 37 | 21.27 |
| 59 | 119 | 2 | 16.4 | 16.4 | 2.595 | 12.25 | 9.46 |
| 60 | 184 | 2 | 32.175 | 32.175 | 10.735 | 33 | 20.4 |
| 126 | 165 | 2 | 57.825 | 57.825 | 21.375 | 62.75 | 22.21 |
| 185 | 256 | 2 | 41.55 | 41.55 | 17.47 | 53.25 | 27.24 |
| 45 | 5 | 2 | 40.692 | 40.692 | 23.975 | 64.5 | 35.35 |
| 135 | 20 | 2 | 39.317 | 39.317 | 14.24 | 44.25 | 21.72 |
| 98 | 232 | 2 | 40.417 | 40.417 | 15.45 | 45.02 | 22.95 |
| 219 | 22 | 2 | 32.117 | 32.117 | 17.41 | 47.25 | 43.59 |
| 64 | 167 | 2 | 30.125 | 30.125 | 13.07 | 38.5 | 27.95 |
| 85 | 4 | 2 | 34.483 | 34.483 | 11.79 | 35.75 | 19.6 |
| 42 | 149 | 2 | 57.117 | 57.117 | 23.18 | 65.75 | 24.27 |
| 192 | 77 | 2 | 31.083 | 31.083 | 8.76 | 30.5 | 17.4 |
| 112 | 150 | 2 | 31.125 | 31.125 | 18.355 | 49.75 | 36.86 |
| 86 | 68 | 2 | 71.15 | 71.15 | 28.26 | 80.75 | 25.17 |
| 6 | 137 | 2 | 28.35 | 28.35 | 10.545 | 31.25 | 21.37 |
| 96 | 48 | 2 | 37.85 | 37.85 | 10.69 | 44.25 | 17.19 |
| 197 | 114 | 2 | 43.808 | 43.808 | 13.385 | 52 | 23.72 |
| 195 | 56 | 2 | 33.033 | 33.033 | 12.405 | 37.75 | 24.38 |
| 19 | 15 | 2 | 14.683 | 14.683 | 6.585 | 19.77 | 26.92 |
| 151 | 6 | 2 | 48.425 | 48.425 | 21.04 | 60.75 | 27.27 |
| 33 | 115 | 2 | 25.733 | 25.733 | 10.42 | 31.75 | 24.88 |