federal_register

All Federal Register documents (rules, proposed rules, notices, presidential documents) from 1994 to present.

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

1 row where pub_year = 1996 and type = "Uncategorized Document" sorted by publication_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

type 1

  • Uncategorized Document · 1 ✖

pub_year 1

  • 1996 · 1 ✖
document_number title type abstract publication_date ▲ pub_year pub_month html_url pdf_url agency_names agency_ids excerpts
96-2320-2 Board of Governors of the Federal Reserve System Uncategorized Document   1996-02-02 1996 2 https://www.federalregister.gov/documents/1996/02/02/96-2320-2/board-of-governors-of-the-federal-reserve-system https://www.govinfo.gov/content/pkg/FR-1996-02-02/pdf/96-2320-2.pdf      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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