dockets

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

8,136 rows where agency_id = "PHMSA" sorted by last_modified descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, subtype, last_modified (date), effective_date (date)

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)
);
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);