$ $ $ Who FundsTennessee
Races PACs Donors Vendors Starting Points What's New Bulk Data About
Memphis
Races PACs Donors Vendors Starting Points What's New Bulk Data About Memphis

Tennessee (Federal)

Tennessee's federal races — U.S. House & Senate (FEC data), published through whofundstn.org. Same schema and privacy floor as the other stores. THIS CYCLE only; prior cycles are a separate database, Tennessee (Federal, archive).

Data source: Who Funds Tennessee

Custom SQL query

Saved reports

  • Compare two candidates
  • Donors giving across many races
  • Gifts to a candidate
  • Organization & PAC donors
  • Top donors

Tables schema

candidate_contributions

canon_id, campaign_id, amount, is_self

>10,000 rows

Candidate totals

candidate, office, party, status, total_contributions, total_refunds, monetary_raised, inkind_received, total_self_contributions, total_loans, loans_received, total_unitemized, total_expenditures, total_expenditure_refunds, total_unitemized_spent, total_spent, cash_on_hand, contributor_count, filing_count, is_incumbent

58 rows

Expenditures

candidate, office, party, status, payee, payee_city, payee_state, payee_zip, purpose, amount, date

>10,000 rows

About this data

store, generated_at, privacy_threshold, rows

1 row

filings

candidate, office, party, year, reporting_period, report_type, coverage_start, coverage_end, filing_date, review_status, published

255 rows

Loans

candidate, office, party, status, lender, amount, amount_this_cycle, date_received, outstanding_balance, amount_repaid, is_self_loan

27 rows

Contributions

canon_id, donor_name, employer, occupation, is_organization, entity_type, entity_subtype, city, state, zip, amount, date, is_inkind, designated_election_phase, campaign_id, reporting_period, party, election_cycle_year, candidate_name, office_name

>10,000 rows

Download the whole dataset: SQLite database 69.2 MB

Powered by Datasette · Data source: Who Funds Tennessee