passage

13 rows where service_id = 38

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ service_id stop_id position time
217 156 38 Peschiera 2   16:10
218 156 38 Desenzano 1   16:40
219 156 38 Sirmione 3   16:52
220 156 38 Garda 10   17:14
221 156 38 Salo 13   17:40
222 156 38 Gardone 14   17:50
223 156 38 Gargnano 17   18:15
224 156 38 Castelletto 19   18:29
225 156 38 Brenzone 20   18:37
226 156 38 Malcesine 23   18:53
227 156 38 Limone Centro 25   19:08
228 156 38 Torbole 26   19:26
229 156 38 Riva 27   19: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);