home / open_comments

documents

Federal regulatory documents currently open for public comment. ⚠ Derive comment deadlines from comment_end_datetime converted to America/New_York, never from comment_end_date, which is mid-correction and may be one day late (DataDawn queue #498).

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.

16 rows where agency_id = "FEMA" sorted by comment_end_datetime descending

✎ View and edit SQL

This data as json, CSV (advanced)

document_type 1

  • Notice 16

agency_id 1

  • FEMA · 16 ✖
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
FEMA-2026-0002-0079 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-11-13 2026 11 2026-11-13 2027-02-11 2027-02-12 04:59:59 0 2026-11-13 18:34:16 2026-23165 1 0 09000064b971b54e
FEMA-2026-0002-0082 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-11-13 2026 11 2026-11-13 2027-02-11 2027-02-12 04:59:59 0 2026-11-13 18:39:36 2026-23164 1 0 09000064b971b440
FEMA-2026-0826-0001 FEMA FEMA-2026-0826 Agency Information Collection Activities: Proposed Collection, Comment Request; Standard Flood Hazard Determination Form (SFHDF) Notice   2026-11-19 2026 11 2026-11-18 2027-01-19 2027-01-20 04:59:59 0 2026-11-19 18:38:21 2026-23602 1 0 09000064b972e19d
FEMA-2026-0793-0001 FEMA FEMA-2026-0793 Agency Information Collection Activities: Proposed Collection; Comment Request; State, Tribe, and Territory Disaster Case Management (DCM) Federal Award Notice   2026-11-20 2026 11 2026-11-20 2027-01-19 2027-01-20 04:59:59 0 2026-11-21 10:01:01 2026-23726 1 0 09000064b972e1ee
FEMA-2026-0002-0072 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-10-14 2026 10 2026-10-14 2027-01-12 2027-01-13 04:59:59 0 2026-10-14 16:53:19 2026-20913 1 0 09000064b966affc
FEMA-2026-0002-0073 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-10-14 2026 10 2026-10-14 2027-01-12 2027-01-13 04:59:59 0 2026-10-14 16:53:19 2026-20914 1 0 09000064b966afba
FEMA-2026-0002-0069 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-10-14 2026 10 2026-10-14 2027-01-12 2027-01-13 04:59:59 0 2026-10-14 16:53:20 2026-20911 1 0 09000064b966b03f
FEMA-2026-0002-0070 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-10-14 2026 10 2026-10-14 2027-01-12 2027-01-13 04:59:59 0 2026-10-14 16:53:20 2026-20926 1 0 09000064b966b03c
FEMA-2026-0002-0076 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-10-14 2026 10 2026-10-14 2027-01-12 2027-01-13 04:59:59 0 2026-10-14 16:57:04 2026-20912 1 0 09000064b966aef5
FEMA-2026-0002-0078 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-10-14 2026 10 2026-10-14 2027-01-12 2027-01-13 04:59:59 0 2026-10-14 17:01:57 2026-20910 1 0 09000064b966aeb0
FEMA-2025-0344-0009 FEMA FEMA-2025-0344 Agency Information Collection Activities: Submission for OMB Review, Comment Request; Environmental and Historic Preservation Screening Form Notice   2026-11-20 2026 11 2026-11-20 2026-12-21 2026-12-22 04:59:59 0 2026-11-20 19:22:46 2026-23727 1 0 09000064b9731359
FEMA-2026-0661-0001 FEMA FEMA-2026-0661 Agency Information Collection Activities: Proposed Collection, Comment Request; FEMA Preparedness Grants: Tribal Homeland Security Grant Program (THSGP) Notice   2026-10-16 2026 10 2026-10-16 2026-12-15 2026-12-16 04:59:59 0 2026-10-23 09:00:44 2026-21199 1 0 09000064b9676291
FEMA-2026-0298-0006 FEMA FEMA-2026-0298 Agency Information Collection Activities: Submission for OMB Review, Comment Request; Homeland Security Exercise and Evaluation Program (HSEEP) Documentation Notice   2026-11-10 2026 11 2026-11-09 2026-12-10 2026-12-11 04:59:59 0 2026-11-10 21:54:24 2026-22857 1 0 09000064b9700a8b
FEMA-2026-0002-0063 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-09-10 2026 9 2026-09-10 2026-12-09 2026-12-10 04:59:59 0 2026-09-10 17:03:17 2026-18406 1 0 09000064b95118f7
FEMA-2026-0002-0066 FEMA FEMA-2026-0002 Proposed Flood Hazard Determinations Notice   2026-09-10 2026 9 2026-09-10 2026-12-09 2026-12-10 04:59:59 0 2026-09-10 17:07:04 2026-18408 1 0 09000064b950a5a1
FEMA-2026-0232-0004 FEMA FEMA-2026-0232 Agency Information Collection Activities: Submission for OMB Review, Comment Request; Application for Participation in the National Flood Insurance Program Notice   2026-10-28 2026 10 2026-10-28 2026-11-27 2026-11-28 04:59:59 0 2026-10-28 16:33:44 2026-21941 1 0 09000064b96b01d9

Advanced export

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

CSV options:

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);
Powered by Datasette · Queries took 5.164ms · Data license: Public Domain (U.S. Government data) · Data source: Regulations.gov API (General Services Administration) · Privacy