documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
46 rows where docket_id = "DOT-OST-1996-1909" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, subtype, posted_month, comment_end_date, last_modified, open_for_comment, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
posted_year 23
agency_id 1
- DOT 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DOT-OST-1996-1909-0041 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Other | Decision | 2026-01-23T05:00:00Z | 2026 | 1 | 2026-01-23T05:00:00Z | 2026-01-24T00:13:25Z | 1 | 0 | 09000064b917d59b | ||
| DOT-OST-1996-1909-0040 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption Filed by Taxi Aereo de Veracurz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2025-11-25T05:00:00Z | 2025 | 11 | 2025-11-25T05:00:00Z | 2025-11-25T19:09:21Z | 1 | 0 | 09000064b90997f0 | ||
| DOT-OST-1996-1909-0039 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Other | Decision | 2023-12-27T05:00:00Z | 2023 | 12 | 2023-12-27T05:00:00Z | 2024-11-12T06:24:42Z | 1 | 0 | 090000648635d65a | ||
| DOT-OST-1996-1909-0038 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption Filed by Taxi Aereo de Veracurz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2021-12-21T05:00:00Z | 2021 | 12 | 2021-12-21T05:00:00Z | 2024-11-07T00:34:41Z | 1 | 0 | 0900006484edded6 | ||
| DOT-OST-1996-1909-0037 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Other | Decision | 2020-01-23T05:00:00Z | 2020 | 1 | 2020-01-23T05:00:00Z | 2024-11-12T23:16:10Z | 1 | 0 | 09000064842de8c6 | ||
| DOT-OST-1996-1909-0036 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption Filed by Taxi Aereo de Veracurz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2019-10-09T04:00:00Z | 2019 | 10 | 2019-10-09T04:00:00Z | 2024-11-12T23:10:15Z | 1 | 0 | 0900006484067a76 | ||
| DOT-OST-1996-1909-0035 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Other | Decision | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T05:00:00Z | 2024-11-07T01:09:28Z | 1 | 0 | 0900006482c62efb | ||
| DOT-OST-1996-1909-0034 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption Filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2017-08-09T04:00:00Z | 2017 | 8 | 2017-08-09T04:00:00Z | 2024-11-07T01:03:22Z | 1 | 0 | 09000064829e9261 | ||
| DOT-OST-1996-1909-0033 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. (September 4, 2015) | Other | Decision | 2017-07-28T04:00:00Z | 2017 | 7 | 2017-07-28T04:00:00Z | 2024-11-07T01:07:49Z | 1 | 0 | 090000648297f7f9 | ||
| DOT-OST-1996-1909-0032 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2015-08-21T04:00:00Z | 2015 | 8 | 2015-08-21T04:00:00Z | 2024-11-12T05:42:17Z | 1 | 0 | 0900006481c2b099 | ||
| DOT-OST-1996-1909-0031 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Apoyo Aereo, S.A. de C.V. | Other | Decision | 2015-08-12T04:00:00Z | 2015 | 8 | 2015-08-12T04:00:00Z | 2015-08-12T17:52:54Z | 0 | 0 | 0900006481c1ace0 | ||
| DOT-OST-1996-1909-0030 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2013-08-21T04:00:00Z | 2013 | 8 | 2024-11-07T22:54:59Z | 1 | 0 | 09000064813b9299 | |||
| DOT-OST-1996-1909-0029 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Other | Decision | 2011-09-07T04:00:00Z | 2011 | 9 | 2011-09-07T04:00:00Z | 2011-09-07T12:26:37Z | 0 | 0 | 0900006480f12334 | ||
| DOT-OST-1996-1909-0028 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracrus, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2011-08-16T04:00:00Z | 2011 | 8 | 2011-08-16T04:00:00Z | 2024-11-12T05:02:03Z | 1 | 0 | 0900006480ee117e | ||
| DOT-OST-1996-1909-0027 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Other | Notice | 2009-09-04T04:00:00Z | 2009 | 9 | 2009-09-04T04:00:00Z | 2024-11-07T22:08:49Z | 1 | 0 | 0900006480a1d772 | ||
| DOT-OST-1996-1909-0026 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption Filed by Taxi Aereo De Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-SubPartB | 2009-08-13T04:00:00Z | 2009 | 8 | 2009-08-13T04:00:00Z | 2024-11-12T04:44:42Z | 1 | 0 | 0900006480a083d4 | ||
| DOT-OST-1996-1909-0025 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, Apoyo Aereo, Servicios de Alquiler Aereo, Aerotransportes Privados, Aero Quimmco, Servicios Especiales del Pacifico Jalisco, Aero Empresa Mexicana, S.A. de C.V. | Notice | Notice | 2007-09-07T04:00:00Z | 2007 | 9 | 2007-09-07T04:00:00Z | 2007-09-08T03:59:59Z | 2024-11-07T01:45:47Z | 1 | 0 | 09000064802a2d7b | |
| DOT-OST-1996-1909-0024-0001 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2007-07-19T04:00:00Z | 2007 | 7 | 2007-07-19T04:00:00Z | 2007-07-20T03:59:59Z | 2024-11-07T01:45:46Z | 1 | 0 | 09000064802a2d79 | |
| DOT-OST-1996-1909-0024-0002 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2007-07-19T04:00:00Z | 2007 | 7 | 2007-07-19T04:00:00Z | 2007-07-20T03:59:59Z | 2024-11-07T01:45:47Z | 1 | 0 | 09000064802a2d7a | |
| DOT-OST-1996-1909-0023 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo De Veracruz, S.A. de C.V. | Notice | Notice | 2006-08-01T04:00:00Z | 2006 | 8 | 2006-08-01T04:00:00Z | 2006-08-02T03:59:59Z | 2024-11-07T01:45:46Z | 1 | 0 | 09000064802a2d78 | |
| DOT-OST-1996-1909-0022-0002 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2006-05-18T04:00:00Z | 2006 | 5 | 2006-05-18T04:00:00Z | 2006-05-19T03:59:59Z | 2024-11-07T01:45:46Z | 1 | 0 | 09000064802a2d77 | |
| DOT-OST-1996-1909-0022-0001 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2006-05-18T04:00:00Z | 2006 | 5 | 2006-05-18T04:00:00Z | 2006-05-19T03:59:59Z | 2024-11-07T01:45:46Z | 1 | 0 | 09000064802a2d76 | |
| DOT-OST-1996-1909-0021 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo De Veracruz, S.A. de C.V. | Notice | Notice | 2005-06-22T04:00:00Z | 2005 | 6 | 2005-06-22T04:00:00Z | 2005-06-23T03:59:59Z | 2024-11-07T01:45:19Z | 1 | 0 | 09000064802a2d75 | |
| DOT-OST-1996-1909-0020-0001 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2005-04-20T04:00:00Z | 2005 | 4 | 2005-04-20T04:00:00Z | 2005-04-21T03:59:59Z | 2024-11-07T01:45:18Z | 1 | 0 | 09000064802a2d73 | |
| DOT-OST-1996-1909-0020-0002 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. for a Period of Two Years | Other | Application-Other | 2005-04-20T04:00:00Z | 2005 | 4 | 2005-04-20T04:00:00Z | 2005-04-21T03:59:59Z | 2024-11-07T01:45:18Z | 1 | 0 | 09000064802a2d74 | |
| DOT-OST-1996-1909-0019 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re Taxi Aereo de Veracruz, S.A. | Notice | Notice | 2004-05-12T04:00:00Z | 2004 | 5 | 2004-05-12T04:00:00Z | 2004-05-13T03:59:59Z | 2024-11-07T01:45:18Z | 1 | 0 | 09000064802a2d71 | |
| DOT-OST-1996-1909-0018-0002 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. | Other | Application-Other | 2004-04-12T04:00:00Z | 2004 | 4 | 2004-04-12T04:00:00Z | 2004-04-13T03:59:59Z | 2024-11-07T01:45:18Z | 1 | 0 | 09000064802a2d70 | |
| DOT-OST-1996-1909-0018-0001 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. | Other | Application-Other | 2004-04-12T04:00:00Z | 2004 | 4 | 2004-04-12T04:00:00Z | 2004-04-13T03:59:59Z | 2024-11-07T01:45:17Z | 1 | 0 | 09000064802a2d6f | |
| DOT-OST-1996-1909-0017 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Notice | Notice | 2003-04-18T04:00:00Z | 2003 | 4 | 2003-04-18T04:00:00Z | 2003-04-19T03:59:59Z | 2024-11-07T01:45:17Z | 1 | 0 | 09000064802a2d6e | |
| DOT-OST-1996-1909-0016-0001 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. | Other | Application-Other | 2003-03-18T05:00:00Z | 2003 | 3 | 2003-03-18T05:00:00Z | 2003-03-19T04:59:59Z | 2024-11-07T01:45:17Z | 1 | 0 | 09000064802a2d6c | |
| DOT-OST-1996-1909-0016-0002 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. | Other | Application-Other | 2003-03-18T05:00:00Z | 2003 | 3 | 2003-03-18T05:00:00Z | 2003-03-19T04:59:59Z | 2024-11-07T01:45:17Z | 1 | 0 | 09000064802a2d6d | |
| DOT-OST-1996-1909-0015 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C. V. | Notice | Notice | 2002-03-28T05:00:00Z | 2002 | 3 | 2002-03-28T05:00:00Z | 2002-03-29T04:59:59Z | 2024-11-07T01:45:17Z | 1 | 0 | 09000064802a2d6b | |
| DOT-OST-1996-1909-0014 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. | Other | Application-Other | 2002-03-12T05:00:00Z | 2002 | 3 | 2002-03-12T05:00:00Z | 2002-03-13T04:59:59Z | 2024-11-07T01:45:17Z | 1 | 0 | 09000064802a2d6a | |
| DOT-OST-1996-1909-0013 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken Re: Taxi Aereo de Veracruz, S.A. de C.V. | Notice | Notice | 2001-03-26T05:00:00Z | 2001 | 3 | 2001-03-26T05:00:00Z | 2001-03-27T04:59:59Z | 2024-11-07T01:45:16Z | 1 | 0 | 09000064802a2d69 | |
| DOT-OST-1996-1909-0012 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Application for a Renewal of an Exemption filed by Taxi Aereo de Veracruz, S.A. de C.V. | Other | Application-Other | 2001-03-06T05:00:00Z | 2001 | 3 | 2001-03-06T05:00:00Z | 2001-03-07T04:59:59Z | 2024-11-07T01:44:50Z | 1 | 0 | 09000064802a2d68 | |
| DOT-OST-1996-1909-0011 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Notice | Notice | 2000-03-08T05:00:00Z | 2000 | 3 | 2000-03-08T05:00:00Z | 2000-03-09T04:59:59Z | 2024-11-07T01:44:51Z | 1 | 0 | 09000064802a2d67 | |
| DOT-OST-1996-1909-0010 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Taxi Aereo De Veracruz, S.A. de C.V. - Renewal/Exemption - Mexico-U.S. | Other | Application-Other | 1999-12-09T05:00:00Z | 1999 | 12 | 1999-12-09T05:00:00Z | 1999-12-10T04:59:59Z | 2024-11-07T01:44:51Z | 1 | 0 | 09000064802a2d66 | |
| DOT-OST-1996-1909-0009 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aereo de Veracruz, S.A. de C.V. | Notice | Notice | 1998-12-21T05:00:00Z | 1998 | 12 | 1998-12-21T05:00:00Z | 1998-12-22T04:59:59Z | 2024-11-07T01:46:15Z | 1 | 0 | 09000064802a2d82 | |
| DOT-OST-1996-1909-0008 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Taxi Aereo De Veracruz, S.A. de C.V. - Renewal/Exemption - Mexico-U.S. | Other | Application-Other | 1998-11-23T05:00:00Z | 1998 | 11 | 1998-11-23T05:00:00Z | 1998-12-18T04:59:59Z | 2024-11-07T01:46:15Z | 1 | 0 | 09000064802a2d81 | |
| DOT-OST-1996-1909-0007 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | 98-1-10 Order | Other | Order | 1998-01-12T05:00:00Z | 1998 | 1 | 1998-01-12T05:00:00Z | 1998-01-13T04:59:59Z | 2024-11-07T01:45:48Z | 1 | 0 | 09000064802a2d80 | |
| DOT-OST-1996-1909-0006 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re: Taxi Aero de Veracruz, S.A. de C.V. | Notice | Notice | 1997-12-01T05:00:00Z | 1997 | 12 | 1997-12-01T05:00:00Z | 1997-12-02T04:59:59Z | 2024-11-07T01:45:47Z | 1 | 0 | 09000064802a2d7f | |
| DOT-OST-1996-1909-0005 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption/Renewal - Mexico-United States | Other | Application-Other | 1997-11-12T05:00:00Z | 1997 | 11 | 1997-11-12T05:00:00Z | 1997-11-13T04:59:59Z | 2024-11-07T01:45:47Z | 1 | 0 | 09000064802a2d7e | |
| DOT-OST-1996-1909-0004 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | 96-12-20 Order | Other | Order | 1996-12-16T05:00:00Z | 1996 | 12 | 1996-12-16T05:00:00Z | 1996-12-17T04:59:59Z | 2024-11-07T01:45:47Z | 1 | 0 | 09000064802a2d7d | |
| DOT-OST-1996-1909-0003 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Notice of Action Taken re Taxi Aereo De Veracruz, S.A. de C.V. | Notice | Notice | 1996-12-03T05:00:00Z | 1996 | 12 | 1996-12-03T05:00:00Z | 1996-12-04T04:59:59Z | 2024-11-07T01:45:47Z | 1 | 0 | 09000064802a2d7c | |
| DOT-OST-1996-1909-0002 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Aero Parts - Response | Other | Correspondence | 1996-11-08T05:00:00Z | 1996 | 11 | 1996-11-08T05:00:00Z | 1996-11-09T04:59:59Z | 2024-11-07T01:45:18Z | 1 | 0 | 09000064802a2d72 | |
| DOT-OST-1996-1909-0001 | DOT | Taxi Aereo de Veracruz, S.A. de C.V. - Exemption - Mexico-United States DOT-OST-1996-1909 | Taxi Aereo De Veracruz, S.A. de C.V. - Exemption - Mexico-United States | Other | Application-Other | 1996-10-28T05:00:00Z | 1996 | 10 | 1996-10-28T05:00:00Z | 1996-10-29T04:59:59Z | 2024-11-07T01:44:50Z | 1 | 0 | 09000064802a2d65 |
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;