agency_monthly_volume
Per-agency monthly document volume, broken out by document type — one row per (agency, year, month, document_type). Feeds activity sparklines and profile activity panels. Built by build_agency_rollups from document posted_date.
- Parquet file:
agency_monthly_volume.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
agency_code |
VARCHAR |
Agency short code. |
year |
BIGINT |
Year of the documents, extracted from posted_date. |
month |
BIGINT |
Month (1–12) of the documents, extracted from posted_date. |
document_type |
VARCHAR |
Document category counted in this bucket (e.g. Rule, Notice). |
document_count |
BIGINT |
Number of documents the agency posted of that type in that month. |