Aberdeen - Perth - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:28:00	07:28:00	...	1
...	07:29:00	07:29:00	...	2
...	07:40:00	07:40:00	...	3
...	07:45:00	07:45:00	...	4
...	07:49:00	07:49:00	...	5
...	07:52:00	07:52:00	...	6
...	07:55:00	07:55:00	...	7
...	08:02:00	08:02:00	...	8
...	08:08:00	08:08:00	...	9
...	08:11:00	08:11:00	...	10
...	08:20:00	08:20:00	...	11
...	08:30:00	08:30:00	...	12
...	08:34:00	08:34:00	...	13
...	08:36:00	08:36:00	...	14
...	08:39:00	08:39:00	...	15
...	08:48:00	08:48:00	...	16
...	08:55:00	08:55:00	...	17
...	08:56:00	08:56:00	...	18
...	08:58:00	08:58:00	...	19
...	09:05:00	09:05:00	...	20
...	09:09:00	09:09:00	...	21
...	09:12:00	09:12:00	...	22
...	09:24:00	09:24:00	...	23
...	09:28:00	09:28:00	...	24
...	09:30:00	09:30:00	...	25
...	09:33:00	09:33:00	...	26
...	09:35:00	09:35:00	...	27

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
36325843	Royal Victoria Hospital	56.4624413465	-3.0151578134
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
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
26425384	Co-op	56.7117713526	-2.4680591901
26424258	Elliot Bridge	56.5460111415	-2.6178492286
26425452	Inch Terrace	56.7012913672	-2.4788052107
26425835	Dobbie's Garden Centre	56.4902335676	-2.8337312367
26427276	Bus Station	56.5591196025	-2.5861748034
26423536	Saltire Centre	56.5693734848	-2.5778385199
26424958	Marywell Gardens	56.5871158047	-2.5702942151
26424686	Chance Inn	56.6351101295	-2.5478530813
26425843	By Pass	56.5226058062	-2.715283952