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

48 rows where docket_id = "DOT-OST-1995-369" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

posted_year 12

  • 1994 27
  • 1997 6
  • 2002 3
  • 1998 2
  • 2003 2
  • 2005 2
  • 1995 1
  • 1996 1
  • 1999 1
  • 2000 1
  • 2004 1
  • 2007 1

document_type 3

  • Other 40
  • Notice 7
  • Supporting & Related Material 1

agency_id 1

  • DOT 48
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
DOT-OST-1995-369-0092 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice of Action Taken re: United Airlines, Inc. Notice Notice 2007-11-29T05:00:00Z 2007 11 2007-11-29T05:00:00Z   2013-07-27T20:27:19Z   0 0 090000648036a374
DOT-OST-1995-369-0091-0001 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Application of United Air Lines, Inc. for Renewal of Exemptions Other Application-Other 2005-12-08T05:00:00Z 2005 12 2005-12-08T05:00:00Z 2005-12-09T04:59:59Z 2024-11-11T21:40:08Z   1 0 09000064802a1843
DOT-OST-1995-369-0091-0002 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Application of United Air Lines, Inc. for Renewal of Exemptions Other Application-Other 2005-12-08T05:00:00Z 2005 12 2005-12-08T05:00:00Z 2005-12-09T04:59:59Z 2024-11-11T21:40:08Z   1 0 09000064802a1844
DOT-OST-1995-369-0090 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice of Action Taken re: United Air Lines, Inc. Notice Notice 2004-02-10T05:00:00Z 2004 2 2004-02-10T05:00:00Z 2004-02-11T04:59:59Z 2024-11-11T21:40:07Z   1 0 09000064802a1842
DOT-OST-1995-369-0089-0001 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Application of United Air Lines, Inc. for Renewal of Exemptions Other Application-Other 2003-12-29T05:00:00Z 2003 12 2003-12-29T05:00:00Z 2003-12-30T04:59:59Z 2024-11-11T21:40:07Z   1 0 09000064802a183e
DOT-OST-1995-369-0089-0002 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Application of United Air Lines, Inc. for Renewal of Exemptions Other Application-Other 2003-12-29T05:00:00Z 2003 12 2003-12-29T05:00:00Z 2003-12-30T04:59:59Z 2024-11-11T21:40:07Z   1 0 09000064802a183f
DOT-OST-1995-369-0088 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice of Action Taken re: United Air Lines, Inc. Notice Notice 2002-03-01T05:00:00Z 2002 3 2002-03-01T05:00:00Z 2002-03-02T04:59:59Z 2024-11-11T21:40:07Z   1 0 09000064802a183d
DOT-OST-1995-369-0087 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Supplement to Application of United Air Lines, Inc. for Renewal and Amendment of Exemptions Supporting & Related Material Supplement 2002-02-27T05:00:00Z 2002 2     2024-11-11T21:40:07Z   0 0 09000064802a183c
DOT-OST-1995-369-0086 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Application of United Air Lines, Inc. for Renewal and Amendment of Exemptions Other Application-Other 2002-01-23T05:00:00Z 2002 1 2002-01-23T05:00:00Z 2002-01-24T04:59:59Z 2024-11-11T21:39:48Z   1 0 09000064802a183b
DOT-OST-1995-369-0085 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice of Action Taken re: United Air Lines, Inc. Notice Notice 2000-03-29T05:00:00Z 2000 3 2000-03-29T05:00:00Z 2000-03-30T04:59:59Z 2024-11-11T21:39:48Z   1 0 09000064802a183a
DOT-OST-1995-369-0083 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. - Renewal/Exemption - United States - Nairobi, Kenya Other Application-Other 1999-10-21T04:00:00Z 1999 10 1999-10-21T04:00:00Z 1999-11-13T04:59:59Z 2024-11-11T21:39:48Z   1 0 09000064802a1839
DOT-OST-1995-369-0082 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice of Action Taken re: United Air Lines, Inc. Notice Notice 1998-05-27T04:00:00Z 1998 5 1998-05-27T04:00:00Z 1998-05-28T03:59:59Z 2024-11-11T21:39:47Z   1 0 09000064802a1838
DOT-OST-1995-369-0080 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 98-1-17 Order for Exemptions or Authorities under 49 U.S.C. Section 40109 and the Orders and Regulations of the Department of Transportation Other Order 1998-01-21T05:00:00Z 1998 1 1998-01-21T05:00:00Z 1998-01-22T04:59:59Z 2024-11-11T21:39:47Z   1 0 09000064802a1836
DOT-OST-1995-369-0079 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice of Action Taken re: United Air Lines, Inc. and Lufthansa German Airlines, Inc. Notice Notice 1997-12-29T05:00:00Z 1997 12 1997-12-29T05:00:00Z 1997-12-30T04:59:59Z 2024-11-11T21:39:47Z   1 0 09000064802a1834
DOT-OST-1995-369-0081 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. - Renewal/Amendment - Exemption - United States - Lyon, France; United States - Nairobi, Kenya; United States - Manchester, England; United States - Baku, Azerbaijan; and United- Ashkhabad, Turkmenistan Other Application-Other 1997-02-27T05:00:00Z 1997 2 1997-02-27T05:00:00Z 1997-03-22T04:59:59Z 2024-11-11T21:39:47Z   1 0 09000064802a1837
DOT-OST-1995-369-0077 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Lufthansa German Airlines, Inc. - Reply Other Reply 1997-02-14T05:00:00Z 1997 2 1997-02-14T05:00:00Z 1997-02-15T04:59:59Z 2024-11-11T21:39:31Z   1 0 09000064802a1832
DOT-OST-1995-369-0078 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. - Reply Other Reply 1997-02-14T05:00:00Z 1997 2 1997-02-14T05:00:00Z 1997-02-15T04:59:59Z 2024-11-11T21:39:47Z   1 0 09000064802a1833
DOT-OST-1995-369-0076 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 American Airlines, Inc. - Answer Other Answer 1997-02-05T05:00:00Z 1997 2 1997-02-05T05:00:00Z 1997-02-06T04:59:59Z 2024-11-11T21:39:31Z   1 0 09000064802a1831
DOT-OST-1995-369-0075 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. and Lufthansa German Airlines - Renewal/Amendment - Code-Sharing/Blocked Space Services with U.S.-Germany Services Other Application-Other 1997-01-21T05:00:00Z 1997 1 1997-01-21T05:00:00Z 1997-01-22T04:59:59Z 2024-11-11T21:39:30Z   1 0 09000064802a1830
DOT-OST-1995-369-0074 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 96-3-37 Order Renewing Exemptions and Statements of Authorization Other Order 1996-03-22T05:00:00Z 1996 3 1996-03-22T05:00:00Z 1996-03-23T04:59:59Z 2024-11-11T21:39:30Z   1 0 09000064802a182f
DOT-OST-1995-369-0073 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Thomas C. Green - Letter of Withdrawal as Counsel Other Correspondence 1995-03-23T05:00:00Z 1995 3 1995-03-23T05:00:00Z 1995-03-24T04:59:59Z 2024-11-11T21:39:30Z   1 0 09000064802a182e
DOT-OST-1995-369-0070 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. - Consolidated Joint Reply Other Reply 1994-12-19T05:00:00Z 1994 12 1994-12-19T05:00:00Z 1994-12-20T04:59:59Z 2024-11-11T21:39:09Z   1 0 09000064802a182b
DOT-OST-1995-369-0069 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Trans World Airlines, Inc. - Answer Other Answer 1994-12-08T05:00:00Z 1994 12 1994-12-08T05:00:00Z 1994-12-09T04:59:59Z 2024-11-11T21:39:08Z   1 0 09000064802a1827
DOT-OST-1995-369-0068 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 American Airlines, Inc. - Answer Other Answer 1994-12-08T05:00:00Z 1994 12 1994-12-08T05:00:00Z 1994-12-09T04:59:59Z 2024-11-11T21:39:08Z   1 0 09000064802a1826
DOT-OST-1995-369-0067 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. and Lufthansa German Airlines - Joint Renewal Application Other Application-Other 1994-11-23T05:00:00Z 1994 11 1994-11-23T05:00:00Z 1994-11-24T04:59:59Z 2024-11-11T21:39:08Z   1 0 09000064802a1825
DOT-OST-1995-369-0071 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. and Lufthansa German Airlines - Letter re Pursuant to Request of DOT Staff Other Acknowledgement Letter/Receipt 1994-08-01T04:00:00Z 1994 8 1994-08-01T04:00:00Z 1994-08-02T03:59:59Z 2024-11-11T21:39:30Z   1 0 09000064802a182c
DOT-OST-1995-369-0066 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 94-4-43 Order (Approving Deferred Portions of Joint Application) Other Order 1994-04-28T04:00:00Z 1994 4 1994-04-28T04:00:00Z 1994-04-29T03:59:59Z 2024-11-11T21:39:08Z   1 0 09000064802a1824
DOT-OST-1995-369-0065 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 American Airlines, Inc. - Motion for leave to file/Responses Other Response(s) 1994-04-12T04:00:00Z 1994 4 1994-04-12T04:00:00Z 1994-04-13T03:59:59Z 2024-11-11T21:39:08Z   1 0 09000064802a1823
DOT-OST-1995-369-0063 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Delta Air Lines, Inc. - Reply Other Reply 1994-04-06T04:00:00Z 1994 4 1994-04-06T04:00:00Z 1994-04-07T03:59:59Z 2024-11-11T21:39:07Z   1 0 09000064802a1821
DOT-OST-1995-369-0064 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. and Lufthansa German Airlines - Consolidated Joint Reply Other Reply 1994-04-06T04:00:00Z 1994 4 1994-04-06T04:00:00Z 1994-04-07T03:59:59Z 2024-11-11T21:39:07Z   1 0 09000064802a1822
DOT-OST-1995-369-0059 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Air India, Ltd. - Response Other Response(s) 1994-04-01T05:00:00Z 1994 4 1994-04-01T05:00:00Z 1994-04-02T04:59:59Z 2024-11-11T21:38:54Z   1 0 09000064802a181c
DOT-OST-1995-369-0061 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Northwest Airlines, Inc. - Answer Other Answer 1994-04-01T05:00:00Z 1994 4 1994-04-01T05:00:00Z 1994-04-02T04:59:59Z 2024-11-11T21:39:07Z   1 0 09000064802a181f
DOT-OST-1995-369-0058 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. and Lufthansa German Airlines - Motion for Confidential Treatment Other Motion 1994-03-30T05:00:00Z 1994 3 1994-03-30T05:00:00Z 1994-03-31T04:59:59Z 2024-11-11T21:38:54Z   1 0 09000064802a181b
DOT-OST-1995-369-0057 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Notice To All Parties Notice Notice 1994-03-25T05:00:00Z 1994 3 1994-03-25T05:00:00Z 1994-03-26T04:59:59Z 2024-11-11T21:38:54Z   1 0 09000064802a181a
DOT-OST-1995-369-0056 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 94-1-19 Order (Approving the Joint Application) Other Order 1994-01-24T05:00:00Z 1994 1 1994-01-24T05:00:00Z 1994-01-25T04:59:59Z 2024-11-11T21:38:54Z   1 0 09000064802a1819
DOT-OST-1995-369-0054 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Northwest Airlines, Inc. - Reply/Motion for leave to file Other Motion/Reply 1994-01-21T05:00:00Z 1994 1 1994-01-21T05:00:00Z 1994-01-22T04:59:59Z 2024-11-11T21:38:53Z   1 0 09000064802a1817
DOT-OST-1995-369-0055 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. Consolidated Reply/Motion for leave to file Other Motion/Reply 1994-01-21T05:00:00Z 1994 1 1994-01-21T05:00:00Z 1994-01-22T04:59:59Z 2024-11-11T21:38:53Z   1 0 09000064802a1818
DOT-OST-1995-369-0050 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 American Airlines, Inc. - Answer Other Answer 1994-01-10T05:00:00Z 1994 1 1994-01-10T05:00:00Z 1994-01-11T04:59:59Z 2024-11-11T21:38:53Z   1 0 09000064802a1813
DOT-OST-1995-369-0051 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 The City of Chicago - Answer Other Answer 1994-01-10T05:00:00Z 1994 1 1994-01-10T05:00:00Z 1994-01-11T04:59:59Z 2024-11-11T21:38:53Z   1 0 09000064802a1814
DOT-OST-1995-369-0052 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Delta Air Lines, Inc. - Answer Other Answer 1994-01-10T05:00:00Z 1994 1 1994-01-10T05:00:00Z 1994-01-11T04:59:59Z 2024-11-11T21:38:53Z   1 0 09000064802a1815
DOT-OST-1995-369-0053 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 The City of Chicago - Motion for leave to file an otherwise unauthorized document/Supplemental Answer Other Motion/Answer 1994-01-10T05:00:00Z 1994 1 1994-01-10T05:00:00Z 1994-01-11T04:59:59Z 2024-11-11T21:38:53Z   1 0 09000064802a1816
DOT-OST-1995-369-0049 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Trans World Airlines, Inc. - Answer Other Answer 1994-01-07T05:00:00Z 1994 1 1994-01-07T05:00:00Z 1994-01-08T04:59:59Z 2024-11-11T21:38:36Z   1 0 09000064802a180f
DOT-OST-1995-369-0046-0002 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Lufthansa German Airlines - Consolidated Reply Other Reply 1994-01-05T05:00:00Z 1994 1 1994-01-05T05:00:00Z 1994-01-06T04:59:59Z 2024-11-11T21:38:36Z   1 0 09000064802a180a
DOT-OST-1995-369-0047-0002 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. - Consolidated Reply Other Reply 1994-01-05T05:00:00Z 1994 1 1994-01-05T05:00:00Z 1994-01-06T04:59:59Z 2024-11-11T21:38:36Z   1 0 09000064802a180c
DOT-OST-1995-369-0046-0001 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Lufthansa German Airlines - Consolidated Reply Other Reply 1994-01-05T05:00:00Z 1994 1 1994-01-05T05:00:00Z 1994-01-06T04:59:59Z 2024-11-11T21:38:35Z   1 0 09000064802a1809
DOT-OST-1995-369-0047-0001 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 United Air Lines, Inc. - Consolidated Reply Other Reply 1994-01-05T05:00:00Z 1994 1 1994-01-05T05:00:00Z 1994-01-06T04:59:59Z 2024-11-11T21:38:36Z   1 0 09000064802a180b
DOT-OST-1995-369-0048-0002 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Lufthansa German Airlines - Answer Other Answer 1994-01-05T05:00:00Z 1994 1 1994-01-05T05:00:00Z 1994-01-06T04:59:59Z 2024-11-11T21:38:36Z   1 0 09000064802a180e
DOT-OST-1995-369-0048-0001 DOT United Air Lines, Inc. and Lufthansa German Airlines - Exemption/Statement of Authorization - Code-Share and Blocked Space Services with U.S.-Germany Services DOT-OST-1995-369 Lufthansa German Airlines - Answer Other Answer 1994-01-05T05:00:00Z 1994 1 1994-01-05T05:00:00Z 1994-01-06T04:59:59Z 2024-11-11T21:38:36Z   1 0 09000064802a180d

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