Blaencwm - Caerphilly - Transport Data Hub

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

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
rhojdja	Miskin Hotel	51.6198671365	-3.4477024958
rhojdma	Rhys Street	51.6227608031	-3.4507560541
rhojdmp	Lee`s Takeaway	51.6249256366	-3.4516630323
rhojdgt	Colliers Arms	51.6276458999	-3.4520099393
rhojdap	Ynyscynon Road	51.6291338049	-3.45166736
rhojdmw	Ynyscynon Park	51.632207638	-3.4495981566
rhojadt	Bus Station	51.6255826685	-3.4581417972
rhogwtj	War Memorial	51.6234935312	-3.456211235
rhogwtw	Steps	51.6224239823	-3.4539956472
rhogwtm	Co-op	51.6201283976	-3.4520299315
rhogdtd	Rugby Club	51.6175549574	-3.4492611169
rhogdtg	Post Office	51.6142346932	-3.4479854218
rhodpdp	Merlin Bridge	51.6040250282	-3.3479088143
rhodpda	Castle Ivor	51.6045140349	-3.3546379542
rhodpdj	Primary School	51.6052663424	-3.3580105144
rhodpap	Hollybush	51.6067640478	-3.359903641
rhodpam	Barry Sidings	51.6087403786	-3.3662591941
rhoajwd	Eirw Road	51.6097635174	-3.4007481233
rhogpdt	Morrisons	51.6101720643	-3.4056854191
rhogpdm	Llwyncelyn Hotel	51.6109751282	-3.402446285
rhopajd	Bus Station	51.605540469	-3.3396360135
rhopapm	Catherine Street	51.6019631616	-3.3418698746
rhopjtg	Swan Terrace	51.6137398011	-3.446554237
rhopdpa	Britannia Street	51.6092118355	-3.3987526287
rhopwma	Workingman's Club	51.6345040592	-3.448587655
rhotapm	Lidl	51.6020242477	-3.3459580031