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 |
|---|---|---|---|---|---|---|---|
| 261 | 18 | 25 | 45.317 | 48.822 | 16.754 | 51.39 | 22.41 |
| 195 | 37 | 25 | 26.667 | 30.805 | 7.073 | 24.71 | 14.99 |
| 143 | 218 | 25 | 86.75 | 87.161 | 18.063 | 69.96 | 12.58 |
| 34 | 112 | 25 | 14.067 | 15.122 | 3.436 | 13.66 | 14.54 |
| 263 | 252 | 25 | 32.383 | 32.859 | 13.326 | 39.46 | 25.95 |
| 212 | 169 | 25 | 18.683 | 20.557 | 4.36 | 16.75 | 14.19 |
| 7 | 64 | 25 | 27.45 | 31.565 | 14.062 | 40.31 | 29.39 |
| 43 | 76 | 25 | 50.05 | 53.513 | 17.694 | 54.77 | 21.73 |
| 207 | 223 | 25 | 5.283 | 7.941 | 1.195 | 8.48 | 16.44 |
| 114 | 182 | 25 | 35.267 | 36.949 | 14.62 | 43.4 | 24.73 |
| 54 | 230 | 25 | 21.333 | 27.031 | 7.044 | 24.86 | 18.11 |
| 247 | 208 | 25 | 19.833 | 24.118 | 8.511 | 26.28 | 24.04 |
| 230 | 176 | 25 | 54.867 | 58.139 | 23.505 | 69.3 | 24.81 |
| 203 | 197 | 25 | 28.317 | 27.263 | 7.849 | 23.69 | 18.36 |
| 137 | 118 | 25 | 42.55 | 43.756 | 18.896 | 53.98 | 26.5 |
| 13 | 31 | 25 | 41.433 | 43.761 | 17.05 | 50.2 | 25.05 |
| 188 | 210 | 25 | 26.35 | 26.917 | 5.634 | 21.57 | 12.96 |
| 155 | 230 | 25 | 59.433 | 62.273 | 23.947 | 70.18 | 24.03 |
| 88 | 109 | 25 | 45.667 | 46.79 | 19.399 | 56.08 | 25.66 |
| 100 | 19 | 25 | 39.733 | 46.583 | 17.828 | 53.25 | 24.72 |
| 152 | 226 | 25 | 34.4 | 34.915 | 8.652 | 30.39 | 15.69 |
| 219 | 41 | 25 | 44.183 | 46.782 | 16.11 | 52.02 | 22.72 |
| 219 | 197 | 25 | 19.7 | 20.915 | 5.823 | 20.52 | 18.36 |
| 208 | 197 | 25 | 29.783 | 30.68 | 12.049 | 34.09 | 23.86 |
| 210 | 230 | 25 | 57.767 | 58.653 | 19.634 | 58.67 | 20.98 |