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 |
|---|---|---|---|---|---|---|---|
| 86 | 136 | 2 | 73.242 | 73.242 | 27.39 | 76.06 | 22.72 |
| 218 | 3 | 2 | 39.175 | 39.175 | 19.01 | 54 | 29.11 |
| 121 | 145 | 2 | 26.008 | 26.008 | 9.395 | 28.25 | 21.7 |
| 86 | 116 | 2 | 63.583 | 63.583 | 23.565 | 69.25 | 23.99 |
| 96 | 160 | 2 | 13.592 | 13.592 | 2.65 | 11.75 | 11.82 |
| 60 | 195 | 2 | 76.217 | 76.217 | 22.75 | 70.25 | 17.93 |
| 39 | 248 | 2 | 62.233 | 62.233 | 23.575 | 68 | 22.95 |
| 113 | 105 | 2 | 16.283 | 16.283 | 2.395 | 12.5 | 12.23 |
| 70 | 241 | 2 | 28.85 | 28.85 | 12.61 | 36.75 | 26.77 |
| 200 | 81 | 2 | 34.483 | 34.483 | 6.7 | 28.75 | 11.65 |
| 259 | 164 | 2 | 57.283 | 57.283 | 17.9 | 58.25 | 19.06 |
| 83 | 15 | 2 | 19.858 | 19.858 | 10.105 | 30.5 | 32.5 |
| 217 | 43 | 2 | 36.192 | 36.192 | 7.975 | 22.68 | 13.65 |
| 81 | 155 | 2 | 52.642 | 52.642 | 27.43 | 74.5 | 32.93 |
| 58 | 32 | 2 | 17.3 | 17.3 | 3.45 | 14.25 | 11.99 |
| 200 | 188 | 2 | 74.433 | 74.433 | 27.54 | 80.5 | 22.38 |
| 54 | 39 | 2 | 37.875 | 37.875 | 16.585 | 48.5 | 28.89 |
| 15 | 241 | 2 | 29.017 | 29.017 | 11.495 | 35 | 24.93 |
| 250 | 28 | 2 | 42.25 | 42.25 | 12.19 | 40.25 | 18 |
| 111 | 40 | 2 | 13.05 | 13.05 | 3.145 | 12.25 | 14.62 |
| 66 | 222 | 2 | 41.983 | 41.983 | 14.93 | 46.5 | 23.45 |
| 98 | 149 | 2 | 45.217 | 45.217 | 17.65 | 50.8 | 25.09 |
| 60 | 236 | 2 | 34.833 | 34.833 | 9.095 | 31.5 | 15.78 |
| 5 | 123 | 2 | 73.858 | 73.858 | 22.44 | 72.25 | 18.85 |
| 102 | 181 | 2 | 37.883 | 37.883 | 7.21 | 29 | 12.24 |