Merthyr Tydfil - Bargoed - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	19:11:00	19:11:00	...	1
...	19:14:00	19:14:00	...	2
...	19:14:00	19:14:00	...	3
...	19:15:00	19:15:00	...	4
...	19:16:00	19:16:00	...	5
...	19:16:00	19:16:00	...	6
...	19:17:00	19:17:00	...	7
...	19:18:00	19:18:00	...	8
...	19:18:00	19:18:00	...	9
...	19:19:00	19:19:00	...	10
...	19:23:00	19:23:00	...	11
...	19:24:00	19:24:00	...	12
...	19:25:00	19:25:00	...	13
...	19:26:00	19:26:00	...	14
...	19:26:00	19:26:00	...	15
...	19:27:00	19:27:00	...	16
...	19:28:00	19:28:00	...	17
...	19:28:00	19:28:00	...	18
...	19:28:00	19:28:00	...	19
...	19:30:00	19:30:00	...	20
...	19:30:00	19:30:00	...	21
...	19:31:00	19:31:00	...	22
...	19:33:00	19:33:00	...	23
...	19:34:00	19:34:00	...	24
...	19:36:00	19:36:00	...	25
...	19:36:00	19:36:00	...	26
...	19:36:00	19:36:00	...	27
...	19:38:00	19:38:00	...	28
...	19:39:00	19:39:00	...	29
...	19:40:00	19:40:00	...	30
...	19:40:00	19:40:00	...	31
...	19:41:00	19:41:00	...	32
...	19:41:00	19:41:00	...	33
...	19:41:00	19:41:00	...	34
...	19:42:00	19:42:00	...	35
...	19:42:00	19:42:00	...	36
...	19:43:00	19:43:00	...	37
...	19:46:00	19:46:00	...	38
...	19:48:00	19:48:00	...	39
...	19:48:00	19:48:00	...	40
...	19:49:00	19:49:00	...	41
...	19:50:00	19:50:00	...	42
...	19:50:00	19:50:00	...	43
...	19:52:00	19:52:00	...	44
...	19:53:00	19:53:00	...	45
...	19:54:00	19:54:00	...	46
...	19:54:00	19:54:00	...	47
...	19:55:00	19:55:00	...	48
...	19:56:00	19:56:00	...	49

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

stop_code	stop_name	stop_lat	stop_lon
mtyagtg	Tredegar Arms	51.7639519232	-3.3408722804
mtyagpw	Coedcae	51.7632879268	-3.3431131559
mtyagtm	Antelope	51.7624865716	-3.3455672392
mtyagmw	Market Street	51.7608655622	-3.3512715493
mtyawjt	Flats	51.7592010799	-3.3583796267
mtydadm	Norton	51.7577961069	-3.3632347339
mtyawpw	Steps	51.75615291	-3.3669087751
mtyawtg	Club	51.7534586547	-3.371260618
mtydmap	High Street Nursing Home	51.7530284768	-3.3742175194
mtydmgm	Bus Station	51.7457987907	-3.3803860289
cpydpgj	Rhymney Bridge	51.7769357972	-3.295989122
cpyjapa	Pen-y-Dre	51.7695431918	-3.2895889527
cpyjapg	Carno Street	51.7676243636	-3.2890994931
cpyjapj	Albion Square	51.7661166331	-3.288839159
cpyjapt	St David's Church	51.7636298219	-3.287667023
cpydpmd	The Royal	51.7605757996	-3.2857399137
cpydpta	Library	51.7595751136	-3.2843349831
cpydpgt	Harvards Row	51.7590249791	-3.2820155743
cpydpjm	Queens Square	51.7558401115	-3.2813603148
cpydpgp	Wellington Way	51.7529277437	-3.28045209
cpydmwp	Maerdy Crossing	51.7510557046	-3.2789649495
cpydpaj	The Square	51.7479394089	-3.281093226
cpydpaw	Sunny View	51.743031196	-3.2801577253
cpydmtm	Brynhyfryd Bottom	51.7442452297	-3.2842622079
cpydmtw	Brynhyfryd Middle	51.7449380023	-3.2842239191
cpydpdm	Brynhyfryd Top	51.7466054075	-3.2863281292
cpyawjw	Heol y Bryn	51.7454257788	-3.2938557513
cpyawmd	Pontlottyn Road	51.7434529822	-3.2950015753
cpydmwd	Community Centre	51.7410579026	-3.2969318092
cpydpdg	Pleasant View	51.7402301352	-3.2969805184
cpydpdj	Pleasant View	51.7400500398	-3.2970043267
cpyawmt	Heol Iago Playground	51.7385284971	-3.2963669576
cpyawmj	Coronation Crescent	51.7373844298	-3.2949294191
cpyawmp	Glan-y-nant	51.7385579194	-3.2945140082
cpydpap	Station Terrace	51.7398672884	-3.2988963877
cpydjwg	Mount Pleasant	51.7322569864	-3.2983885364
cpydmat	Parc Cwm Darran	51.7223707187	-3.2857124426
cpydgpt	Ogilvie Terrace	51.716356608	-3.2707187862
cpydgmw	Bargoed Terrace	51.7141493259	-3.2677908727
cpyawaj	Library	51.7089777484	-3.2654173642
cpyawda	Darran Hotel	51.7078049564	-3.2632715895
cpyawat	New Road	51.7059514642	-3.2600360443
cpyagmt	Groesfaen Terrace	51.6962210245	-3.2475392577
cpyagpw	Puzzle House	51.6977680512	-3.2390013087
cpyagma	Factory Road	51.696084504	-3.2349329078
cpyagjp	Viaduct	51.6948518265	-3.2315860127
cpyjmwd	Pentwyn Farm	51.776542173	-3.299065258
cpyjpad	Station	51.6927347005	-3.2294017315
cpyjpjw	Interchange	51.6913320395	-3.2285390661