Aberdeen - Perth - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:12:00	08:12:00	...	1
...	08:15:00	08:15:00	...	2
...	08:22:00	08:22:00	...	3
...	08:28:00	08:28:00	...	4
...	08:30:00	08:30:00	...	5
...	08:36:00	08:36:00	...	6
...	08:43:00	08:43:00	...	7
...	08:47:00	08:47:00	...	8
...	08:49:00	08:49:00	...	9
...	08:52:00	08:52:00	...	10
...	08:59:00	08:59:00	...	11
...	09:08:00	09:08:00	...	12
...	09:09:00	09:09:00	...	13
...	09:11:00	09:11:00	...	14
...	09:18:00	09:18:00	...	15
...	09:22:00	09:22:00	...	16
...	09:25:00	09:25:00	...	17
...	09:37:00	09:37:00	...	18
...	09:41:00	09:41:00	...	19
...	09:43:00	09:43:00	...	20
...	09:46:00	09:46:00	...	21
...	09:48:00	09:48:00	...	22

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
14/05/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
36325956	Seagate Bus Station	56.4633278865	-2.9659911878
36325823	Carseview Centre	56.4637973492	-3.0455428635
36325834	Panmurefield Village	56.4843761511	-2.8535102742
36324636	Brown Street	56.4595767795	-2.9791862066
36324862	Railway Station	56.4576829175	-2.970943022
36324572	Elliot Road	56.4618125915	-3.0238881807
36323426	Monymusk Park	56.47442964	-2.9141954811
36323274	Riverside Drive	56.4625070158	-3.0546929158
36325743	Blackness Avenue	56.4566358797	-2.9942495678
36324935	Ninewells Hospital	56.4649884271	-3.0406579509
73756982	Road End	56.4470613844	-3.1700764203
73725624	Canal Street	56.3942616061	-3.4317603766
73723856	Western Avenue	56.3971858208	-3.4515069335
73725629	Leisure Pool	56.3955335276	-3.4429545814
73727972	Royal Infirmary Turning Circle	56.3974634382	-3.4561837073
73723934	Manse Road	56.3939817019	-3.4209441003
73725495	Horn Milk Bar	56.4231404072	-3.2235234074
73728753	Turning Circle	56.3963913371	-3.2718516999
26424258	Elliot Bridge	56.5460111415	-2.6178492286
26425835	Dobbie's Garden Centre	56.4902335676	-2.8337312367
26427276	Bus Station	56.5591196025	-2.5861748034
26425843	By Pass	56.5226058062	-2.715283952