openregs: documents: 1 row where docket_id = "FDA-2004-F-0069" and posted_year = 2010 sorted by posted

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

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

1 row where docket_id = "FDA-2004-F-0069" and posted_year = 2010 sorted by posted_date descending

descending

id	agency_id	docket_id	title	document_type	subtype	posted_date ▲	posted_year	posted_month	comment_start_date	comment_end_date	last_modified	fr_doc_num	open_for_comment	withdrawn	object_id
FDA-2004-F-0069-0002	FDA	Filing of Food Additive Petition (FAP 3M4744), provide for the safe use of ionizing radiation in the production of fully cooked shelf stable foods, including fully cooked multiple ingredient shelf stable foods, where the absorbed dose required to cause a 12 log reduction in Clostridium botulinum has been established FDA-2004-F-0069	Withdrawals of Food Additive Petitions: Sterigenics International, Inc.	Notice	NWL-Notice of Withdrawl	2010-07-12T04:00:00Z	2010	7	2010-07-12T04:00:00Z		2010-07-12T14:30:12Z	2010-16884	0	0	0900006480b176fe

Advanced export

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

CREATE TABLE documents (
    id TEXT PRIMARY KEY,
    agency_id TEXT,
    docket_id TEXT REFERENCES dockets(id),
    title TEXT,
    document_type TEXT,
    subtype TEXT,
    posted_date TEXT,
    posted_year INTEGER,
    posted_month INTEGER,
    comment_start_date TEXT,
    comment_end_date TEXT,
    last_modified TEXT,
    fr_doc_num TEXT,
    open_for_comment INTEGER,
    withdrawn INTEGER,
    object_id TEXT
);
CREATE INDEX idx_docs_agency ON documents(agency_id);
CREATE INDEX idx_docs_docket ON documents(docket_id);
CREATE INDEX idx_docs_date ON documents(posted_date);
CREATE INDEX idx_docs_year ON documents(posted_year);
CREATE INDEX idx_docs_type ON documents(document_type);
CREATE INDEX idx_docs_frnum ON documents(fr_doc_num);