documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where docket_id = "FDA-2014-N-0053" and posted_year = 2023 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, posted_date (date), comment_start_date (date), last_modified (date)
| 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-2014-N-0053-1327 | FDA | None FDA-2014-N-0053 | Requirements for Additional Traceability Records for Certain Foods; Technical Amendment | Rule | Final Rule | 2023-09-26T04:00:00Z | 2023 | 9 | 2023-09-26T04:00:00Z | 2023-09-26T14:20:20Z | 2023-20746 | 0 | 0 | 0900006485ff576c | |
| FDA-2014-N-0053-1326 | FDA | None FDA-2014-N-0053 | Agency Information Collection Activities; Announcement of Office of Management and Budget Approvals | Notice | Notice of Approval | 2023-02-14T05:00:00Z | 2023 | 2 | 2023-02-14T05:00:00Z | 2023-02-14T14:55:10Z | 2023-03073 | 0 | 0 | 090000648568b128 | |
| FDA-2014-N-0053-1325 | FDA | None FDA-2014-N-0053 | Requirements for Additional Traceability Records for Certain Foods - Correction | Rule | Correction | 2023-02-01T05:00:00Z | 2023 | 2 | 2023-02-01T05:00:00Z | 2023-09-26T14:20:06Z | C1-2022-24417 | 0 | 0 | 09000064856258ea | |
| FDA-2014-N-0053-1321 | FDA | None FDA-2014-N-0053 | Tab B - FDA Food Traceability- Requirements for Additional Traceability Records for Certain Foods | Supporting & Related Material | Background Material | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:20:51Z | 0 | 0 | 09000064855c6dd9 | |||
| FDA-2014-N-0053-1318 | FDA | None FDA-2014-N-0053 | Memorandum to FDA DMS on Traceability Final Rule- Requirements for Additional Traceability Records for Certain Foods (Final Rule); Publication Date: November 21, 2022 | Supporting & Related Material | Memorandum | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:20:39Z | 0 | 0 | 09000064855c6dd7 | |||
| FDA-2014-N-0053-1320 | FDA | None FDA-2014-N-0053 | Tab A - FDA Food Traceability - FINAL RULE- Requirements for Additional Traceability Records for Certain Foods | Supporting & Related Material | Background Material | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:20:48Z | 0 | 0 | 09000064855c6ddb | |||
| FDA-2014-N-0053-1324 | FDA | None FDA-2014-N-0053 | Tab C - FDA Food Traceability - FINAL RULE- Requirements for Additional Traceability Records for Certain Foods | Supporting & Related Material | Background Material | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:21:04Z | 0 | 0 | 09000064855c6ddd | |||
| FDA-2014-N-0053-1323 | FDA | None FDA-2014-N-0053 | Tab C - FDA Food Traceability- Requirements for Additional Traceability Records for Certain Foods | Supporting & Related Material | Background Material | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:20:59Z | 0 | 0 | 09000064855c6dda | |||
| FDA-2014-N-0053-1319 | FDA | None FDA-2014-N-0053 | Tab A - FDA Food Traceability Requirements for Additional Traceability Records for Certain Foods | Supporting & Related Material | Background Material | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:20:42Z | 0 | 0 | 09000064855c6dd8 | |||
| FDA-2014-N-0053-1322 | FDA | None FDA-2014-N-0053 | Tab B - FDA Food Traceability - FINAL RULE- Requirements for Additional Traceability Records for Certain Foods | Supporting & Related Material | Background Material | 2023-01-09T05:00:00Z | 2023 | 1 | 2023-01-09T21:20:55Z | 0 | 0 | 09000064855c6ddc |
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);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;