Heath Hospital - Sports Village - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
cdipagd	West Grove 1	51.4840264368	-3.1677995196
cdimwjm	Infirmary 1	51.4848019121	-3.1657742458
cdidawd	Woodville Road	51.4946731971	-3.1767579484
cdiatwd	Monthermer Road	51.4957538825	-3.1792779359
cdiatdm	Gladstone School	51.4974443358	-3.1828510528
cdidwjd	Childrens Unit	51.5082876572	-3.1882760863
cdidwtd	Main Entrance	51.5061730773	-3.188422787
cdidwmt	Heath Park Way	51.5085808781	-3.1912809046
cdidtam	Interchange Bay 6	51.5043332437	-3.1969189859
cdijtmd	Maitland Street	51.5037774551	-3.1949881497
cdijtmg	Newfoundland Rd	51.5025109911	-3.1904310132
cdijtgp	Companies House	51.5005458393	-3.1873687291
cdijtja	Heath Hotel	51.4989435016	-3.1848779711
cdidatm	Strathnairn Street	51.491895264	-3.1713136071
cdimwmj	Northcote Lane	51.4900138412	-3.1697241848
cdipada	St Peter's Street	51.4874068618	-3.166949717
cdiajmg	Wyndham Arcade Stop NA	51.4773067918	-3.1770596459
cdimagp	Stockland St	51.467685558	-3.1886316475
cdimagw	Wilfred Brook House	51.4663522386	-3.1879923509
cdijwtw	Bromsgrove Street	51.4651804362	-3.1873860773
cdidtd	Clive Street	51.4627737478	-3.186186384
cdijam	Staples	51.460341023	-3.1866702838
cditawa	Cardiff Bay Asda	51.457519669	-3.184682767
cdidtmw	Clare Road	51.4741833761	-3.1871879143
cdiagtp	Durham Street	51.4707823024	-3.186509306
cdimadp	North Clive Street	51.4688199956	-3.1884883704
cdimtdj	Fitzhamon Embankment	51.4762869318	-3.1836858946
cdimpjd	Beauchamp Street	51.4766707641	-3.1866333292
cdimadg	Dunleavy Drive	51.4533391536	-3.1908207147
cditdwa	Watkiss Way	51.4483236076	-3.1835236916
cditdwp	Watkiss Way	51.4495307145	-3.1868648298
cditgmw	Dunleavy Drive	51.4544270848	-3.1881720263
cditgtw	Watkiss Way	51.4514654744	-3.1876058082
cditgwp	Bute Terrace	51.4775326613	-3.1733647252
cditmjd	Dental Hospital	51.5066399369	-3.1920371729
cditmpa	Churchill Way	51.4814066912	-3.1726145144
cditpgj	Wood Street	51.4775873938	-3.1786652456