Largs - Stevenston Ardeer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	22:35:00	22:35:00	...	1
...	22:35:33	22:35:33	...	2
...	22:36:01	22:36:01	...	3
...	22:36:35	22:36:35	...	4
...	22:37:04	22:37:04	...	5
...	22:37:26	22:37:26	...	6
...	22:38:02	22:38:02	...	7
...	22:38:42	22:38:42	...	8
...	22:39:00	22:39:00	...	9
...	22:39:28	22:39:28	...	10
...	22:39:50	22:39:50	...	11
...	22:40:09	22:40:09	...	12
...	22:40:37	22:40:37	...	13
...	22:41:08	22:41:08	...	14
...	22:42:10	22:42:10	...	15
...	22:44:29	22:44:29	...	16
...	22:44:48	22:44:48	...	17
...	22:45:11	22:45:11	...	18
...	22:45:39	22:45:39	...	19
...	22:46:00	22:46:00	...	20
...	22:46:27	22:46:27	...	21
...	22:47:19	22:47:19	...	22
...	22:56:37	22:56:37	...	23
...	22:57:39	22:57:39	...	24
...	22:57:59	22:57:59	...	25
...	22:58:23	22:58:23	...	26
...	22:58:40	22:58:40	...	27
...	22:58:57	22:58:57	...	28
...	22:59:09	22:59:09	...	29
...	22:59:41	22:59:41	...	30
...	22:59:47	22:59:47	...	31
...	23:00:00	23:00:00	...	32
...	23:00:42	23:00:42	...	33
...	23:01:02	23:01:02	...	34
...	23:01:18	23:01:18	...	35
...	23:02:21	23:02:21	...	36
...	23:03:06	23:03:06	...	37
...	23:04:01	23:04:01	...	38
...	23:04:27	23:04:27	...	39
...	23:04:56	23:04:56	...	40
...	23:11:57	23:11:57	...	41
...	23:12:47	23:12:47	...	42
...	23:13:23	23:13:23	...	43
...	23:13:52	23:13:52	...	44
...	23:14:22	23:14:22	...	45
...	23:15:04	23:15:04	...	46
...	23:15:35	23:15:35	...	47
...	23:16:00	23:16:00	...	48

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

stop_code	stop_name	stop_lat	stop_lon
62957646	Laverock Drive	55.8035498304	-4.8570917009
62957485	Laverock Drive	55.8035884181	-4.8612281542
62957672	Douglas Place	55.802857238	-4.8644462152
62927928	Kelburn Avenue	55.7627825631	-4.8544582072
62927972	Douglas Street	55.8019020725	-4.871477915
62958535	Noddleburn Road	55.8031098318	-4.8686462401
62979692	Corsehill Drive	55.6950731346	-4.8611524286
62956937	Corse Street	55.6962181702	-4.8617772837
62923452	Hill Street	55.6397170104	-4.8133911369
62925387	Congregational Church	55.6415948374	-4.8134304799
62923639	Hill Place	55.6437712654	-4.8114249595
62923685	Park Road	55.6466913122	-4.8087412967
62925383	Caledonia Road	55.6487189358	-4.8108736145
62925258	Seafield Drive	55.6500842133	-4.8140555372
62924873	Witches Linn	55.651727323	-4.8180525423
62924748	Ardrossan Road	55.6807048707	-4.8574456237
62923975	Ardrossan Road	55.6826679433	-4.8592276635
62923636	Chapelton Lane	55.6844892569	-4.8609199715
62923839	Pantonville Road	55.68851383	-4.8637283229
62925247	Bowfield Road	55.6935284271	-4.8607052978
62923854	Manse Road	55.695377361	-4.8558110591
62923293	Meadowfoot Road	55.6925697075	-4.8505294614
62924795	Cubrieshaw Drive	55.691274398	-4.8490187871
62924756	Simon Avenue	55.6897934425	-4.848147162
62923569	Crosbie Drive	55.6914420511	-4.8507019707
62923632	Meadowside	55.693269168	-4.8513761424
62923932	Stairlie Crescent	55.6935149009	-4.8516327678
62925398	Main Street	55.6960989422	-4.8541606959
62923795	Avondale Road	55.6974474856	-4.8580153577
62924942	Burnside Place	55.6962968999	-4.853379327
62924252	Montgomerie Avenue	55.7486678683	-4.8568532039
62924863	Burnfoot Road	55.7533371546	-4.8551385831
62924764	The Causeway	55.7557733243	-4.8543602788
62923892	School Brae	55.7577941996	-4.8540457093
62924659	Pier Road	55.760550289	-4.8541993487
62923653	Kelburn Avenue	55.7646678148	-4.8545641706
62924532	Largs Golf Course	55.7841350184	-4.8574083015
62924545	Springfield Gardens	55.7870136309	-4.8588635279
62923969	Bankhouse Avenue	55.7896526	-4.8605726236
62924637	Lovat Street	55.7910816358	-4.8625122503
62923898	Gogo Street	55.7928640181	-4.8647173113
62924632	Manse Court	55.7942454419	-4.8690790926
62924324	School Street	55.7954543331	-4.8696627012
62923894	Brooksby House	55.7981264994	-4.8687902118
62924964	Brisbane Street	55.8004116181	-4.8706340307
62923852	Overton Drive	55.6917922521	-4.8657664826
62987626	McMillan Drive	55.6539159913	-4.8237267334
62987625	Marina	55.7782088015	-4.8548051444