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 |
|---|---|---|---|---|---|---|---|
| 246 | 222 | 5 | 62.533 | 64.73 | 24.354 | 71.06 | 23.75 |
| 41 | 222 | 5 | 44.017 | 48.227 | 19.824 | 56.97 | 26.41 |
| 134 | 252 | 5 | 16.933 | 18.82 | 7.088 | 22.3 | 25 |
| 9 | 173 | 5 | 15.533 | 18.41 | 5.542 | 17.81 | 19.72 |
| 131 | 174 | 5 | 31.267 | 34.283 | 16.864 | 47.62 | 30.52 |
| 32 | 107 | 5 | 45.117 | 52.777 | 13.476 | 44.26 | 17.17 |
| 41 | 122 | 5 | 34.45 | 36.68 | 16.08 | 46.2 | 26.87 |
| 65 | 18 | 5 | 46.567 | 50.177 | 17.59 | 52.2 | 21.56 |
| 95 | 242 | 5 | 27.383 | 26.097 | 11.08 | 33.2 | 25.93 |
| 62 | 123 | 5 | 31.3 | 34.08 | 5.258 | 24.4 | 9.71 |
| 168 | 58 | 5 | 19.883 | 19.277 | 7.288 | 23.4 | 24.1 |
| 130 | 36 | 5 | 32.817 | 31.603 | 8.768 | 29.4 | 17.56 |
| 147 | 4 | 5 | 39.833 | 37.243 | 10.144 | 33.6 | 17.22 |
| 13 | 240 | 5 | 32.017 | 32.943 | 16.452 | 46.3 | 30.25 |
| 239 | 201 | 5 | 52.467 | 51.98 | 28.012 | 76.1 | 32.52 |
| 4 | 171 | 5 | 31.85 | 34.483 | 14.928 | 43.37 | 26.96 |
| 75 | 149 | 5 | 68.25 | 75.157 | 19.468 | 64.4 | 17.22 |
| 20 | 147 | 5 | 23.3 | 21.493 | 4.022 | 16.7 | 11.8 |
| 78 | 164 | 5 | 47.767 | 49.88 | 11.428 | 39.54 | 15.58 |
| 198 | 10 | 5 | 22.033 | 23.153 | 8.608 | 25.25 | 22.32 |
| 76 | 174 | 5 | 62.95 | 65.76 | 25.914 | 71.9 | 24.18 |
| 159 | 25 | 5 | 50.067 | 46.277 | 13.41 | 42.63 | 19.07 |
| 43 | 73 | 5 | 35.667 | 38.1 | 12.836 | 40.3 | 20.52 |
| 85 | 263 | 5 | 58.75 | 47.49 | 13.138 | 43.6 | 17.31 |
| 11 | 137 | 5 | 48 | 51.727 | 15.83 | 50.91 | 20.39 |