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 |
|---|---|---|---|---|---|---|---|
| 32 | 97 | 5 | 52.883 | 52.693 | 18.506 | 55.82 | 23.55 |
| 240 | 164 | 5 | 38.65 | 38.463 | 13.43 | 41 | 21.08 |
| 126 | 94 | 5 | 24.15 | 22.613 | 4.78 | 19.1 | 13.06 |
| 144 | 221 | 5 | 38.333 | 35.677 | 14.164 | 41.9 | 24.2 |
| 254 | 85 | 5 | 71.417 | 70.103 | 27.188 | 73.64 | 24.19 |
| 177 | 182 | 5 | 33.883 | 33.877 | 16.39 | 45.46 | 29.22 |
| 29 | 100 | 5 | 64.983 | 69.01 | 16.334 | 55.65 | 15.5 |
| 42 | 190 | 5 | 41.317 | 37.47 | 14.328 | 42.4 | 24.11 |
| 91 | 79 | 5 | 62.217 | 58.103 | 10.992 | 40.68 | 12.57 |
| 26 | 163 | 5 | 63.833 | 63.63 | 12.384 | 48.3 | 11.87 |
| 224 | 154 | 5 | 30.85 | 37.057 | 19.452 | 53.6 | 35.62 |
| 20 | 48 | 5 | 60.683 | 65.797 | 13.976 | 52.28 | 14.93 |
| 69 | 70 | 5 | 19.633 | 21.4 | 8.614 | 26.8 | 24.42 |
| 93 | 96 | 5 | 10.517 | 15.167 | 5.232 | 15.4 | 32.28 |
| 153 | 87 | 5 | 43.083 | 40.593 | 15.566 | 46 | 24.13 |
| 12 | 235 | 5 | 60.567 | 59.267 | 15.36 | 51.3 | 19.4 |
| 32 | 166 | 5 | 31.567 | 37.177 | 10.478 | 35.6 | 18.55 |
| 47 | 234 | 5 | 41.85 | 44.533 | 11.86 | 39.8 | 16.85 |
| 126 | 138 | 5 | 18.3 | 18.633 | 7.68 | 23.9 | 25.97 |
| 124 | 90 | 5 | 54.967 | 57.57 | 15.852 | 53.7 | 17.46 |
| 49 | 173 | 5 | 37.35 | 40.517 | 11.318 | 36.35 | 17.62 |
| 39 | 164 | 5 | 73.567 | 64.013 | 17.86 | 54.02 | 18.16 |
| 210 | 233 | 5 | 47.083 | 50.57 | 20.064 | 56.87 | 24.85 |
| 38 | 95 | 5 | 28.217 | 28.2 | 10.886 | 33.61 | 23.26 |
| 128 | 237 | 5 | 38 | 33.883 | 9.136 | 31.4 | 17.26 |