Edinburgh - St Andrews - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:20:00	07:20:00	...	1
...	07:24:00	07:24:00	...	2
...	07:27:00	07:27:00	...	3
...	07:31:00	07:31:00	...	4
...	07:32:00	07:32:00	...	5
...	07:35:00	07:35:00	...	6
...	07:37:00	07:37:00	...	7
...	07:40:00	07:40:00	...	8
...	07:44:00	07:44:00	...	9
...	07:52:00	07:52:00	...	10
...	07:55:00	07:55:00	...	11
...	07:57:00	07:57:00	...	12
...	08:02:00	08:02:00	...	13
...	08:02:00	08:02:00	...	14
...	08:06:00	08:06:00	...	15
...	08:06:00	08:06:00	...	16
...	08:08:00	08:08:00	...	17
...	08:10:00	08:10:00	...	18
...	08:10:00	08:10:00	...	19
...	08:17:00	08:17:00	...	20
...	08:26:00	08:26:00	...	21
...	08:28:00	08:28: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
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
36243759	Bus Station	55.955358747	-3.1918741722
34323672	West Access Ridge Way	56.0417136526	-3.3615429682
34323742	East Access Ridge Way	56.045709662	-3.3404442221
34323652	Pentland Rise	56.041090638	-3.3429647405
34323594	Meadowfield	56.0392101462	-3.356334397
34323425	Square	56.0306833998	-3.3981289106
34323495	Bannerman Avenue	56.0352583318	-3.3964325695
34323246	North Access	56.0125129742	-3.4037922233
34323675	Railway Station	56.0420380283	-3.3663380604
34349496	Park & Ride	56.0226203093	-3.4062929556
34325649	Esplanade	56.0979744884	-3.1626637119
34346479	Bus Station	56.1101197034	-3.1610520602
34345369	West Lodge	56.080763748	-3.27933155