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 |
|---|---|---|---|---|---|---|---|
| 39 | 210 | 38 | 16.483 | 17.493 | 6.676 | 21.4 | 24.01 |
| 165 | 140 | 38 | 51.908 | 53.815 | 15.279 | 48.77 | 17.68 |
| 114 | 20 | 38 | 36.85 | 40.222 | 14.383 | 44.01 | 22.89 |
| 152 | 126 | 38 | 22.958 | 24.981 | 6.453 | 22.93 | 16.62 |
| 89 | 177 | 38 | 27.892 | 27.411 | 4.895 | 20.57 | 11.1 |
| 168 | 81 | 38 | 24.083 | 25.615 | 9.881 | 30.58 | 25.18 |
| 216 | 41 | 38 | 42.25 | 42.839 | 16.67 | 50.16 | 24 |
| 234 | 15 | 38 | 36.917 | 39.888 | 16.256 | 47.83 | 25.77 |
| 10 | 152 | 38 | 42.358 | 45.321 | 16.233 | 52.61 | 23.21 |
| 238 | 217 | 38 | 38.525 | 40.208 | 9.807 | 35.01 | 15.37 |
| 112 | 74 | 38 | 22.625 | 24.778 | 8.398 | 26.68 | 21.14 |
| 82 | 112 | 38 | 17.483 | 17.454 | 4.825 | 17.22 | 18.11 |
| 136 | 169 | 38 | 12.058 | 12.596 | 1.887 | 9.87 | 9.46 |
| 244 | 146 | 38 | 26.158 | 27.796 | 7.986 | 27.42 | 17.89 |
| 56 | 7 | 38 | 22.45 | 21.983 | 6.142 | 21.51 | 17.81 |
| 55 | 150 | 38 | 10.633 | 12.789 | 2.977 | 12.93 | 16.51 |
| 170 | 153 | 38 | 34.425 | 38.344 | 11.651 | 37.47 | 20.59 |
| 143 | 217 | 38 | 41.725 | 42.846 | 8.304 | 32.64 | 12.22 |
| 189 | 145 | 38 | 23.567 | 25.554 | 7.288 | 24.95 | 17.86 |
| 216 | 77 | 38 | 19.45 | 20.942 | 4.837 | 17.93 | 14.65 |
| 139 | 76 | 38 | 18.792 | 19.321 | 8.913 | 25.49 | 28.48 |
| 55 | 14 | 38 | 17.492 | 22.7 | 6.522 | 24.21 | 19.68 |
| 65 | 123 | 38 | 32.692 | 32.097 | 8.944 | 30.07 | 17.59 |
| 168 | 100 | 38 | 33.267 | 32.721 | 7.961 | 29.04 | 16.54 |
| 227 | 67 | 37 | 8.217 | 9.125 | 1.392 | 8.03 | 9.81 |