documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
49 rows where docket_id = "DOT-OST-2001-10833" 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)
posted_year 14
agency_id 1
- DOT 49
| 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-10833-0037 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Delta Air Lines, Inc. for Renewal of an Exemption | Other | Application-Other | 2021-12-02T05:00:00Z | 2021 | 12 | 2021-12-02T05:00:00Z | 2024-11-12T23:34:49Z | 1 | 0 | 0900006484e8f6eb | ||
| DOT-OST-2001-10833-0036 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Delta Air Lines, Inc. | Other | Decision | 2020-01-31T05:00:00Z | 2020 | 1 | 2020-01-31T05:00:00Z | 2024-11-12T23:17:12Z | 1 | 0 | 090000648431942c | ||
| DOT-OST-2001-10833-0035 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Delta Air Lines, Inc. for Renewal of an Exemption | Other | Application-Other | 2019-12-26T05:00:00Z | 2019 | 12 | 2019-12-26T05:00:00Z | 2024-11-12T23:14:45Z | 1 | 0 | 09000064842505d2 | ||
| DOT-OST-2001-10833-0034 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Response of the Delta Master Executive Council of the Air Line Pilots Association, International | Other | Response(s) | 2019-10-09T04:00:00Z | 2019 | 10 | 2019-10-09T04:00:00Z | 2024-11-12T23:09:41Z | 1 | 0 | 090000648406d447 | ||
| DOT-OST-2001-10833-0033 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Correspondence | 2019-09-09T04:00:00Z | 2019 | 9 | 2019-09-09T04:00:00Z | 2024-11-12T23:08:05Z | 1 | 0 | 0900006483f20221 | ||
| DOT-OST-2001-10833-0032 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Correspondence | 2019-08-06T04:00:00Z | 2019 | 8 | 2019-08-06T04:00:00Z | 2024-11-12T23:06:42Z | 1 | 0 | 0900006483dfb758 | ||
| DOT-OST-2001-10833-0031 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Correspondence | 2019-08-06T04:00:00Z | 2019 | 8 | 2019-08-06T04:00:00Z | 2024-11-12T23:06:09Z | 1 | 0 | 0900006483df9e4d | ||
| DOT-OST-2001-10833-0030 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Aerovias de Mexico, S.A. de C.V. for Renewal and Consolidation of Exemptions and Special Authorizations | Other | Application-Other | 2016-12-21T05:00:00Z | 2016 | 12 | 2016-12-21T05:00:00Z | 2024-11-07T23:52:08Z | 1 | 0 | 090000648242ec6b | ||
| DOT-OST-2001-10833-0029 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Additional Information | 2014-06-11T04:00:00Z | 2014 | 6 | 2014-06-11T04:00:00Z | 2024-11-11T20:51:36Z | 1 | 0 | 0900006481720f44 | ||
| DOT-OST-2001-10833-0028 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Approval of 30-day Notice of Additional Codesharing Points | Other | Decision | 2014-06-04T04:00:00Z | 2014 | 6 | 2014-06-04T04:00:00Z | 2014-06-04T15:28:10Z | 0 | 0 | 0900006481728b7d | ||
| DOT-OST-2001-10833-0027 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Aerovias de Mexico, S.A. de C.V. for Renewal of Special Authorization | Other | Application-Other | 2014-05-15T04:00:00Z | 2014 | 5 | 2014-05-15T04:00:00Z | 2024-11-11T20:52:16Z | 1 | 0 | 09000064816fcfd7 | ||
| DOT-OST-2001-10833-0026 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Delta Air Lines, Inc. | Other | Decision | 2014-04-08T04:00:00Z | 2014 | 4 | 2014-04-08T04:00:00Z | 2014-04-08T20:48:56Z | 0 | 0 | 09000064816a9b09 | ||
| DOT-OST-2001-10833-0025 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Delta Air Lines, Inc. for Renewal of Exemption Authorities | Other | Application-Other | 2014-03-04T05:00:00Z | 2014 | 3 | 2014-03-04T05:00:00Z | 2024-11-12T05:25:21Z | 1 | 0 | 09000064815f20a5 | ||
| DOT-OST-2001-10833-0024 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Aerovias De Mexico, S.A. de C.V. | Other | Decision | 2013-05-21T04:00:00Z | 2013 | 5 | 2013-05-21T04:00:00Z | 2024-11-12T05:19:05Z | 1 | 0 | 09000064812f0eb4 | ||
| DOT-OST-2001-10833-0023 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Aerovias de Mexico, S.A. de C.V. for Renewal of Special Authorization | Other | Application-Other | 2013-04-16T04:00:00Z | 2013 | 4 | 2013-04-16T04:00:00Z | 2024-11-11T20:44:53Z | 1 | 0 | 09000064812964b4 | ||
| DOT-OST-2001-10833-0022 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Additional Information | 2012-08-13T04:00:00Z | 2012 | 8 | 2012-08-13T04:00:00Z | 2012-08-13T20:37:40Z | 0 | 0 | 09000064810d342e | ||
| DOT-OST-2001-10833-0021 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Delta Air Lines, Inc. (Delta), ExpressJet Airlines, Inc. (ExpressJet) , Comair, Inc. (Comair), Pinnacle Airlines, Inc. (Pinnacle), SkyWest Airlines, Inc. (SkyWest), Aerovias de Mexico, S.A. de C.V. (Aeromexico), and Aerolitoral, S.A. de C.V. d/b/a Aeromexico Connect (Aerolitoral) | Other | Decision | 2012-04-19T04:00:00Z | 2012 | 4 | 2012-04-19T04:00:00Z | 2024-11-07T22:18:37Z | 1 | 0 | 0900006480ff458d | ||
| DOT-OST-2001-10833-0020 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Delta Air Lines, Inc. (Polling Letter) | Other | Letter(s) | 2012-04-16T04:00:00Z | 2012 | 4 | 2012-04-16T04:00:00Z | 2024-11-07T22:41:15Z | 1 | 0 | 0900006480ff1d0d | ||
| DOT-OST-2001-10833-0019 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Joint Application for Amended Statements of Authorization and Special Authorization, and Renewal and Amendment of Exemption Authority | Other | Application-Other | 2012-04-12T04:00:00Z | 2012 | 4 | 2012-04-12T04:00:00Z | 2024-11-12T04:47:14Z | 1 | 0 | 0900006480fee56a | ||
| DOT-OST-2001-10833-0018 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Notice | 2009-08-27T04:00:00Z | 2009 | 8 | 2009-08-27T04:00:00Z | 2024-11-12T04:41:00Z | 1 | 0 | 0900006480a15709 | ||
| DOT-OST-2001-10833-0017 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Notice | 2009-07-15T04:00:00Z | 2009 | 7 | 2009-07-15T04:00:00Z | 2024-11-12T04:42:19Z | 1 | 0 | 09000064809f212f | ||
| DOT-OST-2001-10833-0016 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Delta Air Lines, Inc. for Renewal of Exemptions | Other | Application-Other | 2009-05-05T04:00:00Z | 2009 | 5 | 2009-05-05T04:00:00Z | 2013-08-11T04:33:10Z | 0 | 0 | 090000648097693c | ||
| DOT-OST-2001-10833-0015 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Other | Notice | 2009-04-02T04:00:00Z | 2009 | 4 | 2009-04-02T04:00:00Z | 2013-07-27T22:41:46Z | 0 | 0 | 090000648093d2db | ||
| DOT-OST-2001-10833-0014 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Delta Air Lines, Inc. (Corrected Copy) | Other | Notice | 2009-03-27T04:00:00Z | 2009 | 3 | 2009-03-27T04:00:00Z | 2013-08-11T01:26:35Z | 0 | 0 | 0900006480932001 | ||
| DOT-OST-2001-10833-0013 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Delta Air Lines, Inc. | Other | Notice | 2009-03-25T04:00:00Z | 2009 | 3 | 2009-03-25T04:00:00Z | 2013-07-27T22:41:06Z | 0 | 0 | 090000648092ecc7 | ||
| DOT-OST-2001-10833-0012 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Aerolitoral, S.A. de C.V. d/b/a Aeromexico Connect | Other | Letter(s) | 2009-03-23T04:00:00Z | 2009 | 3 | 2009-03-23T04:00:00Z | 2013-08-11T03:00:51Z | 0 | 0 | 09000064809282cc | ||
| DOT-OST-2001-10833-0011 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Aerolitoral, S.A. de C.V. d/b/a Aeromexico Connect | Other | Correspondence | 2009-03-23T04:00:00Z | 2009 | 3 | 2009-03-23T04:00:00Z | 2013-07-27T22:40:39Z | 0 | 0 | 09000064809281a5 | ||
| DOT-OST-2001-10833-0010 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Delta for an Amended Exemption | Other | Application-Other | 2009-03-09T04:00:00Z | 2009 | 3 | 2009-03-09T04:00:00Z | 2013-07-27T22:39:44Z | 0 | 0 | 090000648090149c | ||
| DOT-OST-2001-10833-0009 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Aerolitoral, S.A. de C.V. D/B/A Aeromexico Connect (Corrected Copy) | Other | Notice | 2008-01-29T05:00:00Z | 2008 | 1 | 2008-01-29T05:00:00Z | 2013-07-28T01:29:49Z | 0 | 0 | 09000064803a4065 | ||
| DOT-OST-2001-10833-0008 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Notice of Action Taken re: Aerolitoral, S.A. de C.V. D/B/A/ Aeromexico Connect | Other | Notice | 2007-12-12T05:00:00Z | 2007 | 12 | 2007-12-12T05:00:00Z | 2013-07-27T20:28:07Z | 0 | 0 | 0900006480379297 | ||
| DOT-OST-2001-10833-0007 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Application of Aerolitoral, S.A. de C.V. d/b/a Aeromexico Connect for Amendment | Other | Application-Other | 2007-11-28T05:00:00Z | 2007 | 11 | 2007-11-28T05:00:00Z | 2013-07-27T20:27:16Z | 0 | 0 | 09000064803695d0 | ||
| DOT-OST-2001-10833-0006-0002 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-12-20T05:00:00Z | 2006 | 12 | 2006-12-20T05:00:00Z | 2006-12-21T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b763a | |
| DOT-OST-2001-10833-0006-0001 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-12-20T05:00:00Z | 2006 | 12 | 2006-12-20T05:00:00Z | 2006-12-21T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b7639 | |
| DOT-OST-2001-10833-0006-0003 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-12-20T05:00:00Z | 2006 | 12 | 2006-12-20T05:00:00Z | 2006-12-21T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b763b | |
| DOT-OST-2001-10833-0005-0001 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-07-31T04:00:00Z | 2006 | 7 | 2006-07-31T04:00:00Z | 2006-08-01T03:59:59Z | 2008-01-07T23:07:18Z | 0 | 0 | 0900006480382bd4 | |
| DOT-OST-2001-10833-0005-0004 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-07-31T04:00:00Z | 2006 | 7 | 2006-07-31T04:00:00Z | 2006-08-01T03:59:59Z | 2008-01-07T23:07:18Z | 0 | 0 | 0900006480382bd8 | |
| DOT-OST-2001-10833-0005-0005 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-07-31T04:00:00Z | 2006 | 7 | 2006-07-31T04:00:00Z | 2006-08-01T03:59:59Z | 2008-01-07T23:07:18Z | 0 | 0 | 0900006480382bd9 | |
| DOT-OST-2001-10833-0005-0003 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-07-31T04:00:00Z | 2006 | 7 | 2006-07-31T04:00:00Z | 2006-08-01T03:59:59Z | 2008-01-07T23:44:02Z | 0 | 0 | 0900006480382bd6 | |
| DOT-OST-2001-10833-0005-0002 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Regarding Additional Codesharing Points | Notice | Notice | 2006-07-31T04:00:00Z | 2006 | 7 | 2006-07-31T04:00:00Z | 2006-08-01T03:59:59Z | 2008-01-07T23:37:54Z | 0 | 0 | 0900006480382bd5 | |
| DOT-OST-2001-10833-0004-0004 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b7635 | |
| DOT-OST-2001-10833-0004-0001 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:00Z | 1 | 0 | 09000064802b7632 | |
| DOT-OST-2001-10833-0004-0006 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b7637 | |
| DOT-OST-2001-10833-0004-0007 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b7638 | |
| DOT-OST-2001-10833-0004-0003 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:00Z | 1 | 0 | 09000064802b7634 | |
| DOT-OST-2001-10833-0004-0002 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:00Z | 1 | 0 | 09000064802b7633 | |
| DOT-OST-2001-10833-0004-0005 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice Re: Behind-Gateway Codeshare Integration | Notice | Notice | 2003-11-19T05:00:00Z | 2003 | 11 | 2003-11-19T05:00:00Z | 2003-11-20T04:59:59Z | 2024-11-08T04:15:01Z | 1 | 0 | 09000064802b7636 | |
| DOT-OST-2001-10833-0003 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | 30-Day Notice of Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. (Intra-Mexico Code Sharing) | Notice | Notice | 2002-02-05T05:00:00Z | 2002 | 2 | 2002-02-05T05:00:00Z | 2002-02-06T04:59:59Z | 2024-11-08T04:15:00Z | 1 | 0 | 09000064802b7631 | |
| DOT-OST-2001-10833-0002 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Approval of Application | Other | Decision | 2001-10-30T05:00:00Z | 2001 | 10 | 2001-10-30T05:00:00Z | 2001-10-31T04:59:59Z | 2024-11-08T04:14:32Z | 1 | 0 | 09000064802b7630 | |
| DOT-OST-2001-10833-0001 | DOT | Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. - Statements of Authorization DOT-OST-2001-10833 | Joint Application of Delta Air Lines, Inc. and Aerolitoral, S.A. de C.V. for Statements of Authorization | Other | Joint Application | 2001-10-12T04:00:00Z | 2001 | 10 | 2001-10-12T04:00:00Z | 2001-10-13T03:59:59Z | 2024-11-08T04:14:32Z | 1 | 0 | 09000064802b762f |
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;