oge_pas_transactions

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

3,248 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: department, position, asset_class, tx_type, notification_over_30d, amount_range, amount_min, amount_max, tx_date_iso (date)

Next page

CREATE TABLE oge_pas_transactions (
    transaction_id      INTEGER PRIMARY KEY AUTOINCREMENT,
    filer_slug          TEXT NOT NULL,
    filer_last          TEXT,
    filer_first         TEXT,
    person_name_normalized TEXT,
    department          TEXT,
    position            TEXT,
    filing_date         TEXT,
    tx_number           INTEGER,
    asset_description   TEXT,
    asset_name          TEXT,
    asset_class         TEXT,
    ticker              TEXT,
    tx_type             TEXT,               -- Purchase | Sale | Exchange
    tx_date             TEXT,
    tx_date_iso         TEXT,
    notification_over_30d TEXT,
    amount_range        TEXT,
    amount_min          REAL,
    amount_max          REAL,
    source_filename     TEXT,
    public_actor_id     INTEGER
);
CREATE INDEX idx_oget_slug ON oge_pas_transactions(filer_slug);
CREATE INDEX idx_oget_ticker ON oge_pas_transactions(ticker) WHERE ticker IS NOT NULL;
CREATE INDEX idx_oget_txdate ON oge_pas_transactions(tx_date_iso);
CREATE INDEX idx_oget_actor ON oge_pas_transactions(public_actor_id);