Scarborough - Pickering - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:49:00	07:49:00	...	1
...	07:50:00	07:50:00	...	2
...	07:52:00	07:52:00	...	3
...	07:55:00	07:55:00	...	4
...	07:59:00	07:59:00	...	5
...	08:01:00	08:01:00	...	6
...	08:03:00	08:03:00	...	7
...	08:03:00	08:03:00	...	8
...	08:04:00	08:04:00	...	9
...	08:06:00	08:06:00	...	10
...	08:07:00	08:07:00	...	11
...	08:12:00	08:12:00	...	12
...	08:13:00	08:13:00	...	13
...	08:17:00	08:17:00	...	14
...	08:20:00	08:20:00	...	15
...	08:23:00	08:23:00	...	16
...	08:25:00	08:25:00	...	17
...	08:29:00	08:29:00	...	18
...	08:29:00	08:29:00	...	19
...	08:30:00	08:30:00	...	20
...	08:30:00	08:30:00	...	21
...	08:31:00	08:31:00	...	22
...	08:32:00	08:32:00	...	23
...	08:35:00	08:35:00	...	24
...	08:41:00	08:41:00	...	25

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

stop_code	stop_name	stop_lat	stop_lon
32001061	Carr Lane	54.2507655878	-0.4777981545
32001063	Methodist Church	54.2488903214	-0.4859098594
32001065	Bus Shelter	54.2444887598	-0.5062982727
32001067	Wykeham Crossroads	54.2367033407	-0.5214784607
32001069	Ruston Farm	54.23459655	-0.5307443296
32001071	Cayley Arms	54.2269914874	-0.5521993828
32001073	West Brow	54.2274018385	-0.5586893716
32001075	Wydale Lane End	54.2268498133	-0.567421847
32001077	Barkers Lane	54.2267823874	-0.5822427875
32001080	Station Road	54.2283199104	-0.5907195415
32001081	Mill Lane	54.2292296518	-0.6227666123
32001083	Brook House Farm	54.2346523811	-0.6222331835
32001085	Turgate Farm	54.2351325873	-0.656815962
32001087	Village Hall	54.2350627873	-0.6814284837
32001089	Hilltop	54.2378583575	-0.7071787285
32001093	Eastfield Road	54.2406280008	-0.7664925993
32001095	The Royal Oak	54.2434763405	-0.7743415145
32001097	The Library	54.2458640225	-0.7793505535
32090763	Thornton Cross	54.2361494585	-0.7213940679
32096560	Castlegate	54.2500173638	-0.4826145944
32096563	Thornton Road	54.239925684	-0.7628615125
32096564	Thornton Road Industrial Est	54.2385482645	-0.7591433898
32002026	Potter Hill	54.2473021668	-0.7838048819
32010031	Lady Lumley's School	54.2511845576	-0.7846576512
32010038	Eastcroft	54.2416302273	-0.7695778037