Glasgow - Ardrossan - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	06:08:00	06:08:00	...	1
...	06:08:09	06:08:09	...	2
...	06:08:22	06:08:22	...	3
...	06:08:36	06:08:36	...	4
...	06:08:54	06:08:54	...	5
...	06:10:33	06:10:33	...	6
...	06:12:51	06:12:51	...	7
...	06:15:21	06:15:21	...	8
...	06:17:10	06:17:10	...	9
...	06:17:33	06:17:33	...	10
...	06:18:00	06:18:00	...	11
...	06:18:43	06:18:43	...	12
...	06:19:10	06:19:10	...	13
...	06:20:05	06:20:05	...	14
...	06:20:23	06:20:23	...	15
...	06:20:41	06:20:41	...	16
...	06:21:00	06:21:00	...	17
...	06:21:16	06:21:16	...	18
...	06:46:00	06:46:00	...	19
...	06:46:59	06:46:59	...	20
...	06:48:09	06:48:09	...	21
...	06:50:00	06:50:00	...	22

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

stop_code	stop_name	stop_lat	stop_lon
45236758	Bath Street	55.863754666	-4.2576835561
45235639	Blythswood Street	55.861537786	-4.2633879622
45234765	Waterloo Lane	55.8611275209	-4.2593049724
45242868	Buchanan Bus Station	55.8654933569	-4.2505923115
73926786	Risk Cottages	55.8026029725	-4.5856898645
73924947	Auchengreoch Road	55.8221898893	-4.532082269
73924532	Hallhill Road	55.8209098848	-4.5344417964
73923743	Ettrick Terrace	55.8240419333	-4.532058946
73924634	Kilbarchan Road	55.827557285	-4.5337565334
73924562	Corseford School	55.81717681	-4.5424204228
73925648	Corseford Cottage	55.8155032337	-4.5464138008
73923596	Torbracken	55.8132620034	-4.5534983268
73923486	Midton Road	55.8102729146	-4.5571970289
73925487	Eliestoun Cottage	55.8089253401	-4.5619127815
73923492	A737 Roundabout	55.7861705827	-4.6066137011
73924867	Milliken Park Road	55.8259139942	-4.5336815786
73923435	Clarksbridge Roundabout	55.7688387799	-4.6185467009
62923723	Strand	55.7501698198	-4.6340926597
62924735	Bellmans Close	55.7513180419	-4.6329429054
62924272	Wilson Street	55.7526386167	-4.6308802947
62925327	Bigholm Road	55.7542116132	-4.6292011251
62923652	Beech Avenue	55.756478553	-4.6278554227