congressional_record

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

51,268 rows where congress = 119 sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: session, date (date)

Next page

CREATE TABLE congressional_record (
    granule_id TEXT PRIMARY KEY,
    date TEXT,
    congress INTEGER,
    session INTEGER,
    volume TEXT,
    issue TEXT,
    title TEXT,
    chamber TEXT,
    granule_class TEXT,
    sub_granule_class TEXT,
    page_start TEXT,
    page_end TEXT,
    speakers TEXT,
    bills TEXT,
    citation TEXT,
    full_text TEXT
);
CREATE INDEX idx_crec_date ON congressional_record(date);
CREATE INDEX idx_crec_chamber ON congressional_record(chamber);
CREATE INDEX idx_crec_congress ON congressional_record(congress);
CREATE INDEX idx_crec_class ON congressional_record(granule_class);