Ayr - Girvan or Stranraer - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
29748363	Main Street	55.2762100665	-4.7289080434
29785697	Killochan Road	55.2667687324	-4.7988528831
29725269	Rowanston	55.3157875427	-4.6560629879
29756749	Low Craighead	55.2738181685	-4.7779343075
29762842	Barganny Road	55.276162584	-4.7641620218
29756797	Moorston Farm	55.283159864	-4.7099029711
29783632	Kilkerran Road	55.3036460419	-4.6732302609
29724283	McDowall Terrace	55.3577456309	-4.6751415755
29724297	Merrick View	55.3558869303	-4.6787398113
29724327	Asda	55.2466129258	-4.8512981705
29723847	Elder Avenue	55.2325915174	-4.8538806512
29724576	McConnell Square	55.2453790971	-4.8525472783
29723648	Henrietta Street	55.2434150401	-4.8588733815
29723597	Hervey Road	55.237841252	-4.8550435333
29723486	Inglis Way	55.2368187796	-4.8468683485
29723653	Todd Street	55.235198658	-4.8496470479
29723984	Piedmont Road	55.2342605196	-4.8497844137
29724263	Fauldribbon Road	55.2369881112	-4.852701239
29723943	Victoria Crescent	55.276245255	-4.7216984229
29724397	Main Street	55.2779304182	-4.7251364933
29723838	Hadyard Terrace	55.2745732783	-4.7265282678
29723878	Roan Bridge	55.278453817	-4.7202118535
29723279	Kirkbride Crescent	55.3245120427	-4.6388316492
29723739	Maybole Station	55.3546977301	-4.6845919011
29724236	Town Green	55.3543117152	-4.6853861994
29724565	Arran Court	55.2357696257	-4.8479102651
29723683	Gregg Place	55.2368068983	-4.8454516407
29723598	Urnfield	55.2357812045	-4.8462593007
29723574	Duncan Street	55.239745126	-4.8555104529
29724373	Sacred Heart Primary	55.241497053	-4.8586255094
29724868	High Street	55.2434718753	-4.8549123829
29724635	Edlinton Terrace	55.2744795395	-4.7242858937
29724574	Piedmount Road	55.2358510581	-4.852887212
29725727	Kirkmichael Playing Fields	55.3444898419	-4.6160745943
29725742	Chestnut Drive	55.2344400929	-4.8517164279
29725235	Kirkmichael Arms	55.3456450656	-4.6183749099
29724929	Ladywell Avenue	55.2613378807	-4.8230901739
29727298	Rail station	55.2471791851	-4.8489940892
29727234	Hospital	55.2483049392	-4.8469817422
29764796	Carrick Street	55.2443799523	-4.8499109097
29764825	Boyle Court	55.2435173753	-4.8475833986
29764828	Troweir Road	55.2424389664	-4.8467982292
29764786	Orchard Avenue	55.2421811583	-4.8497534993
29764865	Hawthorn Drive	55.2297015772	-4.8525253534
29764875	Willow Drive	55.2314086958	-4.851027471
29764929	Rowan Road	55.2326361016	-4.8496681696
29764938	Coalpots Road	55.2339579126	-4.8504234455
29764283	Caravan Park	55.2840748641	-4.7353699281