documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
32 rows where docket_id = "FDA-1978-N-0018" and posted_year = 2009 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-0691 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Neutrogena Corporation and Johnson & Johnson Consumer Companies - Letter | Other | LET-Letter | 2009-11-18T05:00:00Z | 2009 | 11 | 2009-11-18T05:00:00Z | 2013-07-27T22:59:22Z | 0 | 0 | 0900006480a5498b | ||
| FDA-1978-N-0018-0688 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | 2003 Market Data (Compared to 1997 Market Data) - Report | Other | RPT-Report | 2009-11-12T05:00:00Z | 2009 | 11 | 2009-11-12T05:00:00Z | 2009-11-19T00:53:45Z | 0 | 0 | 0900006480a5605e | ||
| FDA-1978-N-0018-0687 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | "Sunscreen Market Analysis: The Evolution and Use of UVA-1 Actives" (2004 poster)- Report | Other | RPT-Report | 2009-11-12T05:00:00Z | 2009 | 11 | 2009-11-12T05:00:00Z | 2009-11-12T15:07:48Z | 0 | 0 | 0900006480a55e6a | ||
| FDA-1978-N-0018-0689 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | 2009 Market Analysis - Study Data - Report | Other | RPT-Report | 2009-11-12T05:00:00Z | 2009 | 11 | 2009-11-12T05:00:00Z | 2009-11-19T00:54:19Z | 0 | 0 | 0900006480a56062 | ||
| FDA-1978-N-0018-0690 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | 2009 Market Analysis - Study Report - Report | Other | RPT-Report | 2009-11-12T05:00:00Z | 2009 | 11 | 2009-11-12T05:00:00Z | 2009-11-19T00:54:49Z | 0 | 0 | 0900006480a560a4 | ||
| FDA-1978-N-0018-0686 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | FinalDataISORing2.xls - [ISO TC217 WG7 In vitro UVA Ring Test #2 Final Test Report - Report] re FDA-1978-N-0018-0685 | Supporting & Related Material | RPT-Report (Supporting and Related Material) | 2009-11-05T05:00:00Z | 2009 | 11 | 2009-11-19T00:52:50Z | 0 | 0 | 0900006480a52498 | |||
| FDA-1978-N-0018-0685 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | ISO TC217 WG7 In vitro UVA Ring Test #2 Final Test Report - Report | Other | RPT-Report | 2009-11-05T05:00:00Z | 2009 | 11 | 2009-11-05T05:00:00Z | 2009-11-05T18:19:00Z | 0 | 0 | 0900006480a52495 | ||
| FDA-1978-N-0018-0684 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | FDA/CDER Interim Response to L'Oreal U. S. A. Products, Inc. - Letter | Other | LET-Letter | 2009-09-17T04:00:00Z | 2009 | 9 | 2009-09-17T04:00:00Z | 2009-11-12T23:24:10Z | 0 | 0 | 0900006480a25002 | ||
| FDA-1978-N-0018-0682 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Surrette Associates, LLC - Citizen Petition | Other | CP-Citizen Petition | 2009-09-01T04:00:00Z | 2009 | 9 | 2009-09-01T04:00:00Z | 2018-12-19T14:16:18Z | 0 | 0 | 0900006480a0cc4e | ||
| FDA-1978-N-0018-0683 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgement Letter to Surrette Associates, LLC | Other | ACK-Acknowledgement Letter | 2009-09-01T04:00:00Z | 2009 | 9 | 2009-09-01T04:00:00Z | 2013-07-27T22:52:15Z | 0 | 0 | 0900006480a0cc4f | ||
| FDA-1978-N-0018-0679 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | FDA/CDER Interim Response to Ciba Corporation - Letter | Other | LET-Letter | 2009-04-28T04:00:00Z | 2009 | 4 | 2009-04-28T04:00:00Z | 2013-08-11T04:33:03Z | 0 | 0 | 090000648096e819 | ||
| FDA-1978-N-0018-0678 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Appendix 2 - "DSM Sunscreen Monograph Comments - December 21, 2007" - [L'Oreal USA Products, Inc. - Citizen Petition] | Supporting & Related Material | CP-Citizen Petition (Supporting & Related Materials) | 2009-04-10T04:00:00Z | 2009 | 4 | 2009-04-10T18:08:17Z | 0 | 0 | 090000648094906c | |||
| FDA-1978-N-0018-0676 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgement Letter to L'Oreal USA Products, Inc. | Other | ACK-Acknowledgement Letter | 2009-04-09T04:00:00Z | 2009 | 4 | 2009-04-09T04:00:00Z | 2009-04-09T23:19:30Z | 0 | 0 | 0900006480948fc0 | ||
| FDA-1978-N-0018-0675 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | L'Oreal USA Products, Inc. - Citizen Petition | Other | CP-Citizen Petition | 2009-04-09T04:00:00Z | 2009 | 4 | 2009-04-09T04:00:00Z | 2013-08-11T04:32:41Z | 0 | 0 | 0900006480948bf6 | ||
| FDA-1978-N-0018-0677 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | L'Oreal USA Electronic Message to FDA/CDER - Letter | Other | ELET-Electronic Letter | 2009-04-09T04:00:00Z | 2009 | 4 | 2009-04-09T04:00:00Z | 2013-07-27T22:42:04Z | 0 | 0 | 0900006480948bca | ||
| FDA-1978-N-0018-0666 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | The Cosmetic, Toiletry & Fragrance Association & The Consumer Healthcare Products Association - Citizen Petition (CP14) | Other | CP-Citizen Petition | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2009-02-25T17:31:35Z | 0 | 0 | 090000648055a877 | ||
| FDA-1978-N-0018-0669 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to Rapid Precision Testing Laboratories | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T14:59:27Z | 0 | 0 | 09000064808dda30 | ||
| FDA-1978-N-0018-0667 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to Arent Fox Kintner Plotkin and Kahn | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T15:02:39Z | 0 | 0 | 09000064808dd923 | ||
| FDA-1978-N-0018-0674 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to The Cosmetic, Toiletry, and Fragrance Association | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T14:41:13Z | 0 | 0 | 09000064808de198 | ||
| FDA-1978-N-0018-0673 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to Richard Blumenthal | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T14:46:02Z | 0 | 0 | 09000064808de134 | ||
| FDA-1978-N-0018-0668 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to The Procter and Gamble Company | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T15:01:15Z | 0 | 0 | 09000064808dd9e7 | ||
| FDA-1978-N-0018-0672 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to Schering-Plough Consumer Health Care | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T14:47:33Z | 0 | 0 | 09000064808de01b | ||
| FDA-1978-N-0018-0671 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to Tanning Research Laboratories, Inc. | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T14:49:32Z | 0 | 0 | 09000064808ddb9e | ||
| FDA-1978-N-0018-0670 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Partial Petition Approval and Denial from FDA to The Cosmetic, Toiletry, and Fragrance Association | Other | Partial Petition Approval and Denial | 2009-02-25T05:00:00Z | 2009 | 2 | 2009-02-25T05:00:00Z | 2019-08-05T14:56:09Z | 0 | 0 | 09000064808ddb48 | ||
| FDA-1978-N-0018-0664 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from Arent Fox Kintner Plotkin & Kahn on behalf of Estee Lauder, Inc. | Other | Citizen Petition | 2009-02-23T05:00:00Z | 2009 | 2 | 2009-02-23T05:00:00Z | 2019-08-02T12:43:57Z | 0 | 0 | 090000648055a14c | ||
| FDA-1978-N-0018-0665 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Citizen Petition from The Cosmetic, Toiletry & Fragrance Association & The Consumer Healthcare Products Association | Other | Citizen Petition | 2009-02-23T05:00:00Z | 2009 | 2 | 2009-02-23T05:00:00Z | 2019-07-29T19:41:52Z | 0 | 0 | 090000648055a89b | ||
| FDA-1978-N-0018-0661 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Form Letter Sample #1 - [Multiple Submitters=3] - Comment | Other | FL-Form Letter | 2009-02-04T05:00:00Z | 2009 | 2 | 2009-02-04T05:00:00Z | 2013-07-27T22:37:35Z | 0 | 0 | 0900006480845ac8 | ||
| FDA-1978-N-0018-0659 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from International Center for Technology Assessment to Senator re: Citizen Petition from The International Center for Technology Assessment | Other | Letter | 2009-02-02T05:00:00Z | 2009 | 2 | 2019-07-31T18:21:06Z | 0 | 0 | 090000648055a944 | |||
| FDA-1978-N-0018-0660 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Ciba Corporation Citizen Petition - Unified Agenda and Plan Search Results - Reference | Supporting & Related Material | REF-Reference Material (external attachments) | 2009-02-02T05:00:00Z | 2009 | 2 | 2009-02-02T22:47:14Z | 0 | 0 | 09000064807f12cf | |||
| FDA-1978-N-0018-0657 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | US Patent & Trademark Office-Substantially Visibly Transparent Topical Physical Sunscreen Formulation re: Citizen Petition from The International Center for Technology Assessment | Supporting & Related Material | Background Material | 2009-02-02T05:00:00Z | 2009 | 2 | 2019-07-31T18:13:07Z | 0 | 0 | 090000648055a905 | |||
| FDA-1978-N-0018-0656 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | US Patent & Trademark Office-Ultraviolet-Screening Zince Oxide Excellent in Transparency and Composition Containing the Same re: Citizen Petition from The International Center for Technology Assessment | Supporting & Related Material | Background Material | 2009-02-02T05:00:00Z | 2009 | 2 | 2019-07-31T18:11:56Z | 0 | 0 | 090000648055a901 | |||
| FDA-1978-N-0018-0658 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Opportunities and Risk of Nanotechnologies re: Citizen Petition from The International Center for Technology Assessment | Supporting & Related Material | Background Material | 2009-02-02T05:00:00Z | 2009 | 2 | 2019-07-31T18:16:52Z | 0 | 0 | 090000648055a928 |
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);