State committee spending
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
- filer_name
- The committee or entity that spent the money.
- exp_type
- Kind of spending, as reported.
- payee_name
- Who was paid. Blank for payments to individuals.
- support_oppose
- For independent expenditures: whether it supported or opposed the target.
- target
- The candidate or ballot question an independent expenditure supported or opposed.
- target_candidate
- The target, matched by name to a state candidate on file.
- amount
- Negative amounts are refunds, adjustments or offsets for deleted filings.
0 rows sorted by date descending
This data as json
support_oppose 0
filer_type 0
exp_type 0
0 records
CREATE TABLE state_expenditures (
expenditure_id TEXT PRIMARY KEY,
org_id TEXT, -- NADC ID of the committee or entity reporting it
filer_type TEXT,
filer_name TEXT,
candidate_name TEXT, -- if the filer is a candidate committee
exp_type TEXT, -- Direct contribution, Independent Expenditure, Campaign Expense...
sub_type TEXT,
date TEXT,
amount REAL,
description TEXT,
payee_type TEXT,
payee_name TEXT, -- NULL for payments to individuals
payee_org_id TEXT, -- the receiving committee, when it is one on file
city TEXT,
state TEXT,
zip5 TEXT,
filed_date TEXT,
support_oppose TEXT, -- SUPPORT or OPPOSE, for independent expenditures
target TEXT, -- candidate or ballot question supported or opposed
target_office TEXT,
target_candidate TEXT, -- target matched to a state candidate's name on file
amended TEXT,
file_year INTEGER,
source TEXT NOT NULL DEFAULT 'nadc',
run_id INTEGER,
loaded_at TEXT
);
CREATE INDEX idx_se_org ON state_expenditures(org_id, exp_type);
CREATE INDEX idx_se_payee ON state_expenditures(payee_org_id);
CREATE INDEX idx_se_target ON state_expenditures(target_candidate);
CREATE INDEX idx_se_payname ON state_expenditures(payee_name);