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 |
|---|---|---|---|---|---|---|---|
| 96 | 197 | 1 | 2.817 | 2.817 | 0.77 | 4.5 | 16.4 |
| 93 | 251 | 1 | 19.583 | 19.583 | 14.84 | 52 | 45.47 |
| 23 | 11 | 1 | 19.867 | 19.867 | 10.35 | 29.5 | 31.26 |
| 31 | 107 | 1 | 84.383 | 84.383 | 11.4 | 54.5 | 8.11 |
| 63 | 142 | 1 | 49.3 | 49.3 | 19.91 | 58 | 24.23 |
| 210 | 179 | 1 | 39.217 | 39.217 | 23.77 | 63.5 | 36.37 |
| 20 | 240 | 1 | 26.85 | 26.85 | 3.68 | 18.5 | 8.22 |
| 167 | 34 | 1 | 50.433 | 50.433 | 14 | 46.5 | 16.66 |
| 120 | 107 | 1 | 33.633 | 33.633 | 9.84 | 31.5 | 17.55 |
| 119 | 117 | 1 | 69.333 | 69.333 | 24.8 | 72 | 21.46 |
| 23 | 48 | 1 | 34.683 | 34.683 | 24 | 63.5 | 41.52 |
| 105 | 143 | 1 | 20.7 | 20.7 | 6.14 | 21.5 | 17.8 |
| 122 | 170 | 1 | 61.55 | 61.55 | 15.58 | 44.27 | 15.19 |
| 240 | 225 | 1 | 30.4 | 30.4 | 18.8 | 51 | 37.11 |
| 136 | 37 | 1 | 50.133 | 50.133 | 20.64 | 62 | 24.7 |
| 201 | 181 | 1 | 38.667 | 38.667 | 13.8 | 43 | 21.41 |
| 140 | 2 | 1 | 14.517 | 14.517 | 1.63 | 10.5 | 6.74 |
| 173 | 148 | 1 | 22.05 | 22.05 | 11.3 | 32.5 | 30.75 |
| 66 | 6 | 1 | 19.3 | 19.3 | 9.3 | 28.5 | 28.91 |
| 11 | 192 | 1 | 67.283 | 67.283 | 22.96 | 67 | 20.47 |
| 77 | 134 | 1 | 27.083 | 27.083 | 6.68 | 25.5 | 14.8 |
| 190 | 260 | 1 | 25.85 | 25.85 | 10.9 | 32.5 | 25.3 |
| 6 | 35 | 1 | 48.917 | 48.917 | 19.3 | 59.5 | 23.67 |
| 34 | 8 | 1 | 21.717 | 21.717 | 9.35 | 28 | 25.83 |
| 155 | 7 | 1 | 72.4 | 72.4 | 23.25 | 70.5 | 19.27 |