$ $ $ Who FundsMemphis
Races Donors Vendors Starting Points What's New Bulk Data About
Tennessee
Races Donors Vendors Starting Points What's New Bulk Data About Tennessee

Query assistant for candidate_summaries

Schema that will be passed to the model
CREATE TABLE "candidate_summaries" (
  "candidate" TEXT,
  "office" TEXT,
  "party" TEXT,
  "status" TEXT,
  "presentation_term" INTEGER,
  "reported_receipts" REAL,
  "receipts_basis" TEXT,
  "receipts_hold" TEXT,
  "total_contributions" REAL,
  "total_refunds" REAL,
  "inkind_received" REAL,
  "total_self_contributions" REAL,
  "total_loans" REAL,
  "loans_received" REAL,
  "total_unitemized" REAL,
  "total_expenditures" REAL,
  "total_expenditure_refunds" REAL,
  "total_unitemized_spent" REAL,
  "total_spent" REAL,
  "cash_on_hand" REAL,
  "contributor_count" INTEGER,
  "filing_count" INTEGER,
  "is_incumbent" TEXT
)
Powered by Datasette