documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where docket_id = "FDA-1978-N-0018" and posted_year = 2011 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_date, posted_month, comment_start_date, comment_end_date, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 4
- Other 7
- Proposed Rule 3
- Notice 1
- Rule 1
posted_year 1
- 2011 · 12 ✖
agency_id 1
- FDA 12
| 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-0741 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Bare Escentuals Beauty, Inc. - Citizen Petition | Other | Citizen Petition | 2011-11-04T04:00:00Z | 2011 | 11 | 2011-11-04T04:00:00Z | 2024-11-07T22:40:16Z | 1 | 0 | 0900006480f54fcd | ||
| FDA-1978-N-0018-0742 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgement Letter to Bare Escentuals Beauty Inc. | Other | Acknowledgement Letter/Receipt | 2011-11-04T04:00:00Z | 2011 | 11 | 2011-11-04T04:00:00Z | 2011-11-04T23:20:06Z | 0 | 0 | 0900006480f550f6 | ||
| FDA-1978-N-0018-0707 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Energizer Personal Care, LLC (EPC) - Request for Extension | Other | Request for Extension | 2011-09-16T04:00:00Z | 2011 | 9 | 2011-09-16T04:00:00Z | 2011-09-16T14:40:39Z | 0 | 0 | 0900006480ee2067 | ||
| FDA-1978-N-0018-0706 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Sunscreen Drug Products for Over-the-Counter Human Use: Request for Data and Information Regarding Dosage Forms; Extension of Comment Period | Proposed Rule | Notice of Extension | 2011-09-14T04:00:00Z | 2011 | 9 | 2011-09-14T04:00:00Z | 2011-10-18T03:59:59Z | 2012-03-24T19:28:47Z | 2011-23479 | 0 | 0 | 0900006480f19657 |
| FDA-1978-N-0018-0705 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Personal Care Products Council - Request for Extension | Other | Request for Extension | 2011-09-12T04:00:00Z | 2011 | 9 | 2011-09-12T04:00:00Z | 2011-09-12T22:44:37Z | 0 | 0 | 0900006480edf5d9 | ||
| FDA-1978-N-0018-0701 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Merck Consumer Care - Request for Extension Comment Due Date | Other | Request for Extension | 2011-07-08T04:00:00Z | 2011 | 7 | 2011-07-08T04:00:00Z | 2011-08-12T15:40:51Z | 0 | 0 | 0900006480ebd0b1 | ||
| FDA-1978-N-0018-0700 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Labeling and Effectiveness Testing: Sunscreen Drug Products for Over-the-Counter Human Use - Notice of Correction | Notice | Correction | 2011-07-05T04:00:00Z | 2011 | 7 | 2011-07-05T04:00:00Z | 2012-04-25T12:46:12Z | C1-2011-14766 | 0 | 0 | 0900006480eb965e | |
| FDA-1978-N-0018-0697 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Sunscreen Drug Products for Over-the-Counter Human Use; Request for Data and Information Regarding Dosage Forms | Proposed Rule | Notice of Proposed Rulemaking (NPRM) | 2011-06-17T04:00:00Z | 2011 | 6 | 2011-06-17T04:00:00Z | 2011-09-16T03:59:59Z | 2011-08-12T15:28:51Z | 2011-14768 | 0 | 0 | 0900006480e51fc3 |
| FDA-1978-N-0018-0698 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Labeling and Effectiveness Testing: Sunscreen Drug Products for Over-the-Counter Human Use | Rule | Final Rule | 2011-06-17T04:00:00Z | 2011 | 6 | 2011-06-17T04:00:00Z | 2017-12-07T17:18:11Z | 2011-14766 | 0 | 0 | 0900006480e52002 | |
| FDA-1978-N-0018-0699 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Revised Effectiveness Determination; Sunscreen Drug Products for Over-the-Counter Human Use | Proposed Rule | Notice of Proposed Rulemaking (NPRM) | 2011-06-17T04:00:00Z | 2011 | 6 | 2011-06-17T04:00:00Z | 2011-09-16T03:59:59Z | 2012-02-08T21:51:20Z | 2011-14769 | 0 | 0 | 0900006480e52098 |
| FDA-1978-N-0018-0696 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Johnson & Johnson Consumer Companies, Inc. (JJCCI) and Neutrogena Corporation, Johnson & Johnson Consumer & Personal Products Worldwide (CPPW) - Letter | Other | LET-Letter | 2011-02-08T05:00:00Z | 2011 | 2 | 2011-02-08T05:00:00Z | 2011-06-11T16:25:40Z | 0 | 0 | 0900006480be2d06 | ||
| FDA-1978-N-0018-0695 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Johnson & Johnson Consumer Companies, Inc. - Letter | Other | LET-Letter | 2011-02-08T05:00:00Z | 2011 | 2 | 2011-02-08T05:00:00Z | 2013-08-11T03:12:57Z | 0 | 0 | 0900006480bd827e |
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);