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 |
|---|---|---|---|---|---|---|---|
| 114 | 221 | 13 | 34.1 | 36.26 | 14.683 | 43.58 | 25.67 |
| 39 | 92 | 13 | 34.617 | 40.553 | 14.086 | 41.93 | 22.06 |
| 49 | 166 | 13 | 42.283 | 46.121 | 13.458 | 43.96 | 18.97 |
| 24 | 225 | 13 | 45.783 | 47.399 | 12.783 | 42.02 | 17.2 |
| 209 | 254 | 13 | 44.767 | 52.303 | 17.838 | 53.35 | 23.81 |
| 142 | 201 | 13 | 61.083 | 64.899 | 25.958 | 75.35 | 24.52 |
| 192 | 130 | 13 | 20.717 | 21.773 | 4.288 | 17.73 | 12.3 |
| 43 | 175 | 13 | 44.483 | 51.438 | 16.844 | 51.35 | 21.68 |
| 219 | 80 | 13 | 40.683 | 41.388 | 13.118 | 41.23 | 21.2 |
| 143 | 178 | 13 | 53.9 | 55.418 | 13.731 | 47.46 | 15.65 |
| 137 | 23 | 13 | 39.117 | 46.186 | 20.174 | 58.12 | 28.3 |
| 243 | 125 | 13 | 30.783 | 31.729 | 10.775 | 34.15 | 21.38 |
| 127 | 249 | 13 | 24.467 | 29.331 | 11.174 | 34.88 | 24.4 |
| 127 | 78 | 13 | 23.783 | 23.945 | 3.828 | 17.65 | 10.25 |
| 171 | 7 | 13 | 20.417 | 21.667 | 6.757 | 22.83 | 19.27 |
| 81 | 87 | 13 | 47.9 | 52.395 | 20.344 | 58.77 | 25.18 |
| 35 | 210 | 13 | 27.45 | 29.281 | 7.204 | 25.83 | 14.87 |
| 113 | 81 | 13 | 39.483 | 44.745 | 17.212 | 51.31 | 24.85 |
| 174 | 137 | 13 | 52.283 | 50.538 | 15.257 | 47.87 | 20.76 |
| 106 | 76 | 13 | 39.233 | 43.462 | 9.099 | 33.56 | 12.72 |
| 234 | 122 | 13 | 39.633 | 42.308 | 16.55 | 49.27 | 25.02 |
| 144 | 53 | 13 | 48.7 | 48.74 | 14.445 | 47.04 | 20.29 |
| 215 | 203 | 13 | 19.167 | 19.195 | 5.833 | 19.74 | 18.72 |
| 161 | 207 | 13 | 30.567 | 33.319 | 8.052 | 29.08 | 15.66 |
| 45 | 174 | 13 | 53.75 | 53.885 | 17.525 | 54.96 | 21.47 |