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 |
|---|---|---|---|---|---|---|---|
| 247 | 25 | 15 | 37.367 | 44.06 | 14.464 | 45.22 | 21.92 |
| 168 | 39 | 15 | 49.817 | 49.259 | 21.325 | 60.87 | 26.92 |
| 152 | 195 | 15 | 49.35 | 45.803 | 15.016 | 46.2 | 20.07 |
| 10 | 122 | 15 | 16.1 | 17.12 | 3.827 | 15.3 | 14.07 |
| 252 | 7 | 15 | 29.517 | 29.44 | 9.022 | 29.55 | 20.4 |
| 147 | 212 | 15 | 11.1 | 11.662 | 2.164 | 10.3 | 11.62 |
| 142 | 222 | 15 | 57.15 | 60.636 | 21.237 | 64.7 | 21.92 |
| 101 | 92 | 15 | 23.817 | 28.676 | 10.85 | 33.34 | 23.39 |
| 7 | 106 | 15 | 32.483 | 34.653 | 10.874 | 34.5 | 20.27 |
| 50 | 122 | 15 | 45.167 | 48.318 | 17.787 | 53.93 | 23.65 |
| 147 | 78 | 15 | 16.033 | 16.359 | 2.584 | 12.97 | 10.41 |
| 193 | 222 | 15 | 36.133 | 35.478 | 17.121 | 47.13 | 29.52 |
| 183 | 183 | 15 | 2.133 | 4.056 | 0.451 | 8.61 | 11.13 |
| 3 | 142 | 15 | 33.467 | 35.57 | 16.211 | 45.68 | 29.31 |
| 106 | 127 | 15 | 44.95 | 49.167 | 17.956 | 53.63 | 22.76 |
| 259 | 168 | 15 | 29.65 | 34.678 | 10.093 | 32.29 | 20.08 |
| 116 | 36 | 15 | 37.35 | 39.602 | 14.442 | 42.35 | 22.27 |
| 13 | 63 | 15 | 46.317 | 48.536 | 11.148 | 39.33 | 14.11 |
| 125 | 63 | 15 | 44.233 | 47.29 | 12.183 | 41.73 | 16.24 |
| 126 | 60 | 15 | 11.233 | 12.831 | 2.09 | 10.53 | 10.85 |
| 191 | 117 | 15 | 37.933 | 39.35 | 14.901 | 45.97 | 23.48 |
| 155 | 161 | 15 | 60.967 | 57.767 | 23.399 | 66.14 | 25.12 |
| 131 | 76 | 15 | 33.683 | 31.751 | 9.299 | 30.54 | 18.56 |
| 56 | 134 | 15 | 16.167 | 18.446 | 4.046 | 16.97 | 15.7 |
| 216 | 165 | 15 | 36.267 | 36.642 | 13.07 | 40.24 | 22.44 |