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-1636" 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 22
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-1636-0041 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Decision | 2026-01-23T05:00:00Z | 2026 | 1 | 2026-01-23T05:00:00Z | 2026-01-23T22:29:18Z | 1 | 0 | 09000064b917cae5 | ||
| DOT-OST-1996-1636-0040 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2025-11-04T05:00:00Z | 2025 | 11 | 2025-11-04T05:00:00Z | 2025-11-05T02:57:20Z | 1 | 0 | 09000064b906ac37 | ||
| DOT-OST-1996-1636-0039 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Decision | 2023-12-27T05:00:00Z | 2023 | 12 | 2023-12-27T05:00:00Z | 2024-11-12T06:21:26Z | 1 | 0 | 090000648635e80d | ||
| DOT-OST-1996-1636-0038 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Supplement to Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Supplement (SUP) | 2023-09-21T04:00:00Z | 2023 | 9 | 2023-09-21T04:00:00Z | 2024-11-07T00:52:37Z | 1 | 0 | 0900006485fdba65 | ||
| DOT-OST-1996-1636-0037 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2021-10-29T04:00:00Z | 2021 | 10 | 2021-10-29T04:00:00Z | 2024-11-07T00:34:09Z | 1 | 0 | 0900006484e01143 | ||
| DOT-OST-1996-1636-0036 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Decision | 2019-10-30T04:00:00Z | 2019 | 10 | 2019-10-30T04:00:00Z | 2024-11-12T23:10:32Z | 1 | 0 | 0900006484109c01 | ||
| DOT-OST-1996-1636-0035 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2019-10-08T04:00:00Z | 2019 | 10 | 2019-10-08T04:00:00Z | 2024-11-12T23:10:24Z | 1 | 0 | 090000648405d45f | ||
| DOT-OST-1996-1636-0034 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Decision | 2017-10-16T04:00:00Z | 2017 | 10 | 2017-10-16T04:00:00Z | 2024-11-07T01:17:36Z | 1 | 0 | 0900006482bd0115 | ||
| DOT-OST-1996-1636-0033 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2017-06-15T04:00:00Z | 2017 | 6 | 2017-06-15T04:00:00Z | 2024-11-07T01:00:52Z | 1 | 0 | 09000064826d8a36 | ||
| DOT-OST-1996-1636-0031 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2015-06-19T04:00:00Z | 2015 | 6 | 2015-05-28T04:00:00Z | 2024-11-07T23:23:33Z | 1 | 0 | 0900006481b0a712 | ||
| DOT-OST-1996-1636-0032 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Decision | 2015-06-19T04:00:00Z | 2015 | 6 | 2015-06-19T04:00:00Z | 2024-11-11T21:00:03Z | 1 | 0 | 0900006481b49c30 | ||
| DOT-OST-1996-1636-0030 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Servicios Aereos del Nazas, S.A. de C.V. | Other | Decision | 2013-06-06T04:00:00Z | 2013 | 6 | 2013-06-06T04:00:00Z | 2024-11-12T05:15:17Z | 1 | 0 | 0900006481310f24 | ||
| DOT-OST-1996-1636-0029 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2013-05-23T04:00:00Z | 2013 | 5 | 2013-05-23T04:00:00Z | 2024-11-12T05:16:31Z | 1 | 0 | 09000064812e6009 | ||
| DOT-OST-1996-1636-0028 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Notice | 2011-05-18T04:00:00Z | 2011 | 5 | 2011-05-18T04:00:00Z | 2024-11-07T22:31:11Z | 1 | 0 | 0900006480d19277 | ||
| DOT-OST-1996-1636-0027 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. de C.V. | Other | Correspondence | 2011-04-21T04:00:00Z | 2011 | 4 | 2011-04-21T04:00:00Z | 2013-07-27T23:50:59Z | 0 | 0 | 0900006480c34986 | ||
| DOT-OST-1996-1636-0026 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Other | Adjudication Notice | 2009-04-28T04:00:00Z | 2009 | 4 | 2009-04-28T04:00:00Z | 2024-11-07T22:06:22Z | 1 | 0 | 090000648096e67d | ||
| DOT-OST-1996-1636-0025 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. de C.V. | Other | Correspondence | 2009-03-30T04:00:00Z | 2009 | 3 | 2009-03-30T04:00:00Z | 2013-07-27T22:41:20Z | 0 | 0 | 0900006480933d5c | ||
| DOT-OST-1996-1636-0024 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 2007-03-30T04:00:00Z | 2007 | 3 | 2007-03-30T04:00:00Z | 2007-03-31T03:59:59Z | 2024-11-07T01:47:42Z | 1 | 0 | 09000064802a298e | |
| DOT-OST-1996-1636-0023-0001 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2006-11-22T05:00:00Z | 2006 | 11 | 2006-11-22T05:00:00Z | 2006-11-23T04:59:59Z | 2024-11-07T01:47:14Z | 1 | 0 | 09000064802a298c | |
| DOT-OST-1996-1636-0023-0002 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2006-11-22T05:00:00Z | 2006 | 11 | 2006-11-22T05:00:00Z | 2006-11-23T04:59:59Z | 2024-11-07T01:47:42Z | 1 | 0 | 09000064802a298d | |
| DOT-OST-1996-1636-0022 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 2005-12-13T05:00:00Z | 2005 | 12 | 2005-12-13T05:00:00Z | 2005-12-14T04:59:59Z | 2024-11-07T01:47:14Z | 1 | 0 | 09000064802a298b | |
| DOT-OST-1996-1636-0021-0002 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2005-11-16T05:00:00Z | 2005 | 11 | 2005-11-16T05:00:00Z | 2005-11-17T04:59:59Z | 2024-11-07T01:47:14Z | 1 | 0 | 09000064802a298a | |
| DOT-OST-1996-1636-0021-0001 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2005-11-16T05:00:00Z | 2005 | 11 | 2005-11-16T05:00:00Z | 2005-11-17T04:59:59Z | 2024-11-07T01:47:13Z | 1 | 0 | 09000064802a2989 | |
| DOT-OST-1996-1636-0020 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 2004-12-01T05:00:00Z | 2004 | 12 | 2004-12-01T05:00:00Z | 2004-12-02T04:59:59Z | 2024-11-07T01:47:13Z | 1 | 0 | 09000064802a2988 | |
| DOT-OST-1996-1636-0019-0001 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2004-11-09T05:00:00Z | 2004 | 11 | 2004-11-09T05:00:00Z | 2004-11-10T04:59:59Z | 2024-11-07T01:47:13Z | 1 | 0 | 09000064802a2985 | |
| DOT-OST-1996-1636-0019-0002 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2004-11-09T05:00:00Z | 2004 | 11 | 2004-11-09T05:00:00Z | 2004-11-10T04:59:59Z | 2024-11-07T01:47:13Z | 1 | 0 | 09000064802a2986 | |
| DOT-OST-1996-1636-0018 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re Corporacion Aerea Cencor S.A. de C.V. | Notice | Notice | 2003-11-12T05:00:00Z | 2003 | 11 | 2003-11-12T05:00:00Z | 2003-11-13T04:59:59Z | 2024-11-07T01:47:12Z | 1 | 0 | 09000064802a2984 | |
| DOT-OST-1996-1636-0017-0002 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2003-10-22T04:00:00Z | 2003 | 10 | 2003-10-22T04:00:00Z | 2003-10-23T03:59:59Z | 2024-11-07T01:46:47Z | 1 | 0 | 09000064802a2983 | |
| DOT-OST-1996-1636-0017-0001 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2003-10-22T04:00:00Z | 2003 | 10 | 2003-10-22T04:00:00Z | 2003-10-23T03:59:59Z | 2024-11-07T01:46:47Z | 1 | 0 | 09000064802a2982 | |
| DOT-OST-1996-1636-0016 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 2002-11-21T05:00:00Z | 2002 | 11 | 2002-11-21T05:00:00Z | 2002-11-22T04:59:59Z | 2024-11-07T01:46:46Z | 1 | 0 | 09000064802a2981 | |
| DOT-OST-1996-1636-0015-0001 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2002-10-23T04:00:00Z | 2002 | 10 | 2002-10-23T04:00:00Z | 2002-10-24T03:59:59Z | 2024-11-07T01:46:46Z | 1 | 0 | 09000064802a297f | |
| DOT-OST-1996-1636-0015-0002 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2002-10-23T04:00:00Z | 2002 | 10 | 2002-10-23T04:00:00Z | 2002-10-24T03:59:59Z | 2024-11-07T01:46:46Z | 1 | 0 | 09000064802a2980 | |
| DOT-OST-1996-1636-0014 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A, de C.V. | Notice | Notice | 2001-11-19T05:00:00Z | 2001 | 11 | 2001-11-19T05:00:00Z | 2001-11-20T04:59:59Z | 2024-11-07T01:46:46Z | 1 | 0 | 09000064802a297e | |
| DOT-OST-1996-1636-0013 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Application of Corporacion Aerea Cencor, S.A. de C.V. for Renewal of Exemption | Other | Application-Other | 2001-10-25T04:00:00Z | 2001 | 10 | 2001-10-25T04:00:00Z | 2001-10-26T03:59:59Z | 2024-11-07T01:46:46Z | 1 | 0 | 09000064802a297d | |
| DOT-OST-1996-1636-0012 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken Re: CORPORACION AEREA CENCOR, S.A. de C.V. | Notice | Notice | 2000-11-22T05:00:00Z | 2000 | 11 | 2000-11-22T05:00:00Z | 2000-11-23T04:59:59Z | 2024-11-07T01:46:46Z | 1 | 0 | 09000064802a297c | |
| DOT-OST-1996-1636-0011 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. de C.V. - Exemption/Renewal | Other | Application-Other | 2000-10-20T04:00:00Z | 2000 | 10 | 2000-10-20T04:00:00Z | 2000-10-21T03:59:59Z | 2024-11-07T01:46:45Z | 1 | 0 | 09000064802a297b | |
| DOT-OST-1996-1636-0010 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 1999-11-23T05:00:00Z | 1999 | 11 | 1999-11-23T05:00:00Z | 1999-11-24T04:59:59Z | 2024-11-07T01:46:45Z | 1 | 0 | 09000064802a297a | |
| DOT-OST-1996-1636-0009 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. de C.V. - Renewal/Exemption - United States-Mexico | Other | Application-Other | 1999-10-27T04:00:00Z | 1999 | 10 | 1999-10-27T04:00:00Z | 1999-11-19T04:59:59Z | 2024-11-07T01:53:32Z | 1 | 0 | 09000064802a2995 | |
| DOT-OST-1996-1636-0008 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 1998-11-16T05:00:00Z | 1998 | 11 | 1998-11-16T05:00:00Z | 1998-11-17T04:59:59Z | 2024-11-07T01:53:31Z | 1 | 0 | 09000064802a2994 | |
| DOT-OST-1996-1636-0007 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. DE C.V. - Renewal/Exemption - U.S.-Mexico Charter | Other | Application-Other | 1998-10-13T04:00:00Z | 1998 | 10 | 1998-10-13T04:00:00Z | 1998-11-05T04:59:59Z | 2024-11-07T01:53:31Z | 1 | 0 | 09000064802a2993 | |
| DOT-OST-1996-1636-0006 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | 97-11-1 Order Confirming Notices of Action Taken | Other | Order | 1997-11-03T05:00:00Z | 1997 | 11 | 1997-11-03T05:00:00Z | 1997-11-04T04:59:59Z | 2024-11-07T01:53:31Z | 1 | 0 | 09000064802a2992 | |
| DOT-OST-1996-1636-0005 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken re: Corporation Aerea Cencor, S.A. de C.V. | Notice | Notice | 1997-10-20T04:00:00Z | 1997 | 10 | 1997-10-20T04:00:00Z | 1997-10-21T03:59:59Z | 2024-11-07T01:53:04Z | 1 | 0 | 09000064802a2991 | |
| DOT-OST-1996-1636-0004 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. De C.V. - Renewal/Exemption - U.S.-Mexico Charter Air Transportation | Other | Application-Other | 1997-10-01T04:00:00Z | 1997 | 10 | 1997-10-01T04:00:00Z | 1997-10-02T03:59:59Z | 2024-11-07T01:53:04Z | 1 | 0 | 09000064802a2990 | |
| DOT-OST-1996-1636-0003 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | 96-10-12 Order Various Foreign Air Carriers | Other | Order | 1996-10-08T04:00:00Z | 1996 | 10 | 1996-10-08T04:00:00Z | 1996-10-09T03:59:59Z | 2024-11-07T01:47:42Z | 1 | 0 | 09000064802a298f | |
| DOT-OST-1996-1636-0002 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Notice of Action Taken Re Corporacion Aerea Cencor, S.A. de C.V. | Notice | Notice | 1996-10-02T04:00:00Z | 1996 | 10 | 1996-10-02T04:00:00Z | 1996-10-03T03:59:59Z | 2024-11-07T01:47:13Z | 1 | 0 | 09000064802a2987 | |
| DOT-OST-1996-1636-0001 | DOT | Corporacion Aerea Cencor, S.A. de C.V. - Exemption - U.S.-Mexico Charter Air Transportation DOT-OST-1996-1636 | Corporacion Aerea Cencor, S.A. De C.V. - Exemption - U.S.-Mexico Charter Air Transportation | Other | Application-Other | 1996-08-09T04:00:00Z | 1996 | 8 | 1996-08-09T04:00:00Z | 1996-08-10T03:59:59Z | 2024-11-07T01:46:45Z | 1 | 0 | 09000064802a2979 |
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;