passage

17 rows where stop_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: time

id ▼ service_id stop_id position time
2 14 1 Lazise 6   08:28
58 22 12 Lazise 6   10:37
60 2 13 Lazise 6   09:38
96 42 15 Lazise 6   10:20
105 16 17 Lazise 6   11:18
112 24 18 Lazise 6   11:48
125 10 20 Lazise 6   12:35
138 36 23 Lazise 6   14:45
210 12 36 Lazise 6   15:58
231 38 39 Lazise 6   17:03
243 26 42 Lazise 6   18:29
269 33 50 Lazise 6   09:07
271 15 51 Lazise 6   08:28
279 9 52 Lazise 6   10:10
285 23 53 Lazise 6   10:37
305 29 55 Lazise 6   11:37
310 35 56 Lazise 6   11:42

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