Fairhill - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:25:00	08:25:00	...	1
...	08:25:05	08:25:05	...	2
...	08:26:54	08:26:54	...	3
...	08:28:00	08:28:00	...	4
...	08:28:29	08:28:29	...	5
...	08:29:15	08:29:15	...	6
...	08:30:00	08:30:00	...	7
...	08:31:00	08:31:00	...	8
...	08:32:00	08:32:00	...	9
...	08:33:26	08:33:26	...	10
...	08:34:00	08:34:00	...	11
...	08:34:11	08:34:11	...	12
...	08:34:49	08:34:49	...	13
...	08:35:19	08:35:19	...	14
...	08:35:49	08:35:49	...	15
...	08:36:23	08:36:23	...	16
...	08:37:00	08:37:00	...	17

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

stop_code	stop_name	stop_lat	stop_lon
75232825	Meikle Earnock Road	55.7576857071	-4.0569773101
75232485	Woodhead Lane	55.7583104863	-4.0604527999
75234624	Balmore Drive	55.759143175	-4.0643856615
75235976	Dee Terrace	55.7615480147	-4.0656763388
75232362	Chriss Avenue	55.7566753552	-4.0475211484
75232857	Retail Park	55.777321708	-4.0300114768
75234623	Retail Park	55.7775142224	-4.0297823044
75234835	Irvine Terrace	55.757935949	-4.0468381534
75234795	Jack Street	55.7611747092	-4.0450155051
75232383	School Street	55.7634080257	-4.0431240187
75234637	Morris Street	55.7657347935	-4.0415560222
75235785	Portland Park	55.7685781232	-4.0397278745
75235837	Woodside Walk	55.7715046182	-4.0377603184
75235869	John Street	55.7735012	-4.0371311105
75236838	Albany Road	55.7565975845	-4.0489514174
75235379	Scotia Gardens	55.7572776617	-4.053433641
75234936	Miller Street	55.7733809508	-4.032453251