Porth - Wattstown - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:00:00	08:00:00	...	1
...	08:01:00	08:01:00	...	2
...	08:02:00	08:02:00	...	3
...	08:03:00	08:03:00	...	4
...	08:04:00	08:04:00	...	5
...	08:05:00	08:05:00	...	6
...	08:05:00	08:05:00	...	7
...	08:05:00	08:05:00	...	8
...	08:06:00	08:06:00	...	9
...	08:09:00	08:09:00	...	10
...	08:11:00	08:11:00	...	11
...	08:11:00	08:11:00	...	12
...	08:14:00	08:14:00	...	13
...	08:15:00	08:15:00	...	14
...	08:15:00	08:15:00	...	15
...	08:16:00	08:16:00	...	16
...	08:17:00	08:17:00	...	17
...	08:18:00	08:18:00	...	18
...	08:19:00	08:19:00	...	19
...	08:19:00	08:19:00	...	20
...	08:20:00	08:20:00	...	21
...	08:23:00	08:23:00	...	22
...	08:28:00	08:28:00	...	23
...	08:30:00	08:30:00	...	24

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
rhojtpw	New Offices	51.6164716485	-3.4119899017
rhojwaw	Workingmen`s Club	51.6198778296	-3.4113878394
rhojtpg	Llanwonno Road	51.6221512369	-3.411516178
rhojtwd	Gynor Place	51.6252573193	-3.4111936376
rhojtwp	Station Hotel	51.6267584051	-3.4112402255
rhojwap	Wilpak	51.6289916875	-3.4117140887
rhojwaj	Rugby Club	51.6317693917	-3.4132741282
rhojtdm	Calfaria House	51.6341690844	-3.4178425687
rhojtgp	Wattstown Hotel	51.6341585998	-3.4201975312
rhojtgt	Wattstown Hotel	51.6339533369	-3.4208124496
rhojtgm	Hillside Terrace	51.6348919179	-3.4182986109
rhojtdg	Bryn Terrace	51.6359365893	-3.4189092154
rhojtdj	Bryn Terrace	51.6360446258	-3.4188981377
rhojtdt	Cefn Road	51.6360706247	-3.4197226128
rhojtga	Heol Goronwy	51.6372636476	-3.4199621862
rhojtdw	Heol Ceiriog	51.6367302547	-3.4209426036
rhojtgd	Heol Llechau	51.6367851609	-3.4201206436
rhogpdt	Morrisons	51.6101720643	-3.4056854191
rhogpdp	Mary Street	51.6138390037	-3.4088317908
rhogpdj	Llwyncelyn Hotel	51.611124311	-3.4027541718
rhojtgj	Heol y Twyn	51.6381594234	-3.4209872843
rhogpgt	Bus Depot	51.6150720796	-3.4109787392
rhopjwa	Primrose Terrace	51.6111502778	-3.3990721875