stop_id	stop_name	direction	stop_desc	stop_lat	stop_lon	zone_id	location_type	parent_station
13825	SE 7th & Tilikum Way	N	Northbound stop in Portland (Stop ID 13825)	45.505582	-122.658631	B	0

Service IDs for Mon Jan 25, 2021: 1.586, A.586, D.586, Q.586, W.586

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
9	9	Powell Blvd	Portland	04:47:33	04:47:33	W.586	234	10450673	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	05:12:33	05:12:33	W.586	1701	10452288	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	05:17:33	05:17:33	W.586	934	10450674	1	0	70	0	0	65246
9	9	Powell Blvd	Portland	05:32:33	05:32:33	W.586	937	10450675	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	05:35:33	05:35:33	W.586	1702	10452290	1	0	4	0	0	6270
9	9	Powell Blvd	Portland	05:47:33	05:47:33	W.586	938	10450676	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	05:49:33	05:49:33	W.586	1703	10452291	1	0	49	0	0	46653
17	17	Holgate/Broadway	NE Saratoga & 27th	06:04:33	06:04:33	W.586	1704	10452292	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	06:06:33	06:06:33	W.586	939	10450677	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	06:18:33	06:18:33	W.586	1734	10452293	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	06:21:33	06:21:33	W.586	941	10450678	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	06:31:33	06:31:33	W.586	1705	10452294	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	06:32:33	06:32:33	W.586	902	10450679	1	0	70	0	0	65246
9	9	Powell Blvd	Portland	06:42:33	06:42:33	W.586	942	10450680	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	06:44:33	06:44:33	W.586	1706	10452295	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	06:54:33	06:54:33	W.586	947	10450681	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	06:56:33	06:56:33	W.586	1735	10452296	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	07:02:33	07:02:33	W.586	943	10450682	1	0	29	0	0	26696
17	17	Holgate/Broadway	NE Saratoga & 27th	07:06:33	07:06:33	W.586	1707	10452297	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	07:13:33	07:13:33	W.586	944	10450683	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	07:16:33	07:16:33	W.586	1737	10452298	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	07:19:33	07:19:33	W.586	903	10450684	1	0	70	0	0	65246
9	9	Powell Blvd	Portland	07:26:33	07:26:33	W.586	945	10450685	1	0	29	0	0	26696
17	17	Holgate/Broadway	NE Saratoga & 27th	07:26:33	07:26:33	W.586	1708	10452299	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	07:32:33	07:32:33	W.586	901	10450686	1	0	71	0	0	65641
17	17	Holgate/Broadway	Portland	07:36:33	07:36:33	W.586	1713	10452300	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	07:39:33	07:39:33	W.586	946	10450687	1	0	29	0	0	26696
17	17	Holgate/Broadway	NE Saratoga & 27th	07:46:33	07:46:33	W.586	1709	10452301	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	07:46:33	07:46:33	W.586	234	10450688	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	07:54:33	07:54:33	W.586	902	10450689	1	0	29	0	0	26696
17	17	Holgate/Broadway	Portland	07:55:33	07:55:33	W.586	1739	10452302	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	08:02:33	08:02:33	W.586	934	10450690	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	08:05:33	08:05:33	W.586	1710	10452303	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	08:11:33	08:11:33	W.586	905	10450691	1	0	70	0	0	65246
17	17	Holgate/Broadway	Portland	08:16:33	08:16:33	W.586	1741	10452304	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	08:17:33	08:17:33	W.586	935	10450692	1	0	70	0	0	65246
9	9	Powell Blvd	Portland	08:23:33	08:23:33	W.586	907	10450693	1	0	29	0	0	26696
17	17	Holgate/Broadway	NE Saratoga & 27th	08:27:33	08:27:33	W.586	1711	10452305	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	08:29:33	08:29:33	W.586	949	10450694	1	0	70	0	0	65246
17	17	Holgate/Broadway	Portland	08:38:33	08:38:33	W.586	1743	10452306	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	08:42:33	08:42:33	W.586	937	10450695	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	08:49:33	08:49:33	W.586	1701	10452307	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	08:55:33	08:55:33	W.586	938	10450696	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	09:06:33	09:06:33	W.586	1702	10452308	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	09:06:33	09:06:33	W.586	951	10450697	1	0	70	0	0	65246
9	9	Powell Blvd	Portland	09:16:33	09:16:33	W.586	939	10450698	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	09:23:33	09:23:33	W.586	1703	10452309	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	09:26:33	09:26:33	W.586	941	10450699	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	09:37:33	09:37:33	W.586	942	10450700	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	09:40:33	09:40:33	W.586	1704	10452310	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	09:51:33	09:51:33	W.586	901	10450701	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	10:00:33	10:00:33	W.586	1705	10452311	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	10:06:33	10:06:33	W.586	943	10450702	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	10:20:33	10:20:33	W.586	1706	10452312	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	10:21:33	10:21:33	W.586	944	10450703	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	10:36:33	10:36:33	W.586	945	10450704	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	10:38:33	10:38:33	W.586	1707	10452313	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	10:52:33	10:52:33	W.586	946	10450705	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	10:56:33	10:56:33	W.586	1708	10452314	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	11:07:33	11:07:33	W.586	902	10450706	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	11:16:33	11:16:33	W.586	1709	10452315	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	11:22:33	11:22:33	W.586	934	10450707	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	11:36:33	11:36:33	W.586	1710	10452316	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	11:37:33	11:37:33	W.586	935	10450708	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	11:52:33	11:52:33	W.586	937	10450709	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	11:56:33	11:56:33	W.586	1711	10452317	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	12:07:33	12:07:33	W.586	938	10450710	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	12:16:33	12:16:33	W.586	1701	10452318	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	12:22:33	12:22:33	W.586	939	10450711	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	12:36:33	12:36:33	W.586	1702	10452319	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	12:38:33	12:38:33	W.586	941	10450712	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	12:55:33	12:55:33	W.586	942	10450713	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	12:56:33	12:56:33	W.586	1703	10452320	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	13:10:33	13:10:33	W.586	901	10450714	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	13:16:33	13:16:33	W.586	1704	10452321	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	13:26:33	13:26:33	W.586	943	10450715	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	13:36:33	13:36:33	W.586	1705	10452322	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	13:41:33	13:41:33	W.586	944	10450716	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	13:56:33	13:56:33	W.586	1706	10452323	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	13:56:33	13:56:33	W.586	945	10450717	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	14:11:33	14:11:33	W.586	946	10450718	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	14:16:33	14:16:33	W.586	1707	10452324	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	14:26:33	14:26:33	W.586	902	10450719	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	14:36:33	14:36:33	W.586	1708	10452325	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	14:41:33	14:41:33	W.586	934	10450720	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	14:56:33	14:56:33	W.586	1709	10452326	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	14:56:33	14:56:33	W.586	935	10450721	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	15:11:33	15:11:33	W.586	1736	10452327	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	15:11:33	15:11:33	W.586	937	10450722	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	15:22:33	15:22:33	W.586	950	10450723	1	0	29	0	0	26696
17	17	Holgate/Broadway	NE Saratoga & 27th	15:26:33	15:26:33	W.586	1710	10452328	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	15:29:33	15:29:33	W.586	938	10450724	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	15:39:33	15:39:33	W.586	939	10450725	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	15:41:33	15:41:33	W.586	1711	10452329	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	15:55:33	15:55:33	W.586	941	10450726	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	15:56:33	15:56:33	W.586	1701	10452330	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	16:10:33	16:10:33	W.586	942	10450727	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	16:11:33	16:11:33	W.586	1742	10452331	1	0	49	0	0	46653
17	17	Holgate/Broadway	NE Saratoga & 27th	16:25:33	16:25:33	W.586	1702	10452332	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	16:25:33	16:25:33	W.586	904	10450728	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	16:39:33	16:39:33	W.586	1703	10452333	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	16:40:33	16:40:33	W.586	901	10450729	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	16:51:33	16:51:33	W.586	1744	10452334	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	16:53:33	16:53:33	W.586	943	10450730	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	17:03:33	17:03:33	W.586	1704	10452335	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	17:06:33	17:06:33	W.586	944	10450731	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	17:18:33	17:18:33	W.586	945	10450732	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	17:19:33	17:19:33	W.586	1705	10452336	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	17:32:33	17:32:33	W.586	946	10450733	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	17:35:33	17:35:33	W.586	1738	10452337	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	17:45:33	17:45:33	W.586	902	10450734	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	17:55:33	17:55:33	W.586	1706	10452338	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	17:59:33	17:59:33	W.586	948	10450735	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	18:15:33	18:15:33	W.586	906	10450736	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	18:20:33	18:20:33	W.586	1740	10452339	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	18:25:33	18:25:33	W.586	936	10450737	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	18:34:33	18:34:33	W.586	937	10450738	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	18:45:33	18:45:33	W.586	1709	10452340	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	18:49:33	18:49:33	W.586	938	10450739	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	19:02:33	19:02:33	W.586	908	10450740	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	19:10:33	19:10:33	W.586	1710	10452341	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	19:15:33	19:15:33	W.586	940	10450741	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	19:34:33	19:34:33	W.586	934	10450742	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	19:35:33	19:35:33	W.586	1701	10452342	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	19:50:33	19:50:33	W.586	935	10450743	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	20:11:33	20:11:33	W.586	943	10450744	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	20:16:33	20:16:33	W.586	1703	10452343	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	20:33:33	20:33:33	W.586	945	10450745	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	20:54:33	20:54:33	W.586	902	10450746	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	20:56:33	20:56:33	W.586	1705	10452344	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	21:14:33	21:14:33	W.586	936	10450747	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	21:36:33	21:36:33	W.586	1740	10452345	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	21:42:33	21:42:33	W.586	937	10450748	1	0	71	0	0	65641
9	9	Powell Blvd	Portland	22:12:33	22:12:33	W.586	940	10450749	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	22:16:33	22:16:33	W.586	1709	10452346	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	22:42:33	22:42:33	W.586	935	10450750	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	22:56:33	22:56:33	W.586	1701	10452347	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	23:10:33	23:10:33	W.586	943	10450751	1	0	71	0	0	65641
17	17	Holgate/Broadway	NE Saratoga & 27th	23:31:33	23:31:33	W.586	1703	10452348	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	23:39:33	23:39:33	W.586	902	10450752	1	0	70	0	0	65246
17	17	Holgate/Broadway	NE Saratoga & 27th	24:12:33	24:12:33	W.586	1705	10452349	1	0	49	0	0	46653
9	9	Powell Blvd	Portland	24:12:33	24:12:33	W.586	936	10450753	1	0	70	0	0	65246
9	9	Powell Blvd	Portland	25:12:33	25:12:33	W.586	940	10450754	1	0	70	0	0	65246