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

44 rows where docket_id = "FDA-2013-P-1612" and posted_year = 2014 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), comment_end_date (date), last_modified (date)

posted_year 1

  • 2014 · 44 ✖

document_type 1

  • Other 44

agency_id 1

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

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);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;
Powered by Datasette · Queries took 929.41ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API