senate_cont

4 rows where contribution_type = "Monetary (Itemized) - LLC Contribution (Total Amount: 250.00)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Party, contributor, city, zip, occupation

Link rowid ▼ District candidate_name Party contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
1226 1226 Senate District 05 Marc Caitlin Republican 250.0 9/4/24 Chris Votoupal Denver CO 80223 Self Lobbyist Individual (Member of LLC: VOTOUPAL GOVERNMENT AFFAIRS) Monetary (Itemized) - LLC Contribution (Total Amount: 250.00)  
1613 1613 Senate District 06 Cleave Simpson Republican 250.0 9/5/24 Chris Votoupal Denver CO 80223 Voloupal Government Affairs, Llc Lobbyist Individual (Member of LLC: VOTOUPAL GOVERNMENT AFFAIRS LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 250.00)  
2398 2398 Senate District 10 Larry Liston Republican 250.0 12/7/23 Tanya K Bowry Broomfield CO 80020 Policy Matters Llc Lobbyist Individual (Member of LLC: POLICY MATTERS LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 250.00)  
9856 9856 Senate District 33 James Coleman Democratic 250.0 10/10/23 Eliza Schultz Parker CO 80134 Schultz Public Affairs Other Individual (Member of LLC: SCHULTZ PUBLIC AFFAIRS) Monetary (Itemized) - LLC Contribution (Total Amount: 250.00)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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