senate_cand_cont
5 rows where contributor_type = "Candidate" and district = "Senate District 33"
This data as json, CSV (advanced)
Suggested facets: contribution_amount, city
Link | rowid ▼ | district | candidate | affiliation | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14170 | 14170 | Senate District 33 | Coleman, James | Democratic | 400.0 | 3/14/20 0:00 | Susan Lontine | Denver | CO | 80123 | Candidate | Monetary (Itemized) | |||
14466 | 14466 | Senate District 33 | Coleman, James | Democratic | 250.0 | 11/21/19 0:00 | Tracy Kraft-Tharp | Arvada | CO | 80005 | Candidate | Monetary (Itemized) | |||
14476 | 14476 | Senate District 33 | Coleman, James | Democratic | 100.0 | 11/24/19 0:00 | Alex Valdez | Denver | CO | 80211 | Candidate | Monetary (Itemized) | |||
14503 | 14503 | Senate District 33 | Coleman, James | Democratic | 200.0 | 12/4/19 0:00 | Janet P Buckner | Aurora | CO | 80014 | Candidate | Monetary (Itemized) | |||
14518 | 14518 | Senate District 33 | Coleman, James | Democratic | 400.0 | 12/18/19 0:00 | Chris Hansen | Denver | CO | 80220 | Candidate | Monetary (Itemized) |
Advanced export
JSON shape: default, array, newline-delimited
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 );