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 |
|---|---|---|---|---|---|---|---|
| 64 | 171 | 3 | 16.15 | 24.633 | 7.82 | 26.83 | 18.55 |
| 240 | 41 | 3 | 20.35 | 20.378 | 8.153 | 24.67 | 23.97 |
| 55 | 106 | 3 | 30.433 | 39.789 | 10.41 | 36.83 | 22.57 |
| 123 | 86 | 3 | 44.05 | 47.417 | 17.63 | 55.83 | 22.85 |
| 131 | 164 | 3 | 43.133 | 41.533 | 14.97 | 46.83 | 22.33 |
| 200 | 4 | 3 | 57.467 | 58.033 | 18.867 | 57.67 | 20.25 |
| 200 | 95 | 3 | 35.383 | 39.389 | 17.35 | 50.33 | 28.63 |
| 53 | 196 | 3 | 31.483 | 29.9 | 6.68 | 24.59 | 13.69 |
| 135 | 189 | 3 | 31.283 | 33.678 | 11.947 | 36.83 | 21.74 |
| 153 | 126 | 3 | 24.017 | 61.861 | 12.453 | 48.5 | 15.99 |
| 22 | 69 | 3 | 80.25 | 79.861 | 23.087 | 72.83 | 22.43 |
| 173 | 250 | 3 | 27.267 | 30.589 | 10.18 | 33 | 21.52 |
| 21 | 88 | 3 | 33.75 | 43.039 | 11.113 | 39 | 17.56 |
| 33 | 192 | 3 | 26.267 | 25.428 | 11.62 | 33.83 | 27.73 |
| 7 | 139 | 3 | 27.567 | 28.033 | 16.353 | 45.17 | 34.89 |
| 218 | 119 | 3 | 39.6 | 39.289 | 21.337 | 56.62 | 32.72 |
| 29 | 231 | 3 | 31.333 | 34.311 | 14.713 | 47 | 28.36 |
| 125 | 245 | 3 | 35.95 | 35.311 | 15.877 | 45.83 | 27.09 |
| 32 | 153 | 3 | 24.883 | 23.25 | 3.793 | 17.67 | 10.24 |
| 126 | 88 | 3 | 46.45 | 49.961 | 13.487 | 44.83 | 17.1 |
| 243 | 62 | 3 | 56.85 | 56.161 | 18.88 | 56.54 | 20.12 |
| 12 | 167 | 3 | 25.183 | 25.078 | 12.057 | 34.83 | 29.13 |
| 40 | 53 | 3 | 28.583 | 35.128 | 15.677 | 44.33 | 29.52 |
| 22 | 263 | 3 | 48.467 | 43.75 | 13.89 | 41.66 | 17.37 |
| 196 | 243 | 3 | 36.55 | 50.239 | 16.097 | 43.5 | 20.68 |