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 |
|---|---|---|---|---|---|---|---|
| 149 | 42 | 2 | 58.233 | 58.233 | 26.585 | 74 | 27.58 |
| 91 | 211 | 2 | 55 | 55 | 8.53 | 38.75 | 9.36 |
| 14 | 131 | 2 | 66.342 | 66.342 | 25.03 | 67.28 | 23.41 |
| 200 | 89 | 2 | 45.967 | 45.967 | 20.83 | 59.25 | 27.19 |
| 224 | 73 | 2 | 41.417 | 41.417 | 13.085 | 41.75 | 24.86 |
| 207 | 227 | 2 | 39.192 | 39.192 | 12.575 | 55.5 | 25.01 |
| 51 | 147 | 2 | 17.075 | 17.075 | 7.535 | 22.75 | 26.49 |
| 119 | 145 | 2 | 28.25 | 28.25 | 7.63 | 25.75 | 16.22 |
| 94 | 132 | 2 | 35.283 | 35.283 | 23.275 | 62.25 | 39.89 |
| 44 | 99 | 2 | 3.717 | 3.717 | 3.385 | 10.75 | 54.65 |
| 67 | 106 | 2 | 23.392 | 23.392 | 4.555 | 18.75 | 13.68 |
| 85 | 66 | 2 | 35.933 | 35.933 | 8.845 | 25.75 | 15.25 |
| 80 | 245 | 2 | 32.508 | 32.508 | 17.565 | 48 | 33.79 |
| 21 | 18 | 2 | 72.65 | 72.65 | 26.965 | 78.25 | 25.88 |
| 180 | 25 | 2 | 51.333 | 51.333 | 10.05 | 35.81 | 11.81 |
| 192 | 116 | 2 | 44.758 | 44.758 | 12.605 | 39 | 17.22 |
| 71 | 242 | 2 | 63.942 | 63.942 | 20.955 | 65.5 | 19.66 |
| 203 | 147 | 2 | 48.258 | 48.258 | 20.595 | 59.25 | 25.72 |
| 117 | 100 | 2 | 67.908 | 67.908 | 23.945 | 73.25 | 21.2 |
| 14 | 51 | 2 | 69.667 | 69.667 | 34.865 | 100.78 | 31.24 |
| 131 | 262 | 2 | 28.683 | 28.683 | 9.73 | 29.5 | 20.65 |
| 200 | 64 | 2 | 42.183 | 42.183 | 20.835 | 58.5 | 33.41 |
| 133 | 147 | 2 | 37.567 | 37.567 | 19.66 | 54.5 | 33.02 |
| 71 | 78 | 2 | 55.583 | 55.583 | 20.76 | 56.8 | 22.37 |
| 177 | 115 | 2 | 67.592 | 67.592 | 21.195 | 73.5 | 21.32 |