Hereford - Cardiff via Hay, on, Wye, Brecon, Merthyr Tydfil

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:35:00	07:35:00	...	1
...	07:36:00	07:36:00	...	2
...	07:36:00	07:36:00	...	3
...	07:38:00	07:38:00	...	4
...	07:59:00	07:59:00	...	5
...	08:00:00	08:00:00	...	6
...	08:01:00	08:01:00	...	7
...	08:37:00	08:37:00	...	8
...	08:39:00	08:39:00	...	9
...	08:39:00	08:39:00	...	10
...	08:40:00	08:40:00	...	11
...	08:41:00	08:41:00	...	12
...	08:42:00	08:42:00	...	13
...	08:46:00	08:46:00	...	14
...	08:49:00	08:49:00	...	15
...	08:50:00	08:50:00	...	16
...	08:51:00	08:51:00	...	17
...	08:52:00	08:52:00	...	18
...	08:52:00	08:52:00	...	19
...	08:53:00	08:53:00	...	20
...	08:55:00	08:55:00	...	21
...	08:56:00	08:56:00	...	22

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

stop_code	stop_name	stop_lat	stop_lon
rhopapt	Catherine Street	51.6018183499	-3.3419522404
rhopajp	Bus Station	51.6056586421	-3.3395239688
rhojdag	Ynysangharad Park Gates	51.6040344875	-3.3368625291
mtydjmd	Mardy	51.7378698804	-3.3710202783
mtyadam	Hoovers Main Gate	51.7274110592	-3.3634206707
mtydjga	Castle Bingo	51.7419672258	-3.3766482332
mtyapjw	Bus Station	51.746293667	-3.3803576615
cdidjd	Quay Street KE	51.4801356641	-3.1818846794
cdidjg	Royal Hotel KJ	51.4784038545	-3.1788446973
cdijtgm	Cathays High School	51.4979210461	-3.1926019827
cdijwgp	Cross Inn	51.5083285758	-3.2010295442
cdidgaj	Castle Street Stop KB	51.4809763295	-3.1823384415
cdidgjd	Kingsway Stop GR	51.482365946	-3.1791773032
cdidgat	College Road Stop RK	51.4867694974	-3.1838853756
cdidamt	Law Courts Stop RJ	51.4843259732	-3.180984904
cdiptjg	Caedelyn Road	51.519163614	-3.2210747286
cdipwap	Tyn y Parc Road	51.5162412379	-3.2150155754
cdiptmt	Heol Nest	51.5153534425	-3.2130463644
cdiptpg	Manor Rise	51.5145081797	-3.211308942
cdiadmp	Pantbach Place	51.5111849084	-3.2048369684
cditagw	Tresillian Way	51.4747605359	-3.1763173429
cditdpj	Central Station	51.4750554889	-3.1773904559