Troon - Kilmarnock - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	09:51:00	09:51:00	...	1
...	09:51:37	09:51:37	...	2
...	09:51:55	09:51:55	...	3
...	09:52:20	09:52:20	...	4
...	09:52:38	09:52:38	...	5
...	09:52:49	09:52:49	...	6
...	09:53:00	09:53:00	...	7
...	09:53:28	09:53:28	...	8
...	09:53:45	09:53:45	...	9
...	09:53:59	09:53:59	...	10
...	09:54:39	09:54:39	...	11
...	09:55:35	09:55:35	...	12
...	09:55:59	09:55:59	...	13
...	09:56:19	09:56:19	...	14
...	09:56:34	09:56:34	...	15
...	09:56:47	09:56:47	...	16
...	09:57:09	09:57:09	...	17
...	09:57:25	09:57:25	...	18
...	09:57:45	09:57:45	...	19
...	09:58:04	09:58:04	...	20
...	09:58:22	09:58:22	...	21
...	09:58:38	09:58:38	...	22
...	09:59:27	09:59:27	...	23
...	10:00:00	10:00:00	...	24

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
13/11/2016 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
	Dukes Road	55.5452603493	-4.6609026708
29723464	Harling Drive	55.5456870129	-4.6495165218
29724653	Gillies Street	55.5468746627	-4.6523710207
29723483	Ottoline Drive	55.5450390789	-4.6412289109
29723895	Wilson Avenue	55.5456682651	-4.6353892683
29724687	Sandhill Gardens	55.5467356908	-4.6342399385
29723248	West Crescent	55.5480787804	-4.6349006058
29724859	Merrick Avenue	55.5503230864	-4.6362876187
29723989	Esk Road	55.5547003408	-4.6413064609
29723646	Spey Road	55.5526529829	-4.6403762019
29724564	Annick Place	55.5516268363	-4.6383570101
29723524	Spallander Road	55.5588729549	-4.6412218063
29723628	Findhorn Place	55.5558163538	-4.6395735415
29723238	Gillies street	55.5471766902	-4.6521218421
29725349	Lochlea Avenue	55.5511921494	-4.636837378
29725389	Logan Drive	55.5527040095	-4.6525736135
29725392	Fraser Avenue	55.5532377193	-4.6503420115
29725393	Richard Place	55.5516101611	-4.6511996514
29725394	Kenmore	55.5509208086	-4.6514861945
29725395	Marr Drive	55.5500650309	-4.651571244
29725396	Marr Drive	55.5498275486	-4.6517455143
29785946	Brown Avenue	55.5485989667	-4.6520274133
29725439	Brown Avenue	55.5485309324	-4.6518484211
29786376	Barassie Street	55.5439236169	-4.6566428559