documents
Data license: Public Domain (U.S. Government data) · Data source: Regulations.gov API (General Services Administration)
- perpetual_docket
- 1 = a standing/perpetual docket carrying a sentinel comment-end date (2050 or later; in practice 2099/2100 — agency guidance and exemption dockets that never close). 0 = an ordinary docket with a real deadline. NULL = no end date reported. The site's Open-for-Comment surface EXCLUDES perpetual_docket = 1 by default, so the site count and the bulk dump answer the same question differently: the dump is complete and includes them.
- comment_end_date
- The comment deadline as an Eastern (America/New_York) calendar date — CORRECTED in the 2026-09-06 daily snapshot (DataDawn queue #498): a snapshot whose _metadata row comment_end_date_grain reads 'eastern' carries the Eastern date; the pre-correction snapshots (through 2026-09-05) held the UTC-rolled day, one day LATE on every end-of-day close. Federal comment periods close at 11:59:59 PM Eastern and the source publishes that instant in UTC ('2026-08-26T03:59:59Z' = the 2026-08-25 deadline). Prefer comment_end_datetime for any arithmetic and convert it to America/New_York yourself; never 'subtract a day' from this column.
- comment_end_datetime
- AUTHORITATIVE. The full UTC instant of the comment deadline ('2026-08-26 03:59:59' == 11:59:59 PM Eastern on 2026-08-25). Convert to America/New_York for the official date; prefer this column over comment_end_date for anything computed.
12 rows where agency_id = "USCG" sorted by comment_end_datetime descending
This data as json, CSV (advanced)
agency_id 1
- USCG · 12 ✖
| id | agency_id | docket_id | title | document_type | subtype | posted_date | posted_year | posted_month | comment_start_date | comment_end_date | comment_end_datetime ▲ | perpetual_docket | last_modified | fr_doc_num | open_for_comment | withdrawn | object_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USCG-2007-0001-0001 | USCG | USCG-2007-0001 | Instructions for Shell docket for USCG. | Other | 2007-10-02 | 2007 | 10 | 2007-10-02 | 2099-12-31 | 2100-01-01 04:59:59 | 1 | 2017-03-10 22:28:02 | 1 | 0 | 09000064802f553b | ||
| USCG-2026-0376-0001 | USCG | USCG-2026-0376 | Implementation of Electronic Submission of Mariner Course Completion Data | Rule | 2026-10-16 | 2026 | 10 | 2026-10-16 | 2028-11-25 | 2028-11-26 04:59:59 | 0 | 2026-10-16 16:44:48 | 2026-21146 | 1 | 0 | 09000064b967631c | |
| USCG-2026-0242-0001 | USCG | USCG-2026-0242 | Information Collection Request to Office of Management and Budget; OMB Control Number: 1625–0069 | Notice | 2026-11-20 | 2026 | 11 | 2026-11-19 | 2027-01-19 | 2027-01-20 04:59:59 | 0 | 2026-11-20 18:44:06 | 2026-23634 | 1 | 0 | 09000064b97314c9 | |
| USCG-2025-0392-0001 | USCG | USCG-2025-0392 | Clarification of Certain Mariner Training Requirements | Proposed Rule | 2026-10-01 | 2026 | 10 | 2026-10-01 | 2026-12-30 | 2026-12-31 04:59:59 | 0 | 2026-11-13 10:01:21 | 2026-20087 | 1 | 0 | 09000064b95fa70e | |
| USCG-2026-0830-0001 | USCG | USCG-2026-0830 | Safety Zone; Hackensack River, Kearny and Secaucus, NJ | Rule | 2026-11-19 | 2026 | 11 | 2026-11-19 | 2026-12-21 | 2026-12-22 04:59:59 | 0 | 2026-11-19 18:41:39 | 2026-23567 | 1 | 0 | 09000064b972c866 | |
| USCG-2026-0377-0001 | USCG | USCG-2026-0377 | Proposed Decommissioning and Disposition of USCGC Smilax (WLIC 315) | Notice | 2026-11-19 | 2026 | 11 | 2026-11-19 | 2026-12-21 | 2026-12-22 04:59:59 | 0 | 2026-11-20 10:00:30 | 2026-23566 | 1 | 0 | 09000064b972e145 | |
| USCG-2025-0147-0005 | USCG | USCG-2025-0147 | Collection of Information Under Review by Office of Management and Budget; OMB Control Number: 1625-0100 | Notice | 2026-11-09 | 2026 | 11 | 2026-11-08 | 2026-12-09 | 2026-12-10 04:59:59 | 0 | 2026-11-09 18:39:49 | 2026-22733 | 1 | 0 | 09000064b96faade | |
| USCG-2026-1338-0001 | USCG | USCG-2026-1338 | Drawbridge Operation Regulation; Harlem River, Between the Boroughs of Manhattan and the Bronx, New York City, New York | Proposed Rule | 2026-11-06 | 2026 | 11 | 2026-11-05 | 2026-12-07 | 2026-12-08 04:59:59 | 0 | 2026-11-07 10:01:00 | 2026-22734 | 1 | 0 | 09000064b96f28f0 | |
| USCG-2025-0396-0003 | USCG | USCG-2025-0396 | Collection of Information Under Review by Office of Management and Budget; OMB Control Number: 1625-0072 | Notice | 2026-11-03 | 2026 | 11 | 2026-11-03 | 2026-12-03 | 2026-12-04 04:59:59 | 0 | 2026-11-16 18:50:39 | 2026-22362 | 1 | 0 | 09000064b96d0416 | |
| USCG-2026-0941-0001 | USCG | USCG-2026-0941 | Safety Zone; Southern California Annual Firework Events for the Los Angeles-Long Beach Captain of the Port Zone | Proposed Rule | 2026-10-27 | 2026 | 10 | 2026-10-26 | 2026-11-27 | 2026-11-28 04:59:59 | 0 | 2026-11-19 10:01:06 | 2026-21918 | 1 | 0 | 09000064b96a7f60 | |
| USCG-2026-0374-0001 | USCG | USCG-2026-0374 | Cooperative Research and Development Agreement: Super Intelligence (SI) Situational Awareness Tools for Analyzing Coast Guard (CG) Sensor Feeds for Search and Rescue (SAR) | Notice | 2026-10-26 | 2026 | 10 | 2026-10-26 | 2026-11-25 | 2026-11-26 04:59:59 | 0 | 2026-11-18 10:01:01 | 2026-21723 | 1 | 0 | 09000064b96a3925 | |
| USCG-2024-0407-0005 | USCG | USCG-2024-0407 | Drawbridge Operation Regulation; Manitowoc River, Manitowoc, WI | Proposed Rule | 2026-10-22 | 2026 | 10 | 2026-10-22 | 2026-11-23 | 2026-11-24 04:59:59 | 0 | 2026-11-22 10:00:36 | 2026-21608 | 1 | 0 | 09000064b9695a76 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE documents (
id TEXT PRIMARY KEY,
agency_id TEXT,
docket_id TEXT,
title TEXT,
document_type TEXT,
subtype TEXT,
posted_date TEXT,
posted_year INTEGER,
posted_month INTEGER,
comment_start_date TEXT,
comment_end_date TEXT, -- EASTERN calendar date of the close (queue #498 writer
-- fix, 2026-09-05; was the UTC-rolled day AFTER the ET
-- deadline before that). Display-grade only.
comment_end_datetime TEXT, -- full UTC close ("YYYY-MM-DD HH:MM:SS", queue #498):
-- the API expresses the 11:59:59 PM ET deadline as a UTC
-- datetime. AUTHORITATIVE: the predicate, days_left and
-- any timezone-aware render derive from THIS column.
perpetual_docket INTEGER, -- 1 = sentinel end date (queue #464); NULL = no end date
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_comment_end ON documents(comment_end_date);
CREATE INDEX idx_docs_withdrawn ON documents(withdrawn);
CREATE INDEX idx_docs_perpetual ON documents(perpetual_docket);
document_type 4