Hereford - Hay On Wye - Cardiff - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:00:00	16:00:00	...	1
...	16:02:00	16:02:00	...	2
...	16:03:00	16:03:00	...	3
...	16:09:00	16:09:00	...	4
...	16:15:00	16:15:00	...	5
...	16:20:00	16:20:00	...	6
...	16:26:00	16:26:00	...	7
...	16:29:00	16:29:00	...	8
...	16:34:00	16:34:00	...	9
...	16:39:00	16:39:00	...	10
...	16:44:00	16:44:00	...	11
...	16:52:00	16:52:00	...	12
...	16:59:00	16:59:00	...	13
...	17:03:00	17:03:00	...	14
...	17:11:00	17:11:00	...	15
...	17:16:00	17:16:00	...	16
...	17:23:00	17:23:00	...	17
...	17:32:00	17:32:00	...	18
...	17:38:00	17:38:00	...	19
...	17:43:00	17:43:00	...	20

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

stop_code	stop_name	stop_lat	stop_lon
heradajg	Merton Hotel	52.0588055647	-2.7098793988
heradapt	Railway Station	52.0616574748	-2.709574554
heradatm	Bridge Street	52.0539497722	-2.7189027674
heragdpt	Vowchurch Turn	52.0255265502	-2.9288770883
heragdtm	Green	52.0692521348	-3.00310937
heragdtw	Hardwicke Turn	52.088642804	-3.0757921424
herajmaw	Crossways	52.0387831711	-2.9520266547
heramgaw	Belmont Road	52.0439375396	-2.7300274821
heramjpm	Church	52.0169006374	-2.8408000253
heramjwa	Croft Road	52.0338858284	-2.8058703876
powagma	Bishop's Meadow	51.960290577	-3.3751195195
powdgat	Griffin Inn	51.9901051222	-3.3250011195
powajwj	Talgarth Road	52.0058646335	-3.2469840238
powgtpa	Three Cocks	52.0282323201	-3.2110203245
powdjgd	Glasbury Bridge	52.0443681391	-3.1963794826
powdmdt	Hay Castle	52.0733991737	-3.1253109531
powapwa	Castle Estate	52.0850485527	-3.1489114068
powagpt	Coleg Powys	51.952558575	-3.3812129104
powmapa	Nat West	51.9959947387	-3.2330908486
powmgtg	Interchange	51.9467871435	-3.3864772033