All data
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
Queries
- Where Nebraska donors' money goes
- Top employers of Nebraska donors
- Top donors to a candidate
- Same-day giving by coworkers
- Who lobbied on a bill, and what they gave
- An organization's lobbying positions
- Where a lobbying organization's money went
- Top donors to a state candidate
- How senators voted on a bill, and money from each side
- A senator's votes on bills lobbied by donors
- How often senators voted with their donors
- Bills with lobbying positions
- Legislatures with lobbying positions
- Offices with candidate committees
- Who funds a local office
- Candidates for a local office, and what they raised
- State vendors that give to campaigns
- What the state paid a vendor
- A vendor's campaign money
- Find an organization
- Organization summary
- Campaigns an organization funded
- Bills an organization lobbied on
- Senators an organization gave to, and their votes on its bills
- What the state paid an organization
- Lobbyists an organization hired
- Organization name lookup
- Senators' financial ties to lobbying organizations
- A senator's financial interests
- Senators with financial ties to an organization
Tables
bills
bill_id, session, legislature, identifier, bill, title, classification, subjects, url, first_action_date, latest_action_date, latest_action, source, run_id, loaded_at
1,956 rows
candidate_offices
committee, candidate, jurisdiction, office, district, election, status, level, org_id, run_id, loaded_at, place
842 rows
candidates
candidate_id, name, party, office, state, district, incumbent_challenge, status, election_year, principal_committee, source, updated_at
19,770 rows
committees
committee_id, name, committee_type, designation, party, city, state, zip, treasurer_name, connected_org, org_type, filing_frequency, candidate_id, source, updated_at
37,617 rows
contributions
sub_id, cycle, committee_id, contributor_name, city, state, zip, zip5, employer, occupation, entity_type, amount, date, transaction_type, memo_code, memo_text, image_number, file_number, amendment_indicator, other_id, source, run_id, loaded_at
1,145,280 rows
legislators
person_id, name, given_name, family_name, district, start_date, end_date, current, terms, other_names
152 rows
lobby_positions
legislature, session_year, bill, lobbyist, principal, position, is_relay, source_url, run_id, loaded_at
108,579 rows
official_filings
filing_key, filer, filing_year, reason, office_held, office_sought, date_filed, person_id, parsed, note, run_id, loaded_at, doc_url
360 rows
official_interests
interest_id, filing_key, kind, name, name_key, nature, role, value, description, source, confidence
1,620 rows
state_contributions
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
134,109 rows
state_payments
fiscal_year, agency_option, agency, payee, vendor, vendor_key, account, program, total, payments, first_date, last_date, run_id, loaded_at
114,571 rows
vendor_summary
vendor_key, vendor, paid, payments, first_fy, last_fy, agencies, given, gifts, recipients, lobbies, principal
45,022 rows
votes
vote_id, bill_id, session, legislature, date, motion, motion_classification, result, yes_count, no_count, other_count, url, source, run_id, loaded_at
1,842 rows
... and 22 hidden tables
Views
Download SQLite DB: cftracker.db 674.1 MB