Pontypridd - Bridgend - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:22:00	07:22:00	...	1
...	07:27:00	07:27:00	...	2
...	07:29:00	07:29:00	...	3
...	07:30:00	07:30:00	...	4
...	07:31:00	07:31:00	...	5
...	07:32:00	07:32:00	...	6
...	07:32:00	07:32:00	...	7
...	07:33:00	07:33:00	...	8
...	07:34:00	07:34:00	...	9
...	07:35:00	07:35:00	...	10
...	07:36:00	07:36:00	...	11
...	07:36:00	07:36:00	...	12
...	07:38:00	07:38:00	...	13
...	07:42:00	07:42:00	...	14
...	07:44:00	07:44:00	...	15
...	07:45:00	07:45:00	...	16
...	07:47:00	07:47:00	...	17
...	07:47:00	07:47:00	...	18
...	07:48:00	07:48:00	...	19
...	07:48:00	07:48:00	...	20
...	07:53:00	07:53:00	...	21

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

stop_code	stop_name	stop_lat	stop_lon
rhoagwj	Heol Seward	51.5505778201	-3.3618617568
rhoajag	Heol Caerlan	51.5530823581	-3.3622250478
rhoajaj	Llwyncrwn Road	51.555805403	-3.3608062502
rhoagpw	Square	51.5579232327	-3.3580709543
rhoagtg	Brynteg Lane	51.5485281964	-3.361814962
rhodptm	Dan Caerlan	51.5447765795	-3.3697067018
rhodpwa	Ruperra Street	51.5431851125	-3.3727737791
rhodpwt	Wheatsheaf	51.541433858	-3.3733555552
rhodpwj	Southgate	51.5400951998	-3.3732575687
rhogwat	Leisure Centre	51.5390330156	-3.3787193854
rhopapg	Sardis House	51.6003959677	-3.3420980049
rhodjwp	Rose & Crown	51.5978032905	-3.3431477186
rhodjtm	Penrhiw Road	51.5953652756	-3.3471759478
rhogdjw	Burns Way	51.5875163329	-3.3502203951
rhogdmg	Queen`s Head	51.5809454831	-3.3578192148
rhojwgd	Royal Glamorgan Hospital	51.548239573	-3.3925258941
rhopajm	Bus Station	51.6056221924	-3.3395662171
rhodjwt	Temple	51.5971207614	-3.3446435435
rhogwdm	Bus Station	51.5374032652	-3.3842502418
rhopgwa	Rhodfa Marics	51.5455655508	-3.3920548568
rhoptjw	Glen Transport	51.5760934995	-3.358280689