Edinburgh - St Andrews - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	19:25:00	19:25:00	...	1
...	19:29:00	19:29:00	...	2
...	19:32:00	19:32:00	...	3
...	19:35:00	19:35:00	...	4
...	19:36:00	19:36:00	...	5
...	19:40:00	19:40:00	...	6
...	19:42:00	19:42:00	...	7
...	19:45:00	19:45:00	...	8
...	19:49:00	19:49:00	...	9
...	19:57:00	19:57:00	...	10
...	20:00:00	20:00:00	...	11
...	20:02:00	20:02:00	...	12
...	20:10:00	20:10:00	...	13
...	20:11:00	20:11:00	...	14
...	20:30:00	20:30:00	...	15
...	20:31:00	20:31:00	...	16
...	20:34:00	20:34:00	...	17

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
36232525	Princes Street (Scott Mon.)	55.9523439105	-3.1942158046
36243234	Princes Street (west)	55.9511628114	-3.2010977238
36246545	Queensferry Street	55.950587789	-3.2093593254
36232695	Learmonth Terrace	55.9551075427	-3.2193822781
36232729	Craigleith Road	55.9562687983	-3.2434438948
36237645	Telford Road	55.9601344736	-3.2565427484
36238694	Hillpark Steps	55.9625803596	-3.2756050347
36238724	Barnton Junction	55.9605022697	-3.3033129428
36237989	Slip Road	55.9864277768	-3.4053472921
36243834	Bus Station	55.9553681945	-3.1918264137
34323246	North Access	56.0125129742	-3.4037922233
34347929	Park & Ride	56.0840366869	-3.3912548661
34349496	Park & Ride	56.0226203093	-3.4062929556
34347938	Park & Ride Arrival Bay	56.0839217326	-3.3910900212
34342379	Woodside Inn	56.1897423829	-3.1499205252
34347458	Bankhead Roundabout	56.1832204068	-3.1468899196
34346487	Bus Station Arrival Bay	56.1953087704	-3.1714408578