senate_cand_cont
7 rows where district = "Senate District 27" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: candidate, affiliation, contribution_amount, zip, contributor_type
Link | rowid ▼ | district | candidate | affiliation | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10135 | 10135 | Senate District 27 | Staiert, Suzanne | Republican | 400.0 | 8/13/19 0:00 | Michael Davis | Washington | DC | 20002 | Mrd Strategies | Attorney/Legal | Individual | Monetary (Itemized) | |
10225 | 10225 | Senate District 27 | Staiert, Suzanne | Republican | 400.0 | 6/25/20 0:00 | Occidental Petroleum Corporation Political Action Committee | Washington | DC | 20006 | Political Committee | Monetary (Itemized) | |||
10244 | 10244 | Senate District 27 | Staiert, Suzanne | Republican | 400.0 | 7/29/20 0:00 | Cigna Corporation Political Action Committee | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
10260 | 10260 | Senate District 27 | Staiert, Suzanne | Republican | 400.0 | 8/7/20 0:00 | Nfib Colorado Pac | Washington | DC | 20004 | Other | Monetary (Itemized) | |||
11425 | 11425 | Senate District 27 | Kolker, Chris | Democratic | 1500.0 | 8/1/20 0:00 | Ufcw Active Ballot Club Education Fund Colorado Sdc | Washington | DC | 20006 | Small Donor Committee | Monetary (Itemized) | |||
11673 | 11673 | Senate District 27 | Kolker, Chris | Democratic | 200.0 | 9/12/20 0:00 | Megan Hull | Washington | DC | 20007 | Individual | Monetary (Itemized) | |||
12040 | 12040 | Senate District 27 | Kolker, Chris | Democratic | 3100.0 | 10/21/20 0:00 | Seiu Colorado Small Donor Committee | Washington | DC | 20036 | Small Donor Committee | Monetary (Itemized) | Wire Transfer |
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 );