feed_summary
A pre-computed rollup with one row per docket, joining docket metadata to comment counts and comment-period dates. Powers feed/timeline views without scanning the full comments dataset. Built by build_feed_summary, sorted by modify_date descending.
- Parquet file:
feed_summary.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
docket_id |
VARCHAR |
Docket identifier. One row per docket. |
agency_code |
VARCHAR |
Posting agency's short code. |
title |
VARCHAR |
Docket title (from dockets). |
docket_type |
VARCHAR |
Docket category (from dockets). |
modify_date |
VARCHAR |
Docket last-modified timestamp; the table is sorted by this descending. |
abstract |
VARCHAR |
Docket abstract (from dockets). Often null. |
comment_count |
BIGINT |
Total comments on the docket, summed from comments_index. 0 when none. |
comment_end_date |
VARCHAR |
Latest comment-period end date across the docket's documents. Null when unknown. |
date_created |
VARCHAR |
Earliest document posted_date on the docket, used as a creation date. Null when unknown. |