fr_docket_links

The Federal Register ↔ docket bridge: each federal_register row's docket_ids_json array exploded to one row per (docket_id, FR document), carrying the FR display columns. Use this instead of an ILIKE scan over federal_register.docket_ids_json — it is sorted by docket_id, so WHERE docket_id = ? prunes row groups. This is the practical join from regulations.gov to the Federal Register, since documents.fr_doc_num is populated on only ~1% of rules. Built by build_fr_docket_links.

• Parquet file: fr_docket_links.parquet
• Queryable via MCP query_sql: Yes

Column	Type	Description
docket_id	VARCHAR	One docket ID extracted from the FR document's docket_ids_json array.
document_number	VARCHAR	Federal Register document number (joins federal_register.document_number).
title	VARCHAR	FR document title.
abstract	VARCHAR	FR document abstract.
document_type	VARCHAR	FR type: Rule, Proposed Rule, Notice, or Presidential Document.
subtype	VARCHAR	FR subtype where the Federal Register supplies one, e.g. Final Rule, Interim Final Rule.
publication_date	VARCHAR	Date the document published in the Federal Register.
effective_on	VARCHAR	Date the rule takes effect, when the document carries one.
comments_close_on	VARCHAR	Comment period close date, when the document carries one.
signing_date	VARCHAR	Signing date, for presidential documents.
agency_slugs	VARCHAR	Federal Register agency slugs for the issuing agencies.
docket_ids_json	VARCHAR	The full original docket-ID array, retained so consumers can see the other IDs this FR document links to.
regulation_id_numbers_json	VARCHAR	RINs (JSON array) claimed by the FR document — the RIN-side join key for a rulemaking.
html_url	VARCHAR	federalregister.gov HTML permalink.
pdf_url	VARCHAR	Federal Register PDF URL.
executive_order_number	VARCHAR	Executive order number, for presidential documents.