Largs - Stevenston Ardeer - Transport Data Hub

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

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
62927928	Kelburn Avenue	55.7627825631	-4.8544582072
62958643	Overton Crescent	55.6934752771	-4.8622133379
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
62923852	Overton Drive	55.6917922521	-4.8657664826
62987626	McMillan Drive	55.6539159913	-4.8237267334
62987625	Marina	55.7782088015	-4.8548051444