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 |
|---|---|---|---|---|---|---|---|
| 165 | 228 | 38 | 26.083 | 26.004 | 6.461 | 23.11 | 15.84 |
| 196 | 198 | 38 | 17.2 | 18.736 | 3.885 | 15.88 | 13.03 |
| 241 | 209 | 38 | 57.167 | 58.125 | 15.111 | 51.32 | 16.24 |
| 149 | 45 | 38 | 45.05 | 45.905 | 16.638 | 51.04 | 22.55 |
| 236 | 240 | 38 | 25.342 | 27.512 | 10.914 | 32.91 | 25.45 |
| 107 | 73 | 38 | 29.192 | 33.191 | 12.48 | 37.76 | 24.37 |
| 126 | 74 | 38 | 16.35 | 16.589 | 3.397 | 14.45 | 13.55 |
| 56 | 141 | 38 | 18.35 | 22.304 | 8.096 | 51.46 | 25.05 |
| 158 | 208 | 38 | 37.067 | 39.157 | 16.181 | 47.67 | 26.34 |
| 68 | 118 | 38 | 39.558 | 41.638 | 16.753 | 48.87 | 25.21 |
| 162 | 240 | 38 | 27.592 | 31.424 | 13.094 | 38.63 | 27.21 |
| 37 | 230 | 38 | 33.358 | 38.704 | 7.608 | 29.7 | 13.16 |
| 77 | 225 | 38 | 20.992 | 21.391 | 3.389 | 15.4 | 10.06 |
| 248 | 182 | 38 | 7.875 | 10.048 | 1.369 | 8.3 | 9.03 |
| 131 | 209 | 38 | 46.783 | 47.877 | 17.645 | 52.9 | 22.61 |
| 45 | 165 | 38 | 28.667 | 33.249 | 9.056 | 30.88 | 19.04 |
| 247 | 170 | 38 | 34.108 | 36.036 | 8.442 | 30.18 | 14.78 |
| 236 | 19 | 38 | 41.142 | 47.05 | 18.544 | 54.11 | 25.65 |
| 4 | 130 | 38 | 41.383 | 41.508 | 15.762 | 47.41 | 23.46 |
| 54 | 186 | 38 | 21.842 | 23.277 | 5.809 | 20.51 | 15.52 |
| 168 | 79 | 38 | 24.333 | 29.068 | 8.542 | 27.83 | 19.93 |
| 112 | 261 | 38 | 20.983 | 22.353 | 6.694 | 22.95 | 19.54 |
| 145 | 40 | 38 | 29.408 | 30.547 | 7.961 | 26.96 | 17.03 |
| 106 | 249 | 38 | 22.883 | 24.864 | 5.436 | 20.9 | 14.05 |
| 198 | 82 | 38 | 18.5 | 18.962 | 4.465 | 17.07 | 14.06 |