documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
39 rows where docket_id = "NOAA-NMFS-2018-0103" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: title, posted_month, comment_end_date, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
document_type 3
agency_id 1
- NOAA 39
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NOAA-NMFS-2018-0103-0044 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pollock in Statistical Area 620 in the Gulf of Alaska | Rule | 2020-03-23T04:00:00Z | 2020 | 3 | 2020-03-23T04:00:00Z | 2020-03-24T23:23:06Z | 2020-06075 | 0 | 0 | 090000648445ef1b | ||
| NOAA-NMFS-2018-0103-0043 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 610 in the Gulf of Alaska | Rule | 2020-03-18T04:00:00Z | 2020 | 3 | 2020-03-18T04:00:00Z | 2020-03-19T22:46:14Z | 2020-05598 | 0 | 0 | 0900006484450ab9 | ||
| NOAA-NMFS-2018-0103-0042 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in the West Yakutat District of the Gulf of Alaska | Rule | 2020-03-18T04:00:00Z | 2020 | 3 | 2020-03-18T04:00:00Z | 2020-03-19T22:42:31Z | 2020-05597 | 0 | 0 | 0900006484450993 | ||
| NOAA-NMFS-2018-0103-0041 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 630 in the Gulf of Alaska | Rule | 2020-03-16T04:00:00Z | 2020 | 3 | 2020-03-16T04:00:00Z | 2020-03-19T22:20:14Z | 2020-05287 | 0 | 0 | 0900006484447f82 | ||
| NOAA-NMFS-2018-0103-0040 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Deep-Water Species Fishery by Vessels Using Trawl Gear in the Gulf of Alaska | Rule | 2020-03-11T04:00:00Z | 2020 | 3 | 2020-03-11T04:00:00Z | 2020-03-19T22:03:18Z | 2020-04971 | 0 | 0 | 0900006484437528 | ||
| NOAA-NMFS-2018-0103-0039 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 610 in the Gulf of Alaska | Rule | 2020-03-09T04:00:00Z | 2020 | 3 | 2020-03-09T04:00:00Z | 2020-03-24T03:59:59Z | 2020-03-10T00:55:21Z | 2020-04741 | 0 | 0 | 0900006484408cd0 | |
| NOAA-NMFS-2018-0103-0038 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 630 in the Gulf of Alaska | Rule | 2020-03-09T04:00:00Z | 2020 | 3 | 2020-03-09T04:00:00Z | 2020-03-24T03:59:59Z | 2020-03-23T01:02:07Z | 2020-04742 | 0 | 0 | 090000648440914d | |
| NOAA-NMFS-2018-0103-0037 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 630 in the Gulf of Alaska | Rule | 2020-02-26T05:00:00Z | 2020 | 2 | 2020-02-26T05:00:00Z | 2020-02-26T17:12:19Z | 2020-03873 | 0 | 0 | 09000064843b4fa8 | ||
| NOAA-NMFS-2018-0103-0036 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 620 in the Gulf of Alaska | Rule | 2020-02-24T05:00:00Z | 2020 | 2 | 2020-02-24T05:00:00Z | 2020-02-26T01:16:03Z | 2020-03561 | 0 | 0 | 09000064843a32ea | ||
| NOAA-NMFS-2018-0103-0035 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 610 in the Gulf of Alaska | Rule | 2020-01-27T05:00:00Z | 2020 | 1 | 2020-01-27T05:00:00Z | 2020-01-28T16:56:13Z | 2020-00725 | 0 | 0 | 09000064842f58f5 | ||
| NOAA-NMFS-2018-0103-0034 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Chinook Salmon Prohibited Species Catch Limits in the Gulf of Alaska | Rule | 2019-12-30T05:00:00Z | 2019 | 12 | 2019-12-30T05:00:00Z | 2020-01-26T01:00:18Z | 2019-28132 | 0 | 0 | 0900006484256a29 | ||
| NOAA-NMFS-2018-0103-0032 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Inseason Adjustment to the 2020 Gulf of Alaska Pollock and Pacific Cod Total Allowable Catch Amounts | Rule | 2019-12-23T05:00:00Z | 2019 | 12 | 2019-12-23T05:00:00Z | 2020-01-08T04:59:59Z | 2020-01-19T00:25:55Z | 2019-27539 | 0 | 0 | 0900006484248379 | |
| NOAA-NMFS-2018-0103-0033 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pacific Cod in the Gulf of Alaska | Rule | 2019-12-23T05:00:00Z | 2019 | 12 | 2019-12-23T05:00:00Z | 2020-01-19T00:30:15Z | 2019-27567 | 0 | 0 | 0900006484248584 | ||
| NOAA-NMFS-2018-0103-0031 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pacific Cod by Catcher Vessels Greater than or Equal to 50 feet Length Overall using Hook-and-Line Gear in the Central Regulatory Area of the Gulf of Alaska | Rule | 2019-11-19T05:00:00Z | 2019 | 11 | 2019-11-19T05:00:00Z | 2019-11-19T17:08:07Z | 2019-24983 | 0 | 0 | 090000648417cf74 | ||
| NOAA-NMFS-2018-0103-0030 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Reallocation of Pacific Cod in the Western Regulatory Area of the Gulf of Alaska | Rule | 2019-11-05T05:00:00Z | 2019 | 11 | 2019-11-05T05:00:00Z | 2019-11-05T18:08:21Z | 2019-24153 | 0 | 0 | 090000648411e737 | ||
| NOAA-NMFS-2018-0103-0029 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pacific Cod by Vessels using Pot Gear in the Western Regulatory Area of the Gulf of Alaska | Rule | 2019-10-23T04:00:00Z | 2019 | 10 | 2019-10-23T04:00:00Z | 2019-10-23T16:52:19Z | 2019-23086 | 0 | 0 | 09000064840ec8c7 | ||
| NOAA-NMFS-2018-0103-0028 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheriesof the Exclusive Economic Zone off Alaska: Pacific Cod by Non-American Fisheries Act Crab Vessels Operating as Catcher Vessels Using Pot Gear in the Western Regulatory Area of the Gulf of Alaska | Rule | 2019-10-21T04:00:00Z | 2019 | 10 | 2019-10-21T04:00:00Z | 2019-10-22T17:13:59Z | 2019-22856 | 0 | 0 | 09000064840e2c94 | ||
| NOAA-NMFS-2018-0103-0027 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pacific Cod by Vessels using Pot Gear in the Central Regulatory Area of the Gulf of Alaska | Rule | 2019-10-17T04:00:00Z | 2019 | 10 | 2019-10-17T04:00:00Z | 2019-10-17T16:13:29Z | 2019-22634 | 0 | 0 | 09000064840b01e8 | ||
| NOAA-NMFS-2018-0103-0026 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pacific Cod in the Central Regulatory Area of the Gulf of Alaska | Rule | 2019-10-15T04:00:00Z | 2019 | 10 | 2019-10-15T04:00:00Z | 2019-10-15T16:42:16Z | 2019-22424 | 0 | 0 | 090000648408d4ce | ||
| NOAA-NMFS-2018-0103-0025 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Economic Exclusive Zone Off Alaska: Pollock Fishery by Vessels Using Trawl Gear in the Western Regulatory Area of the Gulf of Alaska | Rule | 2019-10-11T04:00:00Z | 2019 | 10 | 2019-10-11T04:00:00Z | 2019-10-11T16:28:10Z | 2019-22318 | 0 | 0 | 0900006484087683 | ||
| NOAA-NMFS-2018-0103-0024 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pacific Cod by Catcher Vessels Less than 50 feet Length Overall using Hook-and-Line Gear in the Central Regulatory Area of the Gulf of Alaska | Rule | 2019-10-07T04:00:00Z | 2019 | 10 | 2019-10-07T04:00:00Z | 2019-10-08T17:33:10Z | 2019-21782 | 0 | 0 | 0900006484048b99 | ||
| NOAA-NMFS-2018-0103-0023 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Sablefish in the Western Regulatory Area of the Gulf of Alaska | Rule | 2019-09-18T04:00:00Z | 2019 | 9 | 2019-09-18T16:44:45Z | 2019-20187 | 0 | 0 | 0900006483f921cf | |||
| NOAA-NMFS-2018-0103-0022 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pollock in Statistical Area 610 in the Gulf of Alaska | Rule | 2019-09-11T04:00:00Z | 2019 | 9 | 2019-09-11T04:00:00Z | 2019-09-11T15:51:05Z | 2019-19660 | 0 | 0 | 0900006483f36797 | ||
| NOAA-NMFS-2018-0103-0021 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pacific Cod by Trawl Catcher Vessels in the Central Regulatory Area of the Gulf of Alaska; Closure | Rule | 2019-09-04T04:00:00Z | 2019 | 9 | 2019-09-04T04:00:00Z | 2019-09-04T16:32:00Z | 2019-19045 | 0 | 0 | 0900006483ee78aa | ||
| NOAA-NMFS-2018-0103-0020 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pacific Cod by Catcher Vessels using Hook-and-Line Gear in the Western Regulatory Area of the Gulf of Alaska; Closure | Rule | 2019-09-04T04:00:00Z | 2019 | 9 | 2019-09-04T04:00:00Z | 2019-09-04T16:27:20Z | 2019-19046 | 0 | 0 | 0900006483ee78ae | ||
| NOAA-NMFS-2018-0103-0019 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Sablefish in the Central Regulatory Area of the Gulf of Alaska | Rule | 2019-08-30T04:00:00Z | 2019 | 8 | 2019-08-30T04:00:00Z | 2019-08-30T16:12:20Z | 2019-18811 | 0 | 0 | 0900006483edc6c2 | ||
| NOAA-NMFS-2018-0103-0018 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pacific Cod in the Central Regulatory Area of the Gulf of Alaska | Rule | 2019-08-27T04:00:00Z | 2019 | 8 | 2019-08-27T04:00:00Z | 2019-08-27T16:39:40Z | 2019-18430 | 0 | 0 | 0900006483ecbb90 | ||
| NOAA-NMFS-2018-0103-0016 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pacific Ocean Perch in the West Yakutat District of the Gulf of Alaska | Rule | 2019-08-08T04:00:00Z | 2019 | 8 | 2019-08-08T04:00:00Z | 2019-08-08T17:04:38Z | 2019-16985 | 0 | 0 | 0900006483e11c3a | ||
| NOAA-NMFS-2018-0103-0017 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Dusky Rockfish in the West Yakutat District of the Gulf of Alaska | Rule | 2019-08-08T04:00:00Z | 2019 | 8 | 2019-08-08T04:00:00Z | 2019-08-08T17:06:03Z | 2019-16982 | 0 | 0 | 0900006483e1238f | ||
| NOAA-NMFS-2018-0103-0015 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Reapportionment of the 2019 Gulf of Alaska Pacific Halibut Prohibited Species Catch Limits for the Trawl Deep-water and Shallow-water Fishery Categories | Rule | 2019-07-23T04:00:00Z | 2019 | 7 | 2019-07-23T04:00:00Z | 2019-07-23T16:37:33Z | 2019-15607 | 0 | 0 | 0900006483da9da7 | ||
| NOAA-NMFS-2018-0103-0014 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in the West Yakutat District of the Gulf of Alaska | Rule | 2019-06-26T04:00:00Z | 2019 | 6 | 2019-06-26T04:00:00Z | 2019-06-26T17:41:54Z | 2019-13568 | 0 | 0 | 0900006483d42686 | ||
| NOAA-NMFS-2018-0103-0013 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Gulf of Alaska; Final 2019 and 2020 Harvest Specifications for Groundfish; Correction | Rule | 2019-04-12T04:00:00Z | 2019 | 4 | 2019-04-12T04:00:00Z | 2019-04-12T15:46:37Z | 2019-07276 | 0 | 0 | 0900006483b89e58 | ||
| NOAA-NMFS-2018-0103-0012 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pollock in Statistical Area 610 in the Gulf of Alaska | Rule | 2019-04-03T04:00:00Z | 2019 | 4 | 2019-04-03T04:00:00Z | 2019-04-03T15:46:54Z | 2019-06496 | 0 | 0 | 0900006483b5e365 | ||
| NOAA-NMFS-2018-0103-0010 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone off Alaska: Pollock in Statistical Area 610 in the Gulf of Alaska | Rule | 2019-03-28T04:00:00Z | 2019 | 3 | 2019-03-28T04:00:00Z | 2019-04-10T03:59:59Z | 2019-03-28T16:02:54Z | 2019-05943 | 0 | 0 | 0900006483b385bb | |
| NOAA-NMFS-2018-0103-0011 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Pollock in Statistical Area 620 in the Gulf of Alaska | Rule | 2019-03-26T04:00:00Z | 2019 | 3 | 2019-03-26T04:00:00Z | 2019-03-28T16:46:39Z | 2019-05719 | 0 | 0 | 0900006483b2e392 | ||
| NOAA-NMFS-2018-0103-0008 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Gulf of Alaska; Final 2019 and 2020 Harvest Specifications for Groundfish | Rule | 2019-03-14T04:00:00Z | 2019 | 3 | 2019-03-14T04:00:00Z | 2019-03-14T15:35:38Z | 2019-04538 | 0 | 0 | 0900006483adeb9a | ||
| NOAA-NMFS-2018-0103-0009 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | BSAI GOA Specs SIR 2019-2020 | Supporting & Related Material | 2019-03-14T04:00:00Z | 2019 | 3 | 2019-03-14T15:50:53Z | 0 | 0 | 0900006483adf921 | ||||
| NOAA-NMFS-2018-0103-0001 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | Fisheries of the Exclusive Economic Zone Off Alaska: Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish | Proposed Rule | 2018-12-06T05:00:00Z | 2018 | 12 | 2018-12-06T05:00:00Z | 2019-01-08T04:59:59Z | 2019-01-07T00:05:53Z | 2018-26390 | 0 | 0 | 090000648394cd08 | |
| NOAA-NMFS-2018-0103-0002 | NOAA | Fisheries of the Exclusive Economic Zone Off Alaska; Gulf of Alaska; 2019 and 2020 Harvest Specifications for Groundfish NOAA-NMFS-2018-0103 | 2019-19 GOA Specs PR IRFA | Supporting & Related Material | 2018-12-06T05:00:00Z | 2018 | 12 | 2018-12-06T16:55:41Z | 0 | 0 | 090000648394f507 |
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;