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 |
|---|---|---|---|---|---|---|---|
| 225 | 14 | 23 | 40.233 | 40.556 | 10.417 | 35.59 | 16.28 |
| 260 | 224 | 23 | 13.517 | 15.881 | 5.637 | 43.83 | 23.32 |
| 10 | 167 | 23 | 42.867 | 42.838 | 16.998 | 47.74 | 24.96 |
| 211 | 39 | 23 | 51.967 | 51.164 | 14.113 | 46.26 | 17.83 |
| 40 | 244 | 23 | 39 | 39.901 | 15.062 | 45.39 | 24.05 |
| 162 | 251 | 23 | 40.133 | 42.483 | 18.948 | 53.96 | 27.3 |
| 32 | 159 | 23 | 19.75 | 23.328 | 6.073 | 21.95 | 17.2 |
| 77 | 25 | 23 | 38.233 | 39.194 | 5.968 | 26.23 | 9.47 |
| 161 | 176 | 23 | 51.933 | 56.257 | 21.567 | 63.26 | 23.73 |
| 100 | 46 | 23 | 40.983 | 46.604 | 18.568 | 55.16 | 25.95 |
| 146 | 18 | 23 | 41.783 | 41.096 | 11.409 | 38.83 | 18.29 |
| 70 | 192 | 23 | 11.1 | 12.842 | 3.993 | 14.57 | 22.08 |
| 98 | 175 | 23 | 3.633 | 6.209 | 1.626 | 10.01 | 23.37 |
| 74 | 150 | 23 | 64.717 | 66.134 | 25.702 | 74.87 | 24.02 |
| 40 | 223 | 23 | 24.683 | 27.143 | 11.603 | 33.78 | 27.22 |
| 37 | 106 | 23 | 21.483 | 25.378 | 5.637 | 21.52 | 15.14 |
| 24 | 130 | 23 | 44.433 | 45.449 | 15.171 | 46.61 | 20.62 |
| 98 | 131 | 23 | 8.033 | 7.317 | 1.581 | 7.78 | 18.8 |
| 127 | 24 | 23 | 15.133 | 17.067 | 6.109 | 19.83 | 22.91 |
| 72 | 26 | 23 | 31 | 31.612 | 4.879 | 20.27 | 9.57 |
| 261 | 254 | 23 | 48.133 | 48.788 | 18.627 | 55.33 | 24.37 |
| 158 | 28 | 23 | 41.4 | 46.225 | 15.075 | 46.76 | 21.7 |
| 17 | 90 | 23 | 29.667 | 30.807 | 6.103 | 23.57 | 13.24 |
| 90 | 98 | 23 | 38.733 | 41.079 | 14.31 | 44.24 | 22.32 |
| 228 | 11 | 23 | 13.983 | 20.461 | 7.019 | 24.52 | 24.16 |