Memphis

Memphis & Shelby County — municipal and county races (whofundsmemphis.org).

Saved reports

Tables schema

Candidate totals

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

206 rows

Expenditures

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

6,194 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

600 rows

Loans

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

64 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 5.1 MB