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 |
|---|---|---|---|---|---|---|---|
| 116 | 248 | 41 | 17.933 | 19.789 | 6.3 | 20.99 | 20.84 |
| 15 | 171 | 41 | 11.983 | 13.343 | 2.617 | 11.85 | 11.84 |
| 235 | 213 | 41 | 20.817 | 22.766 | 6.179 | 20.23 | 18.34 |
| 182 | 167 | 41 | 15.833 | 17.732 | 3.412 | 14.59 | 12.1 |
| 69 | 212 | 41 | 18.483 | 19.72 | 4.116 | 16.82 | 13.43 |
| 257 | 26 | 41 | 12.483 | 12.742 | 2.351 | 11.01 | 11.61 |
| 10 | 194 | 41 | 30.45 | 32.64 | 14.607 | 49.34 | 29.35 |
| 166 | 193 | 41 | 26.6 | 30.377 | 6.93 | 25.75 | 14.6 |
| 233 | 20 | 41 | 32.633 | 35.59 | 12.134 | 37.13 | 22.61 |
| 134 | 75 | 41 | 32.45 | 34.142 | 13.098 | 47.53 | 26.37 |
| 87 | 1 | 41 | 33.783 | 36.528 | 15.14 | 75.04 | 27.61 |
| 192 | 95 | 41 | 14.733 | 17.074 | 3.649 | 14.91 | 14.99 |
| 25 | 179 | 41 | 27.217 | 28.466 | 9.955 | 31.22 | 22.23 |
| 14 | 49 | 41 | 31.533 | 33.967 | 8.256 | 29.56 | 15.27 |
| 205 | 131 | 41 | 14.033 | 14.433 | 2.631 | 12.12 | 11.21 |
| 151 | 17 | 41 | 45.75 | 44.442 | 11.416 | 39.11 | 16.14 |
| 211 | 93 | 41 | 39.05 | 43.376 | 13.245 | 42.83 | 20.02 |
| 195 | 66 | 41 | 14.367 | 16.731 | 3.395 | 13.62 | 13.16 |
| 88 | 250 | 41 | 40.95 | 45.004 | 15.461 | 46.79 | 23.27 |
| 78 | 167 | 41 | 11.367 | 11.818 | 2.07 | 10.15 | 10.85 |
| 88 | 18 | 41 | 35.55 | 36.4 | 16.377 | 47.01 | 27.59 |
| 189 | 246 | 41 | 31.2 | 32.484 | 6.789 | 26.74 | 13.41 |
| 161 | 218 | 41 | 49.733 | 54.706 | 17.612 | 53.68 | 20.7 |
| 203 | 226 | 41 | 30.783 | 32.733 | 17.115 | 48.17 | 32.48 |
| 161 | 109 | 41 | 57.567 | 59.817 | 24.106 | 70.15 | 24.69 |