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 |
|---|---|---|---|---|---|---|---|
| 10 | 169 | 15 | 48.983 | 49.388 | 17.859 | 53.14 | 23.2 |
| 56 | 192 | 15 | 9.55 | 9.814 | 2.765 | 19.8 | 19.67 |
| 26 | 75 | 15 | 56.35 | 54.861 | 15.493 | 49.35 | 17.65 |
| 129 | 49 | 15 | 25.4 | 27.356 | 8.381 | 27.4 | 20.36 |
| 147 | 17 | 15 | 34.133 | 40.809 | 15.16 | 45.89 | 23.88 |
| 205 | 107 | 15 | 57.383 | 61.411 | 16.769 | 50.69 | 17.27 |
| 50 | 86 | 15 | 61.967 | 64.66 | 26.935 | 80.2 | 25.58 |
| 80 | 190 | 15 | 21.367 | 21.631 | 6.006 | 20.87 | 17.34 |
| 10 | 65 | 15 | 58.433 | 53.33 | 15.324 | 50.25 | 21.89 |
| 68 | 154 | 15 | 46.633 | 46.317 | 19.097 | 55.1 | 25.42 |
| 34 | 52 | 15 | 11.567 | 12.106 | 2.247 | 10.4 | 11.38 |
| 155 | 26 | 15 | 28.833 | 30.732 | 5.888 | 25.36 | 12.03 |
| 236 | 96 | 15 | 32.7 | 35.214 | 11.481 | 36.33 | 19.88 |
| 205 | 79 | 15 | 51.4 | 55.437 | 18.779 | 55.59 | 21.28 |
| 167 | 49 | 15 | 48.35 | 47.85 | 14.495 | 44.91 | 18.88 |
| 209 | 64 | 15 | 41.867 | 44.578 | 19.319 | 55.67 | 27.32 |
| 116 | 80 | 15 | 35.05 | 37.486 | 12.057 | 36.87 | 20.86 |
| 230 | 111 | 15 | 31.883 | 34.049 | 10.68 | 33.8 | 19.75 |
| 13 | 173 | 15 | 35.417 | 36.687 | 14.863 | 43.8 | 25.13 |
| 53 | 19 | 15 | 26.117 | 27.078 | 9.987 | 30.1 | 23.03 |
| 90 | 122 | 15 | 45.8 | 51.908 | 16.206 | 50.71 | 20.42 |
| 76 | 195 | 15 | 40.117 | 43.043 | 15.657 | 45.84 | 23.64 |
| 160 | 36 | 15 | 14 | 15.201 | 2.518 | 11.97 | 10.1 |
| 263 | 46 | 15 | 30.533 | 34.277 | 13.384 | 39.97 | 25.65 |
| 98 | 77 | 15 | 36.433 | 37.384 | 9.089 | 31.36 | 15.03 |