state_cont

2 rows where candidate_name = "Robert Barrionton" and city = "Somerville"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ District candidate_name Party contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
113047 113047 CU Regent District 04 Robert Barrionton Democratic 100.0 10/2/22 Actblue Technical Services Somerville MA 02144-3132     Business Monetary (Itemized) Actblue
113049 113049 CU Regent District 04 Robert Barrionton Democratic 100.0 10/9/22 Actblue Technical Services Somerville MA 02144-3132     Business Monetary (Itemized) Actblue

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "state_cont" (
"District" TEXT,
  "candidate_name" TEXT,
  "Party" TEXT,
  "contribution_amount" REAL,
  "contribution_date" TEXT,
  "contributor" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zip" TEXT,
  "employer" TEXT,
  "occupation" TEXT,
  "contributor_type" TEXT,
  "contribution_type" TEXT,
  "explanation" TEXT
);