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 | 22 | 81 | 45.333 | 47.46 | 15.41 | 48 | 20.06 |
| 70 | 162 | 81 | 26.7 | 27.398 | 8.218 | 26.91 | 18.88 |
| 62 | 48 | 81 | 42.333 | 44.071 | 9.856 | 36.26 | 13.96 |
| 144 | 216 | 81 | 46.683 | 49.057 | 15.114 | 49.36 | 21.12 |
| 189 | 114 | 81 | 20.783 | 21.502 | 4.237 | 17.83 | 12.23 |
| 151 | 174 | 81 | 25.717 | 27.211 | 11.604 | 34.59 | 27 |
| 163 | 128 | 81 | 26.233 | 26.977 | 9.61 | 30.36 | 23 |
| 239 | 133 | 81 | 38.45 | 40.615 | 12.752 | 40.39 | 19.64 |
| 141 | 67 | 81 | 36.483 | 38.016 | 14.463 | 43.3 | 24.4 |
| 37 | 132 | 81 | 32.783 | 35.254 | 11.693 | 38.4 | 21.77 |
| 127 | 75 | 81 | 23.467 | 24.088 | 6.639 | 23.44 | 18.2 |
| 127 | 153 | 81 | 6.583 | 7.221 | 1.154 | 6.92 | 10.74 |
| 32 | 174 | 81 | 12.95 | 16.516 | 2.179 | 12.73 | 9.8 |
| 138 | 206 | 81 | 54.083 | 58.538 | 23.645 | 67.15 | 26.22 |
| 249 | 119 | 81 | 30.967 | 33.06 | 11.042 | 35.08 | 21.66 |
| 158 | 22 | 81 | 30.383 | 33.6 | 11.761 | 36.48 | 22.13 |
| 65 | 55 | 81 | 33.8 | 34.623 | 13.369 | 40.13 | 25 |
| 151 | 66 | 81 | 33.617 | 36.03 | 10.434 | 34.36 | 18.5 |
| 261 | 177 | 81 | 36.467 | 37.141 | 7.762 | 29.05 | 13.02 |
| 146 | 198 | 81 | 26.233 | 27.113 | 5.56 | 21.66 | 12.73 |
| 87 | 178 | 81 | 28.717 | 30.388 | 8.394 | 28.74 | 17.79 |
| 10 | 4 | 81 | 40.7 | 42.948 | 15.519 | 51.9 | 23.65 |
| 205 | 61 | 81 | 44.55 | 47.042 | 11.984 | 38.54 | 16.26 |
| 79 | 16 | 81 | 33.767 | 36.085 | 16.177 | 46.87 | 28.79 |
| 243 | 143 | 81 | 17.717 | 20.097 | 6.908 | 22.46 | 22.73 |