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

46 rows where docket_id = "TSA-2003-14610" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subtype, posted_month, comment_end_date, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

posted_year 14

  • 2003 8
  • 2004 7
  • 2005 5
  • 2020 5
  • 2018 4
  • 2007 2
  • 2008 2
  • 2010 2
  • 2012 2
  • 2013 2
  • 2016 2
  • 2017 2
  • 2021 2
  • 2022 1

document_type 3

  • Other 19
  • Notice 18
  • Rule 9

agency_id 1

  • TSA 46
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
TSA-2003-14610-0172 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Exemption from Renewal of the Hazardous Materials Endorsement Security Threat Assessment for Certain Individuals Notice Extension of Comment Period 2022-09-15T04:00:00Z 2022 9 2022-09-15T04:00:00Z   2022-09-23T18:23:40Z 2022-19864 0 0 090000648530cb5f
TSA-2003-14610-0171 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License Notice 30 Day Proposed Information Collection 2021-12-27T05:00:00Z 2021 12 2021-12-27T05:00:00Z 2022-01-27T04:59:59Z 2021-12-27T14:00:48Z 2021-28041 0 0 0900006484efd7cf
TSA-2003-14610-0170 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License Notice 60 Day Proposed Information Collection 2021-04-08T04:00:00Z 2021 4 2021-04-08T04:00:00Z 2021-06-08T03:59:59Z 2021-04-08T11:54:55Z 2021-07193 0 0 0900006484a9fb31
TSA-2003-14610-0169 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Exemption: Renewal of the Hazardous Materials Endorsement Security Threat Assessment for Certain Individuals; Extension Notice Extension of Comment Period 2020-10-28T04:00:00Z 2020 10 2020-10-28T04:00:00Z   2020-10-28T11:57:55Z 2020-23961 0 0 090000648493947c
TSA-2003-14610-0168 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Notice to Extend Exemption from Renewal of the Hazardous Materials Endorsement Security Threat Assessment for Certain Individuals Other Supplement (SUP) 2020-10-26T04:00:00Z 2020 10 2020-10-27T04:00:00Z   2020-10-27T12:07:13Z   0 0 090000648493217d
TSA-2003-14610-0167 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Exemption from Renewal of the Hazardous Materials Endorsement Security Threat Assessment for Certain Individuals; Extension Notice Notice of Change 2020-07-31T04:00:00Z 2020 7 2020-07-31T04:00:00Z   2020-07-31T16:40:04Z 2020-16359 0 0 09000064847c39b5
TSA-2003-14610-0166 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Notice; temporary exemption: Exemption from Renewal of the Hazardous Materials Endorsement Security Threat Assessment for Certain Individuals (Original) Other Supplement (SUP) 2020-04-17T04:00:00Z 2020 4 2020-04-17T04:00:00Z   2020-04-17T15:52:36Z   0 0 09000064844b22df
TSA-2003-14610-0165 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Exemption from Renewal: Hazardous Materials Endorsement Security Threat Assessment for Certain Individuals Notice Notice of Intent 2020-04-08T04:00:00Z 2020 4 2020-04-08T04:00:00Z   2020-04-09T11:52:37Z 2020-07340 0 0 09000064844921e6
TSA-2003-14610-0164 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 30DY PRA Notice: Extension of Agency Information Collection Activity Under OMB Review: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License (Original) Other Supplement (SUP) 2018-06-22T04:00:00Z 2018 6 2018-06-22T04:00:00Z   2018-06-22T18:10:35Z   0 0 09000064834468bc
TSA-2003-14610-0163 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for Hazardous Materials Endorsement for Commercial Driver's License Notice 30 Day Proposed Information Collection 2018-06-19T04:00:00Z 2018 6 2018-06-19T04:00:00Z 2018-07-20T03:59:59Z 2018-06-20T13:00:13Z 2018-13137 0 0 090000648342c77b
TSA-2003-14610-0162 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 60DY PRA Notice: Intent to Request Extension From OMB of One Current Public Collection of Information: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver’s License (Original) Other Supplement (SUP) 2018-05-15T04:00:00Z 2018 5 2018-05-15T04:00:00Z   2018-05-15T19:33:09Z   0 0 090000648326bb19
TSA-2003-14610-0161 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License Notice Request for Comments 2018-04-04T04:00:00Z 2018 4 2018-04-04T04:00:00Z 2018-06-05T03:59:59Z 2018-04-04T13:27:09Z 2018-06868 0 0 09000064830930fe
TSA-2003-14610-0158 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 30-Day Notice: Revision of Agency Information Collection Activity Under OMB Review: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver’s License (Original) Other Supplement (SUP) 2017-01-17T05:00:00Z 2017 1 2017-01-17T05:00:00Z   2017-01-17T13:20:29Z   0 0 090000648247c659
TSA-2003-14610-0157 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License Notice 30 Day Proposed Information Collection 2017-01-09T05:00:00Z 2017 1 2017-01-09T05:00:00Z 2017-02-09T04:59:59Z 2017-02-09T14:02:53Z 2017-00155 0 0 0900006482452a19
TSA-2003-14610-0153 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 60DY PRA Notice: Intent to Request Revision From OMB of One Current Public Collection of Information: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver’s License (Original) Other Supplement (SUP) 2016-08-17T04:00:00Z 2016 8 2016-08-17T04:00:00Z   2016-08-17T20:59:17Z   0 0 090000648217ef9f
TSA-2003-14610-0154 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License Notice 60 Day Proposed Information Collection 2016-08-16T04:00:00Z 2016 8 2016-08-16T04:00:00Z 2016-10-18T03:59:59Z 2016-09-20T13:02:09Z 2016-19448 0 0 0900006482178bda
TSA-2003-14610-0151 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License (Federal Register Publication) Notice 30 Day Proposed Information Collection 2013-06-06T04:00:00Z 2013 6 2013-02-27T05:00:00Z 2013-03-30T03:59:59Z 2024-11-12T05:14:38Z 2013-04427 1 0 090000648130e718
TSA-2003-14610-0152 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Extension of Agency Information Collection Activity Under OMB Review: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License (Original) Other Supplement (SUP) 2013-06-06T04:00:00Z 2013 6 2013-06-06T04:00:00Z   2013-06-06T19:31:29Z   0 0 09000064813100d4
TSA-2003-14610-0149 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Federal Register Publication (Original) Other Supplement (SUP) 2012-10-24T04:00:00Z 2012 10 2012-10-24T04:00:00Z   2012-10-24T18:33:03Z   0 0 090000648114e9ce
TSA-2003-14610-0148 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License (Federal Register Publication) Notice 60 Day Proposed Information Collection 2012-10-22T04:00:00Z 2012 10 2012-10-22T04:00:00Z 2012-12-22T04:59:59Z 2024-11-12T05:08:17Z 2012-25936 1 0 090000648114ad0f
TSA-2003-14610-0146 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 60 Day Notice: Intent to Request Renewal from OMB of ONe Current Public Collection of Information : Security Threat Assessment fro Individuals Applying for a Hazardous Materials endorsement for a Commercial Drivers License (Original) Other Other 2010-09-27T04:00:00Z 2010 9 2010-09-27T04:00:00Z   2013-07-27T23:32:43Z   0 0 0900006480b610b6
TSA-2003-14610-0145 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Agency Information Collection Activities; Proposals, Submissions, and Approvals: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License (Federal Register Publication) Notice Notice 2010-08-30T04:00:00Z 2010 8 2010-08-30T04:00:00Z 2010-10-30T03:59:59Z 2024-11-12T04:55:52Z 2010-21316 1 0 0900006480b3e09d
TSA-2003-14610-0143 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Extension of Agency Information Collection Activity Under OMB Review: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License Notice Notice 2008-02-26T05:00:00Z 2008 2 2008-02-26T05:00:00Z 2008-03-28T03:59:59Z 2024-11-07T21:50:52Z E8-03631 1 0 09000064803c73b1
TSA-2003-14610-0142 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 PRA-30-Day Renewal; Extension of Agency Information Collection Activity Under OMB Review: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers (Original) Notice Notice 2008-02-25T05:00:00Z 2008 2 2008-02-25T05:00:00Z   2008-02-25T15:38:11Z   0 0 09000064803c393d
TSA-2003-14610-0141 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Intent To Request Renewal From OMB of One Current Public Collection of Information: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License (Original) Notice Notice 2007-12-31T05:00:00Z 2007 12 2007-12-31T05:00:00Z   2008-01-08T12:42:50Z   0 0 0900006480380cc3
TSA-2003-14610-0140 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Intent To Request Renewal From OMB of One Current Public Collection of Information: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License Notice Notice 2007-12-28T05:00:00Z 2007 12 2007-12-28T05:00:00Z 2008-02-29T04:59:59Z 2008-01-08T12:42:50Z 07-06231 0 0 090000648037f961
TSA-2003-14610-0138 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Grant of Temporary Exemption From Requirements of 49 CFR 1572.13 (b)(1) for Issuance of a Hazardous Materials Endorsement (HME) Due to Hurricane Katrina Other Grant of Petition 2005-10-25T04:00:00Z 2005 10 2005-10-25T04:00:00Z 2005-10-26T03:59:59Z 2024-11-07T18:09:32Z   1 0 09000064803104a8
TSA-2003-14610-0139 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Notice of Recission of Temporary Exemption From Requirements of 49 CFR 1572.13 (b)(1) for Issuance of a Hazardous Materials Endorsement (HME) Due to Hurricane Katrina Notice Notice 2005-10-25T04:00:00Z 2005 10 2005-10-25T04:00:00Z 2005-10-26T03:59:59Z 2024-11-07T18:09:32Z   1 0 09000064803104a9
TSA-2003-14610-0137 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA HQ - Grant of Exemption Other Decision 2005-07-21T04:00:00Z 2005 7 2005-07-21T04:00:00Z 2005-07-22T03:59:59Z 2024-11-07T18:09:08Z   1 0 09000064803104a7
TSA-2003-14610-0136 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA HQ - Clarification of 49 CFR Section 1572.13(g), of the Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement (HME) on Commercial Drivers License (CDL) Other Response(s) 2005-03-23T05:00:00Z 2005 3 2005-03-23T05:00:00Z 2005-03-24T04:59:59Z 2024-11-07T18:09:08Z   1 0 09000064803104a6
TSA-2003-14610-0135 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA HQ - TSA Denies the American Trucker Association¿s Requests to Delay the Effective Date of Fingerprint-Based Criminal History Record Checks (CHRC) (this item relates to #123 of this docket) Other Decision 2005-03-22T05:00:00Z 2005 3 2005-03-22T05:00:00Z 2005-03-24T04:59:59Z 2024-11-07T18:09:08Z   1 0 09000064803104a5
TSA-2003-14610-0114 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Draft Preliminary Regulatory Evaluation, Regulatory Flexibility Determination, Trade Impact Assessment, and Unfunded Mandates Assessment Rule Interim Final Rule 2004-12-09T05:00:00Z 2004 12 2004-12-09T05:00:00Z 2004-12-10T04:59:59Z 2024-11-07T18:07:19Z   1 0 090000648031048e
TSA-2003-14610-0113 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Interim Final Rule; Request for Comments Rule Federal Register Publication 2004-11-24T05:00:00Z 2004 11 2004-11-24T05:00:00Z 2004-12-09T04:59:59Z 2024-11-07T18:07:19Z   1 0 090000648031048d
TSA-2003-14610-0111 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Interim Final Rule; Request for Comments (Original) Rule Interim Final Rule 2004-11-19T05:00:00Z 2004 11 2004-11-19T05:00:00Z 2004-11-23T04:59:59Z 2024-11-07T18:14:05Z   1 0 090000648031048a
TSA-2003-14610-0108 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Andrew J. Haraldson - Questions re: Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License Other Other 2004-08-19T04:00:00Z 2004 8 2004-08-19T04:00:00Z 2004-08-20T03:59:59Z 2024-11-07T18:14:05Z   1 0 0900006480310486
TSA-2003-14610-0107 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA HQ - Exemption for States from Notification Requirement in 49 CFR 1572.5(c)(2)(ii) Other Exemption/Waiver 2004-07-23T04:00:00Z 2004 7 2004-07-23T04:00:00Z 2004-07-24T03:59:59Z 2024-11-07T18:13:41Z   1 0 0900006480310485
TSA-2003-14610-0106 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Final Rule Rule Federal Register Publication 2004-04-06T04:00:00Z 2004 4 2004-04-06T04:00:00Z 2004-04-07T03:59:59Z 2024-11-07T18:13:41Z   1 0 0900006480310484
TSA-2003-14610-0105 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA HQ - Final Rule - Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Drivers License Rule Final Rule 2004-04-01T05:00:00Z 2004 4 2004-04-01T05:00:00Z 2004-04-02T04:59:59Z 2024-11-07T18:13:41Z   1 0 0900006480310482
TSA-2003-14610-0109 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Interim Final Rule; Amendment Rule Federal Register Publication 2003-11-07T05:00:00Z 2003 11 2003-11-07T05:00:00Z 2004-09-02T03:59:59Z 2024-11-07T18:14:05Z   1 0 0900006480310487
TSA-2003-14610-0103 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Interim Final Rule; Amendment (Original) Rule Interim Final Rule 2003-11-04T05:00:00Z 2003 11 2003-11-04T05:00:00Z 2003-11-06T04:59:59Z 2024-11-07T18:13:41Z   1 0 0900006480310480
TSA-2003-14610-0101-0001 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Petition for a Recall and Change in the Provisions of the Transportation Security Administration's Amended Transportation Security Regulation Other Petition(s) 2003-07-29T04:00:00Z 2003 7 2003-07-29T04:00:00Z 2003-07-30T03:59:59Z 2024-11-07T18:13:40Z   1 0 090000648031047d
TSA-2003-14610-0101-0002 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 Petition for a Recall and Change in the Provisions of the Transportation Security Administration's Amended Transportation Security Regulation Other Petition(s) 2003-07-29T04:00:00Z 2003 7 2003-07-29T04:00:00Z 2003-07-30T03:59:59Z 2024-11-07T18:13:41Z   1 0 090000648031047e
TSA-2003-14610-0085 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 SEARCH - Additional Information Other Additional Information 2003-07-07T04:00:00Z 2003 7 2003-07-07T04:00:00Z 2003-07-10T03:59:59Z 2024-11-07T18:11:59Z   1 0 09000064803104fe
TSA-2003-14610-0039 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 State of Nebraska, Department of Motor Vehicles - Request Clarification on the TSA and FMCSA Dockets Other Request 2003-07-07T04:00:00Z 2003 7 2003-07-07T04:00:00Z 2003-07-08T03:59:59Z 2024-11-07T18:10:32Z   1 0 09000064803104c6
TSA-2003-14610-0003 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Interim Final Rule; Request for Comments Rule Federal Register Publication 2003-05-05T04:00:00Z 2003 5 2003-05-05T04:00:00Z 2003-05-07T03:59:59Z 2024-11-07T18:10:00Z   1 0 09000064803104bb
TSA-2003-14610-0001 TSA Security Threat Assessment for Individuals Applying for a Hazardous Materials Endorsement for a Commercial Driver's License TSA-2003-14610 U.S. DHS/TSA - Interim Final Rule; Request for Comments (Original) Rule Federal Register Publication 2003-05-01T04:00:00Z 2003 5 2003-05-01T04:00:00Z 2003-05-02T03:59:59Z 2024-11-07T18:13:15Z   1 0 090000648031047a

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