passage

10 rows where stop_id = 15

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ service_id stop_id position time
29 92 7 Maderno 15   09:19
67 2 13 Maderno 15   11:36
110 16 17 Maderno 15   13:00
181 162 31 Maderno 15   16:35
199 6 35 Maderno 15   17:26
241 98 41 Maderno 15   19:50
258 91 47 Maderno 15   08:20
293 151 54 Maderno 15   09:49
330 5 59 Maderno 15   11:30
371 161 66 Maderno 15   14:35

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