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 |
|---|---|---|---|---|---|---|---|
| 89 | 144 | 9 | 32.85 | 32.344 | 7.118 | 26.16 | 14.19 |
| 178 | 132 | 9 | 38.783 | 43.241 | 17.9 | 52.88 | 28.46 |
| 98 | 192 | 9 | 10.433 | 10.417 | 2.222 | 10.22 | 13.08 |
| 62 | 216 | 9 | 33.05 | 35.991 | 9.17 | 31.67 | 15.67 |
| 249 | 84 | 9 | 46 | 48.307 | 24.807 | 68.56 | 31.34 |
| 225 | 246 | 9 | 34.483 | 36.48 | 8.729 | 30.84 | 14.56 |
| 37 | 54 | 9 | 17.483 | 19.817 | 5.417 | 18.83 | 17.36 |
| 50 | 6 | 9 | 33.833 | 41.744 | 16.403 | 49.92 | 25.77 |
| 123 | 67 | 9 | 17.5 | 20.631 | 4.404 | 17.94 | 13.38 |
| 83 | 219 | 9 | 29.417 | 29.556 | 11.544 | 34.55 | 23.94 |
| 147 | 254 | 9 | 22.167 | 24.167 | 7.528 | 25.56 | 20.3 |
| 249 | 27 | 9 | 53.167 | 56.987 | 23.412 | 67.61 | 27.25 |
| 72 | 249 | 9 | 52.5 | 52.183 | 9.871 | 36.48 | 12.02 |
| 111 | 26 | 9 | 7.817 | 7.911 | 1.67 | 8.11 | 13.32 |
| 145 | 220 | 9 | 26.417 | 27.97 | 13.233 | 38.11 | 29.13 |
| 142 | 6 | 9 | 42.117 | 43.917 | 17.564 | 51.33 | 24.72 |
| 124 | 20 | 9 | 57.35 | 55.724 | 20.773 | 62 | 23.02 |
| 43 | 63 | 9 | 43.3 | 51.089 | 16.028 | 50.67 | 20.08 |
| 197 | 236 | 9 | 34.717 | 35.561 | 14.262 | 49.22 | 25.5 |
| 190 | 71 | 9 | 13.55 | 14.002 | 2.813 | 11.94 | 12.21 |
| 14 | 229 | 9 | 40.55 | 43.167 | 13.649 | 42.24 | 21.22 |
| 238 | 27 | 9 | 63.05 | 74.191 | 28.61 | 86.44 | 24.31 |
| 42 | 131 | 9 | 33.883 | 37.739 | 16.127 | 47.28 | 28.55 |
| 10 | 18 | 9 | 37.333 | 44.517 | 19.374 | 56.06 | 28.99 |
| 82 | 218 | 9 | 35.833 | 39.863 | 11.518 | 37.89 | 19.89 |