Prestwick Marchburn - Ayr - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	20:10:00	20:10:00	...	1
...	20:11:14	20:11:14	...	2
...	20:12:10	20:12:10	...	3
...	20:13:04	20:13:04	...	4
...	20:14:40	20:14:40	...	5
...	20:15:37	20:15:37	...	6
...	20:16:12	20:16:12	...	7
...	20:17:11	20:17:11	...	8
...	20:17:50	20:17:50	...	9
...	20:18:24	20:18:24	...	10
...	20:19:05	20:19:05	...	11
...	20:19:53	20:19:53	...	12
...	20:21:00	20:21:00	...	13
...	20:24:02	20:24:02	...	14
...	20:25:35	20:25:35	...	15
...	20:26:52	20:26:52	...	16
...	20:29:07	20:29:07	...	17
...	20:30:14	20:30:14	...	18
...	20:32:23	20:32:23	...	19
...	20:36:00	20:36:00	...	20
...	20:36:51	20:36:51	...	21
...	20:37:45	20:37:45	...	22
...	20:38:19	20:38:19	...	23
...	20:38:40	20:38:40	...	24
...	20:39:15	20:39:15	...	25
...	20:39:57	20:39:57	...	26
...	20:40:23	20:40:23	...	27
...	20:40:56	20:40:56	...	28
...	20:41:25	20:41:25	...	29
...	20:41:31	20:41:31	...	30
...	20:41:56	20:41:56	...	31
...	20:42:28	20:42:28	...	32
...	20:43:00	20:43:00	...	33

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
15/07/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
29724678	Ayr Railway Station	55.4585434314	-4.6247633361
29724857	John Street	55.4603452637	-4.6224784987
29723469	Lymburn Place	55.4631772002	-4.6178412245
29724875	Westwood Avenue	55.4671907279	-4.5999274188
29723493	Braehead Avenue	55.4691522031	-4.6015281472
29724642	Mainholm Road	55.4707366627	-4.6001451307
29724672	Whitletts Court	55.4722413065	-4.5953228648
29723692	Whitletts Pr School	55.4731070676	-4.5930693833
29723562	Briarhill Road	55.4980585955	-4.5999036108
29724257	Westbourne Gardens	55.4961621233	-4.602011178
29724324	St Ninians Pr School	55.498193423	-4.5990574212
29723686	Sanquhar Avenue	55.4967703375	-4.596651839
29724689	Raith Avenue	55.4945110005	-4.5946822601
29723485	Carnell Crescent	55.4936970343	-4.5987294524
29723985	Calvinston Road	55.4861045234	-4.6053527927
29724738	Burns Statue Square	55.4585300909	-4.6287330177
29723258	Churchill Crescent	55.4627762675	-4.6003961424
29724234	Beech Grove	55.4619628134	-4.6082052496
29723635	Craigie Lea	55.4623588597	-4.612392189
29724839	Robertson Crescent	55.463712079	-4.5973885069
29723525	Rowallan Crescent	55.494079254	-4.6048503979
29723262	Ardfin Road	55.4844796171	-4.6061002767
29723787	Campbell Court	55.4618415361	-4.6054603388
29723246	Moorefield Road	55.4920476197	-4.60485872
29724942	Fullarton Street	55.4611605861	-4.6313918729
29725454	Moor Park Place	55.4818575652	-4.6072408445
29725475	Parks Garage	55.4788495023	-4.6020249335
29786248	Churchill Crescent	55.462010024	-4.603035131
29792658	Old Bridge Road	55.4758378413	-4.5910331832
29789598	Asda Superstore	55.4802053032	-4.5953243072
29725232	Craigie Way	55.4617271437	-4.6146126887
29796458	Dunlop Terrace	55.4651805705	-4.5934189773
29796596	Fairview	55.4887627996	-4.6041985463