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 |
|---|---|---|---|---|---|---|---|
| 5 | 67 | 2 | 35.5 | 35.5 | 15.595 | 46 | 28.86 |
| 60 | 88 | 2 | 40.492 | 40.492 | 13.175 | 41 | 19.47 |
| 121 | 181 | 2 | 46.95 | 46.95 | 14.85 | 47.5 | 20.17 |
| 253 | 162 | 2 | 38.425 | 38.425 | 10.955 | 43.25 | 19.52 |
| 203 | 28 | 2 | 17.783 | 17.783 | 7.55 | 23.5 | 25.48 |
| 117 | 139 | 2 | 37.467 | 37.467 | 9.62 | 33.5 | 15.47 |
| 78 | 79 | 2 | 58.092 | 58.092 | 12.65 | 44.5 | 14.09 |
| 259 | 188 | 2 | 56.942 | 56.942 | 22.965 | 64.47 | 24.21 |
| 41 | 180 | 2 | 62.567 | 62.567 | 17.185 | 54.75 | 16.67 |
| 94 | 183 | 2 | 21.383 | 21.383 | 4.56 | 18.25 | 13.43 |
| 71 | 143 | 2 | 48.942 | 48.942 | 12.15 | 43 | 14.9 |
| 189 | 1 | 2 | 50.858 | 50.858 | 19.985 | 60.5 | 23.9 |
| 165 | 74 | 2 | 77.142 | 77.142 | 17.475 | 62.25 | 14.13 |
| 256 | 221 | 2 | 35.625 | 35.625 | 15.855 | 46.25 | 26.55 |
| 29 | 49 | 2 | 51.983 | 51.983 | 9.025 | 38 | 10.39 |
| 65 | 58 | 2 | 42.958 | 42.958 | 19.68 | 56.25 | 28.06 |
| 169 | 55 | 2 | 77.3 | 77.3 | 29.19 | 82.25 | 23.68 |
| 211 | 58 | 2 | 30.683 | 30.683 | 15.77 | 44.75 | 30.85 |
| 215 | 77 | 2 | 22.308 | 22.308 | 8.32 | 26.25 | 22.85 |
| 112 | 185 | 2 | 53.742 | 53.742 | 15.7 | 50.5 | 23.53 |
| 124 | 52 | 2 | 46.008 | 46.008 | 18.38 | 55.25 | 26.2 |
| 235 | 225 | 2 | 54.592 | 54.592 | 15.915 | 52.25 | 18.99 |
| 86 | 142 | 2 | 88.833 | 88.833 | 26.415 | 84 | 17.92 |
| 250 | 205 | 2 | 40.85 | 40.85 | 13.92 | 48.25 | 21.16 |
| 31 | 261 | 2 | 39.217 | 39.217 | 13.57 | 41.25 | 20.81 |