crs_reports
One row per Congressional Research Service (CRS) report, ingested from the Congress.gov v3 REST API (/crsreport list endpoint) by build_crs_reports. The nonpartisan policy-analysis layer over the same subjects agencies regulate — complementary to congress_bills (the legislative record) and federal_register (the rule-publication record). Scope is deliberately list-level only (no per-report detail fetches), so every column comes from the list payload. Incremental by update_date, deduped on report_id. All columns are stored as VARCHAR.
- Parquet file:
crs_reports.parquet - Queryable via MCP
query_sql: Yes
| Column | Type | Description |
|---|---|---|
report_id |
VARCHAR |
CRS report id (e.g. R48641, IN12713). Primary key / dedup key. |
title |
VARCHAR |
Report title as returned by the list endpoint. |
report_type |
VARCHAR |
CRS product category from contentType (e.g. Reports, Posts). |
status |
VARCHAR |
Report status as reported by Congress.gov (e.g. Active). |
published_date |
VARCHAR |
Date the report was published (ISO 8601 string). |
update_date |
VARCHAR |
Date the Congress.gov record was last updated (ISO 8601 string). Incremental window key. |
version |
VARCHAR |
Version number of the report as returned by the list endpoint. |
url |
VARCHAR |
Congress.gov API URL for the report's detail resource. |