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 |
|---|---|---|---|---|---|---|---|
| 48 | 9 | 51 | 37.933 | 42.876 | 15.059 | 46.5 | 23.19 |
| 4 | 217 | 51 | 15.217 | 16.269 | 3.172 | 14.09 | 12.4 |
| 236 | 91 | 51 | 57.767 | 61.276 | 17.777 | 56.69 | 18.6 |
| 94 | 94 | 51 | 5 | 5.992 | 1.109 | 7.71 | 72.59 |
| 129 | 215 | 51 | 24.167 | 27.158 | 9.474 | 30.05 | 23.45 |
| 40 | 62 | 51 | 17.283 | 17.891 | 3.148 | 14 | 11.06 |
| 139 | 203 | 51 | 10.117 | 10.412 | 1.643 | 9.6 | 9.86 |
| 256 | 95 | 51 | 21.933 | 23.101 | 7.724 | 25.19 | 21.87 |
| 113 | 171 | 51 | 55.167 | 56.128 | 14.585 | 48.57 | 17.07 |
| 223 | 93 | 51 | 12.217 | 15.436 | 5.653 | 19.46 | 27.41 |
| 193 | 262 | 51 | 15.15 | 15.256 | 3.639 | 14.85 | 15.23 |
| 74 | 95 | 51 | 28.65 | 30.235 | 10.929 | 33.74 | 24.62 |
| 97 | 244 | 51 | 37.867 | 40.58 | 14.532 | 44.29 | 23.14 |
| 262 | 20 | 51 | 26.983 | 29.056 | 8.887 | 29.1 | 20.23 |
| 74 | 83 | 51 | 19.533 | 20.814 | 7.332 | 23.48 | 22.75 |
| 35 | 107 | 51 | 62.067 | 62.579 | 9.362 | 42.07 | 9.37 |
| 235 | 136 | 51 | 8.283 | 8.762 | 1.327 | 8.59 | 12.19 |
| 216 | 45 | 51 | 48.433 | 51.167 | 16.278 | 50.95 | 20.62 |
| 50 | 190 | 51 | 35.783 | 38.545 | 9.546 | 33.49 | 15.7 |
| 179 | 255 | 51 | 21.267 | 22.701 | 5.865 | 21.22 | 16.73 |
| 113 | 147 | 51 | 30.617 | 35.392 | 9.775 | 33.03 | 18.49 |
| 216 | 161 | 51 | 49.3 | 48.723 | 13.923 | 50.3 | 17.82 |
| 165 | 88 | 51 | 30.05 | 34.602 | 9.1 | 30.86 | 16.82 |
| 209 | 130 | 51 | 61.683 | 60.305 | 16.653 | 53.53 | 21.53 |
| 168 | 61 | 51 | 51.467 | 51.701 | 14.605 | 47.39 | 18.08 |