Jennyfield - Harrogate - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:43:00	07:43:00	...	1
...	07:45:00	07:45:00	...	2
...	07:47:00	07:47:00	...	3
...	07:48:00	07:48:00	...	4
...	07:50:00	07:50:00	...	5
...	07:51:00	07:51:00	...	6
...	07:52:00	07:52:00	...	7
...	07:53:00	07:53:00	...	8
...	07:54:00	07:54:00	...	9
...	07:57:00	07:57:00	...	10
...	07:58:00	07:58:00	...	11
...	07:58:00	07:58:00	...	12
...	08:00:00	08:00:00	...	13
...	08:03:00	08:03:00	...	14
...	08:04:00	08:04:00	...	15
...	08:06:00	08:06:00	...	16
...	08:08:00	08:08:00	...	17
...	08:10:00	08:10:00	...	18
...	08:11:00	08:11:00	...	19
...	08:12:00	08:12:00	...	20
...	08:13:00	08:13:00	...	21
...	08:14:00	08:14:00	...	22
...	08:15:00	08:15:00	...	23
...	08:18:00	08:18:00	...	24
...	08:20:00	08:20:00	...	25
...	08:22:00	08:22:00	...	26
...	08:30:00	08:30:00	...	27
...	08:31:00	08:31:00	...	28
...	08:34:00	08:34:00	...	29
...	08:35:00	08:35:00	...	30

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

stop_code	stop_name	stop_lat	stop_lon
32006396	Coach Road	53.9839328166	-1.5203714377
32096399	Saltergate Drive	54.0034519706	-1.5671680083
32096424	Richard Taylor Sch	54.0088245157	-1.5329636442
32096873	Sandhill Way	54.0112682777	-1.5235669832
32096874	Playing Fields	54.014778496	-1.5271131787
32012560	Hydro	54.0037171753	-1.5488419822
32012570	Little Wonder PH	54.0061309886	-1.5502043306
32013100	Cheltenham Crescent	53.9952808558	-1.5425418784
32013120	Hgte Bus Stn Stand 2	53.9940064797	-1.5383307187
32013470	Kings Road Post Office	54.0031512145	-1.5370853487
32013530	St Joseph's Church	54.006053684	-1.5439953431
32013540	Bar Chapel	54.0057096617	-1.5409781321
32013550	King Edward Dr Top	54.0047483186	-1.5363810681
32013570	Chatsworth Place	54.0009995257	-1.5384822219
32020640	Hall Lane	54.010784466	-1.5331248208
32020650	Hall Lane Corner	54.0121408388	-1.5352460146
32020760	Poplar Grove	54.0072058026	-1.530418418
32020770	King Edwards Dr PO	54.0060754555	-1.533269042
32020920	Poplar Crescent	54.0091200655	-1.5235304733
32020930	Grosvenor Road	54.0085112681	-1.526406014
32020940	Cinder Path	54.0079253589	-1.5282589101
32021120	Opp Civic Centre	53.9995577044	-1.5398406163
32057010	Library Gardens	53.9910901757	-1.5372190528
32057030	Slingsby Walk	53.9879984794	-1.525708338
32057040	St Aidans School	53.9863110946	-1.5240194607
32057050	St John Fisher School	53.9841982361	-1.5193161694
32080720	Saltergate Rdbt	54.0012769408	-1.5747269155
32080760	Harewood Road	54.0030914117	-1.5594519827
32080770	Co-Op	54.002974542	-1.5569969339
32080780	Hydro	54.0017334985	-1.5519451251