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 |
|---|---|---|---|---|---|---|---|
| 4 | 143 | 378 | 24.125 | 25.77 | 5.285 | 20.84 | 13.12 |
| 138 | 180 | 378 | 30.733 | 33.426 | 11.178 | 35.01 | 22.06 |
| 82 | 164 | 378 | 19.583 | 21.581 | 6.912 | 48.84 | 21.67 |
| 93 | 142 | 377 | 31.7 | 34.319 | 11.951 | 51.13 | 22.48 |
| 143 | 146 | 377 | 22.633 | 24.001 | 4.273 | 18.53 | 11.5 |
| 261 | 243 | 377 | 32.067 | 35.374 | 12.678 | 39.06 | 23.16 |
| 238 | 223 | 377 | 27.733 | 29.059 | 7.687 | 26.85 | 16.82 |
| 41 | 158 | 377 | 26.5 | 27.46 | 7.113 | 25.23 | 16.35 |
| 43 | 247 | 376 | 22.975 | 25.047 | 5.403 | 21.06 | 13.79 |
| 93 | 100 | 376 | 28.942 | 31.277 | 9.869 | 51.18 | 21.29 |
| 25 | 230 | 376 | 23.633 | 26.99 | 6.691 | 24.1 | 16.02 |
| 97 | 249 | 376 | 17.583 | 18.456 | 3.984 | 16.06 | 13.68 |
| 100 | 160 | 376 | 27.15 | 29.351 | 8.012 | 27.75 | 17.87 |
| 87 | 179 | 376 | 26.783 | 28.172 | 10.233 | 31.43 | 23.21 |
| 97 | 68 | 376 | 22.617 | 24.971 | 5.409 | 20.91 | 13.88 |
| 233 | 12 | 375 | 15.533 | 16.954 | 5.413 | 18.75 | 20.87 |
| 7 | 112 | 375 | 15.7 | 16.436 | 3.617 | 14.6 | 13.73 |
| 151 | 232 | 375 | 27.6 | 28.619 | 7.899 | 27.01 | 17.61 |
| 125 | 243 | 375 | 29.233 | 31.461 | 10.891 | 34.21 | 22.06 |
| 236 | 235 | 374 | 22.758 | 25.03 | 6.745 | 23.3 | 18.06 |
| 100 | 257 | 374 | 31.683 | 33.844 | 10.107 | 33.02 | 18.98 |
| 232 | 66 | 374 | 14.05 | 14.962 | 3.148 | 13.14 | 13.72 |
| 138 | 58 | 374 | 21.458 | 23.691 | 10.438 | 30.72 | 28.23 |
| 88 | 129 | 374 | 28.758 | 31.577 | 11.092 | 34.51 | 22.77 |
| 223 | 237 | 374 | 21.583 | 23.534 | 6.256 | 32.36 | 17.61 |