documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
67 rows where docket_id = "DOT-OST-2011-0134" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: subtype, posted_month, open_for_comment, posted_date (date), comment_start_date (date), last_modified (date)
posted_year 14
agency_id 1
- DOT 67
| 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-2011-0134-0068 | DOT | None DOT-OST-2011-0134 | Amended Notice Regarding the Essential Air Service and Alternate Essential Air Service Programs | Other | Letter(s) | 2025-11-17T05:00:00Z | 2025 | 11 | 2025-11-17T05:00:00Z | 2025-11-17T23:18:03Z | 0 | 0 | 09000064b908645d | ||
| DOT-OST-2011-0134-0067 | DOT | None DOT-OST-2011-0134 | Amended Notice of Additional Funding for the Essential Air Service and Alternate Essential Air Service Programs | Other | Letter(s) | 2025-10-30T04:00:00Z | 2025 | 10 | 2025-10-30T04:00:00Z | 2025-10-30T21:13:00Z | 1 | 0 | 09000064b905c512 | ||
| DOT-OST-2011-0134-0066 | DOT | None DOT-OST-2011-0134 | Amended Notice of Additional Funding for the Essential Air Service and Alternate Essential Air Service Programs | Other | Letter(s) | 2025-10-09T04:00:00Z | 2025 | 10 | 2025-10-09T04:00:00Z | 2025-10-09T18:56:41Z | 1 | 0 | 09000064b8fff394 | ||
| DOT-OST-2011-0134-0065 | DOT | None DOT-OST-2011-0134 | Notice of Funding Lapse and Impacts on the Essential Air Service and Alternate Air Service Programs | Other | Letter(s) | 2025-10-07T04:00:00Z | 2025 | 10 | 2025-10-07T04:00:00Z | 2025-10-07T22:17:02Z | 0 | 0 | 09000064b8ff8a46 | ||
| DOT-OST-2011-0134-0064 | DOT | None DOT-OST-2011-0134 | 2025-1-8 Order Selecting Air Carrier | Other | Order | 2025-01-17T05:00:00Z | 2025 | 1 | 2025-01-17T05:00:00Z | 2025-01-17T17:34:07Z | 1 | 0 | 09000064868cb884 | ||
| DOT-OST-2011-0134-0063 | DOT | None DOT-OST-2011-0134 | Bemidji Regional Airport (Community Comments) | Other | Correspondence | 2024-11-18T05:00:00Z | 2024 | 11 | 2024-11-18T05:00:00Z | 2024-11-26T16:32:58Z | 1 | 0 | 0900006486824830 | ||
| DOT-OST-2011-0134-0061 | DOT | None DOT-OST-2011-0134 | Request for Community Comments | Other | Request | 2024-10-28T04:00:00Z | 2024 | 10 | 2024-10-28T04:00:00Z | 2024-11-12T22:44:26Z | 1 | 0 | 09000064867e9d6a | ||
| DOT-OST-2011-0134-0062 | DOT | None DOT-OST-2011-0134 | SkyWest Airlines (Proposal) | Other | Proposal(s) | 2024-10-28T04:00:00Z | 2024 | 10 | 2024-10-28T04:00:00Z | 2024-11-12T22:44:26Z | 1 | 0 | 09000064867e9d8e | ||
| DOT-OST-2011-0134-0060 | DOT | None DOT-OST-2011-0134 | SkyWest Airlines (Proposal) | Other | Proposal(s) | 2024-10-25T04:00:00Z | 2024 | 10 | 2024-10-25T04:00:00Z | 2024-11-12T22:48:28Z | 1 | 0 | 09000064867e4af3 | ||
| DOT-OST-2011-0134-0059 | DOT | None DOT-OST-2011-0134 | 2024-9-21 Order Requesting Proposals | Other | Order | 2024-09-24T04:00:00Z | 2024 | 9 | 2024-09-24T04:00:00Z | 2024-11-12T22:42:51Z | 1 | 0 | 090000648677ab1e | ||
| DOT-OST-2011-0134-0058 | DOT | None DOT-OST-2011-0134 | 2023-8-19 Order Approving Alternate Service Pattern | Other | Order | 2023-08-25T04:00:00Z | 2023 | 8 | 2023-08-25T04:00:00Z | 2024-11-07T00:50:42Z | 1 | 0 | 0900006485ee6b32 | ||
| DOT-OST-2011-0134-0057 | DOT | None DOT-OST-2011-0134 | Bemidji Regional Airport Authority (Concurrence with Sky West Change in Aircraft) | Other | Correspondence | 2023-08-11T04:00:00Z | 2023 | 8 | 2023-08-11T04:00:00Z | 2024-11-07T00:46:10Z | 1 | 0 | 0900006485e1eee2 | ||
| DOT-OST-2011-0134-0056 | DOT | None DOT-OST-2011-0134 | SkyWest Airlines (Notification of Aircraft Change) | Other | Correspondence | 2023-08-01T04:00:00Z | 2023 | 8 | 2023-08-01T04:00:00Z | 2024-11-07T00:32:58Z | 1 | 0 | 0900006485da070d | ||
| DOT-OST-2011-0134-0055 | DOT | None DOT-OST-2011-0134 | 2022-1-3 Order Selecting Air Carrier | Other | Order | 2022-01-20T05:00:00Z | 2022 | 1 | 2022-01-20T05:00:00Z | 2024-11-07T00:35:57Z | 1 | 0 | 0900006484f2aa9d | ||
| DOT-OST-2011-0134-0052 | DOT | None DOT-OST-2011-0134 | Request for Community Comments | Other | Request | 2021-11-30T05:00:00Z | 2021 | 11 | 2021-11-30T05:00:00Z | 2024-11-07T00:35:47Z | 1 | 0 | 0900006484e89358 | ||
| DOT-OST-2011-0134-0053 | DOT | None DOT-OST-2011-0134 | Beltrami County, City of Bemidji, and Bemidji Regional Airport (Community Comments) | Other | Correspondence | 2021-11-30T05:00:00Z | 2021 | 11 | 2021-11-30T05:00:00Z | 2024-11-07T00:34:20Z | 1 | 0 | 0900006484e8c009 | ||
| DOT-OST-2011-0134-0054 | DOT | None DOT-OST-2011-0134 | Greater Bemidji (Community Comments) | Other | Correspondence | 2021-11-30T05:00:00Z | 2021 | 11 | 2021-11-30T05:00:00Z | 2024-11-07T00:34:20Z | 1 | 0 | 0900006484e8c007 | ||
| DOT-OST-2011-0134-0050 | DOT | None DOT-OST-2011-0134 | Denver Air Connection (Proposal) | Other | Proposal(s) | 2021-10-28T04:00:00Z | 2021 | 10 | 2021-10-28T04:00:00Z | 2024-11-07T00:33:59Z | 1 | 0 | 0900006484dfd692 | ||
| DOT-OST-2011-0134-0051 | DOT | None DOT-OST-2011-0134 | SkyWest Airlines (Proposal) | Other | Proposal(s) | 2021-10-28T04:00:00Z | 2021 | 10 | 2021-10-28T04:00:00Z | 2024-11-07T00:33:43Z | 1 | 0 | 0900006484dfd44f | ||
| DOT-OST-2011-0134-0049 | DOT | None DOT-OST-2011-0134 | 2021-9-15 Order Requesting Proposal | Other | Order | 2021-09-13T04:00:00Z | 2021 | 9 | 2021-09-13T04:00:00Z | 2024-11-07T00:32:35Z | 1 | 0 | 0900006484d6f206 | ||
| DOT-OST-2011-0134-0048 | DOT | None DOT-OST-2011-0134 | Notice of Extension Regarding Current Administration and Enforcement of the Essential Air Service Program | Other | Decision | 2021-03-12T05:00:00Z | 2021 | 3 | 2021-03-17T04:00:00Z | 2024-11-12T23:29:55Z | 1 | 0 | 0900006484a6e953 | ||
| DOT-OST-2011-0134-0047 | DOT | None DOT-OST-2011-0134 | Notice of Third Extension Regarding Current Administration and Enforcement of the Essential Air Service Program | Other | Decision | 2020-12-23T05:00:00Z | 2020 | 12 | 2020-12-23T05:00:00Z | 2024-11-12T23:27:25Z | 1 | 0 | 09000064849c5ea3 | ||
| DOT-OST-2011-0134-0046 | DOT | None DOT-OST-2011-0134 | Notice of Second Extension Regarding Current Administration and Enforcement of the Essential Air Service Program | Other | Decision | 2020-09-22T04:00:00Z | 2020 | 9 | 2020-09-22T04:00:00Z | 2024-11-06T23:39:00Z | 1 | 0 | 090000648486f3b5 | ||
| DOT-OST-2011-0134-0045 | DOT | None DOT-OST-2011-0134 | Notice of Extension Regarding Current Administration and Enforcement of the Essential Air Service Program | Other | Decision | 2020-06-05T04:00:00Z | 2020 | 6 | 2020-06-05T04:00:00Z | 2024-11-12T23:21:22Z | 1 | 0 | 09000064846d0db9 | ||
| DOT-OST-2011-0134-0044 | DOT | None DOT-OST-2011-0134 | Notice Regarding Current Administration and Enforcement of the Essential Air Service Program | Other | Decision | 2020-04-29T04:00:00Z | 2020 | 4 | 2020-04-29T04:00:00Z | 2024-11-06T23:35:46Z | 1 | 0 | 090000648450d183 | ||
| DOT-OST-2011-0134-0043 | DOT | None DOT-OST-2011-0134 | Letter Supporting Reduced EAS Service | Other | Correspondence | 2020-04-03T04:00:00Z | 2020 | 4 | 2020-04-03T04:00:00Z | 2024-11-06T23:33:39Z | 1 | 0 | 0900006484487220 | ||
| DOT-OST-2011-0134-0042 | DOT | None DOT-OST-2011-0134 | 2020-1-13 Order Selecting Air Carrier | Other | Order | 2020-01-29T05:00:00Z | 2020 | 1 | 2020-01-29T05:00:00Z | 2024-11-12T23:16:38Z | 1 | 0 | 090000648430729b | ||
| DOT-OST-2011-0134-0041 | DOT | None DOT-OST-2011-0134 | Beltrami County, City of Bemidji, and Bemidji Regional Airport (Community Comments) | Other | Correspondence | 2019-09-25T04:00:00Z | 2019 | 9 | 2019-09-25T04:00:00Z | 2024-11-12T23:09:10Z | 1 | 0 | 0900006483fc5a7a | ||
| DOT-OST-2011-0134-0040 | DOT | None DOT-OST-2011-0134 | Request for Community Comments | Other | Request | 2019-09-06T04:00:00Z | 2019 | 9 | 2019-09-06T04:00:00Z | 2024-11-12T23:07:32Z | 1 | 0 | 0900006483ef0d90 | ||
| DOT-OST-2011-0134-0039 | DOT | None DOT-OST-2011-0134 | SkyWest Airlines (Proposal) | Other | Proposal(s) | 2019-09-05T04:00:00Z | 2019 | 9 | 2019-09-05T04:00:00Z | 2024-11-12T23:08:21Z | 1 | 0 | 0900006483eef86e | ||
| DOT-OST-2011-0134-0038 | DOT | None DOT-OST-2011-0134 | 2019-7-11 Order Requesting Proposals | Other | Order | 2019-07-31T04:00:00Z | 2019 | 7 | 2019-07-31T04:00:00Z | 2024-11-12T23:04:53Z | 1 | 0 | 0900006483dd78d6 | ||
| DOT-OST-2011-0134-0037 | DOT | None DOT-OST-2011-0134 | 2017-12-15 Order Re-Selecting Airline | Other | Order | 2017-12-19T05:00:00Z | 2017 | 12 | 2017-12-19T05:00:00Z | 2024-11-07T01:12:43Z | 1 | 0 | 0900006482d3c919 | ||
| DOT-OST-2011-0134-0036 | DOT | None DOT-OST-2011-0134 | Bemidji Regional Airport Authority (Comments) | Other | Correspondence | 2017-11-09T05:00:00Z | 2017 | 11 | 2017-11-09T05:00:00Z | 2024-11-07T01:09:32Z | 1 | 0 | 0900006482c62f7a | ||
| DOT-OST-2011-0134-0035 | DOT | None DOT-OST-2011-0134 | Request for Community Comments | Other | Request | 2017-10-17T04:00:00Z | 2017 | 10 | 2017-10-17T04:00:00Z | 2024-11-07T01:17:27Z | 1 | 0 | 0900006482bd83fd | ||
| DOT-OST-2011-0134-0034 | DOT | None DOT-OST-2011-0134 | 2017-8-29 Order Requesting Proposals | Other | Order | 2017-08-31T04:00:00Z | 2017 | 8 | 2017-08-31T04:00:00Z | 2024-11-07T01:11:32Z | 1 | 0 | 0900006482afc82c | ||
| DOT-OST-2011-0134-0033 | DOT | None DOT-OST-2011-0134 | 2016-5-8 Order Requesting Applications | Other | Order | 2016-05-17T04:00:00Z | 2016 | 5 | 2016-05-17T04:00:00Z | 2024-11-07T23:42:15Z | 1 | 0 | 0900006481fcc250 | ||
| DOT-OST-2011-0134-0032 | DOT | None DOT-OST-2011-0134 | 2015-12-15 Order Re-Selecting Air Carrier | Other | Order | 2015-12-22T05:00:00Z | 2015 | 12 | 2015-12-22T05:00:00Z | 2024-11-11T21:16:59Z | 1 | 0 | 0900006481dc590a | ||
| DOT-OST-2011-0134-0030 | DOT | None DOT-OST-2011-0134 | Letters of Support (4) | Other | Letter(s) in Support | 2015-11-13T05:00:00Z | 2015 | 11 | 2015-11-13T05:00:00Z | 2015-11-13T16:31:31Z | 0 | 0 | 0900006481d3a99b | ||
| DOT-OST-2011-0134-0029 | DOT | None DOT-OST-2011-0134 | City of Bemidji and Bemidji Regional Airport Authority | Other | Correspondence | 2015-11-03T05:00:00Z | 2015 | 11 | 2015-11-03T05:00:00Z | 2015-11-03T16:43:35Z | 0 | 0 | 0900006481d07ce6 | ||
| DOT-OST-2011-0134-0028 | DOT | None DOT-OST-2011-0134 | Request for Comments | Other | Request | 2015-10-23T04:00:00Z | 2015 | 10 | 2015-10-23T04:00:00Z | 2024-11-12T05:47:06Z | 1 | 0 | 0900006481ce9739 | ||
| DOT-OST-2011-0134-0027 | DOT | None DOT-OST-2011-0134 | Visit Bemidji (Correspondence) | Other | Correspondence | 2015-10-02T04:00:00Z | 2015 | 10 | 2015-10-02T04:00:00Z | 2024-11-12T05:48:34Z | 1 | 0 | 0900006481cab706 | ||
| DOT-OST-2011-0134-0026 | DOT | None DOT-OST-2011-0134 | Proposal of SkyWest Airlines | Other | Proposal(s) | 2015-09-24T04:00:00Z | 2015 | 9 | 2015-09-24T04:00:00Z | 2024-11-07T23:31:41Z | 1 | 0 | 0900006481c9352b | ||
| DOT-OST-2011-0134-0024 | DOT | None DOT-OST-2011-0134 | Douglas Leif (Letter of Support) | Other | Correspondence | 2015-09-18T04:00:00Z | 2015 | 9 | 2015-09-18T04:00:00Z | 2024-11-07T22:09:55Z | 1 | 0 | 0900006481c7c65c | ||
| DOT-OST-2011-0134-0025 | DOT | None DOT-OST-2011-0134 | Susan Nelson (Comment) | Other | Correspondence | 2015-09-18T04:00:00Z | 2015 | 9 | 2015-09-18T04:00:00Z | 2024-11-07T22:09:55Z | 1 | 0 | 0900006481c7c65f | ||
| DOT-OST-2011-0134-0023 | DOT | None DOT-OST-2011-0134 | 2015-8-22 Order Requesting Proposals | Other | Order | 2015-08-21T04:00:00Z | 2015 | 8 | 2015-08-21T04:00:00Z | 2024-11-12T05:37:20Z | 1 | 0 | 0900006481c31982 | ||
| DOT-OST-2011-0134-0022 | DOT | None DOT-OST-2011-0134 | 2014-1-4 Order Re-Selecting Carrier | Other | Order | 2014-01-08T05:00:00Z | 2014 | 1 | 2014-01-08T05:00:00Z | 2014-01-08T19:37:39Z | 0 | 0 | 09000064814f508d | ||
| DOT-OST-2011-0134-0021 | DOT | None DOT-OST-2011-0134 | Bemidji Regional Airport Authority (Comments) | Other | Correspondence | 2013-11-26T05:00:00Z | 2013 | 11 | 2013-11-26T05:00:00Z | 2024-11-12T05:23:58Z | 1 | 0 | 0900006481496035 | ||
| DOT-OST-2011-0134-0020 | DOT | None DOT-OST-2011-0134 | Request for Comments | Other | Request | 2013-11-25T05:00:00Z | 2013 | 11 | 2013-11-25T05:00:00Z | 2024-11-12T05:23:37Z | 1 | 0 | 0900006481487fdc | ||
| DOT-OST-2011-0134-0019 | DOT | None DOT-OST-2011-0134 | Proposal of SkyWest Airlines | Other | Proposal(s) | 2013-11-20T05:00:00Z | 2013 | 11 | 2013-11-20T05:00:00Z | 2024-11-12T05:23:51Z | 1 | 0 | 0900006481487fdb | ||
| DOT-OST-2011-0134-0018 | DOT | None DOT-OST-2011-0134 | Notice Extending Deadline for Proposals | Notice | Notice of Extension | 2013-10-24T04:00:00Z | 2013 | 10 | 2013-10-24T04:00:00Z | 2013-10-24T19:13:22Z | 0 | 0 | 090000648145e0ed | ||
| DOT-OST-2011-0134-0017 | DOT | None DOT-OST-2011-0134 | 2013-10-2 Order Requesting Proposals | Other | Order | 2013-10-01T04:00:00Z | 2013 | 10 | 2013-10-01T04:00:00Z | 2024-11-12T05:22:34Z | 1 | 0 | 0900006481441884 | ||
| DOT-OST-2011-0134-0016 | DOT | None DOT-OST-2011-0134 | Order 2012-10-8 Setting Final Rates | Other | Order | 2012-10-04T04:00:00Z | 2012 | 10 | 2012-10-04T04:00:00Z | 2024-11-11T20:41:41Z | 1 | 0 | 0900006481134ca3 | ||
| DOT-OST-2011-0134-0015 | DOT | None DOT-OST-2011-0134 | 2012-5-5 Order Extending Service Obligation | Other | Order | 2012-05-02T04:00:00Z | 2012 | 5 | 2012-05-02T04:00:00Z | 2024-11-07T22:40:29Z | 1 | 0 | 0900006481003b33 | ||
| DOT-OST-2011-0134-0014 | DOT | None DOT-OST-2011-0134 | Order 2012-3-15 Extending Service Obligation | Other | Order | 2012-03-23T04:00:00Z | 2012 | 3 | 2012-03-23T04:00:00Z | 2012-03-23T20:05:37Z | 0 | 0 | 0900006480fdfe13 | ||
| DOT-OST-2011-0134-0013 | DOT | None DOT-OST-2011-0134 | 2012-2-19 Order Extending Service Obligation | Other | Order | 2012-02-23T05:00:00Z | 2012 | 2 | 2012-02-23T05:00:00Z | 2012-02-23T16:25:26Z | 0 | 0 | 0900006480fbec83 | ||
| DOT-OST-2011-0134-0012 | DOT | None DOT-OST-2011-0134 | Order 2012-1-32 Extending Service Obligation | Other | Order | 2012-01-31T05:00:00Z | 2012 | 1 | 2012-01-31T05:00:00Z | 2012-01-31T20:10:00Z | 0 | 0 | 0900006480faa043 | ||
| DOT-OST-2011-0134-0011 | DOT | None DOT-OST-2011-0134 | 2012-1-23 Order Selecting Carrier | Other | Order | 2012-01-26T05:00:00Z | 2012 | 1 | 2012-01-26T05:00:00Z | 2024-11-07T22:25:56Z | 1 | 0 | 0900006480fa5859 | ||
| DOT-OST-2011-0134-0010 | DOT | None DOT-OST-2011-0134 | 2011-12-25 Order Extending Service Obligation | Other | Order | 2011-12-29T05:00:00Z | 2011 | 12 | 2011-12-29T05:00:00Z | 2024-11-12T04:43:15Z | 1 | 0 | 0900006480f8af85 | ||
| DOT-OST-2011-0134-0009 | DOT | None DOT-OST-2011-0134 | Order 2011-11-33 Extending Service Obligation | Other | Order | 2011-12-01T05:00:00Z | 2011 | 12 | 2011-12-01T05:00:00Z | 2011-12-01T17:09:47Z | 0 | 0 | 0900006480f78a63 | ||
| DOT-OST-2011-0134-0008 | DOT | None DOT-OST-2011-0134 | Order 2011-11-8 Extending Service Obligation | Other | Order | 2011-11-07T05:00:00Z | 2011 | 11 | 2011-11-07T05:00:00Z | 2024-11-12T05:04:37Z | 1 | 0 | 0900006480f6750f | ||
| DOT-OST-2011-0134-0007 | DOT | None DOT-OST-2011-0134 | Honorable Dave Larson, Mayor (Response to Request for Comments) | Other | Response(s) | 2011-10-25T04:00:00Z | 2011 | 10 | 2011-10-25T04:00:00Z | 2024-11-07T22:41:30Z | 1 | 0 | 0900006480f5a59e | ||
| DOT-OST-2011-0134-0006 | DOT | None DOT-OST-2011-0134 | Bemidji Regional Airport Authority (Response to Request for Comments) | Other | Response(s) | 2011-10-25T04:00:00Z | 2011 | 10 | 2011-10-25T04:00:00Z | 2024-11-07T22:42:33Z | 1 | 0 | 0900006480f59ff5 | ||
| DOT-OST-2011-0134-0005 | DOT | None DOT-OST-2011-0134 | Request for Comment, Bemidji, Minnesota | Other | Request | 2011-10-24T04:00:00Z | 2011 | 10 | 2013-07-28T00:06:15Z | 0 | 0 | 0900006480f5a3c4 | |||
| DOT-OST-2011-0134-0004 | DOT | None DOT-OST-2011-0134 | SkyWest Airlines' Essential Air Service Proposal for Butt, Bemidji, Sioux City, Aberdeen and Waterloo, Montana | Other | Proposal(s) | 2011-10-18T04:00:00Z | 2011 | 10 | 2011-10-18T04:00:00Z | 2024-11-12T05:03:34Z | 1 | 0 | 0900006480f54c43 | ||
| DOT-OST-2011-0134-0003 | DOT | None DOT-OST-2011-0134 | Notice of Extension | Other | Extension of Time | 2011-10-12T04:00:00Z | 2011 | 10 | 2011-10-12T04:00:00Z | 2024-11-12T05:04:34Z | 1 | 0 | 0900006480f50aa2 | ||
| DOT-OST-2011-0134-0002 | DOT | None DOT-OST-2011-0134 | Order 2011-9-5 Prohibiting Suspension Of Service And Requesting Proposals | Other | Order | 2011-09-13T04:00:00Z | 2011 | 9 | 2011-09-13T04:00:00Z | 2011-09-13T17:30:54Z | 0 | 0 | 0900006480f173b1 | ||
| DOT-OST-2011-0134-0001 | DOT | None DOT-OST-2011-0134 | Ninety-Day Notice of Termination of Service | Other | Application | 2011-07-18T04:00:00Z | 2011 | 7 | 2011-07-18T04:00:00Z | 2013-07-27T23:58:41Z | 0 | 0 | 0900006480ec371e |
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;