documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where docket_id = "FDA-2022-N-1635" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_date, posted_month, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 4
agency_id 1
- FDA 9
| 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-2022-N-1635-0019 | FDA | None FDA-2022-N-1635 | Reference 1 - FDA, ‘‘Color Certification Fee Study,’’ March 2024. | Supporting & Related Material | Background Material | 2024-11-08T05:00:00Z | 2024 | 11 | 2024-11-08T13:57:51Z | 0 | 0 | 09000064868099c9 | |||
| FDA-2022-N-1635-0018 | FDA | None FDA-2022-N-1635 | Color Additive Certification; Increase in Fees for Certification Services | Rule | Final Rule | 2024-11-08T05:00:00Z | 2024 | 11 | 2024-11-08T13:57:22Z | 2024-25974 | 0 | 0 | 09000064868092dc | ||
| FDA-2022-N-1635-0014 | FDA | None FDA-2022-N-1635 | Color Additive Certification; Increase in Fees for Certification Services; Extension of the Comment Period | Proposed Rule | Extension of Comment Period | 2024-05-28T04:00:00Z | 2024 | 5 | 2024-05-28T04:00:00Z | 2024-05-28T16:36:53Z | 2024-11639 | 0 | 0 | 0900006486587641 | |
| FDA-2022-N-1635-0013 | FDA | None FDA-2022-N-1635 | Request for Extension from International Association of Color Manufacturers | Other | Request for Extension | 2024-05-09T04:00:00Z | 2024 | 5 | 2024-05-09T04:00:00Z | 2024-05-09T17:39:03Z | 0 | 0 | 090000648654f7c8 | ||
| FDA-2022-N-1635-0009 | FDA | None FDA-2022-N-1635 | Color Certification Fee Study March 2024 | Other | Certifications | 2024-04-26T04:00:00Z | 2024 | 4 | 2024-04-27T04:00:00Z | 2024-04-27T18:19:41Z | 0 | 0 | 090000648651a6d7 | ||
| FDA-2022-N-1635-0008 | FDA | None FDA-2022-N-1635 | Color Additive Certification; Increase in Fees for Certification Services; Reopening of the Comment Period | Proposed Rule | Reopening of Comment Period | 2024-04-26T04:00:00Z | 2024 | 4 | 2024-04-26T04:00:00Z | 2024-06-28T03:59:59Z | 2024-06-28T01:00:42Z | 2024-08950 | 0 | 0 | 09000064864f28cf |
| FDA-2022-N-1635-0005 | FDA | None FDA-2022-N-1635 | Color Additive Certification; Increase in Fees for Certification Services; Reopening of the Comment Period | Proposed Rule | Reopening of Comment Period | 2023-01-24T05:00:00Z | 2023 | 1 | 2023-01-24T05:00:00Z | 2023-01-24T20:20:06Z | 2023-01361 | 0 | 0 | 0900006485605f46 | |
| FDA-2022-N-1635-0003 | FDA | None FDA-2022-N-1635 | Request for Extension from International Association of Color Manufacturers | Other | Request for Extension | 2022-12-01T05:00:00Z | 2022 | 12 | 2022-12-01T05:00:00Z | 2022-12-01T19:17:00Z | 0 | 0 | 090000648550c2c9 | ||
| FDA-2022-N-1635-0001 | FDA | None FDA-2022-N-1635 | Color Additive Certification; Increase in Fees for Certification Services | Proposed Rule | Notice of Proposed Rulemaking (NPRM) | 2022-11-02T04:00:00Z | 2022 | 11 | 2022-11-02T04:00:00Z | 2024-05-29T03:59:59Z | 2024-05-29T01:01:00Z | 2022-23844 | 0 | 0 | 090000648547b387 |
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;