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 |
|---|---|---|---|---|---|---|---|
| 7 | 215 | 30 | 27.892 | 29.422 | 11.066 | 33.72 | 25.29 |
| 33 | 260 | 30 | 19.417 | 20.928 | 7.668 | 24.09 | 23.85 |
| 95 | 107 | 30 | 32.2 | 33.017 | 9.449 | 35.42 | 18.07 |
| 65 | 250 | 30 | 44.033 | 43.959 | 16.792 | 47.2 | 24.37 |
| 26 | 150 | 30 | 32.633 | 32.755 | 6.95 | 26.26 | 13.06 |
| 22 | 210 | 30 | 20.783 | 19.96 | 4.965 | 18.27 | 15.92 |
| 97 | 123 | 30 | 34.658 | 34.539 | 9.298 | 32.13 | 16.67 |
| 174 | 146 | 30 | 42.767 | 42.623 | 11.63 | 39.05 | 17.54 |
| 246 | 242 | 30 | 37.133 | 39.92 | 14.237 | 43.52 | 23.34 |
| 82 | 60 | 30 | 42.817 | 44.827 | 10.432 | 37.8 | 15.22 |
| 20 | 235 | 30 | 17.692 | 17.893 | 2.65 | 13.48 | 9.17 |
| 101 | 191 | 30 | 12.492 | 13.452 | 4.201 | 14.93 | 19.01 |
| 93 | 82 | 30 | 12.492 | 16.548 | 4.238 | 22.52 | 20.49 |
| 195 | 133 | 30 | 11.208 | 13.006 | 3.735 | 15.77 | 22.26 |
| 179 | 148 | 30 | 26.542 | 27.614 | 7.926 | 27.1 | 19.75 |
| 257 | 227 | 30 | 10.8 | 11.606 | 2.26 | 10.22 | 12.94 |
| 188 | 186 | 30 | 35.35 | 34.149 | 8.491 | 29.4 | 15.43 |
| 45 | 259 | 30 | 38.183 | 43.179 | 18.613 | 53.65 | 28.45 |
| 145 | 218 | 30 | 62.517 | 58.509 | 13.636 | 45.33 | 16.26 |
| 90 | 194 | 30 | 29.408 | 30.799 | 8.508 | 28.35 | 17.99 |
| 158 | 126 | 30 | 34.875 | 36.084 | 13.636 | 41.62 | 23.86 |
| 130 | 65 | 30 | 48.85 | 48.429 | 14.766 | 46.62 | 20.59 |
| 247 | 220 | 30 | 18.683 | 18.643 | 5.692 | 19.99 | 20.17 |
| 224 | 82 | 30 | 18.967 | 22.251 | 7.66 | 24.81 | 23.2 |
| 66 | 244 | 30 | 30.967 | 33.474 | 14.348 | 41.72 | 27.95 |