school_board_cont

1 row where contributor_type = "Individual (Member of LLC: DR SAM ARCHIBALD DDS LLC)"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Jurisdiction_x District candidate contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
3642 3642 ADAMS BRIGHTON 27J SHAWNA HIRTER 100.0 10/12/23 Samuel D Archilbald Commerce City CO 80022 Self Healthcare/Medical Individual (Member of LLC: DR SAM ARCHIBALD DDS LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 100.00)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "school_board_cont" (
"Jurisdiction_x" TEXT,
  "District" TEXT,
  "candidate" 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
);