senate_cand_cont
4 rows where contribution_type = "Non-Monetary (Itemized)" and occupation = "Media/Public Relations" sorted by zip
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, contributor, city, zip, employer
Link | rowid | district | candidate | affiliation | contribution_amount | contribution_date | contributor | city | state | zip ▼ | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8792 | 8792 | Senate District 25 | Dickerson, Paula | Democratic | 70.0 | 10/1/20 0:00 | Alaine Lerner | Boulder | CO | 80301 | Self Employed | Media/Public Relations | Individual | Non-Monetary (Itemized) | Postcard Stamps |
7574 | 7574 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 100.0 | 3/20/20 0:00 | Oscar Johanson | Boulder | CO | 80305 | Self-Employed | Media/Public Relations | Individual | Non-Monetary (Itemized) | Portion Of Video Cost Donated In-Kind |
7575 | 7575 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 200.0 | 4/3/20 0:00 | Oscar Johanson | Boulder | CO | 80305 | Self-Employed | Media/Public Relations | Individual | Non-Monetary (Itemized) | In-Kind Donation To Discount A Portion Of The Film Production Costs For Sd-23 Assembly Address |
3277 | 3277 | Senate District 14 | Hochheimer, Hans | Republican | 47.5 | 2/3/20 0:00 | John Clarke | Ft Collin | CO | 80525 | Clark Photography | Media/Public Relations | Individual | Non-Monetary (Itemized) | Document Design |
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 );