comment_bodies

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

26,288,677 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE comment_bodies (
                   id TEXT PRIMARY KEY, body_sha256 TEXT,
                   first_name TEXT, last_name TEXT, organization TEXT, city TEXT,
                   state_province TEXT, zip TEXT, country TEXT, subtype TEXT, category TEXT,
                   tracking_number TEXT, comment_on_document_id TEXT, receive_date TEXT,
                   postmark_date TEXT, gov_agency TEXT, gov_agency_type TEXT,
                   reason_withdrawn TEXT, attachment_files TEXT, content_files TEXT,
                   duplicate_comments INTEGER, page_count INTEGER,
                   -- ⊞ RENAMED from `attachment_count` 2026-09-19. TWO CHANNELS COUNT TWO THINGS
                   -- AND THEY WERE SHARING A NAME. Measured against regulations.gov on 50 ids:
                   -- comment_details.attachment_count == the source's attachment RECORDS (50/50)
                   -- and bulk's value == the source's total fileFormats (50/50). Both faithful,
                   -- to different definitions. 35 of those 50 were an attachment record carrying
                   -- ZERO downloadable formats, so bulk reports 0 where a reader expects 1 —
                   -- corpus-wide that is 44,961 of 313,492 attachment-bearing comments (14.3%).
                   -- One name for both is how a future A.6 repoint would silently change what
                   -- "attachments" means on the served surface. Receipt:
                   -- openregs/working-docs/EXTERNAL_ANCHOR_2026-09-19.md.
                   attachment_format_count INTEGER,
                   -- DERIVED BY THIS BUILD, not copied: staging has no counterpart. See
                   -- _MAIN_ONLY_DERIVED and the UPDATE after the §6.6 fold.
                   organization_normalized TEXT);
CREATE INDEX idx_comment_bodies_sha ON comment_bodies(body_sha256);
CREATE INDEX idx_cb_org_norm ON comment_bodies(organization_normalized);