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 |
|---|---|---|---|---|---|---|---|
| 162 | 6 | 21 | 40.083 | 43.759 | 16.971 | 49.55 | 24.58 |
| 119 | 236 | 21 | 24.617 | 27.802 | 5.339 | 21.74 | 12.45 |
| 225 | 236 | 21 | 46.733 | 45.125 | 10.849 | 36 | 15.28 |
| 68 | 23 | 21 | 39.95 | 44.003 | 20.118 | 58.1 | 29.06 |
| 55 | 162 | 21 | 48.55 | 49.024 | 17.859 | 52.61 | 22.21 |
| 188 | 113 | 21 | 40.917 | 46.329 | 7.47 | 31.08 | 10.41 |
| 137 | 219 | 21 | 52.533 | 53.934 | 16.38 | 51.09 | 20.62 |
| 20 | 241 | 21 | 12.55 | 15.495 | 2.109 | 11.76 | 9.08 |
| 173 | 226 | 21 | 20.467 | 21.123 | 4.92 | 21.9 | 14.76 |
| 141 | 219 | 21 | 42.8 | 51.858 | 17.52 | 53.44 | 24.26 |
| 191 | 107 | 21 | 34.3 | 39.153 | 16.944 | 47.47 | 27.38 |
| 239 | 29 | 21 | 45.333 | 52.747 | 20.272 | 58.9 | 24.31 |
| 106 | 67 | 21 | 17.45 | 16.862 | 4.75 | 17.36 | 18.37 |
| 17 | 164 | 21 | 42.033 | 40.403 | 8.208 | 31.8 | 12.9 |
| 39 | 79 | 21 | 49.533 | 52.152 | 19.928 | 59.04 | 24.54 |
| 11 | 165 | 21 | 22.517 | 25.337 | 3.434 | 17.36 | 8.81 |
| 24 | 242 | 21 | 33 | 33.286 | 10.127 | 32.62 | 19.2 |
| 70 | 87 | 21 | 40.2 | 39.972 | 14.506 | 43.24 | 23.82 |
| 227 | 97 | 21 | 28.117 | 29.804 | 5.424 | 22.36 | 11.27 |
| 247 | 81 | 21 | 22.85 | 24.714 | 9.373 | 29.33 | 24.33 |
| 134 | 231 | 21 | 36.367 | 38.844 | 14.381 | 50.64 | 24.15 |
| 51 | 237 | 21 | 61.15 | 52.072 | 14.086 | 44.47 | 18.66 |
| 188 | 52 | 21 | 21.183 | 23.327 | 4.032 | 17.88 | 11.16 |
| 8 | 166 | 21 | 18.183 | 19.449 | 5.001 | 50.45 | 16.39 |
| 88 | 1 | 21 | 50.067 | 47.317 | 15.442 | 77.29 | 22.17 |