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

3 rows where pub_year = 2003 and type = "Uncategorized Document" sorted by publication_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: publication_date (date)

type 1

  • Uncategorized Document · 3 ✖

pub_year 1

  • 2003 · 3 ✖
document_number title type abstract publication_date ▲ pub_year pub_month html_url pdf_url agency_names agency_ids excerpts
C3-4171 Financial Crimes Enforcement Network; Anti-Money Laundering Programs for Dealers in Precious Metals, Stones, or Jewels Uncategorized Document   2003-03-13 2003 3 https://www.federalregister.gov/documents/2003/03/13/C3-4171/financial-crimes-enforcement-network-anti-money-laundering-programs-for-dealers-in-precious-metals https://www.govinfo.gov/content/pkg/FR-2003-03-13/pdf/C3-4171.pdf Treasury Department; Agriculture Department; Forest Service 497,12,209  
C3-4457 Privacy Act of 1974; System of Records Uncategorized Document   2003-03-13 2003 3 https://www.federalregister.gov/documents/2003/03/13/C3-4457/privacy-act-of-1974-system-of-records https://www.govinfo.gov/content/pkg/FR-2003-03-13/pdf/C3-4457.pdf Treasury Department 497  
C3-5116 National Forest System Land and Resource Management Planning Uncategorized Document   2003-03-13 2003 3 https://www.federalregister.gov/documents/2003/03/13/C3-5116/national-forest-system-land-and-resource-management-planning https://www.govinfo.gov/content/pkg/FR-2003-03-13/pdf/C3-5116.pdf Agriculture Department; Forest Service 12,209  

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