passage

11 rows where stop_id = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: service_id, time

id ▼ service_id stop_id position time
30 92 7 Gargnano 17   09:50
39 110 8 Gargnano 17   10:36
69 2 13 Gargnano 17   12:09
79 160 14 Gargnano 17   10:54
89 160 14 Gargnano 17   10:54
150 96 26 Gargnano 17   15:19
170 112 29 Gargnano 17   15:50
201 6 35 Gargnano 17   17:58
223 156 38 Gargnano 17   18:15
292 151 54 Gargnano 17   09:28
328 5 59 Gargnano 17   10:57

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE passage ( id integer primary key, service_id integer, stop_id integer, position integer, time text, foreign key (service_id ) references service (id), foreign key ( stop_id ) references stop ( id ) );
CREATE INDEX ix_passage_service_stop_time ON passage(service_id, stop_id, time);