home / openregs

documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

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

✎ View and edit SQL

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)

document_type 2

  • Other 26
  • Supporting & Related Material 6

posted_year 1

  • 2009 · 32 ✖

agency_id 1

  • FDA 32
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

CSV options:

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);
Powered by Datasette · Queries took 3366.524ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API