stop_id	stop_name	direction	stop_desc	stop_lat	stop_lon	zone_id	location_type	parent_station
12791	SW Jefferson & 5th	W	Westbound stop in Portland (Stop ID 12791)	45.514806	-122.679535	B	0

Service IDs for Sat Jul 20, 2019: 8.550, B.550, E.550, S.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:27:00	05:27:00	S.550	401	9226091	1	1	70	0	0	60276
4	4	Fessenden	St Johns	05:34:00	05:34:00	S.550	401	9225885	0	1	1	0	0	0
4	4	Fessenden	St Johns	06:27:00	06:27:00	S.550	7501	9226092	1	1	70	0	0	60276
4	4	Fessenden	St Johns	06:34:00	06:34:00	S.550	7501	9225886	0	1	1	0	0	0
4	4	Fessenden	St Johns	06:58:00	06:58:00	S.550	408	9226093	1	1	70	0	0	60276
4	4	Fessenden	St Johns	07:04:00	07:04:00	S.550	408	9225887	0	1	1	0	0	0
4	4	Fessenden	St Johns	07:28:00	07:28:00	S.550	410	9226094	1	1	70	0	0	60276
4	4	Fessenden	St Johns	07:33:00	07:33:00	S.550	410	9225888	0	1	1	0	0	0
4	4	Fessenden	St Johns	07:58:00	07:58:00	S.550	401	9226095	1	1	70	0	0	60276
4	4	Fessenden	St Johns	08:03:00	08:03:00	S.550	401	9225889	0	1	1	0	0	0
4	4	Fessenden	St Johns	08:18:00	08:18:00	S.550	403	9226096	1	1	70	0	0	60276
4	4	Fessenden	St Johns	08:23:00	08:23:00	S.550	403	9225890	0	1	1	0	0	0
4	4	Fessenden	St Johns	08:38:00	08:38:00	S.550	404	9225891	0	1	1	0	1	0
4	4	Fessenden	St Johns	08:38:00	08:38:00	S.550	405	9226097	1	1	70	0	0	60276
4	4	Fessenden	St Johns	08:52:00	08:52:00	S.550	405	9225892	0	1	1	0	0	0
4	4	Fessenden	St Johns	08:58:00	08:58:00	S.550	406	9226098	1	1	70	0	0	60276
4	4	Fessenden	St Johns	09:07:00	09:07:00	S.550	406	9225893	0	1	1	0	0	0
4	4	Fessenden	St Johns	09:13:00	09:13:00	S.550	407	9226099	1	1	70	0	0	60276
4	4	Fessenden	St Johns	09:21:00	09:21:00	S.550	407	9225894	0	1	1	0	0	0
4	4	Fessenden	St Johns	09:29:00	09:29:00	S.550	408	9226100	1	1	70	0	0	60276
4	4	Fessenden	St Johns	09:36:00	09:36:00	S.550	408	9225895	0	1	1	0	0	0
4	4	Fessenden	St Johns	09:45:00	09:45:00	S.550	409	9226101	1	1	70	0	0	60276
4	4	Fessenden	St Johns	09:51:00	09:51:00	S.550	409	9225896	0	1	1	0	0	0
4	4	Fessenden	St Johns	10:00:00	10:00:00	S.550	410	9226102	1	1	70	0	0	60276
4	4	Fessenden	St Johns	10:06:00	10:06:00	S.550	410	9225897	0	1	1	0	0	0
4	4	Fessenden	St Johns	10:15:00	10:15:00	S.550	411	9226103	1	1	70	0	0	60276
4	4	Fessenden	St Johns	10:21:00	10:21:00	S.550	411	9225898	0	1	1	0	0	0
4	4	Fessenden	St Johns	10:30:00	10:30:00	S.550	401	9226104	1	1	70	0	0	60276
4	4	Fessenden	St Johns	10:36:00	10:36:00	S.550	401	9225899	0	1	1	0	0	0
4	4	Fessenden	St Johns	10:45:00	10:45:00	S.550	403	9226105	1	1	70	0	0	60276
4	4	Fessenden	St Johns	10:51:00	10:51:00	S.550	403	9225900	0	1	1	0	0	0
4	4	Fessenden	St Johns	11:00:00	11:00:00	S.550	404	9226106	1	1	70	0	0	60276
4	4	Fessenden	St Johns	11:06:00	11:06:00	S.550	404	9225901	0	1	1	0	0	0
4	4	Fessenden	St Johns	11:15:00	11:15:00	S.550	405	9226107	1	1	70	0	0	60276
4	4	Fessenden	St Johns	11:21:00	11:21:00	S.550	405	9225902	0	1	1	0	0	0
4	4	Fessenden	St Johns	11:31:00	11:31:00	S.550	406	9226108	1	1	70	0	0	60276
4	4	Fessenden	St Johns	11:37:00	11:37:00	S.550	406	9225903	0	1	1	0	0	0
4	4	Fessenden	St Johns	11:46:00	11:46:00	S.550	407	9226109	1	1	70	0	0	60276
4	4	Fessenden	St Johns	11:52:00	11:52:00	S.550	407	9225904	0	1	1	0	0	0
4	4	Fessenden	St Johns	12:01:00	12:01:00	S.550	408	9226110	1	1	70	0	0	60276
4	4	Fessenden	St Johns	12:08:00	12:08:00	S.550	408	9225905	0	1	1	0	0	0
4	4	Fessenden	St Johns	12:16:00	12:16:00	S.550	409	9226111	1	1	70	0	0	60276
4	4	Fessenden	St Johns	12:24:00	12:24:00	S.550	409	9225906	0	1	1	0	0	0
4	4	Fessenden	St Johns	12:32:00	12:32:00	S.550	410	9226112	1	1	70	0	0	60276
4	4	Fessenden	St Johns	12:38:00	12:38:00	S.550	410	9225907	0	1	1	0	0	0
4	4	Fessenden	St Johns	12:47:00	12:47:00	S.550	411	9226113	1	1	70	0	0	60276
4	4	Fessenden	St Johns	12:53:00	12:53:00	S.550	411	9225908	0	1	1	0	0	0
4	4	Fessenden	St Johns	13:02:00	13:02:00	S.550	401	9226114	1	1	70	0	0	60276
4	4	Fessenden	St Johns	13:08:00	13:08:00	S.550	401	9225909	0	1	1	0	0	0
4	4	Fessenden	St Johns	13:17:00	13:17:00	S.550	402	9226115	1	1	70	0	0	60276
4	4	Fessenden	St Johns	13:23:00	13:23:00	S.550	402	9225910	0	1	1	0	0	0
4	4	Fessenden	St Johns	13:33:00	13:33:00	S.550	403	9226116	1	1	70	0	0	60276
4	4	Fessenden	St Johns	13:39:00	13:39:00	S.550	403	9225911	0	1	1	0	0	0
4	4	Fessenden	St Johns	13:48:00	13:48:00	S.550	404	9226117	1	1	70	0	0	60276
4	4	Fessenden	St Johns	13:54:00	13:54:00	S.550	404	9225912	0	1	1	0	0	0
4	4	Fessenden	St Johns	14:03:00	14:03:00	S.550	405	9226118	1	1	70	0	0	60276
4	4	Fessenden	St Johns	14:09:00	14:09:00	S.550	405	9225913	0	1	1	0	0	0
4	4	Fessenden	St Johns	14:18:00	14:18:00	S.550	406	9226119	1	1	70	0	0	60276
4	4	Fessenden	St Johns	14:24:00	14:24:00	S.550	406	9225914	0	1	1	0	0	0
4	4	Fessenden	St Johns	14:33:00	14:33:00	S.550	407	9226120	1	1	70	0	0	60276
4	4	Fessenden	St Johns	14:39:00	14:39:00	S.550	407	9225915	0	1	1	0	0	0
4	4	Fessenden	St Johns	14:48:00	14:48:00	S.550	408	9226121	1	1	70	0	0	60276
4	4	Fessenden	St Johns	14:54:00	14:54:00	S.550	408	9225916	0	1	1	0	0	0
4	4	Fessenden	St Johns	15:03:00	15:03:00	S.550	409	9226122	1	1	70	0	0	60276
4	4	Fessenden	St Johns	15:09:00	15:09:00	S.550	409	9225917	0	1	1	0	0	0
4	4	Fessenden	St Johns	15:18:00	15:18:00	S.550	410	9226123	1	1	70	0	0	60276
4	4	Fessenden	St Johns	15:24:00	15:24:00	S.550	410	9225918	0	1	1	0	0	0
4	4	Fessenden	St Johns	15:33:00	15:33:00	S.550	411	9226124	1	1	70	0	0	60276
4	4	Fessenden	St Johns	15:39:00	15:39:00	S.550	411	9225919	0	1	1	0	0	0
4	4	Fessenden	St Johns	15:48:00	15:48:00	S.550	401	9226125	1	1	70	0	0	60276
4	4	Fessenden	St Johns	15:54:00	15:54:00	S.550	401	9225920	0	1	1	0	0	0
4	4	Fessenden	St Johns	16:03:00	16:03:00	S.550	402	9226126	1	1	70	0	0	60276
4	4	Fessenden	St Johns	16:09:00	16:09:00	S.550	402	9225921	0	1	1	0	0	0
4	4	Fessenden	St Johns	16:18:00	16:18:00	S.550	403	9226127	1	1	70	0	0	60276
4	4	Fessenden	St Johns	16:24:00	16:24:00	S.550	403	9225922	0	1	1	0	0	0
4	4	Fessenden	St Johns	16:33:00	16:33:00	S.550	404	9226128	1	1	70	0	0	60276
4	4	Fessenden	St Johns	16:39:00	16:39:00	S.550	404	9225923	0	1	1	0	0	0
4	4	Fessenden	St Johns	16:48:00	16:48:00	S.550	405	9226129	1	1	70	0	0	60276
4	4	Fessenden	St Johns	16:54:00	16:54:00	S.550	405	9225924	0	1	1	0	0	0
4	4	Fessenden	St Johns	17:03:00	17:03:00	S.550	406	9226130	1	1	70	0	0	60276
4	4	Fessenden	St Johns	17:09:00	17:09:00	S.550	406	9225925	0	1	1	0	0	0
4	4	Fessenden	St Johns	17:18:00	17:18:00	S.550	407	9226131	1	1	70	0	0	60276
4	4	Fessenden	St Johns	17:24:00	17:24:00	S.550	407	9225926	0	1	1	0	0	0
4	4	Fessenden	St Johns	17:33:00	17:33:00	S.550	408	9226132	1	1	70	0	0	60276
4	4	Fessenden	St Johns	17:39:00	17:39:00	S.550	408	9225927	0	1	1	0	0	0
4	4	Fessenden	St Johns	17:48:00	17:48:00	S.550	409	9226133	1	1	70	0	0	60276
4	4	Fessenden	St Johns	17:54:00	17:54:00	S.550	409	9225928	0	1	1	0	0	0
4	4	Fessenden	St Johns	18:03:00	18:03:00	S.550	410	9226134	1	1	70	0	0	60276
4	4	Fessenden	St Johns	18:09:00	18:09:00	S.550	410	9225929	0	1	1	0	0	0
4	4	Fessenden	St Johns	18:17:00	18:17:00	S.550	411	9226135	1	1	70	0	0	60276
4	4	Fessenden	St Johns	18:24:00	18:24:00	S.550	411	9225930	0	1	1	0	0	0
4	4	Fessenden	St Johns	18:32:00	18:32:00	S.550	401	9226136	1	1	70	0	0	60276
4	4	Fessenden	St Johns	18:39:00	18:39:00	S.550	401	9225931	0	1	1	0	0	0
4	4	Fessenden	St Johns	18:47:00	18:47:00	S.550	402	9226137	1	1	70	0	0	60276
4	4	Fessenden	St Johns	18:59:00	18:59:00	S.550	402	9225932	0	1	1	0	0	0
4	4	Fessenden	St Johns	19:02:00	19:02:00	S.550	403	9226138	1	1	70	0	0	60276
4	4	Fessenden	St Johns	19:19:00	19:19:00	S.550	403	9225933	0	1	1	0	0	0
4	4	Fessenden	St Johns	19:22:00	19:22:00	S.550	404	9226139	1	1	70	0	0	60276
4	4	Fessenden	St Johns	19:39:00	19:39:00	S.550	404	9225934	0	1	1	0	0	0
4	4	Fessenden	St Johns	19:42:00	19:42:00	S.550	406	9226140	1	1	70	0	0	60276
4	4	Fessenden	St Johns	19:59:00	19:59:00	S.550	406	9225935	0	1	1	0	0	0
4	4	Fessenden	St Johns	20:02:00	20:02:00	S.550	407	9226141	1	1	70	0	0	60276
4	4	Fessenden	St Johns	20:20:00	20:20:00	S.550	407	9225936	0	1	1	0	0	0
4	4	Fessenden	St Johns	20:21:00	20:21:00	S.550	408	9226142	1	1	70	0	0	60276
4	4	Fessenden	St Johns	20:40:00	20:40:00	S.550	408	9225937	0	1	1	0	0	0
4	4	Fessenden	St Johns	20:41:00	20:41:00	S.550	410	9226143	1	1	70	0	0	60276
4	4	Fessenden	St Johns	21:00:00	21:00:00	S.550	410	9225938	0	1	1	0	0	0
4	4	Fessenden	St Johns	21:01:00	21:01:00	S.550	411	9226144	1	1	70	0	0	60276
4	4	Fessenden	St Johns	21:20:00	21:20:00	S.550	411	9225939	0	1	1	0	0	0
4	4	Fessenden	TriMet is Hiring - Steer Your Career	21:21:00	21:21:00	S.550	401	9226145	1	1	70	1	0	60276
4	4	Fessenden	St Johns	21:41:00	21:41:00	S.550	402	9226146	1	1	70	0	0	60276
4	4	Fessenden	St Johns	21:50:00	21:50:00	S.550	402	9225940	0	1	1	0	0	0
4	4	Fessenden	St Johns	22:01:00	22:01:00	S.550	403	9226147	1	1	70	0	0	60276
4	4	Fessenden	St Johns	22:20:00	22:20:00	S.550	403	9225941	0	1	1	0	0	0
4	4	Fessenden	St Johns	22:31:00	22:31:00	S.550	406	9226148	1	1	70	0	0	60276
4	4	Fessenden	St Johns	22:51:00	22:51:00	S.550	406	9225942	0	1	1	0	0	0
4	4	Fessenden	St Johns	23:00:00	23:00:00	S.550	407	9226149	1	1	70	0	0	60276
4	4	Fessenden	St Johns	23:21:00	23:21:00	S.550	407	9225943	0	1	1	0	0	0
4	4	Fessenden	St Johns	23:30:00	23:30:00	S.550	410	9226150	1	1	70	0	0	60276
4	4	Fessenden	St Johns	23:51:00	23:51:00	S.550	410	9225944	0	1	1	0	0	0
4	4	Fessenden	TriMet is Hiring - Steer Your Career	24:00:00	24:00:00	S.550	411	9226151	1	1	70	1	0	60276
4	4	Fessenden	St Johns	24:29:00	24:29:00	S.550	402	9226152	1	1	70	0	0	60276
4	4	Fessenden	St Johns	24:37:00	24:37:00	S.550	402	9225945	0	1	1	0	0	0
4	4	Fessenden	St Johns	25:27:00	25:27:00	S.550	406	9226153	1	1	70	0	0	60276
4	4	Fessenden	St Johns	25:38:00	25:38:00	S.550	406	9225946	0	1	1	0	0	0