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 |
|---|---|---|---|---|---|---|---|
| 60 | 232 | 1 | 24.45 | 24.45 | 12.69 | 36 | 31.14 |
| 251 | 53 | 1 | 34.433 | 34.433 | 27.35 | 71 | 47.66 |
| 36 | 241 | 1 | 39.2 | 39.2 | 16.87 | 49.5 | 25.82 |
| 160 | 57 | 1 | 20.933 | 20.933 | 5.45 | 19.5 | 15.62 |
| 187 | 234 | 1 | 9.417 | 9.417 | 1.54 | 8 | 9.81 |
| 177 | 94 | 1 | 56.833 | 56.833 | 19.56 | 59.5 | 20.65 |
| 22 | 115 | 1 | 24.8 | 24.8 | 7.8 | 24 | 18.87 |
| 225 | 54 | 1 | 13.533 | 13.533 | 4.65 | 15.5 | 20.62 |
| 94 | 226 | 1 | 24.267 | 24.267 | 13.88 | 37.02 | 34.32 |
| 218 | 114 | 1 | 48.2 | 48.2 | 18.68 | 53.5 | 23.25 |
| 102 | 101 | 1 | 38.867 | 38.867 | 13.22 | 42 | 20.41 |
| 11 | 168 | 1 | 44.333 | 44.333 | 22 | 59.5 | 29.77 |
| 17 | 2 | 1 | 80.583 | 80.583 | 29 | 84 | 21.59 |
| 40 | 44 | 1 | 44.117 | 44.117 | 22 | 60.5 | 29.92 |
| 76 | 44 | 1 | 57.333 | 57.333 | 31.14 | 83 | 32.59 |
| 189 | 214 | 1 | 30.4 | 30.4 | 11.8 | 36 | 23.29 |
| 73 | 217 | 1 | 48.767 | 48.767 | 12.4 | 42 | 15.26 |
| 73 | 170 | 1 | 43.65 | 43.65 | 13.76 | 42.5 | 18.91 |
| 189 | 185 | 1 | 74.433 | 74.433 | 19.42 | 67.5 | 15.65 |
| 169 | 133 | 1 | 76.033 | 76.033 | 19.35 | 64.17 | 15.27 |
| 255 | 15 | 1 | 23.117 | 23.117 | 13.71 | 38 | 35.58 |
| 118 | 40 | 1 | 19.333 | 19.333 | 10.29 | 29.5 | 31.93 |
| 29 | 246 | 1 | 46.983 | 46.983 | 17.22 | 52 | 21.99 |
| 96 | 39 | 1 | 22.267 | 22.267 | 5.1 | 19.5 | 13.74 |
| 18 | 88 | 1 | 47.717 | 47.717 | 15.85 | 47.5 | 19.93 |