documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
45 rows where docket_id = "DOT-OST-2001-9314" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_month, comment_end_date, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
agency_id 1
- DOT 45
| 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-2001-9314-0039 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Delta Air Lines, Inc. (Polling Letter) | Other | Letter(s) | 2015-11-06T05:00:00Z | 2015 | 11 | 2015-11-06T05:00:00Z | 2024-11-07T23:30:06Z | 1 | 0 | 0900006481d1ae49 | ||
| DOT-OST-2001-9314-0040 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Department Action on Application re: Delta Air Lines, Inc., China Southern Airlines Company Limited, and Compass Airlines, LLC | Other | Decision | 2015-11-06T05:00:00Z | 2015 | 11 | 2015-11-06T05:00:00Z | 2024-11-07T23:29:58Z | 1 | 0 | 0900006481d1cb33 | ||
| DOT-OST-2001-9314-0038 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc., China Southern Airlines Company Limited, and Compass Airlines, LLC for a Statement of Authorization | Other | Application-Other | 2015-11-03T05:00:00Z | 2015 | 11 | 2015-11-03T05:00:00Z | 2024-11-12T05:47:41Z | 1 | 0 | 0900006481d08d7d | ||
| DOT-OST-2001-9314-0037 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2015-10-09T04:00:00Z | 2015 | 10 | 2015-10-09T04:00:00Z | 2024-11-07T23:28:31Z | 1 | 0 | 0900006481cbf79c | ||
| DOT-OST-2001-9314-0036 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2014-12-03T05:00:00Z | 2014 | 12 | 2014-12-03T05:00:00Z | 2024-11-12T05:31:10Z | 1 | 0 | 0900006481958fda | ||
| DOT-OST-2001-9314-0035 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2013-12-05T05:00:00Z | 2013 | 12 | 2013-12-05T05:00:00Z | 2024-11-12T05:24:58Z | 1 | 0 | 09000064814ab577 | ||
| DOT-OST-2001-9314-0034 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2012-11-15T05:00:00Z | 2012 | 11 | 2012-11-15T05:00:00Z | 2024-11-12T05:07:43Z | 1 | 0 | 0900006481169524 | ||
| DOT-OST-2001-9314-0033 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Approval of Joint Application | Other | Decision | 2012-07-05T04:00:00Z | 2012 | 7 | 2012-07-05T04:00:00Z | 2012-07-05T18:45:41Z | 0 | 0 | 090000648107baff | ||
| DOT-OST-2001-9314-0032 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc., China Southern Airlines Company Limited, Comair, Inc. and Pinnacle Airlines, Inc. | Other | Application-Other | 2012-06-27T04:00:00Z | 2012 | 6 | 2012-06-27T04:00:00Z | 2024-11-07T22:39:42Z | 1 | 0 | 090000648106c006 | ||
| DOT-OST-2001-9314-0031 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2012-04-30T04:00:00Z | 2012 | 4 | 2012-04-30T04:00:00Z | 2012-04-30T14:02:59Z | 0 | 0 | 0900006481000bdc | ||
| DOT-OST-2001-9314-0030 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2012-04-24T04:00:00Z | 2012 | 4 | 2012-04-24T04:00:00Z | 2024-11-07T22:22:24Z | 1 | 0 | 0900006480ff747f | ||
| DOT-OST-2001-9314-0029 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemption Authorities | Other | Application-Other | 2011-12-22T05:00:00Z | 2011 | 12 | 2011-12-22T05:00:00Z | 2024-11-12T04:15:58Z | 1 | 0 | 0900006480f87f7d | ||
| DOT-OST-2001-9314-0028 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Approval of Motion of Delta Air Lines, Inc. For Leave To Withdraw | Other | Decision | 2011-10-27T04:00:00Z | 2011 | 10 | 2011-10-27T04:00:00Z | 2024-11-12T05:04:27Z | 1 | 0 | 0900006480f5e509 | ||
| DOT-OST-2001-9314-0027 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Action Taken re: Delta Air Lines, Inc. (Delta), SkyWest Airlines, Inc. (SkyWest), and China Southern Airlines Company Limited (China Southern) | Other | Decision | 2011-10-12T04:00:00Z | 2011 | 10 | 2011-10-12T04:00:00Z | 2011-10-12T18:59:53Z | 0 | 0 | 0900006480f50c4b | ||
| DOT-OST-2001-9314-0026 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Motion of Delta Air Lines, Inc. for Leave to Withdraw | Other | Motion | 2011-09-21T04:00:00Z | 2011 | 9 | 2011-09-21T04:00:00Z | 2013-07-28T00:03:52Z | 0 | 0 | 0900006480f267e6 | ||
| DOT-OST-2001-9314-0025 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemption and Certificate Authorities | Other | Application-Other | 2011-09-20T04:00:00Z | 2011 | 9 | 2011-09-20T04:00:00Z | 2013-08-11T01:43:43Z | 0 | 0 | 0900006480f2371f | ||
| DOT-OST-2001-9314-0024 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Delta Air Lines, Inc. | Other | Letter(s) | 2011-09-08T04:00:00Z | 2011 | 9 | 2011-09-08T04:00:00Z | 2013-08-11T03:17:06Z | 0 | 0 | 0900006480f13c32 | ||
| DOT-OST-2001-9314-0023 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc., China Southern Airlines Company Limited and SkyWest Airlines, Inc. for a Statement of Authorization and an Amended Exemption | Other | Application-Other | 2011-09-07T04:00:00Z | 2011 | 9 | 2011-09-07T04:00:00Z | 2013-07-28T00:02:44Z | 0 | 0 | 0900006480f135eb | ||
| DOT-OST-2001-9314-0022 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Notice | 2010-04-01T04:00:00Z | 2010 | 4 | 2010-04-01T04:00:00Z | 2024-11-12T04:51:53Z | 1 | 0 | 0900006480acdf4e | ||
| DOT-OST-2001-9314-0021 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Action Taken re: Delta Air Lines, Inc. (Delta) | Other | Notice | 2010-03-08T05:00:00Z | 2010 | 3 | 2010-03-08T05:00:00Z | 2024-11-12T04:50:30Z | 1 | 0 | 0900006480ab7ee6 | ||
| DOT-OST-2001-9314-0019 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemption Authority | Other | Application-Other | 2010-03-04T05:00:00Z | 2010 | 3 | 2010-03-04T05:00:00Z | 2024-11-12T04:49:57Z | 1 | 0 | 0900006480ab4de1 | ||
| DOT-OST-2001-9314-0020 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Delta Air Lines, Inc. | Other | Letter(s) | 2010-03-04T05:00:00Z | 2010 | 3 | 2010-03-04T05:00:00Z | 2024-11-12T04:50:18Z | 1 | 0 | 0900006480ab52ce | ||
| DOT-OST-2001-9314-0018 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Action Taken re: Delta Air Lines, Inc. (Delta) and China Southern Airlines Company Limited (China Southern) | Other | Notice | 2008-03-12T04:00:00Z | 2008 | 3 | 2008-03-12T04:00:00Z | 2013-07-27T20:37:27Z | 0 | 0 | 09000064803f28ec | ||
| DOT-OST-2001-9314-0017 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Notice | 2008-03-10T04:00:00Z | 2008 | 3 | 2013-07-27T20:37:18Z | 0 | 0 | 09000064803efec5 | |||
| DOT-OST-2001-9314-0016 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc. and China Southern Airlines Company Limited for Amended Statements of Authorization and Exemptions | Other | Application-Other | 2008-02-26T05:00:00Z | 2008 | 2 | 2008-02-26T05:00:00Z | 2024-11-07T21:50:42Z | 1 | 0 | 09000064803c8247 | ||
| DOT-OST-2001-9314-0015 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemption Authority | Other | Application-Other | 2008-02-06T05:00:00Z | 2008 | 2 | 2008-02-06T05:00:00Z | 2024-11-07T21:50:06Z | 1 | 0 | 09000064803a9846 | ||
| DOT-OST-2001-9314-0014 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Action Taken re: Delta Air Lines, Inc. (Delta) and China Southern Airlines Company Limited (China Southern) | Notice | Notice | 2006-04-10T04:00:00Z | 2006 | 4 | 2006-04-10T04:00:00Z | 2006-04-11T03:59:59Z | 2024-11-07T16:52:52Z | 1 | 0 | 09000064802ba75f | |
| DOT-OST-2001-9314-0013-0003 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc. and China Southern Airlines Company Limited for Amended Statements of Authorization and Exemptions | Other | Application-Other | 2005-12-22T05:00:00Z | 2005 | 12 | 2005-12-22T05:00:00Z | 2005-12-23T04:59:59Z | 2024-11-07T16:52:52Z | 1 | 0 | 09000064802ba75d | |
| DOT-OST-2001-9314-0013-0001 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc. and China Southern Airlines Company Limited for Amended Statements of Authorization and Exemptions | Other | Application-Other | 2005-12-22T05:00:00Z | 2005 | 12 | 2005-12-22T05:00:00Z | 2005-12-23T04:59:59Z | 2024-11-07T16:52:51Z | 1 | 0 | 09000064802ba75b | |
| DOT-OST-2001-9314-0013-0002 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc. and China Southern Airlines Company Limited for Amended Statements of Authorization and Exemptions | Other | Application-Other | 2005-12-22T05:00:00Z | 2005 | 12 | 2005-12-22T05:00:00Z | 2005-12-23T04:59:59Z | 2024-11-07T16:52:52Z | 1 | 0 | 09000064802ba75c | |
| DOT-OST-2001-9314-0013-0004 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc. and China Southern Airlines Company Limited for Amended Statements of Authorization and Exemptions | Other | Application-Other | 2005-12-22T05:00:00Z | 2005 | 12 | 2005-12-22T05:00:00Z | 2005-12-23T04:59:59Z | 2024-11-07T16:52:52Z | 1 | 0 | 09000064802ba75e | |
| DOT-OST-2001-9314-0012-0001 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemptions | Other | Application-Other | 2004-06-07T04:00:00Z | 2004 | 6 | 2004-06-07T04:00:00Z | 2004-06-08T03:59:59Z | 2024-11-07T16:52:27Z | 1 | 0 | 09000064802ba759 | |
| DOT-OST-2001-9314-0012-0002 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemptions | Other | Application-Other | 2004-06-07T04:00:00Z | 2004 | 6 | 2004-06-07T04:00:00Z | 2004-06-08T03:59:59Z | 2024-11-07T16:52:28Z | 1 | 0 | 09000064802ba75a | |
| DOT-OST-2001-9314-0011 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Notice of Action Taken re: Delta Air Lines, Inc. | Notice | Notice | 2002-11-06T05:00:00Z | 2002 | 11 | 2002-11-06T05:00:00Z | 2002-11-08T04:59:59Z | 2008-01-07T23:37:55Z | 0 | 0 | 0900006480382871 | |
| DOT-OST-2001-9314-0010-0001 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemptions | Other | Application-Other | 2002-10-01T04:00:00Z | 2002 | 10 | 2002-10-01T04:00:00Z | 2002-10-02T03:59:59Z | 2024-11-07T16:52:28Z | 1 | 0 | 09000064802ba756 | |
| DOT-OST-2001-9314-0010-0002 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Application of Delta Air Lines, Inc. for Renewal of Exemptions | Other | Application-Other | 2002-10-01T04:00:00Z | 2002 | 10 | 2002-10-01T04:00:00Z | 2002-10-02T03:59:59Z | 2024-11-07T16:52:28Z | 1 | 0 | 09000064802ba758 | |
| DOT-OST-2001-9314-0009 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | 2001-7-10 Order | Other | Order | 2001-07-17T04:00:00Z | 2001 | 7 | 2001-07-17T04:00:00Z | 2001-08-02T03:59:59Z | 2024-11-07T16:53:17Z | 1 | 0 | 09000064802ba767 | |
| DOT-OST-2001-9314-0008 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Motion for Leave to File and Response of Delta Air Lines | Other | Motion | 2001-05-25T04:00:00Z | 2001 | 5 | 2001-05-25T04:00:00Z | 2001-05-26T03:59:59Z | 2024-11-07T16:53:17Z | 1 | 0 | 09000064802ba766 | |
| DOT-OST-2001-9314-0007 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Surreply of Northwest Airlines, Inc. and Motion for Leave to File | Other | Motion/Surreply | 2001-05-18T04:00:00Z | 2001 | 5 | 2001-05-18T04:00:00Z | 2001-05-19T03:59:59Z | 2024-11-07T16:53:17Z | 1 | 0 | 09000064802ba765 | |
| DOT-OST-2001-9314-0006 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Consolidated Reply of Delta Air Lines, Inc. to Answers of Northwest Airlines, Inc. and American Airlines, Inc. | Other | Consolidated Answer | 2001-05-08T04:00:00Z | 2001 | 5 | 2001-05-08T04:00:00Z | 2001-05-09T03:59:59Z | 2024-11-07T16:53:17Z | 1 | 0 | 09000064802ba764 | |
| DOT-OST-2001-9314-0005 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Consolidated answer of Northwest Airlines, Inc. | Other | Consolidated Answer | 2001-04-27T04:00:00Z | 2001 | 4 | 2001-04-27T04:00:00Z | 2001-04-28T03:59:59Z | 2024-11-07T16:53:17Z | 1 | 0 | 09000064802ba763 | |
| DOT-OST-2001-9314-0004 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Answer of Delta Air Lines, Inc. to Application of American Airlines, Inc. and Motion for Leave to File Additional Comments to Applications of Northwest/Air China and Delta/China Southern | Other | Motion/Answer | 2001-04-24T04:00:00Z | 2001 | 4 | 2001-04-24T04:00:00Z | 2001-04-25T03:59:59Z | 2024-11-07T16:53:17Z | 1 | 0 | 09000064802ba762 | |
| DOT-OST-2001-9314-0003 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Letter of Northwest Airlines, Inc. | Other | Letter(s) | 2001-04-16T04:00:00Z | 2001 | 4 | 2001-04-16T04:00:00Z | 2001-04-17T03:59:59Z | 2024-11-07T16:53:16Z | 1 | 0 | 09000064802ba761 | |
| DOT-OST-2001-9314-0002 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Motion for Leave to File Late and Consolidated Answer of American Airlines, Inc. | Other | Motion/Answer | 2001-04-12T04:00:00Z | 2001 | 4 | 2001-04-12T04:00:00Z | 2001-04-13T03:59:59Z | 2024-11-07T16:52:52Z | 1 | 0 | 09000064802ba760 | |
| DOT-OST-2001-9314-0001 | DOT | Delta Air Lines, Inc. and China Southern Airlines Company Limited - Exemption/Statement of Authorization - United States-People's Republic of China - 2001 DOT-OST-2001-9314 | Joint Application of Delta Air Lines, Inc. and China Southern Airlines Company Limited for an Exemption and Statement of Authorization | Other | Application-Other | 2001-03-30T05:00:00Z | 2001 | 3 | 2001-03-30T05:00:00Z | 2001-03-31T04:59:59Z | 2024-11-07T16:52:27Z | 1 | 0 | 09000064802ba753 |
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;