documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where docket_id = "FDA-1978-N-0018" and posted_year = 2008 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, comment_start_date, 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-1978-N-0018-0652 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Playtex Products, Inc. Comments to Proposed Monograph for OTC Sunscreen Products re: Comment from Energizer Personal Care (Playtex Products, Inc) | Supporting & Related Material | Background Material | 2008-12-30T05:00:00Z | 2008 | 12 | 2019-07-29T17:47:16Z | 0 | 0 | 090000648055c1e1 | |||
| FDA-1978-N-0018-0653 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Supplement from Energizer Personal Care (Playtex Products, Inc.) | Other | Supplement (SUP) | 2008-12-30T05:00:00Z | 2008 | 12 | 2008-12-30T05:00:00Z | 2019-07-31T14:56:45Z | 0 | 0 | 09000064807df3d8 | ||
| FDA-1978-N-0018-0644 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from The International Center for Technology Assessment | Other | Citizen Petition | 2008-12-23T05:00:00Z | 2008 | 12 | 2008-12-23T05:00:00Z | 2019-07-31T18:01:58Z | 0 | 0 | 090000648055a922 | ||
| FDA-1978-N-0018-0648 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgment Letter from FDA to Ciba Corporation | Other | Acknowledgement Letter/Receipt | 2008-12-23T05:00:00Z | 2008 | 12 | 2008-12-23T05:00:00Z | 2019-07-30T16:41:18Z | 0 | 0 | 09000064807d5c45 | ||
| FDA-1978-N-0018-0646 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from Ciba Corporation | Other | Citizen Petition | 2008-12-23T05:00:00Z | 2008 | 12 | 2008-12-23T05:00:00Z | 2019-08-02T01:01:01Z | 0 | 0 | 09000064807d5b6c | ||
| FDA-1978-N-0018-0645 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from Schering-Plough Corporation | Other | Citizen Petition | 2008-12-23T05:00:00Z | 2008 | 12 | 2008-12-23T05:00:00Z | 2019-07-30T16:47:54Z | 0 | 0 | 090000648055aa39 | ||
| FDA-1978-N-0018-0643 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from Hawaiian Tropic Tanning Research Laboratories, Inc. | Other | Citizen Petition | 2008-12-23T05:00:00Z | 2008 | 12 | 2008-12-23T05:00:00Z | 2019-07-30T13:21:07Z | 0 | 0 | 090000648055a8ae | ||
| FDA-1978-N-0018-0647 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from Home & Personal Care BL, Ciba Corporation to FDA/DDM | Other | Letter(s) | 2008-12-23T05:00:00Z | 2008 | 12 | 2008-12-23T05:00:00Z | 2019-08-06T12:23:21Z | 0 | 0 | 09000064807d5bba | ||
| FDA-1978-N-0018-0640 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from Rapid Precision Testing Laboratories | Other | Citizen Petition | 2008-08-15T04:00:00Z | 2008 | 8 | 2008-08-15T04:00:00Z | 2019-07-25T17:00:49Z | 0 | 0 | 090000648055a692 | ||
| FDA-1978-N-0018-0639 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from The Procter & Gamble Company | Other | Citizen Petition | 2008-08-15T04:00:00Z | 2008 | 8 | 2008-08-15T04:00:00Z | 2019-07-25T13:35:02Z | 0 | 0 | 090000648055a5f1 | ||
| FDA-1978-N-0018-0641 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgment Letter from FDA/DDM to Rapid Precision Testing Laboratories | Other | Acknowledgement Letter/Receipt | 2008-08-15T04:00:00Z | 2008 | 8 | 2008-08-15T04:00:00Z | 2019-07-25T17:16:07Z | 0 | 0 | 090000648055a694 | ||
| FDA-1978-N-0018-0642 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgement Letter from FDA/DDM to the Procter & Gamble Company | Other | Acknowledgement Letter/Receipt | 2008-08-15T04:00:00Z | 2008 | 8 | 2008-08-15T04:00:00Z | 2019-07-25T12:58:14Z | 0 | 0 | 09000064806c6d6b | ||
| FDA-1978-N-0018-0635 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Request for Extension from Personal Care Products Council | Other | Request for Extension | 2008-08-12T04:00:00Z | 2008 | 8 | 2008-08-12T04:00:00Z | 2019-08-06T16:49:33Z | 0 | 0 | 090000648063d7ce | ||
| FDA-1978-N-0018-0633 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Johnson & Johnson Consumer & Personal Product Companies [Cross-Reference Ereg18] - Supplement | Other | SUP-Supplement | 2008-08-12T04:00:00Z | 2008 | 8 | 2008-08-12T04:00:00Z | 2008-08-12T20:24:13Z | 0 | 0 | 09000064806255f0 | ||
| FDA-1978-N-0018-0634 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from Skin Cancer Foundation to FDA/CDER | Other | Letter(s) | 2008-08-12T04:00:00Z | 2008 | 8 | 2008-08-12T04:00:00Z | 2019-08-06T12:12:58Z | 0 | 0 | 090000648063d56d | ||
| FDA-1978-N-0018-0636 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Internal Memorandum from Randall Lutter to DDM (HFA-305) February 25, 2008 | Other | Letter(s) | 2008-08-12T04:00:00Z | 2008 | 8 | 2008-08-12T04:00:00Z | 2019-08-06T18:16:46Z | 0 | 0 | 090000648063d81d |
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);