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

5 rows where ticker = "J" and transaction_type = "Purchase" 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, asset_type, amount_range, owner, source_url, state_district, doc_id, transaction_date (date), disclosure_date (date)

chamber 2

transaction_type 1

  • Purchase · 5 ✖

ticker 1

id member_name bioguide_id chamber transaction_date ▲ disclosure_date ticker cik asset_description asset_type transaction_type amount_range owner comment source_url filing_type state_district doc_id
49722 Greg Stanton S001211 House 2023-09-26 2023-11-09 J 52988 Jacobs Solutions Inc. (J) [ST] ST Purchase $1,001 - $15,000 Spouse   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2023/20023892.pdf P AZ04 20023892
4402 Cynthia M Lummis L000571 Senate 2021-09-03   J 52988 Jacobs Engineering Group Inc. Common Stock Stock Purchase $1,001 - $15,000 Self   https://efdsearch.senate.gov/search/view/ptr/e4053f72-b9ad-4642-a996-f250485f4d33/ P    
39085 William R. Keating K000375 House 2021-03-17 2021-04-27 J 52988 Jacobs Engineering group Inc. (J) [ST] ST Purchase $1,001 - $15,000 Self   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2021/20018465.pdf P MA09 20018465
34811 David B. McKinley M001180 House 2020-04-30 2020-05-15 J 52988 Jacobs Engineering group Inc. (J) [ST] ST Purchase $1,001 - $15,000 Self   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2020/20016540.pdf P WV01 20016540
34812 David B. McKinley M001180 House 2020-04-30 2020-05-15 J 52988 Jacobs Engineering group Inc. (J) [ST] ST Purchase $15,001 - $50,000 Joint   https://disclosures-clerk.house.gov/public_disc/ptr-pdfs/2020/20016540.pdf P WV01 20016540

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,
    cik INTEGER,              -- SEC EDGAR CIK, populated from ticker_sic+sec_companies
    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_cik ON stock_trades(cik) WHERE cik IS NOT NULL;
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);