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

57 rows where docket_id = "FDA-2011-N-0920" 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 · 57 ✖

agency_id 1

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-2011-N-0920-1938 FDA None FDA-2011-N-0920 Supplement from the California Dried Plum Board Other Supplement (SUP) 2014-12-30T05:00:00Z 2014 12 2014-12-30T05:00:00Z   2014-12-30T15:48:53Z   0 0 090000648197c7db
FDA-2011-N-0920-1816 FDA None FDA-2011-N-0920 Comment from Dale Moore, American Farm Bureau Federation Other Supplemental Comment 2014-12-18T05:00:00Z 2014 12 2014-12-18T05:00:00Z   2014-12-18T21:52:49Z   0 0 090000648197703a
FDA-2011-N-0920-1648 FDA None FDA-2011-N-0920 Request for Extension from the Western Colorado Congress Other Request for Extension 2014-12-02T05:00:00Z 2014 12 2014-12-02T05:00:00Z   2014-12-02T17:19:19Z   0 0 09000064819550e6
FDA-2011-N-0920-1647 FDA None FDA-2011-N-0920 FDA Response Letter Denying Comment Period Extension Request November 17, 2014 Other Letter(s) 2014-11-20T05:00:00Z 2014 11 2014-11-20T05:00:00Z   2014-11-20T20:48:03Z   0 0 090000648193b624
FDA-2011-N-0920-1600 FDA None FDA-2011-N-0920 Records of Outreach Sessions Conducted in Support of Proposed Rules Pertaining to FDA Food Safety Modernization Act re Association of Health Care Journalist (AHCJ) Conference March 16, 2013 Other Forms 2014-10-30T04:00:00Z 2014 10 2014-10-30T04:00:00Z   2014-10-30T22:11:02Z   0 0 09000064819080d4
FDA-2011-N-0920-1602 FDA None FDA-2011-N-0920 Records of Outreach Sessions Conducted in Support of Proposed Rules Pertaining to Subpart L of Proposed Rule re Produce Safety Alliance May 8, 2013 Other Forms 2014-10-30T04:00:00Z 2014 10 2014-10-30T04:00:00Z   2014-10-30T22:13:53Z   0 0 0900006481907adf
FDA-2011-N-0920-1599 FDA None FDA-2011-N-0920 Records of Outreach Sessions Conducted in Support of Proposed Rules Pertaining to FDA Food Safety Modernization Act re AFFI Convention PSS, PCHF, and Impact on Global Trade Conference February 23, 2013 Other Forms 2014-10-30T04:00:00Z 2014 10 2014-10-30T04:00:00Z   2014-10-30T22:10:01Z   0 0 09000064819080d3
FDA-2011-N-0920-1603 FDA None FDA-2011-N-0920 Records of Outreach Sessions Conducted in Support of Proposed Rules Pertaining to PC Human Food re International Association for Food Protection July 30, 2013 Other Forms 2014-10-30T04:00:00Z 2014 10 2014-10-30T04:00:00Z   2014-10-30T22:14:47Z   0 0 0900006481907ae0
FDA-2011-N-0920-1601 FDA None FDA-2011-N-0920 Records of Outreach Sessions Conducted in Support of Proposed Rules Pertaining to FDA Food Safety Modernization Act General Overview re Food Sanitation Council Orange County March 27, 2013 Other Forms 2014-10-30T04:00:00Z 2014 10 2014-10-30T04:00:00Z   2014-10-30T22:11:55Z   0 0 0900006481907ade
FDA-2011-N-0920-1604 FDA None FDA-2011-N-0920 Records of Outreach Sessions Conducted in Support of Proposed Rules Pertaining to FDA Food Safety Modernization Act Overview re Missouri Columbia Boone County Public Health and Human Services September 24, 2013 Other Forms 2014-10-30T04:00:00Z 2014 10 2014-10-30T04:00:00Z   2014-10-30T22:15:32Z   0 0 0900006481907ae1
FDA-2011-N-0920-1585 FDA None FDA-2011-N-0920 Food and Drug Administration Food Safety Modernization Act: Meetings on Rule Revisions Proposed Rule Public Meeting 2014-10-23T04:00:00Z 2014 10 2014-10-23T04:00:00Z   2014-10-23T16:21:59Z 2014-25261 0 0 09000064818f6c1c
FDA-2011-N-0920-1578 FDA None FDA-2011-N-0920 OMB Executive Order 12866 Regulatory Planning and Review re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Other Memorandum 2014-10-16T04:00:00Z 2014 10 2014-10-16T04:00:00Z   2014-10-16T22:41:52Z   0 0 09000064818cb441
FDA-2011-N-0920-1583 FDA None FDA-2011-N-0920 Tab C Final Regulatory Action as Cleared by OIRA, and a Final Version of the Materials Required by the Executive Order (Supp NPRM) OMB Executive Order 12866 Regulatory Planning and Review re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Supporting & Related Material Background Material 2014-10-16T04:00:00Z 2014 10     2014-10-16T22:36:02Z   0 0 09000064818cb4c6
FDA-2011-N-0920-1584 FDA None FDA-2011-N-0920 Tab C Final Regulatory Action as Cleared by OIRA, and a Final Version of the Materials Required by the Executive Order (Supp PRIA) OMB Executive Order 12866 Regulatory Planning and Review re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Supporting & Related Material Background Material 2014-10-16T04:00:00Z 2014 10     2014-10-16T22:39:14Z   0 0 09000064818cb4c7
FDA-2011-N-0920-1579 FDA None FDA-2011-N-0920 Tab A Draft Regulatory Action as Submitted to OMB (Supp NPRM) OMB Executive Order 12866 Regulatory Planning and Review re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Supporting & Related Material Background Material 2014-10-16T04:00:00Z 2014 10     2014-10-16T22:14:24Z   0 0 09000064818cb443
FDA-2011-N-0920-1581 FDA None FDA-2011-N-0920 Tab B Substantive Changes Between Draft for Review and Regulatory Action (Supp NPRM) re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Supporting & Related Material Background Material 2014-10-16T04:00:00Z 2014 10     2014-10-16T22:26:48Z   0 0 09000064818cb4c4
FDA-2011-N-0920-1582 FDA None FDA-2011-N-0920 Tab B Substantive Changes Between Draft for Review and Regulatory Action (Supp PRIA) OMB Executive Order 12866 Regulatory Planning and Review re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Supporting & Related Material Background Material 2014-10-16T04:00:00Z 2014 10     2014-10-16T22:30:18Z   0 0 09000064818cb4c5
FDA-2011-N-0920-1580 FDA None FDA-2011-N-0920 Tab A Draft Regulatory Action as Submitted to OMB (Supp PRIA) OMB Executive Order 12866 Regulatory Planning and Review re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food (Supplemental Proposed Rule); Publication Date: September 29, 2014 Supporting & Related Material Background Material 2014-10-16T04:00:00Z 2014 10     2014-10-16T22:24:34Z   0 0 09000064818cb444
FDA-2011-N-0920-1563 FDA None FDA-2011-N-0920 Reference 23 FDA Memorandum, “Environmental Monitoring,” 2014 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:37:43Z   0 0 09000064818998fc
FDA-2011-N-0920-1566 FDA None FDA-2011-N-0920 Reference 26 FDA, "FSMA Supplemental Notice of Proposed Rulemaking for Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food" re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:51:47Z   0 0 09000064818998ff
FDA-2011-N-0920-1556 FDA None FDA-2011-N-0920 Reference 9 Taylor, M., “Your Input Is Bringing Change to Food Safety Rules,” December 19, 2013 re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:18Z   0 0 09000064818998f5
FDA-2011-N-0920-1565 FDA None FDA-2011-N-0920 Reference 25 U.S.Pharmacopeial Convention, “U.S. Pharmacopeial Convention (USP) Food Fraud Database,” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:15:26Z   0 0 09000064818998fe
FDA-2011-N-0920-1576 FDA None FDA-2011-N-0920 PRIA -Reference 7 Arbro Analytical Division. Testing Rates. Melamine Testing re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:13:13Z   0 0 090000648189987f
FDA-2011-N-0920-1555 FDA None FDA-2011-N-0920 Reference 8 Taylor, M., “Statement From FDA Deputy Commissioner for Foods and Veterinary Medicine, Michael Taylor, on Key Provisions of the Proposed FSMA Rules Affecting Farmers,” re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:12Z   0 0 09000064818998f4
FDA-2011-N-0920-1560 FDA None FDA-2011-N-0920 Reference 15 Stored Product Management re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:46Z   0 0 09000064818998f9
FDA-2011-N-0920-1570 FDA None FDA-2011-N-0920 Reference 31 U.K. Food Standards Agency, “Sudan I Timeline,” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:39:49Z   0 0 0900006481899d03
FDA-2011-N-0920-1577 FDA None FDA-2011-N-0920 Supp Notice Additional Info_PC Human Food Regulatory Text REDLINE re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:34:27Z   0 0 090000648189987e
FDA-2011-N-0920-1554 FDA None FDA-2011-N-0920 Reference List - Supplemental Notice of Proposed Rulemaking re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-06T14:07:25Z   0 0 0900006481899d08
FDA-2011-N-0920-1557 FDA None FDA-2011-N-0920 Reference 10 FDA, “Guidance for Industry: Questions and Answers Regarding Food Facility Registration (Fifth Edition),” 2012 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:25Z   0 0 09000064818998f6
FDA-2011-N-0920-1569 FDA None FDA-2011-N-0920 Reference 30 International Agency for Research on Cancer, “Agents Classified by the IARC Monographs, Volumes 1-109,” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:16:02Z   0 0 0900006481899d02
FDA-2011-N-0920-1575 FDA None FDA-2011-N-0920 PRIA -Reference 5 Gluten Testing_ELISA Technologies Inc re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:12:59Z   0 0 0900006481899d0c
FDA-2011-N-0920-1571 FDA None FDA-2011-N-0920 Reference 32 Congressional Research Service, “Food Fraud and “Economically Motivated Adulteration” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:16:17Z   0 0 0900006481899d04
FDA-2011-N-0920-1572 FDA None FDA-2011-N-0920 Reference 33 Everstine, K., J. Spink, et al, “Economically Motivated Adulteration (EMA) of Food: Common Characteristics of EMA Incidents,” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:40:16Z   0 0 0900006481899d05
FDA-2011-N-0920-1561 FDA None FDA-2011-N-0920 Reference 18 FDA Memorandum, “Product Testing,” 2014 re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:52Z   0 0 09000064818998fa
FDA-2011-N-0920-1553 FDA None FDA-2011-N-0920 Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Proposed Rule Supplemental Notice of Proposed Rulemaking (SNPRM) 2014-09-29T04:00:00Z 2014 9 2014-09-29T04:00:00Z 2014-12-16T04:59:59Z 2015-10-07T15:36:24Z 2014-22446 0 0 0900006481898a79
FDA-2011-N-0920-1573 FDA None FDA-2011-N-0920 Reference 35 FDA Memorandum, “Re-proposal of select provisions of the Proposed Rule: Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food,” 2014 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:16:33Z   0 0 0900006481899d06
FDA-2011-N-0920-1558 FDA None FDA-2011-N-0920 Reference 11 FDA, “Guidance for Industry: What You Need to Know About Registration of Food Facilities; Small Entity Compliance Guide,” 2012 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:33Z   0 0 09000064818998f7
FDA-2011-N-0920-1568 FDA None FDA-2011-N-0920 Reference 29 LEAD Action News, “Adulteration of Paprika in Hungary,” re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:39:19Z   0 0 0900006481899d01
FDA-2011-N-0920-1562 FDA None FDA-2011-N-0920 Reference 22 CAC “Code of Hygienic Practice for Powdered Formulae for Infants and Young Children, CAC/RCP 66-2008,” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:58Z   0 0 09000064818998fb
FDA-2011-N-0920-1559 FDA None FDA-2011-N-0920 Reference 13 FDA, “What You Need to Know About Establishment and Maintenance of Records,” 2014 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:14:40Z   0 0 09000064818998f8
FDA-2011-N-0920-1564 FDA None FDA-2011-N-0920 Reference 24 FDA Memorandum, “Supplier Program,” 2014 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-10-05T19:34:53Z   0 0 09000064818998fd
FDA-2011-N-0920-1567 FDA None FDA-2011-N-0920 Reference 28 FDA, “Best Value, Inc., Recalls PRAN Bran[d] Turmeric Powder Due to Elevated Levels of Lead,” re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:15:47Z   0 0 0900006481899d00
FDA-2011-N-0920-1574 FDA None FDA-2011-N-0920 Reference 36 FDA Memorandum, “Modernization of food current Good Manufacturing Practices (cGMP) as required by the Food Safety Modernization Act of 2011,” 2011 re re Current Good Manufacturing Practice and Hazard Analysis and Risk-Based Preventive Controls for Human Food Supporting & Related Material Background Material 2014-09-29T04:00:00Z 2014 9     2014-09-29T19:16:42Z   0 0 0900006481899d07
FDA-2011-N-0920-1520 FDA None FDA-2011-N-0920 See Document ID FDA-2011-N-0920-re Comment from American Herbal Products Association (AHPA) Supporting & Related Material Background Material 2014-06-17T04:00:00Z 2014 6     2014-06-17T22:30:35Z   0 0 09000064816b4c41
FDA-2011-N-0920-1313 FDA None FDA-2011-N-0920 Record of Outreach Session from FDA/CFSAN Other Record of Meeting/Phone Conversation 2014-02-28T05:00:00Z 2014 2 2014-02-28T05:00:00Z   2014-02-28T15:00:15Z   0 0 0900006481492e2e
FDA-2011-N-0920-1314 FDA None FDA-2011-N-0920 Record of Outreach Session from FDA/CFSAN Other Record of Meeting/Phone Conversation 2014-02-28T05:00:00Z 2014 2 2014-02-28T05:00:00Z   2014-02-28T15:13:11Z   0 0 0900006481492e42
FDA-2011-N-0920-1309 FDA None FDA-2011-N-0920 Record of Outreach Session from FDA/CFSAN Other Record of Meeting/Phone Conversation 2014-02-27T05:00:00Z 2014 2 2014-02-27T05:00:00Z   2014-09-08T10:44:49Z   0 0 0900006481492dee
FDA-2011-N-0920-1301 FDA None FDA-2011-N-0920 Record of Outreach Session from FDA/CFSAN Other Record of Meeting/Phone Conversation 2014-02-27T05:00:00Z 2014 2 2014-02-27T05:00:00Z   2014-02-27T18:16:08Z   0 0 0900006481492c88
FDA-2011-N-0920-1292 FDA None FDA-2011-N-0920 Record of Outreach Session from FDA/CFSAN Other Record of Meeting/Phone Conversation 2014-02-27T05:00:00Z 2014 2 2014-02-27T05:00:00Z   2014-02-27T17:54:43Z   0 0 0900006481492bcb
FDA-2011-N-0920-1264 FDA None FDA-2011-N-0920 Transcript from Public Meeting FSMA Proposed Rules on Produce Safety and Preventive Controls for Human Food Facilities February 28 Day Other Transcript(s) 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:38:45Z   0 0 09000064815c93ee
FDA-2011-N-0920-1266 FDA None FDA-2011-N-0920 Agenda from Public Meeting FSMA Proposed Rules on Produce Safety and Preventive Controls for Human Food Facilities March 11 - 12, 2013 Other Agenda 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:21:40Z   0 0 09000064815c93ef
FDA-2011-N-0920-1271 FDA None FDA-2011-N-0920 Transcript from Public Meeting FSMA Proposed Rules on Produce Safety and Preventive Controls for Human Food Facilities March 27 2013 Day Other Transcript(s) 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:45:37Z   0 0 09000064815c9593
FDA-2011-N-0920-1260 FDA None FDA-2011-N-0920 Agenda from FDA Foods Program Public Meeting FDA Food Safety Modernization Act Focus on Preventive Controls For Facilities April 20 2011 Other Agenda 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:20:25Z   0 0 09000064815c93eb
FDA-2011-N-0920-1261 FDA None FDA-2011-N-0920 Transcript from FDA Foods Program Public Meeting FDA Food Safety Modernization Act Focus on Preventive Controls For Facilities April 20 2011 Other Transcript(s) 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:07:46Z   0 0 09000064815c93ec
FDA-2011-N-0920-1263 FDA None FDA-2011-N-0920 Agenda from Public Meeting FSMA Proposed Rules on Produce Safety and Preventive Controls for Human Food Facilities February 28 March 1 2013 Other Agenda 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:38:33Z   0 0 09000064815c93ed
FDA-2011-N-0920-1269 FDA None FDA-2011-N-0920 Transcript from Public Meeting FSMA Proposed Rules on Produce Safety and Preventive Controls for Human Food Facilities March 11, 2013 Day Other Transcript(s) 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:39:02Z   0 0 09000064815c93f0
FDA-2011-N-0920-1270 FDA None FDA-2011-N-0920 Agenda from Public Meeting FSMA Proposed Rules on Produce Safety and Preventive Controls for Human Food Facilities March 27 - 28, 2013 Other Agenda 2014-02-26T05:00:00Z 2014 2 2014-02-26T05:00:00Z   2014-02-26T21:22:18Z   0 0 09000064815c93f1

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;