documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
25 rows where agency_id = "FDA", docket_id = "FDA-1978-N-0018" and posted_year = 1994 sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_date, posted_month, posted_date (date), 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-1978-N-0018-0135 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA CDER to Arlington Dermatology Clinic South | Other | Letter(s) | 1994-10-17T04:00:00Z | 1994 | 10 | 2019-07-22T16:53:28Z | 0 | 0 | 090000648055a1d7 | |||
| FDA-1978-N-0018-0133 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA CDER to Person & Covey, Inc. | Other | Letter(s) | 1994-09-15T04:00:00Z | 1994 | 9 | 2019-07-22T15:37:29Z | 0 | 0 | 090000648055a1c0 | |||
| FDA-1978-N-0018-0132 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Memorandum of Telephone Conversation between Arent, Fox, Kintner, Plotkin & Kahn and FDA/CDER, August 22, 1994 | Other | Memorandum | 1994-09-06T04:00:00Z | 1994 | 9 | 2019-08-02T14:52:14Z | 0 | 0 | 090000648055a19c | |||
| FDA-1978-N-0018-0130 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Internal Memorandum from Director Monograph Review Staff (HFD-810) to Dockets Management Branch (HFA-305) August 3, 1994 re: Comment from Canadian Dermatology Association | Supporting & Related Material | Comment(s) | 1994-08-08T04:00:00Z | 1994 | 8 | 2019-08-02T16:35:11Z | 0 | 0 | 090000648055a16d | |||
| FDA-1978-N-0018-0129 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Correction to Memorandum of Meeting between FDA/CDER, et al., and Givauden-Roure Corporation, et al., May 11, 1994 from FDA/CDER | Other | Correction(s) | 1994-07-28T04:00:00Z | 1994 | 7 | 2019-07-23T15:57:14Z | 0 | 0 | 090000648055a12c | |||
| FDA-1978-N-0018-0459 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Acknowledgment Letter from FDA/DDM to Arent Fox Kintner Plotkin & Kahn on behalf of Estee Lauder, Inc. | Other | Acknowledgement Letter/Receipt | 1994-07-28T04:00:00Z | 1994 | 7 | 2019-07-23T15:01:45Z | 0 | 0 | 090000648055a8b8 | |||
| FDA-1978-N-0018-0128 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to Ivy Laboratories | Other | Letter(s) | 1994-07-27T04:00:00Z | 1994 | 7 | 2019-07-22T18:55:33Z | 0 | 0 | 090000648055a126 | |||
| FDA-1978-N-0018-0127 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to Temple University Medical Practices | Other | Letter(s) | 1994-07-19T04:00:00Z | 1994 | 7 | 2019-07-22T18:26:46Z | 0 | 0 | 090000648055a11b | |||
| FDA-1978-N-0018-0125 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Memorandum of Meeting between FDA/CDER, et al., and Givauden-Roure Corporation, et al., May 11, 1994 | Other | Memorandum | 1994-07-07T04:00:00Z | 1994 | 7 | 2019-07-22T17:58:20Z | 0 | 0 | 090000648055a116 | |||
| FDA-1978-N-0018-0124 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA CDER to King & Spaulding | Other | Letter(s) | 1994-06-30T04:00:00Z | 1994 | 6 | 2019-07-29T18:43:55Z | 0 | 0 | 090000648055a10e | |||
| FDA-1978-N-0018-0123 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Memorandum of Meeting between FDA/CDER, Dr. Madhu Pathak, et al., and Givaudan-Roure Corporation, et al., May 12, 1994 | Other | Memorandum | 1994-06-30T04:00:00Z | 1994 | 6 | 2019-09-04T17:19:22Z | 0 | 0 | 090000648055a10b | |||
| FDA-1978-N-0018-0122 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Sunscreen Drug Products for Over-The-Counter Human Use; Proposed Amendment to the Tentative Final Monograph; Reopening of Comment Period | Notice | Notice of Extension | 1994-06-14T04:00:00Z | 1994 | 6 | 1994-06-14T04:00:00Z | 1994-08-23T03:59:59Z | 2019-07-19T19:49:02Z | 94-13933 | 0 | 0 | 090000648055a108 |
| FDA-1978-N-0018-0120 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to King & Spalding | Other | Letter(s) | 1994-05-12T04:00:00Z | 1994 | 5 | 2019-07-22T18:47:28Z | 0 | 0 | 090000648055a020 | |||
| FDA-1978-N-0018-0117 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Answer Letter from FDA/CDER to Dr. Beverly Summers | Other | Letter(s) | 1994-04-06T04:00:00Z | 1994 | 4 | 2019-07-22T12:23:19Z | 0 | 0 | 0900006480559fad | |||
| FDA-1978-N-0018-0119 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Answer Letter from FDA/CDER to Nicholas J. Lowe | Other | Letter(s) | 1994-04-06T04:00:00Z | 1994 | 4 | 2019-07-22T12:32:57Z | 0 | 0 | 0900006480559fd3 | |||
| FDA-1978-N-0018-0118 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Answer Letter from FDA/CDER to James L. Boren | Other | Letter(s) | 1994-04-06T04:00:00Z | 1994 | 4 | 2019-07-22T12:28:04Z | 0 | 0 | 0900006480559fb4 | |||
| FDA-1978-N-0018-0116 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to Morgan, Lewis & Bockius | Other | Letter(s) | 1994-02-28T05:00:00Z | 1994 | 2 | 2019-07-26T11:46:52Z | 0 | 0 | 0900006480559ec3 | |||
| FDA-1978-N-0018-0465 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Answer Letter from FDA/Associate Commissioner for Legislative Affairs to Comment from the Honorable Congressman Bob Clement | Other | Answer | 1994-02-24T05:00:00Z | 1994 | 2 | 2019-07-19T11:59:16Z | 0 | 0 | 090000648055a8c9 | |||
| FDA-1978-N-0018-0466 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Answer Letter from FDA/Associate Commissioner for Legislative Affairs to Comment from the Honorable Senator Harlan Mathews | Other | Answer | 1994-02-24T05:00:00Z | 1994 | 2 | 2019-07-19T12:09:07Z | 0 | 0 | 090000648055a8cd | |||
| FDA-1978-N-0018-0111 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to The Proctor & Gamble Company | Other | Letter(s) | 1994-02-17T05:00:00Z | 1994 | 2 | 2019-07-26T11:53:00Z | 0 | 0 | 0900006480559e6e | |||
| FDA-1978-N-0018-0108 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to The Proctor & Gamble Company | Other | Letter(s) | 1994-01-26T05:00:00Z | 1994 | 1 | 2019-08-05T12:27:33Z | 0 | 0 | 0900006480559e05 | |||
| FDA-1978-N-0018-0109 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to Nonprescription Drug Manufacturers Association | Other | Letter(s) | 1994-01-26T05:00:00Z | 1994 | 1 | 2019-08-05T12:25:05Z | 0 | 0 | 0900006480559e09 | |||
| FDA-1978-N-0018-0110 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from FDA/CDER to The Cosmetic, Toiletry & Fragrance Association | Other | Letter(s) | 1994-01-26T05:00:00Z | 1994 | 1 | 2019-08-05T12:21:30Z | 0 | 0 | 0900006480559e0c | |||
| FDA-1978-N-0018-0107 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Letter from SunSmart Inc. to FDA/CDER | Other | Letter(s) | 1994-01-10T05:00:00Z | 1994 | 1 | 2019-08-05T12:48:55Z | 0 | 0 | 0900006480559dfc | |||
| FDA-1978-N-0018-0106 | FDA | Sunscreen Drug Products -OPEN FDA-1978-N-0018 | Memorandum of Meeting between FDA/CDER and Cosmetic, Toiletry, and Fragrance Association October 21 1993 | Other | Memorandum | 1994-01-10T05:00:00Z | 1994 | 1 | 2019-08-05T12:57:30Z | 0 | 0 | 0900006480559df7 |
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;