passage

16 rows where service_id = 85

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ service_id stop_id position time
456 3 85 Riva 27   15:15
457 3 85 Limone Centro 25   15:50
458 3 85 Malcesine 23   16:15
459 3 85 Campione 22   16:33
460 3 85 Tignale 18   16:49
461 3 85 Gargnano 17   17:07
462 3 85 Bogliaco 16   17:14
463 3 85 Maderno 15   17:40
464 3 85 Gardone 14   17:54
465 3 85 Salo 13   18:08
466 3 85 Portese 12   18:19
467 3 85 Garda 10   19:02
468 3 85 Bardolino 9   19:16
469 3 85 Cisano 8   19:25
470 3 85 Lazise 6   19:38
471 3 85 Peschiera 2   20:10

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