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.

25 rows where agency_id = "FAA" and document_type = "Notice" sorted by comment_end_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: docket_id, posted_date, posted_month, comment_start_date, comment_end_date, comment_end_datetime, posted_date (date), comment_start_date (date), comment_end_date (date), comment_end_datetime (date), last_modified (date)

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,
            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, so the date-only column above is the UTC-ROLLED
                                        -- day AFTER the official ET date. This column keeps the
                                        -- truth; predicate + any display fix derive from it.
            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);