Cardiff - Aberystwyth - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:45:00	16:45:00	...	1
...	16:55:00	16:55:00	...	2
...	17:10:00	17:10:00	...	3
...	17:30:00	17:30:00	...	4
...	17:52:00	17:52:00	...	5
...	18:12:00	18:12:00	...	6
...	18:47:00	18:47:00	...	7
...	18:57:00	18:57:00	...	8
...	19:04:00	19:04:00	...	9
...	19:09:00	19:09:00	...	10
...	19:15:00	19:15:00	...	11
...	19:27:00	19:27:00	...	12
...	19:41:00	19:41:00	...	13
...	19:48:00	19:48:00	...	14
...	19:52:00	19:52:00	...	15
...	20:00:00	20:00:00	...	16
...	20:10:00	20:10:00	...	17
...	20:15:00	20:15:00	...	18
...	20:24:00	20:24:00	...	19
...	20:31:00	20:31:00	...	20

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

stop_code	stop_name	stop_lat	stop_lon
crmjdma	Peniel	51.8939619139	-4.275090459
crmadmd	Primary School	51.9630849009	-4.2635532355
crmapta	Bus Station	51.8555720304	-4.3083398812
crmjdag	War Memorial	52.0006738069	-4.2658577994
crmawpa	Library	51.794838816	-4.0869600508
cejawtj	King Street	52.0417643592	-4.3091463863
cejadad	Alban Square	52.2425908532	-4.2584062419
cejdawa	Black Lion	52.3063063547	-4.1447211632
cejdagd	Bryn Eglur	52.3818637111	-4.0721942292
cejawdt	Pont Llethi	52.1941622036	-4.3074994607
cejdtam	Synod Inn	52.1645490458	-4.3354458914
cejatdg	Ffostrasol Arms	52.1031022007	-4.3769316615
cejgdmt	Central Hotel	52.2818291465	-4.177214738
cejgmtm	Bus Station Stand 7	52.4145838108	-4.0814189495
breapgj	Sarn Odeon	51.5321155792	-3.5732745608
cdiajap	Mermaid Quay	51.4632891032	-3.1661903257
cditpgd	Customhouse Street	51.4764989956	-3.176016488
vglgtpw	Tesco Extra	51.4662012582	-3.2751145395
swatmat	Bus Station	51.6172456655	-3.9461778904
nptmajm	Port Talbot Parkway	51.592613404	-3.7809739467