documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
36 rows where docket_id = "FDA-1979-N-0028" and posted_year = 2014 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, comment_start_date (date), comment_end_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-1979-N-0028-0041 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Letter from Cosmetic, Toiletry, and Fragrance Association to FDA | Other | Letter(s) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T05:00:00Z | 2014-05-15T14:29:48Z | 0 | 0 | 090000648055396f | ||
| FDA-1979-N-0028-0055 | FDA | Lakes of Color Additives FDA-1979-N-0028 | United States of Agriculture Information for the Press; Certification of Coal-Tar Colors - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:16:36Z | 0 | 0 | 09000064805539b3 | |||
| FDA-1979-N-0028-0062 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Handbook of US Colorants for Foods, Drugs, and Cosmetics - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:51:49Z | 0 | 0 | 09000064805539b8 | |||
| FDA-1979-N-0028-0069 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Memorandum re Food and Color Additives Review Section (FCARS, HFF-415) - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:31:14Z | 0 | 0 | 09000064805539c1 | |||
| FDA-1979-N-0028-0050 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Report on Pure Dye, Impurities, and Substrata in Pigments - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:51:23Z | 0 | 0 | 09000064805539ae | |||
| FDA-1979-N-0028-0066 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Intermediates and Subsidiary Colors in FD&C Blue No.2 Straight Color and Lake - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:16:39Z | 0 | 0 | 09000064805539be | |||
| FDA-1979-N-0028-0071 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Method for Determination of Color Stability in Laking - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:39:45Z | 0 | 0 | 09000064805539c3 | |||
| FDA-1979-N-0028-0046 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Dye Elution from Aluminum Lake Synthetic Food Colors VII - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:31:40Z | 0 | 0 | 09000064805539a9 | |||
| FDA-1979-N-0028-0053 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Cosmetics Science and Technology - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:05:50Z | 0 | 0 | 09000064805539b1 | |||
| FDA-1979-N-0028-0060 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Memorandum re D & C Color Additive Lakes; Certification Records and Answers to Questions Regarding Substrata and Precipitant Usage - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:41:10Z | 0 | 0 | 09000064805539b6 | |||
| FDA-1979-N-0028-0057 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Memorandum from Additives Evaluation Branch re Color Additive Petition - Safety Evaluation of Substrata and Precipitants Used in the Manufacture of Color Additive Lakes - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T19:15:06Z | 0 | 0 | 09000064805539a6 | |||
| FDA-1979-N-0028-0074 | FDA | Lakes of Color Additives FDA-1979-N-0028 | International Cosmetic Ingredient Dictionary - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:54:19Z | 0 | 0 | 09000064805539c6 | |||
| FDA-1979-N-0028-0054 | FDA | Lakes of Color Additives FDA-1979-N-0028 | United States Department of Agriculture; Food Inspection Decision; Dyes, Chemicals and Preservatives in Foods - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:12:00Z | 0 | 0 | 09000064805539b2 | |||
| FDA-1979-N-0028-0042 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Report from Cosmetic, Toiletry and Fragrance Association, Inc. | Other | Report | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T05:00:00Z | 2014-05-15T14:30:12Z | 0 | 0 | 0900006480553970 | ||
| FDA-1979-N-0028-0070 | FDA | Lakes of Color Additives FDA-1979-N-0028 | The 1977 Survey of Industry on the Use of Food Additives - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:32:59Z | 0 | 0 | 09000064805539c2 | |||
| FDA-1979-N-0028-0044 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Color Additive Lakes Reference List - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:27:10Z | 0 | 0 | 09000064805539a7 | |||
| FDA-1979-N-0028-0059 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Color Additives Lakes Reference List - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:38:08Z | 0 | 0 | 09000064805539b5 | |||
| FDA-1979-N-0028-0061 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Colour Index, Volume 4 - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:47:36Z | 0 | 0 | 09000064805539b7 | |||
| FDA-1979-N-0028-0065 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Memorandum re Color Stability in Manufacturing Process for FD&C Lakes - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:10:04Z | 0 | 0 | 09000064805539bc | |||
| FDA-1979-N-0028-0058 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Memorandum from Office of Cosmetics and Colors re Safety Evaluation of Rosin in Color Additive Lakes - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:33:20Z | 0 | 0 | 09000064805539a5 | |||
| FDA-1979-N-0028-0051 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Report on Lakes and Pigments - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:59:06Z | 0 | 0 | 09000064805539af | |||
| FDA-1979-N-0028-0063 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Report on the Certification of Color Additives Foreign and Domestic Manufacturers - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:55:18Z | 0 | 0 | 09000064805539b9 | |||
| FDA-1979-N-0028-0043 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Request for Extension of Comment Due Date from Cosmetic, Toiletry and Fragrance Association | Other | Request for Extension | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T05:00:00Z | 1979-08-22T03:59:59Z | 2014-05-15T15:43:50Z | 0 | 0 | 0900006480553979 | |
| FDA-1979-N-0028-0052 | FDA | Lakes of Color Additives FDA-1979-N-0028 | The Hydrous Oxides of Aluminum and Color Lake Formation - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:01:06Z | 0 | 0 | 09000064805539b0 | |||
| FDA-1979-N-0028-0056 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Coping with International Color Regulations - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T17:23:23Z | 0 | 0 | 09000064805539b4 | |||
| FDA-1979-N-0028-0039 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Request for Extension of Comment Due Date from Cosmetic, Toiletry and Fragrance Association, Inc. | Other | Request for Extension | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T05:00:00Z | 1979-08-22T03:59:59Z | 2014-05-14T15:03:03Z | 0 | 0 | 0900006480553966 | |
| FDA-1979-N-0028-0068 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Memorandum re Estimate of Daily Intake for Aluminum From Its Use in Lakes - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:29:11Z | 0 | 0 | 09000064805539c0 | |||
| FDA-1979-N-0028-0072 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Report of FY-95 Certification Results for Batches of D&C Lakes of D&C Orange No.5 - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:42:42Z | 0 | 0 | 09000064805539c4 | |||
| FDA-1979-N-0028-0049 | FDA | Lakes of Color Additives FDA-1979-N-0028 | United States Patent Office - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:48:16Z | 0 | 0 | 09000064805539ad | |||
| FDA-1979-N-0028-0073 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Report of FY-95 Certification Results for Batches of D&C Yellow No. 10 Lakes Prepared From Certified Batches of Straight Color - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:46:57Z | 0 | 0 | 09000064805539c5 | |||
| FDA-1979-N-0028-0064 | FDA | Lakes of Color Additives FDA-1979-N-0028 | The CTFA re Color Additive Master File No.9 Addition - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:19:45Z | 0 | 0 | 09000064805539ba | |||
| FDA-1979-N-0028-0067 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Thermal Stability of FD&C Lake Pigments - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T18:22:57Z | 0 | 0 | 09000064805539bf | |||
| FDA-1979-N-0028-0075 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Product Data - Reference | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T19:00:47Z | 0 | 0 | 09000064805539a4 | |||
| FDA-1979-N-0028-0045 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Dye Elution from Aluminum Lake Synthetic Food Colors - Reference | Supporting & Related Material | Reference (external attachments) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:27:19Z | 0 | 0 | 09000064805539a8 | |||
| FDA-1979-N-0028-0047 | FDA | Lakes of Color Additives FDA-1979-N-0028 | Dye Elution from Aluminum Lake Synthetic Food Colors V - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:32:38Z | 0 | 0 | 09000064805539ab | |||
| FDA-1979-N-0028-0048 | FDA | Lakes of Color Additives FDA-1979-N-0028 | United States Patent Office - References | Supporting & Related Material | Reference (internal unless indicated) | 2014-01-02T05:00:00Z | 2014 | 1 | 2014-01-02T16:35:07Z | 0 | 0 | 09000064805539ac |
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;