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 |
|---|---|---|---|---|---|---|---|
| 12 | 77 | 1 | 48.767 | 48.767 | 9.34 | 36 | 11.49 |
| 248 | 95 | 1 | 21.1 | 21.1 | 9.77 | 29 | 27.78 |
| 205 | 143 | 1 | 84.05 | 84.05 | 24.1 | 75.5 | 17.2 |
| 26 | 111 | 1 | 5.033 | 5.033 | 0.84 | 5.5 | 10.01 |
| 168 | 155 | 1 | 39.3 | 39.3 | 26.07 | 69 | 39.8 |
| 135 | 18 | 1 | 57.483 | 57.483 | 16.63 | 51 | 17.36 |
| 256 | 111 | 1 | 17.3 | 17.3 | 7.6 | 23.5 | 26.36 |
| 124 | 73 | 1 | 41.667 | 41.667 | 11.8 | 41 | 16.99 |
| 83 | 222 | 1 | 33.067 | 33.067 | 16.76 | 47 | 30.41 |
| 192 | 240 | 1 | 57.55 | 57.55 | 13.58 | 46.5 | 14.16 |
| 47 | 251 | 1 | 66.25 | 66.25 | 28.69 | 81.5 | 25.98 |
| 150 | 205 | 1 | 27.75 | 27.75 | 15.24 | 54.21 | 32.95 |
| 93 | 242 | 1 | 21.117 | 21.117 | 8.1 | 24 | 23.01 |
| 61 | 127 | 1 | 62.95 | 62.95 | 23.19 | 68.5 | 22.1 |
| 101 | 24 | 1 | 42.733 | 42.733 | 20.91 | 57.71 | 29.36 |
| 214 | 245 | 1 | 21.167 | 21.167 | 5.6 | 20 | 15.87 |
| 241 | 197 | 1 | 33.717 | 33.717 | 19.8 | 55 | 35.23 |
| 206 | 32 | 1 | 109.833 | 109.833 | 34.84 | 109 | 19.03 |
| 2 | 68 | 1 | 12.183 | 12.183 | 1.63 | 9.5 | 8.03 |
| 153 | 88 | 1 | 31.65 | 31.65 | 15.5 | 43.5 | 29.38 |
| 54 | 94 | 1 | 48 | 48 | 16.92 | 50 | 21.15 |
| 112 | 15 | 1 | 29.383 | 29.383 | 14.98 | 41.5 | 30.59 |
| 210 | 59 | 1 | 109.367 | 109.367 | 28.81 | 88 | 15.81 |
| 5 | 170 | 1 | 85.95 | 85.95 | 28.25 | 83.5 | 19.72 |
| 124 | 34 | 1 | 34.017 | 34.017 | 17.37 | 48 | 30.64 |