stop_id	stop_name	direction	stop_desc	stop_lat	stop_lon	zone_id	location_type	parent_station
6364	N Williams & NE Morris	N	Northbound stop in Portland (Stop ID 6364)	45.544439	-122.666542	B	0

Service IDs for Fri Jul 19, 2019: 7.550, A.550, D.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:14:54	05:14:54	W.550	467	9226007	0	0	13	0	0	13489
4	4	Fessenden	St Johns	05:44:54	05:44:54	W.550	468	9226008	0	0	13	0	0	13489
4	4	Fessenden	St Johns	06:04:54	06:04:54	W.550	469	9226009	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	06:10:00	06:10:00	W.550	4471	9232154	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	06:22:07	06:22:07	W.550	2467	9230887	1	0	9	0	0	22525
4	4	Fessenden	St Johns	06:24:15	06:24:15	W.550	470	9226010	0	0	13	0	0	13489
4	4	Fessenden	St Johns	06:39:15	06:39:15	W.550	471	9226011	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	06:40:00	06:40:00	W.550	4472	9232155	1	1	48	0	0	51801
4	4	Fessenden	St Johns	06:49:15	06:49:15	W.550	472	9226012	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	06:51:26	06:51:26	W.550	2468	9230888	1	0	9	0	0	22525
4	4	Fessenden	St Johns	06:58:36	06:58:36	W.550	401	9226013	0	0	13	0	0	13489
4	4	Fessenden	St Johns	07:07:58	07:07:58	W.550	408	9226014	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	07:10:00	07:10:00	W.550	4411	9232156	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	07:11:26	07:11:26	W.550	2438	9230889	1	0	9	0	0	22525
4	4	Fessenden	St Johns	07:17:58	07:17:58	W.550	473	9226015	0	0	13	0	0	13489
4	4	Fessenden	St Johns	07:27:58	07:27:58	W.550	402	9226016	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	07:30:44	07:30:44	W.550	2469	9230890	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	07:34:00	07:34:00	W.550	4413	9232157	1	1	48	0	0	51801
4	4	Fessenden	St Johns	07:37:19	07:37:19	W.550	412	9226017	0	0	13	0	0	13489
4	4	Fessenden	St Johns	07:47:19	07:47:19	W.550	467	9226018	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	07:50:44	07:50:44	W.550	2434	9230891	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	07:56:00	07:56:00	W.550	4467	9232158	1	1	48	0	0	51801
4	4	Fessenden	St Johns	07:57:19	07:57:19	W.550	403	9226019	0	0	13	0	0	13489
4	4	Fessenden	St Johns	08:07:19	08:07:19	W.550	414	9226020	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	08:10:44	08:10:44	W.550	2435	9230892	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	08:12:00	08:12:00	W.550	4405	9232159	1	1	48	0	0	51801
4	4	Fessenden	St Johns	08:17:19	08:17:19	W.550	468	9226021	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	08:27:00	08:27:00	W.550	4468	9232160	1	1	48	0	0	51801
4	4	Fessenden	St Johns	08:27:19	08:27:19	W.550	404	9226022	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	08:30:44	08:30:44	W.550	2436	9230893	1	0	9	0	0	22525
4	4	Fessenden	St Johns	08:37:19	08:37:19	W.550	416	9226023	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	08:44:00	08:44:00	W.550	4469	9232162	1	1	48	0	0	51801
4	4	Fessenden	St Johns	08:47:19	08:47:19	W.550	469	9226024	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	08:50:44	08:50:44	W.550	2467	9230894	1	0	9	0	0	22525
4	4	Fessenden	St Johns	09:02:19	09:02:19	W.550	470	9226025	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	09:07:00	09:07:00	W.550	4470	9232164	1	1	48	0	0	51801
4	4	Fessenden	St Johns	09:17:19	09:17:19	W.550	471	9226026	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	09:21:26	09:21:26	W.550	2468	9230895	1	0	9	0	0	22525
4	4	Fessenden	St Johns	09:32:19	09:32:19	W.550	472	9226027	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	09:36:00	09:36:00	W.550	4471	9232166	1	1	48	0	0	51801
4	4	Fessenden	St Johns	09:47:19	09:47:19	W.550	401	9226028	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	09:51:26	09:51:26	W.550	2469	9230896	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	09:57:00	09:57:00	W.550	4402	9232167	1	1	48	0	0	51801
4	4	Fessenden	St Johns	10:02:19	10:02:19	W.550	473	9226029	0	0	13	0	0	13489
4	4	Fessenden	St Johns	10:17:19	10:17:19	W.550	402	9226030	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	10:19:00	10:19:00	W.550	4472	9232168	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	10:21:26	10:21:26	W.550	2434	9230897	1	0	9	0	0	22525
4	4	Fessenden	St Johns	10:32:19	10:32:19	W.550	467	9226031	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	10:41:00	10:41:00	W.550	4401	9232169	1	1	48	0	0	51801
4	4	Fessenden	St Johns	10:47:19	10:47:19	W.550	403	9226032	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	10:51:26	10:51:26	W.550	2435	9230898	1	0	9	0	0	22525
4	4	Fessenden	St Johns	11:02:19	11:02:19	W.550	468	9226033	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	11:03:00	11:03:00	W.550	4473	9232170	1	1	48	0	0	51801
4	4	Fessenden	St Johns	11:17:19	11:17:19	W.550	404	9226034	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	11:21:26	11:21:26	W.550	2467	9230899	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	11:29:00	11:29:00	W.550	4467	9232171	1	1	48	0	0	51801
4	4	Fessenden	St Johns	11:32:19	11:32:19	W.550	469	9226035	0	0	13	0	0	13489
4	4	Fessenden	St Johns	11:47:19	11:47:19	W.550	470	9226036	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	11:51:00	11:51:00	W.550	4468	9232172	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	11:51:26	11:51:26	W.550	2468	9230900	1	0	9	0	0	22525
4	4	Fessenden	St Johns	12:02:19	12:02:19	W.550	471	9226037	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	12:17:00	12:17:00	W.550	4469	9232173	1	1	48	0	0	51801
4	4	Fessenden	St Johns	12:17:19	12:17:19	W.550	472	9226038	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	12:21:26	12:21:26	W.550	2469	9230901	1	0	9	0	0	22525
4	4	Fessenden	St Johns	12:31:40	12:31:40	W.550	401	9226039	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	12:39:00	12:39:00	W.550	4470	9232174	1	1	48	0	0	51801
4	4	Fessenden	St Johns	12:46:40	12:46:40	W.550	473	9226040	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	12:51:26	12:51:26	W.550	2434	9230902	1	0	9	0	0	22525
4	4	Fessenden	St Johns	13:01:40	13:01:40	W.550	402	9226041	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	13:05:00	13:05:00	W.550	4471	9232175	1	1	48	0	0	51801
4	4	Fessenden	St Johns	13:16:40	13:16:40	W.550	467	9226042	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	13:21:26	13:21:26	W.550	2435	9230903	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	13:27:00	13:27:00	W.550	4402	9232176	1	1	48	0	0	51801
4	4	Fessenden	St Johns	13:31:40	13:31:40	W.550	403	9226043	0	0	13	0	0	13489
4	4	Fessenden	St Johns	13:46:40	13:46:40	W.550	468	9226044	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	13:50:44	13:50:44	W.550	2467	9230904	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	13:53:00	13:53:00	W.550	4472	9232177	1	1	48	0	0	51801
4	4	Fessenden	St Johns	14:01:40	14:01:40	W.550	404	9226045	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	14:16:00	14:16:00	W.550	4401	9232178	1	1	48	0	0	51801
4	4	Fessenden	St Johns	14:16:40	14:16:40	W.550	469	9226046	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	14:20:44	14:20:44	W.550	2468	9230905	1	0	9	0	0	22525
4	4	Fessenden	St Johns	14:31:40	14:31:40	W.550	470	9226047	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	14:40:00	14:40:00	W.550	4473	9232179	1	1	48	0	0	51801
4	4	Fessenden	St Johns	14:45:23	14:45:23	W.550	471	9226048	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	14:50:44	14:50:44	W.550	2469	9230906	1	0	9	0	0	22525
4	4	Fessenden	St Johns	15:00:23	15:00:23	W.550	472	9226049	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	15:04:00	15:04:00	W.550	4467	9232180	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	15:10:03	15:10:03	W.550	2434	9230907	1	0	9	0	0	22525
4	4	Fessenden	St Johns	15:10:23	15:10:23	W.550	407	9226050	0	0	13	0	0	13489
4	4	Fessenden	St Johns	15:18:23	15:18:23	W.550	413	9226051	0	0	13	0	0	13489
4	4	Fessenden	St Johns	15:26:23	15:26:23	W.550	401	9226052	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	15:28:00	15:28:00	W.550	4468	9232181	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	15:30:03	15:30:03	W.550	2470	9230908	1	0	9	0	0	22525
4	4	Fessenden	St Johns	15:34:23	15:34:23	W.550	473	9226053	0	0	13	0	0	13489
4	4	Fessenden	St Johns	15:42:23	15:42:23	W.550	415	9226054	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	15:50:03	15:50:03	W.550	2435	9230909	1	0	9	0	0	22525
4	4	Fessenden	St Johns	15:50:44	15:50:44	W.550	409	9226055	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	15:54:00	15:54:00	W.550	4469	9232182	1	1	48	0	0	51801
4	4	Fessenden	St Johns	16:03:44	16:03:44	W.550	402	9226056	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	16:09:00	16:09:00	W.550	4404	9232183	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	16:09:22	16:09:22	W.550	2467	9230910	1	0	9	0	0	22525
4	4	Fessenden	St Johns	16:16:44	16:16:44	W.550	467	9226057	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	16:26:00	16:26:00	W.550	4470	9232184	1	1	48	0	0	51801
4	4	Fessenden	St Johns	16:29:05	16:29:05	W.550	403	9226058	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	16:29:22	16:29:22	W.550	2437	9230911	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	16:40:00	16:40:00	W.550	4471	9232185	1	1	48	0	0	51801
4	4	Fessenden	St Johns	16:42:05	16:42:05	W.550	468	9226059	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	16:49:22	16:49:22	W.550	2468	9230912	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	16:55:00	16:55:00	W.550	4410	9232186	1	1	48	0	0	51801
4	4	Fessenden	St Johns	16:55:05	16:55:05	W.550	404	9226060	0	0	13	0	0	13489
4	4	Fessenden	St Johns	17:08:05	17:08:05	W.550	405	9226061	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	17:08:40	17:08:40	W.550	2469	9230913	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	17:11:00	17:11:00	W.550	4402	9232187	1	1	48	0	0	51801
4	4	Fessenden	St Johns	17:18:05	17:18:05	W.550	469	9226062	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	17:26:00	17:26:00	W.550	4406	9232188	1	1	48	0	0	51801
4	4	Fessenden	St Johns	17:28:05	17:28:05	W.550	470	9226063	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	17:28:40	17:28:40	W.550	2439	9230914	1	0	9	0	0	22525
4	4	Fessenden	St Johns	17:39:05	17:39:05	W.550	471	9226064	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	17:40:00	17:40:00	W.550	4472	9232189	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	17:48:40	17:48:40	W.550	2434	9230915	1	0	9	0	0	22525
4	4	Fessenden	St Johns	17:49:44	17:49:44	W.550	406	9226065	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	17:54:00	17:54:00	W.550	4408	9232190	1	1	48	0	0	51801
4	4	Fessenden	St Johns	18:02:23	18:02:23	W.550	407	9226066	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	18:10:03	18:10:03	W.550	2470	9230916	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	18:12:00	18:12:00	W.550	4401	9232191	1	1	48	0	0	51801
4	4	Fessenden	St Johns	18:17:01	18:17:01	W.550	401	9226067	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	18:26:00	18:26:00	W.550	4412	9232192	1	1	48	0	0	51801
4	4	Fessenden	St Johns	18:29:01	18:29:01	W.550	473	9226068	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	18:30:03	18:30:03	W.550	2467	9230917	1	0	9	0	0	22525
4	4	Fessenden	St Johns	18:41:40	18:41:40	W.550	415	9226069	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	18:44:00	18:44:00	W.550	4473	9232193	1	1	48	0	0	51801
4	4	Fessenden	St Johns	18:54:40	18:54:40	W.550	402	9226070	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	19:00:44	19:00:44	W.550	2437	9230918	1	0	9	0	0	22525
44	44	Capitol Hwy/Mocks Crest	St Johns	19:03:00	19:03:00	W.550	4467	9232194	1	1	48	0	0	51801
4	4	Fessenden	St Johns	19:08:40	19:08:40	W.550	467	9226071	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	19:16:00	19:16:00	W.550	7513	9232195	1	1	48	0	0	51801
4	4	Fessenden	St Johns	19:21:40	19:21:40	W.550	403	9226072	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	19:31:00	19:31:00	W.550	4468	9232196	1	1	48	0	0	51801
24	24	Fremont/NW 18th	Gateway TC	19:31:26	19:31:26	W.550	2468	9230919	1	0	9	0	0	22525
4	4	Fessenden	St Johns	19:37:19	19:37:19	W.550	468	9226073	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	19:51:00	19:51:00	W.550	4404	9232197	1	1	48	0	0	51801
4	4	Fessenden	St Johns	19:52:19	19:52:19	W.550	404	9226074	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	20:01:26	20:01:26	W.550	2434	9230920	1	0	9	0	0	22525
4	4	Fessenden	St Johns	20:07:19	20:07:19	W.550	405	9226075	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	20:21:00	20:21:00	W.550	4471	9232198	1	1	48	0	0	51801
4	4	Fessenden	St Johns	20:22:19	20:22:19	W.550	470	9226076	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	20:31:26	20:31:26	W.550	2467	9230921	1	0	9	0	0	22525
4	4	Fessenden	St Johns	20:37:58	20:37:58	W.550	406	9226077	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	20:52:00	20:52:00	W.550	4402	9232199	1	1	48	0	0	51801
4	4	Fessenden	St Johns	20:52:58	20:52:58	W.550	407	9226078	0	0	13	0	0	13489
24	24	Fremont/NW 18th	Gateway TC	21:01:26	21:01:26	W.550	2437	9230922	1	0	9	0	0	22525
4	4	Fessenden	St Johns	21:07:58	21:07:58	W.550	401	9226079	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	21:21:00	21:21:00	W.550	4472	9232200	1	1	48	0	0	51801
4	4	Fessenden	St Johns	21:22:58	21:22:58	W.550	473	9226080	0	0	13	0	0	13489
4	4	Fessenden	St Johns	21:42:58	21:42:58	W.550	402	9226081	0	0	13	0	0	13489
44	44	Capitol Hwy/Mocks Crest	St Johns	21:51:00	21:51:00	W.550	4401	9232201	1	1	48	0	0	51801
4	4	Fessenden	St Johns	22:02:58	22:02:58	W.550	467	9226082	0	0	13	0	0	13489
4	4	Fessenden	St Johns	22:22:58	22:22:58	W.550	468	9226083	0	0	13	0	0	13489
4	4	Fessenden	St Johns	22:42:58	22:42:58	W.550	404	9226084	0	0	13	0	0	13489
4	4	Fessenden	St Johns	23:02:58	23:02:58	W.550	405	9226085	0	0	13	0	0	13489
4	4	Fessenden	St Johns	23:22:58	23:22:58	W.550	406	9226086	0	0	13	0	0	13489
4	4	Fessenden	St Johns	23:42:58	23:42:58	W.550	407	9226087	0	0	13	0	0	13489
4	4	Fessenden	St Johns	24:13:36	24:13:36	W.550	473	9226088	0	0	13	0	0	13489
4	4	Fessenden	St Johns	24:43:36	24:43:36	W.550	402	9226089	0	0	13	0	0	13489
4	4	Fessenden	St Johns	25:52:36	25:52:36	W.550	407	9226090	0	0	13	0	0	13489