home / openregs

Member Activity Timeline

See a member's stock trades alongside their floor speeches. Enter bioguide_id.

Custom SQL query returning 155 rows (hide)

SELECT 'trade' AS activity_type, st.transaction_date AS date, st.ticker || ' ' || st.transaction_type || ' (' || st.amount_range || ')' AS description, st.chamber FROM stock_trades st WHERE st.bioguide_id = :bioguide_id AND st.transaction_date != '' UNION ALL SELECT 'speech' AS activity_type, cr.date, cr.title AS description, cr.chamber FROM crec_speakers cs JOIN congressional_record cr ON cs.granule_id = cr.granule_id WHERE cs.bioguide_id = :bioguide_id ORDER BY date DESC LIMIT 500

Query parameters

Edit SQL

This data as json, CSV

activity_typedatedescriptionchamber
trade 2025-12-24 LAZR Sale (Partial) ($1,001 - $15,000) Senate
trade 2025-12-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2025-11-11 GS Sale (Partial) ($100,001 - $250,000) Senate
trade 2025-09-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2025-08-04 Purchase ($1,001 - $15,000) Senate
trade 2025-06-26 LAZR Sale (Partial) ($15,001 - $50,000) Senate
trade 2025-06-16 Sale (Full) ($1,001 - $15,000) Senate
trade 2025-06-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2025-03-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2025-02-18 YUM Sale (Full) ($1,001 - $15,000) Senate
trade 2024-12-02 WFC Purchase ($1,001 - $15,000) Senate
trade 2024-09-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2024-06-04 WFC Purchase ($1,001 - $15,000) Senate
trade 2024-04-15 GS Sale (Partial) ($250,001 - $500,000) Senate
trade 2024-03-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2023-12-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2023-10-03 WMT Sale (Full) ($50,001 - $100,000) Senate
trade 2023-09-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2023-08-31 Purchase ($100,001 - $250,000) Senate
trade 2023-08-30 Sale (Full) ($1,000,001 - $5,000,000) Senate
trade 2023-08-03 Purchase ($50,001 - $100,000) Senate
trade 2023-06-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2023-03-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2022-12-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2022-11-29 KR Purchase ($1,001 - $15,000) Senate
trade 2022-11-28 BMY Sale (Partial) ($100,001 - $250,000) House
trade 2022-11-28 CVX Sale (Partial) ($500,001 - $1,000,000) House
trade 2022-11-28 LLY Sale (Partial) ($1,000,001 - $5,000,000) House
trade 2022-11-28 XOM Sale (Partial) ($1,000,001 - $5,000,000) House
trade 2022-11-28 MCO Sale (Full) ($250,001 - $500,000) House
trade 2022-11-28 OXY Sale (Full) ($1,001 - $15,000) House
trade 2022-11-28 SSLTY Sale (Full) ($15,001 - $50,000) House
trade 2022-11-28 ZBH Sale (Full) ($100,001 - $250,000) House
trade 2022-11-28 ZIMV Sale (Full) ($1,001 - $15,000) House
trade 2022-10-31 Purchase ($1,001 - $15,000) House
trade 2022-10-28 Purchase ($1,001 - $15,000) House
trade 2022-09-06 WFC Purchase ($1,001 - $15,000) Senate
trade 2022-06-23 LMT Sale (Full) ($50,001 - $100,000) Senate
trade 2022-06-23 KO Sale (Full) ($1,001 - $15,000) Senate
trade 2022-06-23 CSCO Sale (Full) ($1,001 - $15,000) Senate
trade 2022-06-23 CAT Sale (Full) ($50,001 - $100,000) Senate
trade 2022-06-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2022-03-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2022-01-25 BTC Purchase ($15,001 - $50,000) Senate
trade 2021-12-17 CBOE Sale (Full) ($1,001 - $15,000) House
trade 2021-12-17 RNGR Exchange ($15,001 - $50,000) House
trade 2021-12-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2021-11-24 CBOE Purchase ($1,001 - $15,000) House
trade 2021-09-03 Purchase ($1,001 - $15,000) Senate
trade 2021-06-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2021-03-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2020-12-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2020-09-02 WFC Purchase ($1,001 - $15,000) Senate
trade 2020-08-25 GLD Sale (Full) ($1,001 - $15,000) House
trade 2020-08-25 GLD Sale (Full) ($1,001 - $15,000) House
trade 2020-06-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2020-05-14 GLD Purchase ($1,001 - $15,000) House
trade 2020-05-14 GLD Purchase ($1,001 - $15,000) House
trade 2020-03-31 CAT Sale (Full) ($1,001 - $15,000) House
trade 2020-03-31 NEM Sale (Full) ($1,001 - $15,000) House
trade 2020-03-04 WFC Purchase ($1,001 - $15,000) Senate
trade 2019-12-04 WFC Purchase ($1,001 - $15,000) Senate
trade 2019-11-27 PAGP Sale (Full) ($1,001 - $15,000) Senate
trade 2019-09-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2019-06-03 VMC Sale (Full) ($250,001 - $500,000) Senate
trade 2019-06-03 IR Sale (Full) ($250,001 - $500,000) Senate
trade 2019-06-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2019-05-15 GS Sale (Partial) ($50,001 - $100,000) Senate
trade 2019-03-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2018-12-18 GE Sale (Full) ($15,001 - $50,000) Senate
trade 2018-12-18 GE Sale (Partial) ($1,001 - $15,000) Senate
trade 2018-12-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2018-11-29 WPM Sale (Partial) ($1,001 - $15,000) House
trade 2018-09-06 WFC Purchase ($1,001 - $15,000) Senate
trade 2018-06-01 WFC Purchase ($1,001 - $15,000) Senate
trade 2018-04-10 CBS Sale (Full) ($1,001 - $15,000) Senate
trade 2018-03-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2017-12-05 WFC Purchase ($1,001 - $15,000) Senate
trade 2017-09-07 WFC Purchase ($1,001 - $15,000) Senate
trade 2017-04-21 Sale (Full) ($15,001 - $50,000) Senate
trade 2017-02-02 Sale (Partial) ($50,001 - $100,000) Senate
trade 2016-09-19 AAPL Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 LLY Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 HON Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 IR Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 IBM Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 BTO Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 JPM Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 LYB Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 MA Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 MCHP Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 MSFT Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 MYL Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 PEP Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 PFE Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 SKX Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 SBUX Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 HQL Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 TXT Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 GRX Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 UL Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 UTX Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 V Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 WFC Sale (Full) ($1,001 - $15,000) House
trade 2016-09-19 WY Sale (Full) ($1,001 - $15,000) House
trade 2016-06-09 Sale (Partial) ($50,001 - $100,000) Senate
trade 2016-04-17 Sale (Full) ($15,001 - $50,000) Senate
trade 2016-04-17 OKE Sale (Partial) ($15,001 - $50,000) Senate
trade 2016-02-25 Sale (Full) ($50,001 - $100,000) Senate
trade 2016-02-25 OKE Sale (Partial) ($15,001 - $50,000) Senate
trade 2016-02-25 GS Sale (Partial) ($50,001 - $100,000) Senate
trade 2016-02-25 OKE Sale (Partial) ($15,001 - $50,000) Senate
trade 2015-11-29 Sale (Full) ($15,001 - $50,000) Senate
trade 2015-10-15 Sale (Partial) ($15,001 - $50,000) Senate
trade 2015-07-29 BAX Purchase ($1,001 - $15,000) House
trade 2015-07-29 DLPH Sale (Full) ($1,001 - $15,000) House
trade 2015-07-29 GPC Sale (Full) ($1,001 - $15,000) House
trade 2015-07-29 PYPL Purchase ($1,001 - $15,000) House
trade 2015-07-14 MCHP Purchase ($1,001 - $15,000) House
trade 2015-07-14 HQL Sale (Full) ($1,001 - $15,000) House
trade 2015-07-14 WBA Purchase ($1,001 - $15,000) House
trade 2015-07-10 HD Sale (Full) ($1,001 - $15,000) House
trade 2015-07-10 SBUX Purchase ($1,001 - $15,000) House
trade 2015-05-28 CGO Purchase ($1,001 - $15,000) House
trade 2015-05-28 GILD Sale (Full) ($1,001 - $15,000) House
trade 2015-05-28 SYK Sale (Full) ($1,001 - $15,000) House
trade 2015-05-13 AXP Purchase ($1,001 - $15,000) House
trade 2015-05-13 LLY Purchase ($1,001 - $15,000) House
trade 2015-05-13 HD Purchase ($1,001 - $15,000) House
trade 2015-05-13 INTC Sale (Full) ($1,001 - $15,000) House
trade 2015-05-11 AMGN Sale (Full) ($1,001 - $15,000) House
trade 2015-05-11 GLW Sale (Full) ($1,001 - $15,000) House
trade 2015-05-11 GPC Purchase ($1,001 - $15,000) House
trade 2015-05-11 HR Sale (Full) ($1,001 - $15,000) House
trade 2015-05-11 JDD Purchase ($1,001 - $15,000) House
trade 2015-04-28 KKR Sale (Full) ($1,001 - $15,000) House
trade 2015-04-28 GRX Purchase ($1,001 - $15,000) House
trade 2015-04-10 GD Purchase ($1,001 - $15,000) House
trade 2015-04-10 KKR Purchase ($1,001 - $15,000) House
trade 2015-04-10 MYL Sale (Full) ($1,001 - $15,000) House
trade 2015-04-10 OPY Purchase ($1,001 - $15,000) House
trade 2015-04-10 UPS Sale (Full) ($1,001 - $15,000) House
trade 2015-04-10 FR Sale (Full) ($1,001 - $15,000) House
trade 2015-04-10 OGLYX Purchase ($1,001 - $15,000) House
trade 2015-02-03 PAGP Purchase ($50,001 - $100,000) Senate
trade 2014-12-19 Sale (Full) ($1,000,001 - $5,000,000) House
trade 2014-10-30 EMC Sale (Full) ($1,001 - $15,000) House
trade 2014-10-15 WMB Purchase ($1,001 - $15,000) House
trade 2014-10-14 EPD Purchase ($1,001 - $15,000) House
trade 2014-02-28 DPM Purchase ($1,001 - $15,000) House
trade 2014-02-24 KMI Sale (Full) ($1,001 - $15,000) House
trade 2014-02-21 EPD Purchase ($50,001 - $100,000) Senate
trade 2014-02-06 BFK Purchase ($15,001 - $50,000) Senate
trade 2013-03-28 PAA Sale (Full) ($1,001 - $15,000) House
trade 2013-01-15 KMI Purchase ($1,001 - $15,000) House
Powered by Datasette · Queries took 0.805ms