comments_index
A tiny per-partition row-count index for the partitioned comments. It maps each comments/ partition to its row count so consumers can compute comment totals and discover partitions without scanning the full comments dataset. Maintained by update_comments_index.
- Parquet file:
comments_index.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
agency_code |
VARCHAR |
Agency code of the partition (the agency_code= path segment). |
docket_id |
VARCHAR |
Docket id of the partition (the docket_id= path segment). |
year |
BIGINT |
Year of the partition, from posted_date (the year= path segment). |
month |
BIGINT |
Month (1–12) of the partition (the month= path segment). |
row_count |
BIGINT |
Number of comment rows in that partition file. |