Edinburgh - St Andrews - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:35:00	18:35:00	...	1
...	18:36:00	18:36:00	...	2
...	18:44:00	18:44:00	...	3
...	18:51:00	18:51:00	...	4
...	18:53:00	18:53:00	...	5
...	18:55:00	18:55:00	...	6
...	18:55:00	18:55:00	...	7
...	18:57:00	18:57:00	...	8
...	19:00:00	19:00:00	...	9
...	19:01:00	19:01:00	...	10
...	19:05:00	19:05:00	...	11
...	19:06:00	19:06:00	...	12
...	19:09:00	19:09:00	...	13
...	19:18:00	19:18:00	...	14
...	19:21:00	19:21:00	...	15
...	19:24:00	19:24:00	...	16
...	19:26:00	19:26:00	...	17
...	19:29:00	19:29:00	...	18
...	19:31:00	19:31:00	...	19
...	19:34:00	19:34:00	...	20
...	19:36:00	19:36:00	...	21
...	19:42:00	19:42:00	...	22

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

stop_code	stop_name	stop_lat	stop_lon
36237987	Slip Road	55.9875092345	-3.4042804575
36238725	Barnton Junction	55.9607986881	-3.3050208971
36238726	Hillpark Steps	55.9627215926	-3.2758499743
36237643	Telford Road	55.9601837948	-3.2561118499
36232728	Craigleith Drive	55.9557072539	-3.2403186827
36232696	Learmonth Terrace	55.9552435509	-3.2192584245
36246236	Queensferry Street	55.9504686291	-3.2086830099
36235972	Princes Street (west)	55.9512566262	-3.2016130961
36243246	Princes Street (Scott Mon.)	55.9523426463	-3.1952727578
36253232	Bus Station	55.9555492402	-3.1907588826
34323654	West Access Ridge Way	56.0404829784	-3.360697023
34323743	East Access Ridge Way	56.0458559917	-3.3402084861
34323643	Pentland Rise	56.0407975102	-3.3443029245
34323595	Meadowfield	56.0391116959	-3.35629884
34323286	Civic Centre	56.0297222182	-3.3988965354
34323476	Bannerman Avenue	56.0344054094	-3.3963696643
34323243	North Access	56.0120776034	-3.4033593826
34323659	Railway Station	56.0416344622	-3.3670782577
34323249	Park & Ride	56.022579057	-3.4059705638
34325656	Esplanade	56.0982972031	-3.161789287
34325846	Bus Station	56.1100808347	-3.1604076731
34345467	West Lodge	56.0806802431	-3.279585877