Ayr - Dalmellington Bellsbank - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
56546934	Dalharco Avenue	55.3567213006	-4.499430069
56546892	Carnshalloch Avenue	55.3614707885	-4.5045265552
56598987	Holehouse Junction	55.3917689081	-4.5173390315
56523475	Boghall Cottages	55.417685396	-4.561369778
56524596	Benston Crescent	55.4006931317	-4.5378404034
56525242	Ayr Road	55.3749037752	-4.4968675206
56524956	Ayr Road	55.3647109879	-4.4990501547
56523757	Main Street	55.3632039209	-4.5006594135
56523497	Doonside Avenue	55.3610337861	-4.4999702285
56523683	Plantation Avenue	55.3600462244	-4.5029848731
56523567	Dalvennan Avenue	55.3586828653	-4.5015260587
56524923	Drumbuie Drive	55.3555341025	-4.495947333
56524735	Netherhill Crescent	55.3558523007	-4.4940109663
56523747	Dalharco Avenue	55.3575667099	-4.4967695342
56524536	Dalharco Avenue	55.3586255495	-4.494658785
56523743	Doonbank Crescent	55.35630397	-4.4890536665
56524638	Doonbank Nursing Home	55.3549503894	-4.4866652483
56523572	New Cottages	55.3470854989	-4.4684896374
56523986	Dunaskin Heritage Centre	55.3436065246	-4.4595983127
56523535	St Francis Xavier Church	55.3419641518	-4.4523203505
56524247	Bellsbank Crescent	55.3238974043	-4.4034852344
56524673	Bellsbank Road	55.3200518381	-4.3992959723
56523562	Auchenroy Crescent	55.3167789444	-4.3979791426
56523832	Craiglea Crescent	55.3139125495	-4.3979321367
56524584	Ness Glen Road	55.3117656153	-4.3978655446
56524736	Eriff Road	55.3095254739	-4.3970526827
56523858	Glenmount	55.3077850118	-4.396884618
56524647	Fire Station	55.3230906726	-4.4006304015
56523597	Fire Station	55.3230922151	-4.399637364
56523794	Croft Street	55.3231293199	-4.3972907724
29723797	Ashgrove Street	55.4564642036	-4.624894066
29723536	Inverkar Road	55.4540557569	-4.6236109939
29724586	Belmont Avenue	55.452427363	-4.6220002697
29724364	Belmont Road	55.4488712863	-4.6159601199
29723546	Ailsa Hospital	55.4353232697	-4.5928351358
29723592	Birch Road	55.4431090396	-4.6062965647
29724264	Barnes Crescent	55.4581322077	-4.6342747726
29724572	Beresford Terrace	55.4579912928	-4.6299626584
29723563	Lochlea Drive	55.4500850224	-4.6180490665
29723793	Castlehill Crescent	55.4513425867	-4.6201884992
29725968	Mosshill Ind Estate	55.4250555389	-4.575518756
29723247	Bus Station	55.4620991148	-4.6341438916
29725398	Ayr Hospital	55.4311555953	-4.5948065149
29725423	Ayr Hospital Day Centre	55.4292686977	-4.5939239347
29725498	Ailsa Hospital East Entrance	55.4340180911	-4.5899513298
29723567	Forest Way	55.4467522641	-4.6116448665
29723532	Peggieshill Road	55.4451442578	-4.6090716683
29723748	Queen Margaret Academy	55.4420437807	-4.6052459457
29764593	Carrick Glen Hospital	55.4312400347	-4.5831774426