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 |
|---|---|---|---|---|---|---|---|
| 66 | 178 | 9 | 20.717 | 21.096 | 7.784 | 24.78 | 23.26 |
| 183 | 235 | 9 | 36.817 | 36.007 | 7.808 | 28.59 | 15.65 |
| 22 | 17 | 9 | 49.5 | 49.015 | 9.646 | 38.06 | 12.38 |
| 135 | 173 | 9 | 20.85 | 23.5 | 5.697 | 19.79 | 15.19 |
| 260 | 217 | 9 | 21.083 | 19.643 | 5.156 | 17.94 | 17.69 |
| 225 | 143 | 9 | 59.317 | 58.074 | 10.179 | 41.94 | 10.77 |
| 28 | 171 | 9 | 19.617 | 19.585 | 6.297 | 20.9 | 19.37 |
| 200 | 164 | 9 | 42.767 | 44.011 | 13.329 | 44.78 | 18.65 |
| 4 | 21 | 9 | 35.567 | 40.613 | 12.902 | 39.95 | 22.16 |
| 39 | 36 | 9 | 34.617 | 33.428 | 5.727 | 24.39 | 10.69 |
| 95 | 144 | 9 | 40.417 | 44.515 | 10.499 | 36.83 | 15.38 |
| 212 | 132 | 9 | 24.483 | 25.17 | 16.017 | 43.28 | 38.57 |
| 173 | 42 | 9 | 21.7 | 24.131 | 9.548 | 29.5 | 24.87 |
| 77 | 26 | 9 | 33.167 | 42.652 | 12.077 | 40.64 | 19.06 |
| 191 | 97 | 9 | 68.75 | 62.252 | 17.288 | 54.53 | 17.88 |
| 61 | 54 | 9 | 19.767 | 19.641 | 3.687 | 15.56 | 11.57 |
| 25 | 218 | 9 | 57.533 | 53.352 | 15.363 | 51.16 | 18.38 |
| 134 | 37 | 9 | 22.65 | 23.243 | 6.962 | 23.33 | 18.44 |
| 158 | 117 | 9 | 50.683 | 54.9 | 26.358 | 72.78 | 29.58 |
| 14 | 236 | 9 | 45.167 | 45.63 | 15.723 | 47.63 | 22.43 |
| 137 | 115 | 9 | 29.267 | 32.107 | 15.717 | 44.33 | 30.55 |
| 39 | 169 | 9 | 70.433 | 76.783 | 26.918 | 80.44 | 22.25 |
| 161 | 187 | 9 | 54.567 | 55.787 | 21.267 | 65.11 | 24.59 |
| 89 | 11 | 9 | 22.4 | 24.031 | 5.196 | 19.74 | 13.25 |
| 14 | 86 | 9 | 53.883 | 56.704 | 23.502 | 67.79 | 26.21 |