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.
5,781 rows where filer_type = "Ballot Question Committee" sorted by date descending
This data as json, CSV (advanced)
contributor_type 7
filer_type 1
- Ballot Question Committee · 5,781 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143581 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-11-02 | 14622.17 | PAID CALLS - WINNING CONNECTIONS | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-11-02 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143488 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-30 | 10000.0 | Business (For-Profit and Non-Profit entities) | NODDLE DEVELOPMENT COMPANY | NODDLE DEVELOPMENT COMPANY | OMAHA | NE | 68106 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143524 | 10477 | Ballot Question Committee | GOOD GOVERNMENT LINCOLN PROJECT | In-Kind Contribution | 2026-10-29 | 84949.0 | MEDIA ADVERTISEMENTS | Candidate Committee | VOTE SCHULTE | VOTE SCHULTE | HICKMAN | NE | 68372 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143523 | 10477 | Ballot Question Committee | GOOD GOVERNMENT LINCOLN PROJECT | Monetary | 2026-10-29 | 2550.0 | Business (For-Profit and Non-Profit entities) | RESTORE THE GOOD LIFE INC | RESTORE THE GOOD LIFE INC | LINCOLN | NE | 68516 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143433 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-29 | 150000.0 | Business (For-Profit and Non-Profit entities) | FANDUEL INC | FANDUEL INC | NEW YORK | NY | 10010 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143413 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-29 | 500000.0 | Business (For-Profit and Non-Profit entities) | HILLSIDE NEW MEDIA HOLDINGS US INC. | HILLSIDE NEW MEDIA HOLDINGS US INC. | DENVER | CO | 80202 | 2026-10-29 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143412 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-29 | 150000.0 | Business (For-Profit and Non-Profit entities) | DK CROWN HOLDINGS INC. | DK CROWN HOLDINGS INC. | BOSTON | MA | 02116 | 2026-10-29 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143254 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-27 | 15000.0 | Business (For-Profit and Non-Profit entities) | CASSLING DIAGNOSTIC IMAGING, INC. D/B/A CQUENCE HEALTH GROUP | CASSLING DIAGNOSTIC IMAGING, INC. D/B/A CQUENCE HEALTH GROUP | OMAHA | NE | 68154 | 2026-10-27 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143251 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-27 | 15000.0 | Business (For-Profit and Non-Profit entities) | MUTUAL OF OMAHA INSURANCE COMPANY | MUTUAL OF OMAHA INSURANCE COMPANY | OMAHA | NE | 68175 | 2026-10-27 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142904 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-26 | 10000.0 | Business (For-Profit and Non-Profit entities) | NEBRASKA MEDICAL CENTER | NEBRASKA MEDICAL CENTER | OMAHA | NE | 68198 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142690 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-26 | 100000.0 | Business (For-Profit and Non-Profit entities) | FBG ENTERPRISES OPCO, LLC | FBG ENTERPRISES OPCO, LLC | NEW YORK | NY | 10014 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143185 | 10477 | Ballot Question Committee | GOOD GOVERNMENT LINCOLN PROJECT | In-Kind Contribution | 2026-10-23 | 41462.0 | TELEVISION AND RADIO ADVERTISEMENTS | Candidate Committee | VOTE SCHULTE | VOTE SCHULTE | HICKMAN | NE | 68372 | 2026-10-27 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142225 | 10477 | Ballot Question Committee | GOOD GOVERNMENT LINCOLN PROJECT | Monetary | 2026-10-23 | 50000.0 | Business (For-Profit and Non-Profit entities) | RESTORE THE GOOD LIFE INC | RESTORE THE GOOD LIFE INC | LINCOLN | NE | 68516 | 2026-10-24 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142029 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-23 | 750000.0 | Business (For-Profit and Non-Profit entities) | FANDUEL INC | FANDUEL INC | NEW YORK | NY | 10010 | 2026-10-24 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 140683 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-22 | 750000.0 | Business (For-Profit and Non-Profit entities) | DK CROWN HOLDINGS INC. | DK CROWN HOLDINGS INC. | BOSTON | MA | 02116 | 2026-10-24 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 140681 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-22 | 2500000.0 | Business (For-Profit and Non-Profit entities) | FANDUEL INC | FANDUEL INC | NEW YORK | NY | 10010 | 2026-10-24 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 140601 | 10477 | Ballot Question Committee | GOOD GOVERNMENT LINCOLN PROJECT | Monetary | 2026-10-20 | 165000.0 | Business (For-Profit and Non-Profit entities) | RESTORE THE GOOD LIFE INC | RESTORE THE GOOD LIFE INC | LINCOLN | NE | 68516 | 2026-10-21 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143842 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-19 | 5000.0 | Business (For-Profit and Non-Profit entities) | BRADFORD FAMILY HOLDINGS LLC | BRADFORD FAMILY HOLDINGS LLC | OMAHA | NE | 68106 | 2026-11-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143841 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-19 | -5000.0 | Offset due to delete of filed item | Business (For-Profit and Non-Profit entities) | C3 HOLDING COMPANY, LLC | C3 HOLDING COMPANY, LLC | OMAHA | NE | 68106 | 2026-11-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142823 | 10638 | Ballot Question Committee | VOTE YES ON JOBS NEBRASKA CITY | Monetary | 2026-10-19 | 500.0 | Business (For-Profit and Non-Profit entities) | OTHERS (NON-INDIVIDUALS) WHO HAVE CONTRIBUTED DURING PERIOD, BUT EACH $250 OR LESS FOR CALENDAR YEAR | NE | 2026-10-23 | N | 0 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||||||
| 142525 | 10288 | Ballot Question Committee | FAIRNESS FOR GIRLS | Monetary | 2026-10-19 | 150000.0 | Business (For-Profit and Non-Profit entities) | RESTORE THE GOOD LIFE INC | RESTORE THE GOOD LIFE INC | LINCOLN | NE | 68516 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142284 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-19 | 700.0 | CANVASSER - MILES | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142270 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-19 | 1313.8 | PAYROLL THROUGH 10.19 | Business (For-Profit and Non-Profit entities) | NEBRASKA APPLESEED ACTION FUND | NEBRASKA APPLESEED ACTION FUND | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142269 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-19 | 307.9 | PAYROLL THROUGH 10.19 | Business (For-Profit and Non-Profit entities) | NEBRASKA APPLESEED CENTER FOR LAW IN THE PUBLIC INTEREST | NEBRASKA APPLESEED CENTER FOR LAW IN THE PUBLIC INTEREST | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142268 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-19 | 1293.59 | STAFF TIME (OCT 1 - 19) | Business (For-Profit and Non-Profit entities) | OUTNEBRASKA (OUTLINC, INC DBA) | OUTNEBRASKA (OUTLINC, INC DBA) | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 140061 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-19 | 10000.0 | Individual | SMITH, PAUL G | SMITH | PAUL | OMAHA | NE | 68132 | 2026-10-21 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 139962 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-19 | 5000.0 | Business (For-Profit and Non-Profit entities) | C3 HOLDING COMPANY, LLC | C3 HOLDING COMPANY, LLC | OMAHA | NE | 68106 | 2026-10-21 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143787 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-16 | 2056.8 | PAYROLL | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-11-10 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 143786 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-16 | -1870.22 | Offset due to update of filed item | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-11-10 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142285 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-16 | 280.0 | CANVASSER - FORSYTHE | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142283 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-16 | 420.0 | CANVASSER - JIMINEZ | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142272 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-16 | 1870.22 | PAYROLL | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142271 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-16 | 412.2 | PAYROLL | Business (For-Profit and Non-Profit entities) | NEBRASKA CIVIC ENGAGEMENT TABLE | NEBRASKA CIVIC ENGAGEMENT TABLE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 139847 | 10607 | Ballot Question Committee | BUILDING A BETTER OMAHA | Monetary | 2026-10-16 | 25000.0 | Business (For-Profit and Non-Profit entities) | KIEWIT CORPORATION | KIEWIT CORPORATION | OMAHA | NE | 68131 | 2026-10-21 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142829 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-15 | 27800.0 | VIDEO PRODUCTION AND PAID SOCIAL MEDIA | Business (For-Profit and Non-Profit entities) | LEAD THE CHANGE FUND | LEAD THE CHANGE FUND | OMAHA | NE | 68106 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142260 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-15 | 15356.92 | PAID CALLS - WINNING CONNECTIONS | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142534 | 10661 | Ballot Question Committee | SAVE NEBRASKA SPORTS | Monetary | 2026-10-14 | 1025000.0 | Business (For-Profit and Non-Profit entities) | RESTORE THE GOOD LIFE INC | RESTORE THE GOOD LIFE INC | LINCOLN | NE | 68516 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142282 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-14 | 560.0 | CANVASSER - INGRAM | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142266 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-14 | 29.94 | SUPPLIES FOR CANVASSERS | Business (For-Profit and Non-Profit entities) | OUTNEBRASKA (OUTLINC, INC DBA) | OUTNEBRASKA (OUTLINC, INC DBA) | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142281 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-13 | 700.0 | CANVASSER - MILES | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142265 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-13 | 172.61 | POSTERS | Business (For-Profit and Non-Profit entities) | OUTNEBRASKA (OUTLINC, INC DBA) | OUTNEBRASKA (OUTLINC, INC DBA) | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 141431 | 10217 | Ballot Question Committee | TAX RELIEF NEBRASKA | Monetary | 2026-10-13 | 2500000.0 | Business (For-Profit and Non-Profit entities) | DK CROWN HOLDINGS INC. | DK CROWN HOLDINGS INC. | BOSTON | MA | 02116 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 139989 | 10504 | Ballot Question Committee | BUILD LNK VOLLEYBALL | Pledge | 2026-10-13 | 1000.0 | Individual | HILGERS, HEATHER | HILGERS | HEATHER | LINCOLN | NE | 68528 | 2026-10-21 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142280 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-09 | 280.0 | CANVASSER - FORSYTHE | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142279 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-09 | 420.0 | CANVASSER - JIMENEZ | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142264 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-09 | 2220.08 | YARD SIGNS | Business (For-Profit and Non-Profit entities) | OUTNEBRASKA (OUTLINC, INC DBA) | OUTNEBRASKA (OUTLINC, INC DBA) | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 139987 | 10504 | Ballot Question Committee | BUILD LNK VOLLEYBALL | Pledge Payment Received | 2026-10-09 | 10000.0 | Business (For-Profit and Non-Profit entities) | PINNACLE BANK | PINNACLE BANK | LINCOLN | NE | 68508 | 2026-10-21 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 141536 | 10638 | Ballot Question Committee | VOTE YES ON JOBS NEBRASKA CITY | Monetary | 2026-10-07 | 500.0 | Business (For-Profit and Non-Profit entities) | J.J. PALMTAGE COMPANY | J.J. PALMTAGE COMPANY | NEBRASKA CITY | NE | 68410 | 2026-10-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142278 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-06 | 140.0 | CANVASSER - SHAW | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 142277 | 10487 | Ballot Question Committee | FAIRNESS FOR ALL | In-Kind Contribution | 2026-10-06 | 560.0 | CANVASSER - INGRAM | Business (For-Profit and Non-Profit entities) | SECOND HOUSE COLLABORATIVE | SECOND HOUSE COLLABORATIVE | LINCOLN | NE | 68508 | 2026-10-25 | 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);