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 |
|---|---|---|---|---|---|---|---|
| 25 | 24 | 100 | 38.308 | 39.187 | 10.573 | 35.74 | 17.16 |
| 80 | 211 | 100 | 17.942 | 18.369 | 4.148 | 29.34 | 14.58 |
| 209 | 227 | 100 | 23.45 | 24.142 | 6.935 | 23.11 | 18.18 |
| 116 | 129 | 100 | 23.558 | 26.395 | 8.171 | 27.03 | 19.68 |
| 90 | 34 | 100 | 28.058 | 27.437 | 5.085 | 21.2 | 12.16 |
| 13 | 55 | 100 | 31.592 | 33.473 | 13.569 | 40.06 | 25.78 |
| 64 | 64 | 100 | 4.008 | 6.429 | 1.677 | 9.87 | 26.26 |
| 237 | 171 | 99 | 34.933 | 36.803 | 11.739 | 37.54 | 20.12 |
| 13 | 216 | 99 | 49.55 | 52.916 | 21.087 | 53.56 | 25.93 |
| 235 | 169 | 99 | 10.15 | 11.156 | 1.385 | 8.76 | 8.13 |
| 237 | 252 | 99 | 34.183 | 37.375 | 13.126 | 40.43 | 22.75 |
| 52 | 112 | 99 | 17.833 | 18.873 | 5.747 | 19.63 | 19.54 |
| 7 | 53 | 99 | 18.4 | 19.854 | 7.608 | 23.82 | 24.23 |
| 36 | 49 | 99 | 14.95 | 16.39 | 3.15 | 13.43 | 12.03 |
| 212 | 168 | 99 | 15.383 | 16.501 | 3.496 | 14.49 | 14.59 |
| 114 | 123 | 99 | 32.683 | 34.316 | 11.577 | 36.01 | 21.27 |
| 116 | 241 | 99 | 18.867 | 19.144 | 6.559 | 21.78 | 21.59 |
| 95 | 160 | 99 | 11.867 | 12.255 | 2.33 | 10.68 | 11.9 |
| 223 | 87 | 99 | 31.367 | 34.538 | 11.927 | 38.33 | 23.06 |
| 236 | 60 | 99 | 23.767 | 27.36 | 6.991 | 25.27 | 17.52 |
| 41 | 61 | 99 | 46.883 | 49.69 | 14.735 | 47.03 | 19.15 |
| 90 | 212 | 99 | 33.75 | 39.271 | 12.079 | 38.26 | 20.84 |
| 129 | 163 | 99 | 28.717 | 29.511 | 6.753 | 25.34 | 14.28 |
| 40 | 143 | 99 | 30.867 | 33.997 | 8.59 | 30.22 | 16.17 |
| 211 | 34 | 99 | 19.6 | 19.969 | 3.494 | 15.73 | 11.08 |