dockets

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

1,581 rows where agency_id = "DHS" sorted by last_modified descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE dockets (
    id TEXT PRIMARY KEY,
    agency_id TEXT,
    title TEXT,
    docket_type TEXT,
    last_modified TEXT,
    object_id TEXT,
    -- Rich fields from the per-docket single-GET object (16_backfill_dockets).
    -- The docket LIST endpoint (02/expand_all) returns only the 6 base fields above,
    -- so these are populated for 'single_get' rows and NULL for 'list_pull' rows.
    rin TEXT,
    dkabstract TEXT,
    category TEXT,
    subtype TEXT,
    keywords TEXT,
    program TEXT,
    short_title TEXT,
    effective_date TEXT,
    organization TEXT,     -- docket sponsoring org (single_get); load-bearing for lobbying docket->filing-org joins (spec 2026-07-04)
    attrs_raw TEXT,        -- verbatim data.attributes JSON (insurance: any field recoverable w/o refetch)
    attr_source TEXT       -- 'single_get' (full object) | 'list_pull' (6-field) | NULL (unfetched stub) | 'invalid' (backfill 400/404, nonexistent) | 'unresolved' (source refuses the DERIVED id while real comments reference it — dockets_unresolved.json; not filled, not invalid)
);
CREATE INDEX idx_dockets_agency ON dockets(agency_id);
CREATE INDEX idx_dockets_type ON dockets(docket_type);
CREATE INDEX idx_dockets_attr_source ON dockets(attr_source);