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 |
|---|---|---|---|---|---|---|---|
| 255 | 136 | 1 | 31.867 | 31.867 | 15.54 | 44 | 29.26 |
| 180 | 150 | 1 | 26.35 | 26.35 | 11.54 | 35.5 | 26.28 |
| 39 | 98 | 1 | 33.667 | 33.667 | 13.1 | 40 | 23.35 |
| 2 | 66 | 1 | 34.9 | 34.9 | 19.5 | 53.5 | 33.52 |
| 206 | 169 | 1 | 71.1 | 71.1 | 28.68 | 82 | 24.2 |
| 220 | 10 | 1 | 70.95 | 70.95 | 21.98 | 65.5 | 18.59 |
| 32 | 55 | 1 | 57.933 | 57.933 | 37.88 | 79.73 | 39.23 |
| 9 | 246 | 1 | 45.933 | 45.933 | 15 | 45 | 19.59 |
| 4 | 139 | 1 | 46.983 | 46.983 | 22.3 | 60 | 28.48 |
| 240 | 180 | 1 | 56.417 | 56.417 | 21.65 | 61.5 | 23.03 |
| 15 | 6 | 1 | 54.9 | 54.9 | 39.04 | 102.5 | 42.67 |
| 15 | 144 | 1 | 58.917 | 58.917 | 16.81 | 54.5 | 17.12 |
| 81 | 176 | 1 | 61.917 | 61.917 | 36.34 | 96.5 | 35.22 |
| 258 | 55 | 1 | 27.783 | 27.783 | 14.44 | 41.5 | 31.18 |
| 155 | 197 | 1 | 19.783 | 19.783 | 6.71 | 22 | 20.35 |
| 76 | 204 | 1 | 66.25 | 66.25 | 30.1 | 80.5 | 27.26 |
| 26 | 136 | 1 | 63.017 | 63.017 | 23.18 | 69.95 | 22.07 |
| 183 | 165 | 1 | 67.167 | 67.167 | 25.2 | 76 | 22.51 |
| 218 | 162 | 1 | 40.95 | 40.95 | 17.65 | 50 | 25.86 |
| 19 | 107 | 1 | 30.583 | 30.583 | 22 | 58.5 | 43.16 |
| 128 | 1 | 1 | 50.1 | 50.1 | 25.96 | 52 | 31.09 |
| 70 | 178 | 1 | 54.8 | 54.8 | 23.49 | 65.5 | 25.72 |
| 49 | 15 | 1 | 38.933 | 38.933 | 16.71 | 48 | 25.75 |
| 183 | 7 | 1 | 19.083 | 19.083 | 10.45 | 28.85 | 32.86 |
| 26 | 66 | 1 | 33.8 | 33.8 | 11.7 | 37 | 20.77 |