house_cont

2 rows where explanation = "Check#1112"

✎ 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
18960 18960 House District 27 Brianna Titone Democratic 100.0 8/29/22 Bill Skewes Denver CO 80203 Self Lobbyist Individual (Member of LLC: SKEWES GOVERNMENT AFFAIRS LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 100.00) Check#1112
19241 19241 House District 27 Brianna Titone Democratic 3250.0 10/18/22 Emily'S List Colorado Small Donor Committee Washington DC 20036     Small Donor Committee Monetary (Itemized) Check#1112

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "house_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
);