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.
8 rows where agency_id = "FTC" sorted by comment_end_datetime descending
This data as json, CSV (advanced)
agency_id 1
- FTC · 8 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FTC-2026-1651-0001 | FTC | FTC-2026-1651 | Agency Information Collection Activities; Proposed Collection; Comment Request; Extension | Notice | 2026-10-14 | 2026 | 10 | 2026-10-14 | 2026-12-14 | 2026-12-15 04:59:59 | 0 | 2026-11-14 10:00:49 | 2026-20971 | 1 | 0 | 09000064b966b03e | |
| FTC-2026-1652-0001 | FTC | FTC-2026-1652 | Agency Information Collection Activities; Proposed Collection; Comment Request; Extension | Notice | 2026-10-14 | 2026 | 10 | 2026-10-13 | 2026-12-14 | 2026-12-15 04:59:59 | 0 | 2026-11-17 10:00:32 | 2026-20970 | 1 | 0 | 09000064b966aefb | |
| FTC-2026-1783-0001 | FTC | FTC-2026-1783 | Petition for Rulemaking of New Hope Now | Proposed Rule | 2026-11-05 | 2026 | 11 | 2026-11-04 | 2026-12-07 | 2026-12-08 04:59:59 | 0 | 2026-11-06 10:00:53 | 2026-22581 | 1 | 0 | 09000064b96ed348 | |
| FTC-2026-1585-0002 | FTC | FTC-2026-1585 | Request for Public Comments on Agricultural Equipment Sector | Notice | 2026-10-07 | 2026 | 10 | 2026-10-07 | 2026-12-07 | 2026-12-08 04:59:59 | 0 | 2026-11-15 10:00:32 | 1 | 0 | 09000064b964ddc0 | ||
| FTC-2026-1552-0001 | FTC | FTC-2026-1552 | Rule on Impersonation of Government and Businesses | Proposed Rule | 2026-10-01 | 2026 | 10 | 2026-10-01 | 2026-11-30 | 2026-12-01 04:59:59 | 0 | 2026-11-17 10:00:28 | 2026-20143 | 1 | 0 | 09000064b95fa7a2 | |
| FTC-2026-1750-0001 | FTC | FTC-2026-1750 | Agency Information Collection Activities; Proposed Collection; Comment Request; Extension | Notice | 2026-10-26 | 2026 | 10 | 2026-10-26 | 2026-11-25 | 2026-11-26 04:59:59 | 0 | 2026-11-17 10:00:39 | 2026-21798 | 1 | 0 | 09000064b96a391d | |
| FTC-2026-1717-0001 | FTC | FTC-2026-1717 | Publicis and LiveRamp; Analysis of Proposed Agreement Containing Consent Order To Aid Public Comment | Notice | 2026-10-23 | 2026 | 10 | 2026-10-22 | 2026-11-23 | 2026-11-24 04:59:59 | 0 | 2026-11-08 10:01:05 | 2026-21659 | 1 | 0 | 09000064b969a84e | |
| FTC-2026-1618-0001 | FTC | FTC-2026-1618 | Petition for Rulemaking of Jason Plotzker | Proposed Rule | 2026-10-21 | 2026 | 10 | 2026-10-20 | 2026-11-20 | 2026-11-21 04:59:59 | 0 | 2026-11-14 10:00:52 | 2026-21510 | 1 | 0 | 09000064b968c959 |
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 2