agency_stats
A per-agency dimension table — one row per agency with docket, document, and comment counts. Powers agency directory and profile pages. Built by build_agency_rollups, sorted by comment then document count descending.
- Parquet file:
agency_stats.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
agency_code |
VARCHAR |
Agency short code. One row per agency. |
docket_count |
BIGINT |
Number of dockets posted by the agency. |
document_count |
BIGINT |
Number of documents posted by the agency. |
comment_count |
BIGINT |
Total comments received by the agency, summed from comments_index. |