home / openregs

documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

54 rows where agency_id = "BOEM" and document_type = "Rule" sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

posted_year 15

  • 2025 8
  • 2010 7
  • 2011 6
  • 2016 6
  • 2024 6
  • 2023 4
  • 2014 2
  • 2015 2
  • 2017 2
  • 2018 2
  • 2019 2
  • 2020 2
  • 2021 2
  • 2022 2
  • 2012 1

document_type 1

  • Rule · 54 ✖

agency_id 1

  • BOEM · 54 ✖
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-2025-0038-0002 BOEM Rescinding 30 CFR 551.14(b)(5) and (6) BOEM-2025-0038 Rescission of Expired 1-Year Grace Period for Data Extensions; Corrections Rule   2025-09-25T04:00:00Z 2025 9 2025-09-25T04:00:00Z   2025-09-25T19:52:27Z 2025-18561 0 0 09000064b8fdb04c
BOEM-2025-0038-0001 BOEM Rescinding 30 CFR 551.14(b)(5) and (6) BOEM-2025-0038 Rescission of Expired 1-Year Grace Period for Data Extensions Rule   2025-08-12T04:00:00Z 2025 8 2025-08-12T04:00:00Z   2025-08-12T17:05:59Z 2025-15325 0 0 09000064b8ef8a94
BOEM-2025-0036-0001 BOEM Rescinding 30 CFR 585.150 BOEM-2025-0036 Rescission of Renewable Energy Leasing Schedule Rule   2025-08-05T04:00:00Z 2025 8 2025-08-05T04:00:00Z 2025-08-21T03:59:59Z 2025-08-21T09:01:13Z 2025-14805 0 0 09000064b8ededa2
BOEM-2025-0024-0001 BOEM 30 CFR 556.103 Cross References BOEM-2025-0024 Rescission of Cross References Rule   2025-07-22T04:00:00Z 2025 7 2025-07-22T04:00:00Z   2025-07-22T22:36:01Z 2025-13780 0 0 09000064b8e94184
BOEM-2025-0010-0001 BOEM Restoring Names that Honor American Greatness: Gulf of America BOEM-2025-0010 Restoring Names that Honor American Greatness: Gulf of America Rule   2025-06-06T00:00:00Z 2025 6     2025-06-06T17:24:38Z 2025-10068 0 0 09000064b8dddbb6
BOEM-2023-0012-0041 BOEM Protection of Marine Archaeological Resources BOEM-2023-0012 Protection of Marine Archaeological Resources Rule   2025-04-14T04:00:00Z 2025 4     2025-04-14T16:14:04Z 2025-06291 0 0 0900006486a8e511
BOEM-2025-0001-0001 BOEM 2025 Civil Penalties Inflation Adjustments for Oil, Gas, and Sulfur Operations in the Outer Continental Shelf BOEM-2025-0001 Civil Monetary Penalty Inflation Adjustment Rule   2025-01-13T05:00:00Z 2025 1 2025-01-13T05:00:00Z   2025-01-14T13:35:08Z 2025-00257 0 0 09000064868b674f
BOEM-2023-0012-0036 BOEM Protection of Marine Archaeological Resources BOEM-2023-0012 Protection of Marine Archaeological Resources Rule   2024-09-03T04:00:00Z 2024 9 2024-09-03T04:00:00Z 2024-10-04T03:59:59Z 2025-02-23T05:53:37Z 2024-19188 0 0 09000064866bd561
BOEM-2024-0037-0001 BOEM 2024 Adjustment of Service Fees for Outer Continental Shelf Activities BOEM-2024-0037 Adjustment of Service Fees for Outer Continental Shelf Activities Rule   2024-08-30T04:00:00Z 2024 8 2024-08-30T04:00:00Z   2024-08-30T14:10:14Z 2024-18798 0 0 09000064866b583c
BOEM-2023-0027-2188 BOEM Risk Management and Financial Assurance for OCS Lease and Grant Obligations BOEM-2023-0027 Risk Management and Financial Assurance for OCS Lease and Grant Obligations; Correction Rule   2024-05-31T04:00:00Z 2024 5 2024-05-31T04:00:00Z   2024-05-31T13:34:14Z 2024-11914 0 0 090000648658e3a2
BOEM-2023-0005-0251 BOEM Renewable Energy Modernization Rule BOEM-2023-0005 Renewable Energy Modernization Rule Rule   2024-05-15T04:00:00Z 2024 5 2024-05-15T04:00:00Z   2024-05-15T13:15:00Z 2024-08791 0 0 0900006486566a92
BOEM-2023-0027-2170 BOEM Risk Management and Financial Assurance for OCS Lease and Grant Obligations BOEM-2023-0027 Risk Management and Financial Assurance for Outer Continental Shelf Lease and Grant Obligations Rule   2024-04-24T04:00:00Z 2024 4 2024-04-24T04:00:00Z 2024-05-25T03:59:59Z 2024-04-24T13:24:55Z 2024-08309 0 0 09000064864eb91c
BOEM-2024-0002-0001 BOEM 2024 Civil Penalties Inflation Adjustments for Oil, Gas, and Sulfur Operations in the Outer Continental Shelf BOEM-2024-0002 Civil Monetary Penalty Inflation Adjustment Rule   2024-01-25T05:00:00Z 2024 1 2024-01-25T05:00:00Z   2024-01-25T16:10:05Z 2024-01412 0 0 09000064863c2372
BOEM-2023-0035-0001 BOEM Conformity With the Inflation Reduction Act for Renewable Energy on the Outer Continental Shelf BOEM-2023-0035 Conformity with the Inflation Reduction Act for Renewable Energy on the Outer Continental Shelf Rule   2023-10-04T04:00:00Z 2023 10 2023-10-04T04:00:00Z 2023-11-04T03:59:59Z 2023-10-12T14:14:06Z 2023-21713 0 0 0900006486033ddc
BOEM-2023-0002-0002 BOEM Oil Spill Financial Responsibility Adjustment of the Limit of Liability for Offshore Facilities BOEM-2023-0002 Oil Spill Financial Responsibility Adjustment of the Limit of Liability for Offshore Facilities Rule   2023-04-14T04:00:00Z 2023 4 2023-04-14T04:00:00Z   2023-04-24T15:33:06Z 2023-07931 0 0 0900006485948e27
BOEM-2023-0001-0001 BOEM 2023 Civil Penalties Inflation Adjustments for Oil, Gas, and Sulfur Operations in the Outer Continental Shelf BOEM-2023-0001 Civil Monetary Penalty Inflation Adjustment: Oil, Gas, and Sulfur Operations in the Outer Continental Shelf Rule   2023-02-15T05:00:00Z 2023 2 2023-02-15T05:00:00Z   2023-02-16T12:23:13Z 2023-03217 0 0 090000648569e737
BOEM-2022-0042-0001 BOEM Joint BOEM/BSEE Direct Final Rule: Reorganization of Title 30-Renewable Energy and Alternate Uses of Existing Facilities on the Outer Continental Shelf BOEM-2022-0042 Reorganization of Title 30; Renewable Energy and Alternate Uses of Existing Facilities on the Outer Continental Shelf Rule   2023-01-31T05:00:00Z 2023 1 2023-01-31T05:00:00Z   2023-02-02T12:10:29Z 2023-00871 0 0 090000648561ed7f
BOEM-2022-0022-0001 BOEM Adjustment of Service Fees for Outer Continental Shelf Activities BOEM-2022-0022 Adjustment of Service Fees for Outer Continental Shelf Activities Rule   2022-08-26T04:00:00Z 2022 8 2022-08-26T04:00:00Z   2022-08-26T13:15:08Z 2022-18388 0 0 0900006485278f24
BOEM-2022-0004-0001 BOEM 2022 Civil Penalties Inflation Adjustments for Oil, Gas, and Sulfur Operations in the Outer Continental Shelf BOEM-2022-0004 Civil Monetary Penalty Inflation Adjustment: Oil,Gas, and Sulfur Operations in the Outer Continental Shelf Rule   2022-03-18T04:00:00Z 2022 3 2022-03-18T04:00:00Z   2022-04-29T20:06:02Z 2022-05633 0 0 0900006484fd34e1
BOEM-2021-0028-0001 BOEM Oil and Gas and Sulfur Operations in the Outer Continental Shelf — Maximum Daily Civil Penalty Amounts for Violations of the Federal Oil and Gas Royalty Management Act BOEM-2021-0028 Maximum Daily Civil Penalty Amounts for Violations of the Federal Oil and Gas Royalty Management Act Rule   2021-07-22T04:00:00Z 2021 7 2021-07-22T04:00:00Z   2021-07-23T11:47:12Z 2021-15388 0 0 0900006484c0777c
BOEM-2021-0006-0001 BOEM Commercial Leasing for Wind Power Development on the Outer Continental Shelf (OCS) Offshore California – Call for Information and Nominations (Call) BOEM-2021-0006 2021 Civil Penalties Inflation Adjustments for Oil, Gas, and Sulfur Operations in the Outer Continental Shelf Rule   2021-04-15T04:00:00Z 2021 4 2021-04-15T04:00:00Z   2021-06-21T19:04:37Z 2021-07722 0 0 0900006484aa83d4
BOEM-2018-0038-0001 BOEM Air Quality Control, Reporting, and Compliance BOEM-2018-0038 Air Quality Control, Reporting, and Compliance Rule   2020-06-05T04:00:00Z 2020 6 2020-06-05T04:00:00Z   2020-06-12T18:39:27Z 2020-11573 0 0 09000064846cdfb5
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-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-2017-0079-0002 BOEM Oil and Gas Sulphur Operations in the Outer Continental Shelf-Civil Penalties Inflation Adjustments BOEM-2017-0079 Oil and Gas and Sulfur Operations in the Outer Continental Shelf: Civil Penalties Inflation Adjustments Rule   2019-03-26T04:00:00Z 2019 3 2019-03-26T04:00:00Z   2019-04-11T00:33:23Z 2019-05577 0 0 0900006483b2e437
BOEM-2017-0079-0001 BOEM Oil and Gas Sulphur Operations in the Outer Continental Shelf-Civil Penalties Inflation Adjustments BOEM-2017-0079 Oil and Gas and Sulfur Operations: Outer Continental Shelf-Civil Penalties Inflation Adjustments Rule   2018-03-02T05:00:00Z 2018 3 2018-03-02T05:00:00Z   2018-04-02T13:18:50Z 2018-04248 0 0 0900006482f85238
BOEM-2017-0048-0001 BOEM Oil Spill Financial Responsibility Adjustment of the Limit of Liability for Offshore Facilities BOEM-2017-0048 Oil Spill Financial Responsibility Adjustment of the Limit of Liability for Offshore Facilities Rule   2018-01-18T05:00:00Z 2018 1 2018-01-18T05:00:00Z   2018-01-26T15:17:03Z 2018-00798 0 0 0900006482e25f8a
BOEM-2010-0041-0013 BOEM Negotiated Noncompetitive Leasing of Minerals Other than Oil, Gas and Sulphur on the OCS BOEM-2010-0041 Negotiated Noncompetitive Agreements for the Use of Sand, Gravel, and/or Shell Resources on the Outer Continental Shelf Rule   2017-10-03T04:00:00Z 2017 10 2017-10-03T04:00:00Z   2017-10-03T15:11:30Z 2017-21233 0 0 0900006482b9372d
BOEM-2016-0055-0002 BOEM Oil and Gas and Sulphur Operations in the Outer Continental Shelf -- Civil Penalties Inflation Adjustment BOEM-2016-0055 Oil and Gas and Sulphur Operations in the Outer Continental Shelf-Civil Penalties Inflation Adjustments Rule   2017-02-15T05:00:00Z 2017 2 2017-02-15T05:00:00Z   2017-03-16T18:50:07Z 2017-02983 0 0 09000064824c2684
BOEM-2016-0031-0014 BOEM Leasing of Sulfur or Oil and Gas in the Outer Continental Shelf BOEM-2016-0031 Oil and Gas Leases: Leasing of Sulfur or Oil and Gas in Outer Continental Shelf Rule   2016-10-12T04:00:00Z 2016 10 2016-10-12T04:00:00Z   2017-03-14T15:32:42Z 2016-24586 0 0 09000064822e6dba
BOEM-2017-0022-0001 BOEM Regulatory Guidance: Lessees and Operators of Federal Oil and Gas, and Sulfur Leases, and Holders of Pipeline Right-of-Way and Right-of-Use and Easement Grants in the OCS-Requiring Additional Security BOEM-2017-0022 Regulatory Guidance: Lessees and Operators of Federal Oil and Gas, and Sulfur Leases, and Holders of Pipeline Right-of-Way and Right-of-Use and Easement Grants in the Outer Continental Shelf-Requiring Additional Security Rule   2016-07-18T04:00:00Z 2016 7 2016-07-18T04:00:00Z   2017-03-22T18:34:28Z 2016-16846 0 0 09000064820bfda4
BOEM-2013-0071-0001 BOEM Alaska Regulations BOEM-2013-0071 Oil and Gas and Sulfur Operations on the Outer Continental Shelf: Requirements for Exploratory Drilling on the Arctic Outer Continental Shelf Rule   2016-07-15T04:00:00Z 2016 7 2016-07-15T04:00:00Z   2017-03-15T15:57:46Z 2016-15699 0 0 09000064820b3df2
BOEM-2016-0055-0001 BOEM Oil and Gas and Sulphur Operations in the Outer Continental Shelf -- Civil Penalties Inflation Adjustment BOEM-2016-0055 Oil and Gas and Sulphur Operations in the Outer Continental Shelf--Civil Penalties Inflation Adjustments Rule   2016-07-01T04:00:00Z 2016 7 2016-07-01T04:00:00Z 2016-08-31T03:59:59Z 2016-07-25T18:35:49Z 2016-15607 0 0 0900006482080667
BOEM-2016-0031-0015 BOEM Leasing of Sulfur or Oil and Gas in the Outer Continental Shelf BOEM-2016-0031 Leasing of Sulfur or Oil and Gas in the Outer Continental Shelf; Correction Rule   2016-05-31T04:00:00Z 2016 5 2016-05-31T04:00:00Z   2017-03-15T18:23:16Z 2016-12095 0 0 0900006481fff77e
BOEM-2016-0031-0001 BOEM Leasing of Sulfur or Oil and Gas in the Outer Continental Shelf BOEM-2016-0031 Leasing of Sulfur or Oil and Gas in the Outer Continental Shelf Rule   2016-03-30T04:00:00Z 2016 3 2016-03-30T04:00:00Z   2016-05-04T19:25:52Z 2016-06513 0 0 0900006481eea6b8
BOEM-2017-0018-0002 BOEM GOMESA - Allocation and Disbursement of Royalties, Rentals, and Bonuses—Oil and Gas, Offshore BOEM-2017-0018 Allocation and Disbursement of Royalties, Rentals, and Bonuses-Oil and Gas, Offshore, Rule   2015-12-30T05:00:00Z 2015 12 2015-12-30T05:00:00Z   2017-03-16T12:23:53Z 2015-32787 0 0 0900006481ddb98d
BOEM-2015-0060-0001 BOEM Updating Addresses and Contact Information in BOEM Regulations BOEM-2015-0060 Updating Addresses and Contact Information in Bureau Regulations Rule   2015-09-22T04:00:00Z 2015 9 2015-09-22T04:00:00Z   2017-03-16T12:36:08Z 2015-23719 0 0 0900006481c8b97b
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-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-2010-0045-0091 BOEM AD71 Renewable Energy Alternate Uses of Existing Facilities on the Outer Continental Shelf - Acquire a Lease Noncompetitievely BOEM-2010-0045 Renewable Energy Alternate Uses of Existing Facilities on the Outer Continental Shelf: Acquire a Lease Non-competitively; Correction Rule   2012-01-09T05:00:00Z 2012 1 2012-01-09T05:00:00Z   2012-01-09T13:15:32Z 2012-00050 0 0 0900006480f90406
BOEM-2011-0070-0001 BOEM Direct Final Rule for BOEM and BSEE - 30 CFR Chapter II and Chapter V BOEM-2011-0070 Reorganization of Title 30: Bureaus of Safety and Environmental Enforcement and Ocean Energy Management Rule   2011-10-18T04:00:00Z 2011 10 2011-10-18T04:00:00Z   2011-10-18T13:34:01Z 2011-22675 0 0 0900006480f54e4f
BOEM-2010-0043-0042 BOEM BOEMRE FR Documents BOEM-2010-0043 Reorganization of Title 30, Code of Federal Regulations Rule   2011-07-01T04:00:00Z 2011 7 2011-07-01T04:00:00Z   2011-07-07T16:33:44Z 2011-16681 0 0 0900006480eb8289
BOEM-2010-0070-0001 BOEM 1010-AD74 - Oil and Gas and Sulphur Operations in the Outer Continental Shelf - Civil Penalties BOEM-2010-0070 Oil and Gas and Sulphur Operations in the Outer Continental Shelf; Civil Penalties Rule   2011-06-30T04:00:00Z 2011 6 2011-06-30T04:00:00Z   2011-06-30T12:52:05Z 2011-16288 0 0 0900006480eb737c
BOEM-2010-0045-0088 BOEM AD71 Renewable Energy Alternate Uses of Existing Facilities on the Outer Continental Shelf - Acquire a Lease Noncompetitievely BOEM-2010-0045 Renewable Energy Alternate Uses of Existing Facilities on Outer Continental Shelf; Acquire Lease Noncompetitively Rule   2011-05-16T04:00:00Z 2011 5 2011-05-16T04:00:00Z   2011-06-11T17:01:12Z 2011-11908 0 0 0900006480cd1b7b
BOEM-2010-0076-0001 BOEM Notice of Public Workshop on Oil and Gas and Sulphur Operations in the Outer Continental Shelf – Safety and Environmental Management Systems; Public Workshop BOEM-2010-0076 Oil and Gas and Sulphur Operations in the Outer Continental Shelf: Safety and Environmental Management Systems; Public Workshop Rule   2011-03-01T05:00:00Z 2011 3 2011-03-01T05:00:00Z   2011-03-01T13:58:31Z 2011-04334 0 0 0900006480bfb79f
BOEM-2010-0045-0010 BOEM AD71 Renewable Energy Alternate Uses of Existing Facilities on the Outer Continental Shelf - Acquire a Lease Noncompetitievely BOEM-2010-0045 Renewable Energy Alternate Uses of Existing Facilities on the Outer Continental Shelf: Acquire a Lease Noncompetitively; Withdrawal Rule   2011-01-25T05:00:00Z 2011 1 2011-01-25T05:00:00Z   2011-06-11T17:01:21Z 2011-01505 0 0 0900006480bd1f77
BOEM-2010-0034-0041 BOEM AD68 - Oil and Gas and Sulphur Operations in the Outer Continental Shelf–Increased Safety Measures for Energy Development on the Outer Continental Shelf BOEM-2010-0034 Increased Safety Measures for Energy Development on the Outer Continental Shelf Rule   2010-12-23T05:00:00Z 2010 12 2010-12-23T05:00:00Z 2011-01-25T04:59:59Z 2011-06-11T17:01:03Z 2010-32173 0 0 0900006480bbea4b
BOEM-2010-0034-0016 BOEM AD68 - Oil and Gas and Sulphur Operations in the Outer Continental Shelf–Increased Safety Measures for Energy Development on the Outer Continental Shelf BOEM-2010-0034 Oil and Gas and Sulphur Operations in the Outer Continental Shelf: Increased Safety Measures for Energy Development; Correction Rule   2010-12-09T05:00:00Z 2010 12 2010-12-09T05:00:00Z   2011-06-11T17:00:36Z 2010-30990 0 0 0900006480bb28d0
BOEM-2010-0045-0001 BOEM AD71 Renewable Energy Alternate Uses of Existing Facilities on the Outer Continental Shelf - Acquire a Lease Noncompetitievely BOEM-2010-0045 Acquire Lease Noncompetitively: Renewable Energy Alternate Uses of Existing Facilities on Outer Continental Shelf Rule   2010-11-26T05:00:00Z 2010 11 2010-11-26T05:00:00Z 2010-12-28T04:59:59Z 2011-06-11T17:01:07Z 2010-29761 0 0 0900006480ba4371
BOEM-2010-0048-0003 BOEM Reorganization of Title 30, Code of Federal Regulations BOEM-2010-0048 Reorganization of Title 30, Code of Federal Regulations Rule   2010-10-29T04:00:00Z 2010 10 2010-10-29T04:00:00Z   2010-11-19T14:10:10Z C1-2010-24721 0 0 0900006480b7abd2
BOEM-2010-0046-0001 BOEM AD15 - Oil and Gas and Sulphur Operations in the Outer Continental Shelf—Safety and Environmental Management Systems. BOEM-2010-0046 Safety and Environmental Management Systems: Oil and Gas and Sulphur Operations in Outer Continental Shelf Rule   2010-10-15T04:00:00Z 2010 10 2010-10-15T04:00:00Z   2011-06-11T17:01:25Z 2010-25665 0 0 0900006480b6fc36
BOEM-2010-0034-0001 BOEM AD68 - Oil and Gas and Sulphur Operations in the Outer Continental Shelf–Increased Safety Measures for Energy Development on the Outer Continental Shelf BOEM-2010-0034 Oil and Gas and Sulphur Operations in Outer Continental Shelf: Increased Safety Measures for Energy Development on Outer Continental Shelf Rule   2010-10-14T04:00:00Z 2010 10 2010-10-14T04:00:00Z 2010-12-14T04:59:59Z 2011-06-11T17:00:58Z 2010-25256 0 0 0900006480b6ee25
BOEM-2010-0048-0001 BOEM Reorganization of Title 30, Code of Federal Regulations BOEM-2010-0048 Reorganization of Title 30, Code of Federal Regulations Rule   2010-10-04T04:00:00Z 2010 10 2010-10-04T04:00:00Z 2010-11-04T03:59:59Z 2011-06-11T17:01:30Z 2010-24721 0 0 0900006480b6674a

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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;
Powered by Datasette · Queries took 1915.834ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API