Ripon - Richmond - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:30:00	15:30:00	...	1
...	15:31:00	15:31:00	...	2
...	15:33:00	15:33:00	...	3
...	15:35:00	15:35:00	...	4
...	15:37:00	15:37:00	...	5
...	15:40:00	15:40:00	...	6
...	15:40:00	15:40:00	...	7
...	15:44:00	15:44:00	...	8
...	15:56:00	15:56:00	...	9
...	16:12:00	16:12:00	...	10
...	16:17:00	16:17:00	...	11
...	16:25:00	16:25:00	...	12
...	16:27:00	16:27:00	...	13
...	16:27:00	16:27:00	...	14
...	16:28:00	16:28:00	...	15
...	16:32:00	16:32:00	...	16
...	16:42:00	16:42:00	...	17
...	16:54:00	16:54:00	...	18
...	16:55:00	16:55:00	...	19
...	16:56:00	16:56:00	...	20
...	16:57:00	16:57:00	...	21

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

stop_code	stop_name	stop_lat	stop_lon
32001667	Market Place	54.30975454	-1.829809897
32001669	Middleham Road	54.3080302318	-1.8243917817
32090284	Market Place	54.4027596585	-1.7378317322
32090286	The Old Convent	54.4049884165	-1.750557587
32090288	Whitcliffe Place	54.4049150422	-1.7542244491
32090904	Market Place	54.2220276075	-1.6558810767
32090905	School	54.2693740392	-1.7792907924
32090906	West End Methodist Ch	54.2846834952	-1.8080248101
32090908	Wenslydale School	54.312698174	-1.8268773505
32090909	Mount Drive	54.3156862222	-1.8236367607
32090911	Cross Keys Inn	54.3313077628	-1.8248924961
32090963	School	54.1884633591	-1.5627255999
32090966	Cross Keys	54.1857921861	-1.5622021192
32090968	Lane End	54.1754323159	-1.553134902
32090970	The Terrace	54.1607070232	-1.5425427752
32090972	Ripon Golf Club	54.151247532	-1.5319753214
32091062	North Road	54.1424590915	-1.5186342466
32001022	The Bull Inn	54.204229476	-1.5888816217
32012800	Bus Station Stand 3	54.1368822641	-1.5220048895
32004327	The Vicarage	54.3763852097	-1.8297811695
32004463	Victoria Road	54.4045366635	-1.7408705959