stock_trades

Congressional stock trading disclosures from 100% government sources. Senate: efdsearch.senate.gov (15,000+ transactions, 2012-present). House: disclosures-clerk.house.gov PTR PDFs parsed for transaction-level data (tickers, amounts, buy/sell). 64,000+ total transactions. Both chambers linked to congress_members via bioguide_id.

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

6 rows where ticker = "LIN" and transaction_type = "Exchange" sorted by transaction_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: member_name, bioguide_id, transaction_date, disclosure_date, asset_description, amount_range, owner, source_url, state_district, doc_id, transaction_date (date), disclosure_date (date)

transaction_type 1

  • Exchange · 6 ✖

ticker 1

chamber 1

id member_name bioguide_id chamber transaction_date ▲ disclosure_date ticker asset_description asset_type transaction_type amount_range owner comment source_url filing_type state_district doc_id
23828 Lamar Smith S000583 House 2018-10-31 2018-11-08 LIN Linde plc ordinary Share (LIN) [ST] CoMMENTS: LINdE PLC CoMbINEd LINdE ag WITH PRaXaIR oN oCTobER 31,2018. aLL PRaXaIR SToCK EXCHaNgEd FoR LINdE PLC SToCK. (oNE SHaRE FoR oNE SHaRE). SToCK VaLUE IS CoST baSIS IN PRaXaIR. ST Exchange $1,001 - $15,000 Self   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2018/20010626.pdf P TX21 20010626
24061 Robert J. Wittman W000804 House 2018-10-31 2018-11-14 LIN Linde plc ordinary Share (LIN) [ST] ST Exchange $1,001 - $15,000 Self   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2018/20010635.pdf P Va01 20010635
22854 Thomas MacArthur M001193 House 2018-10-30 2018-12-06 LIN Linde plc ordinary Share (LIN) [ST] ST Exchange $1,001 - $15,000 Dependent Child   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2018/20010583.pdf P NJ03 20010583
22855 Thomas MacArthur M001193 House 2018-10-30 2018-12-06 LIN Linde plc ordinary Share (LIN) [ST] ST Exchange $1,001 - $15,000 Dependent Child   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2018/20010583.pdf P NJ03 20010583
22856 Thomas MacArthur M001193 House 2018-10-30 2018-12-06 LIN Linde plc ordinary Share (LIN) [ST] ST Exchange $50,001 - $100,000 Joint   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2018/20010583.pdf P NJ03 20010583
28714 Bradley S. Schneider S001190 House 2018-10-22 2019-08-04 LIN linde plc Ordinary Share (lIN) [ST] ST Exchange $100,001 - $250,000 Spouse   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2019/20012082.pdf P Il10 20012082

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE stock_trades (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    member_name TEXT,
    bioguide_id TEXT,
    chamber TEXT,
    transaction_date TEXT,
    disclosure_date TEXT,
    ticker TEXT,
    asset_description TEXT,
    asset_type TEXT,
    transaction_type TEXT,
    amount_range TEXT,
    owner TEXT,
    comment TEXT,
    source_url TEXT,
    filing_type TEXT,
    state_district TEXT,
    doc_id TEXT
);
CREATE INDEX idx_st_bioguide ON stock_trades(bioguide_id);
CREATE INDEX idx_st_ticker ON stock_trades(ticker);
CREATE INDEX idx_st_date ON stock_trades(transaction_date);
CREATE INDEX idx_st_member ON stock_trades(member_name);
CREATE INDEX idx_st_type ON stock_trades(transaction_type);
CREATE INDEX idx_st_chamber ON stock_trades(chamber);