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 )