Aldershot - Farnham - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:05:00	08:05:00	...	1
...	08:06:00	08:06:00	...	2
...	08:08:00	08:08:00	...	3
...	08:10:00	08:10:00	...	4
...	08:11:00	08:11:00	...	5
...	08:13:00	08:13:00	...	6
...	08:13:00	08:13:00	...	7
...	08:15:00	08:15:00	...	8
...	08:15:00	08:15:00	...	9
...	08:16:00	08:16:00	...	10
...	08:18:00	08:18:00	...	11
...	08:19:00	08:19:00	...	12
...	08:20:00	08:20:00	...	13
...	08:21:00	08:21:00	...	14
...	08:23:00	08:23:00	...	15
...	08:24:00	08:24:00	...	16
...	08:25:00	08:25:00	...	17
...	08:25:00	08:25:00	...	18
...	08:26:00	08:26:00	...	19
...	08:27:00	08:27:00	...	20
...	08:29:00	08:29:00	...	21
...	08:30:00	08:30:00	...	22
...	08:31:00	08:31:00	...	23
...	08:32:00	08:32:00	...	24
...	08:34:00	08:34:00	...	25
...	08:36:00	08:36:00	...	26

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

stop_code	stop_name	stop_lat	stop_lon
hamgwtjp	Bus Station	51.2464349512	-0.760575729
hamgwtdt	High Street Library	51.2498328286	-0.762160839
hamgwpmj	Short Street	51.250083744	-0.7663380677
hamgwmwt	Queens Road	51.2476615997	-0.7720194002
hamgwmta	Sandford Road	51.246936471	-0.7749042412
hamgwjwg	Chetwode Terrace	51.2474169783	-0.7813103306
hamgwjgm	Cranmore Lane	51.2431401948	-0.7859791589
surgjdmt	Union Road	51.2133708935	-0.7968414087
surgjdpd	East Street Shops	51.2162254199	-0.7963517917
surgjdta	East Street	51.2183350618	-0.791643191
surgjdtg	Adams Park Road	51.2193217218	-0.7879230451
surgjgdj	Farnham Hospital North	51.2215089699	-0.7846579862
surgjgja	Six Bells Roundabout	51.2263538299	-0.7835995184
surgjgmj	St John's Church	51.2290620175	-0.7854759342
surgjgpw	Post Office	51.2380367564	-0.7881189571
surgjgtd	The Alma	51.237600111	-0.7919837825
surgjgtj	Heath Lane	51.2370146372	-0.7953797081
surgjgtp	Trimmers Close	51.2369531653	-0.7972721511
surgjgwa	Sturt Road	51.2381620285	-0.7994036931
surgjgwg	Blackheath Road	51.2366791749	-0.8074066715
surgjgwj	Eton Place	51.2371289123	-0.8047736481
surgjgwp	Brookside	51.2316652556	-0.7902485504
surgjmad	Vicarage Lane	51.2337057599	-0.7936613402
surgjmam	Hereford Lane	51.2344993981	-0.800888414
surgjmat	Hale School	51.2351622375	-0.8041513739
surgjmgw	Sports Centre	51.2165397736	-0.79369473