State contributions
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
- candidate_name
- The candidate, if the recipient is a candidate committee.
- filer_name
- The committee that received the money.
- contributor_type
- Individual, business, PAC, party and so on.
- is_itemized
- 0 = lump sum for small donors; not a single person.
- amount
- Negative amounts are refunds or adjustments.
1,651 rows where contributor_type = "Federal PAC" and is_itemized = 1 sorted by date descending
This data as json, CSV (advanced)
filer_type 4
contributor_type 1
- Federal PAC · 1,651 ✖
| receipt_id | org_id | filer_type | filer_name | candidate_name | receipt_type | other_funds_type | date ▲ | amount | description | contributor_type | contributor_name | last_name | first_name | city | state | zip5 | employer | occupation | filed_date | amended | is_itemized | file_year | source | run_id | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143635 | 7688 | Candidate Committee | JIM PILLEN FOR GOVERNOR | JIM PILLEN | Monetary | 2026-11-02 | 5000.0 | Federal PAC | CATERPILLAR INC. POLITICAL ACTION COMMITTEE | CATERPILLAR INC. POLITICAL ACTION COMMITTEE | DEERFIELD | IL | 60015 | 2026-11-03 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143629 | 7425 | Candidate Committee | FRIENDS OF MIKE HILGERS | MICHAEL HILGERS | Monetary | 2026-11-02 | 3000.0 | Federal PAC | ARDA ROC PAC | ARDA ROC PAC | WASHINGTON | DC | 20005 | 2026-11-03 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143580 | 10131 | Candidate Committee | LEAHY FOR NEBRASKA | PATRICK LEAHY | Monetary | 2026-11-02 | 2000.0 | Federal PAC | ENTERPRISE HOLDINGS ENTERPRISE MOBILITY PAC C00219642 | ENTERPRISE HOLDINGS ENTERPRISE MOBILITY PAC C00219642 | ST. LOUIS | MO | 63105 | 2026-11-02 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143556 | 7645 | Candidate Committee | FRIENDS FOR JOHN FREDRICKSON | JOHN FREDRICKSON | Monetary | 2026-10-31 | 1000.0 | Federal PAC | UNITED HEALTH GROUP PAC | UNITED HEALTH GROUP PAC | WASHINGTON | DC | 20004 | 2026-11-01 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143558 | 7425 | Candidate Committee | FRIENDS OF MIKE HILGERS | MICHAEL HILGERS | Monetary | 2026-10-30 | 1000.0 | Federal PAC | ELI LILLY & COMPANY | ELI LILLY & COMPANY | INDIANAPOLIS | IN | 46285 | 2026-11-01 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143536 | 7640 | Candidate Committee | LYNNE WALZ FOR NEBRASKA | LYNNE WALZ | Monetary | 2026-10-30 | 200000.0 | Federal PAC | DEMOCRATIC GOVERNORS ASSOCIATION | DEMOCRATIC GOVERNORS ASSOCIATION | WASHINGTON | DC | 20005 | 2026-11-02 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143532 | 10075 | Candidate Committee | JESS GOLDONI FOR LEGISLATURE | JESS GOLDONI | Monetary | 2026-10-30 | 2500.0 | Federal PAC | IBEW PAC VOLUNTARY FUND | IBEW PAC VOLUNTARY FUND | WASHINGTON D.C. | DC | 20001 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143521 | 7576 | Candidate Committee | FRIENDS OF CINDY MAXWELL-OSTDIEK | CINDY MAXWELL-OSTDIEK | Monetary | 2026-10-30 | 2500.0 | Federal PAC | IBEW PAC VOLUNTARY FUND | IBEW PAC VOLUNTARY FUND | WASHINGTON D.C. | DC | 20001 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143513 | 10093 | Candidate Committee | CINDY JOHNSON FOR NEBRASKA | CINDY JOHNSON | Monetary | 2026-10-30 | 2500.0 | Federal PAC | IBEW PAC VOLUNTARY FUND | IBEW PAC VOLUNTARY FUND | WASHINGTON D.C. | DC | 20001 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143476 | 10292 | Candidate Committee | BLOOD4OPPD | CAROL BLOOD | Monetary | 2026-10-30 | 5000.0 | Federal PAC | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS (IBEW) PAC VOLUNTARY FUND C00027342 | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS (IBEW) PAC VOLUNTARY FUND C00027342 | WASHINGTON | DC | 20001 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143470 | 10152 | Candidate Committee | JAY FOR OPPD | JAY J IGNOWSKI | Monetary | 2026-10-30 | 5000.0 | Federal PAC | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS (IBEW) PAC VOLUNTARY FUND C00027342 | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS (IBEW) PAC VOLUNTARY FUND C00027342 | WASHINGTON | DC | 20001 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143545 | 9265 | PAC-Independent | DEMOCRACY NEBRASKA | Monetary | 2026-10-29 | 20000.0 | Federal PAC | MOVEMENT VOTER PAC | MOVEMENT VOTER PAC | NORTHHAMPTON | MA | 01061 | 2026-10-31 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143467 | 10244 | Candidate Committee | STRAWN FOR NEBRASKA | ANTHONY STRAWN | Monetary | 2026-10-29 | 1000.0 | Federal PAC | INTERNATIONAL ASSOCIATION OF FIRE FIGHTERS | INTERNATIONAL ASSOCIATION OF FIRE FIGHTERS | WASHINGTON | DC | 20006 | 2026-10-29 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143415 | 8037 | Candidate Committee | MIKE JACOBSON FOR LEGISLATURE | MIKE JACOBSON | Monetary | 2026-10-29 | 1250.0 | Federal PAC | PRIME THERAPEUTICS LLC EMPLOYEE STATE PAC | PRIME THERAPEUTICS LLC EMPLOYEE STATE PAC | EAGAN | AR | 55121 | 2026-10-29 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143506 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-10-28 | -2000.0 | Offset due to update of filed item | Federal PAC | NEBRASKA DEMOCRATIC PARTY FEDERAL ACCOUNT C00003988 | NEBRASKA DEMOCRATIC PARTY FEDERAL ACCOUNT C00003988 | LINCOLN | NE | 68510 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143410 | 7627 | Candidate Committee | VON GILLERN FOR NEBRASKA | BRAD VON GILLERN | Monetary | 2026-10-28 | 1250.0 | Federal PAC | PRIME THERAPEUTICS LLC EMPLOYEE STATE PAC | PRIME THERAPEUTICS LLC EMPLOYEE STATE PAC | EAGAN | AR | 55121 | 2026-10-28 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143405 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-10-28 | 2000.0 | Federal PAC | NEBRASKA DEMOCRATIC PARTY FEDERAL ACCOUNT C00003988 | NEBRASKA DEMOCRATIC PARTY FEDERAL ACCOUNT C00003988 | LINCOLN | NE | 68510 | 2026-10-28 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143368 | 10283 | Candidate Committee | BRUNSWICK FOR LEGISLATURE | DAWSON BRUNSWICK | Monetary | 2026-10-28 | 1000.0 | Federal PAC | ENTERPRISE HOLDINGS ENTERPRISE MOBILITY PAC C00219642 | ENTERPRISE HOLDINGS ENTERPRISE MOBILITY PAC C00219642 | ST. LOUIS | MO | 63105 | 2026-10-28 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143397 | 9903 | Candidate Committee | IDEUS FOR NEBRASKA | CALLY IDEUS | Monetary | 2026-10-27 | 1250.0 | Federal PAC | PRIME THERAPEUTICS LLC EMPLOYEE STATE PAC | PRIME THERAPEUTICS LLC EMPLOYEE STATE PAC | EAGAN | AR | 55121 | 2026-10-28 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143357 | 9265 | PAC-Independent | DEMOCRACY NEBRASKA | Monetary | 2026-10-27 | 25000.0 | Federal PAC | MOVEMENT VOTER PAC | MOVEMENT VOTER PAC | NORTHHAMPTON | MA | 01061 | 2026-10-28 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143356 | 10685 | PAC-Independent | JUSTICE & PUBLIC SAFETY PAC - NEBRASKA | Monetary | 2026-10-27 | 183823.53 | Federal PAC | DEMOCRACY PAC | DEMOCRACY PAC | WASHINGTON | DC | 20005 | 2026-10-29 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143520 | 7688 | Candidate Committee | JIM PILLEN FOR GOVERNOR | JIM PILLEN | Monetary | 2026-10-26 | 500000.0 | Federal PAC | RGA RIGHT DIRECTION PAC | RGA RIGHT DIRECTION PAC | WASHINGTON | DC | 20006 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143400 | 10486 | PAC-Independent | NEBRASKANS FOR A STRONGER FUTURE | Monetary | 2026-10-26 | 10000.0 | Federal PAC | THE PAC FOR AMERICA'S FUTURE C00654053 | THE PAC FOR AMERICA'S FUTURE C00654053 | WASHINGTON | DC | 20003 | 2026-10-28 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143292 | 7627 | Candidate Committee | VON GILLERN FOR NEBRASKA | BRAD VON GILLERN | Monetary | 2026-10-26 | 2000.0 | Federal PAC | ENTERPRISE HOLDINGS ENTERPRISE MOBILITY PAC C00219642 | ENTERPRISE HOLDINGS ENTERPRISE MOBILITY PAC C00219642 | ST. LOUIS | MO | 63105 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143288 | 10071 | Candidate Committee | MAPES FOR OPPD | CHRISTIAN MAPES | Monetary | 2026-10-26 | 1000.0 | Federal PAC | DON BACON FOR CONGRESS (C00575167) | DON BACON FOR CONGRESS (C00575167) | OMAHA | NE | 68139 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143206 | 8036 | Candidate Committee | CONRAD FOR LEGISLATURE | DANIELLE CONRAD | Monetary | 2026-10-26 | 1000.0 | Federal PAC | ENTERPRISE HOLDINGS RENTACAR FED PAC C00219642 | ENTERPRISE HOLDINGS RENTACAR FED PAC C00219642 | ST. LOUIS | MO | 63105 | 2026-10-27 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143194 | 7491 | Candidate Committee | PANSING BROOKS FOR LEGISLATURE | PATRICIA PANSING BROOKS | Monetary | 2026-10-26 | 1000.0 | Federal PAC | ENTERPRISE HOLDINGS RENTACAR FED PAC C00219642 | ENTERPRISE HOLDINGS RENTACAR FED PAC C00219642 | ST. LOUIS | MO | 63105 | 2026-10-27 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142882 | 8037 | Candidate Committee | MIKE JACOBSON FOR LEGISLATURE | MIKE JACOBSON | Monetary | 2026-10-26 | 1000.0 | Federal PAC | PHARMACEUTICAL CARE MANAGEMENT ASSOCIATION PAC | PHARMACEUTICAL CARE MANAGEMENT ASSOCIATION PAC | WASHINGTON | DC | 20004 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142559 | 10169 | Candidate Committee | TED JAPP FOR LEGISLATURE | TED JAPP | Monetary | 2026-10-26 | 1000.0 | Federal PAC | UNITED HEALTH GROUP PAC | UNITED HEALTH GROUP PAC | LINCOLN | NE | 68508 | 2026-10-24 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142395 | 7425 | Candidate Committee | FRIENDS OF MIKE HILGERS | MICHAEL HILGERS | Monetary | 2026-10-23 | 5000.0 | Federal PAC | UNITED HEALTH GROUP PAC | UNITED HEALTH GROUP PAC | WASHINGTON | DC | 20004 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141973 | 7909 | Candidate Committee | HARDIN FOR LEGISLATURE | BRIAN HARDIN | Monetary | 2026-10-23 | 1000.0 | Federal PAC | UNITEDHEALTH GROUP INC. PAC C00274431 | UNITEDHEALTH GROUP INC. PAC C00274431 | HOPKINS | MN | 55343 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141944 | 7640 | Candidate Committee | LYNNE WALZ FOR NEBRASKA | LYNNE WALZ | Monetary | 2026-10-23 | 25000.0 | Federal PAC | NEA FUND FOR CHILDREN AND PUBLIC EDUCATION (C00003251) NATIONAL EDUCATION ASSOCIATION | NEA FUND FOR CHILDREN AND PUBLIC EDUCATION (C00003251) NATIONAL EDUCATION ASSOCIATION | WASHINGTON | DC | 20036 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142010 | 8007 | Candidate Committee | RIEPE FOR NEBRASKA | MERV RIEPE | Monetary | 2026-10-22 | 1000.0 | Federal PAC | UNITEDHEALTH GROUP PAC | UNITEDHEALTH GROUP PAC | WASHINGTON | DC | 20004 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141849 | 9903 | Candidate Committee | IDEUS FOR NEBRASKA | CALLY IDEUS | Monetary | 2026-10-22 | 1000.0 | Federal PAC | UNITEDHEALTH GROUP PAC | UNITEDHEALTH GROUP PAC | WASHINGTON | DC | 20004 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141729 | 10425 | PAC-Independent | MAIN STREET RENEWAL | Monetary | 2026-10-22 | 5000.0 | Federal PAC | THE AMERICAN CLEAN POWER ASSOCIATION | THE AMERICAN CLEAN POWER ASSOCIATION | WASHINGTON | DC | 20004 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 141625 | 7627 | Candidate Committee | VON GILLERN FOR NEBRASKA | BRAD VON GILLERN | Monetary | 2026-10-22 | 1000.0 | Federal PAC | UNITEDHEALTH GROUP PAC | UNITEDHEALTH GROUP PAC | WASHINGTON | DC | 20004 | 2026-10-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141622 | 7627 | Candidate Committee | VON GILLERN FOR NEBRASKA | BRAD VON GILLERN | Monetary | 2026-10-22 | -1000.0 | Offset due to delete of filed item | Federal PAC | UNITED FOR HEALTH PAC | UNITED FOR HEALTH PAC | WASHINGTON | DC | 20094 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||
| 141618 | 7627 | Candidate Committee | VON GILLERN FOR NEBRASKA | BRAD VON GILLERN | Monetary | 2026-10-22 | 1000.0 | Federal PAC | UNITED FOR HEALTH PAC | UNITED FOR HEALTH PAC | WASHINGTON | DC | 20094 | 2026-10-22 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141132 | 9781 | Candidate Committee | HELMICK FOR LEGISLATURE | DEAN WILLIAM HELMICK | Monetary | 2026-10-22 | 1000.0 | Federal PAC | UNITED HEALTH GROUP PAC | UNITED HEALTH GROUP PAC | TOPEKA | KS | 66617 | 2026-10-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141123 | 10414 | Candidate Committee | ELIZABETH BUTLER CAMPAIGN 2026 | ELIZABETH BUTLER | Monetary | 2026-10-22 | 1000.0 | Federal PAC | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS (IBEW) PAC VOLUNTARY FUND C00027342 | INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKERS (IBEW) PAC VOLUNTARY FUND C00027342 | WASHINGTON | DC | 20001 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 140675 | 7640 | Candidate Committee | LYNNE WALZ FOR NEBRASKA | LYNNE WALZ | Monetary | 2026-10-21 | 2500.0 | Federal PAC | FIGHT LIKE HELL PAC | FIGHT LIKE HELL PAC | LANSING | MI | 48901 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 140673 | 7640 | Candidate Committee | LYNNE WALZ FOR NEBRASKA | LYNNE WALZ | Monetary | 2026-10-21 | 500000.0 | Federal PAC | DEMOCRATIC GOVERNORS ASSOCIATION | DEMOCRATIC GOVERNORS ASSOCIATION | WASHINGTON | DC | 20005 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 140670 | 7640 | Candidate Committee | LYNNE WALZ FOR NEBRASKA | LYNNE WALZ | Monetary | 2026-10-20 | 250000.0 | Federal PAC | GOVERNMENT THAT WORKS PAC | GOVERNMENT THAT WORKS PAC | WASHINGTON | DC | 20003 | 2026-10-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142977 | 7669 | Candidate Committee | GEORGE FOR NEBRASKA | GEORGE DUNGAN III | Monetary | 2026-10-19 | 1000.0 | Federal PAC | UNITED HEALTH GROUP PAC | UNITED HEALTH GROUP PAC | WASHINGTON | DC | 20004 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142953 | 7669 | Candidate Committee | GEORGE FOR NEBRASKA | GEORGE DUNGAN III | Monetary | 2026-10-19 | 500.0 | Federal PAC | BLACK HILLS CORPORATION PAC C00125732 | BLACK HILLS CORPORATION PAC C00125732 | RAPID CITY | SD | 57709 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142947 | 7669 | Candidate Committee | GEORGE FOR NEBRASKA | GEORGE DUNGAN III | Monetary | 2026-10-19 | 500.0 | Federal PAC | AMERICAN PROPERTY CASUALTY INSURANCE ASSOCIATION (APCIA-PAC C00066472) | AMERICAN PROPERTY CASUALTY INSURANCE ASSOCIATION (APCIA-PAC C00066472) | CHICAGO | IL | 60631 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142773 | 9265 | PAC-Independent | DEMOCRACY NEBRASKA | Monetary | 2026-10-19 | 30000.0 | Federal PAC | MOVEMENT VOTER PAC | MOVEMENT VOTER PAC | NORTHHAMPTON | MA | 01061 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142495 | 9903 | Candidate Committee | IDEUS FOR NEBRASKA | CALLY IDEUS | Monetary | 2026-10-19 | 1000.0 | Federal PAC | NAIFA PAC | NAIFA PAC | OMAHA | NE | 68124 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141517 | 9956 | Candidate Committee | SCHOENROCK FOR LEGISLATURE | MARK SCHOENROCK | Monetary | 2026-10-19 | 500.0 | Federal PAC | UNITED HEALTH GROUP PAC | UNITED HEALTH GROUP PAC | LINCOLN | NE | 68508 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141491 | 10332 | Candidate Committee | BLODGETT FOR 34 | BEN BLODGETT | Monetary | 2026-10-19 | 5000.0 | Federal PAC | IBEW PAC VOLUNTARY FUND | IBEW PAC VOLUNTARY FUND | WASHINGTON D.C. | DC | 20001 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE state_contributions (
receipt_id TEXT PRIMARY KEY, -- NADC's unique record ID
org_id TEXT, -- NADC ID of the receiving committee
filer_type TEXT, -- Candidate Committee, PAC, party...
filer_name TEXT, -- receiving committee
candidate_name TEXT, -- candidate, if a candidate committee
receipt_type TEXT, -- Monetary, In-Kind, Loan...
other_funds_type TEXT,
date TEXT, -- ISO yyyy-mm-dd
amount REAL, -- negative = refund or adjustment
description TEXT,
contributor_type TEXT, -- Individual, Business, PAC...
contributor_name TEXT, -- LAST, FIRST for people
last_name TEXT,
first_name TEXT,
city TEXT,
state TEXT,
zip5 TEXT,
employer TEXT,
occupation TEXT,
filed_date TEXT,
amended TEXT,
is_itemized INTEGER, -- 0 = lump-sum line for small donors
file_year INTEGER,
source TEXT NOT NULL DEFAULT 'nadc',
run_id INTEGER,
loaded_at TEXT
);
CREATE INDEX idx_sc_candidate ON state_contributions(candidate_name, date);
CREATE INDEX idx_sc_org ON state_contributions(org_id);
CREATE INDEX idx_sc_contributor ON state_contributions(contributor_name);
CREATE INDEX idx_sc_employer ON state_contributions(employer);
CREATE INDEX idx_sc_date ON state_contributions(date);