fec_committees

One row per Federal Election Commission committee/PAC, ingested from the OpenFEC /committees endpoint by build_fec_committees. A reference dimension of the political committees — PACs, party committees, and campaign committees — that money and endorsements flow through, used to resolve commenters and co-filers against the dashboard's ally/opposition (stance) map. Scope is deliberately committees-only: itemized contributions (hundreds of millions of rows) are out of scope for this pass and could follow as a future bounded-by-organization contributions table keyed on committee_id. All columns are stored as VARCHAR; array-valued fields are JSON strings.

• Parquet file: fec_committees.parquet
• Queryable via MCP query_sql: Yes

Column	Type	Description
committee_id	VARCHAR	OpenFEC committee identifier (e.g. C00684373). Primary key / dedup key.
name	VARCHAR	Committee name as registered with the FEC.
committee_type	VARCHAR	Single-letter committee type code (e.g. P presidential, H House, S Senate, N/Q/O PAC variants).
committee_type_full	VARCHAR	Human-readable committee type (e.g. Presidential, PAC - Qualified).
designation	VARCHAR	Single-letter committee designation code (e.g. P principal campaign committee, A authorized, U unauthorized, J joint fundraiser).
designation_full	VARCHAR	Human-readable committee designation (e.g. Principal campaign committee).
party	VARCHAR	Political party code, when set (e.g. DEM, REP, W). Often null for non-party committees.
party_full	VARCHAR	Human-readable political party (e.g. DEMOCRATIC PARTY, WRITE-IN). Often null.
state	VARCHAR	Two-letter state associated with the committee. Often null.
treasurer_name	VARCHAR	Name of the committee's treasurer.
organization_type_full	VARCHAR	Human-readable sponsoring organization type (e.g. Corporation, Labor Organization, Trade Association). Often null.
filing_frequency	VARCHAR	Single-letter filing frequency code (e.g. A administratively terminated, M monthly, Q quarterly, T terminated).
first_file_date	VARCHAR	Date the committee first filed with the FEC (ISO 8601 string).
last_file_date	VARCHAR	Date of the committee's most recent filing (ISO 8601 string).
cycles_json	VARCHAR	JSON array of election-cycle years the committee was active in (e.g. [2018, 2020, 2022]).
candidate_ids_json	VARCHAR	JSON array of OpenFEC candidate IDs associated with the committee (e.g. ["P00008052"]). Often [].