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 |
|---|---|---|---|---|---|---|---|
| 216 | 51 | 3 | 53.533 | 49.494 | 18.623 | 49.51 | 23.41 |
| 125 | 203 | 3 | 45.983 | 44.783 | 21.077 | 59.83 | 28.36 |
| 31 | 47 | 3 | 37.167 | 40.317 | 4.107 | 25.67 | 6.76 |
| 31 | 262 | 3 | 24.817 | 23.256 | 7.853 | 25 | 21.64 |
| 160 | 73 | 3 | 17.733 | 19.061 | 5.967 | 20.5 | 19.26 |
| 17 | 122 | 3 | 31.75 | 42.206 | 13.773 | 41.9 | 22.72 |
| 36 | 67 | 3 | 37.8 | 40.283 | 10.57 | 36.59 | 16.14 |
| 166 | 139 | 3 | 36.883 | 37.939 | 22.493 | 58.42 | 36.12 |
| 20 | 35 | 3 | 80.117 | 72.75 | 22.92 | 70.33 | 20.3 |
| 86 | 154 | 3 | 59.217 | 60.267 | 28.907 | 80.17 | 29.1 |
| 153 | 232 | 3 | 47.45 | 42.706 | 14.12 | 44 | 21.28 |
| 46 | 46 | 3 | 2.133 | 13.606 | 2.397 | 11 | 10.88 |
| 136 | 162 | 3 | 21.55 | 34.617 | 10.193 | 31.27 | 22.68 |
| 102 | 234 | 3 | 42.733 | 42.167 | 9.06 | 33 | 13 |
| 210 | 52 | 3 | 40.5 | 34.917 | 12.143 | 32.85 | 22.91 |
| 150 | 206 | 3 | 60.6 | 70.761 | 15.367 | 59.33 | 13.45 |
| 70 | 18 | 3 | 38.083 | 46.922 | 12.56 | 45.5 | 17.25 |
| 106 | 169 | 3 | 34.7 | 41.389 | 18.923 | 53.17 | 28.65 |
| 128 | 119 | 3 | 18.8 | 19.217 | 3.713 | 16.18 | 12.48 |
| 2 | 161 | 3 | 29.2 | 30 | 11.933 | 39.17 | 21.91 |
| 63 | 217 | 3 | 39.767 | 38.867 | 7.733 | 30.17 | 12.11 |
| 135 | 17 | 3 | 32.683 | 33.194 | 11.173 | 33.02 | 21.04 |
| 200 | 86 | 3 | 72.8 | 69.767 | 28.507 | 77.33 | 25.09 |
| 117 | 69 | 3 | 63.433 | 75.144 | 26.417 | 75.36 | 22.02 |
| 60 | 223 | 3 | 29.6 | 23.939 | 6.25 | 22.97 | 18.2 |