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 |
|---|---|---|---|---|---|---|---|
| 25 | 257 | 395 | 14.383 | 14.816 | 3.425 | 13.67 | 14.58 |
| 45 | 42 | 395 | 28.8 | 32.365 | 10.195 | 32.75 | 21.66 |
| 163 | 216 | 395 | 48.6 | 51.493 | 15.363 | 50.55 | 20.01 |
| 152 | 127 | 394 | 12.158 | 13.131 | 4.613 | 15.66 | 22.71 |
| 181 | 234 | 394 | 30.292 | 33.027 | 6.046 | 25.2 | 11.93 |
| 244 | 235 | 394 | 12.183 | 13.444 | 2.464 | 11.54 | 11.95 |
| 93 | 236 | 394 | 22.867 | 24.788 | 11.191 | 50.34 | 29.08 |
| 232 | 41 | 394 | 25.783 | 28.264 | 8.46 | 27.94 | 19.35 |
| 69 | 42 | 393 | 11.233 | 12.255 | 1.855 | 10.04 | 10.05 |
| 93 | 263 | 393 | 19.367 | 21.278 | 10.829 | 50.87 | 32.62 |
| 255 | 4 | 393 | 13.95 | 14.754 | 2.91 | 12.8 | 12.91 |
| 25 | 233 | 393 | 20.083 | 21.111 | 6.52 | 21.78 | 19.95 |
| 237 | 159 | 392 | 19.983 | 22.345 | 5.482 | 19.93 | 16.02 |
| 97 | 234 | 392 | 20.508 | 21.769 | 4.513 | 18.31 | 13.19 |
| 255 | 164 | 392 | 25.367 | 27.496 | 5.35 | 21.69 | 12.44 |
| 138 | 47 | 392 | 26.45 | 29.073 | 9.865 | 31.28 | 22.39 |
| 260 | 233 | 392 | 18.125 | 19.927 | 4.482 | 25.46 | 16.09 |
| 79 | 56 | 392 | 23.158 | 25.488 | 9.603 | 29.88 | 24.43 |
| 66 | 80 | 391 | 13.183 | 14.086 | 3.739 | 14.14 | 17.46 |
| 79 | 165 | 391 | 34.75 | 35.859 | 10.475 | 34.28 | 18.53 |
| 140 | 196 | 391 | 29.067 | 30.883 | 8.22 | 28.56 | 17.44 |
| 186 | 67 | 391 | 33.75 | 35.692 | 11.976 | 37.49 | 21.48 |
| 189 | 33 | 391 | 12.167 | 13.146 | 2.004 | 10.59 | 9.62 |
| 113 | 146 | 391 | 25.3 | 26.025 | 5.355 | 20.98 | 13.29 |
| 12 | 107 | 391 | 18.333 | 19.46 | 4.685 | 17.85 | 15.38 |