rulemaking_lifecycles

Proposed→final rulemaking arcs, one row per docket, discriminated by kind: pair rows are completed rulemakings (earliest Proposed Rule matched to the earliest subsequent Rule in the same docket, with elapsed days); stuck rows are Proposed Rules with no matching Rule, where final_date and days are NULL. Bounded to proposed_date >= 2010-01-01. Built by build_rulemaking_lifecycles from documents. Note that pairing is per docket, so a docket carrying several RINs across successive rulemakings collapses to a single arc.

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

Column	Type	Description
kind	VARCHAR	pair (completed: proposed and final both present) or stuck (proposed with no final rule in the docket).
docket_id	VARCHAR	Docket the arc belongs to.
agency_code	VARCHAR	Agency short code, from the Proposed Rule.
title	VARCHAR	Title of the Proposed Rule that opens the arc.
proposed_date	DATE	posted_date of the earliest Proposed Rule in the docket.
final_date	DATE	posted_date of the earliest Rule at or after proposed_date. NULL when kind is stuck.
days	BIGINT	Calendar days from proposed_date to final_date. NULL when kind is stuck.