passage

13 rows where service_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ service_id stop_id position time
287 151 54 Riva 27   08:20
288 151 54 Torbole 26   08:27
289 151 54 Limone Centro 25   08:45
290 151 54 Malcesine 23   08:57
291 151 54 Brenzone 20   09:13
292 151 54 Gargnano 17   09:28
293 151 54 Maderno 15   09:49
294 151 54 Gardone 14   10:01
295 151 54 Salo 13   10:15
296 151 54 Portese 12   10:25
297 151 54 Garda 10   10:55
298 151 54 Sirmione 3   11:25
299 151 54 Desenzano 1   11:40

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