issue_comm_cont

2 rows where city = "Gypsum" and occupation = "Financial/Investment"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
351 351 COLORADANS FOR ANIMAL CARE Issue Committee 250.0 6/2/21 Ken Marchetti Gypsum CO 81637 Marchetti Weaver Llc Financial/Investment Individual Monetary (Itemized)  
1288 1288 YES FOR 6A Issue Committee 1000.0 10/11/21 Michael Brown Gypsum CO 81637 Alpine Bank Financial/Investment Individual Monetary (Itemized)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "issue_comm_cont" (
"committee" TEXT,
  "committee_type" 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
);