documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
46 rows where docket_id = "OSHA-2006-0040" and document_type = "Notice" sorted by posted_date descending
This data as json, CSV (advanced)
| 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-0040-0094 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | 2025-01-22T05:00:00Z | 2025 | 1 | 2025-01-22T05:00:00Z | 2025-01-22T14:57:01Z | 2025-01396 | 0 | 0 | 09000064868edfc3 | ||
| OSHA-2006-0040-0093 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Applications for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-11-05T05:00:00Z | 2024 | 11 | 2024-11-05T05:00:00Z | 2024-11-21T04:59:59Z | 2024-11-05T13:10:24Z | 2024-25622 | 0 | 0 | 09000064867fd007 |
| OSHA-2006-0040-0092 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Denial of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-10-25T04:00:00Z | 2024 | 10 | 2024-10-25T04:00:00Z | 2024-10-25T12:55:44Z | 2024-24789 | 0 | 0 | 09000064867e3753 | |
| OSHA-2006-0040-0083 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-08-27T04:00:00Z | 2024 | 8 | 2024-08-27T04:00:00Z | 2024-08-27T12:13:11Z | 2024-19163 | 0 | 0 | 09000064866aa0a2 | |
| OSHA-2006-0040-0082 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-08-06T04:00:00Z | 2024 | 8 | 2024-08-06T04:00:00Z | 2024-08-22T03:59:59Z | 2024-08-06T12:28:30Z | 2024-17305 | 0 | 0 | 090000648661ffa7 |
| OSHA-2006-0040-0081 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2024-07-17T04:00:00Z | 2024 | 7 | 2024-07-17T04:00:00Z | 2024-08-02T03:59:59Z | 2024-07-24T13:08:56Z | 2024-15649 | 0 | 0 | 09000064865f48c3 |
| OSHA-2006-0040-0078 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2022-05-20T04:00:00Z | 2022 | 5 | 2022-05-20T04:00:00Z | 2022-05-20T13:54:56Z | 2022-10898 | 0 | 0 | 090000648509de94 | |
| OSHA-2006-0040-0076 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2022-03-21T04:00:00Z | 2022 | 3 | 2022-03-21T04:00:00Z | 2022-04-06T03:59:59Z | 2022-03-21T12:58:11Z | 2022-05885 | 0 | 0 | 0900006484fd6461 |
| OSHA-2006-0040-0073 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-12-23T05:00:00Z | 2021 | 12 | 2021-12-23T05:00:00Z | 2021-12-23T14:11:07Z | 2021-27802 | 0 | 0 | 0900006484ee805d | |
| OSHA-2006-0040-0072 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-11-29T05:00:00Z | 2021 | 11 | 2021-11-29T05:00:00Z | 2021-11-29T14:30:21Z | 2021-25897 | 0 | 0 | 0900006484e86a07 | |
| OSHA-2006-0040-0068 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, 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-11-01T04:00:00Z | 2021 | 11 | 2021-11-01T04:00:00Z | 2021-11-17T04:59:59Z | 2021-11-01T12:58:41Z | 2021-23690 | 0 | 0 | 0900006484e04f83 |
| OSHA-2006-0040-0067 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, 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-08-24T04:00:00Z | 2021 | 8 | 2021-08-24T04:00:00Z | 2021-09-09T03:59:59Z | 2021-08-24T14:27:03Z | 2021-18142 | 0 | 0 | 0900006484c9fdde |
| OSHA-2006-0040-0066 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, 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:35:44Z | 2021-17437 | 0 | 0 | 0900006484c634d6 | |
| OSHA-2006-0040-0065 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | 2021-06-15T04:00:00Z | 2021 | 6 | 2021-06-15T04:00:00Z | 2021-07-01T03:59:59Z | 2021-06-15T13:03:12Z | 2021-12466 | 0 | 0 | 0900006484b7f5bd | |
| OSHA-2006-0040-0064 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2021-05-24T04:00:00Z | 2021 | 5 | 2021-05-24T04:00:00Z | 2021-05-24T13:20:01Z | 2021-10868 | 0 | 0 | 0900006484b2e3d6 | |
| OSHA-2006-0040-0063 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition and Proposed Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Notice of Variance | 2021-04-07T04:00:00Z | 2021 | 4 | 2021-04-07T04:00:00Z | 2021-04-23T03:59:59Z | 2021-04-07T13:36:21Z | 2021-07131 | 0 | 0 | 0900006484a9ed73 |
| OSHA-2006-0040-0062 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, 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-05T14:01:04Z | 2021-04549 | 0 | 0 | 0900006484a60625 | |
| OSHA-2006-0040-0061 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-09-21T04:00:00Z | 2020 | 9 | 2020-09-21T04:00:00Z | 2020-09-21T13:24:50Z | 2020-20727 | 0 | 0 | 090000648486a8f1 | |
| OSHA-2006-0040-0060 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the Nationally Recognized Testing Laboratory (NRTL) Program’s | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-08-27T04:00:00Z | 2020 | 8 | 2020-08-27T04:00:00Z | 2020-08-27T15:40:32Z | 2020-18833 | 0 | 0 | 0900006484823d4b | |
| OSHA-2006-0040-0058 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Request for Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-07-14T04:00:00Z | 2020 | 7 | 2020-07-14T04:00:00Z | 2020-07-30T03:59:59Z | 2020-07-14T12:48:44Z | 2020-15059 | 0 | 0 | 0900006484752f2a |
| OSHA-2006-0040-0057 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-03-24T04:00:00Z | 2020 | 3 | 2020-03-24T04:00:00Z | 2020-03-24T12:24:39Z | 2020-06084 | 0 | 0 | 090000648446364a | |
| OSHA-2006-0040-0056 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North, America, Inc.: Applications for Expansion of Recognition and Proposed Modification o the NRTL Program's List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-03-05T05:00:00Z | 2020 | 3 | 2020-03-05T05:00:00Z | 2020-03-21T03:59:59Z | 2020-03-05T16:29:07Z | 2020-04389 | 0 | 0 | 09000064843ed607 |
| OSHA-2006-0040-0055 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2020-02-26T05:00:00Z | 2020 | 2 | 2020-02-26T05:00:00Z | 2020-03-13T03:59:59Z | 2020-02-28T02:01:51Z | 2020-03881 | 0 | 0 | 09000064843b4fa4 |
| OSHA-2006-0040-0050 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Applications for Expansion of Recognition and Proposed Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2019-11-05T05:00:00Z | 2019 | 11 | 2019-11-05T05:00:00Z | 2019-11-21T04:59:59Z | 2019-11-21T02:04:32Z | 2019-24094 | 0 | 0 | 090000648411e6cc |
| OSHA-2006-0040-0049 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2019-04-18T04:00:00Z | 2019 | 4 | 2019-04-18T04:00:00Z | 2019-04-18T13:21:56Z | 2019-07728 | 0 | 0 | 0900006483bb9388 | |
| OSHA-2006-0040-0048 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, 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-07T05:00:00Z | 2019 | 2 | 2019-02-07T05:00:00Z | 2019-02-23T04:59:59Z | 2019-02-07T14:46:51Z | 2019-01422 | 0 | 0 | 0900006483a4ff28 |
| OSHA-2006-0040-0035 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2017-06-21T04:00:00Z | 2017 | 6 | 2017-06-21T04:00:00Z | 2017-06-21T13:27:03Z | 2017-12912 | 0 | 0 | 0900006482711aa9 | |
| OSHA-2006-0040-0032 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2017-03-15T04:00:00Z | 2017 | 3 | 2017-03-15T04:00:00Z | 2017-03-31T03:59:59Z | 2017-03-24T13:56:46Z | 2017-05190 | 0 | 0 | 0900006482508807 |
| OSHA-2006-0040-0031 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2016-09-29T04:00:00Z | 2016 | 9 | 2016-09-29T04:00:00Z | 2016-09-29T14:14:51Z | 2016-23547 | 0 | 0 | 090000648227f958 | |
| OSHA-2006-0040-0030 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Applications for Expansion of Recognition | Notice | Notice of Variance | 2016-07-21T04:00:00Z | 2016 | 7 | 2016-07-21T04:00:00Z | 2016-08-06T03:59:59Z | 2016-07-21T13:21:50Z | 2016-17241 | 0 | 0 | 09000064820dba03 |
| OSHA-2006-0040-0024 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition and Modification to the List of Appropriate NRTL Program Test Standards | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2016-01-22T05:00:00Z | 2016 | 1 | 2016-01-22T05:00:00Z | 2016-01-22T14:48:48Z | 2016-01285 | 0 | 0 | 0900006481e2870a | |
| OSHA-2006-0040-0022 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Application for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2015-10-13T04:00:00Z | 2015 | 10 | 2015-10-13T04:00:00Z | 2015-10-29T03:59:59Z | 2015-10-14T13:30:56Z | 2015-25850 | 0 | 0 | 0900006481cc4a74 |
| OSHA-2006-0040-0021 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2015-02-19T05:00:00Z | 2015 | 2 | 2015-02-19T05:00:00Z | 2015-02-19T15:19:09Z | 2015-03476 | 0 | 0 | 0900006481a09b70 | |
| OSHA-2006-0040-0020 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-12-19T05:00:00Z | 2014 | 12 | 2014-12-19T05:00:00Z | 2014-12-19T14:52:18Z | 2014-29732 | 0 | 0 | 0900006481985e00 | |
| OSHA-2006-0040-0015 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Applications for Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-10-27T04:00:00Z | 2014 | 10 | 2014-10-27T04:00:00Z | 2014-11-13T04:59:59Z | 2014-10-27T13:18:03Z | 2014-25377 | 0 | 0 | 09000064818fed24 |
| OSHA-2006-0040-0017 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Nationally Recognized Testing Laboratories: SGS North America, Inc.; Expansion of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-10-27T04:00:00Z | 2014 | 10 | 2014-10-27T04:00:00Z | 2014-10-27T13:22:21Z | 2014-25378 | 0 | 0 | 09000064818fed25 | |
| OSHA-2006-0040-0013 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Nationally Recognized Testing Laboratories: SGS North America, Inc.; Application for Expansion | Notice | 2014-08-29T04:00:00Z | 2014 | 8 | 2014-08-29T04:00:00Z | 2014-09-16T03:59:59Z | 2014-08-29T15:57:14Z | 2014-20593 | 0 | 0 | 090000648184f4c3 | |
| OSHA-2006-0040-0012 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Applications for Expansion of Recognition as Nationally Recognized Testing Laboratories: SGS North America, Inc. | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-07-24T04:00:00Z | 2014 | 7 | 2014-07-24T04:00:00Z | 2014-08-09T03:59:59Z | 2014-07-24T14:48:13Z | 2014-17445 | 0 | 0 | 09000064817dc392 |
| OSHA-2006-0040-0009 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS North America, Inc.: Grant of Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-07-14T04:00:00Z | 2014 | 7 | 2014-07-14T04:00:00Z | 2014-07-18T14:20:28Z | 2014-16433 | 0 | 0 | 09000064817a9e53 | |
| OSHA-2006-0040-0077 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Underwriters Laboratories Inc.; Application for Expansion of Recognition | Notice | 2014-04-14T00:00:00Z | 2014 | 4 | 2022-03-24T21:47:25Z | 0 | 1 | 09000064816b255b | ||||
| OSHA-2006-0040-0007 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | SGS International, Inc.: Request for Renewal of Recognition | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2014-02-25T05:00:00Z | 2014 | 2 | 2014-02-25T05:00:00Z | 2014-03-13T03:59:59Z | 2014-03-24T18:15:02Z | 2014-03923 | 0 | 0 | 09000064815b0e41 |
| OSHA-2006-0040-0006 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Nationally Recognized Testing Laboratories: SGS North America, Inc. | Notice | 2013-08-12T04:00:00Z | 2013 | 8 | 2013-08-12T04:00:00Z | 2013-08-12T14:52:54Z | 2013-19412 | 0 | 0 | 09000064813ac3ec | ||
| OSHA-2006-0040-0005 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Nationally Recognized Testing Laboratories; Expansion Applications: SGS North America, Inc. | Notice | Nationally Recognized Testing Laboratory (NRTL) | 2013-06-26T04:00:00Z | 2013 | 6 | 2013-06-26T04:00:00Z | 2013-07-12T03:59:59Z | 2013-06-26T13:29:43Z | 2013-15229 | 0 | 0 | 09000064813414c8 |
| OSHA-2006-0040-0004 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | 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 | 2013-06-26T11:25:23Z | 176 | 0 | 0 | 0900006480a22e05 | |
| OSHA-2006-0040-0002 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Ex. 18. SGS U.S. Testing Company, Inc.; Expansion of Recognition-Final Decision | Notice | Nationally Recognized Testing Laboratory | 2008-02-07T05:00:00Z | 2008 | 2 | 2008-02-07T05:00:00Z | 2013-06-26T11:25:22Z | E8-02199 | 0 | 0 | 09000064803a9e7a | |
| OSHA-2006-0040-0001 | OSHA | SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition OSHA-2006-0040 | Ex. 17. SGS U.S. Testing Company, Inc.; Applications for Renewal and Expansion of Recognition | Notice | 2006-10-06T04:00:00Z | 2006 | 10 | 2006-10-06T04:00:00Z | 2013-06-26T11:25:22Z | E6-16589 | 0 | 0 | 09000064801d25e3 |
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;