documents

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

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

✎ View and edit SQL

This data as json, CSV (advanced)

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);