Erskine - Glasgow via Govan - Transport Data Hub

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