Fairhill - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:57:00	14:57:00	...	1
...	14:57:03	14:57:03	...	2
...	14:58:16	14:58:16	...	3
...	14:59:00	14:59:00	...	4
...	14:59:59	14:59:59	...	5
...	15:01:31	15:01:31	...	6
...	15:03:00	15:03:00	...	7
...	15:04:00	15:04:00	...	8
...	15:05:00	15:05:00	...	9
...	15:07:09	15:07:09	...	10
...	15:08:00	15:08:00	...	11
...	15:08:07	15:08:07	...	12
...	15:08:33	15:08:33	...	13
...	15:08:52	15:08:52	...	14
...	15:09:12	15:09:12	...	15
...	15:09:35	15:09:35	...	16
...	15:10:00	15:10: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