Erskine - Glasgow via Govan - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
45237239	Pavillion Theatre	55.8646865275	-4.2553882479
45234579	West George Street	55.8624876234	-4.2562036698
45242725	Laidlaw Street	55.8536687276	-4.2675638347
45243283	Houston Place	55.8535847096	-4.2740618786
45239232	Govan Town Hall	55.856432293	-4.3007214283
45239479	Marine Crescent	55.8541023502	-4.2800838674
45232659	Clyde Arc	55.8558945874	-4.2847268392
45235794	Orkney Place	55.8604061647	-4.3088029271
45237264	Briton Street	55.85753396	-4.3052448451
45242854	Neptune Street	55.8583514965	-4.308617088
45234598	Govan Underground	55.8626071094	-4.3107714287
45242756	Central Station	55.8593136368	-4.2567706805
45236792	War Memorial	55.8633491545	-4.3128931547
45235237	Howat Street	55.8638755446	-4.316919988
45234953	Elder Park	55.8640025682	-4.3254300977
45238294	Clachan Drive	55.8641531205	-4.3302977216
45238242	Burghead Place	55.864358997	-4.3331868894
45236534	Sewage Works	55.8665808959	-4.3425425607
45234573	Bogmoor Place	55.8673461214	-4.345305875
45236975	Bogmoor Road	55.866205321	-4.3490411024
45236848	Shieldhall Roundabout	55.8647014563	-4.3510759785
45236349	Govan Road	55.8565963472	-4.2885550745
45243634	Centre Street	55.8539337208	-4.260980421
45294726	Festival Park	55.8559852647	-4.2933766932
45247436	Queen Elizabeth Hospitals	55.8630462476	-4.3422018592
73924547	Tirry Avenue	55.8705273527	-4.3697150816
73925793	Bus Station	55.8748033416	-4.3623499311
73926267	Old Govan Road	55.8729268447	-4.3683266335
73947329	Row Avenue	55.8666813278	-4.3556390506
73924974	Old Greenock Road	55.8873464484	-4.4290158975
73923742	Sunart Avenue	55.8796063134	-4.4062275407
73923872	Blythswood Retail Park	55.8791857364	-4.4015327741
73924982	North Lodge Road	55.8796505432	-4.3975162704
73924543	Robertson Park	55.8781651961	-4.3907095637
73923624	Hairst Street	55.8782739802	-4.3860316574
73923467	Renfrew Road	55.8705745529	-4.3663291108
73923539	Ikea	55.8701290148	-4.356295446
73924874	Millburn Way	55.8755111379	-4.3806502822
73923274	Dean Park Road	55.8737517429	-4.3768177195
73924528	Balfour Kilpatrick	55.8727699756	-4.3745995951
73924967	Inchinnan Bridge	55.8843411183	-4.4154915738