federal_register

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

758,466 rows where type = "Notice" sorted by publication_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publication_date (date)

These facets timed out: pub_year

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