Fairhill - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:38:00	15:38:00	...	1
...	15:38:05	15:38:05	...	2
...	15:39:54	15:39:54	...	3
...	15:41:00	15:41:00	...	4
...	15:42:29	15:42:29	...	5
...	15:44:46	15:44:46	...	6
...	15:47:00	15:47:00	...	7
...	15:48:30	15:48:30	...	8
...	15:50:00	15:50:00	...	9
...	15:52:52	15:52:52	...	10
...	15:54:00	15:54:00	...	11
...	15:54:11	15:54:11	...	12
...	15:54:49	15:54:49	...	13
...	15:55:19	15:55:19	...	14
...	15:55:49	15:55:49	...	15
...	15:56:23	15:56:23	...	16
...	15:57:00	15:57: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