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 |
|---|---|---|---|---|---|---|---|
| 8 | 163 | 14 | 28.217 | 30.639 | 6.659 | 40.21 | 14.75 |
| 215 | 19 | 14 | 22.625 | 22.696 | 5.424 | 19.06 | 14.66 |
| 130 | 17 | 14 | 45.417 | 43.833 | 11.92 | 38.71 | 18.41 |
| 12 | 243 | 14 | 37.817 | 41.414 | 13.23 | 42 | 20.67 |
| 193 | 211 | 14 | 21.992 | 24.082 | 6.394 | 22.11 | 16.82 |
| 71 | 130 | 14 | 46.15 | 47.694 | 12.364 | 42.86 | 16.17 |
| 88 | 53 | 14 | 40.808 | 39.479 | 16.655 | 48 | 26.98 |
| 129 | 175 | 14 | 18.658 | 20.076 | 9.193 | 27.32 | 29.43 |
| 8 | 116 | 14 | 13.983 | 16.256 | 4.974 | 50.93 | 20.18 |
| 25 | 235 | 14 | 43.608 | 43.51 | 15.451 | 46.44 | 22.71 |
| 14 | 100 | 14 | 39.267 | 45.175 | 11.759 | 40 | 16.42 |
| 261 | 187 | 14 | 27.9 | 30.205 | 17.126 | 47.21 | 34.75 |
| 165 | 11 | 14 | 19.667 | 22.681 | 5.156 | 19.71 | 12.55 |
| 7 | 40 | 14 | 27.125 | 28.111 | 11.282 | 33.18 | 25.16 |
| 54 | 256 | 14 | 16.258 | 16.957 | 4.761 | 16.96 | 17.6 |
| 196 | 114 | 14 | 31.625 | 29.004 | 9.207 | 45.21 | 22.45 |
| 29 | 162 | 14 | 55.692 | 52.152 | 15.737 | 48.83 | 17.71 |
| 45 | 185 | 14 | 38.667 | 42.023 | 16.826 | 49.11 | 26.21 |
| 224 | 135 | 14 | 31.817 | 36.376 | 12.08 | 37.51 | 22.65 |
| 50 | 46 | 14 | 32.042 | 31.479 | 18.434 | 50.39 | 36.54 |
| 234 | 115 | 14 | 38.925 | 40.327 | 17.288 | 49.96 | 26.06 |
| 232 | 117 | 14 | 58.533 | 64.993 | 22.826 | 73.11 | 22.52 |
| 190 | 26 | 14 | 19.3 | 18.196 | 2.83 | 14.07 | 10.39 |
| 127 | 254 | 14 | 18.508 | 20.437 | 6.406 | 22 | 19.38 |
| 168 | 145 | 14 | 20.9 | 23.425 | 7.784 | 25.96 | 21.97 |