oira_meetings

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

8,663 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: rule_stage, meeting_type, type_cd, source, meeting_date_iso (date)

Next page

CREATE TABLE oira_meetings (
    meeting_id TEXT PRIMARY KEY,
    rin TEXT,
    title TEXT,
    agency_acronym TEXT,
    rule_stage TEXT,
    meeting_date TEXT,                      -- DD-MMM-YY from reginfo.gov source
    meeting_date_iso TEXT,                  -- YYYY-MM-DD sidecar (audit H6, 2026-05-15) — used by validate_freshness
    requestor_org TEXT,
    requestor_name TEXT,
    meeting_type TEXT,
    type_cd TEXT,
    source TEXT
);
CREATE INDEX idx_oira_meetings_rin ON oira_meetings(rin);
CREATE INDEX idx_oira_meetings_date ON oira_meetings(meeting_date);
CREATE INDEX idx_oira_meetings_org ON oira_meetings(requestor_org);