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

9 rows where docket_id = "FDA-2013-N-0013" and posted_year = 2017 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, open_for_comment, posted_date (date), comment_start_date (date), last_modified (date)

document_type 4

  • Other 3
  • Supporting & Related Material 3
  • Rule 2
  • Notice 1

posted_year 1

  • 2017 · 9 ✖

agency_id 1

  • FDA 9
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-0013-0217 FDA None FDA-2013-N-0013 Sanitary Transportation of Human and Animal Food What You Need to Know Guidance SECG Other Guidance 2017-11-22T05:00:00Z 2017 11 2017-11-22T05:00:00Z   2024-11-07T01:11:59Z   1 0 0900006482c9fe31
FDA-2013-N-0013-0216 FDA None FDA-2013-N-0013 Sanitary Transportation of Human and Animal Food: What You Need to Know About the Food and Drug Administration Regulation; Small Entity Compliance Guide; Availability Notice Guidance 2017-11-22T05:00:00Z 2017 11 2017-11-22T05:00:00Z   2017-11-22T16:38:56Z 2017-25204 0 0 0900006482c9ec41
FDA-2013-N-0013-0215 FDA None FDA-2013-N-0013 Waivers From Requirements of the Sanitary Transportation of Human and Animal Food Rule; Correction Rule Correction 2017-07-03T04:00:00Z 2017 7 2017-07-03T04:00:00Z   2017-07-03T15:20:41Z 2017-13888 0 0 09000064827d5fd7
FDA-2013-N-0013-0214 FDA None FDA-2013-N-0013 Reference 1: Food and Drug Administration Center for Food Safety and Applied Nutrition Analysis of Comments Submitted to Docket FDA 2013-N-0013 Regarding Waivers from the Requirements of 21 CFR Part 1, Subpart O—Sanitary Transportation of Human and Animal Food, March 2017 re Waivers from Requirements of the Sanitary Transportation of Human and Animal Food Rule Supporting & Related Material Background Material 2017-04-06T04:00:00Z 2017 4     2017-04-06T14:42:59Z   0 0 090000648253f2b9
FDA-2013-N-0013-0213 FDA None FDA-2013-N-0013 Reference 2: “National Shellfish Sanitation Program (NSSP) Guide for the Control of Molluscan Shellfish 2015 Revision re Waivers From Requirements of the Sanitary Transportation of Human and Animal Food Rule Supporting & Related Material Background Material 2017-04-06T04:00:00Z 2017 4     2017-04-06T14:42:43Z   0 0 090000648253f102
FDA-2013-N-0013-0212 FDA None FDA-2013-N-0013 List of references - re Waivers From Requirements of the Sanitary Transportation of Human and Animal Food Rule Supporting & Related Material Background Material 2017-04-06T04:00:00Z 2017 4     2017-04-06T14:42:26Z   0 0 090000648253ecf9
FDA-2013-N-0013-0211 FDA None FDA-2013-N-0013 Waivers From Requirements of the Sanitary Transportation of Human and Animal Food Rule Rule Final Rule 2017-04-06T04:00:00Z 2017 4 2017-04-06T04:00:00Z   2017-04-06T12:56:42Z 2017-06854 0 0 090000648253e627
FDA-2013-N-0013-0209 FDA None FDA-2013-N-0013 Email Correspondence from School Nutrition Association (SNA) Other General Correspondence 2017-03-13T04:00:00Z 2017 3 2017-03-13T04:00:00Z   2017-03-13T19:44:35Z   0 0 09000064824ef365
FDA-2013-N-0013-0210 FDA None FDA-2013-N-0013 Letter from School Nutrition Association Other Letter(s) 2017-03-13T04:00:00Z 2017 3 2017-03-13T04:00:00Z   2017-03-13T19:44:54Z   0 0 09000064824ef366

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