documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
44 rows where docket_id = "FDA-2013-P-1612" and posted_year = 2014 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), 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-2013-P-1612-0128 | FDA | None FDA-2013-P-1612 | Letter from Joseph Vafi to FDA/CDER | Other | Letter(s) | 2014-10-16T04:00:00Z | 2014 | 10 | 2014-10-16T04:00:00Z | 2014-10-16T17:08:24Z | 0 | 0 | 090000648179a882 | ||
| FDA-2013-P-1612-0110 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Julie M. Jackle | Other | Letter(s) | 2014-07-31T04:00:00Z | 2014 | 7 | 2014-07-31T04:00:00Z | 2015-01-28T13:40:30Z | 0 | 0 | 09000064817f23e7 | ||
| FDA-2013-P-1612-0111 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Joseph Vafi | Other | Letter(s) | 2014-07-31T04:00:00Z | 2014 | 7 | 2014-07-31T04:00:00Z | 2014-10-02T11:46:25Z | 0 | 0 | 09000064817f23ea | ||
| FDA-2013-P-1612-0096 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to David B. Shirley, D. V. M. | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:37:40Z | 0 | 0 | 090000648172a23e | ||
| FDA-2013-P-1612-0105 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Claude M. McQuarrie, III | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:29:47Z | 0 | 0 | 090000648172a2aa | ||
| FDA-2013-P-1612-0108 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Richard Stricker | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:37:10Z | 0 | 0 | 0900006481729f86 | ||
| FDA-2013-P-1612-0107 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Robert Buchan | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:34:58Z | 0 | 0 | 0900006481729d8c | ||
| FDA-2013-P-1612-0100 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Gary Head and Parners Painting Corporation | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:13:47Z | 0 | 0 | 090000648172a246 | ||
| FDA-2013-P-1612-0093 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Carl D. Overton | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:31:23Z | 0 | 0 | 090000648172a1fd | ||
| FDA-2013-P-1612-0103 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Gary J. Kreider | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:25:24Z | 0 | 0 | 090000648172a2a6 | ||
| FDA-2013-P-1612-0088 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Michael L. Everts | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:17:38Z | 0 | 0 | 090000648172a1b8 | ||
| FDA-2013-P-1612-0095 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Robert J. Blumenthal, D. M. D. | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:35:42Z | 0 | 0 | 090000648172a201 | ||
| FDA-2013-P-1612-0090 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to U. S. I. Insurance Services | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:22:29Z | 0 | 0 | 090000648172a1bc | ||
| FDA-2013-P-1612-0104 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Julie Jackie | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:27:28Z | 0 | 0 | 090000648172a2a8 | ||
| FDA-2013-P-1612-0098 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to William Jenkins, M. D. | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:08:01Z | 0 | 0 | 090000648172a242 | ||
| FDA-2013-P-1612-0091 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Edith Hoechst | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:24:42Z | 0 | 0 | 090000648172a1f9 | ||
| FDA-2013-P-1612-0101 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Tom Hitchcock, R. D. | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:17:55Z | 0 | 0 | 090000648172a2a2 | ||
| FDA-2013-P-1612-0085 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Bruce Holland | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:09:28Z | 0 | 0 | 09000064817297da | ||
| FDA-2013-P-1612-0097 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Lee Wilson | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:00:20Z | 0 | 0 | 090000648172a240 | ||
| FDA-2013-P-1612-0087 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Thomas Ma, M. D., Ph. D. | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:15:20Z | 0 | 0 | 090000648172a1b6 | ||
| FDA-2013-P-1612-0086 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Lisa Hoechst | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:12:39Z | 0 | 0 | 09000064817297dc | ||
| FDA-2013-P-1612-0109 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Ralph Yung | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:39:13Z | 0 | 0 | 0900006481729f88 | ||
| FDA-2013-P-1612-0094 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Joseph Vafi | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:33:27Z | 0 | 0 | 090000648172a1ff | ||
| FDA-2013-P-1612-0089 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Lee Robertson | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:20:10Z | 0 | 0 | 090000648172a1ba | ||
| FDA-2013-P-1612-0092 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Interaction Design, Inc. | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-01T18:26:49Z | 0 | 0 | 090000648172a1fb | ||
| FDA-2013-P-1612-0106 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Jordan Silver | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:32:55Z | 0 | 0 | 090000648172a2d7 | ||
| FDA-2013-P-1612-0102 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Erik Sacher | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:22:51Z | 0 | 0 | 090000648172a2a4 | ||
| FDA-2013-P-1612-0099 | FDA | None FDA-2013-P-1612 | Letter from FDA/CDER to Allen Seto | Other | Letter(s) | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-10-02T11:10:54Z | 0 | 0 | 090000648172a244 | ||
| FDA-2013-P-1612-0075 | FDA | None FDA-2013-P-1612 | Citizen Petition from McQuarrie Law Office | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:38:42Z | 0 | 0 | 09000064815448b1 | |
| FDA-2013-P-1612-0078 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Noble Glasses | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T17:38:08Z | 0 | 0 | 09000064815457a3 | ||
| FDA-2013-P-1612-0070 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Erik Sacher | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T16:57:02Z | 0 | 0 | 0900006481503a8f | ||
| FDA-2013-P-1612-0076 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to McQuarrie Law Office | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T17:27:02Z | 0 | 0 | 090000648154579d | ||
| FDA-2013-P-1612-0072 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Gary J. Kreider | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T17:08:32Z | 0 | 0 | 0900006481503dd2 | ||
| FDA-2013-P-1612-0071 | FDA | None FDA-2013-P-1612 | Citizen Petition from Gary J. Kreider | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:36:59Z | 0 | 0 | 0900006481503a92 | |
| FDA-2013-P-1612-0082 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Richard Stricker | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T17:56:28Z | 0 | 0 | 09000064815457d4 | ||
| FDA-2013-P-1612-0077 | FDA | None FDA-2013-P-1612 | Citizen Petition from Noble Glasses | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:39:05Z | 0 | 0 | 09000064815457a0 | |
| FDA-2013-P-1612-0084 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Ralph Yung | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T18:06:31Z | 0 | 0 | 090000648154639e | ||
| FDA-2013-P-1612-0073 | FDA | None FDA-2013-P-1612 | Citizen Petition from Julie Jackle | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:37:26Z | 0 | 0 | 0900006481503dd5 | |
| FDA-2013-P-1612-0074 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Julie Jackle | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T17:17:32Z | 0 | 0 | 0900006481503e3e | ||
| FDA-2013-P-1612-0080 | FDA | None FDA-2013-P-1612 | Acknowledgement Letter from FDA/DDM to Robert Buchan | Other | Acknowledgement Letter/Receipt | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-10-01T17:47:58Z | 0 | 0 | 09000064815457bb | ||
| FDA-2013-P-1612-0079 | FDA | None FDA-2013-P-1612 | Citizen Petition from Robert Buchan | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:39:25Z | 0 | 0 | 09000064815457b8 | |
| FDA-2013-P-1612-0069 | FDA | None FDA-2013-P-1612 | Citizen Petition from Erik Sacher | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:35:48Z | 0 | 0 | 09000064814cae37 | |
| FDA-2013-P-1612-0081 | FDA | None FDA-2013-P-1612 | Citizen Petition from Richard Stricker | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:39:48Z | 0 | 0 | 09000064815457be | |
| FDA-2013-P-1612-0083 | FDA | None FDA-2013-P-1612 | Citizen Petition from Ralph Yung | Other | Citizen Petition | 2014-02-04T05:00:00Z | 2014 | 2 | 2014-02-04T05:00:00Z | 2014-08-05T03:59:59Z | 2015-09-23T13:40:11Z | 0 | 0 | 09000064815457d7 |
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;