documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where docket_id = "FDA-2017-D-5225" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, comment_start_date, open_for_comment, withdrawn, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 3
- Notice 4
- Other 3
- Proposed Rule 1
agency_id 1
- FDA 8
| 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-2017-D-5225-0028 | FDA | None FDA-2017-D-5225 | Foreign Supplier Verification Programs for Importers of Food for Humans and Animals: Guidance for Industry; Availability | Notice | Notice of Availability | 2023-01-11T05:00:00Z | 2023 | 1 | 2023-01-11T05:00:00Z | 2023-01-11T19:12:46Z | 2023-00391 | 0 | 0 | 09000064855e057a | |
| FDA-2017-D-5225-0029 | FDA | None FDA-2017-D-5225 | Foreign Supplier Verification Programs for Importers of Food for Humans and Animals: Guidance for Industry | Other | Guidance | 2023-01-11T05:00:00Z | 2023 | 1 | 2023-01-11T05:00:00Z | 2024-11-12T23:50:27Z | 1 | 0 | 09000064855e15d9 | ||
| FDA-2017-D-5225-0027 | FDA | None FDA-2017-D-5225 | Agency Information Collection Activities; Proposals, Submissions, and Approvals | Notice | Notice of Approval | 2022-07-06T04:00:00Z | 2022 | 7 | 2022-07-06T04:00:00Z | 2023-01-11T19:11:37Z | 2022-14348 | 0 | 0 | 09000064851b2a8a | |
| FDA-2017-D-5225-0026 | FDA | None FDA-2017-D-5225 | Agency Information Collection Activities; Submission for Office of Management and Budget Review; Comment Request; Foreign Supplier Verification Programs for Food Importers | Notice | 30 Day Proposed Information Collection | 2022-04-11T04:00:00Z | 2022 | 4 | 2022-04-11T04:00:00Z | 2022-05-12T03:59:59Z | 2023-01-11T19:11:24Z | 2022-07617 | 0 | 0 | 090000648500abb7 |
| FDA-2017-D-5225-0025 | FDA | None FDA-2017-D-5225 | Agency Information Collection Activities; Proposed Collection; Comment Request; Foreign Supplier Verification Programs for Food Importers | Notice | 60 Day Proposed Information Collection | 2022-01-28T05:00:00Z | 2022 | 1 | 2022-01-28T05:00:00Z | 2022-03-30T03:59:59Z | 2023-01-11T19:12:05Z | 2022-01796 | 0 | 0 | 0900006484f416e3 |
| FDA-2017-D-5225-0003 | FDA | None FDA-2017-D-5225 | Foreign Supplier Verification Programs for Importers of Food for Humans and Animals; Draft Guidance for Industry; Availability | Proposed Rule | GDL Guidance | 2018-01-25T05:00:00Z | 2018 | 1 | 2018-01-25T05:00:00Z | 2018-05-26T03:59:59Z | 2023-01-11T19:13:39Z | 2018-01297 | 0 | 0 | 0900006482e645c5 |
| FDA-2017-D-5225-0002 | FDA | None FDA-2017-D-5225 | Foreign Supplier Verification Programs for Importers of Food for Humans and Animals: Guidance for Industry Draft Guidance | Other | Guidance | 2018-01-24T05:00:00Z | 2018 | 1 | 2018-01-24T05:00:00Z | 2023-01-11T19:14:43Z | 0 | 0 | 0900006482e55693 | ||
| FDA-2017-D-5225-0001 | FDA | None FDA-2017-D-5225 | Foreign Supplier Verification Programs for Importers of Food for Humans and Animals: Draft Guidance for Industry | Other | 2018-01-19T00:00:00Z | 2018 | 1 | 2018-01-24T17:38:55Z | 0 | 1 | 0900006482e3191b |
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;