documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
52 rows where docket_id = "OSHA-2006-0042" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_month, comment_end_date, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OSHA-2006-0042-0055 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2026-02-03T05:00:00Z | 2026 | 2 | 2026-02-03T05:00:00Z | 2026-02-04T21:45:43Z | 2026-02157 | 0 | 0 | 09000064b918dc4d | |
| OSHA-2006-0042-0054 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2025-08-22T04:00:00Z | 2025 | 8 | 2025-08-22T04:00:00Z | 2025-09-09T03:59:59Z | 2025-08-22T17:02:05Z | 2025-16092 | 0 | 0 | 09000064b8f0c871 |
| OSHA-2006-0042-0053 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc. Expansion Application (June 2022) | Supporting & Related Material | Form | 2025-07-22T04:00:00Z | 2025 | 7 | 2025-07-22T16:47:58Z | 0 | 0 | 09000064b8e8c7be | |||
| OSHA-2006-0042-0052 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2025-06-26T04:00:00Z | 2025 | 6 | 2025-06-26T04:00:00Z | 2025-06-26T19:10:56Z | 2025-11763 | 0 | 0 | 09000064b8e2ed4b | |
| OSHA-2006-0042-0050 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2025-04-25T00:00:00Z | 2025 | 4 | 2025-04-25T00:00:00Z | 2025-05-13T03:59:59Z | 2025-05-12T16:50:09Z | 2025-07125 | 0 | 0 | 0900006486ab8c21 |
| OSHA-2006-0042-0049 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification, Inc. NRTL Application for Expansion (July 2022) | Supporting & Related Material | Form | 2025-02-25T05:00:00Z | 2025 | 2 | 2025-02-25T16:59:55Z | 0 | 0 | 090000648698f138 | |||
| OSHA-2006-0042-0048 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2025-01-23T05:00:00Z | 2025 | 1 | 2025-01-23T05:00:00Z | 2025-01-23T13:48:36Z | 2025-01568 | 0 | 0 | 09000064868f2b72 | |
| OSHA-2006-0042-0046 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-12-31T05:00:00Z | 2024 | 12 | 2024-12-31T05:00:00Z | 2025-01-16T04:59:59Z | 2025-01-16T02:00:50Z | 2024-31361 | 0 | 0 | 0900006486896c3a |
| OSHA-2006-0042-0045 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc. Expansion Application (May 2024) | Supporting & Related Material | Form | 2024-12-17T05:00:00Z | 2024 | 12 | 2025-07-22T16:48:20Z | 0 | 0 | 0900006486878414 | |||
| OSHA-2006-0042-0044 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-10-25T04:00:00Z | 2024 | 10 | 2024-10-25T04:00:00Z | 2024-10-25T13:01:24Z | 2024-24790 | 0 | 0 | 09000064867e37e5 | |
| OSHA-2006-0042-0043 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-09-12T04:00:00Z | 2024 | 9 | 2024-09-12T04:00:00Z | 2024-09-28T03:59:59Z | 2024-09-12T13:19:37Z | 2024-20686 | 0 | 0 | 09000064866eeb2e |
| OSHA-2006-0042-0042 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc. Expansion Request UL 347A (OSHA FORM 1- May 2020) | Supporting & Related Material | Form | 2024-08-19T04:00:00Z | 2024 | 8 | 2024-08-19T20:04:15Z | 0 | 0 | 0900006486654dca | |||
| OSHA-2006-0042-0041 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc. Expansion Application (March 2020) | Supporting & Related Material | Form | 2024-08-19T04:00:00Z | 2024 | 8 | 2024-08-19T20:02:08Z | 0 | 0 | 0900006486654e95 | |||
| OSHA-2006-0042-0040 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-07-17T04:00:00Z | 2024 | 7 | 2024-07-17T04:00:00Z | 2024-07-24T13:06:32Z | 2024-15648 | 0 | 0 | 09000064865f4784 | |
| OSHA-2006-0042-0039 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Applications for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-04-30T04:00:00Z | 2024 | 4 | 2024-04-30T04:00:00Z | 2024-05-16T03:59:59Z | 2024-04-30T12:49:09Z | 2024-09190 | 0 | 0 | 09000064865273c1 |
| OSHA-2006-0042-0037 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA NRTL Expansion Application - January 2022 | Supporting & Related Material | Form | 2024-04-12T04:00:00Z | 2024 | 4 | 2024-04-12T13:15:05Z | 0 | 0 | 09000064864d2afa | |||
| OSHA-2006-0042-0038 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA NRTL Expansion Application - July 2022 | Supporting & Related Material | Form | 2024-04-12T04:00:00Z | 2024 | 4 | 2024-04-12T13:17:18Z | 0 | 0 | 09000064864d2afd | |||
| OSHA-2006-0042-0036 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2023-09-21T04:00:00Z | 2023 | 9 | 2023-09-21T04:00:00Z | 2023-09-21T12:56:09Z | 2023-20402 | 0 | 0 | 0900006485fde187 | |
| OSHA-2006-0042-0035 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Application: CSA Group Testing and Certification, Inc.: Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2023-08-15T04:00:00Z | 2023 | 8 | 2023-08-15T04:00:00Z | 2023-08-31T03:59:59Z | 2023-08-15T13:00:45Z | 2023-17426 | 0 | 0 | 0900006485e3e069 |
| OSHA-2006-0042-0034 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group SNAP Transition Application - December 2020 | Supporting & Related Material | Form | 2023-07-26T04:00:00Z | 2023 | 7 | 2023-07-26T13:39:49Z | 0 | 0 | 0900006485d4d2fd | |||
| OSHA-2006-0042-0033 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2023-03-15T04:00:00Z | 2023 | 3 | 2023-03-15T04:00:00Z | 2023-03-15T13:08:49Z | 2023-05277 | 0 | 0 | 09000064857ab2d5 | |
| OSHA-2006-0042-0032 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition and Proposed Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2023-01-30T05:00:00Z | 2023 | 1 | 2023-01-30T05:00:00Z | 2023-02-15T04:59:59Z | 2023-01-30T13:44:00Z | 2023-01780 | 0 | 0 | 090000648561911a |
| OSHA-2006-0042-0030 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Standard Application (September 2021) | Supporting & Related Material | Form | 2023-01-12T05:00:00Z | 2023 | 1 | 2023-01-12T19:11:43Z | 0 | 0 | 09000064855e995c | |||
| OSHA-2006-0042-0031 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Revised Application (January 2022) | Supporting & Related Material | Form | 2023-01-12T05:00:00Z | 2023 | 1 | 2023-01-12T19:13:37Z | 0 | 0 | 09000064855e9592 | |||
| OSHA-2006-0042-0029 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2022-08-19T04:00:00Z | 2022 | 8 | 2022-08-19T04:00:00Z | 2022-08-19T12:41:27Z | 2022-17880 | 0 | 0 | 09000064852528ac | |
| OSHA-2006-0042-0028 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group & Testing Certification Inc.: Application for Expansion of Recognition | Notice | 2022-06-17T04:00:00Z | 2022 | 6 | 2022-06-17T04:00:00Z | 2022-07-06T03:59:59Z | 2022-06-17T13:23:47Z | 2022-13105 | 0 | 0 | 0900006485178b98 | |
| OSHA-2006-0042-0027 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | NRTL Application Form I | Supporting & Related Material | Form | 2022-05-27T04:00:00Z | 2022 | 5 | 2022-05-27T14:55:54Z | 0 | 0 | 09000064850fb867 | |||
| OSHA-2006-0042-0026 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-08-16T04:00:00Z | 2021 | 8 | 2021-08-16T04:00:00Z | 2021-08-16T14:54:44Z | 2021-17433 | 0 | 0 | 0900006484c63721 | |
| OSHA-2006-0042-0024 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-06-24T04:00:00Z | 2021 | 6 | 2021-06-24T04:00:00Z | 2021-07-10T03:59:59Z | 2021-07-08T01:00:40Z | 2021-13269 | 0 | 0 | 0900006484ba963b |
| OSHA-2006-0042-0023 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | 2021-05-19T04:00:00Z | 2021 | 5 | 2021-05-19T04:00:00Z | 2021-05-19T12:50:33Z | 2021-10522 | 0 | 0 | 0900006484b1a9c6 | ||
| OSHA-2006-0042-0022 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc. Grant of Expansion of Recognition | Notice | 2021-05-11T04:00:00Z | 2021 | 5 | 2021-05-11T04:00:00Z | 2021-05-11T13:44:30Z | 2021-09950 | 0 | 0 | 0900006484ae9a83 | ||
| OSHA-2006-0042-0021 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-03-05T05:00:00Z | 2021 | 3 | 2021-03-05T05:00:00Z | 2021-03-05T13:35:23Z | 2021-04556 | 0 | 0 | 0900006484a5fc4d | |
| OSHA-2006-0042-0019 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition and Proposed Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-02-23T05:00:00Z | 2021 | 2 | 2021-02-23T05:00:00Z | 2021-03-11T04:59:59Z | 2021-02-23T14:58:38Z | 2021-03651 | 0 | 0 | 0900006484a48dc5 |
| OSHA-2006-0042-0020 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-02-23T05:00:00Z | 2021 | 2 | 2021-02-23T05:00:00Z | 2021-03-11T04:59:59Z | 2021-02-23T15:05:02Z | 2021-03649 | 0 | 0 | 0900006484a48f50 |
| OSHA-2006-0042-0018 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Expansion Application, July 2019 | Supporting & Related Material | Guidance | 2021-02-11T05:00:00Z | 2021 | 2 | 2021-02-11T16:42:33Z | 0 | 0 | 0900006484a239e7 | |||
| OSHA-2006-0042-0017 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Request for Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-07-13T04:00:00Z | 2020 | 7 | 2020-07-13T04:00:00Z | 2020-07-29T03:59:59Z | 2020-07-13T14:54:22Z | 2020-15063 | 0 | 0 | 0900006484745c9b |
| OSHA-2006-0042-0016 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA 2018 Renewal Application | Supporting & Related Material | Form | 2019-12-18T05:00:00Z | 2019 | 12 | 2019-12-18T20:38:42Z | 0 | 0 | 0900006484214554 | |||
| OSHA-2006-0042-0015 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Application for Expansion of Recognition and Proposed Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2019-02-12T05:00:00Z | 2019 | 2 | 2019-02-12T05:00:00Z | 2019-02-28T04:59:59Z | 2019-02-12T15:21:23Z | 2019-02026 | 0 | 0 | 0900006483a65b9c |
| OSHA-2006-0042-0014 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2018-05-14T04:00:00Z | 2018 | 5 | 2018-05-14T04:00:00Z | 2018-05-14T12:53:14Z | 2018-10155 | 0 | 0 | 0900006483262ddc | |
| OSHA-2006-0042-0013 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association: Application for Expansion of Recognition and Proposed Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2017-12-18T05:00:00Z | 2017 | 12 | 2017-12-18T05:00:00Z | 2018-01-03T04:59:59Z | 2018-01-02T02:00:42Z | 2017-27122 | 0 | 0 | 0900006482d3021a |
| OSHA-2006-0042-0012 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Group Testing & Certification Inc. Expansion Application (May 2017) | Supporting & Related Material | Form | 2017-10-18T04:00:00Z | 2017 | 10 | 2017-10-18T12:22:17Z | 0 | 0 | 0900006482bd65b0 | |||
| OSHA-2006-0042-0011 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2015-12-07T05:00:00Z | 2015 | 12 | 2015-12-07T05:00:00Z | 2015-12-07T14:20:58Z | 2015-30784 | 0 | 0 | 0900006481d8953f | |
| OSHA-2006-0042-0010 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | CSA Expansion Application from Comparability Tables - January 2015 | Supporting & Related Material | 2015-11-30T05:00:00Z | 2015 | 11 | 2015-11-30T14:20:26Z | 0 | 0 | 0900006481d70dc1 | ||||
| OSHA-2006-0042-0009 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association: Application for Expansion of Recognition | Notice | Notice of Variance | 2015-10-06T04:00:00Z | 2015 | 10 | 2015-10-06T04:00:00Z | 2015-10-22T03:59:59Z | 2015-10-06T14:10:56Z | 2015-25401 | 0 | 0 | 0900006481cb319a |
| OSHA-2006-0042-0008 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association: Grant of Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-08-07T04:00:00Z | 2014 | 8 | 2014-08-07T04:00:00Z | 2014-08-07T20:19:56Z | 2014-18633 | 0 | 0 | 090000648180ba9f | |
| OSHA-2006-0042-0006 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association: Request for Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-02-24T05:00:00Z | 2014 | 2 | 2014-02-24T05:00:00Z | 2014-03-12T03:59:59Z | 2014-02-24T15:41:12Z | 2014-03864 | 0 | 0 | 09000064815a67f8 |
| OSHA-2006-0042-0007 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | 2013 Canadian Standards Association Request for Renewal | Supporting & Related Material | 2014-02-24T05:00:00Z | 2014 | 2 | 2014-02-24T15:41:12Z | 0 | 0 | 0900006481412daf | ||||
| OSHA-2006-0042-0005 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association; Expansion of Recognition. Notice | Notice | Nationally Recognized Testing Laboratory | 2010-10-25T04:00:00Z | 2010 | 10 | 2010-10-25T04:00:00Z | 2014-02-24T15:41:12Z | 2010-26887 | 0 | 0 | 0900006480b76697 | |
| OSHA-2006-0042-0004 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association; Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory | 2010-04-26T04:00:00Z | 2010 | 4 | 2010-04-26T04:00:00Z | 2010-05-12T03:59:59Z | 2014-02-24T15:41:12Z | 2010-09546 | 0 | 0 | 0900006480adf307 |
| OSHA-2006-0042-0003 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Modifications to the Scope of NRTL Recognition; Notice | Notice | Nationally Recognized Testing Laboratory | 2009-09-14T04:00:00Z | 2009 | 9 | 2009-09-14T04:00:00Z | 2014-02-24T15:41:11Z | 176 | 0 | 0 | 0900006480a22e06 | |
| OSHA-2006-0042-0002 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association; Expansion of Recognition | Notice | Federal Register Notices | 2007-03-07T05:00:00Z | 2007 | 3 | 2007-03-07T05:00:00Z | 2014-02-24T15:41:11Z | E7-03953 | 0 | 0 | 090000648020e77a | |
| OSHA-2006-0042-0001 | OSHA | Canadian Standards Association; Application for Expansion of Recognition OSHA-2006-0042 | Canadian Standards Association; Application for Expansion of Recognition | Notice | 2006-10-06T04:00:00Z | 2006 | 10 | 2006-10-06T04:00:00Z | 2024-06-13T19:43:25Z | E6-16587 | 0 | 0 | 09000064801d26e2 |
Advanced export
JSON shape: default, array, newline-delimited, object
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;