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 |
|---|---|---|---|---|---|---|---|
| 142 | 29 | 47 | 52.65 | 55.603 | 19.396 | 59.08 | 22.27 |
| 150 | 123 | 47 | 12.733 | 12.986 | 2.312 | 11.15 | 12.03 |
| 137 | 86 | 47 | 73.9 | 76.116 | 24.614 | 74.36 | 20.7 |
| 249 | 174 | 47 | 37.333 | 39.141 | 16.136 | 47.74 | 25.93 |
| 41 | 56 | 47 | 29.9 | 31.912 | 10.704 | 33.85 | 21.53 |
| 28 | 151 | 47 | 32.483 | 35.357 | 14.299 | 51.75 | 26.24 |
| 116 | 153 | 47 | 16.9 | 17.694 | 5.139 | 18.03 | 18.23 |
| 76 | 117 | 47 | 31.633 | 37.501 | 11.116 | 35.29 | 19.11 |
| 194 | 229 | 47 | 19.617 | 20.882 | 6.565 | 33.65 | 21.49 |
| 88 | 47 | 47 | 41.833 | 48.538 | 13.988 | 44.95 | 18.99 |
| 22 | 108 | 47 | 11.183 | 11.39 | 1.935 | 9.82 | 12.19 |
| 249 | 93 | 47 | 40.867 | 42.41 | 13.312 | 43.14 | 20.37 |
| 90 | 10 | 47 | 48.417 | 50.804 | 16.407 | 51.39 | 22.08 |
| 159 | 18 | 47 | 23.067 | 23.935 | 4.934 | 19.56 | 12.97 |
| 235 | 159 | 47 | 16.817 | 18.434 | 3.487 | 15.29 | 12.48 |
| 141 | 31 | 47 | 26.917 | 29.317 | 10.252 | 31.89 | 22.24 |
| 242 | 69 | 47 | 31.717 | 36.07 | 7.114 | 27.74 | 12.94 |
| 78 | 69 | 47 | 17.883 | 18.265 | 2.863 | 13.97 | 9.96 |
| 37 | 129 | 47 | 20.85 | 23.706 | 6.233 | 22.54 | 17.39 |
| 242 | 3 | 47 | 10.833 | 11.538 | 1.942 | 9.86 | 10.41 |
| 134 | 163 | 47 | 35.5 | 36.972 | 11.996 | 50.03 | 21.14 |
| 246 | 197 | 47 | 46.383 | 46.584 | 14.133 | 46.71 | 19.39 |
| 17 | 140 | 47 | 38.5 | 38.743 | 9.287 | 32.45 | 15.68 |
| 89 | 249 | 47 | 27.583 | 27.552 | 8.414 | 26.03 | 18.79 |
| 143 | 165 | 47 | 49.75 | 51.819 | 13.78 | 46.23 | 17.01 |