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 |
|---|---|---|---|---|---|---|---|
| 250 | 41 | 20 | 32.2 | 34.881 | 7.625 | 28.24 | 14.27 |
| 186 | 96 | 20 | 34.992 | 38.299 | 10.991 | 36.52 | 19.09 |
| 181 | 160 | 20 | 27.567 | 27.862 | 8.72 | 28.05 | 20.22 |
| 85 | 49 | 20 | 18.467 | 21.157 | 3.127 | 15.59 | 10.5 |
| 54 | 100 | 20 | 18.633 | 20.569 | 7.035 | 22.65 | 21.83 |
| 121 | 73 | 20 | 10.175 | 12.708 | 2.268 | 12.15 | 12.13 |
| 24 | 198 | 20 | 34.733 | 38.422 | 12.134 | 38.52 | 19.4 |
| 9 | 252 | 20 | 15.292 | 15.483 | 4.732 | 16.57 | 18.45 |
| 45 | 134 | 20 | 50.217 | 52.541 | 14.256 | 47.2 | 17.93 |
| 209 | 117 | 20 | 61.242 | 69.382 | 26.373 | 77.6 | 24.19 |
| 139 | 209 | 20 | 53.192 | 52.842 | 22.358 | 63.5 | 46.53 |
| 48 | 115 | 20 | 41.742 | 41.58 | 17.661 | 53.3 | 26.08 |
| 47 | 126 | 20 | 12.683 | 13.806 | 2.654 | 11.88 | 12.42 |
| 92 | 157 | 20 | 20.992 | 21.455 | 6.454 | 22.12 | 19.61 |
| 23 | 101 | 20 | 50.525 | 56.17 | 34.802 | 92.3 | 38.74 |
| 220 | 152 | 20 | 21.833 | 24.579 | 6.594 | 22.93 | 17.18 |
| 234 | 109 | 20 | 56.192 | 55.398 | 22.239 | 64.28 | 24.44 |
| 62 | 138 | 20 | 36.942 | 37.041 | 11.808 | 36.71 | 21.15 |
| 125 | 258 | 20 | 54.008 | 52.822 | 12.377 | 43.14 | 15.85 |
| 158 | 173 | 20 | 34.467 | 42.662 | 11.54 | 38.48 | 17.91 |
| 33 | 108 | 20 | 24.567 | 25.587 | 11.862 | 34.33 | 30.41 |
| 218 | 76 | 20 | 19.708 | 21.697 | 7.271 | 23.17 | 21.4 |
| 178 | 21 | 20 | 9.133 | 9.245 | 1.577 | 8.38 | 10.88 |
| 131 | 98 | 20 | 8.967 | 10.125 | 2.041 | 9.65 | 13.03 |
| 35 | 218 | 20 | 30.525 | 30.672 | 9.135 | 30.34 | 18.84 |