committee_member_trades (view)

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

250,518 rows sorted by transaction_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: transaction_date (date)

Next page

CREATE VIEW committee_member_trades AS
SELECT
    cm2.committee_id,
    c.name AS committee_name,
    cm2.bioguide_id,
    cm2.member_name,
    cm2.title AS committee_role,
    st.ticker,
    st.asset_description,
    st.transaction_type,
    st.transaction_date,
    st.amount_range
FROM committee_memberships cm2
JOIN committees c ON cm2.committee_id = c.committee_id
JOIN stock_trades st ON cm2.bioguide_id = st.bioguide_id
WHERE st.ticker IS NOT NULL AND st.ticker != ''
ORDER BY cm2.committee_id, st.transaction_date DESC;