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 |
|---|---|---|---|---|---|---|---|
| 21 | 175 | 3 | 59.85 | 62.083 | 26.997 | 74.39 | 26.31 |
| 58 | 145 | 3 | 35.833 | 36.839 | 16.277 | 46.83 | 26.93 |
| 49 | 92 | 3 | 31.133 | 29.228 | 12.143 | 36 | 25.24 |
| 228 | 260 | 3 | 48.833 | 46.644 | 11.95 | 40.5 | 16.57 |
| 218 | 13 | 3 | 58.033 | 80.594 | 22.183 | 72.33 | 18.48 |
| 97 | 20 | 3 | 49.133 | 42.744 | 17.327 | 51.33 | 26.58 |
| 112 | 31 | 3 | 40.05 | 42.283 | 14.077 | 44 | 20.13 |
| 208 | 93 | 3 | 10.617 | 9.633 | 6.363 | 18.83 | 40.72 |
| 250 | 53 | 3 | 7.167 | 9.617 | 4.55 | 14.5 | 32.02 |
| 52 | 216 | 3 | 51.05 | 52.444 | 16.64 | 52 | 18.78 |
| 17 | 150 | 3 | 42.25 | 46.439 | 15.467 | 46.22 | 20.58 |
| 67 | 154 | 3 | 13.617 | 14.478 | 6.58 | 19.67 | 28.49 |
| 17 | 9 | 3 | 29.1 | 34.6 | 16.6 | 47.33 | 30.01 |
| 177 | 218 | 3 | 26.55 | 27.028 | 8.753 | 26.79 | 19.39 |
| 32 | 93 | 3 | 37.3 | 40.222 | 12.773 | 40.33 | 18.95 |
| 69 | 189 | 3 | 46.283 | 48.4 | 16.37 | 50.83 | 20.69 |
| 19 | 9 | 3 | 14.083 | 15.139 | 5.307 | 17.67 | 29.73 |
| 117 | 189 | 3 | 51.55 | 56.294 | 16.743 | 53.67 | 18.02 |
| 34 | 145 | 3 | 32.933 | 33.489 | 6.65 | 26.33 | 11.73 |
| 73 | 142 | 3 | 62.533 | 58.233 | 14.857 | 50.83 | 15.56 |
| 106 | 254 | 3 | 46.5 | 45.478 | 23.4 | 61.57 | 30.94 |
| 6 | 138 | 3 | 43.75 | 46.444 | 21.58 | 60.33 | 28.78 |
| 22 | 255 | 3 | 44.6 | 50.15 | 11.457 | 40.22 | 14.08 |
| 8 | 107 | 3 | 24.45 | 24.606 | 5.753 | 21.17 | 14.95 |
| 252 | 185 | 3 | 16.85 | 16.233 | 6.883 | 21 | 25.91 |