Fairhill - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	10:25:00	10:25:00	...	1
...	10:25:03	10:25:03	...	2
...	10:26:16	10:26:16	...	3
...	10:27:00	10:27:00	...	4
...	10:27:29	10:27:29	...	5
...	10:28:15	10:28:15	...	6
...	10:29:00	10:29:00	...	7
...	10:30:00	10:30:00	...	8
...	10:31:00	10:31:00	...	9
...	10:32:26	10:32:26	...	10
...	10:33:00	10:33:00	...	11
...	10:33:11	10:33:11	...	12
...	10:33:49	10:33:49	...	13
...	10:34:19	10:34:19	...	14
...	10:34:49	10:34:49	...	15
...	10:35:23	10:35:23	...	16
...	10:36:00	10:36: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