home / openregs

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

2 rows where pub_year = 2005 and type = "Uncategorized Document" sorted by publication_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

type 1

  • Uncategorized Document · 2 ✖

pub_year 1

  • 2005 · 2 ✖
document_number title type abstract publication_date ▲ pub_year pub_month html_url pdf_url agency_names agency_ids excerpts
C5-7607 Intent To Prepare a Draft Programmatic Environmental Impact Statement for Community Relocation, Newtok, AK Uncategorized Document   2005-04-22 2005 4 https://www.federalregister.gov/documents/2005/04/22/C5-7607/intent-to-prepare-a-draft-programmatic-environmental-impact-statement-for-community-relocation https://www.govinfo.gov/content/pkg/FR-2005-04-22/pdf/C5-7607.pdf Defense Department; Engineers Corps 103,142  
Z5-1541 Separate Rates and Combination Rates in Antidumping Investigtions Involving Non-Market Economy Countries Uncategorized Document   2005-04-14 2005 4 https://www.federalregister.gov/documents/2005/04/14/Z5-1541/separate-rates-and-combination-rates-in-antidumping-investigtions-involving-non-market-economy https://www.govinfo.gov/content/pkg/FR-2005-04-14/pdf/Z5-1541.pdf Commerce Department; International Trade Administration 54,261  

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);
Powered by Datasette · Queries took 1739.383ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API