senate_cand_cont
6 rows where district = "Senate District 23" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7002 | 7002 | Senate District 23 | Kirkmeyer, Barbara | Republican | 400.0 | 6/19/20 0:00 | Allies For Educational Equity | Washington | DC | 20002 | Political Committee | Monetary (Itemized) | |||
7059 | 7059 | Senate District 23 | Kirkmeyer, Barbara | Republican | 400.0 | 8/20/20 0:00 | National Federation Of Independent Business Colorado Political Action Committee | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
7175 | 7175 | Senate District 23 | Kirkmeyer, Barbara | Republican | 400.0 | 10/22/20 0:00 | Jpmorgan Chase & Co. Pac | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
7515 | 7515 | Senate District 23 | Parchment, Rupert | Republican | 300.0 | 10/17/19 0:00 | David Carl | Washington | DC | 20001 | Self | Real Estate Professional | Individual | Monetary (Itemized) | |
8083 | 8083 | Senate District 23 | Boccella, Sally | Democratic | 400.0 | 10/9/20 0:00 | Communications Workers Of America Committee On Political Education - Political Contributions Committ | Washington | DC | 20001 | Political Committee | Monetary (Itemized) | |||
8161 | 8161 | Senate District 23 | Boccella, Sally | Democratic | 1500.0 | 10/23/20 0:00 | Ufcw Active Ballot Club Education Fund Colorado Sdc | Washington | DC | 20006 | Small Donor Committee | 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 );