fec_contributions
Data license: Public Domain (U.S. Government data) · Data source: U.S. government sources, plus a few identifier registries; each is listed on the methodology page
4,529,821 rows sorted by transaction_dt descending
This data as json, CSV (advanced)
These facets timed out: entity_tp
| Link | rowid | cmte_id | cmte_name | cand_id | cand_name | transaction_dt ▲ | transaction_amt | entity_tp | state | transaction_tp | cycle |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4361567 | 4361567 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H6TX15162 | GONZALEZ, VICENTE | 12312025 | 2000.0 | CCM | TX | 24K | 2026 |
| 4361568 | 4361568 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2CA13115 | GRAY, ADAM C. | 12312025 | 1000.0 | CCM | CA | 24K | 2026 |
| 4361571 | 4361571 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H4LA06211 | FIELDS, CLEO | 12312025 | 1000.0 | CCM | LA | 24K | 2026 |
| 4361572 | 4361572 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H4CA45170 | TRAN, DEREK | 12312025 | 2000.0 | CCM | CA | 24K | 2026 |
| 4361574 | 4361574 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2OH13264 | SYKES, EMILIA | 12312025 | 1000.0 | CCM | OH | 24K | 2026 |
| 4361576 | 4361576 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2NC06114 | FOUSHEE, VALERIE | 12312025 | 1000.0 | CCM | NC | 24K | 2026 |
| 4361577 | 4361577 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H8CT05245 | HAYES, JAHANA | 12312025 | 1000.0 | CCM | CT | 24K | 2026 |
| 4361578 | 4361578 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2NM02191 | VASQUEZ, GABRIEL | 12312025 | 2000.0 | CCM | NM | 24K | 2026 |
| 4361581 | 4361581 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H4NJ09194 | POU, NELIDA | 12312025 | 2000.0 | CCM | NJ | 24K | 2026 |
| 4361584 | 4361584 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H8MA02041 | NEAL, RICHARD E | 12312025 | 1000.0 | CCM | MA | 24K | 2026 |
| 4361586 | 4361586 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2NV04011 | HORSFORD, STEVEN ALEXZANDER | 12312025 | 1000.0 | CCM | DC | 24K | 2026 |
| 4361587 | 4361587 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2NV04011 | HORSFORD, STEVEN ALEXZANDER | 12312025 | 1000.0 | CCM | DC | 24K | 2026 |
| 4361588 | 4361588 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2CA37304 | KAMLAGER-DOVE, SYDNEY | 12312025 | 1000.0 | CCM | CA | 24K | 2026 |
| 4361589 | 4361589 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H8CO02160 | NEGUSE, JOSEPH | 12312025 | 2000.0 | CCM | CO | 24K | 2026 |
| 4361593 | 4361593 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H0GA05301 | WILLIAMS, NIKEMA N. | 12312025 | 1000.0 | CCM | GA | 24K | 2026 |
| 4361594 | 4361594 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H2FL14053 | FRANKEL, LOIS J. | 12312025 | 1000.0 | CCM | FL | 24K | 2026 |
| 4361596 | 4361596 | C00199711 | HEALTH CARE SERVICE CORPORATION EMPLOYEES' POLITICAL ACTION COMMITTEE | H8PA04116 | DEAN, MADELEINE | 12312025 | 1000.0 | CCM | PA | 24K | 2026 |
| 4361930 | 4361930 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S6NH00141 | PAPPAS, CHRIS | 12312025 | 100.0 | CCM | NH | 24K | 2026 |
| 4361931 | 4361931 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S6NH00141 | PAPPAS, CHRIS | 12312025 | 2000.0 | CCM | NH | 24K | 2026 |
| 4361987 | 4361987 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S6NC00407 | COOPER, ROY | 12312025 | 60.0 | CCM | NC | 24K | 2026 |
| 4361988 | 4361988 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S6NC00407 | COOPER, ROY | 12312025 | 100.0 | CCM | NC | 24K | 2026 |
| 4361989 | 4361989 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S6NC00407 | COOPER, ROY | 12312025 | 2000.0 | CCM | NC | 24K | 2026 |
| 4362011 | 4362011 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S8GA00180 | OSSOFF, T. JONATHAN | 12312025 | 100.0 | CCM | GA | 24K | 2026 |
| 4362012 | 4362012 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S8GA00180 | OSSOFF, T. JONATHAN | 12312025 | 2000.0 | CCM | GA | 24K | 2026 |
| 4362013 | 4362013 | C00252940 | LEAGUE OF CONSERVATION VOTERS ACTION FUND | S8GA00180 | OSSOFF, T. JONATHAN | 12312025 | 200.0 | CCM | GA | 24K | 2026 |
| 4362115 | 4362115 | C00503151 | UPPER HAND FUND | H8PA15195 | MACKENZIE, RYAN EDWARD | 12312025 | 1500.0 | CCM | PA | 24K | 2026 |
| 4362116 | 4362116 | C00503151 | UPPER HAND FUND | H8PA15195 | MACKENZIE, RYAN EDWARD | 12312025 | 1000.0 | CCM | PA | 24K | 2026 |
| 4362118 | 4362118 | C00503151 | UPPER HAND FUND | H4PA08124 | BRESNAHAN, ROB | 12312025 | 3000.0 | CCM | PA | 24K | 2026 |
| 4362185 | 4362185 | C00872325 | AMERICAN UKRAINE PAC | H4TX10093 | MCCAUL, MICHAEL | 12312025 | -2500.0 | CCM | TX | 24K | 2026 |
| 4362189 | 4362189 | C00392290 | POPULUS FINANCIAL GROUP, INC. PAC | H8NY06048 | MEEKS, GREGORY W. | 12312025 | -1000.0 | CCM | NY | 24K | 2026 |
| 4362190 | 4362190 | C00392290 | POPULUS FINANCIAL GROUP, INC. PAC | S6PA00274 | FETTERMAN, JOHN KARL | 12312025 | -1000.0 | CCM | PA | 24K | 2026 |
| 4362277 | 4362277 | C00787945 | BLUEWAVEAMERICA | H8NY22177 | RILEY, JOSH | 12312025 | 1000.0 | CCM | DC | 24K | 2026 |
| 4362339 | 4362339 | C00608695 | MIKE JOHNSON FOR LOUISIANA | H0MI08141 | JUNGE, PAUL | 12312025 | -2000.0 | CCM | MI | 24K | 2026 |
| 4362499 | 4362499 | C00255752 | AMERICAN SOCIETY OF ANESTHESIOLOGISTS POLITICAL ACTION COMMITTEE (ASA PAC) | H4TX26149 | GILL, BRANDON | 12312025 | -2000.0 | CCM | VA | 24K | 2026 |
| 4362506 | 4362506 | C00255752 | AMERICAN SOCIETY OF ANESTHESIOLOGISTS POLITICAL ACTION COMMITTEE (ASA PAC) | S8WA00194 | CANTWELL, MARIA | 12312025 | -2500.0 | CCM | WA | 24K | 2026 |
| 4362513 | 4362513 | C00255752 | AMERICAN SOCIETY OF ANESTHESIOLOGISTS POLITICAL ACTION COMMITTEE (ASA PAC) | H2CO08020 | CARAVEO, YADIRA | 12312025 | -2500.0 | CCM | CO | 24K | 2026 |
| 4362787 | 4362787 | C00914028 | NORTH CAROLINA FIRST | S6NC00415 | WHATLEY, MICHAEL | 12312025 | 3500.0 | CCM | NC | 24K | 2026 |
| 4362788 | 4362788 | C00914028 | NORTH CAROLINA FIRST | S6NC00415 | WHATLEY, MICHAEL | 12312025 | 3500.0 | CCM | NC | 24K | 2026 |
| 4363771 | 4363771 | C00235036 | ZURICH HOLDING COMPANY OF AMERICA, INC. COMMITTEE FOR GOOD GOVERNMENT (Z-PAC, ZURICH PAC) | H4PA13199 | BOYLE, BRENDAN F | 12312025 | 1500.0 | CCM | DC | 24K | 2026 |
| 4363772 | 4363772 | C00235036 | ZURICH HOLDING COMPANY OF AMERICA, INC. COMMITTEE FOR GOOD GOVERNMENT (Z-PAC, ZURICH PAC) | H0WA10034 | STRICKLAND, MARILYN | 12312025 | 2500.0 | CCM | DC | 24K | 2026 |
| 4363920 | 4363920 | C00030718 | NATIONAL ASSOCIATION OF REALTORS POLITICAL ACTION COMMITTEE | H4NJ10176 | MCIVER, LAMONICA | 12312025 | -1000.0 | CCM | NJ | 24K | 2026 |
| 4363955 | 4363955 | C00685297 | ELECT DEMOCRATIC WOMEN | H6VA01299 | TAYLOR, SHANNON LEIGH | 12312025 | 1000.0 | CCM | VA | 24K | 2026 |
| 4363969 | 4363969 | C00685297 | ELECT DEMOCRATIC WOMEN | H6KY06150 | STEVENSON, CHERLYNN | 12312025 | 2500.0 | CCM | KY | 24K | 2026 |
| 4363970 | 4363970 | C00685297 | ELECT DEMOCRATIC WOMEN | H2IA02111 | BOHANNAN, CHRISTINA | 12312025 | 2000.0 | CCM | IA | 24K | 2026 |
| 4363971 | 4363971 | C00685297 | ELECT DEMOCRATIC WOMEN | H4WI03169 | COOKE, REBECCA | 12312025 | 2000.0 | CCM | WI | 24K | 2026 |
| 4363975 | 4363975 | C00685297 | ELECT DEMOCRATIC WOMEN | H6NE02174 | POWELL, DENISE | 12312025 | 5000.0 | CCM | NE | 24K | 2026 |
| 4363976 | 4363976 | C00685297 | ELECT DEMOCRATIC WOMEN | H6IL02355 | MILLER, DONNA | 12312025 | 5000.0 | CCM | IL | 24K | 2026 |
| 4363977 | 4363977 | C00685297 | ELECT DEMOCRATIC WOMEN | H6VA02198 | LURIA, ELAINE | 12312025 | 2000.0 | CCM | VA | 24K | 2026 |
| 4363981 | 4363981 | C00685297 | ELECT DEMOCRATIC WOMEN | H2NC06114 | FOUSHEE, VALERIE | 12312025 | 4000.0 | CCM | NC | 24K | 2026 |
| 4363984 | 4363984 | C00685297 | ELECT DEMOCRATIC WOMEN | H4PA10104 | STELSON, JANELLE | 12312025 | 2000.0 | CCM | PA | 24K | 2026 |
| 4363987 | 4363987 | C00685297 | ELECT DEMOCRATIC WOMEN | S6TX00552 | CROCKETT, JASMINE | 12312025 | 5000.0 | CCM | TX | 24K | 2026 |
| 4363997 | 4363997 | C00685297 | ELECT DEMOCRATIC WOMEN | H6PA08293 | COGNETTI, PAIGE | 12312025 | 2000.0 | CCM | PA | 24K | 2026 |
| 4363998 | 4363998 | C00685297 | ELECT DEMOCRATIC WOMEN | H6FL21059 | DANDIYA, PIA | 12312025 | 1000.0 | CCM | FL | 24K | 2026 |
| 4364000 | 4364000 | C00685297 | ELECT DEMOCRATIC WOMEN | H6MN02271 | BERG, KAELA JO | 12312025 | 5000.0 | CCM | MN | 24K | 2026 |
| 4364007 | 4364007 | C00685297 | ELECT DEMOCRATIC WOMEN | H6CO05324 | KILLIN, JESSICA WILLOW | 12312025 | 1000.0 | CCM | CO | 24K | 2026 |
| 4364018 | 4364018 | C00685297 | ELECT DEMOCRATIC WOMEN | H6IL08329 | BEAN, MELISSA LUBURICH | 12312025 | 5000.0 | CCM | IL | 24K | 2026 |
| 4364019 | 4364019 | C00685297 | ELECT DEMOCRATIC WOMEN | H6AZ06099 | MENDOZA, JOANNA | 12312025 | 2000.0 | CCM | AZ | 24K | 2026 |
| 4364020 | 4364020 | C00685297 | ELECT DEMOCRATIC WOMEN | S6ME00407 | MILLS, JANET TRAFTON | 12312025 | 5000.0 | CCM | ME | 24K | 2026 |
| 4364095 | 4364095 | C00574970 | FAIR SHOT PAC | H6CO05324 | KILLIN, JESSICA WILLOW | 12312025 | 2000.0 | CCM | CO | 24K | 2026 |
| 4364207 | 4364207 | C00770362 | THE CRAZY EIGHT | H6CO08088 | MUNSING, EVAN | 12312025 | 2000.0 | CCM | CO | 24K | 2026 |
| 4364394 | 4364394 | C00385039 | NUTRIEN AG SOLUTIONS EMPLOYEE CITIZENSHIP FUND POLITICAL ACTION COMMITTEE ('NUTRIEN CITIZENSHIP FUND PAC') | S4IA00129 | ERNST, JONI K | 12312025 | -1000.0 | CCM | IA | 24K | 2026 |
| 4364477 | 4364477 | C00849067 | CHESAPEAKE UTILITIES CORPORATION POLITICAL ACTION COMMITTEE (CUC PAC) | S4MD00327 | ALSOBROOKS, ANGELA | 12312025 | 1000.0 | CCM | MD | 24K | 2026 |
| 4364478 | 4364478 | C00849067 | CHESAPEAKE UTILITIES CORPORATION POLITICAL ACTION COMMITTEE (CUC PAC) | S0DE00092 | COONS, CHRISTOPHER A. | 12312025 | 1000.0 | CCM | DE | 24K | 2026 |
| 4364662 | 4364662 | C00880062 | ELECT DEMS NOW PAC | S8GA00180 | OSSOFF, T. JONATHAN | 12312025 | 1500.0 | CCM | GA | 24K | 2026 |
| 4364682 | 4364682 | C00880062 | ELECT DEMS NOW PAC | S6NH00141 | PAPPAS, CHRIS | 12312025 | 1500.0 | CCM | NH | 24K | 2026 |
| 4364693 | 4364693 | C00893859 | PHRONESISDC, LLC PAC (PHRONESISDC PAC) | S6KY00286 | BARR, GARLAND ANDY | 12312025 | 3500.0 | CCM | KY | 24K | 2026 |
| 4364837 | 4364837 | C00853358 | NEPA NEXT PAC | H0MI02094 | HUIZENGA, WILLIAM P | 12312025 | 2500.0 | CCM | MI | 24K | 2026 |
| 4364839 | 4364839 | C00853358 | NEPA NEXT PAC | H0NJ07261 | KEAN, THOMAS H. JR. | 12312025 | 1500.0 | CCM | NJ | 24K | 2026 |
| 4364842 | 4364842 | C00853358 | NEPA NEXT PAC | H8PA15195 | MACKENZIE, RYAN EDWARD | 12312025 | 1500.0 | CCM | PA | 24K | 2026 |
| 4364843 | 4364843 | C00853358 | NEPA NEXT PAC | H8PA15195 | MACKENZIE, RYAN EDWARD | 12312025 | 1000.0 | CCM | PA | 24K | 2026 |
| 4364845 | 4364845 | C00853358 | NEPA NEXT PAC | H2MI07123 | BARRETT, THOMAS MORE | 12312025 | 1500.0 | CCM | MI | 24K | 2026 |
| 4365015 | 4365015 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H6PA08277 | FITZPATRICK, BRIAN | 12312025 | 1000.0 | CCM | PA | 24K | 2026 |
| 4365017 | 4365017 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2VA02064 | KIGGANS, JENNIFER | 12312025 | 1500.0 | CCM | VA | 24K | 2026 |
| 4365019 | 4365019 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2NY17162 | LAWLER, MICHAEL VINCENT | 12312025 | 500.0 | CCM | NY | 24K | 2026 |
| 4365020 | 4365020 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2NY17162 | LAWLER, MICHAEL VINCENT | 12312025 | 1000.0 | CCM | NY | 24K | 2026 |
| 4365022 | 4365022 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H8IA02043 | MILLER-MEEKS, MARIANNETTE JANE | 12312025 | 500.0 | CCM | IA | 24K | 2026 |
| 4365023 | 4365023 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H8IA02043 | MILLER-MEEKS, MARIANNETTE JANE | 12312025 | 1000.0 | CCM | IA | 24K | 2026 |
| 4365024 | 4365024 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H8MN08043 | STAUBER, PETER ALLEN | 12312025 | 1000.0 | CCM | MN | 24K | 2026 |
| 4365026 | 4365026 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2CA20094 | VALADAO, DAVID | 12312025 | 500.0 | CCM | CA | 24K | 2026 |
| 4365027 | 4365027 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2CA20094 | VALADAO, DAVID | 12312025 | 1000.0 | CCM | CA | 24K | 2026 |
| 4365030 | 4365030 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2AK01083 | BEGICH, NICHOLAS III | 12312025 | 500.0 | CCM | AK | 24K | 2026 |
| 4365031 | 4365031 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2AK01083 | BEGICH, NICHOLAS III | 12312025 | 1000.0 | CCM | AK | 24K | 2026 |
| 4365032 | 4365032 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | S6KY00286 | BARR, GARLAND ANDY | 12312025 | 3500.0 | CCM | KY | 24K | 2026 |
| 4365033 | 4365033 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | S6KY00286 | BARR, GARLAND ANDY | 12312025 | 1500.0 | CCM | KY | 24K | 2026 |
| 4365035 | 4365035 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H6PA08277 | FITZPATRICK, BRIAN | 12312025 | 500.0 | CCM | PA | 24K | 2026 |
| 4365036 | 4365036 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2AZ02360 | CISCOMANI, JUAN | 12312025 | 500.0 | CCM | AZ | 24K | 2026 |
| 4365037 | 4365037 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2AZ02360 | CISCOMANI, JUAN | 12312025 | 1000.0 | CCM | AZ | 24K | 2026 |
| 4365038 | 4365038 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2CA02142 | LAMALFA, DOUG | 12312025 | 3500.0 | CCM | CA | 24K | 2026 |
| 4365040 | 4365040 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H4CO08034 | EVANS, TIMOTHY GABRIEL JOSEPH | 12312025 | 1500.0 | CCM | CO | 24K | 2026 |
| 4365042 | 4365042 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H2IA03119 | NUNN, ZACH | 12312025 | 1500.0 | CCM | IA | 24K | 2026 |
| 4365043 | 4365043 | C00885319 | COLORADO WESTERN POLITICAL ACTION COMMITTEE | H0NJ07261 | KEAN, THOMAS H. JR. | 12312025 | 1500.0 | CAN | NJ | 24K | 2026 |
| 4365056 | 4365056 | C00286500 | DOGGETT FOR CONGRESS | H6PA08293 | COGNETTI, PAIGE | 12312025 | 2000.0 | CCM | PA | 24K | 2026 |
| 4365413 | 4365413 | C00767640 | RANGER PAC | H6OH08315 | DAVIDSON, WARREN | 12312025 | -1000.0 | CCM | OH | 24K | 2026 |
| 4365469 | 4365469 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | H2FL04211 | BEAN, AARON P. | 12312025 | 2500.0 | CCM | FL | 24K | 2026 |
| 4365470 | 4365470 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | H0TX11230 | PFLUGER, AUGUST LEE II | 12312025 | 2500.0 | CCM | TX | 24K | 2026 |
| 4365471 | 4365471 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | H2NY17162 | LAWLER, MICHAEL VINCENT | 12312025 | 2500.0 | CCM | NY | 24K | 2026 |
| 4365472 | 4365472 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | H8NJ03073 | PALLONE, FRANK JR | 12312025 | 5000.0 | CCM | NJ | 24K | 2026 |
| 4365473 | 4365473 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | S0NM00058 | LUJAN, BEN RAY | 12312025 | 2500.0 | CCM | NM | 24K | 2026 |
| 4365474 | 4365474 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | H8MN08043 | STAUBER, PETER ALLEN | 12312025 | 2500.0 | CCM | MN | 24K | 2026 |
| 4365475 | 4365475 | C00095869 | POWERPAC OF THE EDISON ELECTRIC INSTITUTE | H8MA02041 | NEAL, RICHARD E | 12312025 | 2500.0 | CCM | MA | 24K | 2026 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE fec_contributions (
cmte_id TEXT,
cmte_name TEXT,
cand_id TEXT,
cand_name TEXT,
transaction_dt TEXT,
transaction_amt REAL,
entity_tp TEXT,
state TEXT,
-- employer / occupation DROPPED (Tony 2026-07-13): donor-level fields, 147/131 nameless rows of
-- 4.4M, zero analytic value — removed so "DataDawn publishes no donor-level records" is categorical.
-- ⚠️ RULE — NEVER SUM(transaction_amt) over fec_contributions without filtering transaction_tp.
-- (findings_register Pattern 4 / audit_charter §I.4 — summed-money flow-label verification.)
-- FEC itpas2 type code: 24K/24Z = contributions RECEIVED by the candidate (~21% of $, the real
-- "received" money); 24A = independent expenditure spent AGAINST (~51%); 24E = IE spent FOR (~25%);
-- 24C/24F/24N = coordinated/communication cost. Summing all types is the 2026-05-25
-- fec_total_received bug: ~79% outside spending mislabeled "received," most of it attack ads.
-- Filter to ('24K','24Z') for received; surface 24A/24E separately + clearly labeled
-- (fec_ie_against / fec_ie_for). The org/company/docket hubs aggregate this table the same way —
-- apply the filter there too. See bestpractices/member_hub_data_audit_2026-05-25.md.
transaction_tp TEXT,
cycle INTEGER NOT NULL
);
CREATE INDEX idx_fec_contrib_cand ON fec_contributions(cand_id);
CREATE INDEX idx_fec_contrib_cmte ON fec_contributions(cmte_id);
CREATE INDEX idx_fec_contrib_cycle ON fec_contributions(cycle);
CREATE INDEX idx_fec_contrib_amt ON fec_contributions(transaction_amt);
CREATE INDEX idx_fec_contrib_cand_tp ON fec_contributions(cand_id, transaction_tp);