passage

16 rows where service_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ service_id stop_id position time
193 6 35 Desenzano 1   15:00
194 6 35 Sirmione 3   15:22
195 6 35 Garda 10   16:07
196 6 35 Portese 12   16:49
197 6 35 Salo 13   17:00
198 6 35 Gardone 14   17:13
199 6 35 Maderno 15   17:26
200 6 35 Bogliaco 16   17:51
201 6 35 Gargnano 17   17:58
202 6 35 Tignale 18   18:15
203 6 35 Campione 22   18:30
204 6 35 Assenza 21   18:43
205 6 35 Malcesine 23   19:00
206 6 35 Limone Centro 25   19:20
207 6 35 Torbole 26   19:50
208 6 35 Riva 27   20: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);