Glasgow - Irvine - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:03:00	07:03:00	...	1
...	07:03:09	07:03:09	...	2
...	07:03:21	07:03:21	...	3
...	07:03:34	07:03:34	...	4
...	07:03:51	07:03:51	...	5
...	07:05:26	07:05:26	...	6
...	07:07:37	07:07:37	...	7
...	07:10:00	07:10:00	...	8
...	07:10:41	07:10:41	...	9
...	07:10:49	07:10:49	...	10
...	07:11:00	07:11:00	...	11
...	07:11:43	07:11:43	...	12
...	07:12:10	07:12:10	...	13
...	07:13:05	07:13:05	...	14
...	07:13:23	07:13:23	...	15
...	07:13:41	07:13:41	...	16
...	07:14:00	07:14:00	...	17
...	07:14:16	07:14:16	...	18
...	07:39:00	07:39:00	...	19
...	07:40:13	07:40:13	...	20
...	07:41:42	07:41:42	...	21
...	07:44:00	07:44: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