🔵 fedregister¶
U.S. Federal Register documents from govinfo.gov bulk XML archives. Covers final rules, proposed rules, notices, and presidential documents (executive orders, proclamations, memoranda) from 1994 to present. Key cross-reference fields: cfr_references (links to affected CFR titles/parts by industry), rin (Regulatory Identifier Number — tracks rulemaking lifecycle from NPRM to final rule), docket_ids (links to regulations.gov comment dockets).
1 datasets · 11 columns
fr_documents · table¶
All Federal Register documents partitioned by publication year and month. RULE=final rules (binding, amend CFR), PRORULE=proposed rules (open for comment), NOTICE=agency announcements/meetings/grants, PRESDOC=executive orders/proclamations. Key analytical fields: rin (tracks NPRM→final rule lifecycle via RIN cross-reference), cfr_references (JSON: affected CFR titles and parts → maps to regulated industry), docket_ids (JSON: links to regulations.gov for comment letter intelligence).
| Column | Type | Null | Description |
|---|---|---|---|
document_ |
string | yes | Federal Register document number (e.g., 2026-07234) |
title |
string | yes | Document title |
doc_ |
string | no | Document type (RULE, PRORULE, NOTICE, PRESDOC) |
publication_ |
string | no | Publication date (YYYY-MM-DD) |
effective_ |
string | yes | Effective date of the rule (YYYY-MM-DD) |
action |
string | yes | Rule action description (e.g., 'Final rule', 'Proposed rule') |
agency_ |
string | yes | Comma-separated issuing agency names (denormalized for easy SQL filtering) |
cfr_ |
string | yes | JSON array of CFR references [{title:N, part:N}] — maps to regulated industry |
rin |
string | yes | Primary Regulatory Identifier Number (links NPRM to final rule lifecycle) |
docket_ |
string | yes | JSON array of docket identifiers (links to regulations.gov comment dockets) |
signing_ |
string | yes | Presidential document signing date (YYYY-MM-DD) |