Scotstoun - Parkhead - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	20:05:00	20:05:00	...	1
...	20:05:00	20:05:00	...	2
...	20:06:00	20:06:00	...	3
...	20:07:00	20:07:00	...	4
...	20:07:00	20:07:00	...	5
...	20:08:00	20:08:00	...	6
...	20:08:00	20:08:00	...	7
...	20:09:00	20:09:00	...	8
...	20:10:00	20:10:00	...	9
...	20:10:00	20:10:00	...	10
...	20:11:00	20:11:00	...	11
...	20:11:00	20:11:00	...	12
...	20:12:00	20:12:00	...	13
...	20:12:00	20:12:00	...	14
...	20:12:00	20:12:00	...	15
...	20:14:00	20:14:00	...	16
...	20:16:00	20:16:00	...	17
...	20:17:00	20:17:00	...	18
...	20:19:00	20:19:00	...	19
...	20:20:00	20:20:00	...	20
...	20:20:00	20:20:00	...	21
...	20:28:00	20:28:00	...	22
...	20:29:00	20:29:00	...	23
...	20:30:00	20:30:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
45235678	East Wellington Street	55.852848876	-4.1973598284
45234934	St Michaels Lane	55.8516949291	-4.1990680907
45237296	Eastern Necropolis	55.8527589547	-4.2023875422
45234348	Society Street	55.8531569891	-4.2067558907
45242867	Forge Retail Park	55.8537942839	-4.2123042906
45234856	Millerston Street	55.8541773967	-4.2159849743
45237923	St Mungo's Academy	55.8543700798	-4.2192554263
45232934	Crownpoint Sports Park	55.8547123818	-4.22219892
45237972	Sword Street	55.855200599	-4.2255183099
45235958	Moore Street	55.8556325435	-4.2289623904
45237672	Sydney Street	55.8557382856	-4.2320522896
45239857	Bain Street	55.8553727539	-4.2348594867
45234629	Kent Street	55.8539155898	-4.2378914658
45234283	Gallowgate	55.8505827647	-4.1989413505
45236259	Burgher Street	55.8492971594	-4.1989645779
45282797	Mart Street	55.8534452249	-4.2479143083
45237853	Tollcross Road	55.8500995279	-4.1963099607
45298987	Tunnel Street	55.8580920099	-4.2830341847
45245458	Finnieston Street	55.8575846397	-4.2808312139
45293495	Ropework Lane	55.8548515514	-4.2521019322
45235369	Harland Street	55.8777721167	-4.3476454511
45242852	Earl Place	55.8787637862	-4.350311442
45243976	Cheapside Street	55.8565123274	-4.2707815112
45232753	Lime Street	55.8761868589	-4.3393322496