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 |
|---|---|---|---|---|---|---|---|
| 167 | 71 | 2 | 72.517 | 72.517 | 21.35 | 68.5 | 21.09 |
| 20 | 137 | 2 | 38.367 | 38.367 | 12.64 | 38.5 | 19.87 |
| 217 | 71 | 2 | 17.483 | 17.483 | 4.75 | 16.75 | 16.3 |
| 254 | 63 | 2 | 76.967 | 76.967 | 22.185 | 67.64 | 20.06 |
| 32 | 49 | 2 | 62.4 | 62.4 | 20.82 | 62.75 | 20.23 |
| 203 | 250 | 2 | 18.625 | 18.625 | 15.09 | 40.25 | 48.62 |
| 261 | 99 | 2 | 35.283 | 35.283 | 18.885 | 53.5 | 32.09 |
| 39 | 96 | 2 | 18.75 | 18.75 | 5.095 | 19.64 | 16.33 |
| 226 | 6 | 2 | 33.25 | 33.25 | 16.875 | 47 | 31.26 |
| 73 | 15 | 2 | 17.208 | 17.208 | 2.805 | 13.5 | 10.43 |
| 116 | 29 | 2 | 75.367 | 75.367 | 25.805 | 76 | 20.7 |
| 18 | 53 | 2 | 38.217 | 38.217 | 10.445 | 34 | 16.43 |
| 156 | 207 | 2 | 43.392 | 43.392 | 24.285 | 66.25 | 34.61 |
| 210 | 246 | 2 | 25.967 | 25.967 | 10.125 | 31.5 | 18.38 |
| 193 | 38 | 2 | 52.55 | 52.55 | 18.83 | 57 | 22.3 |
| 160 | 96 | 2 | 6.983 | 6.983 | 2.43 | 9.25 | 20.8 |
| 224 | 117 | 2 | 66.717 | 66.717 | 29.865 | 84.5 | 26.89 |
| 112 | 213 | 2 | 24.917 | 24.917 | 12.175 | 34.5 | 29.45 |
| 203 | 233 | 2 | 65 | 65 | 20.195 | 56.5 | 19.46 |
| 222 | 11 | 2 | 27.217 | 27.217 | 10.88 | 33.17 | 24 |
| 128 | 229 | 2 | 28 | 28 | 10.32 | 32.5 | 23.91 |
| 126 | 33 | 2 | 69.383 | 69.383 | 14.905 | 48.8 | 13.12 |
| 33 | 203 | 2 | 61.075 | 61.075 | 21.705 | 62.25 | 26.72 |
| 173 | 253 | 2 | 3.025 | 3.025 | 1.105 | 5.25 | 22 |
| 120 | 143 | 2 | 24.558 | 24.558 | 7.125 | 24.75 | 17.28 |