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 |
|---|---|---|---|---|---|---|---|
| 163 | 130 | 97 | 40.233 | 43.49 | 13.667 | 43.54 | 20.58 |
| 67 | 67 | 97 | 4.55 | 8.199 | 1.384 | 8.1 | 11.22 |
| 170 | 192 | 97 | 27.15 | 30.949 | 10.713 | 33.44 | 23.09 |
| 43 | 89 | 97 | 40.283 | 44.873 | 14.118 | 44.49 | 20.19 |
| 65 | 91 | 97 | 33.367 | 35.029 | 7.821 | 28.94 | 14 |
| 41 | 226 | 97 | 27.3 | 28.568 | 7.455 | 25.96 | 16.36 |
| 82 | 146 | 97 | 18.133 | 19.285 | 3.874 | 16.16 | 12.86 |
| 28 | 238 | 97 | 30.883 | 32.832 | 14.739 | 51.9 | 28.73 |
| 101 | 101 | 97 | 3.867 | 7.322 | 1.385 | 10.48 | 30.02 |
| 66 | 75 | 97 | 26.667 | 27.18 | 9.294 | 29.08 | 22.07 |
| 13 | 217 | 97 | 23.4 | 24.374 | 5.784 | 21.62 | 14.89 |
| 225 | 62 | 97 | 14.15 | 14.775 | 2.613 | 12.08 | 11.04 |
| 144 | 196 | 97 | 25.383 | 26.369 | 8.896 | 28.87 | 22.22 |
| 146 | 225 | 97 | 34.8 | 34.827 | 6.052 | 25.29 | 10.93 |
| 239 | 120 | 97 | 17.917 | 19.151 | 5.77 | 19.95 | 19.41 |
| 93 | 224 | 97 | 22.817 | 24.628 | 10.348 | 50.64 | 27.03 |
| 45 | 217 | 97 | 17.183 | 18.655 | 3.339 | 15.38 | 11.91 |
| 210 | 123 | 97 | 13.05 | 13.91 | 2.162 | 11.08 | 10.13 |
| 4 | 106 | 97 | 21.967 | 22.779 | 5.995 | 21.27 | 16.61 |
| 239 | 147 | 97 | 24.55 | 26.192 | 7.361 | 25.03 | 17.76 |
| 233 | 64 | 97 | 33.983 | 36.466 | 15.657 | 44.08 | 29.34 |
| 143 | 196 | 97 | 33.8 | 35.83 | 8.756 | 31.7 | 15.52 |
| 233 | 200 | 97 | 33.45 | 35.604 | 13.18 | 39.99 | 24.29 |
| 246 | 160 | 97 | 29.917 | 31.579 | 8.757 | 30.03 | 17.66 |
| 116 | 136 | 97 | 18.017 | 18.337 | 4.876 | 17.69 | 16.67 |