documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
151 rows where agency_id = "BOEM" and docket_id = "BOEM_FRDOC_0001" sorted by posted_date descending
This data as json, CSV (advanced)
Suggested facets: posted_month, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BOEM_FRDOC_0001-0771 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas and Sulfur Operations in the Outer Continental Shelf; CFR Correction | Rule | 2025-12-15T05:00:00Z | 2025 | 12 | 2025-12-15T05:00:00Z | 2025-12-15T17:24:46Z | 2025-22767 | 0 | 0 | 09000064b90d34da | ||
| BOEM_FRDOC_0001-0735 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Outer Continental Shelf | Notice | 2024-11-01T04:00:00Z | 2024 | 11 | 2024-11-01T04:00:00Z | 2024-11-01T12:40:29Z | 2024-25447 | 0 | 0 | 09000064867f4702 | ||
| BOEM_FRDOC_0001-0706 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Outer Continental Shelf | Notice | 2024-04-30T04:00:00Z | 2024 | 4 | 2024-04-30T04:00:00Z | 2024-04-30T12:10:42Z | 2024-09208 | 0 | 0 | 09000064865254a4 | ||
| BOEM_FRDOC_0001-0672 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Outer Continental Shelf | Notice | 2023-10-06T04:00:00Z | 2023 | 10 | 2023-10-06T04:00:00Z | 2023-10-06T12:21:45Z | 2023-22317 | 0 | 0 | 0900006486056d90 | ||
| BOEM_FRDOC_0001-0668 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: 2024–2029 National Outer Continental Shelf Oil and Gas Leasing Proposed Final Program | Notice | 2023-10-02T04:00:00Z | 2023 | 10 | 2023-10-02T04:00:00Z | 2023-10-02T12:55:21Z | 2023-21678 | 0 | 0 | 0900006486019813 | ||
| BOEM_FRDOC_0001-0659 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Joint Record of Decision: Revolution Wind Farm and Revolution Wind Export Cable Project | Notice | 2023-08-24T04:00:00Z | 2023 | 8 | 2023-08-24T04:00:00Z | 2023-08-24T12:33:18Z | 2023-18244 | 0 | 0 | 0900006485ee0b76 | ||
| BOEM_FRDOC_0001-0644 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Outer Continental Shelf | Notice | 2023-05-04T04:00:00Z | 2023 | 5 | 2023-05-04T04:00:00Z | 2023-05-04T12:16:02Z | 2023-09457 | 0 | 0 | 09000064859c9d56 | ||
| BOEM_FRDOC_0001-0635 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Determination of No Competitive Interest in a Proposed Research Lease Area on the Gulf of Maine Outer Continental Shelf | Notice | 2023-03-20T04:00:00Z | 2023 | 3 | 2023-03-20T04:00:00Z | 2023-03-20T11:50:52Z | 2023-05639 | 0 | 0 | 09000064857fde20 | ||
| BOEM_FRDOC_0001-0634 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Sale for Gulf of Mexico Outer Continental Shelf Oil and Gas Lease Sale 261 | Notice | 2023-03-15T04:00:00Z | 2023 | 3 | 2023-03-15T18:41:43Z | 2023-05259 | 0 | 0 | 09000064857ab369 | |||
| BOEM_FRDOC_0001-0631 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Gulf of Mexico Outer Continental Shelf Sale 259 | Notice | 2023-02-27T05:00:00Z | 2023 | 2 | 2023-02-27T05:00:00Z | 2023-02-27T13:19:09Z | 2023-03973 | 0 | 0 | 090000648571c1a0 | ||
| BOEM_FRDOC_0001-0630 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Record of Decision: Gulf of Mexico, Outer Continental Shelf, Oil and Gas Lease Sale 259 | Notice | 2023-02-27T05:00:00Z | 2023 | 2 | 2023-02-27T05:00:00Z | 2023-02-27T13:17:55Z | 2023-03972 | 0 | 0 | 090000648571b8c8 | ||
| BOEM_FRDOC_0001-0620 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Gulf of Mexico OCS Oil and Gas Lease Sales 259 and 261 | Notice | 2023-01-13T05:00:00Z | 2023 | 1 | 2023-01-13T05:00:00Z | 2023-01-13T12:46:36Z | 2023-00485 | 0 | 0 | 09000064855eb8c8 | ||
| BOEM_FRDOC_0001-0615 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Cook Inlet Planning Area Outer Continental Shelf Oil and Gas Lease Sale258 | Notice | 2022-11-29T05:00:00Z | 2022 | 11 | 2022-11-29T05:00:00Z | 2022-11-29T12:40:02Z | 2022-25794 | 0 | 0 | 0900006485507c27 | ||
| BOEM_FRDOC_0001-0614 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Alaska Cook Inlet Planning Area Outer Continental Shelf Sale 258 | Notice | 2022-11-29T05:00:00Z | 2022 | 11 | 2022-11-29T05:00:00Z | 2022-11-29T12:39:15Z | 2022-25792 | 0 | 0 | 0900006485507b7a | ||
| BOEM_FRDOC_0001-0610 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Cook Inlet Lease Sale 258 | Notice | 2022-10-28T04:00:00Z | 2022 | 10 | 2022-10-28T04:00:00Z | 2022-10-28T11:46:14Z | 2022-23496 | 0 | 0 | 090000648546a1f6 | ||
| BOEM_FRDOC_0001-0609 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2022-10-28T04:00:00Z | 2022 | 10 | 2022-10-28T04:00:00Z | 2022-10-28T11:44:49Z | 2022-23494 | 0 | 0 | 0900006485469cec | ||
| BOEM_FRDOC_0001-0560 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas and Sulfur Operations in the Outer Continental Shelf-Revisions to the Requirements for Exploratory Drilling on the Arctic Outer Continental Shelf; Withdrawal | Proposed Rule | 2021-06-29T04:00:00Z | 2021 | 6 | 2021-06-29T04:00:00Z | 2021-06-29T11:49:23Z | 2021-13803 | 0 | 0 | 0900006484bbd8eb | ||
| BOEM_FRDOC_0001-0552 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2021-04-26T04:00:00Z | 2021 | 4 | 2021-04-26T04:00:00Z | 2021-04-26T12:03:10Z | 2021-08626 | 0 | 0 | 0900006484ab688a | ||
| BOEM_FRDOC_0001-0546 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Construction and Operations Plan for Vineyard Wind, LLC | Notice | 2021-03-03T05:00:00Z | 2021 | 3 | 2021-03-03T05:00:00Z | 2021-03-03T12:39:41Z | 2021-04392 | 0 | 0 | 0900006484a5c6e0 | ||
| BOEM_FRDOC_0001-0543 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas and Sulfur Operations in the Outer Continental Shelf: Revisions to the Requirements for Exploratory Drilling on the Arctic Outer Continental Shelf; Extension of Comment Period | Proposed Rule | 2021-02-10T05:00:00Z | 2021 | 2 | 2021-02-10T05:00:00Z | 2021-04-10T03:59:59Z | 2021-04-09T01:00:14Z | 2021-02799 | 0 | 0 | 0900006484a2c671 | |
| BOEM_FRDOC_0001-0542 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Risk Management, Financial Assurance and Loss Prevention; Withdrawal | Proposed Rule | 2021-01-22T05:00:00Z | 2021 | 1 | 2021-01-22T05:00:00Z | 2021-01-22T12:56:42Z | 2021-01293 | 0 | 0 | 09000064849fc76d | ||
| BOEM_FRDOC_0001-0541 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Record of Decision: Gulf of Mexico, Outer Continental Shelf, Oil and Gas Lease Sale 257 | Notice | 2021-01-21T05:00:00Z | 2021 | 1 | 2021-01-21T05:00:00Z | 2021-01-21T13:06:33Z | 2021-01251 | 0 | 0 | 09000064849faabe | ||
| BOEM_FRDOC_0001-0539 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Area Identification for the Proposed Cook Inlet Oil and Gas Lease Sale 258 | Notice | 2021-01-15T05:00:00Z | 2021 | 1 | 2021-01-15T05:00:00Z | 2021-01-15T16:36:57Z | 2021-00777 | 0 | 0 | 09000064849f4713 | ||
| BOEM_FRDOC_0001-0536 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Vineyard Wind LLC's Proposed Wind Energy Facility Offshore Massachusetts | Notice | 2020-12-16T05:00:00Z | 2020 | 12 | 2020-12-16T05:00:00Z | 2020-12-16T13:00:50Z | 2020-27701 | 0 | 0 | 09000064849a1ae2 | ||
| BOEM_FRDOC_0001-0535 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas and Sulfur Operations on the Outer Continental Shelf: Revisions to the Requirements for Exploratory Drilling on the Arctic Outer Continental Shelf | Proposed Rule | 2020-12-09T05:00:00Z | 2020 | 12 | 2020-12-09T05:00:00Z | 2021-02-09T04:59:59Z | 2021-02-09T02:00:36Z | 2020-25818 | 0 | 0 | 090000648498f9aa | |
| BOEM_FRDOC_0001-0534 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Gulf of Mexico, Outer Continental Shelf, Geological and Geophysical Activities: Western, Central, and Eastern Planning Areas | Notice | 2020-12-04T05:00:00Z | 2020 | 12 | 2020-12-04T05:00:00Z | 2020-12-04T12:42:13Z | 2020-26781 | 0 | 0 | 0900006484985c6e | ||
| BOEM_FRDOC_0001-0532 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Gulf of Mexico Outer Continental Shelf Region-wide Oil and Gas Lease Sale 257 | Notice | 2020-11-18T05:00:00Z | 2020 | 11 | 2020-11-18T05:00:00Z | 2020-11-18T12:52:02Z | 2020-25518 | 0 | 0 | 09000064849661f4 | ||
| BOEM_FRDOC_0001-0527 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2020-09-24T04:00:00Z | 2020 | 9 | 2020-09-24T04:00:00Z | 2020-09-24T11:48:12Z | 2020-21099 | 0 | 0 | 09000064848761f7 | ||
| BOEM_FRDOC_0001-0516 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sale: Outer Continental Shelf; MMAA104000 | Notice | 2020-04-17T04:00:00Z | 2020 | 4 | 2020-04-17T04:00:00Z | 2020-04-17T11:59:25Z | 2020-08181 | 0 | 0 | 09000064844b0f66 | ||
| BOEM_FRDOC_0001-0512 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | 2020 Civil Penalties Inflation Adjustments for Oil, Gas, and Sulfur Operations in the Outer Continental Shelf | Rule | 2020-02-07T05:00:00Z | 2020 | 2 | 2020-02-07T05:00:00Z | 2020-02-07T12:49:47Z | 2020-02059 | 0 | 0 | 090000648433b826 | ||
| BOEM_FRDOC_0001-0506 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2019-11-05T05:00:00Z | 2019 | 11 | 2019-11-05T05:00:00Z | 2019-11-05T12:45:42Z | 2019-24052 | 0 | 0 | 090000648411e6cf | ||
| BOEM_FRDOC_0001-0503 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Policy Statement on Regulating Workplace Safety and Health Conditions on Renewable Energy Facilities on the Outer Continental Shelf | Rule | 2019-10-18T04:00:00Z | 2019 | 10 | 2019-10-18T04:00:00Z | 2019-10-18T11:47:27Z | 2019-22826 | 0 | 0 | 09000064840be62e | ||
| BOEM_FRDOC_0001-0466 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf, Alaska OCS Region, Beaufort Sea, Proposed Oil and GasLease Sale for 2019 | Notice | 2018-05-10T04:00:00Z | 2018 | 5 | 2018-05-10T04:00:00Z | 2018-05-31T03:59:59Z | 2018-06-01T01:02:01Z | 2018-10012 | 0 | 0 | 090000648325408c | |
| BOEM_FRDOC_0001-0461 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico Outer Continental Shelf Oil and Gas Region-wide Lease Sale 251 | Notice | 2018-04-03T04:00:00Z | 2018 | 4 | 2018-04-03T04:00:00Z | 2018-08-16T03:59:59Z | 2018-04-03T12:00:10Z | 2018-06730 | 0 | 0 | 090000648308de27 | |
| BOEM_FRDOC_0001-0455 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico Outer Continental Shelf | Notice | 2018-02-16T05:00:00Z | 2018 | 2 | 2018-02-16T05:00:00Z | 2018-02-16T12:51:32Z | 2018-03278 | 0 | 0 | 0900006482f38b6f | ||
| BOEM_FRDOC_0001-0446 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2017-11-14T05:00:00Z | 2017 | 11 | 2017-11-14T05:00:00Z | 2017-11-14T12:49:06Z | 2017-24630 | 0 | 0 | 0900006482c7223a | ||
| BOEM_FRDOC_0001-0445 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico Outer Continental Shelf | Notice | 2017-10-26T04:00:00Z | 2017 | 10 | 2017-10-26T04:00:00Z | 2017-10-26T11:48:26Z | 2017-23310 | 0 | 0 | 0900006482c0a2cb | ||
| BOEM_FRDOC_0001-0436 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Sand Resources: Martin County Hurricane and Storm Damage Reduction Project, Hutchinson Island, Martin County, FL | Notice | 2017-07-14T04:00:00Z | 2017 | 7 | 2017-07-14T04:00:00Z | 2017-07-14T12:02:13Z | 2017-14867 | 0 | 0 | 09000064829219ab | ||
| BOEM_FRDOC_0001-0339 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Cancellation of Oil and Gas Lease Sale 237 in the Chukchi Sea Planning Area on the Outer Continental Shelf | Notice | 2015-11-30T05:00:00Z | 2015 | 11 | 2015-11-30T05:00:00Z | 2015-11-30T13:51:47Z | 2015-30299 | 0 | 0 | 0900006481d795b8 | ||
| BOEM_FRDOC_0001-0335 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales: List of Restricted Joint Bidders | Notice | 2015-11-02T05:00:00Z | 2015 | 11 | 2015-11-02T05:00:00Z | 2015-11-02T13:16:51Z | 2015-27896 | 0 | 0 | 0900006481d02bad | ||
| BOEM_FRDOC_0001-0332 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Assessments; Availability, etc.: Virginia Offshore Wind Technology Advancement Project on the Atlantic Outer Continental Shelf | Notice | 2015-09-29T04:00:00Z | 2015 | 9 | 2015-09-29T04:00:00Z | 2015-09-29T13:23:47Z | 2015-24408 | 0 | 0 | 0900006481ca0e76 | ||
| BOEM_FRDOC_0001-0325 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Outer Continental Shelf, Gulf of Mexico, Oil and Gas Central Planning Area Lease Sales 241 and 247 and Eastern Planning Area Lease Sale 226 | Notice | 2015-09-04T04:00:00Z | 2015 | 9 | 2015-09-04T04:00:00Z | 2015-09-04T13:08:35Z | 2015-22055 | 0 | 0 | 0900006481c57674 | ||
| BOEM_FRDOC_0001-0321 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Western Gulf of Mexico Planning Area, Outer Continental Shelf, Sale 246 | Notice | 2015-07-17T04:00:00Z | 2015 | 7 | 2015-07-17T04:00:00Z | 2015-07-17T13:04:01Z | 2015-17632 | 0 | 0 | 0900006481b8e96e | ||
| BOEM_FRDOC_0001-0320 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico, Outer Continental Shelf, Western Planning Area, Sale 246 | Notice | 2015-07-17T04:00:00Z | 2015 | 7 | 2015-07-17T04:00:00Z | 2015-07-17T13:03:00Z | 2015-17606 | 0 | 0 | 0900006481b8e46b | ||
| BOEM_FRDOC_0001-0318 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Official and Supplemental Official Protraction Diagrams | Notice | 2015-05-18T04:00:00Z | 2015 | 5 | 2015-05-18T04:00:00Z | 2015-05-18T13:40:25Z | 2015-11993 | 0 | 0 | 0900006481ae55f3 | ||
| BOEM_FRDOC_0001-0314 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Alaska, Outer Continental Shelf, Chukchi Sea Planning Area, Sale 193 | Notice | 2015-04-06T04:00:00Z | 2015 | 4 | 2015-04-06T04:00:00Z | 2015-04-06T12:39:56Z | 2015-07860 | 0 | 0 | 0900006481a8c8d6 | ||
| BOEM_FRDOC_0001-0312 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Leasing Program: Outer Continental Shelf | Notice | 2015-03-06T05:00:00Z | 2015 | 3 | 2015-03-06T05:00:00Z | 2015-03-31T03:59:59Z | 2015-03-31T02:20:58Z | 2015-05107 | 0 | 0 | 0900006481a30310 | |
| BOEM_FRDOC_0001-0310 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Western Gulf of Mexico Planning Area, Outer Continental Shelf, Sale 246 | Notice | 2015-03-03T05:00:00Z | 2015 | 3 | 2015-03-03T05:00:00Z | 2015-03-03T13:24:44Z | 2015-04347 | 0 | 0 | 0900006481a27639 | ||
| BOEM_FRDOC_0001-0309 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Central Gulf of Mexico Planning Area, Outer Continental Shelf, CPA Sale 235; Correction | Notice | 2015-02-24T05:00:00Z | 2015 | 2 | 2015-02-24T05:00:00Z | 2015-02-24T13:56:17Z | 2015-03832 | 0 | 0 | 0900006481a11c1d | ||
| BOEM_FRDOC_0001-0305 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico, Outer Continental Shelf, Central Planning Area | Notice | 2015-02-06T05:00:00Z | 2015 | 2 | 2015-02-06T05:00:00Z | 2015-02-06T14:03:26Z | 2015-02272 | 0 | 0 | 09000064819f77c8 | ||
| BOEM_FRDOC_0001-0306 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Central Gulf of Mexico Planning Area, Outer Continental Shelf, Central Planning Area | Notice | 2015-02-06T05:00:00Z | 2015 | 2 | 2015-02-06T05:00:00Z | 2015-02-06T14:13:21Z | 2015-02273 | 0 | 0 | 09000064819f7d12 | ||
| BOEM_FRDOC_0001-0300 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Official Protraction Diagrams and Supplemental Official Outer Continental Shelf Block Diagrams | Notice | 2015-01-22T05:00:00Z | 2015 | 1 | 2015-01-22T05:00:00Z | 2015-01-22T13:41:23Z | 2015-00930 | 0 | 0 | 09000064819d7883 | ||
| BOEM_FRDOC_0001-0296 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Consumer Price Index Adjustments of the Oil Pollution Act of 1990 Limit of Liability for Offshore Facilities | Rule | 2014-12-12T05:00:00Z | 2014 | 12 | 2014-12-12T05:00:00Z | 2014-12-12T14:13:00Z | 2014-29093 | 0 | 0 | 0900006481970460 | ||
| BOEM_FRDOC_0001-0291 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Outer Continental Shelf, Alaska OCS Region, Chukchi Sea Planning Area, Oil and Gas Lease Sale 193 | Notice | 2014-11-26T05:00:00Z | 2014 | 11 | 2014-11-26T05:00:00Z | 2014-11-26T15:03:42Z | 2014-28003 | 0 | 0 | 09000064819488a7 | ||
| BOEM_FRDOC_0001-0288 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Request for Information: Long Term Monitoring Plan for Marine Mammals; Gulf of Mexico | Notice | 2014-11-07T05:00:00Z | 2014 | 11 | 2014-11-07T05:00:00Z | 2014-12-09T04:59:59Z | 2014-12-11T16:09:16Z | 2014-26520 | 0 | 0 | 090000648191ea43 | |
| BOEM_FRDOC_0001-0286 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2014-10-29T04:00:00Z | 2014 | 10 | 2014-10-29T04:00:00Z | 2014-10-29T13:58:14Z | 2014-25651 | 0 | 0 | 0900006481905313 | ||
| BOEM_FRDOC_0001-0284 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Pollution Prevention and Control | Notice | 2014-10-20T04:00:00Z | 2014 | 10 | 2014-10-20T04:00:00Z | 2014-11-20T04:59:59Z | 2014-10-25T01:04:09Z | 2014-24865 | 0 | 0 | 09000064818dd632 | |
| BOEM_FRDOC_0001-0283 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Central Gulf of Mexico Planning Area, Outer Continental Shelf, CPA Sale 235 | Notice | 2014-10-17T04:00:00Z | 2014 | 10 | 2014-10-17T04:00:00Z | 2014-10-17T13:27:57Z | 2014-24729 | 0 | 0 | 09000064818ccc92 | ||
| BOEM_FRDOC_0001-0280 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Outer Continental Shelf, Gulf of Mexico, Oil and Gas Lease Sales, Central Planning Area Lease Sales 235, 241, and 247 | Notice | 2014-09-19T04:00:00Z | 2014 | 9 | 2014-09-19T04:00:00Z | 2014-09-19T12:39:35Z | 2014-21993 | 0 | 0 | 090000648187edd6 | ||
| BOEM_FRDOC_0001-0272 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Proposed Geological and Geophysical Activities on the Mid- and South Atlantic Outer Continental Shelf | Notice | 2014-07-23T04:00:00Z | 2014 | 7 | 2014-07-23T04:00:00Z | 2014-07-23T12:27:25Z | 2014-17386 | 0 | 0 | 09000064817d7696 | ||
| BOEM_FRDOC_0001-0269 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico, Outer Continental Shelf Western Planning Area | Notice | 2014-07-18T04:00:00Z | 2014 | 7 | 2014-07-18T04:00:00Z | 2014-07-18T13:29:26Z | 2014-16958 | 0 | 0 | 09000064817bcfc9 | ||
| BOEM_FRDOC_0001-0270 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Western Gulf of Mexico Planning Area Outer Continental Shelf | Notice | 2014-07-18T04:00:00Z | 2014 | 7 | 2014-07-18T04:00:00Z | 2014-07-18T13:30:24Z | 2014-16962 | 0 | 0 | 09000064817bd04f | ||
| BOEM_FRDOC_0001-0264 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Determinations of No Competitive Interest: Pacific Marine Energy Center South Energy Test Site Project Offshore Newport, OR | Notice | 2014-06-20T04:00:00Z | 2014 | 6 | 2014-06-20T04:00:00Z | 2014-06-20T12:46:07Z | 2014-14002 | 0 | 0 | 0900006481756efe | ||
| BOEM_FRDOC_0001-0265 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Outer Continental Shelf, Alaska OCS Region, Chukchi Sea Planning Area, Oil and Gas Lease Sale 193 | Notice | 2014-06-20T04:00:00Z | 2014 | 6 | 2014-06-20T04:00:00Z | 2014-06-20T12:50:46Z | 2014-14290 | 0 | 0 | 0900006481757180 | ||
| BOEM_FRDOC_0001-0262 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Assessments; Availability, etc.: Commercial Wind Lease Issuance and Site Assessment Activities, Atlantic Outer Continental Shelf, Offshore Massachusetts | Notice | 2014-06-18T04:00:00Z | 2014 | 6 | 2014-06-18T04:00:00Z | 2014-06-18T13:29:09Z | 2014-14004 | 0 | 0 | 090000648174fb4e | ||
| BOEM_FRDOC_0001-0260 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Plans and Information | Notice | 2014-06-09T04:00:00Z | 2014 | 6 | 2014-06-09T04:00:00Z | 2014-08-09T03:59:59Z | 2014-06-09T13:03:14Z | 2014-13278 | 0 | 0 | 090000648172fb8d | |
| BOEM_FRDOC_0001-0259 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Official Protraction Diagrams; Supplemental Official Outer Continental Shelf Block Diagrams | Notice | 2014-06-05T04:00:00Z | 2014 | 6 | 2014-06-05T04:00:00Z | 2014-06-05T12:34:29Z | 2014-13001 | 0 | 0 | 090000648172aa31 | ||
| BOEM_FRDOC_0001-0258 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Pollution Prevention and Control | Notice | 2014-05-29T04:00:00Z | 2014 | 5 | 2014-05-29T04:00:00Z | 2014-07-29T03:59:59Z | 2014-05-29T12:30:26Z | 2014-12417 | 0 | 0 | 090000648171ba6c | |
| BOEM_FRDOC_0001-0254 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Operations in the Outer Continental Shelf for Minerals Other than Oil, Gas, and Sulphur | Notice | 2014-05-14T04:00:00Z | 2014 | 5 | 2014-05-14T04:00:00Z | 2014-06-14T03:59:59Z | 2014-05-14T13:10:10Z | 2014-11093 | 0 | 0 | 09000064816f9562 | |
| BOEM_FRDOC_0001-0253 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales | Notice | 2014-05-05T04:00:00Z | 2014 | 5 | 2014-05-05T04:00:00Z | 2014-05-05T13:04:01Z | 2014-10164 | 0 | 0 | 09000064816e193e | ||
| BOEM_FRDOC_0001-0252 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Meetings: Outer Continental Shelf Scientific Committee | Notice | 2014-04-25T04:00:00Z | 2014 | 4 | 2014-04-25T04:00:00Z | 2014-04-25T12:34:53Z | 2014-09278 | 0 | 0 | 09000064816cb41c | ||
| BOEM_FRDOC_0001-0251 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Nominations: Outer Continental Shelf Scientific Committee | Notice | 2014-04-24T04:00:00Z | 2014 | 4 | 2014-04-24T04:00:00Z | 2014-04-24T12:34:10Z | 2014-09277 | 0 | 0 | 09000064816c8a91 | ||
| BOEM_FRDOC_0001-0249 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Leasing for Minerals Other than Oil, Gas, and Sulphur in the Outer Continental Shelf | Notice | 2014-04-17T04:00:00Z | 2014 | 4 | 2014-04-17T04:00:00Z | 2014-06-17T03:59:59Z | 2014-04-17T13:26:02Z | 2014-08712 | 0 | 0 | 09000064816b7d8a | |
| BOEM_FRDOC_0001-0250 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Submission Timing Requirements: Site Assessment Plans, General Activities Plans forRenewable Energy Project on the Outer Continental Shelf | Rule | 2014-04-17T04:00:00Z | 2014 | 4 | 2014-04-17T04:00:00Z | 2014-04-17T13:26:52Z | 2014-08488 | 0 | 0 | 09000064816b7e1a | ||
| BOEM_FRDOC_0001-0248 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Western Gulf of Mexico Planning Area, Outer Continental Shelf; 238 | Notice | 2014-04-16T04:00:00Z | 2014 | 4 | 2014-04-16T04:00:00Z | 2014-08-21T03:59:59Z | 2014-07-30T01:04:41Z | 2014-08305 | 0 | 0 | 09000064816b5eba | |
| BOEM_FRDOC_0001-0240 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Social Indicators in Coastal Alaska: Arctic Communities Survey | Notice | 2014-03-14T04:00:00Z | 2014 | 3 | 2014-03-14T04:00:00Z | 2014-05-14T03:59:59Z | 2014-03-14T13:36:05Z | 2014-05605 | 0 | 0 | 0900006481665c4e | |
| BOEM_FRDOC_0001-0239 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Use of Outer Continental Shelf Sand, Gravel, and Shell Resources in Construction Projects | Notice | 2014-03-12T04:00:00Z | 2014 | 3 | 2014-03-12T04:00:00Z | 2014-04-12T03:59:59Z | 2014-03-12T13:10:11Z | 2014-05300 | 0 | 0 | 0900006481661040 | |
| BOEM_FRDOC_0001-0237 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Documents: Oil, Gas, and Mineral Operations Gulf of Mexico Outer Continental Shelf Region | Notice | 2014-03-05T05:00:00Z | 2014 | 3 | 2014-03-05T05:00:00Z | 2014-03-05T13:40:32Z | 2014-04864 | 0 | 0 | 09000064815fb306 | ||
| BOEM_FRDOC_0001-0236 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Central Gulf of Mexico Planning Area Outer Continental Shelf Sale 231; Correction | Notice | 2014-02-27T05:00:00Z | 2014 | 2 | 2014-02-27T05:00:00Z | 2014-02-27T14:28:33Z | 2014-04346 | 0 | 0 | 09000064815d8583 | ||
| BOEM_FRDOC_0001-0235 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Operations in the Outer Continental Shelf for Minerals Other than Oil, Gas, and Sulphur | Notice | 2014-02-26T05:00:00Z | 2014 | 2 | 2014-02-26T05:00:00Z | 2014-04-29T03:59:59Z | 2014-02-26T14:23:06Z | 2014-04121 | 0 | 0 | 09000064815c39e5 | |
| BOEM_FRDOC_0001-0233 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales; Records of Decisions: Gulf of Mexico, Outer Continental Shelf Central Planning Area | Notice | 2014-02-26T05:00:00Z | 2014 | 2 | 2014-02-26T05:00:00Z | 2014-02-26T14:22:39Z | 2014-04187 | 0 | 0 | 09000064815c398d | ||
| BOEM_FRDOC_0001-0234 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales; Records of Decisions: Gulf of Mexico, Outer Continental Shelf Eastern Planning Area Oil and Gas | Notice | 2014-02-26T05:00:00Z | 2014 | 2 | 2014-02-26T05:00:00Z | 2014-02-26T14:22:46Z | 2014-04184 | 0 | 0 | 09000064815c39e1 | ||
| BOEM_FRDOC_0001-0230 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Eastern Gulf of Mexico Planning Area Outer Continental Shelf Sale 225 | Notice | 2014-02-14T05:00:00Z | 2014 | 2 | 2014-02-14T05:00:00Z | 2014-02-14T13:36:31Z | 2014-03320 | 0 | 0 | 09000064815662af | ||
| BOEM_FRDOC_0001-0231 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Outer Continental Shelf Oil and Gas Lease Sales: Central Gulf of Mexico Planning Area | Notice | 2014-02-14T05:00:00Z | 2014 | 2 | 2014-02-14T05:00:00Z | 2014-02-14T13:36:35Z | 2014-03316 | 0 | 0 | 09000064815662ed | ||
| BOEM_FRDOC_0001-0228 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Leasing of Sulphur or Oil and Gas in the Outer Continental Shelf and Pipeline Rights of Way | Notice | 2014-02-03T05:00:00Z | 2014 | 2 | 2014-02-03T05:00:00Z | 2014-03-06T04:59:59Z | 2014-02-08T02:02:52Z | 2014-02195 | 0 | 0 | 0900006481542fae | |
| BOEM_FRDOC_0001-0226 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Determinations of No Competitive Interest: Offshore Virginia | Notice | 2013-12-09T05:00:00Z | 2013 | 12 | 2013-12-09T05:00:00Z | 2013-12-09T14:08:32Z | 2013-29242 | 0 | 0 | 09000064814b255e | ||
| BOEM_FRDOC_0001-0225 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Eastern Gulf of Mexico Planning Area, Outer Continental Shelf, Sale 225 (EPA Sale 225) | Notice | 2013-12-04T05:00:00Z | 2013 | 12 | 2013-12-04T05:00:00Z | 2013-12-04T14:26:29Z | 2013-28934 | 0 | 0 | 09000064814a61a9 | ||
| BOEM_FRDOC_0001-0224 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Assessments; Availability, etc.: Oil, Gas, and Mineral Operations by the Gulf of Mexico Outer Continental Shelf Region | Notice | 2013-12-02T05:00:00Z | 2013 | 12 | 2013-12-02T05:00:00Z | 2013-12-02T14:06:02Z | 2013-28728 | 0 | 0 | 09000064814a2107 | ||
| BOEM_FRDOC_0001-0222 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Oil Spill Financial Responsibility for Offshore Facilities | Notice | 2013-11-06T05:00:00Z | 2013 | 11 | 2013-11-06T05:00:00Z | 2013-12-07T04:59:59Z | 2013-11-07T21:10:55Z | 2013-26591 | 0 | 0 | 09000064814724fa | |
| BOEM_FRDOC_0001-0221 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Leasing of Sulphur or Oil and Gas in the Outer Continental Shelf and Pipeline Rights of Way | Notice | 2013-11-04T05:00:00Z | 2013 | 11 | 2013-11-04T05:00:00Z | 2014-01-04T04:59:59Z | 2013-11-04T15:40:59Z | 2013-26334 | 0 | 0 | 090000648146f283 | |
| BOEM_FRDOC_0001-0216 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: General and Oil and Gas Production Requirements in the Outer Continental Shelf | Notice | 2013-10-28T04:00:00Z | 2013 | 10 | 2013-10-28T04:00:00Z | 2013-11-28T04:59:59Z | 2013-10-28T13:05:01Z | 2013-25322 | 0 | 0 | 0900006481463115 | |
| BOEM_FRDOC_0001-0217 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Impact Statements; Availability, etc.: Outer Continental Shelf, Gulf of Mexico, Oil and Gas Lease Sales, Western Planning Area Lease Sales 238, 246, and 248 | Notice | 2013-10-28T04:00:00Z | 2013 | 10 | 2013-10-28T04:00:00Z | 2013-12-13T04:59:59Z | 2013-10-28T13:10:53Z | 2013-25329 | 0 | 0 | 0900006481463322 | |
| BOEM_FRDOC_0001-0219 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Central Gulf of Mexico Planning Area Outer Continental Shelf Sale 231 | Notice | 2013-10-28T04:00:00Z | 2013 | 10 | 2013-10-28T04:00:00Z | 2013-10-28T13:11:27Z | 2013-25325 | 0 | 0 | 09000064814633cf | ||
| BOEM_FRDOC_0001-0214 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Project Planning for the Use of Outer Continental Shelf Sand, Gravel, and Shell Resources in Construction Projects that Qualify for a Negotiated Noncompetitive Agreement | Notice | 2013-10-03T04:00:00Z | 2013 | 10 | 2013-10-03T04:00:00Z | 2013-12-03T04:59:59Z | 2013-10-03T13:39:42Z | 2013-24248 | 0 | 0 | 0900006481444a56 | |
| BOEM_FRDOC_0001-0213 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Proposed Oil and Gas Lease Sales: Outer Continental Shelf, Alaska Region, Chukchi Sea Planning Area; Call for Information and Nominations; Correction | Notice | 2013-10-02T04:00:00Z | 2013 | 10 | 2013-10-02T04:00:00Z | 2013-10-02T13:05:36Z | 2013-24053 | 0 | 0 | 09000064814437b9 | ||
| BOEM_FRDOC_0001-0208 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Right-of-Way Grant of Submerged Lands: Outer Continental Shelf to Support Renewable Energy Development | Notice | 2013-08-06T04:00:00Z | 2013 | 8 | 2013-08-06T04:00:00Z | 2013-08-06T13:32:40Z | 2013-18949 | 0 | 0 | 0900006481391286 | ||
| BOEM_FRDOC_0001-0206 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Environmental Documents Prepared for Oil, Gas, and Mineral Operations: Mexico Outer Continental Shelf (OCS) Region | Notice | 2013-08-06T04:00:00Z | 2013 | 8 | 2013-08-06T04:00:00Z | 2013-08-06T13:32:39Z | 2013-19097 | 0 | 0 | 0900006481391181 | ||
| BOEM_FRDOC_0001-0207 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Agency Information Collection Activities; Proposals, Submissions, and Approvals: Forms for Oil Spill Financial Responsibility for Offshore Facilities | Notice | 2013-08-06T04:00:00Z | 2013 | 8 | 2013-08-06T04:00:00Z | 2013-10-08T03:59:59Z | 2013-08-06T13:32:38Z | 2013-18923 | 0 | 0 | 0900006481391253 | |
| BOEM_FRDOC_0001-0204 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Gulf of Mexico, Outer Continental Shelf, Western Planning Area, Sale 233 | Notice | 2013-07-29T04:00:00Z | 2013 | 7 | 2013-07-29T04:00:00Z | 2013-07-29T13:55:25Z | 2013-18173 | 0 | 0 | 09000064813825c0 | ||
| BOEM_FRDOC_0001-0203 | BOEM | Recently Posted BOEM Rules and Notices. BOEM_FRDOC_0001 | Oil and Gas Lease Sales: Western Gulf of Mexico Planning Area, Outer Continental Shelf, Sale 233 | Notice | 2013-07-29T04:00:00Z | 2013 | 7 | 2013-07-29T04:00:00Z | 2013-07-29T13:55:25Z | 2013-18175 | 0 | 0 | 09000064813823e7 |
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;