stock_trades

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

19 rows where ticker = "J" 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)

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);