documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
55 rows where docket_id = "DOT-OST-2001-10172" sorted by posted_date descending
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 13
agency_id 1
- DOT 55
| 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-10172-0049 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:40Z | 1 | 0 | 0900006481d1c8df | ||
| DOT-OST-2001-10172-0048 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 0900006481d1ae4b | ||
| DOT-OST-2001-10172-0047 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:49:19Z | 1 | 0 | 0900006481d08bb2 | ||
| DOT-OST-2001-10172-0046 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:32Z | 1 | 0 | 0900006481cbf79e | ||
| DOT-OST-2001-10172-0045 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:30:01Z | 1 | 0 | 0900006481959281 | ||
| DOT-OST-2001-10172-0044 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:25:01Z | 1 | 0 | 09000064814ab5c4 | ||
| DOT-OST-2001-10172-0043 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:06:07Z | 1 | 0 | 0900006481169526 | ||
| DOT-OST-2001-10172-0042 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Approval of Joint Application | Other | Decision | 2012-07-05T04:00:00Z | 2012 | 7 | 2012-07-05T04:00:00Z | 2012-07-05T18:47:59Z | 0 | 0 | 090000648107bb01 | ||
| DOT-OST-2001-10172-0041 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:40:50Z | 1 | 0 | 090000648106c008 | ||
| DOT-OST-2001-10172-0040 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 2024-11-07T22:24:22Z | 1 | 0 | 0900006481000bde | ||
| DOT-OST-2001-10172-0039 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:20:10Z | 1 | 0 | 0900006480ff74a0 | ||
| DOT-OST-2001-10172-0038 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-07T23:55:25Z | 1 | 0 | 0900006480f87f7f | ||
| DOT-OST-2001-10172-0037 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:36Z | 1 | 0 | 0900006480f5e505 | ||
| DOT-OST-2001-10172-0036 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 2024-11-07T22:42:25Z | 1 | 0 | 0900006480f50c4d | ||
| DOT-OST-2001-10172-0035 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Motion of Delta Air Lines, Inc. for Leave to Withdraw | Other | Motion | 2011-09-21T04:00:00Z | 2011 | 9 | 2011-09-21T04:00:00Z | 2024-11-12T05:03:13Z | 1 | 0 | 0900006480f267e4 | ||
| DOT-OST-2001-10172-0034 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 2024-11-12T05:02:27Z | 1 | 0 | 0900006480f2371b | ||
| DOT-OST-2001-10172-0033 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Delta Air Lines, Inc. | Other | Letter(s) | 2011-09-08T04:00:00Z | 2011 | 9 | 2011-09-08T04:00:00Z | 2013-07-28T00:02:45Z | 0 | 0 | 0900006480f13c50 | ||
| DOT-OST-2001-10172-0032 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 2024-11-12T05:02:18Z | 1 | 0 | 0900006480f135ed | ||
| DOT-OST-2001-10172-0031 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 2011-1-22 Order Dismissing Applications/Notice | Other | Order | 2011-01-25T05:00:00Z | 2011 | 1 | 2011-01-25T05:00:00Z | 2011-01-25T14:36:19Z | 0 | 0 | 0900006480bd1f32 | ||
| DOT-OST-2001-10172-0030 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:52:00Z | 1 | 0 | 0900006480acdf9f | ||
| DOT-OST-2001-10172-0029 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:11Z | 1 | 0 | 0900006480ab7ee9 | ||
| DOT-OST-2001-10172-0028 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 0900006480ab5390 | ||
| DOT-OST-2001-10172-0027 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:50:13Z | 1 | 0 | 0900006480ab4de2 | ||
| DOT-OST-2001-10172-0026 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-08-11T02:30:39Z | 0 | 0 | 09000064803f2914 | ||
| DOT-OST-2001-10172-0025 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Notice of Delta Air Lines, Inc. and China Southern Airlines Company Limited | Other | Letter(s) | 2008-03-10T04:00:00Z | 2008 | 3 | 2024-11-07T21:51:13Z | 1 | 0 | 09000064803efe1f | |||
| DOT-OST-2001-10172-0024 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Delta Air Lines, Inc. and China Southern Airlines Company | Other | Letter(s) | 2008-02-28T05:00:00Z | 2008 | 2 | 2008-02-28T05:00:00Z | 2013-07-27T20:36:27Z | 0 | 0 | 09000064803cfd8a | ||
| DOT-OST-2001-10172-0023 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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:46Z | 1 | 0 | 09000064803c824d | ||
| DOT-OST-2001-10172-0022 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Delta Air Lines, Inc. | Other | Correspondence | 2008-02-06T05:00:00Z | 2008 | 2 | 2008-02-06T05:00:00Z | 2013-07-27T20:33:30Z | 0 | 0 | 09000064803a94e5 | ||
| DOT-OST-2001-10172-0021 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:40Z | 1 | 0 | 09000064802bcb8d | |
| DOT-OST-2001-10172-0020-0001 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:20Z | 1 | 0 | 09000064802bcb89 | |
| DOT-OST-2001-10172-0020-0003 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:39Z | 1 | 0 | 09000064802bcb8b | |
| DOT-OST-2001-10172-0020-0002 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:39Z | 1 | 0 | 09000064802bcb8a | |
| DOT-OST-2001-10172-0020-0004 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:39Z | 1 | 0 | 09000064802bcb8c | |
| DOT-OST-2001-10172-0019 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Application of American Airlines, Inc. for Renewal of Exemption Authority | Other | Application-Other | 2005-03-30T05:00:00Z | 2005 | 3 | 2005-03-30T05:00:00Z | 2005-03-31T04:59:59Z | 2024-11-11T22:29:20Z | 1 | 0 | 09000064802bcb87 | |
| DOT-OST-2001-10172-0018-0001 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:20Z | 1 | 0 | 09000064802bcb85 | |
| DOT-OST-2001-10172-0018-0002 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:29:20Z | 1 | 0 | 09000064802bcb86 | |
| DOT-OST-2001-10172-0017 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Notice of Action Taken re Northwest Airlines, Inc. and Air China International Corp. | Notice | Notice | 2003-10-06T04:00:00Z | 2003 | 10 | 2003-10-06T04:00:00Z | 2003-10-07T03:59:59Z | 2024-11-11T22:29:19Z | 1 | 0 | 09000064802bcb84 | |
| DOT-OST-2001-10172-0016-0002 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Amendment to Joint Application of Northwest Airlines, Inc. and Air China International Corp. | Other | Amendment | 2003-07-18T04:00:00Z | 2003 | 7 | 2003-07-18T04:00:00Z | 2003-07-22T03:59:59Z | 2024-11-07T21:45:57Z | 1 | 0 | 090000648038299a | |
| DOT-OST-2001-10172-0016-0001 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Amendment to Joint Application of Northwest Airlines, Inc. and Air China International Corp. | Other | Amendment | 2003-07-18T04:00:00Z | 2003 | 7 | 2003-07-18T04:00:00Z | 2003-07-22T03:59:59Z | 2024-11-07T21:45:57Z | 1 | 0 | 0900006480382999 | |
| DOT-OST-2001-10172-0015 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Northwest Airlines, Inc. | Notice | Notice | 2003-06-30T04:00:00Z | 2003 | 6 | 2003-06-30T04:00:00Z | 2003-07-01T03:59:59Z | 2024-11-07T21:45:57Z | 1 | 0 | 0900006480382998 | |
| DOT-OST-2001-10172-0014 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Notice of Action Taken re: American Airlines, Inc. | Notice | Notice | 2003-06-02T04:00:00Z | 2003 | 6 | 2003-06-02T04:00:00Z | 2003-06-03T03:59:59Z | 2024-11-11T22:29:19Z | 1 | 0 | 09000064802bcb83 | |
| DOT-OST-2001-10172-0013 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Application of American Airlines, Inc. for Renewal of Exemption Authority | Other | Application-Other | 2003-05-08T04:00:00Z | 2003 | 5 | 2003-05-08T04:00:00Z | 2003-05-09T03:59:59Z | 2024-11-11T22:29:19Z | 1 | 0 | 09000064802bcb82 | |
| DOT-OST-2001-10172-0012 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Northwest Airlines, Inc. | Other | Letter(s) | 2003-04-02T05:00:00Z | 2003 | 4 | 2003-04-02T05:00:00Z | 2003-04-03T04:59:59Z | 2024-11-11T22:28:57Z | 1 | 0 | 09000064802bcb81 | |
| DOT-OST-2001-10172-0011 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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 | 2024-11-07T21:45:57Z | 1 | 0 | 0900006480382997 | |
| DOT-OST-2001-10172-0010-0002 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:28:56Z | 1 | 0 | 09000064802bcb80 | |
| DOT-OST-2001-10172-0010-0001 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:28:56Z | 1 | 0 | 09000064802bcb7f | |
| DOT-OST-2001-10172-0009 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Notice of Action Taken re: China Eastern Airlines Corporation Limited | Notice | Notice | 2002-09-09T04:00:00Z | 2002 | 9 | 2002-09-09T04:00:00Z | 2002-09-10T03:59:59Z | 2024-11-11T22:30:05Z | 1 | 0 | 09000064802bcb95 | |
| DOT-OST-2001-10172-0008-0001 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Application of China Eastern Airlines Corporation Limited For Renewal of Exemption Authority | Other | Application-Other | 2002-07-12T04:00:00Z | 2002 | 7 | 2002-07-12T04:00:00Z | 2002-07-13T03:59:59Z | 2024-11-11T22:30:04Z | 1 | 0 | 09000064802bcb93 | |
| DOT-OST-2001-10172-0008-0002 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Application of China Eastern Airlines Corporation Limited For Renewal of Exemption Authority | Other | Application-Other | 2002-07-12T04:00:00Z | 2002 | 7 | 2002-07-12T04:00:00Z | 2002-07-13T03:59:59Z | 2024-11-11T22:30:05Z | 1 | 0 | 09000064802bcb94 | |
| DOT-OST-2001-10172-0007 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Joint Application of Northwest Airlines, Inc. and China International Corp. for Renewal of and Consolidation of Exemptions and Statements of Authorization | Other | Application-Other | 2001-09-10T04:00:00Z | 2001 | 9 | 2001-09-10T04:00:00Z | 2001-09-11T03:59:59Z | 2024-11-11T22:30:04Z | 1 | 0 | 09000064802bcb92 | |
| DOT-OST-2001-10172-0006 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Notice of Action Taken re: 2001-China Code-share Points Case | Notice | Notice | 2001-08-23T04:00:00Z | 2001 | 8 | 2001-08-23T04:00:00Z | 2001-08-24T03:59:59Z | 2024-11-11T22:30:04Z | 1 | 0 | 09000064802bcb91 | |
| DOT-OST-2001-10172-0004 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Notice of Delta Air Lines, Inc. | Notice | Notice | 2001-08-22T04:00:00Z | 2001 | 8 | 2001-08-22T04:00:00Z | 2001-08-23T03:59:59Z | 2024-11-11T22:29:40Z | 1 | 0 | 09000064802bcb8f | |
| DOT-OST-2001-10172-0005 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | Selection by American Airlines, Inc. of Additional China Codeshare Point | Notice | Notice | 2001-08-22T04:00:00Z | 2001 | 8 | 2001-08-22T04:00:00Z | 2001-08-23T03:59:59Z | 2024-11-11T22:30:04Z | 1 | 0 | 09000064802bcb90 | |
| DOT-OST-2001-10172-0003 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 2001-8-16 Final Order | Other | Order | 2001-08-17T04:00:00Z | 2001 | 8 | 2001-08-17T04:00:00Z | 2001-08-18T03:59:59Z | 2024-11-11T22:29:40Z | 1 | 0 | 09000064802bcb8e | |
| DOT-OST-2001-10172-0001 | DOT | 2001 China Code-Share Points Case DOT-OST-2001-10172 | 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-11T22:28:56Z | 1 | 0 | 09000064802bcb7e |
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;