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 S (partial) ($100,001 - $250,000) House
trade 2022-11-28 CVX S (partial) ($500,001 - $1,000,000) House
trade 2022-11-28 LLY S (partial) ($1,000,001 - $5,000,000) House
trade 2022-11-28 XOM S (partial) ($1,000,001 - $5,000,000) House
trade 2022-11-28 MCO S ($250,001 - $500,000) House
trade 2022-11-28 OXY S ($1,001 - $15,000) House
trade 2022-11-28 SSLTY S ($15,001 - $50,000) House
trade 2022-11-28 ZBH S ($100,001 - $250,000) House
trade 2022-11-28 ZIMV S ($1,001 - $15,000) House
trade 2022-10-31 P ($1,001 - $15,000) House
trade 2022-10-28 P ($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 S ($1,001 - $15,000) House
trade 2021-12-17 RNGR E ($15,001 - $50,000) House
trade 2021-12-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2021-11-24 CBOE P ($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 S ($1,001 - $15,000) House
trade 2020-08-25 GLD S ($1,001 - $15,000) House
trade 2020-06-03 WFC Purchase ($1,001 - $15,000) Senate
trade 2020-05-14 GLD P ($1,001 - $15,000) House
trade 2020-05-14 GLD P ($1,001 - $15,000) House
trade 2020-03-31 CAT S ($1,001 - $15,000) House
trade 2020-03-31 NEM S ($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 S (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 S ($1,001 - $15,000) House
trade 2016-09-19 LLY S ($1,001 - $15,000) House
trade 2016-09-19 HON S ($1,001 - $15,000) House
trade 2016-09-19 IR S ($1,001 - $15,000) House
trade 2016-09-19 IBM S ($1,001 - $15,000) House
trade 2016-09-19 BTO S ($1,001 - $15,000) House
trade 2016-09-19 JPM S ($1,001 - $15,000) House
trade 2016-09-19 LYB S ($1,001 - $15,000) House
trade 2016-09-19 MA S ($1,001 - $15,000) House
trade 2016-09-19 MCHP S ($1,001 - $15,000) House
trade 2016-09-19 MSFT S ($1,001 - $15,000) House
trade 2016-09-19 MYL S ($1,001 - $15,000) House
trade 2016-09-19 PEP S ($1,001 - $15,000) House
trade 2016-09-19 PFE S ($1,001 - $15,000) House
trade 2016-09-19 SKX S ($1,001 - $15,000) House
trade 2016-09-19 SBUX S ($1,001 - $15,000) House
trade 2016-09-19 HQL S ($1,001 - $15,000) House
trade 2016-09-19 TXT S ($1,001 - $15,000) House
trade 2016-09-19 GRX S ($1,001 - $15,000) House
trade 2016-09-19 UL S ($1,001 - $15,000) House
trade 2016-09-19 UTX S ($1,001 - $15,000) House
trade 2016-09-19 V S ($1,001 - $15,000) House
trade 2016-09-19 WFC S ($1,001 - $15,000) House
trade 2016-09-19 WY S ($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 P ($1,001 - $15,000) House
trade 2015-07-29 DLPH S ($1,001 - $15,000) House
trade 2015-07-29 GPC S ($1,001 - $15,000) House
trade 2015-07-29 PYPL P ($1,001 - $15,000) House
trade 2015-07-14 MCHP P ($1,001 - $15,000) House
trade 2015-07-14 HQL S ($1,001 - $15,000) House
trade 2015-07-14 WBA P ($1,001 - $15,000) House
trade 2015-07-10 HD S ($1,001 - $15,000) House
trade 2015-07-10 SBUX P ($1,001 - $15,000) House
trade 2015-05-28 CGO P ($1,001 - $15,000) House
trade 2015-05-28 GILD S ($1,001 - $15,000) House
trade 2015-05-28 SYK S ($1,001 - $15,000) House
trade 2015-05-13 AXP P ($1,001 - $15,000) House
trade 2015-05-13 LLY P ($1,001 - $15,000) House
trade 2015-05-13 HD P ($1,001 - $15,000) House
trade 2015-05-13 INTC S ($1,001 - $15,000) House
trade 2015-05-11 AMGN S ($1,001 - $15,000) House
trade 2015-05-11 GLW S ($1,001 - $15,000) House
trade 2015-05-11 GPC P ($1,001 - $15,000) House
trade 2015-05-11 HR S ($1,001 - $15,000) House
trade 2015-05-11 JDD P ($1,001 - $15,000) House
trade 2015-04-28 KKR S ($1,001 - $15,000) House
trade 2015-04-28 GRX P ($1,001 - $15,000) House
trade 2015-04-10 GD P ($1,001 - $15,000) House
trade 2015-04-10 KKR P ($1,001 - $15,000) House
trade 2015-04-10 MYL S ($1,001 - $15,000) House
trade 2015-04-10 OPY P ($1,001 - $15,000) House
trade 2015-04-10 UPS S ($1,001 - $15,000) House
trade 2015-04-10 FR S ($1,001 - $15,000) House
trade 2015-04-10 OGLYX P ($1,001 - $15,000) House
trade 2015-02-03 PAGP Purchase ($50,001 - $100,000) Senate
trade 2014-12-19 S ($1,000,001 - $5,000,000) House
trade 2014-10-30 EMC S ($1,001 - $15,000) House
trade 2014-10-15 WMB P ($1,001 - $15,000) House
trade 2014-10-14 EPD P ($1,001 - $15,000) House
trade 2014-02-28 DPM P ($1,001 - $15,000) House
trade 2014-02-24 KMI S ($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 S ($1,001 - $15,000) House
trade 2013-01-15 KMI P ($1,001 - $15,000) House
Powered by Datasette · Queries took 63.108ms