senate_cand_cont

3 rows where contribution_type = "Monetary (Itemized) - LLC Contribution (Total Amount: 150.00)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: district, candidate, affiliation, contribution_date, employer, occupation

Link rowid ▼ district candidate affiliation contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
7286 7286 Senate District 23 Kirkmeyer, Barbara Republican 150.0 11/27/19 0:00 Kris Trujillo Greeley CO 80634 Spring Creek Electric Llc Construction/Engineering Individual (Member of LLC: KRIS TRUJILLO) Monetary (Itemized) - LLC Contribution (Total Amount: 150.00)  
7287 7287 Senate District 23 Kirkmeyer, Barbara Republican 150.0 11/27/19 0:00 Lenny Trujillo Pierce CO 80650 Spring Creek Electric Llc Construction/Engineering Individual (Member of LLC: LENNY TRUJILLO) Monetary (Itemized) - LLC Contribution (Total Amount: 150.00)  
14514 14514 Senate District 33 Coleman, James Democratic 150.0 12/9/19 0:00 Rebekah Henderson Denver CO 80235 Tan Tigress Productions Other Individual (Member of LLC: TAN TIGRESS PRODUCTIONS LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 150.00)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "senate_cand_cont" (
"district" TEXT,
  "candidate" TEXT,
  "affiliation" 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
);