passage

9 rows where service_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ service_id stop_id position time
33 110 8 Peschiera 2   08:50
34 110 8 Sirmione 3   09:10
35 110 8 Garda 10   09:31
36 110 8 Torri 11   09:45
37 110 8 Salo 13   10:09
38 110 8 Gardone 14   10:19
39 110 8 Gargnano 17   10:36
40 110 8 Malcesine 23   10:55
41 110 8 Limone Centro 25   11:05

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);