state_cont

5 rows where candidate_name = "Ronald Casados"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contribution_date, state, employer, contributor_type, contribution_type

Link rowid ▼ District candidate_name Party contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
112400 112400 CU Regent District 05 Ronald Casados Democratic 105.0 4/29/22 Ronald S Casados Colorado Springs CO 80909     Candidate Monetary (Itemized) Electronic Transfer From The Candidate To Establish Candidate Bank Account
112401 112401 CU Regent District 05 Ronald Casados Democratic 10.0 6/22/22               Monetary (Non-Itemized)  
112402 112402 CU Regent District 05 Ronald Casados Democratic 200.0 7/2/22 John Mikos Monument CO 80132 None Retired Individual Monetary (Itemized)  
112403 112403 CU Regent District 05 Ronald Casados Democratic 50.0 10/26/22 Chau Pham Sugarland TX 77478 Not Employed   Individual Monetary (Itemized)  
112404 112404 CU Regent District 05 Ronald Casados Democratic 100.0 10/26/22 Chip Bair Lahaina HI 96761 Not Employed Unknown Individual Monetary (Itemized)  

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
);