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 |
|---|---|---|---|---|---|---|---|
| 127 | 20 | 17 | 17.817 | 17.327 | 2.786 | 13.44 | 10.2 |
| 123 | 186 | 17 | 53.35 | 55.419 | 12.615 | 44.76 | 13.75 |
| 261 | 201 | 17 | 36.967 | 39.863 | 21.911 | 59.62 | 34.61 |
| 127 | 120 | 17 | 9.417 | 9.002 | 1.971 | 13.3 | 13.98 |
| 167 | 4 | 17 | 35.767 | 37.375 | 10.442 | 33.77 | 17.39 |
| 235 | 97 | 17 | 47.75 | 50.653 | 16.235 | 50.19 | 20.53 |
| 72 | 203 | 17 | 35.05 | 39.901 | 12.881 | 41.1 | 20.53 |
| 90 | 3 | 17 | 38.567 | 39.311 | 16.307 | 47.79 | 25.87 |
| 51 | 145 | 17 | 46.7 | 48.836 | 13.889 | 42.15 | 17.33 |
| 5 | 14 | 17 | 36.683 | 43.434 | 17.363 | 52.97 | 26.37 |
| 182 | 247 | 17 | 23.267 | 24.189 | 5.267 | 20.02 | 15.18 |
| 261 | 64 | 17 | 40.717 | 42.425 | 20.521 | 57.06 | 29.62 |
| 40 | 42 | 17 | 29.1 | 32.809 | 13.009 | 38.59 | 25.76 |
| 90 | 64 | 17 | 47.133 | 48.273 | 17.704 | 52.94 | 24.57 |
| 162 | 59 | 17 | 34.117 | 38.033 | 10.318 | 34.71 | 17.42 |
| 28 | 191 | 17 | 15.583 | 17.597 | 5.483 | 18.56 | 18.66 |
| 212 | 231 | 17 | 52.533 | 57.59 | 13.946 | 46.87 | 15.61 |
| 40 | 165 | 17 | 25.667 | 26.086 | 6.022 | 22.41 | 14.18 |
| 64 | 101 | 17 | 9.217 | 9.014 | 2.164 | 9.41 | 16.06 |
| 152 | 37 | 17 | 41.383 | 43.469 | 14.288 | 44.9 | 20.23 |
| 90 | 118 | 17 | 54.117 | 51.866 | 20.536 | 63 | 24.88 |
| 28 | 218 | 17 | 22.15 | 21.716 | 4.42 | 17.13 | 12.61 |
| 4 | 216 | 17 | 42.3 | 49.243 | 15.239 | 50.97 | 21.84 |
| 143 | 205 | 17 | 53.367 | 58.881 | 19.424 | 59.44 | 20.37 |
| 129 | 25 | 17 | 31.983 | 31.738 | 9.301 | 30.68 | 20.71 |