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

50 rows where docket_id = "FDA-2011-F-0171" 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), comment_end_date (date), last_modified (date)

posted_year 6

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-F-0171-0421 FDA None FDA-2011-F-0171 Food Labeling: Calorie Labeling of Articles of Food Sold From Certain Vending Machines; Front of Package Type Size Rule Final Rule 2019-10-28T04:00:00Z 2019 10 2019-10-28T04:00:00Z   2019-10-28T12:36:01Z 2019-23276 0 0 09000064840fee46
FDA-2011-F-0171-0291 FDA None FDA-2011-F-0171 Food Labeling: Calorie Labeling of Articles of Food Sold From Certain Vending Machines; Front of Package Type Size Proposed Rule Notice of Proposed Rulemaking (NPRM) 2018-07-12T04:00:00Z 2018 7 2018-07-12T04:00:00Z 2018-09-26T03:59:59Z 2018-09-26T01:04:47Z 2018-14906 0 0 09000064834d7dd7
FDA-2011-F-0171-0283 FDA None FDA-2011-F-0171 Calorie Labeling of Articles of Food in Vending Machines: Guidance for Industry; Draft Guidance Other Guidance 2016-08-16T04:00:00Z 2016 8 2016-08-16T04:00:00Z   2024-11-12T06:12:05Z   1 0 090000648217ac1b
FDA-2011-F-0171-0280 FDA None FDA-2011-F-0171 Calorie Labeling of Articles of Food in Vending Machines: Guidance for Industry; Small Entity Compliance Guide; Availability Notice Notice of Availability 2016-08-16T04:00:00Z 2016 8 2016-08-16T04:00:00Z   2016-08-16T17:46:27Z 2016-19492 0 0 0900006482178a99
FDA-2011-F-0171-0281 FDA None FDA-2011-F-0171 Calorie Labeling of Articles of Food in Vending Machines; Draft Guidance for Industry; Availability Notice Notice of Availability 2016-08-16T04:00:00Z 2016 8 2016-08-16T04:00:00Z 2016-10-01T03:59:59Z 2016-10-01T01:01:49Z 2016-19493 0 0 0900006482178bd6
FDA-2011-F-0171-0282 FDA None FDA-2011-F-0171 Guidance for Industry Calorie Labeling of Articles of Food in Vending Machines - Small Entity Compliance Guide Other Guidance 2016-08-16T04:00:00Z 2016 8 2016-08-16T04:00:00Z   2024-11-12T06:13:05Z   1 0 090000648217a73b
FDA-2011-F-0171-0279 FDA None FDA-2011-F-0171 Reference 3 - FDA FRIA July 2016 FINAL re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Extension of Compliance Date Supporting & Related Material Background Material 2016-08-02T04:00:00Z 2016 8     2016-08-02T13:43:36Z   0 0 090000648214c3fa
FDA-2011-F-0171-0276 FDA None FDA-2011-F-0171 Reference 1 - Letter from Karin F. R. Moore from GMA March 2016 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Extension of Compliance Date Supporting & Related Material Background Material 2016-08-02T04:00:00Z 2016 8     2016-08-02T13:42:27Z   0 0 090000648214c3f7
FDA-2011-F-0171-0278 FDA None FDA-2011-F-0171 Reference 2a - Attachment to Letter from Karin Moore of GMA June 2016 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Extension of Compliance Date Supporting & Related Material Background Material 2016-08-02T04:00:00Z 2016 8     2016-08-02T13:42:06Z   0 0 090000648214c3f9
FDA-2011-F-0171-0277 FDA None FDA-2011-F-0171 Reference 2 - Letter from Karin Moore of GMA June 2016 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Extension of Compliance Date Supporting & Related Material Background Material 2016-08-02T04:00:00Z 2016 8     2016-08-02T13:42:17Z   0 0 090000648214c3f8
FDA-2011-F-0171-0275 FDA None FDA-2011-F-0171 Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Extension of Compliance Date Rule Final Rule 2016-08-01T04:00:00Z 2016 8 2016-08-01T04:00:00Z   2016-08-01T15:28:34Z 2016-18140 0 0 0900006482145644
FDA-2011-F-0171-0256 FDA None FDA-2011-F-0171 Agency Information Collection Activities; Announcement of Office of Management and Budget Approval; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Notice Notice of Approval 2015-03-31T04:00:00Z 2015 3 2015-03-31T04:00:00Z   2015-03-31T14:21:37Z 2015-07265 0 0 0900006481a7c9c4
FDA-2011-F-0171-0251 FDA None FDA-2011-F-0171 FDA/OC/OP to Division of Dockets Management - OMB Review, Executive Order 12866, Food Labeling; Calorie Labeling of Articles of Food in Vending Machines, Proposed Rule Published 4/6/2011 - Memorandum Other OMB Review 2015-02-20T05:00:00Z 2015 2 2015-02-20T05:00:00Z   2015-02-20T19:03:35Z   0 0 0900006480fac182
FDA-2011-F-0171-0207 FDA None FDA-2011-F-0171 Tab C Final Rule Impact Analysis, Final Regulatory Action as Cleared by OIRA re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Supporting & Related Material Background Material 2014-12-12T05:00:00Z 2014 12     2014-12-13T00:58:13Z   0 0 0900006481973980
FDA-2011-F-0171-0203 FDA None FDA-2011-F-0171 Tab B Substantive Changes Between the Draft Submitted to OIRA for Review and the Regulatory Action Subsequently Cleared by OIRA re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Supporting & Related Material Background Material 2014-12-12T05:00:00Z 2014 12     2014-12-13T00:56:32Z   0 0 090000648197397c
FDA-2011-F-0171-0204 FDA None FDA-2011-F-0171 Tab C Final Regulatory Action as Cleared by OIRA re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Supporting & Related Material Background Material 2014-12-12T05:00:00Z 2014 12     2014-12-13T00:56:59Z   0 0 090000648197397d
FDA-2011-F-0171-0206 FDA None FDA-2011-F-0171 Tab B Final Rule Impact Analysis (FRIA) Substantive Changes Between the Draft Submitted to OIRA for Review and the Regulatory Action Subsequently Cleared by OIRA re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Supporting & Related Material Background Material 2014-12-12T05:00:00Z 2014 12     2014-12-15T18:20:57Z   0 0 090000648197397f
FDA-2011-F-0171-0202 FDA None FDA-2011-F-0171 Tab A Draft Regulatory Action as Submitted to the Office of Management and Budget's (OMB) Office of Information and Regulatory Affairs (OIRA) for review re OMB Executive Order 12866 Regulatory Planning and Review re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Supporting & Related Material Background Material 2014-12-12T05:00:00Z 2014 12     2014-12-13T00:56:15Z   0 0 090000648197397b
FDA-2011-F-0171-0205 FDA None FDA-2011-F-0171 Tab A Final Rule Impact Analysis (FRIA), Draft Regulatory Action as Submitted to the Office of Management and Budget's (OMB) Office of Information and Regulatory Affairs (OIRA) for review re OMB Executive Order 12866 Regulatory Planning and Review re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Supporting & Related Material Background Material 2014-12-12T05:00:00Z 2014 12     2014-12-13T00:57:27Z   0 0 090000648197397e
FDA-2011-F-0171-0201 FDA None FDA-2011-F-0171 OMB Executive Order 12866 Regulatory Planning and Review reFood Labeling; Calorie Labeling of Articles of Food in Vending Machines (Final Rule); Publication Date: December 1, 2014 Other OMB Review 2014-12-12T05:00:00Z 2014 12 2014-12-12T05:00:00Z   2015-02-20T19:05:24Z   0 0 0900006481974018
FDA-2011-F-0171-0200 FDA None FDA-2011-F-0171 Reference - 6 “2012 Census of the Industry,” Vending Times, 2012; 52(12) re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:34:37Z   0 0 0900006481951d17
FDA-2011-F-0171-0194 FDA None FDA-2011-F-0171 Reference 2- FDA/CFSAN, “Food Labeling: Calorie Labeling of Articles of Food in Vending Machines NPRM, Preliminary Regulatory Impact Analysis,” re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:32:33Z   0 0 09000064819516e5
FDA-2011-F-0171-0196 FDA None FDA-2011-F-0171 Reference 4 - Memo to File. Correspondence with Eric Dell of the National Automatic Merchandising Association. April 13, 2013 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:33:01Z   0 0 09000064819516e7
FDA-2011-F-0171-0193 FDA None FDA-2011-F-0171 Reference 1- FDA/CFSAN, “Food Labeling: Calorie Labeling of Articles of Food in Vending Machines, Regulatory Impact Analysis,” 2014 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:32:20Z   0 0 09000064819516e4
FDA-2011-F-0171-0198 FDA None FDA-2011-F-0171 Reference 7- "2012 State of the Vending Industry Report, 2013,” Automatic Merchandiser re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:34:01Z   0 0 0900006481951d18
FDA-2011-F-0171-0199 FDA None FDA-2011-F-0171 Reference 8 - National Automatic Merchandising Association. Comments of: The National Automatic Merchandising Association. Docket No. FDA-2010-N-0298. 2010 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:34:08Z   0 0 0900006481951d19
FDA-2011-F-0171-0197 FDA None FDA-2011-F-0171 Reference 5 - Eastern Research Group I. “Evaluation of Recordkeeping Costs for Food Manufacturers, Final Report” re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:33:25Z   0 0 09000064819516e8
FDA-2011-F-0171-0192 FDA None FDA-2011-F-0171 List of References re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:32:01Z   0 0 09000064819516e3
FDA-2011-F-0171-0191 FDA None FDA-2011-F-0171 Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Rule Final Rule 2014-12-01T05:00:00Z 2014 12 2014-12-01T05:00:00Z 2015-01-01T04:59:59Z 2015-03-03T03:02:03Z 2014-27834 0 0 090000648194f380
FDA-2011-F-0171-0195 FDA None FDA-2011-F-0171 Reference 3 - Memo to File. Correspondence with Eric Dell of the National Automatic Merchandising Association. April 10, 2013 re Food Labeling; Calorie Labeling of Articles of Food in Vending Machines Supporting & Related Material Background Material 2014-12-01T05:00:00Z 2014 12     2014-12-01T16:32:48Z   0 0 09000064819516e6
FDA-2011-F-0171-0113 FDA None FDA-2011-F-0171 Food Labeling: Calorie Labeling of Articles of Food in Vending Machines; Correction Proposed Rule Notice of Proposed Rulemaking (NPRM) 2011-06-27T04:00:00Z 2011 6 2011-06-27T04:00:00Z   2015-02-20T20:10:55Z 2011-15983 0 0 0900006480eb4100
FDA-2011-F-0171-0011 FDA None FDA-2011-F-0171 Reference List - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:00Z   0 0 0900006480c19ccc
FDA-2011-F-0171-0020 FDA None FDA-2011-F-0171 Reference 39 - "U.S. Census Bureau, Statistical Abstract of the United States: 2011" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:04Z   0 0 0900006480c1a0ec
FDA-2011-F-0171-0001 FDA None FDA-2011-F-0171 Food Labeling: Calorie Labeling of Articles of Food in Vending Machines Proposed Rule NPR-Notice of Proposed Rule-Making 2011-04-06T04:00:00Z 2011 4 2011-04-06T04:00:00Z 2011-07-06T03:59:59Z 2011-06-11T16:30:00Z 2011-08037 0 0 0900006480c1cfbc
FDA-2011-F-0171-0005 FDA None FDA-2011-F-0171 Reference 2 - "Food and Drug Administration, Food Labeling Guide" - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-04-06T14:40:22Z   0 0 0900006480c19867
FDA-2011-F-0171-0003 FDA None FDA-2011-F-0171 Reference List - "Vending Machine Labeling" - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:01Z   0 0 0900006480c19865
FDA-2011-F-0171-0009 FDA None FDA-2011-F-0171 Reference 28 - "Eastern Research Group, Inc., Evaluation of Recordkeeping Costs for Food Manufacturers, Final Report” " - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:03Z   0 0 0900006480c19881
FDA-2011-F-0171-0010 FDA None FDA-2011-F-0171 Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001 Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:04Z   0 0 0900006480c19ccb
FDA-2011-F-0171-0013 FDA None FDA-2011-F-0171 Reference 3 - "U.S. Small Business Administration, Table of Small Business Size Standards Matched to North American Industry Classification System Codes,” Effective November 5, 2010" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:01Z   0 0 0900006480c1a0c8
FDA-2011-F-0171-0015 FDA None FDA-2011-F-0171 Reference 25 - "U.S. Department of Agriculture Economic Research Service., Table 15: Sales of Meals and Snacks Away From Home by Type of Outlet, Food CPI and Expenditures: Food Expenditure Tables" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:03Z   0 0 0900006480c1a0de
FDA-2011-F-0171-0016 FDA None FDA-2011-F-0171 Reference 26 - "RL Food Testing Laboratory, Quality Nutrition Analysis" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:03Z   0 0 0900006480c1a0df
FDA-2011-F-0171-0018 FDA None FDA-2011-F-0171 Reference 29 - "Eastern Research Group, Inc., Evaluation of Recordkeeping Costs for Food Manufacturers, Final Report" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:04Z   0 0 0900006480c1a0e2
FDA-2011-F-0171-0004 FDA None FDA-2011-F-0171 Reference 1 - "Merriam Webster Collegiate Dictionary, Tenth Edition, 1993" - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-04-06T14:40:20Z   0 0 0900006480c19866
FDA-2011-F-0171-0008 FDA None FDA-2011-F-0171 Reference 27 - "U.S. Department of Agriculture Economic Research Service, Table 15: Sales of Meals and Snacks Away From Home by Type of Outlet, Food CPI and Expenditures: Food Expenditure Tables" - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-04-06T14:40:27Z   0 0 0900006480c19880
FDA-2011-F-0171-0006 FDA None FDA-2011-F-0171 Reference 5 - "U.S. Small Business Administration, Table of Small Business Size Standards Matched to North American Industry Classification System Codes, Effective November 5, 2010" - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-04-06T14:40:24Z   0 0 0900006480c1986a
FDA-2011-F-0171-0012 FDA None FDA-2011-F-0171 Reference 1 - "Automatic Merchandiser, 2010 State of the Vending Industry Report" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:01Z   0 0 0900006480c19ccd
FDA-2011-F-0171-0014 FDA None FDA-2011-F-0171 Reference 11 - "Ogden, et al., Prevalence of Overweight, Obesity, and Extreme Obesity Among Adults: United States, Trends 1976–1980 Through 2007–2008" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:02Z   0 0 0900006480c1a0d0
FDA-2011-F-0171-0019 FDA None FDA-2011-F-0171 Reference 30 - "New York Times, 1920, City’s Soda Cost Millions Monthly: Tax on Soft Drinks in Manhattan and Bronx in February and March is $465,445" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:04Z   0 0 0900006480c1a0e3
FDA-2011-F-0171-0007 FDA None FDA-2011-F-0171 Reference 13 - "Ogden, et al., Prevalence of Overweight, Obesity, and Extreme Obesity Among Adults: United States, Trends 1976–1980 Through 2007–2008" - [Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule] re FDA-2011-F-0171-0001 Supporting & Related Material BKG-Background Material 2011-04-06T04:00:00Z 2011 4     2011-04-06T14:40:26Z   0 0 0900006480c19872
FDA-2011-F-0171-0017 FDA None FDA-2011-F-0171 Reference 28 - "Bureau of Labor Statistics, U.S. Department of Labor, Occupational Employment Statistics" - [Preliminary Regulatory Impact Analysis, March 2011, Food Labeling; Food Labeling; Calorie Labeling of Articles of Food in Vending Machines; Proposed Rule, re FDA-2011-F-0171-0001] Supporting & Related Material PRIA-Preliminary Regulatory Impact Analysis 2011-04-06T04:00:00Z 2011 4     2011-06-11T16:30:03Z   0 0 0900006480c1a0e1

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;