Edinburgh - Glasgow - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	23:00:00	23:00:00	...	1
...	23:11:00	23:11:00	...	2
...	23:12:00	23:12:00	...	3
...	23:29:00	23:29:00	...	4
...	23:36:00	23:36:00	...	5
...	23:46:00	23:46:00	...	6
...	23:47:00	23:47:00	...	7
...	23:48:00	23:48:00	...	8
...	23:52:00	23:52:00	...	9
...	23:57:00	23:57:00	...	10
...	23:58:00	23:58:00	...	11
...	00:01:00	00:01:00	...	12
...	00:01:00	00:01:00	...	13
...	00:02:00	00:02:00	...	14
...	00:03:00	00:03:00	...	15
...	00:04:00	00:04:00	...	16
...	00:05:00	00:05:00	...	17
...	00:07:00	00:07:00	...	18
...	00:09:00	00:09:00	...	19
...	00:12:00	00:12:00	...	20
...	00:14:00	00:14:00	...	21

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

stop_code	stop_name	stop_lat	stop_lon
45239472	Swinton Road	55.8538737777	-4.1095580292
45242623	Easterhouse Railway Station	55.8591864703	-4.1073852144
45243673	Buchanan Bus Station	55.8652293328	-4.2517597371
65298987	Harthill Services	55.8638173729	-3.7582826086
36232395	Lochend Road	55.9391268746	-3.3982382541
36232396	Station Road	55.9389339423	-3.3906745974
36232398	Ingliston Road	55.9378484414	-3.3664293621
36232429	Gogarburn A8	55.9383878967	-3.3294501129
36236596	Marriott Hotel	55.9408519156	-3.3116667363
36243478	Drum Brae South	55.942912871	-3.2918022427
36238768	Station Road	55.9425133567	-3.2792842098
36235925	Edinburgh Zoo	55.942331536	-3.2673179413
36236584	Balgreen Road	55.9439968539	-3.2573810167
36239658	Murrayfield Road	55.9453584824	-3.2445192572
36232653	Roseburn Gardens	55.9457942288	-3.2351499535
36232657	Haymarket Station	55.9459542015	-3.2181818345
36236568	Shandwick Place	55.9498633291	-3.2090164563
36235973	Princes Street (west)	55.951361837	-3.2009597554
36298792	North St David Street	55.9550186091	-3.1945223963
36247353	Airport	55.9482439907	-3.3624558247
95624276	Deer Park	55.9149951159	-3.5265235336