oge_pas_filings

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

799 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position, doc_type, parse_status, filing_date (date), filing_date_iso (date)

Next page

CREATE TABLE oge_pas_filings (
    filing_id           INTEGER PRIMARY KEY AUTOINCREMENT,
    filer_slug          TEXT NOT NULL,
    filer_last          TEXT,
    filer_first         TEXT,
    filer_name_full     TEXT,
    person_name_normalized TEXT,
    department          TEXT,
    position            TEXT,
    doc_type            TEXT,
    filing_date         TEXT,
    filing_date_iso     TEXT,
    page_count          INTEGER,
    file_size           INTEGER,
    original_filename   TEXT,
    public_actor_id     INTEGER,            -- FK to public_actors
    parse_status        TEXT
);
CREATE INDEX idx_ogef_slug ON oge_pas_filings(filer_slug);
CREATE INDEX idx_ogef_dept ON oge_pas_filings(department);
CREATE INDEX idx_ogef_actor ON oge_pas_filings(public_actor_id);
CREATE INDEX idx_ogef_name_norm ON oge_pas_filings(person_name_normalized);