comment_details

Full comment text and metadata for a subset of Regulations.gov comments, from the regulations.gov API channel. Includes submitter type and organization. Includes attachment counts and links; the attachment files themselves are not included. Where the served build also carries the bulk-export merge (build_metadata.bulk_merge), most comments have text in comment_texts (reached through comment_bodies.body_sha256); DataDawn serves the API text where it exists, else the bulk text, and labels which. Withdrawn comments carry no text in either table by policy (decisions_log §128). ⚠ PARTICIPATION: where an agency folded a mass-comment campaign into a single record carrying an asserted count (comment_details.duplicate_comments), the same campaign usually also appears as thousands of individual records — measured 2026-08-30 across the regulations.gov bulk exports, 94.1% of dockets with a folded campaign also hold an unfolded one. Neither the record count nor the asserted count is the number of people who commented, and the two must never be summed. https://datadawn.org/methodology.html#participation

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

duplicate_comments
Agency-asserted count of duplicate submissions folded into this record, as reported by regulations.gov (its "Duplicate Comments" field). Not a count of comments and not additive with the record count: the same campaign frequently also appears as thousands of individual records. Blank or 1 means no fold was asserted. See https://datadawn.org/methodology.html#participation

0 rows where id = "EPA-HQ-OW-2025-0322-15460"

✎ View and edit SQL

This data as json

0 records

CREATE TABLE comment_details (
    id TEXT PRIMARY KEY REFERENCES comments(id),
    comment_text TEXT,
    organization TEXT,
    organization_normalized TEXT,
    first_name TEXT,
    last_name TEXT,
    city TEXT,
    state_province TEXT,
    zip TEXT,
    country TEXT,
    subtype TEXT,
    category TEXT,
    tracking_number TEXT,
    duplicate_comments INTEGER,
    comment_on_document_id TEXT,
    receive_date TEXT,
    postmark_date TEXT,
    gov_agency TEXT,
    gov_agency_type TEXT,
    page_count INTEGER,
    attachment_count INTEGER,
    attachment_urls TEXT
);
CREATE INDEX idx_cd_org ON comment_details(organization) WHERE organization IS NOT NULL;
CREATE INDEX idx_cd_org_norm ON comment_details(organization_normalized) WHERE organization_normalized IS NOT NULL;
CREATE INDEX idx_cd_state ON comment_details(state_province) WHERE state_province IS NOT NULL;
CREATE INDEX idx_cd_subtype ON comment_details(subtype);
CREATE INDEX idx_cd_comment_on ON comment_details(comment_on_document_id);