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

50 rows where docket_id = "OSHA-2006-0028" and document_type = "Notice" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

posted_year 14

  • 2022 9
  • 2014 6
  • 2018 6
  • 2019 6
  • 2021 5
  • 2017 4
  • 2016 3
  • 2020 3
  • 2007 2
  • 2010 2
  • 2006 1
  • 2008 1
  • 2009 1
  • 2023 1

document_type 1

  • Notice · 50 ✖

agency_id 1

  • OSHA 50
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-0028-0094 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Eurofins Electrical and Electronic Testing NA, Inc. a/k/a MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2023-01-17T05:00:00Z 2023 1 2023-01-17T05:00:00Z   2023-01-17T13:55:48Z 2023-00676 0 0 09000064855efc3d
OSHA-2006-0028-0093 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Eurofins Electrical and Electronic Testing NA, Inc. a/k/a MET Laboratories, Inc.: Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-11-23T05:00:00Z 2022 11 2022-11-23T05:00:00Z 2022-12-09T04:59:59Z 2022-11-23T13:20:06Z 2022-25545 0 0 09000064854fe9ab
OSHA-2006-0028-0091 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Eurofins Electrical and Electronic Testing NA, Inc. a/k/a MET Laboratories, 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:44:09Z 2022-17878 0 0 0900006485253a04
OSHA-2006-0028-0090 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Eurofins Electrical and Electronic Testing NA, Inc. a/k/a MET Laboratories, Inc.: Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-06-17T04:00:00Z 2022 6 2022-06-17T04:00:00Z 2022-07-06T03:59:59Z 2022-06-17T13:27:47Z 2022-13098 0 0 0900006485178bdb
OSHA-2006-0028-0088 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-04-05T04:00:00Z 2022 4 2022-04-05T04:00:00Z   2022-04-05T12:56:08Z 2022-07091 0 0 0900006484ff9657
OSHA-2006-0028-0087 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-03-11T05:00:00Z 2022 3 2022-03-11T05:00:00Z   2022-03-11T13:13:17Z 2022-05195 0 0 0900006484fc3b42
OSHA-2006-0028-0086 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-03-01T05:00:00Z 2022 3 2022-03-01T05:00:00Z   2022-03-01T14:03:07Z 2022-04275 0 0 0900006484fb0893
OSHA-2006-0028-0085 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-02-15T05:00:00Z 2022 2 2022-02-15T05:00:00Z 2022-03-03T04:59:59Z 2022-02-15T13:55:18Z 2022-03194 0 0 0900006484f79306
OSHA-2006-0028-0084 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-01-26T05:00:00Z 2022 1 2022-01-26T05:00:00Z 2022-02-11T04:59:59Z 2022-01-26T13:08:41Z 2022-01455 0 0 0900006484f38cfb
OSHA-2006-0028-0083 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Applications for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2022-01-21T05:00:00Z 2022 1 2022-01-21T05:00:00Z 2022-02-08T04:59:59Z 2022-01-21T12:57:56Z 2022-01130 0 0 0900006484f2cfad
OSHA-2006-0028-0074 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2021-06-24T04:00:00Z 2021 6 2021-06-24T04:00:00Z   2021-06-24T12:32:59Z 2021-13270 0 0 0900006484ba95ea
OSHA-2006-0028-0071 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2021-04-22T04:00:00Z 2021 4 2021-04-22T04:00:00Z 2021-05-08T03:59:59Z 2021-04-22T13:56:32Z 2021-08337 0 0 0900006484ab2e52
OSHA-2006-0028-0073 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition and Modification to the Nationally Recognized Testing Laboratory (NRTL) Program’s List of Appropriate Test Standards Notice Nationally Recognized Testing Laboratory (NRTL) 2021-04-22T04:00:00Z 2021 4 2021-04-22T04:00:00Z 2021-05-25T03:59:59Z 2021-04-22T18:02:53Z 2021-08338 0 0 0900006484ab2f81
OSHA-2006-0028-0070 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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:03:00Z 2021-04557 0 0 0900006484a60628
OSHA-2006-0028-0069 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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) 2021-01-21T05:00:00Z 2021 1 2021-01-21T05:00:00Z 2021-02-06T04:59:59Z 2021-01-21T14:32:26Z 2021-01221 0 0 09000064849faac0
OSHA-2006-0028-0068 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2020-09-28T04:00:00Z 2020 9 2020-09-28T04:00:00Z   2020-09-28T13:20:41Z 2020-21278 0 0 090000648488e4f7
OSHA-2006-0028-0065 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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:33:37Z 2020-15055 0 0 0900006484745b3e
OSHA-2006-0028-0063 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Applications for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2020-02-21T05:00:00Z 2020 2 2020-02-21T05:00:00Z 2020-03-10T03:59:59Z 2020-02-21T13:26:16Z 2020-03502 0 0 0900006484397e1b
OSHA-2006-0028-0059 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2019-10-01T04:00:00Z 2019 10 2019-10-01T04:00:00Z   2019-10-01T13:23:44Z 2019-21233 0 0 0900006483ff21a7
OSHA-2006-0028-0058 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Grant of Expansion of Recognition and Modification to the Nationally Recognized Testing Laboratory Program's List of Appropriate Test Standards: MET Laboratories, Inc. Notice Nationally Recognized Testing Laboratory (NRTL) 2019-09-17T04:00:00Z 2019 9 2019-09-17T04:00:00Z   2019-09-17T12:49:51Z 2019-20019 0 0 0900006483f8640e
OSHA-2006-0028-0057 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2019-06-05T04:00:00Z 2019 6 2019-06-05T04:00:00Z 2019-06-21T03:59:59Z 2019-06-05T13:11:03Z 2019-11729 0 0 0900006483cebd50
OSHA-2006-0028-0056 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 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) 2019-04-22T04:00:00Z 2019 4 2019-04-22T04:00:00Z   2019-04-22T12:16:08Z 2019-07997 0 0 0900006483bdac0b
OSHA-2006-0028-0052 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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-03-12T04:00:00Z 2019 3 2019-03-12T04:00:00Z 2019-03-28T03:59:59Z 2019-03-29T01:03:08Z 2019-04435 0 0 0900006483ad6dad
OSHA-2006-0028-0051 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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-02-14T05:00:00Z 2019 2 2019-02-14T05:00:00Z   2019-02-14T13:34:19Z 2019-02239 0 0 0900006483a74ab0
OSHA-2006-0028-0050 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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) 2018-07-24T04:00:00Z 2018 7 2018-07-24T04:00:00Z 2018-08-09T03:59:59Z 2018-07-30T01:03:09Z 2018-15773 0 0 0900006483543eb5
OSHA-2006-0028-0048 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards Notice Nationally Recognized Testing Laboratory (NRTL) 2018-05-15T04:00:00Z 2018 5 2018-05-15T04:00:00Z   2018-05-15T12:14:55Z 2018-10330 0 0 09000064832687e6
OSHA-2006-0028-0047 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards Notice Nationally Recognized Testing Laboratory (NRTL) 2018-05-14T04:00:00Z 2018 5 2018-05-14T04:00:00Z   2018-05-14T12:48:28Z 2018-10154 0 0 09000064832628ad
OSHA-2006-0028-0046 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2018-03-09T05:00:00Z 2018 3 2018-03-09T05:00:00Z   2018-03-09T13:38:23Z 2018-04746 0 0 0900006482fce8d3
OSHA-2006-0028-0045 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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) 2018-02-21T05:00:00Z 2018 2 2018-02-21T05:00:00Z 2018-03-09T04:59:59Z 2018-03-09T02:02:49Z 2018-03529 0 0 0900006482f4c9c8
OSHA-2006-0028-0044 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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) 2018-02-09T05:00:00Z 2018 2 2018-02-09T05:00:00Z 2018-02-27T04:59:59Z 2018-02-26T01:37:02Z 2018-02563 0 0 0900006482f060eb
OSHA-2006-0028-0043 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Applications for Expansion of Recognition 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-03T02:01:05Z 2017-27123 0 0 0900006482d304bd
OSHA-2006-0028-0036 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition and Update to the NRTL Program’s List of Appropriate Test Standards Notice Nationally Recognized Testing Laboratory (NRTL) 2017-09-13T04:00:00Z 2017 9 2017-09-13T04:00:00Z   2017-09-13T12:37:01Z 2017-19403 0 0 0900006482b2ce22
OSHA-2006-0028-0035 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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) 2017-06-01T04:00:00Z 2017 6 2017-06-01T04:00:00Z 2017-06-17T03:59:59Z 2017-06-01T12:05:05Z 2017-11239 0 0 0900006482675d1d
OSHA-2006-0028-0034 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition and Modification to the NRTL Program’s List of Appropriate Test Standards Notice Nationally Recognized Testing Laboratory (NRTL) 2017-04-05T04:00:00Z 2017 4 2017-04-05T04:00:00Z   2017-04-05T13:03:09Z 2017-06765 0 0 090000648253c019
OSHA-2006-0028-0030 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Application for Expansion of Recognition and Proposed Modification to the NRTL Program's List of Appropriate Test Standards Notice Request for Comments 2016-11-15T05:00:00Z 2016 11 2016-11-15T05:00:00Z 2016-12-01T04:59:59Z 2016-11-15T15:05:28Z 2016-27356 0 0 090000648239635e
OSHA-2006-0028-0023 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Nationally Recognized Testing Laboratories: MET Laboratories, Inc. Notice Nationally Recognized Testing Laboratory (NRTL) 2016-04-04T04:00:00Z 2016 4 2016-04-04T04:00:00Z   2016-04-04T13:40:17Z 2016-07482 0 0 0900006481f23c5c
OSHA-2006-0028-0022 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Application for 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-02-09T04:59:59Z 2016-01-22T16:13:44Z 2016-01289 0 0 0900006481e28873
OSHA-2006-0028-0019 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Nationally Recognized Testing Laboratories: MET Laboratories, Inc. Notice Nationally Recognized Testing Laboratory (NRTL) 2014-10-20T04:00:00Z 2014 10 2014-10-20T04:00:00Z   2014-10-20T15:56:48Z 2014-24857 0 0 09000064818dd6ea
OSHA-2006-0028-0018 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Grant of Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2014-08-29T04:00:00Z 2014 8 2014-08-29T04:00:00Z   2014-08-29T14:27:31Z 2014-20560 0 0 090000648184f4bd
OSHA-2006-0028-0017 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.: Applications for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2014-07-23T04:00:00Z 2014 7 2014-07-23T04:00:00Z 2014-08-08T03:59:59Z 2014-07-23T16:10:21Z 2014-17343 0 0 09000064817d760c
OSHA-2006-0028-0016 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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-14T16:56:42Z 2014-16432 0 0 09000064817aa807
OSHA-2006-0028-0013 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.; Application for Expansion of Recognition Notice Nationally Recognized Testing Laboratory (NRTL) 2014-05-06T04:00:00Z 2014 5 2014-05-06T04:00:00Z 2014-05-22T03:59:59Z 2014-05-06T13:31:41Z 2014-10294 0 0 09000064816e4002
OSHA-2006-0028-0012 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, 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 2016-01-21T20:59:45Z 2014-03920 0 0 09000064815b10b3
OSHA-2006-0028-0010 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Expansion of Scope of NRTL Recognition of MET Laboratories, Inc.; Correction of Scope of NRTL Recognition of FM Approvals, LLC. Action: Notice Notice Nationally Recognized Testing Laboratory 2010-12-13T05:00:00Z 2010 12 2010-12-13T05:00:00Z   2014-02-07T22:23:23Z 2010-31190 0 0 0900006480bb501d
OSHA-2006-0028-0009 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.; Application for Expansion of Recognition. Notice Notice Nationally Recognized Testing Laboratory 2010-07-28T04:00:00Z 2010 7 2010-07-28T04:00:00Z 2010-08-13T03:59:59Z 2014-02-14T20:53:50Z 2010-18438 0 0 0900006480b226a0
OSHA-2006-0028-0008 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 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-14T20:53:38Z 176 0 0 0900006480a22e01
OSHA-2006-0028-0005 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.; Expansion of Recognition; Notice Notice Federal Register Notices 2008-01-04T05:00:00Z 2008 1 2008-01-04T05:00:00Z   2014-02-14T20:53:20Z E7-25612 0 0 0900006480384bde
OSHA-2006-0028-0003 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc.; Application for Expansion of Recognition Notice Federal Register Notices 2007-07-06T04:00:00Z 2007 7 2007-07-06T04:00:00Z 2007-07-24T03:59:59Z 2014-02-14T20:53:06Z E7-13106 0 0 090000648025e644
OSHA-2006-0028-0002 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 Ex. 2. MET Laboratories, Inc.; Expansion of Recognition. Final Decision Notice Federal Register Notices 2007-02-27T05:00:00Z 2007 2 2007-02-27T05:00:00Z   2016-12-21T18:39:33Z E7-03294 0 0 090000648020c048
OSHA-2006-0028-0001 OSHA MET Laboratories, Inc., Application for Expansion of Recognition OSHA-2006-0028 MET Laboratories, Inc., Application for Expansion of Recognition Notice   2006-08-17T04:00:00Z 2006 8 2006-08-17T04:00:00Z   2014-02-14T20:52:49Z E6-13549 0 0 09000064801b8f7d

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