federal_register

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

307 rows where pub_year = 2024 and type = "Presidential Document" sorted by publication_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE federal_register (
    document_number TEXT PRIMARY KEY,
    title TEXT,
    type TEXT,
    abstract TEXT,
    publication_date TEXT,
    pub_year INTEGER,
    pub_month INTEGER,
    html_url TEXT,
    pdf_url TEXT,
    agency_names TEXT,
    agency_ids TEXT,
    excerpts TEXT
);
CREATE INDEX idx_fr_date ON federal_register(publication_date);
CREATE INDEX idx_fr_year ON federal_register(pub_year);
CREATE INDEX idx_fr_type ON federal_register(type);
CREATE INDEX idx_fr_agencies ON federal_register(agency_names);