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

20 rows where docket_id = "FDA-2013-N-1425" and posted_year = 2014 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, subtype, posted_date, posted_month, comment_start_date, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

document_type 2

  • Other 18
  • Proposed Rule 2

posted_year 1

  • 2014 · 20 ✖

agency_id 1

  • FDA 20
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-N-1425-0145 FDA None FDA-2013-N-1425 Memorandum from Division of Biotechnology and GRAS Notice Review to FDA CFSAN Office of Foods and Veterinary Medicine re the Proposed Rule, Focused Mitigation Strategies to Protect Food Against Intentional Adulteration Other Memorandum 2014-12-18T05:00:00Z 2014 12 2014-12-18T05:00:00Z   2014-12-18T22:42:17Z   0 0 09000064819848ea
FDA-2013-N-1425-0099 FDA None FDA-2013-N-1425 Record of Outreach from FDA/OF 3/22/14 Other Record of Meeting/Phone Conversation 2014-08-04T04:00:00Z 2014 8 2014-08-04T04:00:00Z   2014-08-17T01:05:06Z   0 0 0900006481776214
FDA-2013-N-1425-0098 FDA None FDA-2013-N-1425 Record of Outreach from FDA/OF 4/22/14 Other Record of Meeting/Phone Conversation 2014-08-04T04:00:00Z 2014 8 2014-08-04T04:00:00Z   2016-10-31T15:04:52Z   0 0 0900006481776095
FDA-2013-N-1425-0044 FDA None FDA-2013-N-1425 Agenda from FDA/OF 5/13/14 Other Agenda 2014-07-31T04:00:00Z 2014 7 2014-07-31T04:00:00Z   2014-07-31T15:22:18Z   0 0 0900006481727d63
FDA-2013-N-1425-0060 FDA None FDA-2013-N-1425 Record of Outreach Sessions from FDA/OF 6/9/14 Other Record of Meeting/Phone Conversation 2014-07-31T04:00:00Z 2014 7 2014-07-31T04:00:00Z   2014-07-31T20:58:08Z   0 0 090000648176c01f
FDA-2013-N-1425-0035 FDA None FDA-2013-N-1425 Transcript/Agenda/Roster from FDA/OF 2/27/14 Other Transcript(s) 2014-07-30T04:00:00Z 2014 7 2014-07-30T04:00:00Z   2014-07-30T21:21:41Z   0 0 09000064816c03fb
FDA-2013-N-1425-0036 FDA None FDA-2013-N-1425 Transcript/Agenda/Roster from FDA/OF 3/13/14 Other Transcript(s) 2014-07-30T04:00:00Z 2014 7 2014-07-30T04:00:00Z   2014-07-30T21:24:46Z   0 0 09000064816c0579
FDA-2013-N-1425-0021 FDA None FDA-2013-N-1425 Focused Mitigation Strategies To Protect Food Against Intentional Adulteration; Extension of Comment Period Proposed Rule Extension of Comment Period 2014-03-25T04:00:00Z 2014 3 2014-03-25T04:00:00Z 2014-07-01T03:59:59Z 2014-08-05T01:01:57Z 2014-06468 0 0 090000648167c911
FDA-2013-N-1425-0016 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T17:26:21Z   0 0 090000648159e354
FDA-2013-N-1425-0014 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2013-12-24T05:00:00Z 2014-04-01T03:59:59Z 2014-02-28T02:01:50Z   0 0 090000648158d70e
FDA-2013-N-1425-0015 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T17:20:50Z   0 0 09000064815991d3
FDA-2013-N-1425-0010 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:29:07Z   0 0 090000648158d22b
FDA-2013-N-1425-0012 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:51:59Z   0 0 090000648158d4a9
FDA-2013-N-1425-0011 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:33:04Z   0 0 090000648158d4a7
FDA-2013-N-1425-0009 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:27:21Z   0 0 090000648158d227
FDA-2013-N-1425-0008 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:25:13Z   0 0 090000648158670c
FDA-2013-N-1425-0007 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:25:09Z   0 0 0900006481586699
FDA-2013-N-1425-0013 FDA None FDA-2013-N-1425 Record of Outreach Session from FDA/OF Other Record of Meeting/Phone Conversation 2014-02-25T05:00:00Z 2014 2 2014-02-25T05:00:00Z   2014-02-25T16:40:37Z   0 0 090000648158d4af
FDA-2013-N-1425-0006 FDA None FDA-2013-N-1425 Focused Mitigation Strategies To Protect Food Against Intentional Adulteration; Public Meetings on Proposed Rule Proposed Rule Public Meeting 2014-01-31T05:00:00Z 2014 1 2014-01-31T05:00:00Z   2014-01-31T15:11:58Z 2014-01985 0 0 0900006481539acd
FDA-2013-N-1425-0005 FDA None FDA-2013-N-1425 Memorandum from FDA Office of Policy to the Division of Dockets Management September 30 1993 Executive Order 12866 Regulatory Planning and Review re Focused Mitigation Strategies to Protect Food Against Intentional Adulteration Proposed Rule Other Memorandum 2014-01-03T05:00:00Z 2014 1 2014-01-03T05:00:00Z   2014-01-04T00:51:20Z   0 0 09000064814eb627

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 1051.185ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API