stop_id	stop_name	direction	stop_desc	stop_lat	stop_lon	zone_id	location_type	parent_station
1713	N Fessenden & Midway	W	Westbound stop in Portland (Stop ID 1713)	45.593571	-122.735244	B	0

Service IDs for Thu Jul 18, 2019: 7.550, A.550, D.550, H.550, p.550, Q.550, W.550

t.route_id	r.route_short_name	r.route_long_name	st.stop_headsign	st.arrival_time	st.departure_time	t.service_id	t.block_id	st.trip_id	t.direction_id	st.timepoint	st.stop_sequence	st.pickup_type	st.drop_off_type	st.shape_dist_traveled
4	4	Fessenden	St Johns	05:02:48	05:02:48	W.550	401	9226006	0	0	26	0	0	19387
4	4	Fessenden	St Johns	05:40:48	05:40:48	W.550	467	9226007	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	05:44:00	05:44:00	W.550	1103	9227613	1	1	33	0	0	69771
4	4	Fessenden	St Johns	06:11:48	06:11:48	W.550	468	9226008	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	06:28:00	06:28:00	W.550	1101	9227614	1	1	33	0	0	69771
4	4	Fessenden	St Johns	06:31:48	06:31:48	W.550	469	9226009	0	0	59	0	0	49391
4	4	Fessenden	St Johns	06:51:48	06:51:48	W.550	470	9226010	0	0	59	0	0	49391
4	4	Fessenden	St Johns	07:07:52	07:07:52	W.550	471	9226011	0	0	59	0	0	49391
4	4	Fessenden	St Johns	07:17:52	07:17:52	W.550	472	9226012	0	0	59	0	0	49391
4	4	Fessenden	St Johns	07:28:52	07:28:52	W.550	401	9226013	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	07:31:00	07:31:00	W.550	1103	9227615	1	1	33	0	0	69771
4	4	Fessenden	St Johns	07:38:52	07:38:52	W.550	408	9226014	0	0	59	0	0	49391
4	4	Fessenden	St Johns	07:48:52	07:48:52	W.550	473	9226015	0	0	59	0	0	49391
4	4	Fessenden	St Johns	07:58:52	07:58:52	W.550	402	9226016	0	0	59	0	0	49391
4	4	Fessenden	St Johns	08:08:52	08:08:52	W.550	412	9226017	0	0	59	0	0	49391
4	4	Fessenden	St Johns	08:18:52	08:18:52	W.550	467	9226018	0	0	59	0	0	49391
4	4	Fessenden	St Johns	08:28:57	08:28:57	W.550	403	9226019	0	0	59	0	0	49391
4	4	Fessenden	St Johns	08:38:57	08:38:57	W.550	414	9226020	0	0	59	0	0	49391
4	4	Fessenden	St Johns	08:48:57	08:48:57	W.550	468	9226021	0	0	59	0	0	49391
4	4	Fessenden	St Johns	08:58:57	08:58:57	W.550	404	9226022	0	0	59	0	0	49391
4	4	Fessenden	St Johns	09:08:57	09:08:57	W.550	416	9226023	0	0	59	0	0	49391
4	4	Fessenden	St Johns	09:18:57	09:18:57	W.550	469	9226024	0	0	59	0	0	49391
4	4	Fessenden	St Johns	09:34:57	09:34:57	W.550	470	9226025	0	0	59	0	0	49391
4	4	Fessenden	St Johns	09:49:57	09:49:57	W.550	471	9226026	0	0	59	0	0	49391
4	4	Fessenden	St Johns	10:04:57	10:04:57	W.550	472	9226027	0	0	59	0	0	49391
4	4	Fessenden	St Johns	10:19:57	10:19:57	W.550	401	9226028	0	0	59	0	0	49391
4	4	Fessenden	St Johns	10:34:57	10:34:57	W.550	473	9226029	0	0	59	0	0	49391
4	4	Fessenden	St Johns	10:49:57	10:49:57	W.550	402	9226030	0	0	59	0	0	49391
4	4	Fessenden	St Johns	11:04:57	11:04:57	W.550	467	9226031	0	0	59	0	0	49391
4	4	Fessenden	St Johns	11:19:57	11:19:57	W.550	403	9226032	0	0	59	0	0	49391
4	4	Fessenden	St Johns	11:34:57	11:34:57	W.550	468	9226033	0	0	59	0	0	49391
4	4	Fessenden	St Johns	11:49:57	11:49:57	W.550	404	9226034	0	0	59	0	0	49391
4	4	Fessenden	St Johns	12:04:57	12:04:57	W.550	469	9226035	0	0	59	0	0	49391
4	4	Fessenden	St Johns	12:19:57	12:19:57	W.550	470	9226036	0	0	59	0	0	49391
4	4	Fessenden	St Johns	12:34:57	12:34:57	W.550	471	9226037	0	0	59	0	0	49391
4	4	Fessenden	St Johns	12:49:57	12:49:57	W.550	472	9226038	0	0	59	0	0	49391
4	4	Fessenden	St Johns	13:04:57	13:04:57	W.550	401	9226039	0	0	59	0	0	49391
4	4	Fessenden	St Johns	13:19:57	13:19:57	W.550	473	9226040	0	0	59	0	0	49391
4	4	Fessenden	St Johns	13:34:57	13:34:57	W.550	402	9226041	0	0	59	0	0	49391
4	4	Fessenden	St Johns	13:51:02	13:51:02	W.550	467	9226042	0	0	59	0	0	49391
4	4	Fessenden	St Johns	14:06:02	14:06:02	W.550	403	9226043	0	0	59	0	0	49391
4	4	Fessenden	St Johns	14:21:02	14:21:02	W.550	468	9226044	0	0	59	0	0	49391
4	4	Fessenden	St Johns	14:36:02	14:36:02	W.550	404	9226045	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	14:39:00	14:39:00	W.550	1102	9227616	1	1	33	0	0	69771
4	4	Fessenden	St Johns	14:51:02	14:51:02	W.550	469	9226046	0	0	59	0	0	49391
4	4	Fessenden	St Johns	15:07:02	15:07:02	W.550	470	9226047	0	0	59	0	0	49391
4	4	Fessenden	St Johns	15:22:02	15:22:02	W.550	471	9226048	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	15:30:00	15:30:00	W.550	1104	9227617	1	1	33	0	0	69771
4	4	Fessenden	St Johns	15:37:02	15:37:02	W.550	472	9226049	0	0	59	0	0	49391
4	4	Fessenden	St Johns	15:47:02	15:47:02	W.550	407	9226050	0	0	59	0	0	49391
4	4	Fessenden	St Johns	15:55:02	15:55:02	W.550	413	9226051	0	0	59	0	0	49391
4	4	Fessenden	St Johns	16:03:02	16:03:02	W.550	401	9226052	0	0	59	0	0	49391
4	4	Fessenden	St Johns	16:11:02	16:11:02	W.550	473	9226053	0	0	59	0	0	49391
4	4	Fessenden	St Johns	16:19:02	16:19:02	W.550	415	9226054	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	16:22:00	16:22:00	W.550	1102	9227618	1	1	33	0	0	69771
4	4	Fessenden	St Johns	16:29:02	16:29:02	W.550	409	9226055	0	0	59	0	0	49391
4	4	Fessenden	St Johns	16:42:02	16:42:02	W.550	402	9226056	0	0	59	0	0	49391
4	4	Fessenden	St Johns	16:55:02	16:55:02	W.550	467	9226057	0	0	59	0	0	49391
4	4	Fessenden	St Johns	17:08:02	17:08:02	W.550	403	9226058	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	17:19:00	17:19:00	W.550	1104	9227619	1	1	33	0	0	69771
4	4	Fessenden	St Johns	17:20:02	17:20:02	W.550	468	9226059	0	0	59	0	0	49391
4	4	Fessenden	St Johns	17:33:02	17:33:02	W.550	404	9226060	0	0	59	0	0	49391
4	4	Fessenden	St Johns	17:46:02	17:46:02	W.550	405	9226061	0	0	59	0	0	49391
4	4	Fessenden	St Johns	17:56:02	17:56:02	W.550	469	9226062	0	0	59	0	0	49391
4	4	Fessenden	St Johns	18:05:57	18:05:57	W.550	470	9226063	0	0	59	0	0	49391
11	11	Rivergate/Marine Dr	St Johns	18:15:00	18:15:00	W.550	1102	9227620	1	1	33	0	0	69771
4	4	Fessenden	St Johns	18:16:57	18:16:57	W.550	471	9226064	0	0	59	0	0	49391
4	4	Fessenden	St Johns	18:26:57	18:26:57	W.550	406	9226065	0	0	59	0	0	49391
4	4	Fessenden	St Johns	18:38:57	18:38:57	W.550	407	9226066	0	0	59	0	0	49391
4	4	Fessenden	St Johns	18:52:57	18:52:57	W.550	401	9226067	0	0	59	0	0	49391
4	4	Fessenden	St Johns	19:04:52	19:04:52	W.550	473	9226068	0	0	59	0	0	49391
4	4	Fessenden	St Johns	19:16:52	19:16:52	W.550	415	9226069	0	0	59	0	0	49391
4	4	Fessenden	St Johns	19:29:52	19:29:52	W.550	402	9226070	0	0	59	0	0	49391
4	4	Fessenden	St Johns	19:42:52	19:42:52	W.550	467	9226071	0	0	59	0	0	49391
4	4	Fessenden	St Johns	19:54:52	19:54:52	W.550	403	9226072	0	0	59	0	0	49391
4	4	Fessenden	St Johns	20:09:52	20:09:52	W.550	468	9226073	0	0	59	0	0	49391
4	4	Fessenden	St Johns	20:24:52	20:24:52	W.550	404	9226074	0	0	59	0	0	49391
4	4	Fessenden	St Johns	20:39:48	20:39:48	W.550	405	9226075	0	0	59	0	0	49391
4	4	Fessenden	St Johns	20:54:48	20:54:48	W.550	470	9226076	0	0	59	0	0	49391
4	4	Fessenden	St Johns	21:09:48	21:09:48	W.550	406	9226077	0	0	59	0	0	49391
4	4	Fessenden	St Johns	21:24:48	21:24:48	W.550	407	9226078	0	0	59	0	0	49391
4	4	Fessenden	St Johns	21:39:48	21:39:48	W.550	401	9226079	0	0	59	0	0	49391
4	4	Fessenden	St Johns	21:54:48	21:54:48	W.550	473	9226080	0	0	59	0	0	49391
4	4	Fessenden	St Johns	22:14:48	22:14:48	W.550	402	9226081	0	0	59	0	0	49391
4	4	Fessenden	St Johns	22:34:48	22:34:48	W.550	467	9226082	0	0	59	0	0	49391
4	4	Fessenden	St Johns	22:53:48	22:53:48	W.550	468	9226083	0	0	59	0	0	49391
4	4	Fessenden	St Johns	23:13:48	23:13:48	W.550	404	9226084	0	0	59	0	0	49391
4	4	Fessenden	St Johns	23:33:48	23:33:48	W.550	405	9226085	0	0	59	0	0	49391
4	4	Fessenden	St Johns	23:53:48	23:53:48	W.550	406	9226086	0	0	59	0	0	49391
4	4	Fessenden	St Johns	24:13:43	24:13:43	W.550	407	9226087	0	0	59	0	0	49391
4	4	Fessenden	St Johns	24:43:43	24:43:43	W.550	473	9226088	0	0	59	0	0	49391
4	4	Fessenden	St Johns	25:13:43	25:13:43	W.550	402	9226089	0	0	59	0	0	49391
4	4	Fessenden	St Johns	26:22:43	26:22:43	W.550	407	9226090	0	0	59	0	0	49391